ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clay" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636404 | 636404 | 2020-10-16 | Clay | Missouri | 29047 | 2257 | 50 |
633158 | 633158 | 2020-10-15 | Clay | Missouri | 29047 | 2225 | 50 |
629913 | 629913 | 2020-10-14 | Clay | Missouri | 29047 | 2198 | 47 |
626669 | 626669 | 2020-10-13 | Clay | Missouri | 29047 | 2134 | 44 |
623427 | 623427 | 2020-10-12 | Clay | Missouri | 29047 | 2005 | 44 |
620184 | 620184 | 2020-10-11 | Clay | Missouri | 29047 | 2005 | 44 |
616942 | 616942 | 2020-10-10 | Clay | Missouri | 29047 | 2005 | 44 |
613701 | 613701 | 2020-10-09 | Clay | Missouri | 29047 | 2005 | 44 |
610459 | 610459 | 2020-10-08 | Clay | Missouri | 29047 | 1979 | 43 |
607217 | 607217 | 2020-10-07 | Clay | Missouri | 29047 | 1969 | 43 |
603974 | 603974 | 2020-10-06 | Clay | Missouri | 29047 | 1947 | 42 |
600732 | 600732 | 2020-10-05 | Clay | Missouri | 29047 | 1920 | 40 |
597489 | 597489 | 2020-10-04 | Clay | Missouri | 29047 | 1864 | 39 |
594248 | 594248 | 2020-10-03 | Clay | Missouri | 29047 | 1864 | 39 |
591007 | 591007 | 2020-10-02 | Clay | Missouri | 29047 | 1864 | 39 |
587766 | 587766 | 2020-10-01 | Clay | Missouri | 29047 | 1848 | 39 |
584526 | 584526 | 2020-09-30 | Clay | Missouri | 29047 | 1826 | 39 |
581285 | 581285 | 2020-09-29 | Clay | Missouri | 29047 | 1827 | 41 |
578044 | 578044 | 2020-09-28 | Clay | Missouri | 29047 | 1827 | 41 |
574803 | 574803 | 2020-09-27 | Clay | Missouri | 29047 | 1809 | 41 |
571560 | 571560 | 2020-09-26 | Clay | Missouri | 29047 | 1817 | 41 |
568318 | 568318 | 2020-09-25 | Clay | Missouri | 29047 | 1799 | 41 |
565078 | 565078 | 2020-09-24 | Clay | Missouri | 29047 | 1773 | 41 |
561838 | 561838 | 2020-09-23 | Clay | Missouri | 29047 | 1760 | 41 |
558601 | 558601 | 2020-09-22 | Clay | Missouri | 29047 | 1743 | 40 |
555364 | 555364 | 2020-09-21 | Clay | Missouri | 29047 | 1736 | 40 |
552126 | 552126 | 2020-09-20 | Clay | Missouri | 29047 | 1724 | 40 |
548887 | 548887 | 2020-09-19 | Clay | Missouri | 29047 | 1714 | 40 |
545649 | 545649 | 2020-09-18 | Clay | Missouri | 29047 | 1700 | 40 |
542412 | 542412 | 2020-09-17 | Clay | Missouri | 29047 | 1672 | 40 |
539176 | 539176 | 2020-09-16 | Clay | Missouri | 29047 | 1657 | 40 |
535939 | 535939 | 2020-09-15 | Clay | Missouri | 29047 | 1642 | 39 |
532704 | 532704 | 2020-09-14 | Clay | Missouri | 29047 | 1624 | 39 |
529468 | 529468 | 2020-09-13 | Clay | Missouri | 29047 | 1608 | 39 |
526232 | 526232 | 2020-09-12 | Clay | Missouri | 29047 | 1589 | 39 |
522996 | 522996 | 2020-09-11 | Clay | Missouri | 29047 | 1561 | 39 |
519759 | 519759 | 2020-09-10 | Clay | Missouri | 29047 | 1541 | 39 |
516524 | 516524 | 2020-09-09 | Clay | Missouri | 29047 | 1530 | 39 |
513290 | 513290 | 2020-09-08 | Clay | Missouri | 29047 | 1512 | 39 |
510058 | 510058 | 2020-09-07 | Clay | Missouri | 29047 | 1506 | 39 |
506825 | 506825 | 2020-09-06 | Clay | Missouri | 29047 | 1493 | 39 |
503592 | 503592 | 2020-09-05 | Clay | Missouri | 29047 | 1481 | 39 |
500358 | 500358 | 2020-09-04 | Clay | Missouri | 29047 | 1455 | 38 |
497124 | 497124 | 2020-09-03 | Clay | Missouri | 29047 | 1443 | 37 |
493891 | 493891 | 2020-09-02 | Clay | Missouri | 29047 | 1412 | 37 |
490657 | 490657 | 2020-09-01 | Clay | Missouri | 29047 | 1403 | 37 |
487424 | 487424 | 2020-08-31 | Clay | Missouri | 29047 | 1381 | 37 |
484190 | 484190 | 2020-08-30 | Clay | Missouri | 29047 | 1363 | 36 |
480955 | 480955 | 2020-08-29 | Clay | Missouri | 29047 | 1355 | 36 |
477723 | 477723 | 2020-08-28 | Clay | Missouri | 29047 | 1346 | 36 |
474490 | 474490 | 2020-08-27 | Clay | Missouri | 29047 | 1323 | 36 |
471258 | 471258 | 2020-08-26 | Clay | Missouri | 29047 | 1309 | 34 |
468028 | 468028 | 2020-08-25 | Clay | Missouri | 29047 | 1285 | 34 |
464799 | 464799 | 2020-08-24 | Clay | Missouri | 29047 | 1269 | 34 |
461568 | 461568 | 2020-08-23 | Clay | Missouri | 29047 | 1261 | 34 |
458341 | 458341 | 2020-08-22 | Clay | Missouri | 29047 | 1245 | 34 |
455113 | 455113 | 2020-08-21 | Clay | Missouri | 29047 | 1210 | 34 |
451885 | 451885 | 2020-08-20 | Clay | Missouri | 29047 | 1194 | 34 |
448657 | 448657 | 2020-08-19 | Clay | Missouri | 29047 | 1180 | 34 |
445431 | 445431 | 2020-08-18 | Clay | Missouri | 29047 | 1167 | 34 |
442205 | 442205 | 2020-08-17 | Clay | Missouri | 29047 | 1158 | 33 |
438978 | 438978 | 2020-08-16 | Clay | Missouri | 29047 | 1143 | 32 |
435753 | 435753 | 2020-08-15 | Clay | Missouri | 29047 | 1133 | 32 |
432527 | 432527 | 2020-08-14 | Clay | Missouri | 29047 | 1126 | 32 |
429300 | 429300 | 2020-08-13 | Clay | Missouri | 29047 | 1098 | 32 |
426076 | 426076 | 2020-08-12 | Clay | Missouri | 29047 | 1087 | 27 |
422854 | 422854 | 2020-08-11 | Clay | Missouri | 29047 | 1064 | 27 |
419632 | 419632 | 2020-08-10 | Clay | Missouri | 29047 | 1053 | 27 |
416411 | 416411 | 2020-08-09 | Clay | Missouri | 29047 | 1037 | 27 |
413191 | 413191 | 2020-08-08 | Clay | Missouri | 29047 | 1011 | 27 |
409971 | 409971 | 2020-08-07 | Clay | Missouri | 29047 | 1011 | 27 |
406751 | 406751 | 2020-08-06 | Clay | Missouri | 29047 | 984 | 24 |
403533 | 403533 | 2020-08-05 | Clay | Missouri | 29047 | 974 | 22 |
400316 | 400316 | 2020-08-04 | Clay | Missouri | 29047 | 944 | 22 |
397102 | 397102 | 2020-08-03 | Clay | Missouri | 29047 | 914 | 22 |
393886 | 393886 | 2020-08-02 | Clay | Missouri | 29047 | 900 | 22 |
390669 | 390669 | 2020-08-01 | Clay | Missouri | 29047 | 896 | 22 |
387452 | 387452 | 2020-07-31 | Clay | Missouri | 29047 | 882 | 22 |
384234 | 384234 | 2020-07-30 | Clay | Missouri | 29047 | 857 | 22 |
381018 | 381018 | 2020-07-29 | Clay | Missouri | 29047 | 826 | 22 |
377801 | 377801 | 2020-07-28 | Clay | Missouri | 29047 | 784 | 22 |
374586 | 374586 | 2020-07-27 | Clay | Missouri | 29047 | 744 | 22 |
371374 | 371374 | 2020-07-26 | Clay | Missouri | 29047 | 717 | 22 |
368163 | 368163 | 2020-07-25 | Clay | Missouri | 29047 | 705 | 22 |
364955 | 364955 | 2020-07-24 | Clay | Missouri | 29047 | 688 | 22 |
361748 | 361748 | 2020-07-23 | Clay | Missouri | 29047 | 685 | 22 |
358543 | 358543 | 2020-07-22 | Clay | Missouri | 29047 | 655 | 22 |
355340 | 355340 | 2020-07-21 | Clay | Missouri | 29047 | 646 | 21 |
352138 | 352138 | 2020-07-20 | Clay | Missouri | 29047 | 630 | 21 |
348938 | 348938 | 2020-07-19 | Clay | Missouri | 29047 | 625 | 20 |
345737 | 345737 | 2020-07-18 | Clay | Missouri | 29047 | 617 | 20 |
342537 | 342537 | 2020-07-17 | Clay | Missouri | 29047 | 607 | 20 |
339341 | 339341 | 2020-07-16 | Clay | Missouri | 29047 | 597 | 20 |
336145 | 336145 | 2020-07-15 | Clay | Missouri | 29047 | 589 | 20 |
332952 | 332952 | 2020-07-14 | Clay | Missouri | 29047 | 579 | 20 |
329765 | 329765 | 2020-07-13 | Clay | Missouri | 29047 | 565 | 20 |
326579 | 326579 | 2020-07-12 | Clay | Missouri | 29047 | 558 | 20 |
323396 | 323396 | 2020-07-11 | Clay | Missouri | 29047 | 557 | 20 |
320217 | 320217 | 2020-07-10 | Clay | Missouri | 29047 | 550 | 20 |
317042 | 317042 | 2020-07-09 | Clay | Missouri | 29047 | 539 | 20 |
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);