ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walworth" and state = "Wisconsin" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280757 | 280757 | 2020-06-27 | Walworth | Wisconsin | 55127 | 570 | 18 |
283903 | 283903 | 2020-06-28 | Walworth | Wisconsin | 55127 | 572 | 18 |
287049 | 287049 | 2020-06-29 | Walworth | Wisconsin | 55127 | 574 | 18 |
290199 | 290199 | 2020-06-30 | Walworth | Wisconsin | 55127 | 607 | 18 |
293352 | 293352 | 2020-07-01 | Walworth | Wisconsin | 55127 | 612 | 18 |
296507 | 296507 | 2020-07-02 | Walworth | Wisconsin | 55127 | 622 | 18 |
299669 | 299669 | 2020-07-03 | Walworth | Wisconsin | 55127 | 650 | 18 |
302833 | 302833 | 2020-07-04 | Walworth | Wisconsin | 55127 | 677 | 18 |
305997 | 305997 | 2020-07-05 | Walworth | Wisconsin | 55127 | 689 | 18 |
309166 | 309166 | 2020-07-06 | Walworth | Wisconsin | 55127 | 691 | 18 |
312335 | 312335 | 2020-07-07 | Walworth | Wisconsin | 55127 | 701 | 18 |
315510 | 315510 | 2020-07-08 | Walworth | Wisconsin | 55127 | 713 | 18 |
318683 | 318683 | 2020-07-09 | Walworth | Wisconsin | 55127 | 723 | 18 |
321862 | 321862 | 2020-07-10 | Walworth | Wisconsin | 55127 | 734 | 18 |
325043 | 325043 | 2020-07-11 | Walworth | Wisconsin | 55127 | 752 | 18 |
328229 | 328229 | 2020-07-12 | Walworth | Wisconsin | 55127 | 754 | 18 |
331415 | 331415 | 2020-07-13 | Walworth | Wisconsin | 55127 | 791 | 18 |
334608 | 334608 | 2020-07-14 | Walworth | Wisconsin | 55127 | 800 | 18 |
337803 | 337803 | 2020-07-15 | Walworth | Wisconsin | 55127 | 815 | 18 |
340999 | 340999 | 2020-07-16 | Walworth | Wisconsin | 55127 | 826 | 18 |
344198 | 344198 | 2020-07-17 | Walworth | Wisconsin | 55127 | 858 | 18 |
347398 | 347398 | 2020-07-18 | Walworth | Wisconsin | 55127 | 897 | 18 |
350599 | 350599 | 2020-07-19 | Walworth | Wisconsin | 55127 | 902 | 18 |
353801 | 353801 | 2020-07-20 | Walworth | Wisconsin | 55127 | 942 | 18 |
357004 | 357004 | 2020-07-21 | Walworth | Wisconsin | 55127 | 964 | 18 |
360209 | 360209 | 2020-07-22 | Walworth | Wisconsin | 55127 | 983 | 19 |
363415 | 363415 | 2020-07-23 | Walworth | Wisconsin | 55127 | 993 | 20 |
366622 | 366622 | 2020-07-24 | Walworth | Wisconsin | 55127 | 1006 | 20 |
369832 | 369832 | 2020-07-25 | Walworth | Wisconsin | 55127 | 1024 | 21 |
373044 | 373044 | 2020-07-26 | Walworth | Wisconsin | 55127 | 1051 | 21 |
376258 | 376258 | 2020-07-27 | Walworth | Wisconsin | 55127 | 1067 | 21 |
379474 | 379474 | 2020-07-28 | Walworth | Wisconsin | 55127 | 1083 | 21 |
382691 | 382691 | 2020-07-29 | Walworth | Wisconsin | 55127 | 1103 | 21 |
385909 | 385909 | 2020-07-30 | Walworth | Wisconsin | 55127 | 1142 | 21 |
389126 | 389126 | 2020-07-31 | Walworth | Wisconsin | 55127 | 1179 | 21 |
392343 | 392343 | 2020-08-01 | Walworth | Wisconsin | 55127 | 1225 | 21 |
395559 | 395559 | 2020-08-02 | Walworth | Wisconsin | 55127 | 1237 | 21 |
398775 | 398775 | 2020-08-03 | Walworth | Wisconsin | 55127 | 1258 | 21 |
401991 | 401991 | 2020-08-04 | Walworth | Wisconsin | 55127 | 1265 | 21 |
405209 | 405209 | 2020-08-05 | Walworth | Wisconsin | 55127 | 1291 | 21 |
408429 | 408429 | 2020-08-06 | Walworth | Wisconsin | 55127 | 1284 | 22 |
411648 | 411648 | 2020-08-07 | Walworth | Wisconsin | 55127 | 1298 | 23 |
414868 | 414868 | 2020-08-08 | Walworth | Wisconsin | 55127 | 1314 | 23 |
418089 | 418089 | 2020-08-09 | Walworth | Wisconsin | 55127 | 1335 | 23 |
421310 | 421310 | 2020-08-10 | Walworth | Wisconsin | 55127 | 1335 | 23 |
424531 | 424531 | 2020-08-11 | Walworth | Wisconsin | 55127 | 1359 | 23 |
427755 | 427755 | 2020-08-12 | Walworth | Wisconsin | 55127 | 1369 | 23 |
430983 | 430983 | 2020-08-13 | Walworth | Wisconsin | 55127 | 1401 | 24 |
434208 | 434208 | 2020-08-14 | Walworth | Wisconsin | 55127 | 1430 | 24 |
437434 | 437434 | 2020-08-15 | Walworth | Wisconsin | 55127 | 1479 | 25 |
440660 | 440660 | 2020-08-16 | Walworth | Wisconsin | 55127 | 1499 | 25 |
443886 | 443886 | 2020-08-17 | Walworth | Wisconsin | 55127 | 1516 | 25 |
447113 | 447113 | 2020-08-18 | Walworth | Wisconsin | 55127 | 1526 | 25 |
450341 | 450341 | 2020-08-19 | Walworth | Wisconsin | 55127 | 1534 | 25 |
453569 | 453569 | 2020-08-20 | Walworth | Wisconsin | 55127 | 1546 | 25 |
456797 | 456797 | 2020-08-21 | Walworth | Wisconsin | 55127 | 1573 | 25 |
460024 | 460024 | 2020-08-22 | Walworth | Wisconsin | 55127 | 1591 | 25 |
463253 | 463253 | 2020-08-23 | Walworth | Wisconsin | 55127 | 1591 | 25 |
466482 | 466482 | 2020-08-24 | Walworth | Wisconsin | 55127 | 1614 | 26 |
469711 | 469711 | 2020-08-25 | Walworth | Wisconsin | 55127 | 1631 | 26 |
472943 | 472943 | 2020-08-26 | Walworth | Wisconsin | 55127 | 1645 | 26 |
476176 | 476176 | 2020-08-27 | Walworth | Wisconsin | 55127 | 1654 | 27 |
479409 | 479409 | 2020-08-28 | Walworth | Wisconsin | 55127 | 1684 | 27 |
482643 | 482643 | 2020-08-29 | Walworth | Wisconsin | 55127 | 1689 | 27 |
485878 | 485878 | 2020-08-30 | Walworth | Wisconsin | 55127 | 1695 | 27 |
489111 | 489111 | 2020-08-31 | Walworth | Wisconsin | 55127 | 1703 | 27 |
492344 | 492344 | 2020-09-01 | Walworth | Wisconsin | 55127 | 1714 | 28 |
495578 | 495578 | 2020-09-02 | Walworth | Wisconsin | 55127 | 1726 | 31 |
498811 | 498811 | 2020-09-03 | Walworth | Wisconsin | 55127 | 1749 | 32 |
502045 | 502045 | 2020-09-04 | Walworth | Wisconsin | 55127 | 1901 | 32 |
505279 | 505279 | 2020-09-05 | Walworth | Wisconsin | 55127 | 1927 | 32 |
508511 | 508511 | 2020-09-06 | Walworth | Wisconsin | 55127 | 1947 | 32 |
511744 | 511744 | 2020-09-07 | Walworth | Wisconsin | 55127 | 1969 | 32 |
514977 | 514977 | 2020-09-08 | Walworth | Wisconsin | 55127 | 1974 | 32 |
518212 | 518212 | 2020-09-09 | Walworth | Wisconsin | 55127 | 2020 | 32 |
521449 | 521449 | 2020-09-10 | Walworth | Wisconsin | 55127 | 2106 | 32 |
524685 | 524685 | 2020-09-11 | Walworth | Wisconsin | 55127 | 2143 | 32 |
527921 | 527921 | 2020-09-12 | Walworth | Wisconsin | 55127 | 2200 | 32 |
531158 | 531158 | 2020-09-13 | Walworth | Wisconsin | 55127 | 2235 | 32 |
534393 | 534393 | 2020-09-14 | Walworth | Wisconsin | 55127 | 2258 | 32 |
537629 | 537629 | 2020-09-15 | Walworth | Wisconsin | 55127 | 2380 | 33 |
540866 | 540866 | 2020-09-16 | Walworth | Wisconsin | 55127 | 2423 | 34 |
544102 | 544102 | 2020-09-17 | Walworth | Wisconsin | 55127 | 2474 | 34 |
547339 | 547339 | 2020-09-18 | Walworth | Wisconsin | 55127 | 2515 | 34 |
550578 | 550578 | 2020-09-19 | Walworth | Wisconsin | 55127 | 2566 | 34 |
553817 | 553817 | 2020-09-20 | Walworth | Wisconsin | 55127 | 2573 | 34 |
557054 | 557054 | 2020-09-21 | Walworth | Wisconsin | 55127 | 2603 | 34 |
560290 | 560290 | 2020-09-22 | Walworth | Wisconsin | 55127 | 2630 | 34 |
563529 | 563529 | 2020-09-23 | Walworth | Wisconsin | 55127 | 2649 | 34 |
566770 | 566770 | 2020-09-24 | Walworth | Wisconsin | 55127 | 2672 | 34 |
570011 | 570011 | 2020-09-25 | Walworth | Wisconsin | 55127 | 2695 | 35 |
573253 | 573253 | 2020-09-26 | Walworth | Wisconsin | 55127 | 2724 | 35 |
576497 | 576497 | 2020-09-27 | Walworth | Wisconsin | 55127 | 2730 | 35 |
579738 | 579738 | 2020-09-28 | Walworth | Wisconsin | 55127 | 2730 | 35 |
582977 | 582977 | 2020-09-29 | Walworth | Wisconsin | 55127 | 2772 | 35 |
586217 | 586217 | 2020-09-30 | Walworth | Wisconsin | 55127 | 2784 | 35 |
589458 | 589458 | 2020-10-01 | Walworth | Wisconsin | 55127 | 2803 | 35 |
592698 | 592698 | 2020-10-02 | Walworth | Wisconsin | 55127 | 2876 | 35 |
595940 | 595940 | 2020-10-03 | Walworth | Wisconsin | 55127 | 2916 | 35 |
599183 | 599183 | 2020-10-04 | Walworth | Wisconsin | 55127 | 2941 | 35 |
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);