ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64,147 rows where state = "Mississippi" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 83
- 28035 794
- 28029 792
- 28083 792
- 28109 792
- 28049 790
- 28045 789
- 28095 789
- 28047 788
- 28059 788
- 28011 787
- 28027 787
- 28033 787
- 28089 787
- 28111 787
- 28051 786
- 28067 786
- 28123 786
- 28147 786
- 28157 786
- 28159 786
- 28163 786
- 28001 785
- 28037 785
- 28053 785
- 28071 785
- 28077 785
- 28081 785
- 28093 785
- 28113 785
- 28121 785
- 28129 785
- 28139 785
- 28007 784
- 28025 784
- 28039 784
- 28043 784
- 28057 784
- 28079 784
- 28085 784
- 28087 784
- 28107 784
- 28127 784
- 28143 784
- 28145 784
- 28151 784
- 28017 783
- 28097 783
- 28105 783
- 28115 783
- 28133 783
- 28137 783
- 28155 783
- 28073 782
- 28091 782
- 28135 782
- 28019 781
- 28101 781
- 28103 781
- 28013 780
- 28117 780
- 28009 779
- 28075 779
- 28119 779
- 28161 779
- 28063 778
- 28069 778
- 28099 778
- 28125 778
- 28005 777
- 28023 777
- 28031 777
- 28015 776
- 28021 776
- 28149 776
- 28003 775
- 28141 774
- 28061 773
- 28153 772
- 28131 769
- 28041 768
- 28065 765
- 28055 688
- - 68
county 83
- Forrest 794
- Copiah 792
- Leflore 792
- Pearl River 792
- Hinds 790
- Hancock 789
- Monroe 789
- Harrison 788
- Jackson 788
- Bolivar 787
- Coahoma 787
- DeSoto 787
- Madison 787
- Perry 787
- Holmes 786
- Jones 786
- Scott 786
- Walthall 786
- Wilkinson 786
- Winston 786
- Yazoo 786
- Adams 785
- Franklin 785
- Humphreys 785
- Lafayette 785
- Lawrence 785
- Lee 785
- Marshall 785
- Pike 785
- Rankin 785
- Smith 785
- Tippah 785
- Attala 784
- Clay 784
- George 784
- Grenada 784
- Itawamba 784
- Leake 784
- Lincoln 784
- Lowndes 784
- Panola 784
- Simpson 784
- Tunica 784
- Union 784
- Washington 784
- Chickasaw 783
- Montgomery 783
- Oktibbeha 783
- Pontotoc 783
- Sunflower 783
- Tate 783
- Webster 783
- Lamar 782
- Marion 782
- Tallahatchie 782
- Choctaw 781
- Newton 781
- Noxubee 781
- Calhoun 780
- Prentiss 780
- Benton 779
- Lauderdale 779
- Quitman 779
- Yalobusha 779
- Jefferson 778
- Kemper 778
- Neshoba 778
- Sharkey 778
- Amite 777
- Clarke 777
- Covington 777
- Carroll 776
- Claiborne 776
- Warren 776
- Alcorn 775
- Tishomingo 774
- Jasper 773
- Wayne 772
- Stone 769
- Greene 768
- Jefferson Davis 765
- Issaquena 688
- Unknown 68
state 1
- Mississippi · 64,147 ✖
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
14920 | 14920 | 2020-03-27 | Unknown | Mississippi | 3 | 0 | |
16744 | 16744 | 2020-03-28 | Unknown | Mississippi | 6 | 0 | |
250920 | 250920 | 2020-06-18 | Unknown | Mississippi | 381 | 5 | |
254035 | 254035 | 2020-06-19 | Unknown | Mississippi | 381 | 5 | |
257155 | 257155 | 2020-06-20 | Unknown | Mississippi | 381 | 5 | |
260281 | 260281 | 2020-06-21 | Unknown | Mississippi | 381 | 5 | |
371341 | 371341 | 2020-07-26 | Unknown | Mississippi | 34 | 0 | |
374553 | 374553 | 2020-07-27 | Unknown | Mississippi | 60 | 1 | |
377768 | 377768 | 2020-07-28 | Unknown | Mississippi | 98 | 1 | |
380985 | 380985 | 2020-07-29 | Unknown | Mississippi | 186 | 2 | |
642865 | 642865 | 2020-10-18 | Unknown | Mississippi | 233 | 0 | |
2289502 | 2289502 | 2022-03-09 | Unknown | Mississippi | 163 | 22 | |
2292754 | 2292754 | 2022-03-10 | Unknown | Mississippi | 323 | 41 | |
2296006 | 2296006 | 2022-03-11 | Unknown | Mississippi | 594 | 49 | |
2299258 | 2299258 | 2022-03-12 | Unknown | Mississippi | 594 | 49 | |
2302510 | 2302510 | 2022-03-13 | Unknown | Mississippi | 594 | 49 | |
2309013 | 2309013 | 2022-03-15 | Unknown | Mississippi | 153 | 13 | |
2312266 | 2312266 | 2022-03-16 | Unknown | Mississippi | 251 | 33 | |
2315519 | 2315519 | 2022-03-17 | Unknown | Mississippi | 328 | 44 | |
2318772 | 2318772 | 2022-03-18 | Unknown | Mississippi | 440 | 55 | |
2322026 | 2322026 | 2022-03-19 | Unknown | Mississippi | 440 | 55 | |
2325280 | 2325280 | 2022-03-20 | Unknown | Mississippi | 440 | 55 | |
2331785 | 2331785 | 2022-03-22 | Unknown | Mississippi | 106 | 32 | |
2335039 | 2335039 | 2022-03-23 | Unknown | Mississippi | 235 | 33 | |
2338293 | 2338293 | 2022-03-24 | Unknown | Mississippi | 325 | 33 | |
2341546 | 2341546 | 2022-03-25 | Unknown | Mississippi | 458 | 42 | |
2344799 | 2344799 | 2022-03-26 | Unknown | Mississippi | 458 | 42 | |
2348052 | 2348052 | 2022-03-27 | Unknown | Mississippi | 458 | 42 | |
2354557 | 2354557 | 2022-03-29 | Unknown | Mississippi | 67 | 13 | |
2357810 | 2357810 | 2022-03-30 | Unknown | Mississippi | 202 | 13 | |
2361064 | 2361064 | 2022-03-31 | Unknown | Mississippi | 333 | 14 | |
2364318 | 2364318 | 2022-04-01 | Unknown | Mississippi | 496 | 16 | |
2367571 | 2367571 | 2022-04-02 | Unknown | Mississippi | 496 | 16 | |
2370824 | 2370824 | 2022-04-03 | Unknown | Mississippi | 496 | 16 | |
2377329 | 2377329 | 2022-04-05 | Unknown | Mississippi | 134 | 5 | |
2380584 | 2380584 | 2022-04-06 | Unknown | Mississippi | 244 | 8 | |
2383839 | 2383839 | 2022-04-07 | Unknown | Mississippi | 449 | 8 | |
2387094 | 2387094 | 2022-04-08 | Unknown | Mississippi | 660 | 11 | |
2390350 | 2390350 | 2022-04-09 | Unknown | Mississippi | 660 | 11 | |
2393606 | 2393606 | 2022-04-10 | Unknown | Mississippi | 660 | 11 | |
2396861 | 2396861 | 2022-04-11 | Unknown | Mississippi | 660 | 11 | |
2403371 | 2403371 | 2022-04-13 | Unknown | Mississippi | 116 | 6 | |
2406627 | 2406627 | 2022-04-14 | Unknown | Mississippi | 239 | 7 | |
2409883 | 2409883 | 2022-04-15 | Unknown | Mississippi | 325 | 8 | |
2413139 | 2413139 | 2022-04-16 | Unknown | Mississippi | 325 | 8 | |
2416395 | 2416395 | 2022-04-17 | Unknown | Mississippi | 325 | 8 | |
2422907 | 2422907 | 2022-04-19 | Unknown | Mississippi | 50 | 5 | |
2426163 | 2426163 | 2022-04-20 | Unknown | Mississippi | 149 | 8 | |
2429419 | 2429419 | 2022-04-21 | Unknown | Mississippi | 244 | 8 | |
2432675 | 2432675 | 2022-04-22 | Unknown | Mississippi | 344 | 12 | |
2435931 | 2435931 | 2022-04-23 | Unknown | Mississippi | 344 | 12 | |
2439187 | 2439187 | 2022-04-24 | Unknown | Mississippi | 344 | 12 | |
2442443 | 2442443 | 2022-04-25 | Unknown | Mississippi | 344 | 12 | |
2448955 | 2448955 | 2022-04-27 | Unknown | Mississippi | 88 | 3 | |
2452211 | 2452211 | 2022-04-28 | Unknown | Mississippi | 252 | 7 | |
2455467 | 2455467 | 2022-04-29 | Unknown | Mississippi | 414 | 8 | |
2458723 | 2458723 | 2022-04-30 | Unknown | Mississippi | 414 | 8 | |
2461979 | 2461979 | 2022-05-01 | Unknown | Mississippi | 414 | 8 | |
2468490 | 2468490 | 2022-05-03 | Unknown | Mississippi | 143 | 4 | |
2471746 | 2471746 | 2022-05-04 | Unknown | Mississippi | 361 | 4 | |
2475003 | 2475003 | 2022-05-05 | Unknown | Mississippi | 545 | 5 | |
2478261 | 2478261 | 2022-05-06 | Unknown | Mississippi | 799 | 8 | |
2481519 | 2481519 | 2022-05-07 | Unknown | Mississippi | 799 | 8 | |
2484777 | 2484777 | 2022-05-08 | Unknown | Mississippi | 799 | 8 | |
2491292 | 2491292 | 2022-05-10 | Unknown | Mississippi | 267 | 2 | |
2494550 | 2494550 | 2022-05-11 | Unknown | Mississippi | 633 | 2 | |
2497808 | 2497808 | 2022-05-12 | Unknown | Mississippi | 1218 | 3 | |
2501066 | 2501066 | 2022-05-13 | Unknown | Mississippi | 1919 | 3 | |
4800 | 4800 | 2020-03-19 | Yazoo | Mississippi | 28163 | 1 | 0 |
5633 | 5633 | 2020-03-20 | Yazoo | Mississippi | 28163 | 1 | 0 |
6620 | 6620 | 2020-03-21 | Yazoo | Mississippi | 28163 | 1 | 0 |
7709 | 7709 | 2020-03-22 | Yazoo | Mississippi | 28163 | 1 | 0 |
8892 | 8892 | 2020-03-23 | Yazoo | Mississippi | 28163 | 1 | 0 |
10190 | 10190 | 2020-03-24 | Yazoo | Mississippi | 28163 | 3 | 0 |
11611 | 11611 | 2020-03-25 | Yazoo | Mississippi | 28163 | 3 | 0 |
13206 | 13206 | 2020-03-26 | Yazoo | Mississippi | 28163 | 4 | 0 |
14927 | 14927 | 2020-03-27 | Yazoo | Mississippi | 28163 | 4 | 0 |
16751 | 16751 | 2020-03-28 | Yazoo | Mississippi | 28163 | 4 | 0 |
18673 | 18673 | 2020-03-29 | Yazoo | Mississippi | 28163 | 5 | 0 |
20697 | 20697 | 2020-03-30 | Yazoo | Mississippi | 28163 | 7 | 0 |
22815 | 22815 | 2020-03-31 | Yazoo | Mississippi | 28163 | 9 | 0 |
24999 | 24999 | 2020-04-01 | Yazoo | Mississippi | 28163 | 9 | 0 |
27254 | 27254 | 2020-04-02 | Yazoo | Mississippi | 28163 | 11 | 1 |
29573 | 29573 | 2020-04-03 | Yazoo | Mississippi | 28163 | 13 | 1 |
31953 | 31953 | 2020-04-04 | Yazoo | Mississippi | 28163 | 19 | 1 |
34381 | 34381 | 2020-04-05 | Yazoo | Mississippi | 28163 | 31 | 1 |
36844 | 36844 | 2020-04-06 | Yazoo | Mississippi | 28163 | 32 | 1 |
39355 | 39355 | 2020-04-07 | Yazoo | Mississippi | 28163 | 32 | 1 |
41909 | 41909 | 2020-04-08 | Yazoo | Mississippi | 28163 | 38 | 1 |
44486 | 44486 | 2020-04-09 | Yazoo | Mississippi | 28163 | 47 | 1 |
47095 | 47095 | 2020-04-10 | Yazoo | Mississippi | 28163 | 55 | 1 |
49741 | 49741 | 2020-04-11 | Yazoo | Mississippi | 28163 | 58 | 1 |
52414 | 52414 | 2020-04-12 | Yazoo | Mississippi | 28163 | 63 | 1 |
55096 | 55096 | 2020-04-13 | Yazoo | Mississippi | 28163 | 64 | 1 |
57794 | 57794 | 2020-04-14 | Yazoo | Mississippi | 28163 | 64 | 1 |
60505 | 60505 | 2020-04-15 | Yazoo | Mississippi | 28163 | 65 | 1 |
63227 | 63227 | 2020-04-16 | Yazoo | Mississippi | 28163 | 72 | 1 |
65967 | 65967 | 2020-04-17 | Yazoo | Mississippi | 28163 | 81 | 1 |
68719 | 68719 | 2020-04-18 | Yazoo | Mississippi | 28163 | 85 | 1 |
71485 | 71485 | 2020-04-19 | Yazoo | Mississippi | 28163 | 91 | 1 |
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);