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

7 rows where filing_uuid = "d90bc8b7-bfef-4e55-a16b-2b2d8ba01088" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 7

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
1733116 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter HCR James Zadroga 9/11 Health and Compensation Reauthorization Act HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733117 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter VET Veterans Protection Enhancement Act; Secure Legal Services for Veterans Act HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733118 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter FOR Walter Patterson and Werner Foerster Justice and Extradition Act HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733119 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter BUD Bulletproof Vest Partnership (BVP) grant Program Funding; Byrne Justice Assistance Grant (Byrne-JAG) Program Funding; Mentally Ill Offender Treatment and Crime Reduction Act (MIOTCRA) Grant Program Funding; Community Oriented Policing Services (COPS) Hiring Grant Funding; FY 2016 Budget Request HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733120 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter TAX Middle Class Health Benefits Tax Repeal Act; Ax the Tax on Middle Class Americans Health Plans Act; Cadillac Tax HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733121 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter RET Law Enforcement Officers Equity Act HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-04:00
1733122 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. d90bc8b7-bfef-4e55-a16b-2b2d8ba01088 Q3 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 26980 NATIONAL ASSOCIATION OF POLICE ORGANIZATIONS, INC. 2015 third_quarter LAW Drivers Privacy Protect Act; Transfer of Military Equipment to Law Enforcement Agencies; Comprehensive Justice and Mental Health Act; Bulletproof Vest Partnership Grant Program Reauthorization Act; Stop Militarizing Police Act; Body-Worn Camera Policies; Excessive Use of Force Prevention Act; Shield Our Streets Act; National Statistics on Deadly Force Transparency Act; National Criminal Justice Commission Act; Police Training and Independent Review Act; Crime Victims Fund; Law Enforcement Access to Data Stored Abroad Act (LEADS Act); Civil Asset Forfeiture; SAFE Justice Reinvestment Act; Mental Health and Safe Communities Act; Thin Blue Line Act; Federal Support for State and Local Law Enforcement; Right to Carry on USPS Property for Postal Police Officers; Criminal Justice Reform HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Office of Justice Program,SENATE,Treasury, Dept of,White House Office   40000 0 0 2015-10-16T09:54:13.430000-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);