| User | 00000000-000... |
| Partition Key | default |
| Legacy ID | 167567 |
| Term Key | Linked Contract | Schema |
|---|---|---|
| category | Sweets | USDA FoodData Central |
| Key Name | Type |
|---|---|
| category_code | string |
| data_points | integer |
| data_type | string |
| fdc_id | integer |
| food_category | string |
| food_category_id | integer |
| gram_weight | numeric |
| modifier | string |
| ndb_item_name | string |
| ndb_number | string |
| nutrient_nbr | string |
| nutrient_rank | string |
| portion_desc | string |
| publication_date | string |
| unit_name | string |
| Key | Value |
|---|---|
| data_type | sr_legacy_food |
| fdc_id | 167567 |
| food_category | Sweets |
| food_category_id | 19 |
| ndb_number | 19077 |
| publication_date | 2019-04-01 |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_255 | 0.9 | 1 | - |
| 300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_208 | 472 | 0 | - |
| 400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_268 | 1975 | 0 | - |
| 600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_203 | 12.1 | 1 | - |
| 800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_204 | 47.7 | 1 | - |
| 1000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_207 | 3.1 | 1 | - |
| 1110 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_205 | 36.2 | 0 | - |
| 1200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_291 | 18.1 | 0 | - |
| 1510 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_269 | 0 | 0 | - |
| 5300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_301 | 54 | 1 | - |
| 5400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_303 | 4.15 | 1 | - |
| 5500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_304 | 265 | 1 | - |
| 5600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_305 | 340 | 1 | - |
| 5700 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_306 | 1166 | 1 | - |
| 5800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_307 | 12 | 1 | - |
| 5900 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_309 | 3.68 | 1 | - |
| 6000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_312 | 1.91 | 1 | - |
| 6100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_315 | 1.65 | 1 | - |
| 6200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_317 | 7.9 | 0 | - |
| 6300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_401 | 0 | 0 | - |
| 6400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_404 | 0.05 | 1 | - |
| 6500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_405 | 0.279 | 0 | - |
| 6600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_406 | 2.1 | 1 | - |
| 6700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_410 | 0.154 | 0 | - |
| 6800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_415 | 0.072 | 0 | - |
| 6900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_417 | 19 | 0 | - |
| 7000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_431 | 0 | 0 | - |
| 7100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_432 | 19 | 0 | - |
| 7200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_435 | 19 | 0 | - |
| 7300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_418 | 0 | 0 | - |
| 7420 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_320 | 1 | 0 | - |
| 7430 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_319 | 0 | 0 | - |
| 7500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_318 | 12 | 0 | - |
| 9700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_606 | 25.29 | 0 | - |
| 9900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_608 | 0.13 | 1 | - |
| 10000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_609 | 1.59 | 1 | - |
| 10100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_610 | 1.27 | 1 | - |
| 10300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_611 | 9.45 | 1 | - |
| 10500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_612 | 3.63 | 1 | - |
| 10700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_613 | 6.06 | 1 | - |
| 10900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_614 | 3.16 | 1 | - |
| 11400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_645 | 9.23 | 0 | - |
| 11700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_626 | 0.05 | 1 | - |
| 12100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_617 | 9.18 | 1 | - |
| 12900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_646 | 10.7 | 0 | - |
| 13100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_618 | 10.1 | 1 | - |
| 13900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_619 | 0.6 | 1 | - |
| 15700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_601 | 0 | 0 | - |
| 16300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_501 | 0.182 | 0 | - |
| 16400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_502 | 0.481 | 0 | - |
| 16500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_503 | 0.471 | 0 | - |
| 16600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_504 | 0.737 | 0 | - |
| 16700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_505 | 0.609 | 0 | - |
| 16800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_506 | 0.125 | 0 | - |
| 16900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_507 | 0.148 | 0 | - |
| 17000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_508 | 0.584 | 0 | - |
| 17100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_509 | 0.456 | 0 | - |
| 17200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_510 | 0.73 | 0 | - |
| 17300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_511 | 0.689 | 0 | - |
| 17400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_512 | 0.21 | 0 | - |
| 17500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_513 | 0.561 | 0 | - |
| 17600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_514 | 1.211 | 0 | - |
| 17700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_515 | 1.828 | 0 | - |
| 17800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_516 | 0.545 | 0 | - |
| 17900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_517 | 0.52 | 0 | - |
| 18000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_518 | 0.525 | 0 | - |
| 18300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_262 | 47 | 0 | - |
| 18400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_263 | 1597 | 0 | - |
| Key Name | Type |
|---|---|
| category_code | string |
| data_points | integer |
| data_type | string |
| fdc_id | integer |
| food_category | string |
| food_category_id | integer |
| gram_weight | numeric |
| modifier | string |
| ndb_item_name | string |
| ndb_number | string |
| nutrient_nbr | string |
| nutrient_rank | string |
| portion_desc | string |
| publication_date | string |
| unit_name | string |
| Key | Value |
|---|---|
| ndb_item_name | Baking chocolate, unsweetened, liquid |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 0 | 00000000-000... | portion | portion_1 | 28.35 | - | - |
| Key Name | Type |
|---|---|
| category_code | string |
| data_points | integer |
| data_type | string |
| fdc_id | integer |
| food_category | string |
| food_category_id | integer |
| gram_weight | numeric |
| modifier | string |
| ndb_item_name | string |
| ndb_number | string |
| nutrient_nbr | string |
| nutrient_rank | string |
| portion_desc | string |
| publication_date | string |
| unit_name | string |
| Key | Value |
|---|---|
| portion_1_desc | 1 oz |