lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
14 rows where filing_uuid = "5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 524294 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | MAN | FAIR Act Legislation, Jones Act, HR 2830 Coast Guard Authorization Act, Climate Change, Carbon Management | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524295 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | TRA | Amendments to the Regulations Regarding Gathering Systems and Platform Activities on the OCS Under the Outer Continental Shelf Lands Act, Omnibus Energy Bill, Jones Act, Hydrogen, Renewable Fuels, Codes and Standards for Hydrogen LNG Authority, Deep Port, Authority, Surface Transportation Board Reauthorization, Africa Trade Bill, MEGA Trust Act, Department of Transportation and Related Agencies Appropriations Act, Coast Guard Authorization Act, MMS ANPR on Potential | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524296 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | TAX | Superfund Taxes, Taxation of Mineral Spirits and similar solvents, Domestic Energy Production Incentives, American Competitiveness Corporate Accountability Act, Omnibus Tax Legislation, Omnibus Energy Bill-Section 29 Tax Credit, International Tax Legislation, Windfall Profits Tax Concepts, Gulf Opportunity Zone Act, Refinery Credits, Tax Reconciliation Legislation, LIFO, FTC Issues, Investment Tax Credit for Solar, Production Tax Credit for Wind, Percentage IDC, Production Tax Credit for Wind, Hydrogen Tax Credit, S1419 Energy Advancement and Investment Act of 2007, HR2776 Renewable Energy and Energy Conservation Tax Act of 2007 | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524297 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | FOR | Economic Sanctions, Environmental & Social Issues, Political Risk Assessment, Caspian Policy, India, Pakistan, Iran-Libya Sanctions Act, China, Energy Independence, Project Finance, Russia, including Sakhalin, Energy Policy, Venezuela, Kuwait, Libya, Iraq, Algeria, Saudi Arabia, Cross Border Issues with Mexico, Brazil, Nigeria, The Fair Enforcement of Foreign Judgments Amendment, Funding from ExIm/EBRD for Russian Project, Venezuela Investments, Iraq Reconstruction | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524298 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | MAR | Port & Maritime Security, Port Security & Terrorism Prevention, Marine Mammals Issues, Coast Guard Issues, Oil Pollution Act, Oil Spill Liability Trust Fund, Oceans Policy/Ocean Commission Report, LNG Issues, Outer Continental Shelf Revenue Sharing Act, Revenue Sharing Issues, MMS 5-Year Plan, MMS Lease Sales, Restriction on Joint Bidding on OCS, US/Mexico Cross Border Issues, Outer Continental Shelf Lands Act, Interior Appropriations, Commerce, Justice & Science Appropriations, Jones Act, Coast Guard Authorization Act, OCS Permitting, Royalty Issues, Deficit Reduction Omnibus Reconciliation | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524299 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | ENV | Superfund Legislation, Clean Water Act Legislation, Climate Change Legislation, Greenhouse Gas and Carbon Management, Endangered Species Act Reform, Marine Mammals Protection Act, General Access Issues, NEPA Reform, Toxic Substances Act, Oil Pollution Act, ESA Reform, Carbon Capture and Storage, Renewables, Wind, Solar, Hydrogen, Renewable Fuels, Ozone Air Quality Legislation, Renewable Fuel Legislation/Renewable Fuel Standards | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524300 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | CHM | Chemical Site Security Legislation, Shipment of Hazardous Materials and Information Security, Hydrogen Production | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524301 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | ENG | Electricity Reform, Energy Legislation Access to Federal Lands, Refinery Issues, Gasoline Content (MTBE & Ethanol), Diesel Issues, LNG Issues, Climate Change, Strategic Petroleum Reserve, Energy Supply Demand Issues, Natural Gas Issues, Pipeline, Bio-Fuels, Coal to Liquids, Coal Gasification, Oil Shale Issues, Unconventional Oil & Gas, Energy Conservation, Renewables, Wind, Solar, Hydrogen, Renewable Fuels, Codes and Standards for Hydrogen, BLM EIS for Wind Production, S1419 Senate Energy Bill/Energy Advancement and Investment Act of 2007, HR2776 Renewable Energy and Energy Conservation Tax Act of 2007, Price Gouging Legislation, Gasoline Temperature Adjustment Legislation | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524302 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | FUE | Mineral Leasing Act and National Environmental Policy Act, Energy Supply Legislation, Distribution, or Use, Actions to Expedite Energy-Related Projects, Continental Shelf Revenue Sharing Act, Restriction on Joint Bidding on OCS, Revenue Sharing Issues, Coastal Impact Assistance, MMS 5-Year Plan, MMS Lease Sales, BLM Oil Shale Leases, Price Gouging Legislation, Interior Appropriations, Justice Appropriations, Commerce, Justice & Science Appropriations, Coast Guard Authorization Act, Marine Mammal Protection Act, OCS Permitting, Jones Act, Royalty Issues, Domestic Natural Gas, Deficit Reduction, Hurricane Recovery, Gas to Liquids, Hydrogen, Renewable Fuels, S1419 Senate Energy Bill/Energy Advancement and Investment Act of 2007, HR2776 Renewable Energy and Energy Conservation Tax Act of 2007 Ethanol Renewable Fuels, Comprehensive Energy Legislation, Refinery Issues, Gasoline Price, Gasoline Quality, Gasoline Content, Natural Gas Supply, LNG, Diesel Formulation, Bio-Fuels, Supply Demand, Coal to Liquids Issues, Outer Continental Shelf Lands Act, | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524303 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | CAW | Open Market Trading Guidance, Oceans Governance, Energy Policy, Coastal Zone Management Act, Clean Air Act, Vehicle Fuels Issues, Climate Change, GHG Legislation, NAAQS, EPA Region 10 Air Permit & OCS Regulations, EPA Region 10 NPDES Permit | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524304 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | NAT | Deepwater Royalty Relief, Access to OCS, Royalty in Kind, Royalty Valuation, Coastal Impact Assistance Coastal Zone Management Act Regulations and Legislation, OCS Moratoria on Oil & Gas Drilling, Oil & Gas Royalty Management, Interior Appropriations Bill, Energy Policy Proposals, Energy Policy & Conservation Act, Energy & Water Appropriations Bill, Heating Oil Reserve, MMS Right of Way Legislation, Coastal Zone Management Reauthorization, 5 Year Leasing Program, MMS Alternative Energy, National Energy Policy, National Petroleum Council, Omnibus Energy Bill, Gasoline Price Stabilization Act, Energy Policy Act, Coastal Zone Management Act Regulations, Oil Shale Issues, MMS Regulatory Authority Regarding Transportation and Gas Valuation, Onshore and Offshore Access, Oil Shale Related Matters, Environmental Policy Act, Outer Continental Shelf Leasing Act, and National Environmental Policy Act, Deficit Reduction, Outer Continental Shelf Revenue Sharing Act, Deficit Reduction Act, Revenue Sharing Issues, MMS 5-Year Plan, MMS Lease Sales, Restriction on Joint Bidding on OCS, US/Mexico Cross Border Issues, Outer Continental Shelf Lands Act, Energy Supply Legislation, Distribution, or Use, Actions to Expedite Energy-Related Projects, Implementation of Section 639 of Energy Bill, Marine Mammal Permitting, Mineral Leasing Act, Hurricane Recovery, Rockies Access for Year Round Drilling, National Leasing Act, Justice Appropriations, Commerce, Justice & Science Appropriations, Coast Guard Authorization Act, Marine Mammal Protection Act, OCS Permitting, Hurricane Recovery, Royalty in Kind, Renewables, Wind, Solar, Hydrogen, Renewable Fuels, BLM EIS for Wind Production | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524305 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | TRD | Jones Act, Coast Guard Authorization Act | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524306 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | GOV | Department of the Interior Appropriations, Outer Continental Shelf Revenue Sharing, Revenue Sharing Issues, Restriction on Joint Bidding on OCS, Energy Supply Issues, Distribution, or Use, Actions to Expedite Energy-Related Projects, Justice Appropriations, Commerce Justice & Science Appropriations, Coast Guard Authorization Act, OCS Permitting, Jones Act, Royalty Issues, Outer Continental Shelf Lands Act, Deficit Reduction, Deep Ocean Energy Act of 2006, Gulf of Mexico Energy Security Act of 2006, Anti-Trust re Energy Markets, Renewables, Wind, Solar, Hydrogen, Renewable Fuels, Production Tax Credit for Wind, Hydrogen Tax Credit, Codes and Standards for Hydrogen, BLM EIS for Wind Production, S1419 Senate Energy Bill/Energy Advancement and Investment Act of 2007, HR2776 Renewable Energy and Energy Conservation Tax Act of 2007, S1610 CFIUS Reform Legislation, HR2264 NOPEC Energy Bill Legislation, Minerals Leasing Act, Outer Continental Shelf Leasing Act, and National Environmental Policy Act, Access to Resources, MMS Five-Year Plan, MMS Lease Sales, BLM Oil Shale Leases, OCS Cross Border Issues with Mexico, | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-04:00 | |
| 524307 | SHELL USA, INC. (FKA SHELL OIL COMPANY) 5d2afdd5-9f3b-4f02-92d4-e2430cab2eb5 | MM | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 35092 | SHELL USA, INC. (FKA SHELL OIL COMPANY) | 2007 | mid_year | CSP | Asbestos Legislation, FAIR Act, Punitive Damages Rules | Bureau of Land Management (BLM),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),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Minerals Management Service,Natl Oceanic & Atmospheric Administration (NOAA),Natl Security Council (NSC),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Coast Guard (USCG),U.S. Fish & Wildlife Service (USFWS),White House Office | 1380582 | 0 | 0 | 2007-08-13T13:19:09-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);