Data Dictionary - M3P2
The data dictionary utilized in building the project dataset is outlined below.
| Website Field Name | Description | Data Type | Range of Values | Notes |
|---|---|---|---|---|
| ID | M3P2 system identification number | Text | AZ-OPGIS-1982-1 to AZ-OPGIS-2023-197; AZ-OPGIS-NoDate-1 to AZ-OPGIS-NoDate-151; CA-I-C-2015-1 to CA-I-C-2023-8; CA-I-NU-2009-1 to CA-I-NU-2017-2; CA-R-2006-1 to CA-R-2023-1; CA-SD-MEO-2009-1 to CA-SD-MEO-2023-40; NM-OMI-2009-1 to NM-OMI-2023-116; TX-B-2009-1 to TX-B-2023-45; TX-EP-MEO-2013-1 to TX-EP-MEO-2023-24; TX-NU-2009-1 to TX-NU-2023-21; TX-OI-B-2001-1 to TX-OI-B-2023-10; TX-OI-B-NoDate-2 to TX-OI-B-NoDate-3; TX-OI-nB-1980-1 to TX-OI-nB-2023-25; TX-OI-nB-NoDate-1 to TX-OI-nB-NoDate-8 | Some cases have been consolidated; therefore, the sequence of numbers may be incomplete. For example, there is a "TX-OI-B-NoDate-2" and a "TX-OI-B-NoDate-3," but no "TX-OI-B-NoDate-1" |
| Source | Data source identifier | Text | Imperial County Coroner's Office; Riverside County Sheriff's Office; San Diego Medical Examiner's Office; Maricopa County Office of the Medical Examiner; Pima County Office of the Medical Examiner; New Mexico Office of the Medical Investigator; Brooks County Sheriff's Office; El Paso County Office of the Medical Examiner; Hudspeth Justice of the Peace 1; Hudspeth Justice of the Peace 2; NamUs; OGIS; Operation Identification; No More Deaths; IOM Missing Migrant Program | "OGIS" refers to the Arizona OpenGIS for Deceased Migrants–Humane Borders initiative; "Operation Identification" is an initiative of the Forensic Anthropology Center at Texas State University; "IOM" stands for "International Organization for Migration"; "NamUs" refers to the National Missing and Unidentified Persons System of the National Institute of Justice. |
| Death Date | Date the human remains were found, if known | Date | August 25, 1980 to December 29, 2023 (08/25/1980-12/29/2023) | Some cells are empty |
| Death Year | Year the human remains were found, if known | Number | 1980; 1981; 1982; 1984; 1985; 1986; 1987; 1990; 1991; 1992; 1993; 1994; 1995; 1996; 1997; 1998; 1999; 2000; 2001; 2002; 2003; 2004; 2005; 2006; 2007; 2008; 2009; 2010; 2011; 2012; 2013; 2014; 2015; 2016; 2017; 2018; 2019; 2020; 2021; 2022; 2023 | |
| Death Month | Month the human remains were found, if known | Text | January; February; March; April; May; June; July; August; September; October; November; December; No information | |
| Death Season | Season the human remains were found, if known | Text | Spring; Summer; Fall; Winter; Uncertain; No information | |
| Age Range | Estimated age at death, reported as a range by the data source or determined by the administrator | Text | Fetal (<birth); Teen to Adult; Adult (>18 years); Non adult (≤18 years); No information | Reduced range of values |
| Sex | Biological sex, as estimated or known | Text | Female; Male; Undetermined; No information | Reduced range of values |
| Identified | Indicates whether the human remains have been identified, if known | Text | Identified; Not Identified; No Information | |
| Race/Ethnicity | The categories "race" and/or "ethnicity" were used interchangeably, depending on the data source, and were coded as documented by the original data source before being standardized according to federal reporting categories for "race" and/or "ethnicity." Notation format: Race (if specified), Ethnicity (if specified) | Text | Undetermined Race, Hispanic or Latino; White, Hispanic or Latino; White, Undetermined Ethnicity; Undetermined Race or Ethnicity; Other; No information | Reduced range of values |
| Nationality | Country of origin for identified cases, cases with associated identification documents, or cases for which the data source reports a nationality. Nationality is considered tentative until a positive identification is made | Text | Mexico; El Salvador; Guatemala; Honduras; Ecuador; Other; No information | Reduced range of values |
| Manner of Death | Manner of death, using standardized forensic terminology | Text | Accident; Homicide; Natural; Suicide; Pending investigation; Undetermined; No information | |
| Cause of Death | Cause of death from source, if provided. Standardized categories | Text | Blunt force trauma, various; Drowning; Environmental exposure, various; Skeletal Remains; Pending investigation; Other; Undetermined; No information | Reduced range of values |
| Condition of Remains | Condition of remains as reported by the data source, if provided. Standardized categories | Text | Fresh; Decomposing; Skeletal; No information | |
| State | U.S. State | Text | CA; AZ; NM; TX | |
| County | U.S. County | Text | Brewster; Brooks; Cameron; Cochise; Culberson; Dimmit; Doña Ana; Duval; El Paso; Grant; Hidalgo; Hudspeth; Imperial; Jeff Davis; Jim Hogg; Jim Wells; Kenedy; Kinney; Kleberg; La Paz; La Salle; Lincoln; Live Oak; Luna; Maricopa; Maverick; Otero; Pima; Pinal; Presidio; Riverside; San Diego; Santa Cruz; Sierra; Starr; Val Verde; Webb; Willacy; Yuma; Zapata; Zavala | |
| City | Copied directly from the original data source, when available. May indicate the nearest city, town, or other populated place where the human remains were recovered | Text | Aguanga; Ajo; Ak-Chin Indian Community; Alamo Hueco; Alamogordo; Albuquerque; Alice; Alpine; Animas; Anthony; Apache; Armstrong; Beaumont; Benavides; Benson; Bernadino; Big Horn; Blue Town; Blythe; Borrego Springs; Boulevard; Bouse; Brackettville; Brawley; Brownsville; Bruni; Buena Vista; Cabeza Prieta; Calexico; Campo; Carlsbad; Carrizo Springs; Carrizozo; Casa Grande; Chandler; Chula Vista; Coachella; Columbus; Coolidge; Corona; Cotulla; Cowlic; Crystal City; Del Rio; Deming; Descanso; Desert Center; Doña Ana; Donna; Douglas; Dragoon; Dudleyville; Dulzura; Eagle Pass; Edinburg; El Cenizo; El Centro; El Indio; El Paso; Encinal; Encino; Fabens; Falfurrias; Fallbrook; Felicity; Florence; Fort Bliss; Fort Davis; Fort Hancock; Freer; George West; Gilbert; Glamis; Goldwater; Goodyear; Granjeño; Green Valley; Hachita; Harlingen; Hatch; Havana; Hebbronville; Hemet; Hidalgo; Holtville; Imperial; Imperial Beach; Indio; Jacumba; Jamul; Julian; Kingsville; La Gloria; La Grulla; La Havana; La Jolla; La Joya; La Joya/La Havana; La Mesa; La Pryor; Lajitas; Lake Elsinore; Laredo; Las Cruces; Linn; Lordsburg; Los Ebanos; Lower Santan Village; Marana; Marathon; Maricopa; McAllen; Mescal; Mesquite; Mission; Monte Alto; Mount Laguna; Murrieta; Niland; Nogales; Norias; Oceanside; Ocotillo; Ogilby; Orange Grove; Palm Springs; Palo Verde; Patagonia; Penitas; Pharr; Phoenix; Pine Valley; Plateau; Playas; Port Mansfield; Potrero; Progresso; Queen Valley; Quemado; Rachel; Radium Springs; Ramirez; Realitos; Rincon; Rio Grande City; Riverside; Riviera; Road Forks; Rodeo; Roma; Rudolph; Rural; Sacaton; Salton City; San Benito; San Carlos; San Diego; San Juan; San Miguel; San Ygnacio; San Ysidro; Santa Teresa; Santee; Sarita; Sasabe; Seeley; Sells; Shafter; Sierra Vista; Socorro; South Padre; Sullivan City; Sunland Park; Sunwest; Tacubaya; Tecate; Temescal Valley; Thermal; Tornillo; Truth or Consequences; Tucson; Vado; Valentine; Valley Center; Van Horn; Winterhaven; Yturria; Yuma; Zapata; Uncertain; No information | |
| ZIP Code | U.S. ZIP Code | Text | 78014; 78019; 78040; 78041; 78043; 78045; 78046; 78067; 78071; 78076; 78255; 78332; 78338; 78341; 78344; 78353; 78355; 78355; 78357; 78361; 78372; 78376; 78379; 78385; 78501; 78503; 78516; 78520; 78521; 78538; 78541; 78542; 78548; 78550; 78557; 78560; 78563; 78565; 78565; 78572; 78573; 78576; 78577; 78580; 78582; 78584; 78586; 78588; 78589; 78595; 78597; 78598; 78783; 78832; 78834; 78839; 78840; 78852; 78860; 78872; 78877; 79734; 79830; 79836; 79838; 79839; 79843; 79852; 79853; 79854; 79855; 79901; 79902; 79905; 79915; 79916; 79927; 79928; 85128; 85147; 85192; 85321; 85602; 85609; 85621; 85624; 85633; 85634; 87008; 87901; 87937; 87940; 88001; 88006; 88007; 88008; 88009; 88011; 88020; 88021; 88029; 88030; 88032; 88040; 88044; 88045; 88048; 88054; 88056; 88063; 88072; 88081; 88301; 88310; 88340; 91901; 91903; 91905; 91906; 91910; 91911; 91914; 91915; 91916; 91917; 91932; 91934; 91935; 91942; 91948; 91962; 91963; 91980; 92004; 92011; 92019; 92028; 92036; 92037; 92056; 92071; 92082; 92101; 92103; 92106; 92107; 92109; 92123; 92154; 92158; 92161; 92173; 92179; 92201; 92223; 92225; 92227; 92231; 92236; 92239; 92239; 92240; 92243; 92243; 92250; 92250; 92251; 92257; 92259; 92259; 92262; 92264; 92266; 92273; 92274; 92274; 92283; 92283; 92530; 92536; 92544; 92881; 92883; Uncertain; No information | |
| Land Access | Deductively categorized based on the data source's circumstances or scene removal notes and, when available, information indicating how and/or by whom the decedent was discovered. Standardized categories | Text | Public; Private; Tribal; Military; Other; No information | Reduced range of values |
| Landscape Type | Deductively categorized based on the data source's general description of the landscape in which the decedent was found or died (e.g., a hospital), when provided. Standardized categories | Text | Built area; Mountain; Desert, various; Vegetated area, various; Water, various; Not applicable; No information | Reduced range of values |
| Position Accuracy Level | Copied directly from the original data source, when available. Cross-checked against the case's scene removal and/or circumstances notes to verify the location. | Text | County; Coordinate, zero decimals; Coordinate, one decimal; Coordinate, two decimals; Coordinate, three decimals; Coordinate, four decimals; Coordinate, five decimals; Coordinate, six decimals; Coordinate, seven decimals; Coordinate, eight decimals; Coordinate, twelve decimals | May differ from data source after administrator's review |
| Latitude | Decimal degrees, positive values (Northern Hemisphere), WGS84 | Number | 26.05813 to 33.94276 | Some cells are empty. Values may differ from the data source after administrator's review |
| Longitude | Decimal degrees, negative values (Western Hemisphere), WGS84 | Number | -97.62583 to -117.646183 | Some cells are empty. Values may differ from the data source after administrator's review |
| Coordinate Location Accuracy | Standardized indication of ccordinate location positional accuracy. Cross-checked against the case's latitude and longitude coordinates, when provided. | Text | Low; Medium; High; Not applicable | For Arizona and most of New Mexico, the data source provided an accuracy estimate |
| At Scene | Law enforcement agencies present at the death scene, as documented in the data source's case notes | Text | Local; State; State and Local; State and Other; Federal; Federal and Local; Federal and State; Federal and State and Local; Not specified; No information | Some cells are empty. In some cases, values were estimated by the administrator |
| Finder | Person or entity that discovered the decedent, as documented in the data source's case notes | Text | Local law enforcement; State law enforcement; State and Local law enforcement; Federal law enforcement; Federal and Local law enforcement; Federal and State law enforcement; Situational participant (hunters); Situational participant (migrants); Situational participant (ranch owners); Situational participant (ranch workers); Situational participant (unnamed passersby); Situational participant (other); Situational participant (unspecified); Mexican State Police; Uncertain; Not specified; No information | Some cells are empty. In some cases, values were estimated by the administrator |