lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "dfededc8-9c8f-49e1-ab85-69de8fb951e2" and issue_code = "HCR" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);