ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Green" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063170 | 1063170 | 2021-02-24 | Green | Wisconsin | 55045 | 3209 | 22 |
1059925 | 1059925 | 2021-02-23 | Green | Wisconsin | 55045 | 3190 | 22 |
1056679 | 1056679 | 2021-02-22 | Green | Wisconsin | 55045 | 3186 | 22 |
1053433 | 1053433 | 2021-02-21 | Green | Wisconsin | 55045 | 3185 | 22 |
1050186 | 1050186 | 2021-02-20 | Green | Wisconsin | 55045 | 3175 | 22 |
1046939 | 1046939 | 2021-02-19 | Green | Wisconsin | 55045 | 3151 | 22 |
1043694 | 1043694 | 2021-02-18 | Green | Wisconsin | 55045 | 3131 | 22 |
1040449 | 1040449 | 2021-02-17 | Green | Wisconsin | 55045 | 3119 | 22 |
1037204 | 1037204 | 2021-02-16 | Green | Wisconsin | 55045 | 3087 | 22 |
1033959 | 1033959 | 2021-02-15 | Green | Wisconsin | 55045 | 3080 | 22 |
1030713 | 1030713 | 2021-02-14 | Green | Wisconsin | 55045 | 3075 | 22 |
1027466 | 1027466 | 2021-02-13 | Green | Wisconsin | 55045 | 3067 | 22 |
1024221 | 1024221 | 2021-02-12 | Green | Wisconsin | 55045 | 3045 | 22 |
1020976 | 1020976 | 2021-02-11 | Green | Wisconsin | 55045 | 3017 | 21 |
1017731 | 1017731 | 2021-02-10 | Green | Wisconsin | 55045 | 3000 | 21 |
1014486 | 1014486 | 2021-02-09 | Green | Wisconsin | 55045 | 2962 | 21 |
1011241 | 1011241 | 2021-02-08 | Green | Wisconsin | 55045 | 2957 | 19 |
1007995 | 1007995 | 2021-02-07 | Green | Wisconsin | 55045 | 2950 | 19 |
1004749 | 1004749 | 2021-02-06 | Green | Wisconsin | 55045 | 2940 | 19 |
1001503 | 1001503 | 2021-02-05 | Green | Wisconsin | 55045 | 2922 | 19 |
998257 | 998257 | 2021-02-04 | Green | Wisconsin | 55045 | 2901 | 19 |
995011 | 995011 | 2021-02-03 | Green | Wisconsin | 55045 | 2874 | 19 |
991765 | 991765 | 2021-02-02 | Green | Wisconsin | 55045 | 2844 | 19 |
988519 | 988519 | 2021-02-01 | Green | Wisconsin | 55045 | 2837 | 19 |
985272 | 985272 | 2021-01-31 | Green | Wisconsin | 55045 | 2829 | 19 |
982025 | 982025 | 2021-01-30 | Green | Wisconsin | 55045 | 2812 | 19 |
978779 | 978779 | 2021-01-29 | Green | Wisconsin | 55045 | 2805 | 19 |
975534 | 975534 | 2021-01-28 | Green | Wisconsin | 55045 | 2773 | 17 |
972289 | 972289 | 2021-01-27 | Green | Wisconsin | 55045 | 2756 | 17 |
969044 | 969044 | 2021-01-26 | Green | Wisconsin | 55045 | 2730 | 17 |
965800 | 965800 | 2021-01-25 | Green | Wisconsin | 55045 | 2716 | 17 |
962555 | 962555 | 2021-01-24 | Green | Wisconsin | 55045 | 2712 | 17 |
959310 | 959310 | 2021-01-23 | Green | Wisconsin | 55045 | 2705 | 17 |
956064 | 956064 | 2021-01-22 | Green | Wisconsin | 55045 | 2683 | 15 |
952819 | 952819 | 2021-01-21 | Green | Wisconsin | 55045 | 2659 | 15 |
949574 | 949574 | 2021-01-20 | Green | Wisconsin | 55045 | 2649 | 15 |
946328 | 946328 | 2021-01-19 | Green | Wisconsin | 55045 | 2635 | 15 |
943081 | 943081 | 2021-01-18 | Green | Wisconsin | 55045 | 2630 | 15 |
939836 | 939836 | 2021-01-17 | Green | Wisconsin | 55045 | 2625 | 14 |
936591 | 936591 | 2021-01-16 | Green | Wisconsin | 55045 | 2614 | 14 |
933346 | 933346 | 2021-01-15 | Green | Wisconsin | 55045 | 2597 | 14 |
930101 | 930101 | 2021-01-14 | Green | Wisconsin | 55045 | 2578 | 14 |
926856 | 926856 | 2021-01-13 | Green | Wisconsin | 55045 | 2566 | 14 |
923610 | 923610 | 2021-01-12 | Green | Wisconsin | 55045 | 2542 | 14 |
920365 | 920365 | 2021-01-11 | Green | Wisconsin | 55045 | 2527 | 14 |
917120 | 917120 | 2021-01-10 | Green | Wisconsin | 55045 | 2523 | 14 |
913875 | 913875 | 2021-01-09 | Green | Wisconsin | 55045 | 2511 | 14 |
910630 | 910630 | 2021-01-08 | Green | Wisconsin | 55045 | 2489 | 14 |
907385 | 907385 | 2021-01-07 | Green | Wisconsin | 55045 | 2471 | 13 |
904139 | 904139 | 2021-01-06 | Green | Wisconsin | 55045 | 2459 | 13 |
900894 | 900894 | 2021-01-05 | Green | Wisconsin | 55045 | 2438 | 13 |
897649 | 897649 | 2021-01-04 | Green | Wisconsin | 55045 | 2438 | 12 |
894403 | 894403 | 2021-01-03 | Green | Wisconsin | 55045 | 2430 | 12 |
891157 | 891157 | 2021-01-02 | Green | Wisconsin | 55045 | 2430 | 12 |
887910 | 887910 | 2021-01-01 | Green | Wisconsin | 55045 | 2407 | 12 |
884665 | 884665 | 2020-12-31 | Green | Wisconsin | 55045 | 2392 | 12 |
881420 | 881420 | 2020-12-30 | Green | Wisconsin | 55045 | 2376 | 12 |
878175 | 878175 | 2020-12-29 | Green | Wisconsin | 55045 | 2340 | 12 |
874930 | 874930 | 2020-12-28 | Green | Wisconsin | 55045 | 2327 | 11 |
871685 | 871685 | 2020-12-27 | Green | Wisconsin | 55045 | 2318 | 11 |
868440 | 868440 | 2020-12-26 | Green | Wisconsin | 55045 | 2309 | 10 |
865195 | 865195 | 2020-12-25 | Green | Wisconsin | 55045 | 2296 | 10 |
861950 | 861950 | 2020-12-24 | Green | Wisconsin | 55045 | 2268 | 10 |
858705 | 858705 | 2020-12-23 | Green | Wisconsin | 55045 | 2245 | 10 |
855460 | 855460 | 2020-12-22 | Green | Wisconsin | 55045 | 2213 | 10 |
852215 | 852215 | 2020-12-21 | Green | Wisconsin | 55045 | 2206 | 10 |
848970 | 848970 | 2020-12-20 | Green | Wisconsin | 55045 | 2202 | 10 |
845725 | 845725 | 2020-12-19 | Green | Wisconsin | 55045 | 2181 | 9 |
842479 | 842479 | 2020-12-18 | Green | Wisconsin | 55045 | 2167 | 9 |
839234 | 839234 | 2020-12-17 | Green | Wisconsin | 55045 | 2130 | 9 |
835989 | 835989 | 2020-12-16 | Green | Wisconsin | 55045 | 2093 | 9 |
832743 | 832743 | 2020-12-15 | Green | Wisconsin | 55045 | 2071 | 9 |
829496 | 829496 | 2020-12-14 | Green | Wisconsin | 55045 | 2067 | 10 |
826250 | 826250 | 2020-12-13 | Green | Wisconsin | 55045 | 2057 | 9 |
823003 | 823003 | 2020-12-12 | Green | Wisconsin | 55045 | 2041 | 9 |
819757 | 819757 | 2020-12-11 | Green | Wisconsin | 55045 | 2005 | 9 |
816511 | 816511 | 2020-12-10 | Green | Wisconsin | 55045 | 1967 | 8 |
813265 | 813265 | 2020-12-09 | Green | Wisconsin | 55045 | 1954 | 8 |
810021 | 810021 | 2020-12-08 | Green | Wisconsin | 55045 | 1916 | 7 |
806776 | 806776 | 2020-12-07 | Green | Wisconsin | 55045 | 1905 | 7 |
803531 | 803531 | 2020-12-06 | Green | Wisconsin | 55045 | 1900 | 6 |
800286 | 800286 | 2020-12-05 | Green | Wisconsin | 55045 | 1889 | 6 |
797041 | 797041 | 2020-12-04 | Green | Wisconsin | 55045 | 1839 | 6 |
793796 | 793796 | 2020-12-03 | Green | Wisconsin | 55045 | 1797 | 6 |
790551 | 790551 | 2020-12-02 | Green | Wisconsin | 55045 | 1768 | 6 |
787306 | 787306 | 2020-12-01 | Green | Wisconsin | 55045 | 1726 | 6 |
784062 | 784062 | 2020-11-30 | Green | Wisconsin | 55045 | 1718 | 6 |
780817 | 780817 | 2020-11-29 | Green | Wisconsin | 55045 | 1702 | 6 |
777571 | 777571 | 2020-11-28 | Green | Wisconsin | 55045 | 1683 | 6 |
774326 | 774326 | 2020-11-27 | Green | Wisconsin | 55045 | 1673 | 6 |
771081 | 771081 | 2020-11-26 | Green | Wisconsin | 55045 | 1640 | 6 |
767835 | 767835 | 2020-11-25 | Green | Wisconsin | 55045 | 1627 | 6 |
764590 | 764590 | 2020-11-24 | Green | Wisconsin | 55045 | 1593 | 6 |
761345 | 761345 | 2020-11-23 | Green | Wisconsin | 55045 | 1580 | 6 |
758100 | 758100 | 2020-11-22 | Green | Wisconsin | 55045 | 1570 | 6 |
754853 | 754853 | 2020-11-21 | Green | Wisconsin | 55045 | 1547 | 6 |
751607 | 751607 | 2020-11-20 | Green | Wisconsin | 55045 | 1522 | 6 |
748361 | 748361 | 2020-11-19 | Green | Wisconsin | 55045 | 1502 | 6 |
745115 | 745115 | 2020-11-18 | Green | Wisconsin | 55045 | 1467 | 6 |
741868 | 741868 | 2020-11-17 | Green | Wisconsin | 55045 | 1445 | 5 |
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);