lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "1cd3057f-e8c5-4a7c-871b-e38b71925d2d" and issue_code = "TAX" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2470873 | AMERICAN FARM BUREAU FED 1cd3057f-e8c5-4a7c-871b-e38b71925d2d | Q2 | AMERICAN FARM BUREAU FED | 2285 | AMERICAN FARM BUREAU FED | 2020 | second_quarter | TAX | Support Biodiesel and Renewable Diesel Tax Credit Support Cash Accounting Support Renewable Energy Tax Credits-wind, solar Biogas Short Line Railroad Maintenance Credit (S.407 and H.R.721: Building Rail Access for Customers and the Economy Act or BRACE Act) Support Like Kind Exchange (Section 1031) Support Reduced Capital Gains Taxes Support Estate Tax Repeal Reform, HR. 218, S 215, HR 5259 Marketplace Fairness Act (S976) and Remote Transactions Party Act (H.R.2193) Cost Recovery and Depreciation Issues Jobs and Premium Protection Act, H.R. 246 to repeal the annual fee on health insurance providers enacted by the Patient Protection and Affordable Care Act Repeal Health Insurance Tax Extend Bonus Depreciation Taxes Paid by Cooperatives - HR 2147 and S1032 Unrelated Business Income Taxes Tax credits for Ag Students - HR 1770 Business Income Deduction (Sect 199) - HR 216-S1149 Craft Beverage Modernization Act S362 and HR1175 Taxation of Mutual Irrigation Companies - HR807 and S361 S.2542, Agriculture Environmental Stewardship Act of 2019 HR3744, Agriculture Environmental Stewardship Act of 2019 S.2289, Renewable Energy Extension Act of 2019 HR3961, Renewable Energy Extension Act of 2019 S.3548, CARES Act HR 6821/S 3612 Small Business Expense Protection Act Employee Retention Tax Credit -- HR 6776 Jobs Credit Act of 2020 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Education, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Federal Communications Commission (FCC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Oceanic & Atmospheric Administration (NOAA),Occupational Safety & Health Administration (OSHA),Pipeline & Hazardous Materials Safety Administration,SENATE,Small Business Administration (SBA),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Fish & Wildlife Service (USFWS),U.S. Forest Service,U.S. Trade Representative (USTR),White House Office | 931776 | 0 | 0 | 2020-07-17T10:38:30.617000-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);