New Mexico Electric Retail Service Territories with Select Aggregated 2020 Demographic Data and 2020 Election Results

## RDH Date Retrieval
02/20/2024

## Sources
Electric Retail Service Territory shapefile is from the [U.S. Energy Information Administration](https://hifld-geoplatform.opendata.arcgis.com/datasets/geoplatform::electric-retail-service-territories-2/about)

New Mexico block PL 94-171 2020 is from the [Redistricting Data Hub](https://redistrictingdatahub.org/dataset/new-mexico-block-pl-94171-2020/)

New Mexico 2020 General Election Results Disaggregated to the 2020 Block is from the [Redistricting Data Hub](https://redistrictingdatahub.org/dataset/new-mexico-2020-general-election-results-disaggregated-to-the-2020-block/)
        

## Fields:
Field Name   Description                                                                                               
STATE        State Abbreviation                                                                                        
ERS          Electric Retail Service Territory Name                                                                    
TOT_POP      Total Population (P0010001)                                                                               
TOT_VAP      Total Voting Age Population (P0030001)                                                                    
TOT_ANY_AIAN Total Any Part Native American/Alaska Native Population (sum of fields listed below)                      
VAP_ANY_AIAN Total Voting Age Population Any Part Native American/Alaska Native Population (sum of fields listed below)
PRES_TOT     Total Votes Cast in the 2020 Presidential General Election                                                
G20PRERTRU   Votes for Donald J. Trump (Republican Party) in the 2020 Presidential General Election                    
G20PREDBID   Votes for Joseph R. Biden (Democratic Party) in the 2020 Presidential General Election                    
G20PRELJOR   Votes for Jo Jorgensen (Libertarian Party) in the 202 Presidential General Election
G20PREGHAW   Votes for Howie Hawkins (Green Party) in the 2020 Presidential General Election                           
G20PRECTIT   Votes for Sheila "Samm" Tittle (Constitution Party) in 2020 Presidential General Election                 
G20PRESLAR   Votes for Gloria La Riva (Party for Socialism and Liberation) in the 2020 Presidential Election                         
PER_AIAN     Percent Any Part Native American/Alaska Native of Total Population                                        
PER_VAP_AIAN Percent Any Part Native American/Alaska Native of Voting Age Population                                   
PER_TRUMP    Percent of Votes for Trump in the 2020 Presidential General Election                                      
PER_BIDEN    Percent of Votes for Biden in the 2020 Presidential General Election                                      
         

## Processing Steps
Any part Native American/Alaska Native total field was created summing the following categories in the PL 94-171 data: ['P0010005', 'P0010012', 'P0010016', 'P0010020', 'P0010021', 'P0010022', 'P0010027', 'P0010031', 'P0010032', 'P0010033', 'P0010037', 'P0010038', 'P0010039', 'P0010043', 'P0010044', 'P0010045', 'P0010048', 'P0010049', 'P0010050', 'P0010054', 'P0010055', 'P0010056', 'P0010058', 'P0010059', 'P0010060', 'P0010062', 'P0010064', 'P0010065', 'P0010066', 'P0010068', 'P0010069', 'P0010071'].
Any part Native American/Alaska Native VAP field was created summing the following categories in the PL 94-171 data: ['P0030005', 'P0030012', 'P0030016', 'P0030020', 'P0030021', 'P0030022', 'P0030027', 'P0030031', 'P0030032', 'P0030033', 'P0030037', 'P0030038', 'P0030039', 'P0030043', 'P0030044', 'P0030045', 'P0030048', 'P0030049', 'P0030050', 'P0030054', 'P0030055', 'P0030056', 'P0030058', 'P0030059', 'P0030060', 'P0030062', 'P0030064', 'P0030065', 'P0030066', 'P0030068', 'P0030069', 'P0030071']

All election results and demographic data was queried to the selected fields and joined together. 
Electric Retail Service Territories (ERS) were queried to the state and then clipped to the state boundary (as they can extend into multiple states).
Blocks are spatially assigned iteratively to ERS areas using the [maup library](https://github.com/mggg/maup).
Since ERS areas can overlap, blocks can be assigned to multiple ERS areas, therefore data will not sum to state total values.
All ERS areas included in the ERS file, and just Cooperatives are included in the COOPS file.

Visit the RDH GitHub and the processing script for this code [here](https://github.com/nonpartisan-redistricting-datahub/Processing-Requests)

## Additional Notes
A full raw-from-source file containing all input files can be provided upon request.

Please direct questions related to processing this dataset to info@redistrictingdatahub.org.