ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 6, fips = 55065 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917130 | 917130 | 2021-01-10 | Lafayette | Wisconsin | 55065 | 1406 | 6 |
913885 | 913885 | 2021-01-09 | Lafayette | Wisconsin | 55065 | 1390 | 6 |
910640 | 910640 | 2021-01-08 | Lafayette | Wisconsin | 55065 | 1384 | 6 |
907395 | 907395 | 2021-01-07 | Lafayette | Wisconsin | 55065 | 1377 | 6 |
904149 | 904149 | 2021-01-06 | Lafayette | Wisconsin | 55065 | 1374 | 6 |
900904 | 900904 | 2021-01-05 | Lafayette | Wisconsin | 55065 | 1363 | 6 |
897659 | 897659 | 2021-01-04 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
894413 | 894413 | 2021-01-03 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
891167 | 891167 | 2021-01-02 | Lafayette | Wisconsin | 55065 | 1357 | 6 |
887920 | 887920 | 2021-01-01 | Lafayette | Wisconsin | 55065 | 1349 | 6 |
884675 | 884675 | 2020-12-31 | Lafayette | Wisconsin | 55065 | 1350 | 6 |
881430 | 881430 | 2020-12-30 | Lafayette | Wisconsin | 55065 | 1347 | 6 |
878185 | 878185 | 2020-12-29 | Lafayette | Wisconsin | 55065 | 1338 | 6 |
874940 | 874940 | 2020-12-28 | Lafayette | Wisconsin | 55065 | 1335 | 6 |
871695 | 871695 | 2020-12-27 | Lafayette | Wisconsin | 55065 | 1332 | 6 |
868450 | 868450 | 2020-12-26 | Lafayette | Wisconsin | 55065 | 1330 | 6 |
865205 | 865205 | 2020-12-25 | Lafayette | Wisconsin | 55065 | 1321 | 6 |
861960 | 861960 | 2020-12-24 | Lafayette | Wisconsin | 55065 | 1317 | 6 |
858715 | 858715 | 2020-12-23 | Lafayette | Wisconsin | 55065 | 1314 | 6 |
855470 | 855470 | 2020-12-22 | Lafayette | Wisconsin | 55065 | 1303 | 6 |
852225 | 852225 | 2020-12-21 | Lafayette | Wisconsin | 55065 | 1292 | 6 |
848980 | 848980 | 2020-12-20 | Lafayette | Wisconsin | 55065 | 1280 | 6 |
845735 | 845735 | 2020-12-19 | Lafayette | Wisconsin | 55065 | 1274 | 6 |
842489 | 842489 | 2020-12-18 | Lafayette | Wisconsin | 55065 | 1270 | 6 |
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);