ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-10-20" 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 |
---|---|---|---|---|---|---|---|
650197 | 650197 | 2020-10-20 | Adjuntas | Puerto Rico | 72001 | 170 | |
650198 | 650198 | 2020-10-20 | Aguada | Puerto Rico | 72003 | 400 | |
650199 | 650199 | 2020-10-20 | Aguadilla | Puerto Rico | 72005 | 527 | |
650200 | 650200 | 2020-10-20 | Aguas Buenas | Puerto Rico | 72007 | 345 | |
650201 | 650201 | 2020-10-20 | Aibonito | Puerto Rico | 72009 | 194 | |
650202 | 650202 | 2020-10-20 | Anasco | Puerto Rico | 72011 | 243 | |
650203 | 650203 | 2020-10-20 | Arecibo | Puerto Rico | 72013 | 997 | |
650204 | 650204 | 2020-10-20 | Arroyo | Puerto Rico | 72015 | 193 | |
650205 | 650205 | 2020-10-20 | Barceloneta | Puerto Rico | 72017 | 301 | |
650206 | 650206 | 2020-10-20 | Barranquitas | Puerto Rico | 72019 | 548 | |
650207 | 650207 | 2020-10-20 | Bayamon | Puerto Rico | 72021 | 4530 | |
650208 | 650208 | 2020-10-20 | Cabo Rojo | Puerto Rico | 72023 | 485 | |
650209 | 650209 | 2020-10-20 | Caguas | Puerto Rico | 72025 | 2001 | |
650210 | 650210 | 2020-10-20 | Camuy | Puerto Rico | 72027 | 344 | |
650211 | 650211 | 2020-10-20 | Canovanas | Puerto Rico | 72029 | 845 | |
650212 | 650212 | 2020-10-20 | Carolina | Puerto Rico | 72031 | 3640 | |
650213 | 650213 | 2020-10-20 | Catano | Puerto Rico | 72033 | 561 | |
650214 | 650214 | 2020-10-20 | Cayey | Puerto Rico | 72035 | 452 | |
650215 | 650215 | 2020-10-20 | Ceiba | Puerto Rico | 72037 | 175 | |
650216 | 650216 | 2020-10-20 | Ciales | Puerto Rico | 72039 | 320 | |
650217 | 650217 | 2020-10-20 | Cidra | Puerto Rico | 72041 | 388 | |
650218 | 650218 | 2020-10-20 | Coamo | Puerto Rico | 72043 | 360 | |
650219 | 650219 | 2020-10-20 | Comerio | Puerto Rico | 72045 | 273 | |
650220 | 650220 | 2020-10-20 | Corozal | Puerto Rico | 72047 | 809 | |
650221 | 650221 | 2020-10-20 | Culebra | Puerto Rico | 72049 | 22 | |
650222 | 650222 | 2020-10-20 | Dorado | Puerto Rico | 72051 | 983 | |
650223 | 650223 | 2020-10-20 | Fajardo | Puerto Rico | 72053 | 682 | |
650224 | 650224 | 2020-10-20 | Florida | Puerto Rico | 72054 | 370 | |
650225 | 650225 | 2020-10-20 | Guanica | Puerto Rico | 72055 | 141 | |
650226 | 650226 | 2020-10-20 | Guayama | Puerto Rico | 72057 | 359 | |
650227 | 650227 | 2020-10-20 | Guayanilla | Puerto Rico | 72059 | 233 | |
650228 | 650228 | 2020-10-20 | Guaynabo | Puerto Rico | 72061 | 2096 | |
650229 | 650229 | 2020-10-20 | Gurabo | Puerto Rico | 72063 | 685 | |
650230 | 650230 | 2020-10-20 | Hatillo | Puerto Rico | 72065 | 394 | |
650231 | 650231 | 2020-10-20 | Hormigueros | Puerto Rico | 72067 | 201 | |
650232 | 650232 | 2020-10-20 | Humacao | Puerto Rico | 72069 | 720 | |
650233 | 650233 | 2020-10-20 | Isabela | Puerto Rico | 72071 | 345 | |
650234 | 650234 | 2020-10-20 | Jayuya | Puerto Rico | 72073 | 277 | |
650235 | 650235 | 2020-10-20 | Juana Diaz | Puerto Rico | 72075 | 421 | |
650236 | 650236 | 2020-10-20 | Juncos | Puerto Rico | 72077 | 533 | |
650237 | 650237 | 2020-10-20 | Lajas | Puerto Rico | 72079 | 198 | |
650238 | 650238 | 2020-10-20 | Lares | Puerto Rico | 72081 | 404 | |
650239 | 650239 | 2020-10-20 | Las Marias | Puerto Rico | 72083 | 118 | |
650240 | 650240 | 2020-10-20 | Las Piedras | Puerto Rico | 72085 | 612 | |
650241 | 650241 | 2020-10-20 | Loiza | Puerto Rico | 72087 | 346 | |
650242 | 650242 | 2020-10-20 | Luquillo | Puerto Rico | 72089 | 309 | |
650243 | 650243 | 2020-10-20 | Manati | Puerto Rico | 72091 | 696 | |
650244 | 650244 | 2020-10-20 | Maricao | Puerto Rico | 72093 | 92 | |
650245 | 650245 | 2020-10-20 | Maunabo | Puerto Rico | 72095 | 168 | |
650246 | 650246 | 2020-10-20 | Mayaguez | Puerto Rico | 72097 | 962 | |
650247 | 650247 | 2020-10-20 | Moca | Puerto Rico | 72099 | 416 | |
650248 | 650248 | 2020-10-20 | Morovis | Puerto Rico | 72101 | 587 | |
650249 | 650249 | 2020-10-20 | Naguabo | Puerto Rico | 72103 | 352 | |
650250 | 650250 | 2020-10-20 | Naranjito | Puerto Rico | 72105 | 776 | |
650251 | 650251 | 2020-10-20 | Orocovis | Puerto Rico | 72107 | 402 | |
650252 | 650252 | 2020-10-20 | Patillas | Puerto Rico | 72109 | 192 | |
650253 | 650253 | 2020-10-20 | Penuelas | Puerto Rico | 72111 | 146 | |
650254 | 650254 | 2020-10-20 | Ponce | Puerto Rico | 72113 | 1159 | |
650255 | 650255 | 2020-10-20 | Quebradillas | Puerto Rico | 72115 | 242 | |
650256 | 650256 | 2020-10-20 | Rincon | Puerto Rico | 72117 | 231 | |
650257 | 650257 | 2020-10-20 | Rio Grande | Puerto Rico | 72119 | 759 | |
650258 | 650258 | 2020-10-20 | Sabana Grande | Puerto Rico | 72121 | 228 | |
650259 | 650259 | 2020-10-20 | Salinas | Puerto Rico | 72123 | 516 | |
650260 | 650260 | 2020-10-20 | San German | Puerto Rico | 72125 | 295 | |
650261 | 650261 | 2020-10-20 | San Juan | Puerto Rico | 72127 | 9441 | |
650262 | 650262 | 2020-10-20 | San Lorenzo | Puerto Rico | 72129 | 666 | |
650263 | 650263 | 2020-10-20 | San Sebastian | Puerto Rico | 72131 | 621 | |
650264 | 650264 | 2020-10-20 | Santa Isabel | Puerto Rico | 72133 | 215 | |
650265 | 650265 | 2020-10-20 | Toa Alta | Puerto Rico | 72135 | 1578 | |
650266 | 650266 | 2020-10-20 | Toa Baja | Puerto Rico | 72137 | 1799 | |
650267 | 650267 | 2020-10-20 | Trujillo Alto | Puerto Rico | 72139 | 1362 | |
650268 | 650268 | 2020-10-20 | Unknown | Puerto Rico | 1715 | 769 | |
650269 | 650269 | 2020-10-20 | Utuado | Puerto Rico | 72141 | 196 | |
650270 | 650270 | 2020-10-20 | Vega Alta | Puerto Rico | 72143 | 909 | |
650271 | 650271 | 2020-10-20 | Vega Baja | Puerto Rico | 72145 | 1128 | |
650272 | 650272 | 2020-10-20 | Vieques | Puerto Rico | 72147 | 102 | |
650273 | 650273 | 2020-10-20 | Villalba | Puerto Rico | 72149 | 191 | |
650274 | 650274 | 2020-10-20 | Yabucoa | Puerto Rico | 72151 | 449 | |
650275 | 650275 | 2020-10-20 | Yauco | Puerto Rico | 72153 | 502 |
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);