ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-07-16" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
---|---|---|---|---|---|---|---|
1523334 | 1523334 | 2021-07-16 | Adjuntas | Puerto Rico | 72001 | 554 | |
1523335 | 1523335 | 2021-07-16 | Aguada | Puerto Rico | 72003 | 1569 | |
1523336 | 1523336 | 2021-07-16 | Aguadilla | Puerto Rico | 72005 | 1927 | |
1523337 | 1523337 | 2021-07-16 | Aguas Buenas | Puerto Rico | 72007 | 1395 | |
1523338 | 1523338 | 2021-07-16 | Aibonito | Puerto Rico | 72009 | 816 | |
1523339 | 1523339 | 2021-07-16 | Anasco | Puerto Rico | 72011 | 1002 | |
1523340 | 1523340 | 2021-07-16 | Arecibo | Puerto Rico | 72013 | 3591 | |
1523341 | 1523341 | 2021-07-16 | Arroyo | Puerto Rico | 72015 | 468 | |
1523342 | 1523342 | 2021-07-16 | Barceloneta | Puerto Rico | 72017 | 943 | |
1523343 | 1523343 | 2021-07-16 | Barranquitas | Puerto Rico | 72019 | 1618 | |
1523344 | 1523344 | 2021-07-16 | Bayamon | Puerto Rico | 72021 | 12755 | |
1523345 | 1523345 | 2021-07-16 | Cabo Rojo | Puerto Rico | 72023 | 1299 | |
1523346 | 1523346 | 2021-07-16 | Caguas | Puerto Rico | 72025 | 7392 | |
1523347 | 1523347 | 2021-07-16 | Camuy | Puerto Rico | 72027 | 1433 | |
1523348 | 1523348 | 2021-07-16 | Canovanas | Puerto Rico | 72029 | 2410 | |
1523349 | 1523349 | 2021-07-16 | Carolina | Puerto Rico | 72031 | 10406 | |
1523350 | 1523350 | 2021-07-16 | Catano | Puerto Rico | 72033 | 1556 | |
1523351 | 1523351 | 2021-07-16 | Cayey | Puerto Rico | 72035 | 1642 | |
1523352 | 1523352 | 2021-07-16 | Ceiba | Puerto Rico | 72037 | 530 | |
1523353 | 1523353 | 2021-07-16 | Ciales | Puerto Rico | 72039 | 933 | |
1523354 | 1523354 | 2021-07-16 | Cidra | Puerto Rico | 72041 | 1527 | |
1523355 | 1523355 | 2021-07-16 | Coamo | Puerto Rico | 72043 | 1177 | |
1523356 | 1523356 | 2021-07-16 | Comerio | Puerto Rico | 72045 | 880 | |
1523357 | 1523357 | 2021-07-16 | Corozal | Puerto Rico | 72047 | 2086 | |
1523358 | 1523358 | 2021-07-16 | Culebra | Puerto Rico | 72049 | 44 | |
1523359 | 1523359 | 2021-07-16 | Dorado | Puerto Rico | 72051 | 2700 | |
1523360 | 1523360 | 2021-07-16 | Fajardo | Puerto Rico | 72053 | 1699 | |
1523361 | 1523361 | 2021-07-16 | Florida | Puerto Rico | 72054 | 882 | |
1523362 | 1523362 | 2021-07-16 | Guanica | Puerto Rico | 72055 | 344 | |
1523363 | 1523363 | 2021-07-16 | Guayama | Puerto Rico | 72057 | 1104 | |
1523364 | 1523364 | 2021-07-16 | Guayanilla | Puerto Rico | 72059 | 581 | |
1523365 | 1523365 | 2021-07-16 | Guaynabo | Puerto Rico | 72061 | 5354 | |
1523366 | 1523366 | 2021-07-16 | Gurabo | Puerto Rico | 72063 | 2553 | |
1523367 | 1523367 | 2021-07-16 | Hatillo | Puerto Rico | 72065 | 1376 | |
1523368 | 1523368 | 2021-07-16 | Hormigueros | Puerto Rico | 72067 | 534 | |
1523369 | 1523369 | 2021-07-16 | Humacao | Puerto Rico | 72069 | 2535 | |
1523370 | 1523370 | 2021-07-16 | Isabela | Puerto Rico | 72071 | 1662 | |
1523371 | 1523371 | 2021-07-16 | Jayuya | Puerto Rico | 72073 | 595 | |
1523372 | 1523372 | 2021-07-16 | Juana Diaz | Puerto Rico | 72075 | 1406 | |
1523373 | 1523373 | 2021-07-16 | Juncos | Puerto Rico | 72077 | 2551 | |
1523374 | 1523374 | 2021-07-16 | Lajas | Puerto Rico | 72079 | 612 | |
1523375 | 1523375 | 2021-07-16 | Lares | Puerto Rico | 72081 | 1134 | |
1523376 | 1523376 | 2021-07-16 | Las Marias | Puerto Rico | 72083 | 334 | |
1523377 | 1523377 | 2021-07-16 | Las Piedras | Puerto Rico | 72085 | 1968 | |
1523378 | 1523378 | 2021-07-16 | Loiza | Puerto Rico | 72087 | 1458 | |
1523379 | 1523379 | 2021-07-16 | Luquillo | Puerto Rico | 72089 | 939 | |
1523380 | 1523380 | 2021-07-16 | Manati | Puerto Rico | 72091 | 1927 | |
1523381 | 1523381 | 2021-07-16 | Maricao | Puerto Rico | 72093 | 154 | |
1523382 | 1523382 | 2021-07-16 | Maunabo | Puerto Rico | 72095 | 484 | |
1523383 | 1523383 | 2021-07-16 | Mayaguez | Puerto Rico | 72097 | 2604 | |
1523384 | 1523384 | 2021-07-16 | Moca | Puerto Rico | 72099 | 1709 | |
1523385 | 1523385 | 2021-07-16 | Morovis | Puerto Rico | 72101 | 1749 | |
1523386 | 1523386 | 2021-07-16 | Naguabo | Puerto Rico | 72103 | 1221 | |
1523387 | 1523387 | 2021-07-16 | Naranjito | Puerto Rico | 72105 | 2057 | |
1523388 | 1523388 | 2021-07-16 | Orocovis | Puerto Rico | 72107 | 1117 | |
1523389 | 1523389 | 2021-07-16 | Patillas | Puerto Rico | 72109 | 510 | |
1523390 | 1523390 | 2021-07-16 | Penuelas | Puerto Rico | 72111 | 673 | |
1523391 | 1523391 | 2021-07-16 | Ponce | Puerto Rico | 72113 | 4167 | |
1523392 | 1523392 | 2021-07-16 | Quebradillas | Puerto Rico | 72115 | 1035 | |
1523393 | 1523393 | 2021-07-16 | Rincon | Puerto Rico | 72117 | 677 | |
1523394 | 1523394 | 2021-07-16 | Rio Grande | Puerto Rico | 72119 | 2584 | |
1523395 | 1523395 | 2021-07-16 | Sabana Grande | Puerto Rico | 72121 | 556 | |
1523396 | 1523396 | 2021-07-16 | Salinas | Puerto Rico | 72123 | 1213 | |
1523397 | 1523397 | 2021-07-16 | San German | Puerto Rico | 72125 | 850 | |
1523398 | 1523398 | 2021-07-16 | San Juan | Puerto Rico | 72127 | 22908 | |
1523399 | 1523399 | 2021-07-16 | San Lorenzo | Puerto Rico | 72129 | 2057 | |
1523400 | 1523400 | 2021-07-16 | San Sebastian | Puerto Rico | 72131 | 1969 | |
1523401 | 1523401 | 2021-07-16 | Santa Isabel | Puerto Rico | 72133 | 700 | |
1523402 | 1523402 | 2021-07-16 | Toa Alta | Puerto Rico | 72135 | 4801 | |
1523403 | 1523403 | 2021-07-16 | Toa Baja | Puerto Rico | 72137 | 4914 | |
1523404 | 1523404 | 2021-07-16 | Trujillo Alto | Puerto Rico | 72139 | 3714 | |
1523405 | 1523405 | 2021-07-16 | Unknown | Puerto Rico | 5619 | 2560 | |
1523406 | 1523406 | 2021-07-16 | Utuado | Puerto Rico | 72141 | 1084 | |
1523407 | 1523407 | 2021-07-16 | Vega Alta | Puerto Rico | 72143 | 2299 | |
1523408 | 1523408 | 2021-07-16 | Vega Baja | Puerto Rico | 72145 | 3505 | |
1523409 | 1523409 | 2021-07-16 | Vieques | Puerto Rico | 72147 | 206 | |
1523410 | 1523410 | 2021-07-16 | Villalba | Puerto Rico | 72149 | 885 | |
1523411 | 1523411 | 2021-07-16 | Yabucoa | Puerto Rico | 72151 | 1408 | |
1523412 | 1523412 | 2021-07-16 | Yauco | Puerto Rico | 72153 | 1269 |
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);