ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
718313 | 718313 | 2020-11-10 | Adjuntas | Puerto Rico | 72001 | 213 | |
718314 | 718314 | 2020-11-10 | Aguada | Puerto Rico | 72003 | 509 | |
718315 | 718315 | 2020-11-10 | Aguadilla | Puerto Rico | 72005 | 713 | |
718316 | 718316 | 2020-11-10 | Aguas Buenas | Puerto Rico | 72007 | 430 | |
718317 | 718317 | 2020-11-10 | Aibonito | Puerto Rico | 72009 | 234 | |
718318 | 718318 | 2020-11-10 | Anasco | Puerto Rico | 72011 | 365 | |
718319 | 718319 | 2020-11-10 | Arecibo | Puerto Rico | 72013 | 1225 | |
718320 | 718320 | 2020-11-10 | Arroyo | Puerto Rico | 72015 | 218 | |
718321 | 718321 | 2020-11-10 | Barceloneta | Puerto Rico | 72017 | 366 | |
718322 | 718322 | 2020-11-10 | Barranquitas | Puerto Rico | 72019 | 688 | |
718323 | 718323 | 2020-11-10 | Bayamon | Puerto Rico | 72021 | 5488 | |
718324 | 718324 | 2020-11-10 | Cabo Rojo | Puerto Rico | 72023 | 573 | |
718325 | 718325 | 2020-11-10 | Caguas | Puerto Rico | 72025 | 2541 | |
718326 | 718326 | 2020-11-10 | Camuy | Puerto Rico | 72027 | 464 | |
718327 | 718327 | 2020-11-10 | Canovanas | Puerto Rico | 72029 | 1025 | |
718328 | 718328 | 2020-11-10 | Carolina | Puerto Rico | 72031 | 4489 | |
718329 | 718329 | 2020-11-10 | Catano | Puerto Rico | 72033 | 678 | |
718330 | 718330 | 2020-11-10 | Cayey | Puerto Rico | 72035 | 577 | |
718331 | 718331 | 2020-11-10 | Ceiba | Puerto Rico | 72037 | 221 | |
718332 | 718332 | 2020-11-10 | Ciales | Puerto Rico | 72039 | 394 | |
718333 | 718333 | 2020-11-10 | Cidra | Puerto Rico | 72041 | 505 | |
718334 | 718334 | 2020-11-10 | Coamo | Puerto Rico | 72043 | 472 | |
718335 | 718335 | 2020-11-10 | Comerio | Puerto Rico | 72045 | 323 | |
718336 | 718336 | 2020-11-10 | Corozal | Puerto Rico | 72047 | 999 | |
718337 | 718337 | 2020-11-10 | Culebra | Puerto Rico | 72049 | 23 | |
718338 | 718338 | 2020-11-10 | Dorado | Puerto Rico | 72051 | 1246 | |
718339 | 718339 | 2020-11-10 | Fajardo | Puerto Rico | 72053 | 796 | |
718340 | 718340 | 2020-11-10 | Florida | Puerto Rico | 72054 | 428 | |
718341 | 718341 | 2020-11-10 | Guanica | Puerto Rico | 72055 | 181 | |
718342 | 718342 | 2020-11-10 | Guayama | Puerto Rico | 72057 | 423 | |
718343 | 718343 | 2020-11-10 | Guayanilla | Puerto Rico | 72059 | 282 | |
718344 | 718344 | 2020-11-10 | Guaynabo | Puerto Rico | 72061 | 2537 | |
718345 | 718345 | 2020-11-10 | Gurabo | Puerto Rico | 72063 | 860 | |
718346 | 718346 | 2020-11-10 | Hatillo | Puerto Rico | 72065 | 480 | |
718347 | 718347 | 2020-11-10 | Hormigueros | Puerto Rico | 72067 | 232 | |
718348 | 718348 | 2020-11-10 | Humacao | Puerto Rico | 72069 | 879 | |
718349 | 718349 | 2020-11-10 | Isabela | Puerto Rico | 72071 | 461 | |
718350 | 718350 | 2020-11-10 | Jayuya | Puerto Rico | 72073 | 317 | |
718351 | 718351 | 2020-11-10 | Juana Diaz | Puerto Rico | 72075 | 515 | |
718352 | 718352 | 2020-11-10 | Juncos | Puerto Rico | 72077 | 656 | |
718353 | 718353 | 2020-11-10 | Lajas | Puerto Rico | 72079 | 235 | |
718354 | 718354 | 2020-11-10 | Lares | Puerto Rico | 72081 | 521 | |
718355 | 718355 | 2020-11-10 | Las Marias | Puerto Rico | 72083 | 131 | |
718356 | 718356 | 2020-11-10 | Las Piedras | Puerto Rico | 72085 | 751 | |
718357 | 718357 | 2020-11-10 | Loiza | Puerto Rico | 72087 | 419 | |
718358 | 718358 | 2020-11-10 | Luquillo | Puerto Rico | 72089 | 356 | |
718359 | 718359 | 2020-11-10 | Manati | Puerto Rico | 72091 | 832 | |
718360 | 718360 | 2020-11-10 | Maricao | Puerto Rico | 72093 | 97 | |
718361 | 718361 | 2020-11-10 | Maunabo | Puerto Rico | 72095 | 181 | |
718362 | 718362 | 2020-11-10 | Mayaguez | Puerto Rico | 72097 | 1100 | |
718363 | 718363 | 2020-11-10 | Moca | Puerto Rico | 72099 | 564 | |
718364 | 718364 | 2020-11-10 | Morovis | Puerto Rico | 72101 | 669 | |
718365 | 718365 | 2020-11-10 | Naguabo | Puerto Rico | 72103 | 412 | |
718366 | 718366 | 2020-11-10 | Naranjito | Puerto Rico | 72105 | 904 | |
718367 | 718367 | 2020-11-10 | Orocovis | Puerto Rico | 72107 | 466 | |
718368 | 718368 | 2020-11-10 | Patillas | Puerto Rico | 72109 | 218 | |
718369 | 718369 | 2020-11-10 | Penuelas | Puerto Rico | 72111 | 172 | |
718370 | 718370 | 2020-11-10 | Ponce | Puerto Rico | 72113 | 1421 | |
718371 | 718371 | 2020-11-10 | Quebradillas | Puerto Rico | 72115 | 321 | |
718372 | 718372 | 2020-11-10 | Rincon | Puerto Rico | 72117 | 252 | |
718373 | 718373 | 2020-11-10 | Rio Grande | Puerto Rico | 72119 | 946 | |
718374 | 718374 | 2020-11-10 | Sabana Grande | Puerto Rico | 72121 | 250 | |
718375 | 718375 | 2020-11-10 | Salinas | Puerto Rico | 72123 | 624 | |
718376 | 718376 | 2020-11-10 | San German | Puerto Rico | 72125 | 357 | |
718377 | 718377 | 2020-11-10 | San Juan | Puerto Rico | 72127 | 11375 | |
718378 | 718378 | 2020-11-10 | San Lorenzo | Puerto Rico | 72129 | 807 | |
718379 | 718379 | 2020-11-10 | San Sebastian | Puerto Rico | 72131 | 880 | |
718380 | 718380 | 2020-11-10 | Santa Isabel | Puerto Rico | 72133 | 305 | |
718381 | 718381 | 2020-11-10 | Toa Alta | Puerto Rico | 72135 | 2005 | |
718382 | 718382 | 2020-11-10 | Toa Baja | Puerto Rico | 72137 | 2216 | |
718383 | 718383 | 2020-11-10 | Trujillo Alto | Puerto Rico | 72139 | 1781 | |
718384 | 718384 | 2020-11-10 | Unknown | Puerto Rico | 2353 | 889 | |
718385 | 718385 | 2020-11-10 | Utuado | Puerto Rico | 72141 | 332 | |
718386 | 718386 | 2020-11-10 | Vega Alta | Puerto Rico | 72143 | 1070 | |
718387 | 718387 | 2020-11-10 | Vega Baja | Puerto Rico | 72145 | 1359 | |
718388 | 718388 | 2020-11-10 | Vieques | Puerto Rico | 72147 | 107 | |
718389 | 718389 | 2020-11-10 | Villalba | Puerto Rico | 72149 | 324 | |
718390 | 718390 | 2020-11-10 | Yabucoa | Puerto Rico | 72151 | 520 | |
718391 | 718391 | 2020-11-10 | Yauco | Puerto Rico | 72153 | 651 |
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);