ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2022-01-28 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
- 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 |
---|---|---|---|---|---|---|---|
2160260 | 2160260 | 2022-01-28 | Adjuntas | Puerto Rico | 72001 | 2028 | |
2160261 | 2160261 | 2022-01-28 | Aguada | Puerto Rico | 72003 | 5723 | |
2160262 | 2160262 | 2022-01-28 | Aguadilla | Puerto Rico | 72005 | 6612 | |
2160263 | 2160263 | 2022-01-28 | Aguas Buenas | Puerto Rico | 72007 | 3748 | |
2160264 | 2160264 | 2022-01-28 | Aibonito | Puerto Rico | 72009 | 3276 | |
2160265 | 2160265 | 2022-01-28 | Anasco | Puerto Rico | 72011 | 3252 | |
2160266 | 2160266 | 2022-01-28 | Arecibo | Puerto Rico | 72013 | 11660 | |
2160267 | 2160267 | 2022-01-28 | Arroyo | Puerto Rico | 72015 | 1705 | |
2160268 | 2160268 | 2022-01-28 | Barceloneta | Puerto Rico | 72017 | 2952 | |
2160269 | 2160269 | 2022-01-28 | Barranquitas | Puerto Rico | 72019 | 4355 | |
2160270 | 2160270 | 2022-01-28 | Bayamon | Puerto Rico | 72021 | 31896 | |
2160271 | 2160271 | 2022-01-28 | Cabo Rojo | Puerto Rico | 72023 | 4707 | |
2160272 | 2160272 | 2022-01-28 | Caguas | Puerto Rico | 72025 | 20260 | |
2160273 | 2160273 | 2022-01-28 | Camuy | Puerto Rico | 72027 | 4348 | |
2160274 | 2160274 | 2022-01-28 | Canovanas | Puerto Rico | 72029 | 6104 | |
2160275 | 2160275 | 2022-01-28 | Carolina | Puerto Rico | 72031 | 26181 | |
2160276 | 2160276 | 2022-01-28 | Catano | Puerto Rico | 72033 | 3900 | |
2160277 | 2160277 | 2022-01-28 | Cayey | Puerto Rico | 72035 | 5444 | |
2160278 | 2160278 | 2022-01-28 | Ceiba | Puerto Rico | 72037 | 1274 | |
2160279 | 2160279 | 2022-01-28 | Ciales | Puerto Rico | 72039 | 2353 | |
2160280 | 2160280 | 2022-01-28 | Cidra | Puerto Rico | 72041 | 5215 | |
2160281 | 2160281 | 2022-01-28 | Coamo | Puerto Rico | 72043 | 4096 | |
2160282 | 2160282 | 2022-01-28 | Comerio | Puerto Rico | 72045 | 2637 | |
2160283 | 2160283 | 2022-01-28 | Corozal | Puerto Rico | 72047 | 5783 | |
2160284 | 2160284 | 2022-01-28 | Culebra | Puerto Rico | 72049 | 159 | |
2160285 | 2160285 | 2022-01-28 | Dorado | Puerto Rico | 72051 | 6295 | |
2160286 | 2160286 | 2022-01-28 | Fajardo | Puerto Rico | 72053 | 4257 | |
2160287 | 2160287 | 2022-01-28 | Florida | Puerto Rico | 72054 | 2240 | |
2160288 | 2160288 | 2022-01-28 | Guanica | Puerto Rico | 72055 | 1348 | |
2160289 | 2160289 | 2022-01-28 | Guayama | Puerto Rico | 72057 | 4271 | |
2160290 | 2160290 | 2022-01-28 | Guayanilla | Puerto Rico | 72059 | 1862 | |
2160291 | 2160291 | 2022-01-28 | Guaynabo | Puerto Rico | 72061 | 14306 | |
2160292 | 2160292 | 2022-01-28 | Gurabo | Puerto Rico | 72063 | 6749 | |
2160293 | 2160293 | 2022-01-28 | Hatillo | Puerto Rico | 72065 | 4791 | |
2160294 | 2160294 | 2022-01-28 | Hormigueros | Puerto Rico | 72067 | 1676 | |
2160295 | 2160295 | 2022-01-28 | Humacao | Puerto Rico | 72069 | 7204 | |
2160296 | 2160296 | 2022-01-28 | Isabela | Puerto Rico | 72071 | 6013 | |
2160297 | 2160297 | 2022-01-28 | Jayuya | Puerto Rico | 72073 | 1900 | |
2160298 | 2160298 | 2022-01-28 | Juana Diaz | Puerto Rico | 72075 | 5330 | |
2160299 | 2160299 | 2022-01-28 | Juncos | Puerto Rico | 72077 | 5806 | |
2160300 | 2160300 | 2022-01-28 | Lajas | Puerto Rico | 72079 | 2272 | |
2160301 | 2160301 | 2022-01-28 | Lares | Puerto Rico | 72081 | 3447 | |
2160302 | 2160302 | 2022-01-28 | Las Marias | Puerto Rico | 72083 | 994 | |
2160303 | 2160303 | 2022-01-28 | Las Piedras | Puerto Rico | 72085 | 4936 | |
2160304 | 2160304 | 2022-01-28 | Loiza | Puerto Rico | 72087 | 3022 | |
2160305 | 2160305 | 2022-01-28 | Luquillo | Puerto Rico | 72089 | 2335 | |
2160306 | 2160306 | 2022-01-28 | Manati | Puerto Rico | 72091 | 5559 | |
2160307 | 2160307 | 2022-01-28 | Maricao | Puerto Rico | 72093 | 496 | |
2160308 | 2160308 | 2022-01-28 | Maunabo | Puerto Rico | 72095 | 1287 | |
2160309 | 2160309 | 2022-01-28 | Mayaguez | Puerto Rico | 72097 | 8985 | |
2160310 | 2160310 | 2022-01-28 | Moca | Puerto Rico | 72099 | 5373 | |
2160311 | 2160311 | 2022-01-28 | Morovis | Puerto Rico | 72101 | 4272 | |
2160312 | 2160312 | 2022-01-28 | Naguabo | Puerto Rico | 72103 | 3089 | |
2160313 | 2160313 | 2022-01-28 | Naranjito | Puerto Rico | 72105 | 4757 | |
2160314 | 2160314 | 2022-01-28 | Orocovis | Puerto Rico | 72107 | 2617 | |
2160315 | 2160315 | 2022-01-28 | Patillas | Puerto Rico | 72109 | 1868 | |
2160316 | 2160316 | 2022-01-28 | Penuelas | Puerto Rico | 72111 | 2045 | |
2160317 | 2160317 | 2022-01-28 | Ponce | Puerto Rico | 72113 | 16064 | |
2160318 | 2160318 | 2022-01-28 | Quebradillas | Puerto Rico | 72115 | 3367 | |
2160319 | 2160319 | 2022-01-28 | Rincon | Puerto Rico | 72117 | 2010 | |
2160320 | 2160320 | 2022-01-28 | Rio Grande | Puerto Rico | 72119 | 7014 | |
2160321 | 2160321 | 2022-01-28 | Sabana Grande | Puerto Rico | 72121 | 2081 | |
2160322 | 2160322 | 2022-01-28 | Salinas | Puerto Rico | 72123 | 3182 | |
2160323 | 2160323 | 2022-01-28 | San German | Puerto Rico | 72125 | 3260 | |
2160324 | 2160324 | 2022-01-28 | San Juan | Puerto Rico | 72127 | 57405 | |
2160325 | 2160325 | 2022-01-28 | San Lorenzo | Puerto Rico | 72129 | 5019 | |
2160326 | 2160326 | 2022-01-28 | San Sebastian | Puerto Rico | 72131 | 5750 | |
2160327 | 2160327 | 2022-01-28 | Santa Isabel | Puerto Rico | 72133 | 2339 | |
2160328 | 2160328 | 2022-01-28 | Toa Alta | Puerto Rico | 72135 | 11256 | |
2160329 | 2160329 | 2022-01-28 | Toa Baja | Puerto Rico | 72137 | 12056 | |
2160330 | 2160330 | 2022-01-28 | Trujillo Alto | Puerto Rico | 72139 | 9298 | |
2160331 | 2160331 | 2022-01-28 | Unknown | Puerto Rico | 16039 | 3809 | |
2160332 | 2160332 | 2022-01-28 | Utuado | Puerto Rico | 72141 | 3079 | |
2160333 | 2160333 | 2022-01-28 | Vega Alta | Puerto Rico | 72143 | 5818 | |
2160334 | 2160334 | 2022-01-28 | Vega Baja | Puerto Rico | 72145 | 9783 | |
2160335 | 2160335 | 2022-01-28 | Vieques | Puerto Rico | 72147 | 662 | |
2160336 | 2160336 | 2022-01-28 | Villalba | Puerto Rico | 72149 | 2795 | |
2160337 | 2160337 | 2022-01-28 | Yabucoa | Puerto Rico | 72151 | 4048 | |
2160338 | 2160338 | 2022-01-28 | Yauco | Puerto Rico | 72153 | 3889 |
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);