| User | 00000000-000... |
| Partition Key | default |
| Legacy ID | 167674 |
| Term Key | Linked Contract | Schema |
|---|---|---|
| category | Restaurant Foods | 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 | 167674 |
| food_category | Restaurant Foods |
| food_category_id | 25 |
| ndb_number | 36617 |
| publication_date | 2019-04-01 |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_255 | 52.69 | 8 | - |
| 300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_208 | 252 | 0 | - |
| 400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_268 | 1054 | 0 | - |
| 600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_203 | 11.87 | 8 | - |
| 800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_204 | 13.55 | 14 | - |
| 1000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_207 | 1.28 | 8 | - |
| 1110 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_205 | 20.61 | 0 | - |
| 1200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_291 | 1 | 7 | - |
| 1510 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_269 | 8.18 | 7 | - |
| 1600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_210 | 5.05 | 7 | - |
| 1700 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_211 | 1.58 | 7 | - |
| 1800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_212 | 1.52 | 7 | - |
| 1900 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_213 | 0 | 7 | - |
| 2000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_214 | 0.03 | 7 | - |
| 2100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_287 | 0 | 7 | - |
| 2200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_209 | 10.27 | 6 | - |
| 5300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_301 | 40 | 14 | - |
| 5400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_303 | 1.22 | 14 | - |
| 5500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_304 | 16 | 14 | - |
| 5600 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_305 | 136 | 14 | - |
| 5700 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_306 | 161 | 14 | - |
| 5800 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_307 | 252 | 14 | - |
| 5900 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_309 | 0.51 | 14 | - |
| 6000 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_312 | 0.04 | 14 | - |
| 6100 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_315 | 0.089 | 14 | - |
| 6200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_317 | 13 | 4 | - |
| 6300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_401 | 2.3 | 7 | - |
| 6400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_404 | 0.053 | 7 | - |
| 6500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_405 | 0.07 | 7 | - |
| 6600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_406 | 3.776 | 7 | - |
| 6700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_410 | 0.52 | 4 | - |
| 6800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_415 | 0.25 | 7 | - |
| 6900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_417 | 9 | 1 | - |
| 7000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_431 | 0 | 0 | - |
| 7100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_432 | 9 | 1 | - |
| 7200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_435 | 9 | 0 | - |
| 7220 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_421 | 28.6 | 0 | - |
| 7290 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_454 | 7.5 | 1 | - |
| 7300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_418 | 0.11 | 7 | - |
| 7340 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_578 | 0 | 0 | - |
| 7420 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_320 | 3 | 0 | - |
| 7430 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_319 | 2 | 3 | - |
| 7440 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_321 | 1 | 3 | - |
| 7450 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_322 | 0 | 3 | - |
| 7460 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_334 | 1 | 3 | - |
| 7500 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_318 | 11 | 0 | - |
| 7530 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_337 | 0 | 3 | - |
| 7560 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_338 | 36 | 3 | - |
| 7905 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_323 | 1.28 | 4 | - |
| 7920 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_573 | 0 | 0 | - |
| 8000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_341 | 0.11 | 4 | - |
| 8100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_342 | 5.95 | 4 | - |
| 8200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_343 | 2.32 | 4 | - |
| 8300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_344 | 0.01 | 4 | - |
| 8400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_345 | 0.01 | 4 | - |
| 8500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_346 | 0.01 | 4 | - |
| 8600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_347 | 0 | 4 | - |
| 8650 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_324 | 5 | 0 | - |
| 8700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_328 | 0.1 | 0 | - |
| 8720 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_326 | 0.1 | 0 | - |
| 8800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_430 | 24.4 | 3 | - |
| 8950 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_428 | 2.6 | 3 | - |
| 9700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_606 | 2.033 | 0 | - |
| 9800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_607 | 0.003 | 13 | - |
| 9900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_608 | 0 | 13 | - |
| 10000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_609 | 0.004 | 13 | - |
| 10100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_610 | 0.001 | 13 | - |
| 10300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_611 | 0.002 | 13 | - |
| 10500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_612 | 0.021 | 13 | - |
| 10600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_652 | 0.003 | 13 | - |
| 10700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_613 | 1.402 | 13 | - |
| 10800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_653 | 0.012 | 13 | - |
| 10900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_614 | 0.51 | 13 | - |
| 11100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_615 | 0.033 | 13 | - |
| 11200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_624 | 0.031 | 13 | - |
| 11300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_654 | 0.011 | 13 | - |
| 11400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_645 | 2.749 | 0 | - |
| 11500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_625 | 0.002 | 13 | - |
| 11600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_697 | 0 | 13 | - |
| 11700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_626 | 0.07 | 13 | - |
| 11800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_673 | 0.069 | 13 | - |
| 12000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_687 | 0.009 | 13 | - |
| 12100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_617 | 2.609 | 13 | - |
| 12200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_674 | 2.585 | 13 | - |
| 12400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_628 | 0.051 | 13 | - |
| 12500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_630 | 0.005 | 13 | - |
| 12600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_676 | 0.003 | 13 | - |
| 12800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_671 | 0.003 | 13 | - |
| 12900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_646 | 6.086 | 0 | - |
| 13100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_618 | 5.353 | 13 | - |
| 13200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_675 | 5.301 | 13 | - |
| 13300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_670 | 0.01 | 13 | - |
| 13900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_619 | 0.669 | 13 | - |
| 14000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_851 | 0.663 | 13 | - |
| 14100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_685 | 0.006 | 13 | - |
| 14200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_856 | 0 | 1 | - |
| 14250 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_627 | 0 | 13 | - |
| 14300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_672 | 0.008 | 13 | - |
| 14400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_689 | 0.006 | 13 | - |
| 14500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_852 | 0.001 | 13 | - |
| 14600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_853 | 0.006 | 13 | - |
| 14700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_620 | 0.032 | 13 | - |
| 15000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_629 | 0.003 | 13 | - |
| 15160 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_858 | 0.008 | 13 | - |
| 15200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_631 | 0.003 | 13 | - |
| 15300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_621 | 0.003 | 13 | - |
| 15400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_605 | 0.068 | 0 | - |
| 15500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_693 | 0.026 | 0 | - |
| 15520 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_662 | 0 | 13 | - |
| 15521 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_663 | 0.024 | 13 | - |
| 15550 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_664 | 0.002 | 13 | - |
| 15610 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_665 | 0.041 | 13 | - |
| 15619 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_695 | 0.041 | 0 | - |
| 15700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_601 | 32 | 7 | - |
| 16300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_501 | 0.141 | 0 | - |
| 16400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_502 | 0.513 | 0 | - |
| 16500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_503 | 0.537 | 0 | - |
| 16600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_504 | 0.978 | 0 | - |
| 16700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_505 | 0.958 | 0 | - |
| 16800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_506 | 0.33 | 0 | - |
| 16900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_507 | 0.142 | 0 | - |
| 17000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_508 | 0.478 | 0 | - |
| 17100 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_509 | 0.369 | 0 | - |
| 17200 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_510 | 0.57 | 0 | - |
| 17300 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_511 | 0.521 | 0 | - |
| 17400 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_512 | 0.365 | 0 | - |
| 17500 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_513 | 0.671 | 0 | - |
| 17600 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_514 | 1.102 | 0 | - |
| 17700 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_515 | 2.265 | 0 | - |
| 17800 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_516 | 0.506 | 0 | - |
| 17900 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_517 | 0.524 | 0 | - |
| 18000 | 019c7d9e-e9e... | nutrition_fact | nutrient_ndb_518 | 0.513 | 0 | - |
| 18200 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_221 | 0 | 0 | - |
| 18300 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_262 | 0 | 0 | - |
| 18400 | 019c7d9e-e9d... | nutrition_fact | nutrient_ndb_263 | 0 | 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 | Restaurant, Chinese, lemon chicken |
| # | Linked Contract | Term Key | Key | Qty | Value 1 | Value 2 |
|---|---|---|---|---|---|---|
| 0 | 00000000-000... | portion | portion_1 | 623 | - | - |
| 1 | 00000000-000... | portion | portion_2 | 73 | - | - |
| 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 order |
| portion_2_desc | 3 pieces |