ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2021-10-17 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adjuntas 1
- Aguada 1
- Aguadilla 1
- Aguas Buenas 1
- Aibonito 1
- Anasco 1
- Arecibo 1
- Arroyo 1
- Barceloneta 1
- Barranquitas 1
- Bayamon 1
- Cabo Rojo 1
- Caguas 1
- Camuy 1
- Canovanas 1
- Carolina 1
- Catano 1
- Cayey 1
- Ceiba 1
- Ciales 1
- Cidra 1
- Coamo 1
- Comerio 1
- Corozal 1
- Culebra 1
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- …
state 1
- Puerto Rico · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1825444 | 1825444 | 2021-10-17 | Adjuntas | Puerto Rico | 72001 | 669 | |
1825445 | 1825445 | 2021-10-17 | Aguada | Puerto Rico | 72003 | 2420 | |
1825446 | 1825446 | 2021-10-17 | Aguadilla | Puerto Rico | 72005 | 3041 | |
1825447 | 1825447 | 2021-10-17 | Aguas Buenas | Puerto Rico | 72007 | 1631 | |
1825448 | 1825448 | 2021-10-17 | Aibonito | Puerto Rico | 72009 | 1027 | |
1825449 | 1825449 | 2021-10-17 | Anasco | Puerto Rico | 72011 | 1422 | |
1825450 | 1825450 | 2021-10-17 | Arecibo | Puerto Rico | 72013 | 4600 | |
1825451 | 1825451 | 2021-10-17 | Arroyo | Puerto Rico | 72015 | 545 | |
1825452 | 1825452 | 2021-10-17 | Barceloneta | Puerto Rico | 72017 | 1185 | |
1825453 | 1825453 | 2021-10-17 | Barranquitas | Puerto Rico | 72019 | 1862 | |
1825454 | 1825454 | 2021-10-17 | Bayamon | Puerto Rico | 72021 | 15725 | |
1825455 | 1825455 | 2021-10-17 | Cabo Rojo | Puerto Rico | 72023 | 1906 | |
1825456 | 1825456 | 2021-10-17 | Caguas | Puerto Rico | 72025 | 8900 | |
1825457 | 1825457 | 2021-10-17 | Camuy | Puerto Rico | 72027 | 1775 | |
1825458 | 1825458 | 2021-10-17 | Canovanas | Puerto Rico | 72029 | 3075 | |
1825459 | 1825459 | 2021-10-17 | Carolina | Puerto Rico | 72031 | 12964 | |
1825460 | 1825460 | 2021-10-17 | Catano | Puerto Rico | 72033 | 1917 | |
1825461 | 1825461 | 2021-10-17 | Cayey | Puerto Rico | 72035 | 2011 | |
1825462 | 1825462 | 2021-10-17 | Ceiba | Puerto Rico | 72037 | 664 | |
1825463 | 1825463 | 2021-10-17 | Ciales | Puerto Rico | 72039 | 1070 | |
1825464 | 1825464 | 2021-10-17 | Cidra | Puerto Rico | 72041 | 1897 | |
1825465 | 1825465 | 2021-10-17 | Coamo | Puerto Rico | 72043 | 1411 | |
1825466 | 1825466 | 2021-10-17 | Comerio | Puerto Rico | 72045 | 1059 | |
1825467 | 1825467 | 2021-10-17 | Corozal | Puerto Rico | 72047 | 2452 | |
1825468 | 1825468 | 2021-10-17 | Culebra | Puerto Rico | 72049 | 56 | |
1825469 | 1825469 | 2021-10-17 | Dorado | Puerto Rico | 72051 | 3373 | |
1825470 | 1825470 | 2021-10-17 | Fajardo | Puerto Rico | 72053 | 2168 | |
1825471 | 1825471 | 2021-10-17 | Florida | Puerto Rico | 72054 | 996 | |
1825472 | 1825472 | 2021-10-17 | Guanica | Puerto Rico | 72055 | 443 | |
1825473 | 1825473 | 2021-10-17 | Guayama | Puerto Rico | 72057 | 1348 | |
1825474 | 1825474 | 2021-10-17 | Guayanilla | Puerto Rico | 72059 | 679 | |
1825475 | 1825475 | 2021-10-17 | Guaynabo | Puerto Rico | 72061 | 6806 | |
1825476 | 1825476 | 2021-10-17 | Gurabo | Puerto Rico | 72063 | 3049 | |
1825477 | 1825477 | 2021-10-17 | Hatillo | Puerto Rico | 72065 | 1882 | |
1825478 | 1825478 | 2021-10-17 | Hormigueros | Puerto Rico | 72067 | 697 | |
1825479 | 1825479 | 2021-10-17 | Humacao | Puerto Rico | 72069 | 3024 | |
1825480 | 1825480 | 2021-10-17 | Isabela | Puerto Rico | 72071 | 2534 | |
1825481 | 1825481 | 2021-10-17 | Jayuya | Puerto Rico | 72073 | 650 | |
1825482 | 1825482 | 2021-10-17 | Juana Diaz | Puerto Rico | 72075 | 1750 | |
1825483 | 1825483 | 2021-10-17 | Juncos | Puerto Rico | 72077 | 2984 | |
1825484 | 1825484 | 2021-10-17 | Lajas | Puerto Rico | 72079 | 810 | |
1825485 | 1825485 | 2021-10-17 | Lares | Puerto Rico | 72081 | 1403 | |
1825486 | 1825486 | 2021-10-17 | Las Marias | Puerto Rico | 72083 | 404 | |
1825487 | 1825487 | 2021-10-17 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1825488 | 1825488 | 2021-10-17 | Loiza | Puerto Rico | 72087 | 1731 | |
1825489 | 1825489 | 2021-10-17 | Luquillo | Puerto Rico | 72089 | 1241 | |
1825490 | 1825490 | 2021-10-17 | Manati | Puerto Rico | 72091 | 2340 | |
1825491 | 1825491 | 2021-10-17 | Maricao | Puerto Rico | 72093 | 178 | |
1825492 | 1825492 | 2021-10-17 | Maunabo | Puerto Rico | 72095 | 559 | |
1825493 | 1825493 | 2021-10-17 | Mayaguez | Puerto Rico | 72097 | 3870 | |
1825494 | 1825494 | 2021-10-17 | Moca | Puerto Rico | 72099 | 2416 | |
1825495 | 1825495 | 2021-10-17 | Morovis | Puerto Rico | 72101 | 1975 | |
1825496 | 1825496 | 2021-10-17 | Naguabo | Puerto Rico | 72103 | 1489 | |
1825497 | 1825497 | 2021-10-17 | Naranjito | Puerto Rico | 72105 | 2376 | |
1825498 | 1825498 | 2021-10-17 | Orocovis | Puerto Rico | 72107 | 1204 | |
1825499 | 1825499 | 2021-10-17 | Patillas | Puerto Rico | 72109 | 557 | |
1825500 | 1825500 | 2021-10-17 | Penuelas | Puerto Rico | 72111 | 783 | |
1825501 | 1825501 | 2021-10-17 | Ponce | Puerto Rico | 72113 | 5585 | |
1825502 | 1825502 | 2021-10-17 | Quebradillas | Puerto Rico | 72115 | 1346 | |
1825503 | 1825503 | 2021-10-17 | Rincon | Puerto Rico | 72117 | 920 | |
1825504 | 1825504 | 2021-10-17 | Rio Grande | Puerto Rico | 72119 | 3258 | |
1825505 | 1825505 | 2021-10-17 | Sabana Grande | Puerto Rico | 72121 | 761 | |
1825506 | 1825506 | 2021-10-17 | Salinas | Puerto Rico | 72123 | 1434 | |
1825507 | 1825507 | 2021-10-17 | San German | Puerto Rico | 72125 | 1124 | |
1825508 | 1825508 | 2021-10-17 | San Juan | Puerto Rico | 72127 | 28751 | |
1825509 | 1825509 | 2021-10-17 | San Lorenzo | Puerto Rico | 72129 | 2400 | |
1825510 | 1825510 | 2021-10-17 | San Sebastian | Puerto Rico | 72131 | 2508 | |
1825511 | 1825511 | 2021-10-17 | Santa Isabel | Puerto Rico | 72133 | 853 | |
1825512 | 1825512 | 2021-10-17 | Toa Alta | Puerto Rico | 72135 | 5710 | |
1825513 | 1825513 | 2021-10-17 | Toa Baja | Puerto Rico | 72137 | 6120 | |
1825514 | 1825514 | 2021-10-17 | Trujillo Alto | Puerto Rico | 72139 | 4548 | |
1825515 | 1825515 | 2021-10-17 | Unknown | Puerto Rico | 5386 | 3207 | |
1825516 | 1825516 | 2021-10-17 | Utuado | Puerto Rico | 72141 | 1367 | |
1825517 | 1825517 | 2021-10-17 | Vega Alta | Puerto Rico | 72143 | 2919 | |
1825518 | 1825518 | 2021-10-17 | Vega Baja | Puerto Rico | 72145 | 4402 | |
1825519 | 1825519 | 2021-10-17 | Vieques | Puerto Rico | 72147 | 268 | |
1825520 | 1825520 | 2021-10-17 | Villalba | Puerto Rico | 72149 | 1016 | |
1825521 | 1825521 | 2021-10-17 | Yabucoa | Puerto Rico | 72151 | 1629 | |
1825522 | 1825522 | 2021-10-17 | Yauco | Puerto Rico | 72153 | 1445 |
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);