pa-voter-data-pipeline

Data processing pipeline for PA SURE statewide voter registration data. The current focus is on preparing the data for ingestion for other systems (such as SQL databases); further work to enrich the data is being considered once the initial work is complete.

NOTE: You will have to acquire the actual data yourself; state law prohibits its distribution (4 Pa. Code sections 183.13 (g) & 183.14 (k)).

Full Voters Export List Full export of all voters in the county containing the following fields:

• Voter ID number
• name
• sex
• date of birth
• date registered
• status (i.e., active or inactive)
• date status
• last changed
• party residential address
• mailing address
• polling place
• date last voted
• all districts in which the voter votes (i.e., congressional, legislative, school district, etc.)
• voter history
• date the voter’s record was last changed.

File Layouts

Voter records are stored in the files that begin the following format

    [COUNTY NAME] FVE YYYYMMDD.txt

The files are Tab-delimited, and each file has 153 fields with the following layout:

• 1: ID
• 2: Prefix Name
• 3: Last Name
• 4: First Name
• 5: Middle Name (Initial)
• 6: Suffix Name
• 7: Sex
• 8: Birthdate
• 9: Initial Registration Date
• 10: Status (A: Active, I: Inactive)
• 11: Date Last Changed (Party?)
• 12: Party (see reference file?)
• 13: Physical Street Number
• 14: Physical Street Direction?
• 15: Physical Street Name
• 16:
• 17: Physical City
• 18: Physical State
• 19: Physical Zipcode
• 20:
• 21:
• 22:
• 23:
• 24:
• 25: Date Last Voted
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• 53
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• 97
• 98
• 99
• 100
• 101
• 102
• 103
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• 145
• 146
• 147
• 148
• 149
• 150
• 151: Phone Number
• 152: County Name
• 153: