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 cases
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 |
7273 | 7273 | 2020-03-22 | DeSoto | Florida | 12027 | 1 | 0 |
8419 | 8419 | 2020-03-23 | DeSoto | Florida | 12027 | 1 | 0 |
9664 | 9664 | 2020-03-24 | DeSoto | Florida | 12027 | 1 | 0 |
4783 | 4783 | 2020-03-19 | DeSoto | Mississippi | 28033 | 2 | 0 |
5606 | 5606 | 2020-03-20 | DeSoto | Mississippi | 28033 | 4 | 0 |
11038 | 11038 | 2020-03-25 | DeSoto | Florida | 12027 | 4 | 0 |
12586 | 12586 | 2020-03-26 | DeSoto | Florida | 12027 | 5 | 0 |
14255 | 14255 | 2020-03-27 | DeSoto | Florida | 12027 | 6 | 0 |
16039 | 16039 | 2020-03-28 | DeSoto | Florida | 12027 | 7 | 0 |
17931 | 17931 | 2020-03-29 | DeSoto | Florida | 12027 | 7 | 0 |
19911 | 19911 | 2020-03-30 | DeSoto | Florida | 12027 | 7 | 2 |
21989 | 21989 | 2020-03-31 | DeSoto | Florida | 12027 | 7 | 1 |
24148 | 24148 | 2020-04-01 | DeSoto | Florida | 12027 | 7 | 1 |
26378 | 26378 | 2020-04-02 | DeSoto | Florida | 12027 | 8 | 1 |
28680 | 28680 | 2020-04-03 | DeSoto | Florida | 12027 | 9 | 1 |
31038 | 31038 | 2020-04-04 | DeSoto | Florida | 12027 | 11 | 1 |
33444 | 33444 | 2020-04-05 | DeSoto | Florida | 12027 | 12 | 2 |
6582 | 6582 | 2020-03-21 | DeSoto | Mississippi | 28033 | 13 | 0 |
35889 | 35889 | 2020-04-06 | DeSoto | Florida | 12027 | 14 | 3 |
38379 | 38379 | 2020-04-07 | DeSoto | Florida | 12027 | 16 | 3 |
7665 | 7665 | 2020-03-22 | DeSoto | Mississippi | 28033 | 18 | 0 |
40922 | 40922 | 2020-04-08 | DeSoto | Florida | 12027 | 19 | 3 |
43496 | 43496 | 2020-04-09 | DeSoto | Florida | 12027 | 20 | 3 |
46097 | 46097 | 2020-04-10 | DeSoto | Florida | 12027 | 20 | 3 |
48727 | 48727 | 2020-04-11 | DeSoto | Florida | 12027 | 20 | 3 |
51388 | 51388 | 2020-04-12 | DeSoto | Florida | 12027 | 20 | 3 |
54068 | 54068 | 2020-04-13 | DeSoto | Florida | 12027 | 22 | 3 |
56760 | 56760 | 2020-04-14 | DeSoto | Florida | 12027 | 22 | 3 |
59468 | 59468 | 2020-04-15 | DeSoto | Florida | 12027 | 22 | 3 |
62187 | 62187 | 2020-04-16 | DeSoto | Florida | 12027 | 22 | 3 |
8845 | 8845 | 2020-03-23 | DeSoto | Mississippi | 28033 | 23 | 0 |
64920 | 64920 | 2020-04-17 | DeSoto | Florida | 12027 | 23 | 3 |
67668 | 67668 | 2020-04-18 | DeSoto | Florida | 12027 | 23 | 4 |
70430 | 70430 | 2020-04-19 | DeSoto | Florida | 12027 | 24 | 4 |
73199 | 73199 | 2020-04-20 | DeSoto | Florida | 12027 | 24 | 4 |
75975 | 75975 | 2020-04-21 | DeSoto | Florida | 12027 | 24 | 4 |
78759 | 78759 | 2020-04-22 | DeSoto | Florida | 12027 | 24 | 4 |
81553 | 81553 | 2020-04-23 | DeSoto | Florida | 12027 | 24 | 4 |
84353 | 84353 | 2020-04-24 | DeSoto | Florida | 12027 | 24 | 4 |
87161 | 87161 | 2020-04-25 | DeSoto | Florida | 12027 | 24 | 4 |
89978 | 89978 | 2020-04-26 | DeSoto | Florida | 12027 | 24 | 4 |
92796 | 92796 | 2020-04-27 | DeSoto | Florida | 12027 | 25 | 4 |
95628 | 95628 | 2020-04-28 | DeSoto | Florida | 12027 | 26 | 4 |
98473 | 98473 | 2020-04-29 | DeSoto | Florida | 12027 | 28 | 4 |
10141 | 10141 | 2020-03-24 | DeSoto | Mississippi | 28033 | 29 | 0 |
101323 | 101323 | 2020-04-30 | DeSoto | Florida | 12027 | 29 | 4 |
104178 | 104178 | 2020-05-01 | DeSoto | Florida | 12027 | 30 | 4 |
107043 | 107043 | 2020-05-02 | DeSoto | Florida | 12027 | 31 | 4 |
109912 | 109912 | 2020-05-03 | DeSoto | Florida | 12027 | 32 | 4 |
11561 | 11561 | 2020-03-25 | DeSoto | Mississippi | 28033 | 36 | 0 |
112787 | 112787 | 2020-05-04 | DeSoto | Florida | 12027 | 39 | 4 |
115670 | 115670 | 2020-05-05 | DeSoto | Florida | 12027 | 40 | 4 |
118630 | 118630 | 2020-05-06 | DeSoto | Florida | 12027 | 42 | 4 |
121599 | 121599 | 2020-05-07 | DeSoto | Florida | 12027 | 42 | 5 |
124578 | 124578 | 2020-05-08 | DeSoto | Florida | 12027 | 42 | 5 |
127565 | 127565 | 2020-05-09 | DeSoto | Florida | 12027 | 47 | 5 |
130556 | 130556 | 2020-05-10 | DeSoto | Florida | 12027 | 47 | 5 |
13153 | 13153 | 2020-03-26 | DeSoto | Mississippi | 28033 | 49 | 0 |
133547 | 133547 | 2020-05-11 | DeSoto | Florida | 12027 | 51 | 5 |
136536 | 136536 | 2020-05-12 | DeSoto | Florida | 12027 | 52 | 6 |
139527 | 139527 | 2020-05-13 | DeSoto | Florida | 12027 | 52 | 6 |
142523 | 142523 | 2020-05-14 | DeSoto | Florida | 12027 | 58 | 6 |
145523 | 145523 | 2020-05-15 | DeSoto | Florida | 12027 | 61 | 6 |
148526 | 148526 | 2020-05-16 | DeSoto | Florida | 12027 | 61 | 6 |
14869 | 14869 | 2020-03-27 | DeSoto | Mississippi | 28033 | 63 | 0 |
16693 | 16693 | 2020-03-28 | DeSoto | Mississippi | 28033 | 65 | 1 |
151535 | 151535 | 2020-05-17 | DeSoto | Florida | 12027 | 66 | 7 |
154547 | 154547 | 2020-05-18 | DeSoto | Florida | 12027 | 68 | 7 |
157563 | 157563 | 2020-05-19 | DeSoto | Florida | 12027 | 69 | 7 |
18615 | 18615 | 2020-03-29 | DeSoto | Mississippi | 28033 | 71 | 1 |
20639 | 20639 | 2020-03-30 | DeSoto | Mississippi | 28033 | 77 | 1 |
160589 | 160589 | 2020-05-20 | DeSoto | Florida | 12027 | 80 | 7 |
22756 | 22756 | 2020-03-31 | DeSoto | Mississippi | 28033 | 84 | 1 |
24939 | 24939 | 2020-04-01 | DeSoto | Mississippi | 28033 | 94 | 1 |
163617 | 163617 | 2020-05-21 | DeSoto | Florida | 12027 | 94 | 7 |
166650 | 166650 | 2020-05-22 | DeSoto | Florida | 12027 | 97 | 8 |
27193 | 27193 | 2020-04-02 | DeSoto | Mississippi | 28033 | 103 | 1 |
29512 | 29512 | 2020-04-03 | DeSoto | Mississippi | 28033 | 111 | 1 |
169687 | 169687 | 2020-05-23 | DeSoto | Florida | 12027 | 112 | 8 |
172728 | 172728 | 2020-05-24 | DeSoto | Florida | 12027 | 115 | 8 |
175771 | 175771 | 2020-05-25 | DeSoto | Florida | 12027 | 117 | 8 |
31892 | 31892 | 2020-04-04 | DeSoto | Mississippi | 28033 | 118 | 1 |
178815 | 178815 | 2020-05-26 | DeSoto | Florida | 12027 | 121 | 8 |
181859 | 181859 | 2020-05-27 | DeSoto | Florida | 12027 | 124 | 8 |
34319 | 34319 | 2020-04-05 | DeSoto | Mississippi | 28033 | 132 | 1 |
184913 | 184913 | 2020-05-28 | DeSoto | Florida | 12027 | 132 | 8 |
36781 | 36781 | 2020-04-06 | DeSoto | Mississippi | 28033 | 136 | 1 |
39292 | 39292 | 2020-04-07 | DeSoto | Mississippi | 28033 | 140 | 1 |
41846 | 41846 | 2020-04-08 | DeSoto | Mississippi | 28033 | 144 | 1 |
44422 | 44422 | 2020-04-09 | DeSoto | Mississippi | 28033 | 150 | 1 |
47031 | 47031 | 2020-04-10 | DeSoto | Mississippi | 28033 | 158 | 1 |
49677 | 49677 | 2020-04-11 | DeSoto | Mississippi | 28033 | 163 | 2 |
52350 | 52350 | 2020-04-12 | DeSoto | Mississippi | 28033 | 171 | 2 |
187969 | 187969 | 2020-05-29 | DeSoto | Florida | 12027 | 171 | 8 |
191034 | 191034 | 2020-05-30 | DeSoto | Florida | 12027 | 173 | 7 |
55032 | 55032 | 2020-04-13 | DeSoto | Mississippi | 28033 | 178 | 2 |
194101 | 194101 | 2020-05-31 | DeSoto | Florida | 12027 | 182 | 7 |
197171 | 197171 | 2020-06-01 | DeSoto | Florida | 12027 | 182 | 7 |
57730 | 57730 | 2020-04-14 | DeSoto | Mississippi | 28033 | 188 | 2 |
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);