lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where filing_uuid = "4eec3c5d-efb4-4b68-b5de-46a829e24cdd" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1114250 | VENABLE LLP 4eec3c5d-efb4-4b68-b5de-46a829e24cdd | Q2 | VENABLE LLP | 39941 | DYSTAR LP | 2011 | second_quarter | TRA | Duty Suspension Legislation | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2011-07-15T14:04:17.187000-04:00 | |
| 1114251 | VENABLE LLP 4eec3c5d-efb4-4b68-b5de-46a829e24cdd | Q2 | VENABLE LLP | 39941 | DYSTAR LP | 2011 | second_quarter | TAR | To suspend temporarily the duty on 2-Anthracenesulfonic acid, 1-amino-9,10-dihydro-4-[ [4-[[methyl[(4-methylphenyl) sulfony]amino]methyl]pheny]amino]-9, 10-dioxo-, sodium salt (1:1). To suspend temporarily the duty on Benz[cd]indolium, 1-ethyl-2-[1,2,3,4-tetrahydro-1- (2-hydroxyethyl)2,2,4-trimethyl-6-quinolinyl]-,chloride. To suspend temporarily the duty on 1Propanaminium, 3,3-[(9,10-dihydro-9,10-dioxo- 1,4-anthracenediyl)diimino]bis[N,N,N-triethyl-, bis(ethyl sulfate). To suspend temporarily the duty on 9,10-Anthracenedione, 1,5(or 1,8)-diamino-2-bromo- 4,8(or 4,5)-dihydroxy-. To suspend temporarily the duty on Substituted cyan acetic acid pentylester. To suspend temporarily the duty on 2-Anilino-5-cyano-(3-(substituted)-6-(substituted))-4-methylpyridine. To suspend temporarily the duty on 9,10-Anthracenedione, 1-amino-2-[4-[(hexahydro-2-oxo-1H-azepin-1-yl)methyl]phenoxy]-4-hydroxy-. To suspend temporarily the duty on b-Alanine, N-[3-(acetylamino)-4-[(2,4-dinitrophenyl)azo]phenyl]-N-(3-methoxy-3-oxopropyl)-, methyl ester. To suspend temporarily the duty on 7H-Benzimidazo[2,1-a]benz[de]isoquinolin-7- one, 9(or 10)-methoxy-. To suspend temporarily the duty on 1H-Indene-1,3(2H)-dione, 2-(4-bromo-3-hydroxy-2- quinolinyl)-. To suspend temporarily the duty on Ethanol, 2,2-[[4-[(3,5-dinitro-2-thienyl)azo] phenyl]imino]bis-, diacetate (ester). To suspend temporarily the duty on Propanenitrile, 3-[[4-[(substituted)azo]phenyl] (substituted)amino]-. To suspend temporarily the duty on 9,10-Anthracenedione, 1,1-[(6-phenyl-1,3,5- triazine-2,4-diyl)diimino]bis[3-acetyl-4-amino-. To suspend temporarily the duty on Chromate(3-), bis[3-(hydroxy-kO)-4-[[2-(hydroxy-kO)-1-naphthalenyl]azo-kN1]-7-nitro-1-naphthalenesulfonato(3-)]-, trisodium. To suspend temporarily the duty on (Alkylamino-hydroxyphenyl)azohydroxysubstituted benzene, substituted [(hydroxy-naphthalenyl) hydroxybenzene], chromium complex, sodium salt. To suspend temporarily the duty on Cuprate(4-), [2-[[3-[[substituted]-1,3,5-triazin- 2-yl]amino]-2-hydrox… | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2011-07-15T14:04:17.187000-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);