GitHub - palewire/sopr-contribs: Scripts for processing and analyzing federal lobbyist disclosure data reporting contributions to political campaigns

This repository has been archived by the owner on Dec 29, 2020. It is now read-only.

palewire / sopr-contribs Public archive

Notifications You must be signed in to change notification settings
Fork 0
Star 3

Scripts for processing and analyzing federal lobbyist disclosure data reporting contributions to political campaigns

www.palewire.com

3 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
README		README
fetch.py		fetch.py

Repository files navigation

A script that fetches, parses and archives the XML data dumps of lobbyist's
political contributions published by The Senate Office of Public Records.
 
Zips files containing the XML are:
1. Downloaded and unzipped.
2. Parsed out into flat text files and stored in a timestamped folder structure.
3. Imported to a SQLite database.
 
The ultimate goal is for a series of SQL statements to scrub and cut the data
to account for flaws in the reporting system first uncovered by Bill Allison
and Anupama Narayanswamy of The Sunlight Foundation.