ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55035 and state = "Wisconsin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5146 | 5146 | 2020-03-19 | Eau Claire | Wisconsin | 55035 | 1 | 0 |
6055 | 6055 | 2020-03-20 | Eau Claire | Wisconsin | 55035 | 1 | 0 |
7088 | 7088 | 2020-03-21 | Eau Claire | Wisconsin | 55035 | 2 | 0 |
8226 | 8226 | 2020-03-22 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
9452 | 9452 | 2020-03-23 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
10806 | 10806 | 2020-03-24 | Eau Claire | Wisconsin | 55035 | 4 | 0 |
12333 | 12333 | 2020-03-25 | Eau Claire | Wisconsin | 55035 | 5 | 0 |
13987 | 13987 | 2020-03-26 | Eau Claire | Wisconsin | 55035 | 6 | 0 |
15759 | 15759 | 2020-03-27 | Eau Claire | Wisconsin | 55035 | 8 | 0 |
17639 | 17639 | 2020-03-28 | Eau Claire | Wisconsin | 55035 | 8 | 0 |
19608 | 19608 | 2020-03-29 | Eau Claire | Wisconsin | 55035 | 10 | 0 |
21678 | 21678 | 2020-03-30 | Eau Claire | Wisconsin | 55035 | 10 | 0 |
23830 | 23830 | 2020-03-31 | Eau Claire | Wisconsin | 55035 | 11 | 0 |
26050 | 26050 | 2020-04-01 | Eau Claire | Wisconsin | 55035 | 12 | 0 |
28343 | 28343 | 2020-04-02 | Eau Claire | Wisconsin | 55035 | 14 | 0 |
30698 | 30698 | 2020-04-03 | Eau Claire | Wisconsin | 55035 | 16 | 0 |
33099 | 33099 | 2020-04-04 | Eau Claire | Wisconsin | 55035 | 17 | 0 |
35537 | 35537 | 2020-04-05 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
38023 | 38023 | 2020-04-06 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
40564 | 40564 | 2020-04-07 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
43136 | 43136 | 2020-04-08 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
45733 | 45733 | 2020-04-09 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
48361 | 48361 | 2020-04-10 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
51021 | 51021 | 2020-04-11 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
53698 | 53698 | 2020-04-12 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
56388 | 56388 | 2020-04-13 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
59095 | 59095 | 2020-04-14 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
61814 | 61814 | 2020-04-15 | Eau Claire | Wisconsin | 55035 | 21 | 0 |
64547 | 64547 | 2020-04-16 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
67295 | 67295 | 2020-04-17 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
70057 | 70057 | 2020-04-18 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
72826 | 72826 | 2020-04-19 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
75602 | 75602 | 2020-04-20 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
78385 | 78385 | 2020-04-21 | Eau Claire | Wisconsin | 55035 | 22 | 0 |
81178 | 81178 | 2020-04-22 | Eau Claire | Wisconsin | 55035 | 23 | 0 |
83979 | 83979 | 2020-04-23 | Eau Claire | Wisconsin | 55035 | 23 | 0 |
86786 | 86786 | 2020-04-24 | Eau Claire | Wisconsin | 55035 | 23 | 0 |
89602 | 89602 | 2020-04-25 | Eau Claire | Wisconsin | 55035 | 24 | 0 |
92420 | 92420 | 2020-04-26 | Eau Claire | Wisconsin | 55035 | 25 | 0 |
95250 | 95250 | 2020-04-27 | Eau Claire | Wisconsin | 55035 | 25 | 0 |
98095 | 98095 | 2020-04-28 | Eau Claire | Wisconsin | 55035 | 27 | 0 |
100945 | 100945 | 2020-04-29 | Eau Claire | Wisconsin | 55035 | 27 | 0 |
103800 | 103800 | 2020-04-30 | Eau Claire | Wisconsin | 55035 | 28 | 0 |
106664 | 106664 | 2020-05-01 | Eau Claire | Wisconsin | 55035 | 28 | 0 |
109533 | 109533 | 2020-05-02 | Eau Claire | Wisconsin | 55035 | 34 | 0 |
112408 | 112408 | 2020-05-03 | Eau Claire | Wisconsin | 55035 | 36 | 0 |
115291 | 115291 | 2020-05-04 | Eau Claire | Wisconsin | 55035 | 41 | 0 |
118250 | 118250 | 2020-05-05 | Eau Claire | Wisconsin | 55035 | 42 | 0 |
121215 | 121215 | 2020-05-06 | Eau Claire | Wisconsin | 55035 | 45 | 0 |
124195 | 124195 | 2020-05-07 | Eau Claire | Wisconsin | 55035 | 47 | 0 |
127180 | 127180 | 2020-05-08 | Eau Claire | Wisconsin | 55035 | 50 | 0 |
130170 | 130170 | 2020-05-09 | Eau Claire | Wisconsin | 55035 | 54 | 0 |
133160 | 133160 | 2020-05-10 | Eau Claire | Wisconsin | 55035 | 54 | 0 |
136150 | 136150 | 2020-05-11 | Eau Claire | Wisconsin | 55035 | 57 | 0 |
139141 | 139141 | 2020-05-12 | Eau Claire | Wisconsin | 55035 | 60 | 0 |
142137 | 142137 | 2020-05-13 | Eau Claire | Wisconsin | 55035 | 61 | 0 |
145135 | 145135 | 2020-05-14 | Eau Claire | Wisconsin | 55035 | 63 | 0 |
148138 | 148138 | 2020-05-15 | Eau Claire | Wisconsin | 55035 | 65 | 0 |
151147 | 151147 | 2020-05-16 | Eau Claire | Wisconsin | 55035 | 65 | 0 |
154159 | 154159 | 2020-05-17 | Eau Claire | Wisconsin | 55035 | 66 | 0 |
157175 | 157175 | 2020-05-18 | Eau Claire | Wisconsin | 55035 | 70 | 0 |
160199 | 160199 | 2020-05-19 | Eau Claire | Wisconsin | 55035 | 75 | 0 |
163227 | 163227 | 2020-05-20 | Eau Claire | Wisconsin | 55035 | 78 | 0 |
166256 | 166256 | 2020-05-21 | Eau Claire | Wisconsin | 55035 | 82 | 0 |
169292 | 169292 | 2020-05-22 | Eau Claire | Wisconsin | 55035 | 89 | 0 |
172333 | 172333 | 2020-05-23 | Eau Claire | Wisconsin | 55035 | 93 | 0 |
175376 | 175376 | 2020-05-24 | Eau Claire | Wisconsin | 55035 | 96 | 0 |
178421 | 178421 | 2020-05-25 | Eau Claire | Wisconsin | 55035 | 98 | 0 |
181465 | 181465 | 2020-05-26 | Eau Claire | Wisconsin | 55035 | 100 | 0 |
184516 | 184516 | 2020-05-27 | Eau Claire | Wisconsin | 55035 | 99 | 0 |
187573 | 187573 | 2020-05-28 | Eau Claire | Wisconsin | 55035 | 99 | 0 |
190637 | 190637 | 2020-05-29 | Eau Claire | Wisconsin | 55035 | 107 | 0 |
193703 | 193703 | 2020-05-30 | Eau Claire | Wisconsin | 55035 | 108 | 0 |
196773 | 196773 | 2020-05-31 | Eau Claire | Wisconsin | 55035 | 108 | 0 |
199846 | 199846 | 2020-06-01 | Eau Claire | Wisconsin | 55035 | 113 | 0 |
202922 | 202922 | 2020-06-02 | Eau Claire | Wisconsin | 55035 | 114 | 0 |
206001 | 206001 | 2020-06-03 | Eau Claire | Wisconsin | 55035 | 114 | 0 |
209083 | 209083 | 2020-06-04 | Eau Claire | Wisconsin | 55035 | 116 | 0 |
212168 | 212168 | 2020-06-05 | Eau Claire | Wisconsin | 55035 | 119 | 0 |
215255 | 215255 | 2020-06-06 | Eau Claire | Wisconsin | 55035 | 121 | 0 |
218345 | 218345 | 2020-06-07 | Eau Claire | Wisconsin | 55035 | 123 | 0 |
221437 | 221437 | 2020-06-08 | Eau Claire | Wisconsin | 55035 | 124 | 0 |
224533 | 224533 | 2020-06-09 | Eau Claire | Wisconsin | 55035 | 124 | 0 |
227633 | 227633 | 2020-06-10 | Eau Claire | Wisconsin | 55035 | 126 | 0 |
230737 | 230737 | 2020-06-11 | Eau Claire | Wisconsin | 55035 | 126 | 0 |
233842 | 233842 | 2020-06-12 | Eau Claire | Wisconsin | 55035 | 130 | 0 |
236949 | 236949 | 2020-06-13 | Eau Claire | Wisconsin | 55035 | 132 | 0 |
240057 | 240057 | 2020-06-14 | Eau Claire | Wisconsin | 55035 | 137 | 0 |
243168 | 243168 | 2020-06-15 | Eau Claire | Wisconsin | 55035 | 137 | 0 |
246281 | 246281 | 2020-06-16 | Eau Claire | Wisconsin | 55035 | 138 | 0 |
249393 | 249393 | 2020-06-17 | Eau Claire | Wisconsin | 55035 | 140 | 0 |
252508 | 252508 | 2020-06-18 | Eau Claire | Wisconsin | 55035 | 149 | 0 |
255627 | 255627 | 2020-06-19 | Eau Claire | Wisconsin | 55035 | 151 | 0 |
258754 | 258754 | 2020-06-20 | Eau Claire | Wisconsin | 55035 | 156 | 0 |
261881 | 261881 | 2020-06-21 | Eau Claire | Wisconsin | 55035 | 161 | 0 |
265010 | 265010 | 2020-06-22 | Eau Claire | Wisconsin | 55035 | 163 | 1 |
268139 | 268139 | 2020-06-23 | Eau Claire | Wisconsin | 55035 | 167 | 1 |
271273 | 271273 | 2020-06-24 | Eau Claire | Wisconsin | 55035 | 170 | 1 |
274413 | 274413 | 2020-06-25 | Eau Claire | Wisconsin | 55035 | 176 | 1 |
277561 | 277561 | 2020-06-26 | Eau Claire | Wisconsin | 55035 | 180 | 1 |
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);