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

7 rows where filing_uuid = "fca98a7b-091b-4330-94de-b0fa738cbb64" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 7

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
3092515 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter BAN infrastructure financing; proxy adviser regulations HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE 55000   0 0 2024-01-10T14:49:13-05:00
3092516 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter FIN ongoing implementation of Dodd-Frank; access to the proxy; corporate governance issues; executive compensation; public pension plan accounting and disclosure; investor (trustee) education; SEC state settlements re: bond disclosures; state of municipal securities markets; municipal adviser registration; proxy advisory services; applying the Unrelated Business Income Tax (UBIT) to the investment earnings of state and local governments retirement systems; infrastructure financing; ESG investments; Federal restrictions on investments of institutional investors; financial transactions tax; regulations implementing restrictions on stimulus aid to state and local governments related to public pensions; Implementation of the SECURE 2.0 Act of 2022; Advance Notice of Proposed Rulemaking (ANPRM) issued by Treasury entitled Provisions Pertaining to U.S. Investments in Certain National Security Technologies and Products in Countries of Concern HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of 55000   0 0 2024-01-10T14:49:13-05:00
3092517 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter RET IRS Governmental plans compliance; IRS Normal Retirement Age regulations; IRS revenue ruling 2006-43; IRS ANPRM on definition of a governmental plan; funding of governmental plans; general pension plan reform; governmental plan accounting and disclosure; disclosure of state death records; tax deferrals related to pension contributions and earnings;applying the Unrelated Business Income Tax (UBIT) to the investment earnings of state and local government retirement systems; Office of State and Local Finance public pension plan interests; the Public Employee Pension Transparency Act (PEPTA); solvency of Multiemployer Plans deliberations; reform of the windfall elimination provision (WEP); SECURE Act dealing with overall retirement security and implementation of the law; Federal restrictions on institutional investor investment activity; CARES Act stimulus checks and retired public employees not covered by Social Security; restrictions related to public pensions on any Federal aid to states in negotiations on new COVID stimulus legislation; H.R. 2954, retirement security legisltion and issues affecting public pensions; implementation of SECURE 2.0 Act of 2022; Advance Notice of Proposed Rulemaking (ANPRM) issued by Treasury entitled Provisions Pertaining to U.S. Investments in Certain National Security Technologies and Products in Countries of Concern; OMBs Office of Federal Financial Management proposed rule to revise their Uniform Administrative Requirements, Cost Principles, and Audit Requirements, stipulating how public pension costs are to be reimbursed for a state or local employee whose position is partially or fully federally funded. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE,Treasury, Dept of 55000   0 0 2024-01-10T14:49:13-05:00
3092518 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter TAX IRS Governmental plans compliance; IRS Normal Retirement Age regulations; IRS revenue ruling 2006-43; IRS ANPRM on definition of a governmental plan; funding of governmental plans; general pension plan reform; tax deferral of pension contributions and earnings; application of the Unrelated Business Income Tax (UBIT) to the investment earnings of state and local government retirement systems; Office of State and Local Finance public pension plan interests; infrastructure financing; Public Employee Pension Transparency Act (PEPTA); solvency of Multiemployer Plans deliberations (H.R.397); infrastructure financing; SECURE Act (H.R. 1994), its implementation and changes in the IRC to enhance retirement security; financial transaction tax issues; the Coronavirus Aid, Relief, and Economic Security Act (CARES) Act implementation and stimulus checks to retired public employees not covered by Social Security; implementation of SECURE 2.0 Act of 2022 HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Treasury, Dept of 55000   0 0 2024-01-10T14:49:13-05:00
3092519 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter BNK governmental bankruptcy issues; Federal aid to states HOUSE OF REPRESENTATIVES,SENATE 55000   0 0 2024-01-10T14:49:13-05:00
3092520 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter GOV implementation of pension provisions of the Puerto Rico Oversight, Management and Economic Stability Act of 2016; infrastructure financing; general Federal regulation and taxation of state and local governmental retirement systems; restrictions related to public pensions on Federal aid to states in 2021 COVID-19 stimulus package; implementation of SECURE 2.0 Act of 2022; Advance Notice of Proposed Rulemaking (ANPRM) issued by Treasury entitled Provisions Pertaining to U.S. Investments in Certain National Security Technologies and Products in Countries of Concern; OMBs Office of Federal Financial Management proposed rule to revise their Uniform Administrative Requirements, Cost Principles, and Audit Requirements, stipulating how public pension costs are to be reimbursed for a state or local employee whose position is partially or fully federally funded. HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of 55000   0 0 2024-01-10T14:49:13-05:00
3092521 MR. PETER SNELL fca98a7b-091b-4330-94de-b0fa738cbb64 Q4 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 fourth_quarter EDU general issues pertaining to teacher retirement; student loans; Federal grants covering teacher benefits; impact of COVID-19 on teachers, education support professionals, and public education; infrastructure spending related to schools, education HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Treasury, Dept of 55000   0 0 2024-01-10T14:49:13-05: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);