ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 46109 and state = "South Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
311645 | 311645 | 2020-07-07 | Roberts | South Dakota | 46109 | 52 | 0 |
314819 | 314819 | 2020-07-08 | Roberts | South Dakota | 46109 | 52 | 0 |
317992 | 317992 | 2020-07-09 | Roberts | South Dakota | 46109 | 53 | 0 |
321170 | 321170 | 2020-07-10 | Roberts | South Dakota | 46109 | 53 | 0 |
324351 | 324351 | 2020-07-11 | Roberts | South Dakota | 46109 | 56 | 0 |
327536 | 327536 | 2020-07-12 | Roberts | South Dakota | 46109 | 57 | 0 |
330722 | 330722 | 2020-07-13 | Roberts | South Dakota | 46109 | 58 | 0 |
333914 | 333914 | 2020-07-14 | Roberts | South Dakota | 46109 | 58 | 0 |
337108 | 337108 | 2020-07-15 | Roberts | South Dakota | 46109 | 59 | 0 |
340305 | 340305 | 2020-07-16 | Roberts | South Dakota | 46109 | 59 | 0 |
343503 | 343503 | 2020-07-17 | Roberts | South Dakota | 46109 | 59 | 0 |
346703 | 346703 | 2020-07-18 | Roberts | South Dakota | 46109 | 62 | 0 |
349903 | 349903 | 2020-07-19 | Roberts | South Dakota | 46109 | 62 | 0 |
353106 | 353106 | 2020-07-20 | Roberts | South Dakota | 46109 | 62 | 0 |
356309 | 356309 | 2020-07-21 | Roberts | South Dakota | 46109 | 62 | 0 |
359513 | 359513 | 2020-07-22 | Roberts | South Dakota | 46109 | 62 | 0 |
362720 | 362720 | 2020-07-23 | Roberts | South Dakota | 46109 | 62 | 0 |
365926 | 365926 | 2020-07-24 | Roberts | South Dakota | 46109 | 62 | 0 |
369135 | 369135 | 2020-07-25 | Roberts | South Dakota | 46109 | 63 | 0 |
372347 | 372347 | 2020-07-26 | Roberts | South Dakota | 46109 | 63 | 0 |
375560 | 375560 | 2020-07-27 | Roberts | South Dakota | 46109 | 63 | 0 |
378776 | 378776 | 2020-07-28 | Roberts | South Dakota | 46109 | 64 | 0 |
381993 | 381993 | 2020-07-29 | Roberts | South Dakota | 46109 | 67 | 1 |
385211 | 385211 | 2020-07-30 | Roberts | South Dakota | 46109 | 69 | 1 |
388428 | 388428 | 2020-07-31 | Roberts | South Dakota | 46109 | 69 | 1 |
391645 | 391645 | 2020-08-01 | Roberts | South Dakota | 46109 | 70 | 1 |
394861 | 394861 | 2020-08-02 | Roberts | South Dakota | 46109 | 70 | 1 |
398078 | 398078 | 2020-08-03 | Roberts | South Dakota | 46109 | 70 | 1 |
401293 | 401293 | 2020-08-04 | Roberts | South Dakota | 46109 | 71 | 1 |
404511 | 404511 | 2020-08-05 | Roberts | South Dakota | 46109 | 71 | 1 |
407731 | 407731 | 2020-08-06 | Roberts | South Dakota | 46109 | 73 | 1 |
410950 | 410950 | 2020-08-07 | Roberts | South Dakota | 46109 | 75 | 1 |
414170 | 414170 | 2020-08-08 | Roberts | South Dakota | 46109 | 81 | 1 |
417391 | 417391 | 2020-08-09 | Roberts | South Dakota | 46109 | 80 | 1 |
420612 | 420612 | 2020-08-10 | Roberts | South Dakota | 46109 | 80 | 1 |
423834 | 423834 | 2020-08-11 | Roberts | South Dakota | 46109 | 80 | 1 |
427057 | 427057 | 2020-08-12 | Roberts | South Dakota | 46109 | 80 | 1 |
430284 | 430284 | 2020-08-13 | Roberts | South Dakota | 46109 | 80 | 1 |
433509 | 433509 | 2020-08-14 | Roberts | South Dakota | 46109 | 83 | 1 |
436736 | 436736 | 2020-08-15 | Roberts | South Dakota | 46109 | 83 | 1 |
439961 | 439961 | 2020-08-16 | Roberts | South Dakota | 46109 | 87 | 1 |
443188 | 443188 | 2020-08-17 | Roberts | South Dakota | 46109 | 87 | 1 |
446414 | 446414 | 2020-08-18 | Roberts | South Dakota | 46109 | 87 | 1 |
449642 | 449642 | 2020-08-19 | Roberts | South Dakota | 46109 | 87 | 1 |
452870 | 452870 | 2020-08-20 | Roberts | South Dakota | 46109 | 87 | 1 |
456098 | 456098 | 2020-08-21 | Roberts | South Dakota | 46109 | 88 | 1 |
459326 | 459326 | 2020-08-22 | Roberts | South Dakota | 46109 | 89 | 1 |
462554 | 462554 | 2020-08-23 | Roberts | South Dakota | 46109 | 89 | 1 |
465783 | 465783 | 2020-08-24 | Roberts | South Dakota | 46109 | 91 | 1 |
469011 | 469011 | 2020-08-25 | Roberts | South Dakota | 46109 | 91 | 1 |
472243 | 472243 | 2020-08-26 | Roberts | South Dakota | 46109 | 91 | 1 |
475477 | 475477 | 2020-08-27 | Roberts | South Dakota | 46109 | 93 | 1 |
478710 | 478710 | 2020-08-28 | Roberts | South Dakota | 46109 | 93 | 1 |
481944 | 481944 | 2020-08-29 | Roberts | South Dakota | 46109 | 95 | 1 |
485179 | 485179 | 2020-08-30 | Roberts | South Dakota | 46109 | 97 | 1 |
488412 | 488412 | 2020-08-31 | Roberts | South Dakota | 46109 | 100 | 1 |
491645 | 491645 | 2020-09-01 | Roberts | South Dakota | 46109 | 100 | 1 |
494879 | 494879 | 2020-09-02 | Roberts | South Dakota | 46109 | 100 | 1 |
498112 | 498112 | 2020-09-03 | Roberts | South Dakota | 46109 | 102 | 1 |
501346 | 501346 | 2020-09-04 | Roberts | South Dakota | 46109 | 104 | 1 |
504580 | 504580 | 2020-09-05 | Roberts | South Dakota | 46109 | 105 | 1 |
507812 | 507812 | 2020-09-06 | Roberts | South Dakota | 46109 | 105 | 1 |
511045 | 511045 | 2020-09-07 | Roberts | South Dakota | 46109 | 105 | 1 |
514278 | 514278 | 2020-09-08 | Roberts | South Dakota | 46109 | 105 | 1 |
517513 | 517513 | 2020-09-09 | Roberts | South Dakota | 46109 | 107 | 1 |
520749 | 520749 | 2020-09-10 | Roberts | South Dakota | 46109 | 109 | 1 |
523985 | 523985 | 2020-09-11 | Roberts | South Dakota | 46109 | 110 | 1 |
527221 | 527221 | 2020-09-12 | Roberts | South Dakota | 46109 | 122 | 1 |
530458 | 530458 | 2020-09-13 | Roberts | South Dakota | 46109 | 123 | 1 |
533693 | 533693 | 2020-09-14 | Roberts | South Dakota | 46109 | 126 | 1 |
536929 | 536929 | 2020-09-15 | Roberts | South Dakota | 46109 | 128 | 1 |
540166 | 540166 | 2020-09-16 | Roberts | South Dakota | 46109 | 131 | 1 |
543402 | 543402 | 2020-09-17 | Roberts | South Dakota | 46109 | 139 | 1 |
546639 | 546639 | 2020-09-18 | Roberts | South Dakota | 46109 | 139 | 1 |
549878 | 549878 | 2020-09-19 | Roberts | South Dakota | 46109 | 148 | 1 |
553117 | 553117 | 2020-09-20 | Roberts | South Dakota | 46109 | 157 | 1 |
556354 | 556354 | 2020-09-21 | Roberts | South Dakota | 46109 | 163 | 1 |
559591 | 559591 | 2020-09-22 | Roberts | South Dakota | 46109 | 163 | 1 |
562828 | 562828 | 2020-09-23 | Roberts | South Dakota | 46109 | 167 | 1 |
566069 | 566069 | 2020-09-24 | Roberts | South Dakota | 46109 | 174 | 1 |
569310 | 569310 | 2020-09-25 | Roberts | South Dakota | 46109 | 181 | 1 |
572552 | 572552 | 2020-09-26 | Roberts | South Dakota | 46109 | 204 | 1 |
575796 | 575796 | 2020-09-27 | Roberts | South Dakota | 46109 | 209 | 1 |
579037 | 579037 | 2020-09-28 | Roberts | South Dakota | 46109 | 209 | 1 |
582277 | 582277 | 2020-09-29 | Roberts | South Dakota | 46109 | 212 | 1 |
585517 | 585517 | 2020-09-30 | Roberts | South Dakota | 46109 | 217 | 1 |
588757 | 588757 | 2020-10-01 | Roberts | South Dakota | 46109 | 220 | 1 |
591998 | 591998 | 2020-10-02 | Roberts | South Dakota | 46109 | 224 | 1 |
595239 | 595239 | 2020-10-03 | Roberts | South Dakota | 46109 | 237 | 1 |
598482 | 598482 | 2020-10-04 | Roberts | South Dakota | 46109 | 236 | 1 |
601725 | 601725 | 2020-10-05 | Roberts | South Dakota | 46109 | 236 | 1 |
604967 | 604967 | 2020-10-06 | Roberts | South Dakota | 46109 | 237 | 1 |
608210 | 608210 | 2020-10-07 | Roberts | South Dakota | 46109 | 243 | 1 |
611452 | 611452 | 2020-10-08 | Roberts | South Dakota | 46109 | 244 | 1 |
614693 | 614693 | 2020-10-09 | Roberts | South Dakota | 46109 | 247 | 1 |
617935 | 617935 | 2020-10-10 | Roberts | South Dakota | 46109 | 252 | 1 |
621178 | 621178 | 2020-10-11 | Roberts | South Dakota | 46109 | 254 | 1 |
624421 | 624421 | 2020-10-12 | Roberts | South Dakota | 46109 | 252 | 2 |
627663 | 627663 | 2020-10-13 | Roberts | South Dakota | 46109 | 256 | 2 |
630907 | 630907 | 2020-10-14 | Roberts | South Dakota | 46109 | 258 | 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);