ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 40109 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333607 | 333607 | 2020-07-14 | Oklahoma | Oklahoma | 40109 | 5259 | 75 |
330415 | 330415 | 2020-07-13 | Oklahoma | Oklahoma | 40109 | 4986 | 74 |
327228 | 327228 | 2020-07-12 | Oklahoma | Oklahoma | 40109 | 4802 | 74 |
324043 | 324043 | 2020-07-11 | Oklahoma | Oklahoma | 40109 | 4613 | 74 |
320863 | 320863 | 2020-07-10 | Oklahoma | Oklahoma | 40109 | 4379 | 72 |
317686 | 317686 | 2020-07-09 | Oklahoma | Oklahoma | 40109 | 4194 | 72 |
314513 | 314513 | 2020-07-08 | Oklahoma | Oklahoma | 40109 | 4039 | 71 |
311341 | 311341 | 2020-07-07 | Oklahoma | Oklahoma | 40109 | 3819 | 70 |
308172 | 308172 | 2020-07-06 | Oklahoma | Oklahoma | 40109 | 3607 | 70 |
305005 | 305005 | 2020-07-05 | Oklahoma | Oklahoma | 40109 | 3479 | 70 |
301842 | 301842 | 2020-07-04 | Oklahoma | Oklahoma | 40109 | 3393 | 70 |
298679 | 298679 | 2020-07-03 | Oklahoma | Oklahoma | 40109 | 3263 | 70 |
295520 | 295520 | 2020-07-02 | Oklahoma | Oklahoma | 40109 | 3135 | 70 |
292364 | 292364 | 2020-07-01 | Oklahoma | Oklahoma | 40109 | 3029 | 70 |
289211 | 289211 | 2020-06-30 | Oklahoma | Oklahoma | 40109 | 2913 | 70 |
286061 | 286061 | 2020-06-29 | Oklahoma | Oklahoma | 40109 | 2732 | 70 |
282916 | 282916 | 2020-06-28 | Oklahoma | Oklahoma | 40109 | 2663 | 70 |
279770 | 279770 | 2020-06-27 | Oklahoma | Oklahoma | 40109 | 2600 | 69 |
276622 | 276622 | 2020-06-26 | Oklahoma | Oklahoma | 40109 | 2486 | 69 |
273475 | 273475 | 2020-06-25 | Oklahoma | Oklahoma | 40109 | 2410 | 68 |
270336 | 270336 | 2020-06-24 | Oklahoma | Oklahoma | 40109 | 2317 | 65 |
267202 | 267202 | 2020-06-23 | Oklahoma | Oklahoma | 40109 | 2230 | 65 |
264074 | 264074 | 2020-06-22 | Oklahoma | Oklahoma | 40109 | 2147 | 65 |
260946 | 260946 | 2020-06-21 | Oklahoma | Oklahoma | 40109 | 2099 | 65 |
257819 | 257819 | 2020-06-20 | Oklahoma | Oklahoma | 40109 | 1990 | 65 |
254693 | 254693 | 2020-06-19 | Oklahoma | Oklahoma | 40109 | 1946 | 65 |
251578 | 251578 | 2020-06-18 | Oklahoma | Oklahoma | 40109 | 1861 | 65 |
248463 | 248463 | 2020-06-17 | Oklahoma | Oklahoma | 40109 | 1754 | 65 |
245350 | 245350 | 2020-06-16 | Oklahoma | Oklahoma | 40109 | 1673 | 64 |
242238 | 242238 | 2020-06-15 | Oklahoma | Oklahoma | 40109 | 1643 | 64 |
239129 | 239129 | 2020-06-14 | Oklahoma | Oklahoma | 40109 | 1597 | 64 |
236021 | 236021 | 2020-06-13 | Oklahoma | Oklahoma | 40109 | 1561 | 64 |
232916 | 232916 | 2020-06-12 | Oklahoma | Oklahoma | 40109 | 1517 | 64 |
229811 | 229811 | 2020-06-11 | Oklahoma | Oklahoma | 40109 | 1461 | 64 |
226707 | 226707 | 2020-06-10 | Oklahoma | Oklahoma | 40109 | 1436 | 64 |
223607 | 223607 | 2020-06-09 | Oklahoma | Oklahoma | 40109 | 1404 | 64 |
220512 | 220512 | 2020-06-08 | Oklahoma | Oklahoma | 40109 | 1384 | 64 |
217420 | 217420 | 2020-06-07 | Oklahoma | Oklahoma | 40109 | 1369 | 64 |
214330 | 214330 | 2020-06-06 | Oklahoma | Oklahoma | 40109 | 1360 | 64 |
211244 | 211244 | 2020-06-05 | Oklahoma | Oklahoma | 40109 | 1350 | 63 |
208162 | 208162 | 2020-06-04 | Oklahoma | Oklahoma | 40109 | 1328 | 63 |
205081 | 205081 | 2020-06-03 | Oklahoma | Oklahoma | 40109 | 1309 | 62 |
202004 | 202004 | 2020-06-02 | Oklahoma | Oklahoma | 40109 | 1294 | 62 |
198929 | 198929 | 2020-06-01 | Oklahoma | Oklahoma | 40109 | 1284 | 61 |
195856 | 195856 | 2020-05-31 | Oklahoma | Oklahoma | 40109 | 1281 | 61 |
192787 | 192787 | 2020-05-30 | Oklahoma | Oklahoma | 40109 | 1263 | 61 |
189722 | 189722 | 2020-05-29 | Oklahoma | Oklahoma | 40109 | 1254 | 60 |
186661 | 186661 | 2020-05-28 | Oklahoma | Oklahoma | 40109 | 1241 | 59 |
183604 | 183604 | 2020-05-27 | Oklahoma | Oklahoma | 40109 | 1227 | 58 |
180555 | 180555 | 2020-05-26 | Oklahoma | Oklahoma | 40109 | 1216 | 58 |
177512 | 177512 | 2020-05-25 | Oklahoma | Oklahoma | 40109 | 1208 | 56 |
174468 | 174468 | 2020-05-24 | Oklahoma | Oklahoma | 40109 | 1203 | 56 |
171426 | 171426 | 2020-05-23 | Oklahoma | Oklahoma | 40109 | 1189 | 56 |
168387 | 168387 | 2020-05-22 | Oklahoma | Oklahoma | 40109 | 1179 | 55 |
165351 | 165351 | 2020-05-21 | Oklahoma | Oklahoma | 40109 | 1109 | 54 |
162322 | 162322 | 2020-05-20 | Oklahoma | Oklahoma | 40109 | 1093 | 51 |
159295 | 159295 | 2020-05-19 | Oklahoma | Oklahoma | 40109 | 1087 | 49 |
156274 | 156274 | 2020-05-18 | Oklahoma | Oklahoma | 40109 | 1075 | 46 |
153257 | 153257 | 2020-05-17 | Oklahoma | Oklahoma | 40109 | 1074 | 46 |
150246 | 150246 | 2020-05-16 | Oklahoma | Oklahoma | 40109 | 1070 | 46 |
147239 | 147239 | 2020-05-15 | Oklahoma | Oklahoma | 40109 | 1035 | 45 |
144238 | 144238 | 2020-05-14 | Oklahoma | Oklahoma | 40109 | 1013 | 45 |
141243 | 141243 | 2020-05-13 | Oklahoma | Oklahoma | 40109 | 1007 | 43 |
138247 | 138247 | 2020-05-12 | Oklahoma | Oklahoma | 40109 | 997 | 43 |
135257 | 135257 | 2020-05-11 | Oklahoma | Oklahoma | 40109 | 954 | 43 |
132266 | 132266 | 2020-05-10 | Oklahoma | Oklahoma | 40109 | 945 | 43 |
129277 | 129277 | 2020-05-09 | Oklahoma | Oklahoma | 40109 | 927 | 42 |
126288 | 126288 | 2020-05-08 | Oklahoma | Oklahoma | 40109 | 905 | 41 |
123305 | 123305 | 2020-05-07 | Oklahoma | Oklahoma | 40109 | 895 | 40 |
120328 | 120328 | 2020-05-06 | Oklahoma | Oklahoma | 40109 | 868 | 40 |
117367 | 117367 | 2020-05-05 | Oklahoma | Oklahoma | 40109 | 853 | 36 |
114486 | 114486 | 2020-05-04 | Oklahoma | Oklahoma | 40109 | 841 | 33 |
111604 | 111604 | 2020-05-03 | Oklahoma | Oklahoma | 40109 | 838 | 33 |
108730 | 108730 | 2020-05-02 | Oklahoma | Oklahoma | 40109 | 822 | 33 |
105863 | 105863 | 2020-05-01 | Oklahoma | Oklahoma | 40109 | 816 | 31 |
103000 | 103000 | 2020-04-30 | Oklahoma | Oklahoma | 40109 | 773 | 31 |
100147 | 100147 | 2020-04-29 | Oklahoma | Oklahoma | 40109 | 743 | 30 |
97298 | 97298 | 2020-04-28 | Oklahoma | Oklahoma | 40109 | 729 | 29 |
94460 | 94460 | 2020-04-27 | Oklahoma | Oklahoma | 40109 | 703 | 29 |
91634 | 91634 | 2020-04-26 | Oklahoma | Oklahoma | 40109 | 696 | 29 |
88818 | 88818 | 2020-04-25 | Oklahoma | Oklahoma | 40109 | 694 | 29 |
86004 | 86004 | 2020-04-24 | Oklahoma | Oklahoma | 40109 | 670 | 27 |
83200 | 83200 | 2020-04-23 | Oklahoma | Oklahoma | 40109 | 634 | 25 |
80401 | 80401 | 2020-04-22 | Oklahoma | Oklahoma | 40109 | 607 | 24 |
77611 | 77611 | 2020-04-21 | Oklahoma | Oklahoma | 40109 | 590 | 24 |
74829 | 74829 | 2020-04-20 | Oklahoma | Oklahoma | 40109 | 575 | 23 |
72054 | 72054 | 2020-04-19 | Oklahoma | Oklahoma | 40109 | 561 | 23 |
69287 | 69287 | 2020-04-18 | Oklahoma | Oklahoma | 40109 | 550 | 23 |
66529 | 66529 | 2020-04-17 | Oklahoma | Oklahoma | 40109 | 520 | 22 |
63784 | 63784 | 2020-04-16 | Oklahoma | Oklahoma | 40109 | 497 | 22 |
61058 | 61058 | 2020-04-15 | Oklahoma | Oklahoma | 40109 | 483 | 22 |
58343 | 58343 | 2020-04-14 | Oklahoma | Oklahoma | 40109 | 474 | 19 |
55641 | 55641 | 2020-04-13 | Oklahoma | Oklahoma | 40109 | 455 | 19 |
52956 | 52956 | 2020-04-12 | Oklahoma | Oklahoma | 40109 | 435 | 19 |
50283 | 50283 | 2020-04-11 | Oklahoma | Oklahoma | 40109 | 425 | 19 |
47627 | 47627 | 2020-04-10 | Oklahoma | Oklahoma | 40109 | 413 | 17 |
45010 | 45010 | 2020-04-09 | Oklahoma | Oklahoma | 40109 | 385 | 15 |
42424 | 42424 | 2020-04-08 | Oklahoma | Oklahoma | 40109 | 317 | 15 |
39864 | 39864 | 2020-04-07 | Oklahoma | Oklahoma | 40109 | 303 | 11 |
37343 | 37343 | 2020-04-06 | Oklahoma | Oklahoma | 40109 | 279 | 11 |
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 ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);