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 |
---|---|---|---|---|---|---|---|
920359 | 920359 | 2021-01-11 | Dunn | Wisconsin | 55033 | 4006 | 25 |
917114 | 917114 | 2021-01-10 | Dunn | Wisconsin | 55033 | 4002 | 25 |
913869 | 913869 | 2021-01-09 | Dunn | Wisconsin | 55033 | 3985 | 25 |
910624 | 910624 | 2021-01-08 | Dunn | Wisconsin | 55033 | 3973 | 25 |
907379 | 907379 | 2021-01-07 | Dunn | Wisconsin | 55033 | 3931 | 24 |
904133 | 904133 | 2021-01-06 | Dunn | Wisconsin | 55033 | 3897 | 24 |
900888 | 900888 | 2021-01-05 | Dunn | Wisconsin | 55033 | 3851 | 24 |
897643 | 897643 | 2021-01-04 | Dunn | Wisconsin | 55033 | 3835 | 24 |
894397 | 894397 | 2021-01-03 | Dunn | Wisconsin | 55033 | 3826 | 24 |
891151 | 891151 | 2021-01-02 | Dunn | Wisconsin | 55033 | 3800 | 23 |
887904 | 887904 | 2021-01-01 | Dunn | Wisconsin | 55033 | 3800 | 23 |
884659 | 884659 | 2020-12-31 | Dunn | Wisconsin | 55033 | 3768 | 23 |
881414 | 881414 | 2020-12-30 | Dunn | Wisconsin | 55033 | 3741 | 23 |
878169 | 878169 | 2020-12-29 | Dunn | Wisconsin | 55033 | 3700 | 23 |
874924 | 874924 | 2020-12-28 | Dunn | Wisconsin | 55033 | 3689 | 22 |
871679 | 871679 | 2020-12-27 | Dunn | Wisconsin | 55033 | 3674 | 22 |
868434 | 868434 | 2020-12-26 | Dunn | Wisconsin | 55033 | 3637 | 22 |
865189 | 865189 | 2020-12-25 | Dunn | Wisconsin | 55033 | 3637 | 22 |
861944 | 861944 | 2020-12-24 | Dunn | Wisconsin | 55033 | 3637 | 22 |
858699 | 858699 | 2020-12-23 | Dunn | Wisconsin | 55033 | 3608 | 22 |
855454 | 855454 | 2020-12-22 | Dunn | Wisconsin | 55033 | 3564 | 21 |
852209 | 852209 | 2020-12-21 | Dunn | Wisconsin | 55033 | 3550 | 21 |
848964 | 848964 | 2020-12-20 | Dunn | Wisconsin | 55033 | 3541 | 20 |
845719 | 845719 | 2020-12-19 | Dunn | Wisconsin | 55033 | 3519 | 20 |
842473 | 842473 | 2020-12-18 | Dunn | Wisconsin | 55033 | 3491 | 20 |
839228 | 839228 | 2020-12-17 | Dunn | Wisconsin | 55033 | 3462 | 20 |
835983 | 835983 | 2020-12-16 | Dunn | Wisconsin | 55033 | 3414 | 20 |
832737 | 832737 | 2020-12-15 | Dunn | Wisconsin | 55033 | 3382 | 20 |
829490 | 829490 | 2020-12-14 | Dunn | Wisconsin | 55033 | 3357 | 20 |
826244 | 826244 | 2020-12-13 | Dunn | Wisconsin | 55033 | 3347 | 18 |
822997 | 822997 | 2020-12-12 | Dunn | Wisconsin | 55033 | 3315 | 18 |
819751 | 819751 | 2020-12-11 | Dunn | Wisconsin | 55033 | 3285 | 17 |
816505 | 816505 | 2020-12-10 | Dunn | Wisconsin | 55033 | 3244 | 16 |
813259 | 813259 | 2020-12-09 | Dunn | Wisconsin | 55033 | 3213 | 16 |
810015 | 810015 | 2020-12-08 | Dunn | Wisconsin | 55033 | 3184 | 16 |
806770 | 806770 | 2020-12-07 | Dunn | Wisconsin | 55033 | 3154 | 15 |
803525 | 803525 | 2020-12-06 | Dunn | Wisconsin | 55033 | 3142 | 15 |
800280 | 800280 | 2020-12-05 | Dunn | Wisconsin | 55033 | 3117 | 14 |
797035 | 797035 | 2020-12-04 | Dunn | Wisconsin | 55033 | 3081 | 14 |
793790 | 793790 | 2020-12-03 | Dunn | Wisconsin | 55033 | 3021 | 14 |
790545 | 790545 | 2020-12-02 | Dunn | Wisconsin | 55033 | 2986 | 13 |
787300 | 787300 | 2020-12-01 | Dunn | Wisconsin | 55033 | 2945 | 13 |
784056 | 784056 | 2020-11-30 | Dunn | Wisconsin | 55033 | 2925 | 12 |
780811 | 780811 | 2020-11-29 | Dunn | Wisconsin | 55033 | 2902 | 12 |
777565 | 777565 | 2020-11-28 | Dunn | Wisconsin | 55033 | 2876 | 12 |
774320 | 774320 | 2020-11-27 | Dunn | Wisconsin | 55033 | 2829 | 12 |
771075 | 771075 | 2020-11-26 | Dunn | Wisconsin | 55033 | 2829 | 12 |
767829 | 767829 | 2020-11-25 | Dunn | Wisconsin | 55033 | 2758 | 12 |
764584 | 764584 | 2020-11-24 | Dunn | Wisconsin | 55033 | 2596 | 9 |
761339 | 761339 | 2020-11-23 | Dunn | Wisconsin | 55033 | 2541 | 8 |
758094 | 758094 | 2020-11-22 | Dunn | Wisconsin | 55033 | 2504 | 8 |
754847 | 754847 | 2020-11-21 | Dunn | Wisconsin | 55033 | 2395 | 8 |
751601 | 751601 | 2020-11-20 | Dunn | Wisconsin | 55033 | 2365 | 8 |
748355 | 748355 | 2020-11-19 | Dunn | Wisconsin | 55033 | 2307 | 5 |
745109 | 745109 | 2020-11-18 | Dunn | Wisconsin | 55033 | 2246 | 5 |
741862 | 741862 | 2020-11-17 | Dunn | Wisconsin | 55033 | 2203 | 4 |
738615 | 738615 | 2020-11-16 | Dunn | Wisconsin | 55033 | 2148 | 3 |
735371 | 735371 | 2020-11-15 | Dunn | Wisconsin | 55033 | 2068 | 3 |
732125 | 732125 | 2020-11-14 | Dunn | Wisconsin | 55033 | 1952 | 2 |
728880 | 728880 | 2020-11-13 | Dunn | Wisconsin | 55033 | 1908 | 1 |
725637 | 725637 | 2020-11-12 | Dunn | Wisconsin | 55033 | 1817 | 1 |
722394 | 722394 | 2020-11-11 | Dunn | Wisconsin | 55033 | 1779 | 1 |
719151 | 719151 | 2020-11-10 | Dunn | Wisconsin | 55033 | 1708 | 1 |
715908 | 715908 | 2020-11-09 | Dunn | Wisconsin | 55033 | 1677 | 1 |
712664 | 712664 | 2020-11-08 | Dunn | Wisconsin | 55033 | 1636 | 1 |
709420 | 709420 | 2020-11-07 | Dunn | Wisconsin | 55033 | 1599 | 1 |
706176 | 706176 | 2020-11-06 | Dunn | Wisconsin | 55033 | 1545 | 1 |
702933 | 702933 | 2020-11-05 | Dunn | Wisconsin | 55033 | 1484 | 1 |
699690 | 699690 | 2020-11-04 | Dunn | Wisconsin | 55033 | 1422 | 1 |
696446 | 696446 | 2020-11-03 | Dunn | Wisconsin | 55033 | 1330 | 1 |
693204 | 693204 | 2020-11-02 | Dunn | Wisconsin | 55033 | 1291 | 1 |
689960 | 689960 | 2020-11-01 | Dunn | Wisconsin | 55033 | 1241 | 1 |
686715 | 686715 | 2020-10-31 | Dunn | Wisconsin | 55033 | 1222 | 1 |
683472 | 683472 | 2020-10-30 | Dunn | Wisconsin | 55033 | 1170 | 1 |
680229 | 680229 | 2020-10-29 | Dunn | Wisconsin | 55033 | 1141 | 1 |
676986 | 676986 | 2020-10-28 | Dunn | Wisconsin | 55033 | 1103 | 1 |
673743 | 673743 | 2020-10-27 | Dunn | Wisconsin | 55033 | 1076 | 1 |
670501 | 670501 | 2020-10-26 | Dunn | Wisconsin | 55033 | 1055 | 1 |
667258 | 667258 | 2020-10-25 | Dunn | Wisconsin | 55033 | 1033 | 1 |
664013 | 664013 | 2020-10-24 | Dunn | Wisconsin | 55033 | 1021 | 1 |
660769 | 660769 | 2020-10-23 | Dunn | Wisconsin | 55033 | 1010 | 1 |
657525 | 657525 | 2020-10-22 | Dunn | Wisconsin | 55033 | 967 | 1 |
654280 | 654280 | 2020-10-21 | Dunn | Wisconsin | 55033 | 938 | 1 |
651035 | 651035 | 2020-10-20 | Dunn | Wisconsin | 55033 | 922 | 1 |
647791 | 647791 | 2020-10-19 | Dunn | Wisconsin | 55033 | 896 | 1 |
644545 | 644545 | 2020-10-18 | Dunn | Wisconsin | 55033 | 865 | 1 |
641297 | 641297 | 2020-10-17 | Dunn | Wisconsin | 55033 | 865 | 1 |
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 |
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);