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

This data as json, copyable, CSV (advanced)

fips

state

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