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 104
- Adjuntas 51
- Aguada 51
- Aguadilla 51
- Aguas Buenas 51
- Aibonito 51
- Anasco 51
- Arecibo 51
- Arroyo 51
- Barceloneta 51
- Barranquitas 51
- Bayamon 51
- Cabo Rojo 51
- Caguas 51
- Camuy 51
- Canovanas 51
- Carolina 51
- Catano 51
- Cayey 51
- Ceiba 51
- Ciales 51
- Cidra 51
- Coamo 51
- Comerio 51
- Corozal 51
- Dorado 51
- Fajardo 51
- Florida 51
- Guanica 51
- Guayama 51
- …
state 1
- Puerto Rico · 4,045 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
270459 | 270459 | 2020-06-24 | Adjuntas | Puerto Rico | 72001 | 43 | |
270460 | 270460 | 2020-06-24 | Aguada | Puerto Rico | 72003 | 30 | |
270461 | 270461 | 2020-06-24 | Aguadilla | Puerto Rico | 72005 | 43 | |
270462 | 270462 | 2020-06-24 | Aguas Buenas | Puerto Rico | 72007 | 57 | |
270463 | 270463 | 2020-06-24 | Aibonito | Puerto Rico | 72009 | 41 | |
270464 | 270464 | 2020-06-24 | Anasco | Puerto Rico | 72011 | 37 | |
270465 | 270465 | 2020-06-24 | Arecibo | Puerto Rico | 72013 | 117 | |
270466 | 270466 | 2020-06-24 | Arroyo | Puerto Rico | 72015 | 29 | |
270467 | 270467 | 2020-06-24 | Barceloneta | Puerto Rico | 72017 | 26 | |
270468 | 270468 | 2020-06-24 | Barranquitas | Puerto Rico | 72019 | 74 | |
270469 | 270469 | 2020-06-24 | Bayamon | Puerto Rico | 72021 | 322 | |
270470 | 270470 | 2020-06-24 | Cabo Rojo | Puerto Rico | 72023 | 67 | |
270471 | 270471 | 2020-06-24 | Caguas | Puerto Rico | 72025 | 225 | |
270472 | 270472 | 2020-06-24 | Camuy | Puerto Rico | 72027 | 35 | |
270473 | 270473 | 2020-06-24 | Canovanas | Puerto Rico | 72029 | 105 | |
270474 | 270474 | 2020-06-24 | Carolina | Puerto Rico | 72031 | 307 | |
270475 | 270475 | 2020-06-24 | Catano | Puerto Rico | 72033 | 30 | |
270476 | 270476 | 2020-06-24 | Cayey | Puerto Rico | 72035 | 105 | |
270477 | 270477 | 2020-06-24 | Ceiba | Puerto Rico | 72037 | 25 | |
270478 | 270478 | 2020-06-24 | Ciales | Puerto Rico | 72039 | 55 | |
270479 | 270479 | 2020-06-24 | Cidra | Puerto Rico | 72041 | 71 | |
270480 | 270480 | 2020-06-24 | Coamo | Puerto Rico | 72043 | 41 | |
270481 | 270481 | 2020-06-24 | Comerio | Puerto Rico | 72045 | 32 | |
270482 | 270482 | 2020-06-24 | Corozal | Puerto Rico | 72047 | 48 | |
270483 | 270483 | 2020-06-24 | Culebra | Puerto Rico | 72049 | 2 | |
270484 | 270484 | 2020-06-24 | Dorado | Puerto Rico | 72051 | 91 | |
270485 | 270485 | 2020-06-24 | Fajardo | Puerto Rico | 72053 | 72 | |
270486 | 270486 | 2020-06-24 | Florida | Puerto Rico | 72054 | 31 | |
270487 | 270487 | 2020-06-24 | Guanica | Puerto Rico | 72055 | 30 | |
270488 | 270488 | 2020-06-24 | Guayama | Puerto Rico | 72057 | 66 | |
270489 | 270489 | 2020-06-24 | Guayanilla | Puerto Rico | 72059 | 49 | |
270490 | 270490 | 2020-06-24 | Guaynabo | Puerto Rico | 72061 | 308 | |
270491 | 270491 | 2020-06-24 | Gurabo | Puerto Rico | 72063 | 97 | |
270492 | 270492 | 2020-06-24 | Hatillo | Puerto Rico | 72065 | 30 | |
270493 | 270493 | 2020-06-24 | Hormigueros | Puerto Rico | 72067 | 29 | |
270494 | 270494 | 2020-06-24 | Humacao | Puerto Rico | 72069 | 80 | |
270495 | 270495 | 2020-06-24 | Isabela | Puerto Rico | 72071 | 36 | |
270496 | 270496 | 2020-06-24 | Jayuya | Puerto Rico | 72073 | 62 | |
270497 | 270497 | 2020-06-24 | Juana Diaz | Puerto Rico | 72075 | 58 | |
270498 | 270498 | 2020-06-24 | Juncos | Puerto Rico | 72077 | 46 | |
270499 | 270499 | 2020-06-24 | Lajas | Puerto Rico | 72079 | 42 | |
270500 | 270500 | 2020-06-24 | Lares | Puerto Rico | 72081 | 67 | |
270501 | 270501 | 2020-06-24 | Las Marias | Puerto Rico | 72083 | 13 | |
270502 | 270502 | 2020-06-24 | Las Piedras | Puerto Rico | 72085 | 62 | |
270503 | 270503 | 2020-06-24 | Loiza | Puerto Rico | 72087 | 40 | |
270504 | 270504 | 2020-06-24 | Luquillo | Puerto Rico | 72089 | 39 | |
270505 | 270505 | 2020-06-24 | Manati | Puerto Rico | 72091 | 38 | |
270506 | 270506 | 2020-06-24 | Maricao | Puerto Rico | 72093 | 16 | |
270507 | 270507 | 2020-06-24 | Maunabo | Puerto Rico | 72095 | 21 | |
270508 | 270508 | 2020-06-24 | Mayaguez | Puerto Rico | 72097 | 121 | |
270509 | 270509 | 2020-06-24 | Moca | Puerto Rico | 72099 | 42 | |
270510 | 270510 | 2020-06-24 | Morovis | Puerto Rico | 72101 | 61 | |
270511 | 270511 | 2020-06-24 | Naguabo | Puerto Rico | 72103 | 41 | |
270512 | 270512 | 2020-06-24 | Naranjito | Puerto Rico | 72105 | 69 | |
270513 | 270513 | 2020-06-24 | Orocovis | Puerto Rico | 72107 | 69 | |
270514 | 270514 | 2020-06-24 | Patillas | Puerto Rico | 72109 | 52 | |
270515 | 270515 | 2020-06-24 | Penuelas | Puerto Rico | 72111 | 18 | |
270516 | 270516 | 2020-06-24 | Ponce | Puerto Rico | 72113 | 169 | |
270517 | 270517 | 2020-06-24 | Quebradillas | Puerto Rico | 72115 | 37 | |
270518 | 270518 | 2020-06-24 | Rincon | Puerto Rico | 72117 | 25 | |
270519 | 270519 | 2020-06-24 | Rio Grande | Puerto Rico | 72119 | 86 | |
270520 | 270520 | 2020-06-24 | Sabana Grande | Puerto Rico | 72121 | 39 | |
270521 | 270521 | 2020-06-24 | Salinas | Puerto Rico | 72123 | 101 | |
270522 | 270522 | 2020-06-24 | San German | Puerto Rico | 72125 | 45 | |
270523 | 270523 | 2020-06-24 | San Juan | Puerto Rico | 72127 | 889 | |
270524 | 270524 | 2020-06-24 | San Lorenzo | Puerto Rico | 72129 | 63 | |
270525 | 270525 | 2020-06-24 | San Sebastian | Puerto Rico | 72131 | 78 | |
270526 | 270526 | 2020-06-24 | Santa Isabel | Puerto Rico | 72133 | 51 | |
270527 | 270527 | 2020-06-24 | Toa Alta | Puerto Rico | 72135 | 150 | |
270528 | 270528 | 2020-06-24 | Toa Baja | Puerto Rico | 72137 | 176 | |
270529 | 270529 | 2020-06-24 | Trujillo Alto | Puerto Rico | 72139 | 148 | |
270530 | 270530 | 2020-06-24 | Unknown | Puerto Rico | 560 | 149 | |
270531 | 270531 | 2020-06-24 | Utuado | Puerto Rico | 72141 | 13 | |
270532 | 270532 | 2020-06-24 | Vega Alta | Puerto Rico | 72143 | 73 | |
270533 | 270533 | 2020-06-24 | Vega Baja | Puerto Rico | 72145 | 78 | |
270534 | 270534 | 2020-06-24 | Vieques | Puerto Rico | 72147 | 20 | |
270535 | 270535 | 2020-06-24 | Villalba | Puerto Rico | 72149 | 43 | |
270536 | 270536 | 2020-06-24 | Yabucoa | Puerto Rico | 72151 | 32 | |
270537 | 270537 | 2020-06-24 | Yauco | Puerto Rico | 72153 | 81 | |
267325 | 267325 | 2020-06-23 | Adjuntas | Puerto Rico | 72001 | 43 | |
267326 | 267326 | 2020-06-23 | Aguada | Puerto Rico | 72003 | 30 | |
267327 | 267327 | 2020-06-23 | Aguadilla | Puerto Rico | 72005 | 39 | |
267328 | 267328 | 2020-06-23 | Aguas Buenas | Puerto Rico | 72007 | 56 | |
267329 | 267329 | 2020-06-23 | Aibonito | Puerto Rico | 72009 | 41 | |
267330 | 267330 | 2020-06-23 | Anasco | Puerto Rico | 72011 | 37 | |
267331 | 267331 | 2020-06-23 | Arecibo | Puerto Rico | 72013 | 115 | |
267332 | 267332 | 2020-06-23 | Arroyo | Puerto Rico | 72015 | 27 | |
267333 | 267333 | 2020-06-23 | Barceloneta | Puerto Rico | 72017 | 24 | |
267334 | 267334 | 2020-06-23 | Barranquitas | Puerto Rico | 72019 | 73 | |
267335 | 267335 | 2020-06-23 | Bayamon | Puerto Rico | 72021 | 322 | |
267336 | 267336 | 2020-06-23 | Cabo Rojo | Puerto Rico | 72023 | 67 | |
267337 | 267337 | 2020-06-23 | Caguas | Puerto Rico | 72025 | 223 | |
267338 | 267338 | 2020-06-23 | Camuy | Puerto Rico | 72027 | 35 | |
267339 | 267339 | 2020-06-23 | Canovanas | Puerto Rico | 72029 | 105 | |
267340 | 267340 | 2020-06-23 | Carolina | Puerto Rico | 72031 | 304 | |
267341 | 267341 | 2020-06-23 | Catano | Puerto Rico | 72033 | 30 | |
267342 | 267342 | 2020-06-23 | Cayey | Puerto Rico | 72035 | 103 | |
267343 | 267343 | 2020-06-23 | Ceiba | Puerto Rico | 72037 | 25 | |
267344 | 267344 | 2020-06-23 | Ciales | Puerto Rico | 72039 | 52 | |
267345 | 267345 | 2020-06-23 | Cidra | Puerto Rico | 72041 | 68 |
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);