ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where county = "Unknown" and state = "Wisconsin" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
227678 | 227678 | 2020-06-10 | Unknown | Wisconsin | 2005 | 6 | |
230782 | 230782 | 2020-06-11 | Unknown | Wisconsin | 2048 | 6 | |
233887 | 233887 | 2020-06-12 | Unknown | Wisconsin | 2072 | 6 | |
236994 | 236994 | 2020-06-13 | Unknown | Wisconsin | 2072 | 6 | |
240102 | 240102 | 2020-06-14 | Unknown | Wisconsin | 2133 | 6 | |
243213 | 243213 | 2020-06-15 | Unknown | Wisconsin | 2138 | 6 | |
246326 | 246326 | 2020-06-16 | Unknown | Wisconsin | 2176 | 6 | |
249438 | 249438 | 2020-06-17 | Unknown | Wisconsin | 2207 | 6 | |
252553 | 252553 | 2020-06-18 | Unknown | Wisconsin | 2240 | 6 | |
255672 | 255672 | 2020-06-19 | Unknown | Wisconsin | 2272 | 6 | |
258799 | 258799 | 2020-06-20 | Unknown | Wisconsin | 2329 | 7 | |
261926 | 261926 | 2020-06-21 | Unknown | Wisconsin | 2350 | 7 | |
265055 | 265055 | 2020-06-22 | Unknown | Wisconsin | 2341 | 6 | |
268184 | 268184 | 2020-06-23 | Unknown | Wisconsin | 2364 | 7 | |
271318 | 271318 | 2020-06-24 | Unknown | Wisconsin | 2403 | 7 | |
274458 | 274458 | 2020-06-25 | Unknown | Wisconsin | 2446 | 7 | |
277606 | 277606 | 2020-06-26 | Unknown | Wisconsin | 2489 | 7 | |
280754 | 280754 | 2020-06-27 | Unknown | Wisconsin | 2521 | 7 | |
283900 | 283900 | 2020-06-28 | Unknown | Wisconsin | 2532 | 7 | |
287046 | 287046 | 2020-06-29 | Unknown | Wisconsin | 2538 | 7 | |
290196 | 290196 | 2020-06-30 | Unknown | Wisconsin | 2538 | 7 | |
293349 | 293349 | 2020-07-01 | Unknown | Wisconsin | 2588 | 7 | |
296504 | 296504 | 2020-07-02 | Unknown | Wisconsin | 2633 | 7 | |
299666 | 299666 | 2020-07-03 | Unknown | Wisconsin | 2676 | 7 | |
302830 | 302830 | 2020-07-04 | Unknown | Wisconsin | 2713 | 7 | |
305994 | 305994 | 2020-07-05 | Unknown | Wisconsin | 2724 | 7 | |
309163 | 309163 | 2020-07-06 | Unknown | Wisconsin | 2722 | 7 | |
312332 | 312332 | 2020-07-07 | Unknown | Wisconsin | 2762 | 7 | |
315507 | 315507 | 2020-07-08 | Unknown | Wisconsin | 2762 | 7 | |
318680 | 318680 | 2020-07-09 | Unknown | Wisconsin | 2855 | 7 | |
321859 | 321859 | 2020-07-10 | Unknown | Wisconsin | 2999 | 7 | |
325040 | 325040 | 2020-07-11 | Unknown | Wisconsin | 2948 | 7 | |
328226 | 328226 | 2020-07-12 | Unknown | Wisconsin | 2976 | 7 | |
331412 | 331412 | 2020-07-13 | Unknown | Wisconsin | 2970 | 7 | |
334605 | 334605 | 2020-07-14 | Unknown | Wisconsin | 2972 | 7 | |
337800 | 337800 | 2020-07-15 | Unknown | Wisconsin | 2996 | 7 | |
340996 | 340996 | 2020-07-16 | Unknown | Wisconsin | 3041 | 7 | |
344195 | 344195 | 2020-07-17 | Unknown | Wisconsin | 3082 | 7 | |
347395 | 347395 | 2020-07-18 | Unknown | Wisconsin | 3135 | 7 | |
350596 | 350596 | 2020-07-19 | Unknown | Wisconsin | 3154 | 7 | |
353798 | 353798 | 2020-07-20 | Unknown | Wisconsin | 3163 | 7 | |
357001 | 357001 | 2020-07-21 | Unknown | Wisconsin | 3207 | 7 | |
360206 | 360206 | 2020-07-22 | Unknown | Wisconsin | 3240 | 7 | |
363412 | 363412 | 2020-07-23 | Unknown | Wisconsin | 3276 | 7 | |
366619 | 366619 | 2020-07-24 | Unknown | Wisconsin | 3314 | 7 | |
369829 | 369829 | 2020-07-25 | Unknown | Wisconsin | 3344 | 7 | |
373041 | 373041 | 2020-07-26 | Unknown | Wisconsin | 3352 | 7 | |
376255 | 376255 | 2020-07-27 | Unknown | Wisconsin | 3345 | 7 | |
379471 | 379471 | 2020-07-28 | Unknown | Wisconsin | 3367 | 7 | |
382688 | 382688 | 2020-07-29 | Unknown | Wisconsin | 3418 | 7 | |
385906 | 385906 | 2020-07-30 | Unknown | Wisconsin | 3453 | 7 | |
389123 | 389123 | 2020-07-31 | Unknown | Wisconsin | 3471 | 7 | |
392340 | 392340 | 2020-08-01 | Unknown | Wisconsin | 3533 | 7 | |
395556 | 395556 | 2020-08-02 | Unknown | Wisconsin | 3543 | 7 | |
398772 | 398772 | 2020-08-03 | Unknown | Wisconsin | 3533 | 7 | |
401988 | 401988 | 2020-08-04 | Unknown | Wisconsin | 3576 | 7 | |
405206 | 405206 | 2020-08-05 | Unknown | Wisconsin | 3630 | 7 | |
408426 | 408426 | 2020-08-06 | Unknown | Wisconsin | 3666 | 7 | |
411645 | 411645 | 2020-08-07 | Unknown | Wisconsin | 3720 | 7 | |
414865 | 414865 | 2020-08-08 | Unknown | Wisconsin | 3740 | 7 | |
418086 | 418086 | 2020-08-09 | Unknown | Wisconsin | 3741 | 7 | |
421307 | 421307 | 2020-08-10 | Unknown | Wisconsin | 3746 | 7 | |
424528 | 424528 | 2020-08-11 | Unknown | Wisconsin | 3789 | 7 | |
427752 | 427752 | 2020-08-12 | Unknown | Wisconsin | 3842 | 7 | |
430980 | 430980 | 2020-08-13 | Unknown | Wisconsin | 3867 | 7 | |
434205 | 434205 | 2020-08-14 | Unknown | Wisconsin | 3905 | 7 | |
437431 | 437431 | 2020-08-15 | Unknown | Wisconsin | 3942 | 7 | |
440657 | 440657 | 2020-08-16 | Unknown | Wisconsin | 3956 | 7 | |
443883 | 443883 | 2020-08-17 | Unknown | Wisconsin | 3966 | 7 | |
447110 | 447110 | 2020-08-18 | Unknown | Wisconsin | 4041 | 7 | |
450338 | 450338 | 2020-08-19 | Unknown | Wisconsin | 4088 | 7 | |
453566 | 453566 | 2020-08-20 | Unknown | Wisconsin | 4117 | 7 | |
456794 | 456794 | 2020-08-21 | Unknown | Wisconsin | 4139 | 7 | |
460021 | 460021 | 2020-08-22 | Unknown | Wisconsin | 4164 | 8 | |
463250 | 463250 | 2020-08-23 | Unknown | Wisconsin | 4182 | 8 | |
466479 | 466479 | 2020-08-24 | Unknown | Wisconsin | 4183 | 8 | |
469708 | 469708 | 2020-08-25 | Unknown | Wisconsin | 4232 | 8 | |
472940 | 472940 | 2020-08-26 | Unknown | Wisconsin | 4250 | 8 | |
476173 | 476173 | 2020-08-27 | Unknown | Wisconsin | 4284 | 8 | |
479406 | 479406 | 2020-08-28 | Unknown | Wisconsin | 4305 | 8 | |
482640 | 482640 | 2020-08-29 | Unknown | Wisconsin | 4348 | 8 | |
485875 | 485875 | 2020-08-30 | Unknown | Wisconsin | 4381 | 8 | |
489108 | 489108 | 2020-08-31 | Unknown | Wisconsin | 4368 | 8 | |
492341 | 492341 | 2020-09-01 | Unknown | Wisconsin | 4423 | 9 | |
495575 | 495575 | 2020-09-02 | Unknown | Wisconsin | 4456 | 8 | |
498808 | 498808 | 2020-09-03 | Unknown | Wisconsin | 4469 | 8 | |
502042 | 502042 | 2020-09-04 | Unknown | Wisconsin | 0 | 8 | |
505276 | 505276 | 2020-09-05 | Unknown | Wisconsin | 0 | 8 | |
508508 | 508508 | 2020-09-06 | Unknown | Wisconsin | 0 | 8 | |
511741 | 511741 | 2020-09-07 | Unknown | Wisconsin | 0 | 8 | |
514974 | 514974 | 2020-09-08 | Unknown | Wisconsin | 0 | 8 | |
518209 | 518209 | 2020-09-09 | Unknown | Wisconsin | 0 | 8 | |
521446 | 521446 | 2020-09-10 | Unknown | Wisconsin | 0 | 8 | |
524682 | 524682 | 2020-09-11 | Unknown | Wisconsin | 0 | 8 | |
527918 | 527918 | 2020-09-12 | Unknown | Wisconsin | 0 | 8 | |
531155 | 531155 | 2020-09-13 | Unknown | Wisconsin | 0 | 8 | |
534390 | 534390 | 2020-09-14 | Unknown | Wisconsin | 0 | 8 | |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
540863 | 540863 | 2020-09-16 | Unknown | Wisconsin | 0 | 9 | |
544099 | 544099 | 2020-09-17 | Unknown | Wisconsin | 0 | 8 |
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);