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

1 row where filing_uuid = "e1cdc46c-a88d-4a3f-beb2-89ee9b8a890e" and issue_code = "TAR" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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