ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46109 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 |
---|---|---|---|---|---|---|---|
19231 | 19231 | 2020-03-29 | Roberts | South Dakota | 46109 | 1 | 0 |
21284 | 21284 | 2020-03-30 | Roberts | South Dakota | 46109 | 1 | 0 |
23422 | 23422 | 2020-03-31 | Roberts | South Dakota | 46109 | 1 | 0 |
25620 | 25620 | 2020-04-01 | Roberts | South Dakota | 46109 | 2 | 0 |
27897 | 27897 | 2020-04-02 | Roberts | South Dakota | 46109 | 2 | 0 |
30232 | 30232 | 2020-04-03 | Roberts | South Dakota | 46109 | 3 | 0 |
32623 | 32623 | 2020-04-04 | Roberts | South Dakota | 46109 | 4 | 0 |
35059 | 35059 | 2020-04-05 | Roberts | South Dakota | 46109 | 4 | 0 |
37534 | 37534 | 2020-04-06 | Roberts | South Dakota | 46109 | 4 | 0 |
40057 | 40057 | 2020-04-07 | Roberts | South Dakota | 46109 | 4 | 0 |
42618 | 42618 | 2020-04-08 | Roberts | South Dakota | 46109 | 4 | 0 |
45206 | 45206 | 2020-04-09 | Roberts | South Dakota | 46109 | 4 | 0 |
47824 | 47824 | 2020-04-10 | Roberts | South Dakota | 46109 | 4 | 0 |
50481 | 50481 | 2020-04-11 | Roberts | South Dakota | 46109 | 4 | 0 |
53154 | 53154 | 2020-04-12 | Roberts | South Dakota | 46109 | 4 | 0 |
55840 | 55840 | 2020-04-13 | Roberts | South Dakota | 46109 | 4 | 0 |
58543 | 58543 | 2020-04-14 | Roberts | South Dakota | 46109 | 4 | 0 |
61258 | 61258 | 2020-04-15 | Roberts | South Dakota | 46109 | 4 | 0 |
63985 | 63985 | 2020-04-16 | Roberts | South Dakota | 46109 | 4 | 0 |
66731 | 66731 | 2020-04-17 | Roberts | South Dakota | 46109 | 4 | 0 |
69489 | 69489 | 2020-04-18 | Roberts | South Dakota | 46109 | 4 | 0 |
72256 | 72256 | 2020-04-19 | Roberts | South Dakota | 46109 | 4 | 0 |
75031 | 75031 | 2020-04-20 | Roberts | South Dakota | 46109 | 4 | 0 |
77813 | 77813 | 2020-04-21 | Roberts | South Dakota | 46109 | 4 | 0 |
80603 | 80603 | 2020-04-22 | Roberts | South Dakota | 46109 | 4 | 0 |
83402 | 83402 | 2020-04-23 | Roberts | South Dakota | 46109 | 4 | 0 |
86206 | 86206 | 2020-04-24 | Roberts | South Dakota | 46109 | 4 | 0 |
89021 | 89021 | 2020-04-25 | Roberts | South Dakota | 46109 | 4 | 0 |
91838 | 91838 | 2020-04-26 | Roberts | South Dakota | 46109 | 4 | 0 |
94666 | 94666 | 2020-04-27 | Roberts | South Dakota | 46109 | 4 | 0 |
97506 | 97506 | 2020-04-28 | Roberts | South Dakota | 46109 | 4 | 0 |
100356 | 100356 | 2020-04-29 | Roberts | South Dakota | 46109 | 4 | 0 |
103209 | 103209 | 2020-04-30 | Roberts | South Dakota | 46109 | 4 | 0 |
106072 | 106072 | 2020-05-01 | Roberts | South Dakota | 46109 | 8 | 0 |
108939 | 108939 | 2020-05-02 | Roberts | South Dakota | 46109 | 9 | 0 |
111813 | 111813 | 2020-05-03 | Roberts | South Dakota | 46109 | 10 | 0 |
114695 | 114695 | 2020-05-04 | Roberts | South Dakota | 46109 | 10 | 0 |
117651 | 117651 | 2020-05-05 | Roberts | South Dakota | 46109 | 10 | 0 |
120614 | 120614 | 2020-05-06 | Roberts | South Dakota | 46109 | 11 | 0 |
123592 | 123592 | 2020-05-07 | Roberts | South Dakota | 46109 | 11 | 0 |
126575 | 126575 | 2020-05-08 | Roberts | South Dakota | 46109 | 11 | 0 |
129564 | 129564 | 2020-05-09 | Roberts | South Dakota | 46109 | 13 | 0 |
132553 | 132553 | 2020-05-10 | Roberts | South Dakota | 46109 | 14 | 0 |
135544 | 135544 | 2020-05-11 | Roberts | South Dakota | 46109 | 14 | 0 |
138534 | 138534 | 2020-05-12 | Roberts | South Dakota | 46109 | 14 | 0 |
141530 | 141530 | 2020-05-13 | Roberts | South Dakota | 46109 | 14 | 0 |
144526 | 144526 | 2020-05-14 | Roberts | South Dakota | 46109 | 17 | 0 |
147527 | 147527 | 2020-05-15 | Roberts | South Dakota | 46109 | 18 | 0 |
150535 | 150535 | 2020-05-16 | Roberts | South Dakota | 46109 | 19 | 0 |
153546 | 153546 | 2020-05-17 | Roberts | South Dakota | 46109 | 19 | 0 |
156563 | 156563 | 2020-05-18 | Roberts | South Dakota | 46109 | 19 | 0 |
159584 | 159584 | 2020-05-19 | Roberts | South Dakota | 46109 | 20 | 0 |
162611 | 162611 | 2020-05-20 | Roberts | South Dakota | 46109 | 20 | 0 |
165640 | 165640 | 2020-05-21 | Roberts | South Dakota | 46109 | 20 | 0 |
168676 | 168676 | 2020-05-22 | Roberts | South Dakota | 46109 | 22 | 0 |
171715 | 171715 | 2020-05-23 | Roberts | South Dakota | 46109 | 23 | 0 |
174758 | 174758 | 2020-05-24 | Roberts | South Dakota | 46109 | 35 | 0 |
177802 | 177802 | 2020-05-25 | Roberts | South Dakota | 46109 | 35 | 0 |
180845 | 180845 | 2020-05-26 | Roberts | South Dakota | 46109 | 35 | 0 |
183895 | 183895 | 2020-05-27 | Roberts | South Dakota | 46109 | 39 | 0 |
186952 | 186952 | 2020-05-28 | Roberts | South Dakota | 46109 | 39 | 0 |
190016 | 190016 | 2020-05-29 | Roberts | South Dakota | 46109 | 35 | 0 |
193081 | 193081 | 2020-05-30 | Roberts | South Dakota | 46109 | 36 | 0 |
196151 | 196151 | 2020-05-31 | Roberts | South Dakota | 46109 | 36 | 0 |
199224 | 199224 | 2020-06-01 | Roberts | South Dakota | 46109 | 36 | 0 |
202299 | 202299 | 2020-06-02 | Roberts | South Dakota | 46109 | 36 | 0 |
205378 | 205378 | 2020-06-03 | Roberts | South Dakota | 46109 | 36 | 0 |
208460 | 208460 | 2020-06-04 | Roberts | South Dakota | 46109 | 37 | 0 |
211542 | 211542 | 2020-06-05 | Roberts | South Dakota | 46109 | 37 | 0 |
214629 | 214629 | 2020-06-06 | Roberts | South Dakota | 46109 | 38 | 0 |
217719 | 217719 | 2020-06-07 | Roberts | South Dakota | 46109 | 38 | 0 |
220811 | 220811 | 2020-06-08 | Roberts | South Dakota | 46109 | 38 | 0 |
223906 | 223906 | 2020-06-09 | Roberts | South Dakota | 46109 | 39 | 0 |
227006 | 227006 | 2020-06-10 | Roberts | South Dakota | 46109 | 39 | 0 |
230110 | 230110 | 2020-06-11 | Roberts | South Dakota | 46109 | 39 | 0 |
233215 | 233215 | 2020-06-12 | Roberts | South Dakota | 46109 | 40 | 0 |
236321 | 236321 | 2020-06-13 | Roberts | South Dakota | 46109 | 40 | 0 |
239429 | 239429 | 2020-06-14 | Roberts | South Dakota | 46109 | 40 | 0 |
242539 | 242539 | 2020-06-15 | Roberts | South Dakota | 46109 | 40 | 0 |
245651 | 245651 | 2020-06-16 | Roberts | South Dakota | 46109 | 40 | 0 |
248764 | 248764 | 2020-06-17 | Roberts | South Dakota | 46109 | 40 | 0 |
251879 | 251879 | 2020-06-18 | Roberts | South Dakota | 46109 | 40 | 0 |
254994 | 254994 | 2020-06-19 | Roberts | South Dakota | 46109 | 40 | 0 |
258120 | 258120 | 2020-06-20 | Roberts | South Dakota | 46109 | 40 | 0 |
261247 | 261247 | 2020-06-21 | Roberts | South Dakota | 46109 | 40 | 0 |
264375 | 264375 | 2020-06-22 | Roberts | South Dakota | 46109 | 40 | 0 |
267503 | 267503 | 2020-06-23 | Roberts | South Dakota | 46109 | 40 | 0 |
270637 | 270637 | 2020-06-24 | Roberts | South Dakota | 46109 | 40 | 0 |
273776 | 273776 | 2020-06-25 | Roberts | South Dakota | 46109 | 40 | 0 |
276923 | 276923 | 2020-06-26 | Roberts | South Dakota | 46109 | 40 | 0 |
280071 | 280071 | 2020-06-27 | Roberts | South Dakota | 46109 | 40 | 0 |
283217 | 283217 | 2020-06-28 | Roberts | South Dakota | 46109 | 41 | 0 |
286362 | 286362 | 2020-06-29 | Roberts | South Dakota | 46109 | 45 | 0 |
289513 | 289513 | 2020-06-30 | Roberts | South Dakota | 46109 | 47 | 0 |
292665 | 292665 | 2020-07-01 | Roberts | South Dakota | 46109 | 47 | 0 |
295821 | 295821 | 2020-07-02 | Roberts | South Dakota | 46109 | 47 | 0 |
298981 | 298981 | 2020-07-03 | Roberts | South Dakota | 46109 | 49 | 0 |
302145 | 302145 | 2020-07-04 | Roberts | South Dakota | 46109 | 49 | 0 |
305308 | 305308 | 2020-07-05 | Roberts | South Dakota | 46109 | 52 | 0 |
308476 | 308476 | 2020-07-06 | Roberts | South Dakota | 46109 | 52 | 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);