ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-07-25" 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 |
---|---|---|---|---|---|---|---|
368951 | 368951 | 2020-07-25 | Adjuntas | Puerto Rico | 72001 | 74 | |
368952 | 368952 | 2020-07-25 | Aguada | Puerto Rico | 72003 | 89 | |
368953 | 368953 | 2020-07-25 | Aguadilla | Puerto Rico | 72005 | 142 | |
368954 | 368954 | 2020-07-25 | Aguas Buenas | Puerto Rico | 72007 | 91 | |
368955 | 368955 | 2020-07-25 | Aibonito | Puerto Rico | 72009 | 67 | |
368956 | 368956 | 2020-07-25 | Anasco | Puerto Rico | 72011 | 99 | |
368957 | 368957 | 2020-07-25 | Arecibo | Puerto Rico | 72013 | 224 | |
368958 | 368958 | 2020-07-25 | Arroyo | Puerto Rico | 72015 | 68 | |
368959 | 368959 | 2020-07-25 | Barceloneta | Puerto Rico | 72017 | 51 | |
368960 | 368960 | 2020-07-25 | Barranquitas | Puerto Rico | 72019 | 154 | |
368961 | 368961 | 2020-07-25 | Bayamon | Puerto Rico | 72021 | 912 | |
368962 | 368962 | 2020-07-25 | Cabo Rojo | Puerto Rico | 72023 | 152 | |
368963 | 368963 | 2020-07-25 | Caguas | Puerto Rico | 72025 | 486 | |
368964 | 368964 | 2020-07-25 | Camuy | Puerto Rico | 72027 | 78 | |
368965 | 368965 | 2020-07-25 | Canovanas | Puerto Rico | 72029 | 247 | |
368966 | 368966 | 2020-07-25 | Carolina | Puerto Rico | 72031 | 740 | |
368967 | 368967 | 2020-07-25 | Catano | Puerto Rico | 72033 | 119 | |
368968 | 368968 | 2020-07-25 | Cayey | Puerto Rico | 72035 | 152 | |
368969 | 368969 | 2020-07-25 | Ceiba | Puerto Rico | 72037 | 48 | |
368970 | 368970 | 2020-07-25 | Ciales | Puerto Rico | 72039 | 102 | |
368971 | 368971 | 2020-07-25 | Cidra | Puerto Rico | 72041 | 119 | |
368972 | 368972 | 2020-07-25 | Coamo | Puerto Rico | 72043 | 89 | |
368973 | 368973 | 2020-07-25 | Comerio | Puerto Rico | 72045 | 92 | |
368974 | 368974 | 2020-07-25 | Corozal | Puerto Rico | 72047 | 107 | |
368975 | 368975 | 2020-07-25 | Culebra | Puerto Rico | 72049 | 14 | |
368976 | 368976 | 2020-07-25 | Dorado | Puerto Rico | 72051 | 203 | |
368977 | 368977 | 2020-07-25 | Fajardo | Puerto Rico | 72053 | 154 | |
368978 | 368978 | 2020-07-25 | Florida | Puerto Rico | 72054 | 103 | |
368979 | 368979 | 2020-07-25 | Guanica | Puerto Rico | 72055 | 52 | |
368980 | 368980 | 2020-07-25 | Guayama | Puerto Rico | 72057 | 114 | |
368981 | 368981 | 2020-07-25 | Guayanilla | Puerto Rico | 72059 | 97 | |
368982 | 368982 | 2020-07-25 | Guaynabo | Puerto Rico | 72061 | 605 | |
368983 | 368983 | 2020-07-25 | Gurabo | Puerto Rico | 72063 | 172 | |
368984 | 368984 | 2020-07-25 | Hatillo | Puerto Rico | 72065 | 72 | |
368985 | 368985 | 2020-07-25 | Hormigueros | Puerto Rico | 72067 | 73 | |
368986 | 368986 | 2020-07-25 | Humacao | Puerto Rico | 72069 | 136 | |
368987 | 368987 | 2020-07-25 | Isabela | Puerto Rico | 72071 | 97 | |
368988 | 368988 | 2020-07-25 | Jayuya | Puerto Rico | 72073 | 172 | |
368989 | 368989 | 2020-07-25 | Juana Diaz | Puerto Rico | 72075 | 152 | |
368990 | 368990 | 2020-07-25 | Juncos | Puerto Rico | 72077 | 83 | |
368991 | 368991 | 2020-07-25 | Lajas | Puerto Rico | 72079 | 63 | |
368992 | 368992 | 2020-07-25 | Lares | Puerto Rico | 72081 | 111 | |
368993 | 368993 | 2020-07-25 | Las Marias | Puerto Rico | 72083 | 42 | |
368994 | 368994 | 2020-07-25 | Las Piedras | Puerto Rico | 72085 | 116 | |
368995 | 368995 | 2020-07-25 | Loiza | Puerto Rico | 72087 | 69 | |
368996 | 368996 | 2020-07-25 | Luquillo | Puerto Rico | 72089 | 81 | |
368997 | 368997 | 2020-07-25 | Manati | Puerto Rico | 72091 | 134 | |
368998 | 368998 | 2020-07-25 | Maricao | Puerto Rico | 72093 | 38 | |
368999 | 368999 | 2020-07-25 | Maunabo | Puerto Rico | 72095 | 44 | |
369000 | 369000 | 2020-07-25 | Mayaguez | Puerto Rico | 72097 | 370 | |
369001 | 369001 | 2020-07-25 | Moca | Puerto Rico | 72099 | 122 | |
369002 | 369002 | 2020-07-25 | Morovis | Puerto Rico | 72101 | 161 | |
369003 | 369003 | 2020-07-25 | Naguabo | Puerto Rico | 72103 | 69 | |
369004 | 369004 | 2020-07-25 | Naranjito | Puerto Rico | 72105 | 151 | |
369005 | 369005 | 2020-07-25 | Orocovis | Puerto Rico | 72107 | 143 | |
369006 | 369006 | 2020-07-25 | Patillas | Puerto Rico | 72109 | 85 | |
369007 | 369007 | 2020-07-25 | Penuelas | Puerto Rico | 72111 | 50 | |
369008 | 369008 | 2020-07-25 | Ponce | Puerto Rico | 72113 | 360 | |
369009 | 369009 | 2020-07-25 | Quebradillas | Puerto Rico | 72115 | 56 | |
369010 | 369010 | 2020-07-25 | Rincon | Puerto Rico | 72117 | 76 | |
369011 | 369011 | 2020-07-25 | Rio Grande | Puerto Rico | 72119 | 190 | |
369012 | 369012 | 2020-07-25 | Sabana Grande | Puerto Rico | 72121 | 98 | |
369013 | 369013 | 2020-07-25 | Salinas | Puerto Rico | 72123 | 129 | |
369014 | 369014 | 2020-07-25 | San German | Puerto Rico | 72125 | 116 | |
369015 | 369015 | 2020-07-25 | San Juan | Puerto Rico | 72127 | 1923 | |
369016 | 369016 | 2020-07-25 | San Lorenzo | Puerto Rico | 72129 | 110 | |
369017 | 369017 | 2020-07-25 | San Sebastian | Puerto Rico | 72131 | 151 | |
369018 | 369018 | 2020-07-25 | Santa Isabel | Puerto Rico | 72133 | 78 | |
369019 | 369019 | 2020-07-25 | Toa Alta | Puerto Rico | 72135 | 335 | |
369020 | 369020 | 2020-07-25 | Toa Baja | Puerto Rico | 72137 | 316 | |
369021 | 369021 | 2020-07-25 | Trujillo Alto | Puerto Rico | 72139 | 324 | |
369022 | 369022 | 2020-07-25 | Unknown | Puerto Rico | 833 | 201 | |
369023 | 369023 | 2020-07-25 | Utuado | Puerto Rico | 72141 | 51 | |
369024 | 369024 | 2020-07-25 | Vega Alta | Puerto Rico | 72143 | 145 | |
369025 | 369025 | 2020-07-25 | Vega Baja | Puerto Rico | 72145 | 250 | |
369026 | 369026 | 2020-07-25 | Vieques | Puerto Rico | 72147 | 31 | |
369027 | 369027 | 2020-07-25 | Villalba | Puerto Rico | 72149 | 69 | |
369028 | 369028 | 2020-07-25 | Yabucoa | Puerto Rico | 72151 | 74 | |
369029 | 369029 | 2020-07-25 | Yauco | Puerto Rico | 72153 | 175 |
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);