ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,758 rows where state = "Puerto Rico" sorted by date descending

View and edit SQL

fips

state

  • Puerto Rico · 7,758
Link rowid date ▲ county state fips cases deaths
420477 2020-08-10 Adjuntas Puerto Rico 72001 94 0
420478 2020-08-10 Aguada Puerto Rico 72003 140 0
420479 2020-08-10 Aguadilla Puerto Rico 72005 230 0
420480 2020-08-10 Aguas Buenas Puerto Rico 72007 133 0
420481 2020-08-10 Aibonito Puerto Rico 72009 89 0
420482 2020-08-10 Anasco Puerto Rico 72011 145 0
420483 2020-08-10 Arecibo Puerto Rico 72013 324 0
420484 2020-08-10 Arroyo Puerto Rico 72015 92 0
420485 2020-08-10 Barceloneta Puerto Rico 72017 95 0
420486 2020-08-10 Barranquitas Puerto Rico 72019 248 0
420487 2020-08-10 Bayamon Puerto Rico 72021 1565 0
420488 2020-08-10 Cabo Rojo Puerto Rico 72023 210 0
420489 2020-08-10 Caguas Puerto Rico 72025 745 0
420490 2020-08-10 Camuy Puerto Rico 72027 143 0
420491 2020-08-10 Canovanas Puerto Rico 72029 388 0
420492 2020-08-10 Carolina Puerto Rico 72031 1302 0
420493 2020-08-10 Catano Puerto Rico 72033 198 0
420494 2020-08-10 Cayey Puerto Rico 72035 199 0
420495 2020-08-10 Ceiba Puerto Rico 72037 70 0
420496 2020-08-10 Ciales Puerto Rico 72039 155 0
420497 2020-08-10 Cidra Puerto Rico 72041 171 0
420498 2020-08-10 Coamo Puerto Rico 72043 152 0
420499 2020-08-10 Comerio Puerto Rico 72045 122 0
420500 2020-08-10 Corozal Puerto Rico 72047 242 0
420501 2020-08-10 Culebra Puerto Rico 72049 19 0
420502 2020-08-10 Dorado Puerto Rico 72051 325 0
420503 2020-08-10 Fajardo Puerto Rico 72053 256 0
420504 2020-08-10 Florida Puerto Rico 72054 178 0
420505 2020-08-10 Guanica Puerto Rico 72055 59 0
420506 2020-08-10 Guayama Puerto Rico 72057 162 0
420507 2020-08-10 Guayanilla Puerto Rico 72059 129 0
420508 2020-08-10 Guaynabo Puerto Rico 72061 861 0
420509 2020-08-10 Gurabo Puerto Rico 72063 261 0
420510 2020-08-10 Hatillo Puerto Rico 72065 114 0
420511 2020-08-10 Hormigueros Puerto Rico 72067 97 0
420512 2020-08-10 Humacao Puerto Rico 72069 192 0
420513 2020-08-10 Isabela Puerto Rico 72071 141 0
420514 2020-08-10 Jayuya Puerto Rico 72073 179 0
420515 2020-08-10 Juana Diaz Puerto Rico 72075 197 0
420516 2020-08-10 Juncos Puerto Rico 72077 141 0
420517 2020-08-10 Lajas Puerto Rico 72079 82 0
420518 2020-08-10 Lares Puerto Rico 72081 175 0
420519 2020-08-10 Las Marias Puerto Rico 72083 72 0
420520 2020-08-10 Las Piedras Puerto Rico 72085 158 0
420521 2020-08-10 Loiza Puerto Rico 72087 135 0
420522 2020-08-10 Luquillo Puerto Rico 72089 110 0
420523 2020-08-10 Manati Puerto Rico 72091 249 0
420524 2020-08-10 Maricao Puerto Rico 72093 42 0
420525 2020-08-10 Maunabo Puerto Rico 72095 63 0
420526 2020-08-10 Mayaguez Puerto Rico 72097 507 0
420527 2020-08-10 Moca Puerto Rico 72099 177 0
420528 2020-08-10 Morovis Puerto Rico 72101 258 0
420529 2020-08-10 Naguabo Puerto Rico 72103 94 0
420530 2020-08-10 Naranjito Puerto Rico 72105 294 0
420531 2020-08-10 Orocovis Puerto Rico 72107 221 0
420532 2020-08-10 Patillas Puerto Rico 72109 107 0
420533 2020-08-10 Penuelas Puerto Rico 72111 76 0
420534 2020-08-10 Ponce Puerto Rico 72113 499 0
420535 2020-08-10 Quebradillas Puerto Rico 72115 81 0
420536 2020-08-10 Rincon Puerto Rico 72117 98 0
420537 2020-08-10 Rio Grande Puerto Rico 72119 302 0
420538 2020-08-10 Sabana Grande Puerto Rico 72121 130 0
420539 2020-08-10 Salinas Puerto Rico 72123 187 0
420540 2020-08-10 San German Puerto Rico 72125 146 0
420541 2020-08-10 San Juan Puerto Rico 72127 3361 0
420542 2020-08-10 San Lorenzo Puerto Rico 72129 179 0
420543 2020-08-10 San Sebastian Puerto Rico 72131 236 0
420544 2020-08-10 Santa Isabel Puerto Rico 72133 98 0
420545 2020-08-10 Toa Alta Puerto Rico 72135 595 0
420546 2020-08-10 Toa Baja Puerto Rico 72137 543 0
420547 2020-08-10 Trujillo Alto Puerto Rico 72139 514 0
420548 2020-08-10 Unknown Puerto Rico   1204 0
420549 2020-08-10 Utuado Puerto Rico 72141 75 0
420550 2020-08-10 Vega Alta Puerto Rico 72143 250 0
420551 2020-08-10 Vega Baja Puerto Rico 72145 418 0
420552 2020-08-10 Vieques Puerto Rico 72147 60 0
420553 2020-08-10 Villalba Puerto Rico 72149 81 0
420554 2020-08-10 Yabucoa Puerto Rico 72151 126 0
420555 2020-08-10 Yauco Puerto Rico 72153 255 0
417257 2020-08-09 Adjuntas Puerto Rico 72001 94 0
417258 2020-08-09 Aguada Puerto Rico 72003 135 0
417259 2020-08-09 Aguadilla Puerto Rico 72005 223 0
417260 2020-08-09 Aguas Buenas Puerto Rico 72007 129 0
417261 2020-08-09 Aibonito Puerto Rico 72009 89 0
417262 2020-08-09 Anasco Puerto Rico 72011 142 0
417263 2020-08-09 Arecibo Puerto Rico 72013 312 0
417264 2020-08-09 Arroyo Puerto Rico 72015 89 0
417265 2020-08-09 Barceloneta Puerto Rico 72017 91 0
417266 2020-08-09 Barranquitas Puerto Rico 72019 245 0
417267 2020-08-09 Bayamon Puerto Rico 72021 1511 0
417268 2020-08-09 Cabo Rojo Puerto Rico 72023 206 0
417269 2020-08-09 Caguas Puerto Rico 72025 717 0
417270 2020-08-09 Camuy Puerto Rico 72027 139 0
417271 2020-08-09 Canovanas Puerto Rico 72029 373 0
417272 2020-08-09 Carolina Puerto Rico 72031 1263 0
417273 2020-08-09 Catano Puerto Rico 72033 189 0
417274 2020-08-09 Cayey Puerto Rico 72035 197 0
417275 2020-08-09 Ceiba Puerto Rico 72037 68 0
417276 2020-08-09 Ciales Puerto Rico 72039 149 0
417277 2020-08-09 Cidra Puerto Rico 72041 169 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1236.43ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette