home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 44ed8a75-e933-44c5-8aaf-aeffd57fbbfa

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
44ed8a75-e933-44c5-8aaf-aeffd57fbbfa Q2 400794388 SCONSET STRATEGIES, LLC 195349 AIR CONDITIONING, HEATING AND REFRIGERATION INSTITUTE (AHRI) 2024 second_quarter 2024-07-22T18:43:35-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/44ed8a75-e933-44c5-8aaf-aeffd57fbbfa/", "filing_uuid": "44ed8a75-e933-44c5-8aaf-aeffd57fbbfa", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2024, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/44ed8a75-e933-44c5-8aaf-aeffd57fbbfa/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-07-22T18:43:35-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": "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)"}]}, {"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": "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": "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"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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