ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Minnehaha" and state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1127 | 1127 | 2020-03-10 | Minnehaha | South Dakota | 46099 | 1 | 0 |
1323 | 1323 | 2020-03-11 | Minnehaha | South Dakota | 46099 | 3 | 0 |
1569 | 1569 | 2020-03-12 | Minnehaha | South Dakota | 46099 | 3 | 0 |
1870 | 1870 | 2020-03-13 | Minnehaha | South Dakota | 46099 | 3 | 0 |
2234 | 2234 | 2020-03-14 | Minnehaha | South Dakota | 46099 | 3 | 0 |
2659 | 2659 | 2020-03-15 | Minnehaha | South Dakota | 46099 | 3 | 0 |
3125 | 3125 | 2020-03-16 | Minnehaha | South Dakota | 46099 | 4 | 0 |
3658 | 3658 | 2020-03-17 | Minnehaha | South Dakota | 46099 | 5 | 0 |
4278 | 4278 | 2020-03-18 | Minnehaha | South Dakota | 46099 | 5 | 0 |
5023 | 5023 | 2020-03-19 | Minnehaha | South Dakota | 46099 | 5 | 0 |
5904 | 5904 | 2020-03-20 | Minnehaha | South Dakota | 46099 | 5 | 0 |
6914 | 6914 | 2020-03-21 | Minnehaha | South Dakota | 46099 | 5 | 0 |
8036 | 8036 | 2020-03-22 | Minnehaha | South Dakota | 46099 | 5 | 0 |
9253 | 9253 | 2020-03-23 | Minnehaha | South Dakota | 46099 | 5 | 0 |
10580 | 10580 | 2020-03-24 | Minnehaha | South Dakota | 46099 | 5 | 0 |
12056 | 12056 | 2020-03-25 | Minnehaha | South Dakota | 46099 | 13 | 0 |
13678 | 13678 | 2020-03-26 | Minnehaha | South Dakota | 46099 | 16 | 0 |
15428 | 15428 | 2020-03-27 | Minnehaha | South Dakota | 46099 | 18 | 0 |
17286 | 17286 | 2020-03-28 | Minnehaha | South Dakota | 46099 | 21 | 0 |
19229 | 19229 | 2020-03-29 | Minnehaha | South Dakota | 46099 | 25 | 0 |
21282 | 21282 | 2020-03-30 | Minnehaha | South Dakota | 46099 | 28 | 0 |
23420 | 23420 | 2020-03-31 | Minnehaha | South Dakota | 46099 | 31 | 0 |
25618 | 25618 | 2020-04-01 | Minnehaha | South Dakota | 46099 | 40 | 0 |
27895 | 27895 | 2020-04-02 | Minnehaha | South Dakota | 46099 | 54 | 0 |
30230 | 30230 | 2020-04-03 | Minnehaha | South Dakota | 46099 | 68 | 0 |
32621 | 32621 | 2020-04-04 | Minnehaha | South Dakota | 46099 | 81 | 0 |
35057 | 35057 | 2020-04-05 | Minnehaha | South Dakota | 46099 | 104 | 0 |
37532 | 37532 | 2020-04-06 | Minnehaha | South Dakota | 46099 | 140 | 0 |
40055 | 40055 | 2020-04-07 | Minnehaha | South Dakota | 46099 | 165 | 0 |
42615 | 42615 | 2020-04-08 | Minnehaha | South Dakota | 46099 | 228 | 0 |
45203 | 45203 | 2020-04-09 | Minnehaha | South Dakota | 46099 | 274 | 2 |
47821 | 47821 | 2020-04-10 | Minnehaha | South Dakota | 46099 | 352 | 2 |
50478 | 50478 | 2020-04-11 | Minnehaha | South Dakota | 46099 | 438 | 2 |
53151 | 53151 | 2020-04-12 | Minnehaha | South Dakota | 46099 | 527 | 2 |
55837 | 55837 | 2020-04-13 | Minnehaha | South Dakota | 46099 | 654 | 2 |
58540 | 58540 | 2020-04-14 | Minnehaha | South Dakota | 46099 | 768 | 2 |
61255 | 61255 | 2020-04-15 | Minnehaha | South Dakota | 46099 | 934 | 2 |
63981 | 63981 | 2020-04-16 | Minnehaha | South Dakota | 46099 | 1065 | 3 |
66727 | 66727 | 2020-04-17 | Minnehaha | South Dakota | 46099 | 1157 | 3 |
69485 | 69485 | 2020-04-18 | Minnehaha | South Dakota | 46099 | 1276 | 3 |
72252 | 72252 | 2020-04-19 | Minnehaha | South Dakota | 46099 | 1362 | 3 |
75027 | 75027 | 2020-04-20 | Minnehaha | South Dakota | 46099 | 1405 | 3 |
77809 | 77809 | 2020-04-21 | Minnehaha | South Dakota | 46099 | 1469 | 4 |
80599 | 80599 | 2020-04-22 | Minnehaha | South Dakota | 46099 | 1555 | 5 |
83398 | 83398 | 2020-04-23 | Minnehaha | South Dakota | 46099 | 1636 | 5 |
86202 | 86202 | 2020-04-24 | Minnehaha | South Dakota | 46099 | 1707 | 5 |
89017 | 89017 | 2020-04-25 | Minnehaha | South Dakota | 46099 | 1796 | 5 |
91834 | 91834 | 2020-04-26 | Minnehaha | South Dakota | 46099 | 1854 | 6 |
94662 | 94662 | 2020-04-27 | Minnehaha | South Dakota | 46099 | 1880 | 6 |
97502 | 97502 | 2020-04-28 | Minnehaha | South Dakota | 46099 | 1939 | 6 |
100352 | 100352 | 2020-04-29 | Minnehaha | South Dakota | 46099 | 1984 | 8 |
103205 | 103205 | 2020-04-30 | Minnehaha | South Dakota | 46099 | 2038 | 12 |
106068 | 106068 | 2020-05-01 | Minnehaha | South Dakota | 46099 | 2089 | 16 |
108935 | 108935 | 2020-05-02 | Minnehaha | South Dakota | 46099 | 2123 | 16 |
111809 | 111809 | 2020-05-03 | Minnehaha | South Dakota | 46099 | 2142 | 16 |
114691 | 114691 | 2020-05-04 | Minnehaha | South Dakota | 46099 | 2170 | 16 |
117647 | 117647 | 2020-05-05 | Minnehaha | South Dakota | 46099 | 2195 | 19 |
120610 | 120610 | 2020-05-06 | Minnehaha | South Dakota | 46099 | 2231 | 24 |
123588 | 123588 | 2020-05-07 | Minnehaha | South Dakota | 46099 | 2332 | 26 |
126571 | 126571 | 2020-05-08 | Minnehaha | South Dakota | 46099 | 2535 | 26 |
129560 | 129560 | 2020-05-09 | Minnehaha | South Dakota | 46099 | 2767 | 29 |
132549 | 132549 | 2020-05-10 | Minnehaha | South Dakota | 46099 | 2867 | 29 |
135540 | 135540 | 2020-05-11 | Minnehaha | South Dakota | 46099 | 2952 | 29 |
138530 | 138530 | 2020-05-12 | Minnehaha | South Dakota | 46099 | 2978 | 34 |
141526 | 141526 | 2020-05-13 | Minnehaha | South Dakota | 46099 | 3017 | 34 |
144522 | 144522 | 2020-05-14 | Minnehaha | South Dakota | 46099 | 3050 | 38 |
147523 | 147523 | 2020-05-15 | Minnehaha | South Dakota | 46099 | 3101 | 39 |
150531 | 150531 | 2020-05-16 | Minnehaha | South Dakota | 46099 | 3119 | 39 |
153542 | 153542 | 2020-05-17 | Minnehaha | South Dakota | 46099 | 3135 | 39 |
156559 | 156559 | 2020-05-18 | Minnehaha | South Dakota | 46099 | 3150 | 39 |
159580 | 159580 | 2020-05-19 | Minnehaha | South Dakota | 46099 | 3165 | 40 |
162607 | 162607 | 2020-05-20 | Minnehaha | South Dakota | 46099 | 3182 | 40 |
165636 | 165636 | 2020-05-21 | Minnehaha | South Dakota | 46099 | 3182 | 40 |
168672 | 168672 | 2020-05-22 | Minnehaha | South Dakota | 46099 | 3211 | 43 |
171711 | 171711 | 2020-05-23 | Minnehaha | South Dakota | 46099 | 3248 | 43 |
174754 | 174754 | 2020-05-24 | Minnehaha | South Dakota | 46099 | 3260 | 43 |
177798 | 177798 | 2020-05-25 | Minnehaha | South Dakota | 46099 | 3274 | 43 |
180841 | 180841 | 2020-05-26 | Minnehaha | South Dakota | 46099 | 3289 | 43 |
183891 | 183891 | 2020-05-27 | Minnehaha | South Dakota | 46099 | 3300 | 45 |
186948 | 186948 | 2020-05-28 | Minnehaha | South Dakota | 46099 | 3317 | 45 |
190012 | 190012 | 2020-05-29 | Minnehaha | South Dakota | 46099 | 3330 | 49 |
193077 | 193077 | 2020-05-30 | Minnehaha | South Dakota | 46099 | 3345 | 49 |
196147 | 196147 | 2020-05-31 | Minnehaha | South Dakota | 46099 | 3349 | 49 |
199220 | 199220 | 2020-06-01 | Minnehaha | South Dakota | 46099 | 3355 | 49 |
202295 | 202295 | 2020-06-02 | Minnehaha | South Dakota | 46099 | 3362 | 49 |
205374 | 205374 | 2020-06-03 | Minnehaha | South Dakota | 46099 | 3377 | 49 |
208456 | 208456 | 2020-06-04 | Minnehaha | South Dakota | 46099 | 3385 | 50 |
211538 | 211538 | 2020-06-05 | Minnehaha | South Dakota | 46099 | 3387 | 50 |
214625 | 214625 | 2020-06-06 | Minnehaha | South Dakota | 46099 | 3397 | 50 |
217715 | 217715 | 2020-06-07 | Minnehaha | South Dakota | 46099 | 3407 | 50 |
220807 | 220807 | 2020-06-08 | Minnehaha | South Dakota | 46099 | 3409 | 50 |
223902 | 223902 | 2020-06-09 | Minnehaha | South Dakota | 46099 | 3418 | 51 |
227002 | 227002 | 2020-06-10 | Minnehaha | South Dakota | 46099 | 3430 | 51 |
230106 | 230106 | 2020-06-11 | Minnehaha | South Dakota | 46099 | 3444 | 52 |
233211 | 233211 | 2020-06-12 | Minnehaha | South Dakota | 46099 | 3458 | 53 |
236317 | 236317 | 2020-06-13 | Minnehaha | South Dakota | 46099 | 3467 | 53 |
239425 | 239425 | 2020-06-14 | Minnehaha | South Dakota | 46099 | 3479 | 53 |
242535 | 242535 | 2020-06-15 | Minnehaha | South Dakota | 46099 | 3485 | 53 |
245647 | 245647 | 2020-06-16 | Minnehaha | South Dakota | 46099 | 3488 | 54 |
248760 | 248760 | 2020-06-17 | Minnehaha | South Dakota | 46099 | 3499 | 54 |
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);