ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Crawford" and fips = 55023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1020965 | 1020965 | 2021-02-11 | Crawford | Wisconsin | 55023 | 1697 | 17 |
1017720 | 1017720 | 2021-02-10 | Crawford | Wisconsin | 55023 | 1695 | 17 |
1014475 | 1014475 | 2021-02-09 | Crawford | Wisconsin | 55023 | 1693 | 17 |
1011230 | 1011230 | 2021-02-08 | Crawford | Wisconsin | 55023 | 1691 | 17 |
1007984 | 1007984 | 2021-02-07 | Crawford | Wisconsin | 55023 | 1691 | 17 |
1004738 | 1004738 | 2021-02-06 | Crawford | Wisconsin | 55023 | 1691 | 17 |
1001492 | 1001492 | 2021-02-05 | Crawford | Wisconsin | 55023 | 1691 | 17 |
998246 | 998246 | 2021-02-04 | Crawford | Wisconsin | 55023 | 1690 | 17 |
995000 | 995000 | 2021-02-03 | Crawford | Wisconsin | 55023 | 1689 | 16 |
991754 | 991754 | 2021-02-02 | Crawford | Wisconsin | 55023 | 1688 | 16 |
988508 | 988508 | 2021-02-01 | Crawford | Wisconsin | 55023 | 1686 | 16 |
985261 | 985261 | 2021-01-31 | Crawford | Wisconsin | 55023 | 1686 | 16 |
982014 | 982014 | 2021-01-30 | Crawford | Wisconsin | 55023 | 1684 | 16 |
978768 | 978768 | 2021-01-29 | Crawford | Wisconsin | 55023 | 1682 | 16 |
975523 | 975523 | 2021-01-28 | Crawford | Wisconsin | 55023 | 1683 | 15 |
972278 | 972278 | 2021-01-27 | Crawford | Wisconsin | 55023 | 1679 | 15 |
969033 | 969033 | 2021-01-26 | Crawford | Wisconsin | 55023 | 1676 | 15 |
965789 | 965789 | 2021-01-25 | Crawford | Wisconsin | 55023 | 1675 | 15 |
962544 | 962544 | 2021-01-24 | Crawford | Wisconsin | 55023 | 1673 | 15 |
959299 | 959299 | 2021-01-23 | Crawford | Wisconsin | 55023 | 1673 | 15 |
956053 | 956053 | 2021-01-22 | Crawford | Wisconsin | 55023 | 1672 | 14 |
952808 | 952808 | 2021-01-21 | Crawford | Wisconsin | 55023 | 1668 | 14 |
949563 | 949563 | 2021-01-20 | Crawford | Wisconsin | 55023 | 1667 | 14 |
946317 | 946317 | 2021-01-19 | Crawford | Wisconsin | 55023 | 1664 | 14 |
943070 | 943070 | 2021-01-18 | Crawford | Wisconsin | 55023 | 1663 | 13 |
939825 | 939825 | 2021-01-17 | Crawford | Wisconsin | 55023 | 1665 | 13 |
936580 | 936580 | 2021-01-16 | Crawford | Wisconsin | 55023 | 1662 | 13 |
933335 | 933335 | 2021-01-15 | Crawford | Wisconsin | 55023 | 1660 | 13 |
930090 | 930090 | 2021-01-14 | Crawford | Wisconsin | 55023 | 1659 | 13 |
926845 | 926845 | 2021-01-13 | Crawford | Wisconsin | 55023 | 1656 | 13 |
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 |
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);