ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Douglas" and fips = 55031 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6053 | 6053 | 2020-03-20 | Douglas | Wisconsin | 55031 | 1 | 0 |
7086 | 7086 | 2020-03-21 | Douglas | Wisconsin | 55031 | 1 | 0 |
8224 | 8224 | 2020-03-22 | Douglas | Wisconsin | 55031 | 1 | 0 |
9450 | 9450 | 2020-03-23 | Douglas | Wisconsin | 55031 | 2 | 0 |
10804 | 10804 | 2020-03-24 | Douglas | Wisconsin | 55031 | 4 | 0 |
12331 | 12331 | 2020-03-25 | Douglas | Wisconsin | 55031 | 4 | 0 |
13985 | 13985 | 2020-03-26 | Douglas | Wisconsin | 55031 | 4 | 0 |
15757 | 15757 | 2020-03-27 | Douglas | Wisconsin | 55031 | 5 | 0 |
17637 | 17637 | 2020-03-28 | Douglas | Wisconsin | 55031 | 6 | 0 |
19606 | 19606 | 2020-03-29 | Douglas | Wisconsin | 55031 | 6 | 0 |
21676 | 21676 | 2020-03-30 | Douglas | Wisconsin | 55031 | 6 | 0 |
23828 | 23828 | 2020-03-31 | Douglas | Wisconsin | 55031 | 6 | 0 |
26048 | 26048 | 2020-04-01 | Douglas | Wisconsin | 55031 | 7 | 0 |
28341 | 28341 | 2020-04-02 | Douglas | Wisconsin | 55031 | 6 | 0 |
30696 | 30696 | 2020-04-03 | Douglas | Wisconsin | 55031 | 6 | 0 |
33097 | 33097 | 2020-04-04 | Douglas | Wisconsin | 55031 | 7 | 0 |
35535 | 35535 | 2020-04-05 | Douglas | Wisconsin | 55031 | 7 | 0 |
38021 | 38021 | 2020-04-06 | Douglas | Wisconsin | 55031 | 7 | 0 |
40562 | 40562 | 2020-04-07 | Douglas | Wisconsin | 55031 | 7 | 0 |
43134 | 43134 | 2020-04-08 | Douglas | Wisconsin | 55031 | 7 | 0 |
45731 | 45731 | 2020-04-09 | Douglas | Wisconsin | 55031 | 7 | 0 |
48359 | 48359 | 2020-04-10 | Douglas | Wisconsin | 55031 | 7 | 0 |
51019 | 51019 | 2020-04-11 | Douglas | Wisconsin | 55031 | 7 | 0 |
53696 | 53696 | 2020-04-12 | Douglas | Wisconsin | 55031 | 7 | 0 |
56386 | 56386 | 2020-04-13 | Douglas | Wisconsin | 55031 | 7 | 0 |
59093 | 59093 | 2020-04-14 | Douglas | Wisconsin | 55031 | 7 | 0 |
61812 | 61812 | 2020-04-15 | Douglas | Wisconsin | 55031 | 7 | 0 |
64545 | 64545 | 2020-04-16 | Douglas | Wisconsin | 55031 | 7 | 0 |
67293 | 67293 | 2020-04-17 | Douglas | Wisconsin | 55031 | 7 | 0 |
70055 | 70055 | 2020-04-18 | Douglas | Wisconsin | 55031 | 8 | 0 |
72824 | 72824 | 2020-04-19 | Douglas | Wisconsin | 55031 | 8 | 0 |
75600 | 75600 | 2020-04-20 | Douglas | Wisconsin | 55031 | 8 | 0 |
78383 | 78383 | 2020-04-21 | Douglas | Wisconsin | 55031 | 8 | 0 |
81176 | 81176 | 2020-04-22 | Douglas | Wisconsin | 55031 | 8 | 0 |
83977 | 83977 | 2020-04-23 | Douglas | Wisconsin | 55031 | 9 | 0 |
86784 | 86784 | 2020-04-24 | Douglas | Wisconsin | 55031 | 9 | 0 |
89600 | 89600 | 2020-04-25 | Douglas | Wisconsin | 55031 | 9 | 0 |
92418 | 92418 | 2020-04-26 | Douglas | Wisconsin | 55031 | 9 | 0 |
95248 | 95248 | 2020-04-27 | Douglas | Wisconsin | 55031 | 9 | 0 |
98093 | 98093 | 2020-04-28 | Douglas | Wisconsin | 55031 | 9 | 0 |
100943 | 100943 | 2020-04-29 | Douglas | Wisconsin | 55031 | 9 | 0 |
103798 | 103798 | 2020-04-30 | Douglas | Wisconsin | 55031 | 9 | 0 |
106662 | 106662 | 2020-05-01 | Douglas | Wisconsin | 55031 | 9 | 0 |
109531 | 109531 | 2020-05-02 | Douglas | Wisconsin | 55031 | 9 | 0 |
112406 | 112406 | 2020-05-03 | Douglas | Wisconsin | 55031 | 9 | 0 |
115289 | 115289 | 2020-05-04 | Douglas | Wisconsin | 55031 | 9 | 0 |
118248 | 118248 | 2020-05-05 | Douglas | Wisconsin | 55031 | 9 | 0 |
121213 | 121213 | 2020-05-06 | Douglas | Wisconsin | 55031 | 10 | 0 |
124193 | 124193 | 2020-05-07 | Douglas | Wisconsin | 55031 | 10 | 0 |
127178 | 127178 | 2020-05-08 | Douglas | Wisconsin | 55031 | 10 | 0 |
130168 | 130168 | 2020-05-09 | Douglas | Wisconsin | 55031 | 11 | 0 |
133158 | 133158 | 2020-05-10 | Douglas | Wisconsin | 55031 | 11 | 0 |
136148 | 136148 | 2020-05-11 | Douglas | Wisconsin | 55031 | 11 | 0 |
139139 | 139139 | 2020-05-12 | Douglas | Wisconsin | 55031 | 11 | 0 |
142135 | 142135 | 2020-05-13 | Douglas | Wisconsin | 55031 | 11 | 0 |
145133 | 145133 | 2020-05-14 | Douglas | Wisconsin | 55031 | 12 | 0 |
148136 | 148136 | 2020-05-15 | Douglas | Wisconsin | 55031 | 12 | 0 |
151145 | 151145 | 2020-05-16 | Douglas | Wisconsin | 55031 | 12 | 0 |
154157 | 154157 | 2020-05-17 | Douglas | Wisconsin | 55031 | 12 | 0 |
157173 | 157173 | 2020-05-18 | Douglas | Wisconsin | 55031 | 13 | 0 |
160197 | 160197 | 2020-05-19 | Douglas | Wisconsin | 55031 | 15 | 0 |
163225 | 163225 | 2020-05-20 | Douglas | Wisconsin | 55031 | 15 | 0 |
166254 | 166254 | 2020-05-21 | Douglas | Wisconsin | 55031 | 15 | 0 |
169290 | 169290 | 2020-05-22 | Douglas | Wisconsin | 55031 | 16 | 0 |
172331 | 172331 | 2020-05-23 | Douglas | Wisconsin | 55031 | 17 | 0 |
175374 | 175374 | 2020-05-24 | Douglas | Wisconsin | 55031 | 17 | 0 |
178419 | 178419 | 2020-05-25 | Douglas | Wisconsin | 55031 | 18 | 0 |
181463 | 181463 | 2020-05-26 | Douglas | Wisconsin | 55031 | 19 | 0 |
184514 | 184514 | 2020-05-27 | Douglas | Wisconsin | 55031 | 19 | 0 |
187571 | 187571 | 2020-05-28 | Douglas | Wisconsin | 55031 | 19 | 0 |
190635 | 190635 | 2020-05-29 | Douglas | Wisconsin | 55031 | 19 | 0 |
193701 | 193701 | 2020-05-30 | Douglas | Wisconsin | 55031 | 19 | 0 |
196771 | 196771 | 2020-05-31 | Douglas | Wisconsin | 55031 | 19 | 0 |
199844 | 199844 | 2020-06-01 | Douglas | Wisconsin | 55031 | 19 | 0 |
202920 | 202920 | 2020-06-02 | Douglas | Wisconsin | 55031 | 19 | 0 |
205999 | 205999 | 2020-06-03 | Douglas | Wisconsin | 55031 | 19 | 0 |
209081 | 209081 | 2020-06-04 | Douglas | Wisconsin | 55031 | 19 | 0 |
212166 | 212166 | 2020-06-05 | Douglas | Wisconsin | 55031 | 19 | 0 |
215253 | 215253 | 2020-06-06 | Douglas | Wisconsin | 55031 | 20 | 0 |
218343 | 218343 | 2020-06-07 | Douglas | Wisconsin | 55031 | 20 | 0 |
221435 | 221435 | 2020-06-08 | Douglas | Wisconsin | 55031 | 20 | 0 |
224531 | 224531 | 2020-06-09 | Douglas | Wisconsin | 55031 | 20 | 0 |
227631 | 227631 | 2020-06-10 | Douglas | Wisconsin | 55031 | 20 | 0 |
230735 | 230735 | 2020-06-11 | Douglas | Wisconsin | 55031 | 20 | 0 |
233840 | 233840 | 2020-06-12 | Douglas | Wisconsin | 55031 | 20 | 0 |
236947 | 236947 | 2020-06-13 | Douglas | Wisconsin | 55031 | 20 | 0 |
240055 | 240055 | 2020-06-14 | Douglas | Wisconsin | 55031 | 20 | 0 |
243166 | 243166 | 2020-06-15 | Douglas | Wisconsin | 55031 | 20 | 0 |
246279 | 246279 | 2020-06-16 | Douglas | Wisconsin | 55031 | 20 | 0 |
249391 | 249391 | 2020-06-17 | Douglas | Wisconsin | 55031 | 20 | 0 |
252506 | 252506 | 2020-06-18 | Douglas | Wisconsin | 55031 | 20 | 0 |
255625 | 255625 | 2020-06-19 | Douglas | Wisconsin | 55031 | 20 | 0 |
258752 | 258752 | 2020-06-20 | Douglas | Wisconsin | 55031 | 20 | 0 |
261879 | 261879 | 2020-06-21 | Douglas | Wisconsin | 55031 | 20 | 0 |
265008 | 265008 | 2020-06-22 | Douglas | Wisconsin | 55031 | 20 | 0 |
268137 | 268137 | 2020-06-23 | Douglas | Wisconsin | 55031 | 20 | 0 |
271271 | 271271 | 2020-06-24 | Douglas | Wisconsin | 55031 | 20 | 0 |
274411 | 274411 | 2020-06-25 | Douglas | Wisconsin | 55031 | 20 | 0 |
277559 | 277559 | 2020-06-26 | Douglas | Wisconsin | 55031 | 22 | 0 |
280707 | 280707 | 2020-06-27 | Douglas | Wisconsin | 55031 | 22 | 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);