ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
995 rows where deaths = 3 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Franklin 87
- Tunica 61
- Marshall 59
- Issaquena 56
- Prentiss 56
- Lafayette 38
- Pontotoc 38
- Sunflower 36
- George 31
- Montgomery 31
- Coahoma 30
- Jefferson 28
- Jefferson Davis 27
- Perry 25
- Washington 24
- Clay 22
- Simpson 21
- Panola 19
- Humphreys 16
- Jasper 15
- Oktibbeha 14
- Wilkinson 14
- Clarke 13
- Benton 12
- Tishomingo 12
- Amite 11
- Covington 10
- Holmes 10
- Lowndes 10
- Stone 10
- …
state 1
- Mississippi · 995 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501066 | 2501066 | 2022-05-13 | Unknown | Mississippi | 1919 | 3 | |
2497808 | 2497808 | 2022-05-12 | Unknown | Mississippi | 1218 | 3 | |
2448955 | 2448955 | 2022-04-27 | Unknown | Mississippi | 88 | 3 | |
727147 | 727147 | 2020-11-13 | Franklin | Mississippi | 28037 | 274 | 3 |
723904 | 723904 | 2020-11-12 | Franklin | Mississippi | 28037 | 271 | 3 |
720661 | 720661 | 2020-11-11 | Franklin | Mississippi | 28037 | 267 | 3 |
717418 | 717418 | 2020-11-10 | Franklin | Mississippi | 28037 | 266 | 3 |
714174 | 714174 | 2020-11-09 | Franklin | Mississippi | 28037 | 264 | 3 |
710930 | 710930 | 2020-11-08 | Franklin | Mississippi | 28037 | 262 | 3 |
707686 | 707686 | 2020-11-07 | Franklin | Mississippi | 28037 | 261 | 3 |
704443 | 704443 | 2020-11-06 | Franklin | Mississippi | 28037 | 260 | 3 |
701201 | 701201 | 2020-11-05 | Franklin | Mississippi | 28037 | 260 | 3 |
697957 | 697957 | 2020-11-04 | Franklin | Mississippi | 28037 | 259 | 3 |
694714 | 694714 | 2020-11-03 | Franklin | Mississippi | 28037 | 259 | 3 |
691472 | 691472 | 2020-11-02 | Franklin | Mississippi | 28037 | 258 | 3 |
688227 | 688227 | 2020-11-01 | Franklin | Mississippi | 28037 | 258 | 3 |
684983 | 684983 | 2020-10-31 | Franklin | Mississippi | 28037 | 256 | 3 |
681740 | 681740 | 2020-10-30 | Franklin | Mississippi | 28037 | 253 | 3 |
678496 | 678496 | 2020-10-29 | Franklin | Mississippi | 28037 | 253 | 3 |
675254 | 675254 | 2020-10-28 | Franklin | Mississippi | 28037 | 251 | 3 |
672011 | 672011 | 2020-10-27 | Franklin | Mississippi | 28037 | 248 | 3 |
668769 | 668769 | 2020-10-26 | Franklin | Mississippi | 28037 | 246 | 3 |
665525 | 665525 | 2020-10-25 | Franklin | Mississippi | 28037 | 242 | 3 |
662280 | 662280 | 2020-10-24 | Franklin | Mississippi | 28037 | 242 | 3 |
659036 | 659036 | 2020-10-23 | Franklin | Mississippi | 28037 | 240 | 3 |
655791 | 655791 | 2020-10-22 | Franklin | Mississippi | 28037 | 237 | 3 |
652546 | 652546 | 2020-10-21 | Franklin | Mississippi | 28037 | 237 | 3 |
649301 | 649301 | 2020-10-20 | Franklin | Mississippi | 28037 | 237 | 3 |
649310 | 649310 | 2020-10-20 | Issaquena | Mississippi | 28055 | 106 | 3 |
646057 | 646057 | 2020-10-19 | Franklin | Mississippi | 28037 | 230 | 3 |
646066 | 646066 | 2020-10-19 | Issaquena | Mississippi | 28055 | 106 | 3 |
642810 | 642810 | 2020-10-18 | Franklin | Mississippi | 28037 | 228 | 3 |
642819 | 642819 | 2020-10-18 | Issaquena | Mississippi | 28055 | 106 | 3 |
639563 | 639563 | 2020-10-17 | Franklin | Mississippi | 28037 | 228 | 3 |
639572 | 639572 | 2020-10-17 | Issaquena | Mississippi | 28055 | 106 | 3 |
636317 | 636317 | 2020-10-16 | Franklin | Mississippi | 28037 | 223 | 3 |
636326 | 636326 | 2020-10-16 | Issaquena | Mississippi | 28055 | 106 | 3 |
633071 | 633071 | 2020-10-15 | Franklin | Mississippi | 28037 | 220 | 3 |
633080 | 633080 | 2020-10-15 | Issaquena | Mississippi | 28055 | 106 | 3 |
629826 | 629826 | 2020-10-14 | Franklin | Mississippi | 28037 | 213 | 3 |
629835 | 629835 | 2020-10-14 | Issaquena | Mississippi | 28055 | 106 | 3 |
626582 | 626582 | 2020-10-13 | Franklin | Mississippi | 28037 | 212 | 3 |
626591 | 626591 | 2020-10-13 | Issaquena | Mississippi | 28055 | 106 | 3 |
623340 | 623340 | 2020-10-12 | Franklin | Mississippi | 28037 | 212 | 3 |
623349 | 623349 | 2020-10-12 | Issaquena | Mississippi | 28055 | 106 | 3 |
620097 | 620097 | 2020-10-11 | Franklin | Mississippi | 28037 | 211 | 3 |
620106 | 620106 | 2020-10-11 | Issaquena | Mississippi | 28055 | 106 | 3 |
616855 | 616855 | 2020-10-10 | Franklin | Mississippi | 28037 | 211 | 3 |
616864 | 616864 | 2020-10-10 | Issaquena | Mississippi | 28055 | 106 | 3 |
613614 | 613614 | 2020-10-09 | Franklin | Mississippi | 28037 | 209 | 3 |
613623 | 613623 | 2020-10-09 | Issaquena | Mississippi | 28055 | 106 | 3 |
610372 | 610372 | 2020-10-08 | Franklin | Mississippi | 28037 | 207 | 3 |
610381 | 610381 | 2020-10-08 | Issaquena | Mississippi | 28055 | 106 | 3 |
607130 | 607130 | 2020-10-07 | Franklin | Mississippi | 28037 | 206 | 3 |
607139 | 607139 | 2020-10-07 | Issaquena | Mississippi | 28055 | 106 | 3 |
603873 | 603873 | 2020-10-06 | Benton | Mississippi | 28009 | 250 | 3 |
603887 | 603887 | 2020-10-06 | Franklin | Mississippi | 28037 | 206 | 3 |
603896 | 603896 | 2020-10-06 | Issaquena | Mississippi | 28055 | 106 | 3 |
600631 | 600631 | 2020-10-05 | Benton | Mississippi | 28009 | 248 | 3 |
600645 | 600645 | 2020-10-05 | Franklin | Mississippi | 28037 | 204 | 3 |
600654 | 600654 | 2020-10-05 | Issaquena | Mississippi | 28055 | 106 | 3 |
597388 | 597388 | 2020-10-04 | Benton | Mississippi | 28009 | 248 | 3 |
597402 | 597402 | 2020-10-04 | Franklin | Mississippi | 28037 | 204 | 3 |
597411 | 597411 | 2020-10-04 | Issaquena | Mississippi | 28055 | 106 | 3 |
594147 | 594147 | 2020-10-03 | Benton | Mississippi | 28009 | 248 | 3 |
594161 | 594161 | 2020-10-03 | Franklin | Mississippi | 28037 | 203 | 3 |
594170 | 594170 | 2020-10-03 | Issaquena | Mississippi | 28055 | 106 | 3 |
590906 | 590906 | 2020-10-02 | Benton | Mississippi | 28009 | 244 | 3 |
590920 | 590920 | 2020-10-02 | Franklin | Mississippi | 28037 | 201 | 3 |
590929 | 590929 | 2020-10-02 | Issaquena | Mississippi | 28055 | 106 | 3 |
587665 | 587665 | 2020-10-01 | Benton | Mississippi | 28009 | 238 | 3 |
587679 | 587679 | 2020-10-01 | Franklin | Mississippi | 28037 | 201 | 3 |
587688 | 587688 | 2020-10-01 | Issaquena | Mississippi | 28055 | 106 | 3 |
584425 | 584425 | 2020-09-30 | Benton | Mississippi | 28009 | 233 | 3 |
584439 | 584439 | 2020-09-30 | Franklin | Mississippi | 28037 | 199 | 3 |
584448 | 584448 | 2020-09-30 | Issaquena | Mississippi | 28055 | 106 | 3 |
581184 | 581184 | 2020-09-29 | Benton | Mississippi | 28009 | 233 | 3 |
581198 | 581198 | 2020-09-29 | Franklin | Mississippi | 28037 | 197 | 3 |
581207 | 581207 | 2020-09-29 | Issaquena | Mississippi | 28055 | 105 | 3 |
577943 | 577943 | 2020-09-28 | Benton | Mississippi | 28009 | 229 | 3 |
577957 | 577957 | 2020-09-28 | Franklin | Mississippi | 28037 | 193 | 3 |
577966 | 577966 | 2020-09-28 | Issaquena | Mississippi | 28055 | 105 | 3 |
574702 | 574702 | 2020-09-27 | Benton | Mississippi | 28009 | 228 | 3 |
574716 | 574716 | 2020-09-27 | Franklin | Mississippi | 28037 | 193 | 3 |
574725 | 574725 | 2020-09-27 | Issaquena | Mississippi | 28055 | 105 | 3 |
571459 | 571459 | 2020-09-26 | Benton | Mississippi | 28009 | 227 | 3 |
571473 | 571473 | 2020-09-26 | Franklin | Mississippi | 28037 | 193 | 3 |
571482 | 571482 | 2020-09-26 | Issaquena | Mississippi | 28055 | 105 | 3 |
568217 | 568217 | 2020-09-25 | Benton | Mississippi | 28009 | 226 | 3 |
568231 | 568231 | 2020-09-25 | Franklin | Mississippi | 28037 | 192 | 3 |
568240 | 568240 | 2020-09-25 | Issaquena | Mississippi | 28055 | 104 | 3 |
564991 | 564991 | 2020-09-24 | Franklin | Mississippi | 28037 | 192 | 3 |
565000 | 565000 | 2020-09-24 | Issaquena | Mississippi | 28055 | 104 | 3 |
561751 | 561751 | 2020-09-23 | Franklin | Mississippi | 28037 | 192 | 3 |
561760 | 561760 | 2020-09-23 | Issaquena | Mississippi | 28055 | 104 | 3 |
558514 | 558514 | 2020-09-22 | Franklin | Mississippi | 28037 | 191 | 3 |
558523 | 558523 | 2020-09-22 | Issaquena | Mississippi | 28055 | 103 | 3 |
555277 | 555277 | 2020-09-21 | Franklin | Mississippi | 28037 | 189 | 3 |
555286 | 555286 | 2020-09-21 | Issaquena | Mississippi | 28055 | 103 | 3 |
552039 | 552039 | 2020-09-20 | Franklin | Mississippi | 28037 | 189 | 3 |
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);