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

5 rows where filing_uuid = "c00a67ad-9cdf-4678-af8e-cdf49e7a8704" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

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
2428727 FEDERAL SCIENCE PARTNERS LLC c00a67ad-9cdf-4678-af8e-cdf49e7a8704 Q1 FEDERAL SCIENCE PARTNERS LLC 401103311 MONTEREY BAY AQUARIUM 2020 first_quarter MAR S. ___ Marine Aquaculture Legislation S. 910, the National Sea Grant College Program Amendments Act sponsored by Senators Roger Wicker (R-MS) and Brian Schatz (D-HI). This bill would authorize appropriations for the Sea Grant until FY 2024; HR 2405, Sea Grant Reauthorization Act sponsored by Rep Jared Huffman (D-CA); S. 877, the Shark Fin Trade Elimination Act sponsored by Senators Cory Booker (D-NJ) and Shelley Moore Capito (R-WV), which would prohibit the sale of shark fins or products containing shark fins; S. 494, the American Fisheries Advisory Committee Act, sponsored by Senators Dan Sullivan (R-AK), Maria Cantwell (D-WA), and Ed Markey (D-MA). This bill would establish the American Fisheries Advisory Committee to assist in the awarding of fisheries research and development grants by NOAA; S. 914, the Coordinated Ocean Observations and Research Act, sponsored by Senators Roger Wicker (R-MS) and Maria Cantwell (D-WA). This bill would reauthorize the Integrated Coastal and Ocean Observation System Act of 2009 and the establishment of a National Water Center; S. 906, the Driftnet Modernization and Bycatch Reduction Act, sponsored by Senators Dianne Feinstein (D-CA) and Shelley Moore Capito (R-WV). This bill Direct the Secretary of Commerce to conduct a transition program to facilitate the adoption of alternative fishing gear and to make grants to affected fishers through the Bycatch Reduction Engineering Program and prohibit the use of large-scale driftnet fishing not later than 5 years after the date of enactment of this Act; Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),Natl Park Service (NPS),Natl Science Foundation (NSF),SENATE,U.S. Fish & Wildlife Service (USFWS) 30000   0 0 2020-04-16T13:59:04.637000-04:00
2428728 FEDERAL SCIENCE PARTNERS LLC c00a67ad-9cdf-4678-af8e-cdf49e7a8704 Q1 FEDERAL SCIENCE PARTNERS LLC 401103311 MONTEREY BAY AQUARIUM 2020 first_quarter SCI S. 910, the National Sea Grant College Program Amendments Act sponsored by Senators Roger Wicker (R-MS) and Brian Schatz (D-HI). This bill would authorize appropriations for the Sea Grant until FY 2024; HR 2405, Sea Grant Reauthorization Act sponsored by Rep. Jared Huffman (D-CA) S. 914, the Coordinated Ocean Observations and Research Act, sponsored by Senators Roger Wicker (R-MS) and Maria Cantwell (D-WA). This bill would reauthorize the Integrated Coastal and Ocean Observation System Act of 2009 and the establishment of a National Water Center; S. ___ Marine Aquaculture Legislation - permitting, regulations, and research components climate research activities at NSF, NOAA and NASA Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),Natl Park Service (NPS),Natl Science Foundation (NSF),SENATE,U.S. Fish & Wildlife Service (USFWS) 30000   0 0 2020-04-16T13:59:04.637000-04:00
2428729 FEDERAL SCIENCE PARTNERS LLC c00a67ad-9cdf-4678-af8e-cdf49e7a8704 Q1 FEDERAL SCIENCE PARTNERS LLC 401103311 MONTEREY BAY AQUARIUM 2020 first_quarter NAT HR 3055 NOAA ocean/coastal extramural programs Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),Natl Park Service (NPS),Natl Science Foundation (NSF),SENATE,U.S. Fish & Wildlife Service (USFWS) 30000   0 0 2020-04-16T13:59:04.637000-04:00
2428730 FEDERAL SCIENCE PARTNERS LLC c00a67ad-9cdf-4678-af8e-cdf49e7a8704 Q1 FEDERAL SCIENCE PARTNERS LLC 401103311 MONTEREY BAY AQUARIUM 2020 first_quarter BUD FY21 Commerce, Justice, Science Appropriations Bill - funding for NOAA programs related to IUU enforcement, sustainable seafood, Pacific Bluefin Tuna, marine debris, STEM education, marine sanctuaries, and other ocean conservation programs Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),Natl Park Service (NPS),Natl Science Foundation (NSF),SENATE,U.S. Fish & Wildlife Service (USFWS) 30000   0 0 2020-04-16T13:59:04.637000-04:00
2428731 FEDERAL SCIENCE PARTNERS LLC c00a67ad-9cdf-4678-af8e-cdf49e7a8704 Q1 FEDERAL SCIENCE PARTNERS LLC 401103311 MONTEREY BAY AQUARIUM 2020 first_quarter ENV FY21 Interior/EPA Appropriations National Park Service and EPA - reduction of plastics in the oceans and environment and USF&S funding for Prescott program (sea otters) Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Oceanic & Atmospheric Administration (NOAA),Natl Park Service (NPS),Natl Science Foundation (NSF),SENATE,U.S. Fish & Wildlife Service (USFWS) 30000   0 0 2020-04-16T13:59:04.637000-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);