ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rock" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923641 | 923641 | 2021-01-12 | Rock | Wisconsin | 55105 | 14089 | 134 |
920396 | 920396 | 2021-01-11 | Rock | Wisconsin | 55105 | 13975 | 131 |
917151 | 917151 | 2021-01-10 | Rock | Wisconsin | 55105 | 13919 | 131 |
913906 | 913906 | 2021-01-09 | Rock | Wisconsin | 55105 | 13887 | 131 |
910661 | 910661 | 2021-01-08 | Rock | Wisconsin | 55105 | 13770 | 131 |
907416 | 907416 | 2021-01-07 | Rock | Wisconsin | 55105 | 13634 | 128 |
904170 | 904170 | 2021-01-06 | Rock | Wisconsin | 55105 | 13516 | 128 |
900925 | 900925 | 2021-01-05 | Rock | Wisconsin | 55105 | 13411 | 127 |
897680 | 897680 | 2021-01-04 | Rock | Wisconsin | 55105 | 13267 | 125 |
894434 | 894434 | 2021-01-03 | Rock | Wisconsin | 55105 | 13216 | 126 |
891188 | 891188 | 2021-01-02 | Rock | Wisconsin | 55105 | 13175 | 126 |
887941 | 887941 | 2021-01-01 | Rock | Wisconsin | 55105 | 13134 | 126 |
884696 | 884696 | 2020-12-31 | Rock | Wisconsin | 55105 | 13032 | 126 |
881451 | 881451 | 2020-12-30 | Rock | Wisconsin | 55105 | 12895 | 124 |
878206 | 878206 | 2020-12-29 | Rock | Wisconsin | 55105 | 12776 | 123 |
874961 | 874961 | 2020-12-28 | Rock | Wisconsin | 55105 | 12680 | 121 |
871716 | 871716 | 2020-12-27 | Rock | Wisconsin | 55105 | 12625 | 120 |
868471 | 868471 | 2020-12-26 | Rock | Wisconsin | 55105 | 12500 | 119 |
865226 | 865226 | 2020-12-25 | Rock | Wisconsin | 55105 | 12492 | 119 |
861981 | 861981 | 2020-12-24 | Rock | Wisconsin | 55105 | 12421 | 119 |
858736 | 858736 | 2020-12-23 | Rock | Wisconsin | 55105 | 12338 | 116 |
855491 | 855491 | 2020-12-22 | Rock | Wisconsin | 55105 | 12256 | 114 |
852246 | 852246 | 2020-12-21 | Rock | Wisconsin | 55105 | 12194 | 112 |
849001 | 849001 | 2020-12-20 | Rock | Wisconsin | 55105 | 12140 | 112 |
845756 | 845756 | 2020-12-19 | Rock | Wisconsin | 55105 | 12075 | 110 |
842510 | 842510 | 2020-12-18 | Rock | Wisconsin | 55105 | 11951 | 109 |
839265 | 839265 | 2020-12-17 | Rock | Wisconsin | 55105 | 11820 | 106 |
836020 | 836020 | 2020-12-16 | Rock | Wisconsin | 55105 | 11625 | 107 |
832774 | 832774 | 2020-12-15 | Rock | Wisconsin | 55105 | 11586 | 107 |
829527 | 829527 | 2020-12-14 | Rock | Wisconsin | 55105 | 11552 | 106 |
826281 | 826281 | 2020-12-13 | Rock | Wisconsin | 55105 | 11517 | 105 |
823034 | 823034 | 2020-12-12 | Rock | Wisconsin | 55105 | 11265 | 105 |
819788 | 819788 | 2020-12-11 | Rock | Wisconsin | 55105 | 11053 | 104 |
816542 | 816542 | 2020-12-10 | Rock | Wisconsin | 55105 | 10910 | 103 |
813296 | 813296 | 2020-12-09 | Rock | Wisconsin | 55105 | 10809 | 102 |
810052 | 810052 | 2020-12-08 | Rock | Wisconsin | 55105 | 10715 | 102 |
806807 | 806807 | 2020-12-07 | Rock | Wisconsin | 55105 | 10659 | 101 |
803562 | 803562 | 2020-12-06 | Rock | Wisconsin | 55105 | 10590 | 101 |
800317 | 800317 | 2020-12-05 | Rock | Wisconsin | 55105 | 10421 | 101 |
797072 | 797072 | 2020-12-04 | Rock | Wisconsin | 55105 | 10348 | 100 |
793827 | 793827 | 2020-12-03 | Rock | Wisconsin | 55105 | 10141 | 93 |
790582 | 790582 | 2020-12-02 | Rock | Wisconsin | 55105 | 9999 | 93 |
787337 | 787337 | 2020-12-01 | Rock | Wisconsin | 55105 | 9936 | 90 |
784093 | 784093 | 2020-11-30 | Rock | Wisconsin | 55105 | 9872 | 85 |
780848 | 780848 | 2020-11-29 | Rock | Wisconsin | 55105 | 9795 | 84 |
777602 | 777602 | 2020-11-28 | Rock | Wisconsin | 55105 | 9708 | 84 |
774357 | 774357 | 2020-11-27 | Rock | Wisconsin | 55105 | 9412 | 80 |
771112 | 771112 | 2020-11-26 | Rock | Wisconsin | 55105 | 9413 | 80 |
767866 | 767866 | 2020-11-25 | Rock | Wisconsin | 55105 | 9231 | 76 |
764621 | 764621 | 2020-11-24 | Rock | Wisconsin | 55105 | 9156 | 76 |
761376 | 761376 | 2020-11-23 | Rock | Wisconsin | 55105 | 9059 | 71 |
758131 | 758131 | 2020-11-22 | Rock | Wisconsin | 55105 | 8979 | 71 |
754884 | 754884 | 2020-11-21 | Rock | Wisconsin | 55105 | 8824 | 71 |
751638 | 751638 | 2020-11-20 | Rock | Wisconsin | 55105 | 8554 | 70 |
748392 | 748392 | 2020-11-19 | Rock | Wisconsin | 55105 | 8468 | 64 |
745146 | 745146 | 2020-11-18 | Rock | Wisconsin | 55105 | 8382 | 62 |
741899 | 741899 | 2020-11-17 | Rock | Wisconsin | 55105 | 8294 | 62 |
738652 | 738652 | 2020-11-16 | Rock | Wisconsin | 55105 | 8184 | 62 |
735408 | 735408 | 2020-11-15 | Rock | Wisconsin | 55105 | 7995 | 62 |
732162 | 732162 | 2020-11-14 | Rock | Wisconsin | 55105 | 7698 | 61 |
728917 | 728917 | 2020-11-13 | Rock | Wisconsin | 55105 | 7546 | 60 |
725674 | 725674 | 2020-11-12 | Rock | Wisconsin | 55105 | 7396 | 60 |
722431 | 722431 | 2020-11-11 | Rock | Wisconsin | 55105 | 7241 | 59 |
719188 | 719188 | 2020-11-10 | Rock | Wisconsin | 55105 | 7089 | 57 |
715945 | 715945 | 2020-11-09 | Rock | Wisconsin | 55105 | 7023 | 57 |
712701 | 712701 | 2020-11-08 | Rock | Wisconsin | 55105 | 6884 | 56 |
709457 | 709457 | 2020-11-07 | Rock | Wisconsin | 55105 | 6653 | 55 |
706213 | 706213 | 2020-11-06 | Rock | Wisconsin | 55105 | 6455 | 55 |
702970 | 702970 | 2020-11-05 | Rock | Wisconsin | 55105 | 6358 | 50 |
699727 | 699727 | 2020-11-04 | Rock | Wisconsin | 55105 | 6241 | 49 |
696483 | 696483 | 2020-11-03 | Rock | Wisconsin | 55105 | 6139 | 48 |
693241 | 693241 | 2020-11-02 | Rock | Wisconsin | 55105 | 6043 | 48 |
689997 | 689997 | 2020-11-01 | Rock | Wisconsin | 55105 | 5957 | 48 |
686752 | 686752 | 2020-10-31 | Rock | Wisconsin | 55105 | 5796 | 48 |
683509 | 683509 | 2020-10-30 | Rock | Wisconsin | 55105 | 5653 | 48 |
680266 | 680266 | 2020-10-29 | Rock | Wisconsin | 55105 | 5428 | 48 |
677023 | 677023 | 2020-10-28 | Rock | Wisconsin | 55105 | 5365 | 46 |
673780 | 673780 | 2020-10-27 | Rock | Wisconsin | 55105 | 5305 | 46 |
670538 | 670538 | 2020-10-26 | Rock | Wisconsin | 55105 | 5150 | 43 |
667295 | 667295 | 2020-10-25 | Rock | Wisconsin | 55105 | 4960 | 43 |
664050 | 664050 | 2020-10-24 | Rock | Wisconsin | 55105 | 4833 | 43 |
660806 | 660806 | 2020-10-23 | Rock | Wisconsin | 55105 | 4745 | 42 |
657562 | 657562 | 2020-10-22 | Rock | Wisconsin | 55105 | 4677 | 40 |
654317 | 654317 | 2020-10-21 | Rock | Wisconsin | 55105 | 4514 | 40 |
651072 | 651072 | 2020-10-20 | Rock | Wisconsin | 55105 | 4413 | 40 |
647828 | 647828 | 2020-10-19 | Rock | Wisconsin | 55105 | 4328 | 39 |
644582 | 644582 | 2020-10-18 | Rock | Wisconsin | 55105 | 4042 | 38 |
641334 | 641334 | 2020-10-17 | Rock | Wisconsin | 55105 | 4042 | 38 |
638087 | 638087 | 2020-10-16 | Rock | Wisconsin | 55105 | 4042 | 38 |
634842 | 634842 | 2020-10-15 | Rock | Wisconsin | 55105 | 3844 | 37 |
631597 | 631597 | 2020-10-14 | Rock | Wisconsin | 55105 | 3747 | 37 |
628353 | 628353 | 2020-10-13 | Rock | Wisconsin | 55105 | 3686 | 36 |
625110 | 625110 | 2020-10-12 | Rock | Wisconsin | 55105 | 3629 | 36 |
621867 | 621867 | 2020-10-11 | Rock | Wisconsin | 55105 | 3486 | 36 |
618624 | 618624 | 2020-10-10 | Rock | Wisconsin | 55105 | 3416 | 36 |
615382 | 615382 | 2020-10-09 | Rock | Wisconsin | 55105 | 3311 | 34 |
612141 | 612141 | 2020-10-08 | Rock | Wisconsin | 55105 | 3205 | 34 |
608899 | 608899 | 2020-10-07 | Rock | Wisconsin | 55105 | 3138 | 34 |
605656 | 605656 | 2020-10-06 | Rock | Wisconsin | 55105 | 3076 | 33 |
602414 | 602414 | 2020-10-05 | Rock | Wisconsin | 55105 | 3063 | 33 |
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);