ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-09-04" 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 |
---|---|---|---|---|---|---|---|
501161 | 501161 | 2020-09-04 | Adjuntas | Puerto Rico | 72001 | 127 | |
501162 | 501162 | 2020-09-04 | Aguada | Puerto Rico | 72003 | 229 | |
501163 | 501163 | 2020-09-04 | Aguadilla | Puerto Rico | 72005 | 329 | |
501164 | 501164 | 2020-09-04 | Aguas Buenas | Puerto Rico | 72007 | 204 | |
501165 | 501165 | 2020-09-04 | Aibonito | Puerto Rico | 72009 | 125 | |
501166 | 501166 | 2020-09-04 | Anasco | Puerto Rico | 72011 | 193 | |
501167 | 501167 | 2020-09-04 | Arecibo | Puerto Rico | 72013 | 529 | |
501168 | 501168 | 2020-09-04 | Arroyo | Puerto Rico | 72015 | 129 | |
501169 | 501169 | 2020-09-04 | Barceloneta | Puerto Rico | 72017 | 129 | |
501170 | 501170 | 2020-09-04 | Barranquitas | Puerto Rico | 72019 | 347 | |
501171 | 501171 | 2020-09-04 | Bayamon | Puerto Rico | 72021 | 2677 | |
501172 | 501172 | 2020-09-04 | Cabo Rojo | Puerto Rico | 72023 | 278 | |
501173 | 501173 | 2020-09-04 | Caguas | Puerto Rico | 72025 | 1136 | |
501174 | 501174 | 2020-09-04 | Camuy | Puerto Rico | 72027 | 196 | |
501175 | 501175 | 2020-09-04 | Canovanas | Puerto Rico | 72029 | 529 | |
501176 | 501176 | 2020-09-04 | Carolina | Puerto Rico | 72031 | 1965 | |
501177 | 501177 | 2020-09-04 | Catano | Puerto Rico | 72033 | 312 | |
501178 | 501178 | 2020-09-04 | Cayey | Puerto Rico | 72035 | 271 | |
501179 | 501179 | 2020-09-04 | Ceiba | Puerto Rico | 72037 | 90 | |
501180 | 501180 | 2020-09-04 | Ciales | Puerto Rico | 72039 | 192 | |
501181 | 501181 | 2020-09-04 | Cidra | Puerto Rico | 72041 | 241 | |
501182 | 501182 | 2020-09-04 | Coamo | Puerto Rico | 72043 | 215 | |
501183 | 501183 | 2020-09-04 | Comerio | Puerto Rico | 72045 | 173 | |
501184 | 501184 | 2020-09-04 | Corozal | Puerto Rico | 72047 | 422 | |
501185 | 501185 | 2020-09-04 | Culebra | Puerto Rico | 72049 | 21 | |
501186 | 501186 | 2020-09-04 | Dorado | Puerto Rico | 72051 | 538 | |
501187 | 501187 | 2020-09-04 | Fajardo | Puerto Rico | 72053 | 364 | |
501188 | 501188 | 2020-09-04 | Florida | Puerto Rico | 72054 | 211 | |
501189 | 501189 | 2020-09-04 | Guanica | Puerto Rico | 72055 | 84 | |
501190 | 501190 | 2020-09-04 | Guayama | Puerto Rico | 72057 | 236 | |
501191 | 501191 | 2020-09-04 | Guayanilla | Puerto Rico | 72059 | 147 | |
501192 | 501192 | 2020-09-04 | Guaynabo | Puerto Rico | 72061 | 1314 | |
501193 | 501193 | 2020-09-04 | Gurabo | Puerto Rico | 72063 | 372 | |
501194 | 501194 | 2020-09-04 | Hatillo | Puerto Rico | 72065 | 198 | |
501195 | 501195 | 2020-09-04 | Hormigueros | Puerto Rico | 72067 | 128 | |
501196 | 501196 | 2020-09-04 | Humacao | Puerto Rico | 72069 | 319 | |
501197 | 501197 | 2020-09-04 | Isabela | Puerto Rico | 72071 | 212 | |
501198 | 501198 | 2020-09-04 | Jayuya | Puerto Rico | 72073 | 207 | |
501199 | 501199 | 2020-09-04 | Juana Diaz | Puerto Rico | 72075 | 272 | |
501200 | 501200 | 2020-09-04 | Juncos | Puerto Rico | 72077 | 254 | |
501201 | 501201 | 2020-09-04 | Lajas | Puerto Rico | 72079 | 118 | |
501202 | 501202 | 2020-09-04 | Lares | Puerto Rico | 72081 | 251 | |
501203 | 501203 | 2020-09-04 | Las Marias | Puerto Rico | 72083 | 81 | |
501204 | 501204 | 2020-09-04 | Las Piedras | Puerto Rico | 72085 | 303 | |
501205 | 501205 | 2020-09-04 | Loiza | Puerto Rico | 72087 | 192 | |
501206 | 501206 | 2020-09-04 | Luquillo | Puerto Rico | 72089 | 178 | |
501207 | 501207 | 2020-09-04 | Manati | Puerto Rico | 72091 | 373 | |
501208 | 501208 | 2020-09-04 | Maricao | Puerto Rico | 72093 | 63 | |
501209 | 501209 | 2020-09-04 | Maunabo | Puerto Rico | 72095 | 89 | |
501210 | 501210 | 2020-09-04 | Mayaguez | Puerto Rico | 72097 | 664 | |
501211 | 501211 | 2020-09-04 | Moca | Puerto Rico | 72099 | 259 | |
501212 | 501212 | 2020-09-04 | Morovis | Puerto Rico | 72101 | 412 | |
501213 | 501213 | 2020-09-04 | Naguabo | Puerto Rico | 72103 | 142 | |
501214 | 501214 | 2020-09-04 | Naranjito | Puerto Rico | 72105 | 487 | |
501215 | 501215 | 2020-09-04 | Orocovis | Puerto Rico | 72107 | 276 | |
501216 | 501216 | 2020-09-04 | Patillas | Puerto Rico | 72109 | 137 | |
501217 | 501217 | 2020-09-04 | Penuelas | Puerto Rico | 72111 | 99 | |
501218 | 501218 | 2020-09-04 | Ponce | Puerto Rico | 72113 | 668 | |
501219 | 501219 | 2020-09-04 | Quebradillas | Puerto Rico | 72115 | 118 | |
501220 | 501220 | 2020-09-04 | Rincon | Puerto Rico | 72117 | 129 | |
501221 | 501221 | 2020-09-04 | Rio Grande | Puerto Rico | 72119 | 446 | |
501222 | 501222 | 2020-09-04 | Sabana Grande | Puerto Rico | 72121 | 166 | |
501223 | 501223 | 2020-09-04 | Salinas | Puerto Rico | 72123 | 318 | |
501224 | 501224 | 2020-09-04 | San German | Puerto Rico | 72125 | 198 | |
501225 | 501225 | 2020-09-04 | San Juan | Puerto Rico | 72127 | 5528 | |
501226 | 501226 | 2020-09-04 | San Lorenzo | Puerto Rico | 72129 | 287 | |
501227 | 501227 | 2020-09-04 | San Sebastian | Puerto Rico | 72131 | 281 | |
501228 | 501228 | 2020-09-04 | Santa Isabel | Puerto Rico | 72133 | 135 | |
501229 | 501229 | 2020-09-04 | Toa Alta | Puerto Rico | 72135 | 956 | |
501230 | 501230 | 2020-09-04 | Toa Baja | Puerto Rico | 72137 | 935 | |
501231 | 501231 | 2020-09-04 | Trujillo Alto | Puerto Rico | 72139 | 766 | |
501232 | 501232 | 2020-09-04 | Unknown | Puerto Rico | 1283 | 455 | |
501233 | 501233 | 2020-09-04 | Utuado | Puerto Rico | 72141 | 104 | |
501234 | 501234 | 2020-09-04 | Vega Alta | Puerto Rico | 72143 | 487 | |
501235 | 501235 | 2020-09-04 | Vega Baja | Puerto Rico | 72145 | 678 | |
501236 | 501236 | 2020-09-04 | Vieques | Puerto Rico | 72147 | 84 | |
501237 | 501237 | 2020-09-04 | Villalba | Puerto Rico | 72149 | 98 | |
501238 | 501238 | 2020-09-04 | Yabucoa | Puerto Rico | 72151 | 216 | |
501239 | 501239 | 2020-09-04 | Yauco | Puerto Rico | 72153 | 321 |
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);