ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46099 and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
251875 | 251875 | 2020-06-18 | Minnehaha | South Dakota | 46099 | 3513 | 54 |
254990 | 254990 | 2020-06-19 | Minnehaha | South Dakota | 46099 | 3526 | 54 |
258116 | 258116 | 2020-06-20 | Minnehaha | South Dakota | 46099 | 3503 | 54 |
261243 | 261243 | 2020-06-21 | Minnehaha | South Dakota | 46099 | 3523 | 54 |
264371 | 264371 | 2020-06-22 | Minnehaha | South Dakota | 46099 | 3534 | 54 |
267499 | 267499 | 2020-06-23 | Minnehaha | South Dakota | 46099 | 3537 | 55 |
270633 | 270633 | 2020-06-24 | Minnehaha | South Dakota | 46099 | 3550 | 56 |
273772 | 273772 | 2020-06-25 | Minnehaha | South Dakota | 46099 | 3560 | 56 |
276919 | 276919 | 2020-06-26 | Minnehaha | South Dakota | 46099 | 3577 | 56 |
280067 | 280067 | 2020-06-27 | Minnehaha | South Dakota | 46099 | 3586 | 57 |
283213 | 283213 | 2020-06-28 | Minnehaha | South Dakota | 46099 | 3598 | 57 |
286358 | 286358 | 2020-06-29 | Minnehaha | South Dakota | 46099 | 3600 | 57 |
289509 | 289509 | 2020-06-30 | Minnehaha | South Dakota | 46099 | 3610 | 57 |
292661 | 292661 | 2020-07-01 | Minnehaha | South Dakota | 46099 | 3627 | 58 |
295817 | 295817 | 2020-07-02 | Minnehaha | South Dakota | 46099 | 3638 | 58 |
298977 | 298977 | 2020-07-03 | Minnehaha | South Dakota | 46099 | 3655 | 58 |
302141 | 302141 | 2020-07-04 | Minnehaha | South Dakota | 46099 | 3659 | 58 |
305304 | 305304 | 2020-07-05 | Minnehaha | South Dakota | 46099 | 3663 | 58 |
308472 | 308472 | 2020-07-06 | Minnehaha | South Dakota | 46099 | 3667 | 58 |
311641 | 311641 | 2020-07-07 | Minnehaha | South Dakota | 46099 | 3685 | 59 |
314815 | 314815 | 2020-07-08 | Minnehaha | South Dakota | 46099 | 3706 | 59 |
317988 | 317988 | 2020-07-09 | Minnehaha | South Dakota | 46099 | 3723 | 59 |
321166 | 321166 | 2020-07-10 | Minnehaha | South Dakota | 46099 | 3738 | 60 |
324346 | 324346 | 2020-07-11 | Minnehaha | South Dakota | 46099 | 3751 | 60 |
327531 | 327531 | 2020-07-12 | Minnehaha | South Dakota | 46099 | 3756 | 60 |
330717 | 330717 | 2020-07-13 | Minnehaha | South Dakota | 46099 | 3760 | 60 |
333909 | 333909 | 2020-07-14 | Minnehaha | South Dakota | 46099 | 3778 | 60 |
337103 | 337103 | 2020-07-15 | Minnehaha | South Dakota | 46099 | 3796 | 60 |
340300 | 340300 | 2020-07-16 | Minnehaha | South Dakota | 46099 | 3802 | 61 |
343498 | 343498 | 2020-07-17 | Minnehaha | South Dakota | 46099 | 3822 | 61 |
346698 | 346698 | 2020-07-18 | Minnehaha | South Dakota | 46099 | 3846 | 61 |
349898 | 349898 | 2020-07-19 | Minnehaha | South Dakota | 46099 | 3854 | 62 |
353101 | 353101 | 2020-07-20 | Minnehaha | South Dakota | 46099 | 3869 | 62 |
356304 | 356304 | 2020-07-21 | Minnehaha | South Dakota | 46099 | 3889 | 62 |
359508 | 359508 | 2020-07-22 | Minnehaha | South Dakota | 46099 | 3907 | 62 |
362714 | 362714 | 2020-07-23 | Minnehaha | South Dakota | 46099 | 3920 | 62 |
365920 | 365920 | 2020-07-24 | Minnehaha | South Dakota | 46099 | 3941 | 62 |
369129 | 369129 | 2020-07-25 | Minnehaha | South Dakota | 46099 | 3983 | 62 |
372341 | 372341 | 2020-07-26 | Minnehaha | South Dakota | 46099 | 4018 | 62 |
375554 | 375554 | 2020-07-27 | Minnehaha | South Dakota | 46099 | 4036 | 62 |
378770 | 378770 | 2020-07-28 | Minnehaha | South Dakota | 46099 | 4058 | 62 |
381987 | 381987 | 2020-07-29 | Minnehaha | South Dakota | 46099 | 4118 | 63 |
385205 | 385205 | 2020-07-30 | Minnehaha | South Dakota | 46099 | 4133 | 63 |
388422 | 388422 | 2020-07-31 | Minnehaha | South Dakota | 46099 | 4150 | 63 |
391639 | 391639 | 2020-08-01 | Minnehaha | South Dakota | 46099 | 4189 | 63 |
394855 | 394855 | 2020-08-02 | Minnehaha | South Dakota | 46099 | 4223 | 64 |
398072 | 398072 | 2020-08-03 | Minnehaha | South Dakota | 46099 | 4233 | 64 |
401287 | 401287 | 2020-08-04 | Minnehaha | South Dakota | 46099 | 4258 | 64 |
404505 | 404505 | 2020-08-05 | Minnehaha | South Dakota | 46099 | 4285 | 64 |
407725 | 407725 | 2020-08-06 | Minnehaha | South Dakota | 46099 | 4329 | 65 |
410944 | 410944 | 2020-08-07 | Minnehaha | South Dakota | 46099 | 4349 | 67 |
414164 | 414164 | 2020-08-08 | Minnehaha | South Dakota | 46099 | 4376 | 68 |
417385 | 417385 | 2020-08-09 | Minnehaha | South Dakota | 46099 | 4422 | 68 |
420606 | 420606 | 2020-08-10 | Minnehaha | South Dakota | 46099 | 4437 | 68 |
423828 | 423828 | 2020-08-11 | Minnehaha | South Dakota | 46099 | 4457 | 68 |
427051 | 427051 | 2020-08-12 | Minnehaha | South Dakota | 46099 | 4498 | 68 |
430278 | 430278 | 2020-08-13 | Minnehaha | South Dakota | 46099 | 4521 | 68 |
433503 | 433503 | 2020-08-14 | Minnehaha | South Dakota | 46099 | 4561 | 68 |
436730 | 436730 | 2020-08-15 | Minnehaha | South Dakota | 46099 | 4584 | 68 |
439955 | 439955 | 2020-08-16 | Minnehaha | South Dakota | 46099 | 4629 | 68 |
443182 | 443182 | 2020-08-17 | Minnehaha | South Dakota | 46099 | 4655 | 68 |
446408 | 446408 | 2020-08-18 | Minnehaha | South Dakota | 46099 | 4682 | 68 |
449636 | 449636 | 2020-08-19 | Minnehaha | South Dakota | 46099 | 4727 | 69 |
452864 | 452864 | 2020-08-20 | Minnehaha | South Dakota | 46099 | 4757 | 70 |
456092 | 456092 | 2020-08-21 | Minnehaha | South Dakota | 46099 | 4819 | 70 |
459320 | 459320 | 2020-08-22 | Minnehaha | South Dakota | 46099 | 4875 | 70 |
462548 | 462548 | 2020-08-23 | Minnehaha | South Dakota | 46099 | 4896 | 70 |
465777 | 465777 | 2020-08-24 | Minnehaha | South Dakota | 46099 | 4924 | 70 |
469005 | 469005 | 2020-08-25 | Minnehaha | South Dakota | 46099 | 4938 | 70 |
472237 | 472237 | 2020-08-26 | Minnehaha | South Dakota | 46099 | 4954 | 70 |
475471 | 475471 | 2020-08-27 | Minnehaha | South Dakota | 46099 | 5028 | 70 |
478704 | 478704 | 2020-08-28 | Minnehaha | South Dakota | 46099 | 5079 | 70 |
481938 | 481938 | 2020-08-29 | Minnehaha | South Dakota | 46099 | 5178 | 70 |
485173 | 485173 | 2020-08-30 | Minnehaha | South Dakota | 46099 | 5235 | 70 |
488406 | 488406 | 2020-08-31 | Minnehaha | South Dakota | 46099 | 5267 | 70 |
491639 | 491639 | 2020-09-01 | Minnehaha | South Dakota | 46099 | 5340 | 70 |
494873 | 494873 | 2020-09-02 | Minnehaha | South Dakota | 46099 | 5389 | 70 |
498106 | 498106 | 2020-09-03 | Minnehaha | South Dakota | 46099 | 5457 | 70 |
501340 | 501340 | 2020-09-04 | Minnehaha | South Dakota | 46099 | 5496 | 71 |
504574 | 504574 | 2020-09-05 | Minnehaha | South Dakota | 46099 | 5548 | 71 |
507806 | 507806 | 2020-09-06 | Minnehaha | South Dakota | 46099 | 5578 | 71 |
511039 | 511039 | 2020-09-07 | Minnehaha | South Dakota | 46099 | 5601 | 71 |
514272 | 514272 | 2020-09-08 | Minnehaha | South Dakota | 46099 | 5625 | 71 |
517507 | 517507 | 2020-09-09 | Minnehaha | South Dakota | 46099 | 5653 | 71 |
520743 | 520743 | 2020-09-10 | Minnehaha | South Dakota | 46099 | 5689 | 72 |
523979 | 523979 | 2020-09-11 | Minnehaha | South Dakota | 46099 | 5772 | 72 |
527215 | 527215 | 2020-09-12 | Minnehaha | South Dakota | 46099 | 5839 | 74 |
530452 | 530452 | 2020-09-13 | Minnehaha | South Dakota | 46099 | 5874 | 74 |
533687 | 533687 | 2020-09-14 | Minnehaha | South Dakota | 46099 | 5898 | 74 |
536923 | 536923 | 2020-09-15 | Minnehaha | South Dakota | 46099 | 5938 | 74 |
540160 | 540160 | 2020-09-16 | Minnehaha | South Dakota | 46099 | 5992 | 76 |
543396 | 543396 | 2020-09-17 | Minnehaha | South Dakota | 46099 | 6033 | 76 |
546633 | 546633 | 2020-09-18 | Minnehaha | South Dakota | 46099 | 6105 | 76 |
549872 | 549872 | 2020-09-19 | Minnehaha | South Dakota | 46099 | 6170 | 76 |
553111 | 553111 | 2020-09-20 | Minnehaha | South Dakota | 46099 | 6216 | 78 |
556348 | 556348 | 2020-09-21 | Minnehaha | South Dakota | 46099 | 6231 | 78 |
559585 | 559585 | 2020-09-22 | Minnehaha | South Dakota | 46099 | 6293 | 78 |
562822 | 562822 | 2020-09-23 | Minnehaha | South Dakota | 46099 | 6383 | 78 |
566063 | 566063 | 2020-09-24 | Minnehaha | South Dakota | 46099 | 6453 | 80 |
569304 | 569304 | 2020-09-25 | Minnehaha | South Dakota | 46099 | 6508 | 81 |
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);