lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where filing_uuid = "3e044906-3db3-47f2-9d98-e2ff2dd098d0" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 598558 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | ANI | HR 2419 - Farm, Nutrition, and Bioenergy Act of 2007 | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598559 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | ALC | HR 3043/S 1710 FY08 Labor-HHS-Education Appropriations Act | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598560 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | FAM | Disabilities Savings Accounts | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598561 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | DIS | Emergency preparedness and response initiatives S 1452 Public Mental Health Emergency Preparedness Act DHS Reauthorization | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598562 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | DEF | FY09 Defense Appropriations Bills HR 1585 - FY08 House Defense Authorization Bill S 1547 - FY08 Senate Defense Authorization Bill S1196 - Mental Health Care for Our Wounded Warriors Act H.R. 2082 - Intelligence Authorization Act for FY2008 | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598563 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | CIV | HR 1246 - Military Readiness Enhancement Act HR 2015/HR 3685 - Employment Non-Discrimination Act S 1556/HR 1820 - Tax Equity for Health Plan Beneficiaries HR 3195/S 1881 ADA Restoration Act | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598564 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | HCR | HR 2073/S. 1572 - Child Health Care Crisis Relief Act HR 20 - Melanie Blocker-Stokes Postpartum Depression Research and Care Act S. 1375 - MOTHERS Act HR 1669/S 982 - Positive Aging Act of 2007 PL 108-335 Garrett Lee Smith memorial Act HR 2677 - Improved Nutrition and Physical Activity Act HR 2188/S 661 - Kinship Caregiver Support Act Bureau of Health Professions Reauthorization and Appropriations SAMHSA Reauthorization State Children's Health Insurance Program S. 1050 - Promoting Wellness for Individuals with Disabilities Act of 2007 S. 651 - Play Every Day S. 1576 - Minority Health Improvement and Health Disparity Elimination Act HR 3014 - Health Equity and Accountability Act of 2007 Americans with Disabilities Act restoration House NIST Health IT Bill Children's Mental Health HR 1108/S 625 - The Family Smoking Prevention and Tobacco Control Act HR 4232 - Improving the Quality of Mental and Substance Use Health Care Act of 2007 NIH Appropriations | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598565 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | MMM | S. 382/H.R. 687 - Keeping Families Together Act H.R. 154 - Ending the Medicare Disability Waiting Period Act of 2007 H.R. 1663 - Medicare Mental health Modernization Act of 2007 H.R. 5613 - Protecting the Medicaid Safety Net Act of 2008 Federal Medical Assistance Percentage change in economic stimulus package S. 2819 - Economic Recovery in Health Care Act of 2008 Ticket to Work Rehabilitation Services CMS payment for costs of school administration and transportation final rule Optional case management services interim final rul | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598566 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | HOU | S 1518 - McKinney-Vento Homeless Assistance Act HR 840 - Homeless Emergency Assistance and Rapid Transition to Housing Act of 2007 | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598567 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | BUD | FY09 Depts of Labor, HHS and Education and related agencies Appropriations Act (including Bureau of Health Professions, NIH, SAMHSA, CDC, NIOSH, ACF and IHS and Dept of Education Programs) FY09 Dept of Defense funding bills FY09 Dept of Homeland Security Appropriations Act (DHS) FY09 Military Construction, Military Quality of Life and Veterans Affairs funding bills FY09 Science, State, Justice, Commerce, and related agencies funding bills FL 109-271 - Violence Against Women & Dept of Justice Reauthorization Act of 2005 PL 109-365 - Lifespan Respite Care Act FY08 Supplemental Appropriations bill (NSF) | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598568 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | TOB | S. 625/H.R. 1108 Family Smoking Prevention and Tobacco Control Act | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598569 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | IMM | S 821/HR 2608 - SSI Extension for Elderly and Disabled Refugees Act S 764/HR 1308 - Legal Immigrant Children's Health Improvement Act of 2007 Medicade Proof of Citizenship Food Stamp Program and Nutrition for legal immigrants in farming legislation S 1328/HR 2221 - Uniting American Families Act of 2007 ICE Raids Family detention standards Health tracking of immigrant detainees | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598570 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | EDU | Improving Education Results for Children with Disabilities/IDEA reauthorization implementation HR 3043/S1710 - FY08 Labor-HHS-Education Appropriations FY09 Science/Justice/Commerce Appropriations Bills (including NSF) Higher Education Act Reauthorization HR 2073/S 1572 Child Health Care Crisis Relief Act PL 108-355 - Garrett Lee Smith Memorial Act HR 3430/S 1332 - Mental Health in Schools Act PL 107-110 - No Child Left Behind Act Reauthorization HR 3438 - The Bullying & Gang Reduction for Improved Education Act H. Res. 762 - Supporting the Goals of National Bullying Prevention Awareness Week Threat Assessment HR 88 - Eating Disorders Awareness, Prevention, and Education Act of 2007 S. 2708 - Caring for an Aging America Act of 2008 HR 4188 - IDEA Fairness Restoration Act | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598571 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | LBR | Addition of statistics on individuals with disabilities within the Current Population Survey | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598572 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | IND | S 1200/HR 1328 - Indian Health Care Improvement Act Amendments of 2007 S 322 (Included in S 1200/Included in HR 1328) - Indian Youth Telemental health Demonstration Project S 398 - Indian Child Protection and Family Violence Prevention act Amendments of 2007 | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598573 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | WEL | Legislative implementation of the American Psychological Association's Task Force on Socioeconomic Status Final Report Child Abuse Prevention and Treatment Act Reauthorization Institutional Abuse Against Children TANF Block Grant | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598574 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | MIA | S. 948 - Children and Media Research Advancement Act Children's Media Internet Privacy and Television Violence Interactive Media and Children's Development Media Consolidation Media Violence TV Ratings Obesity/Advertising | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598575 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | SCI | FY09 House and Senate Dept of Defense Appropriation Bills FY09 House and Senate Dept of Homeland Security Appropriation Act (DHS) FY09 Military Construction, Military Quality of Life and Veterns Affairs Appropriations Bill (VA) FY 09 Science/Justice/Commerce Appropriations Bill (including NSF, NASA &DOJ) S. 976 - Personalized Medicine | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-04:00 | |
| 598576 | AMERICAN PSYCHOLOGICAL ASSOCIATION 3e044906-3db3-47f2-9d98-e2ff2dd098d0 | Q1 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 3162 | AMERICAN PSYCHOLOGICAL ASSOCIATION | 2008 | first_quarter | LAW | H.R. 1592 - Local Law Enforcement Hate Crimes Prevention Act of 2007 S. 1105 - Matthew Shepard Local Law Enforcement Enhancement Act S. 1070 - 1783 Elder Justice Act H.R. 5654 - Families Beyond Bars Act of 2008 Juvenile Justice and Delinquency Prevention Act Reauthorization H.R. 3846 Youth Promise Act | Administration for Children & Families (ACF),Administration on Aging,Bureau of Labor Statistics (BLS),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Defense, Dept of (DOD),Education, Dept of,Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Indian Health Service,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Aeronautics & Space Administration (NASA),Natl Institute of Mental Health (NIMH),Natl Institute on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office | 133966 | 0 | 0 | 2008-04-18T11:34:19-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);