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 304
- Adjuntas 251
- Aguada 251
- Aguadilla 251
- Aguas Buenas 251
- Aibonito 251
- Anasco 251
- Arecibo 251
- Arroyo 251
- Barceloneta 251
- Barranquitas 251
- Bayamon 251
- Cabo Rojo 251
- Caguas 251
- Camuy 251
- Canovanas 251
- Carolina 251
- Catano 251
- Cayey 251
- Ceiba 251
- Ciales 251
- Cidra 251
- Coamo 251
- Comerio 251
- Corozal 251
- Dorado 251
- Fajardo 251
- Florida 251
- Guanica 251
- Guayama 251
- …
state 1
- Puerto Rico · 19,845 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
916276 | 916276 | 2021-01-10 | Adjuntas | Puerto Rico | 72001 | 430 | |
916277 | 916277 | 2021-01-10 | Aguada | Puerto Rico | 72003 | 990 | |
916278 | 916278 | 2021-01-10 | Aguadilla | Puerto Rico | 72005 | 1292 | |
916279 | 916279 | 2021-01-10 | Aguas Buenas | Puerto Rico | 72007 | 868 | |
916280 | 916280 | 2021-01-10 | Aibonito | Puerto Rico | 72009 | 465 | |
916281 | 916281 | 2021-01-10 | Anasco | Puerto Rico | 72011 | 699 | |
916282 | 916282 | 2021-01-10 | Arecibo | Puerto Rico | 72013 | 2495 | |
916283 | 916283 | 2021-01-10 | Arroyo | Puerto Rico | 72015 | 317 | |
916284 | 916284 | 2021-01-10 | Barceloneta | Puerto Rico | 72017 | 630 | |
916285 | 916285 | 2021-01-10 | Barranquitas | Puerto Rico | 72019 | 1051 | |
916286 | 916286 | 2021-01-10 | Bayamon | Puerto Rico | 72021 | 8696 | |
916287 | 916287 | 2021-01-10 | Cabo Rojo | Puerto Rico | 72023 | 794 | |
916288 | 916288 | 2021-01-10 | Caguas | Puerto Rico | 72025 | 4811 | |
916289 | 916289 | 2021-01-10 | Camuy | Puerto Rico | 72027 | 967 | |
916290 | 916290 | 2021-01-10 | Canovanas | Puerto Rico | 72029 | 1541 | |
916291 | 916291 | 2021-01-10 | Carolina | Puerto Rico | 72031 | 6947 | |
916292 | 916292 | 2021-01-10 | Catano | Puerto Rico | 72033 | 1060 | |
916293 | 916293 | 2021-01-10 | Cayey | Puerto Rico | 72035 | 1115 | |
916294 | 916294 | 2021-01-10 | Ceiba | Puerto Rico | 72037 | 338 | |
916295 | 916295 | 2021-01-10 | Ciales | Puerto Rico | 72039 | 618 | |
916296 | 916296 | 2021-01-10 | Cidra | Puerto Rico | 72041 | 1018 | |
916297 | 916297 | 2021-01-10 | Coamo | Puerto Rico | 72043 | 835 | |
916298 | 916298 | 2021-01-10 | Comerio | Puerto Rico | 72045 | 635 | |
916299 | 916299 | 2021-01-10 | Corozal | Puerto Rico | 72047 | 1492 | |
916300 | 916300 | 2021-01-10 | Culebra | Puerto Rico | 72049 | 28 | |
916301 | 916301 | 2021-01-10 | Dorado | Puerto Rico | 72051 | 1930 | |
916302 | 916302 | 2021-01-10 | Fajardo | Puerto Rico | 72053 | 1159 | |
916303 | 916303 | 2021-01-10 | Florida | Puerto Rico | 72054 | 642 | |
916304 | 916304 | 2021-01-10 | Guanica | Puerto Rico | 72055 | 231 | |
916305 | 916305 | 2021-01-10 | Guayama | Puerto Rico | 72057 | 704 | |
916306 | 916306 | 2021-01-10 | Guayanilla | Puerto Rico | 72059 | 358 | |
916307 | 916307 | 2021-01-10 | Guaynabo | Puerto Rico | 72061 | 3812 | |
916308 | 916308 | 2021-01-10 | Gurabo | Puerto Rico | 72063 | 1538 | |
916309 | 916309 | 2021-01-10 | Hatillo | Puerto Rico | 72065 | 904 | |
916310 | 916310 | 2021-01-10 | Hormigueros | Puerto Rico | 72067 | 357 | |
916311 | 916311 | 2021-01-10 | Humacao | Puerto Rico | 72069 | 1404 | |
916312 | 916312 | 2021-01-10 | Isabela | Puerto Rico | 72071 | 1029 | |
916313 | 916313 | 2021-01-10 | Jayuya | Puerto Rico | 72073 | 377 | |
916314 | 916314 | 2021-01-10 | Juana Diaz | Puerto Rico | 72075 | 900 | |
916315 | 916315 | 2021-01-10 | Juncos | Puerto Rico | 72077 | 1466 | |
916316 | 916316 | 2021-01-10 | Lajas | Puerto Rico | 72079 | 333 | |
916317 | 916317 | 2021-01-10 | Lares | Puerto Rico | 72081 | 783 | |
916318 | 916318 | 2021-01-10 | Las Marias | Puerto Rico | 72083 | 186 | |
916319 | 916319 | 2021-01-10 | Las Piedras | Puerto Rico | 72085 | 1167 | |
916320 | 916320 | 2021-01-10 | Loiza | Puerto Rico | 72087 | 818 | |
916321 | 916321 | 2021-01-10 | Luquillo | Puerto Rico | 72089 | 555 | |
916322 | 916322 | 2021-01-10 | Manati | Puerto Rico | 72091 | 1406 | |
916323 | 916323 | 2021-01-10 | Maricao | Puerto Rico | 72093 | 101 | |
916324 | 916324 | 2021-01-10 | Maunabo | Puerto Rico | 72095 | 298 | |
916325 | 916325 | 2021-01-10 | Mayaguez | Puerto Rico | 72097 | 1623 | |
916326 | 916326 | 2021-01-10 | Moca | Puerto Rico | 72099 | 1216 | |
916327 | 916327 | 2021-01-10 | Morovis | Puerto Rico | 72101 | 1171 | |
916328 | 916328 | 2021-01-10 | Naguabo | Puerto Rico | 72103 | 671 | |
916329 | 916329 | 2021-01-10 | Naranjito | Puerto Rico | 72105 | 1428 | |
916330 | 916330 | 2021-01-10 | Orocovis | Puerto Rico | 72107 | 702 | |
916331 | 916331 | 2021-01-10 | Patillas | Puerto Rico | 72109 | 327 | |
916332 | 916332 | 2021-01-10 | Penuelas | Puerto Rico | 72111 | 418 | |
916333 | 916333 | 2021-01-10 | Ponce | Puerto Rico | 72113 | 2408 | |
916334 | 916334 | 2021-01-10 | Quebradillas | Puerto Rico | 72115 | 610 | |
916335 | 916335 | 2021-01-10 | Rincon | Puerto Rico | 72117 | 379 | |
916336 | 916336 | 2021-01-10 | Rio Grande | Puerto Rico | 72119 | 1517 | |
916337 | 916337 | 2021-01-10 | Sabana Grande | Puerto Rico | 72121 | 344 | |
916338 | 916338 | 2021-01-10 | Salinas | Puerto Rico | 72123 | 941 | |
916339 | 916339 | 2021-01-10 | San German | Puerto Rico | 72125 | 523 | |
916340 | 916340 | 2021-01-10 | San Juan | Puerto Rico | 72127 | 16059 | |
916341 | 916341 | 2021-01-10 | San Lorenzo | Puerto Rico | 72129 | 1314 | |
916342 | 916342 | 2021-01-10 | San Sebastian | Puerto Rico | 72131 | 1516 | |
916343 | 916343 | 2021-01-10 | Santa Isabel | Puerto Rico | 72133 | 485 | |
916344 | 916344 | 2021-01-10 | Toa Alta | Puerto Rico | 72135 | 3227 | |
916345 | 916345 | 2021-01-10 | Toa Baja | Puerto Rico | 72137 | 3409 | |
916346 | 916346 | 2021-01-10 | Trujillo Alto | Puerto Rico | 72139 | 2551 | |
916347 | 916347 | 2021-01-10 | Unknown | Puerto Rico | 4016 | 1630 | |
916348 | 916348 | 2021-01-10 | Utuado | Puerto Rico | 72141 | 768 | |
916349 | 916349 | 2021-01-10 | Vega Alta | Puerto Rico | 72143 | 1626 | |
916350 | 916350 | 2021-01-10 | Vega Baja | Puerto Rico | 72145 | 2324 | |
916351 | 916351 | 2021-01-10 | Vieques | Puerto Rico | 72147 | 189 | |
916352 | 916352 | 2021-01-10 | Villalba | Puerto Rico | 72149 | 609 | |
916353 | 916353 | 2021-01-10 | Yabucoa | Puerto Rico | 72151 | 859 | |
916354 | 916354 | 2021-01-10 | Yauco | Puerto Rico | 72153 | 914 | |
913031 | 913031 | 2021-01-09 | Adjuntas | Puerto Rico | 72001 | 421 | |
913032 | 913032 | 2021-01-09 | Aguada | Puerto Rico | 72003 | 990 | |
913033 | 913033 | 2021-01-09 | Aguadilla | Puerto Rico | 72005 | 1292 | |
913034 | 913034 | 2021-01-09 | Aguas Buenas | Puerto Rico | 72007 | 865 | |
913035 | 913035 | 2021-01-09 | Aibonito | Puerto Rico | 72009 | 464 | |
913036 | 913036 | 2021-01-09 | Anasco | Puerto Rico | 72011 | 697 | |
913037 | 913037 | 2021-01-09 | Arecibo | Puerto Rico | 72013 | 2483 | |
913038 | 913038 | 2021-01-09 | Arroyo | Puerto Rico | 72015 | 316 | |
913039 | 913039 | 2021-01-09 | Barceloneta | Puerto Rico | 72017 | 629 | |
913040 | 913040 | 2021-01-09 | Barranquitas | Puerto Rico | 72019 | 1047 | |
913041 | 913041 | 2021-01-09 | Bayamon | Puerto Rico | 72021 | 8661 | |
913042 | 913042 | 2021-01-09 | Cabo Rojo | Puerto Rico | 72023 | 790 | |
913043 | 913043 | 2021-01-09 | Caguas | Puerto Rico | 72025 | 4797 | |
913044 | 913044 | 2021-01-09 | Camuy | Puerto Rico | 72027 | 966 | |
913045 | 913045 | 2021-01-09 | Canovanas | Puerto Rico | 72029 | 1531 | |
913046 | 913046 | 2021-01-09 | Carolina | Puerto Rico | 72031 | 6935 | |
913047 | 913047 | 2021-01-09 | Catano | Puerto Rico | 72033 | 1054 | |
913048 | 913048 | 2021-01-09 | Cayey | Puerto Rico | 72035 | 1110 | |
913049 | 913049 | 2021-01-09 | Ceiba | Puerto Rico | 72037 | 338 | |
913050 | 913050 | 2021-01-09 | Ciales | Puerto Rico | 72039 | 617 | |
913051 | 913051 | 2021-01-09 | Cidra | Puerto Rico | 72041 | 1009 |
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);