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

1 row where filing_period = "third_quarter", filing_uuid = "c55830c2-914e-4f05-9103-e823a5a67c2e" and issue_code = "RES" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

  • third_quarter · 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
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);