ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064717 | 1064717 | 2021-02-25 | Rankin | Mississippi | 28121 | 12595 | 262 |
1061473 | 1061473 | 2021-02-24 | Rankin | Mississippi | 28121 | 12543 | 261 |
1058227 | 1058227 | 2021-02-23 | Rankin | Mississippi | 28121 | 12498 | 260 |
1054981 | 1054981 | 2021-02-22 | Rankin | Mississippi | 28121 | 12490 | 258 |
1051734 | 1051734 | 2021-02-21 | Rankin | Mississippi | 28121 | 12483 | 258 |
1048487 | 1048487 | 2021-02-20 | Rankin | Mississippi | 28121 | 12478 | 258 |
1045241 | 1045241 | 2021-02-19 | Rankin | Mississippi | 28121 | 12476 | 258 |
1041996 | 1041996 | 2021-02-18 | Rankin | Mississippi | 28121 | 12468 | 257 |
1038751 | 1038751 | 2021-02-17 | Rankin | Mississippi | 28121 | 12467 | 257 |
1035506 | 1035506 | 2021-02-16 | Rankin | Mississippi | 28121 | 12450 | 254 |
1032261 | 1032261 | 2021-02-15 | Rankin | Mississippi | 28121 | 12413 | 253 |
1029014 | 1029014 | 2021-02-14 | Rankin | Mississippi | 28121 | 12384 | 253 |
1025768 | 1025768 | 2021-02-13 | Rankin | Mississippi | 28121 | 12313 | 253 |
1022523 | 1022523 | 2021-02-12 | Rankin | Mississippi | 28121 | 12272 | 252 |
1019278 | 1019278 | 2021-02-11 | Rankin | Mississippi | 28121 | 12244 | 249 |
1016033 | 1016033 | 2021-02-10 | Rankin | Mississippi | 28121 | 12215 | 248 |
1012788 | 1012788 | 2021-02-09 | Rankin | Mississippi | 28121 | 12176 | 246 |
1009543 | 1009543 | 2021-02-08 | Rankin | Mississippi | 28121 | 12146 | 243 |
1006296 | 1006296 | 2021-02-07 | Rankin | Mississippi | 28121 | 12109 | 243 |
1003050 | 1003050 | 2021-02-06 | Rankin | Mississippi | 28121 | 12040 | 243 |
999805 | 999805 | 2021-02-05 | Rankin | Mississippi | 28121 | 11964 | 243 |
996559 | 996559 | 2021-02-04 | Rankin | Mississippi | 28121 | 11890 | 242 |
993313 | 993313 | 2021-02-03 | Rankin | Mississippi | 28121 | 11796 | 240 |
990067 | 990067 | 2021-02-02 | Rankin | Mississippi | 28121 | 11761 | 237 |
986820 | 986820 | 2021-02-01 | Rankin | Mississippi | 28121 | 11734 | 235 |
983573 | 983573 | 2021-01-31 | Rankin | Mississippi | 28121 | 11693 | 232 |
980327 | 980327 | 2021-01-30 | Rankin | Mississippi | 28121 | 11670 | 231 |
977081 | 977081 | 2021-01-29 | Rankin | Mississippi | 28121 | 11568 | 228 |
973836 | 973836 | 2021-01-28 | Rankin | Mississippi | 28121 | 11478 | 227 |
970591 | 970591 | 2021-01-27 | Rankin | Mississippi | 28121 | 11404 | 225 |
967346 | 967346 | 2021-01-26 | Rankin | Mississippi | 28121 | 11315 | 223 |
964102 | 964102 | 2021-01-25 | Rankin | Mississippi | 28121 | 11280 | 221 |
960857 | 960857 | 2021-01-24 | Rankin | Mississippi | 28121 | 11239 | 220 |
957611 | 957611 | 2021-01-23 | Rankin | Mississippi | 28121 | 11167 | 219 |
954366 | 954366 | 2021-01-22 | Rankin | Mississippi | 28121 | 11102 | 217 |
951121 | 951121 | 2021-01-21 | Rankin | Mississippi | 28121 | 11000 | 217 |
947875 | 947875 | 2021-01-20 | Rankin | Mississippi | 28121 | 10854 | 217 |
944628 | 944628 | 2021-01-19 | Rankin | Mississippi | 28121 | 10804 | 212 |
941383 | 941383 | 2021-01-18 | Rankin | Mississippi | 28121 | 10749 | 211 |
938138 | 938138 | 2021-01-17 | Rankin | Mississippi | 28121 | 10689 | 211 |
934893 | 934893 | 2021-01-16 | Rankin | Mississippi | 28121 | 10629 | 208 |
931648 | 931648 | 2021-01-15 | Rankin | Mississippi | 28121 | 10439 | 205 |
928403 | 928403 | 2021-01-14 | Rankin | Mississippi | 28121 | 10334 | 204 |
925157 | 925157 | 2021-01-13 | Rankin | Mississippi | 28121 | 10243 | 201 |
921912 | 921912 | 2021-01-12 | Rankin | Mississippi | 28121 | 10201 | 195 |
918667 | 918667 | 2021-01-11 | Rankin | Mississippi | 28121 | 10084 | 189 |
915422 | 915422 | 2021-01-10 | Rankin | Mississippi | 28121 | 9979 | 187 |
912177 | 912177 | 2021-01-09 | Rankin | Mississippi | 28121 | 9872 | 186 |
908932 | 908932 | 2021-01-08 | Rankin | Mississippi | 28121 | 9663 | 180 |
905686 | 905686 | 2021-01-07 | Rankin | Mississippi | 28121 | 9465 | 179 |
902441 | 902441 | 2021-01-06 | Rankin | Mississippi | 28121 | 9361 | 178 |
899196 | 899196 | 2021-01-05 | Rankin | Mississippi | 28121 | 9228 | 175 |
895951 | 895951 | 2021-01-04 | Rankin | Mississippi | 28121 | 9202 | 171 |
892704 | 892704 | 2021-01-03 | Rankin | Mississippi | 28121 | 9139 | 171 |
889458 | 889458 | 2021-01-02 | Rankin | Mississippi | 28121 | 9086 | 169 |
886212 | 886212 | 2021-01-01 | Rankin | Mississippi | 28121 | 8957 | 168 |
882967 | 882967 | 2020-12-31 | Rankin | Mississippi | 28121 | 8793 | 165 |
879722 | 879722 | 2020-12-30 | Rankin | Mississippi | 28121 | 8671 | 163 |
876477 | 876477 | 2020-12-29 | Rankin | Mississippi | 28121 | 8510 | 163 |
873232 | 873232 | 2020-12-28 | Rankin | Mississippi | 28121 | 8449 | 161 |
869987 | 869987 | 2020-12-27 | Rankin | Mississippi | 28121 | 8350 | 157 |
866742 | 866742 | 2020-12-26 | Rankin | Mississippi | 28121 | 8284 | 156 |
863497 | 863497 | 2020-12-25 | Rankin | Mississippi | 28121 | 8256 | 156 |
860252 | 860252 | 2020-12-24 | Rankin | Mississippi | 28121 | 8197 | 156 |
857007 | 857007 | 2020-12-23 | Rankin | Mississippi | 28121 | 8116 | 155 |
853762 | 853762 | 2020-12-22 | Rankin | Mississippi | 28121 | 8020 | 149 |
850517 | 850517 | 2020-12-21 | Rankin | Mississippi | 28121 | 7952 | 143 |
847272 | 847272 | 2020-12-20 | Rankin | Mississippi | 28121 | 7902 | 143 |
844026 | 844026 | 2020-12-19 | Rankin | Mississippi | 28121 | 7795 | 143 |
840781 | 840781 | 2020-12-18 | Rankin | Mississippi | 28121 | 7741 | 142 |
837536 | 837536 | 2020-12-17 | Rankin | Mississippi | 28121 | 7636 | 140 |
834290 | 834290 | 2020-12-16 | Rankin | Mississippi | 28121 | 7542 | 136 |
831043 | 831043 | 2020-12-15 | Rankin | Mississippi | 28121 | 7366 | 132 |
827797 | 827797 | 2020-12-14 | Rankin | Mississippi | 28121 | 7285 | 129 |
824550 | 824550 | 2020-12-13 | Rankin | Mississippi | 28121 | 7254 | 129 |
821304 | 821304 | 2020-12-12 | Rankin | Mississippi | 28121 | 7188 | 128 |
818058 | 818058 | 2020-12-11 | Rankin | Mississippi | 28121 | 7036 | 122 |
814812 | 814812 | 2020-12-10 | Rankin | Mississippi | 28121 | 6886 | 118 |
811567 | 811567 | 2020-12-09 | Rankin | Mississippi | 28121 | 6785 | 117 |
808322 | 808322 | 2020-12-08 | Rankin | Mississippi | 28121 | 6645 | 117 |
805077 | 805077 | 2020-12-07 | Rankin | Mississippi | 28121 | 6589 | 116 |
801832 | 801832 | 2020-12-06 | Rankin | Mississippi | 28121 | 6544 | 116 |
798587 | 798587 | 2020-12-05 | Rankin | Mississippi | 28121 | 6422 | 115 |
795342 | 795342 | 2020-12-04 | Rankin | Mississippi | 28121 | 6303 | 114 |
792097 | 792097 | 2020-12-03 | Rankin | Mississippi | 28121 | 6130 | 112 |
788852 | 788852 | 2020-12-02 | Rankin | Mississippi | 28121 | 6057 | 107 |
785607 | 785607 | 2020-12-01 | Rankin | Mississippi | 28121 | 5887 | 106 |
782363 | 782363 | 2020-11-30 | Rankin | Mississippi | 28121 | 5805 | 103 |
779117 | 779117 | 2020-11-29 | Rankin | Mississippi | 28121 | 5705 | 103 |
775872 | 775872 | 2020-11-28 | Rankin | Mississippi | 28121 | 5588 | 103 |
772627 | 772627 | 2020-11-27 | Rankin | Mississippi | 28121 | 5462 | 102 |
769382 | 769382 | 2020-11-26 | Rankin | Mississippi | 28121 | 5417 | 102 |
766136 | 766136 | 2020-11-25 | Rankin | Mississippi | 28121 | 5319 | 100 |
762891 | 762891 | 2020-11-24 | Rankin | Mississippi | 28121 | 5285 | 98 |
759646 | 759646 | 2020-11-23 | Rankin | Mississippi | 28121 | 5237 | 96 |
756399 | 756399 | 2020-11-22 | Rankin | Mississippi | 28121 | 5219 | 96 |
753153 | 753153 | 2020-11-21 | Rankin | Mississippi | 28121 | 5187 | 96 |
749907 | 749907 | 2020-11-20 | Rankin | Mississippi | 28121 | 5078 | 95 |
746661 | 746661 | 2020-11-19 | Rankin | Mississippi | 28121 | 5038 | 94 |
743414 | 743414 | 2020-11-18 | Rankin | Mississippi | 28121 | 4954 | 93 |
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);