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 219
- Adjuntas 166
- Aguada 166
- Aguadilla 166
- Aguas Buenas 166
- Aibonito 166
- Anasco 166
- Arecibo 166
- Arroyo 166
- Barceloneta 166
- Barranquitas 166
- Bayamon 166
- Cabo Rojo 166
- Caguas 166
- Camuy 166
- Canovanas 166
- Carolina 166
- Catano 166
- Cayey 166
- Ceiba 166
- Ciales 166
- Cidra 166
- Coamo 166
- Comerio 166
- Corozal 166
- Dorado 166
- Fajardo 166
- Florida 166
- Guanica 166
- Guayama 166
- …
state 1
- Puerto Rico · 13,130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
640459 | 640459 | 2020-10-17 | Adjuntas | Puerto Rico | 72001 | 167 | |
640460 | 640460 | 2020-10-17 | Aguada | Puerto Rico | 72003 | 393 | |
640461 | 640461 | 2020-10-17 | Aguadilla | Puerto Rico | 72005 | 511 | |
640462 | 640462 | 2020-10-17 | Aguas Buenas | Puerto Rico | 72007 | 336 | |
640463 | 640463 | 2020-10-17 | Aibonito | Puerto Rico | 72009 | 190 | |
640464 | 640464 | 2020-10-17 | Anasco | Puerto Rico | 72011 | 239 | |
640465 | 640465 | 2020-10-17 | Arecibo | Puerto Rico | 72013 | 975 | |
640466 | 640466 | 2020-10-17 | Arroyo | Puerto Rico | 72015 | 188 | |
640467 | 640467 | 2020-10-17 | Barceloneta | Puerto Rico | 72017 | 297 | |
640468 | 640468 | 2020-10-17 | Barranquitas | Puerto Rico | 72019 | 537 | |
640469 | 640469 | 2020-10-17 | Bayamon | Puerto Rico | 72021 | 4396 | |
640470 | 640470 | 2020-10-17 | Cabo Rojo | Puerto Rico | 72023 | 463 | |
640471 | 640471 | 2020-10-17 | Caguas | Puerto Rico | 72025 | 1944 | |
640472 | 640472 | 2020-10-17 | Camuy | Puerto Rico | 72027 | 336 | |
640473 | 640473 | 2020-10-17 | Canovanas | Puerto Rico | 72029 | 800 | |
640474 | 640474 | 2020-10-17 | Carolina | Puerto Rico | 72031 | 3376 | |
640475 | 640475 | 2020-10-17 | Catano | Puerto Rico | 72033 | 542 | |
640476 | 640476 | 2020-10-17 | Cayey | Puerto Rico | 72035 | 439 | |
640477 | 640477 | 2020-10-17 | Ceiba | Puerto Rico | 72037 | 167 | |
640478 | 640478 | 2020-10-17 | Ciales | Puerto Rico | 72039 | 315 | |
640479 | 640479 | 2020-10-17 | Cidra | Puerto Rico | 72041 | 381 | |
640480 | 640480 | 2020-10-17 | Coamo | Puerto Rico | 72043 | 351 | |
640481 | 640481 | 2020-10-17 | Comerio | Puerto Rico | 72045 | 267 | |
640482 | 640482 | 2020-10-17 | Corozal | Puerto Rico | 72047 | 774 | |
640483 | 640483 | 2020-10-17 | Culebra | Puerto Rico | 72049 | 22 | |
640484 | 640484 | 2020-10-17 | Dorado | Puerto Rico | 72051 | 951 | |
640485 | 640485 | 2020-10-17 | Fajardo | Puerto Rico | 72053 | 642 | |
640486 | 640486 | 2020-10-17 | Florida | Puerto Rico | 72054 | 366 | |
640487 | 640487 | 2020-10-17 | Guanica | Puerto Rico | 72055 | 137 | |
640488 | 640488 | 2020-10-17 | Guayama | Puerto Rico | 72057 | 350 | |
640489 | 640489 | 2020-10-17 | Guayanilla | Puerto Rico | 72059 | 224 | |
640490 | 640490 | 2020-10-17 | Guaynabo | Puerto Rico | 72061 | 2048 | |
640491 | 640491 | 2020-10-17 | Gurabo | Puerto Rico | 72063 | 657 | |
640492 | 640492 | 2020-10-17 | Hatillo | Puerto Rico | 72065 | 382 | |
640493 | 640493 | 2020-10-17 | Hormigueros | Puerto Rico | 72067 | 192 | |
640494 | 640494 | 2020-10-17 | Humacao | Puerto Rico | 72069 | 691 | |
640495 | 640495 | 2020-10-17 | Isabela | Puerto Rico | 72071 | 336 | |
640496 | 640496 | 2020-10-17 | Jayuya | Puerto Rico | 72073 | 271 | |
640497 | 640497 | 2020-10-17 | Juana Diaz | Puerto Rico | 72075 | 403 | |
640498 | 640498 | 2020-10-17 | Juncos | Puerto Rico | 72077 | 517 | |
640499 | 640499 | 2020-10-17 | Lajas | Puerto Rico | 72079 | 190 | |
640500 | 640500 | 2020-10-17 | Lares | Puerto Rico | 72081 | 393 | |
640501 | 640501 | 2020-10-17 | Las Marias | Puerto Rico | 72083 | 118 | |
640502 | 640502 | 2020-10-17 | Las Piedras | Puerto Rico | 72085 | 592 | |
640503 | 640503 | 2020-10-17 | Loiza | Puerto Rico | 72087 | 333 | |
640504 | 640504 | 2020-10-17 | Luquillo | Puerto Rico | 72089 | 295 | |
640505 | 640505 | 2020-10-17 | Manati | Puerto Rico | 72091 | 682 | |
640506 | 640506 | 2020-10-17 | Maricao | Puerto Rico | 72093 | 91 | |
640507 | 640507 | 2020-10-17 | Maunabo | Puerto Rico | 72095 | 167 | |
640508 | 640508 | 2020-10-17 | Mayaguez | Puerto Rico | 72097 | 935 | |
640509 | 640509 | 2020-10-17 | Moca | Puerto Rico | 72099 | 408 | |
640510 | 640510 | 2020-10-17 | Morovis | Puerto Rico | 72101 | 584 | |
640511 | 640511 | 2020-10-17 | Naguabo | Puerto Rico | 72103 | 340 | |
640512 | 640512 | 2020-10-17 | Naranjito | Puerto Rico | 72105 | 761 | |
640513 | 640513 | 2020-10-17 | Orocovis | Puerto Rico | 72107 | 393 | |
640514 | 640514 | 2020-10-17 | Patillas | Puerto Rico | 72109 | 190 | |
640515 | 640515 | 2020-10-17 | Penuelas | Puerto Rico | 72111 | 141 | |
640516 | 640516 | 2020-10-17 | Ponce | Puerto Rico | 72113 | 1080 | |
640517 | 640517 | 2020-10-17 | Quebradillas | Puerto Rico | 72115 | 231 | |
640518 | 640518 | 2020-10-17 | Rincon | Puerto Rico | 72117 | 229 | |
640519 | 640519 | 2020-10-17 | Rio Grande | Puerto Rico | 72119 | 728 | |
640520 | 640520 | 2020-10-17 | Sabana Grande | Puerto Rico | 72121 | 221 | |
640521 | 640521 | 2020-10-17 | Salinas | Puerto Rico | 72123 | 503 | |
640522 | 640522 | 2020-10-17 | San German | Puerto Rico | 72125 | 289 | |
640523 | 640523 | 2020-10-17 | San Juan | Puerto Rico | 72127 | 9161 | |
640524 | 640524 | 2020-10-17 | San Lorenzo | Puerto Rico | 72129 | 633 | |
640525 | 640525 | 2020-10-17 | San Sebastian | Puerto Rico | 72131 | 562 | |
640526 | 640526 | 2020-10-17 | Santa Isabel | Puerto Rico | 72133 | 212 | |
640527 | 640527 | 2020-10-17 | Toa Alta | Puerto Rico | 72135 | 1530 | |
640528 | 640528 | 2020-10-17 | Toa Baja | Puerto Rico | 72137 | 1748 | |
640529 | 640529 | 2020-10-17 | Trujillo Alto | Puerto Rico | 72139 | 1322 | |
640530 | 640530 | 2020-10-17 | Unknown | Puerto Rico | 1651 | 761 | |
640531 | 640531 | 2020-10-17 | Utuado | Puerto Rico | 72141 | 193 | |
640532 | 640532 | 2020-10-17 | Vega Alta | Puerto Rico | 72143 | 885 | |
640533 | 640533 | 2020-10-17 | Vega Baja | Puerto Rico | 72145 | 1102 | |
640534 | 640534 | 2020-10-17 | Vieques | Puerto Rico | 72147 | 101 | |
640535 | 640535 | 2020-10-17 | Villalba | Puerto Rico | 72149 | 176 | |
640536 | 640536 | 2020-10-17 | Yabucoa | Puerto Rico | 72151 | 440 | |
640537 | 640537 | 2020-10-17 | Yauco | Puerto Rico | 72153 | 467 | |
637213 | 637213 | 2020-10-16 | Adjuntas | Puerto Rico | 72001 | 166 | |
637214 | 637214 | 2020-10-16 | Aguada | Puerto Rico | 72003 | 391 | |
637215 | 637215 | 2020-10-16 | Aguadilla | Puerto Rico | 72005 | 506 | |
637216 | 637216 | 2020-10-16 | Aguas Buenas | Puerto Rico | 72007 | 334 | |
637217 | 637217 | 2020-10-16 | Aibonito | Puerto Rico | 72009 | 190 | |
637218 | 637218 | 2020-10-16 | Anasco | Puerto Rico | 72011 | 239 | |
637219 | 637219 | 2020-10-16 | Arecibo | Puerto Rico | 72013 | 971 | |
637220 | 637220 | 2020-10-16 | Arroyo | Puerto Rico | 72015 | 187 | |
637221 | 637221 | 2020-10-16 | Barceloneta | Puerto Rico | 72017 | 297 | |
637222 | 637222 | 2020-10-16 | Barranquitas | Puerto Rico | 72019 | 537 | |
637223 | 637223 | 2020-10-16 | Bayamon | Puerto Rico | 72021 | 4383 | |
637224 | 637224 | 2020-10-16 | Cabo Rojo | Puerto Rico | 72023 | 462 | |
637225 | 637225 | 2020-10-16 | Caguas | Puerto Rico | 72025 | 1936 | |
637226 | 637226 | 2020-10-16 | Camuy | Puerto Rico | 72027 | 335 | |
637227 | 637227 | 2020-10-16 | Canovanas | Puerto Rico | 72029 | 797 | |
637228 | 637228 | 2020-10-16 | Carolina | Puerto Rico | 72031 | 3355 | |
637229 | 637229 | 2020-10-16 | Catano | Puerto Rico | 72033 | 539 | |
637230 | 637230 | 2020-10-16 | Cayey | Puerto Rico | 72035 | 434 | |
637231 | 637231 | 2020-10-16 | Ceiba | Puerto Rico | 72037 | 167 | |
637232 | 637232 | 2020-10-16 | Ciales | Puerto Rico | 72039 | 314 | |
637233 | 637233 | 2020-10-16 | Cidra | Puerto Rico | 72041 | 381 |
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);