ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28163 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918688 | 918688 | 2021-01-11 | Yazoo | Mississippi | 28163 | 2306 | 52 |
915443 | 915443 | 2021-01-10 | Yazoo | Mississippi | 28163 | 2302 | 52 |
912198 | 912198 | 2021-01-09 | Yazoo | Mississippi | 28163 | 2286 | 52 |
908953 | 908953 | 2021-01-08 | Yazoo | Mississippi | 28163 | 2235 | 52 |
905707 | 905707 | 2021-01-07 | Yazoo | Mississippi | 28163 | 2216 | 51 |
902462 | 902462 | 2021-01-06 | Yazoo | Mississippi | 28163 | 2190 | 51 |
899217 | 899217 | 2021-01-05 | Yazoo | Mississippi | 28163 | 2184 | 50 |
895972 | 895972 | 2021-01-04 | Yazoo | Mississippi | 28163 | 2172 | 50 |
892725 | 892725 | 2021-01-03 | Yazoo | Mississippi | 28163 | 2161 | 50 |
889479 | 889479 | 2021-01-02 | Yazoo | Mississippi | 28163 | 2143 | 50 |
886233 | 886233 | 2021-01-01 | Yazoo | Mississippi | 28163 | 2133 | 50 |
882988 | 882988 | 2020-12-31 | Yazoo | Mississippi | 28163 | 2114 | 50 |
879743 | 879743 | 2020-12-30 | Yazoo | Mississippi | 28163 | 2083 | 50 |
876498 | 876498 | 2020-12-29 | Yazoo | Mississippi | 28163 | 2060 | 50 |
873253 | 873253 | 2020-12-28 | Yazoo | Mississippi | 28163 | 2049 | 50 |
870008 | 870008 | 2020-12-27 | Yazoo | Mississippi | 28163 | 2031 | 50 |
866763 | 866763 | 2020-12-26 | Yazoo | Mississippi | 28163 | 2012 | 50 |
863518 | 863518 | 2020-12-25 | Yazoo | Mississippi | 28163 | 2005 | 50 |
860273 | 860273 | 2020-12-24 | Yazoo | Mississippi | 28163 | 1997 | 50 |
857028 | 857028 | 2020-12-23 | Yazoo | Mississippi | 28163 | 1985 | 50 |
853783 | 853783 | 2020-12-22 | Yazoo | Mississippi | 28163 | 1970 | 50 |
850538 | 850538 | 2020-12-21 | Yazoo | Mississippi | 28163 | 1952 | 50 |
847293 | 847293 | 2020-12-20 | Yazoo | Mississippi | 28163 | 1948 | 50 |
844047 | 844047 | 2020-12-19 | Yazoo | Mississippi | 28163 | 1941 | 47 |
840802 | 840802 | 2020-12-18 | Yazoo | Mississippi | 28163 | 1936 | 45 |
837557 | 837557 | 2020-12-17 | Yazoo | Mississippi | 28163 | 1829 | 44 |
834311 | 834311 | 2020-12-16 | Yazoo | Mississippi | 28163 | 1821 | 44 |
831064 | 831064 | 2020-12-15 | Yazoo | Mississippi | 28163 | 1808 | 43 |
827818 | 827818 | 2020-12-14 | Yazoo | Mississippi | 28163 | 1802 | 42 |
824571 | 824571 | 2020-12-13 | Yazoo | Mississippi | 28163 | 1794 | 42 |
821325 | 821325 | 2020-12-12 | Yazoo | Mississippi | 28163 | 1781 | 42 |
818079 | 818079 | 2020-12-11 | Yazoo | Mississippi | 28163 | 1758 | 42 |
814833 | 814833 | 2020-12-10 | Yazoo | Mississippi | 28163 | 1726 | 42 |
811588 | 811588 | 2020-12-09 | Yazoo | Mississippi | 28163 | 1714 | 42 |
808343 | 808343 | 2020-12-08 | Yazoo | Mississippi | 28163 | 1707 | 42 |
805098 | 805098 | 2020-12-07 | Yazoo | Mississippi | 28163 | 1703 | 41 |
801853 | 801853 | 2020-12-06 | Yazoo | Mississippi | 28163 | 1696 | 41 |
798608 | 798608 | 2020-12-05 | Yazoo | Mississippi | 28163 | 1688 | 41 |
795363 | 795363 | 2020-12-04 | Yazoo | Mississippi | 28163 | 1644 | 41 |
792118 | 792118 | 2020-12-03 | Yazoo | Mississippi | 28163 | 1629 | 40 |
788873 | 788873 | 2020-12-02 | Yazoo | Mississippi | 28163 | 1613 | 40 |
785628 | 785628 | 2020-12-01 | Yazoo | Mississippi | 28163 | 1601 | 40 |
782384 | 782384 | 2020-11-30 | Yazoo | Mississippi | 28163 | 1588 | 40 |
779138 | 779138 | 2020-11-29 | Yazoo | Mississippi | 28163 | 1579 | 40 |
775893 | 775893 | 2020-11-28 | Yazoo | Mississippi | 28163 | 1560 | 39 |
772648 | 772648 | 2020-11-27 | Yazoo | Mississippi | 28163 | 1542 | 39 |
769403 | 769403 | 2020-11-26 | Yazoo | Mississippi | 28163 | 1529 | 39 |
766157 | 766157 | 2020-11-25 | Yazoo | Mississippi | 28163 | 1520 | 39 |
762912 | 762912 | 2020-11-24 | Yazoo | Mississippi | 28163 | 1512 | 39 |
759667 | 759667 | 2020-11-23 | Yazoo | Mississippi | 28163 | 1506 | 38 |
756420 | 756420 | 2020-11-22 | Yazoo | Mississippi | 28163 | 1495 | 38 |
753174 | 753174 | 2020-11-21 | Yazoo | Mississippi | 28163 | 1468 | 37 |
749928 | 749928 | 2020-11-20 | Yazoo | Mississippi | 28163 | 1455 | 36 |
746682 | 746682 | 2020-11-19 | Yazoo | Mississippi | 28163 | 1433 | 36 |
743435 | 743435 | 2020-11-18 | Yazoo | Mississippi | 28163 | 1428 | 36 |
740188 | 740188 | 2020-11-17 | Yazoo | Mississippi | 28163 | 1425 | 36 |
736944 | 736944 | 2020-11-16 | Yazoo | Mississippi | 28163 | 1421 | 36 |
733698 | 733698 | 2020-11-15 | Yazoo | Mississippi | 28163 | 1418 | 36 |
730453 | 730453 | 2020-11-14 | Yazoo | Mississippi | 28163 | 1413 | 36 |
727210 | 727210 | 2020-11-13 | Yazoo | Mississippi | 28163 | 1406 | 36 |
723967 | 723967 | 2020-11-12 | Yazoo | Mississippi | 28163 | 1404 | 36 |
720724 | 720724 | 2020-11-11 | Yazoo | Mississippi | 28163 | 1395 | 36 |
717481 | 717481 | 2020-11-10 | Yazoo | Mississippi | 28163 | 1394 | 36 |
714237 | 714237 | 2020-11-09 | Yazoo | Mississippi | 28163 | 1389 | 36 |
710993 | 710993 | 2020-11-08 | Yazoo | Mississippi | 28163 | 1383 | 36 |
707749 | 707749 | 2020-11-07 | Yazoo | Mississippi | 28163 | 1341 | 36 |
704506 | 704506 | 2020-11-06 | Yazoo | Mississippi | 28163 | 1327 | 36 |
701264 | 701264 | 2020-11-05 | Yazoo | Mississippi | 28163 | 1323 | 36 |
698020 | 698020 | 2020-11-04 | Yazoo | Mississippi | 28163 | 1317 | 36 |
694777 | 694777 | 2020-11-03 | Yazoo | Mississippi | 28163 | 1312 | 35 |
691535 | 691535 | 2020-11-02 | Yazoo | Mississippi | 28163 | 1291 | 35 |
688290 | 688290 | 2020-11-01 | Yazoo | Mississippi | 28163 | 1277 | 35 |
685046 | 685046 | 2020-10-31 | Yazoo | Mississippi | 28163 | 1260 | 35 |
681803 | 681803 | 2020-10-30 | Yazoo | Mississippi | 28163 | 1254 | 35 |
678559 | 678559 | 2020-10-29 | Yazoo | Mississippi | 28163 | 1245 | 34 |
675317 | 675317 | 2020-10-28 | Yazoo | Mississippi | 28163 | 1234 | 34 |
672074 | 672074 | 2020-10-27 | Yazoo | Mississippi | 28163 | 1227 | 34 |
668832 | 668832 | 2020-10-26 | Yazoo | Mississippi | 28163 | 1226 | 34 |
665588 | 665588 | 2020-10-25 | Yazoo | Mississippi | 28163 | 1222 | 34 |
662343 | 662343 | 2020-10-24 | Yazoo | Mississippi | 28163 | 1222 | 34 |
659099 | 659099 | 2020-10-23 | Yazoo | Mississippi | 28163 | 1217 | 33 |
655854 | 655854 | 2020-10-22 | Yazoo | Mississippi | 28163 | 1207 | 33 |
652609 | 652609 | 2020-10-21 | Yazoo | Mississippi | 28163 | 1199 | 33 |
649364 | 649364 | 2020-10-20 | Yazoo | Mississippi | 28163 | 1193 | 33 |
646120 | 646120 | 2020-10-19 | Yazoo | Mississippi | 28163 | 1172 | 33 |
642874 | 642874 | 2020-10-18 | Yazoo | Mississippi | 28163 | 1169 | 33 |
639626 | 639626 | 2020-10-17 | Yazoo | Mississippi | 28163 | 1169 | 33 |
636380 | 636380 | 2020-10-16 | Yazoo | Mississippi | 28163 | 1160 | 33 |
633134 | 633134 | 2020-10-15 | Yazoo | Mississippi | 28163 | 1140 | 33 |
629889 | 629889 | 2020-10-14 | Yazoo | Mississippi | 28163 | 1126 | 33 |
626645 | 626645 | 2020-10-13 | Yazoo | Mississippi | 28163 | 1109 | 33 |
623403 | 623403 | 2020-10-12 | Yazoo | Mississippi | 28163 | 1103 | 33 |
620160 | 620160 | 2020-10-11 | Yazoo | Mississippi | 28163 | 1101 | 33 |
616918 | 616918 | 2020-10-10 | Yazoo | Mississippi | 28163 | 1101 | 33 |
613677 | 613677 | 2020-10-09 | Yazoo | Mississippi | 28163 | 1098 | 33 |
610435 | 610435 | 2020-10-08 | Yazoo | Mississippi | 28163 | 1091 | 33 |
607193 | 607193 | 2020-10-07 | Yazoo | Mississippi | 28163 | 1088 | 33 |
603950 | 603950 | 2020-10-06 | Yazoo | Mississippi | 28163 | 1086 | 33 |
600708 | 600708 | 2020-10-05 | Yazoo | Mississippi | 28163 | 1084 | 33 |
597465 | 597465 | 2020-10-04 | Yazoo | Mississippi | 28163 | 1083 | 33 |
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);