ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 46029 and state = "South Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
292629 | 292629 | 2020-07-01 | Codington | South Dakota | 46029 | 70 | 0 |
295785 | 295785 | 2020-07-02 | Codington | South Dakota | 46029 | 72 | 0 |
298945 | 298945 | 2020-07-03 | Codington | South Dakota | 46029 | 75 | 0 |
302109 | 302109 | 2020-07-04 | Codington | South Dakota | 46029 | 83 | 0 |
305272 | 305272 | 2020-07-05 | Codington | South Dakota | 46029 | 83 | 0 |
308439 | 308439 | 2020-07-06 | Codington | South Dakota | 46029 | 83 | 0 |
311608 | 311608 | 2020-07-07 | Codington | South Dakota | 46029 | 85 | 0 |
314781 | 314781 | 2020-07-08 | Codington | South Dakota | 46029 | 86 | 0 |
317954 | 317954 | 2020-07-09 | Codington | South Dakota | 46029 | 90 | 0 |
321132 | 321132 | 2020-07-10 | Codington | South Dakota | 46029 | 92 | 0 |
324312 | 324312 | 2020-07-11 | Codington | South Dakota | 46029 | 92 | 0 |
327497 | 327497 | 2020-07-12 | Codington | South Dakota | 46029 | 92 | 0 |
330683 | 330683 | 2020-07-13 | Codington | South Dakota | 46029 | 92 | 0 |
333875 | 333875 | 2020-07-14 | Codington | South Dakota | 46029 | 93 | 0 |
337069 | 337069 | 2020-07-15 | Codington | South Dakota | 46029 | 96 | 0 |
340266 | 340266 | 2020-07-16 | Codington | South Dakota | 46029 | 96 | 0 |
343464 | 343464 | 2020-07-17 | Codington | South Dakota | 46029 | 101 | 0 |
346664 | 346664 | 2020-07-18 | Codington | South Dakota | 46029 | 103 | 0 |
349864 | 349864 | 2020-07-19 | Codington | South Dakota | 46029 | 103 | 0 |
353067 | 353067 | 2020-07-20 | Codington | South Dakota | 46029 | 103 | 0 |
356270 | 356270 | 2020-07-21 | Codington | South Dakota | 46029 | 107 | 0 |
359474 | 359474 | 2020-07-22 | Codington | South Dakota | 46029 | 108 | 0 |
362680 | 362680 | 2020-07-23 | Codington | South Dakota | 46029 | 109 | 0 |
365886 | 365886 | 2020-07-24 | Codington | South Dakota | 46029 | 109 | 0 |
369095 | 369095 | 2020-07-25 | Codington | South Dakota | 46029 | 109 | 0 |
372307 | 372307 | 2020-07-26 | Codington | South Dakota | 46029 | 111 | 0 |
375520 | 375520 | 2020-07-27 | Codington | South Dakota | 46029 | 111 | 0 |
378736 | 378736 | 2020-07-28 | Codington | South Dakota | 46029 | 112 | 0 |
381953 | 381953 | 2020-07-29 | Codington | South Dakota | 46029 | 117 | 0 |
385171 | 385171 | 2020-07-30 | Codington | South Dakota | 46029 | 117 | 0 |
388388 | 388388 | 2020-07-31 | Codington | South Dakota | 46029 | 117 | 0 |
391605 | 391605 | 2020-08-01 | Codington | South Dakota | 46029 | 118 | 0 |
394821 | 394821 | 2020-08-02 | Codington | South Dakota | 46029 | 118 | 0 |
398038 | 398038 | 2020-08-03 | Codington | South Dakota | 46029 | 119 | 0 |
401253 | 401253 | 2020-08-04 | Codington | South Dakota | 46029 | 120 | 1 |
404471 | 404471 | 2020-08-05 | Codington | South Dakota | 46029 | 123 | 1 |
407691 | 407691 | 2020-08-06 | Codington | South Dakota | 46029 | 124 | 1 |
410910 | 410910 | 2020-08-07 | Codington | South Dakota | 46029 | 129 | 1 |
414130 | 414130 | 2020-08-08 | Codington | South Dakota | 46029 | 129 | 1 |
417351 | 417351 | 2020-08-09 | Codington | South Dakota | 46029 | 133 | 1 |
420572 | 420572 | 2020-08-10 | Codington | South Dakota | 46029 | 137 | 1 |
423794 | 423794 | 2020-08-11 | Codington | South Dakota | 46029 | 138 | 1 |
427017 | 427017 | 2020-08-12 | Codington | South Dakota | 46029 | 143 | 1 |
430243 | 430243 | 2020-08-13 | Codington | South Dakota | 46029 | 147 | 1 |
433468 | 433468 | 2020-08-14 | Codington | South Dakota | 46029 | 151 | 1 |
436695 | 436695 | 2020-08-15 | Codington | South Dakota | 46029 | 156 | 1 |
439920 | 439920 | 2020-08-16 | Codington | South Dakota | 46029 | 163 | 1 |
443147 | 443147 | 2020-08-17 | Codington | South Dakota | 46029 | 169 | 1 |
446373 | 446373 | 2020-08-18 | Codington | South Dakota | 46029 | 173 | 1 |
449601 | 449601 | 2020-08-19 | Codington | South Dakota | 46029 | 183 | 1 |
452829 | 452829 | 2020-08-20 | Codington | South Dakota | 46029 | 191 | 1 |
456057 | 456057 | 2020-08-21 | Codington | South Dakota | 46029 | 195 | 1 |
459285 | 459285 | 2020-08-22 | Codington | South Dakota | 46029 | 207 | 1 |
462513 | 462513 | 2020-08-23 | Codington | South Dakota | 46029 | 217 | 1 |
465742 | 465742 | 2020-08-24 | Codington | South Dakota | 46029 | 220 | 1 |
468970 | 468970 | 2020-08-25 | Codington | South Dakota | 46029 | 220 | 1 |
472202 | 472202 | 2020-08-26 | Codington | South Dakota | 46029 | 221 | 1 |
475436 | 475436 | 2020-08-27 | Codington | South Dakota | 46029 | 243 | 1 |
478669 | 478669 | 2020-08-28 | Codington | South Dakota | 46029 | 266 | 1 |
481903 | 481903 | 2020-08-29 | Codington | South Dakota | 46029 | 287 | 2 |
485138 | 485138 | 2020-08-30 | Codington | South Dakota | 46029 | 310 | 2 |
488371 | 488371 | 2020-08-31 | Codington | South Dakota | 46029 | 318 | 2 |
491604 | 491604 | 2020-09-01 | Codington | South Dakota | 46029 | 330 | 2 |
494838 | 494838 | 2020-09-02 | Codington | South Dakota | 46029 | 357 | 2 |
498071 | 498071 | 2020-09-03 | Codington | South Dakota | 46029 | 372 | 2 |
501305 | 501305 | 2020-09-04 | Codington | South Dakota | 46029 | 399 | 2 |
504539 | 504539 | 2020-09-05 | Codington | South Dakota | 46029 | 414 | 2 |
507771 | 507771 | 2020-09-06 | Codington | South Dakota | 46029 | 446 | 2 |
511004 | 511004 | 2020-09-07 | Codington | South Dakota | 46029 | 462 | 2 |
514237 | 514237 | 2020-09-08 | Codington | South Dakota | 46029 | 468 | 2 |
517472 | 517472 | 2020-09-09 | Codington | South Dakota | 46029 | 490 | 2 |
520708 | 520708 | 2020-09-10 | Codington | South Dakota | 46029 | 516 | 2 |
523944 | 523944 | 2020-09-11 | Codington | South Dakota | 46029 | 534 | 2 |
527180 | 527180 | 2020-09-12 | Codington | South Dakota | 46029 | 557 | 2 |
530417 | 530417 | 2020-09-13 | Codington | South Dakota | 46029 | 570 | 2 |
533652 | 533652 | 2020-09-14 | Codington | South Dakota | 46029 | 591 | 2 |
536888 | 536888 | 2020-09-15 | Codington | South Dakota | 46029 | 597 | 2 |
540125 | 540125 | 2020-09-16 | Codington | South Dakota | 46029 | 612 | 2 |
543361 | 543361 | 2020-09-17 | Codington | South Dakota | 46029 | 638 | 2 |
546598 | 546598 | 2020-09-18 | Codington | South Dakota | 46029 | 662 | 2 |
549837 | 549837 | 2020-09-19 | Codington | South Dakota | 46029 | 682 | 3 |
553076 | 553076 | 2020-09-20 | Codington | South Dakota | 46029 | 706 | 3 |
556313 | 556313 | 2020-09-21 | Codington | South Dakota | 46029 | 719 | 3 |
559550 | 559550 | 2020-09-22 | Codington | South Dakota | 46029 | 741 | 3 |
562787 | 562787 | 2020-09-23 | Codington | South Dakota | 46029 | 757 | 3 |
566028 | 566028 | 2020-09-24 | Codington | South Dakota | 46029 | 780 | 3 |
569269 | 569269 | 2020-09-25 | Codington | South Dakota | 46029 | 805 | 3 |
572511 | 572511 | 2020-09-26 | Codington | South Dakota | 46029 | 842 | 4 |
575755 | 575755 | 2020-09-27 | Codington | South Dakota | 46029 | 872 | 4 |
578996 | 578996 | 2020-09-28 | Codington | South Dakota | 46029 | 876 | 4 |
582236 | 582236 | 2020-09-29 | Codington | South Dakota | 46029 | 882 | 6 |
585476 | 585476 | 2020-09-30 | Codington | South Dakota | 46029 | 894 | 6 |
588716 | 588716 | 2020-10-01 | Codington | South Dakota | 46029 | 942 | 7 |
591957 | 591957 | 2020-10-02 | Codington | South Dakota | 46029 | 954 | 7 |
595198 | 595198 | 2020-10-03 | Codington | South Dakota | 46029 | 970 | 7 |
598441 | 598441 | 2020-10-04 | Codington | South Dakota | 46029 | 989 | 7 |
601684 | 601684 | 2020-10-05 | Codington | South Dakota | 46029 | 1001 | 7 |
604926 | 604926 | 2020-10-06 | Codington | South Dakota | 46029 | 1014 | 7 |
608169 | 608169 | 2020-10-07 | Codington | South Dakota | 46029 | 1031 | 9 |
611411 | 611411 | 2020-10-08 | Codington | South Dakota | 46029 | 1053 | 9 |
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);