lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
13 rows where filing_uuid = "c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1752239 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | TRD | countervailing duties intellectual property rights and protection agriculture trade conflict minerals | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752240 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | CPT | Intellectual property protection and enforcement Trade secrets | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752241 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | ENG | Biofuels Industrial energy efficiency | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752242 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | BUD | H.R. 4870. Defense Appropriations, soldier protective equipments S 1558 - Fiscal 2016 Defense Appropriations | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752243 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | TAR | Duty suspensions Miscellaneous tariff bills | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752244 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | RRR | Surface Transportation Bill Reauthorization, S.808 Hazardous material transportation program Rail competition issues highway trust fund Positive Train Control extension | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752245 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | AGR | Biotechnology issues biofuels issues farm bill implementation bio-energy nutrition energy related tax provisions renewable energy pollinator issues | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752246 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | TAX | Corporate tax reform international tax reform research and experimentation tax credit renewable energy tax credits capital cost recovery extension of expiring tax code provisions repatriation taxes on foreign earnings minimum taxes on foreign earnings Bring Jobs Home to America Act (HR 3086) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752247 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | ENV | S.697, Frank R. Lautenberg Chemical Safety for the 21st Century Act(TSCA); Chemicals in Commerce Act (House discussions draft) Renewable fuels standard Clean air act FIFRA climate change ESA | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752248 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | CHM | Chemical Facilities Ant-Terrorism Standards (CFATS) Authorization FIFRA S.697, Frank R. Lautenberg Chemical Safety for the 21st Century Act(TSCA); Chemicals in Commerce Act (House discussions draft) Confidential business information/protection of trade secrets pollinator issues Congressional oversight of the President's Executive Order on chemical facility safety and security | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752249 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | FOO | Child nutrition food security biotechnology H.R.1599 Safe and Accurate Food Labeling Act of 2015 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752250 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | LBR | Immigration reform - HIB and skilled worker visas Guest worker visas | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-04:00 | |
| 1752251 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) c585b7b0-a06d-480a-b2c0-e42bb2b2c3d5 | Q3 | CORTEVA AGRISCIENCE LLC (FKA E.I. DU PONT DE NEMOURS AND COMPANY) | 12813 | CORTEVA AGRISCIENCE LLC (FKA E I DU PONT DE NEMOURS AND COMPANY) | 2015 | third_quarter | HOM | Cyber Intelligence Sharing and Protection Act (CISPA); Cybersecurity Information Sharing Act (CISA) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Executive Office of the President (EOP),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR) | 1529651 | 0 | 0 | 2015-10-20T16:08:38.277000-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);