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

14 rows where filing_uuid = "c55830c2-914e-4f05-9103-e823a5a67c2e" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 14

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
2530954 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter HCR COVID at NPS HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530955 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter DIS H.R.4347 - PREPARE Act of 2019 S.4431 - Emergency Wildfire and Public Safety Act of 2020 HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530956 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter ANI S.614 - Grizzly Bear State Management Act of 2019 S.1499 - Wildlife Corridors Conservation Act of 2019 S.4589 - Endangered Species Act Amendments of 2020 HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530957 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter LAW H.R.7089 - PRIDE Act NPS Police Reform HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530958 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter ENV H.R.3879 - Simplifying Outdoor Access for Recreation Act H.R.5986 - Environmental Justice For All Act No Leg Yet General Forestry HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530959 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter GOV No Leg Yet Pendley Nomination HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530960 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter TRA H.R.2 - Moving Forward Act H.R.5449 - Road User Charge Advancement Act of 2019 HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530961 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter DEF H.R.6395 - William M. (Mac) Thornberry National Defense Authorization Act for Fiscal Year 2021 S.4049 - National Defense Authorization Act for Fiscal Year 2021 HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530962 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter VET H.R.2435 -Accelerating Veterans Recovery Outdoors Act S.1263 - Accelerating Veterans Recovery Outdoors Act S.3366 - Gold Star Families Parks Pass Act HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530963 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter BUD H.R.7092 - Great American Outdoors Act H.R.7608 - State, Foreign Operations, Agriculture, Rural Development, Interior, Environment, Military Construction, and Veterans Affairs Appropriations Act, 2021 H.R.7617 - Defense, Commerce, Justice, Science, Energy and Water Development, Financial Services and General Government, Labor, Health and Human Services, Education, Transportation, Housing, and Urban Development Appropriations Act, 2021 S.3422 - Great American Outdoors Act No Leg Yet FY21 Omnibus Appropriations HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530964 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter ENG H.R.2711 - Methane Waste Prevention Act of 2019 H.R.3225 - Restoring Community Input and Public Protections in Oil and Gas Leasing Act of 2019 H.R.4447 - Clean Economy Jobs and Innovation Act S.180 - A bill to streamline the oil and gas permitting process and to recognize fee ownership for certain oil and gas drilling or spacing units, and for other purposes S.3202 - End Speculative Oil and Gas Leasing Act of 2020 S.3330 - Fair Returns for Public Lands Act of 2020 S.4223 - Leasing Market Efficiency Act S.4641 - PEOPLE Act of 2020 S.4642 - Oil and Gas Bonding Reform and Orphaned Well Remediation Act HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530965 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter IND H.R.5153 - Indian Buffalo Management Act S.1765 - Blackfoot Clearwater Stewardship Act HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530966 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter CAW H.R.5598 - Boundary Waters Wilderness Protection and Pollution Prevention Act H.R.7575 - Water Resources Development Act of 2020 H.R.7822 - Public Health Air Quality Act of 2020 HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-04:00
2530967 NATIONAL PARKS CONSERVATION ASSOCIATION c55830c2-914e-4f05-9103-e823a5a67c2e Q3 NATIONAL PARKS CONSERVATION ASSOCIATION 28300 NATIONAL PARKS CONSERVATION ASSOCIATION 2020 third_quarter RES H.R.970 - Robert E. Lee Statue Removal Act H.R.1049 - National Heritage Area Act of 2019 H.R.1267 - B-47 Ridge Designation Act H.R.3250 - Julius Rosenwald and the Rosenwald Schools Act of 2019 H.R.3651 - To facilitate the use of certain land in Nebraska for public outdoor recreational opportunities, and for other purposes H.R.4135 - To direct the Secretary of the Interior to remove the statue to the memory and in honor of Albert Pike erected near Judiciary Square in the District of Columbia, and for other purposes H.R.4139 - To provide for the boundary of the Palo Alto Battlefield National Historic Park to be adjusted, to authorize the donation of land to the United States for addition to that historic park, and for other purposes H.R.4345 - Fort Monroe National Monument Land Acquisition Act H.R.4840 - Casa Grande Ruins National Monument Boundary Modification Act of 2019 H.R.5458 - Rocky Mountain National Park Boundary Modification Act H.R.5472 - Jimmy Carter National Historical Park Redesignation Act H.R.5853 - Great Dismal Swamp National Heritage Area Act H.R.5989 - Alabama Black Belt National Heritage Area Act H.R.7550 - Confederate Commemorative Works Inventory and Joint Resource Study Act H.R.8093 - Big Bend National Park Boundary Adjustment Act H.R.8221 - Blackwell School National Historic Site Act H.R.5990 - Bronzeville-Black Metropolis National Heritage Area Act S.1863 - Julius Rosenwald and Rosenwald Schools Study Act of 2019 S.3217 - National Heritage Area Act S.3427 - Modernizing Access to Our Public Land Act S.3241 - A bill to amend the John D. Dingell, Jr. Conservation, Management, and Recreation Act to establish the Cerro de la Olla Wilderness in the Rio Grande del Norte National Monument, New Mexico S.3363 - Alabama Black Belt National Heritage Area Act No Leg Yet African American Monuments at GETT Chesapeake Bay NRA HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE   156287 0 0 2020-10-20T14:35:52.450000-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);