lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "fd1f1abb-eefc-41ca-a3b2-260faaa462a8" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1769638 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | TRD | Issue: US-Canada Softwood Lumber Agreement | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769639 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | TRA | HR 22: Hire Americans Heroes / DRIVE Act of 2015 (House Floor Amendment No. 14, truck weights) HR 3488: Safe, Flexible and Efficient Trucking Act of 2015 Issues: Truck weights | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769640 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | IMM | HR 2029: Consolidated Appropriations Act, 2016 (Division H, Title I, Section 112 & 113, H-2B program) HR 3020: FY 2016, Labor Health, Human Services & Related Agencies Appropriations Act (Section 108, H-2B; Report Language, Title I, H-2B) HR 3128: Department of Homeland Security Appropriations Act, 2015. (Report Language, Title IV, Research Development Training & Services - US Citizenship & Immigration Services, H-2B visas) S. 1619: Department of Homeland Security Appropriations Act, 2015. (Report Language, Title IV, Research Development Training & Services - US Citizenship & Immigration Services, H-2B visas) S. 1695: FY 2016, Labor Health, Human Services & Related Agencies Appropriations Act (Section 111, H-2B; Report Language, Title I, H-2B) Issue: H-2B visa program. | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769641 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | NAT | HR 1052: Molalla River Wild and Scenic Act (entire bill) HR 2822: FY 2016 Interior, Environment and Related Agencies Appropriations Act (Title I, Ssection 122, Northern Long Eared Bat) S. 132: Oregon & California Land Grant Act of 2015 (adjacent landowner issues: Tit. I, Sec. 2,3 & 8 & 9; Molalla: Tit. III, Sec. 321) S. 1699: Oregon Wildlands Act (section 204, Molalla River) Issues: Endangered Species Act, including USF&WS proposed listing of the long-eared bat, green building/building with wood, forest certification. | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769642 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | TAX | Brady Proposed Amendment to the Senate Amdment to HR 34: Tax Increase Prevention and Real Estate Investment Act of 2015 (Sections 201 & 212, REIT provisions) HR 2029: Consolidated Appropriations Act, 2016 (Division Q, Sections 311 & 321, REIT provisions) Issues: Timber Tax, Timber REIT & REIT Tax Issues | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769643 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | ENG | HR 8: North American Energy Security & Infrastructure Act of 2015 (Section 3141, energy codes) Issues: Biomass in energy policies, Building energy code programs, Bonneville Power Administration rates, Columbia River Treaty. | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05:00 | |
| 1769644 | WEYERHAEUSER COMPANY fd1f1abb-eefc-41ca-a3b2-260faaa462a8 | Q4 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2015 | fourth_quarter | CAW | HR 594: Waters of the U.S. Regulatory Overreach Act of 2015 (entire bill) HR 1732: Regulatory Integrity Protection Act of 2015 (entire bill) HR 2822: FY 2016 Interior, Environment and Related Agencies Appropriations Act (Title II EPA Adminstrative Provisions, biomass carbon dioxide emissions provision; Title IV General Provisions, Sec. 422 Waters of the US). S. 1645, FY 2016 Interior, Environment and Related Agencies Appropriations Act (Title II EPA General Provisions, biomass carbon dioxide emissions provisions; Title IV General Provisions, Sec. 421 Waters of the US). Issues: EPA final rule on redefining Waters of the US; EPA activity to regulate biomass carbon emissions under Clean Air Act, EPA final Clean Air Act Rule on stationary electricity generators, and climate & carbon policies; EPA human health water quality criteria. | Agriculture, Dept of (USDA),Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE | 210000 | 0 | 0 | 2016-01-15T16:38:25.770000-05: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);