Risk-Screening Environmental Indicators (RSEI) Model

RSEI Data Dictionary: Aggregated Microdata

                            Tables in the RSEI Data Dictionary  
  Facility Chemical Submission Category Block Group Microdata Population Data  
  Offsite MCL Release Disaggregated Microdata Water Microdata Shapefiles  
  NAICS Media Elements Aggregated Microdata Census Crosswalks    

Aggregated Microdata files use the same data as the disaggregated files, but sum the chemical releases over each grid cell. Because the values are summed, unweighted concentrations are not available (the sum of the concentrations of different chemicals would be meaningless).

Naming: These annual files have historically been named MicroXXXX_YYYY, where XXXX is the reporting year for the data freeze, and YYYY is the year of the data contained in the file. So Micro 2014_2010 is from the RY2014 RSEI update, and contains data for chemicals released in 2010. The new naming convention substitutes the version number for the version year, as in vXXX_micro_YYYY, where XXX is the version number and YYYY is the data year; for example v234_micro_2014.csv.These files have historically been named in the format AggMicroXXXX_YYYY_GCZZ, where XXXX is the reporting year for the data freeze, YYYY is the year of the data contained in the file, and ZZ is the 2-digit grid code (see Field 1 in the Table 1 below for grid codes).  The new naming convention substitutes the version number for the version year, as in vXXX_aggregated_micro_gcZZ_YYYY; for example, v234_aggregated_micro_gc14_2014.csv.

Aggregated Microdata Table

Field Number

Name

Description

1

X

X-coordinate of grid cell

2

Y

Y-Coordinate of grid cell

3

NumberOfFacilities

Number of facilities with releases affecting grid cell.

4

NumberOfReleases

Number of individual releases affecting grid cell.

5

NumberOfChemicals

Number of chemicals with nonzero concentrations for grid cell.

6

ToxConc

Concentration multiplied by inhalation toxicity weight, summed over all chemicals impacting cell

7

Score

Risk-related score (surrogate dose * toxicity weight * population), summed over all chemicals impacting cell

8

Pop

Population of grid cell

9

ScoreCancer

Risk-related score (surrogate dose * toxicity weight * population) using only toxicity values for cancer effects

10

ScoreNonCancer

Risk-related score (surrogate dose * toxicity weight * population) using only toxicity values for cancer effects