ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Unknown" and state = "Guam" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920988 | 920988 | 2021-01-12 | Unknown | Guam | 8398 | 125 | |
917743 | 917743 | 2021-01-11 | Unknown | Guam | 8392 | 125 | |
914498 | 914498 | 2021-01-10 | Unknown | Guam | 8381 | 125 | |
911253 | 911253 | 2021-01-09 | Unknown | Guam | 8373 | 125 | |
908008 | 908008 | 2021-01-08 | Unknown | Guam | 8368 | 125 | |
904762 | 904762 | 2021-01-07 | Unknown | Guam | 8355 | 124 | |
901517 | 901517 | 2021-01-06 | Unknown | Guam | 8347 | 124 | |
898272 | 898272 | 2021-01-05 | Unknown | Guam | 8326 | 124 | |
895027 | 895027 | 2021-01-04 | Unknown | Guam | 8313 | 124 | |
891780 | 891780 | 2021-01-03 | Unknown | Guam | 8296 | 124 | |
888533 | 888533 | 2021-01-02 | Unknown | Guam | 8295 | 124 | |
885288 | 885288 | 2021-01-01 | Unknown | Guam | 8295 | 123 | |
882043 | 882043 | 2020-12-31 | Unknown | Guam | 8286 | 123 | |
878798 | 878798 | 2020-12-30 | Unknown | Guam | 8277 | 122 | |
875553 | 875553 | 2020-12-29 | Unknown | Guam | 8262 | 122 | |
872308 | 872308 | 2020-12-28 | Unknown | Guam | 8250 | 122 | |
869063 | 869063 | 2020-12-27 | Unknown | Guam | 8239 | 122 | |
865818 | 865818 | 2020-12-26 | Unknown | Guam | 8238 | 122 | |
862573 | 862573 | 2020-12-25 | Unknown | Guam | 8237 | 122 | |
859328 | 859328 | 2020-12-24 | Unknown | Guam | 8235 | 122 | |
856083 | 856083 | 2020-12-23 | Unknown | Guam | 8180 | 121 | |
852838 | 852838 | 2020-12-22 | Unknown | Guam | 8180 | 121 | |
849593 | 849593 | 2020-12-21 | Unknown | Guam | 8180 | 121 | |
846348 | 846348 | 2020-12-20 | Unknown | Guam | 8171 | 120 | |
843102 | 843102 | 2020-12-19 | Unknown | Guam | 8167 | 120 | |
839857 | 839857 | 2020-12-18 | Unknown | Guam | 8162 | 120 | |
836612 | 836612 | 2020-12-17 | Unknown | Guam | 8152 | 120 | |
833366 | 833366 | 2020-12-16 | Unknown | Guam | 8137 | 120 | |
830119 | 830119 | 2020-12-15 | Unknown | Guam | 8118 | 120 | |
826873 | 826873 | 2020-12-14 | Unknown | Guam | 8106 | 120 | |
823626 | 823626 | 2020-12-13 | Unknown | Guam | 8075 | 119 | |
820380 | 820380 | 2020-12-12 | Unknown | Guam | 8059 | 118 | |
817134 | 817134 | 2020-12-11 | Unknown | Guam | 8048 | 116 | |
813888 | 813888 | 2020-12-10 | Unknown | Guam | 8021 | 116 | |
810644 | 810644 | 2020-12-09 | Unknown | Guam | 8008 | 114 | |
807399 | 807399 | 2020-12-08 | Unknown | Guam | 7995 | 114 | |
804154 | 804154 | 2020-12-07 | Unknown | Guam | 7988 | 114 | |
800909 | 800909 | 2020-12-06 | Unknown | Guam | 7973 | 114 | |
797664 | 797664 | 2020-12-05 | Unknown | Guam | 7946 | 114 | |
794419 | 794419 | 2020-12-04 | Unknown | Guam | 7928 | 114 | |
791174 | 791174 | 2020-12-03 | Unknown | Guam | 7911 | 113 | |
787929 | 787929 | 2020-12-02 | Unknown | Guam | 7889 | 113 | |
784685 | 784685 | 2020-12-01 | Unknown | Guam | 7858 | 113 | |
781440 | 781440 | 2020-11-30 | Unknown | Guam | 7821 | 113 | |
778194 | 778194 | 2020-11-29 | Unknown | Guam | 7787 | 113 | |
774949 | 774949 | 2020-11-28 | Unknown | Guam | 7751 | 113 | |
771704 | 771704 | 2020-11-27 | Unknown | Guam | 7737 | 113 | |
768459 | 768459 | 2020-11-26 | Unknown | Guam | 7717 | 112 | |
765213 | 765213 | 2020-11-25 | Unknown | Guam | 7674 | 110 | |
761968 | 761968 | 2020-11-24 | Unknown | Guam | 7624 | 108 | |
758723 | 758723 | 2020-11-23 | Unknown | Guam | 7571 | 107 | |
755476 | 755476 | 2020-11-22 | Unknown | Guam | 7518 | 107 | |
752230 | 752230 | 2020-11-21 | Unknown | Guam | 7421 | 104 | |
748984 | 748984 | 2020-11-20 | Unknown | Guam | 7421 | 104 | |
745738 | 745738 | 2020-11-19 | Unknown | Guam | 7385 | 102 | |
742491 | 742491 | 2020-11-18 | Unknown | Guam | 7315 | 101 | |
739244 | 739244 | 2020-11-17 | Unknown | Guam | 7203 | 101 | |
736000 | 736000 | 2020-11-16 | Unknown | Guam | 7144 | 99 | |
732754 | 732754 | 2020-11-15 | Unknown | Guam | 6893 | 93 | |
729509 | 729509 | 2020-11-14 | Unknown | Guam | 6893 | 93 | |
726266 | 726266 | 2020-11-13 | Unknown | Guam | 6893 | 93 | |
723023 | 723023 | 2020-11-12 | Unknown | Guam | 6819 | 92 | |
719780 | 719780 | 2020-11-11 | Unknown | Guam | 6724 | 92 | |
716537 | 716537 | 2020-11-10 | Unknown | Guam | 6623 | 92 | |
713293 | 713293 | 2020-11-09 | Unknown | Guam | 6442 | 91 | |
710049 | 710049 | 2020-11-08 | Unknown | Guam | 6046 | 89 | |
706805 | 706805 | 2020-11-07 | Unknown | Guam | 6046 | 89 | |
703562 | 703562 | 2020-11-06 | Unknown | Guam | 6046 | 89 | |
700319 | 700319 | 2020-11-05 | Unknown | Guam | 5973 | 84 | |
697075 | 697075 | 2020-11-04 | Unknown | Guam | 5872 | 84 | |
693833 | 693833 | 2020-11-03 | Unknown | Guam | 5781 | 81 | |
690590 | 690590 | 2020-11-02 | Unknown | Guam | 5662 | 80 | |
687345 | 687345 | 2020-11-01 | Unknown | Guam | 5659 | 80 | |
684101 | 684101 | 2020-10-31 | Unknown | Guam | 5650 | 80 | |
680858 | 680858 | 2020-10-30 | Unknown | Guam | 5597 | 80 | |
677615 | 677615 | 2020-10-29 | Unknown | Guam | 5518 | 79 | |
674372 | 674372 | 2020-10-28 | Unknown | Guam | 5435 | 77 | |
671130 | 671130 | 2020-10-27 | Unknown | Guam | 5387 | 76 | |
667887 | 667887 | 2020-10-26 | Unknown | Guam | 5305 | 76 | |
664642 | 664642 | 2020-10-25 | Unknown | Guam | 5185 | 72 | |
661398 | 661398 | 2020-10-24 | Unknown | Guam | 5144 | 72 | |
658154 | 658154 | 2020-10-23 | Unknown | Guam | 5110 | 70 | |
654909 | 654909 | 2020-10-22 | Unknown | Guam | 5025 | 70 | |
651664 | 651664 | 2020-10-21 | Unknown | Guam | 4937 | 69 | |
648420 | 648420 | 2020-10-20 | Unknown | Guam | 4855 | 67 | |
645175 | 645175 | 2020-10-19 | Unknown | Guam | 4725 | 67 | |
641927 | 641927 | 2020-10-18 | Unknown | Guam | 4507 | 64 | |
638680 | 638680 | 2020-10-17 | Unknown | Guam | 4507 | 64 | |
635435 | 635435 | 2020-10-16 | Unknown | Guam | 4507 | 64 | |
632189 | 632189 | 2020-10-15 | Unknown | Guam | 4396 | 62 | |
628945 | 628945 | 2020-10-14 | Unknown | Guam | 4310 | 62 | |
625702 | 625702 | 2020-10-13 | Unknown | Guam | 4235 | 62 | |
622459 | 622459 | 2020-10-12 | Unknown | Guam | 4139 | 61 | |
619216 | 619216 | 2020-10-11 | Unknown | Guam | 4047 | 61 | |
615974 | 615974 | 2020-10-10 | Unknown | Guam | 4025 | 60 | |
612733 | 612733 | 2020-10-09 | Unknown | Guam | 3958 | 59 | |
609491 | 609491 | 2020-10-08 | Unknown | Guam | 3903 | 59 | |
606248 | 606248 | 2020-10-07 | Unknown | Guam | 3837 | 58 | |
603006 | 603006 | 2020-10-06 | Unknown | Guam | 3787 | 56 | |
599763 | 599763 | 2020-10-05 | Unknown | Guam | 3722 | 56 |
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);