lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "985f2f8a-36ee-4fd5-8a79-28fa09c2156a" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1880336 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | HCR | definition of seasonal labor - STARS Act (H.R. 863) | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880337 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | IMM | Legal Workforce Act - requires e-verify (HR 1772/HR 1147) | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880338 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | ENV | Worker Protection Standard proposed rule change; general pesticide issues, spray drift, product registration; NPDES permitting; Renewable Fuel Standards- EPA proposed rule; Greenhouse Gas Emissions proposed rule; Reducing Regulatory Burden (HR 897) | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880339 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | TRD | Normalization of relations with Cuba & repeal of restrictions on export financing - S. 1049 Ag Export Expansion to Cuba Act of 2015, HR 3687 Cuba Ag Export Act, 2105 Senate Appropriations Trans Pacific Partnership agreement - vote for Congressional approval Transatlantic Trade and Investment Partnership Agreement Repeal of Country of Origin Labeling for meat (HR 2393) (HR 1314) Voluntary use of County of Origin Labeling (S. 1844) | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880340 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | AGR | Farm Bill Implementation (S954, HR 1771, HR 2642) and 2016 Ag Appropriations HR 22 (FAST Act) and HR 1314 (Budget Act) - provisions regarding rate of return cap for crop insurance Farm Bill 2018 discussions - Title 1, crop insurance, conservation | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880341 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | TRA | Water Resources and Reform Development Act Implementation and WRDA 2016 (HR 5303) S. 2848) extension of Positive Train Control requirements for transport of anhydrous ammonia- HR 22 - FAST Act | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880342 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | TAX | Estate Tax HR 6100 - change IRS intrepretation of deductions; request for Senate support of letter to IRS overall tax reform Implementation of bills passed in December: Permanently extend Section 179 small business expensing (H.R. 636) Permanently repeal the Estate Tax (H.R. 1105) Fifty percent bonus depreciation permanent (S 1660) Fifty percent bonus depreciation extended (S. 1666) All also included in Protecting Americans from Tax Hikes Act of 2015 (PATH) Senate package of two-year extension of tax extenders House Tax Reform Package- proposal to eliminate ability to deduct net business interest | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880343 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | ANI | General issues regarding livestock care in Ohio. Antibiotic and hormone use in animals; equine slaughter, Safeguard American Food Exports Act of 2015 (HR 1942); antimicrobial drug use in animals (HR 2459); black vulture depredation; Veterinary Feed Directive rules | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880344 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | LBR | OSHA interpretation of exempt farming activities definition of seasonal labor - STARS Act (H.R. 863) OSHA intrepretation of "retail facility" under Process Safety Management program | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880345 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | CAW | Legislation to limit EPA authority regarding Waters of the United States rule implementation (S 1140, HR 1732, Barrasso AMDT 347 to budget resolution). Reducing Regulatory Burdens Act of 2015 (HR 897) to eliminate duplication of pesticide regulation. Regional Conservation Partnership Program participation - funding opportunity in the Farm Bill; funds for conservation programs in the Western Lake Erie Basin. The Drinking Water Protection Act (HR 212); Safe and Secure Drinking Water Protection Act of 2015 (S. 462/HR 243); Great Lakes Assurance Program (HR 3120); NASA remote sensing program funding | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880346 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | ENG | General education and field meetings regarding oil and gas development, tax and leasing issues in Ohio; wind production tax credit; oil and gas royalty tax, solar farm development and pipeline placement and FERC jurisdiction. | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-04:00 | |
| 1880347 | OHIO FARM BUREAU FEDERATION 985f2f8a-36ee-4fd5-8a79-28fa09c2156a | Q3 | OHIO FARM BUREAU FEDERATION | 40013105 | OHIO FARM BUREAU FEDERATION | 2016 | third_quarter | FOO | Food Safety Modernization Act - all proposed rules with a focus on rule for Growing, Harvesting, Packing and Holding Produce for Human Consumption Veterinary Feed Directive rules GMO labeling legislation -Safe and Accurate Food Labeling Act of 2015 (HR 1599)(S 2609)(S.764) Food production in urban areas | Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 60000 | 0 | 0 | 2016-10-17T16:37:26.273000-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);