Commonwealth of Pennsylvania Department of State Bureau of Commissions, Elections and Legislation Precinct Election Returns Electronic Data File Transmittal and Instructions bcel@state.pa.us www.dos.state.pa.us Data Extracted: March 13, 2020 Requested Year 2019 Requested Election: Primary Record Count: 145,644 The text data file, prcres.txt, is an ASCII text, comma delimited file. The file can also be easily imported into most PC database and spreadsheet applications. The field descriptions, maximum length, and data type are listed below in the order in which they appear (from left to right) in the file. Field Description Length Data Type ----------------------------------------------------------------- Election Year 4 Numeric Election Type (P = Primary) 1 Character County Code * 2 Numeric Precinct Code 7 Numeric Candidate Office Rank 2 Numeric Candidate District 3 Numeric Candidate Party Rank 2 Numeric Candidate Ballot Position 2 Numeric Candidate Office Code * 3 Character Candidate Party Code* 3 Character Candidate Number 7 Numeric Candidate Last Name 50 Character Candidate First Name 50 Character Candidate Middle Name 50 Character Candidate Suffix 10 Character Vote Total 7 Numeric Yes Vote Total 7 Numeric No Vote Total 7 Numeric U.S. Congressional District 2 Numeric State Senatorial District 2 Numeric State House District 3 Numeric Municipality Type Code * 1 Numeric Municipality Name 23 Character Municipality Breakdown Code 1 1 Character Municipality Breakdown Name 1 21 Character Municipality Breakdown Code 2 1 Character Municipality Breakdown Name 2 21 Character Bi-County Code ** 2 Numeric MCD Code 3 Numeric FIPS Code 3 Numeric VTD code 4 Numeric BallotQuestion 500 Character RecordType 15 Character Previous Precinct Code 7 Numeric Previous U.S. Congressional District 2 Numeric Previous State Senatorial District 2 Numeric Previous State House District 3 Numeric -------------------------------------------------------------- * See tables below. ** If a municipality is located in more than 1 county (i.e. it crosses county lines), this is the code of the other county. Election Type Table ------------------- P Primary G General M Municipal S Special County Code Table ----------------- 01 Adams 02 Allegheny 03 Armstrong 04 Beaver 05 Bedford 06 Berks 07 Blair 08 Bradford 09 Bucks 10 Butler 11 Cambria 12 Cameron 13 Carbon 14 Centre 15 Chester 16 Clarion 17 Clearfield 18 Clinton 19 Columbia 20 Crawford 21 Cumberland 22 Dauphin 23 Delaware 24 Elk 25 Erie 26 Fayette 27 Forest 28 Franklin 29 Fulton 30 Greene 31 Huntingdon 32 Indiana 33 Jefferson 34 Juniata 35 Lackawanna 36 Lancaster 37 Lawrence 38 Lebanon 39 Lehigh 40 Luzerne 41 Lycoming 42 McKean 43 Mercer 44 Mifflin 45 Monroe 46 Montgomery 47 Montour 48 Northampton 49 Northumberland 50 Perry 51 Philadelphia 52 Pike 53 Potter 54 Schuylkill 55 Snyder 56 Somerset 57 Sullivan 58 Susquehanna 59 Tioga 60 Union 61 Venango 62 Warren 63 Washington 64 Wayne 65 Westmoreland 66 Wyoming 67 York Municipality Type Codes ----------------------- 2 City 4 Township 5 Town 6 Borough Municipality Breakdown Codes ---------------------------- D District W Ward P Precinct X Other Office Code Table ------------------------------------------------------------ 1 USP President Of The United States 2 USS United States Senator 3 USC Representative In Congress 4 STS Senator In The General Assembly 5 STH Representative In The General Assembly 6 ATT Attorney General 7 AUD Auditor General 8 TRE State Treasurer 9 DED Delegate To Democratic National Convention 10 DER Delegate To Republican National Convention 11 ADD Alt Delegate To Democratic National Convention 12 ADR Alt Delegate To Republican National Convention Party Code Table -------------------------- D/R Democratic / Republican DEM Democratic REP Republican