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 305
- Coamo 252
- Comerio 252
- Corozal 252
- Dorado 252
- Fajardo 252
- Florida 252
- Guanica 252
- Guayama 252
- Guayanilla 252
- Guaynabo 252
- Gurabo 252
- Hatillo 252
- Hormigueros 252
- Humacao 252
- Isabela 252
- Jayuya 252
- Juana Diaz 252
- Juncos 252
- Lajas 252
- Lares 252
- Las Marias 252
- Las Piedras 252
- Loiza 252
- Luquillo 252
- Manati 252
- Maunabo 252
- Mayaguez 252
- Moca 252
- Morovis 252
- …
state 1
- Puerto Rico · 19,903 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919542 | 919542 | 2021-01-11 | Coamo | Puerto Rico | 72043 | 840 | |
919543 | 919543 | 2021-01-11 | Comerio | Puerto Rico | 72045 | 635 | |
919544 | 919544 | 2021-01-11 | Corozal | Puerto Rico | 72047 | 1498 | |
919545 | 919545 | 2021-01-11 | Culebra | Puerto Rico | 72049 | 28 | |
919546 | 919546 | 2021-01-11 | Dorado | Puerto Rico | 72051 | 1933 | |
919547 | 919547 | 2021-01-11 | Fajardo | Puerto Rico | 72053 | 1162 | |
919548 | 919548 | 2021-01-11 | Florida | Puerto Rico | 72054 | 642 | |
919549 | 919549 | 2021-01-11 | Guanica | Puerto Rico | 72055 | 231 | |
919550 | 919550 | 2021-01-11 | Guayama | Puerto Rico | 72057 | 710 | |
919551 | 919551 | 2021-01-11 | Guayanilla | Puerto Rico | 72059 | 360 | |
919552 | 919552 | 2021-01-11 | Guaynabo | Puerto Rico | 72061 | 3824 | |
919553 | 919553 | 2021-01-11 | Gurabo | Puerto Rico | 72063 | 1539 | |
919554 | 919554 | 2021-01-11 | Hatillo | Puerto Rico | 72065 | 904 | |
919555 | 919555 | 2021-01-11 | Hormigueros | Puerto Rico | 72067 | 357 | |
919556 | 919556 | 2021-01-11 | Humacao | Puerto Rico | 72069 | 1407 | |
919557 | 919557 | 2021-01-11 | Isabela | Puerto Rico | 72071 | 1031 | |
919558 | 919558 | 2021-01-11 | Jayuya | Puerto Rico | 72073 | 378 | |
919559 | 919559 | 2021-01-11 | Juana Diaz | Puerto Rico | 72075 | 908 | |
919560 | 919560 | 2021-01-11 | Juncos | Puerto Rico | 72077 | 1465 | |
919561 | 919561 | 2021-01-11 | Lajas | Puerto Rico | 72079 | 334 | |
919562 | 919562 | 2021-01-11 | Lares | Puerto Rico | 72081 | 783 | |
919563 | 919563 | 2021-01-11 | Las Marias | Puerto Rico | 72083 | 186 | |
919564 | 919564 | 2021-01-11 | Las Piedras | Puerto Rico | 72085 | 1169 | |
919565 | 919565 | 2021-01-11 | Loiza | Puerto Rico | 72087 | 822 | |
919566 | 919566 | 2021-01-11 | Luquillo | Puerto Rico | 72089 | 556 | |
919567 | 919567 | 2021-01-11 | Manati | Puerto Rico | 72091 | 1408 | |
919568 | 919568 | 2021-01-11 | Maricao | Puerto Rico | 72093 | 101 | |
919569 | 919569 | 2021-01-11 | Maunabo | Puerto Rico | 72095 | 299 | |
919570 | 919570 | 2021-01-11 | Mayaguez | Puerto Rico | 72097 | 1630 | |
919571 | 919571 | 2021-01-11 | Moca | Puerto Rico | 72099 | 1218 | |
919572 | 919572 | 2021-01-11 | Morovis | Puerto Rico | 72101 | 1173 | |
919573 | 919573 | 2021-01-11 | Naguabo | Puerto Rico | 72103 | 671 | |
919574 | 919574 | 2021-01-11 | Naranjito | Puerto Rico | 72105 | 1431 | |
919575 | 919575 | 2021-01-11 | Orocovis | Puerto Rico | 72107 | 704 | |
919576 | 919576 | 2021-01-11 | Patillas | Puerto Rico | 72109 | 327 | |
919577 | 919577 | 2021-01-11 | Penuelas | Puerto Rico | 72111 | 421 | |
919578 | 919578 | 2021-01-11 | Ponce | Puerto Rico | 72113 | 2435 | |
919579 | 919579 | 2021-01-11 | Quebradillas | Puerto Rico | 72115 | 611 | |
919580 | 919580 | 2021-01-11 | Rincon | Puerto Rico | 72117 | 379 | |
919581 | 919581 | 2021-01-11 | Rio Grande | Puerto Rico | 72119 | 1520 | |
919582 | 919582 | 2021-01-11 | Sabana Grande | Puerto Rico | 72121 | 346 | |
919583 | 919583 | 2021-01-11 | Salinas | Puerto Rico | 72123 | 941 | |
919584 | 919584 | 2021-01-11 | San German | Puerto Rico | 72125 | 525 | |
919585 | 919585 | 2021-01-11 | San Juan | Puerto Rico | 72127 | 16114 | |
919586 | 919586 | 2021-01-11 | San Lorenzo | Puerto Rico | 72129 | 1315 | |
919587 | 919587 | 2021-01-11 | San Sebastian | Puerto Rico | 72131 | 1517 | |
919588 | 919588 | 2021-01-11 | Santa Isabel | Puerto Rico | 72133 | 487 | |
919589 | 919589 | 2021-01-11 | Toa Alta | Puerto Rico | 72135 | 3234 | |
919590 | 919590 | 2021-01-11 | Toa Baja | Puerto Rico | 72137 | 3413 | |
919591 | 919591 | 2021-01-11 | Trujillo Alto | Puerto Rico | 72139 | 2559 | |
919592 | 919592 | 2021-01-11 | Unknown | Puerto Rico | 4016 | 1642 | |
919593 | 919593 | 2021-01-11 | Utuado | Puerto Rico | 72141 | 772 | |
919594 | 919594 | 2021-01-11 | Vega Alta | Puerto Rico | 72143 | 1629 | |
919595 | 919595 | 2021-01-11 | Vega Baja | Puerto Rico | 72145 | 2331 | |
919596 | 919596 | 2021-01-11 | Vieques | Puerto Rico | 72147 | 190 | |
919597 | 919597 | 2021-01-11 | Villalba | Puerto Rico | 72149 | 613 | |
919598 | 919598 | 2021-01-11 | Yabucoa | Puerto Rico | 72151 | 865 | |
919599 | 919599 | 2021-01-11 | Yauco | Puerto Rico | 72153 | 914 | |
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 |
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);