lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where filing_uuid = "1b954d7b-740b-423b-98ea-eec0a2d7b110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2490861 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | TRD | Importation of Prescription Drugs Proposed Rule, Docket No. FDA-2019-N-5711 Coalition letter in opposition to "buy american" mandates on medicines Other issues related to buy American mandates Issues related to broad tariff policies, especially suspension or delay General issues related to promoting international trade H.R. 6800, The Heroes Act S.3727 - Cash Refunds for Coronavirus Cancellations Act of 2020 | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490862 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | POS | H.R. 6800, The Heroes Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490863 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | BAN | Comments - Amendments to Volcker Rule Comments - Disclosure of Payments by Resource Extraction Comments - File No. 4-725. SEC Staff Roundtable on the proxy process Comments -Leveraged/Inverse Funds & Due Diligence Opposition to Expanding the Durbin Amendment in Coronavirus aid package Issues related to credit score reporting and phase 4 COVID-19 relief bill IRS langauge related to CARES Act disbursments of relief funding for prepaid debit cards 2017 CFPB consent decree Sen. Scott Letter to Sec. Mnuchin, Dir. Calabria and Dir. Kraninger on credit information suppressio | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490864 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | FIN | Comments - Amendments to Volcker Rule Comments - Disclosure of Payments by Resource Extraction Comments - File No. 4-725. SEC Staff Roundtable on the proxy process Comments -Leveraged/Inverse Funds & Due Diligence Opposition to Expanding the Durbin Amendment in Coronavirus aid package Issues related to credit score reporting and phase 4 COVID-19 relief bill IRS langauge related to CARES Act disbursments of relief funding for prepaid debit cards 2017 CFPB consent decree Sen. Scott Letter to Sec. Mnuchin, Dir. Calabria and Dir. Kraninger on credit information suppression | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490865 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | TAX | H.R. 1434/S.634, the Education Freedom Scholarships and Opportunity Act H.R. 2210, the Invest in America Act H.R. 748, the CARES Act Issues related to FIRPTA reform Issues related to GILTI implementation Issues related to indexing capital gains taxes to inflation Issues related to SALT deduction Issues related to tax extenders Mobile Workforce State Income Tax Simplification Act of 2020, H.R. 5674 S. 3280, the Blocking New Corporate Tax Giveaways Act S. 3296, the Accelerate Long-Term Investment Growth Now Act The PLAN Act, H.R. 4232 "H.R. 6800, The Heroes Act " Issues related to implementation of the Paycheck Protection Program "S. 3612, the Small Business Expense Protection Act " Issues related to Schedule B Issues related to alcohol excise taxes Issues related to tax filing and tax preparation deadlines Issues related to DoL information letter on Private Equity investments H.R. 6800, The Heroes Act Issues related to federal royalty rate payments Issues related to federal royalty rate payments Issues related to C-Band Helping Gig Economy Workers Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490866 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | TEC | Expanding Flexible Use of the 3.7 to 4.2 GHz Band; GN Docket No. 18-122 In the Matter of Expanding Flexible Use of the 3.7 to 4.2 GHz Band; GN Docket No. 18-122 Mobile Workforce State Income Tax Simplification Act of 2020, H.R. 5674 The PLAN Act, H.R. 4232 Use of the 5.850-5.925 GHz Band; ET Docket No. 19-138 Issues related to C-Band Helping Gig Economy Workers Act H.R.7160, Expanding Opportunities for Broadband Deployment Act Issues related to contact tracing Issues Realted to Citizens Broadband Radio Services 3.5 Mghz Band | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490867 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | BUD | H.R. 748, the CARES Act HR 6379, the Take Responsibility for Workers and Families Act H.R. 6800, The Heroes Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490868 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | CSP | Proposed Rule on Securing the ICTS Supply Chain, 15 CFR Part 7, RIN 0605-AA51 | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490869 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | GOV | H.R. 3063 - Business Activity Tax Simplification Act (BATSA) Issues Related to 5G Issues Related to Intellectual Property Issues Related to Mergers Issues Related to Privacy | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490870 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | ENG | H.R. 6800, The Heroes Act Issues related to federal royalty rate payments Issues related to net metering reform Issues related to federal royalty rate payments | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490871 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | TOB | Issues related to electronic cigarettes and vapor products S. 1253, Preventing Online Sales of E-Cigarettes to Children Act Issues related to FDA Deeming Rule, implementation and delay | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490872 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | LBR | Mobile Workforce State Income Tax Simplification Act of 2020, H.R. 5674 The PLAN Act, H.R. 4232 The PRO Act, S. 1306, H.R. 2474 Issues related to DoL information letter on Private Equity investments Issues related to C-Band Helping Gig Economy Workers Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490873 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | LAW | FairChanceto Compete for JobsActof 2019, S.387 United States of America et al. v. Deutsche Telekom AG et al.; Case 1:19-cv-02232 S. 3835, Stopping Censorship, Restoring Integrity, and Protecting Talkies Act, SCRIPT Act S. 3985, the JUSTICE Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490874 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | COM | H.R.7160, Expanding Opportunities for Broadband Deployment Act Issues Realted to Citizens Broadband Radio Services 3.5 Mghz Band | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490875 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | UTI | Issues related to net metering reform | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-04:00 | |
| 2490876 | AMERICANS FOR TAX REFORM 1b954d7b-740b-423b-98ea-eec0a2d7b110 | Q2 | AMERICANS FOR TAX REFORM | 3801 | AMERICANS FOR TAX REFORM | 2020 | second_quarter | HCR | Importation of Prescription Drugs Proposed Rule, Docket No. FDA-2019-N-5711 S. 3546/H.R. 6338, the Pandemic Healthcare Access Act H.R. 5741, the Strengthening Innovation in Medicare and Medicaid Act H.R. 748, the CARES Act H.R.3, the Elijah E. Cummings Lower Drug Costs Now Act Issues related to Buy American Pharmacetucial mandates Issues related to Medicare Part D Pandemic Healthcare Access Act, S. 3546, H.R. 6338 Proposed International Pricing Index (IPI) for drugs administered under Medicare Part B S. 1895, the Lower Healthcare Costs Act S. 2543, the Prescription Drug Pricing Reduction Act S. 3129, the Lower Costs, More Cures Act H.R. 2500, the National Defense Authorization Act S. 3769, the Right to Test Act H.R. 7242, Legislation to amend the Internal Revenue Code of 1986 to permit expenditures from health savings accounts for gym memberships and costs of home gym H.R. 6800, The Heroes Act | Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Energy Regulatory Commission (FERC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80000 | 0 | 0 | 2020-07-20T16:35:29.683000-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);