lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

18 rows where filing_uuid = "d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 18

filing_year 1

filing_period 1

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
623311 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_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,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623312 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter EDU Improving Education Results for Children with Disabilities/IDEA reauthorization implementation H.R. 3043/S. 1710 - FY08 Labor-HHS-Education Appropriations FY09 Science/Justice/Commerce Appropriations Bills (including NSF) House FY08 Science/State/Justice/Commerce Appropriations Bill (including NSF) Higher Education Act Reauthorization H.R. 2073/S. 1572 - Child Health Care Crisis Relief Act P.L. 108-355 Garrett Lee Smith Memorial Act H.R. 3430/S. 1332 Mental Health in Schools Act P.L. 107-110 No Child Left Behind Act Reauthorization H.R. 3438 The Bullying & Gang Reduction for Improved Education Act H.Res. 762 Supporting the Goals of National Bullying Prevention Awareness Week Threat Assessment H.R. 88 Eating Disorders Awareness, Prevention, and Education Act of 2007 S. 2708 Caring for an Aging America Act of 2008 H.R. 2343 - Education Begins at Home Act Cyberbullying legislation Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623313 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter ANI H.R. 2419 Farm, Nutrition, and Bioenergy Act of 2007 Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623314 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_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 S.1956 - Tribal Foster Care & Adoption Access Act of 2007 Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623315 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter WEL Child Abuse Prevention and Treatment Act Reauthorization H.R. 5876 - Stop Child Abuse in Residential Programs for Teens Act of 2008 H.R. 6358 - Stop Child Abuse in Residential Programs for Teens Act of 2008 (amended) TANF Block Grant Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623316 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter DEF FY09 Defense Appropriations Bills H.R. 1585 FY08 House Defense Authorization Bill S. 1547 FY08 Senate Defense Authorization Bill S. 1196 Mental Health Care for Our Wounded Warriors Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623317 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter ALC H.R. 3043/S. 1710 FY08 Labor-HHS-Education Appropriations Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623318 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter CIV H.R. 1246 Military Readiness Enhancement Act H.R. 2015/H.R. 3685 Employment Non-Discrimination Act S. 1556/H.R. 1820 Tax Equity for Health Plan Beneficiaries H.R. 3195 ADA Amendments Act Zero Tolerance policies Black Youth Resiliency Interracial Adoptions Foster Care/Guardian Ad Litem Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623319 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter HCR H.R. 2073/S. 1572 - Child Health Care Crisis Relief Act H.R. 20 - Melanie Blocker-Stokes Postpartum Depression Research and Care Act S. 1375 - MOTHERS Act H.R. 1669 /S. 982 - Positive Aging Act of 2007 P.L. 108-355 - Garrett Lee Smith Memorial Act H.R. 2677 - Improved Nutrition and Physical Activity Act H.R. 2188/S.661 Kinship Caregiver Support Act Bureau of Health Professions Reauthorization and Appropriations SAMHSA Reauthorization S. 1224 Childrens Health Insurance Program Reauthorization Act of 2007 S. 1050 Promoting Wellness for Individuals with Disabilities Act of 2007 S. 651 Play Every Day HR. 1198/S. 1069 Early Hearing Detection and Intervention Act of 2007 S. 1576 Minority Health Improvement and Health Disparity Elimination Act HR. 3014 Health Equity and Accountability Act of 2007 House NIST Health IT Bill H.R. 3195 ADA Amendments Act Developmental Disabilities Act Regulations Home and Community Based Services Regulations Transition for Youth with Serious Mental Illness Childrens Mental Health H.R. 1108/S. 625 The Family Smoking Prevention and Tobacco Control Act H.R. 4232 Improving the Quality of Mental and Substance Use Health Care Act of 2007 NIH Appropriations Federal Response to Eliminate Eating Disorders Act S. 793 Traumatic Brain Injury Act S. 358/H.R. 493 - Genetic Information Nondiscrimination Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623320 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter VET VA Appropriations Bill Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623321 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter MMM Federal Medical Assistance Percentage change in economic stimulus package Rehabilitation Services Medicaid Moratorium within the War Supplemental Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623322 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter BUD FY09 Dept 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 FY08 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 P.L. 109-365 Lifespan Respite Care Act FY08 Suplemental Appropriations Bill (NSF) Institute of Medicine Study on Geriatric Mental Health Workforce Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623323 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter FAM S. 1681/H.R. 5873 Family Leave Insurance Act of 2008 S. 400/H.R. 2851 Michelle's Law S. 3195/H.R. 6375 Health Transition Act of 2008 Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623324 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter TOB S. 625/H.R. 1108 Family Smoking Prevention and Tobacco Control Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623325 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter IMM 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 H.R. 5950 - Detainee Basic Medical Care Act of 2008 S. 2731 - PEPFAR (Specifically HIV/AIDS Travel and Immigration Ban) S. 2486/H.R. 3337 - HIV Nondiscrimination in Travel & Immigration Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623326 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_quarter SCI FY09 House and Senate Department of Defense Appropriations Bills FY09 House and Senate Department of Homeland Security Appropriations Act (DHS) FY09 Military Construction/Veteran Affairs Appropriations Bill FY09 Military Construction, Military Quality of Life and Veterans Affairs Appropriations Bill (VA) FY09 Science/Justice/Commerce Appropriations Bill (including NSF, NASA & DOJ) S. 976 Personalized Medicine H.R. 6063 FY09 NASA Authorization Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623327 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_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/H.R. 1783 -Elder Justice Act Families Beyond Bars Act Juvenile Justice and Delinquency Prevention Act Reauthorization FY 09 Commerce/Science/Justice Appropriations Bills H.R. 3846 Youth Promise Act Second Chance Act Administration for Children & Families (ACF),Administration on Aging,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00
623328 AMERICAN PSYCHOLOGICAL ASSOCIATION d8cb9c58-b5fa-4eb9-975e-b2ecb3ffb667 Q2 AMERICAN PSYCHOLOGICAL ASSOCIATION 3162 AMERICAN PSYCHOLOGICAL ASSOCIATION 2008 second_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,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 on Alcohol Abuse & Alcoholism (NIAA),Natl Institutes of Health (NIH),Natl Science Foundation (NSF),Office of Management & Budget (OMB),SENATE,Social Security Administration (SSA),Substance Abuse & Mental Health Services Administration (SAMHSA),Veterans Affairs, Dept of (VA),White House Office   165659 0 0 2008-07-09T10:42:03-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);