ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Monroe" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730419 | 730419 | 2020-11-14 | Monroe | Mississippi | 28095 | 1742 | 76 |
727176 | 727176 | 2020-11-13 | Monroe | Mississippi | 28095 | 1726 | 76 |
723933 | 723933 | 2020-11-12 | Monroe | Mississippi | 28095 | 1706 | 76 |
720690 | 720690 | 2020-11-11 | Monroe | Mississippi | 28095 | 1690 | 76 |
717447 | 717447 | 2020-11-10 | Monroe | Mississippi | 28095 | 1678 | 76 |
714203 | 714203 | 2020-11-09 | Monroe | Mississippi | 28095 | 1670 | 75 |
710959 | 710959 | 2020-11-08 | Monroe | Mississippi | 28095 | 1660 | 75 |
707715 | 707715 | 2020-11-07 | Monroe | Mississippi | 28095 | 1653 | 75 |
704472 | 704472 | 2020-11-06 | Monroe | Mississippi | 28095 | 1640 | 75 |
701230 | 701230 | 2020-11-05 | Monroe | Mississippi | 28095 | 1629 | 75 |
697986 | 697986 | 2020-11-04 | Monroe | Mississippi | 28095 | 1607 | 75 |
694743 | 694743 | 2020-11-03 | Monroe | Mississippi | 28095 | 1595 | 75 |
691501 | 691501 | 2020-11-02 | Monroe | Mississippi | 28095 | 1582 | 74 |
688256 | 688256 | 2020-11-01 | Monroe | Mississippi | 28095 | 1577 | 74 |
685012 | 685012 | 2020-10-31 | Monroe | Mississippi | 28095 | 1571 | 74 |
681769 | 681769 | 2020-10-30 | Monroe | Mississippi | 28095 | 1554 | 74 |
678525 | 678525 | 2020-10-29 | Monroe | Mississippi | 28095 | 1548 | 73 |
675283 | 675283 | 2020-10-28 | Monroe | Mississippi | 28095 | 1538 | 73 |
672040 | 672040 | 2020-10-27 | Monroe | Mississippi | 28095 | 1530 | 73 |
668798 | 668798 | 2020-10-26 | Monroe | Mississippi | 28095 | 1521 | 73 |
665554 | 665554 | 2020-10-25 | Monroe | Mississippi | 28095 | 1506 | 73 |
662309 | 662309 | 2020-10-24 | Monroe | Mississippi | 28095 | 1506 | 73 |
659065 | 659065 | 2020-10-23 | Monroe | Mississippi | 28095 | 1481 | 72 |
655820 | 655820 | 2020-10-22 | Monroe | Mississippi | 28095 | 1473 | 72 |
652575 | 652575 | 2020-10-21 | Monroe | Mississippi | 28095 | 1465 | 72 |
649330 | 649330 | 2020-10-20 | Monroe | Mississippi | 28095 | 1459 | 72 |
646086 | 646086 | 2020-10-19 | Monroe | Mississippi | 28095 | 1448 | 72 |
642839 | 642839 | 2020-10-18 | Monroe | Mississippi | 28095 | 1436 | 72 |
639592 | 639592 | 2020-10-17 | Monroe | Mississippi | 28095 | 1436 | 72 |
636346 | 636346 | 2020-10-16 | Monroe | Mississippi | 28095 | 1422 | 72 |
633100 | 633100 | 2020-10-15 | Monroe | Mississippi | 28095 | 1410 | 72 |
629855 | 629855 | 2020-10-14 | Monroe | Mississippi | 28095 | 1402 | 72 |
626611 | 626611 | 2020-10-13 | Monroe | Mississippi | 28095 | 1386 | 72 |
623369 | 623369 | 2020-10-12 | Monroe | Mississippi | 28095 | 1378 | 71 |
620126 | 620126 | 2020-10-11 | Monroe | Mississippi | 28095 | 1363 | 71 |
616884 | 616884 | 2020-10-10 | Monroe | Mississippi | 28095 | 1347 | 71 |
613643 | 613643 | 2020-10-09 | Monroe | Mississippi | 28095 | 1332 | 71 |
610401 | 610401 | 2020-10-08 | Monroe | Mississippi | 28095 | 1320 | 71 |
607159 | 607159 | 2020-10-07 | Monroe | Mississippi | 28095 | 1308 | 70 |
603916 | 603916 | 2020-10-06 | Monroe | Mississippi | 28095 | 1303 | 70 |
600674 | 600674 | 2020-10-05 | Monroe | Mississippi | 28095 | 1294 | 70 |
597431 | 597431 | 2020-10-04 | Monroe | Mississippi | 28095 | 1287 | 70 |
594190 | 594190 | 2020-10-03 | Monroe | Mississippi | 28095 | 1283 | 70 |
590949 | 590949 | 2020-10-02 | Monroe | Mississippi | 28095 | 1274 | 69 |
587708 | 587708 | 2020-10-01 | Monroe | Mississippi | 28095 | 1268 | 69 |
584468 | 584468 | 2020-09-30 | Monroe | Mississippi | 28095 | 1253 | 69 |
581227 | 581227 | 2020-09-29 | Monroe | Mississippi | 28095 | 1246 | 69 |
577986 | 577986 | 2020-09-28 | Monroe | Mississippi | 28095 | 1239 | 69 |
574745 | 574745 | 2020-09-27 | Monroe | Mississippi | 28095 | 1236 | 69 |
571502 | 571502 | 2020-09-26 | Monroe | Mississippi | 28095 | 1235 | 68 |
568260 | 568260 | 2020-09-25 | Monroe | Mississippi | 28095 | 1228 | 68 |
565020 | 565020 | 2020-09-24 | Monroe | Mississippi | 28095 | 1221 | 68 |
561780 | 561780 | 2020-09-23 | Monroe | Mississippi | 28095 | 1207 | 68 |
558543 | 558543 | 2020-09-22 | Monroe | Mississippi | 28095 | 1199 | 66 |
555306 | 555306 | 2020-09-21 | Monroe | Mississippi | 28095 | 1189 | 65 |
552068 | 552068 | 2020-09-20 | Monroe | Mississippi | 28095 | 1188 | 65 |
548829 | 548829 | 2020-09-19 | Monroe | Mississippi | 28095 | 1183 | 65 |
545591 | 545591 | 2020-09-18 | Monroe | Mississippi | 28095 | 1182 | 65 |
542354 | 542354 | 2020-09-17 | Monroe | Mississippi | 28095 | 1176 | 65 |
539118 | 539118 | 2020-09-16 | Monroe | Mississippi | 28095 | 1166 | 65 |
535881 | 535881 | 2020-09-15 | Monroe | Mississippi | 28095 | 1151 | 65 |
532646 | 532646 | 2020-09-14 | Monroe | Mississippi | 28095 | 1146 | 65 |
529410 | 529410 | 2020-09-13 | Monroe | Mississippi | 28095 | 1144 | 65 |
526174 | 526174 | 2020-09-12 | Monroe | Mississippi | 28095 | 1143 | 64 |
522938 | 522938 | 2020-09-11 | Monroe | Mississippi | 28095 | 1134 | 64 |
519701 | 519701 | 2020-09-10 | Monroe | Mississippi | 28095 | 1124 | 64 |
516466 | 516466 | 2020-09-09 | Monroe | Mississippi | 28095 | 1114 | 61 |
513232 | 513232 | 2020-09-08 | Monroe | Mississippi | 28095 | 1110 | 61 |
510000 | 510000 | 2020-09-07 | Monroe | Mississippi | 28095 | 1100 | 61 |
506767 | 506767 | 2020-09-06 | Monroe | Mississippi | 28095 | 1098 | 61 |
503534 | 503534 | 2020-09-05 | Monroe | Mississippi | 28095 | 1092 | 61 |
500300 | 500300 | 2020-09-04 | Monroe | Mississippi | 28095 | 1086 | 61 |
497066 | 497066 | 2020-09-03 | Monroe | Mississippi | 28095 | 1067 | 60 |
493833 | 493833 | 2020-09-02 | Monroe | Mississippi | 28095 | 1059 | 60 |
490599 | 490599 | 2020-09-01 | Monroe | Mississippi | 28095 | 1046 | 59 |
487366 | 487366 | 2020-08-31 | Monroe | Mississippi | 28095 | 1037 | 59 |
484132 | 484132 | 2020-08-30 | Monroe | Mississippi | 28095 | 1035 | 57 |
480897 | 480897 | 2020-08-29 | Monroe | Mississippi | 28095 | 1025 | 57 |
477665 | 477665 | 2020-08-28 | Monroe | Mississippi | 28095 | 1012 | 56 |
474432 | 474432 | 2020-08-27 | Monroe | Mississippi | 28095 | 1009 | 56 |
471200 | 471200 | 2020-08-26 | Monroe | Mississippi | 28095 | 996 | 56 |
467970 | 467970 | 2020-08-25 | Monroe | Mississippi | 28095 | 984 | 56 |
464741 | 464741 | 2020-08-24 | Monroe | Mississippi | 28095 | 974 | 56 |
461510 | 461510 | 2020-08-23 | Monroe | Mississippi | 28095 | 967 | 56 |
458283 | 458283 | 2020-08-22 | Monroe | Mississippi | 28095 | 965 | 56 |
455055 | 455055 | 2020-08-21 | Monroe | Mississippi | 28095 | 950 | 56 |
451827 | 451827 | 2020-08-20 | Monroe | Mississippi | 28095 | 938 | 56 |
448599 | 448599 | 2020-08-19 | Monroe | Mississippi | 28095 | 918 | 55 |
445373 | 445373 | 2020-08-18 | Monroe | Mississippi | 28095 | 893 | 55 |
442147 | 442147 | 2020-08-17 | Monroe | Mississippi | 28095 | 883 | 55 |
438920 | 438920 | 2020-08-16 | Monroe | Mississippi | 28095 | 873 | 55 |
435695 | 435695 | 2020-08-15 | Monroe | Mississippi | 28095 | 868 | 55 |
432469 | 432469 | 2020-08-14 | Monroe | Mississippi | 28095 | 858 | 55 |
429242 | 429242 | 2020-08-13 | Monroe | Mississippi | 28095 | 839 | 55 |
426018 | 426018 | 2020-08-12 | Monroe | Mississippi | 28095 | 831 | 55 |
422796 | 422796 | 2020-08-11 | Monroe | Mississippi | 28095 | 821 | 55 |
419574 | 419574 | 2020-08-10 | Monroe | Mississippi | 28095 | 801 | 55 |
416353 | 416353 | 2020-08-09 | Monroe | Mississippi | 28095 | 796 | 55 |
413133 | 413133 | 2020-08-08 | Monroe | Mississippi | 28095 | 778 | 53 |
409913 | 409913 | 2020-08-07 | Monroe | Mississippi | 28095 | 769 | 52 |
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);