ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46035 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
251846 | 251846 | 2020-06-18 | Davison | South Dakota | 46035 | 33 | 1 |
254961 | 254961 | 2020-06-19 | Davison | South Dakota | 46035 | 33 | 1 |
258087 | 258087 | 2020-06-20 | Davison | South Dakota | 46035 | 34 | 1 |
261214 | 261214 | 2020-06-21 | Davison | South Dakota | 46035 | 35 | 1 |
264342 | 264342 | 2020-06-22 | Davison | South Dakota | 46035 | 35 | 1 |
267470 | 267470 | 2020-06-23 | Davison | South Dakota | 46035 | 35 | 1 |
270604 | 270604 | 2020-06-24 | Davison | South Dakota | 46035 | 35 | 1 |
273743 | 273743 | 2020-06-25 | Davison | South Dakota | 46035 | 35 | 1 |
276890 | 276890 | 2020-06-26 | Davison | South Dakota | 46035 | 36 | 1 |
280038 | 280038 | 2020-06-27 | Davison | South Dakota | 46035 | 37 | 1 |
283184 | 283184 | 2020-06-28 | Davison | South Dakota | 46035 | 39 | 1 |
286329 | 286329 | 2020-06-29 | Davison | South Dakota | 46035 | 40 | 1 |
289480 | 289480 | 2020-06-30 | Davison | South Dakota | 46035 | 41 | 1 |
292632 | 292632 | 2020-07-01 | Davison | South Dakota | 46035 | 41 | 1 |
295788 | 295788 | 2020-07-02 | Davison | South Dakota | 46035 | 43 | 1 |
298948 | 298948 | 2020-07-03 | Davison | South Dakota | 46035 | 44 | 1 |
302112 | 302112 | 2020-07-04 | Davison | South Dakota | 46035 | 44 | 1 |
305275 | 305275 | 2020-07-05 | Davison | South Dakota | 46035 | 46 | 1 |
308442 | 308442 | 2020-07-06 | Davison | South Dakota | 46035 | 47 | 1 |
311611 | 311611 | 2020-07-07 | Davison | South Dakota | 46035 | 47 | 1 |
314784 | 314784 | 2020-07-08 | Davison | South Dakota | 46035 | 50 | 1 |
317957 | 317957 | 2020-07-09 | Davison | South Dakota | 46035 | 51 | 1 |
321135 | 321135 | 2020-07-10 | Davison | South Dakota | 46035 | 52 | 1 |
324315 | 324315 | 2020-07-11 | Davison | South Dakota | 46035 | 54 | 1 |
327500 | 327500 | 2020-07-12 | Davison | South Dakota | 46035 | 55 | 1 |
330686 | 330686 | 2020-07-13 | Davison | South Dakota | 46035 | 56 | 1 |
333878 | 333878 | 2020-07-14 | Davison | South Dakota | 46035 | 57 | 1 |
337072 | 337072 | 2020-07-15 | Davison | South Dakota | 46035 | 57 | 1 |
340269 | 340269 | 2020-07-16 | Davison | South Dakota | 46035 | 57 | 1 |
343467 | 343467 | 2020-07-17 | Davison | South Dakota | 46035 | 65 | 1 |
346667 | 346667 | 2020-07-18 | Davison | South Dakota | 46035 | 66 | 1 |
349867 | 349867 | 2020-07-19 | Davison | South Dakota | 46035 | 67 | 1 |
353070 | 353070 | 2020-07-20 | Davison | South Dakota | 46035 | 69 | 1 |
356273 | 356273 | 2020-07-21 | Davison | South Dakota | 46035 | 71 | 1 |
359477 | 359477 | 2020-07-22 | Davison | South Dakota | 46035 | 73 | 1 |
362683 | 362683 | 2020-07-23 | Davison | South Dakota | 46035 | 75 | 1 |
365889 | 365889 | 2020-07-24 | Davison | South Dakota | 46035 | 76 | 1 |
369098 | 369098 | 2020-07-25 | Davison | South Dakota | 46035 | 78 | 1 |
372310 | 372310 | 2020-07-26 | Davison | South Dakota | 46035 | 81 | 1 |
375523 | 375523 | 2020-07-27 | Davison | South Dakota | 46035 | 81 | 1 |
378739 | 378739 | 2020-07-28 | Davison | South Dakota | 46035 | 81 | 1 |
381956 | 381956 | 2020-07-29 | Davison | South Dakota | 46035 | 83 | 1 |
385174 | 385174 | 2020-07-30 | Davison | South Dakota | 46035 | 84 | 1 |
388391 | 388391 | 2020-07-31 | Davison | South Dakota | 46035 | 86 | 1 |
391608 | 391608 | 2020-08-01 | Davison | South Dakota | 46035 | 87 | 1 |
394824 | 394824 | 2020-08-02 | Davison | South Dakota | 46035 | 88 | 1 |
398041 | 398041 | 2020-08-03 | Davison | South Dakota | 46035 | 88 | 1 |
401256 | 401256 | 2020-08-04 | Davison | South Dakota | 46035 | 93 | 1 |
404474 | 404474 | 2020-08-05 | Davison | South Dakota | 46035 | 93 | 2 |
407694 | 407694 | 2020-08-06 | Davison | South Dakota | 46035 | 94 | 2 |
410913 | 410913 | 2020-08-07 | Davison | South Dakota | 46035 | 94 | 2 |
414133 | 414133 | 2020-08-08 | Davison | South Dakota | 46035 | 94 | 1 |
417354 | 417354 | 2020-08-09 | Davison | South Dakota | 46035 | 97 | 1 |
420575 | 420575 | 2020-08-10 | Davison | South Dakota | 46035 | 97 | 1 |
423797 | 423797 | 2020-08-11 | Davison | South Dakota | 46035 | 96 | 1 |
427020 | 427020 | 2020-08-12 | Davison | South Dakota | 46035 | 96 | 1 |
430246 | 430246 | 2020-08-13 | Davison | South Dakota | 46035 | 99 | 1 |
433471 | 433471 | 2020-08-14 | Davison | South Dakota | 46035 | 99 | 1 |
436698 | 436698 | 2020-08-15 | Davison | South Dakota | 46035 | 100 | 1 |
439923 | 439923 | 2020-08-16 | Davison | South Dakota | 46035 | 100 | 1 |
443150 | 443150 | 2020-08-17 | Davison | South Dakota | 46035 | 101 | 1 |
446376 | 446376 | 2020-08-18 | Davison | South Dakota | 46035 | 101 | 1 |
449604 | 449604 | 2020-08-19 | Davison | South Dakota | 46035 | 101 | 1 |
452832 | 452832 | 2020-08-20 | Davison | South Dakota | 46035 | 104 | 2 |
456060 | 456060 | 2020-08-21 | Davison | South Dakota | 46035 | 104 | 2 |
459288 | 459288 | 2020-08-22 | Davison | South Dakota | 46035 | 106 | 2 |
462516 | 462516 | 2020-08-23 | Davison | South Dakota | 46035 | 108 | 2 |
465745 | 465745 | 2020-08-24 | Davison | South Dakota | 46035 | 108 | 2 |
468973 | 468973 | 2020-08-25 | Davison | South Dakota | 46035 | 112 | 2 |
472205 | 472205 | 2020-08-26 | Davison | South Dakota | 46035 | 113 | 2 |
475439 | 475439 | 2020-08-27 | Davison | South Dakota | 46035 | 121 | 2 |
478672 | 478672 | 2020-08-28 | Davison | South Dakota | 46035 | 126 | 2 |
481906 | 481906 | 2020-08-29 | Davison | South Dakota | 46035 | 133 | 2 |
485141 | 485141 | 2020-08-30 | Davison | South Dakota | 46035 | 135 | 2 |
488374 | 488374 | 2020-08-31 | Davison | South Dakota | 46035 | 136 | 2 |
491607 | 491607 | 2020-09-01 | Davison | South Dakota | 46035 | 143 | 2 |
494841 | 494841 | 2020-09-02 | Davison | South Dakota | 46035 | 142 | 2 |
498074 | 498074 | 2020-09-03 | Davison | South Dakota | 46035 | 146 | 2 |
501308 | 501308 | 2020-09-04 | Davison | South Dakota | 46035 | 148 | 2 |
504542 | 504542 | 2020-09-05 | Davison | South Dakota | 46035 | 152 | 2 |
507774 | 507774 | 2020-09-06 | Davison | South Dakota | 46035 | 155 | 2 |
511007 | 511007 | 2020-09-07 | Davison | South Dakota | 46035 | 158 | 2 |
514240 | 514240 | 2020-09-08 | Davison | South Dakota | 46035 | 162 | 2 |
517475 | 517475 | 2020-09-09 | Davison | South Dakota | 46035 | 164 | 2 |
520711 | 520711 | 2020-09-10 | Davison | South Dakota | 46035 | 165 | 2 |
523947 | 523947 | 2020-09-11 | Davison | South Dakota | 46035 | 165 | 2 |
527183 | 527183 | 2020-09-12 | Davison | South Dakota | 46035 | 169 | 2 |
530420 | 530420 | 2020-09-13 | Davison | South Dakota | 46035 | 171 | 2 |
533655 | 533655 | 2020-09-14 | Davison | South Dakota | 46035 | 171 | 2 |
536891 | 536891 | 2020-09-15 | Davison | South Dakota | 46035 | 176 | 2 |
540128 | 540128 | 2020-09-16 | Davison | South Dakota | 46035 | 181 | 2 |
543364 | 543364 | 2020-09-17 | Davison | South Dakota | 46035 | 186 | 2 |
546601 | 546601 | 2020-09-18 | Davison | South Dakota | 46035 | 197 | 2 |
549840 | 549840 | 2020-09-19 | Davison | South Dakota | 46035 | 200 | 2 |
553079 | 553079 | 2020-09-20 | Davison | South Dakota | 46035 | 204 | 2 |
556316 | 556316 | 2020-09-21 | Davison | South Dakota | 46035 | 210 | 2 |
559553 | 559553 | 2020-09-22 | Davison | South Dakota | 46035 | 225 | 2 |
562790 | 562790 | 2020-09-23 | Davison | South Dakota | 46035 | 230 | 2 |
566031 | 566031 | 2020-09-24 | Davison | South Dakota | 46035 | 249 | 2 |
569272 | 569272 | 2020-09-25 | Davison | South Dakota | 46035 | 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);