ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
825405 | 825405 | 2020-12-13 | Adjuntas | Puerto Rico | 72001 | 303 | |
825406 | 825406 | 2020-12-13 | Aguada | Puerto Rico | 72003 | 764 | |
825407 | 825407 | 2020-12-13 | Aguadilla | Puerto Rico | 72005 | 995 | |
825408 | 825408 | 2020-12-13 | Aguas Buenas | Puerto Rico | 72007 | 582 | |
825409 | 825409 | 2020-12-13 | Aibonito | Puerto Rico | 72009 | 384 | |
825410 | 825410 | 2020-12-13 | Anasco | Puerto Rico | 72011 | 562 | |
825411 | 825411 | 2020-12-13 | Arecibo | Puerto Rico | 72013 | 1955 | |
825412 | 825412 | 2020-12-13 | Arroyo | Puerto Rico | 72015 | 270 | |
825413 | 825413 | 2020-12-13 | Barceloneta | Puerto Rico | 72017 | 536 | |
825414 | 825414 | 2020-12-13 | Barranquitas | Puerto Rico | 72019 | 919 | |
825415 | 825415 | 2020-12-13 | Bayamon | Puerto Rico | 72021 | 7110 | |
825416 | 825416 | 2020-12-13 | Cabo Rojo | Puerto Rico | 72023 | 696 | |
825417 | 825417 | 2020-12-13 | Caguas | Puerto Rico | 72025 | 3770 | |
825418 | 825418 | 2020-12-13 | Camuy | Puerto Rico | 72027 | 797 | |
825419 | 825419 | 2020-12-13 | Canovanas | Puerto Rico | 72029 | 1285 | |
825420 | 825420 | 2020-12-13 | Carolina | Puerto Rico | 72031 | 5815 | |
825421 | 825421 | 2020-12-13 | Catano | Puerto Rico | 72033 | 881 | |
825422 | 825422 | 2020-12-13 | Cayey | Puerto Rico | 72035 | 903 | |
825423 | 825423 | 2020-12-13 | Ceiba | Puerto Rico | 72037 | 270 | |
825424 | 825424 | 2020-12-13 | Ciales | Puerto Rico | 72039 | 561 | |
825425 | 825425 | 2020-12-13 | Cidra | Puerto Rico | 72041 | 758 | |
825426 | 825426 | 2020-12-13 | Coamo | Puerto Rico | 72043 | 630 | |
825427 | 825427 | 2020-12-13 | Comerio | Puerto Rico | 72045 | 490 | |
825428 | 825428 | 2020-12-13 | Corozal | Puerto Rico | 72047 | 1284 | |
825429 | 825429 | 2020-12-13 | Culebra | Puerto Rico | 72049 | 25 | |
825430 | 825430 | 2020-12-13 | Dorado | Puerto Rico | 72051 | 1628 | |
825431 | 825431 | 2020-12-13 | Fajardo | Puerto Rico | 72053 | 888 | |
825432 | 825432 | 2020-12-13 | Florida | Puerto Rico | 72054 | 551 | |
825433 | 825433 | 2020-12-13 | Guanica | Puerto Rico | 72055 | 214 | |
825434 | 825434 | 2020-12-13 | Guayama | Puerto Rico | 72057 | 603 | |
825435 | 825435 | 2020-12-13 | Guayanilla | Puerto Rico | 72059 | 335 | |
825436 | 825436 | 2020-12-13 | Guaynabo | Puerto Rico | 72061 | 3242 | |
825437 | 825437 | 2020-12-13 | Gurabo | Puerto Rico | 72063 | 1209 | |
825438 | 825438 | 2020-12-13 | Hatillo | Puerto Rico | 72065 | 769 | |
825439 | 825439 | 2020-12-13 | Hormigueros | Puerto Rico | 72067 | 306 | |
825440 | 825440 | 2020-12-13 | Humacao | Puerto Rico | 72069 | 1089 | |
825441 | 825441 | 2020-12-13 | Isabela | Puerto Rico | 72071 | 721 | |
825442 | 825442 | 2020-12-13 | Jayuya | Puerto Rico | 72073 | 363 | |
825443 | 825443 | 2020-12-13 | Juana Diaz | Puerto Rico | 72075 | 735 | |
825444 | 825444 | 2020-12-13 | Juncos | Puerto Rico | 72077 | 958 | |
825445 | 825445 | 2020-12-13 | Lajas | Puerto Rico | 72079 | 276 | |
825446 | 825446 | 2020-12-13 | Lares | Puerto Rico | 72081 | 666 | |
825447 | 825447 | 2020-12-13 | Las Marias | Puerto Rico | 72083 | 168 | |
825448 | 825448 | 2020-12-13 | Las Piedras | Puerto Rico | 72085 | 897 | |
825449 | 825449 | 2020-12-13 | Loiza | Puerto Rico | 72087 | 616 | |
825450 | 825450 | 2020-12-13 | Luquillo | Puerto Rico | 72089 | 425 | |
825451 | 825451 | 2020-12-13 | Manati | Puerto Rico | 72091 | 1126 | |
825452 | 825452 | 2020-12-13 | Maricao | Puerto Rico | 72093 | 100 | |
825453 | 825453 | 2020-12-13 | Maunabo | Puerto Rico | 72095 | 247 | |
825454 | 825454 | 2020-12-13 | Mayaguez | Puerto Rico | 72097 | 1403 | |
825455 | 825455 | 2020-12-13 | Moca | Puerto Rico | 72099 | 920 | |
825456 | 825456 | 2020-12-13 | Morovis | Puerto Rico | 72101 | 957 | |
825457 | 825457 | 2020-12-13 | Naguabo | Puerto Rico | 72103 | 539 | |
825458 | 825458 | 2020-12-13 | Naranjito | Puerto Rico | 72105 | 1198 | |
825459 | 825459 | 2020-12-13 | Orocovis | Puerto Rico | 72107 | 583 | |
825460 | 825460 | 2020-12-13 | Patillas | Puerto Rico | 72109 | 294 | |
825461 | 825461 | 2020-12-13 | Penuelas | Puerto Rico | 72111 | 346 | |
825462 | 825462 | 2020-12-13 | Ponce | Puerto Rico | 72113 | 1920 | |
825463 | 825463 | 2020-12-13 | Quebradillas | Puerto Rico | 72115 | 504 | |
825464 | 825464 | 2020-12-13 | Rincon | Puerto Rico | 72117 | 312 | |
825465 | 825465 | 2020-12-13 | Rio Grande | Puerto Rico | 72119 | 1184 | |
825466 | 825466 | 2020-12-13 | Sabana Grande | Puerto Rico | 72121 | 293 | |
825467 | 825467 | 2020-12-13 | Salinas | Puerto Rico | 72123 | 797 | |
825468 | 825468 | 2020-12-13 | San German | Puerto Rico | 72125 | 420 | |
825469 | 825469 | 2020-12-13 | San Juan | Puerto Rico | 72127 | 13897 | |
825470 | 825470 | 2020-12-13 | San Lorenzo | Puerto Rico | 72129 | 1013 | |
825471 | 825471 | 2020-12-13 | San Sebastian | Puerto Rico | 72131 | 1293 | |
825472 | 825472 | 2020-12-13 | Santa Isabel | Puerto Rico | 72133 | 417 | |
825473 | 825473 | 2020-12-13 | Toa Alta | Puerto Rico | 72135 | 2730 | |
825474 | 825474 | 2020-12-13 | Toa Baja | Puerto Rico | 72137 | 2904 | |
825475 | 825475 | 2020-12-13 | Trujillo Alto | Puerto Rico | 72139 | 2180 | |
825476 | 825476 | 2020-12-13 | Unknown | Puerto Rico | 3245 | 1272 | |
825477 | 825477 | 2020-12-13 | Utuado | Puerto Rico | 72141 | 573 | |
825478 | 825478 | 2020-12-13 | Vega Alta | Puerto Rico | 72143 | 1417 | |
825479 | 825479 | 2020-12-13 | Vega Baja | Puerto Rico | 72145 | 1919 | |
825480 | 825480 | 2020-12-13 | Vieques | Puerto Rico | 72147 | 137 | |
825481 | 825481 | 2020-12-13 | Villalba | Puerto Rico | 72149 | 533 | |
825482 | 825482 | 2020-12-13 | Yabucoa | Puerto Rico | 72151 | 629 | |
825483 | 825483 | 2020-12-13 | Yauco | Puerto Rico | 72153 | 812 |
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);