ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,910 rows where state = "Colorado" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
334618	334618	2020-07-15	Adams	Colorado	8001	4916	159
334619	334619	2020-07-15	Alamosa	Colorado	8003	204	7
334620	334620	2020-07-15	Arapahoe	Colorado	8005	5789	352
334621	334621	2020-07-15	Archuleta	Colorado	8007	13	0
334622	334622	2020-07-15	Baca	Colorado	8009	14	0
334623	334623	2020-07-15	Bent	Colorado	8011	5	0
334624	334624	2020-07-15	Boulder	Colorado	8013	1595	74
334625	334625	2020-07-15	Broomfield	Colorado	8014	352	30
334626	334626	2020-07-15	Chaffee	Colorado	8015	123	19
334627	334627	2020-07-15	Cheyenne	Colorado	8017	5	0
334628	334628	2020-07-15	Clear Creek	Colorado	8019	21	1
334629	334629	2020-07-15	Conejos	Colorado	8021	18	0
334630	334630	2020-07-15	Costilla	Colorado	8023	22	0
334631	334631	2020-07-15	Crowley	Colorado	8025	71	1
334632	334632	2020-07-15	Custer	Colorado	8027	7	0
334633	334633	2020-07-15	Delta	Colorado	8029	86	1
334634	334634	2020-07-15	Denver	Colorado	8031	8098	397
334635	334635	2020-07-15	Douglas	Colorado	8035	1224	54
334636	334636	2020-07-15	Eagle	Colorado	8037	795	9
334637	334637	2020-07-15	El Paso	Colorado	8041	3287	119
334638	334638	2020-07-15	Elbert	Colorado	8039	67	2
334639	334639	2020-07-15	Fremont	Colorado	8043	47	0
334640	334640	2020-07-15	Garfield	Colorado	8045	448	4
334641	334641	2020-07-15	Gilpin	Colorado	8047	11	0
334642	334642	2020-07-15	Grand	Colorado	8049	29	1
334643	334643	2020-07-15	Gunnison	Colorado	8051	193	6
334644	334644	2020-07-15	Hinsdale	Colorado	8053	3	0
334645	334645	2020-07-15	Huerfano	Colorado	8055	5	1
334646	334646	2020-07-15	Jackson	Colorado	8057	8	0
334647	334647	2020-07-15	Jefferson	Colorado	8059	3118	217
334648	334648	2020-07-15	Kit Carson	Colorado	8063	36	3
334649	334649	2020-07-15	La Plata	Colorado	8067	146	1
334650	334650	2020-07-15	Lake	Colorado	8065	56	0
334651	334651	2020-07-15	Larimer	Colorado	8069	982	30
334652	334652	2020-07-15	Las Animas	Colorado	8071	11	0
334653	334653	2020-07-15	Lincoln	Colorado	8073	4	0
334654	334654	2020-07-15	Logan	Colorado	8075	641	5
334655	334655	2020-07-15	Mesa	Colorado	8077	162	0
334656	334656	2020-07-15	Mineral	Colorado	8079	17	0
334657	334657	2020-07-15	Moffat	Colorado	8081	16	1
334658	334658	2020-07-15	Montezuma	Colorado	8083	84	3
334659	334659	2020-07-15	Montrose	Colorado	8085	222	12
334660	334660	2020-07-15	Morgan	Colorado	8087	663	46
334661	334661	2020-07-15	Otero	Colorado	8089	23	1
334662	334662	2020-07-15	Ouray	Colorado	8091	12	1
334663	334663	2020-07-15	Park	Colorado	8093	33	0
334664	334664	2020-07-15	Phillips	Colorado	8095	16	0
334665	334665	2020-07-15	Pitkin	Colorado	8097	140	2
334666	334666	2020-07-15	Prowers	Colorado	8099	39	0
334667	334667	2020-07-15	Pueblo	Colorado	8101	458	32
334668	334668	2020-07-15	Rio Blanco	Colorado	8103	6	0
334669	334669	2020-07-15	Rio Grande	Colorado	8105	83	2
334670	334670	2020-07-15	Routt	Colorado	8107	86	6
334671	334671	2020-07-15	Saguache	Colorado	8109	103	2
334672	334672	2020-07-15	San Juan	Colorado	8111	2	0
334673	334673	2020-07-15	San Miguel	Colorado	8113	57	0
334674	334674	2020-07-15	Sedgwick	Colorado	8115	3	0
334675	334675	2020-07-15	Summit	Colorado	8117	294	4
334676	334676	2020-07-15	Teller	Colorado	8119	65	2
334677	334677	2020-07-15	Washington	Colorado	8121	46	0
334678	334678	2020-07-15	Weld	Colorado	8123	3105	138
334679	334679	2020-07-15	Yuma	Colorado	8125	55	0
331427	331427	2020-07-14	Adams	Colorado	8001	4847	159
331428	331428	2020-07-14	Alamosa	Colorado	8003	204	7
331429	331429	2020-07-14	Arapahoe	Colorado	8005	5734	352
331430	331430	2020-07-14	Archuleta	Colorado	8007	12	0
331431	331431	2020-07-14	Baca	Colorado	8009	14	0
331432	331432	2020-07-14	Bent	Colorado	8011	4	0
331433	331433	2020-07-14	Boulder	Colorado	8013	1572	74
331434	331434	2020-07-14	Broomfield	Colorado	8014	348	30
331435	331435	2020-07-14	Chaffee	Colorado	8015	123	19
331436	331436	2020-07-14	Cheyenne	Colorado	8017	5	0
331437	331437	2020-07-14	Clear Creek	Colorado	8019	21	1
331438	331438	2020-07-14	Conejos	Colorado	8021	18	0
331439	331439	2020-07-14	Costilla	Colorado	8023	22	0
331440	331440	2020-07-14	Crowley	Colorado	8025	71	1
331441	331441	2020-07-14	Custer	Colorado	8027	7	0
331442	331442	2020-07-14	Delta	Colorado	8029	84	1
331443	331443	2020-07-14	Denver	Colorado	8031	8011	395
331444	331444	2020-07-14	Douglas	Colorado	8035	1201	53
331445	331445	2020-07-14	Eagle	Colorado	8037	783	8
331446	331446	2020-07-14	El Paso	Colorado	8041	3224	118
331447	331447	2020-07-14	Elbert	Colorado	8039	65	2
331448	331448	2020-07-14	Fremont	Colorado	8043	46	0
331449	331449	2020-07-14	Garfield	Colorado	8045	441	3
331450	331450	2020-07-14	Gilpin	Colorado	8047	8	0
331451	331451	2020-07-14	Grand	Colorado	8049	29	1
331452	331452	2020-07-14	Gunnison	Colorado	8051	193	6
331453	331453	2020-07-14	Hinsdale	Colorado	8053	3	0
331454	331454	2020-07-14	Huerfano	Colorado	8055	5	1
331455	331455	2020-07-14	Jackson	Colorado	8057	8	0
331456	331456	2020-07-14	Jefferson	Colorado	8059	3089	217
331457	331457	2020-07-14	Kit Carson	Colorado	8063	37	3
331458	331458	2020-07-14	La Plata	Colorado	8067	146	1
331459	331459	2020-07-14	Lake	Colorado	8065	54	0
331460	331460	2020-07-14	Larimer	Colorado	8069	959	30
331461	331461	2020-07-14	Las Animas	Colorado	8071	10	0
331462	331462	2020-07-14	Lincoln	Colorado	8073	4	0
331463	331463	2020-07-14	Logan	Colorado	8075	641	5
331464	331464	2020-07-14	Mesa	Colorado	8077	153	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);