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

7 rows where filing_uuid = "91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 7

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
2032267 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter CHM TSCA Modernization TSCA Regulation of Oil & Gas Exploration and Production TSCA Reporting for Hydraulic Fracturing Risk Management & Reporting Asbestos Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032268 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter WAS Exploration and Production Waste Regulation Definition of Solid Waste TENORM Corrective Action Produced Water Remedial Actions Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032269 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter TAX Enhanced Oil Recovery (CO2) Tertiary Injectants 45(Q) Tax Credit for Sequestered CO2 Enhanced Oil Recovery Credit Incentives for Increasing Carbond Capture Storage & Transportation FUTURE Act Public Financing of Infrastructure Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032270 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter ENV Superfund Oil Spill Remediation Brownfields Remediation RCRA Corrective Action Natural Resource Damages Financial Assurance Requirements Wastes from E&P Activities Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032271 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter ENG Carbon Capture and Storage Enhanced Oil Recovery Regulation of Hydraulic Gracturing Electricity Reliability Export of Oil and Natural Gas CO2 Pipelines Natural Gas Pipelines Oil Pipelines Federal Lands Endangered Species Greenhouse Gas Reporting for Carbon Capture Energy Infrastructure Financing Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032272 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter CAW Carbon Capture and Storage Greenhouse Gas Reporting Regulation of Hydraulic Gracturing Clean Air and Water (Quality) Oil and Gas NSPS/NESHAPS Rule Modeling for Air Quality Compliance NAAQS OZONE CO2 Enhanced Oil Recovery Definition of Waters of the United States Effluent Limitation Guidelines Methane Emissions & Regulation VOC Emission from E&P Activities Fugitive Air Emission Emission Factor Affirmative Defense Aggregation UIC Permitting Flaring of Natural Gas Acquifer Exemptions Risk Management Planning FUTURE Act Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-04:00
2032273 OCCIDENTAL PETROLEUM CORPORATION 91bd4ad5-4e8e-4ae2-bbc4-6dd9d2bdd8f0 Q3 OCCIDENTAL PETROLEUM CORPORATION 29994 OCCIDENTAL PETROLEUM CORPORATION 2017 third_quarter NAT Enhanced Oil Recovery Endangered Species Act Carbon Capture and Storage Natural Resources Damages Assessment Oil Spill Response Hydraulic Fracturing E&P Federal Lands Flaring & Venting CO2 Pipelines Federal Lands Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service   1299384 0 0 2017-10-19T10:11:13.047000-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);