ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where fips = 46045 and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
189991 | 189991 | 2020-05-29 | Edmunds | South Dakota | 46045 | 1 | 0 |
193056 | 193056 | 2020-05-30 | Edmunds | South Dakota | 46045 | 1 | 0 |
196125 | 196125 | 2020-05-31 | Edmunds | South Dakota | 46045 | 1 | 0 |
199198 | 199198 | 2020-06-01 | Edmunds | South Dakota | 46045 | 1 | 0 |
202273 | 202273 | 2020-06-02 | Edmunds | South Dakota | 46045 | 1 | 0 |
205351 | 205351 | 2020-06-03 | Edmunds | South Dakota | 46045 | 3 | 0 |
208433 | 208433 | 2020-06-04 | Edmunds | South Dakota | 46045 | 3 | 0 |
211515 | 211515 | 2020-06-05 | Edmunds | South Dakota | 46045 | 3 | 0 |
214602 | 214602 | 2020-06-06 | Edmunds | South Dakota | 46045 | 3 | 0 |
217692 | 217692 | 2020-06-07 | Edmunds | South Dakota | 46045 | 3 | 0 |
220784 | 220784 | 2020-06-08 | Edmunds | South Dakota | 46045 | 4 | 0 |
223879 | 223879 | 2020-06-09 | Edmunds | South Dakota | 46045 | 4 | 0 |
226979 | 226979 | 2020-06-10 | Edmunds | South Dakota | 46045 | 4 | 0 |
230083 | 230083 | 2020-06-11 | Edmunds | South Dakota | 46045 | 4 | 0 |
233188 | 233188 | 2020-06-12 | Edmunds | South Dakota | 46045 | 4 | 0 |
236293 | 236293 | 2020-06-13 | Edmunds | South Dakota | 46045 | 4 | 0 |
239401 | 239401 | 2020-06-14 | Edmunds | South Dakota | 46045 | 4 | 0 |
242511 | 242511 | 2020-06-15 | Edmunds | South Dakota | 46045 | 4 | 0 |
245623 | 245623 | 2020-06-16 | Edmunds | South Dakota | 46045 | 4 | 0 |
248736 | 248736 | 2020-06-17 | Edmunds | South Dakota | 46045 | 4 | 0 |
251851 | 251851 | 2020-06-18 | Edmunds | South Dakota | 46045 | 4 | 0 |
254966 | 254966 | 2020-06-19 | Edmunds | South Dakota | 46045 | 4 | 0 |
258092 | 258092 | 2020-06-20 | Edmunds | South Dakota | 46045 | 4 | 0 |
261219 | 261219 | 2020-06-21 | Edmunds | South Dakota | 46045 | 5 | 0 |
264347 | 264347 | 2020-06-22 | Edmunds | South Dakota | 46045 | 5 | 0 |
267475 | 267475 | 2020-06-23 | Edmunds | South Dakota | 46045 | 6 | 0 |
270609 | 270609 | 2020-06-24 | Edmunds | South Dakota | 46045 | 6 | 0 |
273748 | 273748 | 2020-06-25 | Edmunds | South Dakota | 46045 | 6 | 0 |
276895 | 276895 | 2020-06-26 | Edmunds | South Dakota | 46045 | 6 | 0 |
280043 | 280043 | 2020-06-27 | Edmunds | South Dakota | 46045 | 7 | 0 |
283189 | 283189 | 2020-06-28 | Edmunds | South Dakota | 46045 | 7 | 0 |
286334 | 286334 | 2020-06-29 | Edmunds | South Dakota | 46045 | 7 | 0 |
289485 | 289485 | 2020-06-30 | Edmunds | South Dakota | 46045 | 7 | 0 |
292637 | 292637 | 2020-07-01 | Edmunds | South Dakota | 46045 | 7 | 0 |
295793 | 295793 | 2020-07-02 | Edmunds | South Dakota | 46045 | 7 | 0 |
298953 | 298953 | 2020-07-03 | Edmunds | South Dakota | 46045 | 7 | 0 |
302117 | 302117 | 2020-07-04 | Edmunds | South Dakota | 46045 | 8 | 0 |
305280 | 305280 | 2020-07-05 | Edmunds | South Dakota | 46045 | 8 | 0 |
308447 | 308447 | 2020-07-06 | Edmunds | South Dakota | 46045 | 8 | 0 |
311616 | 311616 | 2020-07-07 | Edmunds | South Dakota | 46045 | 8 | 0 |
314789 | 314789 | 2020-07-08 | Edmunds | South Dakota | 46045 | 8 | 0 |
317962 | 317962 | 2020-07-09 | Edmunds | South Dakota | 46045 | 8 | 0 |
321140 | 321140 | 2020-07-10 | Edmunds | South Dakota | 46045 | 8 | 0 |
324320 | 324320 | 2020-07-11 | Edmunds | South Dakota | 46045 | 8 | 0 |
327505 | 327505 | 2020-07-12 | Edmunds | South Dakota | 46045 | 8 | 0 |
330691 | 330691 | 2020-07-13 | Edmunds | South Dakota | 46045 | 8 | 0 |
333883 | 333883 | 2020-07-14 | Edmunds | South Dakota | 46045 | 9 | 0 |
337077 | 337077 | 2020-07-15 | Edmunds | South Dakota | 46045 | 9 | 0 |
340274 | 340274 | 2020-07-16 | Edmunds | South Dakota | 46045 | 9 | 0 |
343472 | 343472 | 2020-07-17 | Edmunds | South Dakota | 46045 | 9 | 0 |
346672 | 346672 | 2020-07-18 | Edmunds | South Dakota | 46045 | 10 | 0 |
349872 | 349872 | 2020-07-19 | Edmunds | South Dakota | 46045 | 10 | 0 |
353075 | 353075 | 2020-07-20 | Edmunds | South Dakota | 46045 | 10 | 0 |
356278 | 356278 | 2020-07-21 | Edmunds | South Dakota | 46045 | 10 | 0 |
359482 | 359482 | 2020-07-22 | Edmunds | South Dakota | 46045 | 10 | 0 |
362688 | 362688 | 2020-07-23 | Edmunds | South Dakota | 46045 | 10 | 0 |
365894 | 365894 | 2020-07-24 | Edmunds | South Dakota | 46045 | 10 | 0 |
369103 | 369103 | 2020-07-25 | Edmunds | South Dakota | 46045 | 10 | 0 |
372315 | 372315 | 2020-07-26 | Edmunds | South Dakota | 46045 | 10 | 0 |
375528 | 375528 | 2020-07-27 | Edmunds | South Dakota | 46045 | 10 | 0 |
378744 | 378744 | 2020-07-28 | Edmunds | South Dakota | 46045 | 10 | 0 |
381961 | 381961 | 2020-07-29 | Edmunds | South Dakota | 46045 | 10 | 0 |
385179 | 385179 | 2020-07-30 | Edmunds | South Dakota | 46045 | 10 | 0 |
388396 | 388396 | 2020-07-31 | Edmunds | South Dakota | 46045 | 13 | 0 |
391613 | 391613 | 2020-08-01 | Edmunds | South Dakota | 46045 | 13 | 0 |
394829 | 394829 | 2020-08-02 | Edmunds | South Dakota | 46045 | 13 | 0 |
398046 | 398046 | 2020-08-03 | Edmunds | South Dakota | 46045 | 13 | 0 |
401261 | 401261 | 2020-08-04 | Edmunds | South Dakota | 46045 | 13 | 0 |
404479 | 404479 | 2020-08-05 | Edmunds | South Dakota | 46045 | 13 | 0 |
407699 | 407699 | 2020-08-06 | Edmunds | South Dakota | 46045 | 13 | 0 |
410918 | 410918 | 2020-08-07 | Edmunds | South Dakota | 46045 | 14 | 0 |
414138 | 414138 | 2020-08-08 | Edmunds | South Dakota | 46045 | 14 | 0 |
417359 | 417359 | 2020-08-09 | Edmunds | South Dakota | 46045 | 15 | 0 |
420580 | 420580 | 2020-08-10 | Edmunds | South Dakota | 46045 | 16 | 0 |
423802 | 423802 | 2020-08-11 | Edmunds | South Dakota | 46045 | 17 | 0 |
427025 | 427025 | 2020-08-12 | Edmunds | South Dakota | 46045 | 18 | 0 |
430251 | 430251 | 2020-08-13 | Edmunds | South Dakota | 46045 | 18 | 0 |
433476 | 433476 | 2020-08-14 | Edmunds | South Dakota | 46045 | 19 | 0 |
436703 | 436703 | 2020-08-15 | Edmunds | South Dakota | 46045 | 19 | 0 |
439928 | 439928 | 2020-08-16 | Edmunds | South Dakota | 46045 | 19 | 0 |
443155 | 443155 | 2020-08-17 | Edmunds | South Dakota | 46045 | 19 | 0 |
446381 | 446381 | 2020-08-18 | Edmunds | South Dakota | 46045 | 21 | 0 |
449609 | 449609 | 2020-08-19 | Edmunds | South Dakota | 46045 | 21 | 0 |
452837 | 452837 | 2020-08-20 | Edmunds | South Dakota | 46045 | 22 | 0 |
456065 | 456065 | 2020-08-21 | Edmunds | South Dakota | 46045 | 22 | 0 |
459293 | 459293 | 2020-08-22 | Edmunds | South Dakota | 46045 | 25 | 0 |
462521 | 462521 | 2020-08-23 | Edmunds | South Dakota | 46045 | 25 | 0 |
465750 | 465750 | 2020-08-24 | Edmunds | South Dakota | 46045 | 25 | 0 |
468978 | 468978 | 2020-08-25 | Edmunds | South Dakota | 46045 | 25 | 0 |
472210 | 472210 | 2020-08-26 | Edmunds | South Dakota | 46045 | 26 | 0 |
475444 | 475444 | 2020-08-27 | Edmunds | South Dakota | 46045 | 27 | 0 |
478677 | 478677 | 2020-08-28 | Edmunds | South Dakota | 46045 | 31 | 0 |
481911 | 481911 | 2020-08-29 | Edmunds | South Dakota | 46045 | 31 | 0 |
485146 | 485146 | 2020-08-30 | Edmunds | South Dakota | 46045 | 31 | 0 |
488379 | 488379 | 2020-08-31 | Edmunds | South Dakota | 46045 | 31 | 0 |
491612 | 491612 | 2020-09-01 | Edmunds | South Dakota | 46045 | 31 | 0 |
494846 | 494846 | 2020-09-02 | Edmunds | South Dakota | 46045 | 32 | 0 |
498079 | 498079 | 2020-09-03 | Edmunds | South Dakota | 46045 | 34 | 0 |
501313 | 501313 | 2020-09-04 | Edmunds | South Dakota | 46045 | 34 | 0 |
504547 | 504547 | 2020-09-05 | Edmunds | South Dakota | 46045 | 34 | 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);