home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e2217d75-912a-48c8-af6d-e4f2c8d335b0

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 registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
e2217d75-912a-48c8-af6d-e4f2c8d335b0 Q2 401105291 CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES 203504 CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES 2022 second_quarter 2022-07-09T15:15:28-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e2217d75-912a-48c8-af6d-e4f2c8d335b0/", "filing_uuid": "e2217d75-912a-48c8-af6d-e4f2c8d335b0", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e2217d75-912a-48c8-af6d-e4f2c8d335b0/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Ted Heckmann", "dt_posted": "2022-07-09T15:15:28-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "P.O. Box 2301", "registrant_address_2": "103-1080", "registrant_different_address": false, "registrant_city": "Cincinnati", "registrant_state": "OH", "registrant_zip": "45201", "registrant": {"id": 401105291, "url": "https://lda.senate.gov/api/v1/registrants/401105291/", "house_registrant_id": null, "name": "CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES", "description": "Telecommunications and IT Services and Hardware", "address_1": "P.O. Box 2301", "address_2": null, "address_3": null, "address_4": null, "city": "Cincinnati", "state": "OH", "state_display": "Ohio", "zip": "45201", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TED HECKMANN", "contact_telephone": "+1 513-608-7624", "dt_updated": "2026-01-13T09:43:17.015405-05:00"}, "client": {"id": 203504, "url": "https://lda.senate.gov/api/v1/clients/203504/", "client_id": 12, "name": "CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "OH", "state_display": "Ohio", "country": "US", "country_display": "United States of America", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-06-01"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Infrastructure Investment and Jobs Act (IIJA) - Broadband Implementation (NTIA Programs & Commerce Reconnect),H.R. 4275, the Ensuring Phone and Internet Access for SNAP Recipients Act of 2021,H.R. 4990, the ITS Codification Act,H.R. 5400, the Preventing Disruptions to Universal Service Funds Act,H.R. 5486, the SMART Act, H.R. 7132, the Safe Connections Act of 2022, H.R. 7624, the Spectrum Innovation Act of 2022,H.R. 7783, the Extending Americas Spectrum Auction Leadership Act of 2022, S2427 FAIR Contributions Act, S3692 NET Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70735, "prefix": null, "prefix_display": null, "first_name": "TED", "nickname": null, "middle_name": null, "last_name": "HECKMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} OH US   OH OH US US   0 0        

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 212.648ms