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 >30
county >30
- Unknown 672
- Adjuntas 619
- Aguada 619
- Aguadilla 619
- Aguas Buenas 619
- Aibonito 619
- Anasco 619
- Arecibo 619
- Arroyo 619
- Barceloneta 619
- Barranquitas 619
- Bayamon 619
- Cabo Rojo 619
- Caguas 619
- Camuy 619
- Canovanas 619
- Carolina 619
- Catano 619
- Cayey 619
- Ceiba 619
- Ciales 619
- Cidra 619
- Coamo 619
- Comerio 619
- Corozal 619
- Dorado 619
- Fajardo 619
- Florida 619
- Guanica 619
- Guayama 619
- …
state 1
- Puerto Rico · 48,917 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111463 | 2111463 | 2022-01-13 | Adjuntas | Puerto Rico | 72001 | 1624 | |
2111464 | 2111464 | 2022-01-13 | Aguada | Puerto Rico | 72003 | 4866 | |
2111465 | 2111465 | 2022-01-13 | Aguadilla | Puerto Rico | 72005 | 5698 | |
2111466 | 2111466 | 2022-01-13 | Aguas Buenas | Puerto Rico | 72007 | 3116 | |
2111467 | 2111467 | 2022-01-13 | Aibonito | Puerto Rico | 72009 | 2689 | |
2111468 | 2111468 | 2022-01-13 | Anasco | Puerto Rico | 72011 | 2736 | |
2111469 | 2111469 | 2022-01-13 | Arecibo | Puerto Rico | 72013 | 9645 | |
2111470 | 2111470 | 2022-01-13 | Arroyo | Puerto Rico | 72015 | 1361 | |
2111471 | 2111471 | 2022-01-13 | Barceloneta | Puerto Rico | 72017 | 2408 | |
2111472 | 2111472 | 2022-01-13 | Barranquitas | Puerto Rico | 72019 | 3775 | |
2111473 | 2111473 | 2022-01-13 | Bayamon | Puerto Rico | 72021 | 28405 | |
2111474 | 2111474 | 2022-01-13 | Cabo Rojo | Puerto Rico | 72023 | 4083 | |
2111475 | 2111475 | 2022-01-13 | Caguas | Puerto Rico | 72025 | 17714 | |
2111476 | 2111476 | 2022-01-13 | Camuy | Puerto Rico | 72027 | 3554 | |
2111477 | 2111477 | 2022-01-13 | Canovanas | Puerto Rico | 72029 | 5353 | |
2111478 | 2111478 | 2022-01-13 | Carolina | Puerto Rico | 72031 | 23243 | |
2111479 | 2111479 | 2022-01-13 | Catano | Puerto Rico | 72033 | 3444 | |
2111480 | 2111480 | 2022-01-13 | Cayey | Puerto Rico | 72035 | 4572 | |
2111481 | 2111481 | 2022-01-13 | Ceiba | Puerto Rico | 72037 | 1091 | |
2111482 | 2111482 | 2022-01-13 | Ciales | Puerto Rico | 72039 | 1972 | |
2111483 | 2111483 | 2022-01-13 | Cidra | Puerto Rico | 72041 | 4348 | |
2111484 | 2111484 | 2022-01-13 | Coamo | Puerto Rico | 72043 | 3419 | |
2111485 | 2111485 | 2022-01-13 | Comerio | Puerto Rico | 72045 | 2216 | |
2111486 | 2111486 | 2022-01-13 | Corozal | Puerto Rico | 72047 | 4988 | |
2111487 | 2111487 | 2022-01-13 | Culebra | Puerto Rico | 72049 | 147 | |
2111488 | 2111488 | 2022-01-13 | Dorado | Puerto Rico | 72051 | 5565 | |
2111489 | 2111489 | 2022-01-13 | Fajardo | Puerto Rico | 72053 | 3689 | |
2111490 | 2111490 | 2022-01-13 | Florida | Puerto Rico | 72054 | 1855 | |
2111491 | 2111491 | 2022-01-13 | Guanica | Puerto Rico | 72055 | 1057 | |
2111492 | 2111492 | 2022-01-13 | Guayama | Puerto Rico | 72057 | 3525 | |
2111493 | 2111493 | 2022-01-13 | Guayanilla | Puerto Rico | 72059 | 1435 | |
2111494 | 2111494 | 2022-01-13 | Guaynabo | Puerto Rico | 72061 | 12538 | |
2111495 | 2111495 | 2022-01-13 | Gurabo | Puerto Rico | 72063 | 5691 | |
2111496 | 2111496 | 2022-01-13 | Hatillo | Puerto Rico | 72065 | 3895 | |
2111497 | 2111497 | 2022-01-13 | Hormigueros | Puerto Rico | 72067 | 1457 | |
2111498 | 2111498 | 2022-01-13 | Humacao | Puerto Rico | 72069 | 6177 | |
2111499 | 2111499 | 2022-01-13 | Isabela | Puerto Rico | 72071 | 4975 | |
2111500 | 2111500 | 2022-01-13 | Jayuya | Puerto Rico | 72073 | 1524 | |
2111501 | 2111501 | 2022-01-13 | Juana Diaz | Puerto Rico | 72075 | 4288 | |
2111502 | 2111502 | 2022-01-13 | Juncos | Puerto Rico | 72077 | 5146 | |
2111503 | 2111503 | 2022-01-13 | Lajas | Puerto Rico | 72079 | 1756 | |
2111504 | 2111504 | 2022-01-13 | Lares | Puerto Rico | 72081 | 2781 | |
2111505 | 2111505 | 2022-01-13 | Las Marias | Puerto Rico | 72083 | 817 | |
2111506 | 2111506 | 2022-01-13 | Las Piedras | Puerto Rico | 72085 | 4179 | |
2111507 | 2111507 | 2022-01-13 | Loiza | Puerto Rico | 72087 | 2617 | |
2111508 | 2111508 | 2022-01-13 | Luquillo | Puerto Rico | 72089 | 2019 | |
2111509 | 2111509 | 2022-01-13 | Manati | Puerto Rico | 72091 | 4622 | |
2111510 | 2111510 | 2022-01-13 | Maricao | Puerto Rico | 72093 | 389 | |
2111511 | 2111511 | 2022-01-13 | Maunabo | Puerto Rico | 72095 | 1031 | |
2111512 | 2111512 | 2022-01-13 | Mayaguez | Puerto Rico | 72097 | 7690 | |
2111513 | 2111513 | 2022-01-13 | Moca | Puerto Rico | 72099 | 4565 | |
2111514 | 2111514 | 2022-01-13 | Morovis | Puerto Rico | 72101 | 3543 | |
2111515 | 2111515 | 2022-01-13 | Naguabo | Puerto Rico | 72103 | 2534 | |
2111516 | 2111516 | 2022-01-13 | Naranjito | Puerto Rico | 72105 | 4203 | |
2111517 | 2111517 | 2022-01-13 | Orocovis | Puerto Rico | 72107 | 2170 | |
2111518 | 2111518 | 2022-01-13 | Patillas | Puerto Rico | 72109 | 1510 | |
2111519 | 2111519 | 2022-01-13 | Penuelas | Puerto Rico | 72111 | 1653 | |
2111520 | 2111520 | 2022-01-13 | Ponce | Puerto Rico | 72113 | 12979 | |
2111521 | 2111521 | 2022-01-13 | Quebradillas | Puerto Rico | 72115 | 2666 | |
2111522 | 2111522 | 2022-01-13 | Rincon | Puerto Rico | 72117 | 1771 | |
2111523 | 2111523 | 2022-01-13 | Rio Grande | Puerto Rico | 72119 | 6170 | |
2111524 | 2111524 | 2022-01-13 | Sabana Grande | Puerto Rico | 72121 | 1693 | |
2111525 | 2111525 | 2022-01-13 | Salinas | Puerto Rico | 72123 | 2668 | |
2111526 | 2111526 | 2022-01-13 | San German | Puerto Rico | 72125 | 2613 | |
2111527 | 2111527 | 2022-01-13 | San Juan | Puerto Rico | 72127 | 51969 | |
2111528 | 2111528 | 2022-01-13 | San Lorenzo | Puerto Rico | 72129 | 4274 | |
2111529 | 2111529 | 2022-01-13 | San Sebastian | Puerto Rico | 72131 | 5043 | |
2111530 | 2111530 | 2022-01-13 | Santa Isabel | Puerto Rico | 72133 | 1980 | |
2111531 | 2111531 | 2022-01-13 | Toa Alta | Puerto Rico | 72135 | 10134 | |
2111532 | 2111532 | 2022-01-13 | Toa Baja | Puerto Rico | 72137 | 10649 | |
2111533 | 2111533 | 2022-01-13 | Trujillo Alto | Puerto Rico | 72139 | 8224 | |
2111534 | 2111534 | 2022-01-13 | Unknown | Puerto Rico | 13352 | 3446 | |
2111535 | 2111535 | 2022-01-13 | Utuado | Puerto Rico | 72141 | 2544 | |
2111536 | 2111536 | 2022-01-13 | Vega Alta | Puerto Rico | 72143 | 4914 | |
2111537 | 2111537 | 2022-01-13 | Vega Baja | Puerto Rico | 72145 | 8309 | |
2111538 | 2111538 | 2022-01-13 | Vieques | Puerto Rico | 72147 | 557 | |
2111539 | 2111539 | 2022-01-13 | Villalba | Puerto Rico | 72149 | 2340 | |
2111540 | 2111540 | 2022-01-13 | Yabucoa | Puerto Rico | 72151 | 3296 | |
2111541 | 2111541 | 2022-01-13 | Yauco | Puerto Rico | 72153 | 3230 | |
2108211 | 2108211 | 2022-01-12 | Adjuntas | Puerto Rico | 72001 | 1537 | |
2108212 | 2108212 | 2022-01-12 | Aguada | Puerto Rico | 72003 | 4701 | |
2108213 | 2108213 | 2022-01-12 | Aguadilla | Puerto Rico | 72005 | 5516 | |
2108214 | 2108214 | 2022-01-12 | Aguas Buenas | Puerto Rico | 72007 | 2984 | |
2108215 | 2108215 | 2022-01-12 | Aibonito | Puerto Rico | 72009 | 2603 | |
2108216 | 2108216 | 2022-01-12 | Anasco | Puerto Rico | 72011 | 2661 | |
2108217 | 2108217 | 2022-01-12 | Arecibo | Puerto Rico | 72013 | 9272 | |
2108218 | 2108218 | 2022-01-12 | Arroyo | Puerto Rico | 72015 | 1286 | |
2108219 | 2108219 | 2022-01-12 | Barceloneta | Puerto Rico | 72017 | 2318 | |
2108220 | 2108220 | 2022-01-12 | Barranquitas | Puerto Rico | 72019 | 3671 | |
2108221 | 2108221 | 2022-01-12 | Bayamon | Puerto Rico | 72021 | 27811 | |
2108222 | 2108222 | 2022-01-12 | Cabo Rojo | Puerto Rico | 72023 | 4005 | |
2108223 | 2108223 | 2022-01-12 | Caguas | Puerto Rico | 72025 | 17216 | |
2108224 | 2108224 | 2022-01-12 | Camuy | Puerto Rico | 72027 | 3469 | |
2108225 | 2108225 | 2022-01-12 | Canovanas | Puerto Rico | 72029 | 5272 | |
2108226 | 2108226 | 2022-01-12 | Carolina | Puerto Rico | 72031 | 22758 | |
2108227 | 2108227 | 2022-01-12 | Catano | Puerto Rico | 72033 | 3362 | |
2108228 | 2108228 | 2022-01-12 | Cayey | Puerto Rico | 72035 | 4372 | |
2108229 | 2108229 | 2022-01-12 | Ceiba | Puerto Rico | 72037 | 1065 | |
2108230 | 2108230 | 2022-01-12 | Ciales | Puerto Rico | 72039 | 1913 | |
2108231 | 2108231 | 2022-01-12 | Cidra | Puerto Rico | 72041 | 4161 |
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);