ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Monroe" and fips = 28095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921899 | 921899 | 2021-01-12 | Monroe | Mississippi | 28095 | 3409 | 100 |
918654 | 918654 | 2021-01-11 | Monroe | Mississippi | 28095 | 3394 | 98 |
915409 | 915409 | 2021-01-10 | Monroe | Mississippi | 28095 | 3380 | 96 |
912164 | 912164 | 2021-01-09 | Monroe | Mississippi | 28095 | 3369 | 96 |
908919 | 908919 | 2021-01-08 | Monroe | Mississippi | 28095 | 3323 | 95 |
905673 | 905673 | 2021-01-07 | Monroe | Mississippi | 28095 | 3303 | 93 |
902428 | 902428 | 2021-01-06 | Monroe | Mississippi | 28095 | 3241 | 91 |
899183 | 899183 | 2021-01-05 | Monroe | Mississippi | 28095 | 3184 | 91 |
895938 | 895938 | 2021-01-04 | Monroe | Mississippi | 28095 | 3137 | 90 |
892691 | 892691 | 2021-01-03 | Monroe | Mississippi | 28095 | 3119 | 90 |
889445 | 889445 | 2021-01-02 | Monroe | Mississippi | 28095 | 3090 | 90 |
886199 | 886199 | 2021-01-01 | Monroe | Mississippi | 28095 | 3061 | 89 |
882954 | 882954 | 2020-12-31 | Monroe | Mississippi | 28095 | 3007 | 89 |
879709 | 879709 | 2020-12-30 | Monroe | Mississippi | 28095 | 2947 | 89 |
876464 | 876464 | 2020-12-29 | Monroe | Mississippi | 28095 | 2899 | 88 |
873219 | 873219 | 2020-12-28 | Monroe | Mississippi | 28095 | 2854 | 85 |
869974 | 869974 | 2020-12-27 | Monroe | Mississippi | 28095 | 2833 | 85 |
866729 | 866729 | 2020-12-26 | Monroe | Mississippi | 28095 | 2821 | 84 |
863484 | 863484 | 2020-12-25 | Monroe | Mississippi | 28095 | 2815 | 84 |
860239 | 860239 | 2020-12-24 | Monroe | Mississippi | 28095 | 2799 | 84 |
856994 | 856994 | 2020-12-23 | Monroe | Mississippi | 28095 | 2773 | 84 |
853749 | 853749 | 2020-12-22 | Monroe | Mississippi | 28095 | 2725 | 84 |
850504 | 850504 | 2020-12-21 | Monroe | Mississippi | 28095 | 2677 | 83 |
847259 | 847259 | 2020-12-20 | Monroe | Mississippi | 28095 | 2667 | 83 |
844013 | 844013 | 2020-12-19 | Monroe | Mississippi | 28095 | 2641 | 83 |
840768 | 840768 | 2020-12-18 | Monroe | Mississippi | 28095 | 2613 | 83 |
837523 | 837523 | 2020-12-17 | Monroe | Mississippi | 28095 | 2580 | 83 |
834277 | 834277 | 2020-12-16 | Monroe | Mississippi | 28095 | 2547 | 82 |
831030 | 831030 | 2020-12-15 | Monroe | Mississippi | 28095 | 2504 | 81 |
827784 | 827784 | 2020-12-14 | Monroe | Mississippi | 28095 | 2459 | 80 |
824537 | 824537 | 2020-12-13 | Monroe | Mississippi | 28095 | 2429 | 80 |
821291 | 821291 | 2020-12-12 | Monroe | Mississippi | 28095 | 2419 | 80 |
818045 | 818045 | 2020-12-11 | Monroe | Mississippi | 28095 | 2387 | 80 |
814799 | 814799 | 2020-12-10 | Monroe | Mississippi | 28095 | 2359 | 79 |
811554 | 811554 | 2020-12-09 | Monroe | Mississippi | 28095 | 2325 | 78 |
808309 | 808309 | 2020-12-08 | Monroe | Mississippi | 28095 | 2287 | 78 |
805064 | 805064 | 2020-12-07 | Monroe | Mississippi | 28095 | 2236 | 78 |
801819 | 801819 | 2020-12-06 | Monroe | Mississippi | 28095 | 2217 | 78 |
798574 | 798574 | 2020-12-05 | Monroe | Mississippi | 28095 | 2192 | 78 |
795329 | 795329 | 2020-12-04 | Monroe | Mississippi | 28095 | 2162 | 78 |
792084 | 792084 | 2020-12-03 | Monroe | Mississippi | 28095 | 2122 | 78 |
788839 | 788839 | 2020-12-02 | Monroe | Mississippi | 28095 | 2097 | 78 |
785594 | 785594 | 2020-12-01 | Monroe | Mississippi | 28095 | 2067 | 78 |
782350 | 782350 | 2020-11-30 | Monroe | Mississippi | 28095 | 2039 | 78 |
779104 | 779104 | 2020-11-29 | Monroe | Mississippi | 28095 | 2010 | 78 |
775859 | 775859 | 2020-11-28 | Monroe | Mississippi | 28095 | 1981 | 77 |
772614 | 772614 | 2020-11-27 | Monroe | Mississippi | 28095 | 1973 | 77 |
769369 | 769369 | 2020-11-26 | Monroe | Mississippi | 28095 | 1960 | 77 |
766123 | 766123 | 2020-11-25 | Monroe | Mississippi | 28095 | 1914 | 77 |
762878 | 762878 | 2020-11-24 | Monroe | Mississippi | 28095 | 1902 | 77 |
759633 | 759633 | 2020-11-23 | Monroe | Mississippi | 28095 | 1895 | 77 |
756386 | 756386 | 2020-11-22 | Monroe | Mississippi | 28095 | 1888 | 77 |
753140 | 753140 | 2020-11-21 | Monroe | Mississippi | 28095 | 1882 | 77 |
749894 | 749894 | 2020-11-20 | Monroe | Mississippi | 28095 | 1857 | 77 |
746648 | 746648 | 2020-11-19 | Monroe | Mississippi | 28095 | 1827 | 77 |
743401 | 743401 | 2020-11-18 | Monroe | Mississippi | 28095 | 1810 | 76 |
740154 | 740154 | 2020-11-17 | Monroe | Mississippi | 28095 | 1787 | 76 |
736910 | 736910 | 2020-11-16 | Monroe | Mississippi | 28095 | 1758 | 76 |
733664 | 733664 | 2020-11-15 | Monroe | Mississippi | 28095 | 1753 | 76 |
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 |
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);