lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "2bc1d8e2-8a48-4d36-b765-bfbb173d84e2" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1570739 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | HOU | Rental Assistance Demonstration Program | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570740 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | FAM | Child Welfare administrative and financing issues S 1086 -The Child Care and Development Block Grant Act of 2013 | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570741 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | TRA | HR 2322 -Surface Transportation Reauthorization HR 3080 -Water Resources Reform and Development Act S 2438 -Transportation, Housing and Urban Development FY 2015 appropriations | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570742 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | TRD | Trans-Pacific Partnership Agreement, provisions related to medicines and medical devices and investor-state dispute resolution Trans-Atlantic Trade Investment Partnership, provisions related to medicines, medical devices, investor-state dispute resolution HR 3830, S 1900 -Bipartisan Congressional Trade Priorities Act, provisions related to medicines and medical devices and transparency issues | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570743 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | CIV | Increasing access to medical language interpreters Increasing community integration for individuals with disabilities HR 3899, S 1945 - Voting Rights Amendment Act of 2014 | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570744 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | TAX | HR 694, S 250, S 268, S 307 -Corporate tax reform, including tax rates, loopholes, profit repatriation, tax holiday, territorial system HR 4438, HR 4457, HR 4453, HR 3474, S 2260 -Tax extenders -offsets, active financing exception, CFC look-through rule HR 4438 -Research and Experimentation Tax Credit bill HR 4718 -Bonus DepreciationFederal income tax deduction for state and local government taxes; including state and local sales tax HR 2288 -Federal income tax exclusion for employer-sponsored mass transit commuter benefits; Commuter Parity Act of 2013 Limits on itemized deductions and selected exclusions Federal income tax exclusion for interest on state and local government public purpose bonds Federal tax reform impact on state and local government revenues Reduced tax rates on capital gains and dividends S 1533 -Stop Tax Haven Abuse Act S 743, HR 684 -Marketplace Fairness Act of 2013 S 743 -Internet Sales Tax HR 1129 -Mobile Workforce State Income Tax Simplification Act HR 3086, S 1431 -Permanent Internet Tax Freedom Act HR 3724, S 1364 -Digital Goods and Services Tax Fairness Act of 2013 HR 2992 -Business Activity Tax Simplification Act Financial Transaction Tax Tax Reform issues HR 2084, S 1957 -Partnership to Build America Act of 2014 HR 2429, S 1183 -Death Tax Repeal Act | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570745 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | RET | S 1270, HR 1628 -Public Pensions and Pension Transparency Act S 567, HR 3118 -Strengthening Social Security Act S 308, HR 694 -Protecting and Preserving Social Security Act | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570746 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | ECN | Job Creation S 1747, S 1797, S 1845, S 2077, S 2148, S 2149 -Extending Federal Unemployment Compensation S 1356 -Workforce Investment Act of 2013 HR 803, HR 798 -SKILLS Act/Workforce Investment Act of 2013 | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570747 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | HCR | S 2297 -Nurses for Under-Resourced Schools Everywhere Act Improving federal funds for states to invest in home care services Increasing access to medical language interpreters Workplace Violence in health care settingsHR 4414 -Expatriate Health Care Coverage Clarification Act HR 2575 -Save American Workers Act HR 2988 -Forty Hours is Full Time Act HR 4775 -Safeguarding Classrooms Hurt by ObamaCare's Obligatory Levies Repeal of Affordable Care Act's excise tax on high-cost plans Federal income tax exclusion on high-cost employer sponsored health care insurance Federal excise tax on high-cost employer sponsored health care benefits | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570748 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | MMM | S 2087, S 2491 -Medicare Protection Act, reconciliation budget rules S 2297 -Nurses for Under-Resourced Schools Everywhere Act HR 4302 -Medicare Sustainable Growth Rate Reform and repeal Waste, abuse and fraud in MedicareMedicare Geographic Wage Index Improving federal funds for states to invest in home care services Reduce prescription drug costs in Medicare/Medicaid Increasing access to medical language interpreters Increasing community integration for individuals with disabilities Medicaid funding/benefits Medicare funding/benefits/policy/eligibility age/mean test | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570749 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | BUD | S 2087, S 2491 -Medicare Protection Act (reconciliation budget rules) Improving federal funds for states to invest in home care services HR 4745, S 2348 -increased funding for public transportation and housing/Public Housing Operating Fund and Capital Fund Funding for East-West CenterSequester, decrease spending reductions for non-security discretionary FY 2014 Minibus Appropriations SConRes 8, HConRes 96 -FY 2015 Budget Resolution S 1284 -Labor-HHS-Ed Appropriations, increased funding for various labor, health and education accounts to states HR 1874 -Pro-Growth Budgeting Act of 2014 HR 4800, S 2389 -Agriculture Appropriations bill | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570750 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | GOV | HR 4318 -Endangered Species Litigation Reasonableness Act | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570751 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | IMM | HR 4414 -Expatriate Health Coverage Clarification Act | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570752 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | EDU | S 2432 -Student Loan Refinancing Child Care and Development Block Grant (CCDBG) Reauthorization, background checks S 1697, HR 3641 -Strong Start for America's Children Act, to authorize pre-K and Child Care and Early Head Start partnerships HR 10 -Success and Opportunity through Quality Charter Schools ActS 2432 -The Bank on Students Emergency Loan Refinancing Act Background Check bill for School Employees S 1356 -Workforce Investment Act of 2013 HR 803, HR 798 -SKILLS Act/Workforce Investment Act of 2013 | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570753 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | LBR | S 2297 -Nurses for Under-Resourced Schools Everywhere Act Improving the stability of the home care workforce Workplace Violence in health care settings HR 4306 -FAIR Act (3.3% federal pay raise)HR 2575 -Save American Workers Act of 2014 S 2223 -Fair Minimum Wage Act HR 1010, HR 3746, HR 3939, S 460, S 1737 -Minimum Wage Increase HR 4792 -Empower Employees Act S 1845, S 3979 -Unemployment Benefits Extension S 815 -Employee Non-Discrimination Act S 84 -Paycheck Fairness Act | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570754 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | PHA | Reduce prescription drug costs in Medicare/Medicaid | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-04:00 | |
| 1570755 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES 2bc1d8e2-8a48-4d36-b765-bfbb173d84e2 | Q2 | AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES | 2321 | AMERICAN FEDERATION OF STATE COUNTY AND MUNICIPAL EMPLOYEES | 2014 | second_quarter | LAW | Nomination of Robert Wilkins, US Court of Appeals | Council of Economic Advisers (CEA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,U.S. Trade Representative (USTR),White House Office | 660000 | 0 | 0 | 2014-07-21T14:57:14.130000-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);