ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638101 | 638101 | 2020-10-16 | Washington | Wisconsin | 55131 | 3850 | 40 |
634856 | 634856 | 2020-10-15 | Washington | Wisconsin | 55131 | 3754 | 40 |
631611 | 631611 | 2020-10-14 | Washington | Wisconsin | 55131 | 3623 | 40 |
628367 | 628367 | 2020-10-13 | Washington | Wisconsin | 55131 | 3536 | 40 |
625124 | 625124 | 2020-10-12 | Washington | Wisconsin | 55131 | 3437 | 38 |
621881 | 621881 | 2020-10-11 | Washington | Wisconsin | 55131 | 3425 | 37 |
618638 | 618638 | 2020-10-10 | Washington | Wisconsin | 55131 | 3340 | 37 |
615396 | 615396 | 2020-10-09 | Washington | Wisconsin | 55131 | 3253 | 37 |
612155 | 612155 | 2020-10-08 | Washington | Wisconsin | 55131 | 3194 | 37 |
608913 | 608913 | 2020-10-07 | Washington | Wisconsin | 55131 | 3123 | 37 |
605670 | 605670 | 2020-10-06 | Washington | Wisconsin | 55131 | 3069 | 35 |
602428 | 602428 | 2020-10-05 | Washington | Wisconsin | 55131 | 3013 | 35 |
599185 | 599185 | 2020-10-04 | Washington | Wisconsin | 55131 | 3007 | 35 |
595942 | 595942 | 2020-10-03 | Washington | Wisconsin | 55131 | 2962 | 35 |
592700 | 592700 | 2020-10-02 | Washington | Wisconsin | 55131 | 2901 | 35 |
589460 | 589460 | 2020-10-01 | Washington | Wisconsin | 55131 | 2833 | 36 |
586219 | 586219 | 2020-09-30 | Washington | Wisconsin | 55131 | 2776 | 34 |
582979 | 582979 | 2020-09-29 | Washington | Wisconsin | 55131 | 2736 | 33 |
579740 | 579740 | 2020-09-28 | Washington | Wisconsin | 55131 | 2677 | 32 |
576499 | 576499 | 2020-09-27 | Washington | Wisconsin | 55131 | 2677 | 32 |
573255 | 573255 | 2020-09-26 | Washington | Wisconsin | 55131 | 2607 | 32 |
570013 | 570013 | 2020-09-25 | Washington | Wisconsin | 55131 | 2569 | 32 |
566772 | 566772 | 2020-09-24 | Washington | Wisconsin | 55131 | 2514 | 32 |
563531 | 563531 | 2020-09-23 | Washington | Wisconsin | 55131 | 2452 | 32 |
560292 | 560292 | 2020-09-22 | Washington | Wisconsin | 55131 | 2395 | 32 |
557056 | 557056 | 2020-09-21 | Washington | Wisconsin | 55131 | 2338 | 32 |
553819 | 553819 | 2020-09-20 | Washington | Wisconsin | 55131 | 2338 | 32 |
550580 | 550580 | 2020-09-19 | Washington | Wisconsin | 55131 | 2282 | 32 |
547341 | 547341 | 2020-09-18 | Washington | Wisconsin | 55131 | 2226 | 32 |
544104 | 544104 | 2020-09-17 | Washington | Wisconsin | 55131 | 2177 | 32 |
540868 | 540868 | 2020-09-16 | Washington | Wisconsin | 55131 | 2118 | 32 |
537631 | 537631 | 2020-09-15 | Washington | Wisconsin | 55131 | 2084 | 32 |
534395 | 534395 | 2020-09-14 | Washington | Wisconsin | 55131 | 2040 | 32 |
531160 | 531160 | 2020-09-13 | Washington | Wisconsin | 55131 | 2040 | 32 |
527923 | 527923 | 2020-09-12 | Washington | Wisconsin | 55131 | 1988 | 32 |
524687 | 524687 | 2020-09-11 | Washington | Wisconsin | 55131 | 1946 | 31 |
521451 | 521451 | 2020-09-10 | Washington | Wisconsin | 55131 | 1903 | 31 |
518214 | 518214 | 2020-09-09 | Washington | Wisconsin | 55131 | 1882 | 31 |
514979 | 514979 | 2020-09-08 | Washington | Wisconsin | 55131 | 1869 | 30 |
511746 | 511746 | 2020-09-07 | Washington | Wisconsin | 55131 | 1831 | 29 |
508513 | 508513 | 2020-09-06 | Washington | Wisconsin | 55131 | 1830 | 29 |
505281 | 505281 | 2020-09-05 | Washington | Wisconsin | 55131 | 1816 | 29 |
502047 | 502047 | 2020-09-04 | Washington | Wisconsin | 55131 | 1791 | 29 |
498813 | 498813 | 2020-09-03 | Washington | Wisconsin | 55131 | 1724 | 29 |
495580 | 495580 | 2020-09-02 | Washington | Wisconsin | 55131 | 1670 | 29 |
492346 | 492346 | 2020-09-01 | Washington | Wisconsin | 55131 | 1658 | 29 |
489113 | 489113 | 2020-08-31 | Washington | Wisconsin | 55131 | 1640 | 29 |
485880 | 485880 | 2020-08-30 | Washington | Wisconsin | 55131 | 1622 | 29 |
482645 | 482645 | 2020-08-29 | Washington | Wisconsin | 55131 | 1595 | 29 |
479411 | 479411 | 2020-08-28 | Washington | Wisconsin | 55131 | 1590 | 29 |
476178 | 476178 | 2020-08-27 | Washington | Wisconsin | 55131 | 1566 | 29 |
472945 | 472945 | 2020-08-26 | Washington | Wisconsin | 55131 | 1537 | 29 |
469713 | 469713 | 2020-08-25 | Washington | Wisconsin | 55131 | 1516 | 28 |
466484 | 466484 | 2020-08-24 | Washington | Wisconsin | 55131 | 1477 | 27 |
463255 | 463255 | 2020-08-23 | Washington | Wisconsin | 55131 | 1458 | 27 |
460026 | 460026 | 2020-08-22 | Washington | Wisconsin | 55131 | 1441 | 27 |
456799 | 456799 | 2020-08-21 | Washington | Wisconsin | 55131 | 1435 | 27 |
453571 | 453571 | 2020-08-20 | Washington | Wisconsin | 55131 | 1397 | 26 |
450343 | 450343 | 2020-08-19 | Washington | Wisconsin | 55131 | 1358 | 26 |
447115 | 447115 | 2020-08-18 | Washington | Wisconsin | 55131 | 1314 | 26 |
443888 | 443888 | 2020-08-17 | Washington | Wisconsin | 55131 | 1288 | 26 |
440662 | 440662 | 2020-08-16 | Washington | Wisconsin | 55131 | 1259 | 24 |
437436 | 437436 | 2020-08-15 | Washington | Wisconsin | 55131 | 1207 | 24 |
434210 | 434210 | 2020-08-14 | Washington | Wisconsin | 55131 | 1204 | 24 |
430985 | 430985 | 2020-08-13 | Washington | Wisconsin | 55131 | 1183 | 24 |
427757 | 427757 | 2020-08-12 | Washington | Wisconsin | 55131 | 1135 | 23 |
424533 | 424533 | 2020-08-11 | Washington | Wisconsin | 55131 | 1108 | 23 |
421312 | 421312 | 2020-08-10 | Washington | Wisconsin | 55131 | 1095 | 23 |
418091 | 418091 | 2020-08-09 | Washington | Wisconsin | 55131 | 1066 | 23 |
414870 | 414870 | 2020-08-08 | Washington | Wisconsin | 55131 | 1039 | 23 |
411650 | 411650 | 2020-08-07 | Washington | Wisconsin | 55131 | 1036 | 23 |
408431 | 408431 | 2020-08-06 | Washington | Wisconsin | 55131 | 968 | 23 |
405211 | 405211 | 2020-08-05 | Washington | Wisconsin | 55131 | 968 | 23 |
401993 | 401993 | 2020-08-04 | Washington | Wisconsin | 55131 | 942 | 23 |
398777 | 398777 | 2020-08-03 | Washington | Wisconsin | 55131 | 907 | 23 |
395561 | 395561 | 2020-08-02 | Washington | Wisconsin | 55131 | 880 | 23 |
392345 | 392345 | 2020-08-01 | Washington | Wisconsin | 55131 | 860 | 23 |
389128 | 389128 | 2020-07-31 | Washington | Wisconsin | 55131 | 854 | 23 |
385911 | 385911 | 2020-07-30 | Washington | Wisconsin | 55131 | 804 | 23 |
382693 | 382693 | 2020-07-29 | Washington | Wisconsin | 55131 | 789 | 23 |
379476 | 379476 | 2020-07-28 | Washington | Wisconsin | 55131 | 753 | 23 |
376260 | 376260 | 2020-07-27 | Washington | Wisconsin | 55131 | 717 | 23 |
373046 | 373046 | 2020-07-26 | Washington | Wisconsin | 55131 | 700 | 20 |
369834 | 369834 | 2020-07-25 | Washington | Wisconsin | 55131 | 679 | 20 |
366624 | 366624 | 2020-07-24 | Washington | Wisconsin | 55131 | 679 | 20 |
363417 | 363417 | 2020-07-23 | Washington | Wisconsin | 55131 | 666 | 20 |
360211 | 360211 | 2020-07-22 | Washington | Wisconsin | 55131 | 641 | 20 |
357006 | 357006 | 2020-07-21 | Washington | Wisconsin | 55131 | 616 | 20 |
353803 | 353803 | 2020-07-20 | Washington | Wisconsin | 55131 | 599 | 19 |
350601 | 350601 | 2020-07-19 | Washington | Wisconsin | 55131 | 570 | 19 |
347400 | 347400 | 2020-07-18 | Washington | Wisconsin | 55131 | 558 | 19 |
344200 | 344200 | 2020-07-17 | Washington | Wisconsin | 55131 | 558 | 19 |
341001 | 341001 | 2020-07-16 | Washington | Wisconsin | 55131 | 537 | 19 |
337805 | 337805 | 2020-07-15 | Washington | Wisconsin | 55131 | 523 | 19 |
334610 | 334610 | 2020-07-14 | Washington | Wisconsin | 55131 | 514 | 19 |
331417 | 331417 | 2020-07-13 | Washington | Wisconsin | 55131 | 498 | 19 |
328231 | 328231 | 2020-07-12 | Washington | Wisconsin | 55131 | 490 | 19 |
325045 | 325045 | 2020-07-11 | Washington | Wisconsin | 55131 | 482 | 19 |
321864 | 321864 | 2020-07-10 | Washington | Wisconsin | 55131 | 480 | 19 |
318685 | 318685 | 2020-07-09 | Washington | Wisconsin | 55131 | 470 | 19 |
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);