This codebook.txt file was generated on <20180924> by <Zhiyuan Yao>


-------------------
GENERAL INFORMATION
-------------------


1. Title of Dataset 
Airborne Manganese at Ohio Valley Educational Service Center, Marietta

2. Author Information

  Principal Investigator Contact Information
        Name: Erin Haynes
           Institution: University of Cincinnati
           Address: G32A Kettering Building, 160 Panzeca Way, Cincinnati, OH 45267
           Email: erin.haynes@uc.edu


  Associate or Co-investigator Contact Information
        Name:
           Institution:
           Address:
           Email:


  Associate or Co-investigator Contact Information
           Name:
           Institution:
           Address:
           Email:


3. Date of data collection (single date, range, approximate date) <suggested format YYYYMMDD>
20090817-20120225

4. Geographic location of data collection (where was data collected?): 
1338 Colegate Dr, Marietta, OH 45750

5. Information about funding sources that supported the collection of the data:




--------------------------
SHARING/ACCESS INFORMATION
-------------------------- 


1. Licenses/restrictions placed on the data:


2. Links to publications that cite or use the data:


3. Links to other publicly accessible locations of the data:


4. Links/relationships to ancillary data sets:


5. Was data derived from another source?
           If yes, list source(s): https://www3.epa.gov/air/sat/TheOhioValAddl.html

6. Recommended citation for the data:




---------------------
DATA & FILE OVERVIEW
---------------------


1. File List
   A. Filename: Marietta_OhioValleyEducationalServiceCenter.mp4       
      Short description: The video shows the changes of the monthly average of airborne manganese in 
                         Ohio Valley Educational Service Center, Marietta.        

        
   B. Filename:  Marietta_OhioValleyEducationalServiceCenter.ppt       
      Short description: This file shows how the video is created in PowerPoint.       

        
   C. Filename:  Marietta_OhioValleyEducationalServiceCenter_Processed.csv        
      Short description: This file gives the processed monthly averages of airborne manganese. 


   D. Filename:  Marietta_OhioValleyEducationalServiceCenter_Raw.csv     
      Short description: This file gives the raw data of airborne manganese.     

        
   E. Filename:  Marietta_OhioValleyEducationalServiceCenter_WorkingFile.xlsx        
      Short description: This file shows how data are processed.

2. Relationship between files:        
Marietta_OhioValleyEducationalServiceCenter_Raw.csv is the raw data. Marietta_OhioValleyEducationalServiceCenter_Processed.csv is
the aggregated monthly averages of the raw data. Marietta_OhioValleyEducationalServiceCenter_WorkingFile.xlsx shows how the raw
data are processed into monthly averages. Marietta_OhioValleyEducationalServiceCenter.ppt illustrates how the video is 
generated. Marietta_OhioValleyEducationalServiceCenter.mp4 is the video generated from Marietta_OhioValleyEducationalServiceCenter.ppt.  

3. Additional related data collected that was not included in the current data package:




4. Are there multiple versions of the dataset? no
   If yes, list versions:
           Name of file that was updated:
                     i. Why was the file updated? 
                ii. When was the file updated?
           Name of file that was updated:
                      i. Why was the file updated?
                    ii. When was the file updated?






--------------------------
METHODOLOGICAL INFORMATION
--------------------------


1. Description of methods used for collection/generation of data: 
<Include links or references to publications or other documentation containing experimental design or protocols used in data collection>


2. Methods for processing the data: <describe how the submitted data were generated from the raw or collected data>
The daily airborne manganese data are aggregated into monthly averages.

3. Instrument- or software-specific information needed to interpret the data:


4. Standards and calibration information, if appropriate:


5. Environmental/experimental conditions:


6. Describe any quality-assurance procedures performed on the data:


7. People involved with sample collection, processing, analysis and/or submission:






-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_OhioValleyEducationalServiceCenter_Raw.csv]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
5
2. Number of cases/rows: 
81

3. Missing data codes:
         --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                

    A. Name: <Date>
       Description: <The day when data were collected>
                    Value labels: 8/17/2009, et al.

    B. Name: <Lead Non-FRM/FEM (Nanograms/cubic meter)>
       Description: <Airborne lead>
                    Value labels: 1.68, et al.

    C. Name: <Manganese (Nanograms/cubic meter)>
       Description: <Airborne manganese>
                    Value labels: 43.7, et al.

    D. Name: <Lead Sample Screening Level>
       Description: <Lead Sample Screen Level>
                    Value labels: 150.

    E. Name: <Manganese Sample Screening Level>
       Description: <Manganese Sample Screen Level>
                    Value labels: 500.

-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_OhioValleyEducationalServiceCenter_Processed.csv]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
5

2. Number of cases/rows: 
32

3. Missing data codes:
         --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                

    A. Name: <Date_Month>
       Description: <The month when the data were collected>
                    Value labels: 2009 Aug., et al. 


    B. Name: <Month_Average (ug/m3)>
       Description: <The monthly average of the airborne manganese>
                     Value labels:0.033983333, et al.

    C. Name: <EPA Standard (ug/m3)>
       Description: <EPA reference for airborne manganese>
                    Value labels: 0.05, et al. 


    D. Name: <ATSDR Standard (ug/m3)>
       Description: <ATSDR Standard for airborne manganese>
                     Value labels: 0.3, et al.

    E. Name: <WHO Standard (ug/m3)>
       Description: <WHO Standard for airborne manganese>
                    Value labels: 0.15, et al.

-----------------------------------------
DATA-SPECIFIC INFORMATION FOR: [Marietta_WarrenElementaySchool_WorkingFile.xlsx]
-----------------------------------------
<create sections for each dataset included>


1. Number of variables:
10

2. Number of cases/rows: 
For variables, Date_Day, Manganese (Nanograms/cubic meter), Manganese (ug/m3) and Month, there are 81 rows.
For variables, Date_Month, Month_Average(ug/m3), EPA Standard, ATSDR Standard, WHO Standard, and Month_condition,
there are 32 rows.

3. Missing data codes:
        --                 Sample not taken or invalid


4. Variable List

    Example. Name: Gender 
             Description: Gender of respondent
                    1 = Male
                    2 = Female
                    3 = Other                

    A. Name: <Date_Day>
       Description: <The day when the data were collected>
                    Value labels: 08/17/2009, et al. 

    B. Name: <Manganese (Nanograms/cubic meter)>
       Description: <Airborne manganese>
                     Value labels: 43.7, et al.

    C. Name: <Manganese (ug/m3)>
       Description: <Airborne manganese>
                     Value labels:0.0437, et al.

    D. Name: <Month>
       Description: <The month when the data were collected>
                     Value labels:  8, 9, et al.

    E. Name: <Date_Month>
       Description: <The month when the data were collected>
                    Value labels: Aug-09, Sep-09, et al. 

    F. Name: <Month_Average (ug/m3)>
       Description: <The monthly average of the airborne manganese>
                     Value labels:0.033983333, et al.

    G. Name: <EPA Standard (ug/m3)>
       Description: <EPA reference for airborne manganese>
                    Value labels: 0.05, et al. 


    H. Name: <ATSDR Standard (ug/m3)>
       Description: <ATSDR Standard for airborne manganese>
                     Value labels: 0.3, et al.

    I. Name: <WHO Standard (ug/m3)>
       Description: <WHO Standard for airborne manganese>
                    Value labels: 0.15, et al.

    J. Name: <Month_condition>
       Description: <The condition variable for calculating monthly averages>
                    Value labels: 8, 9, et al.