ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where "date" is on date 2020-05-15 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
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- Guayanilla 1
- …
state 1
- Puerto Rico · 77 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
147361 | 147361 | 2020-05-15 | Adjuntas | Puerto Rico | 72001 | 4 | |
147362 | 147362 | 2020-05-15 | Aguada | Puerto Rico | 72003 | 11 | |
147363 | 147363 | 2020-05-15 | Aguadilla | Puerto Rico | 72005 | 14 | |
147364 | 147364 | 2020-05-15 | Aguas Buenas | Puerto Rico | 72007 | 30 | |
147365 | 147365 | 2020-05-15 | Aibonito | Puerto Rico | 72009 | 17 | |
147366 | 147366 | 2020-05-15 | Anasco | Puerto Rico | 72011 | 12 | |
147367 | 147367 | 2020-05-15 | Arecibo | Puerto Rico | 72013 | 50 | |
147368 | 147368 | 2020-05-15 | Arroyo | Puerto Rico | 72015 | 7 | |
147369 | 147369 | 2020-05-15 | Barceloneta | Puerto Rico | 72017 | 7 | |
147370 | 147370 | 2020-05-15 | Barranquitas | Puerto Rico | 72019 | 27 | |
147371 | 147371 | 2020-05-15 | Bayamon | Puerto Rico | 72021 | 155 | |
147372 | 147372 | 2020-05-15 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
147373 | 147373 | 2020-05-15 | Caguas | Puerto Rico | 72025 | 77 | |
147374 | 147374 | 2020-05-15 | Camuy | Puerto Rico | 72027 | 8 | |
147375 | 147375 | 2020-05-15 | Canovanas | Puerto Rico | 72029 | 45 | |
147376 | 147376 | 2020-05-15 | Carolina | Puerto Rico | 72031 | 108 | |
147377 | 147377 | 2020-05-15 | Catano | Puerto Rico | 72033 | 14 | |
147378 | 147378 | 2020-05-15 | Cayey | Puerto Rico | 72035 | 32 | |
147379 | 147379 | 2020-05-15 | Ceiba | Puerto Rico | 72037 | 9 | |
147380 | 147380 | 2020-05-15 | Ciales | Puerto Rico | 72039 | 13 | |
147381 | 147381 | 2020-05-15 | Cidra | Puerto Rico | 72041 | 35 | |
147382 | 147382 | 2020-05-15 | Coamo | Puerto Rico | 72043 | 9 | |
147383 | 147383 | 2020-05-15 | Comerio | Puerto Rico | 72045 | 13 | |
147384 | 147384 | 2020-05-15 | Corozal | Puerto Rico | 72047 | 20 | |
147385 | 147385 | 2020-05-15 | Dorado | Puerto Rico | 72051 | 42 | |
147386 | 147386 | 2020-05-15 | Fajardo | Puerto Rico | 72053 | 12 | |
147387 | 147387 | 2020-05-15 | Florida | Puerto Rico | 72054 | 7 | |
147388 | 147388 | 2020-05-15 | Guanica | Puerto Rico | 72055 | 16 | |
147389 | 147389 | 2020-05-15 | Guayama | Puerto Rico | 72057 | 17 | |
147390 | 147390 | 2020-05-15 | Guayanilla | Puerto Rico | 72059 | 15 | |
147391 | 147391 | 2020-05-15 | Guaynabo | Puerto Rico | 72061 | 143 | |
147392 | 147392 | 2020-05-15 | Gurabo | Puerto Rico | 72063 | 37 | |
147393 | 147393 | 2020-05-15 | Hatillo | Puerto Rico | 72065 | 8 | |
147394 | 147394 | 2020-05-15 | Hormigueros | Puerto Rico | 72067 | 11 | |
147395 | 147395 | 2020-05-15 | Humacao | Puerto Rico | 72069 | 28 | |
147396 | 147396 | 2020-05-15 | Isabela | Puerto Rico | 72071 | 16 | |
147397 | 147397 | 2020-05-15 | Jayuya | Puerto Rico | 72073 | 2 | |
147398 | 147398 | 2020-05-15 | Juana Diaz | Puerto Rico | 72075 | 31 | |
147399 | 147399 | 2020-05-15 | Juncos | Puerto Rico | 72077 | 14 | |
147400 | 147400 | 2020-05-15 | Lajas | Puerto Rico | 72079 | 11 | |
147401 | 147401 | 2020-05-15 | Lares | Puerto Rico | 72081 | 16 | |
147402 | 147402 | 2020-05-15 | Las Marias | Puerto Rico | 72083 | 6 | |
147403 | 147403 | 2020-05-15 | Las Piedras | Puerto Rico | 72085 | 17 | |
147404 | 147404 | 2020-05-15 | Loiza | Puerto Rico | 72087 | 6 | |
147405 | 147405 | 2020-05-15 | Luquillo | Puerto Rico | 72089 | 11 | |
147406 | 147406 | 2020-05-15 | Manati | Puerto Rico | 72091 | 20 | |
147407 | 147407 | 2020-05-15 | Maunabo | Puerto Rico | 72095 | 8 | |
147408 | 147408 | 2020-05-15 | Mayaguez | Puerto Rico | 72097 | 53 | |
147409 | 147409 | 2020-05-15 | Moca | Puerto Rico | 72099 | 16 | |
147410 | 147410 | 2020-05-15 | Morovis | Puerto Rico | 72101 | 20 | |
147411 | 147411 | 2020-05-15 | Naguabo | Puerto Rico | 72103 | 16 | |
147412 | 147412 | 2020-05-15 | Naranjito | Puerto Rico | 72105 | 19 | |
147413 | 147413 | 2020-05-15 | Orocovis | Puerto Rico | 72107 | 32 | |
147414 | 147414 | 2020-05-15 | Patillas | Puerto Rico | 72109 | 23 | |
147415 | 147415 | 2020-05-15 | Penuelas | Puerto Rico | 72111 | 5 | |
147416 | 147416 | 2020-05-15 | Ponce | Puerto Rico | 72113 | 68 | |
147417 | 147417 | 2020-05-15 | Quebradillas | Puerto Rico | 72115 | 27 | |
147418 | 147418 | 2020-05-15 | Rincon | Puerto Rico | 72117 | 4 | |
147419 | 147419 | 2020-05-15 | Rio Grande | Puerto Rico | 72119 | 27 | |
147420 | 147420 | 2020-05-15 | Sabana Grande | Puerto Rico | 72121 | 20 | |
147421 | 147421 | 2020-05-15 | Salinas | Puerto Rico | 72123 | 42 | |
147422 | 147422 | 2020-05-15 | San German | Puerto Rico | 72125 | 29 | |
147423 | 147423 | 2020-05-15 | San Juan | Puerto Rico | 72127 | 373 | |
147424 | 147424 | 2020-05-15 | San Lorenzo | Puerto Rico | 72129 | 23 | |
147425 | 147425 | 2020-05-15 | San Sebastian | Puerto Rico | 72131 | 31 | |
147426 | 147426 | 2020-05-15 | Santa Isabel | Puerto Rico | 72133 | 12 | |
147427 | 147427 | 2020-05-15 | Toa Alta | Puerto Rico | 72135 | 67 | |
147428 | 147428 | 2020-05-15 | Toa Baja | Puerto Rico | 72137 | 67 | |
147429 | 147429 | 2020-05-15 | Trujillo Alto | Puerto Rico | 72139 | 49 | |
147430 | 147430 | 2020-05-15 | Unknown | Puerto Rico | 157 | 122 | |
147431 | 147431 | 2020-05-15 | Utuado | Puerto Rico | 72141 | 3 | |
147432 | 147432 | 2020-05-15 | Vega Alta | Puerto Rico | 72143 | 32 | |
147433 | 147433 | 2020-05-15 | Vega Baja | Puerto Rico | 72145 | 31 | |
147434 | 147434 | 2020-05-15 | Vieques | Puerto Rico | 72147 | 11 | |
147435 | 147435 | 2020-05-15 | Villalba | Puerto Rico | 72149 | 13 | |
147436 | 147436 | 2020-05-15 | Yabucoa | Puerto Rico | 72151 | 8 | |
147437 | 147437 | 2020-05-15 | Yauco | Puerto Rico | 72153 | 30 |
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);