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 = "bde1b801-400a-449b-99e5-9fda7a8fb563" and issue_code = "CIV" 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
480984 HUMAN RIGHTS FIRST bde1b801-400a-449b-99e5-9fda7a8fb563 YY HUMAN RIGHTS FIRST 293494 HUMAN RIGHTS FIRST 2006 year_end CIV S.3861: A bill to facilitate bringing to justice terrorists and other unlawful enemy combatants through full and fair trials by military commissions, and for other purposes S.3886: A bill to authorize military commissions to bring terrorists to justice, to strengthen and modernize terrorist surveillance capabilities, and for other purposes S.3901: An original bill to authorize trial by military commission for violations of the law of war, and for other purposes S.3929: A bill to authorize military commissions to bring terrorists to justice, to strengthen and modernize terrorist surveillance capabilities, and for other purposes S.3930: A bill to authorize trial by military commission for violations of the law of war, and for other purposes S. 1937: A Bill to Set Forth Certain Requirements for Trials and Sentencing by Military Commissions and other potential legislation resulting from the Supreme Court’s decision in Hamdan v. Rumsfeld H.R. 952: Torture Outsourcing Prevention Act (Introduced in House) S. 4060: Effective Terrorist Prosecution Act of 2006 Amendment 4341 to S. 2766: To prohibit the rendition of individuals to countries if there are substantial grounds to believe the individuals will be subject to torture Nomination of William J. Haynes II to the United States Court of Appeals for the Fourth Circuit Nomination of Robert Gates to Secretary of the Department of Defense General lobbying on military commissions H.R.6054: To amend title 10, United States Code, to authorize trial by military commission for violations of the law of war, and for other purposes H.R.6166: To amend title 10, United States Code, to authorize trial by military commission for violations of the law of war, and for other purposes Defense, Dept of (DOD),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),SENATE,State, Dept of (DOS)   160000 0 0 2007-02-13T09:51:15-05: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);