lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
15 rows where filing_uuid = "bc96f59e-6589-44e8-a96e-059142092b6c" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 770591 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | MAR | HR 1108: Grow American Supply Act; Provisions regarding impacts on energy business. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770592 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | NAT | HR 1: American Recovery and Reinvestment Act of 2009; Provisions regarding impacts oil and gas. HR 146/S 22: Omnibus Public Land Management Act of 2009; Provisions regarding access and protecting production. HR 1404: Federal Land Assistance, Management and Enhancement Act (FLAME Act); Provisions regarding access and production. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770593 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | HCR | General discussions on health care. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770594 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | TRD | HR 1: American Recovery and Reinvestment Act of 2009; Provisions regarding trade in general and buy American in particular. HR 730: Nuclear Forensics and Attribution Act; Provisions regarding impacts on foreign partners. HR 977: Derivatives Markets Transparency and Accountability Act of 2009; Provisions regarding energy trading. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770595 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | TAX | H Con Res. 85: Setting forth the congressional budget for the United States Government for fiscal year 2010 and including the appropriate budgetary levels for fiscal years 2009 and 2011 through 2014; Title III. HR 1: American Recovery and Reinvestment Act of 2009; Title I, tax provisions. HR 594: Save Our Climate Act of 2009; All provisions of the bill. HR 1105: Omnibus Appropriations Act, 2009; Provisions regarding access and new revenues. HR 1337: Americas Energy Security Trust Fund Act of 2009; All provisions of the bill. HR 1666: Safe Markets Development Act of 2009; All provisions of the bill. HR 1683: Clean Environment and Stable Energy Market Act of 2009; All provisions of the bill. General discussions regarding oil industry taxes and potential legislation. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770596 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | BUD | H Con Res 85: Setting forth the congressional budget for the United States Government for fiscal year 2010 and including the appropriate budgetary levels for fiscal years 2009 and 2011 through 2014; Provisions regarding access, oil and gas impacts and climate issues. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770597 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | ENV | HR 14: Federal Ocean Acidification Research And Monitoring Act of 2009 (FOARAM Act); Provisions regarding impacts to oil and gas business. HR 146: Omnibus Public Land Management Act of 2009; Sec. 2002, the establishment of a National Landscape Conservation System and Sec. 3202, the withdrawal of certain land in the Wyoming Range. HR 232: Greenhouse Gas Registry Act; Provisions regarding greenhouse gas impacts to oil and gas business, fuels. HR 391: To amend the Clean Air Act to provide that greenhouse gases are not subject to the Act, and for other purposes; Provisions regarding impacts to oil and gas business. HR 469: Produced Water Utilization Act of 2009; Provisions regarding impacts to oil and gas. HR 637: South Orange County Recycled Water Enhancement Act; Provisions regarding access and water used in processes. HR 1689: Carbon Capture and Storage Early Deployment Act; Provisions regarding greenhouse gas management. HR 1760: Black Carbon Emissions Reduction Act of 2009; Provisions regarding carbon management. HR 1790: Forest Carbon Emission Reduction Act; Provisions regarding carbon tax and impacts to oil and gas. HR 1796: Residential Carbon Monoxide Poisoning Prevention Act; Provisions regarding phthalate language and other impacts. HR 1862: Cap and Dividend Act of 2009; Provisions regarding carbon tax and impacts to oil and gas. S 173: Federal Ocean Acidification Research And Monitoring Act of 2009 (FOARAM Act); Provisions regarding the impact of exploration and production. General discussions and tracking regarding climate principles, carbon tax vs. cap-and trade, and hydraulic fracturing regulations. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770598 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | INS | HR 1253: Health Insurance Restrictions and Limitations Clarification Act of 2009; Provisions regarding the ability of U.S. companies to offer employees insurance without taxation. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770599 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | CHM | HR 261: Chemical Facility Security Improvement Act of 2009; Provisions regarding impacts on chemical industry. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770600 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | GOV | HR 2: Childrens Health Insurance Program Reauthorization Act of 2009; Provisions regarding new revenues. HR 384: TARP Reform and Accountability Act of 2009; Provisions regarding limiting government intervention in business, and new revenues. HR 628: To establish a pilot program in certain United States district courts to encourage enhancement of expertise in patent cases among district judges; Provisions regarding protecting U.S. patents. HR 1106: Helping Families Save Their Homes Act of 2009; Provisions regarding new revenues. HR 1260/S 515/S 610: Patent Reform Act of 2009; Provisions regarding impacts to patents. HR 1256: Family Smoking Prevention and Tobacco Control Act; Provisions regarding impacts to service stations. HR 1586: To impose an additional tax on bonuses received from certain TARP recipients; Provisions regarding protecting free enterprise and governance. HR 1617: Department of Homeland Security Component Privacy Officer Act of 2009; Provisions regarding disclosure. HR 1603: TARP Wage Accountability Act; Provisions regarding procurement issues of alternative fuels. HR 1664: To amend the executive compensation provisions of the Emergency Economic Stabilization Act of 2008 to prohibit unreasonable and excessive compensation and compensation not based on performance standards; Provisions regarding compensation. S 5: Cleaner, Greener, and Smarter Act of 2009; Provisions regarding climate impacts of business. S 290: A bill to repeal a requirement with respect to the procurement and acquisition of alternative fuels; Provisions regarding oil sands crude. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 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 | |
| 770602 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | EDU | HR 1388: Generations Invigorating Volunteerism and Education Act (GIVE Act); Provisions regarding the National Math and Science Initiative and educational signature programs. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770603 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | LBR | S 181: Lilly Ledbetter Fair Pay Act of 2009; Provisions regarding labor relations. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770604 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | FUE | HR 260: 21st Century Energy Independence Act of 2009; Provisions regarding cellulosic loans. HR 392: Boutique Fuel Reduction Act of 2009; Provisions regarding fuel issues. HR 1787: To amend the Clean Air Act regarding transportation fuels and establishment of a low carbon fuel standard; Provisions regarding impacts to gasoline production and marketing. HR 1112: E-85 Investment Act of 2009; Provisions regarding the protection of service station investments. General discussions regarding potential ethanol blendwall. | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,White House Office | 9320000 | 0 | 0 | 2009-04-20T16:02:43-04:00 | |
| 770605 | EXXON MOBIL CORP bc96f59e-6589-44e8-a96e-059142092b6c | Q1 | EXXON MOBIL CORP | 14017 | EXXON MOBIL CORP | 2009 | first_quarter | SCI | HR 531: Social Security Number Fraudulent Use Notification Act of 2009; Provisions regarding impacts to energy business. | 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);