home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e5a450d5-e8a5-4b09-9cc4-b948bf9d9806

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
e5a450d5-e8a5-4b09-9cc4-b948bf9d9806 Q1 401104718 HB STRATEGIES 56663 ALAMEDA COUNTY TRANSPORTATION COMMISSION 2024 first_quarter 2024-04-18T15:24:48-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e5a450d5-e8a5-4b09-9cc4-b948bf9d9806/", "filing_uuid": "e5a450d5-e8a5-4b09-9cc4-b948bf9d9806", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2024, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e5a450d5-e8a5-4b09-9cc4-b948bf9d9806/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Amy Blunt", "dt_posted": "2024-04-18T15:24:48-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "733 10th Street", "registrant_address_2": "Suite 900", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 401104718, "url": "https://lda.senate.gov/api/v1/registrants/401104718/", "house_registrant_id": null, "name": "HB STRATEGIES", "description": "Government Affairs Consulting", "address_1": "733 10th St. NW,", "address_2": "Suite 900", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM FOX", "contact_telephone": "+1 202-899-3801", "dt_updated": "2026-01-23T12:32:15.996997-05:00"}, "client": {"id": 56663, "url": "https://lda.senate.gov/api/v1/clients/56663/", "client_id": 56663, "name": "ALAMEDA COUNTY TRANSPORTATION COMMISSION", "general_description": "County Transportation and Infrastructure Commission", "client_government_entity": null, "client_self_select": false, "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": "2023-07-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Support emergency funding for local governments and transit agencies. Support funding for RAISE and RAISE grant applications. Support funding for CRISI. Support funding for Safe Streets and Roads for All grant applications. Support funding for Reconnecting Communities and Neighborhoods Program grant applications. Support Community Project funding/Congressionally Directed Spending requests.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145286, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "THEODORE", "last_name": "ASSINI", "suffix": null, "suffix_display": null}, "covered_position": "Senator Baldwin, Legislative Assistant, Congressman Panetta, Legislative Assistant, Energy and Natural Resources Committee, Majority Staff", "new": false}, {"lobbyist": {"id": 67394, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "House Transportation Committee, Legislative Assistant", "new": false}, {"lobbyist": {"id": 70784, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "LAUSTEN", "suffix": null, "suffix_display": null}, "covered_position": "Congressman Lipinski, Chief of Staff, Congressman Acevedo-Villa, Chief of Staff, Congressman McKinney, Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Support RAISE grant applications. Support CRISI grant applications Support Safe Streets and Roads for All Grant applications. Support Reconnecting Communities and Neighborhoods program grant application", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145286, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "THEODORE", "last_name": "ASSINI", "suffix": null, "suffix_display": null}, "covered_position": "Senator Baldwin, Legislative Assistant, Congressman Panetta, Legislative Assistant, Energy and Natural Resources Committe, Majority Staff", "new": false}, {"lobbyist": {"id": 67394, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": null, "last_name": "FOX", "suffix": null, "suffix_display": null}, "covered_position": "House Transporation Committee, Legislative Assistant", "new": false}, {"lobbyist": {"id": 70784, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "LAUSTEN", "suffix": null, "suffix_display": null}, "covered_position": "Congressman Lipinski, Chief of Staff, Congressman Acevedo-Villa, Chief of Staff, Congressman McKinney, Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Support emergency support for local governments and transit agencies.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 145286, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "THEODORE", "last_name": "ASSINI", "suffix": null, "suffix_display": null}, "covered_position": "Senator Baldwin, Legislative Assistant, Congressman Panetta, Legislative Assistant, Energy and Natural Resources Committee, Majority Staff", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 29.135ms