ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Charles Mix" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
295782 | 295782 | 2020-07-02 | Charles Mix | South Dakota | 46023 | 86 | 0 |
292626 | 292626 | 2020-07-01 | Charles Mix | South Dakota | 46023 | 85 | 0 |
289474 | 289474 | 2020-06-30 | Charles Mix | South Dakota | 46023 | 82 | 0 |
286323 | 286323 | 2020-06-29 | Charles Mix | South Dakota | 46023 | 75 | 0 |
283178 | 283178 | 2020-06-28 | Charles Mix | South Dakota | 46023 | 70 | 0 |
280032 | 280032 | 2020-06-27 | Charles Mix | South Dakota | 46023 | 68 | 0 |
276884 | 276884 | 2020-06-26 | Charles Mix | South Dakota | 46023 | 58 | 0 |
273737 | 273737 | 2020-06-25 | Charles Mix | South Dakota | 46023 | 57 | 0 |
270598 | 270598 | 2020-06-24 | Charles Mix | South Dakota | 46023 | 56 | 0 |
267464 | 267464 | 2020-06-23 | Charles Mix | South Dakota | 46023 | 49 | 0 |
264336 | 264336 | 2020-06-22 | Charles Mix | South Dakota | 46023 | 49 | 0 |
261208 | 261208 | 2020-06-21 | Charles Mix | South Dakota | 46023 | 48 | 0 |
258081 | 258081 | 2020-06-20 | Charles Mix | South Dakota | 46023 | 47 | 0 |
254955 | 254955 | 2020-06-19 | Charles Mix | South Dakota | 46023 | 45 | 0 |
251840 | 251840 | 2020-06-18 | Charles Mix | South Dakota | 46023 | 41 | 0 |
248725 | 248725 | 2020-06-17 | Charles Mix | South Dakota | 46023 | 37 | 0 |
245612 | 245612 | 2020-06-16 | Charles Mix | South Dakota | 46023 | 32 | 0 |
242500 | 242500 | 2020-06-15 | Charles Mix | South Dakota | 46023 | 32 | 0 |
239390 | 239390 | 2020-06-14 | Charles Mix | South Dakota | 46023 | 32 | 0 |
236282 | 236282 | 2020-06-13 | Charles Mix | South Dakota | 46023 | 30 | 0 |
233177 | 233177 | 2020-06-12 | Charles Mix | South Dakota | 46023 | 21 | 0 |
230072 | 230072 | 2020-06-11 | Charles Mix | South Dakota | 46023 | 21 | 0 |
226968 | 226968 | 2020-06-10 | Charles Mix | South Dakota | 46023 | 20 | 0 |
223868 | 223868 | 2020-06-09 | Charles Mix | South Dakota | 46023 | 20 | 0 |
220773 | 220773 | 2020-06-08 | Charles Mix | South Dakota | 46023 | 20 | 0 |
217681 | 217681 | 2020-06-07 | Charles Mix | South Dakota | 46023 | 20 | 0 |
214591 | 214591 | 2020-06-06 | Charles Mix | South Dakota | 46023 | 20 | 0 |
211505 | 211505 | 2020-06-05 | Charles Mix | South Dakota | 46023 | 18 | 0 |
208423 | 208423 | 2020-06-04 | Charles Mix | South Dakota | 46023 | 18 | 0 |
205342 | 205342 | 2020-06-03 | Charles Mix | South Dakota | 46023 | 18 | 0 |
202264 | 202264 | 2020-06-02 | Charles Mix | South Dakota | 46023 | 18 | 0 |
199189 | 199189 | 2020-06-01 | Charles Mix | South Dakota | 46023 | 17 | 0 |
196116 | 196116 | 2020-05-31 | Charles Mix | South Dakota | 46023 | 17 | 0 |
193047 | 193047 | 2020-05-30 | Charles Mix | South Dakota | 46023 | 17 | 0 |
189982 | 189982 | 2020-05-29 | Charles Mix | South Dakota | 46023 | 16 | 0 |
186920 | 186920 | 2020-05-28 | Charles Mix | South Dakota | 46023 | 16 | 0 |
183863 | 183863 | 2020-05-27 | Charles Mix | South Dakota | 46023 | 14 | 0 |
180813 | 180813 | 2020-05-26 | Charles Mix | South Dakota | 46023 | 13 | 0 |
177770 | 177770 | 2020-05-25 | Charles Mix | South Dakota | 46023 | 13 | 0 |
174726 | 174726 | 2020-05-24 | Charles Mix | South Dakota | 46023 | 13 | 0 |
171684 | 171684 | 2020-05-23 | Charles Mix | South Dakota | 46023 | 12 | 0 |
168645 | 168645 | 2020-05-22 | Charles Mix | South Dakota | 46023 | 11 | 0 |
165609 | 165609 | 2020-05-21 | Charles Mix | South Dakota | 46023 | 10 | 0 |
162580 | 162580 | 2020-05-20 | Charles Mix | South Dakota | 46023 | 10 | 0 |
159553 | 159553 | 2020-05-19 | Charles Mix | South Dakota | 46023 | 10 | 0 |
156532 | 156532 | 2020-05-18 | Charles Mix | South Dakota | 46023 | 9 | 0 |
153515 | 153515 | 2020-05-17 | Charles Mix | South Dakota | 46023 | 9 | 0 |
150504 | 150504 | 2020-05-16 | Charles Mix | South Dakota | 46023 | 8 | 0 |
147496 | 147496 | 2020-05-15 | Charles Mix | South Dakota | 46023 | 8 | 0 |
144495 | 144495 | 2020-05-14 | Charles Mix | South Dakota | 46023 | 7 | 0 |
141499 | 141499 | 2020-05-13 | Charles Mix | South Dakota | 46023 | 6 | 0 |
138503 | 138503 | 2020-05-12 | Charles Mix | South Dakota | 46023 | 5 | 0 |
135513 | 135513 | 2020-05-11 | Charles Mix | South Dakota | 46023 | 5 | 0 |
132522 | 132522 | 2020-05-10 | Charles Mix | South Dakota | 46023 | 5 | 0 |
129533 | 129533 | 2020-05-09 | Charles Mix | South Dakota | 46023 | 5 | 0 |
126544 | 126544 | 2020-05-08 | Charles Mix | South Dakota | 46023 | 5 | 0 |
123561 | 123561 | 2020-05-07 | Charles Mix | South Dakota | 46023 | 5 | 0 |
120583 | 120583 | 2020-05-06 | Charles Mix | South Dakota | 46023 | 5 | 0 |
117621 | 117621 | 2020-05-05 | Charles Mix | South Dakota | 46023 | 5 | 0 |
114665 | 114665 | 2020-05-04 | Charles Mix | South Dakota | 46023 | 5 | 0 |
111783 | 111783 | 2020-05-03 | Charles Mix | South Dakota | 46023 | 5 | 0 |
108909 | 108909 | 2020-05-02 | Charles Mix | South Dakota | 46023 | 5 | 0 |
106042 | 106042 | 2020-05-01 | Charles Mix | South Dakota | 46023 | 5 | 0 |
103179 | 103179 | 2020-04-30 | Charles Mix | South Dakota | 46023 | 5 | 0 |
100326 | 100326 | 2020-04-29 | Charles Mix | South Dakota | 46023 | 5 | 0 |
97477 | 97477 | 2020-04-28 | Charles Mix | South Dakota | 46023 | 4 | 0 |
94637 | 94637 | 2020-04-27 | Charles Mix | South Dakota | 46023 | 4 | 0 |
91810 | 91810 | 2020-04-26 | Charles Mix | South Dakota | 46023 | 4 | 0 |
88994 | 88994 | 2020-04-25 | Charles Mix | South Dakota | 46023 | 4 | 0 |
86180 | 86180 | 2020-04-24 | Charles Mix | South Dakota | 46023 | 4 | 0 |
83376 | 83376 | 2020-04-23 | Charles Mix | South Dakota | 46023 | 4 | 0 |
80577 | 80577 | 2020-04-22 | Charles Mix | South Dakota | 46023 | 4 | 0 |
77787 | 77787 | 2020-04-21 | Charles Mix | South Dakota | 46023 | 4 | 0 |
75005 | 75005 | 2020-04-20 | Charles Mix | South Dakota | 46023 | 4 | 0 |
72230 | 72230 | 2020-04-19 | Charles Mix | South Dakota | 46023 | 4 | 0 |
69463 | 69463 | 2020-04-18 | Charles Mix | South Dakota | 46023 | 4 | 0 |
66705 | 66705 | 2020-04-17 | Charles Mix | South Dakota | 46023 | 4 | 0 |
63959 | 63959 | 2020-04-16 | Charles Mix | South Dakota | 46023 | 4 | 0 |
61233 | 61233 | 2020-04-15 | Charles Mix | South Dakota | 46023 | 4 | 0 |
58518 | 58518 | 2020-04-14 | Charles Mix | South Dakota | 46023 | 4 | 0 |
55815 | 55815 | 2020-04-13 | Charles Mix | South Dakota | 46023 | 4 | 0 |
53130 | 53130 | 2020-04-12 | Charles Mix | South Dakota | 46023 | 4 | 0 |
50457 | 50457 | 2020-04-11 | Charles Mix | South Dakota | 46023 | 3 | 0 |
47800 | 47800 | 2020-04-10 | Charles Mix | South Dakota | 46023 | 3 | 0 |
45183 | 45183 | 2020-04-09 | Charles Mix | South Dakota | 46023 | 2 | 0 |
42597 | 42597 | 2020-04-08 | Charles Mix | South Dakota | 46023 | 2 | 0 |
40037 | 40037 | 2020-04-07 | Charles Mix | South Dakota | 46023 | 2 | 0 |
37514 | 37514 | 2020-04-06 | Charles Mix | South Dakota | 46023 | 2 | 0 |
35039 | 35039 | 2020-04-05 | Charles Mix | South Dakota | 46023 | 2 | 0 |
32603 | 32603 | 2020-04-04 | Charles Mix | South Dakota | 46023 | 2 | 0 |
30212 | 30212 | 2020-04-03 | Charles Mix | South Dakota | 46023 | 1 | 0 |
27877 | 27877 | 2020-04-02 | Charles Mix | South Dakota | 46023 | 1 | 0 |
25601 | 25601 | 2020-04-01 | Charles Mix | South Dakota | 46023 | 1 | 0 |
23403 | 23403 | 2020-03-31 | Charles Mix | South Dakota | 46023 | 1 | 0 |
21265 | 21265 | 2020-03-30 | Charles Mix | South Dakota | 46023 | 1 | 0 |
19213 | 19213 | 2020-03-29 | Charles Mix | South Dakota | 46023 | 1 | 0 |
17273 | 17273 | 2020-03-28 | Charles Mix | South Dakota | 46023 | 1 | 0 |
15418 | 15418 | 2020-03-27 | Charles Mix | South Dakota | 46023 | 1 | 0 |
13670 | 13670 | 2020-03-26 | Charles Mix | South Dakota | 46023 | 1 | 0 |
12048 | 12048 | 2020-03-25 | Charles Mix | South Dakota | 46023 | 1 | 0 |
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);