ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Lafayette", deaths = 18 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2151354 | 2151354 | 2022-01-25 | Lafayette | Wisconsin | 55065 | 3360 | 18 |
2148102 | 2148102 | 2022-01-24 | Lafayette | Wisconsin | 55065 | 3333 | 18 |
2144850 | 2144850 | 2022-01-23 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2141595 | 2141595 | 2022-01-22 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2138339 | 2138339 | 2022-01-21 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2135084 | 2135084 | 2022-01-20 | Lafayette | Wisconsin | 55065 | 3246 | 18 |
2131832 | 2131832 | 2022-01-19 | Lafayette | Wisconsin | 55065 | 3198 | 18 |
2128578 | 2128578 | 2022-01-18 | Lafayette | Wisconsin | 55065 | 3170 | 18 |
2125325 | 2125325 | 2022-01-17 | Lafayette | Wisconsin | 55065 | 3131 | 18 |
2122073 | 2122073 | 2022-01-16 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2118821 | 2118821 | 2022-01-15 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2115569 | 2115569 | 2022-01-14 | Lafayette | Wisconsin | 55065 | 3063 | 18 |
2112317 | 2112317 | 2022-01-13 | Lafayette | Wisconsin | 55065 | 3001 | 18 |
2109065 | 2109065 | 2022-01-12 | Lafayette | Wisconsin | 55065 | 2961 | 18 |
2105814 | 2105814 | 2022-01-11 | Lafayette | Wisconsin | 55065 | 2909 | 18 |
2102563 | 2102563 | 2022-01-10 | Lafayette | Wisconsin | 55065 | 2883 | 18 |
2099312 | 2099312 | 2022-01-09 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2096061 | 2096061 | 2022-01-08 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2092809 | 2092809 | 2022-01-07 | Lafayette | Wisconsin | 55065 | 2815 | 18 |
2089557 | 2089557 | 2022-01-06 | Lafayette | Wisconsin | 55065 | 2788 | 18 |
2086306 | 2086306 | 2022-01-05 | Lafayette | Wisconsin | 55065 | 2763 | 18 |
2083054 | 2083054 | 2022-01-04 | Lafayette | Wisconsin | 55065 | 2744 | 18 |
2079802 | 2079802 | 2022-01-03 | Lafayette | Wisconsin | 55065 | 2733 | 18 |
2076550 | 2076550 | 2022-01-02 | Lafayette | Wisconsin | 55065 | 2703 | 18 |
2073299 | 2073299 | 2022-01-01 | Lafayette | Wisconsin | 55065 | 2703 | 18 |
2070048 | 2070048 | 2021-12-31 | Lafayette | Wisconsin | 55065 | 2703 | 18 |
2066797 | 2066797 | 2021-12-30 | Lafayette | Wisconsin | 55065 | 2686 | 18 |
2063547 | 2063547 | 2021-12-29 | Lafayette | Wisconsin | 55065 | 2675 | 18 |
2060297 | 2060297 | 2021-12-28 | Lafayette | Wisconsin | 55065 | 2666 | 18 |
2057048 | 2057048 | 2021-12-27 | Lafayette | Wisconsin | 55065 | 2659 | 18 |
2053799 | 2053799 | 2021-12-26 | Lafayette | Wisconsin | 55065 | 2639 | 18 |
2050549 | 2050549 | 2021-12-25 | Lafayette | Wisconsin | 55065 | 2639 | 18 |
2047299 | 2047299 | 2021-12-24 | Lafayette | Wisconsin | 55065 | 2639 | 18 |
2044049 | 2044049 | 2021-12-23 | Lafayette | Wisconsin | 55065 | 2626 | 18 |
2040800 | 2040800 | 2021-12-22 | Lafayette | Wisconsin | 55065 | 2619 | 18 |
2037550 | 2037550 | 2021-12-21 | Lafayette | Wisconsin | 55065 | 2607 | 18 |
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);