| User | 00000000-000... |
| Partition Key | default |
| Legacy ID | 171700 |
| Term Key | Linked Contract | Schema |
|---|---|---|
| category | Fruits and Fruit Juices | 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 | 171700 |
| food_category | Fruits and Fruit Juices |
| food_category_id | 9 |
| ndb_number | 9028 |
| publication_date | 2019-04-01 |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_255 | 77.66 | 115 | - |
| 300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_208 | 83 | 0 | - |
| 400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_268 | 347 | 0 | - |
| 600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_203 | 0.51 | 58 | - |
| 800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_204 | 0.09 | 42 | - |
| 1000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_207 | 0.29 | 58 | - |
| 1110 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_205 | 21.45 | 0 | - |
| 1200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_291 | 1.6 | 0 | - |
| 5300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_301 | 9 | 65 | - |
| 5400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_303 | 0.43 | 66 | - |
| 5500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_304 | 8 | 61 | - |
| 5600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_305 | 13 | 66 | - |
| 5700 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_306 | 134 | 65 | - |
| 5800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_307 | 11 | 63 | - |
| 5900 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_309 | 0.1 | 32 | - |
| 6000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_312 | 0.065 | 32 | - |
| 6100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_315 | 0.051 | 0 | - |
| 6300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_401 | 2.8 | 173 | - |
| 6400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_404 | 0.019 | 62 | - |
| 6500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_405 | 0.023 | 66 | - |
| 6600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_406 | 0.416 | 59 | - |
| 6700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_410 | 0.092 | 0 | - |
| 6800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_415 | 0.054 | 0 | - |
| 6900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_417 | 2 | 0 | - |
| 7000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_431 | 0 | 0 | - |
| 7100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_432 | 2 | 0 | - |
| 7200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_435 | 2 | 0 | - |
| 7300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_418 | 0 | 0 | - |
| 7420 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_320 | 62 | 168 | - |
| 7430 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_319 | 0 | 0 | - |
| 7500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_318 | 1240 | 168 | - |
| 8650 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_324 | 0 | 0 | - |
| 8700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_328 | 0 | 0 | - |
| 9700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_606 | 0.006 | 0 | - |
| 10700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_613 | 0.005 | 0 | - |
| 10900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_614 | 0.001 | 0 | - |
| 11400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_645 | 0.037 | 0 | - |
| 12100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_617 | 0.037 | 0 | - |
| 12900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_646 | 0.017 | 0 | - |
| 13100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_618 | 0.017 | 0 | - |
| 15400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_605 | 0 | 0 | - |
| 15700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_601 | 0 | 0 | - |
| 16300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_501 | 0.009 | 0 | - |
| 16400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_502 | 0.018 | 0 | - |
| 16500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_503 | 0.016 | 0 | - |
| 16600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_504 | 0.03 | 0 | - |
| 16700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_505 | 0.036 | 0 | - |
| 16800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_506 | 0.003 | 0 | - |
| 16900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_507 | 0.002 | 0 | - |
| 17000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_508 | 0.021 | 0 | - |
| 17100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_509 | 0.012 | 0 | - |
| 17200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_510 | 0.019 | 0 | - |
| 17300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_511 | 0.02 | 0 | - |
| 17400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_512 | 0.008 | 0 | - |
| 17500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_513 | 0.025 | 0 | - |
| 17600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_514 | 0.117 | 0 | - |
| 17700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_515 | 0.052 | 0 | - |
| 17800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_516 | 0.016 | 0 | - |
| 17900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_517 | 0.031 | 0 | - |
| 18000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_518 | 0.029 | 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 | Apricots, canned, heavy syrup pack, without skin, solids and liquids |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 0 | 00000000-000... | portion | portion_1 | 258 | - | - |
| 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 cup, whole, without pits |