Comprehensive Pennsylvania Results by Precinct, 1992-2008

[DavidNYC]

Because I've received more than one request for the data, I've uploaded the PA file to a hosting service. It's a 40 MB ZIP file which contains precinct-level results for the following PA races from 1992 through 2008, including both primaries and generals:

• President of the United States
• United States Senator
• Governor
• Lieutenant Governor
• Attorney General
• Auditor General
• State Treasurer
• Justice of the Supreme Court
• Judge of the Superior Court
• Judge of the Commonwealth Court
• Representative in Congress
• Senator in the General Assembly
• Representative in the General Assembly

The archive also contains voter registration data. I obtained it on a CD from the PA Dept. of State for $10 a few months ago. (The CD isn't mentioned on their website, but someone told me about it... and it turned out to be legit.) There's no reason to order the CD yourself, since its entire contents are available in the ZIP file.

One word of warning: I can tell you that there are occasional errors and missing data in these files. What those problems are, of course, remains to be discovered. But the data is still extremely useful.

Anyhow, without further ado, here is the link:

http://www.mediafire.com/?kngm1mgntmw

Let me know if you have any problems downloading it. Enjoy!

[DavidNYC]

Ok, I couldn't resist - I downloaded it...only to later realize that the results are a jumbled mess. 

How so? There are definitely some errors, but the files are certainly usable.

[DavidNYC]

Rowan: Yep, one and the same.

Phil: Even though they are .txt files, you'll need to open them with Excel to make any sense of them. They are comma separated, which means Excel will try to put every data item between commas in its own cell. Also, due to their large size, Excel 2003 will probably truncate the files. Excel 2007 can handle them without a problem.

[DavidNYC]

Hahah, you're too kind, RBH. I do think that these PA files are pretty amazing, though. You just slap an Excel PivotTable on `em and all the work is done for you automagically.