From a 500-row sample across 12 columns.
| agency | time_period | food_product_group | food_product_category | product_name | product_type | origin_detail | distributor | vendor | of_units | total_weight_in_lbs | total_cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, dinner, assorted | Stage 2 Baby Food Dinner, Assorted Variety | Beech-Nut | Babylab Inc. | Babylab Inc. | 40 | 100 | 560 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
agency | categorical | NYC agency that purchased food product | 0% | Health + HospitalsDepartment of Homeless S…Department of Educationof 7 |
time_period | categorical | Time period in which product was purchased | 0% | 2019-20202020-20212018-2019of 3 |
food_product_group | categorical | High level categorization of the food product | 0% | Condiments & SnacksProduceMealsof 9 |
food_product_category | text | Lower level categorization of the food product | 0% |
GET /api/datasets/usrf-za7k GET /api/datasets/usrf-za7k/quality GET /api/datasets/usrf-za7k/related GET /api/columns?dataset=usrf-za7k
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, dinner, assorted | Stage 3 Baby Food Dinner, Assorted Variety | Beech-Nut | Babylab Inc. | Babylab Inc. | 40 | 106 | 600 |
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, formula | Premium Nursette Ready-to-Feed Infant Formula, 2 fl. oz. Bottles | Enfamil | Babylab Inc. | Babylab Inc. | 200 | 1200 | 16200 |
| Administration for Childrens Services | 2018-2019 | Beverages | Beverages | juice, fruit punch, ss | 100% Juice Variety Pack, 4 fl oz bottles | Enfamil | Babylab Inc. | Babylab Inc. | 100 | 600 | 1940 |
| Administration for Childrens Services | 2018-2019 | Condiments & Snacks | Condiments & Snacks | cereal, baby, oatmeal | Single Grain Oatmeal Baby Cereal | Enfamil | Babylab Inc. | Babylab Inc. | 10 | 60 | 290 |
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, fruit, vegetable, assorted | Stage 1 Fruit & Vegetable Baby Food, Assorted Variety | Gerber | Babylab Inc. | Babylab Inc. | 40 | 100 | 456 |
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, fruit, vegetable, assorted | Stage 2 Fruit & Vegetable Baby Food, Assorted Variety | Gerber | Babylab Inc. | Babylab Inc. | 40 | 160 | 540 |
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, fruit, vegetable, assorted | Stage 3 Fruit & Vegetable Baby Food, Assorted Variety | Gerber | Babylab Inc. | Babylab Inc. | 10 | 38 | 125 |
| Administration for Childrens Services | 2018-2019 | Beverages | Beverages | drink, electrolyte, variety, ss | Pedialyte Electrolyte Solution, Assorted Flavors, 1.33 fl oz bottles | Pedialyte | Babylab Inc. | Babylab Inc. | 10 | 7 | 450 |
| Administration for Childrens Services | 2018-2019 | Meals | Meals | baby food, formula | Ready-to-Use Infant Formula, 2 fl oz bottles | Similac | Babylab Inc. | Babylab Inc. | 85 | 510 | 4420 |
Condiments & SnacksMealsVegetables |
product_name | text | Product name normalized from product type | 0% | meal, breakfast, koshermeal, lunch, kosherjuice, orange |
product_type | text | Product description submitted by food vendor or agency | 0% | Fruit Peaches FreshBeverage Soda/Premium - …Fruit Oranges Fresh |
origin_detail | text | Name and location of supplier (grower or manufacturer of product) | 12% | PACKERFresh, NAFRESH |
distributor | text | Intermediary distributor between supplier and vendor to agency | 5% | US FoodsDriscoll Foods Food Serv…Baldor Specialty Foods |
vendor | text | Direct vendor to agency | 3% | US FoodsDriscoll Foods Food Serv…Baldor Specialty Foods |
of_units | integer | Units of product purchased by agency | 0% | 123 |
total_weight_in_lbs | integer | Total weight in lbs of food item purchased by agency | 0% | 01020 |
total_cost | integer | Total cost in dollars spent by agency on item | 78% | 706516 |