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 |
---|---|---|---|---|---|---|---|
389112 | 389112 | 2020-07-31 | Racine | Wisconsin | 55101 | 3483 | 77 |
385895 | 385895 | 2020-07-30 | Racine | Wisconsin | 55101 | 3446 | 75 |
382677 | 382677 | 2020-07-29 | Racine | Wisconsin | 55101 | 3399 | 75 |
379460 | 379460 | 2020-07-28 | Racine | Wisconsin | 55101 | 3372 | 73 |
376244 | 376244 | 2020-07-27 | Racine | Wisconsin | 55101 | 3339 | 72 |
373030 | 373030 | 2020-07-26 | Racine | Wisconsin | 55101 | 3276 | 72 |
369818 | 369818 | 2020-07-25 | Racine | Wisconsin | 55101 | 3251 | 72 |
366608 | 366608 | 2020-07-24 | Racine | Wisconsin | 55101 | 3209 | 69 |
363401 | 363401 | 2020-07-23 | Racine | Wisconsin | 55101 | 3164 | 69 |
360195 | 360195 | 2020-07-22 | Racine | Wisconsin | 55101 | 3109 | 69 |
356990 | 356990 | 2020-07-21 | Racine | Wisconsin | 55101 | 3085 | 69 |
353787 | 353787 | 2020-07-20 | Racine | Wisconsin | 55101 | 2994 | 66 |
350585 | 350585 | 2020-07-19 | Racine | Wisconsin | 55101 | 2944 | 66 |
347384 | 347384 | 2020-07-18 | Racine | Wisconsin | 55101 | 2919 | 66 |
344184 | 344184 | 2020-07-17 | Racine | Wisconsin | 55101 | 2874 | 66 |
340985 | 340985 | 2020-07-16 | Racine | Wisconsin | 55101 | 2818 | 66 |
337789 | 337789 | 2020-07-15 | Racine | Wisconsin | 55101 | 2773 | 65 |
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 |
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);