Skip to content

From Senate lobbying disclosures, merge, filter and export data to CSV

License

Notifications You must be signed in to change notification settings

shmcminn/analyze-senate-lobbying-disclosures

Repository files navigation

Analyzing Senate lobbying disclosures

The U.S. Senate posts lobbyist disclosure spending data in XML format, which is due quarterly, here. It includes lobbying records in both the House of Representatives and Senate.

Those Senate files are broken up chronologically, with (I believe) 1,000 entries per file.

This Python script looks for a folder of those XML files in your local directory, combines them, filters them on categories such as year/filing period/lobbying topic, then exports the results as a CSV file.

This was originally built for CQ Roll Call reporting on banking and fiancial institutions lobbying data, though it has broader uses for news reporting. I'd love to see what you do with this - feel free to shoot me a note if you have questions or end up doing something cool with the script!

About

From Senate lobbying disclosures, merge, filter and export data to CSV

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages