ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Milwaukee" and state = "Wisconsin" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- …
state 1
- Wisconsin · 792 ✖
fips 1
- 55079 792
county 1
- Milwaukee · 792 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1928 | 1928 | 2020-03-13 | Milwaukee | Wisconsin | 55079 | 2 | 0 |
2302 | 2302 | 2020-03-14 | Milwaukee | Wisconsin | 55079 | 6 | 0 |
2731 | 2731 | 2020-03-15 | Milwaukee | Wisconsin | 55079 | 7 | 0 |
3205 | 3205 | 2020-03-16 | Milwaukee | Wisconsin | 55079 | 13 | 0 |
3749 | 3749 | 2020-03-17 | Milwaukee | Wisconsin | 55079 | 24 | 0 |
4387 | 4387 | 2020-03-18 | Milwaukee | Wisconsin | 55079 | 47 | 0 |
5150 | 5150 | 2020-03-19 | Milwaukee | Wisconsin | 55079 | 62 | 0 |
6062 | 6062 | 2020-03-20 | Milwaukee | Wisconsin | 55079 | 95 | 1 |
7095 | 7095 | 2020-03-21 | Milwaukee | Wisconsin | 55079 | 126 | 2 |
8233 | 8233 | 2020-03-22 | Milwaukee | Wisconsin | 55079 | 183 | 2 |
9459 | 9459 | 2020-03-23 | Milwaukee | Wisconsin | 55079 | 206 | 3 |
10813 | 10813 | 2020-03-24 | Milwaukee | Wisconsin | 55079 | 243 | 3 |
12343 | 12343 | 2020-03-25 | Milwaukee | Wisconsin | 55079 | 325 | 4 |
13997 | 13997 | 2020-03-26 | Milwaukee | Wisconsin | 55079 | 393 | 7 |
15771 | 15771 | 2020-03-27 | Milwaukee | Wisconsin | 55079 | 468 | 9 |
17651 | 17651 | 2020-03-28 | Milwaukee | Wisconsin | 55079 | 541 | 9 |
19620 | 19620 | 2020-03-29 | Milwaukee | Wisconsin | 55079 | 565 | 9 |
21692 | 21692 | 2020-03-30 | Milwaukee | Wisconsin | 55079 | 663 | 10 |
23844 | 23844 | 2020-03-31 | Milwaukee | Wisconsin | 55079 | 674 | 11 |
26065 | 26065 | 2020-04-01 | Milwaukee | Wisconsin | 55079 | 780 | 16 |
28358 | 28358 | 2020-04-02 | Milwaukee | Wisconsin | 55079 | 869 | 18 |
30713 | 30713 | 2020-04-03 | Milwaukee | Wisconsin | 55079 | 955 | 28 |
33115 | 33115 | 2020-04-04 | Milwaukee | Wisconsin | 55079 | 1069 | 29 |
35554 | 35554 | 2020-04-05 | Milwaukee | Wisconsin | 55079 | 1148 | 39 |
38041 | 38041 | 2020-04-06 | Milwaukee | Wisconsin | 55079 | 1256 | 45 |
40583 | 40583 | 2020-04-07 | Milwaukee | Wisconsin | 55079 | 1323 | 49 |
43155 | 43155 | 2020-04-08 | Milwaukee | Wisconsin | 55079 | 1417 | 59 |
45752 | 45752 | 2020-04-09 | Milwaukee | Wisconsin | 55079 | 1484 | 67 |
48380 | 48380 | 2020-04-10 | Milwaukee | Wisconsin | 55079 | 1575 | 77 |
51040 | 51040 | 2020-04-11 | Milwaukee | Wisconsin | 55079 | 1653 | 85 |
53717 | 53717 | 2020-04-12 | Milwaukee | Wisconsin | 55079 | 1710 | 88 |
56408 | 56408 | 2020-04-13 | Milwaukee | Wisconsin | 55079 | 1743 | 94 |
59115 | 59115 | 2020-04-14 | Milwaukee | Wisconsin | 55079 | 1795 | 101 |
61834 | 61834 | 2020-04-15 | Milwaukee | Wisconsin | 55079 | 1870 | 105 |
64567 | 64567 | 2020-04-16 | Milwaukee | Wisconsin | 55079 | 1947 | 114 |
67315 | 67315 | 2020-04-17 | Milwaukee | Wisconsin | 55079 | 2013 | 120 |
70077 | 70077 | 2020-04-18 | Milwaukee | Wisconsin | 55079 | 2065 | 122 |
72846 | 72846 | 2020-04-19 | Milwaukee | Wisconsin | 55079 | 2150 | 125 |
75622 | 75622 | 2020-04-20 | Milwaukee | Wisconsin | 55079 | 2191 | 132 |
78405 | 78405 | 2020-04-21 | Milwaukee | Wisconsin | 55079 | 2234 | 139 |
81198 | 81198 | 2020-04-22 | Milwaukee | Wisconsin | 55079 | 2304 | 142 |
83999 | 83999 | 2020-04-23 | Milwaukee | Wisconsin | 55079 | 2382 | 150 |
86806 | 86806 | 2020-04-24 | Milwaukee | Wisconsin | 55079 | 2431 | 154 |
89622 | 89622 | 2020-04-25 | Milwaukee | Wisconsin | 55079 | 2525 | 157 |
92440 | 92440 | 2020-04-26 | Milwaukee | Wisconsin | 55079 | 2629 | 162 |
95270 | 95270 | 2020-04-27 | Milwaukee | Wisconsin | 55079 | 2674 | 167 |
98115 | 98115 | 2020-04-28 | Milwaukee | Wisconsin | 55079 | 2722 | 174 |
100965 | 100965 | 2020-04-29 | Milwaukee | Wisconsin | 55079 | 2815 | 177 |
103820 | 103820 | 2020-04-30 | Milwaukee | Wisconsin | 55079 | 2940 | 181 |
106685 | 106685 | 2020-05-01 | Milwaukee | Wisconsin | 55079 | 3044 | 186 |
109554 | 109554 | 2020-05-02 | Milwaukee | Wisconsin | 55079 | 3147 | 191 |
112429 | 112429 | 2020-05-03 | Milwaukee | Wisconsin | 55079 | 3244 | 195 |
115312 | 115312 | 2020-05-04 | Milwaukee | Wisconsin | 55079 | 3296 | 195 |
118271 | 118271 | 2020-05-05 | Milwaukee | Wisconsin | 55079 | 3353 | 201 |
121237 | 121237 | 2020-05-06 | Milwaukee | Wisconsin | 55079 | 3469 | 204 |
124217 | 124217 | 2020-05-07 | Milwaukee | Wisconsin | 55079 | 3573 | 212 |
127202 | 127202 | 2020-05-08 | Milwaukee | Wisconsin | 55079 | 3722 | 219 |
130192 | 130192 | 2020-05-09 | Milwaukee | Wisconsin | 55079 | 3854 | 224 |
133182 | 133182 | 2020-05-10 | Milwaukee | Wisconsin | 55079 | 3952 | 225 |
136172 | 136172 | 2020-05-11 | Milwaukee | Wisconsin | 55079 | 4022 | 231 |
139163 | 139163 | 2020-05-12 | Milwaukee | Wisconsin | 55079 | 4069 | 235 |
142159 | 142159 | 2020-05-13 | Milwaukee | Wisconsin | 55079 | 4215 | 236 |
145157 | 145157 | 2020-05-14 | Milwaukee | Wisconsin | 55079 | 4387 | 242 |
148160 | 148160 | 2020-05-15 | Milwaukee | Wisconsin | 55079 | 4694 | 249 |
151169 | 151169 | 2020-05-16 | Milwaukee | Wisconsin | 55079 | 4936 | 252 |
154181 | 154181 | 2020-05-17 | Milwaukee | Wisconsin | 55079 | 4973 | 252 |
157197 | 157197 | 2020-05-18 | Milwaukee | Wisconsin | 55079 | 5040 | 256 |
160221 | 160221 | 2020-05-19 | Milwaukee | Wisconsin | 55079 | 5185 | 260 |
163249 | 163249 | 2020-05-20 | Milwaukee | Wisconsin | 55079 | 5531 | 265 |
166279 | 166279 | 2020-05-21 | Milwaukee | Wisconsin | 55079 | 5631 | 269 |
169315 | 169315 | 2020-05-22 | Milwaukee | Wisconsin | 55079 | 5893 | 270 |
172356 | 172356 | 2020-05-23 | Milwaukee | Wisconsin | 55079 | 6092 | 276 |
175399 | 175399 | 2020-05-24 | Milwaukee | Wisconsin | 55079 | 6265 | 276 |
178444 | 178444 | 2020-05-25 | Milwaukee | Wisconsin | 55079 | 6403 | 276 |
181488 | 181488 | 2020-05-26 | Milwaukee | Wisconsin | 55079 | 6577 | 277 |
184539 | 184539 | 2020-05-27 | Milwaukee | Wisconsin | 55079 | 6848 | 282 |
187596 | 187596 | 2020-05-28 | Milwaukee | Wisconsin | 55079 | 7182 | 285 |
190660 | 190660 | 2020-05-29 | Milwaukee | Wisconsin | 55079 | 7498 | 294 |
193726 | 193726 | 2020-05-30 | Milwaukee | Wisconsin | 55079 | 7672 | 299 |
196796 | 196796 | 2020-05-31 | Milwaukee | Wisconsin | 55079 | 7750 | 299 |
199869 | 199869 | 2020-06-01 | Milwaukee | Wisconsin | 55079 | 7800 | 299 |
202945 | 202945 | 2020-06-02 | Milwaukee | Wisconsin | 55079 | 8016 | 309 |
206024 | 206024 | 2020-06-03 | Milwaukee | Wisconsin | 55079 | 8206 | 315 |
209106 | 209106 | 2020-06-04 | Milwaukee | Wisconsin | 55079 | 8463 | 316 |
212191 | 212191 | 2020-06-05 | Milwaukee | Wisconsin | 55079 | 8608 | 317 |
215278 | 215278 | 2020-06-06 | Milwaukee | Wisconsin | 55079 | 8709 | 325 |
221460 | 221460 | 2020-06-08 | Milwaukee | Wisconsin | 55079 | 8925 | 325 |
218368 | 218368 | 2020-06-07 | Milwaukee | Wisconsin | 55079 | 8827 | 326 |
224556 | 224556 | 2020-06-09 | Milwaukee | Wisconsin | 55079 | 9001 | 331 |
227656 | 227656 | 2020-06-10 | Milwaukee | Wisconsin | 55079 | 9161 | 336 |
230760 | 230760 | 2020-06-11 | Milwaukee | Wisconsin | 55079 | 9220 | 346 |
233865 | 233865 | 2020-06-12 | Milwaukee | Wisconsin | 55079 | 9310 | 349 |
236972 | 236972 | 2020-06-13 | Milwaukee | Wisconsin | 55079 | 9438 | 350 |
240080 | 240080 | 2020-06-14 | Milwaukee | Wisconsin | 55079 | 9511 | 350 |
243191 | 243191 | 2020-06-15 | Milwaukee | Wisconsin | 55079 | 9610 | 350 |
246304 | 246304 | 2020-06-16 | Milwaukee | Wisconsin | 55079 | 9678 | 352 |
249416 | 249416 | 2020-06-17 | Milwaukee | Wisconsin | 55079 | 9818 | 356 |
252531 | 252531 | 2020-06-18 | Milwaukee | Wisconsin | 55079 | 9995 | 360 |
255650 | 255650 | 2020-06-19 | Milwaukee | Wisconsin | 55079 | 10087 | 362 |
258777 | 258777 | 2020-06-20 | Milwaukee | Wisconsin | 55079 | 10167 | 371 |
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);