ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1705236 | 1705236 | 2021-09-10 | Adjuntas | Puerto Rico | 72001 | 650 | |
1705237 | 1705237 | 2021-09-10 | Aguada | Puerto Rico | 72003 | 2362 | |
1705238 | 1705238 | 2021-09-10 | Aguadilla | Puerto Rico | 72005 | 2941 | |
1705239 | 1705239 | 2021-09-10 | Aguas Buenas | Puerto Rico | 72007 | 1595 | |
1705240 | 1705240 | 2021-09-10 | Aibonito | Puerto Rico | 72009 | 972 | |
1705241 | 1705241 | 2021-09-10 | Anasco | Puerto Rico | 72011 | 1389 | |
1705242 | 1705242 | 2021-09-10 | Arecibo | Puerto Rico | 72013 | 4329 | |
1705243 | 1705243 | 2021-09-10 | Arroyo | Puerto Rico | 72015 | 531 | |
1705244 | 1705244 | 2021-09-10 | Barceloneta | Puerto Rico | 72017 | 1132 | |
1705245 | 1705245 | 2021-09-10 | Barranquitas | Puerto Rico | 72019 | 1792 | |
1705246 | 1705246 | 2021-09-10 | Bayamon | Puerto Rico | 72021 | 15115 | |
1705247 | 1705247 | 2021-09-10 | Cabo Rojo | Puerto Rico | 72023 | 1857 | |
1705248 | 1705248 | 2021-09-10 | Caguas | Puerto Rico | 72025 | 8686 | |
1705249 | 1705249 | 2021-09-10 | Camuy | Puerto Rico | 72027 | 1711 | |
1705250 | 1705250 | 2021-09-10 | Canovanas | Puerto Rico | 72029 | 2956 | |
1705251 | 1705251 | 2021-09-10 | Carolina | Puerto Rico | 72031 | 12440 | |
1705252 | 1705252 | 2021-09-10 | Catano | Puerto Rico | 72033 | 1858 | |
1705253 | 1705253 | 2021-09-10 | Cayey | Puerto Rico | 72035 | 1886 | |
1705254 | 1705254 | 2021-09-10 | Ceiba | Puerto Rico | 72037 | 643 | |
1705255 | 1705255 | 2021-09-10 | Ciales | Puerto Rico | 72039 | 1035 | |
1705256 | 1705256 | 2021-09-10 | Cidra | Puerto Rico | 72041 | 1833 | |
1705257 | 1705257 | 2021-09-10 | Coamo | Puerto Rico | 72043 | 1375 | |
1705258 | 1705258 | 2021-09-10 | Comerio | Puerto Rico | 72045 | 1030 | |
1705259 | 1705259 | 2021-09-10 | Corozal | Puerto Rico | 72047 | 2364 | |
1705260 | 1705260 | 2021-09-10 | Culebra | Puerto Rico | 72049 | 48 | |
1705261 | 1705261 | 2021-09-10 | Dorado | Puerto Rico | 72051 | 3291 | |
1705262 | 1705262 | 2021-09-10 | Fajardo | Puerto Rico | 72053 | 2073 | |
1705263 | 1705263 | 2021-09-10 | Florida | Puerto Rico | 72054 | 971 | |
1705264 | 1705264 | 2021-09-10 | Guanica | Puerto Rico | 72055 | 427 | |
1705265 | 1705265 | 2021-09-10 | Guayama | Puerto Rico | 72057 | 1305 | |
1705266 | 1705266 | 2021-09-10 | Guayanilla | Puerto Rico | 72059 | 655 | |
1705267 | 1705267 | 2021-09-10 | Guaynabo | Puerto Rico | 72061 | 6559 | |
1705268 | 1705268 | 2021-09-10 | Gurabo | Puerto Rico | 72063 | 2944 | |
1705269 | 1705269 | 2021-09-10 | Hatillo | Puerto Rico | 72065 | 1758 | |
1705270 | 1705270 | 2021-09-10 | Hormigueros | Puerto Rico | 72067 | 679 | |
1705271 | 1705271 | 2021-09-10 | Humacao | Puerto Rico | 72069 | 2924 | |
1705272 | 1705272 | 2021-09-10 | Isabela | Puerto Rico | 72071 | 2391 | |
1705273 | 1705273 | 2021-09-10 | Jayuya | Puerto Rico | 72073 | 632 | |
1705274 | 1705274 | 2021-09-10 | Juana Diaz | Puerto Rico | 72075 | 1678 | |
1705275 | 1705275 | 2021-09-10 | Juncos | Puerto Rico | 72077 | 2887 | |
1705276 | 1705276 | 2021-09-10 | Lajas | Puerto Rico | 72079 | 765 | |
1705277 | 1705277 | 2021-09-10 | Lares | Puerto Rico | 72081 | 1354 | |
1705278 | 1705278 | 2021-09-10 | Las Marias | Puerto Rico | 72083 | 397 | |
1705279 | 1705279 | 2021-09-10 | Las Piedras | Puerto Rico | 72085 | 2226 | |
1705280 | 1705280 | 2021-09-10 | Loiza | Puerto Rico | 72087 | 1685 | |
1705281 | 1705281 | 2021-09-10 | Luquillo | Puerto Rico | 72089 | 1183 | |
1705282 | 1705282 | 2021-09-10 | Manati | Puerto Rico | 72091 | 2256 | |
1705283 | 1705283 | 2021-09-10 | Maricao | Puerto Rico | 72093 | 178 | |
1705284 | 1705284 | 2021-09-10 | Maunabo | Puerto Rico | 72095 | 539 | |
1705285 | 1705285 | 2021-09-10 | Mayaguez | Puerto Rico | 72097 | 3755 | |
1705286 | 1705286 | 2021-09-10 | Moca | Puerto Rico | 72099 | 2366 | |
1705287 | 1705287 | 2021-09-10 | Morovis | Puerto Rico | 72101 | 1937 | |
1705288 | 1705288 | 2021-09-10 | Naguabo | Puerto Rico | 72103 | 1409 | |
1705289 | 1705289 | 2021-09-10 | Naranjito | Puerto Rico | 72105 | 2323 | |
1705290 | 1705290 | 2021-09-10 | Orocovis | Puerto Rico | 72107 | 1193 | |
1705291 | 1705291 | 2021-09-10 | Patillas | Puerto Rico | 72109 | 547 | |
1705292 | 1705292 | 2021-09-10 | Penuelas | Puerto Rico | 72111 | 766 | |
1705293 | 1705293 | 2021-09-10 | Ponce | Puerto Rico | 72113 | 5195 | |
1705294 | 1705294 | 2021-09-10 | Quebradillas | Puerto Rico | 72115 | 1306 | |
1705295 | 1705295 | 2021-09-10 | Rincon | Puerto Rico | 72117 | 901 | |
1705296 | 1705296 | 2021-09-10 | Rio Grande | Puerto Rico | 72119 | 3127 | |
1705297 | 1705297 | 2021-09-10 | Sabana Grande | Puerto Rico | 72121 | 744 | |
1705298 | 1705298 | 2021-09-10 | Salinas | Puerto Rico | 72123 | 1402 | |
1705299 | 1705299 | 2021-09-10 | San German | Puerto Rico | 72125 | 1092 | |
1705300 | 1705300 | 2021-09-10 | San Juan | Puerto Rico | 72127 | 27812 | |
1705301 | 1705301 | 2021-09-10 | San Lorenzo | Puerto Rico | 72129 | 2332 | |
1705302 | 1705302 | 2021-09-10 | San Sebastian | Puerto Rico | 72131 | 2428 | |
1705303 | 1705303 | 2021-09-10 | Santa Isabel | Puerto Rico | 72133 | 806 | |
1705304 | 1705304 | 2021-09-10 | Toa Alta | Puerto Rico | 72135 | 5562 | |
1705305 | 1705305 | 2021-09-10 | Toa Baja | Puerto Rico | 72137 | 5938 | |
1705306 | 1705306 | 2021-09-10 | Trujillo Alto | Puerto Rico | 72139 | 4408 | |
1705307 | 1705307 | 2021-09-10 | Unknown | Puerto Rico | 5249 | 2984 | |
1705308 | 1705308 | 2021-09-10 | Utuado | Puerto Rico | 72141 | 1273 | |
1705309 | 1705309 | 2021-09-10 | Vega Alta | Puerto Rico | 72143 | 2853 | |
1705310 | 1705310 | 2021-09-10 | Vega Baja | Puerto Rico | 72145 | 4254 | |
1705311 | 1705311 | 2021-09-10 | Vieques | Puerto Rico | 72147 | 260 | |
1705312 | 1705312 | 2021-09-10 | Villalba | Puerto Rico | 72149 | 1003 | |
1705313 | 1705313 | 2021-09-10 | Yabucoa | Puerto Rico | 72151 | 1585 | |
1705314 | 1705314 | 2021-09-10 | Yauco | Puerto Rico | 72153 | 1398 |
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);