ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72055 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922794 | 922794 | 2021-01-12 | Guanica | Puerto Rico | 72055 | 231 | |
919549 | 919549 | 2021-01-11 | Guanica | Puerto Rico | 72055 | 231 | |
916304 | 916304 | 2021-01-10 | Guanica | Puerto Rico | 72055 | 231 | |
913059 | 913059 | 2021-01-09 | Guanica | Puerto Rico | 72055 | 230 | |
909814 | 909814 | 2021-01-08 | Guanica | Puerto Rico | 72055 | 230 | |
906569 | 906569 | 2021-01-07 | Guanica | Puerto Rico | 72055 | 228 | |
903323 | 903323 | 2021-01-06 | Guanica | Puerto Rico | 72055 | 227 | |
900078 | 900078 | 2021-01-05 | Guanica | Puerto Rico | 72055 | 227 | |
896833 | 896833 | 2021-01-04 | Guanica | Puerto Rico | 72055 | 227 | |
893587 | 893587 | 2021-01-03 | Guanica | Puerto Rico | 72055 | 227 | |
890341 | 890341 | 2021-01-02 | Guanica | Puerto Rico | 72055 | 227 | |
887094 | 887094 | 2021-01-01 | Guanica | Puerto Rico | 72055 | 226 | |
883849 | 883849 | 2020-12-31 | Guanica | Puerto Rico | 72055 | 223 | |
880604 | 880604 | 2020-12-30 | Guanica | Puerto Rico | 72055 | 223 | |
877359 | 877359 | 2020-12-29 | Guanica | Puerto Rico | 72055 | 223 | |
874114 | 874114 | 2020-12-28 | Guanica | Puerto Rico | 72055 | 219 | |
870869 | 870869 | 2020-12-27 | Guanica | Puerto Rico | 72055 | 219 | |
867624 | 867624 | 2020-12-26 | Guanica | Puerto Rico | 72055 | 219 | |
864379 | 864379 | 2020-12-25 | Guanica | Puerto Rico | 72055 | 219 | |
861134 | 861134 | 2020-12-24 | Guanica | Puerto Rico | 72055 | 219 | |
857889 | 857889 | 2020-12-23 | Guanica | Puerto Rico | 72055 | 219 | |
854644 | 854644 | 2020-12-22 | Guanica | Puerto Rico | 72055 | 217 | |
851399 | 851399 | 2020-12-21 | Guanica | Puerto Rico | 72055 | 217 | |
848154 | 848154 | 2020-12-20 | Guanica | Puerto Rico | 72055 | 217 | |
844909 | 844909 | 2020-12-19 | Guanica | Puerto Rico | 72055 | 217 | |
841663 | 841663 | 2020-12-18 | Guanica | Puerto Rico | 72055 | 215 | |
838418 | 838418 | 2020-12-17 | Guanica | Puerto Rico | 72055 | 215 | |
835172 | 835172 | 2020-12-16 | Guanica | Puerto Rico | 72055 | 215 | |
831926 | 831926 | 2020-12-15 | Guanica | Puerto Rico | 72055 | 215 | |
828679 | 828679 | 2020-12-14 | Guanica | Puerto Rico | 72055 | 215 | |
825433 | 825433 | 2020-12-13 | Guanica | Puerto Rico | 72055 | 214 | |
822186 | 822186 | 2020-12-12 | Guanica | Puerto Rico | 72055 | 214 | |
818940 | 818940 | 2020-12-11 | Guanica | Puerto Rico | 72055 | 214 | |
815694 | 815694 | 2020-12-10 | Guanica | Puerto Rico | 72055 | 214 | |
812448 | 812448 | 2020-12-09 | Guanica | Puerto Rico | 72055 | 213 | |
809204 | 809204 | 2020-12-08 | Guanica | Puerto Rico | 72055 | 212 | |
805959 | 805959 | 2020-12-07 | Guanica | Puerto Rico | 72055 | 212 | |
802714 | 802714 | 2020-12-06 | Guanica | Puerto Rico | 72055 | 210 | |
799469 | 799469 | 2020-12-05 | Guanica | Puerto Rico | 72055 | 209 | |
796224 | 796224 | 2020-12-04 | Guanica | Puerto Rico | 72055 | 208 | |
792979 | 792979 | 2020-12-03 | Guanica | Puerto Rico | 72055 | 208 | |
789734 | 789734 | 2020-12-02 | Guanica | Puerto Rico | 72055 | 207 | |
786489 | 786489 | 2020-12-01 | Guanica | Puerto Rico | 72055 | 207 | |
783245 | 783245 | 2020-11-30 | Guanica | Puerto Rico | 72055 | 198 | |
780000 | 780000 | 2020-11-29 | Guanica | Puerto Rico | 72055 | 197 | |
776754 | 776754 | 2020-11-28 | Guanica | Puerto Rico | 72055 | 197 | |
773509 | 773509 | 2020-11-27 | Guanica | Puerto Rico | 72055 | 197 | |
770264 | 770264 | 2020-11-26 | Guanica | Puerto Rico | 72055 | 197 | |
767018 | 767018 | 2020-11-25 | Guanica | Puerto Rico | 72055 | 197 | |
763773 | 763773 | 2020-11-24 | Guanica | Puerto Rico | 72055 | 197 | |
760528 | 760528 | 2020-11-23 | Guanica | Puerto Rico | 72055 | 193 | |
757283 | 757283 | 2020-11-22 | Guanica | Puerto Rico | 72055 | 193 | |
754036 | 754036 | 2020-11-21 | Guanica | Puerto Rico | 72055 | 193 | |
750790 | 750790 | 2020-11-20 | Guanica | Puerto Rico | 72055 | 191 | |
747544 | 747544 | 2020-11-19 | Guanica | Puerto Rico | 72055 | 188 | |
744298 | 744298 | 2020-11-18 | Guanica | Puerto Rico | 72055 | 186 | |
741051 | 741051 | 2020-11-17 | Guanica | Puerto Rico | 72055 | 186 | |
737805 | 737805 | 2020-11-16 | Guanica | Puerto Rico | 72055 | 186 | |
734561 | 734561 | 2020-11-15 | Guanica | Puerto Rico | 72055 | 184 | |
731315 | 731315 | 2020-11-14 | Guanica | Puerto Rico | 72055 | 184 | |
728071 | 728071 | 2020-11-13 | Guanica | Puerto Rico | 72055 | 183 | |
724827 | 724827 | 2020-11-12 | Guanica | Puerto Rico | 72055 | 182 | |
721584 | 721584 | 2020-11-11 | Guanica | Puerto Rico | 72055 | 181 | |
718341 | 718341 | 2020-11-10 | Guanica | Puerto Rico | 72055 | 181 | |
715098 | 715098 | 2020-11-09 | Guanica | Puerto Rico | 72055 | 181 | |
711854 | 711854 | 2020-11-08 | Guanica | Puerto Rico | 72055 | 181 | |
708610 | 708610 | 2020-11-07 | Guanica | Puerto Rico | 72055 | 181 | |
705367 | 705367 | 2020-11-06 | Guanica | Puerto Rico | 72055 | 181 | |
702124 | 702124 | 2020-11-05 | Guanica | Puerto Rico | 72055 | 180 | |
698880 | 698880 | 2020-11-04 | Guanica | Puerto Rico | 72055 | 179 | |
695637 | 695637 | 2020-11-03 | Guanica | Puerto Rico | 72055 | 179 | |
692395 | 692395 | 2020-11-02 | Guanica | Puerto Rico | 72055 | 178 | |
689151 | 689151 | 2020-11-01 | Guanica | Puerto Rico | 72055 | 173 | |
685906 | 685906 | 2020-10-31 | Guanica | Puerto Rico | 72055 | 169 | |
682663 | 682663 | 2020-10-30 | Guanica | Puerto Rico | 72055 | 166 | |
679420 | 679420 | 2020-10-29 | Guanica | Puerto Rico | 72055 | 161 | |
676177 | 676177 | 2020-10-28 | Guanica | Puerto Rico | 72055 | 156 | |
672934 | 672934 | 2020-10-27 | Guanica | Puerto Rico | 72055 | 155 | |
669692 | 669692 | 2020-10-26 | Guanica | Puerto Rico | 72055 | 154 | |
666448 | 666448 | 2020-10-25 | Guanica | Puerto Rico | 72055 | 153 | |
663203 | 663203 | 2020-10-24 | Guanica | Puerto Rico | 72055 | 148 | |
659959 | 659959 | 2020-10-23 | Guanica | Puerto Rico | 72055 | 145 | |
656715 | 656715 | 2020-10-22 | Guanica | Puerto Rico | 72055 | 143 | |
653470 | 653470 | 2020-10-21 | Guanica | Puerto Rico | 72055 | 141 | |
650225 | 650225 | 2020-10-20 | Guanica | Puerto Rico | 72055 | 141 | |
646981 | 646981 | 2020-10-19 | Guanica | Puerto Rico | 72055 | 140 | |
643735 | 643735 | 2020-10-18 | Guanica | Puerto Rico | 72055 | 137 | |
640487 | 640487 | 2020-10-17 | Guanica | Puerto Rico | 72055 | 137 | |
637241 | 637241 | 2020-10-16 | Guanica | Puerto Rico | 72055 | 133 | |
633995 | 633995 | 2020-10-15 | Guanica | Puerto Rico | 72055 | 133 | |
630750 | 630750 | 2020-10-14 | Guanica | Puerto Rico | 72055 | 129 | |
627506 | 627506 | 2020-10-13 | Guanica | Puerto Rico | 72055 | 128 | |
624264 | 624264 | 2020-10-12 | Guanica | Puerto Rico | 72055 | 127 | |
621021 | 621021 | 2020-10-11 | Guanica | Puerto Rico | 72055 | 124 | |
617778 | 617778 | 2020-10-10 | Guanica | Puerto Rico | 72055 | 123 | |
614536 | 614536 | 2020-10-09 | Guanica | Puerto Rico | 72055 | 118 | |
611295 | 611295 | 2020-10-08 | Guanica | Puerto Rico | 72055 | 118 | |
608053 | 608053 | 2020-10-07 | Guanica | Puerto Rico | 72055 | 117 | |
604810 | 604810 | 2020-10-06 | Guanica | Puerto Rico | 72055 | 117 | |
601568 | 601568 | 2020-10-05 | Guanica | Puerto Rico | 72055 | 117 |
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);