home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb

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
dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb Q1 35070 INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS 143445 INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS 2009 first_quarter 2009-04-20T11:23:56-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb/", "filing_uuid": "dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2009, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/dcc69f95-8e75-4e1b-bb9f-eb009dd3d3cb/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "VINCENT PANVINI, DIRECTOR OF GOVERNMENTAL AFFAIRS", "dt_posted": "2009-04-20T11:23:56-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1750 NEW YORK AVENUE, NW, 6TH FLOOR", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 35070, "url": "https://lda.senate.gov/api/v1/registrants/35070/", "house_registrant_id": 31690, "name": "INTERNATIONAL ASSOCIATION OF SHEET METAL, AIR, RAIL & TRANSPORTATION WORKERS", "description": "International Union for the Sheet Metal,Air, Rail and Transportation Workers", "address_1": "1750 New York Avenue, NW", "address_2": "Suite 600", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVE DODD", "contact_telephone": "+1 202-662-0867", "dt_updated": "2026-01-07T14:03:10.541886-05:00"}, "client": {"id": 143445, "url": "https://lda.senate.gov/api/v1/clients/143445/", "client_id": 12, "name": "INTERNATIONAL ASSOCIATION OF SHEET METAL AIR RAIL & TRANSPORTATION WORKERS", "general_description": "International Union Sheet Metal, Air, Rail and Transportation Workers", "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": "2018-10-15"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "medicare rx coverage S.1/H.R. 1\nminimum wage bill H.R. 2429/S.2725 raising the minimum wage\nminimum wge/tax relief H.R. 1591, H.R. 976 & H.R. 2", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "united states cruise vessel acat S.127/H.R. 2901", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "coast guard authorization bill S. 951\nnatural defense authorization acat for 2004 H.R. 1588\nmarad authorization S. 1262\nnavel vessel delivery method of account S.774, H.R. 1479 fy2005 defense authorization bill (miliatry vase security)\nfy2005 departmetn fo defense appropriation(helmets to hardhats)\nappropriations for department of defense - 2006 navy shipbuilgin budget\nnaval force structure police act-H.R. 375/S.902\nnaval vessel delivery method of accounting S. 774", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "pension preservation & savings expansion acat 2003 H.R. 1776/S.2264/S.2233/H.R. 3108\nemployee retirment security action of 1974 H.R. 525/S.406\npension system overhaul-multi employer pension fund reform H.R. 2830\npension reform bills H.R. 280/S.1783 pension bill H.R. 2830/H.R. 4/S. 1783", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "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": "reform act H.R. 1316/S.271", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "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": "energy bill H.R. 4\nenergy employers occupational illness compensation illness act\ncomprehensive energy legislation H.R. 6\nenergy bille H.R. 6", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "foreign workers H.R. 2899/S.1461\nsecure america & orderly immigration of 205 S.1033/H.R. 230\nimmigration S.2611 & H.R. 4437\nimmigration S.1639 & H.R. 1645 & S. 1348 H-1B Visas s.32,S.1083,S.1092,S.1351 & H.R. 1930", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "training & eduction for american workers act H.R. 4402\nprevention OSHA action of ergonomics H.R. 987/S.1070\nbarring OSHA home office inspections H.R. 4098\nbid shopping repeal H.R. 4012 minimum wage act H.R. 655/S.277\nfair acat H.R. 19\nnational labaor relations act H.R. 1696/S.842\noccupational safety & helath small employer of justice act H.R. 739/H.R. 741/H.R.740 & H.R. 742\nkeller bill - recreational marine employment act of 2005 H.R. 940\ntruth in employment act H.R. 1816\nemployee right to choose act S. 1513/H.R. 3763\ndavis bacon act S.187/S.1749/H.R. 3763\nreveiw of OSHA citation H.R. 741\ndeadline flexibility - OSHA review commission H.R. 739\njob training S.1021/H.R. 27\n(reauthoirize workforce investment act)\nemployee free choice act H.R. 800 & S. 1041", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "water quality financial act H.R. 3930\nclean water infrastructure and security improvement act H.R. 3792\nenergy & water development H.R. 2765\ncalfed -bay/delta H.R. 2828", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "central american freetrade agreement", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "railroad track modernization bill S. 1220\nnational defense rail acat S. 1991\nhouse rail bills H.R. 1020/Ride 21/H.R. 2950\nrailroad safety improvement H.R. 2095", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "fsc repeal/manufacaturing tax act credit H.R. 1769", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ACC", "general_issue_code_display": "Accounting", "description": "Accounting Issues (no specific bill)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "H.R. 4115 & J.R. 2176- Indian Land Swap Bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "transportation equity act of teh 21st century- ISTEA\nsurface transportaion law (TEA-21)\nTWIC /port security\nhighway & mass transit reauthorization act H.R. 3", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "radiation exposure compensation S.1515\nhealth care safety net amendments S,.1281\nassocation health plans H.R. 660/S.545\nasbestos compensation reform S.2290 asbestos litigation S.853 & H.R.1360\nasbestos litigation S.3274 & H.R. 1360", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "school construction H.R. 1076", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41764, "prefix": "mr", "prefix_display": "MR.", "first_name": "VINCENT", "nickname": null, "middle_name": "ALBERT", "last_name": "PANVINI", "suffix": null, "suffix_display": null}, "covered_position": "Director of Governmental Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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