ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-09-30" 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 |
---|---|---|---|---|---|---|---|
1770208 | 1770208 | 2021-09-30 | Adjuntas | Puerto Rico | 72001 | 664 | |
1770209 | 1770209 | 2021-09-30 | Aguada | Puerto Rico | 72003 | 2404 | |
1770210 | 1770210 | 2021-09-30 | Aguadilla | Puerto Rico | 72005 | 3023 | |
1770211 | 1770211 | 2021-09-30 | Aguas Buenas | Puerto Rico | 72007 | 1623 | |
1770212 | 1770212 | 2021-09-30 | Aibonito | Puerto Rico | 72009 | 1013 | |
1770213 | 1770213 | 2021-09-30 | Anasco | Puerto Rico | 72011 | 1407 | |
1770214 | 1770214 | 2021-09-30 | Arecibo | Puerto Rico | 72013 | 4526 | |
1770215 | 1770215 | 2021-09-30 | Arroyo | Puerto Rico | 72015 | 544 | |
1770216 | 1770216 | 2021-09-30 | Barceloneta | Puerto Rico | 72017 | 1170 | |
1770217 | 1770217 | 2021-09-30 | Barranquitas | Puerto Rico | 72019 | 1833 | |
1770218 | 1770218 | 2021-09-30 | Bayamon | Puerto Rico | 72021 | 15523 | |
1770219 | 1770219 | 2021-09-30 | Cabo Rojo | Puerto Rico | 72023 | 1891 | |
1770220 | 1770220 | 2021-09-30 | Caguas | Puerto Rico | 72025 | 8855 | |
1770221 | 1770221 | 2021-09-30 | Camuy | Puerto Rico | 72027 | 1747 | |
1770222 | 1770222 | 2021-09-30 | Canovanas | Puerto Rico | 72029 | 3040 | |
1770223 | 1770223 | 2021-09-30 | Carolina | Puerto Rico | 72031 | 12823 | |
1770224 | 1770224 | 2021-09-30 | Catano | Puerto Rico | 72033 | 1897 | |
1770225 | 1770225 | 2021-09-30 | Cayey | Puerto Rico | 72035 | 1944 | |
1770226 | 1770226 | 2021-09-30 | Ceiba | Puerto Rico | 72037 | 649 | |
1770227 | 1770227 | 2021-09-30 | Ciales | Puerto Rico | 72039 | 1063 | |
1770228 | 1770228 | 2021-09-30 | Cidra | Puerto Rico | 72041 | 1882 | |
1770229 | 1770229 | 2021-09-30 | Coamo | Puerto Rico | 72043 | 1401 | |
1770230 | 1770230 | 2021-09-30 | Comerio | Puerto Rico | 72045 | 1052 | |
1770231 | 1770231 | 2021-09-30 | Corozal | Puerto Rico | 72047 | 2413 | |
1770232 | 1770232 | 2021-09-30 | Culebra | Puerto Rico | 72049 | 56 | |
1770233 | 1770233 | 2021-09-30 | Dorado | Puerto Rico | 72051 | 3349 | |
1770234 | 1770234 | 2021-09-30 | Fajardo | Puerto Rico | 72053 | 2134 | |
1770235 | 1770235 | 2021-09-30 | Florida | Puerto Rico | 72054 | 991 | |
1770236 | 1770236 | 2021-09-30 | Guanica | Puerto Rico | 72055 | 437 | |
1770237 | 1770237 | 2021-09-30 | Guayama | Puerto Rico | 72057 | 1338 | |
1770238 | 1770238 | 2021-09-30 | Guayanilla | Puerto Rico | 72059 | 665 | |
1770239 | 1770239 | 2021-09-30 | Guaynabo | Puerto Rico | 72061 | 6731 | |
1770240 | 1770240 | 2021-09-30 | Gurabo | Puerto Rico | 72063 | 3029 | |
1770241 | 1770241 | 2021-09-30 | Hatillo | Puerto Rico | 72065 | 1841 | |
1770242 | 1770242 | 2021-09-30 | Hormigueros | Puerto Rico | 72067 | 690 | |
1770243 | 1770243 | 2021-09-30 | Humacao | Puerto Rico | 72069 | 2984 | |
1770244 | 1770244 | 2021-09-30 | Isabela | Puerto Rico | 72071 | 2505 | |
1770245 | 1770245 | 2021-09-30 | Jayuya | Puerto Rico | 72073 | 643 | |
1770246 | 1770246 | 2021-09-30 | Juana Diaz | Puerto Rico | 72075 | 1730 | |
1770247 | 1770247 | 2021-09-30 | Juncos | Puerto Rico | 72077 | 2968 | |
1770248 | 1770248 | 2021-09-30 | Lajas | Puerto Rico | 72079 | 790 | |
1770249 | 1770249 | 2021-09-30 | Lares | Puerto Rico | 72081 | 1394 | |
1770250 | 1770250 | 2021-09-30 | Las Marias | Puerto Rico | 72083 | 402 | |
1770251 | 1770251 | 2021-09-30 | Las Piedras | Puerto Rico | 72085 | 2262 | |
1770252 | 1770252 | 2021-09-30 | Loiza | Puerto Rico | 72087 | 1720 | |
1770253 | 1770253 | 2021-09-30 | Luquillo | Puerto Rico | 72089 | 1218 | |
1770254 | 1770254 | 2021-09-30 | Manati | Puerto Rico | 72091 | 2313 | |
1770255 | 1770255 | 2021-09-30 | Maricao | Puerto Rico | 72093 | 178 | |
1770256 | 1770256 | 2021-09-30 | Maunabo | Puerto Rico | 72095 | 552 | |
1770257 | 1770257 | 2021-09-30 | Mayaguez | Puerto Rico | 72097 | 3844 | |
1770258 | 1770258 | 2021-09-30 | Moca | Puerto Rico | 72099 | 2402 | |
1770259 | 1770259 | 2021-09-30 | Morovis | Puerto Rico | 72101 | 1964 | |
1770260 | 1770260 | 2021-09-30 | Naguabo | Puerto Rico | 72103 | 1454 | |
1770261 | 1770261 | 2021-09-30 | Naranjito | Puerto Rico | 72105 | 2368 | |
1770262 | 1770262 | 2021-09-30 | Orocovis | Puerto Rico | 72107 | 1200 | |
1770263 | 1770263 | 2021-09-30 | Patillas | Puerto Rico | 72109 | 556 | |
1770264 | 1770264 | 2021-09-30 | Penuelas | Puerto Rico | 72111 | 776 | |
1770265 | 1770265 | 2021-09-30 | Ponce | Puerto Rico | 72113 | 5413 | |
1770266 | 1770266 | 2021-09-30 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1770267 | 1770267 | 2021-09-30 | Rincon | Puerto Rico | 72117 | 916 | |
1770268 | 1770268 | 2021-09-30 | Rio Grande | Puerto Rico | 72119 | 3211 | |
1770269 | 1770269 | 2021-09-30 | Sabana Grande | Puerto Rico | 72121 | 757 | |
1770270 | 1770270 | 2021-09-30 | Salinas | Puerto Rico | 72123 | 1429 | |
1770271 | 1770271 | 2021-09-30 | San German | Puerto Rico | 72125 | 1113 | |
1770272 | 1770272 | 2021-09-30 | San Juan | Puerto Rico | 72127 | 28493 | |
1770273 | 1770273 | 2021-09-30 | San Lorenzo | Puerto Rico | 72129 | 2368 | |
1770274 | 1770274 | 2021-09-30 | San Sebastian | Puerto Rico | 72131 | 2487 | |
1770275 | 1770275 | 2021-09-30 | Santa Isabel | Puerto Rico | 72133 | 844 | |
1770276 | 1770276 | 2021-09-30 | Toa Alta | Puerto Rico | 72135 | 5672 | |
1770277 | 1770277 | 2021-09-30 | Toa Baja | Puerto Rico | 72137 | 6074 | |
1770278 | 1770278 | 2021-09-30 | Trujillo Alto | Puerto Rico | 72139 | 4516 | |
1770279 | 1770279 | 2021-09-30 | Unknown | Puerto Rico | 5373 | 3149 | |
1770280 | 1770280 | 2021-09-30 | Utuado | Puerto Rico | 72141 | 1344 | |
1770281 | 1770281 | 2021-09-30 | Vega Alta | Puerto Rico | 72143 | 2904 | |
1770282 | 1770282 | 2021-09-30 | Vega Baja | Puerto Rico | 72145 | 4361 | |
1770283 | 1770283 | 2021-09-30 | Vieques | Puerto Rico | 72147 | 266 | |
1770284 | 1770284 | 2021-09-30 | Villalba | Puerto Rico | 72149 | 1014 | |
1770285 | 1770285 | 2021-09-30 | Yabucoa | Puerto Rico | 72151 | 1616 | |
1770286 | 1770286 | 2021-09-30 | Yauco | Puerto Rico | 72153 | 1428 |
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);