Skip to content

Instantly share code, notes, and snippets.

@joshmeee
joshmeee / sample-CO-200rows-2026-05-19.csv
Created May 20, 2026 00:46
NewFilingAlerts 200-row Colorado SOS new-business-filing sample (2026-05-19). Schema: source_state, filing_date, entity_name, entity_type, entity_status, business_address, mailing_address, naics_code, naics_description, dba_names, ein_status, formation_country. PII-stripped (no registered agents/officers). Sample of 1.17M-row CO dataset. Contact…
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 7.
entity_name,entity_type,status,formation_date,principal_address,street,city,state,zip,filing_id,source_url,naics_code,naics_source
"DENVER GAS COMPANY, Dissolved November 30, 1874",Other,Dissolved,1869-11-13,CO,CO,,,,18691000001,https://data.colorado.gov/d/4ykn-tg5h,541990,keyword_inferred_low
"SILVER CLOUD MINING COMPANY, Dissolved January 1, 1880",Other,Dissolved,1875-12-06,CO,CO,,,,18751000001,https://data.colorado.gov/d/4ykn-tg5h,541990,keyword_inferred_low
"Silverthorn Tunnel Company, Dissolved October 5, 1901",Other,Dissolved,1881-10-05,CO,CO,,,,18811004244,https://data.colorado.gov/d/4ykn-tg5h,541990,keyword_inferred_low
"SILVER CLOUD MINING COMPANY, Dissolved January 1, 1888",Other,Dissolved,1883-02-03,CO,CO,,,,18831000001,https://data.colorado.gov/d/4ykn-tg5h,541990,keyword_inferred_low
KUNER PICKLE COMPANY,Other,Unknown,1884-07-16,CO,CO,,,,18841006478,https://data.colorado.gov/d/4ykn-tg5h,541990,keyword_inferred_low
"DENVER UNION CORPROATION, Dissolved January 17, 1983",Other,Dissolved,1886-03-29,"1