lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3148859 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | NAT | Lake Tahoe Restoration Act, Forest Health, Watershed Restoration, FY24 appropriations, FY25 appropriations | HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service | 20000 | 0 | 0 | 2024-04-17T13:49:32-04:00 | |
| 3148860 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | CAW | Lake Tahoe Restoration Act funding, FY24 appropriations, FY25 appropriations, Water Resources Development Act. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2024-04-17T13:49:32-04:00 | |
| 3148861 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | BUD | Funding for the Lake Tahoe Restoration Act, funding for priority transportation projects in the Tahoe Basin, Lake Tahoe Restoration Act Extension Act, FY24 appropriations, FY25 appropriations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2024-04-17T13:49:32-04:00 | |
| 3148862 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | TRA | Funding for priority projects in the Tahoe Basin; appropriations; surface transportation authorization; FY24 appropriations | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 20000 | 0 | 0 | 2024-04-17T13:49:32-04:00 | |
| 3148863 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | TOU | Grant programs, S. 1516 The Transportation Resources Adding Vital Economic Longevity (TRAVEL) Act in support of infrastructure for the travel and tourism industry | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2024-04-17T13:49:32-04:00 | |
| 3148864 | R&R PARTNERS, INC. c8e5bc2d-e76f-4dcf-9a26-ea84d1e7301a | Q1 | R&R PARTNERS, INC. | 308833 | TAHOE REGIONAL PLANNING AGENCY | 2024 | first_quarter | DIS | Emergency response and restoration relating to wildfires, FY24 appropriations, FY25 appropriations | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2024-04-17T13:49:32-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);