home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dab70eae-86a9-4687-b140-e75bb4e183b4

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
dab70eae-86a9-4687-b140-e75bb4e183b4 Q2 19822 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS 126404 INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS 2017 second_quarter 2017-07-20T14:58:44.910000-04:00 76993.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dab70eae-86a9-4687-b140-e75bb4e183b4/", "filing_uuid": "dab70eae-86a9-4687-b140-e75bb4e183b4", "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/dab70eae-86a9-4687-b140-e75bb4e183b4/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "76993.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Austin Keyser", "dt_posted": "2017-07-20T14:58:44.910000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "900 7TH STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 19822, "url": "https://lda.senate.gov/api/v1/registrants/19822/", "house_registrant_id": 31118, "name": "INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS", "description": "Labor Union", "address_1": "900 7TH STREET, NW", "address_2": null, "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": "DEAN WARSH", "contact_telephone": "+1 202-728-6046", "dt_updated": "2026-01-27T11:49:36.849245-05:00"}, "client": {"id": 126404, "url": "https://lda.senate.gov/api/v1/clients/126404/", "client_id": 12, "name": "INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS", "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": "2020-01-01"}, "lobbying_activities": [{"general_issue_code": "UTI", "general_issue_code_display": "Utilities", "description": "The IBEW lobbied republican members of congress in regard to HR 3043; the Hydro-power Policy Modernization Act of 2017. The intent of this legislation was to streamline licensing of hydro-power projects making them comparable to those of nuclear and wind. It would help to modernize federal policies by designating FERC as the lead agency for hydro-power projects to help promote this affordable-renewable energy source.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53249, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "M", "last_name": "WALSH", "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": "DEF", "general_issue_code_display": "Defense", "description": "The IBEW lobbied members of congress in coalition with other unions and members of the travel industry for passage of HR 2036. This bill was introduced by Rep. Derek Kilmer and would prohibit the Department of Defense from continual implementation of a revised per diem reimbursement schedule for its civilian and military employees based upon duration of assignment. The bill nullifies the DOD policy implemented on Nov. 1, 2014, regarding reductions in per diem allowances based on the duration of temporary duty assignments or civilian travel. The bill amends the National Defense Authorization Act for Fiscal Year 2017 to repeal the modifications to the flat rate per diem requirements for DOD military and civilian personnel on long-term temporary duty assignments so that they revert to a fairer system of reimbursement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53249, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "M", "last_name": "WALSH", "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

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