ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Marion" and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
374627 | 374627 | 2020-07-27 | Marion | Missouri | 29127 | 92 | 1 |
377842 | 377842 | 2020-07-28 | Marion | Missouri | 29127 | 102 | 1 |
381059 | 381059 | 2020-07-29 | Marion | Missouri | 29127 | 111 | 1 |
384275 | 384275 | 2020-07-30 | Marion | Missouri | 29127 | 127 | 1 |
387493 | 387493 | 2020-07-31 | Marion | Missouri | 29127 | 139 | 1 |
390710 | 390710 | 2020-08-01 | Marion | Missouri | 29127 | 150 | 1 |
393927 | 393927 | 2020-08-02 | Marion | Missouri | 29127 | 150 | 1 |
397143 | 397143 | 2020-08-03 | Marion | Missouri | 29127 | 157 | 1 |
400357 | 400357 | 2020-08-04 | Marion | Missouri | 29127 | 160 | 1 |
403574 | 403574 | 2020-08-05 | Marion | Missouri | 29127 | 164 | 1 |
406792 | 406792 | 2020-08-06 | Marion | Missouri | 29127 | 171 | 1 |
410012 | 410012 | 2020-08-07 | Marion | Missouri | 29127 | 181 | 1 |
413232 | 413232 | 2020-08-08 | Marion | Missouri | 29127 | 181 | 1 |
416452 | 416452 | 2020-08-09 | Marion | Missouri | 29127 | 193 | 1 |
419673 | 419673 | 2020-08-10 | Marion | Missouri | 29127 | 201 | 1 |
422895 | 422895 | 2020-08-11 | Marion | Missouri | 29127 | 204 | 1 |
426117 | 426117 | 2020-08-12 | Marion | Missouri | 29127 | 223 | 1 |
429341 | 429341 | 2020-08-13 | Marion | Missouri | 29127 | 236 | 1 |
432568 | 432568 | 2020-08-14 | Marion | Missouri | 29127 | 256 | 1 |
435794 | 435794 | 2020-08-15 | Marion | Missouri | 29127 | 264 | 1 |
439019 | 439019 | 2020-08-16 | Marion | Missouri | 29127 | 269 | 1 |
442246 | 442246 | 2020-08-17 | Marion | Missouri | 29127 | 272 | 1 |
445472 | 445472 | 2020-08-18 | Marion | Missouri | 29127 | 278 | 1 |
448698 | 448698 | 2020-08-19 | Marion | Missouri | 29127 | 293 | 1 |
451926 | 451926 | 2020-08-20 | Marion | Missouri | 29127 | 307 | 1 |
455154 | 455154 | 2020-08-21 | Marion | Missouri | 29127 | 315 | 1 |
458382 | 458382 | 2020-08-22 | Marion | Missouri | 29127 | 325 | 1 |
461609 | 461609 | 2020-08-23 | Marion | Missouri | 29127 | 335 | 1 |
464840 | 464840 | 2020-08-24 | Marion | Missouri | 29127 | 349 | 1 |
468069 | 468069 | 2020-08-25 | Marion | Missouri | 29127 | 360 | 1 |
471299 | 471299 | 2020-08-26 | Marion | Missouri | 29127 | 365 | 1 |
474531 | 474531 | 2020-08-27 | Marion | Missouri | 29127 | 378 | 1 |
477764 | 477764 | 2020-08-28 | Marion | Missouri | 29127 | 425 | 1 |
480996 | 480996 | 2020-08-29 | Marion | Missouri | 29127 | 453 | 3 |
484231 | 484231 | 2020-08-30 | Marion | Missouri | 29127 | 463 | 3 |
487465 | 487465 | 2020-08-31 | Marion | Missouri | 29127 | 471 | 3 |
490698 | 490698 | 2020-09-01 | Marion | Missouri | 29127 | 483 | 3 |
493932 | 493932 | 2020-09-02 | Marion | Missouri | 29127 | 489 | 3 |
497165 | 497165 | 2020-09-03 | Marion | Missouri | 29127 | 497 | 3 |
500399 | 500399 | 2020-09-04 | Marion | Missouri | 29127 | 505 | 4 |
503633 | 503633 | 2020-09-05 | Marion | Missouri | 29127 | 531 | 7 |
506866 | 506866 | 2020-09-06 | Marion | Missouri | 29127 | 545 | 7 |
510099 | 510099 | 2020-09-07 | Marion | Missouri | 29127 | 558 | 7 |
513331 | 513331 | 2020-09-08 | Marion | Missouri | 29127 | 563 | 7 |
516565 | 516565 | 2020-09-09 | Marion | Missouri | 29127 | 571 | 7 |
519800 | 519800 | 2020-09-10 | Marion | Missouri | 29127 | 574 | 7 |
523037 | 523037 | 2020-09-11 | Marion | Missouri | 29127 | 575 | 7 |
526273 | 526273 | 2020-09-12 | Marion | Missouri | 29127 | 583 | 7 |
529509 | 529509 | 2020-09-13 | Marion | Missouri | 29127 | 595 | 7 |
532745 | 532745 | 2020-09-14 | Marion | Missouri | 29127 | 604 | 7 |
535980 | 535980 | 2020-09-15 | Marion | Missouri | 29127 | 610 | 7 |
539217 | 539217 | 2020-09-16 | Marion | Missouri | 29127 | 614 | 7 |
542453 | 542453 | 2020-09-17 | Marion | Missouri | 29127 | 620 | 7 |
545690 | 545690 | 2020-09-18 | Marion | Missouri | 29127 | 625 | 11 |
548928 | 548928 | 2020-09-19 | Marion | Missouri | 29127 | 626 | 14 |
552167 | 552167 | 2020-09-20 | Marion | Missouri | 29127 | 628 | 14 |
555405 | 555405 | 2020-09-21 | Marion | Missouri | 29127 | 631 | 14 |
558642 | 558642 | 2020-09-22 | Marion | Missouri | 29127 | 634 | 14 |
561879 | 561879 | 2020-09-23 | Marion | Missouri | 29127 | 643 | 14 |
565119 | 565119 | 2020-09-24 | Marion | Missouri | 29127 | 649 | 14 |
568359 | 568359 | 2020-09-25 | Marion | Missouri | 29127 | 651 | 14 |
571601 | 571601 | 2020-09-26 | Marion | Missouri | 29127 | 655 | 14 |
574844 | 574844 | 2020-09-27 | Marion | Missouri | 29127 | 663 | 14 |
578085 | 578085 | 2020-09-28 | Marion | Missouri | 29127 | 671 | 14 |
581326 | 581326 | 2020-09-29 | Marion | Missouri | 29127 | 671 | 14 |
584567 | 584567 | 2020-09-30 | Marion | Missouri | 29127 | 690 | 14 |
587807 | 587807 | 2020-10-01 | Marion | Missouri | 29127 | 700 | 14 |
591048 | 591048 | 2020-10-02 | Marion | Missouri | 29127 | 704 | 14 |
594289 | 594289 | 2020-10-03 | Marion | Missouri | 29127 | 708 | 14 |
597530 | 597530 | 2020-10-04 | Marion | Missouri | 29127 | 712 | 14 |
600773 | 600773 | 2020-10-05 | Marion | Missouri | 29127 | 718 | 14 |
604015 | 604015 | 2020-10-06 | Marion | Missouri | 29127 | 723 | 14 |
607258 | 607258 | 2020-10-07 | Marion | Missouri | 29127 | 730 | 14 |
610500 | 610500 | 2020-10-08 | Marion | Missouri | 29127 | 734 | 14 |
613742 | 613742 | 2020-10-09 | Marion | Missouri | 29127 | 742 | 14 |
616983 | 616983 | 2020-10-10 | Marion | Missouri | 29127 | 765 | 14 |
620225 | 620225 | 2020-10-11 | Marion | Missouri | 29127 | 765 | 14 |
623468 | 623468 | 2020-10-12 | Marion | Missouri | 29127 | 765 | 14 |
626710 | 626710 | 2020-10-13 | Marion | Missouri | 29127 | 765 | 14 |
629954 | 629954 | 2020-10-14 | Marion | Missouri | 29127 | 781 | 14 |
633199 | 633199 | 2020-10-15 | Marion | Missouri | 29127 | 789 | 14 |
636445 | 636445 | 2020-10-16 | Marion | Missouri | 29127 | 801 | 14 |
639691 | 639691 | 2020-10-17 | Marion | Missouri | 29127 | 804 | 14 |
642939 | 642939 | 2020-10-18 | Marion | Missouri | 29127 | 813 | 14 |
646185 | 646185 | 2020-10-19 | Marion | Missouri | 29127 | 822 | 14 |
649429 | 649429 | 2020-10-20 | Marion | Missouri | 29127 | 822 | 14 |
652674 | 652674 | 2020-10-21 | Marion | Missouri | 29127 | 850 | 14 |
655919 | 655919 | 2020-10-22 | Marion | Missouri | 29127 | 858 | 14 |
659164 | 659164 | 2020-10-23 | Marion | Missouri | 29127 | 871 | 14 |
662408 | 662408 | 2020-10-24 | Marion | Missouri | 29127 | 890 | 14 |
665653 | 665653 | 2020-10-25 | Marion | Missouri | 29127 | 901 | 14 |
668897 | 668897 | 2020-10-26 | Marion | Missouri | 29127 | 906 | 14 |
672139 | 672139 | 2020-10-27 | Marion | Missouri | 29127 | 929 | 14 |
675382 | 675382 | 2020-10-28 | Marion | Missouri | 29127 | 938 | 14 |
678624 | 678624 | 2020-10-29 | Marion | Missouri | 29127 | 950 | 14 |
681868 | 681868 | 2020-10-30 | Marion | Missouri | 29127 | 970 | 14 |
685111 | 685111 | 2020-10-31 | Marion | Missouri | 29127 | 991 | 14 |
688355 | 688355 | 2020-11-01 | Marion | Missouri | 29127 | 1008 | 14 |
691600 | 691600 | 2020-11-02 | Marion | Missouri | 29127 | 1028 | 14 |
694842 | 694842 | 2020-11-03 | Marion | Missouri | 29127 | 1065 | 14 |
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);