ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Waupaca" and state = "Wisconsin" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15787 | 15787 | 2020-03-27 | Waupaca | Wisconsin | 55135 | 1 | 0 |
17668 | 17668 | 2020-03-28 | Waupaca | Wisconsin | 55135 | 1 | 1 |
19637 | 19637 | 2020-03-29 | Waupaca | Wisconsin | 55135 | 1 | 1 |
21709 | 21709 | 2020-03-30 | Waupaca | Wisconsin | 55135 | 1 | 1 |
23862 | 23862 | 2020-03-31 | Waupaca | Wisconsin | 55135 | 1 | 1 |
26083 | 26083 | 2020-04-01 | Waupaca | Wisconsin | 55135 | 2 | 1 |
28377 | 28377 | 2020-04-02 | Waupaca | Wisconsin | 55135 | 2 | 1 |
30733 | 30733 | 2020-04-03 | Waupaca | Wisconsin | 55135 | 2 | 1 |
33136 | 33136 | 2020-04-04 | Waupaca | Wisconsin | 55135 | 2 | 1 |
35575 | 35575 | 2020-04-05 | Waupaca | Wisconsin | 55135 | 2 | 1 |
38062 | 38062 | 2020-04-06 | Waupaca | Wisconsin | 55135 | 2 | 1 |
40604 | 40604 | 2020-04-07 | Waupaca | Wisconsin | 55135 | 2 | 1 |
43176 | 43176 | 2020-04-08 | Waupaca | Wisconsin | 55135 | 2 | 1 |
45774 | 45774 | 2020-04-09 | Waupaca | Wisconsin | 55135 | 3 | 1 |
48403 | 48403 | 2020-04-10 | Waupaca | Wisconsin | 55135 | 3 | 1 |
51064 | 51064 | 2020-04-11 | Waupaca | Wisconsin | 55135 | 3 | 1 |
53741 | 53741 | 2020-04-12 | Waupaca | Wisconsin | 55135 | 4 | 1 |
56432 | 56432 | 2020-04-13 | Waupaca | Wisconsin | 55135 | 4 | 1 |
59140 | 59140 | 2020-04-14 | Waupaca | Wisconsin | 55135 | 4 | 1 |
61859 | 61859 | 2020-04-15 | Waupaca | Wisconsin | 55135 | 4 | 1 |
64592 | 64592 | 2020-04-16 | Waupaca | Wisconsin | 55135 | 4 | 1 |
67340 | 67340 | 2020-04-17 | Waupaca | Wisconsin | 55135 | 4 | 1 |
70102 | 70102 | 2020-04-18 | Waupaca | Wisconsin | 55135 | 4 | 1 |
72871 | 72871 | 2020-04-19 | Waupaca | Wisconsin | 55135 | 4 | 1 |
75647 | 75647 | 2020-04-20 | Waupaca | Wisconsin | 55135 | 4 | 1 |
78430 | 78430 | 2020-04-21 | Waupaca | Wisconsin | 55135 | 4 | 1 |
81223 | 81223 | 2020-04-22 | Waupaca | Wisconsin | 55135 | 5 | 1 |
84024 | 84024 | 2020-04-23 | Waupaca | Wisconsin | 55135 | 6 | 1 |
86832 | 86832 | 2020-04-24 | Waupaca | Wisconsin | 55135 | 7 | 1 |
89648 | 89648 | 2020-04-25 | Waupaca | Wisconsin | 55135 | 7 | 1 |
92466 | 92466 | 2020-04-26 | Waupaca | Wisconsin | 55135 | 7 | 1 |
95296 | 95296 | 2020-04-27 | Waupaca | Wisconsin | 55135 | 7 | 1 |
98141 | 98141 | 2020-04-28 | Waupaca | Wisconsin | 55135 | 7 | 1 |
100991 | 100991 | 2020-04-29 | Waupaca | Wisconsin | 55135 | 8 | 1 |
103846 | 103846 | 2020-04-30 | Waupaca | Wisconsin | 55135 | 8 | 1 |
106711 | 106711 | 2020-05-01 | Waupaca | Wisconsin | 55135 | 10 | 1 |
109580 | 109580 | 2020-05-02 | Waupaca | Wisconsin | 55135 | 10 | 1 |
112455 | 112455 | 2020-05-03 | Waupaca | Wisconsin | 55135 | 10 | 1 |
115338 | 115338 | 2020-05-04 | Waupaca | Wisconsin | 55135 | 10 | 1 |
118297 | 118297 | 2020-05-05 | Waupaca | Wisconsin | 55135 | 10 | 1 |
121263 | 121263 | 2020-05-06 | Waupaca | Wisconsin | 55135 | 10 | 1 |
124243 | 124243 | 2020-05-07 | Waupaca | Wisconsin | 55135 | 10 | 1 |
127228 | 127228 | 2020-05-08 | Waupaca | Wisconsin | 55135 | 11 | 1 |
130218 | 130218 | 2020-05-09 | Waupaca | Wisconsin | 55135 | 13 | 1 |
133208 | 133208 | 2020-05-10 | Waupaca | Wisconsin | 55135 | 13 | 1 |
136198 | 136198 | 2020-05-11 | Waupaca | Wisconsin | 55135 | 13 | 1 |
139189 | 139189 | 2020-05-12 | Waupaca | Wisconsin | 55135 | 13 | 1 |
142185 | 142185 | 2020-05-13 | Waupaca | Wisconsin | 55135 | 14 | 1 |
145184 | 145184 | 2020-05-14 | Waupaca | Wisconsin | 55135 | 15 | 1 |
148187 | 148187 | 2020-05-15 | Waupaca | Wisconsin | 55135 | 16 | 1 |
151196 | 151196 | 2020-05-16 | Waupaca | Wisconsin | 55135 | 17 | 1 |
154208 | 154208 | 2020-05-17 | Waupaca | Wisconsin | 55135 | 17 | 1 |
157224 | 157224 | 2020-05-18 | Waupaca | Wisconsin | 55135 | 17 | 1 |
160248 | 160248 | 2020-05-19 | Waupaca | Wisconsin | 55135 | 19 | 1 |
163276 | 163276 | 2020-05-20 | Waupaca | Wisconsin | 55135 | 19 | 1 |
166307 | 166307 | 2020-05-21 | Waupaca | Wisconsin | 55135 | 19 | 1 |
169343 | 169343 | 2020-05-22 | Waupaca | Wisconsin | 55135 | 20 | 1 |
172384 | 172384 | 2020-05-23 | Waupaca | Wisconsin | 55135 | 20 | 1 |
175427 | 175427 | 2020-05-24 | Waupaca | Wisconsin | 55135 | 23 | 1 |
178472 | 178472 | 2020-05-25 | Waupaca | Wisconsin | 55135 | 23 | 1 |
181516 | 181516 | 2020-05-26 | Waupaca | Wisconsin | 55135 | 26 | 1 |
184567 | 184567 | 2020-05-27 | Waupaca | Wisconsin | 55135 | 27 | 1 |
187624 | 187624 | 2020-05-28 | Waupaca | Wisconsin | 55135 | 27 | 1 |
190688 | 190688 | 2020-05-29 | Waupaca | Wisconsin | 55135 | 29 | 1 |
193754 | 193754 | 2020-05-30 | Waupaca | Wisconsin | 55135 | 39 | 1 |
196824 | 196824 | 2020-05-31 | Waupaca | Wisconsin | 55135 | 41 | 1 |
199897 | 199897 | 2020-06-01 | Waupaca | Wisconsin | 55135 | 42 | 1 |
202973 | 202973 | 2020-06-02 | Waupaca | Wisconsin | 55135 | 45 | 1 |
206052 | 206052 | 2020-06-03 | Waupaca | Wisconsin | 55135 | 45 | 1 |
209134 | 209134 | 2020-06-04 | Waupaca | Wisconsin | 55135 | 47 | 1 |
212219 | 212219 | 2020-06-05 | Waupaca | Wisconsin | 55135 | 49 | 1 |
215306 | 215306 | 2020-06-06 | Waupaca | Wisconsin | 55135 | 51 | 1 |
218396 | 218396 | 2020-06-07 | Waupaca | Wisconsin | 55135 | 57 | 1 |
221488 | 221488 | 2020-06-08 | Waupaca | Wisconsin | 55135 | 58 | 1 |
224584 | 224584 | 2020-06-09 | Waupaca | Wisconsin | 55135 | 58 | 1 |
227685 | 227685 | 2020-06-10 | Waupaca | Wisconsin | 55135 | 61 | 1 |
230789 | 230789 | 2020-06-11 | Waupaca | Wisconsin | 55135 | 63 | 2 |
233894 | 233894 | 2020-06-12 | Waupaca | Wisconsin | 55135 | 66 | 3 |
237001 | 237001 | 2020-06-13 | Waupaca | Wisconsin | 55135 | 71 | 3 |
240109 | 240109 | 2020-06-14 | Waupaca | Wisconsin | 55135 | 78 | 3 |
243220 | 243220 | 2020-06-15 | Waupaca | Wisconsin | 55135 | 79 | 3 |
246333 | 246333 | 2020-06-16 | Waupaca | Wisconsin | 55135 | 80 | 4 |
249445 | 249445 | 2020-06-17 | Waupaca | Wisconsin | 55135 | 82 | 5 |
252560 | 252560 | 2020-06-18 | Waupaca | Wisconsin | 55135 | 84 | 5 |
255679 | 255679 | 2020-06-19 | Waupaca | Wisconsin | 55135 | 87 | 5 |
258806 | 258806 | 2020-06-20 | Waupaca | Wisconsin | 55135 | 89 | 5 |
261933 | 261933 | 2020-06-21 | Waupaca | Wisconsin | 55135 | 91 | 5 |
265062 | 265062 | 2020-06-22 | Waupaca | Wisconsin | 55135 | 91 | 5 |
268191 | 268191 | 2020-06-23 | Waupaca | Wisconsin | 55135 | 95 | 6 |
271325 | 271325 | 2020-06-24 | Waupaca | Wisconsin | 55135 | 96 | 6 |
274465 | 274465 | 2020-06-25 | Waupaca | Wisconsin | 55135 | 101 | 6 |
277613 | 277613 | 2020-06-26 | Waupaca | Wisconsin | 55135 | 104 | 6 |
280761 | 280761 | 2020-06-27 | Waupaca | Wisconsin | 55135 | 106 | 6 |
283907 | 283907 | 2020-06-28 | Waupaca | Wisconsin | 55135 | 106 | 6 |
287053 | 287053 | 2020-06-29 | Waupaca | Wisconsin | 55135 | 106 | 6 |
290203 | 290203 | 2020-06-30 | Waupaca | Wisconsin | 55135 | 113 | 7 |
293356 | 293356 | 2020-07-01 | Waupaca | Wisconsin | 55135 | 116 | 7 |
296511 | 296511 | 2020-07-02 | Waupaca | Wisconsin | 55135 | 121 | 10 |
299673 | 299673 | 2020-07-03 | Waupaca | Wisconsin | 55135 | 122 | 10 |
302837 | 302837 | 2020-07-04 | Waupaca | Wisconsin | 55135 | 128 | 10 |
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);