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

3 rows where filing_uuid = "bde1b801-400a-449b-99e5-9fda7a8fb563" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 3

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
480982 HUMAN RIGHTS FIRST bde1b801-400a-449b-99e5-9fda7a8fb563 YY HUMAN RIGHTS FIRST 293494 HUMAN RIGHTS FIRST 2006 year_end FOR H.R. 5522: Foreign Operations, Export Financing, and Related Programs Appropriations Act 2007, Section 578, Secretary of State submission of a report to the Committees on Appropriations detailing progress on human rights made by the Indonesian Government Meetings with Members of Congress and Executive Officials to discuss increasing US support for a political solution to the crisis in Darfur, Sudan, including asking for more government attention to and support for the "commanders conference" and the Darfur-Darfur Dialogue and Consultation Working towards the appointment of a UN envoy for the crisis in Darfur, Sudan and support for former Secretary-General Kofi Annan's envoy H.Res 1081: Expressing the sympathy of House of Representatives to the families of women and girls murdered in Guatemala and encouraging the Government of Guatemala to bring an end to these crimes Worked to draw attention to the issue of increased attacks against human rights defenders in Colombia Participated in certification meeting of US Aid to Colombia and lobbied in relation the certification, in relation to specific cases of attacks against individual human rights defenders and in relation to country human rights reports Lobbied members of Guatemala country desk and Democracy, Human Rights and Labor at State Department regarding individual human rights defenders cases H.R. 5522: Foreign Operations, Export Financing, and Related Programs Appropriations Act 2007, Section 572(2) Of the funds appropriated under the heading "Foreign Military Financing Program" not less than ten million dollars for assistance to Indonesia 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
480983 HUMAN RIGHTS FIRST bde1b801-400a-449b-99e5-9fda7a8fb563 YY HUMAN RIGHTS FIRST 293494 HUMAN RIGHTS FIRST 2006 year_end IMM H.R. 5918: a bill to amend the Immigration and Naturalization Act to protect refugees and asylum seekers by solving problems with the “material support” bar, Sections 1, 2, and 3 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
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);