ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-12-14" 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 |
---|---|---|---|---|---|---|---|
2013942 | 2013942 | 2021-12-14 | Adjuntas | Puerto Rico | 72001 | 722 | |
2013943 | 2013943 | 2021-12-14 | Aguada | Puerto Rico | 72003 | 2472 | |
2013944 | 2013944 | 2021-12-14 | Aguadilla | Puerto Rico | 72005 | 3119 | |
2013945 | 2013945 | 2021-12-14 | Aguas Buenas | Puerto Rico | 72007 | 1661 | |
2013946 | 2013946 | 2021-12-14 | Aibonito | Puerto Rico | 72009 | 1079 | |
2013947 | 2013947 | 2021-12-14 | Anasco | Puerto Rico | 72011 | 1440 | |
2013948 | 2013948 | 2021-12-14 | Arecibo | Puerto Rico | 72013 | 4724 | |
2013949 | 2013949 | 2021-12-14 | Arroyo | Puerto Rico | 72015 | 566 | |
2013950 | 2013950 | 2021-12-14 | Barceloneta | Puerto Rico | 72017 | 1218 | |
2013951 | 2013951 | 2021-12-14 | Barranquitas | Puerto Rico | 72019 | 1951 | |
2013952 | 2013952 | 2021-12-14 | Bayamon | Puerto Rico | 72021 | 16075 | |
2013953 | 2013953 | 2021-12-14 | Cabo Rojo | Puerto Rico | 72023 | 1951 | |
2013954 | 2013954 | 2021-12-14 | Caguas | Puerto Rico | 72025 | 9143 | |
2013955 | 2013955 | 2021-12-14 | Camuy | Puerto Rico | 72027 | 1819 | |
2013956 | 2013956 | 2021-12-14 | Canovanas | Puerto Rico | 72029 | 3131 | |
2013957 | 2013957 | 2021-12-14 | Carolina | Puerto Rico | 72031 | 13221 | |
2013958 | 2013958 | 2021-12-14 | Catano | Puerto Rico | 72033 | 1972 | |
2013959 | 2013959 | 2021-12-14 | Cayey | Puerto Rico | 72035 | 2095 | |
2013960 | 2013960 | 2021-12-14 | Ceiba | Puerto Rico | 72037 | 681 | |
2013961 | 2013961 | 2021-12-14 | Ciales | Puerto Rico | 72039 | 1113 | |
2013962 | 2013962 | 2021-12-14 | Cidra | Puerto Rico | 72041 | 1981 | |
2013963 | 2013963 | 2021-12-14 | Coamo | Puerto Rico | 72043 | 1459 | |
2013964 | 2013964 | 2021-12-14 | Comerio | Puerto Rico | 72045 | 1087 | |
2013965 | 2013965 | 2021-12-14 | Corozal | Puerto Rico | 72047 | 2529 | |
2013966 | 2013966 | 2021-12-14 | Culebra | Puerto Rico | 72049 | 57 | |
2013967 | 2013967 | 2021-12-14 | Dorado | Puerto Rico | 72051 | 3422 | |
2013968 | 2013968 | 2021-12-14 | Fajardo | Puerto Rico | 72053 | 2225 | |
2013969 | 2013969 | 2021-12-14 | Florida | Puerto Rico | 72054 | 1010 | |
2013970 | 2013970 | 2021-12-14 | Guanica | Puerto Rico | 72055 | 461 | |
2013971 | 2013971 | 2021-12-14 | Guayama | Puerto Rico | 72057 | 1434 | |
2013972 | 2013972 | 2021-12-14 | Guayanilla | Puerto Rico | 72059 | 715 | |
2013973 | 2013973 | 2021-12-14 | Guaynabo | Puerto Rico | 72061 | 6975 | |
2013974 | 2013974 | 2021-12-14 | Gurabo | Puerto Rico | 72063 | 3158 | |
2013975 | 2013975 | 2021-12-14 | Hatillo | Puerto Rico | 72065 | 1943 | |
2013976 | 2013976 | 2021-12-14 | Hormigueros | Puerto Rico | 72067 | 714 | |
2013977 | 2013977 | 2021-12-14 | Humacao | Puerto Rico | 72069 | 3174 | |
2013978 | 2013978 | 2021-12-14 | Isabela | Puerto Rico | 72071 | 2595 | |
2013979 | 2013979 | 2021-12-14 | Jayuya | Puerto Rico | 72073 | 661 | |
2013980 | 2013980 | 2021-12-14 | Juana Diaz | Puerto Rico | 72075 | 1800 | |
2013981 | 2013981 | 2021-12-14 | Juncos | Puerto Rico | 72077 | 3057 | |
2013982 | 2013982 | 2021-12-14 | Lajas | Puerto Rico | 72079 | 842 | |
2013983 | 2013983 | 2021-12-14 | Lares | Puerto Rico | 72081 | 1425 | |
2013984 | 2013984 | 2021-12-14 | Las Marias | Puerto Rico | 72083 | 405 | |
2013985 | 2013985 | 2021-12-14 | Las Piedras | Puerto Rico | 72085 | 2333 | |
2013986 | 2013986 | 2021-12-14 | Loiza | Puerto Rico | 72087 | 1776 | |
2013987 | 2013987 | 2021-12-14 | Luquillo | Puerto Rico | 72089 | 1276 | |
2013988 | 2013988 | 2021-12-14 | Manati | Puerto Rico | 72091 | 2440 | |
2013989 | 2013989 | 2021-12-14 | Maricao | Puerto Rico | 72093 | 183 | |
2013990 | 2013990 | 2021-12-14 | Maunabo | Puerto Rico | 72095 | 576 | |
2013991 | 2013991 | 2021-12-14 | Mayaguez | Puerto Rico | 72097 | 4047 | |
2013992 | 2013992 | 2021-12-14 | Moca | Puerto Rico | 72099 | 2461 | |
2013993 | 2013993 | 2021-12-14 | Morovis | Puerto Rico | 72101 | 2016 | |
2013994 | 2013994 | 2021-12-14 | Naguabo | Puerto Rico | 72103 | 1518 | |
2013995 | 2013995 | 2021-12-14 | Naranjito | Puerto Rico | 72105 | 2428 | |
2013996 | 2013996 | 2021-12-14 | Orocovis | Puerto Rico | 72107 | 1250 | |
2013997 | 2013997 | 2021-12-14 | Patillas | Puerto Rico | 72109 | 580 | |
2013998 | 2013998 | 2021-12-14 | Penuelas | Puerto Rico | 72111 | 817 | |
2013999 | 2013999 | 2021-12-14 | Ponce | Puerto Rico | 72113 | 5797 | |
2014000 | 2014000 | 2021-12-14 | Quebradillas | Puerto Rico | 72115 | 1390 | |
2014001 | 2014001 | 2021-12-14 | Rincon | Puerto Rico | 72117 | 935 | |
2014002 | 2014002 | 2021-12-14 | Rio Grande | Puerto Rico | 72119 | 3351 | |
2014003 | 2014003 | 2021-12-14 | Sabana Grande | Puerto Rico | 72121 | 787 | |
2014004 | 2014004 | 2021-12-14 | Salinas | Puerto Rico | 72123 | 1471 | |
2014005 | 2014005 | 2021-12-14 | San German | Puerto Rico | 72125 | 1174 | |
2014006 | 2014006 | 2021-12-14 | San Juan | Puerto Rico | 72127 | 29628 | |
2014007 | 2014007 | 2021-12-14 | San Lorenzo | Puerto Rico | 72129 | 2484 | |
2014008 | 2014008 | 2021-12-14 | San Sebastian | Puerto Rico | 72131 | 2566 | |
2014009 | 2014009 | 2021-12-14 | Santa Isabel | Puerto Rico | 72133 | 886 | |
2014010 | 2014010 | 2021-12-14 | Toa Alta | Puerto Rico | 72135 | 5858 | |
2014011 | 2014011 | 2021-12-14 | Toa Baja | Puerto Rico | 72137 | 6220 | |
2014012 | 2014012 | 2021-12-14 | Trujillo Alto | Puerto Rico | 72139 | 4618 | |
2014013 | 2014013 | 2021-12-14 | Unknown | Puerto Rico | 5797 | 3276 | |
2014014 | 2014014 | 2021-12-14 | Utuado | Puerto Rico | 72141 | 1387 | |
2014015 | 2014015 | 2021-12-14 | Vega Alta | Puerto Rico | 72143 | 2959 | |
2014016 | 2014016 | 2021-12-14 | Vega Baja | Puerto Rico | 72145 | 4526 | |
2014017 | 2014017 | 2021-12-14 | Vieques | Puerto Rico | 72147 | 292 | |
2014018 | 2014018 | 2021-12-14 | Villalba | Puerto Rico | 72149 | 1050 | |
2014019 | 2014019 | 2021-12-14 | Yabucoa | Puerto Rico | 72151 | 1659 | |
2014020 | 2014020 | 2021-12-14 | Yauco | Puerto Rico | 72153 | 1498 |
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);