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

7,927 rows where state = "Oklahoma" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
336485	336485	2020-07-15	Adair	Oklahoma	40001	160	4
336486	336486	2020-07-15	Alfalfa	Oklahoma	40003	1	0
336487	336487	2020-07-15	Atoka	Oklahoma	40005	42	0
336488	336488	2020-07-15	Beaver	Oklahoma	40007	32	0
336489	336489	2020-07-15	Beckham	Oklahoma	40009	25	0
336490	336490	2020-07-15	Blaine	Oklahoma	40011	22	0
336491	336491	2020-07-15	Bryan	Oklahoma	40013	199	1
336492	336492	2020-07-15	Caddo	Oklahoma	40015	214	11
336493	336493	2020-07-15	Canadian	Oklahoma	40017	594	3
336494	336494	2020-07-15	Carter	Oklahoma	40019	203	2
336495	336495	2020-07-15	Cherokee	Oklahoma	40021	138	1
336496	336496	2020-07-15	Choctaw	Oklahoma	40023	131	1
336497	336497	2020-07-15	Cimarron	Oklahoma	40025	1	0
336498	336498	2020-07-15	Cleveland	Oklahoma	40027	1526	40
336499	336499	2020-07-15	Coal	Oklahoma	40029	12	0
336500	336500	2020-07-15	Comanche	Oklahoma	40031	570	9
336501	336501	2020-07-15	Cotton	Oklahoma	40033	13	2
336502	336502	2020-07-15	Craig	Oklahoma	40035	29	0
336503	336503	2020-07-15	Creek	Oklahoma	40037	231	9
336504	336504	2020-07-15	Custer	Oklahoma	40039	93	0
336505	336505	2020-07-15	Delaware	Oklahoma	40041	270	17
336506	336506	2020-07-15	Dewey	Oklahoma	40043	4	0
336507	336507	2020-07-15	Ellis	Oklahoma	40045	2	0
336508	336508	2020-07-15	Garfield	Oklahoma	40047	138	2
336509	336509	2020-07-15	Garvin	Oklahoma	40049	140	3
336510	336510	2020-07-15	Grady	Oklahoma	40051	264	5
336511	336511	2020-07-15	Grant	Oklahoma	40053	3	0
336512	336512	2020-07-15	Greer	Oklahoma	40055	71	7
336513	336513	2020-07-15	Harmon	Oklahoma	40057	4	0
336514	336514	2020-07-15	Harper	Oklahoma	40059	2	0
336515	336515	2020-07-15	Haskell	Oklahoma	40061	19	0
336516	336516	2020-07-15	Hughes	Oklahoma	40063	16	0
336517	336517	2020-07-15	Jackson	Oklahoma	40065	128	3
336518	336518	2020-07-15	Jefferson	Oklahoma	40067	19	0
336519	336519	2020-07-15	Johnston	Oklahoma	40069	21	0
336520	336520	2020-07-15	Kay	Oklahoma	40071	133	9
336521	336521	2020-07-15	Kingfisher	Oklahoma	40073	54	0
336522	336522	2020-07-15	Kiowa	Oklahoma	40075	18	1
336523	336523	2020-07-15	Latimer	Oklahoma	40077	25	1
336524	336524	2020-07-15	Le Flore	Oklahoma	40079	75	1
336525	336525	2020-07-15	Lincoln	Oklahoma	40081	49	2
336526	336526	2020-07-15	Logan	Oklahoma	40083	111	1
336527	336527	2020-07-15	Love	Oklahoma	40085	49	0
336528	336528	2020-07-15	Major	Oklahoma	40093	16	1
336529	336529	2020-07-15	Marshall	Oklahoma	40095	49	0
336530	336530	2020-07-15	Mayes	Oklahoma	40097	148	5
336531	336531	2020-07-15	McClain	Oklahoma	40087	271	4
336532	336532	2020-07-15	McCurtain	Oklahoma	40089	651	12
336533	336533	2020-07-15	McIntosh	Oklahoma	40091	88	1
336534	336534	2020-07-15	Murray	Oklahoma	40099	28	0
336535	336535	2020-07-15	Muskogee	Oklahoma	40101	228	14
336536	336536	2020-07-15	Noble	Oklahoma	40103	55	1
336537	336537	2020-07-15	Nowata	Oklahoma	40105	41	1
336538	336538	2020-07-15	Okfuskee	Oklahoma	40107	20	0
336539	336539	2020-07-15	Oklahoma	Oklahoma	40109	5591	76
336540	336540	2020-07-15	Okmulgee	Oklahoma	40111	196	0
336541	336541	2020-07-15	Osage	Oklahoma	40113	228	8
336542	336542	2020-07-15	Ottawa	Oklahoma	40115	190	2
336543	336543	2020-07-15	Pawnee	Oklahoma	40117	75	3
336544	336544	2020-07-15	Payne	Oklahoma	40119	493	2
336545	336545	2020-07-15	Pittsburg	Oklahoma	40121	83	3
336546	336546	2020-07-15	Pontotoc	Oklahoma	40123	93	2
336547	336547	2020-07-15	Pottawatomie	Oklahoma	40125	178	4
336548	336548	2020-07-15	Pushmataha	Oklahoma	40127	35	0
336549	336549	2020-07-15	Rogers	Oklahoma	40131	368	7
336550	336550	2020-07-15	Seminole	Oklahoma	40133	80	3
336551	336551	2020-07-15	Sequoyah	Oklahoma	40135	73	3
336552	336552	2020-07-15	Stephens	Oklahoma	40137	102	1
336553	336553	2020-07-15	Texas	Oklahoma	40139	1007	6
336554	336554	2020-07-15	Tillman	Oklahoma	40141	27	1
336555	336555	2020-07-15	Tulsa	Oklahoma	40143	5626	79
336556	336556	2020-07-15	Wagoner	Oklahoma	40145	410	19
336557	336557	2020-07-15	Washington	Oklahoma	40147	474	39
336558	336558	2020-07-15	Washita	Oklahoma	40149	12	0
336559	336559	2020-07-15	Woods	Oklahoma	40151	11	0
336560	336560	2020-07-15	Woodward	Oklahoma	40153	15	0
333293	333293	2020-07-14	Adair	Oklahoma	40001	144	4
333294	333294	2020-07-14	Alfalfa	Oklahoma	40003	1	0
333295	333295	2020-07-14	Atoka	Oklahoma	40005	42	0
333296	333296	2020-07-14	Beaver	Oklahoma	40007	32	0
333297	333297	2020-07-14	Beckham	Oklahoma	40009	22	0
333298	333298	2020-07-14	Blaine	Oklahoma	40011	22	0
333299	333299	2020-07-14	Bryan	Oklahoma	40013	190	1
333300	333300	2020-07-14	Caddo	Oklahoma	40015	210	11
333301	333301	2020-07-14	Canadian	Oklahoma	40017	543	3
333302	333302	2020-07-14	Carter	Oklahoma	40019	186	2
333303	333303	2020-07-14	Cherokee	Oklahoma	40021	131	1
333304	333304	2020-07-14	Choctaw	Oklahoma	40023	128	1
333305	333305	2020-07-14	Cimarron	Oklahoma	40025	1	0
333306	333306	2020-07-14	Cleveland	Oklahoma	40027	1448	40
333307	333307	2020-07-14	Coal	Oklahoma	40029	12	0
333308	333308	2020-07-14	Comanche	Oklahoma	40031	517	9
333309	333309	2020-07-14	Cotton	Oklahoma	40033	12	2
333310	333310	2020-07-14	Craig	Oklahoma	40035	27	0
333311	333311	2020-07-14	Creek	Oklahoma	40037	223	8
333312	333312	2020-07-14	Custer	Oklahoma	40039	85	0
333313	333313	2020-07-14	Delaware	Oklahoma	40041	261	17
333314	333314	2020-07-14	Dewey	Oklahoma	40043	4	0
333315	333315	2020-07-14	Ellis	Oklahoma	40045	2	0
333316	333316	2020-07-14	Garfield	Oklahoma	40047	132	2

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