ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Green" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732131 | 732131 | 2020-11-14 | Green | Wisconsin | 55045 | 1357 | 5 |
728886 | 728886 | 2020-11-13 | Green | Wisconsin | 55045 | 1353 | 5 |
725643 | 725643 | 2020-11-12 | Green | Wisconsin | 55045 | 1324 | 5 |
722400 | 722400 | 2020-11-11 | Green | Wisconsin | 55045 | 1286 | 5 |
719157 | 719157 | 2020-11-10 | Green | Wisconsin | 55045 | 1268 | 5 |
715914 | 715914 | 2020-11-09 | Green | Wisconsin | 55045 | 1245 | 5 |
712670 | 712670 | 2020-11-08 | Green | Wisconsin | 55045 | 1234 | 5 |
709426 | 709426 | 2020-11-07 | Green | Wisconsin | 55045 | 1202 | 5 |
706182 | 706182 | 2020-11-06 | Green | Wisconsin | 55045 | 1162 | 5 |
702939 | 702939 | 2020-11-05 | Green | Wisconsin | 55045 | 1147 | 5 |
699696 | 699696 | 2020-11-04 | Green | Wisconsin | 55045 | 1115 | 5 |
696452 | 696452 | 2020-11-03 | Green | Wisconsin | 55045 | 1088 | 5 |
693210 | 693210 | 2020-11-02 | Green | Wisconsin | 55045 | 1083 | 5 |
689966 | 689966 | 2020-11-01 | Green | Wisconsin | 55045 | 1078 | 6 |
686721 | 686721 | 2020-10-31 | Green | Wisconsin | 55045 | 1050 | 6 |
683478 | 683478 | 2020-10-30 | Green | Wisconsin | 55045 | 1019 | 5 |
680235 | 680235 | 2020-10-29 | Green | Wisconsin | 55045 | 1002 | 5 |
676992 | 676992 | 2020-10-28 | Green | Wisconsin | 55045 | 977 | 5 |
673749 | 673749 | 2020-10-27 | Green | Wisconsin | 55045 | 951 | 5 |
670507 | 670507 | 2020-10-26 | Green | Wisconsin | 55045 | 943 | 5 |
667264 | 667264 | 2020-10-25 | Green | Wisconsin | 55045 | 936 | 5 |
664019 | 664019 | 2020-10-24 | Green | Wisconsin | 55045 | 924 | 5 |
660775 | 660775 | 2020-10-23 | Green | Wisconsin | 55045 | 905 | 5 |
657531 | 657531 | 2020-10-22 | Green | Wisconsin | 55045 | 877 | 5 |
654286 | 654286 | 2020-10-21 | Green | Wisconsin | 55045 | 867 | 5 |
651041 | 651041 | 2020-10-20 | Green | Wisconsin | 55045 | 848 | 4 |
647797 | 647797 | 2020-10-19 | Green | Wisconsin | 55045 | 836 | 4 |
644551 | 644551 | 2020-10-18 | Green | Wisconsin | 55045 | 796 | 3 |
641303 | 641303 | 2020-10-17 | Green | Wisconsin | 55045 | 796 | 3 |
638056 | 638056 | 2020-10-16 | Green | Wisconsin | 55045 | 796 | 3 |
634811 | 634811 | 2020-10-15 | Green | Wisconsin | 55045 | 780 | 3 |
631566 | 631566 | 2020-10-14 | Green | Wisconsin | 55045 | 762 | 3 |
628322 | 628322 | 2020-10-13 | Green | Wisconsin | 55045 | 737 | 3 |
625079 | 625079 | 2020-10-12 | Green | Wisconsin | 55045 | 721 | 3 |
621836 | 621836 | 2020-10-11 | Green | Wisconsin | 55045 | 702 | 3 |
618593 | 618593 | 2020-10-10 | Green | Wisconsin | 55045 | 683 | 3 |
615351 | 615351 | 2020-10-09 | Green | Wisconsin | 55045 | 679 | 3 |
612110 | 612110 | 2020-10-08 | Green | Wisconsin | 55045 | 670 | 3 |
608868 | 608868 | 2020-10-07 | Green | Wisconsin | 55045 | 655 | 3 |
605625 | 605625 | 2020-10-06 | Green | Wisconsin | 55045 | 642 | 3 |
602383 | 602383 | 2020-10-05 | Green | Wisconsin | 55045 | 637 | 3 |
599140 | 599140 | 2020-10-04 | Green | Wisconsin | 55045 | 622 | 3 |
595897 | 595897 | 2020-10-03 | Green | Wisconsin | 55045 | 606 | 3 |
592655 | 592655 | 2020-10-02 | Green | Wisconsin | 55045 | 595 | 3 |
589415 | 589415 | 2020-10-01 | Green | Wisconsin | 55045 | 587 | 3 |
586174 | 586174 | 2020-09-30 | Green | Wisconsin | 55045 | 580 | 3 |
582934 | 582934 | 2020-09-29 | Green | Wisconsin | 55045 | 558 | 3 |
579695 | 579695 | 2020-09-28 | Green | Wisconsin | 55045 | 548 | 3 |
576454 | 576454 | 2020-09-27 | Green | Wisconsin | 55045 | 535 | 3 |
573210 | 573210 | 2020-09-26 | Green | Wisconsin | 55045 | 505 | 3 |
569968 | 569968 | 2020-09-25 | Green | Wisconsin | 55045 | 495 | 2 |
566727 | 566727 | 2020-09-24 | Green | Wisconsin | 55045 | 486 | 2 |
563486 | 563486 | 2020-09-23 | Green | Wisconsin | 55045 | 478 | 2 |
560247 | 560247 | 2020-09-22 | Green | Wisconsin | 55045 | 469 | 2 |
557011 | 557011 | 2020-09-21 | Green | Wisconsin | 55045 | 463 | 2 |
553774 | 553774 | 2020-09-20 | Green | Wisconsin | 55045 | 456 | 2 |
550535 | 550535 | 2020-09-19 | Green | Wisconsin | 55045 | 449 | 2 |
547296 | 547296 | 2020-09-18 | Green | Wisconsin | 55045 | 415 | 2 |
544059 | 544059 | 2020-09-17 | Green | Wisconsin | 55045 | 404 | 2 |
540823 | 540823 | 2020-09-16 | Green | Wisconsin | 55045 | 391 | 2 |
537586 | 537586 | 2020-09-15 | Green | Wisconsin | 55045 | 382 | 2 |
534350 | 534350 | 2020-09-14 | Green | Wisconsin | 55045 | 378 | 2 |
531115 | 531115 | 2020-09-13 | Green | Wisconsin | 55045 | 377 | 2 |
527878 | 527878 | 2020-09-12 | Green | Wisconsin | 55045 | 360 | 2 |
524642 | 524642 | 2020-09-11 | Green | Wisconsin | 55045 | 352 | 2 |
521406 | 521406 | 2020-09-10 | Green | Wisconsin | 55045 | 342 | 2 |
518169 | 518169 | 2020-09-09 | Green | Wisconsin | 55045 | 336 | 2 |
514934 | 514934 | 2020-09-08 | Green | Wisconsin | 55045 | 330 | 2 |
511701 | 511701 | 2020-09-07 | Green | Wisconsin | 55045 | 324 | 2 |
508468 | 508468 | 2020-09-06 | Green | Wisconsin | 55045 | 310 | 2 |
505236 | 505236 | 2020-09-05 | Green | Wisconsin | 55045 | 302 | 2 |
502002 | 502002 | 2020-09-04 | Green | Wisconsin | 55045 | 298 | 2 |
498768 | 498768 | 2020-09-03 | Green | Wisconsin | 55045 | 272 | 1 |
495535 | 495535 | 2020-09-02 | Green | Wisconsin | 55045 | 269 | 1 |
492301 | 492301 | 2020-09-01 | Green | Wisconsin | 55045 | 270 | 1 |
489068 | 489068 | 2020-08-31 | Green | Wisconsin | 55045 | 270 | 1 |
485835 | 485835 | 2020-08-30 | Green | Wisconsin | 55045 | 268 | 1 |
482600 | 482600 | 2020-08-29 | Green | Wisconsin | 55045 | 265 | 1 |
479366 | 479366 | 2020-08-28 | Green | Wisconsin | 55045 | 262 | 1 |
476133 | 476133 | 2020-08-27 | Green | Wisconsin | 55045 | 261 | 1 |
472900 | 472900 | 2020-08-26 | Green | Wisconsin | 55045 | 256 | 1 |
469668 | 469668 | 2020-08-25 | Green | Wisconsin | 55045 | 255 | 1 |
466439 | 466439 | 2020-08-24 | Green | Wisconsin | 55045 | 250 | 1 |
463210 | 463210 | 2020-08-23 | Green | Wisconsin | 55045 | 249 | 1 |
459981 | 459981 | 2020-08-22 | Green | Wisconsin | 55045 | 247 | 1 |
456754 | 456754 | 2020-08-21 | Green | Wisconsin | 55045 | 235 | 1 |
453526 | 453526 | 2020-08-20 | Green | Wisconsin | 55045 | 229 | 1 |
450298 | 450298 | 2020-08-19 | Green | Wisconsin | 55045 | 225 | 1 |
447070 | 447070 | 2020-08-18 | Green | Wisconsin | 55045 | 221 | 1 |
443843 | 443843 | 2020-08-17 | Green | Wisconsin | 55045 | 220 | 1 |
440617 | 440617 | 2020-08-16 | Green | Wisconsin | 55045 | 214 | 1 |
437391 | 437391 | 2020-08-15 | Green | Wisconsin | 55045 | 210 | 1 |
434165 | 434165 | 2020-08-14 | Green | Wisconsin | 55045 | 194 | 1 |
430940 | 430940 | 2020-08-13 | Green | Wisconsin | 55045 | 186 | 1 |
427712 | 427712 | 2020-08-12 | Green | Wisconsin | 55045 | 179 | 1 |
424488 | 424488 | 2020-08-11 | Green | Wisconsin | 55045 | 169 | 1 |
421267 | 421267 | 2020-08-10 | Green | Wisconsin | 55045 | 167 | 1 |
418046 | 418046 | 2020-08-09 | Green | Wisconsin | 55045 | 162 | 1 |
414825 | 414825 | 2020-08-08 | Green | Wisconsin | 55045 | 158 | 1 |
411605 | 411605 | 2020-08-07 | Green | Wisconsin | 55045 | 149 | 1 |
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);