home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cf2d07fa-8a30-46eb-bc70-d6b0ebfcf6d8

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
cf2d07fa-8a30-46eb-bc70-d6b0ebfcf6d8 Q2 401104802 WESTMORELAND160, LLC 202760 BENCHMARK ELECTRONICS, INC. 2018 second_quarter 2018-07-05T08:27:18.523000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cf2d07fa-8a30-46eb-bc70-d6b0ebfcf6d8/", "filing_uuid": "cf2d07fa-8a30-46eb-bc70-d6b0ebfcf6d8", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cf2d07fa-8a30-46eb-bc70-d6b0ebfcf6d8/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "William Rice", "dt_posted": "2018-07-05T08:27:18.523000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "PO Box 396", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "The Plains", "registrant_state": "VA", "registrant_zip": "20198", "registrant": {"id": 401104802, "url": "https://lda.senate.gov/api/v1/registrants/401104802/", "house_registrant_id": null, "name": "WESTMORELAND160, LLC", "description": "Consulting", "address_1": "PO Box 396", "address_2": null, "address_3": null, "address_4": null, "city": "The Plains", "state": "VA", "state_display": "Virginia", "zip": "20198", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "WILLIAM RICE", "contact_telephone": "+1 703-298-1843", "dt_updated": "2026-01-15T13:43:43.949065-05:00"}, "client": {"id": 202760, "url": "https://lda.senate.gov/api/v1/clients/202760/", "client_id": 12, "name": "BENCHMARK ELECTRONICS, INC.", "general_description": "Electronics design and precision manufacturing", "client_government_entity": false, "client_self_select": null, "state": "AZ", "state_display": "Arizona", "country": "US", "country_display": "United States of America", "ppb_state": "AZ", "ppb_state_display": "Arizona", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2018-02-22"}, "lobbying_activities": [{"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Mobile Video Surveillance Systems\nHouse Homeland Security Appropriations for the fiscal year ending September 30, 2019, US Customs and Border Protection, Procurement\nSenate Homeland Security Appropriations for the fiscal year ending September 30, 2019, US Customs and Border Protection, Procurement\nHouse Homeland Security Authorizations for the fiscal year ending September 30, 2019, US Customs and Border Protection, Procurement\nSenate Homeland Security Authorizations for the fiscal year ending September 30, 2019, US Customs and Border Protection, Procurement\nSecuring America's Future Act (H.R. 4760)\nH.R. 1625 - Consolidated Appropriations Act, 2018 as it pertains to US Customs and Border Protection, Procurement", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 140914, "prefix": "mr", "prefix_display": "MR.", "first_name": "WILLIAM", "nickname": null, "middle_name": "THOMAS", "last_name": "RICE", "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
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.198ms