ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Unknown 141
- Adjuntas 88
- Aguada 88
- Aguadilla 88
- Aguas Buenas 88
- Aibonito 88
- Anasco 88
- Arecibo 88
- Arroyo 88
- Barceloneta 88
- Barranquitas 88
- Bayamon 88
- Cabo Rojo 88
- Caguas 88
- Camuy 88
- Canovanas 88
- Carolina 88
- Catano 88
- Cayey 88
- Ceiba 88
- Ciales 88
- Cidra 88
- Coamo 88
- Comerio 88
- Corozal 88
- Dorado 88
- Fajardo 88
- Florida 88
- Guanica 88
- Guayama 88
- …
state 1
- Puerto Rico · 6,968 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388244 | 388244 | 2020-07-31 | Adjuntas | Puerto Rico | 72001 | 82 | |
388245 | 388245 | 2020-07-31 | Aguada | Puerto Rico | 72003 | 99 | |
388246 | 388246 | 2020-07-31 | Aguadilla | Puerto Rico | 72005 | 168 | |
388247 | 388247 | 2020-07-31 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
388248 | 388248 | 2020-07-31 | Aibonito | Puerto Rico | 72009 | 73 | |
388249 | 388249 | 2020-07-31 | Anasco | Puerto Rico | 72011 | 108 | |
388250 | 388250 | 2020-07-31 | Arecibo | Puerto Rico | 72013 | 240 | |
388251 | 388251 | 2020-07-31 | Arroyo | Puerto Rico | 72015 | 76 | |
388252 | 388252 | 2020-07-31 | Barceloneta | Puerto Rico | 72017 | 67 | |
388253 | 388253 | 2020-07-31 | Barranquitas | Puerto Rico | 72019 | 187 | |
388254 | 388254 | 2020-07-31 | Bayamon | Puerto Rico | 72021 | 1064 | |
388255 | 388255 | 2020-07-31 | Cabo Rojo | Puerto Rico | 72023 | 163 | |
388256 | 388256 | 2020-07-31 | Caguas | Puerto Rico | 72025 | 563 | |
388257 | 388257 | 2020-07-31 | Camuy | Puerto Rico | 72027 | 96 | |
388258 | 388258 | 2020-07-31 | Canovanas | Puerto Rico | 72029 | 282 | |
388259 | 388259 | 2020-07-31 | Carolina | Puerto Rico | 72031 | 848 | |
388260 | 388260 | 2020-07-31 | Catano | Puerto Rico | 72033 | 147 | |
388261 | 388261 | 2020-07-31 | Cayey | Puerto Rico | 72035 | 165 | |
388262 | 388262 | 2020-07-31 | Ceiba | Puerto Rico | 72037 | 55 | |
388263 | 388263 | 2020-07-31 | Ciales | Puerto Rico | 72039 | 115 | |
388264 | 388264 | 2020-07-31 | Cidra | Puerto Rico | 72041 | 134 | |
388265 | 388265 | 2020-07-31 | Coamo | Puerto Rico | 72043 | 110 | |
388266 | 388266 | 2020-07-31 | Comerio | Puerto Rico | 72045 | 99 | |
388267 | 388267 | 2020-07-31 | Corozal | Puerto Rico | 72047 | 145 | |
388268 | 388268 | 2020-07-31 | Culebra | Puerto Rico | 72049 | 17 | |
388269 | 388269 | 2020-07-31 | Dorado | Puerto Rico | 72051 | 228 | |
388270 | 388270 | 2020-07-31 | Fajardo | Puerto Rico | 72053 | 180 | |
388271 | 388271 | 2020-07-31 | Florida | Puerto Rico | 72054 | 136 | |
388272 | 388272 | 2020-07-31 | Guanica | Puerto Rico | 72055 | 52 | |
388273 | 388273 | 2020-07-31 | Guayama | Puerto Rico | 72057 | 128 | |
388274 | 388274 | 2020-07-31 | Guayanilla | Puerto Rico | 72059 | 113 | |
388275 | 388275 | 2020-07-31 | Guaynabo | Puerto Rico | 72061 | 668 | |
388276 | 388276 | 2020-07-31 | Gurabo | Puerto Rico | 72063 | 197 | |
388277 | 388277 | 2020-07-31 | Hatillo | Puerto Rico | 72065 | 80 | |
388278 | 388278 | 2020-07-31 | Hormigueros | Puerto Rico | 72067 | 79 | |
388279 | 388279 | 2020-07-31 | Humacao | Puerto Rico | 72069 | 152 | |
388280 | 388280 | 2020-07-31 | Isabela | Puerto Rico | 72071 | 115 | |
388281 | 388281 | 2020-07-31 | Jayuya | Puerto Rico | 72073 | 177 | |
388282 | 388282 | 2020-07-31 | Juana Diaz | Puerto Rico | 72075 | 166 | |
388283 | 388283 | 2020-07-31 | Juncos | Puerto Rico | 72077 | 97 | |
388284 | 388284 | 2020-07-31 | Lajas | Puerto Rico | 72079 | 70 | |
388285 | 388285 | 2020-07-31 | Lares | Puerto Rico | 72081 | 124 | |
388286 | 388286 | 2020-07-31 | Las Marias | Puerto Rico | 72083 | 48 | |
388287 | 388287 | 2020-07-31 | Las Piedras | Puerto Rico | 72085 | 125 | |
388288 | 388288 | 2020-07-31 | Loiza | Puerto Rico | 72087 | 77 | |
388289 | 388289 | 2020-07-31 | Luquillo | Puerto Rico | 72089 | 88 | |
388290 | 388290 | 2020-07-31 | Manati | Puerto Rico | 72091 | 179 | |
388291 | 388291 | 2020-07-31 | Maricao | Puerto Rico | 72093 | 41 | |
388292 | 388292 | 2020-07-31 | Maunabo | Puerto Rico | 72095 | 50 | |
388293 | 388293 | 2020-07-31 | Mayaguez | Puerto Rico | 72097 | 418 | |
388294 | 388294 | 2020-07-31 | Moca | Puerto Rico | 72099 | 144 | |
388295 | 388295 | 2020-07-31 | Morovis | Puerto Rico | 72101 | 197 | |
388296 | 388296 | 2020-07-31 | Naguabo | Puerto Rico | 72103 | 81 | |
388297 | 388297 | 2020-07-31 | Naranjito | Puerto Rico | 72105 | 207 | |
388298 | 388298 | 2020-07-31 | Orocovis | Puerto Rico | 72107 | 162 | |
388299 | 388299 | 2020-07-31 | Patillas | Puerto Rico | 72109 | 92 | |
388300 | 388300 | 2020-07-31 | Penuelas | Puerto Rico | 72111 | 57 | |
388301 | 388301 | 2020-07-31 | Ponce | Puerto Rico | 72113 | 395 | |
388302 | 388302 | 2020-07-31 | Quebradillas | Puerto Rico | 72115 | 65 | |
388303 | 388303 | 2020-07-31 | Rincon | Puerto Rico | 72117 | 81 | |
388304 | 388304 | 2020-07-31 | Rio Grande | Puerto Rico | 72119 | 225 | |
388305 | 388305 | 2020-07-31 | Sabana Grande | Puerto Rico | 72121 | 104 | |
388306 | 388306 | 2020-07-31 | Salinas | Puerto Rico | 72123 | 132 | |
388307 | 388307 | 2020-07-31 | San German | Puerto Rico | 72125 | 121 | |
388308 | 388308 | 2020-07-31 | San Juan | Puerto Rico | 72127 | 2291 | |
388309 | 388309 | 2020-07-31 | San Lorenzo | Puerto Rico | 72129 | 127 | |
388310 | 388310 | 2020-07-31 | San Sebastian | Puerto Rico | 72131 | 170 | |
388311 | 388311 | 2020-07-31 | Santa Isabel | Puerto Rico | 72133 | 82 | |
388312 | 388312 | 2020-07-31 | Toa Alta | Puerto Rico | 72135 | 410 | |
388313 | 388313 | 2020-07-31 | Toa Baja | Puerto Rico | 72137 | 395 | |
388314 | 388314 | 2020-07-31 | Trujillo Alto | Puerto Rico | 72139 | 372 | |
388315 | 388315 | 2020-07-31 | Unknown | Puerto Rico | 970 | 219 | |
388316 | 388316 | 2020-07-31 | Utuado | Puerto Rico | 72141 | 57 | |
388317 | 388317 | 2020-07-31 | Vega Alta | Puerto Rico | 72143 | 167 | |
388318 | 388318 | 2020-07-31 | Vega Baja | Puerto Rico | 72145 | 290 | |
388319 | 388319 | 2020-07-31 | Vieques | Puerto Rico | 72147 | 37 | |
388320 | 388320 | 2020-07-31 | Villalba | Puerto Rico | 72149 | 71 | |
388321 | 388321 | 2020-07-31 | Yabucoa | Puerto Rico | 72151 | 92 | |
388322 | 388322 | 2020-07-31 | Yauco | Puerto Rico | 72153 | 194 | |
385027 | 385027 | 2020-07-30 | Adjuntas | Puerto Rico | 72001 | 78 | |
385028 | 385028 | 2020-07-30 | Aguada | Puerto Rico | 72003 | 97 | |
385029 | 385029 | 2020-07-30 | Aguadilla | Puerto Rico | 72005 | 166 | |
385030 | 385030 | 2020-07-30 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
385031 | 385031 | 2020-07-30 | Aibonito | Puerto Rico | 72009 | 73 | |
385032 | 385032 | 2020-07-30 | Anasco | Puerto Rico | 72011 | 108 | |
385033 | 385033 | 2020-07-30 | Arecibo | Puerto Rico | 72013 | 237 | |
385034 | 385034 | 2020-07-30 | Arroyo | Puerto Rico | 72015 | 76 | |
385035 | 385035 | 2020-07-30 | Barceloneta | Puerto Rico | 72017 | 65 | |
385036 | 385036 | 2020-07-30 | Barranquitas | Puerto Rico | 72019 | 172 | |
385037 | 385037 | 2020-07-30 | Bayamon | Puerto Rico | 72021 | 1053 | |
385038 | 385038 | 2020-07-30 | Cabo Rojo | Puerto Rico | 72023 | 160 | |
385039 | 385039 | 2020-07-30 | Caguas | Puerto Rico | 72025 | 560 | |
385040 | 385040 | 2020-07-30 | Camuy | Puerto Rico | 72027 | 96 | |
385041 | 385041 | 2020-07-30 | Canovanas | Puerto Rico | 72029 | 280 | |
385042 | 385042 | 2020-07-30 | Carolina | Puerto Rico | 72031 | 841 | |
385043 | 385043 | 2020-07-30 | Catano | Puerto Rico | 72033 | 145 | |
385044 | 385044 | 2020-07-30 | Cayey | Puerto Rico | 72035 | 163 | |
385045 | 385045 | 2020-07-30 | Ceiba | Puerto Rico | 72037 | 53 | |
385046 | 385046 | 2020-07-30 | Ciales | Puerto Rico | 72039 | 115 | |
385047 | 385047 | 2020-07-30 | Cidra | Puerto Rico | 72041 | 132 |
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);