lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where filing_uuid = "84de775d-1f34-4e72-a77d-80eefe3db3aa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2481406 | OCEAN CONSERVANCY 84de775d-1f34-4e72-a77d-80eefe3db3aa | 2A | OCEAN CONSERVANCY | 8635 | OCEAN CONSERVANCY | 2020 | second_quarter | MAR | Legislation pertaining to ocean acidification, harmful algal blooms, hypoxia, red tide/blue-green algae generally, Arctic shipping, red snapper/bluefin/groundfish fishing regulations, fisheries and the Magnuson-Stevens Act generally including fishery disaster assistance, USCG PARS, implementation of EO 13840, maritime shipping, ocean exploration/mapping, climate change and our oceans, marine debris, regional ocean data portals and ocean data legislation generally. NEPA regulations regarding GHG emissions and climate change. Marine Debris: S.1982 - Save Our Seas 2.0 Act S.2660 - Save Our Seas 2.0: Improving Domestic Infrastructure to Prevent Marine Debris Act S.2364 - Save Our Seas 2.0: Enhancing the Domestic Marine Debris Response Act S.2372 - Save Our Seas 2.0: Enhanced Global Engagement to Combat Marine Debris Act H.R.3969 - SOS 2.0 Act H.R.4636 - PLASTIC Seas Act H.R.5845/S.3263/S.3944 - Break Free From Plastic Pollution Act of 2020 S.3281 - Original Recycle Bottle Act of 2020 H.R.5902/S.3306 - MICRO Plastics Act of 2020 S.3306/H.R.5902 - MICRO Plastics Act of 2020 Ocean Acidification/Harmful Algal Blooms/Water Quality: H.R.335/S.10 - South Florida Coastal Waters Act of 2019 H.R.414 - Protecting Local Communities from Harmful Algal Blooms Act H.R.462 - Everglades for the Next Generation Act H.R.988 - NEAR Act of 2019 H.R.1237 - COAST Research Act of 2019 H.R.1716/S.778 - Coastal Communities Ocean Acidification Act of 2019 H.R.1834 - Defending Our National Marine Sanctuaries from Damaging Chemicals Act of 2019 H.R.1921 - Ocean Acidification Innovation Act of 2019 H.R.2448 - Ocean Acidification Research Partnerships Act H.R.2587/S.1375 - Reef Safe Act of 2019 H.R.2588/S.1371 - Oxybenzone and Octinoxate Impact Study of 2019 H.R.3297 - Harmful Algal Bloom Essential Forecasting Act H.R.3324 - Prioritizing Revised Operations to Eliminate Cyanobacteria Toxins in Florida Act H.R.4160/S.2429 - Restoring Resilient Reefs Act of 2019 H.R.6738 - Coral Reef Conservation Reauthorization Act of 2020 S. 778 - Coastal Communi… | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),U.S. Coast Guard (USCG) | 146044 | 0 | 0 | 2020-07-20T10:57:00.453000-04:00 | |
| 2481407 | OCEAN CONSERVANCY 84de775d-1f34-4e72-a77d-80eefe3db3aa | 2A | OCEAN CONSERVANCY | 8635 | OCEAN CONSERVANCY | 2020 | second_quarter | ENG | Offshore oil and gas, OCSLA reforms, DoI five year plan, offshore oil safety rules (well control rule), oil spill response, offshore wind energy, port energy infrastructure, CZMA consistency, renewable marine energy resources. H.R.205 - Protecting and Securing Floridas Coastline Act of 2019 H.R.279 - California Clean Coast Act of 2019 H.R.286 - Florida Coastal Protection Act H.R.287 - New England Coastal Protection Act H.R.291 - Coastal Economies Protection Act H.R.309 - Stop Arctic Ocean Drilling Act of 2019 H.R.310 - West Coast Ocean Protection Act of 2019 H.R.337 - Defend our Coast Act H.R.341 - COAST Anti-Drilling Act H.R.1149 - Atlantic Coastal Economies Protection Act H.R.1335 - Safe COAST Act H.R.1606/S.828 - Atlantic Seismic Airgun Protection Act H.R.1941 - Coastal and Marine Economies Protection Act H.R.2352 - Marine Oil Spill Prevention Act H.R.3585 - Bolstering Economies, Anglers, Coastal Habitats, Ecosystems and Security in Florida Act H.R.5186/S.2906 - Stop Giving Big Oil Free Money Act of 2019 H.R.5695 - Offshore Accountability Act of 2020 H.R.7024/S.4046 - Climate Smart Ports Act S.13 - Florida Shores Protection and Fairness Act S.828 - Atlantic Seismic Airgun Protection Act S.1296 - New England Coastal Protection Act S.1304 - COAST Anti-Drilling Act S.1318 - West Coast Ocean Protection Act of 2019 S.1523 - Stop Arctic Ocean Drilling Act of 2019 S.1821/H.R.3203 - Marine Energy Research and Development Act of 2019 S.3485 - OFFSHORE Act of 2020 | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),U.S. Coast Guard (USCG) | 146044 | 0 | 0 | 2020-07-20T10:57:00.453000-04:00 | |
| 2481408 | OCEAN CONSERVANCY 84de775d-1f34-4e72-a77d-80eefe3db3aa | 2A | OCEAN CONSERVANCY | 8635 | OCEAN CONSERVANCY | 2020 | second_quarter | BUD | Appropriations bills related to ocean specific issues, such as NOAA funding (marine debris, fisheries, ocean acidification, Sea Grant, regional ocean portals, Coastal Zone Management Grants, marine mammal & other species, PFMC Climate and Communities, Marine Operations & Maintenance), DOI funding (Everglades restoration, BOEM,BSEE, and other OCS related amendments and riders), Energy and Water funding (Everglades restoration), budget caps, non-defense discretionary programs, USCG funding specifically for icebreaker funds, amendments that targeted ocean related programs, and COVID-19 relief for coastal communities. H.R. 21 - Consolidated Appropriations Act H.R.266 - Department of the Interior, Environment, and Related Agencies Appropriations Act, 2019 H.R.268 - Making Supplemental Appropriations for FY 2019 H.R.648 - 2nd Consolidated Appropriations Act, 2019 H.R.748 - CARES Act H.R. 2021 - Investing for the People Act of 2019 H.R. 2157 - Additional Supplemental Appropriations for Disaster Relief Act, 2019 H.R.2405 - National Sea Grant College Program Amendments Act of 2019 H.R.2960 - Energy and Water Development and Related Agencies Appropriations Act, 2020 H.R.3052 - Department of the Interior, Environment, and Related Agencies Appropriations Act, 2020 H.R.3055 - Commerce, Justice, Science, and Related Agencies Appropriations Act, 2020 H.R. 3409 - Coast Guard Authorization Act of 2019 H.R.6074 - Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 H.R.6800 - The Heroes Act H.R.7167 - Pandemic Fishery Disaster Response Act H.J.Res.27 - FY2019 Further Additional Continuing Appropriations Act H.J.Res.28 - FY2019 Further Additional Continuing Appropriations Act H.J.Res.31 - Consolidated Appropriations Act 2019 S.2470 - Energy and Water Development and Related Agencies Appropriations Act, 2020 S.2580 - Department of the Interior, Environment, and Related Agencies Appropriations Act, 2020 S.2584 - Commerce, Justice, Science, and Related Agencies Appropriations Act, 2020 S.4049 - NDAA for FY 2… | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),U.S. Coast Guard (USCG) | 146044 | 0 | 0 | 2020-07-20T10:57:00.453000-04:00 | |
| 2481409 | OCEAN CONSERVANCY 84de775d-1f34-4e72-a77d-80eefe3db3aa | 2A | OCEAN CONSERVANCY | 8635 | OCEAN CONSERVANCY | 2020 | second_quarter | ANI | Issues pertaining to marine wildlife and protected areas, marine mammals, Marine Mammal Protection Act, the Agreement on the Conservation of Albatrosses and Petrels, proposed changes to the Endangered Species Act. Marine Wildlife and Fisheries: H.R.1568 - SAVE Right Whales Act H.R.3424 - SEA Act of 2019 H.R.4348/S.2491 - PAW and FIN Conservation Act of 2019 S.2802- Marine Mammal Research and Response Act of 2019 H.R.5552 - Migratory Bird Protection Act of 2020 S.Res 372/H.Res 835 - A resolution expressing the sense of the Senate that the Federal Government should establish a national goal of conserving at least 30 percent of the land and ocean of the United States by 2030. | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),U.S. Coast Guard (USCG) | 146044 | 0 | 0 | 2020-07-20T10:57:00.453000-04:00 | |
| 2481410 | OCEAN CONSERVANCY 84de775d-1f34-4e72-a77d-80eefe3db3aa | 2A | OCEAN CONSERVANCY | 8635 | OCEAN CONSERVANCY | 2020 | second_quarter | SCI | Issues pertaining to scientific integrity [H.R.1709/S.775 Scientific Integrity Act] and FAC Committees. | Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Oceanic & Atmospheric Administration (NOAA),Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),U.S. Coast Guard (USCG) | 146044 | 0 | 0 | 2020-07-20T10:57:00.453000-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);