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 390
- Adjuntas 337
- Aguada 337
- Aguadilla 337
- Aguas Buenas 337
- Aibonito 337
- Anasco 337
- Arecibo 337
- Arroyo 337
- Barceloneta 337
- Barranquitas 337
- Bayamon 337
- Cabo Rojo 337
- Caguas 337
- Camuy 337
- Canovanas 337
- Carolina 337
- Catano 337
- Cayey 337
- Ceiba 337
- Ciales 337
- Cidra 337
- Coamo 337
- Comerio 337
- Corozal 337
- Dorado 337
- Fajardo 337
- Florida 337
- Guanica 337
- Guayama 337
- …
state 1
- Puerto Rico · 26,639 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195439 | 1195439 | 2021-04-06 | Adjuntas | Puerto Rico | 72001 | 493 | |
1195440 | 1195440 | 2021-04-06 | Aguada | Puerto Rico | 72003 | 1287 | |
1195441 | 1195441 | 2021-04-06 | Aguadilla | Puerto Rico | 72005 | 1632 | |
1195442 | 1195442 | 2021-04-06 | Aguas Buenas | Puerto Rico | 72007 | 1078 | |
1195443 | 1195443 | 2021-04-06 | Aibonito | Puerto Rico | 72009 | 636 | |
1195444 | 1195444 | 2021-04-06 | Anasco | Puerto Rico | 72011 | 856 | |
1195445 | 1195445 | 2021-04-06 | Arecibo | Puerto Rico | 72013 | 3056 | |
1195446 | 1195446 | 2021-04-06 | Arroyo | Puerto Rico | 72015 | 367 | |
1195447 | 1195447 | 2021-04-06 | Barceloneta | Puerto Rico | 72017 | 774 | |
1195448 | 1195448 | 2021-04-06 | Barranquitas | Puerto Rico | 72019 | 1367 | |
1195449 | 1195449 | 2021-04-06 | Bayamon | Puerto Rico | 72021 | 10719 | |
1195450 | 1195450 | 2021-04-06 | Cabo Rojo | Puerto Rico | 72023 | 982 | |
1195451 | 1195451 | 2021-04-06 | Caguas | Puerto Rico | 72025 | 6085 | |
1195452 | 1195452 | 2021-04-06 | Camuy | Puerto Rico | 72027 | 1217 | |
1195453 | 1195453 | 2021-04-06 | Canovanas | Puerto Rico | 72029 | 1916 | |
1195454 | 1195454 | 2021-04-06 | Carolina | Puerto Rico | 72031 | 8539 | |
1195455 | 1195455 | 2021-04-06 | Catano | Puerto Rico | 72033 | 1275 | |
1195456 | 1195456 | 2021-04-06 | Cayey | Puerto Rico | 72035 | 1412 | |
1195457 | 1195457 | 2021-04-06 | Ceiba | Puerto Rico | 72037 | 420 | |
1195458 | 1195458 | 2021-04-06 | Ciales | Puerto Rico | 72039 | 800 | |
1195459 | 1195459 | 2021-04-06 | Cidra | Puerto Rico | 72041 | 1289 | |
1195460 | 1195460 | 2021-04-06 | Coamo | Puerto Rico | 72043 | 1010 | |
1195461 | 1195461 | 2021-04-06 | Comerio | Puerto Rico | 72045 | 735 | |
1195462 | 1195462 | 2021-04-06 | Corozal | Puerto Rico | 72047 | 1708 | |
1195463 | 1195463 | 2021-04-06 | Culebra | Puerto Rico | 72049 | 29 | |
1195464 | 1195464 | 2021-04-06 | Dorado | Puerto Rico | 72051 | 2271 | |
1195465 | 1195465 | 2021-04-06 | Fajardo | Puerto Rico | 72053 | 1334 | |
1195466 | 1195466 | 2021-04-06 | Florida | Puerto Rico | 72054 | 713 | |
1195467 | 1195467 | 2021-04-06 | Guanica | Puerto Rico | 72055 | 263 | |
1195468 | 1195468 | 2021-04-06 | Guayama | Puerto Rico | 72057 | 912 | |
1195469 | 1195469 | 2021-04-06 | Guayanilla | Puerto Rico | 72059 | 468 | |
1195470 | 1195470 | 2021-04-06 | Guaynabo | Puerto Rico | 72061 | 4589 | |
1195471 | 1195471 | 2021-04-06 | Gurabo | Puerto Rico | 72063 | 2019 | |
1195472 | 1195472 | 2021-04-06 | Hatillo | Puerto Rico | 72065 | 1176 | |
1195473 | 1195473 | 2021-04-06 | Hormigueros | Puerto Rico | 72067 | 439 | |
1195474 | 1195474 | 2021-04-06 | Humacao | Puerto Rico | 72069 | 1833 | |
1195475 | 1195475 | 2021-04-06 | Isabela | Puerto Rico | 72071 | 1298 | |
1195476 | 1195476 | 2021-04-06 | Jayuya | Puerto Rico | 72073 | 448 | |
1195477 | 1195477 | 2021-04-06 | Juana Diaz | Puerto Rico | 72075 | 1205 | |
1195478 | 1195478 | 2021-04-06 | Juncos | Puerto Rico | 72077 | 1969 | |
1195479 | 1195479 | 2021-04-06 | Lajas | Puerto Rico | 72079 | 446 | |
1195480 | 1195480 | 2021-04-06 | Lares | Puerto Rico | 72081 | 978 | |
1195481 | 1195481 | 2021-04-06 | Las Marias | Puerto Rico | 72083 | 216 | |
1195482 | 1195482 | 2021-04-06 | Las Piedras | Puerto Rico | 72085 | 1593 | |
1195483 | 1195483 | 2021-04-06 | Loiza | Puerto Rico | 72087 | 1082 | |
1195484 | 1195484 | 2021-04-06 | Luquillo | Puerto Rico | 72089 | 693 | |
1195485 | 1195485 | 2021-04-06 | Manati | Puerto Rico | 72091 | 1621 | |
1195486 | 1195486 | 2021-04-06 | Maricao | Puerto Rico | 72093 | 120 | |
1195487 | 1195487 | 2021-04-06 | Maunabo | Puerto Rico | 72095 | 338 | |
1195488 | 1195488 | 2021-04-06 | Mayaguez | Puerto Rico | 72097 | 2081 | |
1195489 | 1195489 | 2021-04-06 | Moca | Puerto Rico | 72099 | 1470 | |
1195490 | 1195490 | 2021-04-06 | Morovis | Puerto Rico | 72101 | 1426 | |
1195491 | 1195491 | 2021-04-06 | Naguabo | Puerto Rico | 72103 | 869 | |
1195492 | 1195492 | 2021-04-06 | Naranjito | Puerto Rico | 72105 | 1692 | |
1195493 | 1195493 | 2021-04-06 | Orocovis | Puerto Rico | 72107 | 927 | |
1195494 | 1195494 | 2021-04-06 | Patillas | Puerto Rico | 72109 | 395 | |
1195495 | 1195495 | 2021-04-06 | Penuelas | Puerto Rico | 72111 | 555 | |
1195496 | 1195496 | 2021-04-06 | Ponce | Puerto Rico | 72113 | 3362 | |
1195497 | 1195497 | 2021-04-06 | Quebradillas | Puerto Rico | 72115 | 783 | |
1195498 | 1195498 | 2021-04-06 | Rincon | Puerto Rico | 72117 | 488 | |
1195499 | 1195499 | 2021-04-06 | Rio Grande | Puerto Rico | 72119 | 1945 | |
1195500 | 1195500 | 2021-04-06 | Sabana Grande | Puerto Rico | 72121 | 442 | |
1195501 | 1195501 | 2021-04-06 | Salinas | Puerto Rico | 72123 | 1072 | |
1195502 | 1195502 | 2021-04-06 | San German | Puerto Rico | 72125 | 636 | |
1195503 | 1195503 | 2021-04-06 | San Juan | Puerto Rico | 72127 | 19157 | |
1195504 | 1195504 | 2021-04-06 | San Lorenzo | Puerto Rico | 72129 | 1674 | |
1195505 | 1195505 | 2021-04-06 | San Sebastian | Puerto Rico | 72131 | 1741 | |
1195506 | 1195506 | 2021-04-06 | Santa Isabel | Puerto Rico | 72133 | 594 | |
1195507 | 1195507 | 2021-04-06 | Toa Alta | Puerto Rico | 72135 | 4006 | |
1195508 | 1195508 | 2021-04-06 | Toa Baja | Puerto Rico | 72137 | 4070 | |
1195509 | 1195509 | 2021-04-06 | Trujillo Alto | Puerto Rico | 72139 | 3087 | |
1195510 | 1195510 | 2021-04-06 | Unknown | Puerto Rico | 4691 | 2136 | |
1195511 | 1195511 | 2021-04-06 | Utuado | Puerto Rico | 72141 | 925 | |
1195512 | 1195512 | 2021-04-06 | Vega Alta | Puerto Rico | 72143 | 1892 | |
1195513 | 1195513 | 2021-04-06 | Vega Baja | Puerto Rico | 72145 | 2832 | |
1195514 | 1195514 | 2021-04-06 | Vieques | Puerto Rico | 72147 | 202 | |
1195515 | 1195515 | 2021-04-06 | Villalba | Puerto Rico | 72149 | 796 | |
1195516 | 1195516 | 2021-04-06 | Yabucoa | Puerto Rico | 72151 | 1083 | |
1195517 | 1195517 | 2021-04-06 | Yauco | Puerto Rico | 72153 | 1038 | |
1192191 | 1192191 | 2021-04-05 | Adjuntas | Puerto Rico | 72001 | 493 | |
1192192 | 1192192 | 2021-04-05 | Aguada | Puerto Rico | 72003 | 1287 | |
1192193 | 1192193 | 2021-04-05 | Aguadilla | Puerto Rico | 72005 | 1631 | |
1192194 | 1192194 | 2021-04-05 | Aguas Buenas | Puerto Rico | 72007 | 1077 | |
1192195 | 1192195 | 2021-04-05 | Aibonito | Puerto Rico | 72009 | 632 | |
1192196 | 1192196 | 2021-04-05 | Anasco | Puerto Rico | 72011 | 856 | |
1192197 | 1192197 | 2021-04-05 | Arecibo | Puerto Rico | 72013 | 3056 | |
1192198 | 1192198 | 2021-04-05 | Arroyo | Puerto Rico | 72015 | 367 | |
1192199 | 1192199 | 2021-04-05 | Barceloneta | Puerto Rico | 72017 | 774 | |
1192200 | 1192200 | 2021-04-05 | Barranquitas | Puerto Rico | 72019 | 1365 | |
1192201 | 1192201 | 2021-04-05 | Bayamon | Puerto Rico | 72021 | 10707 | |
1192202 | 1192202 | 2021-04-05 | Cabo Rojo | Puerto Rico | 72023 | 976 | |
1192203 | 1192203 | 2021-04-05 | Caguas | Puerto Rico | 72025 | 6076 | |
1192204 | 1192204 | 2021-04-05 | Camuy | Puerto Rico | 72027 | 1212 | |
1192205 | 1192205 | 2021-04-05 | Canovanas | Puerto Rico | 72029 | 1916 | |
1192206 | 1192206 | 2021-04-05 | Carolina | Puerto Rico | 72031 | 8527 | |
1192207 | 1192207 | 2021-04-05 | Catano | Puerto Rico | 72033 | 1274 | |
1192208 | 1192208 | 2021-04-05 | Cayey | Puerto Rico | 72035 | 1404 | |
1192209 | 1192209 | 2021-04-05 | Ceiba | Puerto Rico | 72037 | 420 | |
1192210 | 1192210 | 2021-04-05 | Ciales | Puerto Rico | 72039 | 800 | |
1192211 | 1192211 | 2021-04-05 | Cidra | Puerto Rico | 72041 | 1286 |
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);