lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

13 rows where filing_uuid = "e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 13

filing_year 1

filing_period 1

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
1418838 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter FUE Helium Stewardship Act of 2013; HR 527 and S 783 Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418839 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter RET Hybrid pension design reform and guidance; PBGC premiums; pension funding derivatives; Continuing resolution; H. Con. Res. 25, FY 2014 Budget; S. Con. Res. 8, FY 2014 Budget Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418840 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter HCR Implementation and improvements to health reform proposals; ERISA preemption, health information technology, employer wellness programs, domestic partner health plans, health savings accounts, employer plan fees, retiree health, H. Con. Res. 25 and S. Con. Res. 8, FY 2014 Budget Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418841 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter BUD Fiscal cliff resolution, H.Con. Res. 25 and S. Con. Res. 8, FY 2014 Budget Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418842 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter ENV Toxic Substances Control Act; regulation of bisphenol-A; dioxin Reform of the Toxic Substances Control Act Chemical Safety Improvement Act, S 1009 Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418843 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter GOV Regulatory reform legislation The Regulatory Accountability Act (HR 2122 and S 1029) Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418844 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter ENG Energy efficiency legislation including S. 761, Energy Savings and Industrial Competitiveness Act, S 1106 SAVE Act; exports of liquified natural gas Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418845 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter TRD Trans Pacific Partnership Market Access - India, China TTIP - Transatlantic Trade & Investment Partnership Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418846 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter MAN Policy supporting growth of manufacturing in U.S. Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418847 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter AGR Endangered Species Act Reform and FIFRA reform and guidance; APHIS guidance; Changes to the Plant Protection Act; herbicide tolerance trait regulation; 2,4-D new product approval Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418848 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter TAX Extension & expansion of research credit, renewable energy & energy efficiency tax benefits, corporate tax reform, domestic partner tax equity, international taxation, superfund taxes; H. Con. Res. 25 and S. Con. Res. 8, FY 2014 Budget Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418849 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter HOM Congressional oversight of chemical and transportation security issues and programs; Cyber Information Sharing & Protection Act (CISPA), HR 624 Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00
1418850 THE DOW CHEMICAL COMPANY, DBA DOW e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e Q2 THE DOW CHEMICAL COMPANY, DBA DOW 12527 DOW CHEMICAL COMPANY DBA DOW 2013 second_quarter TAR 112th Congress bills; not reintroduced in 113th Congress: HR 5702, To extend temporary suspension of duty on Diiodomethyl-p-tolylsulfone; HR 5703, To extend temporary suspension of duty on 2-Propenoic acid, polymer with diethenylbenzene; HR 5704, To renew the temporary suspension of duty on Methyl Hydroxyethyl Cellulose; HR 4880, To extend suspension of duty on ion-exchange resin powder, dried to less than 10 percentmoisture; HR 4881, To extend suspension of duty on an ion exchange resin comprising a copolymer of styrene crosslinked with divinylbenzene, iminodiacetic acid, sodium form; HR 4882, To extend suspension of duty on an ion exchange resin comprising a copolymer of styrene crosslinked with ethenylbenzene, aminophosphonic acid, sodium form; HR 4884, To extend temporary suspension of duty on 2-Phenylphenol sodium salt; HR 4886, To extend temporary suspension of duty on 2-Phenylphenol; HR 5346, To extend temporary suspension of duty on Macroporous; HR 5347, To extend temporary suspension of duty on certain ion-exchange resin powder; HR 5348, To temporarily suspend duty on poly(4-1-isobutoxy ethoxy)styrene-co-4-hydroxystyrene; HR 5360, To extend temporary suspension of duty on powdered ion exchange resin comprised of a copolymer of styrene, cross linked with divinyl-benzene; HR 5361, To extend temporary suspension of duty on 10,10'-Oxybisphenoxarsine; HR 5362, To suspend temporarily the duty on certain macroporus adsorpent polymers; HR 5363, To suspend temporarily the duty on 4-(1-Ethoxyethoxy) styrene-4- (t-butylcarbonyloxy) styrene-4-hydroxystyrene copolymer; HR 4996, To extend temporary suspension of duty on quinoline; HR 4997, To extend and modify temporary suspension of duty on 2-Cyanopyridine; HR 4998, To extend temporary reduction of duty on DAT intermediate; HR 4999, To extend the temporary reduction of duty on DMDS; HR 5000, To extend temporary reduction of duty on methoxyfenozide; HR 5001, To extend the temporary suspension of duty on Quintec; HR 5002, To suspend temporarily the duty on Benzamide, … Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office   2830000 0 0 2013-07-19T14:46:32.343000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);