home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ae4737f6-0fe5-42f0-be01-82bc48fc52ea

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
ae4737f6-0fe5-42f0-be01-82bc48fc52ea Q1 35068 SHEET METAL & AIR CONDITIONING CONTRACTORS NAT'L ASSN 143439 SHEET METAL & AIR CONDITIONING CONTRACTORS NAT'L ASSN 2012 first_quarter 2012-04-16T14:48:03.780000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ae4737f6-0fe5-42f0-be01-82bc48fc52ea/", "filing_uuid": "ae4737f6-0fe5-42f0-be01-82bc48fc52ea", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ae4737f6-0fe5-42f0-be01-82bc48fc52ea/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Stanley E. Kolbe, Jr.", "dt_posted": "2012-04-16T14:48:03.780000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "305 4TH STREET, NE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20002", "registrant": {"id": 35068, "url": "https://lda.senate.gov/api/v1/registrants/35068/", "house_registrant_id": 32882, "name": "SHEET METAL & AIR CONDITIONING CONTRACTORS NAT'L ASSN", "description": null, "address_1": "305 4TH STREET, NE", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20002", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STANLEY KOLBE JR.", "contact_telephone": "+1 202-547-8202", "dt_updated": "2026-01-30T09:27:54.314813-05:00"}, "client": {"id": 143439, "url": "https://lda.senate.gov/api/v1/clients/143439/", "client_id": 12, "name": "SHEET METAL & AIR CONDITIONING CONTRACTORS NAT'L ASSN", "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": "1996-02-14"}, "lobbying_activities": [{"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Savings Recovery Act H.R. 2021", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Green Schools Construction H.R. 2187\nGreen Schools Grant H.R. 58", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Green Builders Tax Incentive H.R. 2198\n3% Withholding Tax Repeal S. 292 / H.R. 1023 and H.R. 275\nAmend the Internal Revenue Service Code to reduce the depreciation period for energy efficient mechanical equipment for heating, ventilating and air conditioning (HVAC) to twenty years from the current thirty-nine year depreciation period H.R. 2198 1099 reporting enacted in Patient Protection and Affordable Care Act\n\nExtension of Treasury Grants Program for Manufacturing Energy Efficiency/Combined Heat and Power (CHP)/Industrial Retrofit Efficiency\n\nExtension of the U.S. Treasury Program providing grants in lieu of tax credits for clean energy property \n\nExpanding to 25 magawatts the size of combined heat and power systems allowed to take advantage of Sec. 48(C) tax credits as provided in Se. 114 of the Advanced Energy Tax Incentives Act of 2010 (S. 3935)\n\nThe Energy Savings and Industrial Competitiveness Act S. 1000 \n\nExtension of Tax Provisions (expiring in 2012)\n\nSecurity in Bonding Act of 2011 - H.R. 3534\n\nAmend and Repeal 3% Withholding Law - H.R. 674\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nSmall Business participation in public contracting matters\n\nExtend in 2012 tax provisions that expired in 2011\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nDetection and deterance of misclassification of workers as independent contractors", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Worker Misclassification H.R. 3408 / S. 2882 \nExtending and preserving Davis - Bacon Act on all federal and federally assisted construction\nThe Energy Savings and Industrial Competitiveness Act S. 1000 Amend the Internal Revenue Service Code to reduce the depreciation period for energy efficient mechanical equipment for heating, ventilating and air conditioning (HVAC) to twenty years from teh current thirty-nine year depreciation period H.R. 2198\n\n1099 reporting enacted in Patient Protection and Affordable Care Act\n\nExtension of Treasury Grants Program for Manufacturing Energy EfficiencyCombined Heat and Power (CHP)/Industrial Retrofit Efficiency\n\nExtension of U.S. Treasury Program providing grants in lieu of tax credits for clean energy property\n\nExpanding to 25 megawatts the size of combined heat and power systems allowed to take advantage of Sec. 48(C) tax credits as provided in Sec. 114 of the Advanced Energy Tax Incentives Act of 2010 S. 3935\n\nDeMint Amendment to repeal The Davis-Bacon Act (S.A. 167) to S. 493, the SBIR/STTR Reauthorization Act of 2011\n\nGuinta Amedment banning use of Project Labor Agreements (PLAs) on federal construction \n\nProvisions in H.R. 1, the Full Year Continuing Appropriations Act of 2011, which would slash the General Services Administration's (GSA) Federal Building Fund \n\nFAA Re-Authorization Bill: prevailing wage coverage S. 223\n\nUse of Project Labor Agreements (PLAs) on federal funded construction\n\nGovernment Neutrality in Contracting Act S. 119/H.R. 735 \n\nScalise Amendment to H.R. 2017 banning use of PLAs on federal construction\n\nGosar Amendment to H.R. 2017 (prevailing wage coverage)\n\nLaTourette Amendment to Military Construction Appropriations Bill H.R. 2055 (PLAs)\n\nJob Creation\n\nExtension of Tax Provisions (expiring in 2012)\n\nSecurity in Bonding Act of 2011 - H.R. 3534\n\nAmend and Repeal 3% Withholding Law - H.R. 674\n\nFiscal Year 2012 Funding for DOE's Office of Energy Efficiency and Renewable Energy; Energy Information Administration - H.R. 2354\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nSmall Business participation in public contracting matters\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nExtend in 2012 tax provisions that expired in 2011 Detection and deterance of misclassification of workers as independent contractors\n\nSmart Energy Bill (support) - H.R. 4017\n\nInnovative Energy System Act - H.R. 2784\n\nHeat in Power Act (support) - H.R. 2812", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "1099 reporting enacted in Patient Protection and Affordable Care Act\nDeMint Amendment to repeal The Davis-Bacon Act (S.A. 167) to S. 493, the SBIR/STTR Reauthorization Act of 2011\nExtending and preserving Davis - Bacon Act on all federal and federally assisted construction Guinta amedment banning use of Project Labor Agreements (PLAs) on federal construction\n\nS. 223 FAA Re-Authorization Bill: prevailing wage coverage\n\nUse of Project Labor Agreements (PLAs) on federal funded construction\n\nGovernment Neutrality in Contracting Act S. 119/H.R. 735 \n\nScalise Amendment to H.R. 2017 banning use of PLAs on federal construction\n\nGosar Amendment to H.R. 2017 (prevailing wage coverage)\n\nLaTourette Amendment to Military Construction Appropriations Bill H.R. 2055 (PLAs)\n\nJob Creation\n\nExtension of Tax Provisions (expiring in 2012)\n\nSecurity in Bonding Act of 2011 - H.R. 3534\n\nAmend and Repeal 3% Withholding Law - H.R. 674\n\nFiscal Year 2012 Funding for DOE's Office of Energy Efficiency and Renewable Energy; Energy Information Administration - H.R. 2354\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nSmall Business participation in public contracting matters\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nExtend in 2012 tax provisions that expired in 2011\n\nDetection and deterance of misclassification of workers as independent contractors", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Water Quality/Drinking Water Grants S. 1005\nExtension of Treasury Grants Program for Manufacturing Energy Efficiency/Combined Heat and Power (CHP)/Industrial/Retrofit Efficiency\nExtension of the U.S. Treasury Program providing grants in lieu of tax credits for clean energy property Provisions in H.R. 1, the Full Year Continuing Appropriations Act of 2011, which would slash the General Services Administration's (GSA) Federal Building Fund \n\nExtending and preserving Davis - Bacon Act on all federal and federally assisted construction\n\nFiscal Year 2012 Funding for DOE's Office of Energy Efficiency and Renewable Energy; Energy Information Administration - H.R. 2354\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nSmart Energy Bill (support) - H.R. 4017\n\nInnovative Energy System Act - H.R. 2784\n\nHeat in Power Act (support) - H.R. 2812", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "3% Withholding Tax Repeal S. 292 / H.R. 1023, H.R. 275\nConstruction Bidding Reform H.R. 3854\nAmend the Internal Revenue Service Code to reduce the depriciation period for energy efficient mechanical equipment for heating, ventilating and air conditioning (HVAC) to twenty years from the current thirty-nine year depreciation period H.R. 2198 1099 reporting enacted in Patient Protection and Affordable Care Act\n\nSupport of Extension of Treasury Grants Program for Manufacturing Energy Efficiency/Combined Heat and Power (CHP)/Industrial Retrofit Efficiency\n\nExtension of the U.S. Treasury Program providing grants in lieu of tax credits for clean energy property \n\nExpanding to 25 magawatts the size of combined heat and power systems allowed to take advantage of Sec. 48(C) tax credits as provided in Se. 114 of the Advanced Energy Tax Incentives Act of 2010 (S. 3935)\n\nDeMint Amendment to repeal The Davis-Bacon Act (S.A. 167) to S. 493, the SBIR/STTR Reauthorization Act of 2011\n\nGuinta Amedment banning use of Project Labor Agreements (PLAs) on federal construction\n\nFAA Re-Authorization Bill: prevailing wage coverage S. 223 \n\nExtending and preserving Davis - Bacon Act on all federal and federally assisted construction\n\nUse of Project Labor Agreements (PLAs) on federal funded construction\n\nGovernment Neutrality in Contracting Act S. 119/H.R. 735 \n\nScalise Amendment to H.R. 2017 banning use of PLAs on federal construction\n\nGosar Amendment to H.R. 2017 (prevailing wage coverage)\n\nLaTourette Amendment to Military Construction Appropriations Bill H.R. 2055 (PLAs)\n\nJob Creation\n\nExtension of Tax Provisions (expiring in 2012)\n\nSecurity in Bonding Act of 2011 - H.R. 3534\n\nAmend and Repeal 3% Withholding Law - H.R. 674\n\nFiscal Year 2012 Funding for DOE's Office of Energy Efficiency and Renewable Energy; Energy Information Administration - H.R. 2354\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nSmall Business participation in public contracting matters\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nExtend in 2012 tax provisions that expired in 2011\n\nDetection and deterance of misclassification of workers as independent contractors", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Amend the Internal Revenue Service Code to reduce the depreciation period for energy efficient mechanical equipment for heating, ventilating and air conditioning (HVAC) to twenty years from teh current thirty-nine year depreciation period H.R. 2198\n\nExtending and preserving Davis - Bacon Act on all federal and federally assisted construction Extension of Treasury Grants Program for Manufacturing Energy Efficiency/Combined Heat and Power (CHP)/Industrial Retrofit Efficiency\n\nExtension of the U.S. Treasury Program providing grants in lieu of tax credits for clean energy property \n\nExpanding to 25 magawatts the size of combined heat and power systems allowed to take advantage of Sec. 48(C) tax credits as provided in Se. 114 of the Advanced Energy Tax Incentives Act of 2010 (S. 3935)\n\nFiscal Year 2012 Funding for DOE's Office of Energy Efficiency and Renewable Energy; Energy Information Administration - H.R. 2354\n\nRoofing Efficiency Jobs Act of 2011 - H.R. 2962\n\nEnergy-Efficient Cool Roof Jobs Act - S. 1575\n\nHigh-Performance Federal Buildings Act - H.R. 3371\n\nSmart Energy Bill (support) - H.R. 4017\n\nInnovative Energy System Act - H.R. 2784\n\nHeat in Power Act (support) - H.R. 2812", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39924, "prefix": null, "prefix_display": null, "first_name": "STANLEY", "nickname": null, "middle_name": "E", "last_name": "KOLBE", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 37651, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "THOMPSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32882 DC DC US US   0 0            

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.71ms · Privacy