ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,570 rows where county = "DeSoto" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4071 | 4071 | 2020-03-18 | DeSoto | Mississippi | 28033 | 1 | 0 |
4783 | 4783 | 2020-03-19 | DeSoto | Mississippi | 28033 | 2 | 0 |
5606 | 5606 | 2020-03-20 | DeSoto | Mississippi | 28033 | 4 | 0 |
6582 | 6582 | 2020-03-21 | DeSoto | Mississippi | 28033 | 13 | 0 |
7273 | 7273 | 2020-03-22 | DeSoto | Florida | 12027 | 1 | 0 |
7665 | 7665 | 2020-03-22 | DeSoto | Mississippi | 28033 | 18 | 0 |
8419 | 8419 | 2020-03-23 | DeSoto | Florida | 12027 | 1 | 0 |
8845 | 8845 | 2020-03-23 | DeSoto | Mississippi | 28033 | 23 | 0 |
9664 | 9664 | 2020-03-24 | DeSoto | Florida | 12027 | 1 | 0 |
10141 | 10141 | 2020-03-24 | DeSoto | Mississippi | 28033 | 29 | 0 |
11038 | 11038 | 2020-03-25 | DeSoto | Florida | 12027 | 4 | 0 |
11561 | 11561 | 2020-03-25 | DeSoto | Mississippi | 28033 | 36 | 0 |
12586 | 12586 | 2020-03-26 | DeSoto | Florida | 12027 | 5 | 0 |
13153 | 13153 | 2020-03-26 | DeSoto | Mississippi | 28033 | 49 | 0 |
14255 | 14255 | 2020-03-27 | DeSoto | Florida | 12027 | 6 | 0 |
14869 | 14869 | 2020-03-27 | DeSoto | Mississippi | 28033 | 63 | 0 |
16039 | 16039 | 2020-03-28 | DeSoto | Florida | 12027 | 7 | 0 |
16693 | 16693 | 2020-03-28 | DeSoto | Mississippi | 28033 | 65 | 1 |
17931 | 17931 | 2020-03-29 | DeSoto | Florida | 12027 | 7 | 0 |
18615 | 18615 | 2020-03-29 | DeSoto | Mississippi | 28033 | 71 | 1 |
19911 | 19911 | 2020-03-30 | DeSoto | Florida | 12027 | 7 | 2 |
20639 | 20639 | 2020-03-30 | DeSoto | Mississippi | 28033 | 77 | 1 |
21989 | 21989 | 2020-03-31 | DeSoto | Florida | 12027 | 7 | 1 |
22756 | 22756 | 2020-03-31 | DeSoto | Mississippi | 28033 | 84 | 1 |
24148 | 24148 | 2020-04-01 | DeSoto | Florida | 12027 | 7 | 1 |
24939 | 24939 | 2020-04-01 | DeSoto | Mississippi | 28033 | 94 | 1 |
26378 | 26378 | 2020-04-02 | DeSoto | Florida | 12027 | 8 | 1 |
27193 | 27193 | 2020-04-02 | DeSoto | Mississippi | 28033 | 103 | 1 |
28680 | 28680 | 2020-04-03 | DeSoto | Florida | 12027 | 9 | 1 |
29512 | 29512 | 2020-04-03 | DeSoto | Mississippi | 28033 | 111 | 1 |
31038 | 31038 | 2020-04-04 | DeSoto | Florida | 12027 | 11 | 1 |
31892 | 31892 | 2020-04-04 | DeSoto | Mississippi | 28033 | 118 | 1 |
33444 | 33444 | 2020-04-05 | DeSoto | Florida | 12027 | 12 | 2 |
34319 | 34319 | 2020-04-05 | DeSoto | Mississippi | 28033 | 132 | 1 |
35889 | 35889 | 2020-04-06 | DeSoto | Florida | 12027 | 14 | 3 |
36781 | 36781 | 2020-04-06 | DeSoto | Mississippi | 28033 | 136 | 1 |
38379 | 38379 | 2020-04-07 | DeSoto | Florida | 12027 | 16 | 3 |
39292 | 39292 | 2020-04-07 | DeSoto | Mississippi | 28033 | 140 | 1 |
40922 | 40922 | 2020-04-08 | DeSoto | Florida | 12027 | 19 | 3 |
41846 | 41846 | 2020-04-08 | DeSoto | Mississippi | 28033 | 144 | 1 |
43496 | 43496 | 2020-04-09 | DeSoto | Florida | 12027 | 20 | 3 |
44422 | 44422 | 2020-04-09 | DeSoto | Mississippi | 28033 | 150 | 1 |
46097 | 46097 | 2020-04-10 | DeSoto | Florida | 12027 | 20 | 3 |
47031 | 47031 | 2020-04-10 | DeSoto | Mississippi | 28033 | 158 | 1 |
48727 | 48727 | 2020-04-11 | DeSoto | Florida | 12027 | 20 | 3 |
49677 | 49677 | 2020-04-11 | DeSoto | Mississippi | 28033 | 163 | 2 |
51388 | 51388 | 2020-04-12 | DeSoto | Florida | 12027 | 20 | 3 |
52350 | 52350 | 2020-04-12 | DeSoto | Mississippi | 28033 | 171 | 2 |
54068 | 54068 | 2020-04-13 | DeSoto | Florida | 12027 | 22 | 3 |
55032 | 55032 | 2020-04-13 | DeSoto | Mississippi | 28033 | 178 | 2 |
56760 | 56760 | 2020-04-14 | DeSoto | Florida | 12027 | 22 | 3 |
57730 | 57730 | 2020-04-14 | DeSoto | Mississippi | 28033 | 188 | 2 |
59468 | 59468 | 2020-04-15 | DeSoto | Florida | 12027 | 22 | 3 |
60441 | 60441 | 2020-04-15 | DeSoto | Mississippi | 28033 | 199 | 3 |
62187 | 62187 | 2020-04-16 | DeSoto | Florida | 12027 | 22 | 3 |
63163 | 63163 | 2020-04-16 | DeSoto | Mississippi | 28033 | 211 | 3 |
64920 | 64920 | 2020-04-17 | DeSoto | Florida | 12027 | 23 | 3 |
65903 | 65903 | 2020-04-17 | DeSoto | Mississippi | 28033 | 213 | 3 |
67668 | 67668 | 2020-04-18 | DeSoto | Florida | 12027 | 23 | 4 |
68655 | 68655 | 2020-04-18 | DeSoto | Mississippi | 28033 | 220 | 3 |
70430 | 70430 | 2020-04-19 | DeSoto | Florida | 12027 | 24 | 4 |
71421 | 71421 | 2020-04-19 | DeSoto | Mississippi | 28033 | 234 | 3 |
73199 | 73199 | 2020-04-20 | DeSoto | Florida | 12027 | 24 | 4 |
74194 | 74194 | 2020-04-20 | DeSoto | Mississippi | 28033 | 238 | 3 |
75975 | 75975 | 2020-04-21 | DeSoto | Florida | 12027 | 24 | 4 |
76975 | 76975 | 2020-04-21 | DeSoto | Mississippi | 28033 | 239 | 3 |
78759 | 78759 | 2020-04-22 | DeSoto | Florida | 12027 | 24 | 4 |
79760 | 79760 | 2020-04-22 | DeSoto | Mississippi | 28033 | 244 | 3 |
81553 | 81553 | 2020-04-23 | DeSoto | Florida | 12027 | 24 | 4 |
82556 | 82556 | 2020-04-23 | DeSoto | Mississippi | 28033 | 252 | 4 |
84353 | 84353 | 2020-04-24 | DeSoto | Florida | 12027 | 24 | 4 |
85360 | 85360 | 2020-04-24 | DeSoto | Mississippi | 28033 | 256 | 4 |
87161 | 87161 | 2020-04-25 | DeSoto | Florida | 12027 | 24 | 4 |
88170 | 88170 | 2020-04-25 | DeSoto | Mississippi | 28033 | 263 | 4 |
89978 | 89978 | 2020-04-26 | DeSoto | Florida | 12027 | 24 | 4 |
90986 | 90986 | 2020-04-26 | DeSoto | Mississippi | 28033 | 261 | 4 |
92796 | 92796 | 2020-04-27 | DeSoto | Florida | 12027 | 25 | 4 |
93807 | 93807 | 2020-04-27 | DeSoto | Mississippi | 28033 | 266 | 4 |
95628 | 95628 | 2020-04-28 | DeSoto | Florida | 12027 | 26 | 4 |
96643 | 96643 | 2020-04-28 | DeSoto | Mississippi | 28033 | 272 | 4 |
98473 | 98473 | 2020-04-29 | DeSoto | Florida | 12027 | 28 | 4 |
99489 | 99489 | 2020-04-29 | DeSoto | Mississippi | 28033 | 277 | 4 |
101323 | 101323 | 2020-04-30 | DeSoto | Florida | 12027 | 29 | 4 |
102341 | 102341 | 2020-04-30 | DeSoto | Mississippi | 28033 | 282 | 4 |
104178 | 104178 | 2020-05-01 | DeSoto | Florida | 12027 | 30 | 4 |
105202 | 105202 | 2020-05-01 | DeSoto | Mississippi | 28033 | 293 | 4 |
107043 | 107043 | 2020-05-02 | DeSoto | Florida | 12027 | 31 | 4 |
108067 | 108067 | 2020-05-02 | DeSoto | Mississippi | 28033 | 294 | 4 |
109912 | 109912 | 2020-05-03 | DeSoto | Florida | 12027 | 32 | 4 |
110938 | 110938 | 2020-05-03 | DeSoto | Mississippi | 28033 | 298 | 4 |
112787 | 112787 | 2020-05-04 | DeSoto | Florida | 12027 | 39 | 4 |
113817 | 113817 | 2020-05-04 | DeSoto | Mississippi | 28033 | 304 | 4 |
115670 | 115670 | 2020-05-05 | DeSoto | Florida | 12027 | 40 | 4 |
116699 | 116699 | 2020-05-05 | DeSoto | Mississippi | 28033 | 308 | 4 |
118630 | 118630 | 2020-05-06 | DeSoto | Florida | 12027 | 42 | 4 |
119659 | 119659 | 2020-05-06 | DeSoto | Mississippi | 28033 | 310 | 4 |
121599 | 121599 | 2020-05-07 | DeSoto | Florida | 12027 | 42 | 5 |
122633 | 122633 | 2020-05-07 | DeSoto | Mississippi | 28033 | 320 | 5 |
124578 | 124578 | 2020-05-08 | DeSoto | Florida | 12027 | 42 | 5 |
125615 | 125615 | 2020-05-08 | DeSoto | Mississippi | 28033 | 325 | 5 |
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);