lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2876432 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | AGR | HR 5919- Early Childhood Nutrition Improvement Act S 1270- Access to Healthy Food for Young Children Act HR 8450- Healthy Meals, Healthy Kids Act Child Nutrition reauthorization Farm Bill | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876433 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | ALC | S 4301- Substance Use Prevention, Treatment and Recovery Act S 4170- Mental Health Reform Reauthorization Act of 2022 | SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876434 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | BAN | S 4890- Consumer Bankruptcy Reform Act | SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876435 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | BUD | HR 5305- Extending Government Funding (Continuing Resolution) Appropriations bills HR 5376- Inflation Reduction Act of 2022 Education and training for behavioral health care paraprofessionals Continuing Resolution added funding for health issues Automatic economic stabilizers (e.g. UI benefits) FY 2023 Appropriations: Transportation: FTA Transit Federal Formula Grants Water: Drinking Water State Revolving Fund; Clean Water State Revolving Fund; Water Infrastructure Finance and Innovation Act Labor: Unemployment Insurance Library of Congress, Architect of Capitol East-West Center Puerto Rico disaster relief Minibus Appropriations package HR 8295, S 4659- Labor, Health and Human Services, Education | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876436 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | CIV | HR 8296- Women's Health Protection Act of 2022 S 4504- Freedom to Travel for Health Care Act of 2022 | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876437 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | EDU | Student Loan Reforms HR 8856, S 4867- Loan Forgiveness for Educators Act of 2022 HR 8872- The LOAN Act | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876438 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | ENV | HR 6985- Financing Lead Out of Water (FLOW) Act HR 1352, S 916- Water Affordability, Transparency, Equity and Reliability (WATER) Act HR 4597- Clean Water State Revolving Fund Parity Act | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876439 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | GOV | Executive and Judicial Nominations S 2747, HR 5746- Freedom to Vote Act S 4573- Electoral Count Reform and Presidential Transition Act S 443- Disclose Act of 2021 re: Campaign Finance Reform | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876440 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | HCR | HR 7254, HR 7666- Mental Health Reforms HR 4965, S 2683- 9/11 Responder and Survivor Health Funding Correction Act Federal tax exclusion for employer-sponsored health benefits Medicaid Federal Medical Assistance Percentage (FMAP) | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876441 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | HOU | HR 4497- Housing is Infrastructure Act: Public Housing funds HR 235, S 598- Public Housing Emergency Response Act FY 2023 Appropriations: HUD funds for Public Housing Operating Fund, Public Housing Capital Fund, Rental Assistance Demonstration, ROSS, FSS Anti-displacement worker protections in Public Housing/RAD HR 659- Repeal the Faircloth Amendment Act of 2021 HR 2664- Green New Deal for Public Housing | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876442 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | LAW | HR 6943, S 3635- Public Safety Officer Support Act of 2022 HR 2992, S 4286- TBI and PTSD Law Enforcement Training Act PSOB benefits for correctional staff | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876443 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | LBR | HR 842, S 420- Protecting the Right to Organize (PRO) Act HR 5727- Public Service Freedom to Negotiate (PSFN) Act HR 2351, S 1175, HR 4350- 911 SAVES Act/NDAA HR 564- Comprehensive Paid Leave for Federal Employees Act HR 7309- Workforce Innovation Opportunities Act (WIOA) Reauthorization S 3373- PACT Act of 2022 HR 2193- Asuncion Valdivia Heat Illness and Fatality Prevention Act of 2021 Promoting apprenticeship for behavior health workers Issues related to the Fair Labor Standards Act (FLSA) Unemployment Insurance reform HR 1195- Workplace Violence Prevention for Health Care and Social Service Workers Act HR 2876- Protecting America's Workers Act Workplace safety for congressional employees HR 5456- Federal Employee Civil Relief Act Federal Labor-Management Partnership Act HR 1948- VA Employee Fairness Act of 2021 Research for workplace resilience Home- and Community-Based Services workforce Workforce for individuals with intellectual and developmental disabilities American Red Cross Workers Union Sequoia Hospital Reconciliation Package- Wage Tax Credits for Puerto Rico Nominees- FLRA: Ernest DuBester, Kurt Rumsfeld HR 302- Preventing a Patronage System Act Confirmation of Jessica Looman to be DOL Wage and Hour Division Administrator | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876444 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | MMM | HR 5376- Inflation Reduction Act of 2022 HR 6000- Electronic visit verification of home care workers Reconciliation Package- Medicaid Parity with States for Puerto Rico | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876445 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | PHA | Lower Prescription Drug Prices | SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876446 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | RET | HR 5723, HR 82, S 1302- Social Security Reforms- Social Security Fairness Act of 2021, Social Security 2100: A Sacred Trust, GPO/WEP | HOUSE OF REPRESENTATIVES,SENATE | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876447 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | TAX | Billionaires Surtax- various proposals Individual taxes- Surtax, increase rates on high income, return top rate to 39.6%, close loopholes, Mark to Market Corporate tax rates, close loopholes Supporting Americans with Lower Taxes (SALT) Act Earned income tax credits, child tax credits HR 2549, S 1157- Tax Fairness for Workers Act, Individual tax deduction for union dues S 4192, HR 8448- No Tax Breaks for Union Busting Act HR 2337- Public Servants Protection and Fairness Act of 2021 Tax Filing Simplification Act HR 5376, HR 1785, S 714- International tax incentives for outsourcing and rates, No Tax Breaks for Outsourcing Act HR 5376, HR 2576, S 994- Estate Taxes, For the 99.5% Act HR 5376, S 510, HR 1459- Ultra-Millionaire Tax Act of 2021 HR 3805, S 2028- Millionaires Surtax Act HR 5376, S 2617, HR 1068, S 1598- Carried interest tax loophole HR 7502- Babies Over Billionaires Act HR 8558- Billionaire Minimum Income Tax Deemed realization (1 time) at death/transfer for large assets (e.g. >$1 B) HR 2286- Deemed Realization of capital gains HR 5376, HR 1116, HR 1200, S 1857, S 1788- Increase funds for IRS tax enforcement and services, IRS Enhancement and Tax Gap Reduction Act of 2021, Stop CHEATERS Act, Restoring the IRS Act S 1652- Paying a Fair Share Act Close NIIT and SECA tax loopholes- use revenue for Medicare HR 5376, S 2680, HR 4940- Corporate tax: minimum rate (e.g. 15%), Real Corporate Profits Tax Act of 2021 General Business Tax Credits refundability Tax extenders General, R&D Tax Credit, Refundable NOL Carryover Opportunity Zone Reform Act | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 470000 | 0 | 0 | 2022-10-19T13:02:47-04:00 | |
| 2876448 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES e8f0fa77-18ca-4e0e-bb06-cf7dbc10e81f | Q3 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2022 | third_quarter | TRA | HR 5434- Surface Transportation Extension Act of 2021 | HOUSE OF REPRESENTATIVES | 470000 | 0 | 0 | 2022-10-19T13:02:47-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);