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 |
---|---|---|---|---|---|---|---|
1064738 | 1064738 | 2021-02-25 | Yazoo | Mississippi | 28163 | 2838 | 62 |
1061494 | 1061494 | 2021-02-24 | Yazoo | Mississippi | 28163 | 2832 | 62 |
1058248 | 1058248 | 2021-02-23 | Yazoo | Mississippi | 28163 | 2826 | 62 |
1055002 | 1055002 | 2021-02-22 | Yazoo | Mississippi | 28163 | 2824 | 62 |
1051755 | 1051755 | 2021-02-21 | Yazoo | Mississippi | 28163 | 2822 | 62 |
1048508 | 1048508 | 2021-02-20 | Yazoo | Mississippi | 28163 | 2824 | 62 |
1045262 | 1045262 | 2021-02-19 | Yazoo | Mississippi | 28163 | 2822 | 62 |
1042017 | 1042017 | 2021-02-18 | Yazoo | Mississippi | 28163 | 2821 | 62 |
1038772 | 1038772 | 2021-02-17 | Yazoo | Mississippi | 28163 | 2821 | 62 |
1035527 | 1035527 | 2021-02-16 | Yazoo | Mississippi | 28163 | 2815 | 61 |
1032282 | 1032282 | 2021-02-15 | Yazoo | Mississippi | 28163 | 2810 | 60 |
1029035 | 1029035 | 2021-02-14 | Yazoo | Mississippi | 28163 | 2803 | 60 |
1025789 | 1025789 | 2021-02-13 | Yazoo | Mississippi | 28163 | 2785 | 60 |
1022544 | 1022544 | 2021-02-12 | Yazoo | Mississippi | 28163 | 2775 | 60 |
1019299 | 1019299 | 2021-02-11 | Yazoo | Mississippi | 28163 | 2770 | 60 |
1016054 | 1016054 | 2021-02-10 | Yazoo | Mississippi | 28163 | 2768 | 60 |
1012809 | 1012809 | 2021-02-09 | Yazoo | Mississippi | 28163 | 2759 | 60 |
1009564 | 1009564 | 2021-02-08 | Yazoo | Mississippi | 28163 | 2758 | 59 |
1006317 | 1006317 | 2021-02-07 | Yazoo | Mississippi | 28163 | 2745 | 59 |
1003071 | 1003071 | 2021-02-06 | Yazoo | Mississippi | 28163 | 2733 | 59 |
999826 | 999826 | 2021-02-05 | Yazoo | Mississippi | 28163 | 2718 | 59 |
996580 | 996580 | 2021-02-04 | Yazoo | Mississippi | 28163 | 2714 | 59 |
993334 | 993334 | 2021-02-03 | Yazoo | Mississippi | 28163 | 2706 | 59 |
990088 | 990088 | 2021-02-02 | Yazoo | Mississippi | 28163 | 2693 | 59 |
986841 | 986841 | 2021-02-01 | Yazoo | Mississippi | 28163 | 2683 | 57 |
983594 | 983594 | 2021-01-31 | Yazoo | Mississippi | 28163 | 2673 | 57 |
980348 | 980348 | 2021-01-30 | Yazoo | Mississippi | 28163 | 2668 | 57 |
977102 | 977102 | 2021-01-29 | Yazoo | Mississippi | 28163 | 2642 | 57 |
973857 | 973857 | 2021-01-28 | Yazoo | Mississippi | 28163 | 2621 | 56 |
970612 | 970612 | 2021-01-27 | Yazoo | Mississippi | 28163 | 2599 | 56 |
967367 | 967367 | 2021-01-26 | Yazoo | Mississippi | 28163 | 2584 | 56 |
964123 | 964123 | 2021-01-25 | Yazoo | Mississippi | 28163 | 2571 | 56 |
960878 | 960878 | 2021-01-24 | Yazoo | Mississippi | 28163 | 2567 | 56 |
957632 | 957632 | 2021-01-23 | Yazoo | Mississippi | 28163 | 2552 | 56 |
954387 | 954387 | 2021-01-22 | Yazoo | Mississippi | 28163 | 2537 | 56 |
951142 | 951142 | 2021-01-21 | Yazoo | Mississippi | 28163 | 2501 | 56 |
947896 | 947896 | 2021-01-20 | Yazoo | Mississippi | 28163 | 2473 | 56 |
944649 | 944649 | 2021-01-19 | Yazoo | Mississippi | 28163 | 2470 | 56 |
941404 | 941404 | 2021-01-18 | Yazoo | Mississippi | 28163 | 2459 | 55 |
938159 | 938159 | 2021-01-17 | Yazoo | Mississippi | 28163 | 2443 | 55 |
934914 | 934914 | 2021-01-16 | Yazoo | Mississippi | 28163 | 2426 | 54 |
931669 | 931669 | 2021-01-15 | Yazoo | Mississippi | 28163 | 2377 | 54 |
928424 | 928424 | 2021-01-14 | Yazoo | Mississippi | 28163 | 2350 | 54 |
925178 | 925178 | 2021-01-13 | Yazoo | Mississippi | 28163 | 2339 | 53 |
921933 | 921933 | 2021-01-12 | Yazoo | Mississippi | 28163 | 2323 | 53 |
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 |
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);