New Orleans 2021 City Council Primary and Runoff Precinct-Level Results

## RDH Date Retrieval
3/8/24

## Sources
Election results via [Louisiana Secretary of State](https://voterportal.sos.la.gov/static/)

Precinct boundaries (Census 2020 TigerLine VTD Layer as Validated by the LA Legislature.zip (08-23-2021)) via [Louisiana Legislature Redistricting Website](https://redist.legis.la.gov/default_ShapeFiles2020)

Council Districts via [City of New Orleans GIS Department](https://portal-nolagis.opendata.arcgis.com/datasets/22961c88e66e405e8f020c4fab81854e/explore?location=29.971537%2C-90.071375%2C12.45). 

## Notes on Field Names (adapted from VEST):
Columns reporting votes generally follow the pattern: 
One example is:
G16PREDCLI
The first character is P for a primary and R for a runoff.
Characters 2 and 3 are the year of the election.*
Characters 4-6 represent the office type (see list below).
Character 7 represents the party of the candidate.
Characters 8-10 are the first three letters of the candidate's last name.

*To fit within the GIS 10 character limit for field names, the naming convention is slightly different for the State Legislature and US House of Representatives. All fields are listed below with definitions.

Office Codes Used:
CM - Councilmember

District Codes Used:
D[A/B/C/D/E] - District (Not At-Large)
DV# - Division 1 or Division 2 (At-Large Districts)

Party Codes Used:
D - Democrat
I - Independent
L - Libertarian
N - No Party


## Fields:
Field Name Description                                                                  
UNIQUE_ID  Unique ID for each precinct, corresponds to VTDST20 except to reflect splits  
COUNTYFP   County FIP identifier                                                         
COUN_DIST  Council District 
PCMDADGIA  Joseph "Joe" Giarrusso III (DEM)-:-Councilmember -- District A-:-Primary      
PCMDADMUR  Robert "Bob" Murrell (DEM)-:-Councilmember -- District A-:-Primary            
PCMDALMIS  Amy Misko (LBT)-:-Councilmember -- District A-:-Primary                       
PCMDBDBAN  Jay H. Banks (DEM)-:-Councilmember -- District B-:-Primary                    
PCMDBDHAR  Lesli Harris (DEM)-:-Councilmember -- District B-:-Primary                    
PCMDBDZAP  Rella Zapletal (DEM)-:-Councilmember -- District B-:-Primary                  
PCMDBIREE  Rosalind "Roz" Reed-Thibodeaux (IND)-:-Councilmember -- District B-:-Primary  
PCMDCDBRI  Stephanie Bridges (DEM)-:-Councilmember -- District C-:-Primary               
PCMDCDKIN  Freddie King III (DEM)-:-Councilmember -- District C-:-Primary                
PCMDCDKNO  Alonzo Knox (DEM)-:-Councilmember -- District C-:-Primary                     
PCMDCDMOS  Stephen Mosgrove (DEM)-:-Councilmember -- District C-:-Primary                
PCMDCDPER  "Frank" Perez (DEM)-:-Councilmember -- District C-:-Primary                   
PCMDCDWAI  Barbara Waiters (DEM)-:-Councilmember -- District C-:-Primary                 
PCMDCNMIL  Vincent Milligan, Jr. (NOPTY)-:-Councilmember -- District C-:-Primary         
PCMDDDBUR  Chantrisse Burnett (DEM)-:-Councilmember -- District D-:-Primary              
PCMDDDCLE  Morgan Clevenger (DEM)-:-Councilmember -- District D-:-Primary                
PCMDDDGLO  Troy Glover (DEM)-:-Councilmember -- District D-:-Primary                     
PCMDDDGRE  Eugene Green (DEM)-:-Councilmember -- District D-:-Primary                    
PCMDDDGRI  Kevin Griffin-Clark (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDDLAW  Mark "Johari" Lawes (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDDMOO  Mariah Moore (DEM)-:-Councilmember -- District D-:-Primary                    
PCMDDDMUR  Robert "Bob" Murray (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDDPAR  Keith "KP" Parker (DEM)-:-Councilmember -- District D-:-Primary               
PCMDDDSAM  Timolynn "Tim" Sams (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDDVIN  Dulaine Troy Vining (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDDYOU  Kourtney Youngblood (DEM)-:-Councilmember -- District D-:-Primary             
PCMDDNDOB  Anthony Doby (NOPTY)-:-Councilmember -- District D-:-Primary                  
PCMDDRARD  Chelsea Ardoin (REP)-:-Councilmember -- District D-:-Primary                  
PCMDEDBAG  John Bagneris (DEM)-:-Councilmember -- District E-:-Primary                   
PCMDEDCOP  Michon Copelin (DEM)-:-Councilmember -- District E-:-Primary                  
PCMDEDJOH  Vanessa "Gueringer" Johnson (DEM)-:-Councilmember -- District E-:-Primary     
PCMDEDMIL  Aaron Miller (DEM)-:-Councilmember -- District E-:-Primary                    
PCMDEDNGU  Cyndi Nguyen (DEM)-:-Councilmember -- District E-:-Primary                    
PCMDEDTHO  Oliver M. Thomas (DEM)-:-Councilmember -- District E-:-Primary                
PCMDV1DCUT Kenneth Cutno (DEM)-:-Councilmember at Large -- Division 1-:-Primary          
PCMDV1DMOR Helena Moreno (DEM)-:-Councilmember at Large -- Division 1-:-Primary          
PCMDV2DBRO Jared Brossett (DEM)-:-Councilmember at Large -- Division 2-:-Primary         
PCMDV2DMOR Jean-Paul "JP" Morrell (DEM)-:-Councilmember at Large -- Division 2-:-Primary 
PCMDV2DPAL Kristin Gisleson Palmer (DEM)-:-Councilmember at Large -- Division 2-:-Primary
PCMDV2GEVE "Bart" Everson (GRN)-:-Councilmember at Large -- Division 2-:-Primary         
RCMDBDBAN  Jay H. Banks (DEM)-:-Councilmember -- District B-:-Runoff                     
RCMDBDHAR  Lesli Harris (DEM)-:-Councilmember -- District B-:-Runoff                     
RCMDCDBRI  Stephanie Bridges (DEM)-:-Councilmember -- District C-:-Runoff                
RCMDCDKIN  Freddie King III (DEM)-:-Councilmember -- District C-:-Runoff                 
RCMDDDGLO  Troy Glover (DEM)-:-Councilmember -- District D-:-Runoff                      
RCMDDDGRE  Eugene Green (DEM)-:-Councilmember -- District D-:-Runoff                     
RCMDEDNGU  Cyndi Nguyen (DEM)-:-Councilmember -- District E-:-Runoff                     
RCMDEDTHO  Oliver M. Thomas (DEM)-:-Councilmember -- District E-:-Runoff                 
                                                             

## Processing Steps
A handful of election precincts are split by precinct. Because the proportion of at-large council votes for each portion of these precincts is not known, these results are split into two files, "LA_Orleans_Parish_Council_21_At_Large" and "LA_Orleans_Parish_Council_21_Districts". District assignments for precincts implied by election results were checked against actual council districts, all 5 districts differ by less than 1km^2 in area, with main differences resulting from water boundaries.

There is a version of the file without any splits, "LA_Orleans_Parish_Council_21_Combined",in which results from a particular precinct may contain votes for more than one districted councilmember. As such, this file does not contain the "COUN_DIST" column.  

Absentee and early votes were allocated to precincts based on precinct share of day-of election results. Election result totals were checked before and after processing to make sure no votes were lost in processing. 

The 2020 TIGER Boundaries were selected as they appeared to match the election results and were verified in August, 2021. Louisiana's 2022 precinct boundaries are unchanged from their 2021 boundaries.

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

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