ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Racine" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056708 | 1056708 | 2021-02-22 | Racine | Wisconsin | 55101 | 22791 | 343 |
1053462 | 1053462 | 2021-02-21 | Racine | Wisconsin | 55101 | 22788 | 343 |
1050215 | 1050215 | 2021-02-20 | Racine | Wisconsin | 55101 | 22766 | 343 |
1046968 | 1046968 | 2021-02-19 | Racine | Wisconsin | 55101 | 22743 | 343 |
1043723 | 1043723 | 2021-02-18 | Racine | Wisconsin | 55101 | 22727 | 343 |
1040478 | 1040478 | 2021-02-17 | Racine | Wisconsin | 55101 | 22715 | 343 |
1037233 | 1037233 | 2021-02-16 | Racine | Wisconsin | 55101 | 22697 | 343 |
1033988 | 1033988 | 2021-02-15 | Racine | Wisconsin | 55101 | 22686 | 343 |
1030742 | 1030742 | 2021-02-14 | Racine | Wisconsin | 55101 | 22680 | 343 |
1027495 | 1027495 | 2021-02-13 | Racine | Wisconsin | 55101 | 22669 | 343 |
1024250 | 1024250 | 2021-02-12 | Racine | Wisconsin | 55101 | 22637 | 343 |
1021005 | 1021005 | 2021-02-11 | Racine | Wisconsin | 55101 | 22619 | 343 |
1017760 | 1017760 | 2021-02-10 | Racine | Wisconsin | 55101 | 22581 | 341 |
1014515 | 1014515 | 2021-02-09 | Racine | Wisconsin | 55101 | 22545 | 337 |
1011270 | 1011270 | 2021-02-08 | Racine | Wisconsin | 55101 | 22519 | 330 |
1008024 | 1008024 | 2021-02-07 | Racine | Wisconsin | 55101 | 22517 | 330 |
1004778 | 1004778 | 2021-02-06 | Racine | Wisconsin | 55101 | 22497 | 330 |
1001532 | 1001532 | 2021-02-05 | Racine | Wisconsin | 55101 | 22461 | 328 |
998286 | 998286 | 2021-02-04 | Racine | Wisconsin | 55101 | 22433 | 328 |
995040 | 995040 | 2021-02-03 | Racine | Wisconsin | 55101 | 22400 | 328 |
991794 | 991794 | 2021-02-02 | Racine | Wisconsin | 55101 | 22357 | 328 |
988548 | 988548 | 2021-02-01 | Racine | Wisconsin | 55101 | 22331 | 327 |
985301 | 985301 | 2021-01-31 | Racine | Wisconsin | 55101 | 22309 | 327 |
982054 | 982054 | 2021-01-30 | Racine | Wisconsin | 55101 | 22276 | 327 |
978808 | 978808 | 2021-01-29 | Racine | Wisconsin | 55101 | 22222 | 323 |
975563 | 975563 | 2021-01-28 | Racine | Wisconsin | 55101 | 22181 | 321 |
972318 | 972318 | 2021-01-27 | Racine | Wisconsin | 55101 | 22139 | 318 |
969073 | 969073 | 2021-01-26 | Racine | Wisconsin | 55101 | 22097 | 317 |
965829 | 965829 | 2021-01-25 | Racine | Wisconsin | 55101 | 22011 | 313 |
962584 | 962584 | 2021-01-24 | Racine | Wisconsin | 55101 | 22006 | 313 |
959339 | 959339 | 2021-01-23 | Racine | Wisconsin | 55101 | 21970 | 313 |
956093 | 956093 | 2021-01-22 | Racine | Wisconsin | 55101 | 21887 | 313 |
952848 | 952848 | 2021-01-21 | Racine | Wisconsin | 55101 | 21816 | 300 |
949603 | 949603 | 2021-01-20 | Racine | Wisconsin | 55101 | 21631 | 299 |
946357 | 946357 | 2021-01-19 | Racine | Wisconsin | 55101 | 21574 | 298 |
943110 | 943110 | 2021-01-18 | Racine | Wisconsin | 55101 | 21488 | 293 |
939865 | 939865 | 2021-01-17 | Racine | Wisconsin | 55101 | 21478 | 293 |
936620 | 936620 | 2021-01-16 | Racine | Wisconsin | 55101 | 21398 | 293 |
933375 | 933375 | 2021-01-15 | Racine | Wisconsin | 55101 | 21311 | 291 |
930130 | 930130 | 2021-01-14 | Racine | Wisconsin | 55101 | 21221 | 290 |
926885 | 926885 | 2021-01-13 | Racine | Wisconsin | 55101 | 21126 | 285 |
923639 | 923639 | 2021-01-12 | Racine | Wisconsin | 55101 | 21031 | 283 |
920394 | 920394 | 2021-01-11 | Racine | Wisconsin | 55101 | 20865 | 282 |
917149 | 917149 | 2021-01-10 | Racine | Wisconsin | 55101 | 20826 | 282 |
913904 | 913904 | 2021-01-09 | Racine | Wisconsin | 55101 | 20784 | 282 |
910659 | 910659 | 2021-01-08 | Racine | Wisconsin | 55101 | 20651 | 278 |
907414 | 907414 | 2021-01-07 | Racine | Wisconsin | 55101 | 20502 | 278 |
904168 | 904168 | 2021-01-06 | Racine | Wisconsin | 55101 | 20314 | 278 |
900923 | 900923 | 2021-01-05 | Racine | Wisconsin | 55101 | 20184 | 267 |
897678 | 897678 | 2021-01-04 | Racine | Wisconsin | 55101 | 19895 | 259 |
894432 | 894432 | 2021-01-03 | Racine | Wisconsin | 55101 | 19878 | 259 |
891186 | 891186 | 2021-01-02 | Racine | Wisconsin | 55101 | 19672 | 259 |
887939 | 887939 | 2021-01-01 | Racine | Wisconsin | 55101 | 19569 | 259 |
884694 | 884694 | 2020-12-31 | Racine | Wisconsin | 55101 | 19548 | 259 |
881449 | 881449 | 2020-12-30 | Racine | Wisconsin | 55101 | 19350 | 256 |
878204 | 878204 | 2020-12-29 | Racine | Wisconsin | 55101 | 19181 | 256 |
874959 | 874959 | 2020-12-28 | Racine | Wisconsin | 55101 | 19040 | 256 |
871714 | 871714 | 2020-12-27 | Racine | Wisconsin | 55101 | 19018 | 256 |
868469 | 868469 | 2020-12-26 | Racine | Wisconsin | 55101 | 18848 | 256 |
865224 | 865224 | 2020-12-25 | Racine | Wisconsin | 55101 | 18830 | 256 |
861979 | 861979 | 2020-12-24 | Racine | Wisconsin | 55101 | 18829 | 256 |
858734 | 858734 | 2020-12-23 | Racine | Wisconsin | 55101 | 18682 | 251 |
855489 | 855489 | 2020-12-22 | Racine | Wisconsin | 55101 | 18519 | 249 |
852244 | 852244 | 2020-12-21 | Racine | Wisconsin | 55101 | 18340 | 246 |
848999 | 848999 | 2020-12-20 | Racine | Wisconsin | 55101 | 18332 | 246 |
845754 | 845754 | 2020-12-19 | Racine | Wisconsin | 55101 | 18279 | 246 |
842508 | 842508 | 2020-12-18 | Racine | Wisconsin | 55101 | 18108 | 246 |
839263 | 839263 | 2020-12-17 | Racine | Wisconsin | 55101 | 17970 | 240 |
836018 | 836018 | 2020-12-16 | Racine | Wisconsin | 55101 | 17786 | 232 |
832772 | 832772 | 2020-12-15 | Racine | Wisconsin | 55101 | 17702 | 231 |
829525 | 829525 | 2020-12-14 | Racine | Wisconsin | 55101 | 17474 | 227 |
826279 | 826279 | 2020-12-13 | Racine | Wisconsin | 55101 | 17413 | 227 |
823032 | 823032 | 2020-12-12 | Racine | Wisconsin | 55101 | 17312 | 227 |
819786 | 819786 | 2020-12-11 | Racine | Wisconsin | 55101 | 17078 | 220 |
816540 | 816540 | 2020-12-10 | Racine | Wisconsin | 55101 | 16952 | 220 |
813294 | 813294 | 2020-12-09 | Racine | Wisconsin | 55101 | 16732 | 216 |
810050 | 810050 | 2020-12-08 | Racine | Wisconsin | 55101 | 16601 | 207 |
806805 | 806805 | 2020-12-07 | Racine | Wisconsin | 55101 | 16430 | 203 |
803560 | 803560 | 2020-12-06 | Racine | Wisconsin | 55101 | 16400 | 203 |
800315 | 800315 | 2020-12-05 | Racine | Wisconsin | 55101 | 16329 | 203 |
797070 | 797070 | 2020-12-04 | Racine | Wisconsin | 55101 | 16074 | 194 |
793825 | 793825 | 2020-12-03 | Racine | Wisconsin | 55101 | 15906 | 185 |
790580 | 790580 | 2020-12-02 | Racine | Wisconsin | 55101 | 15697 | 183 |
787335 | 787335 | 2020-12-01 | Racine | Wisconsin | 55101 | 15580 | 175 |
784091 | 784091 | 2020-11-30 | Racine | Wisconsin | 55101 | 15482 | 169 |
780846 | 780846 | 2020-11-29 | Racine | Wisconsin | 55101 | 15397 | 169 |
777600 | 777600 | 2020-11-28 | Racine | Wisconsin | 55101 | 15203 | 168 |
774355 | 774355 | 2020-11-27 | Racine | Wisconsin | 55101 | 15121 | 168 |
771110 | 771110 | 2020-11-26 | Racine | Wisconsin | 55101 | 15120 | 168 |
767864 | 767864 | 2020-11-25 | Racine | Wisconsin | 55101 | 14916 | 168 |
764619 | 764619 | 2020-11-24 | Racine | Wisconsin | 55101 | 14671 | 167 |
761374 | 761374 | 2020-11-23 | Racine | Wisconsin | 55101 | 14420 | 152 |
758129 | 758129 | 2020-11-22 | Racine | Wisconsin | 55101 | 14362 | 152 |
754882 | 754882 | 2020-11-21 | Racine | Wisconsin | 55101 | 14206 | 152 |
751636 | 751636 | 2020-11-20 | Racine | Wisconsin | 55101 | 13838 | 151 |
748390 | 748390 | 2020-11-19 | Racine | Wisconsin | 55101 | 13501 | 149 |
745144 | 745144 | 2020-11-18 | Racine | Wisconsin | 55101 | 13245 | 144 |
741897 | 741897 | 2020-11-17 | Racine | Wisconsin | 55101 | 12987 | 143 |
738650 | 738650 | 2020-11-16 | Racine | Wisconsin | 55101 | 12534 | 143 |
735406 | 735406 | 2020-11-15 | Racine | Wisconsin | 55101 | 12423 | 143 |
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);