ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-11-14" 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 |
---|---|---|---|---|---|---|---|
731287 | 731287 | 2020-11-14 | Adjuntas | Puerto Rico | 72001 | 221 | |
731288 | 731288 | 2020-11-14 | Aguada | Puerto Rico | 72003 | 529 | |
731289 | 731289 | 2020-11-14 | Aguadilla | Puerto Rico | 72005 | 751 | |
731290 | 731290 | 2020-11-14 | Aguas Buenas | Puerto Rico | 72007 | 447 | |
731291 | 731291 | 2020-11-14 | Aibonito | Puerto Rico | 72009 | 247 | |
731292 | 731292 | 2020-11-14 | Anasco | Puerto Rico | 72011 | 399 | |
731293 | 731293 | 2020-11-14 | Arecibo | Puerto Rico | 72013 | 1299 | |
731294 | 731294 | 2020-11-14 | Arroyo | Puerto Rico | 72015 | 222 | |
731295 | 731295 | 2020-11-14 | Barceloneta | Puerto Rico | 72017 | 384 | |
731296 | 731296 | 2020-11-14 | Barranquitas | Puerto Rico | 72019 | 723 | |
731297 | 731297 | 2020-11-14 | Bayamon | Puerto Rico | 72021 | 5733 | |
731298 | 731298 | 2020-11-14 | Cabo Rojo | Puerto Rico | 72023 | 591 | |
731299 | 731299 | 2020-11-14 | Caguas | Puerto Rico | 72025 | 2719 | |
731300 | 731300 | 2020-11-14 | Camuy | Puerto Rico | 72027 | 497 | |
731301 | 731301 | 2020-11-14 | Canovanas | Puerto Rico | 72029 | 1048 | |
731302 | 731302 | 2020-11-14 | Carolina | Puerto Rico | 72031 | 4672 | |
731303 | 731303 | 2020-11-14 | Catano | Puerto Rico | 72033 | 716 | |
731304 | 731304 | 2020-11-14 | Cayey | Puerto Rico | 72035 | 606 | |
731305 | 731305 | 2020-11-14 | Ceiba | Puerto Rico | 72037 | 222 | |
731306 | 731306 | 2020-11-14 | Ciales | Puerto Rico | 72039 | 419 | |
731307 | 731307 | 2020-11-14 | Cidra | Puerto Rico | 72041 | 520 | |
731308 | 731308 | 2020-11-14 | Coamo | Puerto Rico | 72043 | 500 | |
731309 | 731309 | 2020-11-14 | Comerio | Puerto Rico | 72045 | 328 | |
731310 | 731310 | 2020-11-14 | Corozal | Puerto Rico | 72047 | 1027 | |
731311 | 731311 | 2020-11-14 | Culebra | Puerto Rico | 72049 | 24 | |
731312 | 731312 | 2020-11-14 | Dorado | Puerto Rico | 72051 | 1284 | |
731313 | 731313 | 2020-11-14 | Fajardo | Puerto Rico | 72053 | 819 | |
731314 | 731314 | 2020-11-14 | Florida | Puerto Rico | 72054 | 442 | |
731315 | 731315 | 2020-11-14 | Guanica | Puerto Rico | 72055 | 184 | |
731316 | 731316 | 2020-11-14 | Guayama | Puerto Rico | 72057 | 453 | |
731317 | 731317 | 2020-11-14 | Guayanilla | Puerto Rico | 72059 | 289 | |
731318 | 731318 | 2020-11-14 | Guaynabo | Puerto Rico | 72061 | 2653 | |
731319 | 731319 | 2020-11-14 | Gurabo | Puerto Rico | 72063 | 919 | |
731320 | 731320 | 2020-11-14 | Hatillo | Puerto Rico | 72065 | 501 | |
731321 | 731321 | 2020-11-14 | Hormigueros | Puerto Rico | 72067 | 248 | |
731322 | 731322 | 2020-11-14 | Humacao | Puerto Rico | 72069 | 906 | |
731323 | 731323 | 2020-11-14 | Isabela | Puerto Rico | 72071 | 510 | |
731324 | 731324 | 2020-11-14 | Jayuya | Puerto Rico | 72073 | 331 | |
731325 | 731325 | 2020-11-14 | Juana Diaz | Puerto Rico | 72075 | 542 | |
731326 | 731326 | 2020-11-14 | Juncos | Puerto Rico | 72077 | 705 | |
731327 | 731327 | 2020-11-14 | Lajas | Puerto Rico | 72079 | 241 | |
731328 | 731328 | 2020-11-14 | Lares | Puerto Rico | 72081 | 539 | |
731329 | 731329 | 2020-11-14 | Las Marias | Puerto Rico | 72083 | 135 | |
731330 | 731330 | 2020-11-14 | Las Piedras | Puerto Rico | 72085 | 769 | |
731331 | 731331 | 2020-11-14 | Loiza | Puerto Rico | 72087 | 447 | |
731332 | 731332 | 2020-11-14 | Luquillo | Puerto Rico | 72089 | 360 | |
731333 | 731333 | 2020-11-14 | Manati | Puerto Rico | 72091 | 858 | |
731334 | 731334 | 2020-11-14 | Maricao | Puerto Rico | 72093 | 97 | |
731335 | 731335 | 2020-11-14 | Maunabo | Puerto Rico | 72095 | 186 | |
731336 | 731336 | 2020-11-14 | Mayaguez | Puerto Rico | 72097 | 1140 | |
731337 | 731337 | 2020-11-14 | Moca | Puerto Rico | 72099 | 615 | |
731338 | 731338 | 2020-11-14 | Morovis | Puerto Rico | 72101 | 693 | |
731339 | 731339 | 2020-11-14 | Naguabo | Puerto Rico | 72103 | 431 | |
731340 | 731340 | 2020-11-14 | Naranjito | Puerto Rico | 72105 | 929 | |
731341 | 731341 | 2020-11-14 | Orocovis | Puerto Rico | 72107 | 489 | |
731342 | 731342 | 2020-11-14 | Patillas | Puerto Rico | 72109 | 225 | |
731343 | 731343 | 2020-11-14 | Penuelas | Puerto Rico | 72111 | 185 | |
731344 | 731344 | 2020-11-14 | Ponce | Puerto Rico | 72113 | 1450 | |
731345 | 731345 | 2020-11-14 | Quebradillas | Puerto Rico | 72115 | 351 | |
731346 | 731346 | 2020-11-14 | Rincon | Puerto Rico | 72117 | 259 | |
731347 | 731347 | 2020-11-14 | Rio Grande | Puerto Rico | 72119 | 976 | |
731348 | 731348 | 2020-11-14 | Sabana Grande | Puerto Rico | 72121 | 255 | |
731349 | 731349 | 2020-11-14 | Salinas | Puerto Rico | 72123 | 636 | |
731350 | 731350 | 2020-11-14 | San German | Puerto Rico | 72125 | 367 | |
731351 | 731351 | 2020-11-14 | San Juan | Puerto Rico | 72127 | 11744 | |
731352 | 731352 | 2020-11-14 | San Lorenzo | Puerto Rico | 72129 | 832 | |
731353 | 731353 | 2020-11-14 | San Sebastian | Puerto Rico | 72131 | 977 | |
731354 | 731354 | 2020-11-14 | Santa Isabel | Puerto Rico | 72133 | 316 | |
731355 | 731355 | 2020-11-14 | Toa Alta | Puerto Rico | 72135 | 2085 | |
731356 | 731356 | 2020-11-14 | Toa Baja | Puerto Rico | 72137 | 2305 | |
731357 | 731357 | 2020-11-14 | Trujillo Alto | Puerto Rico | 72139 | 1849 | |
731358 | 731358 | 2020-11-14 | Unknown | Puerto Rico | 2453 | 921 | |
731359 | 731359 | 2020-11-14 | Utuado | Puerto Rico | 72141 | 350 | |
731360 | 731360 | 2020-11-14 | Vega Alta | Puerto Rico | 72143 | 1111 | |
731361 | 731361 | 2020-11-14 | Vega Baja | Puerto Rico | 72145 | 1418 | |
731362 | 731362 | 2020-11-14 | Vieques | Puerto Rico | 72147 | 107 | |
731363 | 731363 | 2020-11-14 | Villalba | Puerto Rico | 72149 | 375 | |
731364 | 731364 | 2020-11-14 | Yabucoa | Puerto Rico | 72151 | 528 | |
731365 | 731365 | 2020-11-14 | Yauco | Puerto Rico | 72153 | 674 |
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);