home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bb9c4ea0-e0fe-4b48-96dd-de05d2a4d858

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
bb9c4ea0-e0fe-4b48-96dd-de05d2a4d858 Q1 400534596 THORN RUN PARTNERS 192644 DEL NORTE COUNTY, CA 2019 first_quarter 2019-04-17T15:42:50.333000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bb9c4ea0-e0fe-4b48-96dd-de05d2a4d858/", "filing_uuid": "bb9c4ea0-e0fe-4b48-96dd-de05d2a4d858", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2019, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bb9c4ea0-e0fe-4b48-96dd-de05d2a4d858/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Elizabeth Ray", "dt_posted": "2019-04-17T15:42:50.333000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "100 M Street, SE", "registrant_address_2": "Suite 750", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 400534596, "url": "https://lda.senate.gov/api/v1/registrants/400534596/", "house_registrant_id": 41161, "name": "THORN RUN PARTNERS", "description": "Government Affairs Firm", "address_1": "100 M Street, SE", "address_2": "Suite 750", "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": "W. CHRISTOPHER LAMOND", "contact_telephone": "+1 202-688-0225", "dt_updated": "2026-01-29T09:03:11.805178-05:00"}, "client": {"id": 192644, "url": "https://lda.senate.gov/api/v1/clients/192644/", "client_id": 1522, "name": "DEL NORTE COUNTY, CA", "general_description": "Local government. County.", "client_government_entity": true, "client_self_select": null, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-02-01"}, "lobbying_activities": [{"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Municipality related issues and initiatives, including, Secure Rural Schools reauthorization, Essential Air Service program, Payments in Lieu of Taxes, forest management, freight, highway, Last Chance Grade, Airport Improvement Program, opioid related issues; FY 2020 appropriations;\nH.R. 530 Accelerating Broadband Development by Empowering Local Communities Act of 2019", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69887, "prefix": null, "prefix_display": null, "first_name": "GREGORY", "nickname": null, "middle_name": null, "last_name": "BURNS", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, Congresswoman Darlene Hooley", "new": false}, {"lobbyist": {"id": 68381, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "SCOTT", "last_name": "HARDWICK", "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 7.204ms