ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 40027 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388078 | 388078 | 2020-07-31 | Cleveland | Oklahoma | 40027 | 2555 | 49 |
384861 | 384861 | 2020-07-30 | Cleveland | Oklahoma | 40027 | 2487 | 47 |
381643 | 381643 | 2020-07-29 | Cleveland | Oklahoma | 40027 | 2382 | 45 |
378426 | 378426 | 2020-07-28 | Cleveland | Oklahoma | 40027 | 2209 | 42 |
375209 | 375209 | 2020-07-27 | Cleveland | Oklahoma | 40027 | 2170 | 41 |
371997 | 371997 | 2020-07-26 | Cleveland | Oklahoma | 40027 | 2120 | 41 |
368785 | 368785 | 2020-07-25 | Cleveland | Oklahoma | 40027 | 2048 | 41 |
365576 | 365576 | 2020-07-24 | Cleveland | Oklahoma | 40027 | 1958 | 40 |
362370 | 362370 | 2020-07-23 | Cleveland | Oklahoma | 40027 | 1887 | 40 |
359164 | 359164 | 2020-07-22 | Cleveland | Oklahoma | 40027 | 1847 | 40 |
355960 | 355960 | 2020-07-21 | Cleveland | Oklahoma | 40027 | 1760 | 40 |
352757 | 352757 | 2020-07-20 | Cleveland | Oklahoma | 40027 | 1693 | 40 |
349554 | 349554 | 2020-07-19 | Cleveland | Oklahoma | 40027 | 1678 | 40 |
346354 | 346354 | 2020-07-18 | Cleveland | Oklahoma | 40027 | 1670 | 40 |
343154 | 343154 | 2020-07-17 | Cleveland | Oklahoma | 40027 | 1630 | 40 |
339956 | 339956 | 2020-07-16 | Cleveland | Oklahoma | 40027 | 1576 | 40 |
336760 | 336760 | 2020-07-15 | Cleveland | Oklahoma | 40027 | 1526 | 40 |
333566 | 333566 | 2020-07-14 | Cleveland | Oklahoma | 40027 | 1448 | 40 |
330374 | 330374 | 2020-07-13 | Cleveland | Oklahoma | 40027 | 1348 | 40 |
327187 | 327187 | 2020-07-12 | Cleveland | Oklahoma | 40027 | 1319 | 40 |
324002 | 324002 | 2020-07-11 | Cleveland | Oklahoma | 40027 | 1277 | 40 |
320822 | 320822 | 2020-07-10 | Cleveland | Oklahoma | 40027 | 1238 | 40 |
317645 | 317645 | 2020-07-09 | Cleveland | Oklahoma | 40027 | 1208 | 40 |
314472 | 314472 | 2020-07-08 | Cleveland | Oklahoma | 40027 | 1186 | 40 |
311300 | 311300 | 2020-07-07 | Cleveland | Oklahoma | 40027 | 1157 | 40 |
308131 | 308131 | 2020-07-06 | Cleveland | Oklahoma | 40027 | 1107 | 40 |
304964 | 304964 | 2020-07-05 | Cleveland | Oklahoma | 40027 | 1052 | 40 |
301801 | 301801 | 2020-07-04 | Cleveland | Oklahoma | 40027 | 1035 | 40 |
298638 | 298638 | 2020-07-03 | Cleveland | Oklahoma | 40027 | 1003 | 40 |
295479 | 295479 | 2020-07-02 | Cleveland | Oklahoma | 40027 | 935 | 40 |
292323 | 292323 | 2020-07-01 | Cleveland | Oklahoma | 40027 | 911 | 40 |
289171 | 289171 | 2020-06-30 | Cleveland | Oklahoma | 40027 | 886 | 40 |
286021 | 286021 | 2020-06-29 | Cleveland | Oklahoma | 40027 | 873 | 40 |
282876 | 282876 | 2020-06-28 | Cleveland | Oklahoma | 40027 | 852 | 40 |
279730 | 279730 | 2020-06-27 | Cleveland | Oklahoma | 40027 | 795 | 40 |
276582 | 276582 | 2020-06-26 | Cleveland | Oklahoma | 40027 | 780 | 40 |
273435 | 273435 | 2020-06-25 | Cleveland | Oklahoma | 40027 | 763 | 40 |
270296 | 270296 | 2020-06-24 | Cleveland | Oklahoma | 40027 | 735 | 40 |
267162 | 267162 | 2020-06-23 | Cleveland | Oklahoma | 40027 | 711 | 40 |
264034 | 264034 | 2020-06-22 | Cleveland | Oklahoma | 40027 | 684 | 40 |
260906 | 260906 | 2020-06-21 | Cleveland | Oklahoma | 40027 | 677 | 40 |
257780 | 257780 | 2020-06-20 | Cleveland | Oklahoma | 40027 | 640 | 40 |
254654 | 254654 | 2020-06-19 | Cleveland | Oklahoma | 40027 | 620 | 40 |
251539 | 251539 | 2020-06-18 | Cleveland | Oklahoma | 40027 | 605 | 40 |
248424 | 248424 | 2020-06-17 | Cleveland | Oklahoma | 40027 | 576 | 40 |
245311 | 245311 | 2020-06-16 | Cleveland | Oklahoma | 40027 | 564 | 40 |
242199 | 242199 | 2020-06-15 | Cleveland | Oklahoma | 40027 | 552 | 40 |
239090 | 239090 | 2020-06-14 | Cleveland | Oklahoma | 40027 | 546 | 40 |
235982 | 235982 | 2020-06-13 | Cleveland | Oklahoma | 40027 | 544 | 40 |
232877 | 232877 | 2020-06-12 | Cleveland | Oklahoma | 40027 | 539 | 40 |
229772 | 229772 | 2020-06-11 | Cleveland | Oklahoma | 40027 | 533 | 40 |
226668 | 226668 | 2020-06-10 | Cleveland | Oklahoma | 40027 | 529 | 40 |
223568 | 223568 | 2020-06-09 | Cleveland | Oklahoma | 40027 | 529 | 39 |
220473 | 220473 | 2020-06-08 | Cleveland | Oklahoma | 40027 | 524 | 37 |
217381 | 217381 | 2020-06-07 | Cleveland | Oklahoma | 40027 | 520 | 37 |
214291 | 214291 | 2020-06-06 | Cleveland | Oklahoma | 40027 | 519 | 37 |
211205 | 211205 | 2020-06-05 | Cleveland | Oklahoma | 40027 | 520 | 37 |
208123 | 208123 | 2020-06-04 | Cleveland | Oklahoma | 40027 | 514 | 37 |
205042 | 205042 | 2020-06-03 | Cleveland | Oklahoma | 40027 | 511 | 37 |
201965 | 201965 | 2020-06-02 | Cleveland | Oklahoma | 40027 | 506 | 37 |
198890 | 198890 | 2020-06-01 | Cleveland | Oklahoma | 40027 | 503 | 37 |
195817 | 195817 | 2020-05-31 | Cleveland | Oklahoma | 40027 | 501 | 37 |
192748 | 192748 | 2020-05-30 | Cleveland | Oklahoma | 40027 | 500 | 37 |
189683 | 189683 | 2020-05-29 | Cleveland | Oklahoma | 40027 | 498 | 37 |
186623 | 186623 | 2020-05-28 | Cleveland | Oklahoma | 40027 | 496 | 37 |
183566 | 183566 | 2020-05-27 | Cleveland | Oklahoma | 40027 | 494 | 37 |
180517 | 180517 | 2020-05-26 | Cleveland | Oklahoma | 40027 | 493 | 37 |
177474 | 177474 | 2020-05-25 | Cleveland | Oklahoma | 40027 | 490 | 37 |
174430 | 174430 | 2020-05-24 | Cleveland | Oklahoma | 40027 | 489 | 37 |
171388 | 171388 | 2020-05-23 | Cleveland | Oklahoma | 40027 | 487 | 37 |
168349 | 168349 | 2020-05-22 | Cleveland | Oklahoma | 40027 | 481 | 37 |
165313 | 165313 | 2020-05-21 | Cleveland | Oklahoma | 40027 | 482 | 37 |
162284 | 162284 | 2020-05-20 | Cleveland | Oklahoma | 40027 | 472 | 37 |
159257 | 159257 | 2020-05-19 | Cleveland | Oklahoma | 40027 | 470 | 36 |
156237 | 156237 | 2020-05-18 | Cleveland | Oklahoma | 40027 | 468 | 36 |
153220 | 153220 | 2020-05-17 | Cleveland | Oklahoma | 40027 | 468 | 36 |
150209 | 150209 | 2020-05-16 | Cleveland | Oklahoma | 40027 | 466 | 36 |
147202 | 147202 | 2020-05-15 | Cleveland | Oklahoma | 40027 | 459 | 35 |
144201 | 144201 | 2020-05-14 | Cleveland | Oklahoma | 40027 | 458 | 35 |
141206 | 141206 | 2020-05-13 | Cleveland | Oklahoma | 40027 | 458 | 33 |
138210 | 138210 | 2020-05-12 | Cleveland | Oklahoma | 40027 | 457 | 33 |
135220 | 135220 | 2020-05-11 | Cleveland | Oklahoma | 40027 | 456 | 32 |
132229 | 132229 | 2020-05-10 | Cleveland | Oklahoma | 40027 | 456 | 32 |
129240 | 129240 | 2020-05-09 | Cleveland | Oklahoma | 40027 | 455 | 32 |
126251 | 126251 | 2020-05-08 | Cleveland | Oklahoma | 40027 | 453 | 32 |
123268 | 123268 | 2020-05-07 | Cleveland | Oklahoma | 40027 | 448 | 32 |
120291 | 120291 | 2020-05-06 | Cleveland | Oklahoma | 40027 | 447 | 31 |
117330 | 117330 | 2020-05-05 | Cleveland | Oklahoma | 40027 | 439 | 30 |
114449 | 114449 | 2020-05-04 | Cleveland | Oklahoma | 40027 | 436 | 29 |
111567 | 111567 | 2020-05-03 | Cleveland | Oklahoma | 40027 | 432 | 29 |
108693 | 108693 | 2020-05-02 | Cleveland | Oklahoma | 40027 | 430 | 29 |
105826 | 105826 | 2020-05-01 | Cleveland | Oklahoma | 40027 | 426 | 29 |
102963 | 102963 | 2020-04-30 | Cleveland | Oklahoma | 40027 | 419 | 28 |
100110 | 100110 | 2020-04-29 | Cleveland | Oklahoma | 40027 | 417 | 28 |
97261 | 97261 | 2020-04-28 | Cleveland | Oklahoma | 40027 | 410 | 28 |
94423 | 94423 | 2020-04-27 | Cleveland | Oklahoma | 40027 | 404 | 27 |
91597 | 91597 | 2020-04-26 | Cleveland | Oklahoma | 40027 | 403 | 27 |
88781 | 88781 | 2020-04-25 | Cleveland | Oklahoma | 40027 | 400 | 27 |
85967 | 85967 | 2020-04-24 | Cleveland | Oklahoma | 40027 | 393 | 27 |
83163 | 83163 | 2020-04-23 | Cleveland | Oklahoma | 40027 | 388 | 26 |
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);