ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-12-07" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Adjuntas 1
- Aguada 1
- Aguadilla 1
- Aguas Buenas 1
- Aibonito 1
- Anasco 1
- Arecibo 1
- Arroyo 1
- Barceloneta 1
- Barranquitas 1
- Bayamon 1
- Cabo Rojo 1
- Caguas 1
- Camuy 1
- Canovanas 1
- Carolina 1
- Catano 1
- Cayey 1
- Ceiba 1
- Ciales 1
- Cidra 1
- Coamo 1
- Comerio 1
- Corozal 1
- Culebra 1
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- …
state 1
- Puerto Rico · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
805931 | 805931 | 2020-12-07 | Adjuntas | Puerto Rico | 72001 | 258 | |
805932 | 805932 | 2020-12-07 | Aguada | Puerto Rico | 72003 | 721 | |
805933 | 805933 | 2020-12-07 | Aguadilla | Puerto Rico | 72005 | 926 | |
805934 | 805934 | 2020-12-07 | Aguas Buenas | Puerto Rico | 72007 | 550 | |
805935 | 805935 | 2020-12-07 | Aibonito | Puerto Rico | 72009 | 339 | |
805936 | 805936 | 2020-12-07 | Anasco | Puerto Rico | 72011 | 525 | |
805937 | 805937 | 2020-12-07 | Arecibo | Puerto Rico | 72013 | 1767 | |
805938 | 805938 | 2020-12-07 | Arroyo | Puerto Rico | 72015 | 258 | |
805939 | 805939 | 2020-12-07 | Barceloneta | Puerto Rico | 72017 | 494 | |
805940 | 805940 | 2020-12-07 | Barranquitas | Puerto Rico | 72019 | 882 | |
805941 | 805941 | 2020-12-07 | Bayamon | Puerto Rico | 72021 | 6687 | |
805942 | 805942 | 2020-12-07 | Cabo Rojo | Puerto Rico | 72023 | 669 | |
805943 | 805943 | 2020-12-07 | Caguas | Puerto Rico | 72025 | 3555 | |
805944 | 805944 | 2020-12-07 | Camuy | Puerto Rico | 72027 | 748 | |
805945 | 805945 | 2020-12-07 | Canovanas | Puerto Rico | 72029 | 1243 | |
805946 | 805946 | 2020-12-07 | Carolina | Puerto Rico | 72031 | 5572 | |
805947 | 805947 | 2020-12-07 | Catano | Puerto Rico | 72033 | 840 | |
805948 | 805948 | 2020-12-07 | Cayey | Puerto Rico | 72035 | 849 | |
805949 | 805949 | 2020-12-07 | Ceiba | Puerto Rico | 72037 | 247 | |
805950 | 805950 | 2020-12-07 | Ciales | Puerto Rico | 72039 | 536 | |
805951 | 805951 | 2020-12-07 | Cidra | Puerto Rico | 72041 | 703 | |
805952 | 805952 | 2020-12-07 | Coamo | Puerto Rico | 72043 | 587 | |
805953 | 805953 | 2020-12-07 | Comerio | Puerto Rico | 72045 | 464 | |
805954 | 805954 | 2020-12-07 | Corozal | Puerto Rico | 72047 | 1219 | |
805955 | 805955 | 2020-12-07 | Culebra | Puerto Rico | 72049 | 25 | |
805956 | 805956 | 2020-12-07 | Dorado | Puerto Rico | 72051 | 1530 | |
805957 | 805957 | 2020-12-07 | Fajardo | Puerto Rico | 72053 | 874 | |
805958 | 805958 | 2020-12-07 | Florida | Puerto Rico | 72054 | 533 | |
805959 | 805959 | 2020-12-07 | Guanica | Puerto Rico | 72055 | 212 | |
805960 | 805960 | 2020-12-07 | Guayama | Puerto Rico | 72057 | 576 | |
805961 | 805961 | 2020-12-07 | Guayanilla | Puerto Rico | 72059 | 325 | |
805962 | 805962 | 2020-12-07 | Guaynabo | Puerto Rico | 72061 | 3142 | |
805963 | 805963 | 2020-12-07 | Gurabo | Puerto Rico | 72063 | 1148 | |
805964 | 805964 | 2020-12-07 | Hatillo | Puerto Rico | 72065 | 687 | |
805965 | 805965 | 2020-12-07 | Hormigueros | Puerto Rico | 72067 | 296 | |
805966 | 805966 | 2020-12-07 | Humacao | Puerto Rico | 72069 | 1049 | |
805967 | 805967 | 2020-12-07 | Isabela | Puerto Rico | 72071 | 678 | |
805968 | 805968 | 2020-12-07 | Jayuya | Puerto Rico | 72073 | 360 | |
805969 | 805969 | 2020-12-07 | Juana Diaz | Puerto Rico | 72075 | 690 | |
805970 | 805970 | 2020-12-07 | Juncos | Puerto Rico | 72077 | 911 | |
805971 | 805971 | 2020-12-07 | Lajas | Puerto Rico | 72079 | 273 | |
805972 | 805972 | 2020-12-07 | Lares | Puerto Rico | 72081 | 643 | |
805973 | 805973 | 2020-12-07 | Las Marias | Puerto Rico | 72083 | 162 | |
805974 | 805974 | 2020-12-07 | Las Piedras | Puerto Rico | 72085 | 863 | |
805975 | 805975 | 2020-12-07 | Loiza | Puerto Rico | 72087 | 566 | |
805976 | 805976 | 2020-12-07 | Luquillo | Puerto Rico | 72089 | 413 | |
805977 | 805977 | 2020-12-07 | Manati | Puerto Rico | 72091 | 1071 | |
805978 | 805978 | 2020-12-07 | Maricao | Puerto Rico | 72093 | 100 | |
805979 | 805979 | 2020-12-07 | Maunabo | Puerto Rico | 72095 | 226 | |
805980 | 805980 | 2020-12-07 | Mayaguez | Puerto Rico | 72097 | 1352 | |
805981 | 805981 | 2020-12-07 | Moca | Puerto Rico | 72099 | 840 | |
805982 | 805982 | 2020-12-07 | Morovis | Puerto Rico | 72101 | 892 | |
805983 | 805983 | 2020-12-07 | Naguabo | Puerto Rico | 72103 | 508 | |
805984 | 805984 | 2020-12-07 | Naranjito | Puerto Rico | 72105 | 1130 | |
805985 | 805985 | 2020-12-07 | Orocovis | Puerto Rico | 72107 | 567 | |
805986 | 805986 | 2020-12-07 | Patillas | Puerto Rico | 72109 | 274 | |
805987 | 805987 | 2020-12-07 | Penuelas | Puerto Rico | 72111 | 319 | |
805988 | 805988 | 2020-12-07 | Ponce | Puerto Rico | 72113 | 1838 | |
805989 | 805989 | 2020-12-07 | Quebradillas | Puerto Rico | 72115 | 432 | |
805990 | 805990 | 2020-12-07 | Rincon | Puerto Rico | 72117 | 306 | |
805991 | 805991 | 2020-12-07 | Rio Grande | Puerto Rico | 72119 | 1132 | |
805992 | 805992 | 2020-12-07 | Sabana Grande | Puerto Rico | 72121 | 283 | |
805993 | 805993 | 2020-12-07 | Salinas | Puerto Rico | 72123 | 763 | |
805994 | 805994 | 2020-12-07 | San German | Puerto Rico | 72125 | 414 | |
805995 | 805995 | 2020-12-07 | San Juan | Puerto Rico | 72127 | 13413 | |
805996 | 805996 | 2020-12-07 | San Lorenzo | Puerto Rico | 72129 | 981 | |
805997 | 805997 | 2020-12-07 | San Sebastian | Puerto Rico | 72131 | 1246 | |
805998 | 805998 | 2020-12-07 | Santa Isabel | Puerto Rico | 72133 | 392 | |
805999 | 805999 | 2020-12-07 | Toa Alta | Puerto Rico | 72135 | 2566 | |
806000 | 806000 | 2020-12-07 | Toa Baja | Puerto Rico | 72137 | 2762 | |
806001 | 806001 | 2020-12-07 | Trujillo Alto | Puerto Rico | 72139 | 2104 | |
806002 | 806002 | 2020-12-07 | Unknown | Puerto Rico | 3058 | 1202 | |
806003 | 806003 | 2020-12-07 | Utuado | Puerto Rico | 72141 | 516 | |
806004 | 806004 | 2020-12-07 | Vega Alta | Puerto Rico | 72143 | 1357 | |
806005 | 806005 | 2020-12-07 | Vega Baja | Puerto Rico | 72145 | 1794 | |
806006 | 806006 | 2020-12-07 | Vieques | Puerto Rico | 72147 | 111 | |
806007 | 806007 | 2020-12-07 | Villalba | Puerto Rico | 72149 | 506 | |
806008 | 806008 | 2020-12-07 | Yabucoa | Puerto Rico | 72151 | 607 | |
806009 | 806009 | 2020-12-07 | Yauco | Puerto Rico | 72153 | 782 |
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);