ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 55101 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199562 | 1199562 | 2021-04-07 | Racine | Wisconsin | 55101 | 23683 | 364 |
1196313 | 1196313 | 2021-04-06 | Racine | Wisconsin | 55101 | 23663 | 364 |
1193065 | 1193065 | 2021-04-05 | Racine | Wisconsin | 55101 | 23614 | 364 |
1189815 | 1189815 | 2021-04-04 | Racine | Wisconsin | 55101 | 23614 | 364 |
1186568 | 1186568 | 2021-04-03 | Racine | Wisconsin | 55101 | 23587 | 364 |
1183321 | 1183321 | 2021-04-02 | Racine | Wisconsin | 55101 | 23559 | 364 |
1180074 | 1180074 | 2021-04-01 | Racine | Wisconsin | 55101 | 23527 | 364 |
1176827 | 1176827 | 2021-03-31 | Racine | Wisconsin | 55101 | 23490 | 363 |
1173580 | 1173580 | 2021-03-30 | Racine | Wisconsin | 55101 | 23465 | 363 |
1170333 | 1170333 | 2021-03-29 | Racine | Wisconsin | 55101 | 23427 | 361 |
1167085 | 1167085 | 2021-03-28 | Racine | Wisconsin | 55101 | 23416 | 361 |
1163837 | 1163837 | 2021-03-27 | Racine | Wisconsin | 55101 | 23395 | 361 |
1160589 | 1160589 | 2021-03-26 | Racine | Wisconsin | 55101 | 23368 | 361 |
1157341 | 1157341 | 2021-03-25 | Racine | Wisconsin | 55101 | 23344 | 361 |
1154094 | 1154094 | 2021-03-24 | Racine | Wisconsin | 55101 | 23329 | 361 |
1150847 | 1150847 | 2021-03-23 | Racine | Wisconsin | 55101 | 23267 | 361 |
1147600 | 1147600 | 2021-03-22 | Racine | Wisconsin | 55101 | 23267 | 361 |
1144353 | 1144353 | 2021-03-21 | Racine | Wisconsin | 55101 | 23261 | 361 |
1141106 | 1141106 | 2021-03-20 | Racine | Wisconsin | 55101 | 23245 | 361 |
1137860 | 1137860 | 2021-03-19 | Racine | Wisconsin | 55101 | 23234 | 360 |
1134614 | 1134614 | 2021-03-18 | Racine | Wisconsin | 55101 | 23220 | 358 |
1131366 | 1131366 | 2021-03-17 | Racine | Wisconsin | 55101 | 23203 | 358 |
1128119 | 1128119 | 2021-03-16 | Racine | Wisconsin | 55101 | 23197 | 356 |
1124873 | 1124873 | 2021-03-15 | Racine | Wisconsin | 55101 | 23183 | 355 |
1121627 | 1121627 | 2021-03-14 | Racine | Wisconsin | 55101 | 23164 | 355 |
1118380 | 1118380 | 2021-03-13 | Racine | Wisconsin | 55101 | 23162 | 355 |
1115133 | 1115133 | 2021-03-12 | Racine | Wisconsin | 55101 | 23141 | 355 |
1111887 | 1111887 | 2021-03-11 | Racine | Wisconsin | 55101 | 23111 | 355 |
1108641 | 1108641 | 2021-03-10 | Racine | Wisconsin | 55101 | 23094 | 353 |
1105395 | 1105395 | 2021-03-09 | Racine | Wisconsin | 55101 | 23067 | 353 |
1102149 | 1102149 | 2021-03-08 | Racine | Wisconsin | 55101 | 23057 | 353 |
1098903 | 1098903 | 2021-03-07 | Racine | Wisconsin | 55101 | 23057 | 353 |
1095655 | 1095655 | 2021-03-06 | Racine | Wisconsin | 55101 | 23045 | 353 |
1092409 | 1092409 | 2021-03-05 | Racine | Wisconsin | 55101 | 23036 | 352 |
1089163 | 1089163 | 2021-03-04 | Racine | Wisconsin | 55101 | 23019 | 352 |
1085918 | 1085918 | 2021-03-03 | Racine | Wisconsin | 55101 | 22996 | 352 |
1082672 | 1082672 | 2021-03-02 | Racine | Wisconsin | 55101 | 22969 | 350 |
1079426 | 1079426 | 2021-03-01 | Racine | Wisconsin | 55101 | 22940 | 349 |
1076181 | 1076181 | 2021-02-28 | Racine | Wisconsin | 55101 | 22940 | 349 |
1072935 | 1072935 | 2021-02-27 | Racine | Wisconsin | 55101 | 22921 | 349 |
1069689 | 1069689 | 2021-02-26 | Racine | Wisconsin | 55101 | 22899 | 349 |
1066444 | 1066444 | 2021-02-25 | Racine | Wisconsin | 55101 | 22879 | 349 |
1063199 | 1063199 | 2021-02-24 | Racine | Wisconsin | 55101 | 22847 | 344 |
1059954 | 1059954 | 2021-02-23 | Racine | Wisconsin | 55101 | 22820 | 343 |
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 |
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);