lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "4fe2ca5a-1350-4260-ab02-e82646d32f2e" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1375327 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | TRD | Enhancement to trade security and human rights worldwide, Libya trade issues, Burma & South Sudan trade, Cuba sanctions, Alien tort claims, Argentina trade issues, Nigerian minimum content legislation, S. 45 (Offshoring Prevention Act), Export control reform, Rare Earth & Conflict minerals, Intellectual Property Protection | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375328 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | TRA | FMCSA Permitting Issues Hours of Service-Oilfield Exemptions, HR 1097 (Preserving Jobs in the Oilfield Act) | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375329 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | TAX | Tax reform legislation, Corporate tax rate Legislation covering foreign tax credits, deferral of foreign-earned income, capital gains Tax extenders, Transparency & EITI Energy tax bills | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375330 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | FOR | Presidential Nominations Sudan Referendum, Sanctions Egypt & Libya Status, Export-Import Bank Authorization, Venezuela Status, Cybersecurity | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375331 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | ENG | BLM proposed hydraulic fracturing regulation, Energy & Energy-related bills, LNG Export Issue, HR 1165 (Maximize Offshore Resource Exploration Act), HR 555 (BLM Live Internet Auctions Act), HR 771/S. 176 (South Carolina Offshore Drilling Act/OCS Leasing Program) | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375332 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | IMM | H1-B Visa reform, L-Visas, Comprehensive immigration reform | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
| 1375333 | HALLIBURTON COMPANY 4fe2ca5a-1350-4260-ab02-e82646d32f2e | Q1 | HALLIBURTON COMPANY | 17374 | HALLIBURTON COMPANY | 2013 | first_quarter | ENV | Provisions related to TSCA, HR 1154 (BREATHE Act), S. 15/HR 367 (REINS Act) | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Overseas Private Investment Corp (OPIC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade & Development Agency (USTDA),U.S. Trade Representative (USTR) | 0 | 0 | 2013-04-17T15:10:03.890000-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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,
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);