ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Eau Claire" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
35537 | 35537 | 2020-04-05 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
33099 | 33099 | 2020-04-04 | Eau Claire | Wisconsin | 55035 | 17 | 0 |
30698 | 30698 | 2020-04-03 | Eau Claire | Wisconsin | 55035 | 16 | 0 |
28343 | 28343 | 2020-04-02 | Eau Claire | Wisconsin | 55035 | 14 | 0 |
26050 | 26050 | 2020-04-01 | Eau Claire | Wisconsin | 55035 | 12 | 0 |
23830 | 23830 | 2020-03-31 | Eau Claire | Wisconsin | 55035 | 11 | 0 |
21678 | 21678 | 2020-03-30 | Eau Claire | Wisconsin | 55035 | 10 | 0 |
19608 | 19608 | 2020-03-29 | Eau Claire | Wisconsin | 55035 | 10 | 0 |
17639 | 17639 | 2020-03-28 | Eau Claire | Wisconsin | 55035 | 8 | 0 |
15759 | 15759 | 2020-03-27 | Eau Claire | Wisconsin | 55035 | 8 | 0 |
13987 | 13987 | 2020-03-26 | Eau Claire | Wisconsin | 55035 | 6 | 0 |
12333 | 12333 | 2020-03-25 | Eau Claire | Wisconsin | 55035 | 5 | 0 |
10806 | 10806 | 2020-03-24 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
9452 | 9452 | 2020-03-23 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
8226 | 8226 | 2020-03-22 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
7088 | 7088 | 2020-03-21 | Eau Claire | Wisconsin | 55035 | 2 | 0 |
6055 | 6055 | 2020-03-20 | Eau Claire | Wisconsin | 55035 | 1 | 0 |
5146 | 5146 | 2020-03-19 | Eau Claire | Wisconsin | 55035 | 1 | 0 |
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);