ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Crawford" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923599 | 923599 | 2021-01-12 | Crawford | Wisconsin | 55023 | 1645 | 13 |
920354 | 920354 | 2021-01-11 | Crawford | Wisconsin | 55023 | 1640 | 13 |
917109 | 917109 | 2021-01-10 | Crawford | Wisconsin | 55023 | 1640 | 13 |
913864 | 913864 | 2021-01-09 | Crawford | Wisconsin | 55023 | 1634 | 13 |
910619 | 910619 | 2021-01-08 | Crawford | Wisconsin | 55023 | 1634 | 13 |
907374 | 907374 | 2021-01-07 | Crawford | Wisconsin | 55023 | 1625 | 13 |
904128 | 904128 | 2021-01-06 | Crawford | Wisconsin | 55023 | 1614 | 12 |
900883 | 900883 | 2021-01-05 | Crawford | Wisconsin | 55023 | 1609 | 12 |
897638 | 897638 | 2021-01-04 | Crawford | Wisconsin | 55023 | 1608 | 12 |
894392 | 894392 | 2021-01-03 | Crawford | Wisconsin | 55023 | 1606 | 12 |
891146 | 891146 | 2021-01-02 | Crawford | Wisconsin | 55023 | 1602 | 12 |
887899 | 887899 | 2021-01-01 | Crawford | Wisconsin | 55023 | 1599 | 12 |
884654 | 884654 | 2020-12-31 | Crawford | Wisconsin | 55023 | 1596 | 12 |
881409 | 881409 | 2020-12-30 | Crawford | Wisconsin | 55023 | 1591 | 12 |
878164 | 878164 | 2020-12-29 | Crawford | Wisconsin | 55023 | 1583 | 12 |
874919 | 874919 | 2020-12-28 | Crawford | Wisconsin | 55023 | 1582 | 12 |
871674 | 871674 | 2020-12-27 | Crawford | Wisconsin | 55023 | 1579 | 12 |
868429 | 868429 | 2020-12-26 | Crawford | Wisconsin | 55023 | 1578 | 12 |
865184 | 865184 | 2020-12-25 | Crawford | Wisconsin | 55023 | 1576 | 12 |
861939 | 861939 | 2020-12-24 | Crawford | Wisconsin | 55023 | 1573 | 12 |
858694 | 858694 | 2020-12-23 | Crawford | Wisconsin | 55023 | 1570 | 11 |
855449 | 855449 | 2020-12-22 | Crawford | Wisconsin | 55023 | 1562 | 11 |
852204 | 852204 | 2020-12-21 | Crawford | Wisconsin | 55023 | 1558 | 11 |
848959 | 848959 | 2020-12-20 | Crawford | Wisconsin | 55023 | 1552 | 11 |
845714 | 845714 | 2020-12-19 | Crawford | Wisconsin | 55023 | 1547 | 11 |
842468 | 842468 | 2020-12-18 | Crawford | Wisconsin | 55023 | 1542 | 11 |
839223 | 839223 | 2020-12-17 | Crawford | Wisconsin | 55023 | 1531 | 11 |
835978 | 835978 | 2020-12-16 | Crawford | Wisconsin | 55023 | 1522 | 11 |
832732 | 832732 | 2020-12-15 | Crawford | Wisconsin | 55023 | 1514 | 11 |
829485 | 829485 | 2020-12-14 | Crawford | Wisconsin | 55023 | 1509 | 11 |
826239 | 826239 | 2020-12-13 | Crawford | Wisconsin | 55023 | 1505 | 10 |
822992 | 822992 | 2020-12-12 | Crawford | Wisconsin | 55023 | 1493 | 10 |
819746 | 819746 | 2020-12-11 | Crawford | Wisconsin | 55023 | 1481 | 10 |
816500 | 816500 | 2020-12-10 | Crawford | Wisconsin | 55023 | 1480 | 10 |
813254 | 813254 | 2020-12-09 | Crawford | Wisconsin | 55023 | 1461 | 10 |
810010 | 810010 | 2020-12-08 | Crawford | Wisconsin | 55023 | 1441 | 9 |
806765 | 806765 | 2020-12-07 | Crawford | Wisconsin | 55023 | 1429 | 9 |
803520 | 803520 | 2020-12-06 | Crawford | Wisconsin | 55023 | 1425 | 9 |
800275 | 800275 | 2020-12-05 | Crawford | Wisconsin | 55023 | 1411 | 9 |
797030 | 797030 | 2020-12-04 | Crawford | Wisconsin | 55023 | 1404 | 9 |
793785 | 793785 | 2020-12-03 | Crawford | Wisconsin | 55023 | 1378 | 8 |
790540 | 790540 | 2020-12-02 | Crawford | Wisconsin | 55023 | 1346 | 8 |
787295 | 787295 | 2020-12-01 | Crawford | Wisconsin | 55023 | 1343 | 8 |
784051 | 784051 | 2020-11-30 | Crawford | Wisconsin | 55023 | 1251 | 7 |
780806 | 780806 | 2020-11-29 | Crawford | Wisconsin | 55023 | 1231 | 7 |
777560 | 777560 | 2020-11-28 | Crawford | Wisconsin | 55023 | 1215 | 7 |
774315 | 774315 | 2020-11-27 | Crawford | Wisconsin | 55023 | 1184 | 7 |
771070 | 771070 | 2020-11-26 | Crawford | Wisconsin | 55023 | 1169 | 7 |
767824 | 767824 | 2020-11-25 | Crawford | Wisconsin | 55023 | 1160 | 7 |
764579 | 764579 | 2020-11-24 | Crawford | Wisconsin | 55023 | 874 | 7 |
761334 | 761334 | 2020-11-23 | Crawford | Wisconsin | 55023 | 853 | 6 |
758089 | 758089 | 2020-11-22 | Crawford | Wisconsin | 55023 | 830 | 5 |
754842 | 754842 | 2020-11-21 | Crawford | Wisconsin | 55023 | 813 | 4 |
751596 | 751596 | 2020-11-20 | Crawford | Wisconsin | 55023 | 797 | 4 |
748350 | 748350 | 2020-11-19 | Crawford | Wisconsin | 55023 | 762 | 4 |
745104 | 745104 | 2020-11-18 | Crawford | Wisconsin | 55023 | 733 | 4 |
741857 | 741857 | 2020-11-17 | Crawford | Wisconsin | 55023 | 718 | 4 |
738610 | 738610 | 2020-11-16 | Crawford | Wisconsin | 55023 | 696 | 4 |
735366 | 735366 | 2020-11-15 | Crawford | Wisconsin | 55023 | 676 | 4 |
732120 | 732120 | 2020-11-14 | Crawford | Wisconsin | 55023 | 651 | 4 |
728875 | 728875 | 2020-11-13 | Crawford | Wisconsin | 55023 | 623 | 4 |
725632 | 725632 | 2020-11-12 | Crawford | Wisconsin | 55023 | 597 | 4 |
722389 | 722389 | 2020-11-11 | Crawford | Wisconsin | 55023 | 573 | 3 |
719146 | 719146 | 2020-11-10 | Crawford | Wisconsin | 55023 | 548 | 3 |
715903 | 715903 | 2020-11-09 | Crawford | Wisconsin | 55023 | 513 | 1 |
712659 | 712659 | 2020-11-08 | Crawford | Wisconsin | 55023 | 501 | 1 |
709415 | 709415 | 2020-11-07 | Crawford | Wisconsin | 55023 | 494 | 1 |
706171 | 706171 | 2020-11-06 | Crawford | Wisconsin | 55023 | 473 | 1 |
702928 | 702928 | 2020-11-05 | Crawford | Wisconsin | 55023 | 457 | 1 |
699685 | 699685 | 2020-11-04 | Crawford | Wisconsin | 55023 | 436 | 1 |
696441 | 696441 | 2020-11-03 | Crawford | Wisconsin | 55023 | 419 | 1 |
693199 | 693199 | 2020-11-02 | Crawford | Wisconsin | 55023 | 408 | 1 |
689955 | 689955 | 2020-11-01 | Crawford | Wisconsin | 55023 | 396 | 1 |
686710 | 686710 | 2020-10-31 | Crawford | Wisconsin | 55023 | 381 | 1 |
683467 | 683467 | 2020-10-30 | Crawford | Wisconsin | 55023 | 374 | 1 |
680224 | 680224 | 2020-10-29 | Crawford | Wisconsin | 55023 | 354 | 1 |
676981 | 676981 | 2020-10-28 | Crawford | Wisconsin | 55023 | 347 | 1 |
673738 | 673738 | 2020-10-27 | Crawford | Wisconsin | 55023 | 335 | 0 |
670496 | 670496 | 2020-10-26 | Crawford | Wisconsin | 55023 | 330 | 0 |
667253 | 667253 | 2020-10-25 | Crawford | Wisconsin | 55023 | 323 | 0 |
664008 | 664008 | 2020-10-24 | Crawford | Wisconsin | 55023 | 320 | 0 |
660764 | 660764 | 2020-10-23 | Crawford | Wisconsin | 55023 | 318 | 0 |
657520 | 657520 | 2020-10-22 | Crawford | Wisconsin | 55023 | 315 | 0 |
654275 | 654275 | 2020-10-21 | Crawford | Wisconsin | 55023 | 307 | 0 |
651030 | 651030 | 2020-10-20 | Crawford | Wisconsin | 55023 | 304 | 0 |
647786 | 647786 | 2020-10-19 | Crawford | Wisconsin | 55023 | 303 | 0 |
644540 | 644540 | 2020-10-18 | Crawford | Wisconsin | 55023 | 291 | 0 |
641292 | 641292 | 2020-10-17 | Crawford | Wisconsin | 55023 | 291 | 0 |
638045 | 638045 | 2020-10-16 | Crawford | Wisconsin | 55023 | 291 | 0 |
634800 | 634800 | 2020-10-15 | Crawford | Wisconsin | 55023 | 275 | 0 |
631555 | 631555 | 2020-10-14 | Crawford | Wisconsin | 55023 | 268 | 0 |
628311 | 628311 | 2020-10-13 | Crawford | Wisconsin | 55023 | 261 | 0 |
625068 | 625068 | 2020-10-12 | Crawford | Wisconsin | 55023 | 248 | 0 |
621825 | 621825 | 2020-10-11 | Crawford | Wisconsin | 55023 | 246 | 0 |
618582 | 618582 | 2020-10-10 | Crawford | Wisconsin | 55023 | 244 | 0 |
615340 | 615340 | 2020-10-09 | Crawford | Wisconsin | 55023 | 233 | 0 |
612099 | 612099 | 2020-10-08 | Crawford | Wisconsin | 55023 | 226 | 0 |
608857 | 608857 | 2020-10-07 | Crawford | Wisconsin | 55023 | 216 | 0 |
605614 | 605614 | 2020-10-06 | Crawford | Wisconsin | 55023 | 212 | 0 |
602372 | 602372 | 2020-10-05 | Crawford | Wisconsin | 55023 | 209 | 0 |
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);