ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 28049 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064681 | 1064681 | 2021-02-25 | Hinds | Mississippi | 28049 | 18674 | 385 |
1061437 | 1061437 | 2021-02-24 | Hinds | Mississippi | 28049 | 18611 | 385 |
1058191 | 1058191 | 2021-02-23 | Hinds | Mississippi | 28049 | 18555 | 383 |
1054945 | 1054945 | 2021-02-22 | Hinds | Mississippi | 28049 | 18542 | 382 |
1051698 | 1051698 | 2021-02-21 | Hinds | Mississippi | 28049 | 18532 | 382 |
1048451 | 1048451 | 2021-02-20 | Hinds | Mississippi | 28049 | 18528 | 382 |
1045205 | 1045205 | 2021-02-19 | Hinds | Mississippi | 28049 | 18519 | 380 |
1041960 | 1041960 | 2021-02-18 | Hinds | Mississippi | 28049 | 18515 | 380 |
1038715 | 1038715 | 2021-02-17 | Hinds | Mississippi | 28049 | 18514 | 380 |
1035470 | 1035470 | 2021-02-16 | Hinds | Mississippi | 28049 | 18501 | 378 |
1032225 | 1032225 | 2021-02-15 | Hinds | Mississippi | 28049 | 18476 | 377 |
1028978 | 1028978 | 2021-02-14 | Hinds | Mississippi | 28049 | 18438 | 377 |
1025732 | 1025732 | 2021-02-13 | Hinds | Mississippi | 28049 | 18362 | 377 |
1022487 | 1022487 | 2021-02-12 | Hinds | Mississippi | 28049 | 18321 | 374 |
1019242 | 1019242 | 2021-02-11 | Hinds | Mississippi | 28049 | 18246 | 372 |
1015997 | 1015997 | 2021-02-10 | Hinds | Mississippi | 28049 | 18191 | 372 |
1012752 | 1012752 | 2021-02-09 | Hinds | Mississippi | 28049 | 18128 | 369 |
1009507 | 1009507 | 2021-02-08 | Hinds | Mississippi | 28049 | 18086 | 362 |
1006260 | 1006260 | 2021-02-07 | Hinds | Mississippi | 28049 | 18038 | 362 |
1003014 | 1003014 | 2021-02-06 | Hinds | Mississippi | 28049 | 17962 | 362 |
999769 | 999769 | 2021-02-05 | Hinds | Mississippi | 28049 | 17897 | 361 |
996523 | 996523 | 2021-02-04 | Hinds | Mississippi | 28049 | 17823 | 359 |
993277 | 993277 | 2021-02-03 | Hinds | Mississippi | 28049 | 17748 | 358 |
990031 | 990031 | 2021-02-02 | Hinds | Mississippi | 28049 | 17669 | 357 |
986784 | 986784 | 2021-02-01 | Hinds | Mississippi | 28049 | 17633 | 351 |
983537 | 983537 | 2021-01-31 | Hinds | Mississippi | 28049 | 17576 | 351 |
980291 | 980291 | 2021-01-30 | Hinds | Mississippi | 28049 | 17526 | 350 |
977045 | 977045 | 2021-01-29 | Hinds | Mississippi | 28049 | 17419 | 348 |
973800 | 973800 | 2021-01-28 | Hinds | Mississippi | 28049 | 17286 | 346 |
970555 | 970555 | 2021-01-27 | Hinds | Mississippi | 28049 | 17192 | 342 |
967310 | 967310 | 2021-01-26 | Hinds | Mississippi | 28049 | 17030 | 337 |
964066 | 964066 | 2021-01-25 | Hinds | Mississippi | 28049 | 16967 | 332 |
960821 | 960821 | 2021-01-24 | Hinds | Mississippi | 28049 | 16891 | 332 |
957575 | 957575 | 2021-01-23 | Hinds | Mississippi | 28049 | 16813 | 331 |
954330 | 954330 | 2021-01-22 | Hinds | Mississippi | 28049 | 16687 | 329 |
951085 | 951085 | 2021-01-21 | Hinds | Mississippi | 28049 | 16524 | 328 |
947839 | 947839 | 2021-01-20 | Hinds | Mississippi | 28049 | 16373 | 328 |
944592 | 944592 | 2021-01-19 | Hinds | Mississippi | 28049 | 16331 | 322 |
941347 | 941347 | 2021-01-18 | Hinds | Mississippi | 28049 | 16280 | 322 |
938102 | 938102 | 2021-01-17 | Hinds | Mississippi | 28049 | 16207 | 322 |
934857 | 934857 | 2021-01-16 | Hinds | Mississippi | 28049 | 16091 | 318 |
931612 | 931612 | 2021-01-15 | Hinds | Mississippi | 28049 | 15890 | 312 |
928367 | 928367 | 2021-01-14 | Hinds | Mississippi | 28049 | 15748 | 310 |
925121 | 925121 | 2021-01-13 | Hinds | Mississippi | 28049 | 15605 | 309 |
921876 | 921876 | 2021-01-12 | Hinds | Mississippi | 28049 | 15559 | 308 |
918631 | 918631 | 2021-01-11 | Hinds | Mississippi | 28049 | 15477 | 299 |
915386 | 915386 | 2021-01-10 | Hinds | Mississippi | 28049 | 15381 | 297 |
912141 | 912141 | 2021-01-09 | Hinds | Mississippi | 28049 | 15180 | 295 |
908896 | 908896 | 2021-01-08 | Hinds | Mississippi | 28049 | 14999 | 294 |
905650 | 905650 | 2021-01-07 | Hinds | Mississippi | 28049 | 14874 | 293 |
902405 | 902405 | 2021-01-06 | Hinds | Mississippi | 28049 | 14652 | 291 |
899160 | 899160 | 2021-01-05 | Hinds | Mississippi | 28049 | 14467 | 290 |
895915 | 895915 | 2021-01-04 | Hinds | Mississippi | 28049 | 14400 | 282 |
892668 | 892668 | 2021-01-03 | Hinds | Mississippi | 28049 | 14301 | 281 |
889422 | 889422 | 2021-01-02 | Hinds | Mississippi | 28049 | 14242 | 278 |
886176 | 886176 | 2021-01-01 | Hinds | Mississippi | 28049 | 14118 | 272 |
882931 | 882931 | 2020-12-31 | Hinds | Mississippi | 28049 | 13966 | 265 |
879686 | 879686 | 2020-12-30 | Hinds | Mississippi | 28049 | 13807 | 263 |
876441 | 876441 | 2020-12-29 | Hinds | Mississippi | 28049 | 13643 | 262 |
873196 | 873196 | 2020-12-28 | Hinds | Mississippi | 28049 | 13567 | 252 |
869951 | 869951 | 2020-12-27 | Hinds | Mississippi | 28049 | 13461 | 250 |
866706 | 866706 | 2020-12-26 | Hinds | Mississippi | 28049 | 13403 | 248 |
863461 | 863461 | 2020-12-25 | Hinds | Mississippi | 28049 | 13335 | 248 |
860216 | 860216 | 2020-12-24 | Hinds | Mississippi | 28049 | 13255 | 248 |
856971 | 856971 | 2020-12-23 | Hinds | Mississippi | 28049 | 13153 | 248 |
853726 | 853726 | 2020-12-22 | Hinds | Mississippi | 28049 | 13018 | 242 |
850481 | 850481 | 2020-12-21 | Hinds | Mississippi | 28049 | 12911 | 236 |
847236 | 847236 | 2020-12-20 | Hinds | Mississippi | 28049 | 12849 | 236 |
843990 | 843990 | 2020-12-19 | Hinds | Mississippi | 28049 | 12678 | 236 |
840745 | 840745 | 2020-12-18 | Hinds | Mississippi | 28049 | 12498 | 233 |
837500 | 837500 | 2020-12-17 | Hinds | Mississippi | 28049 | 12361 | 230 |
834254 | 834254 | 2020-12-16 | Hinds | Mississippi | 28049 | 12228 | 229 |
831007 | 831007 | 2020-12-15 | Hinds | Mississippi | 28049 | 12069 | 227 |
827761 | 827761 | 2020-12-14 | Hinds | Mississippi | 28049 | 11955 | 222 |
824514 | 824514 | 2020-12-13 | Hinds | Mississippi | 28049 | 11866 | 222 |
821268 | 821268 | 2020-12-12 | Hinds | Mississippi | 28049 | 11753 | 220 |
818022 | 818022 | 2020-12-11 | Hinds | Mississippi | 28049 | 11535 | 217 |
814776 | 814776 | 2020-12-10 | Hinds | Mississippi | 28049 | 11374 | 217 |
811531 | 811531 | 2020-12-09 | Hinds | Mississippi | 28049 | 11193 | 213 |
808286 | 808286 | 2020-12-08 | Hinds | Mississippi | 28049 | 11046 | 210 |
805041 | 805041 | 2020-12-07 | Hinds | Mississippi | 28049 | 10993 | 208 |
801796 | 801796 | 2020-12-06 | Hinds | Mississippi | 28049 | 10951 | 208 |
798551 | 798551 | 2020-12-05 | Hinds | Mississippi | 28049 | 10855 | 208 |
795306 | 795306 | 2020-12-04 | Hinds | Mississippi | 28049 | 10705 | 207 |
792061 | 792061 | 2020-12-03 | Hinds | Mississippi | 28049 | 10519 | 205 |
788816 | 788816 | 2020-12-02 | Hinds | Mississippi | 28049 | 10414 | 204 |
785571 | 785571 | 2020-12-01 | Hinds | Mississippi | 28049 | 10279 | 202 |
782327 | 782327 | 2020-11-30 | Hinds | Mississippi | 28049 | 10190 | 199 |
779081 | 779081 | 2020-11-29 | Hinds | Mississippi | 28049 | 10095 | 199 |
775836 | 775836 | 2020-11-28 | Hinds | Mississippi | 28049 | 9984 | 199 |
772591 | 772591 | 2020-11-27 | Hinds | Mississippi | 28049 | 9892 | 198 |
769346 | 769346 | 2020-11-26 | Hinds | Mississippi | 28049 | 9821 | 198 |
766100 | 766100 | 2020-11-25 | Hinds | Mississippi | 28049 | 9668 | 197 |
762855 | 762855 | 2020-11-24 | Hinds | Mississippi | 28049 | 9584 | 195 |
759610 | 759610 | 2020-11-23 | Hinds | Mississippi | 28049 | 9541 | 193 |
756363 | 756363 | 2020-11-22 | Hinds | Mississippi | 28049 | 9520 | 193 |
753117 | 753117 | 2020-11-21 | Hinds | Mississippi | 28049 | 9460 | 193 |
749871 | 749871 | 2020-11-20 | Hinds | Mississippi | 28049 | 9338 | 193 |
746625 | 746625 | 2020-11-19 | Hinds | Mississippi | 28049 | 9261 | 189 |
743378 | 743378 | 2020-11-18 | Hinds | Mississippi | 28049 | 9166 | 187 |
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);