ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Clark" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536487 | 536487 | 2020-09-15 | Clark | Ohio | 39023 | 1665 | 36 |
533251 | 533251 | 2020-09-14 | Clark | Ohio | 39023 | 1653 | 36 |
530016 | 530016 | 2020-09-13 | Clark | Ohio | 39023 | 1615 | 36 |
526779 | 526779 | 2020-09-12 | Clark | Ohio | 39023 | 1599 | 36 |
523543 | 523543 | 2020-09-11 | Clark | Ohio | 39023 | 1579 | 36 |
520307 | 520307 | 2020-09-10 | Clark | Ohio | 39023 | 1565 | 33 |
517071 | 517071 | 2020-09-09 | Clark | Ohio | 39023 | 1547 | 31 |
513836 | 513836 | 2020-09-08 | Clark | Ohio | 39023 | 1527 | 31 |
510603 | 510603 | 2020-09-07 | Clark | Ohio | 39023 | 1524 | 31 |
507370 | 507370 | 2020-09-06 | Clark | Ohio | 39023 | 1511 | 30 |
504138 | 504138 | 2020-09-05 | Clark | Ohio | 39023 | 1509 | 30 |
500904 | 500904 | 2020-09-04 | Clark | Ohio | 39023 | 1488 | 29 |
497670 | 497670 | 2020-09-03 | Clark | Ohio | 39023 | 1467 | 29 |
494437 | 494437 | 2020-09-02 | Clark | Ohio | 39023 | 1449 | 28 |
491203 | 491203 | 2020-09-01 | Clark | Ohio | 39023 | 1433 | 28 |
487970 | 487970 | 2020-08-31 | Clark | Ohio | 39023 | 1420 | 27 |
484737 | 484737 | 2020-08-30 | Clark | Ohio | 39023 | 1407 | 27 |
481502 | 481502 | 2020-08-29 | Clark | Ohio | 39023 | 1398 | 27 |
478268 | 478268 | 2020-08-28 | Clark | Ohio | 39023 | 1394 | 27 |
475035 | 475035 | 2020-08-27 | Clark | Ohio | 39023 | 1383 | 23 |
471801 | 471801 | 2020-08-26 | Clark | Ohio | 39023 | 1373 | 21 |
468569 | 468569 | 2020-08-25 | Clark | Ohio | 39023 | 1360 | 21 |
465341 | 465341 | 2020-08-24 | Clark | Ohio | 39023 | 1351 | 20 |
462112 | 462112 | 2020-08-23 | Clark | Ohio | 39023 | 1341 | 19 |
458884 | 458884 | 2020-08-22 | Clark | Ohio | 39023 | 1330 | 19 |
455656 | 455656 | 2020-08-21 | Clark | Ohio | 39023 | 1312 | 19 |
452428 | 452428 | 2020-08-20 | Clark | Ohio | 39023 | 1307 | 17 |
449200 | 449200 | 2020-08-19 | Clark | Ohio | 39023 | 1291 | 16 |
445972 | 445972 | 2020-08-18 | Clark | Ohio | 39023 | 1275 | 16 |
442746 | 442746 | 2020-08-17 | Clark | Ohio | 39023 | 1261 | 16 |
439519 | 439519 | 2020-08-16 | Clark | Ohio | 39023 | 1244 | 16 |
436294 | 436294 | 2020-08-15 | Clark | Ohio | 39023 | 1249 | 16 |
433068 | 433068 | 2020-08-14 | Clark | Ohio | 39023 | 1235 | 16 |
429842 | 429842 | 2020-08-13 | Clark | Ohio | 39023 | 1218 | 15 |
426617 | 426617 | 2020-08-12 | Clark | Ohio | 39023 | 1213 | 15 |
423394 | 423394 | 2020-08-11 | Clark | Ohio | 39023 | 1178 | 15 |
420171 | 420171 | 2020-08-10 | Clark | Ohio | 39023 | 1158 | 14 |
416951 | 416951 | 2020-08-09 | Clark | Ohio | 39023 | 1146 | 14 |
413730 | 413730 | 2020-08-08 | Clark | Ohio | 39023 | 1142 | 14 |
410510 | 410510 | 2020-08-07 | Clark | Ohio | 39023 | 1133 | 14 |
407290 | 407290 | 2020-08-06 | Clark | Ohio | 39023 | 1115 | 14 |
404071 | 404071 | 2020-08-05 | Clark | Ohio | 39023 | 1104 | 14 |
400853 | 400853 | 2020-08-04 | Clark | Ohio | 39023 | 1092 | 14 |
397638 | 397638 | 2020-08-03 | Clark | Ohio | 39023 | 1086 | 13 |
394421 | 394421 | 2020-08-02 | Clark | Ohio | 39023 | 1076 | 13 |
391205 | 391205 | 2020-08-01 | Clark | Ohio | 39023 | 1067 | 13 |
387988 | 387988 | 2020-07-31 | Clark | Ohio | 39023 | 1058 | 13 |
384771 | 384771 | 2020-07-30 | Clark | Ohio | 39023 | 1046 | 13 |
381553 | 381553 | 2020-07-29 | Clark | Ohio | 39023 | 1031 | 13 |
378336 | 378336 | 2020-07-28 | Clark | Ohio | 39023 | 1023 | 12 |
375119 | 375119 | 2020-07-27 | Clark | Ohio | 39023 | 1002 | 11 |
371907 | 371907 | 2020-07-26 | Clark | Ohio | 39023 | 988 | 11 |
368695 | 368695 | 2020-07-25 | Clark | Ohio | 39023 | 988 | 11 |
365486 | 365486 | 2020-07-24 | Clark | Ohio | 39023 | 976 | 11 |
362280 | 362280 | 2020-07-23 | Clark | Ohio | 39023 | 964 | 11 |
359074 | 359074 | 2020-07-22 | Clark | Ohio | 39023 | 951 | 11 |
355870 | 355870 | 2020-07-21 | Clark | Ohio | 39023 | 924 | 11 |
352667 | 352667 | 2020-07-20 | Clark | Ohio | 39023 | 907 | 11 |
349464 | 349464 | 2020-07-19 | Clark | Ohio | 39023 | 895 | 11 |
346263 | 346263 | 2020-07-18 | Clark | Ohio | 39023 | 877 | 11 |
343064 | 343064 | 2020-07-17 | Clark | Ohio | 39023 | 868 | 11 |
339866 | 339866 | 2020-07-16 | Clark | Ohio | 39023 | 851 | 11 |
336670 | 336670 | 2020-07-15 | Clark | Ohio | 39023 | 840 | 10 |
333476 | 333476 | 2020-07-14 | Clark | Ohio | 39023 | 832 | 10 |
330284 | 330284 | 2020-07-13 | Clark | Ohio | 39023 | 820 | 10 |
327097 | 327097 | 2020-07-12 | Clark | Ohio | 39023 | 816 | 10 |
323912 | 323912 | 2020-07-11 | Clark | Ohio | 39023 | 800 | 10 |
320732 | 320732 | 2020-07-10 | Clark | Ohio | 39023 | 793 | 10 |
317555 | 317555 | 2020-07-09 | Clark | Ohio | 39023 | 784 | 10 |
314382 | 314382 | 2020-07-08 | Clark | Ohio | 39023 | 780 | 9 |
311210 | 311210 | 2020-07-07 | Clark | Ohio | 39023 | 772 | 9 |
308041 | 308041 | 2020-07-06 | Clark | Ohio | 39023 | 766 | 9 |
304874 | 304874 | 2020-07-05 | Clark | Ohio | 39023 | 765 | 9 |
301711 | 301711 | 2020-07-04 | Clark | Ohio | 39023 | 765 | 9 |
298548 | 298548 | 2020-07-03 | Clark | Ohio | 39023 | 761 | 9 |
295388 | 295388 | 2020-07-02 | Clark | Ohio | 39023 | 739 | 9 |
292233 | 292233 | 2020-07-01 | Clark | Ohio | 39023 | 739 | 9 |
289081 | 289081 | 2020-06-30 | Clark | Ohio | 39023 | 729 | 8 |
285931 | 285931 | 2020-06-29 | Clark | Ohio | 39023 | 728 | 8 |
282786 | 282786 | 2020-06-28 | Clark | Ohio | 39023 | 727 | 8 |
279640 | 279640 | 2020-06-27 | Clark | Ohio | 39023 | 722 | 8 |
276492 | 276492 | 2020-06-26 | Clark | Ohio | 39023 | 712 | 8 |
273345 | 273345 | 2020-06-25 | Clark | Ohio | 39023 | 703 | 8 |
270206 | 270206 | 2020-06-24 | Clark | Ohio | 39023 | 697 | 8 |
267072 | 267072 | 2020-06-23 | Clark | Ohio | 39023 | 688 | 8 |
263944 | 263944 | 2020-06-22 | Clark | Ohio | 39023 | 670 | 8 |
260816 | 260816 | 2020-06-21 | Clark | Ohio | 39023 | 653 | 8 |
257689 | 257689 | 2020-06-20 | Clark | Ohio | 39023 | 639 | 8 |
254564 | 254564 | 2020-06-19 | Clark | Ohio | 39023 | 606 | 8 |
251449 | 251449 | 2020-06-18 | Clark | Ohio | 39023 | 568 | 8 |
248334 | 248334 | 2020-06-17 | Clark | Ohio | 39023 | 502 | 8 |
245221 | 245221 | 2020-06-16 | Clark | Ohio | 39023 | 460 | 8 |
242109 | 242109 | 2020-06-15 | Clark | Ohio | 39023 | 425 | 8 |
239000 | 239000 | 2020-06-14 | Clark | Ohio | 39023 | 409 | 8 |
235892 | 235892 | 2020-06-13 | Clark | Ohio | 39023 | 403 | 8 |
232787 | 232787 | 2020-06-12 | Clark | Ohio | 39023 | 400 | 8 |
229682 | 229682 | 2020-06-11 | Clark | Ohio | 39023 | 394 | 8 |
226578 | 226578 | 2020-06-10 | Clark | Ohio | 39023 | 384 | 8 |
223478 | 223478 | 2020-06-09 | Clark | Ohio | 39023 | 377 | 8 |
220383 | 220383 | 2020-06-08 | Clark | Ohio | 39023 | 371 | 8 |
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);