home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4852e36c-e465-4e29-a2ca-4f4e29b9631d

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
4852e36c-e465-4e29-a2ca-4f4e29b9631d Q2 82055 ERIS GROUP 171492 PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA 2017 second_quarter 2017-07-17T14:07:16.717000-04:00 22500.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4852e36c-e465-4e29-a2ca-4f4e29b9631d/", "filing_uuid": "4852e36c-e465-4e29-a2ca-4f4e29b9631d", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4852e36c-e465-4e29-a2ca-4f4e29b9631d/print/", "filing_document_content_type": "text/html", "income": "22500.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kenneth E Swab", "dt_posted": "2017-07-17T14:07:16.717000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "439 New Jersey Avenue, SE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 82055, "url": "https://lda.senate.gov/api/v1/registrants/82055/", "house_registrant_id": 36338, "name": "ERIS GROUP", "description": "Private consulting firm.", "address_1": "439 New Jersey Avenue, SE", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "KENNETH SWAB", "contact_telephone": "+1 202-546-1761", "dt_updated": "2026-01-20T16:18:44.919063-05:00"}, "client": {"id": 171492, "url": "https://lda.senate.gov/api/v1/clients/171492/", "client_id": 1004924, "name": "PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA", "general_description": "Trade association of property casualty insurers.", "client_government_entity": false, "client_self_select": null, "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": "2017-03-21"}, "lobbying_activities": [{"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "Issues related to the reauthorization and implementation of the National Flood Insurance Program.\nH.R.1422, Flood Insurance Market Parity and Modernization Act, all provisions.\nH.R.1558, Repeatedly Flooded Communities Preparation Act, all provisions.\nH.R.2246, Taxpayer Exposure Mitigation Act of 2017, all provisions.\nH.R.2565, To require the use of replacement cost value in determining the premium rates for flood insurance coverage under the National Flood Insurance Act, all provisions.\nH.R.2868, National Flood Insurance Program Policyholder Protection Act of 2017, all provisions.\nH.R.2874, 21st Century Flood Reform Act, all provisions.\nH.R.2875, National Flood Insurance Program Administrative Reform Act of 2017, all provisions.\nS.563, Flood Insurance Market Parity and Modernization Act, all provisions.\nS.1313, Flood Insurance Affordability and Sustainability Act of 2017, all provisions.\nS.1368, Sustainable, Affordable, Fair, and Efficient (SAFE) National Flood Insurance Program Reauthorization Act of 2017, all provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 63833, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 18713, "prefix": null, "prefix_display": null, "first_name": "DOYLE", "nickname": null, "middle_name": null, "last_name": "BARTLETT", "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

  • 1 row from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.402ms