ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Shawano" and state = "Wisconsin" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
33128 | 33128 | 2020-04-04 | Shawano | Wisconsin | 55115 | 1 | 0 |
35567 | 35567 | 2020-04-05 | Shawano | Wisconsin | 55115 | 1 | 0 |
38054 | 38054 | 2020-04-06 | Shawano | Wisconsin | 55115 | 2 | 0 |
40596 | 40596 | 2020-04-07 | Shawano | Wisconsin | 55115 | 3 | 0 |
43168 | 43168 | 2020-04-08 | Shawano | Wisconsin | 55115 | 4 | 0 |
45766 | 45766 | 2020-04-09 | Shawano | Wisconsin | 55115 | 4 | 0 |
48395 | 48395 | 2020-04-10 | Shawano | Wisconsin | 55115 | 5 | 0 |
51056 | 51056 | 2020-04-11 | Shawano | Wisconsin | 55115 | 5 | 0 |
53733 | 53733 | 2020-04-12 | Shawano | Wisconsin | 55115 | 5 | 0 |
56424 | 56424 | 2020-04-13 | Shawano | Wisconsin | 55115 | 5 | 0 |
59131 | 59131 | 2020-04-14 | Shawano | Wisconsin | 55115 | 6 | 0 |
61850 | 61850 | 2020-04-15 | Shawano | Wisconsin | 55115 | 6 | 0 |
64583 | 64583 | 2020-04-16 | Shawano | Wisconsin | 55115 | 6 | 0 |
67331 | 67331 | 2020-04-17 | Shawano | Wisconsin | 55115 | 6 | 0 |
70093 | 70093 | 2020-04-18 | Shawano | Wisconsin | 55115 | 6 | 0 |
72862 | 72862 | 2020-04-19 | Shawano | Wisconsin | 55115 | 6 | 0 |
75638 | 75638 | 2020-04-20 | Shawano | Wisconsin | 55115 | 6 | 0 |
78421 | 78421 | 2020-04-21 | Shawano | Wisconsin | 55115 | 6 | 0 |
81214 | 81214 | 2020-04-22 | Shawano | Wisconsin | 55115 | 6 | 0 |
84015 | 84015 | 2020-04-23 | Shawano | Wisconsin | 55115 | 6 | 0 |
86822 | 86822 | 2020-04-24 | Shawano | Wisconsin | 55115 | 8 | 0 |
89638 | 89638 | 2020-04-25 | Shawano | Wisconsin | 55115 | 8 | 0 |
92456 | 92456 | 2020-04-26 | Shawano | Wisconsin | 55115 | 8 | 0 |
95286 | 95286 | 2020-04-27 | Shawano | Wisconsin | 55115 | 8 | 0 |
98131 | 98131 | 2020-04-28 | Shawano | Wisconsin | 55115 | 8 | 0 |
100981 | 100981 | 2020-04-29 | Shawano | Wisconsin | 55115 | 10 | 0 |
103836 | 103836 | 2020-04-30 | Shawano | Wisconsin | 55115 | 10 | 0 |
106701 | 106701 | 2020-05-01 | Shawano | Wisconsin | 55115 | 15 | 0 |
109570 | 109570 | 2020-05-02 | Shawano | Wisconsin | 55115 | 16 | 0 |
112445 | 112445 | 2020-05-03 | Shawano | Wisconsin | 55115 | 16 | 0 |
115328 | 115328 | 2020-05-04 | Shawano | Wisconsin | 55115 | 16 | 0 |
118287 | 118287 | 2020-05-05 | Shawano | Wisconsin | 55115 | 17 | 0 |
121253 | 121253 | 2020-05-06 | Shawano | Wisconsin | 55115 | 17 | 0 |
124233 | 124233 | 2020-05-07 | Shawano | Wisconsin | 55115 | 17 | 0 |
127218 | 127218 | 2020-05-08 | Shawano | Wisconsin | 55115 | 20 | 0 |
130208 | 130208 | 2020-05-09 | Shawano | Wisconsin | 55115 | 20 | 0 |
133198 | 133198 | 2020-05-10 | Shawano | Wisconsin | 55115 | 22 | 0 |
136188 | 136188 | 2020-05-11 | Shawano | Wisconsin | 55115 | 25 | 0 |
139179 | 139179 | 2020-05-12 | Shawano | Wisconsin | 55115 | 25 | 0 |
142175 | 142175 | 2020-05-13 | Shawano | Wisconsin | 55115 | 27 | 0 |
145174 | 145174 | 2020-05-14 | Shawano | Wisconsin | 55115 | 28 | 0 |
148177 | 148177 | 2020-05-15 | Shawano | Wisconsin | 55115 | 29 | 0 |
151186 | 151186 | 2020-05-16 | Shawano | Wisconsin | 55115 | 31 | 0 |
154198 | 154198 | 2020-05-17 | Shawano | Wisconsin | 55115 | 31 | 0 |
157214 | 157214 | 2020-05-18 | Shawano | Wisconsin | 55115 | 33 | 0 |
160238 | 160238 | 2020-05-19 | Shawano | Wisconsin | 55115 | 33 | 0 |
163266 | 163266 | 2020-05-20 | Shawano | Wisconsin | 55115 | 34 | 0 |
166296 | 166296 | 2020-05-21 | Shawano | Wisconsin | 55115 | 36 | 0 |
169332 | 169332 | 2020-05-22 | Shawano | Wisconsin | 55115 | 36 | 0 |
172373 | 172373 | 2020-05-23 | Shawano | Wisconsin | 55115 | 37 | 0 |
175416 | 175416 | 2020-05-24 | Shawano | Wisconsin | 55115 | 38 | 0 |
178461 | 178461 | 2020-05-25 | Shawano | Wisconsin | 55115 | 38 | 0 |
181505 | 181505 | 2020-05-26 | Shawano | Wisconsin | 55115 | 38 | 0 |
184556 | 184556 | 2020-05-27 | Shawano | Wisconsin | 55115 | 41 | 0 |
187613 | 187613 | 2020-05-28 | Shawano | Wisconsin | 55115 | 43 | 0 |
190677 | 190677 | 2020-05-29 | Shawano | Wisconsin | 55115 | 45 | 0 |
193743 | 193743 | 2020-05-30 | Shawano | Wisconsin | 55115 | 46 | 0 |
196813 | 196813 | 2020-05-31 | Shawano | Wisconsin | 55115 | 47 | 0 |
199886 | 199886 | 2020-06-01 | Shawano | Wisconsin | 55115 | 48 | 0 |
202962 | 202962 | 2020-06-02 | Shawano | Wisconsin | 55115 | 50 | 0 |
206041 | 206041 | 2020-06-03 | Shawano | Wisconsin | 55115 | 51 | 0 |
209123 | 209123 | 2020-06-04 | Shawano | Wisconsin | 55115 | 53 | 0 |
212208 | 212208 | 2020-06-05 | Shawano | Wisconsin | 55115 | 53 | 0 |
215295 | 215295 | 2020-06-06 | Shawano | Wisconsin | 55115 | 56 | 0 |
218385 | 218385 | 2020-06-07 | Shawano | Wisconsin | 55115 | 56 | 0 |
221477 | 221477 | 2020-06-08 | Shawano | Wisconsin | 55115 | 57 | 0 |
224573 | 224573 | 2020-06-09 | Shawano | Wisconsin | 55115 | 60 | 0 |
227673 | 227673 | 2020-06-10 | Shawano | Wisconsin | 55115 | 60 | 0 |
230777 | 230777 | 2020-06-11 | Shawano | Wisconsin | 55115 | 60 | 0 |
233882 | 233882 | 2020-06-12 | Shawano | Wisconsin | 55115 | 62 | 0 |
236989 | 236989 | 2020-06-13 | Shawano | Wisconsin | 55115 | 62 | 0 |
240097 | 240097 | 2020-06-14 | Shawano | Wisconsin | 55115 | 63 | 0 |
243208 | 243208 | 2020-06-15 | Shawano | Wisconsin | 55115 | 64 | 0 |
246321 | 246321 | 2020-06-16 | Shawano | Wisconsin | 55115 | 64 | 0 |
249433 | 249433 | 2020-06-17 | Shawano | Wisconsin | 55115 | 64 | 0 |
252548 | 252548 | 2020-06-18 | Shawano | Wisconsin | 55115 | 66 | 0 |
255667 | 255667 | 2020-06-19 | Shawano | Wisconsin | 55115 | 66 | 0 |
258794 | 258794 | 2020-06-20 | Shawano | Wisconsin | 55115 | 68 | 0 |
261921 | 261921 | 2020-06-21 | Shawano | Wisconsin | 55115 | 68 | 0 |
265050 | 265050 | 2020-06-22 | Shawano | Wisconsin | 55115 | 70 | 0 |
268179 | 268179 | 2020-06-23 | Shawano | Wisconsin | 55115 | 70 | 0 |
271313 | 271313 | 2020-06-24 | Shawano | Wisconsin | 55115 | 70 | 0 |
274453 | 274453 | 2020-06-25 | Shawano | Wisconsin | 55115 | 73 | 0 |
277601 | 277601 | 2020-06-26 | Shawano | Wisconsin | 55115 | 74 | 0 |
280749 | 280749 | 2020-06-27 | Shawano | Wisconsin | 55115 | 75 | 0 |
283895 | 283895 | 2020-06-28 | Shawano | Wisconsin | 55115 | 75 | 0 |
287041 | 287041 | 2020-06-29 | Shawano | Wisconsin | 55115 | 76 | 0 |
290191 | 290191 | 2020-06-30 | Shawano | Wisconsin | 55115 | 78 | 0 |
293344 | 293344 | 2020-07-01 | Shawano | Wisconsin | 55115 | 78 | 0 |
296499 | 296499 | 2020-07-02 | Shawano | Wisconsin | 55115 | 78 | 0 |
299661 | 299661 | 2020-07-03 | Shawano | Wisconsin | 55115 | 81 | 0 |
302825 | 302825 | 2020-07-04 | Shawano | Wisconsin | 55115 | 83 | 0 |
305989 | 305989 | 2020-07-05 | Shawano | Wisconsin | 55115 | 86 | 0 |
309158 | 309158 | 2020-07-06 | Shawano | Wisconsin | 55115 | 86 | 0 |
312327 | 312327 | 2020-07-07 | Shawano | Wisconsin | 55115 | 86 | 0 |
315502 | 315502 | 2020-07-08 | Shawano | Wisconsin | 55115 | 87 | 0 |
318675 | 318675 | 2020-07-09 | Shawano | Wisconsin | 55115 | 89 | 0 |
321854 | 321854 | 2020-07-10 | Shawano | Wisconsin | 55115 | 91 | 0 |
325035 | 325035 | 2020-07-11 | Shawano | Wisconsin | 55115 | 94 | 0 |
328221 | 328221 | 2020-07-12 | Shawano | Wisconsin | 55115 | 95 | 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);