About this Dataset

Delta Neighborhood Physical Activity Study

The Delta Neighborhood Physical Activity Study was an observational study designed to assess characteristics of neighborhood built environments associated with physical activity. It was an ancillary study to the Delta Healthy Sprouts Project and therefore included towns and neighborhoods in which Delta Healthy Sprouts participants resided. The 12 towns were located in the Lower Mississippi Delta region of Mississippi. Data were collected via electronic surveys between August 2016 and September 2017 using the Rural Active Living Assessment (RALA) tools and the Community Park Audit Tool (CPAT). Scale scores for the RALA Programs and Policies Assessment and the Town-Wide Assessment were computed using the scoring algorithms provided for these tools via SAS software programming. The Street Segment Assessment and CPAT do not have associated scoring algorithms and therefore no scores are provided for them. Because the towns were not randomly selected and the sample size is small, the data may not be generalizable to all rural towns in the Lower Mississippi Delta region of Mississippi.

Dataset one contains data collected with the RALA Programs and Policies Assessment (PPA) tool. Dataset two contains data collected with the RALA Town-Wide Assessment (TWA) tool. Dataset three contains data collected with the RALA Street Segment Assessment (SSA) tool. Dataset four contains data collected with the Community Park Audit Tool (CPAT).

[Note : title changed 9/4/2020 to reflect study name]

Resources in this dataset:

Resource Title: Dataset One RALA PPA Data Dictionary.

File Name: RALA PPA Data Dictionary.csv

Resource Description: Data dictionary for dataset one collected using the RALA PPA tool.

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

Resource Title: Dataset Two RALA TWA Data Dictionary.

File Name: RALA TWA Data Dictionary.csv

Resource Description: Data dictionary for dataset two collected using the RALA TWA tool.

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

Resource Title: Dataset Three RALA SSA Data Dictionary.

File Name: RALA SSA Data Dictionary.csv

Resource Description: Data dictionary for dataset three collected using the RALA SSA tool.

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

Resource Title: Dataset Four CPAT Data Dictionary.

File Name: CPAT Data Dictionary.csv

Resource Description: Data dictionary for dataset four collected using the CPAT.

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

Resource Title: Dataset One RALA PPA.

File Name: RALA PPA Data.csv

Resource Description: Data collected using the RALA PPA tool.

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

Resource Title: Dataset Two RALA TWA.

File Name: RALA TWA Data.csv

Resource Description: Data collected using the RALA TWA tool.

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

Resource Title: Dataset Three RALA SSA.

File Name: RALA SSA Data.csv

Resource Description: Data collected using the RALA SSA tool.

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

Resource Title: Dataset Four CPAT.

File Name: CPAT Data.csv

Resource Description: Data collected using the CPAT.

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

Resource Title: Data Dictionary.

File Name: DataDictionary_RALA_PPA_SSA_TWA_CPAT.csv

Resource Description: This is a combined data dictionary from each of the 4 dataset files in this set.
Organization: Department of Agriculture
Last updated: 2024-03-30T11:28:32.362290
Tags: ars, assessment, built-environment, data-gov, lower-mississippi-delta, neighborhood, np107, park, pedestrian-safety, physical-activity, street, town

Tables

CPAT Data

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.cpat_data

150.97 KB
31 rows
258 columns


CREATE TABLE cpat_data (
  "id_date" TIMESTAMP,
  "id_park" VARCHAR,
  "q1" BIGINT,
  "q2" BIGINT,
  "q2a" VARCHAR,
  "q3" BIGINT,
  "q4" BIGINT,
  "q4a" VARCHAR,
  "q5_1" BIGINT,
  "q5_2" BIGINT,
  "q5_3" BIGINT,
  "q5_4" BIGINT,
  "q5_5" BIGINT,
  "q5_6" BIGINT,
  "q5_7" BIGINT,
  "q5_8" BIGINT,
  "q5_9" BIGINT,
  "q6" BIGINT,
  "q7" BIGINT,
  "q8_1" BIGINT,
  "q8_2" BIGINT,
  "q8_3" BIGINT,
  "q8_4" BIGINT,
  "q9" BIGINT,
  "q10" DOUBLE,
  "q11" DOUBLE,
  "q12" BIGINT,
  "q13" VARCHAR,
  "q14_1" BIGINT,
  "q14_2" BIGINT,
  "q14_3" BIGINT,
  "q14_4" BIGINT,
  "q15_1" BIGINT,
  "q15_2" BIGINT,
  "q15_3" BIGINT,
  "q15_4" BIGINT,
  "q16_1" BIGINT,
  "q16_2" BIGINT,
  "q16_3" BIGINT,
  "q16_4" BIGINT,
  "q16_5" BIGINT,
  "q16_6" BIGINT,
  "q16a" VARCHAR,
  "q17_1" BIGINT,
  "q17_2" BIGINT,
  "q17_3" BIGINT,
  "q17_4" BIGINT,
  "q17_5" BIGINT,
  "q17_6" BIGINT,
  "q17_7" BIGINT,
  "q17_8" BIGINT,
  "q17_9" BIGINT,
  "q17_10" BIGINT,
  "q17_11" BIGINT,
  "q17_12" BIGINT,
  "q17_13" BIGINT,
  "q17a" VARCHAR,
  "q18" VARCHAR,
  "q19" BIGINT,
  "q20_1" BIGINT,
  "q20_2" BIGINT,
  "q20_3" BIGINT,
  "q20_4" BIGINT,
  "q20_5" BIGINT,
  "q20_6" BIGINT,
  "q20_7" BIGINT,
  "q20_8" BIGINT,
  "q20_9" BIGINT,
  "q20_10" BIGINT,
  "q20_11" BIGINT,
  "q20_12" BIGINT,
  "q20_13" BIGINT,
  "q20_14" BIGINT,
  "q20a" VARCHAR,
  "q21a" DOUBLE,
  "q21b" DOUBLE,
  "q21c" DOUBLE,
  "q21d" DOUBLE,
  "q21e" DOUBLE,
  "q21f" DOUBLE,
  "q21g" DOUBLE,
  "q21h" DOUBLE,
  "q21i" VARCHAR,
  "q22a" DOUBLE,
  "q22b" DOUBLE,
  "q22c" VARCHAR,
  "q23a" DOUBLE,
  "q23b" DOUBLE,
  "q23c" VARCHAR,
  "q24a" DOUBLE,
  "q24b" DOUBLE,
  "q24c" VARCHAR,
  "q25a" VARCHAR,
  "q25b" VARCHAR,
  "q25c" VARCHAR,
  "q26a" DOUBLE,
  "q26b" DOUBLE,
  "q26c" VARCHAR,
  "q27a" DOUBLE,
  "q27b" DOUBLE
);

CPAT Data Dictionary

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.cpat_data_dictionary

11.13 KB
258 rows
7 columns


CREATE TABLE cpat_data_dictionary (
  "variable_name" VARCHAR,
  "brief_description" VARCHAR,
  "variable_type" VARCHAR,
  "variable_length" BIGINT,
  "values" VARCHAR,
  "required" VARCHAR,
  "null_value" VARCHAR
);

DataDictionary RALA PPA SSA TWA CPAT

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.datadictionary_rala_ppa_ssa_twa_cpat

18.78 KB
608 rows
8 columns


CREATE TABLE datadictionary_rala_ppa_ssa_twa_cpat (
  "file_name" VARCHAR,
  "variable_name" VARCHAR,
  "brief_description" VARCHAR,
  "variable_type" VARCHAR,
  "variable_length" BIGINT,
  "values" VARCHAR,
  "required" VARCHAR,
  "null_value" VARCHAR
);

RALA PPA Data

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.rala_ppa_data

27.3 KB
12 rows
42 columns


CREATE TABLE rala_ppa_data (
  "id_date" TIMESTAMP,
  "id_town" VARCHAR,
  "q1" BIGINT,
  "q2" BIGINT,
  "q3" BIGINT,
  "q4" DOUBLE,
  "q4a" VARCHAR,
  "q5" DOUBLE,
  "q5a" VARCHAR,
  "q6" DOUBLE,
  "q7" DOUBLE,
  "q7a" VARCHAR,
  "q8" BIGINT,
  "q9" DOUBLE,
  "q9a" VARCHAR,
  "q10" DOUBLE,
  "q10a" VARCHAR,
  "q11" DOUBLE,
  "q12" DOUBLE,
  "q13" DOUBLE,
  "q13a" VARCHAR,
  "q14" BIGINT,
  "q14a" VARCHAR,
  "q15" BIGINT,
  "q15a" VARCHAR,
  "q16" BIGINT,
  "q16a" VARCHAR,
  "q17" BIGINT,
  "q17a" VARCHAR,
  "q18" BIGINT,
  "q18a" VARCHAR,
  "q19" BIGINT,
  "q19a" VARCHAR,
  "q20" BIGINT,
  "q20a" VARCHAR,
  "q21" DOUBLE,
  "q21a" VARCHAR,
  "tpol_score" BIGINT,
  "tprg_score" BIGINT,
  "spol_score" BIGINT,
  "sprg_score" BIGINT,
  "ppa_score" BIGINT
);

RALA SSA Data

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.rala_ssa_data

102.64 KB
615 rows
148 columns


CREATE TABLE rala_ssa_data (
  "id_date" TIMESTAMP,
  "id_segment" VARCHAR,
  "q1_1" BIGINT,
  "q1_2" BIGINT,
  "q1_3" BIGINT,
  "q1_4" BIGINT,
  "q1_5" BIGINT,
  "q1_6" BIGINT,
  "q1a" VARCHAR,
  "q2" BIGINT,
  "q2a" VARCHAR,
  "q2b" VARCHAR,
  "q3" BIGINT,
  "q4" BIGINT,
  "q5_1" BIGINT,
  "q5_2" BIGINT,
  "q5_3" BIGINT,
  "q5_4" BIGINT,
  "q5_5" BIGINT,
  "q6_1" BIGINT,
  "q6_2" BIGINT,
  "q6_3" BIGINT,
  "q6_4" BIGINT,
  "q6_5" BIGINT,
  "q6_6" BIGINT,
  "q7" BIGINT,
  "q8" BIGINT,
  "q9" BIGINT,
  "q10" BIGINT,
  "q11_1" BIGINT,
  "q11_2" BIGINT,
  "q11_3" BIGINT,
  "q11_4" BIGINT,
  "q11_5" BIGINT,
  "q11_6" BIGINT,
  "q11_7" BIGINT,
  "q11a" VARCHAR,
  "q12a" DOUBLE,
  "q12b" DOUBLE,
  "q12c" VARCHAR,
  "q12d" VARCHAR,
  "q12e" DOUBLE,
  "q12f" DOUBLE,
  "q12g" DOUBLE,
  "q12h" DOUBLE,
  "q12i" VARCHAR,
  "q12j" DOUBLE,
  "q12k" DOUBLE,
  "q12l" VARCHAR,
  "q12m" BIGINT,
  "q13" BIGINT,
  "q14_1" BIGINT,
  "q14_2" BIGINT,
  "q14_3" BIGINT,
  "q14_4" BIGINT,
  "q14_5" BIGINT,
  "q14a" 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,
  "q15_10" BIGINT,
  "q15_11" BIGINT,
  "q15_12" BIGINT,
  "q15_13" BIGINT,
  "q15_14" BIGINT,
  "q15a" VARCHAR,
  "q16_1" BIGINT,
  "q16_2" BIGINT,
  "q16_3" BIGINT,
  "q16_4" BIGINT,
  "q16_5" BIGINT,
  "q16_6" BIGINT,
  "q16_7" BIGINT,
  "q16_8" BIGINT,
  "q16_9" BIGINT,
  "q16_10" BIGINT,
  "q16_11" BIGINT,
  "q16_12" BIGINT,
  "q16_13" BIGINT,
  "q16a" VARCHAR,
  "q17_1" BIGINT,
  "q17_2" BIGINT,
  "q17_3" BIGINT,
  "q17_4" BIGINT,
  "q17_5" BIGINT,
  "q17_6" BIGINT,
  "q17a" VARCHAR,
  "q18_1" BIGINT,
  "q18_2" BIGINT,
  "q18_3" BIGINT,
  "q18_4" BIGINT,
  "q18_5" BIGINT,
  "q18a" VARCHAR,
  "q19a" DOUBLE
);

RALA SSA Data Dictionary

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.rala_ssa_data_dictionary

8.83 KB
186 rows
7 columns


CREATE TABLE rala_ssa_data_dictionary (
  "variable_name" VARCHAR,
  "brief_description" VARCHAR,
  "variable_type" VARCHAR,
  "variable_length" DOUBLE,
  "values" VARCHAR,
  "required" VARCHAR,
  "null_value" VARCHAR
);

RALA TWA Data

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.rala_twa_data

95.89 KB
12 rows
160 columns


CREATE TABLE rala_twa_data (
  "id_date" TIMESTAMP,
  "id_town" VARCHAR,
  "q1" BIGINT,
  "q2a" BIGINT,
  "q2b" BIGINT,
  "q2c" BIGINT,
  "q2d" VARCHAR,
  "q3a" BIGINT,
  "q3b" BIGINT,
  "q3c" BIGINT,
  "q3d" VARCHAR,
  "q4" BIGINT,
  "q4a" VARCHAR,
  "q5" BIGINT,
  "q5a" VARCHAR,
  "q6" BIGINT,
  "q6a" VARCHAR,
  "q7a" DOUBLE,
  "q7b" DOUBLE,
  "q7c" DOUBLE,
  "q7d" DOUBLE,
  "q7e" DOUBLE,
  "q7f" DOUBLE,
  "q7g" DOUBLE,
  "q7h" VARCHAR,
  "q7i" DOUBLE,
  "q7j" DOUBLE,
  "q7k" DOUBLE,
  "q7l" DOUBLE,
  "q7m" DOUBLE,
  "q7n" VARCHAR,
  "q7o" DOUBLE,
  "q7p" DOUBLE,
  "q7q" DOUBLE,
  "q7r" DOUBLE,
  "q7s" DOUBLE,
  "q7t" DOUBLE,
  "q8a" VARCHAR,
  "q8b" VARCHAR,
  "q8c" VARCHAR,
  "q8d" VARCHAR,
  "q8e" VARCHAR,
  "q8f" VARCHAR,
  "q8g" VARCHAR,
  "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" VARCHAR,
  "q10c" VARCHAR,
  "q10d" VARCHAR,
  "q10e" DOUBLE,
  "q10f" DOUBLE,
  "q10g" DOUBLE,
  "q10h" VARCHAR,
  "q10i" VARCHAR,
  "q10j" VARCHAR,
  "q10k" VARCHAR,
  "q10l" DOUBLE,
  "q10m" DOUBLE,
  "q10n" DOUBLE,
  "q10o" DOUBLE,
  "q10p" DOUBLE,
  "q10q" DOUBLE,
  "q10r" DOUBLE,
  "q10s" DOUBLE,
  "q11a" DOUBLE,
  "q11b" VARCHAR,
  "q11c" VARCHAR,
  "q11d" VARCHAR,
  "q11e" DOUBLE,
  "q11f" DOUBLE,
  "q11g" DOUBLE,
  "q11h" VARCHAR,
  "q11i" VARCHAR,
  "q11j" VARCHAR,
  "q11k" VARCHAR,
  "q11l" DOUBLE,
  "q11m" DOUBLE,
  "q11n" DOUBLE,
  "q11o" DOUBLE,
  "q11p" DOUBLE,
  "q11q" DOUBLE,
  "q11r" DOUBLE,
  "q11s" DOUBLE,
  "q12a_1" DOUBLE,
  "q12a_2" DOUBLE,
  "q12a_3" DOUBLE,
  "q12b_1" VARCHAR,
  "q12b_2" VARCHAR,
  "q12b_3" VARCHAR
);

RALA TWA Data Dictionary

@usgov.usda_gov_delta_neighborhood_physical_activity_study_f82d7.rala_twa_data_dictionary

8.68 KB
160 rows
7 columns


CREATE TABLE rala_twa_data_dictionary (
  "variable_name" VARCHAR,
  "brief_description" VARCHAR,
  "variable_type" VARCHAR,
  "variable_length" BIGINT,
  "values" VARCHAR,
  "required" VARCHAR,
  "null_value" VARCHAR
);