Data Dictionary template for Tempe Open Data.

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.csvResource 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.csvResource 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.csvResource 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.csvResource 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.csvResource 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.csvResource 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.csvResource 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.csvResource 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.csvResource Description: This is a combined data dictionary from each of the 4 dataset files in this set.

Excel Spreadsheet Data Dictionary for Abatements and TIFs.For more information, please visit Cuyahoga County's Fiscal Hub Incentive Information Site.

Supplementary_Data_Dictionary_Sheet_v1.0.xls

The data dictionary Excel sheet is the main supporting document for the paper.

DD_-_Neonatal_Data.csv

The patient dataset is provided as a format for capturing data with respect to data dictionary.

Data dictionary and brochure for REAP (Resilient Economic Agricultural Practices). https://data.nal.usda.gov/node/5594

Data Entry Template 2017 includes

Excel templates for Experiment description worksheets, Site characterization worksheets, Management worksheets, Measurement worksheets where experimental unit data are reported, and Information that may be useful to the user, including drop down lists of treatment specific information and ranges of expected values. General and introductory instructions, as well as a Data Validation check are also included.A data dictionary typically provides a detailed description for each element or variable in a dataset or data model. Data dictionaries are used to document important and useful information such as a descriptive name, the data type, allowed values, units, and text description.Dataset citation: (dataset) USDA Agricultural Research Service. (2017). REAP (Resilient Economic Agricultural Practices). Agricultural Research Service. https://doi.org/10.15482/USDA.ADC/1372394.

This PDF file contains the data dictionary for the accompanying Excel file with a record of Historic Fire Incidents recorded in the Rochester Fire Department Mainframe Data System. The date range for this historic data is 01/01/1983 to 12/31/2005. The Personally Identifiable Information (PII) has been removed from the original data.

Analytical and field sampling data for each 2018-2019 NRSA Fish Tissue Study chemical contaminant are provided, along with a data dictionary that describes the contents of each data file. All results for the fillet tissue concentrations are reported on a wet weight basis. All the fish fillet samples analyzed contained detectable levels of mercury and PCBs, and PFAS were detected in 95% of the fillet samples. This dataset is associated with the following publication: Stahl, L., B.D. Snyder, H.B. McCarty, T. Kincaid, A. Olsen, T.R. Cohen, and J. Healey. Contaminants in Fish from U.S. Rivers: Probability-Based National Assessments. SCIENCE OF THE TOTAL ENVIRONMENT. Elsevier BV, AMSTERDAM, NETHERLANDS, 861(25): 160557, (2023).

These are the most recent Data Dictionary (pop-ups) and Panarctic Species List (PASL) zip files for all the vegetation plot data entered into Turboveg for the Alaska AVA. These files are necessary to correctly use the Turboveg data with regards to coded data. The Data Dictionary file will be updated when new datasets are entered into Turboveg which result in additions to coded data such as references, author code, habitat type, surficial geology, etc. Updates to the PASL will occur less frequently. Check the dates in the file names to be certain that you are using the most current files. Our data model is a set of tables that comprise our relational database. The Excel spreadsheet included in the resources below provides information about each field in our database, such as data type, description, if it is a required field, whether the information within the field is selected from a pop-up list, and whether the field is a standard within Turboveg or is specific to the AVA. Using Turboveg: 1) Download the installation file available through the link at Alaska Arctic Geoecological Atlas portal from the official Turboveg webpage (general installation file for worldwide users, however, some adjustments will be needed when using data from AAVA after installation of this program). 2) Open the Turboveg program and restore the most recent Data Dictionary and PASL zipped files into the Turboveg program by using the function 'Database-Backup/Restore-Restore.' All the previous versions of data dictionary files and PASL that are already in program will be overwritten. 3) Use the Alaska-AVA following the manual for Turboveg for Windows which is available at http://www.synbiosys.alterra.nl/turboveg/tvwin.pdf

The Delta Produce Sources Study was an observational study designed to measure and compare food environments of farmers markets (n=3) and grocery stores (n=12) in 5 rural towns located in the Lower Mississippi Delta region of Mississippi. Data were collected via electronic surveys from June 2019 to March 2020 using a modified version of the Nutrition Environment Measures Survey (NEMS) Farmers Market Audit tool. The tool was modified to collect information pertaining to source of fresh produce and also for use with both farmers markets and grocery stores. Availability, source, quality, and price information were collected and compared between farmers markets and grocery stores for 13 fresh fruits and 32 fresh vegetables 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. Resources in this dataset:Resource Title: Delta Produce Sources Study dataset . File Name: DPS Data Public.csvResource Description: The dataset contains variables corresponding to availability, source (country, state and town if country is the United States), quality, and price (by weight or volume) of 13 fresh fruits and 32 fresh vegetables sold in farmers markets and grocery stores located in 5 Lower Mississippi Delta towns.Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel Resource Title: Delta Produce Sources Study data dictionary. File Name: DPS Data Dictionary Public.csvResource Description: This file is the data dictionary corresponding to the Delta Produce Sources Study dataset.Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel

Resource Description: Description of variables in Condensed_HV data fileResource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: Consolidated data. File Name: consolidated_HV.csvResource Description: Condensed data for each site by year for plant size, weevil density, vegetation cover and meteorological data, 2008-2019.Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: Cover_2008 data dictionary. File Name: cover_2008_HV_meta.csvResource Description: description of variables in the file cover_2008_HVResource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: vegetation cover 2008. File Name: cover_2008_HV.csvResource Description: vegetation cover 2008-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: vegetation cover 2013 data dictionary. File Name: cover_2013_HV_meta.csvResource Description: description of variables in the file cover_2013_HV, which contains vegetation cover 2013-2019Resource Title: vegetation cover 2013. File Name: cover_2013_HV.csvResource Description: vegetation cover 2013-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2009 data dictionary. File Name: dissections_2009_HV_meta.csvResource Description: Description of variables in the file dissections_2009_HV, containing dissections of toadflax stems 2009-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2009-2011. File Name: dissections_2009_HV.csvResource Description: Data from dissection of toadflax stems 2009-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2012 data dictionary. File Name: dissections_2012_HV_meta.csvResource Description: description of variables in the file dissections_2012_HV, containing data from dissections of toadflax stems 2012-2019Resource Title: dissections 2012-2019. File Name: dissections_2012_HV.csvResource Description: data from dissection of toadflax stems 2012-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: stem_counts data dictionary. File Name: stem_counts_HV_meta.csvResource Description: description of variables in the file stem_counts_HV, which contains data on number of toadflax stems in 25 x 50 cm quadrats, 2008-2013Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com

We monitored populations of the stem weevil, Mecinus janthiniformis, the invasive alien weed Dalmatian toadflax (Linaria dalmatica) and other vegetation to document the impact of using M. janthiniformis as a biological control agent of L. dalmatica. Weevils were released in 2008 and again in 2014 after a wild fire. The results document increases and spread of weevil populations, decrease in Dalmatian toadflax and changes in cover of some vegetation classes. Resources in this dataset:Resource Title: Consolidated data dictionary. File Name: consolidated_HV_meta.csvResource Description: Description of variables in Condensed_HV data fileResource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: Consolidated data. File Name: consolidated_HV.csvResource Description: Condensed data for each site by year for plant size, weevil density, vegetation cover and meteorological data, 2008-2019.Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: Cover_2008 data dictionary. File Name: cover_2008_HV_meta.csvResource Description: description of variables in the file cover_2008_HVResource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: vegetation cover 2008. File Name: cover_2008_HV.csvResource Description: vegetation cover 2008-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: vegetation cover 2013 data dictionary. File Name: cover_2013_HV_meta.csvResource Description: description of variables in the file cover_2013_HV, which contains vegetation cover 2013-2019Resource Title: vegetation cover 2013. File Name: cover_2013_HV.csvResource Description: vegetation cover 2013-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2009 data dictionary. File Name: dissections_2009_HV_meta.csvResource Description: Description of variables in the file dissections_2009_HV, containing dissections of toadflax stems 2009-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2009-2011. File Name: dissections_2009_HV.csvResource Description: Data from dissection of toadflax stems 2009-2011Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: dissections 2012 data dictionary. File Name: dissections_2012_HV_meta.csvResource Description: description of variables in the file dissections_2012_HV, containing data from dissections of toadflax stems 2012-2019Resource Title: dissections 2012-2019. File Name: dissections_2012_HV.csvResource Description: data from dissection of toadflax stems 2012-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: stem_counts data dictionary. File Name: stem_counts_HV_meta.csvResource Description: description of variables in the file stem_counts_HV, which contains data on number of toadflax stems in 25 x 50 cm quadrats, 2008-2013Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: stem_counts. File Name: stem_counts_HV.csvResource Description: Number of toadflax stems in 25 x 50 cm quadrats, 2008-2013Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: stem_height data dictionary. File Name: stem_height_HV_meta.csvResource Description: description of variables in the file stem_height_HV.csv, which contains data on height of live Linaria dalmatica stems, 2008-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com Resource Title: stem_height. File Name: stem_height_HV.csvResource Description: height of live stems of Linaria dalmatica, 2008-2019Resource Software Recommended: Microsoft Excel,url: http://www.microsoft.com

These are results of a series of laboratory experiments to determine if topical application of methoprene and 20-ecdysone can terminate reproductive diapause of the weevil, Ceratapion basicorne, which is a recently permitted biological control agent of yellow starthistle (Centaurea solstitialis). Adult weevils feed on leaves, creating pin holes, and lay eggs inside leaves. Diapausing weevils were treated with various doses of methoprene (0, 0.01, 0.1, 1.0 micrograms) dissolved in acetone in experiments 1 and 2. They were treated sequentially first with acetone or 20-ecdysone (1.0 microgram) and then with methoprene (1.0 microgram) in experiment 3 and were treated with 20-ecdysone followed by methoprene in experiment 4. Resources in this dataset:Resource Title: data dictionary. File Name: JH Data Dictionary.csvResource Description: description of data fieldsResource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 1. File Name: JH expt1 data.csvResource Description: Methoprene dissolved in acetone was applied topically at doses of 0.0, 0.01 and 0.1 and 1.0 μg per female weevil, and the number of feeding holes and eggs were recorded daily on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 2. File Name: JH expt2 data.csvResource Description: Methoprene dissolved in acetone was applied topically at doses of 0.0 and 1.0 μg to female weevils that did not produce eggs in experiment 1. The number of feeding holes and eggs were recorded daily on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 3. File Name: JH expt3 data.csvResource Description: Three types of treatments were applied with sequential applications 2 days apart: 1) acetone + acetone [AA: control], 2) acetone + methoprene [AM], and 20-ecdysone + methoprene 174 [2M]. All doses were 1.0 μg. The number of feeding holes and eggs were recorded every 2 days on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel Resource Title: experiment 4. File Name: JH expt4 data.csvResource Description: Females from experiment 3 that did not oviposit consistently were treated with 1.0 μg of 20-ecdysone followed 2 days later by 1.0 μg of methoprene. The treatments AA, AM, 2M refer to experiment 3. The number of feeding holes and eggs were recorded every 2 days on cut leaves of yellow starthistle at room temperature (12 h photoperiod, temperature range 17 to 21°C).Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/microsoft-365/excel

Resource Description: This is a table of chemical compounds found in watermelonResource Title: Data dictionary. File Name: Data_dictionary_Watermelon_compounds_NAL_20210623.xlsxResource Description: This is the data dictionaryResource Software Recommended: Microsoft Excel,url: https://products.office.com/en-us/access

These are Excel outputs of each of the USEEIO State Models v1.0 for year 2020. They were developed using useeior v1.4.0 (https://github.com/USEPA/useeior/releases/tag/v1.4.0). See the referenced USEPA report for a full description. See the Data Dictionary for interpretation of the sheets in each Excel file.

Processed FTIR spectral data that demonstrates performance of quality assurance procedures used for data validation. This data is presented in "QA Summary of Surrogate Injections" Excel spreadsheet and contains data dictionary of parameters measured.

Project Description:

Title: Pandas Data Manipulation and File Conversion

Overview: This project aims to demonstrate the basic functionalities of Pandas, a powerful data manipulation library in Python. In this project, we will create a DataFrame, perform some data manipulation operations using Pandas, and then convert the DataFrame into both Excel and CSV formats.

Key Objectives:

1. DataFrame Creation: Utilize Pandas to create a DataFrame with sample data.
2. Data Manipulation: Perform basic data manipulation tasks such as adding columns, filtering data, and performing calculations.
3. File Conversion: Convert the DataFrame into Excel (.xlsx) and CSV (.csv) file formats.

Tools and Libraries Used:

• Python
• Pandas

Project Implementation:

1. DataFrame Creation:

   • Import the Pandas library.
   • Create a DataFrame using either a dictionary, a list of dictionaries, or by reading data from an external source like a CSV file.
   • Populate the DataFrame with sample data representing various data types (e.g., integer, float, string, datetime).

2. Data Manipulation:

   • Add new columns to the DataFrame representing derived data or computations based on existing columns.
   • Filter the DataFrame to include only specific rows based on certain conditions.
   • Perform basic calculations or transformations on the data, such as aggregation functions or arithmetic operations.

3. File Conversion:

   • Utilize Pandas to convert the DataFrame into an Excel (.xlsx) file using the to_excel() function.
   • Convert the DataFrame into a CSV (.csv) file using the to_csv() function.
   • Save the generated files to the local file system for further analysis or sharing.

Expected Outcome:

Upon completion of this project, you will have gained a fundamental understanding of how to work with Pandas DataFrames, perform basic data manipulation tasks, and convert DataFrames into different file formats. This knowledge will be valuable for data analysis, preprocessing, and data export tasks in various data science and analytics projects.

Conclusion:

The Pandas library offers powerful tools for data manipulation and file conversion in Python. By completing this project, you will have acquired essential skills that are widely applicable in the field of data science and analytics. You can further extend this project by exploring more advanced Pandas functionalities or integrating it into larger data processing pipelines.in this data we add number of data and make that data a data frame.and save in single excel file as different sheet name and then convert that excel file in csv file .

Dataset I and dictionary I. Excel spreadsheet and Data Dictionary that contain information on tissue samples of suspected Melanoma cases including specimens such as presence of tumor, tissue source and other relevant tissue information relevant to genomic analysis.

The Pesticide Data Program (PDP) is a national pesticide residue database program. Through cooperation with State agriculture departments and other Federal agencies, PDP manages the collection, analysis, data entry, and reporting of pesticide residues on agricultural commodities in the U.S. food supply, with an emphasis on those commodities highly consumed by infants and children.This dataset provides information on where each tested sample was collected, where the product originated from, what type of product it was, and what residues were found on the product, for calendar years 1992 through 2023. The data can measure residues of individual compounds and classes of compounds, as well as provide information about the geographic distribution of the origin of samples, from growers, packers and distributors. The dataset also includes information on where the samples were taken, what laboratory was used to test them, and all testing procedures (by sample, so can be linked to the compound that is identified). The dataset also contains a reference variable for each compound that denotes the limit of detection for a pesticide/commodity pair (LOD variable). The metadata also includes EPA tolerance levels or action levels for each pesticide/commodity pair. The dataset will be updated on a continual basis, with a new resource data file added annually after the PDP calendar-year survey data is released.Resources in this dataset:Resource Title: CSV Data Dictionary for PDP.File Name: PDP_DataDictionary.csv. Resource Description: Machine-readable Comma Separated Values (CSV) format data dictionary for PDP Database Zip files. Defines variables for the sample identity and analytical results data tables/files. The ## characters in the Table and Text Data File name refer to the 2-digit year for the PDP survey, like 97 for 1997 or 01 for 2001. For details on table linking, see PDF. Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excelResource Title: Data dictionary for Pesticide Data Program. File Name: PDP DataDictionary.pdf. Resource Description: Data dictionary for PDP Database Zip files. Resource Software Recommended: Adobe Acrobat, url: https://www.adobe.comResource Title: 2023 PDP Database Zip File. File Name: 2023PDPDatabase.zipResource Title: 2022 PDP Database Zip File. File Name: 2022PDPDatabase.zipResource Title: 2021 PDP Database Zip File. File Name: 2021PDPDatabase.zipResource Title: 2020 PDP Database Zip File. File Name: 2020PDPDatabase.zipResource Title: 2019 PDP Database Zip File. File Name: 2019PDPDatabase.zipResource Title: 2018 PDP Database Zip File. File Name: 2018PDPDatabase.zipResource Title: 2017 PDP Database Zip File. File Name: 2017PDPDatabase.zipResource Title: 2016 PDP Database Zip File. File Name: 2016PDPDatabase.zipResource Title: 2015 PDP Database Zip File. File Name: 2015PDPDatabase.zipResource Title: 2014 PDP Database Zip File. File Name: 2014PDPDatabase.zipResource Title: 2013 PDP Database Zip File. File Name: 2013PDPDatabase.zipResource Title: 2012 PDP Database Zip File. File Name: 2012PDPDatabase.zipResource Title: 2011 PDP Database Zip File. File Name: 2011PDPDatabase.zipResource Title: 2010 PDP Database Zip File. File Name: 2010PDPDatabase.zipResource Title: 2009 PDP Database Zip File. File Name: 2009PDPDatabase.zipResource Title: 2008 PDP Database Zip File. File Name: 2008PDPDatabase.zipResource Title: 2007 PDP Database Zip File. File Name: 2007PDPDatabase.zipResource Title: 2006 PDP Database Zip File. File Name: 2006PDPDatabase.zipResource Title: 2005 PDP Database Zip File. File Name: 2005PDPDatabase.zipResource Title: 2004 PDP Database Zip File. File Name: 2004PDPDatabase.zipResource Title: 2003 PDP Database Zip File. File Name: 2003PDPDatabase.zipResource Title: 2002 PDP Database Zip File. File Name: 2002PDPDatabase.zipResource Title: 2001 PDP Database Zip File. File Name: 2001PDPDatabase.zipResource Title: 2000 PDP Database Zip File. File Name: 2000PDPDatabase.zipResource Title: 1999 PDP Database Zip File. File Name: 1999PDPDatabase.zipResource Title: 1998 PDP Database Zip File. File Name: 1998PDPDatabase.zipResource Title: 1997 PDP Database Zip File. File Name: 1997PDPDatabase.zipResource Title: 1996 PDP Database Zip File. File Name: 1996PDPDatabase.zipResource Title: 1995 PDP Database Zip File. File Name: 1995PDPDatabase.zipResource Title: 1994 PDP Database Zip File. File Name: 1994PDPDatabase.zipResource Title: 1993 PDP Database Zip File. File Name: 1993PDPDatabase.zipResource Title: 1992 PDP Database Zip File. File Name: 1992PDPDatabase.zip

SDR 2.0 Cotton File: Cumulative List of Variables in the Surveys of the SDR Database is a comprehensive data dictionary, in Microsoft Excel format. Its main purpose is to facilitate the overview of 88118 variables (i.e. variable names, values, and labels) available in the original (source) data files that we retrieved automatically for harmonization purposes in the SDR Project. Information in the Cotton File comes from 215 source data files that comprise ca. 3500 national surveys administered between 1966 and 2017 in 169 countries or territories, as part of 23 international survey projects. The COTTON FILE SDR2 is a product of the project Survey Data Recycling: New Analytic Framework, Integrated Database, and Tools for Cross-national Social, Behavioral and Economic Research, financed by the US National Science Foundation (PTE Federal award 1738502). We thank the Ohio State University and the Institute of Philosophy and Sociology, Polish Academy of Sciences, for organizational support.

The National Health and Nutrition Examination Survey (NHANES) provides data and have considerable potential to study the health and environmental exposure of the non-institutionalized US population. However, as NHANES data are plagued with multiple inconsistencies, processing these data is required before deriving new insights through large-scale analyses. Thus, we developed a set of curated and unified datasets by merging 614 separate files and harmonizing unrestricted data across NHANES III (1988-1994) and Continuous (1999-2018), totaling 135,310 participants and 5,078 variables. The variables conveydemographics (281 variables),dietary consumption (324 variables),physiological functions (1,040 variables),occupation (61 variables),questionnaires (1444 variables, e.g., physical activity, medical conditions, diabetes, reproductive health, blood pressure and cholesterol, early childhood),medications (29 variables),mortality information linked from the National Death Index (15 variables),survey weights (857 variables),environmental exposure biomarker measurements (598 variables), andchemical comments indicating which measurements are below or above the lower limit of detection (505 variables).csv Data Record: The curated NHANES datasets and the data dictionaries includes 23 .csv files and 1 excel file.The curated NHANES datasets involves 20 .csv formatted files, two for each module with one as the uncleaned version and the other as the cleaned version. The modules are labeled as the following: 1) mortality, 2) dietary, 3) demographics, 4) response, 5) medications, 6) questionnaire, 7) chemicals, 8) occupation, 9) weights, and 10) comments."dictionary_nhanes.csv" is a dictionary that lists the variable name, description, module, category, units, CAS Number, comment use, chemical family, chemical family shortened, number of measurements, and cycles available for all 5,078 variables in NHANES."dictionary_harmonized_categories.csv" contains the harmonized categories for the categorical variables.“dictionary_drug_codes.csv” contains the dictionary for descriptors on the drugs codes.“nhanes_inconsistencies_documentation.xlsx” is an excel file that contains the cleaning documentation, which records all the inconsistencies for all affected variables to help curate each of the NHANES modules.R Data Record: For researchers who want to conduct their analysis in the R programming language, only cleaned NHANES modules and the data dictionaries can be downloaded as a .zip file which include an .RData file and an .R file.“w - nhanes_1988_2018.RData” contains all the aforementioned datasets as R data objects. We make available all R scripts on customized functions that were written to curate the data.“m - nhanes_1988_2018.R” shows how we used the customized functions (i.e. our pipeline) to curate the original NHANES data.Example starter codes: The set of starter code to help users conduct exposome analysis consists of four R markdown files (.Rmd). We recommend going through the tutorials in order.“example_0 - merge_datasets_together.Rmd” demonstrates how to merge the curated NHANES datasets together.“example_1 - account_for_nhanes_design.Rmd” demonstrates how to conduct a linear regression model, a survey-weighted regression model, a Cox proportional hazard model, and a survey-weighted Cox proportional hazard model.“example_2 - calculate_summary_statistics.Rmd” demonstrates how to calculate summary statistics for one variable and multiple variables with and without accounting for the NHANES sampling design.“example_3 - run_multiple_regressions.Rmd” demonstrates how run multiple regression models with and without adjusting for the sampling design.