ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Unknown" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917283 | 917283 | 2021-01-11 | Unknown | Alaska | 211 | 0 | |
914038 | 914038 | 2021-01-10 | Unknown | Alaska | 253 | 0 | |
910793 | 910793 | 2021-01-09 | Unknown | Alaska | 248 | 0 | |
907548 | 907548 | 2021-01-08 | Unknown | Alaska | 245 | 0 | |
904302 | 904302 | 2021-01-07 | Unknown | Alaska | 237 | 0 | |
901057 | 901057 | 2021-01-06 | Unknown | Alaska | 237 | 0 | |
897812 | 897812 | 2021-01-05 | Unknown | Alaska | 231 | 0 | |
894566 | 894566 | 2021-01-04 | Unknown | Alaska | 229 | 0 | |
891320 | 891320 | 2021-01-03 | Unknown | Alaska | 226 | 0 | |
888073 | 888073 | 2021-01-02 | Unknown | Alaska | 225 | 0 | |
884828 | 884828 | 2021-01-01 | Unknown | Alaska | 218 | 0 | |
881583 | 881583 | 2020-12-31 | Unknown | Alaska | 218 | 0 | |
878338 | 878338 | 2020-12-30 | Unknown | Alaska | 221 | 0 | |
875093 | 875093 | 2020-12-29 | Unknown | Alaska | 219 | 0 | |
871848 | 871848 | 2020-12-28 | Unknown | Alaska | 216 | 0 | |
868603 | 868603 | 2020-12-27 | Unknown | Alaska | 214 | 0 | |
865358 | 865358 | 2020-12-26 | Unknown | Alaska | 210 | 0 | |
862113 | 862113 | 2020-12-25 | Unknown | Alaska | 207 | 0 | |
858868 | 858868 | 2020-12-24 | Unknown | Alaska | 207 | 0 | |
855623 | 855623 | 2020-12-23 | Unknown | Alaska | 205 | 0 | |
852378 | 852378 | 2020-12-22 | Unknown | Alaska | 204 | 0 | |
849133 | 849133 | 2020-12-21 | Unknown | Alaska | 204 | 0 | |
845888 | 845888 | 2020-12-20 | Unknown | Alaska | 209 | 0 | |
842642 | 842642 | 2020-12-19 | Unknown | Alaska | 226 | 0 | |
839397 | 839397 | 2020-12-18 | Unknown | Alaska | 223 | 0 | |
836152 | 836152 | 2020-12-17 | Unknown | Alaska | 215 | 0 | |
832906 | 832906 | 2020-12-16 | Unknown | Alaska | 218 | 0 | |
829659 | 829659 | 2020-12-15 | Unknown | Alaska | 215 | 0 | |
826413 | 826413 | 2020-12-14 | Unknown | Alaska | 212 | 0 | |
823166 | 823166 | 2020-12-13 | Unknown | Alaska | 210 | 0 | |
819920 | 819920 | 2020-12-12 | Unknown | Alaska | 207 | 0 | |
816674 | 816674 | 2020-12-11 | Unknown | Alaska | 206 | 0 | |
813428 | 813428 | 2020-12-10 | Unknown | Alaska | 203 | 0 | |
810184 | 810184 | 2020-12-09 | Unknown | Alaska | 192 | 0 | |
806939 | 806939 | 2020-12-08 | Unknown | Alaska | 192 | 0 | |
803694 | 803694 | 2020-12-07 | Unknown | Alaska | 184 | 0 | |
800449 | 800449 | 2020-12-06 | Unknown | Alaska | 180 | 0 | |
797204 | 797204 | 2020-12-05 | Unknown | Alaska | 179 | 0 | |
793959 | 793959 | 2020-12-04 | Unknown | Alaska | 170 | 0 | |
790714 | 790714 | 2020-12-03 | Unknown | Alaska | 167 | 0 | |
787469 | 787469 | 2020-12-02 | Unknown | Alaska | 164 | 0 | |
784225 | 784225 | 2020-12-01 | Unknown | Alaska | 158 | 0 | |
780980 | 780980 | 2020-11-30 | Unknown | Alaska | 158 | 0 | |
777734 | 777734 | 2020-11-29 | Unknown | Alaska | 156 | 0 | |
774489 | 774489 | 2020-11-28 | Unknown | Alaska | 155 | 0 | |
771244 | 771244 | 2020-11-27 | Unknown | Alaska | 151 | 0 | |
767998 | 767998 | 2020-11-26 | Unknown | Alaska | 144 | 0 | |
764753 | 764753 | 2020-11-25 | Unknown | Alaska | 139 | 0 | |
761508 | 761508 | 2020-11-24 | Unknown | Alaska | 132 | 0 | |
758263 | 758263 | 2020-11-23 | Unknown | Alaska | 129 | 0 | |
755016 | 755016 | 2020-11-22 | Unknown | Alaska | 129 | 0 | |
751770 | 751770 | 2020-11-21 | Unknown | Alaska | 122 | 0 | |
748524 | 748524 | 2020-11-20 | Unknown | Alaska | 118 | 0 | |
745278 | 745278 | 2020-11-19 | Unknown | Alaska | 115 | 0 | |
742031 | 742031 | 2020-11-18 | Unknown | Alaska | 116 | 0 | |
738784 | 738784 | 2020-11-17 | Unknown | Alaska | 115 | 0 | |
735540 | 735540 | 2020-11-16 | Unknown | Alaska | 106 | 0 | |
732294 | 732294 | 2020-11-15 | Unknown | Alaska | 104 | 0 | |
729049 | 729049 | 2020-11-14 | Unknown | Alaska | 100 | 0 | |
725806 | 725806 | 2020-11-13 | Unknown | Alaska | 90 | 0 | |
722563 | 722563 | 2020-11-12 | Unknown | Alaska | 82 | 0 | |
719320 | 719320 | 2020-11-11 | Unknown | Alaska | 81 | 0 | |
716077 | 716077 | 2020-11-10 | Unknown | Alaska | 84 | 0 | |
712833 | 712833 | 2020-11-09 | Unknown | Alaska | 82 | 0 | |
709589 | 709589 | 2020-11-08 | Unknown | Alaska | 81 | 0 | |
706345 | 706345 | 2020-11-07 | Unknown | Alaska | 80 | 0 | |
703102 | 703102 | 2020-11-06 | Unknown | Alaska | 79 | 0 | |
699859 | 699859 | 2020-11-05 | Unknown | Alaska | 77 | 0 | |
696615 | 696615 | 2020-11-04 | Unknown | Alaska | 73 | 0 | |
693373 | 693373 | 2020-11-03 | Unknown | Alaska | 71 | 0 | |
690130 | 690130 | 2020-11-02 | Unknown | Alaska | 69 | 0 | |
686885 | 686885 | 2020-11-01 | Unknown | Alaska | 68 | 0 | |
683641 | 683641 | 2020-10-31 | Unknown | Alaska | 64 | 0 | |
680398 | 680398 | 2020-10-30 | Unknown | Alaska | 64 | 0 | |
677155 | 677155 | 2020-10-29 | Unknown | Alaska | 60 | 0 | |
673912 | 673912 | 2020-10-28 | Unknown | Alaska | 64 | 0 | |
670670 | 670670 | 2020-10-27 | Unknown | Alaska | 62 | 0 | |
667427 | 667427 | 2020-10-26 | Unknown | Alaska | 61 | 0 | |
664182 | 664182 | 2020-10-25 | Unknown | Alaska | 61 | 0 | |
660938 | 660938 | 2020-10-24 | Unknown | Alaska | 58 | 0 | |
657694 | 657694 | 2020-10-23 | Unknown | Alaska | 59 | 0 | |
654449 | 654449 | 2020-10-22 | Unknown | Alaska | 55 | 0 | |
651204 | 651204 | 2020-10-21 | Unknown | Alaska | 56 | 0 | |
647960 | 647960 | 2020-10-20 | Unknown | Alaska | 55 | 0 | |
644715 | 644715 | 2020-10-19 | Unknown | Alaska | 53 | 0 | |
641467 | 641467 | 2020-10-18 | Unknown | Alaska | 51 | 0 | |
638220 | 638220 | 2020-10-17 | Unknown | Alaska | 52 | 0 | |
634975 | 634975 | 2020-10-16 | Unknown | Alaska | 50 | 0 | |
631729 | 631729 | 2020-10-15 | Unknown | Alaska | 49 | 0 | |
628485 | 628485 | 2020-10-14 | Unknown | Alaska | 47 | 0 | |
625242 | 625242 | 2020-10-13 | Unknown | Alaska | 47 | 0 | |
621999 | 621999 | 2020-10-12 | Unknown | Alaska | 47 | 0 | |
618756 | 618756 | 2020-10-11 | Unknown | Alaska | 43 | 0 | |
615514 | 615514 | 2020-10-10 | Unknown | Alaska | 43 | 0 | |
612273 | 612273 | 2020-10-09 | Unknown | Alaska | 43 | 0 | |
609031 | 609031 | 2020-10-08 | Unknown | Alaska | 41 | 0 | |
605788 | 605788 | 2020-10-07 | Unknown | Alaska | 39 | 0 | |
602546 | 602546 | 2020-10-06 | Unknown | Alaska | 39 | 0 | |
599303 | 599303 | 2020-10-05 | Unknown | Alaska | 37 | 0 | |
596060 | 596060 | 2020-10-04 | Unknown | Alaska | 37 | 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);