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 2020-06-03 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 |
---|---|---|---|---|---|---|---|
205204 | 205204 | 2020-06-03 | Adjuntas | Puerto Rico | 72001 | 27 | |
205205 | 205205 | 2020-06-03 | Aguada | Puerto Rico | 72003 | 20 | |
205206 | 205206 | 2020-06-03 | Aguadilla | Puerto Rico | 72005 | 21 | |
205207 | 205207 | 2020-06-03 | Aguas Buenas | Puerto Rico | 72007 | 39 | |
205208 | 205208 | 2020-06-03 | Aibonito | Puerto Rico | 72009 | 29 | |
205209 | 205209 | 2020-06-03 | Anasco | Puerto Rico | 72011 | 24 | |
205210 | 205210 | 2020-06-03 | Arecibo | Puerto Rico | 72013 | 64 | |
205211 | 205211 | 2020-06-03 | Arroyo | Puerto Rico | 72015 | 15 | |
205212 | 205212 | 2020-06-03 | Barceloneta | Puerto Rico | 72017 | 12 | |
205213 | 205213 | 2020-06-03 | Barranquitas | Puerto Rico | 72019 | 40 | |
205214 | 205214 | 2020-06-03 | Bayamon | Puerto Rico | 72021 | 245 | |
205215 | 205215 | 2020-06-03 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
205216 | 205216 | 2020-06-03 | Caguas | Puerto Rico | 72025 | 129 | |
205217 | 205217 | 2020-06-03 | Camuy | Puerto Rico | 72027 | 12 | |
205218 | 205218 | 2020-06-03 | Canovanas | Puerto Rico | 72029 | 75 | |
205219 | 205219 | 2020-06-03 | Carolina | Puerto Rico | 72031 | 172 | |
205220 | 205220 | 2020-06-03 | Catano | Puerto Rico | 72033 | 18 | |
205221 | 205221 | 2020-06-03 | Cayey | Puerto Rico | 72035 | 55 | |
205222 | 205222 | 2020-06-03 | Ceiba | Puerto Rico | 72037 | 15 | |
205223 | 205223 | 2020-06-03 | Ciales | Puerto Rico | 72039 | 20 | |
205224 | 205224 | 2020-06-03 | Cidra | Puerto Rico | 72041 | 46 | |
205225 | 205225 | 2020-06-03 | Coamo | Puerto Rico | 72043 | 17 | |
205226 | 205226 | 2020-06-03 | Comerio | Puerto Rico | 72045 | 26 | |
205227 | 205227 | 2020-06-03 | Corozal | Puerto Rico | 72047 | 30 | |
205228 | 205228 | 2020-06-03 | Culebra | Puerto Rico | 72049 | 1 | |
205229 | 205229 | 2020-06-03 | Dorado | Puerto Rico | 72051 | 62 | |
205230 | 205230 | 2020-06-03 | Fajardo | Puerto Rico | 72053 | 28 | |
205231 | 205231 | 2020-06-03 | Florida | Puerto Rico | 72054 | 14 | |
205232 | 205232 | 2020-06-03 | Guanica | Puerto Rico | 72055 | 23 | |
205233 | 205233 | 2020-06-03 | Guayama | Puerto Rico | 72057 | 41 | |
205234 | 205234 | 2020-06-03 | Guayanilla | Puerto Rico | 72059 | 21 | |
205235 | 205235 | 2020-06-03 | Guaynabo | Puerto Rico | 72061 | 209 | |
205236 | 205236 | 2020-06-03 | Gurabo | Puerto Rico | 72063 | 50 | |
205237 | 205237 | 2020-06-03 | Hatillo | Puerto Rico | 72065 | 18 | |
205238 | 205238 | 2020-06-03 | Hormigueros | Puerto Rico | 72067 | 18 | |
205239 | 205239 | 2020-06-03 | Humacao | Puerto Rico | 72069 | 44 | |
205240 | 205240 | 2020-06-03 | Isabela | Puerto Rico | 72071 | 25 | |
205241 | 205241 | 2020-06-03 | Jayuya | Puerto Rico | 72073 | 10 | |
205242 | 205242 | 2020-06-03 | Juana Diaz | Puerto Rico | 72075 | 44 | |
205243 | 205243 | 2020-06-03 | Juncos | Puerto Rico | 72077 | 22 | |
205244 | 205244 | 2020-06-03 | Lajas | Puerto Rico | 72079 | 19 | |
205245 | 205245 | 2020-06-03 | Lares | Puerto Rico | 72081 | 43 | |
205246 | 205246 | 2020-06-03 | Las Marias | Puerto Rico | 72083 | 11 | |
205247 | 205247 | 2020-06-03 | Las Piedras | Puerto Rico | 72085 | 26 | |
205248 | 205248 | 2020-06-03 | Loiza | Puerto Rico | 72087 | 22 | |
205249 | 205249 | 2020-06-03 | Luquillo | Puerto Rico | 72089 | 20 | |
205250 | 205250 | 2020-06-03 | Manati | Puerto Rico | 72091 | 26 | |
205251 | 205251 | 2020-06-03 | Maricao | Puerto Rico | 72093 | 3 | |
205252 | 205252 | 2020-06-03 | Maunabo | Puerto Rico | 72095 | 17 | |
205253 | 205253 | 2020-06-03 | Mayaguez | Puerto Rico | 72097 | 96 | |
205254 | 205254 | 2020-06-03 | Moca | Puerto Rico | 72099 | 27 | |
205255 | 205255 | 2020-06-03 | Morovis | Puerto Rico | 72101 | 42 | |
205256 | 205256 | 2020-06-03 | Naguabo | Puerto Rico | 72103 | 25 | |
205257 | 205257 | 2020-06-03 | Naranjito | Puerto Rico | 72105 | 54 | |
205258 | 205258 | 2020-06-03 | Orocovis | Puerto Rico | 72107 | 50 | |
205259 | 205259 | 2020-06-03 | Patillas | Puerto Rico | 72109 | 34 | |
205260 | 205260 | 2020-06-03 | Penuelas | Puerto Rico | 72111 | 15 | |
205261 | 205261 | 2020-06-03 | Ponce | Puerto Rico | 72113 | 117 | |
205262 | 205262 | 2020-06-03 | Quebradillas | Puerto Rico | 72115 | 29 | |
205263 | 205263 | 2020-06-03 | Rincon | Puerto Rico | 72117 | 18 | |
205264 | 205264 | 2020-06-03 | Rio Grande | Puerto Rico | 72119 | 56 | |
205265 | 205265 | 2020-06-03 | Sabana Grande | Puerto Rico | 72121 | 29 | |
205266 | 205266 | 2020-06-03 | Salinas | Puerto Rico | 72123 | 74 | |
205267 | 205267 | 2020-06-03 | San German | Puerto Rico | 72125 | 36 | |
205268 | 205268 | 2020-06-03 | San Juan | Puerto Rico | 72127 | 577 | |
205269 | 205269 | 2020-06-03 | San Lorenzo | Puerto Rico | 72129 | 42 | |
205270 | 205270 | 2020-06-03 | San Sebastian | Puerto Rico | 72131 | 47 | |
205271 | 205271 | 2020-06-03 | Santa Isabel | Puerto Rico | 72133 | 17 | |
205272 | 205272 | 2020-06-03 | Toa Alta | Puerto Rico | 72135 | 96 | |
205273 | 205273 | 2020-06-03 | Toa Baja | Puerto Rico | 72137 | 113 | |
205274 | 205274 | 2020-06-03 | Trujillo Alto | Puerto Rico | 72139 | 75 | |
205275 | 205275 | 2020-06-03 | Unknown | Puerto Rico | 135 | 140 | |
205276 | 205276 | 2020-06-03 | Utuado | Puerto Rico | 72141 | 3 | |
205277 | 205277 | 2020-06-03 | Vega Alta | Puerto Rico | 72143 | 41 | |
205278 | 205278 | 2020-06-03 | Vega Baja | Puerto Rico | 72145 | 47 | |
205279 | 205279 | 2020-06-03 | Vieques | Puerto Rico | 72147 | 20 | |
205280 | 205280 | 2020-06-03 | Villalba | Puerto Rico | 72149 | 33 | |
205281 | 205281 | 2020-06-03 | Yabucoa | Puerto Rico | 72151 | 12 | |
205282 | 205282 | 2020-06-03 | Yauco | Puerto Rico | 72153 | 53 |
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);