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

1 row where filing_uuid = "caa5b044-6e2e-4a00-99cd-fd3fa2143fb8" and issue_code = "FAM" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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
990048 AMERICAN HUMANE ASSOCIATION caa5b044-6e2e-4a00-99cd-fd3fa2143fb8 Q3 AMERICAN HUMANE ASSOCIATION 2593 AMERICAN HUMANE ASSOCIATION 2010 third_quarter FAM Protecting Incentives for Adoption of Children with Special Needs of 2009 (HR 1840/S 735) Keeping Parents and Communities Engaged Act (S 1411) Humane Enforcement and Legal Protections (HELP) for Separated Children Act (HR 3531) Responsible Fatherhood and Healthy Families Act of 2009 (HR 2979/S 1309) National Adoption Day & National Adoption Month (HRES 358/SRES 291) School Choice for Foster Kids Act (HR 2072) Essential Oral Health Care Act of 2009 (HR 2220) Early Support for Families Act (HR 2667) Medicaid Servcices Restoration Act (S 1217) Child Abuse Prevention and Treatment Act White House Conference on Children and Youth in 2010 Act (HR 618/S 938) Stop Child Abuse in Residential Programs for Teens Act of 2009 (HR 911) Education Begins at Home Act (HR 2205/S 244) Child Welfare Improvement Act (S 2837) Preventing Harmful Restraint and Seclusion in Schools Act (HR 4247/S 2860) Resource Family Recruitment and Retention Act of 2009 (S 410) Educational Success for Children and Youth Without Homes Act (S 2800) Fostering Success in Education Act (S 2801) Vision Care for Kids Act of 2009 (HR 577/S 259) All Healthy Children Act of 2009 (HR 747) Children's Mental Health Parity Act (S 77) Kid's Come First Act of 2009 (S 142) Patient Protection and Affordable Care Act (HR 3590) Affordable Health Care for America Act (HR 3962) Children's Budget Act (HR 3772) Immigration Oversight and Fairness Act (HR 1215) Humane Enforcement and Legal Protections for Separated Children Act (S 3522/HR 3531) HOUSE OF REPRESENTATIVES,SENATE     0 0 2010-10-12T11:18:25.117000-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);