lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "bc96f59e-6589-44e8-a96e-059142092b6c" and issue_code = "ENG" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 770601 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | ENG | HR 49: American Energy Independence and Price Reduction Act; Provisions regarding increasing oil and gas production. HR 790: Georges Bank Preservation Act; Provisions regarding liquefied natural gas and offshore production. H 871: To amend the Internal Revenue Code of 1986 to provide that the taxable income limit on the allowance for depletion shall not apply in 2008 to domestic marginal oil or gas wells; Provisions regarding marginal well taxes. HR 1143: Developing Resources Immediately and Long-Term through Leases on Our Nation's Offshore Waters Act of 2009 (DRILL NOW Act of 2009); Provisions regarding the moratorium and state petition for oil and gas production. HR 1262: Water Quality Investment Act of 2009; Provisions regarding production. HR 1811: Getting Resources Efficiently and Effectively Now Act (GREEN Act); Provisions regarding the moratorium and state petition for oil and gas production. HR 1813: Emergency Energy Cut the Red Tape Now Act of 2009; Provisions regarding downstream issues. S 32: A bill to require the Federal Energy Regulatory Commission to hold at least 1 public hearing before issuance of a permit affecting public or private land use in a locality; Provisions regarding carbon tax and production. S 286: Marginal Well Production Preservation and Enhancement Act; Provisions regarding exploration and production. S 503: No Surface Occupancy Western Arctic Coastal Plain Domestic Energy Security Act; Provisions regarding exploration and production. S 587: Western Hemisphere Energy Compact; Provisions regarding increasing oil and gas production. General discussions and tracking regarding energy markets, access to resources, domestic access, oil shale leasing, heavy oils/oil sands, DOI Draft Proposed Program for OCS 5-Year Leasing Program 2010-2015, energy policy, energy and climate change issues, energy legislation review/regional product reserve issues. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-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,
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);