ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Dunn" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638050 | 638050 | 2020-10-16 | Dunn | Wisconsin | 55033 | 865 | 1 |
634805 | 634805 | 2020-10-15 | Dunn | Wisconsin | 55033 | 832 | 1 |
631560 | 631560 | 2020-10-14 | Dunn | Wisconsin | 55033 | 826 | 1 |
628316 | 628316 | 2020-10-13 | Dunn | Wisconsin | 55033 | 821 | 1 |
625073 | 625073 | 2020-10-12 | Dunn | Wisconsin | 55033 | 815 | 1 |
621830 | 621830 | 2020-10-11 | Dunn | Wisconsin | 55033 | 808 | 1 |
618587 | 618587 | 2020-10-10 | Dunn | Wisconsin | 55033 | 795 | 1 |
615345 | 615345 | 2020-10-09 | Dunn | Wisconsin | 55033 | 773 | 1 |
612104 | 612104 | 2020-10-08 | Dunn | Wisconsin | 55033 | 753 | 1 |
608862 | 608862 | 2020-10-07 | Dunn | Wisconsin | 55033 | 733 | 1 |
605619 | 605619 | 2020-10-06 | Dunn | Wisconsin | 55033 | 727 | 1 |
602377 | 602377 | 2020-10-05 | Dunn | Wisconsin | 55033 | 715 | 1 |
599134 | 599134 | 2020-10-04 | Dunn | Wisconsin | 55033 | 710 | 1 |
595891 | 595891 | 2020-10-03 | Dunn | Wisconsin | 55033 | 700 | 1 |
592649 | 592649 | 2020-10-02 | Dunn | Wisconsin | 55033 | 685 | 1 |
589409 | 589409 | 2020-10-01 | Dunn | Wisconsin | 55033 | 658 | 1 |
586168 | 586168 | 2020-09-30 | Dunn | Wisconsin | 55033 | 637 | 1 |
582928 | 582928 | 2020-09-29 | Dunn | Wisconsin | 55033 | 618 | 0 |
579689 | 579689 | 2020-09-28 | Dunn | Wisconsin | 55033 | 580 | 0 |
576448 | 576448 | 2020-09-27 | Dunn | Wisconsin | 55033 | 550 | 0 |
573204 | 573204 | 2020-09-26 | Dunn | Wisconsin | 55033 | 524 | 0 |
569962 | 569962 | 2020-09-25 | Dunn | Wisconsin | 55033 | 497 | 0 |
566721 | 566721 | 2020-09-24 | Dunn | Wisconsin | 55033 | 471 | 0 |
563480 | 563480 | 2020-09-23 | Dunn | Wisconsin | 55033 | 448 | 0 |
560241 | 560241 | 2020-09-22 | Dunn | Wisconsin | 55033 | 426 | 0 |
557005 | 557005 | 2020-09-21 | Dunn | Wisconsin | 55033 | 406 | 0 |
553768 | 553768 | 2020-09-20 | Dunn | Wisconsin | 55033 | 398 | 0 |
550529 | 550529 | 2020-09-19 | Dunn | Wisconsin | 55033 | 373 | 0 |
547290 | 547290 | 2020-09-18 | Dunn | Wisconsin | 55033 | 338 | 0 |
544053 | 544053 | 2020-09-17 | Dunn | Wisconsin | 55033 | 309 | 0 |
540817 | 540817 | 2020-09-16 | Dunn | Wisconsin | 55033 | 284 | 0 |
537580 | 537580 | 2020-09-15 | Dunn | Wisconsin | 55033 | 275 | 0 |
534344 | 534344 | 2020-09-14 | Dunn | Wisconsin | 55033 | 270 | 0 |
531109 | 531109 | 2020-09-13 | Dunn | Wisconsin | 55033 | 265 | 0 |
527872 | 527872 | 2020-09-12 | Dunn | Wisconsin | 55033 | 254 | 0 |
524636 | 524636 | 2020-09-11 | Dunn | Wisconsin | 55033 | 240 | 0 |
521400 | 521400 | 2020-09-10 | Dunn | Wisconsin | 55033 | 231 | 0 |
518163 | 518163 | 2020-09-09 | Dunn | Wisconsin | 55033 | 224 | 0 |
514928 | 514928 | 2020-09-08 | Dunn | Wisconsin | 55033 | 218 | 0 |
511695 | 511695 | 2020-09-07 | Dunn | Wisconsin | 55033 | 216 | 0 |
508462 | 508462 | 2020-09-06 | Dunn | Wisconsin | 55033 | 211 | 0 |
505230 | 505230 | 2020-09-05 | Dunn | Wisconsin | 55033 | 206 | 0 |
501996 | 501996 | 2020-09-04 | Dunn | Wisconsin | 55033 | 204 | 0 |
498762 | 498762 | 2020-09-03 | Dunn | Wisconsin | 55033 | 183 | 0 |
495529 | 495529 | 2020-09-02 | Dunn | Wisconsin | 55033 | 179 | 0 |
492295 | 492295 | 2020-09-01 | Dunn | Wisconsin | 55033 | 179 | 0 |
489062 | 489062 | 2020-08-31 | Dunn | Wisconsin | 55033 | 175 | 0 |
485829 | 485829 | 2020-08-30 | Dunn | Wisconsin | 55033 | 176 | 0 |
482594 | 482594 | 2020-08-29 | Dunn | Wisconsin | 55033 | 173 | 0 |
479360 | 479360 | 2020-08-28 | Dunn | Wisconsin | 55033 | 169 | 0 |
476127 | 476127 | 2020-08-27 | Dunn | Wisconsin | 55033 | 163 | 0 |
472894 | 472894 | 2020-08-26 | Dunn | Wisconsin | 55033 | 159 | 0 |
469662 | 469662 | 2020-08-25 | Dunn | Wisconsin | 55033 | 155 | 0 |
466433 | 466433 | 2020-08-24 | Dunn | Wisconsin | 55033 | 155 | 0 |
463204 | 463204 | 2020-08-23 | Dunn | Wisconsin | 55033 | 154 | 0 |
459975 | 459975 | 2020-08-22 | Dunn | Wisconsin | 55033 | 153 | 0 |
456748 | 456748 | 2020-08-21 | Dunn | Wisconsin | 55033 | 152 | 0 |
453520 | 453520 | 2020-08-20 | Dunn | Wisconsin | 55033 | 150 | 0 |
450292 | 450292 | 2020-08-19 | Dunn | Wisconsin | 55033 | 147 | 0 |
447064 | 447064 | 2020-08-18 | Dunn | Wisconsin | 55033 | 142 | 0 |
443837 | 443837 | 2020-08-17 | Dunn | Wisconsin | 55033 | 142 | 0 |
440611 | 440611 | 2020-08-16 | Dunn | Wisconsin | 55033 | 139 | 0 |
437385 | 437385 | 2020-08-15 | Dunn | Wisconsin | 55033 | 139 | 0 |
434159 | 434159 | 2020-08-14 | Dunn | Wisconsin | 55033 | 138 | 0 |
430934 | 430934 | 2020-08-13 | Dunn | Wisconsin | 55033 | 134 | 0 |
427706 | 427706 | 2020-08-12 | Dunn | Wisconsin | 55033 | 131 | 0 |
424482 | 424482 | 2020-08-11 | Dunn | Wisconsin | 55033 | 128 | 0 |
421261 | 421261 | 2020-08-10 | Dunn | Wisconsin | 55033 | 126 | 0 |
418040 | 418040 | 2020-08-09 | Dunn | Wisconsin | 55033 | 123 | 0 |
414819 | 414819 | 2020-08-08 | Dunn | Wisconsin | 55033 | 122 | 0 |
411599 | 411599 | 2020-08-07 | Dunn | Wisconsin | 55033 | 119 | 0 |
408380 | 408380 | 2020-08-06 | Dunn | Wisconsin | 55033 | 112 | 0 |
405160 | 405160 | 2020-08-05 | Dunn | Wisconsin | 55033 | 112 | 0 |
401942 | 401942 | 2020-08-04 | Dunn | Wisconsin | 55033 | 107 | 0 |
398726 | 398726 | 2020-08-03 | Dunn | Wisconsin | 55033 | 105 | 0 |
395510 | 395510 | 2020-08-02 | Dunn | Wisconsin | 55033 | 105 | 0 |
392294 | 392294 | 2020-08-01 | Dunn | Wisconsin | 55033 | 105 | 0 |
389077 | 389077 | 2020-07-31 | Dunn | Wisconsin | 55033 | 102 | 0 |
385860 | 385860 | 2020-07-30 | Dunn | Wisconsin | 55033 | 101 | 0 |
382642 | 382642 | 2020-07-29 | Dunn | Wisconsin | 55033 | 98 | 0 |
379425 | 379425 | 2020-07-28 | Dunn | Wisconsin | 55033 | 95 | 0 |
376209 | 376209 | 2020-07-27 | Dunn | Wisconsin | 55033 | 91 | 0 |
372995 | 372995 | 2020-07-26 | Dunn | Wisconsin | 55033 | 88 | 0 |
369783 | 369783 | 2020-07-25 | Dunn | Wisconsin | 55033 | 85 | 0 |
366573 | 366573 | 2020-07-24 | Dunn | Wisconsin | 55033 | 84 | 0 |
363366 | 363366 | 2020-07-23 | Dunn | Wisconsin | 55033 | 79 | 0 |
360160 | 360160 | 2020-07-22 | Dunn | Wisconsin | 55033 | 74 | 0 |
356955 | 356955 | 2020-07-21 | Dunn | Wisconsin | 55033 | 71 | 0 |
353752 | 353752 | 2020-07-20 | Dunn | Wisconsin | 55033 | 68 | 0 |
350550 | 350550 | 2020-07-19 | Dunn | Wisconsin | 55033 | 65 | 0 |
347349 | 347349 | 2020-07-18 | Dunn | Wisconsin | 55033 | 63 | 0 |
344149 | 344149 | 2020-07-17 | Dunn | Wisconsin | 55033 | 60 | 0 |
340950 | 340950 | 2020-07-16 | Dunn | Wisconsin | 55033 | 59 | 0 |
337754 | 337754 | 2020-07-15 | Dunn | Wisconsin | 55033 | 59 | 0 |
334559 | 334559 | 2020-07-14 | Dunn | Wisconsin | 55033 | 57 | 0 |
331366 | 331366 | 2020-07-13 | Dunn | Wisconsin | 55033 | 57 | 0 |
328180 | 328180 | 2020-07-12 | Dunn | Wisconsin | 55033 | 57 | 0 |
324994 | 324994 | 2020-07-11 | Dunn | Wisconsin | 55033 | 54 | 0 |
321813 | 321813 | 2020-07-10 | Dunn | Wisconsin | 55033 | 54 | 0 |
318634 | 318634 | 2020-07-09 | Dunn | Wisconsin | 55033 | 50 | 0 |
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);