home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ce3480ba-cdb2-4dc7-9dca-e9172b0db874

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence
ce3480ba-cdb2-4dc7-9dca-e9172b0db874 Q2 315978 MR. JOHN DEMING 185597 HUNTSMAN INTERNATIONAL LLC 2008 second_quarter 2008-07-07T08:09:54-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ce3480ba-cdb2-4dc7-9dca-e9172b0db874/", "filing_uuid": "ce3480ba-cdb2-4dc7-9dca-e9172b0db874", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2008, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ce3480ba-cdb2-4dc7-9dca-e9172b0db874/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "John L. Deming - president", "dt_posted": "2008-07-07T08:09:54-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "70 Lynthwaite Farm Lane", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Wilmington", "registrant_state": "DE", "registrant_zip": "19803", "registrant": {"id": 315978, "url": "https://lda.senate.gov/api/v1/registrants/315978/", "house_registrant_id": 39236, "name": "MR. JOHN DEMING", "description": null, "address_1": "70 Lynthwaite Farm Lane", "address_2": null, "address_3": null, "address_4": null, "city": "Wilmington", "state": "DE", "state_display": "Delaware", "zip": "19803", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOHN DEMING", "contact_telephone": "+1 302-379-1583", "dt_updated": "2022-04-06T16:08:19.819478-04:00"}, "client": {"id": 185597, "url": "https://lda.senate.gov/api/v1/clients/185597/", "client_id": 12, "name": "HUNTSMAN INTERNATIONAL LLC", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-19"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "H. R. 4420 - To suspend temporarily the duty on 2,4-Diamino-3-[4-(2-sulfoxyethylsulfonyl)-phenylazo]-5-[4-(2-sulfoxyethylsulfonyl)-2-sulfophenylazo]-benzenesulfonic acid potassium sodium salt. \nH. R. 4429. - To extend the suspension of the duty on Reactive Black 5 H. R. 4430 - To extend the suspension of duty on a certain chemical\n\nH. R. 4431 - To extend the suspension of duty on a certain chemical\n\nH. R. 4432 - To extend the suspension of duty on a certain chemical\n\nH. R. 4961 - To extend the temporary suspension of duty on 7,7 -[1,3-Propanediylbis[imino(6-fluoro-1,3,5-triazine-4,2-diyl)imino[2-[(aminocarbonyl)amino]-4,1-phenylene]azo]]bis-, sodium salt\n\nH. R. 4962 - To extend the temporary suspension of duty on Vat Black 25\n\nH. R. 4970 - To suspend temporarily the duty on 1,4-Benzenedisulfonic acid, 2,2' \n-[(1-methyl-1,2-ethanediyl)bis[imino(6-fluoro-1,3,5-triazine-4,2-diyl)imino(1-hydroxy-3-sulfo-6,2-naphthalenediyl)azo]]bis[5-methoxy-, sodium salt.\n\nH. R. 4971 - To suspend temporarily the duty on Cobaltate(2-), [6-amino-.kappa.N)-5-[[2hydroxy-.kappa.O)-4-nitrophenyl]azo-.kappa.N1]-N-methyl-2-naphthalenesulfonamidato(2-)][6-(amino-.kappa.N)-5-[[2-(hydroxy-.kappa.O)-4-nitrophenyl]azo-.kappa.N1]-2-naphthalenesulfonato(3-)]-, disodium. \n\nH. R. 4972 - To suspend temporarily the duty on 2 ,7 -Naphthalenedisulfonic acid, 5-[[4-chloro-6-[[2 -[[4-chloro-6-[[7 -[[4-(ethenylsulfonyl)phenyl]azo]-8-hydroxy-3,6-disulfo-1-naphthalenyl]amino]-1,3,5-triazin-2 -yl]amino]ethyl](2 -hydroxyethyl)amino]-1,3,5-triazin-2 -yl]amino]-3-[[4-(ethenylsulfonyl)phenyl]azo]-4-hydroxy-, sodium salt\n\nH. R. 5162 - To suspend temporarily the duty on a certain chemical used in the production of textiles\n\nH. R. 5163 - To suspend temporarily the duty on a certain chemical that is used for dyeing apparel home textiles. \n\nH. R. 5164 - To suspend temporarily the duty on a certain chemical that is used for dyeing apparel home textiles\n\nH. R. 5165 - To extend the temporary suspension of duty on 4-Anilino-3-nitro-N-phenylbenzenesulphonamide. \n\nH. R. 5166 - To suspend temorarily the duty on 2,7-Naphthalenedisulfonic acid, 5-((4-chloro-6-((2-(2-(ethenylsulfonyl)ethoxy)ethyl)amino)-1,3,5-triazin-2-yl)amino)-3-((4-(ethenylsulfonyl)phenyl)azo)-4-hydroxy-, potassium sodium salt \n.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 8891, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "DEMING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 98, "name": "U.S. International Trade Commission (ITC)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DE US 39236 TX   US US   0 0 2052858   normalized_name 0.7

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 9.74ms