ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where county = "Waupaca", deaths = 1 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
227685 | 227685 | 2020-06-10 | Waupaca | Wisconsin | 55135 | 61 | 1 |
224584 | 224584 | 2020-06-09 | Waupaca | Wisconsin | 55135 | 58 | 1 |
221488 | 221488 | 2020-06-08 | Waupaca | Wisconsin | 55135 | 58 | 1 |
218396 | 218396 | 2020-06-07 | Waupaca | Wisconsin | 55135 | 57 | 1 |
215306 | 215306 | 2020-06-06 | Waupaca | Wisconsin | 55135 | 51 | 1 |
212219 | 212219 | 2020-06-05 | Waupaca | Wisconsin | 55135 | 49 | 1 |
209134 | 209134 | 2020-06-04 | Waupaca | Wisconsin | 55135 | 47 | 1 |
206052 | 206052 | 2020-06-03 | Waupaca | Wisconsin | 55135 | 45 | 1 |
202973 | 202973 | 2020-06-02 | Waupaca | Wisconsin | 55135 | 45 | 1 |
199897 | 199897 | 2020-06-01 | Waupaca | Wisconsin | 55135 | 42 | 1 |
196824 | 196824 | 2020-05-31 | Waupaca | Wisconsin | 55135 | 41 | 1 |
193754 | 193754 | 2020-05-30 | Waupaca | Wisconsin | 55135 | 39 | 1 |
190688 | 190688 | 2020-05-29 | Waupaca | Wisconsin | 55135 | 29 | 1 |
187624 | 187624 | 2020-05-28 | Waupaca | Wisconsin | 55135 | 27 | 1 |
184567 | 184567 | 2020-05-27 | Waupaca | Wisconsin | 55135 | 27 | 1 |
181516 | 181516 | 2020-05-26 | Waupaca | Wisconsin | 55135 | 26 | 1 |
178472 | 178472 | 2020-05-25 | Waupaca | Wisconsin | 55135 | 23 | 1 |
175427 | 175427 | 2020-05-24 | Waupaca | Wisconsin | 55135 | 23 | 1 |
172384 | 172384 | 2020-05-23 | Waupaca | Wisconsin | 55135 | 20 | 1 |
169343 | 169343 | 2020-05-22 | Waupaca | Wisconsin | 55135 | 20 | 1 |
166307 | 166307 | 2020-05-21 | Waupaca | Wisconsin | 55135 | 19 | 1 |
163276 | 163276 | 2020-05-20 | Waupaca | Wisconsin | 55135 | 19 | 1 |
160248 | 160248 | 2020-05-19 | Waupaca | Wisconsin | 55135 | 19 | 1 |
157224 | 157224 | 2020-05-18 | Waupaca | Wisconsin | 55135 | 17 | 1 |
154208 | 154208 | 2020-05-17 | Waupaca | Wisconsin | 55135 | 17 | 1 |
151196 | 151196 | 2020-05-16 | Waupaca | Wisconsin | 55135 | 17 | 1 |
148187 | 148187 | 2020-05-15 | Waupaca | Wisconsin | 55135 | 16 | 1 |
145184 | 145184 | 2020-05-14 | Waupaca | Wisconsin | 55135 | 15 | 1 |
142185 | 142185 | 2020-05-13 | Waupaca | Wisconsin | 55135 | 14 | 1 |
139189 | 139189 | 2020-05-12 | Waupaca | Wisconsin | 55135 | 13 | 1 |
136198 | 136198 | 2020-05-11 | Waupaca | Wisconsin | 55135 | 13 | 1 |
133208 | 133208 | 2020-05-10 | Waupaca | Wisconsin | 55135 | 13 | 1 |
130218 | 130218 | 2020-05-09 | Waupaca | Wisconsin | 55135 | 13 | 1 |
127228 | 127228 | 2020-05-08 | Waupaca | Wisconsin | 55135 | 11 | 1 |
124243 | 124243 | 2020-05-07 | Waupaca | Wisconsin | 55135 | 10 | 1 |
121263 | 121263 | 2020-05-06 | Waupaca | Wisconsin | 55135 | 10 | 1 |
118297 | 118297 | 2020-05-05 | Waupaca | Wisconsin | 55135 | 10 | 1 |
115338 | 115338 | 2020-05-04 | Waupaca | Wisconsin | 55135 | 10 | 1 |
112455 | 112455 | 2020-05-03 | Waupaca | Wisconsin | 55135 | 10 | 1 |
109580 | 109580 | 2020-05-02 | Waupaca | Wisconsin | 55135 | 10 | 1 |
106711 | 106711 | 2020-05-01 | Waupaca | Wisconsin | 55135 | 10 | 1 |
103846 | 103846 | 2020-04-30 | Waupaca | Wisconsin | 55135 | 8 | 1 |
100991 | 100991 | 2020-04-29 | Waupaca | Wisconsin | 55135 | 8 | 1 |
98141 | 98141 | 2020-04-28 | Waupaca | Wisconsin | 55135 | 7 | 1 |
95296 | 95296 | 2020-04-27 | Waupaca | Wisconsin | 55135 | 7 | 1 |
92466 | 92466 | 2020-04-26 | Waupaca | Wisconsin | 55135 | 7 | 1 |
89648 | 89648 | 2020-04-25 | Waupaca | Wisconsin | 55135 | 7 | 1 |
86832 | 86832 | 2020-04-24 | Waupaca | Wisconsin | 55135 | 7 | 1 |
84024 | 84024 | 2020-04-23 | Waupaca | Wisconsin | 55135 | 6 | 1 |
81223 | 81223 | 2020-04-22 | Waupaca | Wisconsin | 55135 | 5 | 1 |
78430 | 78430 | 2020-04-21 | Waupaca | Wisconsin | 55135 | 4 | 1 |
75647 | 75647 | 2020-04-20 | Waupaca | Wisconsin | 55135 | 4 | 1 |
72871 | 72871 | 2020-04-19 | Waupaca | Wisconsin | 55135 | 4 | 1 |
70102 | 70102 | 2020-04-18 | Waupaca | Wisconsin | 55135 | 4 | 1 |
67340 | 67340 | 2020-04-17 | Waupaca | Wisconsin | 55135 | 4 | 1 |
64592 | 64592 | 2020-04-16 | Waupaca | Wisconsin | 55135 | 4 | 1 |
61859 | 61859 | 2020-04-15 | Waupaca | Wisconsin | 55135 | 4 | 1 |
59140 | 59140 | 2020-04-14 | Waupaca | Wisconsin | 55135 | 4 | 1 |
56432 | 56432 | 2020-04-13 | Waupaca | Wisconsin | 55135 | 4 | 1 |
53741 | 53741 | 2020-04-12 | Waupaca | Wisconsin | 55135 | 4 | 1 |
51064 | 51064 | 2020-04-11 | Waupaca | Wisconsin | 55135 | 3 | 1 |
48403 | 48403 | 2020-04-10 | Waupaca | Wisconsin | 55135 | 3 | 1 |
45774 | 45774 | 2020-04-09 | Waupaca | Wisconsin | 55135 | 3 | 1 |
43176 | 43176 | 2020-04-08 | Waupaca | Wisconsin | 55135 | 2 | 1 |
40604 | 40604 | 2020-04-07 | Waupaca | Wisconsin | 55135 | 2 | 1 |
38062 | 38062 | 2020-04-06 | Waupaca | Wisconsin | 55135 | 2 | 1 |
35575 | 35575 | 2020-04-05 | Waupaca | Wisconsin | 55135 | 2 | 1 |
33136 | 33136 | 2020-04-04 | Waupaca | Wisconsin | 55135 | 2 | 1 |
30733 | 30733 | 2020-04-03 | Waupaca | Wisconsin | 55135 | 2 | 1 |
28377 | 28377 | 2020-04-02 | Waupaca | Wisconsin | 55135 | 2 | 1 |
26083 | 26083 | 2020-04-01 | Waupaca | Wisconsin | 55135 | 2 | 1 |
23862 | 23862 | 2020-03-31 | Waupaca | Wisconsin | 55135 | 1 | 1 |
21709 | 21709 | 2020-03-30 | Waupaca | Wisconsin | 55135 | 1 | 1 |
19637 | 19637 | 2020-03-29 | Waupaca | Wisconsin | 55135 | 1 | 1 |
17668 | 17668 | 2020-03-28 | Waupaca | Wisconsin | 55135 | 1 | 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);