ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46125 and state = "South Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
19233 | 19233 | 2020-03-29 | Turner | South Dakota | 46125 | 1 | 0 |
21286 | 21286 | 2020-03-30 | Turner | South Dakota | 46125 | 1 | 0 |
23424 | 23424 | 2020-03-31 | Turner | South Dakota | 46125 | 1 | 0 |
25622 | 25622 | 2020-04-01 | Turner | South Dakota | 46125 | 1 | 0 |
27900 | 27900 | 2020-04-02 | Turner | South Dakota | 46125 | 2 | 0 |
30235 | 30235 | 2020-04-03 | Turner | South Dakota | 46125 | 3 | 0 |
32626 | 32626 | 2020-04-04 | Turner | South Dakota | 46125 | 3 | 0 |
35062 | 35062 | 2020-04-05 | Turner | South Dakota | 46125 | 4 | 0 |
37537 | 37537 | 2020-04-06 | Turner | South Dakota | 46125 | 4 | 0 |
40060 | 40060 | 2020-04-07 | Turner | South Dakota | 46125 | 4 | 0 |
42621 | 42621 | 2020-04-08 | Turner | South Dakota | 46125 | 5 | 0 |
45209 | 45209 | 2020-04-09 | Turner | South Dakota | 46125 | 5 | 0 |
47827 | 47827 | 2020-04-10 | Turner | South Dakota | 46125 | 5 | 0 |
50485 | 50485 | 2020-04-11 | Turner | South Dakota | 46125 | 5 | 0 |
53159 | 53159 | 2020-04-12 | Turner | South Dakota | 46125 | 5 | 0 |
55845 | 55845 | 2020-04-13 | Turner | South Dakota | 46125 | 5 | 0 |
58548 | 58548 | 2020-04-14 | Turner | South Dakota | 46125 | 5 | 0 |
61263 | 61263 | 2020-04-15 | Turner | South Dakota | 46125 | 5 | 0 |
63990 | 63990 | 2020-04-16 | Turner | South Dakota | 46125 | 5 | 0 |
66736 | 66736 | 2020-04-17 | Turner | South Dakota | 46125 | 5 | 0 |
69494 | 69494 | 2020-04-18 | Turner | South Dakota | 46125 | 5 | 0 |
72261 | 72261 | 2020-04-19 | Turner | South Dakota | 46125 | 6 | 0 |
75036 | 75036 | 2020-04-20 | Turner | South Dakota | 46125 | 6 | 0 |
77818 | 77818 | 2020-04-21 | Turner | South Dakota | 46125 | 6 | 0 |
80608 | 80608 | 2020-04-22 | Turner | South Dakota | 46125 | 9 | 0 |
83407 | 83407 | 2020-04-23 | Turner | South Dakota | 46125 | 13 | 0 |
86212 | 86212 | 2020-04-24 | Turner | South Dakota | 46125 | 13 | 0 |
89027 | 89027 | 2020-04-25 | Turner | South Dakota | 46125 | 15 | 0 |
91844 | 91844 | 2020-04-26 | Turner | South Dakota | 46125 | 15 | 0 |
94672 | 94672 | 2020-04-27 | Turner | South Dakota | 46125 | 15 | 0 |
97512 | 97512 | 2020-04-28 | Turner | South Dakota | 46125 | 15 | 0 |
100362 | 100362 | 2020-04-29 | Turner | South Dakota | 46125 | 15 | 0 |
103215 | 103215 | 2020-04-30 | Turner | South Dakota | 46125 | 17 | 0 |
106078 | 106078 | 2020-05-01 | Turner | South Dakota | 46125 | 17 | 0 |
108945 | 108945 | 2020-05-02 | Turner | South Dakota | 46125 | 17 | 0 |
111819 | 111819 | 2020-05-03 | Turner | South Dakota | 46125 | 17 | 0 |
114701 | 114701 | 2020-05-04 | Turner | South Dakota | 46125 | 17 | 0 |
117657 | 117657 | 2020-05-05 | Turner | South Dakota | 46125 | 17 | 0 |
120620 | 120620 | 2020-05-06 | Turner | South Dakota | 46125 | 18 | 0 |
123598 | 123598 | 2020-05-07 | Turner | South Dakota | 46125 | 18 | 0 |
126581 | 126581 | 2020-05-08 | Turner | South Dakota | 46125 | 18 | 0 |
129570 | 129570 | 2020-05-09 | Turner | South Dakota | 46125 | 18 | 0 |
132559 | 132559 | 2020-05-10 | Turner | South Dakota | 46125 | 18 | 0 |
135550 | 135550 | 2020-05-11 | Turner | South Dakota | 46125 | 18 | 0 |
138540 | 138540 | 2020-05-12 | Turner | South Dakota | 46125 | 18 | 0 |
141536 | 141536 | 2020-05-13 | Turner | South Dakota | 46125 | 18 | 0 |
144533 | 144533 | 2020-05-14 | Turner | South Dakota | 46125 | 18 | 0 |
147534 | 147534 | 2020-05-15 | Turner | South Dakota | 46125 | 19 | 0 |
150542 | 150542 | 2020-05-16 | Turner | South Dakota | 46125 | 19 | 0 |
153553 | 153553 | 2020-05-17 | Turner | South Dakota | 46125 | 19 | 0 |
156570 | 156570 | 2020-05-18 | Turner | South Dakota | 46125 | 19 | 0 |
159591 | 159591 | 2020-05-19 | Turner | South Dakota | 46125 | 21 | 0 |
162618 | 162618 | 2020-05-20 | Turner | South Dakota | 46125 | 22 | 0 |
165647 | 165647 | 2020-05-21 | Turner | South Dakota | 46125 | 22 | 0 |
168683 | 168683 | 2020-05-22 | Turner | South Dakota | 46125 | 22 | 0 |
171722 | 171722 | 2020-05-23 | Turner | South Dakota | 46125 | 22 | 0 |
174765 | 174765 | 2020-05-24 | Turner | South Dakota | 46125 | 22 | 0 |
177809 | 177809 | 2020-05-25 | Turner | South Dakota | 46125 | 23 | 0 |
180852 | 180852 | 2020-05-26 | Turner | South Dakota | 46125 | 23 | 0 |
183902 | 183902 | 2020-05-27 | Turner | South Dakota | 46125 | 24 | 0 |
186959 | 186959 | 2020-05-28 | Turner | South Dakota | 46125 | 24 | 0 |
190023 | 190023 | 2020-05-29 | Turner | South Dakota | 46125 | 24 | 0 |
193088 | 193088 | 2020-05-30 | Turner | South Dakota | 46125 | 24 | 0 |
196158 | 196158 | 2020-05-31 | Turner | South Dakota | 46125 | 24 | 0 |
199231 | 199231 | 2020-06-01 | Turner | South Dakota | 46125 | 24 | 0 |
202306 | 202306 | 2020-06-02 | Turner | South Dakota | 46125 | 25 | 0 |
205385 | 205385 | 2020-06-03 | Turner | South Dakota | 46125 | 25 | 0 |
208467 | 208467 | 2020-06-04 | Turner | South Dakota | 46125 | 25 | 0 |
211549 | 211549 | 2020-06-05 | Turner | South Dakota | 46125 | 25 | 0 |
214636 | 214636 | 2020-06-06 | Turner | South Dakota | 46125 | 25 | 0 |
217726 | 217726 | 2020-06-07 | Turner | South Dakota | 46125 | 25 | 0 |
220818 | 220818 | 2020-06-08 | Turner | South Dakota | 46125 | 25 | 0 |
223913 | 223913 | 2020-06-09 | Turner | South Dakota | 46125 | 25 | 0 |
227013 | 227013 | 2020-06-10 | Turner | South Dakota | 46125 | 25 | 0 |
230117 | 230117 | 2020-06-11 | Turner | South Dakota | 46125 | 25 | 0 |
233222 | 233222 | 2020-06-12 | Turner | South Dakota | 46125 | 25 | 0 |
236328 | 236328 | 2020-06-13 | Turner | South Dakota | 46125 | 25 | 0 |
239436 | 239436 | 2020-06-14 | Turner | South Dakota | 46125 | 25 | 0 |
242546 | 242546 | 2020-06-15 | Turner | South Dakota | 46125 | 25 | 0 |
245658 | 245658 | 2020-06-16 | Turner | South Dakota | 46125 | 25 | 0 |
248771 | 248771 | 2020-06-17 | Turner | South Dakota | 46125 | 25 | 0 |
251886 | 251886 | 2020-06-18 | Turner | South Dakota | 46125 | 25 | 0 |
255001 | 255001 | 2020-06-19 | Turner | South Dakota | 46125 | 25 | 0 |
258127 | 258127 | 2020-06-20 | Turner | South Dakota | 46125 | 25 | 0 |
261254 | 261254 | 2020-06-21 | Turner | South Dakota | 46125 | 24 | 0 |
264382 | 264382 | 2020-06-22 | Turner | South Dakota | 46125 | 24 | 0 |
267510 | 267510 | 2020-06-23 | Turner | South Dakota | 46125 | 24 | 0 |
270644 | 270644 | 2020-06-24 | Turner | South Dakota | 46125 | 24 | 0 |
273783 | 273783 | 2020-06-25 | Turner | South Dakota | 46125 | 24 | 0 |
276930 | 276930 | 2020-06-26 | Turner | South Dakota | 46125 | 24 | 0 |
280078 | 280078 | 2020-06-27 | Turner | South Dakota | 46125 | 25 | 0 |
283224 | 283224 | 2020-06-28 | Turner | South Dakota | 46125 | 24 | 0 |
286369 | 286369 | 2020-06-29 | Turner | South Dakota | 46125 | 24 | 0 |
289520 | 289520 | 2020-06-30 | Turner | South Dakota | 46125 | 24 | 0 |
292672 | 292672 | 2020-07-01 | Turner | South Dakota | 46125 | 25 | 0 |
295828 | 295828 | 2020-07-02 | Turner | South Dakota | 46125 | 25 | 0 |
298988 | 298988 | 2020-07-03 | Turner | South Dakota | 46125 | 25 | 0 |
302152 | 302152 | 2020-07-04 | Turner | South Dakota | 46125 | 25 | 0 |
305315 | 305315 | 2020-07-05 | Turner | South Dakota | 46125 | 25 | 0 |
308483 | 308483 | 2020-07-06 | Turner | South Dakota | 46125 | 27 | 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);