home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e4efc512-e863-42ce-a29f-0cb16c8a1a9f

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
e4efc512-e863-42ce-a29f-0cb16c8a1a9f Q2 24338 MCDERMOTT WILL & SCHULTE LLP 131876 DAIKIN COMFORT TECHNOLOGIES 2018 second_quarter 2018-07-05T10:43:57.067000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e4efc512-e863-42ce-a29f-0cb16c8a1a9f/", "filing_uuid": "e4efc512-e863-42ce-a29f-0cb16c8a1a9f", "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/e4efc512-e863-42ce-a29f-0cb16c8a1a9f/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "David Ransom", "dt_posted": "2018-07-05T10:43:57.067000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "500 North Capitol Street, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 24338, "url": "https://lda.senate.gov/api/v1/registrants/24338/", "house_registrant_id": 31445, "name": "MCDERMOTT WILL & SCHULTE LLP", "description": "Law Firm", "address_1": "500 North Capitol 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": "ERIC ZIMMERMAN", "contact_telephone": "+1 202-204-1457", "dt_updated": "2026-01-14T11:28:33.077433-05:00"}, "client": {"id": 131876, "url": "https://lda.senate.gov/api/v1/clients/131876/", "client_id": 1005216, "name": "DAIKIN COMFORT TECHNOLOGIES", "general_description": "U.S. manufacturer of residential and commercial air conditioning units", "client_government_entity": false, "client_self_select": false, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-08-12"}, "lobbying_activities": [{"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "Monitor and advocate on EPA regulations affecting refrigerants and DOE regulations on energy efficiency and legislation affecting energy efficiency. Also advocate for energy legislation, including S. 385 and H.R. 1443.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 40292, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": "M", "last_name": "RYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46579, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "DUANE", "last_name": "RANSOM", "suffix": null, "suffix_display": null}, "covered_position": "2007-08: Sr Communications and Policy Advisor, House Majority Leader Steny Hoyer; 2002-06: Communications Director, House Democratic Whip Steny Hoyer; 1999-2001: Communications Director, House Committee on Administration (Steny Hoyer, Ranking Member)", "new": false}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Monitor and advocate on EPA regulations affecting refrigerants and DOE regulations on energy efficiency and legislation affecting energy efficiency. Also advocate for energy legislation, including S. 385 and H.R. 1443.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46579, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "DUANE", "last_name": "RANSOM", "suffix": null, "suffix_display": null}, "covered_position": "2007-08: Sr Communications and Policy Advisor, House Majority Leader Steny Hoyer; 2002-06: Communications Director, House Democratic Whip Steny Hoyer; 1999-2001: Communications Director, House Committee on Administration (Steny Hoyer, Ranking Member)", "new": false}, {"lobbyist": {"id": 40292, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": "M", "last_name": "RYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.761ms