home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1392eb72-e9f1-475d-a32a-4fe5dd4ebe0b

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
1392eb72-e9f1-475d-a32a-4fe5dd4ebe0b Q3 39052 UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 147117 UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS 2024 third_quarter 2024-10-21T11:27:27-04:00 200000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1392eb72-e9f1-475d-a32a-4fe5dd4ebe0b/", "filing_uuid": "1392eb72-e9f1-475d-a32a-4fe5dd4ebe0b", "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/1392eb72-e9f1-475d-a32a-4fe5dd4ebe0b/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "200000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Margaret Mock", "dt_posted": "2024-10-21T11:27:27-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1757 N STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 39052, "url": "https://lda.senate.gov/api/v1/registrants/39052/", "house_registrant_id": 30765, "name": "UNITED AUTOMOBILE, AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS", "description": null, "address_1": "1757 N STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RAJIV SICORA", "contact_telephone": "+1 202-828-8500", "dt_updated": "2026-01-30T10:31:57.311773-05:00"}, "client": {"id": 147117, "url": "https://lda.senate.gov/api/v1/clients/147117/", "client_id": 12, "name": "UNITED AUTOMOBILE AEROSPACE & AGRICULTURAL IMPLEMENT WORKERS", "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": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "NLRB FY '25 Appropriations, National Defense Authorization Act (NDAA) FY '25 Appropriations, FY 2025 Appropriations, retirement security", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "National Defense Authorization Act (NDAA) FY '25 appropriations, Securing Americas Titanium Manufacturing Act of 2024", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Title IX reform at Department of Education, Time Off to Vote Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Inflation Reduction Act (H.R.5376) implementation, Electric vehicle infrastructure investments, Infrastructure Investment and Jobs Act (H.R. 3684) implementation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "POS", "general_issue_code_display": "Postal", "description": "Inflation Reduction Act (H.R.5376) implementation, USPS Fleet", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 99, "name": "U.S. Postal Service (USPS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Public Service Loan Forgiveness Program, Biden's student debt cancellation, student loan repayment pause, higher education affordability, Title IX, Family Educational Rights and Privacy Act (FERPA), Oppose H.R. 1516, DHS Restrictions on Confucius Institutes and Chinese Entities of Concern Act, Oppose H.R. 1516, Protect America's Innovation and Economic Security from CCP Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "AUT", "general_issue_code_display": "Automotive Industry", "description": "Electric vehicle consumer and manufacturing tax credits implementation in the Inflation Reduction Act: 45W, Domestic Manufacturing Conversion grants, Advanced Technology Vehicles Manufacturing Loan Program (ATVM). Corporate Average Fuel Economy civil penalties, Infrastructure Investment and Jobs Act implementation, CHIPS and Science Act implementation, Clean School Bus Program, Greenhouse Gas Emissions Standards, Oppose End Chinese Dominance of Electric Vehicles in America Act (H.R. 7980), Oppose Protect Americas Innovation and Economic Security from CCP Act (H.R. 1398)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"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": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Inflation Reduction Act implementation, Advanced Technology Vehicles Manufacturing Loan Program (ATVM), Manufacturing tax credits (45W), Domestic Manufacturing Conversion grants, Autonomous vehicle manufacturing labor standards, Corporate Average Fuel Economy (CAFE) Standard and Greenhouse Gas Emissions Standards for Motor Vehicles, Infrastructure Investment and Jobs Act Implementation, Heavy Duty tailpipe emission, Electric Steel (GOES/NOES), Battery Workforce Initiative", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"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": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Inflation Reduction Act (H.R.5376) implementation, OSHA heat stress protection rule, Medicare/Medicaid", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "International student work visas (J1 & F1)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}, {"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}], "government_entities": [{"id": 154, "name": "Bureau of Citizenship & Immigration Services (BCIS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Inflation Reduction Act (H.R.5376) implementation, Protecting the Right to Organize (PRO) Act, Secure And Fair Elections for Workers (SAFE) Act, Workplace Violence Prevention Act, Raise the Wage Act, Public Service Freedom to Negotiate Act, Infrastructure Investment and Jobs Act (IIJA) implementation, Toxic Substances Control Act, Nationwide Right to Unionize Act, Thirty-Two Hour Workweek Act, Homes Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 73, "name": "Natl Labor Relations Board (NLRB)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Inflation Reduction Act (H.R.5376) implementation: prescription drug reform. Stabilizing multi- and single-employer defined benefit pension plans, implementation of multi-employer pension provisions from the American Rescue Plan Act (ARPA, H.R.1319), defending Social Security, Retirement Security Rule", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 85, "name": "Pension Benefit Guaranty Corporation (PBGC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Inflation Reduction Act (H.R.5376) implementation: corporate international tax reform, IRS enforcement", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "USMCA implementation and enforcement, USMCA 6-year review, CHIPS and Science Act (H.R.4346) implementation, Section 301, de minimis trade loophole", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}, {"id": 98, "name": "U.S. International Trade Commission (ITC)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Advanced Technology Vehicles Manufacturing Loan Program (ATVM), Domestic Manufacturing Conversion grants, Autonomous vehicle manufacturing labor standards, Corporate Average Fuel Economy (CAFE) Standard and Greenhouse Gas Emissions Standards for Motor Vehicles, CAFE civil penalties, Infrastructure Investment and Jobs Act (H.R.3684) Implementation, Heavy Duty tailpipe emission, Heavy-Duty and Light-Duty emissions, Inflation Reduction Act implementation (45W)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 141589, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ZATRATZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Representative", "new": false}, {"lobbyist": {"id": 146940, "prefix": null, "prefix_display": null, "first_name": "RAJIV", "nickname": null, "middle_name": null, "last_name": "SICORA", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Director", "new": false}], "government_entities": [{"id": 14, "name": "Council of Economic Advisers (CEA)"}, {"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": 175, "name": "Natl Highway Traffic Safety Administration (NHTSA)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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