ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Racine" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334594 | 334594 | 2020-07-14 | Racine | Wisconsin | 55101 | 2746 | 65 |
331401 | 331401 | 2020-07-13 | Racine | Wisconsin | 55101 | 2704 | 65 |
328215 | 328215 | 2020-07-12 | Racine | Wisconsin | 55101 | 2680 | 65 |
325029 | 325029 | 2020-07-11 | Racine | Wisconsin | 55101 | 2667 | 65 |
321848 | 321848 | 2020-07-10 | Racine | Wisconsin | 55101 | 2647 | 65 |
318669 | 318669 | 2020-07-09 | Racine | Wisconsin | 55101 | 2635 | 65 |
315496 | 315496 | 2020-07-08 | Racine | Wisconsin | 55101 | 2613 | 65 |
312321 | 312321 | 2020-07-07 | Racine | Wisconsin | 55101 | 2594 | 65 |
309152 | 309152 | 2020-07-06 | Racine | Wisconsin | 55101 | 2559 | 65 |
305983 | 305983 | 2020-07-05 | Racine | Wisconsin | 55101 | 2550 | 65 |
302819 | 302819 | 2020-07-04 | Racine | Wisconsin | 55101 | 2529 | 65 |
299655 | 299655 | 2020-07-03 | Racine | Wisconsin | 55101 | 2527 | 65 |
296493 | 296493 | 2020-07-02 | Racine | Wisconsin | 55101 | 2520 | 64 |
293338 | 293338 | 2020-07-01 | Racine | Wisconsin | 55101 | 2509 | 63 |
290185 | 290185 | 2020-06-30 | Racine | Wisconsin | 55101 | 2504 | 63 |
287035 | 287035 | 2020-06-29 | Racine | Wisconsin | 55101 | 2488 | 61 |
283889 | 283889 | 2020-06-28 | Racine | Wisconsin | 55101 | 2478 | 61 |
280743 | 280743 | 2020-06-27 | Racine | Wisconsin | 55101 | 2475 | 61 |
277595 | 277595 | 2020-06-26 | Racine | Wisconsin | 55101 | 2471 | 61 |
274447 | 274447 | 2020-06-25 | Racine | Wisconsin | 55101 | 2451 | 61 |
271307 | 271307 | 2020-06-24 | Racine | Wisconsin | 55101 | 2441 | 61 |
268173 | 268173 | 2020-06-23 | Racine | Wisconsin | 55101 | 2434 | 60 |
265044 | 265044 | 2020-06-22 | Racine | Wisconsin | 55101 | 2417 | 58 |
261915 | 261915 | 2020-06-21 | Racine | Wisconsin | 55101 | 2409 | 58 |
258788 | 258788 | 2020-06-20 | Racine | Wisconsin | 55101 | 2407 | 58 |
255661 | 255661 | 2020-06-19 | Racine | Wisconsin | 55101 | 2394 | 57 |
252542 | 252542 | 2020-06-18 | Racine | Wisconsin | 55101 | 2381 | 56 |
249427 | 249427 | 2020-06-17 | Racine | Wisconsin | 55101 | 2367 | 56 |
246315 | 246315 | 2020-06-16 | Racine | Wisconsin | 55101 | 2358 | 55 |
243202 | 243202 | 2020-06-15 | Racine | Wisconsin | 55101 | 2311 | 54 |
240091 | 240091 | 2020-06-14 | Racine | Wisconsin | 55101 | 2305 | 54 |
236983 | 236983 | 2020-06-13 | Racine | Wisconsin | 55101 | 2302 | 54 |
233876 | 233876 | 2020-06-12 | Racine | Wisconsin | 55101 | 2291 | 52 |
230771 | 230771 | 2020-06-11 | Racine | Wisconsin | 55101 | 2280 | 51 |
227667 | 227667 | 2020-06-10 | Racine | Wisconsin | 55101 | 2266 | 51 |
224567 | 224567 | 2020-06-09 | Racine | Wisconsin | 55101 | 2242 | 51 |
221471 | 221471 | 2020-06-08 | Racine | Wisconsin | 55101 | 2213 | 47 |
218379 | 218379 | 2020-06-07 | Racine | Wisconsin | 55101 | 2206 | 47 |
215289 | 215289 | 2020-06-06 | Racine | Wisconsin | 55101 | 2202 | 47 |
212202 | 212202 | 2020-06-05 | Racine | Wisconsin | 55101 | 2174 | 46 |
209117 | 209117 | 2020-06-04 | Racine | Wisconsin | 55101 | 2122 | 44 |
206035 | 206035 | 2020-06-03 | Racine | Wisconsin | 55101 | 2079 | 41 |
202956 | 202956 | 2020-06-02 | Racine | Wisconsin | 55101 | 2036 | 41 |
199880 | 199880 | 2020-06-01 | Racine | Wisconsin | 55101 | 2002 | 40 |
196807 | 196807 | 2020-05-31 | Racine | Wisconsin | 55101 | 1988 | 37 |
193737 | 193737 | 2020-05-30 | Racine | Wisconsin | 55101 | 1980 | 36 |
190671 | 190671 | 2020-05-29 | Racine | Wisconsin | 55101 | 1918 | 35 |
187607 | 187607 | 2020-05-28 | Racine | Wisconsin | 55101 | 1870 | 33 |
184550 | 184550 | 2020-05-27 | Racine | Wisconsin | 55101 | 1800 | 28 |
181499 | 181499 | 2020-05-26 | Racine | Wisconsin | 55101 | 1613 | 25 |
178455 | 178455 | 2020-05-25 | Racine | Wisconsin | 55101 | 1605 | 25 |
175410 | 175410 | 2020-05-24 | Racine | Wisconsin | 55101 | 1598 | 22 |
172367 | 172367 | 2020-05-23 | Racine | Wisconsin | 55101 | 1522 | 22 |
169326 | 169326 | 2020-05-22 | Racine | Wisconsin | 55101 | 1480 | 22 |
166290 | 166290 | 2020-05-21 | Racine | Wisconsin | 55101 | 1371 | 20 |
163260 | 163260 | 2020-05-20 | Racine | Wisconsin | 55101 | 1320 | 20 |
160232 | 160232 | 2020-05-19 | Racine | Wisconsin | 55101 | 1260 | 19 |
157208 | 157208 | 2020-05-18 | Racine | Wisconsin | 55101 | 1224 | 18 |
154192 | 154192 | 2020-05-17 | Racine | Wisconsin | 55101 | 1200 | 18 |
151180 | 151180 | 2020-05-16 | Racine | Wisconsin | 55101 | 1187 | 18 |
148171 | 148171 | 2020-05-15 | Racine | Wisconsin | 55101 | 1103 | 18 |
145168 | 145168 | 2020-05-14 | Racine | Wisconsin | 55101 | 1002 | 17 |
142169 | 142169 | 2020-05-13 | Racine | Wisconsin | 55101 | 953 | 17 |
139173 | 139173 | 2020-05-12 | Racine | Wisconsin | 55101 | 927 | 17 |
136182 | 136182 | 2020-05-11 | Racine | Wisconsin | 55101 | 887 | 16 |
133192 | 133192 | 2020-05-10 | Racine | Wisconsin | 55101 | 864 | 16 |
130202 | 130202 | 2020-05-09 | Racine | Wisconsin | 55101 | 840 | 16 |
127212 | 127212 | 2020-05-08 | Racine | Wisconsin | 55101 | 794 | 16 |
124227 | 124227 | 2020-05-07 | Racine | Wisconsin | 55101 | 744 | 16 |
121247 | 121247 | 2020-05-06 | Racine | Wisconsin | 55101 | 710 | 15 |
118281 | 118281 | 2020-05-05 | Racine | Wisconsin | 55101 | 665 | 15 |
115322 | 115322 | 2020-05-04 | Racine | Wisconsin | 55101 | 583 | 14 |
112439 | 112439 | 2020-05-03 | Racine | Wisconsin | 55101 | 560 | 13 |
109564 | 109564 | 2020-05-02 | Racine | Wisconsin | 55101 | 533 | 13 |
106695 | 106695 | 2020-05-01 | Racine | Wisconsin | 55101 | 518 | 13 |
103830 | 103830 | 2020-04-30 | Racine | Wisconsin | 55101 | 474 | 12 |
100975 | 100975 | 2020-04-29 | Racine | Wisconsin | 55101 | 418 | 12 |
98125 | 98125 | 2020-04-28 | Racine | Wisconsin | 55101 | 408 | 12 |
95280 | 95280 | 2020-04-27 | Racine | Wisconsin | 55101 | 356 | 10 |
92450 | 92450 | 2020-04-26 | Racine | Wisconsin | 55101 | 345 | 10 |
89632 | 89632 | 2020-04-25 | Racine | Wisconsin | 55101 | 330 | 10 |
86816 | 86816 | 2020-04-24 | Racine | Wisconsin | 55101 | 304 | 10 |
84009 | 84009 | 2020-04-23 | Racine | Wisconsin | 55101 | 288 | 10 |
81208 | 81208 | 2020-04-22 | Racine | Wisconsin | 55101 | 268 | 10 |
78415 | 78415 | 2020-04-21 | Racine | Wisconsin | 55101 | 256 | 10 |
75632 | 75632 | 2020-04-20 | Racine | Wisconsin | 55101 | 239 | 10 |
72856 | 72856 | 2020-04-19 | Racine | Wisconsin | 55101 | 168 | 9 |
70087 | 70087 | 2020-04-18 | Racine | Wisconsin | 55101 | 164 | 8 |
67325 | 67325 | 2020-04-17 | Racine | Wisconsin | 55101 | 157 | 8 |
64577 | 64577 | 2020-04-16 | Racine | Wisconsin | 55101 | 143 | 6 |
61844 | 61844 | 2020-04-15 | Racine | Wisconsin | 55101 | 138 | 6 |
59125 | 59125 | 2020-04-14 | Racine | Wisconsin | 55101 | 135 | 5 |
56418 | 56418 | 2020-04-13 | Racine | Wisconsin | 55101 | 117 | 5 |
53727 | 53727 | 2020-04-12 | Racine | Wisconsin | 55101 | 117 | 4 |
51050 | 51050 | 2020-04-11 | Racine | Wisconsin | 55101 | 105 | 3 |
48389 | 48389 | 2020-04-10 | Racine | Wisconsin | 55101 | 100 | 3 |
45760 | 45760 | 2020-04-09 | Racine | Wisconsin | 55101 | 84 | 2 |
43163 | 43163 | 2020-04-08 | Racine | Wisconsin | 55101 | 77 | 2 |
40591 | 40591 | 2020-04-07 | Racine | Wisconsin | 55101 | 66 | 2 |
38049 | 38049 | 2020-04-06 | Racine | Wisconsin | 55101 | 57 | 2 |
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);