lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "1925b6a7-2394-4e1f-b4d2-a4e1ead389f5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1113037 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | TAX | Issues: Timber REIT and REIT Tax Issues, Cellulosic Biofuels Tax Credit, Home Mortgage Interest Deduction Tax Credit, Section 1402(a) of Title XIV of Water Resources Development Act (Harbor Maintenance Tax), Section 530 of the Fair Labor Standards Act (Independent Contractor Deduction) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113038 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | NAT | HR 752 / S 403: Designate segments of Molalla River in Oregon as components of the National Wild and Scenic Rivers System (entire bill) Issues: Northern Spotted Owl, Mount St. Helens National Volcanic Monument, Funding for Forest Legacy and Land & Water Conservation Fund | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113039 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | TRD | Issues: Canadian Softwood Lumber Agreement; Lacey Act Amendment implementation | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113040 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | IMM | Issue: H-2B visas | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113041 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | FIN | PL 111-203: Dodd-Frank Wall Street Reform and Consumer Protection Act (Business Conduct Standards related to the implementation of derivatives & swaps provisions); Issues: Use of swaps by pension funds HR 1573: To facilitate implementation of Title VII of the Dodd-Frank Wall Street Reform and Consumer Protection Act, promote regulatory coordination, and avoid market disruption (Business Conduct Standards related to the implementation of derivatives & swaps provisions) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113042 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | TRA | HR 763 / S 747: Safe & Efficient Transportation Act (entire bill) HR 801: Truck Weight Uniformity Act (entire bill) Issues: Truck weights, Georgia Port Authority deepening project | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113043 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | HOU | Public Law 111-203: Dodd-Frank Wall Street Reform and Consumer Protection Act (qualified residential mortgages) Issues: Housing market reform issues (foreclosure policy, GSE reform, interest rates, conforming loan limit, jumbo loans, home mortgage interest deduction tax credit) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113044 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | ENV | HR 2055: Military construction and veterans affairs appropriations act (green building) Issues: Green building & forest certification issues, EPA Pesticide Registration/Endangered Species Act Consultation issues; EPA Re-registration Eligibility Decision for Soil Fumigants | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113045 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | ENG | S. 559: Securing America's Future of Energy and Sustainable Technologies Act (biomass) S. 781 / H.R. 1920: Amending the Clean Air Act to conform the defintion of biomass (entire bill) Issues: Biomass in Energy Policies, Renewable Fuel Standard, Renewable/Clean Energy Standard, Bonneville Power Administration, Biomass Crop Assistance Program, Cellulosic Biofuels Tax Credit, building energy code programs | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-04:00 | |
| 1113046 | WEYERHAEUSER COMPANY 1925b6a7-2394-4e1f-b4d2-a4e1ead389f5 | Q2 | WEYERHAEUSER COMPANY | 41124 | WEYERHAEUSER COMPANY | 2011 | second_quarter | CAW | HR 199 / S 231: Protecting America's Energy and Manufacturing Jobs Act (entire bill) HR 872: Reducing Regulatory Burdens Act (entire bill) HR 910 / S 482: Energy Tax Prevention Act (entire bill) HR 2250: EPA Regulatory Relief Act (entire bill) Issues: Clean Water Act: pesticide general permits for CWA, forest roads & CWA, and other provisions that impact forestry, manufacturing & housing Clean Air Act: Boiler Maximum Achievable Control Technology (MACT) rules, EPA final PSD GHG tailoring rule, EPA deferral of biomass treatment in PSD GHG tailoring rule, other provisions that impact forest products manufacturing facilities Climate Policy: EPA GHG reporting rule, carbon offsets | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Commodity Futures Trading Commission (CFTC),Council on Environmental Quality (CEQ),Defense, Dept of (DOD),Energy, Dept of,Environmental Protection Agency (EPA),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Labor, Dept of (DOL),Office of Management & Budget (OMB),Securities & Exchange Commission (SEC),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR) | 750000 | 0 | 0 | 2011-07-14T16:26:31.710000-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);