ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Kane" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923325 | 923325 | 2021-01-12 | Kane | Utah | 49025 | 369 | 2 |
920080 | 920080 | 2021-01-11 | Kane | Utah | 49025 | 369 | 2 |
916835 | 916835 | 2021-01-10 | Kane | Utah | 49025 | 357 | 2 |
913590 | 913590 | 2021-01-09 | Kane | Utah | 49025 | 357 | 2 |
910345 | 910345 | 2021-01-08 | Kane | Utah | 49025 | 351 | 2 |
907100 | 907100 | 2021-01-07 | Kane | Utah | 49025 | 348 | 2 |
903854 | 903854 | 2021-01-06 | Kane | Utah | 49025 | 344 | 2 |
900609 | 900609 | 2021-01-05 | Kane | Utah | 49025 | 343 | 2 |
897364 | 897364 | 2021-01-04 | Kane | Utah | 49025 | 339 | 2 |
894118 | 894118 | 2021-01-03 | Kane | Utah | 49025 | 335 | 2 |
890872 | 890872 | 2021-01-02 | Kane | Utah | 49025 | 335 | 2 |
887625 | 887625 | 2021-01-01 | Kane | Utah | 49025 | 332 | 2 |
884380 | 884380 | 2020-12-31 | Kane | Utah | 49025 | 332 | 2 |
881135 | 881135 | 2020-12-30 | Kane | Utah | 49025 | 331 | 2 |
877890 | 877890 | 2020-12-29 | Kane | Utah | 49025 | 330 | 2 |
874645 | 874645 | 2020-12-28 | Kane | Utah | 49025 | 327 | 1 |
871400 | 871400 | 2020-12-27 | Kane | Utah | 49025 | 323 | 1 |
868155 | 868155 | 2020-12-26 | Kane | Utah | 49025 | 323 | 1 |
864910 | 864910 | 2020-12-25 | Kane | Utah | 49025 | 320 | 1 |
861665 | 861665 | 2020-12-24 | Kane | Utah | 49025 | 320 | 1 |
858420 | 858420 | 2020-12-23 | Kane | Utah | 49025 | 319 | 1 |
855175 | 855175 | 2020-12-22 | Kane | Utah | 49025 | 317 | 1 |
851930 | 851930 | 2020-12-21 | Kane | Utah | 49025 | 310 | 1 |
848685 | 848685 | 2020-12-20 | Kane | Utah | 49025 | 303 | 1 |
845440 | 845440 | 2020-12-19 | Kane | Utah | 49025 | 303 | 1 |
842194 | 842194 | 2020-12-18 | Kane | Utah | 49025 | 301 | 1 |
838949 | 838949 | 2020-12-17 | Kane | Utah | 49025 | 297 | 1 |
835703 | 835703 | 2020-12-16 | Kane | Utah | 49025 | 290 | 1 |
832457 | 832457 | 2020-12-15 | Kane | Utah | 49025 | 283 | 1 |
829210 | 829210 | 2020-12-14 | Kane | Utah | 49025 | 279 | 1 |
825964 | 825964 | 2020-12-13 | Kane | Utah | 49025 | 268 | 1 |
822717 | 822717 | 2020-12-12 | Kane | Utah | 49025 | 268 | 1 |
819471 | 819471 | 2020-12-11 | Kane | Utah | 49025 | 255 | 1 |
816225 | 816225 | 2020-12-10 | Kane | Utah | 49025 | 253 | 1 |
812979 | 812979 | 2020-12-09 | Kane | Utah | 49025 | 243 | 1 |
809735 | 809735 | 2020-12-08 | Kane | Utah | 49025 | 234 | 1 |
806490 | 806490 | 2020-12-07 | Kane | Utah | 49025 | 222 | 1 |
803245 | 803245 | 2020-12-06 | Kane | Utah | 49025 | 205 | 1 |
800000 | 800000 | 2020-12-05 | Kane | Utah | 49025 | 205 | 1 |
796755 | 796755 | 2020-12-04 | Kane | Utah | 49025 | 198 | 1 |
793510 | 793510 | 2020-12-03 | Kane | Utah | 49025 | 193 | 1 |
790265 | 790265 | 2020-12-02 | Kane | Utah | 49025 | 187 | 1 |
787020 | 787020 | 2020-12-01 | Kane | Utah | 49025 | 182 | 1 |
783776 | 783776 | 2020-11-30 | Kane | Utah | 49025 | 173 | 1 |
780531 | 780531 | 2020-11-29 | Kane | Utah | 49025 | 163 | 1 |
777285 | 777285 | 2020-11-28 | Kane | Utah | 49025 | 163 | 1 |
774040 | 774040 | 2020-11-27 | Kane | Utah | 49025 | 158 | 1 |
770795 | 770795 | 2020-11-26 | Kane | Utah | 49025 | 158 | 1 |
767549 | 767549 | 2020-11-25 | Kane | Utah | 49025 | 158 | 1 |
764304 | 764304 | 2020-11-24 | Kane | Utah | 49025 | 154 | 1 |
761059 | 761059 | 2020-11-23 | Kane | Utah | 49025 | 153 | 1 |
757814 | 757814 | 2020-11-22 | Kane | Utah | 49025 | 150 | 1 |
754567 | 754567 | 2020-11-21 | Kane | Utah | 49025 | 150 | 1 |
751321 | 751321 | 2020-11-20 | Kane | Utah | 49025 | 140 | 1 |
748075 | 748075 | 2020-11-19 | Kane | Utah | 49025 | 137 | 1 |
744829 | 744829 | 2020-11-18 | Kane | Utah | 49025 | 133 | 1 |
741582 | 741582 | 2020-11-17 | Kane | Utah | 49025 | 124 | 1 |
738335 | 738335 | 2020-11-16 | Kane | Utah | 49025 | 123 | 1 |
735091 | 735091 | 2020-11-15 | Kane | Utah | 49025 | 118 | 1 |
731845 | 731845 | 2020-11-14 | Kane | Utah | 49025 | 118 | 1 |
728600 | 728600 | 2020-11-13 | Kane | Utah | 49025 | 111 | 1 |
725357 | 725357 | 2020-11-12 | Kane | Utah | 49025 | 111 | 1 |
722114 | 722114 | 2020-11-11 | Kane | Utah | 49025 | 109 | 1 |
718871 | 718871 | 2020-11-10 | Kane | Utah | 49025 | 108 | 1 |
715628 | 715628 | 2020-11-09 | Kane | Utah | 49025 | 107 | 1 |
712384 | 712384 | 2020-11-08 | Kane | Utah | 49025 | 107 | 1 |
709140 | 709140 | 2020-11-07 | Kane | Utah | 49025 | 107 | 1 |
705896 | 705896 | 2020-11-06 | Kane | Utah | 49025 | 107 | 1 |
702653 | 702653 | 2020-11-05 | Kane | Utah | 49025 | 106 | 1 |
699410 | 699410 | 2020-11-04 | Kane | Utah | 49025 | 105 | 1 |
696166 | 696166 | 2020-11-03 | Kane | Utah | 49025 | 105 | 1 |
692924 | 692924 | 2020-11-02 | Kane | Utah | 49025 | 104 | 1 |
689680 | 689680 | 2020-11-01 | Kane | Utah | 49025 | 104 | 1 |
686435 | 686435 | 2020-10-31 | Kane | Utah | 49025 | 104 | 1 |
683192 | 683192 | 2020-10-30 | Kane | Utah | 49025 | 103 | 1 |
679949 | 679949 | 2020-10-29 | Kane | Utah | 49025 | 103 | 1 |
676706 | 676706 | 2020-10-28 | Kane | Utah | 49025 | 101 | 1 |
673463 | 673463 | 2020-10-27 | Kane | Utah | 49025 | 98 | 1 |
670221 | 670221 | 2020-10-26 | Kane | Utah | 49025 | 97 | 1 |
666978 | 666978 | 2020-10-25 | Kane | Utah | 49025 | 97 | 1 |
663733 | 663733 | 2020-10-24 | Kane | Utah | 49025 | 97 | 1 |
660489 | 660489 | 2020-10-23 | Kane | Utah | 49025 | 97 | 1 |
657245 | 657245 | 2020-10-22 | Kane | Utah | 49025 | 95 | 1 |
654000 | 654000 | 2020-10-21 | Kane | Utah | 49025 | 95 | 1 |
650755 | 650755 | 2020-10-20 | Kane | Utah | 49025 | 95 | 1 |
647511 | 647511 | 2020-10-19 | Kane | Utah | 49025 | 95 | 1 |
644265 | 644265 | 2020-10-18 | Kane | Utah | 49025 | 93 | 1 |
641017 | 641017 | 2020-10-17 | Kane | Utah | 49025 | 93 | 1 |
637770 | 637770 | 2020-10-16 | Kane | Utah | 49025 | 91 | 1 |
634525 | 634525 | 2020-10-15 | Kane | Utah | 49025 | 90 | 1 |
631280 | 631280 | 2020-10-14 | Kane | Utah | 49025 | 90 | 1 |
628036 | 628036 | 2020-10-13 | Kane | Utah | 49025 | 90 | 1 |
624793 | 624793 | 2020-10-12 | Kane | Utah | 49025 | 88 | 1 |
621550 | 621550 | 2020-10-11 | Kane | Utah | 49025 | 87 | 1 |
618307 | 618307 | 2020-10-10 | Kane | Utah | 49025 | 87 | 1 |
615065 | 615065 | 2020-10-09 | Kane | Utah | 49025 | 87 | 1 |
611824 | 611824 | 2020-10-08 | Kane | Utah | 49025 | 87 | 1 |
608582 | 608582 | 2020-10-07 | Kane | Utah | 49025 | 86 | 1 |
605339 | 605339 | 2020-10-06 | Kane | Utah | 49025 | 86 | 1 |
602097 | 602097 | 2020-10-05 | Kane | Utah | 49025 | 85 | 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);