home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 604f41b7-fa3b-4e5c-a970-e3098a3f0e51

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
604f41b7-fa3b-4e5c-a970-e3098a3f0e51 Q1 38962 AMEREN SERVICES 147112 AMEREN SERVICES 2016 first_quarter 2016-04-15T17:30:11.213000-04:00 500000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/604f41b7-fa3b-4e5c-a970-e3098a3f0e51/", "filing_uuid": "604f41b7-fa3b-4e5c-a970-e3098a3f0e51", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2016, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/604f41b7-fa3b-4e5c-a970-e3098a3f0e51/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "500000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Shaun Garrison", "dt_posted": "2016-04-15T17:30:11.213000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1331 PENNSYLVANIA AVE, NW", "registrant_address_2": "SUITE 550S", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 38962, "url": "https://lda.senate.gov/api/v1/registrants/38962/", "house_registrant_id": 30710, "name": "AMEREN SERVICES", "description": null, "address_1": "1331 PENNSYLVANIA AVE, NW", "address_2": "SUITE 550S", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TRACY WALTON", "contact_telephone": "+1 618-210-5919", "dt_updated": "2026-01-28T10:30:32.405402-05:00"}, "client": {"id": 147112, "url": "https://lda.senate.gov/api/v1/clients/147112/", "client_id": 12, "name": "AMEREN SERVICES", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-08"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 4016, amending the Internal Revenue Code of 1986 to extend the limitation on the carryover of excess corporate charitable contributions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44266, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAUN", "nickname": null, "middle_name": "F", "last_name": "GARRISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 92, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOSEPH", "nickname": null, "middle_name": "M", "last_name": "POWER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "H.R. 1734, Improving Coal Combustion Residuals Regulation Act of 2015, to provide for implementation of minimum federal CCR requirements through a state-based permit program\nS. 1803 Improving Coal Combustion Residuals Regulation Act of 2015, to provide for implementation of minimum federal CCR requirements through a state-based permit program.\nSO2 attainment/non-attainment designation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44266, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAUN", "nickname": null, "middle_name": "F", "last_name": "GARRISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 92, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOSEPH", "nickname": null, "middle_name": "M", "last_name": "POWER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "S. 2012, the Energy Policy Modernization Act of 2015\nAmendments in areas related to grid security, grid reliability, transmission, energy storage, energy supply, environment and renewables:\nMurkowski (2963), Cassidy (2976), Inhofe (2981), Reid (2993), Barrasso (3017), Barrasso (3030), Rounds (3036), 3038 (Hoeven), Coats (3039), Manchin (3044), Flake (3048), Flake (3051), Blunt (3058), Boozman (3059), Boozman (3060), Capito (3061), Capito (3062), Blunt (3074), Johnson (3076), Markey (3101), Franken (3110), Franken (3111), Franken (3113), Franken (3115), 3120 (King-Reid), Heinrich (3122), Heinrich (3123), Thune (3141)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44266, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAUN", "nickname": null, "middle_name": "F", "last_name": "GARRISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 92, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOSEPH", "nickname": null, "middle_name": "M", "last_name": "POWER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Discussion draft of legislation to facilitate the deployment of communications infrastructure, provisions regarding regulation of pole attachments", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44266, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAUN", "nickname": null, "middle_name": "F", "last_name": "GARRISON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 92, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOSEPH", "nickname": null, "middle_name": "M", "last_name": "POWER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 6.351ms