ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55009 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920347 | 920347 | 2021-01-11 | Brown | Wisconsin | 55009 | 29284 | 179 |
917102 | 917102 | 2021-01-10 | Brown | Wisconsin | 55009 | 29275 | 179 |
913857 | 913857 | 2021-01-09 | Brown | Wisconsin | 55009 | 29142 | 179 |
910612 | 910612 | 2021-01-08 | Brown | Wisconsin | 55009 | 28962 | 179 |
907367 | 907367 | 2021-01-07 | Brown | Wisconsin | 55009 | 28776 | 178 |
904121 | 904121 | 2021-01-06 | Brown | Wisconsin | 55009 | 28594 | 178 |
900876 | 900876 | 2021-01-05 | Brown | Wisconsin | 55009 | 28377 | 177 |
897631 | 897631 | 2021-01-04 | Brown | Wisconsin | 55009 | 28015 | 173 |
894385 | 894385 | 2021-01-03 | Brown | Wisconsin | 55009 | 28003 | 173 |
891139 | 891139 | 2021-01-02 | Brown | Wisconsin | 55009 | 27822 | 173 |
887892 | 887892 | 2021-01-01 | Brown | Wisconsin | 55009 | 27818 | 173 |
884647 | 884647 | 2020-12-31 | Brown | Wisconsin | 55009 | 27818 | 172 |
881402 | 881402 | 2020-12-30 | Brown | Wisconsin | 55009 | 27619 | 171 |
878157 | 878157 | 2020-12-29 | Brown | Wisconsin | 55009 | 27458 | 171 |
874912 | 874912 | 2020-12-28 | Brown | Wisconsin | 55009 | 27172 | 171 |
871667 | 871667 | 2020-12-27 | Brown | Wisconsin | 55009 | 27126 | 171 |
868422 | 868422 | 2020-12-26 | Brown | Wisconsin | 55009 | 27004 | 171 |
865177 | 865177 | 2020-12-25 | Brown | Wisconsin | 55009 | 27003 | 171 |
861932 | 861932 | 2020-12-24 | Brown | Wisconsin | 55009 | 26997 | 171 |
858687 | 858687 | 2020-12-23 | Brown | Wisconsin | 55009 | 26876 | 170 |
855442 | 855442 | 2020-12-22 | Brown | Wisconsin | 55009 | 26712 | 170 |
852197 | 852197 | 2020-12-21 | Brown | Wisconsin | 55009 | 26464 | 167 |
848952 | 848952 | 2020-12-20 | Brown | Wisconsin | 55009 | 26460 | 166 |
845707 | 845707 | 2020-12-19 | Brown | Wisconsin | 55009 | 26382 | 165 |
842461 | 842461 | 2020-12-18 | Brown | Wisconsin | 55009 | 26276 | 165 |
839216 | 839216 | 2020-12-17 | Brown | Wisconsin | 55009 | 26067 | 165 |
835971 | 835971 | 2020-12-16 | Brown | Wisconsin | 55009 | 25997 | 165 |
832725 | 832725 | 2020-12-15 | Brown | Wisconsin | 55009 | 25813 | 163 |
829478 | 829478 | 2020-12-14 | Brown | Wisconsin | 55009 | 25550 | 160 |
826232 | 826232 | 2020-12-13 | Brown | Wisconsin | 55009 | 25542 | 160 |
822985 | 822985 | 2020-12-12 | Brown | Wisconsin | 55009 | 25479 | 159 |
819739 | 819739 | 2020-12-11 | Brown | Wisconsin | 55009 | 25336 | 159 |
816493 | 816493 | 2020-12-10 | Brown | Wisconsin | 55009 | 25162 | 159 |
813247 | 813247 | 2020-12-09 | Brown | Wisconsin | 55009 | 24945 | 159 |
810003 | 810003 | 2020-12-08 | Brown | Wisconsin | 55009 | 24697 | 159 |
806758 | 806758 | 2020-12-07 | Brown | Wisconsin | 55009 | 24461 | 159 |
803513 | 803513 | 2020-12-06 | Brown | Wisconsin | 55009 | 24457 | 158 |
800268 | 800268 | 2020-12-05 | Brown | Wisconsin | 55009 | 24375 | 158 |
797023 | 797023 | 2020-12-04 | Brown | Wisconsin | 55009 | 24180 | 156 |
793778 | 793778 | 2020-12-03 | Brown | Wisconsin | 55009 | 23986 | 154 |
790533 | 790533 | 2020-12-02 | Brown | Wisconsin | 55009 | 23724 | 149 |
787288 | 787288 | 2020-12-01 | Brown | Wisconsin | 55009 | 23512 | 148 |
784044 | 784044 | 2020-11-30 | Brown | Wisconsin | 55009 | 23219 | 143 |
780799 | 780799 | 2020-11-29 | Brown | Wisconsin | 55009 | 23212 | 143 |
777553 | 777553 | 2020-11-28 | Brown | Wisconsin | 55009 | 23062 | 143 |
774308 | 774308 | 2020-11-27 | Brown | Wisconsin | 55009 | 22933 | 139 |
771063 | 771063 | 2020-11-26 | Brown | Wisconsin | 55009 | 22931 | 139 |
767817 | 767817 | 2020-11-25 | Brown | Wisconsin | 55009 | 22677 | 134 |
764572 | 764572 | 2020-11-24 | Brown | Wisconsin | 55009 | 22349 | 133 |
761327 | 761327 | 2020-11-23 | Brown | Wisconsin | 55009 | 21793 | 131 |
758082 | 758082 | 2020-11-22 | Brown | Wisconsin | 55009 | 21680 | 131 |
754835 | 754835 | 2020-11-21 | Brown | Wisconsin | 55009 | 21579 | 131 |
751589 | 751589 | 2020-11-20 | Brown | Wisconsin | 55009 | 21354 | 131 |
748343 | 748343 | 2020-11-19 | Brown | Wisconsin | 55009 | 21047 | 130 |
745097 | 745097 | 2020-11-18 | Brown | Wisconsin | 55009 | 20782 | 128 |
741850 | 741850 | 2020-11-17 | Brown | Wisconsin | 55009 | 20565 | 126 |
738603 | 738603 | 2020-11-16 | Brown | Wisconsin | 55009 | 20336 | 123 |
735359 | 735359 | 2020-11-15 | Brown | Wisconsin | 55009 | 20312 | 123 |
732113 | 732113 | 2020-11-14 | Brown | Wisconsin | 55009 | 20227 | 123 |
728868 | 728868 | 2020-11-13 | Brown | Wisconsin | 55009 | 19926 | 121 |
725625 | 725625 | 2020-11-12 | Brown | Wisconsin | 55009 | 19627 | 120 |
722382 | 722382 | 2020-11-11 | Brown | Wisconsin | 55009 | 19280 | 119 |
719139 | 719139 | 2020-11-10 | Brown | Wisconsin | 55009 | 18667 | 117 |
715896 | 715896 | 2020-11-09 | Brown | Wisconsin | 55009 | 18411 | 113 |
712652 | 712652 | 2020-11-08 | Brown | Wisconsin | 55009 | 18384 | 113 |
709408 | 709408 | 2020-11-07 | Brown | Wisconsin | 55009 | 18281 | 113 |
706164 | 706164 | 2020-11-06 | Brown | Wisconsin | 55009 | 17927 | 113 |
702921 | 702921 | 2020-11-05 | Brown | Wisconsin | 55009 | 17681 | 108 |
699678 | 699678 | 2020-11-04 | Brown | Wisconsin | 55009 | 17376 | 107 |
696434 | 696434 | 2020-11-03 | Brown | Wisconsin | 55009 | 16937 | 106 |
693192 | 693192 | 2020-11-02 | Brown | Wisconsin | 55009 | 16752 | 106 |
689948 | 689948 | 2020-11-01 | Brown | Wisconsin | 55009 | 16581 | 106 |
686703 | 686703 | 2020-10-31 | Brown | Wisconsin | 55009 | 16484 | 106 |
683460 | 683460 | 2020-10-30 | Brown | Wisconsin | 55009 | 16341 | 104 |
680217 | 680217 | 2020-10-29 | Brown | Wisconsin | 55009 | 16084 | 107 |
676974 | 676974 | 2020-10-28 | Brown | Wisconsin | 55009 | 15710 | 100 |
673731 | 673731 | 2020-10-27 | Brown | Wisconsin | 55009 | 15432 | 96 |
670489 | 670489 | 2020-10-26 | Brown | Wisconsin | 55009 | 14903 | 91 |
667246 | 667246 | 2020-10-25 | Brown | Wisconsin | 55009 | 14887 | 91 |
664001 | 664001 | 2020-10-24 | Brown | Wisconsin | 55009 | 14724 | 91 |
660757 | 660757 | 2020-10-23 | Brown | Wisconsin | 55009 | 14556 | 91 |
657513 | 657513 | 2020-10-22 | Brown | Wisconsin | 55009 | 14238 | 88 |
654268 | 654268 | 2020-10-21 | Brown | Wisconsin | 55009 | 13912 | 88 |
651023 | 651023 | 2020-10-20 | Brown | Wisconsin | 55009 | 13666 | 87 |
647779 | 647779 | 2020-10-19 | Brown | Wisconsin | 55009 | 13497 | 86 |
644533 | 644533 | 2020-10-18 | Brown | Wisconsin | 55009 | 13098 | 84 |
641285 | 641285 | 2020-10-17 | Brown | Wisconsin | 55009 | 13098 | 84 |
638038 | 638038 | 2020-10-16 | Brown | Wisconsin | 55009 | 13098 | 84 |
634793 | 634793 | 2020-10-15 | Brown | Wisconsin | 55009 | 12768 | 82 |
631548 | 631548 | 2020-10-14 | Brown | Wisconsin | 55009 | 12462 | 79 |
628304 | 628304 | 2020-10-13 | Brown | Wisconsin | 55009 | 12282 | 78 |
625061 | 625061 | 2020-10-12 | Brown | Wisconsin | 55009 | 12032 | 75 |
621818 | 621818 | 2020-10-11 | Brown | Wisconsin | 55009 | 12029 | 75 |
618575 | 618575 | 2020-10-10 | Brown | Wisconsin | 55009 | 11936 | 75 |
615333 | 615333 | 2020-10-09 | Brown | Wisconsin | 55009 | 11610 | 74 |
612092 | 612092 | 2020-10-08 | Brown | Wisconsin | 55009 | 11389 | 72 |
608850 | 608850 | 2020-10-07 | Brown | Wisconsin | 55009 | 11067 | 72 |
605607 | 605607 | 2020-10-06 | Brown | Wisconsin | 55009 | 10812 | 69 |
602365 | 602365 | 2020-10-05 | Brown | Wisconsin | 55009 | 10682 | 69 |
599122 | 599122 | 2020-10-04 | Brown | Wisconsin | 55009 | 10653 | 69 |
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);