ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walworth" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732173 | 732173 | 2020-11-14 | Walworth | Wisconsin | 55127 | 5279 | 45 |
728928 | 728928 | 2020-11-13 | Walworth | Wisconsin | 55127 | 5189 | 44 |
725685 | 725685 | 2020-11-12 | Walworth | Wisconsin | 55127 | 5014 | 42 |
722442 | 722442 | 2020-11-11 | Walworth | Wisconsin | 55127 | 4881 | 42 |
719199 | 719199 | 2020-11-10 | Walworth | Wisconsin | 55127 | 4791 | 41 |
715956 | 715956 | 2020-11-09 | Walworth | Wisconsin | 55127 | 4625 | 41 |
712712 | 712712 | 2020-11-08 | Walworth | Wisconsin | 55127 | 4541 | 41 |
709468 | 709468 | 2020-11-07 | Walworth | Wisconsin | 55127 | 4506 | 41 |
706224 | 706224 | 2020-11-06 | Walworth | Wisconsin | 55127 | 4382 | 41 |
702981 | 702981 | 2020-11-05 | Walworth | Wisconsin | 55127 | 4215 | 41 |
699738 | 699738 | 2020-11-04 | Walworth | Wisconsin | 55127 | 4065 | 41 |
696494 | 696494 | 2020-11-03 | Walworth | Wisconsin | 55127 | 4022 | 41 |
693252 | 693252 | 2020-11-02 | Walworth | Wisconsin | 55127 | 3907 | 40 |
690009 | 690009 | 2020-11-01 | Walworth | Wisconsin | 55127 | 3902 | 40 |
686764 | 686764 | 2020-10-31 | Walworth | Wisconsin | 55127 | 3901 | 40 |
683520 | 683520 | 2020-10-30 | Walworth | Wisconsin | 55127 | 3803 | 40 |
680277 | 680277 | 2020-10-29 | Walworth | Wisconsin | 55127 | 3741 | 39 |
677034 | 677034 | 2020-10-28 | Walworth | Wisconsin | 55127 | 3698 | 39 |
673791 | 673791 | 2020-10-27 | Walworth | Wisconsin | 55127 | 3666 | 39 |
670549 | 670549 | 2020-10-26 | Walworth | Wisconsin | 55127 | 3632 | 38 |
667306 | 667306 | 2020-10-25 | Walworth | Wisconsin | 55127 | 3572 | 38 |
664061 | 664061 | 2020-10-24 | Walworth | Wisconsin | 55127 | 3531 | 38 |
660817 | 660817 | 2020-10-23 | Walworth | Wisconsin | 55127 | 3453 | 38 |
657573 | 657573 | 2020-10-22 | Walworth | Wisconsin | 55127 | 3424 | 38 |
654328 | 654328 | 2020-10-21 | Walworth | Wisconsin | 55127 | 3392 | 38 |
651083 | 651083 | 2020-10-20 | Walworth | Wisconsin | 55127 | 3348 | 36 |
647839 | 647839 | 2020-10-19 | Walworth | Wisconsin | 55127 | 3285 | 36 |
644594 | 644594 | 2020-10-18 | Walworth | Wisconsin | 55127 | 3253 | 36 |
641346 | 641346 | 2020-10-17 | Walworth | Wisconsin | 55127 | 3253 | 36 |
638099 | 638099 | 2020-10-16 | Walworth | Wisconsin | 55127 | 3253 | 36 |
634854 | 634854 | 2020-10-15 | Walworth | Wisconsin | 55127 | 3213 | 36 |
631609 | 631609 | 2020-10-14 | Walworth | Wisconsin | 55127 | 3173 | 36 |
628365 | 628365 | 2020-10-13 | Walworth | Wisconsin | 55127 | 3147 | 36 |
625122 | 625122 | 2020-10-12 | Walworth | Wisconsin | 55127 | 3120 | 36 |
621879 | 621879 | 2020-10-11 | Walworth | Wisconsin | 55127 | 3104 | 36 |
618636 | 618636 | 2020-10-10 | Walworth | Wisconsin | 55127 | 3094 | 36 |
615394 | 615394 | 2020-10-09 | Walworth | Wisconsin | 55127 | 3058 | 36 |
612153 | 612153 | 2020-10-08 | Walworth | Wisconsin | 55127 | 3032 | 35 |
608911 | 608911 | 2020-10-07 | Walworth | Wisconsin | 55127 | 3003 | 35 |
605668 | 605668 | 2020-10-06 | Walworth | Wisconsin | 55127 | 2979 | 35 |
602426 | 602426 | 2020-10-05 | Walworth | Wisconsin | 55127 | 2954 | 35 |
599183 | 599183 | 2020-10-04 | Walworth | Wisconsin | 55127 | 2941 | 35 |
595940 | 595940 | 2020-10-03 | Walworth | Wisconsin | 55127 | 2916 | 35 |
592698 | 592698 | 2020-10-02 | Walworth | Wisconsin | 55127 | 2876 | 35 |
589458 | 589458 | 2020-10-01 | Walworth | Wisconsin | 55127 | 2803 | 35 |
586217 | 586217 | 2020-09-30 | Walworth | Wisconsin | 55127 | 2784 | 35 |
582977 | 582977 | 2020-09-29 | Walworth | Wisconsin | 55127 | 2772 | 35 |
579738 | 579738 | 2020-09-28 | Walworth | Wisconsin | 55127 | 2730 | 35 |
576497 | 576497 | 2020-09-27 | Walworth | Wisconsin | 55127 | 2730 | 35 |
573253 | 573253 | 2020-09-26 | Walworth | Wisconsin | 55127 | 2724 | 35 |
570011 | 570011 | 2020-09-25 | Walworth | Wisconsin | 55127 | 2695 | 35 |
566770 | 566770 | 2020-09-24 | Walworth | Wisconsin | 55127 | 2672 | 34 |
563529 | 563529 | 2020-09-23 | Walworth | Wisconsin | 55127 | 2649 | 34 |
560290 | 560290 | 2020-09-22 | Walworth | Wisconsin | 55127 | 2630 | 34 |
557054 | 557054 | 2020-09-21 | Walworth | Wisconsin | 55127 | 2603 | 34 |
553817 | 553817 | 2020-09-20 | Walworth | Wisconsin | 55127 | 2573 | 34 |
550578 | 550578 | 2020-09-19 | Walworth | Wisconsin | 55127 | 2566 | 34 |
547339 | 547339 | 2020-09-18 | Walworth | Wisconsin | 55127 | 2515 | 34 |
544102 | 544102 | 2020-09-17 | Walworth | Wisconsin | 55127 | 2474 | 34 |
540866 | 540866 | 2020-09-16 | Walworth | Wisconsin | 55127 | 2423 | 34 |
537629 | 537629 | 2020-09-15 | Walworth | Wisconsin | 55127 | 2380 | 33 |
534393 | 534393 | 2020-09-14 | Walworth | Wisconsin | 55127 | 2258 | 32 |
531158 | 531158 | 2020-09-13 | Walworth | Wisconsin | 55127 | 2235 | 32 |
527921 | 527921 | 2020-09-12 | Walworth | Wisconsin | 55127 | 2200 | 32 |
524685 | 524685 | 2020-09-11 | Walworth | Wisconsin | 55127 | 2143 | 32 |
521449 | 521449 | 2020-09-10 | Walworth | Wisconsin | 55127 | 2106 | 32 |
518212 | 518212 | 2020-09-09 | Walworth | Wisconsin | 55127 | 2020 | 32 |
514977 | 514977 | 2020-09-08 | Walworth | Wisconsin | 55127 | 1974 | 32 |
511744 | 511744 | 2020-09-07 | Walworth | Wisconsin | 55127 | 1969 | 32 |
508511 | 508511 | 2020-09-06 | Walworth | Wisconsin | 55127 | 1947 | 32 |
505279 | 505279 | 2020-09-05 | Walworth | Wisconsin | 55127 | 1927 | 32 |
502045 | 502045 | 2020-09-04 | Walworth | Wisconsin | 55127 | 1901 | 32 |
498811 | 498811 | 2020-09-03 | Walworth | Wisconsin | 55127 | 1749 | 32 |
495578 | 495578 | 2020-09-02 | Walworth | Wisconsin | 55127 | 1726 | 31 |
492344 | 492344 | 2020-09-01 | Walworth | Wisconsin | 55127 | 1714 | 28 |
489111 | 489111 | 2020-08-31 | Walworth | Wisconsin | 55127 | 1703 | 27 |
485878 | 485878 | 2020-08-30 | Walworth | Wisconsin | 55127 | 1695 | 27 |
482643 | 482643 | 2020-08-29 | Walworth | Wisconsin | 55127 | 1689 | 27 |
479409 | 479409 | 2020-08-28 | Walworth | Wisconsin | 55127 | 1684 | 27 |
476176 | 476176 | 2020-08-27 | Walworth | Wisconsin | 55127 | 1654 | 27 |
472943 | 472943 | 2020-08-26 | Walworth | Wisconsin | 55127 | 1645 | 26 |
469711 | 469711 | 2020-08-25 | Walworth | Wisconsin | 55127 | 1631 | 26 |
466482 | 466482 | 2020-08-24 | Walworth | Wisconsin | 55127 | 1614 | 26 |
463253 | 463253 | 2020-08-23 | Walworth | Wisconsin | 55127 | 1591 | 25 |
460024 | 460024 | 2020-08-22 | Walworth | Wisconsin | 55127 | 1591 | 25 |
456797 | 456797 | 2020-08-21 | Walworth | Wisconsin | 55127 | 1573 | 25 |
453569 | 453569 | 2020-08-20 | Walworth | Wisconsin | 55127 | 1546 | 25 |
450341 | 450341 | 2020-08-19 | Walworth | Wisconsin | 55127 | 1534 | 25 |
447113 | 447113 | 2020-08-18 | Walworth | Wisconsin | 55127 | 1526 | 25 |
443886 | 443886 | 2020-08-17 | Walworth | Wisconsin | 55127 | 1516 | 25 |
440660 | 440660 | 2020-08-16 | Walworth | Wisconsin | 55127 | 1499 | 25 |
437434 | 437434 | 2020-08-15 | Walworth | Wisconsin | 55127 | 1479 | 25 |
434208 | 434208 | 2020-08-14 | Walworth | Wisconsin | 55127 | 1430 | 24 |
430983 | 430983 | 2020-08-13 | Walworth | Wisconsin | 55127 | 1401 | 24 |
427755 | 427755 | 2020-08-12 | Walworth | Wisconsin | 55127 | 1369 | 23 |
424531 | 424531 | 2020-08-11 | Walworth | Wisconsin | 55127 | 1359 | 23 |
421310 | 421310 | 2020-08-10 | Walworth | Wisconsin | 55127 | 1335 | 23 |
418089 | 418089 | 2020-08-09 | Walworth | Wisconsin | 55127 | 1335 | 23 |
414868 | 414868 | 2020-08-08 | Walworth | Wisconsin | 55127 | 1314 | 23 |
411648 | 411648 | 2020-08-07 | Walworth | Wisconsin | 55127 | 1298 | 23 |
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);