home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dfbb2e40-31fa-4ac5-b76e-d7a9b16cc4f8

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
dfbb2e40-31fa-4ac5-b76e-d7a9b16cc4f8 Q3 400794388 SCONSET STRATEGIES, LLC 195349 AIR CONDITIONING, HEATING AND REFRIGERATION INSTITUTE (AHRI) 2024 third_quarter 2024-10-21T17:36:57-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dfbb2e40-31fa-4ac5-b76e-d7a9b16cc4f8/", "filing_uuid": "dfbb2e40-31fa-4ac5-b76e-d7a9b16cc4f8", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2024, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/dfbb2e40-31fa-4ac5-b76e-d7a9b16cc4f8/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Adam S. Olsen", "dt_posted": "2024-10-21T17:36:57-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "100 M Street, S.E.", "registrant_address_2": "Suite 600", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 400794388, "url": "https://lda.senate.gov/api/v1/registrants/400794388/", "house_registrant_id": 41783, "name": "SCONSET STRATEGIES, LLC", "description": "Federal Government Relations", "address_1": "100 M Street, S.E.", "address_2": "Suite 600", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ADAM S. OLSEN", "contact_telephone": "+1 202-400-2543", "dt_updated": "2026-03-03T10:48:45.425364-05:00"}, "client": {"id": 195349, "url": "https://lda.senate.gov/api/v1/clients/195349/", "client_id": 63, "name": "AIR CONDITIONING, HEATING AND REFRIGERATION INSTITUTE (AHRI)", "general_description": "Trade Association for the Air Conditioning, Heating and Refrigeration Industry", "client_government_entity": false, "client_self_select": false, "state": "VA", "state_display": "Virginia", "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": "2012-08-01"}, "lobbying_activities": [{"general_issue_code": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Consideration of Steel and Aluminum relating to the Section 232 review of steel/aluminum and the imposition of tariffs or quotas on steel/aluminum. Consideration of tariffs for imports from China under Section 301. Miscellaneous Tariff Bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54920, "prefix": null, "prefix_display": null, "first_name": "ADAM", "nickname": null, "middle_name": "S", "last_name": "OLSEN", "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": 198, "name": "Natl Economic Council (NEC)"}, {"id": 9, "name": "President of the U.S."}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Legislative proposals on supply chain and shortage issues including aluminum, steel, microchips, and semiconductors. Legislative proposals related to U.S. competitiveness with China. Legislation on Chinas status in international organizations, including H.R. 1107.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54920, "prefix": null, "prefix_display": null, "first_name": "ADAM", "nickname": null, "middle_name": "S", "last_name": "OLSEN", "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": 9, "name": "President of the U.S."}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Legislative proposals related to the Energy Policy and Conservation Act (EPCA) and its modernization or reform. Legislative proposals concerning Regional Standards HVAC compliance date. Legislative proposals related to indoor air quality issues. Legislative proposals related to plastics, packing, recycling, and extended producer responsibility programs. Legislative proposals related to decarbonization and heat pumps. Natural Gas Appliances Standards Act, \"S. 1043.\" Regional standards and EPCA, \"H.R. 4378.\" HR 8402 (2022 Lesko) HR 6192, Hands Off Our Home Appliances Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54920, "prefix": null, "prefix_display": null, "first_name": "ADAM", "nickname": null, "middle_name": "S", "last_name": "OLSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Legislative proposals related to the Inflation Reduction Act of 2022 and its implementation. Legislative proposals for Thermal Energy Storage investment tax incentives. Legislative proposals for incentives related to decarbonization and heat pumps. American Innovation and R&D Competitiveness Act, or 174 legislation. Build it in America Act, \"H.R. 3938.\" Clean energy tax incentives.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54920, "prefix": null, "prefix_display": null, "first_name": "ADAM", "nickname": null, "middle_name": "S", "last_name": "OLSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Legislative proposals related to climate policy, including decarbonization and heat pumps. Legislative proposals related to chemicals policy, including PFAS. Legislative proposal related to HFCs and refrigerants.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54920, "prefix": null, "prefix_display": null, "first_name": "ADAM", "nickname": null, "middle_name": "S", "last_name": "OLSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 16, "name": "Natl Security Council (NSC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 9, "name": "President of the U.S."}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 41783 VA   US US Trade Association for the Air Conditioning, Heating and Refrigeration Industry 0 0 331537   normalized_name_state 0.9

Links from other tables

  • 5 rows 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 154.941ms