ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Iron" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056682 | 1056682 | 2021-02-22 | Iron | Wisconsin | 55051 | 647 | 39 |
1053436 | 1053436 | 2021-02-21 | Iron | Wisconsin | 55051 | 647 | 39 |
1050189 | 1050189 | 2021-02-20 | Iron | Wisconsin | 55051 | 647 | 39 |
1046942 | 1046942 | 2021-02-19 | Iron | Wisconsin | 55051 | 646 | 39 |
1043697 | 1043697 | 2021-02-18 | Iron | Wisconsin | 55051 | 645 | 39 |
1040452 | 1040452 | 2021-02-17 | Iron | Wisconsin | 55051 | 640 | 39 |
1037207 | 1037207 | 2021-02-16 | Iron | Wisconsin | 55051 | 635 | 38 |
1033962 | 1033962 | 2021-02-15 | Iron | Wisconsin | 55051 | 632 | 38 |
1030716 | 1030716 | 2021-02-14 | Iron | Wisconsin | 55051 | 631 | 38 |
1027469 | 1027469 | 2021-02-13 | Iron | Wisconsin | 55051 | 631 | 38 |
1024224 | 1024224 | 2021-02-12 | Iron | Wisconsin | 55051 | 630 | 38 |
1020979 | 1020979 | 2021-02-11 | Iron | Wisconsin | 55051 | 622 | 37 |
1017734 | 1017734 | 2021-02-10 | Iron | Wisconsin | 55051 | 612 | 37 |
1014489 | 1014489 | 2021-02-09 | Iron | Wisconsin | 55051 | 609 | 37 |
1011244 | 1011244 | 2021-02-08 | Iron | Wisconsin | 55051 | 601 | 37 |
1007998 | 1007998 | 2021-02-07 | Iron | Wisconsin | 55051 | 601 | 37 |
1004752 | 1004752 | 2021-02-06 | Iron | Wisconsin | 55051 | 601 | 37 |
1001506 | 1001506 | 2021-02-05 | Iron | Wisconsin | 55051 | 599 | 37 |
998260 | 998260 | 2021-02-04 | Iron | Wisconsin | 55051 | 595 | 37 |
995014 | 995014 | 2021-02-03 | Iron | Wisconsin | 55051 | 588 | 37 |
991768 | 991768 | 2021-02-02 | Iron | Wisconsin | 55051 | 588 | 37 |
988522 | 988522 | 2021-02-01 | Iron | Wisconsin | 55051 | 588 | 36 |
985275 | 985275 | 2021-01-31 | Iron | Wisconsin | 55051 | 588 | 36 |
982028 | 982028 | 2021-01-30 | Iron | Wisconsin | 55051 | 587 | 36 |
978782 | 978782 | 2021-01-29 | Iron | Wisconsin | 55051 | 584 | 36 |
975537 | 975537 | 2021-01-28 | Iron | Wisconsin | 55051 | 582 | 36 |
972292 | 972292 | 2021-01-27 | Iron | Wisconsin | 55051 | 582 | 36 |
969047 | 969047 | 2021-01-26 | Iron | Wisconsin | 55051 | 583 | 36 |
965803 | 965803 | 2021-01-25 | Iron | Wisconsin | 55051 | 581 | 36 |
962558 | 962558 | 2021-01-24 | Iron | Wisconsin | 55051 | 581 | 36 |
959313 | 959313 | 2021-01-23 | Iron | Wisconsin | 55051 | 581 | 36 |
956067 | 956067 | 2021-01-22 | Iron | Wisconsin | 55051 | 579 | 36 |
952822 | 952822 | 2021-01-21 | Iron | Wisconsin | 55051 | 561 | 36 |
949577 | 949577 | 2021-01-20 | Iron | Wisconsin | 55051 | 563 | 36 |
946331 | 946331 | 2021-01-19 | Iron | Wisconsin | 55051 | 559 | 36 |
943084 | 943084 | 2021-01-18 | Iron | Wisconsin | 55051 | 556 | 36 |
939839 | 939839 | 2021-01-17 | Iron | Wisconsin | 55051 | 556 | 36 |
936594 | 936594 | 2021-01-16 | Iron | Wisconsin | 55051 | 556 | 36 |
933349 | 933349 | 2021-01-15 | Iron | Wisconsin | 55051 | 550 | 36 |
930104 | 930104 | 2021-01-14 | Iron | Wisconsin | 55051 | 550 | 36 |
926859 | 926859 | 2021-01-13 | Iron | Wisconsin | 55051 | 546 | 36 |
923613 | 923613 | 2021-01-12 | Iron | Wisconsin | 55051 | 545 | 36 |
920368 | 920368 | 2021-01-11 | Iron | Wisconsin | 55051 | 544 | 35 |
917123 | 917123 | 2021-01-10 | Iron | Wisconsin | 55051 | 544 | 35 |
913878 | 913878 | 2021-01-09 | Iron | Wisconsin | 55051 | 544 | 35 |
910633 | 910633 | 2021-01-08 | Iron | Wisconsin | 55051 | 544 | 35 |
907388 | 907388 | 2021-01-07 | Iron | Wisconsin | 55051 | 538 | 35 |
904142 | 904142 | 2021-01-06 | Iron | Wisconsin | 55051 | 535 | 35 |
900897 | 900897 | 2021-01-05 | Iron | Wisconsin | 55051 | 533 | 35 |
897652 | 897652 | 2021-01-04 | Iron | Wisconsin | 55051 | 532 | 35 |
894406 | 894406 | 2021-01-03 | Iron | Wisconsin | 55051 | 532 | 35 |
891160 | 891160 | 2021-01-02 | Iron | Wisconsin | 55051 | 530 | 35 |
887913 | 887913 | 2021-01-01 | Iron | Wisconsin | 55051 | 527 | 33 |
884668 | 884668 | 2020-12-31 | Iron | Wisconsin | 55051 | 527 | 33 |
881423 | 881423 | 2020-12-30 | Iron | Wisconsin | 55051 | 525 | 33 |
878178 | 878178 | 2020-12-29 | Iron | Wisconsin | 55051 | 524 | 29 |
874933 | 874933 | 2020-12-28 | Iron | Wisconsin | 55051 | 522 | 29 |
871688 | 871688 | 2020-12-27 | Iron | Wisconsin | 55051 | 521 | 28 |
868443 | 868443 | 2020-12-26 | Iron | Wisconsin | 55051 | 518 | 25 |
865198 | 865198 | 2020-12-25 | Iron | Wisconsin | 55051 | 518 | 25 |
861953 | 861953 | 2020-12-24 | Iron | Wisconsin | 55051 | 518 | 25 |
858708 | 858708 | 2020-12-23 | Iron | Wisconsin | 55051 | 516 | 25 |
855463 | 855463 | 2020-12-22 | Iron | Wisconsin | 55051 | 517 | 25 |
852218 | 852218 | 2020-12-21 | Iron | Wisconsin | 55051 | 507 | 20 |
848973 | 848973 | 2020-12-20 | Iron | Wisconsin | 55051 | 507 | 20 |
845728 | 845728 | 2020-12-19 | Iron | Wisconsin | 55051 | 507 | 20 |
842482 | 842482 | 2020-12-18 | Iron | Wisconsin | 55051 | 506 | 20 |
839237 | 839237 | 2020-12-17 | Iron | Wisconsin | 55051 | 500 | 18 |
835992 | 835992 | 2020-12-16 | Iron | Wisconsin | 55051 | 495 | 17 |
832746 | 832746 | 2020-12-15 | Iron | Wisconsin | 55051 | 483 | 16 |
829499 | 829499 | 2020-12-14 | Iron | Wisconsin | 55051 | 477 | 16 |
826253 | 826253 | 2020-12-13 | Iron | Wisconsin | 55051 | 477 | 16 |
823006 | 823006 | 2020-12-12 | Iron | Wisconsin | 55051 | 477 | 16 |
819760 | 819760 | 2020-12-11 | Iron | Wisconsin | 55051 | 477 | 16 |
816514 | 816514 | 2020-12-10 | Iron | Wisconsin | 55051 | 461 | 16 |
813268 | 813268 | 2020-12-09 | Iron | Wisconsin | 55051 | 459 | 16 |
810024 | 810024 | 2020-12-08 | Iron | Wisconsin | 55051 | 458 | 16 |
806779 | 806779 | 2020-12-07 | Iron | Wisconsin | 55051 | 452 | 15 |
803534 | 803534 | 2020-12-06 | Iron | Wisconsin | 55051 | 443 | 15 |
800289 | 800289 | 2020-12-05 | Iron | Wisconsin | 55051 | 443 | 15 |
797044 | 797044 | 2020-12-04 | Iron | Wisconsin | 55051 | 438 | 15 |
793799 | 793799 | 2020-12-03 | Iron | Wisconsin | 55051 | 433 | 14 |
790554 | 790554 | 2020-12-02 | Iron | Wisconsin | 55051 | 428 | 14 |
787309 | 787309 | 2020-12-01 | Iron | Wisconsin | 55051 | 426 | 14 |
784065 | 784065 | 2020-11-30 | Iron | Wisconsin | 55051 | 413 | 13 |
780820 | 780820 | 2020-11-29 | Iron | Wisconsin | 55051 | 413 | 13 |
777574 | 777574 | 2020-11-28 | Iron | Wisconsin | 55051 | 410 | 13 |
774329 | 774329 | 2020-11-27 | Iron | Wisconsin | 55051 | 405 | 13 |
771084 | 771084 | 2020-11-26 | Iron | Wisconsin | 55051 | 405 | 13 |
767838 | 767838 | 2020-11-25 | Iron | Wisconsin | 55051 | 398 | 12 |
764593 | 764593 | 2020-11-24 | Iron | Wisconsin | 55051 | 396 | 11 |
761348 | 761348 | 2020-11-23 | Iron | Wisconsin | 55051 | 384 | 9 |
758103 | 758103 | 2020-11-22 | Iron | Wisconsin | 55051 | 384 | 9 |
754856 | 754856 | 2020-11-21 | Iron | Wisconsin | 55051 | 383 | 9 |
751610 | 751610 | 2020-11-20 | Iron | Wisconsin | 55051 | 380 | 9 |
748364 | 748364 | 2020-11-19 | Iron | Wisconsin | 55051 | 375 | 9 |
745118 | 745118 | 2020-11-18 | Iron | Wisconsin | 55051 | 371 | 9 |
741871 | 741871 | 2020-11-17 | Iron | Wisconsin | 55051 | 362 | 9 |
738624 | 738624 | 2020-11-16 | Iron | Wisconsin | 55051 | 350 | 7 |
735380 | 735380 | 2020-11-15 | Iron | Wisconsin | 55051 | 350 | 7 |
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);