lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where filing_uuid = "08a2dfa6-9357-43f4-83ca-3f0923120c19" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2029078 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | DIS | flood insurance reform; national flood insurance program; HR 2548-FEMA reauthorization. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029079 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | ENV | William Wehrum nomination for EPA Assistant Administrator for Office of Air and Radiation | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029080 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | FIR | S 1514-Sportsmen's bill: lead bullets and wolves provisions. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029081 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | CHM | Bayer-Monsanto merger; pesticides. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029082 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | SMB | Hearing Small Business Act | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029083 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | MAR | Commercial Vessel Incidental Discharge Act (S. 168); Coast Guard reauthorization (S 1129) issues dealing with invasive species. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029084 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | FOO | Food waste: farm bill, date labeling (HR 3444), Good Samaritan Food Donation Act (HR 952). | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029085 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | CAW | air quality; drinking water and lead contamination; opposition to repeal of Clean Water Rule. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029086 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | DEF | National Defense Authorization Act (HR 2810/S 1519). | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029087 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | AUT | autonomous vehicles. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029088 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | BUD | FY18 budget resolution; HR 3292-Defense appropriations bill: energy and water title provisions; HR 3266/S 1609-energy and water appropriations; HR 3354-Interior and environment appropriations. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029089 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | GOV | Regulatory Accountability Act (S 951) | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029090 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | ENG | HR 2910-Promoting Interagency Coordination for Review of Natural Gas Pipelines Act and HR 2883-Promoting Cross-Border Energy Infrastructure Act: all provisions dealing with environmental reviews. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029091 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | FUE | S 517-Consumer Fuel Retailer Choice Act: E15 gasoline. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029092 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | WAS | HR 848-Agricultural and Solid Waste Disposal Act: water quality and industrial animal waste; nuclear waste. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-04:00 | |
| 2029093 | NATURAL RESOURCES DEFENSE COUNCIL 08a2dfa6-9357-43f4-83ca-3f0923120c19 | Q3 | NATURAL RESOURCES DEFENSE COUNCIL | 28867 | NATURAL RESOURCES DEFENSE COUNCIL | 2017 | third_quarter | NAT | NEPA exemption for internet towers; Endangered Species Act amendments on wolves; opposition to Barasso bill on endangered species; HR 2083-Endangered Salmon and Fisheries Predation Prevention Act (NEPA issues); HR 3668 (SHARE Act); HR 424-Gray Wolf State Management Act; HR 717-Listing Reform Act; HR 1274-State, Tribal and Local Species Transparency and Recovery Act; HR 2603-SAVES Act; HR 3131-Endangered Species Litigation Reasonableness Act; HR 210-Native American Energy Act. | HOUSE OF REPRESENTATIVES,SENATE,White House Office | 177240 | 0 | 0 | 2017-10-18T10:47:38.490000-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);