ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 46003 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 |
---|---|---|---|---|---|---|---|
388375 | 388375 | 2020-07-31 | Aurora | South Dakota | 46003 | 37 | 0 |
385158 | 385158 | 2020-07-30 | Aurora | South Dakota | 46003 | 37 | 0 |
381940 | 381940 | 2020-07-29 | Aurora | South Dakota | 46003 | 37 | 0 |
378723 | 378723 | 2020-07-28 | Aurora | South Dakota | 46003 | 37 | 0 |
375507 | 375507 | 2020-07-27 | Aurora | South Dakota | 46003 | 37 | 0 |
372294 | 372294 | 2020-07-26 | Aurora | South Dakota | 46003 | 37 | 0 |
369082 | 369082 | 2020-07-25 | Aurora | South Dakota | 46003 | 37 | 0 |
365873 | 365873 | 2020-07-24 | Aurora | South Dakota | 46003 | 37 | 0 |
362667 | 362667 | 2020-07-23 | Aurora | South Dakota | 46003 | 36 | 0 |
359461 | 359461 | 2020-07-22 | Aurora | South Dakota | 46003 | 36 | 0 |
356257 | 356257 | 2020-07-21 | Aurora | South Dakota | 46003 | 35 | 0 |
353054 | 353054 | 2020-07-20 | Aurora | South Dakota | 46003 | 35 | 0 |
349851 | 349851 | 2020-07-19 | Aurora | South Dakota | 46003 | 35 | 0 |
346651 | 346651 | 2020-07-18 | Aurora | South Dakota | 46003 | 35 | 0 |
343451 | 343451 | 2020-07-17 | Aurora | South Dakota | 46003 | 35 | 0 |
340253 | 340253 | 2020-07-16 | Aurora | South Dakota | 46003 | 35 | 0 |
337056 | 337056 | 2020-07-15 | Aurora | South Dakota | 46003 | 34 | 0 |
333862 | 333862 | 2020-07-14 | Aurora | South Dakota | 46003 | 34 | 0 |
330670 | 330670 | 2020-07-13 | Aurora | South Dakota | 46003 | 34 | 0 |
327484 | 327484 | 2020-07-12 | Aurora | South Dakota | 46003 | 34 | 0 |
324299 | 324299 | 2020-07-11 | Aurora | South Dakota | 46003 | 34 | 0 |
321119 | 321119 | 2020-07-10 | Aurora | South Dakota | 46003 | 34 | 0 |
317941 | 317941 | 2020-07-09 | Aurora | South Dakota | 46003 | 34 | 0 |
314768 | 314768 | 2020-07-08 | Aurora | South Dakota | 46003 | 34 | 0 |
311596 | 311596 | 2020-07-07 | Aurora | South Dakota | 46003 | 34 | 0 |
308427 | 308427 | 2020-07-06 | Aurora | South Dakota | 46003 | 34 | 0 |
305260 | 305260 | 2020-07-05 | Aurora | South Dakota | 46003 | 34 | 0 |
302097 | 302097 | 2020-07-04 | Aurora | South Dakota | 46003 | 34 | 0 |
298933 | 298933 | 2020-07-03 | Aurora | South Dakota | 46003 | 34 | 0 |
295774 | 295774 | 2020-07-02 | Aurora | South Dakota | 46003 | 34 | 0 |
292618 | 292618 | 2020-07-01 | Aurora | South Dakota | 46003 | 34 | 0 |
289466 | 289466 | 2020-06-30 | Aurora | South Dakota | 46003 | 34 | 0 |
286315 | 286315 | 2020-06-29 | Aurora | South Dakota | 46003 | 34 | 0 |
283170 | 283170 | 2020-06-28 | Aurora | South Dakota | 46003 | 34 | 0 |
280024 | 280024 | 2020-06-27 | Aurora | South Dakota | 46003 | 34 | 0 |
276876 | 276876 | 2020-06-26 | Aurora | South Dakota | 46003 | 34 | 0 |
273729 | 273729 | 2020-06-25 | Aurora | South Dakota | 46003 | 34 | 0 |
270590 | 270590 | 2020-06-24 | Aurora | South Dakota | 46003 | 34 | 0 |
267456 | 267456 | 2020-06-23 | Aurora | South Dakota | 46003 | 34 | 0 |
264328 | 264328 | 2020-06-22 | Aurora | South Dakota | 46003 | 34 | 0 |
261200 | 261200 | 2020-06-21 | Aurora | South Dakota | 46003 | 34 | 0 |
258073 | 258073 | 2020-06-20 | Aurora | South Dakota | 46003 | 34 | 0 |
254947 | 254947 | 2020-06-19 | Aurora | South Dakota | 46003 | 34 | 0 |
251832 | 251832 | 2020-06-18 | Aurora | South Dakota | 46003 | 33 | 0 |
248717 | 248717 | 2020-06-17 | Aurora | South Dakota | 46003 | 33 | 0 |
245604 | 245604 | 2020-06-16 | Aurora | South Dakota | 46003 | 33 | 0 |
242492 | 242492 | 2020-06-15 | Aurora | South Dakota | 46003 | 33 | 0 |
239383 | 239383 | 2020-06-14 | Aurora | South Dakota | 46003 | 33 | 0 |
236275 | 236275 | 2020-06-13 | Aurora | South Dakota | 46003 | 33 | 0 |
233170 | 233170 | 2020-06-12 | Aurora | South Dakota | 46003 | 30 | 0 |
230065 | 230065 | 2020-06-11 | Aurora | South Dakota | 46003 | 29 | 0 |
226961 | 226961 | 2020-06-10 | Aurora | South Dakota | 46003 | 29 | 0 |
223861 | 223861 | 2020-06-09 | Aurora | South Dakota | 46003 | 29 | 0 |
220766 | 220766 | 2020-06-08 | Aurora | South Dakota | 46003 | 29 | 0 |
217674 | 217674 | 2020-06-07 | Aurora | South Dakota | 46003 | 29 | 0 |
214584 | 214584 | 2020-06-06 | Aurora | South Dakota | 46003 | 29 | 0 |
211498 | 211498 | 2020-06-05 | Aurora | South Dakota | 46003 | 27 | 0 |
208416 | 208416 | 2020-06-04 | Aurora | South Dakota | 46003 | 27 | 0 |
205335 | 205335 | 2020-06-03 | Aurora | South Dakota | 46003 | 27 | 0 |
202258 | 202258 | 2020-06-02 | Aurora | South Dakota | 46003 | 26 | 0 |
199183 | 199183 | 2020-06-01 | Aurora | South Dakota | 46003 | 26 | 0 |
196110 | 196110 | 2020-05-31 | Aurora | South Dakota | 46003 | 26 | 0 |
193041 | 193041 | 2020-05-30 | Aurora | South Dakota | 46003 | 25 | 0 |
189976 | 189976 | 2020-05-29 | Aurora | South Dakota | 46003 | 23 | 0 |
186914 | 186914 | 2020-05-28 | Aurora | South Dakota | 46003 | 23 | 0 |
183857 | 183857 | 2020-05-27 | Aurora | South Dakota | 46003 | 22 | 0 |
180807 | 180807 | 2020-05-26 | Aurora | South Dakota | 46003 | 22 | 0 |
177764 | 177764 | 2020-05-25 | Aurora | South Dakota | 46003 | 22 | 0 |
174720 | 174720 | 2020-05-24 | Aurora | South Dakota | 46003 | 22 | 0 |
171678 | 171678 | 2020-05-23 | Aurora | South Dakota | 46003 | 22 | 0 |
168639 | 168639 | 2020-05-22 | Aurora | South Dakota | 46003 | 20 | 0 |
165603 | 165603 | 2020-05-21 | Aurora | South Dakota | 46003 | 8 | 0 |
162574 | 162574 | 2020-05-20 | Aurora | South Dakota | 46003 | 8 | 0 |
159547 | 159547 | 2020-05-19 | Aurora | South Dakota | 46003 | 3 | 0 |
156526 | 156526 | 2020-05-18 | Aurora | South Dakota | 46003 | 3 | 0 |
153509 | 153509 | 2020-05-17 | Aurora | South Dakota | 46003 | 3 | 0 |
150498 | 150498 | 2020-05-16 | Aurora | South Dakota | 46003 | 2 | 0 |
147490 | 147490 | 2020-05-15 | Aurora | South Dakota | 46003 | 2 | 0 |
144489 | 144489 | 2020-05-14 | Aurora | South Dakota | 46003 | 2 | 0 |
141493 | 141493 | 2020-05-13 | Aurora | South Dakota | 46003 | 2 | 0 |
138497 | 138497 | 2020-05-12 | Aurora | South Dakota | 46003 | 2 | 0 |
135507 | 135507 | 2020-05-11 | Aurora | South Dakota | 46003 | 2 | 0 |
132516 | 132516 | 2020-05-10 | Aurora | South Dakota | 46003 | 2 | 0 |
129527 | 129527 | 2020-05-09 | Aurora | South Dakota | 46003 | 1 | 0 |
126538 | 126538 | 2020-05-08 | Aurora | South Dakota | 46003 | 1 | 0 |
123555 | 123555 | 2020-05-07 | Aurora | South Dakota | 46003 | 1 | 0 |
120577 | 120577 | 2020-05-06 | Aurora | South Dakota | 46003 | 1 | 0 |
117615 | 117615 | 2020-05-05 | Aurora | South Dakota | 46003 | 1 | 0 |
114659 | 114659 | 2020-05-04 | Aurora | South Dakota | 46003 | 1 | 0 |
111777 | 111777 | 2020-05-03 | Aurora | South Dakota | 46003 | 1 | 0 |
108903 | 108903 | 2020-05-02 | Aurora | South Dakota | 46003 | 1 | 0 |
106036 | 106036 | 2020-05-01 | Aurora | South Dakota | 46003 | 1 | 0 |
103173 | 103173 | 2020-04-30 | Aurora | South Dakota | 46003 | 1 | 0 |
100320 | 100320 | 2020-04-29 | Aurora | South Dakota | 46003 | 1 | 0 |
97471 | 97471 | 2020-04-28 | Aurora | South Dakota | 46003 | 1 | 0 |
94632 | 94632 | 2020-04-27 | Aurora | South Dakota | 46003 | 1 | 0 |
91805 | 91805 | 2020-04-26 | Aurora | South Dakota | 46003 | 1 | 0 |
88989 | 88989 | 2020-04-25 | Aurora | South Dakota | 46003 | 1 | 0 |
86175 | 86175 | 2020-04-24 | Aurora | South Dakota | 46003 | 1 | 0 |
83371 | 83371 | 2020-04-23 | Aurora | South Dakota | 46003 | 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);