ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jackson" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923614 | 923614 | 2021-01-12 | Jackson | Wisconsin | 55053 | 2511 | 18 |
920369 | 920369 | 2021-01-11 | Jackson | Wisconsin | 55053 | 2507 | 18 |
917124 | 917124 | 2021-01-10 | Jackson | Wisconsin | 55053 | 2505 | 18 |
913879 | 913879 | 2021-01-09 | Jackson | Wisconsin | 55053 | 2501 | 18 |
910634 | 910634 | 2021-01-08 | Jackson | Wisconsin | 55053 | 2483 | 18 |
907389 | 907389 | 2021-01-07 | Jackson | Wisconsin | 55053 | 2476 | 18 |
904143 | 904143 | 2021-01-06 | Jackson | Wisconsin | 55053 | 2466 | 18 |
900898 | 900898 | 2021-01-05 | Jackson | Wisconsin | 55053 | 2452 | 18 |
897653 | 897653 | 2021-01-04 | Jackson | Wisconsin | 55053 | 2438 | 18 |
894407 | 894407 | 2021-01-03 | Jackson | Wisconsin | 55053 | 2436 | 18 |
891161 | 891161 | 2021-01-02 | Jackson | Wisconsin | 55053 | 2436 | 18 |
887914 | 887914 | 2021-01-01 | Jackson | Wisconsin | 55053 | 2413 | 18 |
884669 | 884669 | 2020-12-31 | Jackson | Wisconsin | 55053 | 2402 | 18 |
881424 | 881424 | 2020-12-30 | Jackson | Wisconsin | 55053 | 2399 | 17 |
878179 | 878179 | 2020-12-29 | Jackson | Wisconsin | 55053 | 2385 | 18 |
874934 | 874934 | 2020-12-28 | Jackson | Wisconsin | 55053 | 2362 | 16 |
871689 | 871689 | 2020-12-27 | Jackson | Wisconsin | 55053 | 2359 | 16 |
868444 | 868444 | 2020-12-26 | Jackson | Wisconsin | 55053 | 2361 | 16 |
865199 | 865199 | 2020-12-25 | Jackson | Wisconsin | 55053 | 2346 | 16 |
861954 | 861954 | 2020-12-24 | Jackson | Wisconsin | 55053 | 2337 | 15 |
858709 | 858709 | 2020-12-23 | Jackson | Wisconsin | 55053 | 2331 | 15 |
855464 | 855464 | 2020-12-22 | Jackson | Wisconsin | 55053 | 2280 | 13 |
852219 | 852219 | 2020-12-21 | Jackson | Wisconsin | 55053 | 2270 | 13 |
848974 | 848974 | 2020-12-20 | Jackson | Wisconsin | 55053 | 2262 | 13 |
845729 | 845729 | 2020-12-19 | Jackson | Wisconsin | 55053 | 2247 | 13 |
842483 | 842483 | 2020-12-18 | Jackson | Wisconsin | 55053 | 2169 | 12 |
839238 | 839238 | 2020-12-17 | Jackson | Wisconsin | 55053 | 2148 | 8 |
835993 | 835993 | 2020-12-16 | Jackson | Wisconsin | 55053 | 2130 | 6 |
832747 | 832747 | 2020-12-15 | Jackson | Wisconsin | 55053 | 2116 | 6 |
829500 | 829500 | 2020-12-14 | Jackson | Wisconsin | 55053 | 2096 | 6 |
826254 | 826254 | 2020-12-13 | Jackson | Wisconsin | 55053 | 2091 | 6 |
823007 | 823007 | 2020-12-12 | Jackson | Wisconsin | 55053 | 2085 | 6 |
819761 | 819761 | 2020-12-11 | Jackson | Wisconsin | 55053 | 2053 | 6 |
816515 | 816515 | 2020-12-10 | Jackson | Wisconsin | 55053 | 2041 | 6 |
813269 | 813269 | 2020-12-09 | Jackson | Wisconsin | 55053 | 2029 | 6 |
810025 | 810025 | 2020-12-08 | Jackson | Wisconsin | 55053 | 2006 | 6 |
806780 | 806780 | 2020-12-07 | Jackson | Wisconsin | 55053 | 1986 | 5 |
803535 | 803535 | 2020-12-06 | Jackson | Wisconsin | 55053 | 1980 | 5 |
800290 | 800290 | 2020-12-05 | Jackson | Wisconsin | 55053 | 1964 | 5 |
797045 | 797045 | 2020-12-04 | Jackson | Wisconsin | 55053 | 1823 | 5 |
793800 | 793800 | 2020-12-03 | Jackson | Wisconsin | 55053 | 1798 | 5 |
790555 | 790555 | 2020-12-02 | Jackson | Wisconsin | 55053 | 1775 | 5 |
787310 | 787310 | 2020-12-01 | Jackson | Wisconsin | 55053 | 1758 | 4 |
784066 | 784066 | 2020-11-30 | Jackson | Wisconsin | 55053 | 1737 | 4 |
780821 | 780821 | 2020-11-29 | Jackson | Wisconsin | 55053 | 1731 | 4 |
777575 | 777575 | 2020-11-28 | Jackson | Wisconsin | 55053 | 1716 | 4 |
774330 | 774330 | 2020-11-27 | Jackson | Wisconsin | 55053 | 1652 | 4 |
771085 | 771085 | 2020-11-26 | Jackson | Wisconsin | 55053 | 1652 | 4 |
767839 | 767839 | 2020-11-25 | Jackson | Wisconsin | 55053 | 1624 | 4 |
764594 | 764594 | 2020-11-24 | Jackson | Wisconsin | 55053 | 1614 | 4 |
761349 | 761349 | 2020-11-23 | Jackson | Wisconsin | 55053 | 1602 | 4 |
758104 | 758104 | 2020-11-22 | Jackson | Wisconsin | 55053 | 1592 | 4 |
754857 | 754857 | 2020-11-21 | Jackson | Wisconsin | 55053 | 1505 | 4 |
751611 | 751611 | 2020-11-20 | Jackson | Wisconsin | 55053 | 1447 | 4 |
748365 | 748365 | 2020-11-19 | Jackson | Wisconsin | 55053 | 1397 | 4 |
745119 | 745119 | 2020-11-18 | Jackson | Wisconsin | 55053 | 1379 | 4 |
741872 | 741872 | 2020-11-17 | Jackson | Wisconsin | 55053 | 1309 | 4 |
738625 | 738625 | 2020-11-16 | Jackson | Wisconsin | 55053 | 1278 | 3 |
735381 | 735381 | 2020-11-15 | Jackson | Wisconsin | 55053 | 1243 | 2 |
732135 | 732135 | 2020-11-14 | Jackson | Wisconsin | 55053 | 1190 | 2 |
728890 | 728890 | 2020-11-13 | Jackson | Wisconsin | 55053 | 1129 | 2 |
725647 | 725647 | 2020-11-12 | Jackson | Wisconsin | 55053 | 1040 | 2 |
722404 | 722404 | 2020-11-11 | Jackson | Wisconsin | 55053 | 985 | 2 |
719161 | 719161 | 2020-11-10 | Jackson | Wisconsin | 55053 | 944 | 2 |
715918 | 715918 | 2020-11-09 | Jackson | Wisconsin | 55053 | 922 | 2 |
712674 | 712674 | 2020-11-08 | Jackson | Wisconsin | 55053 | 901 | 2 |
709430 | 709430 | 2020-11-07 | Jackson | Wisconsin | 55053 | 857 | 2 |
706186 | 706186 | 2020-11-06 | Jackson | Wisconsin | 55053 | 781 | 2 |
702943 | 702943 | 2020-11-05 | Jackson | Wisconsin | 55053 | 757 | 2 |
699700 | 699700 | 2020-11-04 | Jackson | Wisconsin | 55053 | 729 | 2 |
696456 | 696456 | 2020-11-03 | Jackson | Wisconsin | 55053 | 674 | 2 |
693214 | 693214 | 2020-11-02 | Jackson | Wisconsin | 55053 | 612 | 2 |
689970 | 689970 | 2020-11-01 | Jackson | Wisconsin | 55053 | 609 | 2 |
686725 | 686725 | 2020-10-31 | Jackson | Wisconsin | 55053 | 598 | 1 |
683482 | 683482 | 2020-10-30 | Jackson | Wisconsin | 55053 | 572 | 1 |
680239 | 680239 | 2020-10-29 | Jackson | Wisconsin | 55053 | 552 | 1 |
676996 | 676996 | 2020-10-28 | Jackson | Wisconsin | 55053 | 501 | 1 |
673753 | 673753 | 2020-10-27 | Jackson | Wisconsin | 55053 | 479 | 1 |
670511 | 670511 | 2020-10-26 | Jackson | Wisconsin | 55053 | 471 | 1 |
667268 | 667268 | 2020-10-25 | Jackson | Wisconsin | 55053 | 446 | 1 |
664023 | 664023 | 2020-10-24 | Jackson | Wisconsin | 55053 | 369 | 1 |
660779 | 660779 | 2020-10-23 | Jackson | Wisconsin | 55053 | 347 | 1 |
657535 | 657535 | 2020-10-22 | Jackson | Wisconsin | 55053 | 331 | 1 |
654290 | 654290 | 2020-10-21 | Jackson | Wisconsin | 55053 | 314 | 1 |
651045 | 651045 | 2020-10-20 | Jackson | Wisconsin | 55053 | 304 | 1 |
647801 | 647801 | 2020-10-19 | Jackson | Wisconsin | 55053 | 285 | 1 |
644555 | 644555 | 2020-10-18 | Jackson | Wisconsin | 55053 | 261 | 1 |
641307 | 641307 | 2020-10-17 | Jackson | Wisconsin | 55053 | 261 | 1 |
638060 | 638060 | 2020-10-16 | Jackson | Wisconsin | 55053 | 261 | 1 |
634815 | 634815 | 2020-10-15 | Jackson | Wisconsin | 55053 | 252 | 1 |
631570 | 631570 | 2020-10-14 | Jackson | Wisconsin | 55053 | 230 | 1 |
628326 | 628326 | 2020-10-13 | Jackson | Wisconsin | 55053 | 223 | 1 |
625083 | 625083 | 2020-10-12 | Jackson | Wisconsin | 55053 | 215 | 1 |
621840 | 621840 | 2020-10-11 | Jackson | Wisconsin | 55053 | 215 | 1 |
618597 | 618597 | 2020-10-10 | Jackson | Wisconsin | 55053 | 209 | 1 |
615355 | 615355 | 2020-10-09 | Jackson | Wisconsin | 55053 | 207 | 1 |
612114 | 612114 | 2020-10-08 | Jackson | Wisconsin | 55053 | 199 | 1 |
608872 | 608872 | 2020-10-07 | Jackson | Wisconsin | 55053 | 194 | 1 |
605629 | 605629 | 2020-10-06 | Jackson | Wisconsin | 55053 | 186 | 1 |
602387 | 602387 | 2020-10-05 | Jackson | Wisconsin | 55053 | 182 | 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);