lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
22 rows where filing_uuid = "f862baf7-fa83-45e5-8b05-e6d643ec87ef" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 850953 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | MAN | Competitiveness Issues | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850954 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | TEC | H.R. 1 - American Recovery and Reinvestment Act of 2009 - Transmission | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850955 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | HOM | Appropriations Pandemic Influenza Policy | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850956 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | FOO | Safety Microbial Detection Antimicrobials Import Safety / Pedigree Bills H.R. 2749 - Food Safety Enhancement Act S. 510 - Food and Drug Administration Food Safety Modernization Act H.R. 759 - Food and Drug Administration Globalization Act of 2009 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850957 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | TRA | Solvency of the Highway Trust Fund Federal Procurement Regulations Highway Planning H.R. 2125 - Surface Transportation Safety Act S. 791 - Surface Transportation Safety Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850958 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | ENV | Science-Based Environmental Regulatory Reform Ban Asbestos in Products Climate Change Legislation H.R. 2454 - American Clean Energy and Security Act of 2009 Senate Climate Change Draft Bill | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850959 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | TRD | IP Protection / Technology Transfer President TPA Authority Lacey Act Retaliatory Tariffs Miscellaneous Tariffs and Duty Suspension Bills related to: - Perfluorocarbons - Perfluorobutane Sulfonyl Fluoride - THV - Catalytic Converter Mats Korea FTA Columbia FTA Panama FTA | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850960 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | DEF | Military Health FY10 Defense Appropriations Request - H.R. 3326 Records Management Warfighter Protection | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850961 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | ROD | Work Zone Safety Transportation Reauthorization Traffic Safety H.R. 2125 - Surface Transportation Safety Act S. 791 - Surface Transportation Safety Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850962 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | TAX | International Tax Policy Jobs and Growth Policy Bilateral Tax Treaties Corporate Tax Reform H.R. 2348 - Energy Tax Provisions Medical Device Taxes in America's Healthy Future Act R&D Tax Issues Taxes on Employee Benefits (also in America's Healthy Future Act) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850963 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | DIS | Prep Act coverage for N95 Respirators FEMA, First Responders, Disaster Preparedness Pandemic Influenza Policy and Liability Policy (H1N1) HHS Action Plan to Prevent Healthcare Associated Infections | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850964 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | RET | H.R. 2803 - Pension Reform and follow-up H.R. 977 - Derivatives Markets Transparency and Accountability Act S. 272 - Derivatives Trading Integrity Act Financial System Reforms and Regulation of Derivatives H.R. 3300 - Derivative Trading Accountability and Disclosure Act H.R 3795 - To Enact the Over-the-Counter Derivatives Market Act of 2009 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850965 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | CPT | S. 515 - The Patent Reform Act of 2009 S. 610 - The Patent Reform Act of 2009 H.R. 1260 - The Patent Reform Act of 2009 H.R. 2410 - Green IP Protection/Technology Transfer | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850966 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | FOR | Embassy Operations Trade Impact Non-tariff barriers to trade and concerns about market access for business operation in the Netherlands IP Protection / Technology Transfer | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850967 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | MMM | The Physician Payments Sunshine Act The Drug and Medical Device Company Gift Disclosure Act Antimicrobial Resistance Medicare Reform Implementation Medical Technology Reimbursement ICD-10 Implementation Comparative Effectiveness Research Patient Safety Healthcare Associated Conditions 9HACs) and Infections (HAIs), Readmissions and Bundling HIT / Electronic Health Records S. 295 - Medicare Quality and Payment Reform Act Health Care Reform Legislation: - H.R. 3200 - America's Affordable Health Choices Act - S. 1679 - Affordable Heath Choices Act - America's Healthy Future Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850968 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | HCR | The Physician Payments Sunshine Act The Drug and Medical Device Company Gift Disclosure Act Health Information Technology and Electronic Health Records Patient Safety ERISA Preservation Healthcare associated conditions (HACs), Readmissions, and bundling Comparative Effectiveness Research Medical Technology Reimbursement Health Care Reform Legislation: - H.R. 3200 - America's Affordable Health Choices Act - S. 1679 - Affordable Heath Choices Act - America's Healthy Future Act Antimicrobial Resistance | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850969 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | BUD | Federal R&D Appropriations General Appropriations - HR 2638 FY10 Federal Appropriations Requests FY10 Defense Appropriations - H.R. 3326 H.R.1 - American Recovery and Reinvestment Act of 2009. | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850970 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | CHM | Chemical Regulation TSCA Reform Kids Safe Chemical Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850971 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | ENG | Electricity Regulation Energy Policy - Transmission Alternative Energy Technology Renewable Energy Standards TV Energy Efficiency Test Method H.R.1 - American Recovery and Reinvestment Act of 2009 H.R. 2454 - American Clean Energy and Security Act of 2009 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850972 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | LBR | FLSA OSHA / NIOSH FMLA FAIR ACT Employee Free Choice Act (EFCA) H.R. 2768 - S-Miner Act (mandatory standards to protect miners during emergencies) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850973 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | TOR | Tort System Reform Federal Preemption for Medical Device Reviews Medical Malpractive/Tort Reform (in Health Care Reform) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 | |
| 850974 | 3M COMPANY f862baf7-fa83-45e5-8b05-e6d643ec87ef | Q3 | 3M COMPANY | 25465 | 3M COMPANY | 2009 | third_quarter | CAW | Science-Based decision making on water and air quality | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Federal Communications Commission (FCC),Federal Highway Administration (FHA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 430000 | 0 | 0 | 2009-10-20T15:18:19-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);