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

11 rows where filing_uuid = "dd308e33-fd01-476d-8d82-107bb6052182" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 11

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
622233 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter TRD Enhancement to trade, sanctions and human rights through sanction reform acts, Libya trade issues, Burma sanctions ILSA changes and continuing issues Sudan sanctions, Nigerian Minimum Content Legislation Alien tort claims Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622234 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter TRA Reauthorization of the Highway Bill, Safe Truckers Act Transportation Equity Act FAA Reauthorization, HR 2881 Rail Transit Security Act Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622235 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter TAX Tax reduction legislation Tax legislation covering foreign tax credits and capital gains Tax extenders, Transparency & EITI Energy tax bills, HR 6, HR 2776 Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622236 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter FOR FY 2008 Foreign appropriations bill funding EX-IM, OPIC, TDA HR 2798, Overseas Private Investment Reauthorization Energy services included in the ongoing round of the WTO CFIUS Reform, S. 1610, HR 556 Foreign Investment & National Security Act of 2007, Nigerian Minimum Content Legislation Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622237 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter ENV Clean Water Restoration Act, HR 2421 Global Climate Change Security Oversight Act DOI and Related Agencies FY 2008 Appropriations Act Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622238 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter CSP Product Liability Bills Multi-party litigation reform Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622239 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter GOV Government Reform & Oversight Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622240 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter ENG Energy & energy-related bills PL 109-58 Hydraulic Fracturing HR6, HR 1180, HR 2337 Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622241 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter IMM SKIL Act, HR 1930, S. 1083 Immigration Act, S. 1639 Comprehensive Immigration Reform Act, S. 1348, S. 2611, HR 4437 H-1B Visa Program Modernization Act, S. 1351 Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622242 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter LBR Pension Preservation and Savings Plan Expansion Act, HR 4 Workforce America Competes Act, Card Check, HR 800 Executive Compensation, Alternative Dispute Resolution Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-04:00
622243 HALLIBURTON COMPANY dd308e33-fd01-476d-8d82-107bb6052182 Q2 HALLIBURTON COMPANY 17374 HALLIBURTON COMPANY 2008 second_quarter HOM Solutions available to Homeland Security Chemical Security, HR 1530 Port-Security DHS 2008 Appropriations Act, HR 2638 Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),Export-Import Bank of the United States (EXIM Bank),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Customs & Border Protection,U.S. Trade & Development Agency (USTDA),White House Office   50000 0 0 2008-07-07T11:12:25-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);