lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "dfededc8-9c8f-49e1-ab85-69de8fb951e2" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436721 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | POS | 21st Century Postal Service Act (S.1789) DATA Act (H.R.2146) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436722 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | AGR | Farm Bill (H.R.1947, S.954) Healthy, Hunger-Free Kids Act (P.L. 111-296) - Implementation Proposed Nutrition Standards for All Foods Sold in Schools (FNS-2011-0019) School Food Modernization Act (H.R.1783)The Sensible School Lunch Act (S.247) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436723 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | TRA | MAP-21 Implementation (P.L.112-141) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436724 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | HCR | Authority for Mandate Delay Act (H.R.2667) Draft Guidance on Laboratory Developed Tests (FDA) Draft Research Priorities (PCORI) EMS Quality, Innovation, and Cost Effectiveness Improvements Act of 2011 (H.R.3144)Fairness for American Families Act (H.R.2668) Health Risk Assessments in Medicare Comments (CDC) Health Risk Assessments in Medicare Comments (CDC) Interest Rate Reduction Act (H.R.4628/S.2366) and other legislation using Prevention Fund to offset student loans Josh Miller Helping Everyone Access Responsive Treatment in Schools (HEARTS) Act (H.R.1377) Menu Labeling (ACA Section 4205) No Child Left Inside Act of 2013 (H.R.2702) Patient Protection and Affordable Care Act (P.L. 111-148; P.L. 111-152) - Implementation Physical Activity Guidelines for Americans Act (S.531 & H.R.2179) Prevention and Public Health Fund (ACA Section 4002) Proposed rule on Community Health Needs Assessment Requirements for Charitable Hospitals (IRS) Proposed rule on Medicaid Essential Health Benefits (CMS) Proposed rule on Minimum Value of Employer Health Coverage (IRS) Proposed rule on Multi-State Plans Program (OPM) Proposed rule on Workplace Wellness Programs (HHS-Labor) Request for Comments Surgeon General's Report on Walking The HELPAmerica Act (S.39) The Helping Sick Americans Now Act (H.R.1549) The Personal Health Investment Today Act (H.R. 956) The Sensible School Lunch Act (S.247) The Stopping Taxpayer Outlays for Propaganda Act (H.R.1572) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436725 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | MMM | Cardiac Rehabilitation : Chronic Heart Failure (CAG-00089R3) Medicare Access to Rehabilitation Services Act (H.R.713/S.367) Medicare Diabetes Prevention Act (S.452) Medicare FY2014 Hospital Inpatient Prospective Payment System (CMS-1599-P)Medication Adherence/Medication Therapy Management Medication Therapy Management Act of 2013 (H.R. 1024/S.557) Proposed rule on Hospital FY2014 IPPS-HHS & Congress (stroke measures) Recruiting Individuals to Drive our Elders (RIDE) Act-not yet introduced Single-Chamber and Dual-Chamber Permanent Cardiac Pacemakers (CAG-00063R3) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436726 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | BUD | American Taxpayer Relief Act (H.R.8) "fiscal cliff bill" - Medicare/Medicaid therapy caps Appropriations - provisions relating to CDC, Commerce, FDA, HRSA, NIH, USDA Budget - provisions relating to Medicaid and Medicare FY2014 Agriculture AppropriatonsFY2014 Financial Services FY2014 Labor-HHS-Education Appropriations bill-provisions relating to CDC, HRSA and NIH Land and Water Conservation Fund | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436727 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | GOV | Regulatory Accountability Act (H.R.3010/S.1606) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436728 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | TOB | Implementation of the Family Smoking Prevention and Tobacco Control Act (P.L. 111-31) Potus Tobacco Tax Proposal Smokeless Tobacco Product Warning Statements (FDA-2012-N-1032-0001) Smuggled Tobacco Prevention STOP ActStop Tobacco Smuggling in the Territories Act (H.R. 338) Tobacco Industry Submission of Health Documents (FDA-2013-N-0337) Tobacco Product Good Manufacturing Practices (FDA-2013-N-0227) Tobacco Tax Equity Act, S.194 Tobacco Tax & Enforcement Reform Act (S.826) Traditional Cigar Manufacturing and Small Business Jobs Preservation Act of 2013 (H.R.792 & S.772) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436729 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | EDU | Afterschool for America's Children Act (TBD) Fitness Integrated with Teaching Kids Act (FIT Kids Act) (S.1033, H.R.2178) Placement of AEDS in schools Student Success Act (S.1094) Strengthening America's Schools Act | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-04:00 | |
| 1436730 | AMERICAN HEART ASSOCIATION dfededc8-9c8f-49e1-ab85-69de8fb951e2 | 2A | AMERICAN HEART ASSOCIATION | 2525 | AMERICAN HEART ASSOCIATION | 2013 | second_quarter | CAW | Domestic Jobs and Energy Act (H.R.4480) Gasoline Regulations Act of 2012 (H.R.4471) National Ambient Air Quality Standards (NAAQS) for Particulate Matter Proposal for Cleaner Gasoline Vehicle StandardsStop the War on Coal Act of 2012 (H.R. 3409) | Agency for Healthcare Research & Quality (AHRQ),Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Education, Dept of,Environmental Protection Agency (EPA),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Institutes of Health (NIH),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,White House Office | 251785 | 0 | 0 | 2013-08-28T14:18:49.530000-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);