lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "2d05a77e-e534-4c0d-996d-e6ed196b4471" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 602282 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | TOB | H.R. 3162, Children's Health and Medicare Protection Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602283 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | TAX | H.R. 3162, Children's Health and Medicare Protection Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602284 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | DEF | S. 1548/H.R. 1585, Department of Defense Authorization H.R. 5122, Sonny Montgomery National Defense Authorization Act for Fiscal Year 2007 (coverage of Mental Health Counselors under TRICARE) Department of Defense Mental Health Task Force The Presidents Commission on Care for Americas Returning Wounded Warriors H.R. 1541, the Coming Together for Guard and Reserve Families Act S. 1196/H.R. 2612, the Mental Health Care for Our Wounded Warriors Act H.R. 4986, Defense Authorization Act of 2007 Defense Authorization for Fiscal Year 2009 S. 2689 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602285 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | ALC | H.R. 6344, Office of the National Drug Control Policy Reauthorization Act of 2006 H.R. 1424, the Paul Wellstone Mental Health and Addiction Equity Act of 2007 H.R. 1328/S. 1200, the Indian Health Care Improvement Act Amendments of 2007 S. 558, Mental Health Parity Act of 2007 H.R. 1593/S. 1060, the Second Chance Act H.R. 3992/S. 2304, the Mentally Ill Criminal Offender Treatment and Crime Reduction Act | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602286 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | CIV | H.R. 1328/S. 1200, the Indian Health Care Improvement Act Amendments of 2007 S. 1814, the Health Information Privacy and Security Act H.R. 3014, the Health Equity and Accountability Act H.R. 3333/S.1576, the Minority Health Improvement and Health Disparity Elimination Act H.R. 1593/S. 1060, the Second Chance Act H.R. 3992/S. 2304, the Mentally Ill Criminal Offender Treatment and Crime Reduction Act | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602287 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | HCR | H.R. 1571, Seniors Access to Mental Health Act of 2007 (Medicare parity) H.R. 1663, Medicare Mental Health Modernization Act of 2007 H.R. 2626, Comprehensive HealthCARE Act of 2007 (Price Healthcare Bill) H.R. 3162, Children's Health and Medicare Protection Act of 2007 H.R. 2585, Ensuring the Future Physician Workforce Act of 2007 (Burgess SGR Bill) H.R. 3025, Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2007 H.R. 3061, Medicare Part D Drug Class Protection Act of 2007 (Six Classes Bill) H.R. 820, Seniors Mental Health Access Improvement Act of 2007 (MFTs/MHCs) H.R. 1588, Seniors Mental Health Access Improvement Act of 2007 (MFTs/MHCs) H.R. 1424, Paul Wellstone Mental Health Equitable Treatment Act of 2007 S. 558, Mental Health Parity Act of 2007 H.R. 2580, Help Efficient, Accessible, Low-cost, Timely Healthcare (HEALTH) Act of 2007 S. 382/H.R. 687, Keeping Families Together Act, S. 1572/H.R. 2073, Child Health Care Crisis Relief Act of 2007, S. 1893/HR 976, Childrens Health Insurance Program Reauthorization Act of 2007 S. 1337, Childrens Mental Health Parity Act S. 2086, SCHIP Extension Act of 2007 S. 2499, Medicare, Medicaid and SCHIP extension of 2007 S. 1814, Health Information Privacy and Security Act H.R. 2406, Healthcare Information Technology Enterprise Integration Act H.R. 5442, Technologies for Restoring Users' Security and Trust in Health Information Act (TRUST Act) H.R. 493, Genetic Information Nondiscrimination Act of 2007 S. 1693/ H.R. 3800, the Wired for Health Care Quality Act S. 358/H.R. 493, Genetic Information Nondiscrimination Act of 2007 H.R. 2260, Healthcare Truth and Transparency Act of 2007 H.R. 1368, the Personalized Health Information Act of 2007 H.R. 2991, Independent Health Record Trust Act of 2007 S. 2408/H.R. 4296, E-MEDS Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602288 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | VET | S. 1223, Traumatic Brain Injury Bill S. 479/H.R. 327, Joshua Omvig Suicide Prevention Act H.R. 612, Returning Service Member VA Healthcare Insurance Act of 2007 S. 117, Lane Evans Veterans Healthcare and Benefits Improvement Act of 2007 S. 713/H.R. 1268, Dignity for Wounded Warriors Act H.R. 922, Veterans Administration Mental Health Services Enhancement Act H.R. 1588, Comprehensive Assistance for Veterans Exposed to Traumatic Stressors Act of 2006 H.R. 5835, Veterans Identity and Credit Security Act of 2006 H.R. 4986, Defense Authorization Act of 2008 S. 793, Reauthorization of Traumatic Brian Injury Act S. 2689 (no title) | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602289 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | MMM | H.R. 1571, Seniors Access to Mental Health Act of 2007 (Medicare parity) H.R. 1663, Medicare Mental Health Modernization Act of 2007 H.R. 2626, Comprehensive HealthCARE Act of 2007 (Price Healthcare Bill) H.R. 3162, Children's Health and Medicare Protection Act of 2007 H.R. 2585, Ensuring the Future Physician Workforce Act of 2007 (Burgess SGR Bill) H.R. 3025, Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2007 H.R. 3061, Medicare Part D Drug Class Protection Act of 2007 (Six Classes Bill) H.R. 820, Seniors Mental Health Access Improvement Act of 2007 (MFTs/MHCs) H.R. 1588, Seniors Mental Health Access Improvement Act of 2007 (MFTs/MHCs) H.R. 2860, Health Care Access and Rural Equity (H-CARE) Act of 2007 H.R. 2050, Medicaid Emergency Psychiatric Care Act of 2007 (IMD-EMTALA) H.R. 882, Access to Emergency Medical Services Act of 2007 (EMTALA) S. 1887, Medicare Access to Critical Medications Act (Six Classes Bill) H.R. 470, to provide Medicare coverage of benzodiazepines and off-label uses of certain prescription drugs, optional Medicaid coverage of Medicare prescription drug cost-sharing, and authorization for the Secretary of Health and Human Services to waive certain determinations denying Medicare prescription drug coverage S. 137, Preserving Medicare for All Act of 2007 (Cardin Healthcare Bill, Includes Benzos) S. 588, Physician Shortage Act S. 1715, Medicare Mental Health Copayment Equity Act of 2007 S. 2499, Medicare, Medicaid, and SCHIP Extension Act S. 2785, to amend title XVIII of the Security Act to preserve access to physicians' services under the Medicare program H.R. 5445, Ensuring the Future Physician Workforce Act of 2007 (physician payment under Medicare) | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602290 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | BUD | S.338/H.R. 985, Bipartisan Commission on Medicaid Act S. 1710/H.R. 3043, Labor Health and Human Services Appropriations for 2008 S. 1645/H.R. 2642, Military Quality of Life and Veterans Affairs Appropriations for 2008 S. 1932/H.R. 4241, 2006 Deficit Reduction and Budget Reconciliation Act H.R. 1591, 2007 War Supplemental H.R. 2206, 2007 War Supplemental H.J. Res 32, Continuing Funding Resolution H.R. 3043, Omnibus Funding of 2008 Defense Appropriations for 2009 Military Quality of Life and Veterans Affairs Appropriations for 2009 Labor Health and Human Services Appropriations for 2009 S.Con.Res.70, Budget resolution FY 2009 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602291 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | FAM | S. 382/H.R. 687, Keeping Families Together Act S. 1932/ H.R. 4241 Deficit Reduction Act of 2005 S. 3449 Child and Adolescent Mental Health Resiliency Act of 2006 S. 1337, Childrens Mental Health Parity Act H.R. 20, Melanie Blocker-Stokes Postpartum Depression Research and Care Act H.R. 687, Keeping Families Together Act of 2007 S. 1375, Mom's Opportunity to Access Health, Education, Research, and Support for Postpartum Depression Act or the MOTHERS Act | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602292 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | INS | H.R. 1424, Paul Wellstone Mental Health Equitable Treatment Act of 2007 S. 558, Mental Health Parity Act of 2007 H.R. 2580, Help Efficient, Accessible, Low-cost, Timely Healthcare (HEALTH) Act of 2007 H.R. 2626, Comprehensive HealthCARE Act of 2007 (Price Healthcare Bill) H.R. 2132, Small Business Health Plans Act of 2007 (AHPs) H.R. 493, Genetic Information Nondiscrimination Act of 2007 H.R. 4848, To extend for one year parity in the application of certain limits to mental health benefits, and for other purposes. | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602293 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | CSP | H.R. 2260, Healthcare Truth and Transparency Act of 2007 S. 1814, the Health Information Privacy and Security Act S. 1693, the Wired for Health Care Quality Act S. 358/H.R. 493, Genetic Information Nondiscrimination Act of 2007 H.R. 1368, the Personalized Health Information Act of 2007 H.R. 2991, Independent Health Record Trust Act of 2007 H.R. 2626, Comprehensive HealthCARE Act of 2007 (Price Healthcare Bill) S. 1814, Health Information Privacy and Security Act H.R. 2406, Healthcare Information Technology Enterprise Integration Act H.R. 5442, Technologies for Restoring Users' Security and Trust in Health Information Act (TRUST Act) H.R. 493, Genetic Information Nondiscrimination Act of 2007 S. 1693/ H.R. 3800, the Wired for Health Care Quality Act S. 358/H.R. 493, Genetic Information Nondiscrimination Act of 2007 H.R. 2260, Healthcare Truth and Transparency Act of 2007 H.R. 1368, the Personalized Health Information Act of 2007 H.R. 2991, Independent Health Record Trust Act of 2007 S. 2408/H.R. 4296, E-MEDS Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602294 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | GOV | H.R. 493, Genetic Information Nondiscrimination Act of 2007 S. 1693/ H.R. 3800, the Wired for Health Care Quality Act S. 358/H.R. 493, Genetic Information Nondiscrimination Act of 2007 H.R. 2260, Healthcare Truth and Transparency Act of 2007 H.R. 1368, the Personalized Health Information Act of 2007 H.R. 2991, Independent Health Record Trust Act of 2007 S. 2408/H.R. 4296, E-MEDS Act of 2007 S. 1814, Health Information Privacy and Security Act H.R. 2406, Healthcare Information Technology Enterprise Integration Act H.R. 5442, Technologies for Restoring Users' Security and Trust in Health Information Act (TRUST Act) | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602295 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | PHA | S. 45/H.R. 896, to lift the patient limitation on prescribing drug addiction treatments by medical practitioners in group practices, S. 1082, Prescription Drug User Fee Amendments of 2007 H.R. 2900, The FDA Amendments Act Promoting Quality and Efficient Health Care in Federal Government Administered or Sponsored, Executive Order; 2006 S. 2408/H.R. 4296, E-MEDS Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602296 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | MED | H.R. 20, Melanie Blocker-Stokes Postpartum Depression Research and Care Act S. 1375, Mom's Opportunity to Access Health, Education, Research, and Support for Postpartum Depression Act or the MOTHERS Act | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602297 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | WEL | H.R. 3162, Children's Health and Medicare Protection Act of 2007 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-04:00 | |
| 602298 | AMERICAN PSYCHIATRIC ASSOCIATION 2d05a77e-e534-4c0d-996d-e6ed196b4471 | Q1 | AMERICAN PSYCHIATRIC ASSOCIATION | 3151 | AMERICAN PSYCHIATRIC ASSOCIATION | 2008 | first_quarter | LAW | H.R. 297, the NICS Improvement Act of 2007 H.R. 2580, the Help Efficient, Accessible, Low-cost, Timely Healthcare (HEALTH) Act of 2007 H.R. 2220, the Mental Health Security for Americas Families in Education Act of 2007 H.R. 3992/S. 2304, the Mentally Ill Criminal Offender Treatment and Crime Reduction Act H.R. 1593/S. 1060, the Second Chance Act Congressional Hearings on the Use of Torture Intelligence Authorization for 2009 Intelligence Authorization for 2008 | Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Justice, Dept of (DOJ),Natl Institute of Mental Health (NIMH),Office of Management & Budget (OMB),Office of Personnel Management (OPM),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 127101 | 0 | 0 | 2008-04-18T17:25:02-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);