ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 46013 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 |
---|---|---|---|---|---|---|---|
637349 | 637349 | 2020-10-16 | Brown | South Dakota | 46013 | 1685 | 4 |
634103 | 634103 | 2020-10-15 | Brown | South Dakota | 46013 | 1650 | 4 |
630858 | 630858 | 2020-10-14 | Brown | South Dakota | 46013 | 1626 | 4 |
627614 | 627614 | 2020-10-13 | Brown | South Dakota | 46013 | 1593 | 4 |
624372 | 624372 | 2020-10-12 | Brown | South Dakota | 46013 | 1575 | 4 |
621129 | 621129 | 2020-10-11 | Brown | South Dakota | 46013 | 1555 | 4 |
617886 | 617886 | 2020-10-10 | Brown | South Dakota | 46013 | 1534 | 4 |
614644 | 614644 | 2020-10-09 | Brown | South Dakota | 46013 | 1488 | 4 |
611403 | 611403 | 2020-10-08 | Brown | South Dakota | 46013 | 1427 | 4 |
608161 | 608161 | 2020-10-07 | Brown | South Dakota | 46013 | 1415 | 4 |
604918 | 604918 | 2020-10-06 | Brown | South Dakota | 46013 | 1380 | 4 |
601676 | 601676 | 2020-10-05 | Brown | South Dakota | 46013 | 1363 | 4 |
598433 | 598433 | 2020-10-04 | Brown | South Dakota | 46013 | 1356 | 4 |
595190 | 595190 | 2020-10-03 | Brown | South Dakota | 46013 | 1326 | 4 |
591949 | 591949 | 2020-10-02 | Brown | South Dakota | 46013 | 1292 | 4 |
588708 | 588708 | 2020-10-01 | Brown | South Dakota | 46013 | 1275 | 4 |
585468 | 585468 | 2020-09-30 | Brown | South Dakota | 46013 | 1240 | 4 |
582228 | 582228 | 2020-09-29 | Brown | South Dakota | 46013 | 1223 | 4 |
578988 | 578988 | 2020-09-28 | Brown | South Dakota | 46013 | 1205 | 4 |
575747 | 575747 | 2020-09-27 | Brown | South Dakota | 46013 | 1189 | 4 |
572503 | 572503 | 2020-09-26 | Brown | South Dakota | 46013 | 1160 | 4 |
569261 | 569261 | 2020-09-25 | Brown | South Dakota | 46013 | 1124 | 4 |
566020 | 566020 | 2020-09-24 | Brown | South Dakota | 46013 | 1102 | 4 |
562779 | 562779 | 2020-09-23 | Brown | South Dakota | 46013 | 1067 | 3 |
559542 | 559542 | 2020-09-22 | Brown | South Dakota | 46013 | 1052 | 3 |
556305 | 556305 | 2020-09-21 | Brown | South Dakota | 46013 | 1031 | 3 |
553068 | 553068 | 2020-09-20 | Brown | South Dakota | 46013 | 1027 | 3 |
549829 | 549829 | 2020-09-19 | Brown | South Dakota | 46013 | 1017 | 3 |
546590 | 546590 | 2020-09-18 | Brown | South Dakota | 46013 | 1001 | 3 |
543353 | 543353 | 2020-09-17 | Brown | South Dakota | 46013 | 979 | 3 |
540117 | 540117 | 2020-09-16 | Brown | South Dakota | 46013 | 959 | 3 |
536880 | 536880 | 2020-09-15 | Brown | South Dakota | 46013 | 946 | 3 |
533644 | 533644 | 2020-09-14 | Brown | South Dakota | 46013 | 931 | 3 |
530409 | 530409 | 2020-09-13 | Brown | South Dakota | 46013 | 921 | 3 |
527172 | 527172 | 2020-09-12 | Brown | South Dakota | 46013 | 905 | 3 |
523936 | 523936 | 2020-09-11 | Brown | South Dakota | 46013 | 889 | 3 |
520700 | 520700 | 2020-09-10 | Brown | South Dakota | 46013 | 871 | 3 |
517464 | 517464 | 2020-09-09 | Brown | South Dakota | 46013 | 848 | 3 |
514229 | 514229 | 2020-09-08 | Brown | South Dakota | 46013 | 838 | 3 |
510996 | 510996 | 2020-09-07 | Brown | South Dakota | 46013 | 829 | 3 |
507763 | 507763 | 2020-09-06 | Brown | South Dakota | 46013 | 792 | 3 |
504531 | 504531 | 2020-09-05 | Brown | South Dakota | 46013 | 774 | 3 |
501297 | 501297 | 2020-09-04 | Brown | South Dakota | 46013 | 742 | 3 |
498063 | 498063 | 2020-09-03 | Brown | South Dakota | 46013 | 718 | 3 |
494830 | 494830 | 2020-09-02 | Brown | South Dakota | 46013 | 696 | 3 |
491596 | 491596 | 2020-09-01 | Brown | South Dakota | 46013 | 695 | 3 |
488363 | 488363 | 2020-08-31 | Brown | South Dakota | 46013 | 675 | 3 |
485130 | 485130 | 2020-08-30 | Brown | South Dakota | 46013 | 662 | 3 |
481895 | 481895 | 2020-08-29 | Brown | South Dakota | 46013 | 641 | 3 |
478661 | 478661 | 2020-08-28 | Brown | South Dakota | 46013 | 618 | 3 |
475428 | 475428 | 2020-08-27 | Brown | South Dakota | 46013 | 604 | 3 |
472194 | 472194 | 2020-08-26 | Brown | South Dakota | 46013 | 562 | 3 |
468962 | 468962 | 2020-08-25 | Brown | South Dakota | 46013 | 561 | 3 |
465734 | 465734 | 2020-08-24 | Brown | South Dakota | 46013 | 555 | 3 |
462505 | 462505 | 2020-08-23 | Brown | South Dakota | 46013 | 549 | 3 |
459277 | 459277 | 2020-08-22 | Brown | South Dakota | 46013 | 537 | 3 |
456049 | 456049 | 2020-08-21 | Brown | South Dakota | 46013 | 521 | 3 |
452821 | 452821 | 2020-08-20 | Brown | South Dakota | 46013 | 503 | 3 |
449593 | 449593 | 2020-08-19 | Brown | South Dakota | 46013 | 496 | 3 |
446365 | 446365 | 2020-08-18 | Brown | South Dakota | 46013 | 491 | 3 |
443139 | 443139 | 2020-08-17 | Brown | South Dakota | 46013 | 485 | 3 |
439912 | 439912 | 2020-08-16 | Brown | South Dakota | 46013 | 473 | 3 |
436687 | 436687 | 2020-08-15 | Brown | South Dakota | 46013 | 466 | 3 |
433460 | 433460 | 2020-08-14 | Brown | South Dakota | 46013 | 463 | 3 |
430235 | 430235 | 2020-08-13 | Brown | South Dakota | 46013 | 456 | 3 |
427009 | 427009 | 2020-08-12 | Brown | South Dakota | 46013 | 452 | 3 |
423786 | 423786 | 2020-08-11 | Brown | South Dakota | 46013 | 451 | 3 |
420564 | 420564 | 2020-08-10 | Brown | South Dakota | 46013 | 446 | 3 |
417343 | 417343 | 2020-08-09 | Brown | South Dakota | 46013 | 442 | 3 |
414122 | 414122 | 2020-08-08 | Brown | South Dakota | 46013 | 436 | 3 |
410902 | 410902 | 2020-08-07 | Brown | South Dakota | 46013 | 428 | 3 |
407683 | 407683 | 2020-08-06 | Brown | South Dakota | 46013 | 422 | 3 |
404463 | 404463 | 2020-08-05 | Brown | South Dakota | 46013 | 419 | 3 |
401245 | 401245 | 2020-08-04 | Brown | South Dakota | 46013 | 412 | 3 |
398030 | 398030 | 2020-08-03 | Brown | South Dakota | 46013 | 410 | 3 |
394813 | 394813 | 2020-08-02 | Brown | South Dakota | 46013 | 407 | 3 |
391597 | 391597 | 2020-08-01 | Brown | South Dakota | 46013 | 406 | 3 |
388380 | 388380 | 2020-07-31 | Brown | South Dakota | 46013 | 397 | 3 |
385163 | 385163 | 2020-07-30 | Brown | South Dakota | 46013 | 395 | 3 |
381945 | 381945 | 2020-07-29 | Brown | South Dakota | 46013 | 390 | 3 |
378728 | 378728 | 2020-07-28 | Brown | South Dakota | 46013 | 385 | 2 |
375512 | 375512 | 2020-07-27 | Brown | South Dakota | 46013 | 379 | 2 |
372299 | 372299 | 2020-07-26 | Brown | South Dakota | 46013 | 379 | 2 |
369087 | 369087 | 2020-07-25 | Brown | South Dakota | 46013 | 374 | 2 |
365878 | 365878 | 2020-07-24 | Brown | South Dakota | 46013 | 373 | 2 |
362672 | 362672 | 2020-07-23 | Brown | South Dakota | 46013 | 371 | 2 |
359466 | 359466 | 2020-07-22 | Brown | South Dakota | 46013 | 369 | 2 |
356262 | 356262 | 2020-07-21 | Brown | South Dakota | 46013 | 368 | 2 |
353059 | 353059 | 2020-07-20 | Brown | South Dakota | 46013 | 366 | 2 |
349856 | 349856 | 2020-07-19 | Brown | South Dakota | 46013 | 366 | 2 |
346656 | 346656 | 2020-07-18 | Brown | South Dakota | 46013 | 366 | 2 |
343456 | 343456 | 2020-07-17 | Brown | South Dakota | 46013 | 365 | 2 |
340258 | 340258 | 2020-07-16 | Brown | South Dakota | 46013 | 363 | 2 |
337061 | 337061 | 2020-07-15 | Brown | South Dakota | 46013 | 362 | 2 |
333867 | 333867 | 2020-07-14 | Brown | South Dakota | 46013 | 361 | 2 |
330675 | 330675 | 2020-07-13 | Brown | South Dakota | 46013 | 359 | 2 |
327489 | 327489 | 2020-07-12 | Brown | South Dakota | 46013 | 358 | 2 |
324304 | 324304 | 2020-07-11 | Brown | South Dakota | 46013 | 356 | 2 |
321124 | 321124 | 2020-07-10 | Brown | South Dakota | 46013 | 354 | 2 |
317946 | 317946 | 2020-07-09 | Brown | South Dakota | 46013 | 352 | 2 |
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);