About this Dataset

Delta Food Outlets Study

The Delta Food Outlets Study was an observational study designed to assess the nutritional environments of 5 towns located in the Lower Mississippi Delta region of Mississippi. It was an ancillary study to the Delta Healthy Sprouts Project and therefore included towns in which Delta Healthy Sprouts participants resided and that contained at least one convenience (corner) store, grocery store, or gas station. Data were collected via electronic surveys between March 2016 and September 2018 using the Nutrition Environment Measures Survey (NEMS) tools. Survey scores for the NEMS Corner Store, NEMS Grocery Store, and NEMS Restaurant were computed using modified scoring algorithms provided for these tools via SAS software programming. Because the towns were not randomly selected and the sample sizes are relatively small, the data may not be generalizable to all rural towns in the Lower Mississippi Delta region of Mississippi.

Dataset one (NEMS-C) contains data collected with the NEMS Corner (convenience) Store tool. Dataset two (NEMS-G) contains data collected with the NEMS Grocery Store tool. Dataset three (NEMS-R) contains data collected with the NEMS Restaurant tool.

Resources in this dataset:

Resource Title: Delta Food Outlets Data Dictionary.

File Name: DFO_DataDictionary_Public.csv

Resource Description: This file contains the data dictionary for all 3 datasets that are part of the Delta Food Outlets Study.

Resource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/excel

Resource Title: Dataset One NEMS-C.

File Name: NEMS-C Data.csv

Resource Description: This file contains data collected with the Nutrition Environment Measures Survey (NEMS) tool for convenience stores.

Resource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/excel

Resource Title: Dataset Two NEMS-G.

File Name: NEMS-G Data.csv

Resource Description: This file contains data collected with the Nutrition Environment Measures Survey (NEMS) tool for grocery stores.

Resource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/excel

Resource Title: Dataset Three NEMS-R.

File Name: NEMS-R Data.csv

Resource Description: This file contains data collected with the Nutrition Environment Measures Survey (NEMS) tool for restaurants.

Resource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/excel
Organization: Department of Agriculture
Last updated: 2024-04-10T09:15:08.665683
Tags: ars, assessment, convenience-stores, data-gov, grocery-stores, lower-mississippi-delta, np107, nutrition-environment, restaurants, rural

Tables

NEMS-C Data 0

@usgov.usda_gov_delta_food_outlets_study_2786d.nems_c_data_0

251.03 KB
86 rows
411 columns


CREATE TABLE nems_c_data_0 (
  "id_date" TIMESTAMP,
  "q1" VARCHAR,
  "q2" BIGINT,
  "q3" BIGINT,
  "q4" BIGINT,
  "q5_1" BIGINT,
  "q5_2" BIGINT,
  "q5_3" BIGINT,
  "q5_4" BIGINT,
  "q5_5" BIGINT,
  "q6a" DOUBLE,
  "q6b" DOUBLE,
  "q6c" DOUBLE,
  "q6d" DOUBLE,
  "q7" DOUBLE,
  "q7a" VARCHAR,
  "q8" DOUBLE,
  "q9_1" BIGINT,
  "q9_2" BIGINT,
  "q9_3" BIGINT,
  "q9_4" BIGINT,
  "q9_5" BIGINT,
  "q9_6" BIGINT,
  "q9_7" BIGINT,
  "q9_8" BIGINT,
  "q9_9" BIGINT,
  "q9_10" BIGINT,
  "q9_11" BIGINT,
  "q9_12" BIGINT,
  "q10a" DOUBLE,
  "q10b" DOUBLE,
  "q11a" DOUBLE,
  "q11b" DOUBLE,
  "q12" VARCHAR,
  "q13a" DOUBLE,
  "q13b" DOUBLE,
  "q14a" DOUBLE,
  "q14b" DOUBLE,
  "q15" VARCHAR,
  "q16" DOUBLE,
  "q16a" VARCHAR,
  "q17a" DOUBLE,
  "q17b" DOUBLE,
  "q18a" DOUBLE,
  "q18b" DOUBLE,
  "q19" VARCHAR,
  "q20" DOUBLE,
  "q20a" VARCHAR,
  "q21a" DOUBLE,
  "q21b" DOUBLE,
  "q22a" DOUBLE,
  "q22b" DOUBLE,
  "q23" VARCHAR,
  "q24" DOUBLE,
  "q24a" VARCHAR,
  "q25a" DOUBLE,
  "q25b" DOUBLE,
  "q26a" DOUBLE,
  "q26b" DOUBLE,
  "q27" VARCHAR,
  "q28a" DOUBLE,
  "q28b" DOUBLE,
  "q29a" DOUBLE,
  "q29b" DOUBLE,
  "q30" VARCHAR,
  "q31a" VARCHAR,
  "q31b" VARCHAR,
  "q32a" VARCHAR,
  "q32b" VARCHAR,
  "q33" VARCHAR,
  "q34a" VARCHAR,
  "q34b" VARCHAR,
  "q35a" VARCHAR,
  "q35b" VARCHAR,
  "q36" VARCHAR,
  "q37a" DOUBLE,
  "q37b" DOUBLE,
  "q38a" DOUBLE,
  "q38b" DOUBLE,
  "q39" VARCHAR,
  "q40" DOUBLE,
  "q40a" VARCHAR,
  "q41a" DOUBLE,
  "q41b" DOUBLE,
  "q42a" DOUBLE,
  "q42b" DOUBLE,
  "q43" VARCHAR,
  "q44" DOUBLE,
  "q44a" VARCHAR,
  "q44b" VARCHAR,
  "q45_1" BIGINT,
  "q45_2" BIGINT,
  "q45_3" BIGINT,
  "q45_4" BIGINT,
  "q45_5" BIGINT,
  "q45_6" BIGINT,
  "q45_7" BIGINT,
  "q45_8" BIGINT,
  "q45_9" BIGINT,
  "q45_10" BIGINT
);

NEMS-G Data 0

@usgov.usda_gov_delta_food_outlets_study_2786d.nems_g_data_0

227.63 KB
11 rows
384 columns


CREATE TABLE nems_g_data_0 (
  "id_date" TIMESTAMP,
  "q1" VARCHAR,
  "q2" BIGINT,
  "q3_1" BIGINT,
  "q3_2" BIGINT,
  "q3_3" BIGINT,
  "q3_4" BIGINT,
  "q3_5" BIGINT,
  "q4a" DOUBLE,
  "q4b" DOUBLE,
  "q4c" DOUBLE,
  "q4d" DOUBLE,
  "q5" BIGINT,
  "q5a" VARCHAR,
  "q6" BIGINT,
  "q7_1" BIGINT,
  "q7_2" BIGINT,
  "q7_3" BIGINT,
  "q7_4" BIGINT,
  "q7_5" BIGINT,
  "q7_6" BIGINT,
  "q7_7" BIGINT,
  "q7_8" BIGINT,
  "q7_9" BIGINT,
  "q7_10" BIGINT,
  "q7_11" BIGINT,
  "q8a" BIGINT,
  "q8b" BIGINT,
  "q9a" BIGINT,
  "q9b" DOUBLE,
  "q10" VARCHAR,
  "q11a" BIGINT,
  "q11b" BIGINT,
  "q12a" BIGINT,
  "q12b" DOUBLE,
  "q13" VARCHAR,
  "q14" BIGINT,
  "q14a" VARCHAR,
  "q15a" BIGINT,
  "q15b" BIGINT,
  "q16a" BIGINT,
  "q16b" DOUBLE,
  "q17" VARCHAR,
  "q18" BIGINT,
  "q18a" VARCHAR,
  "q19a" BIGINT,
  "q19b" BIGINT,
  "q20a" BIGINT,
  "q20b" DOUBLE,
  "q21" VARCHAR,
  "q22" BIGINT,
  "q22a" VARCHAR,
  "q23a" BIGINT,
  "q23b" BIGINT,
  "q24a" BIGINT,
  "q24b" DOUBLE,
  "q25" VARCHAR,
  "q26a" DOUBLE,
  "q26b" DOUBLE,
  "q27a" DOUBLE,
  "q27b" DOUBLE,
  "q28" VARCHAR,
  "q29a" BIGINT,
  "q29b" BIGINT,
  "q30a" BIGINT,
  "q30b" DOUBLE,
  "q31" VARCHAR,
  "q32a" DOUBLE,
  "q32b" DOUBLE,
  "q33a" DOUBLE,
  "q33b" DOUBLE,
  "q34" VARCHAR,
  "q35a" DOUBLE,
  "q35b" DOUBLE,
  "q36a" DOUBLE,
  "q36b" DOUBLE,
  "q37" VARCHAR,
  "q38" DOUBLE,
  "q38a" VARCHAR,
  "q39a" DOUBLE,
  "q39b" DOUBLE,
  "q40a" DOUBLE,
  "q40b" DOUBLE,
  "q41" VARCHAR,
  "q42" DOUBLE,
  "q42a" VARCHAR,
  "q43_1" BIGINT,
  "q43_2" BIGINT,
  "q43_3" BIGINT,
  "q43_4" BIGINT,
  "q43_5" BIGINT,
  "q43_6" BIGINT,
  "q43_7" BIGINT,
  "q43_8" BIGINT,
  "q43_9" BIGINT,
  "q43_10" BIGINT,
  "q43_11" BIGINT,
  "q44a" BIGINT,
  "q44b" BIGINT,
  "q45a" BIGINT
);

NEMS-R Data

@usgov.usda_gov_delta_food_outlets_study_2786d.nems_r_data

106.81 KB
169 rows
156 columns


CREATE TABLE nems_r_data (
  "id_date" TIMESTAMP,
  "q1" VARCHAR,
  "q2_1" BIGINT,
  "q2_2" BIGINT,
  "q2_3" BIGINT,
  "q2_4" BIGINT,
  "q3_1" DOUBLE,
  "q3_2" DOUBLE,
  "q3_3" DOUBLE,
  "q3_4" DOUBLE,
  "q3_5" DOUBLE,
  "q3a" VARCHAR,
  "q3b" VARCHAR,
  "q4_1" BIGINT,
  "q4_2" BIGINT,
  "q4_3" BIGINT,
  "q4_4" BIGINT,
  "q4a" VARCHAR,
  "q5_1" DOUBLE,
  "q5_2" DOUBLE,
  "q5_3" DOUBLE,
  "q5_4" DOUBLE,
  "q5a" VARCHAR,
  "q6_1" DOUBLE,
  "q6_2" DOUBLE,
  "q6_3" DOUBLE,
  "q6_4" DOUBLE,
  "q6a" VARCHAR,
  "q7" BIGINT,
  "q8a_1" DOUBLE,
  "q8a_2" DOUBLE,
  "q8a_3" DOUBLE,
  "q8a_4" DOUBLE,
  "q8b_1" DOUBLE,
  "q8b_2" DOUBLE,
  "q8b_3" DOUBLE,
  "q8b_4" DOUBLE,
  "q8c_1" DOUBLE,
  "q8c_2" DOUBLE,
  "q8c_3" DOUBLE,
  "q8c_4" DOUBLE,
  "q8d_1" DOUBLE,
  "q8d_2" DOUBLE,
  "q8d_3" DOUBLE,
  "q8d_4" DOUBLE,
  "q8e_1" DOUBLE,
  "q8e_2" DOUBLE,
  "q8e_3" DOUBLE,
  "q8e_4" DOUBLE,
  "q9a" VARCHAR,
  "q9b" VARCHAR,
  "q9c" VARCHAR,
  "q9d" VARCHAR,
  "q9e" VARCHAR,
  "q10_1" BIGINT,
  "q10_2" BIGINT,
  "q10_3" BIGINT,
  "q10a" VARCHAR,
  "q11" BIGINT,
  "q12a" DOUBLE,
  "q12b" DOUBLE,
  "q12c" VARCHAR,
  "q13_1" BIGINT,
  "q13_2" BIGINT,
  "q13_3" BIGINT,
  "q13_4" BIGINT,
  "q13_5" BIGINT,
  "q13_6" BIGINT,
  "q13_7" BIGINT,
  "q14a" VARCHAR,
  "q14b" VARCHAR,
  "q14c" VARCHAR,
  "q14d" VARCHAR,
  "q14e" VARCHAR,
  "q14f" VARCHAR,
  "q15_1" BIGINT,
  "q15_2" BIGINT,
  "q15_3" BIGINT,
  "q15_4" BIGINT,
  "q15_5" BIGINT,
  "q15_6" BIGINT,
  "q15_7" BIGINT,
  "q15_8" BIGINT,
  "q15_9" BIGINT,
  "q15a" VARCHAR,
  "q16a" BIGINT,
  "q16b" BIGINT,
  "q16c" VARCHAR,
  "q17a" BIGINT,
  "q17b" BIGINT,
  "q17c" VARCHAR,
  "q18a" DOUBLE,
  "q18b" DOUBLE,
  "q19a" VARCHAR,
  "q19b" VARCHAR,
  "q20_1" BIGINT,
  "q20_2" BIGINT,
  "q20_3" BIGINT,
  "q20_4" BIGINT,
  "q20_5" BIGINT
);