lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2634083 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | HCR | H.R. 3 - Elijah E. Cummings Lower Drug Costs Now Act Correspondence urging opposition to the legislation and various provisions therein; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634084 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | BAN | S. Joint Res. 15 Correspondence in opposition to House passage of S.J.Res.15, the Congressional Review Act resolution to overturn the True Lender rule issued last year by the Office of the Comptroller of the Currency; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634085 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | COM | Intellectual Property/Performance Rights/Broadcast Radio: Correspondence in opposition to any reincarnation of the so-called Local Radio Freedom Act (LRFA) - legislation or a resolution by Congress calling for no imposition of new performance fee, tax, royalty, or other charge relating to the public performance of sound recordings on a local radio station for broadcasting sound recordings over the air - and urging Members of Congress to refrain from co-sponsoring such legislation; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634086 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | CON | S. 1 and H.R. 1 - For the People Act of 2021 Correspondence opposing S. 1 and H.R. 1 as contrary to the First Amendment to the United States Constitution; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634087 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | ECN | 1) S. 2071 - Broadband Reform and Investment to Drive Growth in the Economy (BRIDGE) Act of 2021 Correspondence urging opposition to the legislation, which would increase the size and scope of the federal government into inappropriate realms of broadband deployment while also limiting the Constitutionally delegated powers of states; research relating thereto. 2) Correspondence with the FCC urging greater efficiency in the Rural Digital Opportunity Fund (RDOF) subsidy program to ensure truly unserved areas are served; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634088 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | GOV | Internal Revenue Service Oversight - Correspondence urging the commencement of a formal Congressional investigation into the illegal release of private tax information by the Internal Revenue Service (IRS); research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634089 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | TRD | S. 1683 and H.R. 3035 - Preventing Foreign Attempts to Erode Healthcare Innovation Act Correspondence with United States Senate and United States House of Representatives in support of S. 1683 and H.R. 3035, legislation that would prohibit the use of funds to support a measure at the World Trade Organization waiving intellectual property rights, and for other purposes. Research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634090 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | TAX | 1) Correspondence with United States Senate and United States House of Representatives generally encouraging tax reform, including legislation to make permanent the full and immediate expensing provisions of the 2017 tax law (Section 168(k) of the Internal Revenue Code); legislation to ensure businesses can continue to fully and immediately expense research and development (R&D) costs (Section 174); and legislation to ensure depreciation and amortization costs continue to count towards business income for purposes of the business interest deduction (Section 163(j)); research relating thereto. 2) Correspondence with United States Senate and United States House of Representatives in general opposition to any effort to raise taxes on American energy, in particular discriminatory tax increases that would repeal legitimate cost recovery mechanisms like the ability to immediately expense intangible drilling costs (IDCs); research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-04:00 | |
| 2634091 | CENTER FOR INDIVIDUAL FREEDOM 18c8ea42-8d3a-493a-bc5b-c2f3ec96bf2e | Q2 | CENTER FOR INDIVIDUAL FREEDOM | 63952 | CENTER FOR INDIVIDUAL FREEDOM | 2021 | second_quarter | LBR | S. 420 and H.R. 842 - Protecting the Right to Organize Act of 2021 Correspondence in opposition to the Protecting the Right to Organize Act and various provisions therein; research relating thereto. | Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2021-07-08T11:55:46.303000-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);