ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Spink" and state = "South Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27898 | 27898 | 2020-04-02 | Spink | South Dakota | 46115 | 1 | 0 |
30233 | 30233 | 2020-04-03 | Spink | South Dakota | 46115 | 1 | 0 |
32624 | 32624 | 2020-04-04 | Spink | South Dakota | 46115 | 2 | 0 |
35060 | 35060 | 2020-04-05 | Spink | South Dakota | 46115 | 3 | 0 |
37535 | 37535 | 2020-04-06 | Spink | South Dakota | 46115 | 3 | 0 |
40058 | 40058 | 2020-04-07 | Spink | South Dakota | 46115 | 3 | 0 |
42619 | 42619 | 2020-04-08 | Spink | South Dakota | 46115 | 3 | 0 |
45207 | 45207 | 2020-04-09 | Spink | South Dakota | 46115 | 3 | 0 |
47825 | 47825 | 2020-04-10 | Spink | South Dakota | 46115 | 3 | 0 |
50483 | 50483 | 2020-04-11 | Spink | South Dakota | 46115 | 3 | 0 |
53156 | 53156 | 2020-04-12 | Spink | South Dakota | 46115 | 3 | 0 |
55842 | 55842 | 2020-04-13 | Spink | South Dakota | 46115 | 3 | 0 |
58545 | 58545 | 2020-04-14 | Spink | South Dakota | 46115 | 3 | 0 |
61260 | 61260 | 2020-04-15 | Spink | South Dakota | 46115 | 3 | 0 |
63987 | 63987 | 2020-04-16 | Spink | South Dakota | 46115 | 3 | 0 |
66733 | 66733 | 2020-04-17 | Spink | South Dakota | 46115 | 3 | 0 |
69491 | 69491 | 2020-04-18 | Spink | South Dakota | 46115 | 3 | 0 |
72258 | 72258 | 2020-04-19 | Spink | South Dakota | 46115 | 3 | 0 |
75033 | 75033 | 2020-04-20 | Spink | South Dakota | 46115 | 3 | 0 |
77815 | 77815 | 2020-04-21 | Spink | South Dakota | 46115 | 3 | 0 |
80605 | 80605 | 2020-04-22 | Spink | South Dakota | 46115 | 3 | 0 |
83404 | 83404 | 2020-04-23 | Spink | South Dakota | 46115 | 3 | 0 |
86208 | 86208 | 2020-04-24 | Spink | South Dakota | 46115 | 3 | 0 |
89023 | 89023 | 2020-04-25 | Spink | South Dakota | 46115 | 3 | 0 |
91840 | 91840 | 2020-04-26 | Spink | South Dakota | 46115 | 3 | 0 |
94668 | 94668 | 2020-04-27 | Spink | South Dakota | 46115 | 3 | 0 |
97508 | 97508 | 2020-04-28 | Spink | South Dakota | 46115 | 3 | 0 |
100358 | 100358 | 2020-04-29 | Spink | South Dakota | 46115 | 3 | 0 |
103211 | 103211 | 2020-04-30 | Spink | South Dakota | 46115 | 3 | 0 |
106074 | 106074 | 2020-05-01 | Spink | South Dakota | 46115 | 3 | 0 |
108941 | 108941 | 2020-05-02 | Spink | South Dakota | 46115 | 3 | 0 |
111815 | 111815 | 2020-05-03 | Spink | South Dakota | 46115 | 3 | 0 |
114697 | 114697 | 2020-05-04 | Spink | South Dakota | 46115 | 3 | 0 |
117653 | 117653 | 2020-05-05 | Spink | South Dakota | 46115 | 3 | 0 |
120616 | 120616 | 2020-05-06 | Spink | South Dakota | 46115 | 3 | 0 |
123594 | 123594 | 2020-05-07 | Spink | South Dakota | 46115 | 3 | 0 |
126577 | 126577 | 2020-05-08 | Spink | South Dakota | 46115 | 3 | 0 |
129566 | 129566 | 2020-05-09 | Spink | South Dakota | 46115 | 4 | 0 |
132555 | 132555 | 2020-05-10 | Spink | South Dakota | 46115 | 4 | 0 |
135546 | 135546 | 2020-05-11 | Spink | South Dakota | 46115 | 4 | 0 |
138536 | 138536 | 2020-05-12 | Spink | South Dakota | 46115 | 4 | 0 |
141532 | 141532 | 2020-05-13 | Spink | South Dakota | 46115 | 4 | 0 |
144528 | 144528 | 2020-05-14 | Spink | South Dakota | 46115 | 4 | 0 |
147529 | 147529 | 2020-05-15 | Spink | South Dakota | 46115 | 4 | 0 |
150537 | 150537 | 2020-05-16 | Spink | South Dakota | 46115 | 4 | 0 |
153548 | 153548 | 2020-05-17 | Spink | South Dakota | 46115 | 4 | 0 |
156565 | 156565 | 2020-05-18 | Spink | South Dakota | 46115 | 4 | 0 |
159586 | 159586 | 2020-05-19 | Spink | South Dakota | 46115 | 4 | 0 |
162613 | 162613 | 2020-05-20 | Spink | South Dakota | 46115 | 4 | 0 |
165642 | 165642 | 2020-05-21 | Spink | South Dakota | 46115 | 4 | 0 |
168678 | 168678 | 2020-05-22 | Spink | South Dakota | 46115 | 4 | 0 |
171717 | 171717 | 2020-05-23 | Spink | South Dakota | 46115 | 4 | 0 |
174760 | 174760 | 2020-05-24 | Spink | South Dakota | 46115 | 4 | 0 |
177804 | 177804 | 2020-05-25 | Spink | South Dakota | 46115 | 4 | 0 |
180847 | 180847 | 2020-05-26 | Spink | South Dakota | 46115 | 4 | 0 |
183897 | 183897 | 2020-05-27 | Spink | South Dakota | 46115 | 4 | 0 |
186954 | 186954 | 2020-05-28 | Spink | South Dakota | 46115 | 4 | 0 |
190018 | 190018 | 2020-05-29 | Spink | South Dakota | 46115 | 5 | 0 |
193083 | 193083 | 2020-05-30 | Spink | South Dakota | 46115 | 5 | 0 |
196153 | 196153 | 2020-05-31 | Spink | South Dakota | 46115 | 5 | 0 |
199226 | 199226 | 2020-06-01 | Spink | South Dakota | 46115 | 5 | 0 |
202301 | 202301 | 2020-06-02 | Spink | South Dakota | 46115 | 5 | 0 |
205380 | 205380 | 2020-06-03 | Spink | South Dakota | 46115 | 5 | 0 |
208462 | 208462 | 2020-06-04 | Spink | South Dakota | 46115 | 5 | 0 |
211544 | 211544 | 2020-06-05 | Spink | South Dakota | 46115 | 5 | 0 |
214631 | 214631 | 2020-06-06 | Spink | South Dakota | 46115 | 5 | 0 |
217721 | 217721 | 2020-06-07 | Spink | South Dakota | 46115 | 5 | 0 |
220813 | 220813 | 2020-06-08 | Spink | South Dakota | 46115 | 5 | 0 |
223908 | 223908 | 2020-06-09 | Spink | South Dakota | 46115 | 5 | 0 |
227008 | 227008 | 2020-06-10 | Spink | South Dakota | 46115 | 5 | 0 |
230112 | 230112 | 2020-06-11 | Spink | South Dakota | 46115 | 5 | 0 |
233217 | 233217 | 2020-06-12 | Spink | South Dakota | 46115 | 5 | 0 |
236323 | 236323 | 2020-06-13 | Spink | South Dakota | 46115 | 5 | 0 |
239431 | 239431 | 2020-06-14 | Spink | South Dakota | 46115 | 5 | 0 |
242541 | 242541 | 2020-06-15 | Spink | South Dakota | 46115 | 5 | 0 |
245653 | 245653 | 2020-06-16 | Spink | South Dakota | 46115 | 5 | 0 |
248766 | 248766 | 2020-06-17 | Spink | South Dakota | 46115 | 5 | 0 |
251881 | 251881 | 2020-06-18 | Spink | South Dakota | 46115 | 5 | 0 |
254996 | 254996 | 2020-06-19 | Spink | South Dakota | 46115 | 6 | 0 |
258122 | 258122 | 2020-06-20 | Spink | South Dakota | 46115 | 6 | 0 |
261249 | 261249 | 2020-06-21 | Spink | South Dakota | 46115 | 7 | 0 |
264377 | 264377 | 2020-06-22 | Spink | South Dakota | 46115 | 8 | 0 |
267505 | 267505 | 2020-06-23 | Spink | South Dakota | 46115 | 8 | 0 |
270639 | 270639 | 2020-06-24 | Spink | South Dakota | 46115 | 9 | 0 |
273778 | 273778 | 2020-06-25 | Spink | South Dakota | 46115 | 10 | 0 |
276925 | 276925 | 2020-06-26 | Spink | South Dakota | 46115 | 11 | 0 |
280073 | 280073 | 2020-06-27 | Spink | South Dakota | 46115 | 11 | 0 |
283219 | 283219 | 2020-06-28 | Spink | South Dakota | 46115 | 11 | 0 |
286364 | 286364 | 2020-06-29 | Spink | South Dakota | 46115 | 11 | 0 |
289515 | 289515 | 2020-06-30 | Spink | South Dakota | 46115 | 11 | 0 |
292667 | 292667 | 2020-07-01 | Spink | South Dakota | 46115 | 11 | 0 |
295823 | 295823 | 2020-07-02 | Spink | South Dakota | 46115 | 11 | 0 |
298983 | 298983 | 2020-07-03 | Spink | South Dakota | 46115 | 12 | 0 |
302147 | 302147 | 2020-07-04 | Spink | South Dakota | 46115 | 12 | 0 |
305310 | 305310 | 2020-07-05 | Spink | South Dakota | 46115 | 12 | 0 |
308478 | 308478 | 2020-07-06 | Spink | South Dakota | 46115 | 12 | 0 |
311647 | 311647 | 2020-07-07 | Spink | South Dakota | 46115 | 12 | 0 |
314821 | 314821 | 2020-07-08 | Spink | South Dakota | 46115 | 12 | 0 |
317994 | 317994 | 2020-07-09 | Spink | South Dakota | 46115 | 12 | 0 |
321172 | 321172 | 2020-07-10 | Spink | South Dakota | 46115 | 12 | 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);