ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 79
- - 459
- 72001 406
- 72003 406
- 72005 406
- 72007 406
- 72009 406
- 72011 406
- 72013 406
- 72015 406
- 72017 406
- 72019 406
- 72021 406
- 72023 406
- 72025 406
- 72027 406
- 72029 406
- 72031 406
- 72033 406
- 72035 406
- 72037 406
- 72039 406
- 72041 406
- 72043 406
- 72045 406
- 72047 406
- 72051 406
- 72053 406
- 72054 406
- 72055 406
- 72057 406
- 72059 406
- 72061 406
- 72063 406
- 72065 406
- 72067 406
- 72069 406
- 72071 406
- 72073 406
- 72075 406
- 72077 406
- 72079 406
- 72081 406
- 72083 406
- 72085 406
- 72087 406
- 72089 406
- 72091 406
- 72095 406
- 72097 406
- 72099 406
- 72101 406
- 72103 406
- 72105 406
- 72107 406
- 72109 406
- 72111 406
- 72113 406
- 72115 406
- 72117 406
- 72119 406
- 72121 406
- 72123 406
- 72125 406
- 72127 406
- 72129 406
- 72131 406
- 72133 406
- 72135 406
- 72137 406
- 72139 406
- 72141 406
- 72143 406
- 72145 406
- 72149 406
- 72151 406
- 72153 406
- 72147 404
- 72093 395
- 72049 382
county 79
- Unknown 459
- Adjuntas 406
- Aguada 406
- Aguadilla 406
- Aguas Buenas 406
- Aibonito 406
- Anasco 406
- Arecibo 406
- Arroyo 406
- Barceloneta 406
- Barranquitas 406
- Bayamon 406
- Cabo Rojo 406
- Caguas 406
- Camuy 406
- Canovanas 406
- Carolina 406
- Catano 406
- Cayey 406
- Ceiba 406
- Ciales 406
- Cidra 406
- Coamo 406
- Comerio 406
- Corozal 406
- Dorado 406
- Fajardo 406
- Florida 406
- Guanica 406
- Guayama 406
- Guayanilla 406
- Guaynabo 406
- Gurabo 406
- Hatillo 406
- Hormigueros 406
- Humacao 406
- Isabela 406
- Jayuya 406
- Juana Diaz 406
- Juncos 406
- Lajas 406
- Lares 406
- Las Marias 406
- Las Piedras 406
- Loiza 406
- Luquillo 406
- Manati 406
- Maunabo 406
- Mayaguez 406
- Moca 406
- Morovis 406
- Naguabo 406
- Naranjito 406
- Orocovis 406
- Patillas 406
- Penuelas 406
- Ponce 406
- Quebradillas 406
- Rincon 406
- Rio Grande 406
- Sabana Grande 406
- Salinas 406
- San German 406
- San Juan 406
- San Lorenzo 406
- San Sebastian 406
- Santa Isabel 406
- Toa Alta 406
- Toa Baja 406
- Trujillo Alto 406
- Utuado 406
- Vega Alta 406
- Vega Baja 406
- Villalba 406
- Yabucoa 406
- Yauco 406
- Vieques 404
- Maricao 395
- Culebra 382
state 1
- Puerto Rico · 32,090 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419458 | 1419458 | 2021-06-14 | Adjuntas | Puerto Rico | 72001 | 552 | |
1419459 | 1419459 | 2021-06-14 | Aguada | Puerto Rico | 72003 | 1555 | |
1419460 | 1419460 | 2021-06-14 | Aguadilla | Puerto Rico | 72005 | 1895 | |
1419461 | 1419461 | 2021-06-14 | Aguas Buenas | Puerto Rico | 72007 | 1381 | |
1419462 | 1419462 | 2021-06-14 | Aibonito | Puerto Rico | 72009 | 812 | |
1419463 | 1419463 | 2021-06-14 | Anasco | Puerto Rico | 72011 | 988 | |
1419464 | 1419464 | 2021-06-14 | Arecibo | Puerto Rico | 72013 | 3544 | |
1419465 | 1419465 | 2021-06-14 | Arroyo | Puerto Rico | 72015 | 456 | |
1419466 | 1419466 | 2021-06-14 | Barceloneta | Puerto Rico | 72017 | 934 | |
1419467 | 1419467 | 2021-06-14 | Barranquitas | Puerto Rico | 72019 | 1613 | |
1419468 | 1419468 | 2021-06-14 | Bayamon | Puerto Rico | 72021 | 12645 | |
1419469 | 1419469 | 2021-06-14 | Cabo Rojo | Puerto Rico | 72023 | 1281 | |
1419470 | 1419470 | 2021-06-14 | Caguas | Puerto Rico | 72025 | 7328 | |
1419471 | 1419471 | 2021-06-14 | Camuy | Puerto Rico | 72027 | 1418 | |
1419472 | 1419472 | 2021-06-14 | Canovanas | Puerto Rico | 72029 | 2389 | |
1419473 | 1419473 | 2021-06-14 | Carolina | Puerto Rico | 72031 | 10278 | |
1419474 | 1419474 | 2021-06-14 | Catano | Puerto Rico | 72033 | 1546 | |
1419475 | 1419475 | 2021-06-14 | Cayey | Puerto Rico | 72035 | 1632 | |
1419476 | 1419476 | 2021-06-14 | Ceiba | Puerto Rico | 72037 | 524 | |
1419477 | 1419477 | 2021-06-14 | Ciales | Puerto Rico | 72039 | 930 | |
1419478 | 1419478 | 2021-06-14 | Cidra | Puerto Rico | 72041 | 1510 | |
1419479 | 1419479 | 2021-06-14 | Coamo | Puerto Rico | 72043 | 1169 | |
1419480 | 1419480 | 2021-06-14 | Comerio | Puerto Rico | 72045 | 876 | |
1419481 | 1419481 | 2021-06-14 | Corozal | Puerto Rico | 72047 | 2074 | |
1419482 | 1419482 | 2021-06-14 | Culebra | Puerto Rico | 72049 | 44 | |
1419483 | 1419483 | 2021-06-14 | Dorado | Puerto Rico | 72051 | 2674 | |
1419484 | 1419484 | 2021-06-14 | Fajardo | Puerto Rico | 72053 | 1686 | |
1419485 | 1419485 | 2021-06-14 | Florida | Puerto Rico | 72054 | 840 | |
1419486 | 1419486 | 2021-06-14 | Guanica | Puerto Rico | 72055 | 339 | |
1419487 | 1419487 | 2021-06-14 | Guayama | Puerto Rico | 72057 | 1093 | |
1419488 | 1419488 | 2021-06-14 | Guayanilla | Puerto Rico | 72059 | 574 | |
1419489 | 1419489 | 2021-06-14 | Guaynabo | Puerto Rico | 72061 | 5288 | |
1419490 | 1419490 | 2021-06-14 | Gurabo | Puerto Rico | 72063 | 2529 | |
1419491 | 1419491 | 2021-06-14 | Hatillo | Puerto Rico | 72065 | 1366 | |
1419492 | 1419492 | 2021-06-14 | Hormigueros | Puerto Rico | 72067 | 510 | |
1419493 | 1419493 | 2021-06-14 | Humacao | Puerto Rico | 72069 | 2516 | |
1419494 | 1419494 | 2021-06-14 | Isabela | Puerto Rico | 72071 | 1630 | |
1419495 | 1419495 | 2021-06-14 | Jayuya | Puerto Rico | 72073 | 593 | |
1419496 | 1419496 | 2021-06-14 | Juana Diaz | Puerto Rico | 72075 | 1393 | |
1419497 | 1419497 | 2021-06-14 | Juncos | Puerto Rico | 72077 | 2540 | |
1419498 | 1419498 | 2021-06-14 | Lajas | Puerto Rico | 72079 | 606 | |
1419499 | 1419499 | 2021-06-14 | Lares | Puerto Rico | 72081 | 1119 | |
1419500 | 1419500 | 2021-06-14 | Las Marias | Puerto Rico | 72083 | 323 | |
1419501 | 1419501 | 2021-06-14 | Las Piedras | Puerto Rico | 72085 | 1958 | |
1419502 | 1419502 | 2021-06-14 | Loiza | Puerto Rico | 72087 | 1449 | |
1419503 | 1419503 | 2021-06-14 | Luquillo | Puerto Rico | 72089 | 928 | |
1419504 | 1419504 | 2021-06-14 | Manati | Puerto Rico | 72091 | 1912 | |
1419505 | 1419505 | 2021-06-14 | Maricao | Puerto Rico | 72093 | 151 | |
1419506 | 1419506 | 2021-06-14 | Maunabo | Puerto Rico | 72095 | 480 | |
1419507 | 1419507 | 2021-06-14 | Mayaguez | Puerto Rico | 72097 | 2512 | |
1419508 | 1419508 | 2021-06-14 | Moca | Puerto Rico | 72099 | 1692 | |
1419509 | 1419509 | 2021-06-14 | Morovis | Puerto Rico | 72101 | 1737 | |
1419510 | 1419510 | 2021-06-14 | Naguabo | Puerto Rico | 72103 | 1212 | |
1419511 | 1419511 | 2021-06-14 | Naranjito | Puerto Rico | 72105 | 2045 | |
1419512 | 1419512 | 2021-06-14 | Orocovis | Puerto Rico | 72107 | 1108 | |
1419513 | 1419513 | 2021-06-14 | Patillas | Puerto Rico | 72109 | 506 | |
1419514 | 1419514 | 2021-06-14 | Penuelas | Puerto Rico | 72111 | 663 | |
1419515 | 1419515 | 2021-06-14 | Ponce | Puerto Rico | 72113 | 4107 | |
1419516 | 1419516 | 2021-06-14 | Quebradillas | Puerto Rico | 72115 | 1027 | |
1419517 | 1419517 | 2021-06-14 | Rincon | Puerto Rico | 72117 | 669 | |
1419518 | 1419518 | 2021-06-14 | Rio Grande | Puerto Rico | 72119 | 2545 | |
1419519 | 1419519 | 2021-06-14 | Sabana Grande | Puerto Rico | 72121 | 544 | |
1419520 | 1419520 | 2021-06-14 | Salinas | Puerto Rico | 72123 | 1210 | |
1419521 | 1419521 | 2021-06-14 | San German | Puerto Rico | 72125 | 826 | |
1419522 | 1419522 | 2021-06-14 | San Juan | Puerto Rico | 72127 | 22624 | |
1419523 | 1419523 | 2021-06-14 | San Lorenzo | Puerto Rico | 72129 | 2039 | |
1419524 | 1419524 | 2021-06-14 | San Sebastian | Puerto Rico | 72131 | 1959 | |
1419525 | 1419525 | 2021-06-14 | Santa Isabel | Puerto Rico | 72133 | 697 | |
1419526 | 1419526 | 2021-06-14 | Toa Alta | Puerto Rico | 72135 | 4765 | |
1419527 | 1419527 | 2021-06-14 | Toa Baja | Puerto Rico | 72137 | 4866 | |
1419528 | 1419528 | 2021-06-14 | Trujillo Alto | Puerto Rico | 72139 | 3667 | |
1419529 | 1419529 | 2021-06-14 | Unknown | Puerto Rico | 5589 | 2530 | |
1419530 | 1419530 | 2021-06-14 | Utuado | Puerto Rico | 72141 | 1077 | |
1419531 | 1419531 | 2021-06-14 | Vega Alta | Puerto Rico | 72143 | 2285 | |
1419532 | 1419532 | 2021-06-14 | Vega Baja | Puerto Rico | 72145 | 3453 | |
1419533 | 1419533 | 2021-06-14 | Vieques | Puerto Rico | 72147 | 204 | |
1419534 | 1419534 | 2021-06-14 | Villalba | Puerto Rico | 72149 | 879 | |
1419535 | 1419535 | 2021-06-14 | Yabucoa | Puerto Rico | 72151 | 1402 | |
1419536 | 1419536 | 2021-06-14 | Yauco | Puerto Rico | 72153 | 1258 | |
1416213 | 1416213 | 2021-06-13 | Adjuntas | Puerto Rico | 72001 | 552 | |
1416214 | 1416214 | 2021-06-13 | Aguada | Puerto Rico | 72003 | 1555 | |
1416215 | 1416215 | 2021-06-13 | Aguadilla | Puerto Rico | 72005 | 1895 | |
1416216 | 1416216 | 2021-06-13 | Aguas Buenas | Puerto Rico | 72007 | 1381 | |
1416217 | 1416217 | 2021-06-13 | Aibonito | Puerto Rico | 72009 | 812 | |
1416218 | 1416218 | 2021-06-13 | Anasco | Puerto Rico | 72011 | 988 | |
1416219 | 1416219 | 2021-06-13 | Arecibo | Puerto Rico | 72013 | 3544 | |
1416220 | 1416220 | 2021-06-13 | Arroyo | Puerto Rico | 72015 | 455 | |
1416221 | 1416221 | 2021-06-13 | Barceloneta | Puerto Rico | 72017 | 934 | |
1416222 | 1416222 | 2021-06-13 | Barranquitas | Puerto Rico | 72019 | 1613 | |
1416223 | 1416223 | 2021-06-13 | Bayamon | Puerto Rico | 72021 | 12643 | |
1416224 | 1416224 | 2021-06-13 | Cabo Rojo | Puerto Rico | 72023 | 1280 | |
1416225 | 1416225 | 2021-06-13 | Caguas | Puerto Rico | 72025 | 7327 | |
1416226 | 1416226 | 2021-06-13 | Camuy | Puerto Rico | 72027 | 1418 | |
1416227 | 1416227 | 2021-06-13 | Canovanas | Puerto Rico | 72029 | 2388 | |
1416228 | 1416228 | 2021-06-13 | Carolina | Puerto Rico | 72031 | 10270 | |
1416229 | 1416229 | 2021-06-13 | Catano | Puerto Rico | 72033 | 1546 | |
1416230 | 1416230 | 2021-06-13 | Cayey | Puerto Rico | 72035 | 1632 | |
1416231 | 1416231 | 2021-06-13 | Ceiba | Puerto Rico | 72037 | 524 | |
1416232 | 1416232 | 2021-06-13 | Ciales | Puerto Rico | 72039 | 930 | |
1416233 | 1416233 | 2021-06-13 | Cidra | Puerto Rico | 72041 | 1509 |
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);