ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 28083 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054962 | 1054962 | 2021-02-22 | Leflore | Mississippi | 28083 | 3341 | 117 |
1051715 | 1051715 | 2021-02-21 | Leflore | Mississippi | 28083 | 3336 | 117 |
1048468 | 1048468 | 2021-02-20 | Leflore | Mississippi | 28083 | 3333 | 117 |
1045222 | 1045222 | 2021-02-19 | Leflore | Mississippi | 28083 | 3330 | 117 |
1041977 | 1041977 | 2021-02-18 | Leflore | Mississippi | 28083 | 3329 | 117 |
1038732 | 1038732 | 2021-02-17 | Leflore | Mississippi | 28083 | 3328 | 117 |
1035487 | 1035487 | 2021-02-16 | Leflore | Mississippi | 28083 | 3320 | 117 |
1032242 | 1032242 | 2021-02-15 | Leflore | Mississippi | 28083 | 3314 | 117 |
1028995 | 1028995 | 2021-02-14 | Leflore | Mississippi | 28083 | 3311 | 117 |
1025749 | 1025749 | 2021-02-13 | Leflore | Mississippi | 28083 | 3299 | 117 |
1022504 | 1022504 | 2021-02-12 | Leflore | Mississippi | 28083 | 3290 | 116 |
1019259 | 1019259 | 2021-02-11 | Leflore | Mississippi | 28083 | 3284 | 116 |
1016014 | 1016014 | 2021-02-10 | Leflore | Mississippi | 28083 | 3274 | 116 |
1012769 | 1012769 | 2021-02-09 | Leflore | Mississippi | 28083 | 3271 | 116 |
1009524 | 1009524 | 2021-02-08 | Leflore | Mississippi | 28083 | 3261 | 115 |
1006277 | 1006277 | 2021-02-07 | Leflore | Mississippi | 28083 | 3258 | 115 |
1003031 | 1003031 | 2021-02-06 | Leflore | Mississippi | 28083 | 3254 | 115 |
999786 | 999786 | 2021-02-05 | Leflore | Mississippi | 28083 | 3246 | 114 |
996540 | 996540 | 2021-02-04 | Leflore | Mississippi | 28083 | 3224 | 114 |
993294 | 993294 | 2021-02-03 | Leflore | Mississippi | 28083 | 3220 | 114 |
990048 | 990048 | 2021-02-02 | Leflore | Mississippi | 28083 | 3217 | 114 |
986801 | 986801 | 2021-02-01 | Leflore | Mississippi | 28083 | 3210 | 114 |
983554 | 983554 | 2021-01-31 | Leflore | Mississippi | 28083 | 3204 | 114 |
980308 | 980308 | 2021-01-30 | Leflore | Mississippi | 28083 | 3193 | 114 |
977062 | 977062 | 2021-01-29 | Leflore | Mississippi | 28083 | 3188 | 114 |
973817 | 973817 | 2021-01-28 | Leflore | Mississippi | 28083 | 3172 | 110 |
970572 | 970572 | 2021-01-27 | Leflore | Mississippi | 28083 | 3148 | 110 |
967327 | 967327 | 2021-01-26 | Leflore | Mississippi | 28083 | 3132 | 110 |
964083 | 964083 | 2021-01-25 | Leflore | Mississippi | 28083 | 3122 | 109 |
960838 | 960838 | 2021-01-24 | Leflore | Mississippi | 28083 | 3118 | 109 |
957592 | 957592 | 2021-01-23 | Leflore | Mississippi | 28083 | 3111 | 109 |
954347 | 954347 | 2021-01-22 | Leflore | Mississippi | 28083 | 3090 | 109 |
951102 | 951102 | 2021-01-21 | Leflore | Mississippi | 28083 | 3079 | 108 |
947856 | 947856 | 2021-01-20 | Leflore | Mississippi | 28083 | 3059 | 107 |
944609 | 944609 | 2021-01-19 | Leflore | Mississippi | 28083 | 3041 | 107 |
941364 | 941364 | 2021-01-18 | Leflore | Mississippi | 28083 | 3004 | 105 |
938119 | 938119 | 2021-01-17 | Leflore | Mississippi | 28083 | 3002 | 105 |
934874 | 934874 | 2021-01-16 | Leflore | Mississippi | 28083 | 2992 | 105 |
931629 | 931629 | 2021-01-15 | Leflore | Mississippi | 28083 | 2980 | 104 |
928384 | 928384 | 2021-01-14 | Leflore | Mississippi | 28083 | 2969 | 104 |
925138 | 925138 | 2021-01-13 | Leflore | Mississippi | 28083 | 2946 | 104 |
921893 | 921893 | 2021-01-12 | Leflore | Mississippi | 28083 | 2926 | 104 |
918648 | 918648 | 2021-01-11 | Leflore | Mississippi | 28083 | 2912 | 104 |
915403 | 915403 | 2021-01-10 | Leflore | Mississippi | 28083 | 2906 | 104 |
912158 | 912158 | 2021-01-09 | Leflore | Mississippi | 28083 | 2890 | 104 |
908913 | 908913 | 2021-01-08 | Leflore | Mississippi | 28083 | 2850 | 104 |
905667 | 905667 | 2021-01-07 | Leflore | Mississippi | 28083 | 2834 | 104 |
902422 | 902422 | 2021-01-06 | Leflore | Mississippi | 28083 | 2788 | 103 |
899177 | 899177 | 2021-01-05 | Leflore | Mississippi | 28083 | 2752 | 102 |
895932 | 895932 | 2021-01-04 | Leflore | Mississippi | 28083 | 2732 | 102 |
892685 | 892685 | 2021-01-03 | Leflore | Mississippi | 28083 | 2708 | 102 |
889439 | 889439 | 2021-01-02 | Leflore | Mississippi | 28083 | 2671 | 101 |
886193 | 886193 | 2021-01-01 | Leflore | Mississippi | 28083 | 2664 | 101 |
882948 | 882948 | 2020-12-31 | Leflore | Mississippi | 28083 | 2649 | 101 |
879703 | 879703 | 2020-12-30 | Leflore | Mississippi | 28083 | 2589 | 100 |
876458 | 876458 | 2020-12-29 | Leflore | Mississippi | 28083 | 2574 | 100 |
873213 | 873213 | 2020-12-28 | Leflore | Mississippi | 28083 | 2553 | 98 |
869968 | 869968 | 2020-12-27 | Leflore | Mississippi | 28083 | 2542 | 98 |
866723 | 866723 | 2020-12-26 | Leflore | Mississippi | 28083 | 2527 | 98 |
863478 | 863478 | 2020-12-25 | Leflore | Mississippi | 28083 | 2517 | 98 |
860233 | 860233 | 2020-12-24 | Leflore | Mississippi | 28083 | 2512 | 98 |
856988 | 856988 | 2020-12-23 | Leflore | Mississippi | 28083 | 2492 | 99 |
853743 | 853743 | 2020-12-22 | Leflore | Mississippi | 28083 | 2470 | 99 |
850498 | 850498 | 2020-12-21 | Leflore | Mississippi | 28083 | 2444 | 98 |
847253 | 847253 | 2020-12-20 | Leflore | Mississippi | 28083 | 2436 | 98 |
844007 | 844007 | 2020-12-19 | Leflore | Mississippi | 28083 | 2418 | 98 |
840762 | 840762 | 2020-12-18 | Leflore | Mississippi | 28083 | 2408 | 98 |
837517 | 837517 | 2020-12-17 | Leflore | Mississippi | 28083 | 2388 | 98 |
834271 | 834271 | 2020-12-16 | Leflore | Mississippi | 28083 | 2356 | 98 |
831024 | 831024 | 2020-12-15 | Leflore | Mississippi | 28083 | 2337 | 97 |
827778 | 827778 | 2020-12-14 | Leflore | Mississippi | 28083 | 2324 | 96 |
824531 | 824531 | 2020-12-13 | Leflore | Mississippi | 28083 | 2316 | 96 |
821285 | 821285 | 2020-12-12 | Leflore | Mississippi | 28083 | 2310 | 96 |
818039 | 818039 | 2020-12-11 | Leflore | Mississippi | 28083 | 2291 | 95 |
814793 | 814793 | 2020-12-10 | Leflore | Mississippi | 28083 | 2270 | 95 |
811548 | 811548 | 2020-12-09 | Leflore | Mississippi | 28083 | 2248 | 94 |
808303 | 808303 | 2020-12-08 | Leflore | Mississippi | 28083 | 2235 | 94 |
805058 | 805058 | 2020-12-07 | Leflore | Mississippi | 28083 | 2214 | 93 |
801813 | 801813 | 2020-12-06 | Leflore | Mississippi | 28083 | 2204 | 93 |
798568 | 798568 | 2020-12-05 | Leflore | Mississippi | 28083 | 2196 | 93 |
795323 | 795323 | 2020-12-04 | Leflore | Mississippi | 28083 | 2164 | 92 |
792078 | 792078 | 2020-12-03 | Leflore | Mississippi | 28083 | 2139 | 91 |
788833 | 788833 | 2020-12-02 | Leflore | Mississippi | 28083 | 2111 | 91 |
785588 | 785588 | 2020-12-01 | Leflore | Mississippi | 28083 | 2085 | 91 |
782344 | 782344 | 2020-11-30 | Leflore | Mississippi | 28083 | 2077 | 91 |
779098 | 779098 | 2020-11-29 | Leflore | Mississippi | 28083 | 2068 | 91 |
775853 | 775853 | 2020-11-28 | Leflore | Mississippi | 28083 | 2055 | 90 |
772608 | 772608 | 2020-11-27 | Leflore | Mississippi | 28083 | 2047 | 90 |
769363 | 769363 | 2020-11-26 | Leflore | Mississippi | 28083 | 2034 | 90 |
766117 | 766117 | 2020-11-25 | Leflore | Mississippi | 28083 | 2014 | 90 |
762872 | 762872 | 2020-11-24 | Leflore | Mississippi | 28083 | 2008 | 90 |
759627 | 759627 | 2020-11-23 | Leflore | Mississippi | 28083 | 2007 | 89 |
756380 | 756380 | 2020-11-22 | Leflore | Mississippi | 28083 | 2003 | 89 |
753134 | 753134 | 2020-11-21 | Leflore | Mississippi | 28083 | 1987 | 89 |
749888 | 749888 | 2020-11-20 | Leflore | Mississippi | 28083 | 1977 | 89 |
746642 | 746642 | 2020-11-19 | Leflore | Mississippi | 28083 | 1965 | 89 |
743395 | 743395 | 2020-11-18 | Leflore | Mississippi | 28083 | 1945 | 89 |
740148 | 740148 | 2020-11-17 | Leflore | Mississippi | 28083 | 1929 | 89 |
736904 | 736904 | 2020-11-16 | Leflore | Mississippi | 28083 | 1918 | 88 |
733658 | 733658 | 2020-11-15 | Leflore | Mississippi | 28083 | 1915 | 88 |
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);