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_uuid = "92e51191-e4d7-4740-b21e-507cf50c8c19" and issue_code = "TEC" 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

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
709045 NATIONAL TELECOMMUNICATIONS COOPERATIVE ASSOCIATION 92e51191-e4d7-4740-b21e-507cf50c8c19 Q4 NATIONAL TELECOMMUNICATIONS COOPERATIVE ASSOCIATION 28674 NATIONAL TELECOMMUNICATIONS COOPERATIVE ASSOCIATION 2008 fourth_quarter TEC Monitored, reacted to, and/or developed proposals and/or initiatives that will impact the operations of rural telecommunications providers, their consumers, and/or the association. With regard to the measures listed below, the association is committed to pursuing a policy environment that allows the associations members to continue effectively serving rural economically challenging markets. The association bases its approaches on whether or not policies are flexible in their application to rural carriers that have different needs and capabilities and that have far different economies of scale and competitive opportunities than larger carriers. There were issues where the association did not focus on legislation itself, but rather focused on concepts and worked with different members of Congress to help them understand the related issues and/or to develop and distribute some form of public statement on the given subject. For example we worked with a number of offices to try to ensure that the Federal Communications Commission understood that there were many members of Congress that are opposed to a drastic modifications in the universal service and intercarrier compensation cost recovery mechanisms that rural providers rely upon. We also routinely discuss access to spectrum, video programming and its equitable distribution and data transmission and all that entails. During the reporting period, in addition to discussing the issues outlined above, association representatives specifically discussed the following bills with policymakers: Broadband Deployment: H.R. 3428 -- To facilitate the deployment by the private sector of broadband telecommunications networks and capabilities (including wireless and satellite networks and capabilities) to underserved rural areas through federal grants and loans-all sections. Government Owned Networks: H.R. 3281 To promote competition and to preserve the ability of local governments to provide broadband capability and services all sections. S. 1853 To promote competiti… Agriculture, Dept of (USDA),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE   50000 0 0 2009-01-16T11:03:22-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);