ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-08-27" 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 |
---|---|---|---|---|---|---|---|
475292 | 475292 | 2020-08-27 | Adjuntas | Puerto Rico | 72001 | 119 | |
475293 | 475293 | 2020-08-27 | Aguada | Puerto Rico | 72003 | 202 | |
475294 | 475294 | 2020-08-27 | Aguadilla | Puerto Rico | 72005 | 298 | |
475295 | 475295 | 2020-08-27 | Aguas Buenas | Puerto Rico | 72007 | 188 | |
475296 | 475296 | 2020-08-27 | Aibonito | Puerto Rico | 72009 | 119 | |
475297 | 475297 | 2020-08-27 | Anasco | Puerto Rico | 72011 | 182 | |
475298 | 475298 | 2020-08-27 | Arecibo | Puerto Rico | 72013 | 477 | |
475299 | 475299 | 2020-08-27 | Arroyo | Puerto Rico | 72015 | 119 | |
475300 | 475300 | 2020-08-27 | Barceloneta | Puerto Rico | 72017 | 119 | |
475301 | 475301 | 2020-08-27 | Barranquitas | Puerto Rico | 72019 | 323 | |
475302 | 475302 | 2020-08-27 | Bayamon | Puerto Rico | 72021 | 2384 | |
475303 | 475303 | 2020-08-27 | Cabo Rojo | Puerto Rico | 72023 | 268 | |
475304 | 475304 | 2020-08-27 | Caguas | Puerto Rico | 72025 | 1044 | |
475305 | 475305 | 2020-08-27 | Camuy | Puerto Rico | 72027 | 188 | |
475306 | 475306 | 2020-08-27 | Canovanas | Puerto Rico | 72029 | 489 | |
475307 | 475307 | 2020-08-27 | Carolina | Puerto Rico | 72031 | 1766 | |
475308 | 475308 | 2020-08-27 | Catano | Puerto Rico | 72033 | 281 | |
475309 | 475309 | 2020-08-27 | Cayey | Puerto Rico | 72035 | 251 | |
475310 | 475310 | 2020-08-27 | Ceiba | Puerto Rico | 72037 | 82 | |
475311 | 475311 | 2020-08-27 | Ciales | Puerto Rico | 72039 | 186 | |
475312 | 475312 | 2020-08-27 | Cidra | Puerto Rico | 72041 | 235 | |
475313 | 475313 | 2020-08-27 | Coamo | Puerto Rico | 72043 | 199 | |
475314 | 475314 | 2020-08-27 | Comerio | Puerto Rico | 72045 | 164 | |
475315 | 475315 | 2020-08-27 | Corozal | Puerto Rico | 72047 | 376 | |
475316 | 475316 | 2020-08-27 | Culebra | Puerto Rico | 72049 | 20 | |
475317 | 475317 | 2020-08-27 | Dorado | Puerto Rico | 72051 | 455 | |
475318 | 475318 | 2020-08-27 | Fajardo | Puerto Rico | 72053 | 334 | |
475319 | 475319 | 2020-08-27 | Florida | Puerto Rico | 72054 | 204 | |
475320 | 475320 | 2020-08-27 | Guanica | Puerto Rico | 72055 | 78 | |
475321 | 475321 | 2020-08-27 | Guayama | Puerto Rico | 72057 | 214 | |
475322 | 475322 | 2020-08-27 | Guayanilla | Puerto Rico | 72059 | 142 | |
475323 | 475323 | 2020-08-27 | Guaynabo | Puerto Rico | 72061 | 1203 | |
475324 | 475324 | 2020-08-27 | Gurabo | Puerto Rico | 72063 | 346 | |
475325 | 475325 | 2020-08-27 | Hatillo | Puerto Rico | 72065 | 183 | |
475326 | 475326 | 2020-08-27 | Hormigueros | Puerto Rico | 72067 | 118 | |
475327 | 475327 | 2020-08-27 | Humacao | Puerto Rico | 72069 | 286 | |
475328 | 475328 | 2020-08-27 | Isabela | Puerto Rico | 72071 | 191 | |
475329 | 475329 | 2020-08-27 | Jayuya | Puerto Rico | 72073 | 198 | |
475330 | 475330 | 2020-08-27 | Juana Diaz | Puerto Rico | 72075 | 247 | |
475331 | 475331 | 2020-08-27 | Juncos | Puerto Rico | 72077 | 225 | |
475332 | 475332 | 2020-08-27 | Lajas | Puerto Rico | 72079 | 109 | |
475333 | 475333 | 2020-08-27 | Lares | Puerto Rico | 72081 | 234 | |
475334 | 475334 | 2020-08-27 | Las Marias | Puerto Rico | 72083 | 80 | |
475335 | 475335 | 2020-08-27 | Las Piedras | Puerto Rico | 72085 | 256 | |
475336 | 475336 | 2020-08-27 | Loiza | Puerto Rico | 72087 | 176 | |
475337 | 475337 | 2020-08-27 | Luquillo | Puerto Rico | 72089 | 169 | |
475338 | 475338 | 2020-08-27 | Manati | Puerto Rico | 72091 | 343 | |
475339 | 475339 | 2020-08-27 | Maricao | Puerto Rico | 72093 | 50 | |
475340 | 475340 | 2020-08-27 | Maunabo | Puerto Rico | 72095 | 82 | |
475341 | 475341 | 2020-08-27 | Mayaguez | Puerto Rico | 72097 | 612 | |
475342 | 475342 | 2020-08-27 | Moca | Puerto Rico | 72099 | 245 | |
475343 | 475343 | 2020-08-27 | Morovis | Puerto Rico | 72101 | 368 | |
475344 | 475344 | 2020-08-27 | Naguabo | Puerto Rico | 72103 | 127 | |
475345 | 475345 | 2020-08-27 | Naranjito | Puerto Rico | 72105 | 437 | |
475346 | 475346 | 2020-08-27 | Orocovis | Puerto Rico | 72107 | 267 | |
475347 | 475347 | 2020-08-27 | Patillas | Puerto Rico | 72109 | 130 | |
475348 | 475348 | 2020-08-27 | Penuelas | Puerto Rico | 72111 | 96 | |
475349 | 475349 | 2020-08-27 | Ponce | Puerto Rico | 72113 | 633 | |
475350 | 475350 | 2020-08-27 | Quebradillas | Puerto Rico | 72115 | 109 | |
475351 | 475351 | 2020-08-27 | Rincon | Puerto Rico | 72117 | 123 | |
475352 | 475352 | 2020-08-27 | Rio Grande | Puerto Rico | 72119 | 414 | |
475353 | 475353 | 2020-08-27 | Sabana Grande | Puerto Rico | 72121 | 155 | |
475354 | 475354 | 2020-08-27 | Salinas | Puerto Rico | 72123 | 295 | |
475355 | 475355 | 2020-08-27 | San German | Puerto Rico | 72125 | 186 | |
475356 | 475356 | 2020-08-27 | San Juan | Puerto Rico | 72127 | 4993 | |
475357 | 475357 | 2020-08-27 | San Lorenzo | Puerto Rico | 72129 | 248 | |
475358 | 475358 | 2020-08-27 | San Sebastian | Puerto Rico | 72131 | 272 | |
475359 | 475359 | 2020-08-27 | Santa Isabel | Puerto Rico | 72133 | 123 | |
475360 | 475360 | 2020-08-27 | Toa Alta | Puerto Rico | 72135 | 858 | |
475361 | 475361 | 2020-08-27 | Toa Baja | Puerto Rico | 72137 | 844 | |
475362 | 475362 | 2020-08-27 | Trujillo Alto | Puerto Rico | 72139 | 712 | |
475363 | 475363 | 2020-08-27 | Unknown | Puerto Rico | 1329 | 412 | |
475364 | 475364 | 2020-08-27 | Utuado | Puerto Rico | 72141 | 98 | |
475365 | 475365 | 2020-08-27 | Vega Alta | Puerto Rico | 72143 | 415 | |
475366 | 475366 | 2020-08-27 | Vega Baja | Puerto Rico | 72145 | 623 | |
475367 | 475367 | 2020-08-27 | Vieques | Puerto Rico | 72147 | 84 | |
475368 | 475368 | 2020-08-27 | Villalba | Puerto Rico | 72149 | 92 | |
475369 | 475369 | 2020-08-27 | Yabucoa | Puerto Rico | 72151 | 187 | |
475370 | 475370 | 2020-08-27 | Yauco | Puerto Rico | 72153 | 306 |
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);