| User | 00000000-000... |
| Partition Key | default |
| Legacy ID | 174810 |
| Term Key | Linked Contract | Schema |
|---|---|---|
| category | Beverages | 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 | 174810 |
| food_category | Beverages |
| food_category_id | 14 |
| ndb_number | 14027 |
| publication_date | 2019-04-01 |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_255 | 76.9 | 1 | - |
| 300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_208 | 119 | 0 | - |
| 400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_268 | 498 | 0 | - |
| 600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_203 | 0 | 0 | - |
| 800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_204 | 0 | 0 | - |
| 1000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_207 | 0.1 | 1 | - |
| 1110 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_205 | 13.4 | 0 | - |
| 1200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_291 | 0.1 | 0 | - |
| 5300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_301 | 0 | 1 | - |
| 5400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_303 | 0.01 | 1 | - |
| 5500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_304 | 1 | 0 | - |
| 5600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_305 | 6 | 0 | - |
| 5700 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_306 | 11 | 1 | - |
| 5800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_307 | 44 | 1 | - |
| 5900 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_309 | 0.06 | 0 | - |
| 6000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_312 | 0.009 | 0 | - |
| 6100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_315 | 0.006 | 0 | - |
| 6200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_317 | 0.1 | 0 | - |
| 6300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_401 | 1.6 | 0 | - |
| 6400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_404 | 0.011 | 0 | - |
| 6500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_405 | 0.006 | 0 | - |
| 6600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_406 | 0.02 | 0 | - |
| 6700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_410 | 0.008 | 0 | - |
| 6800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_415 | 0 | 0 | - |
| 6900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_417 | 0 | 0 | - |
| 7000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_431 | 0 | 0 | - |
| 7100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_432 | 0 | 0 | - |
| 7200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_435 | 0 | 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 | 13 | 0 | - |
| 15400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_605 | 0 | 0 | - |
| 15700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_601 | 0 | 0 | - |
| 18200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_221 | 9.5 | 1 | - |
| 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 | Alcoholic beverage, whiskey sour, canned |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 0 | 00000000-000... | portion | portion_1 | 30.8 | - | - |
| 1 | 00000000-000... | portion | portion_2 | 209 | - | - |
| 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 fl oz |
| portion_2_desc | 1 can (6.8 fl oz, 200 ml) |