ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-04-29" 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 |
---|---|---|---|---|---|---|---|
2456315 | 2456315 | 2022-04-29 | Adjuntas | Puerto Rico | 72001 | 2442 | |
2456316 | 2456316 | 2022-04-29 | Aguada | Puerto Rico | 72003 | 6794 | |
2456317 | 2456317 | 2022-04-29 | Aguadilla | Puerto Rico | 72005 | 7765 | |
2456318 | 2456318 | 2022-04-29 | Aguas Buenas | Puerto Rico | 72007 | 4253 | |
2456319 | 2456319 | 2022-04-29 | Aibonito | Puerto Rico | 72009 | 3896 | |
2456320 | 2456320 | 2022-04-29 | Anasco | Puerto Rico | 72011 | 3937 | |
2456321 | 2456321 | 2022-04-29 | Arecibo | Puerto Rico | 72013 | 13794 | |
2456322 | 2456322 | 2022-04-29 | Arroyo | Puerto Rico | 72015 | 2220 | |
2456323 | 2456323 | 2022-04-29 | Barceloneta | Puerto Rico | 72017 | 3622 | |
2456324 | 2456324 | 2022-04-29 | Barranquitas | Puerto Rico | 72019 | 5050 | |
2456325 | 2456325 | 2022-04-29 | Bayamon | Puerto Rico | 72021 | 36335 | |
2456326 | 2456326 | 2022-04-29 | Cabo Rojo | Puerto Rico | 72023 | 5654 | |
2456327 | 2456327 | 2022-04-29 | Caguas | Puerto Rico | 72025 | 22925 | |
2456328 | 2456328 | 2022-04-29 | Camuy | Puerto Rico | 72027 | 5392 | |
2456329 | 2456329 | 2022-04-29 | Canovanas | Puerto Rico | 72029 | 6840 | |
2456330 | 2456330 | 2022-04-29 | Carolina | Puerto Rico | 72031 | 30031 | |
2456331 | 2456331 | 2022-04-29 | Catano | Puerto Rico | 72033 | 4419 | |
2456332 | 2456332 | 2022-04-29 | Cayey | Puerto Rico | 72035 | 6473 | |
2456333 | 2456333 | 2022-04-29 | Ceiba | Puerto Rico | 72037 | 1496 | |
2456334 | 2456334 | 2022-04-29 | Ciales | Puerto Rico | 72039 | 2793 | |
2456335 | 2456335 | 2022-04-29 | Cidra | Puerto Rico | 72041 | 6241 | |
2456336 | 2456336 | 2022-04-29 | Coamo | Puerto Rico | 72043 | 5193 | |
2456337 | 2456337 | 2022-04-29 | Comerio | Puerto Rico | 72045 | 3040 | |
2456338 | 2456338 | 2022-04-29 | Corozal | Puerto Rico | 72047 | 6667 | |
2456339 | 2456339 | 2022-04-29 | Culebra | Puerto Rico | 72049 | 190 | |
2456340 | 2456340 | 2022-04-29 | Dorado | Puerto Rico | 72051 | 7194 | |
2456341 | 2456341 | 2022-04-29 | Fajardo | Puerto Rico | 72053 | 4927 | |
2456342 | 2456342 | 2022-04-29 | Florida | Puerto Rico | 72054 | 2665 | |
2456343 | 2456343 | 2022-04-29 | Guanica | Puerto Rico | 72055 | 1596 | |
2456344 | 2456344 | 2022-04-29 | Guayama | Puerto Rico | 72057 | 5400 | |
2456345 | 2456345 | 2022-04-29 | Guayanilla | Puerto Rico | 72059 | 2315 | |
2456346 | 2456346 | 2022-04-29 | Guaynabo | Puerto Rico | 72061 | 16830 | |
2456347 | 2456347 | 2022-04-29 | Gurabo | Puerto Rico | 72063 | 7781 | |
2456348 | 2456348 | 2022-04-29 | Hatillo | Puerto Rico | 72065 | 5650 | |
2456349 | 2456349 | 2022-04-29 | Hormigueros | Puerto Rico | 72067 | 2146 | |
2456350 | 2456350 | 2022-04-29 | Humacao | Puerto Rico | 72069 | 8321 | |
2456351 | 2456351 | 2022-04-29 | Isabela | Puerto Rico | 72071 | 7000 | |
2456352 | 2456352 | 2022-04-29 | Jayuya | Puerto Rico | 72073 | 2379 | |
2456353 | 2456353 | 2022-04-29 | Juana Diaz | Puerto Rico | 72075 | 6659 | |
2456354 | 2456354 | 2022-04-29 | Juncos | Puerto Rico | 72077 | 6621 | |
2456355 | 2456355 | 2022-04-29 | Lajas | Puerto Rico | 72079 | 2774 | |
2456356 | 2456356 | 2022-04-29 | Lares | Puerto Rico | 72081 | 4260 | |
2456357 | 2456357 | 2022-04-29 | Las Marias | Puerto Rico | 72083 | 1163 | |
2456358 | 2456358 | 2022-04-29 | Las Piedras | Puerto Rico | 72085 | 5784 | |
2456359 | 2456359 | 2022-04-29 | Loiza | Puerto Rico | 72087 | 3555 | |
2456360 | 2456360 | 2022-04-29 | Luquillo | Puerto Rico | 72089 | 2679 | |
2456361 | 2456361 | 2022-04-29 | Manati | Puerto Rico | 72091 | 6569 | |
2456362 | 2456362 | 2022-04-29 | Maricao | Puerto Rico | 72093 | 596 | |
2456363 | 2456363 | 2022-04-29 | Maunabo | Puerto Rico | 72095 | 1468 | |
2456364 | 2456364 | 2022-04-29 | Mayaguez | Puerto Rico | 72097 | 10487 | |
2456365 | 2456365 | 2022-04-29 | Moca | Puerto Rico | 72099 | 6449 | |
2456366 | 2456366 | 2022-04-29 | Morovis | Puerto Rico | 72101 | 5193 | |
2456367 | 2456367 | 2022-04-29 | Naguabo | Puerto Rico | 72103 | 3577 | |
2456368 | 2456368 | 2022-04-29 | Naranjito | Puerto Rico | 72105 | 5367 | |
2456369 | 2456369 | 2022-04-29 | Orocovis | Puerto Rico | 72107 | 3108 | |
2456370 | 2456370 | 2022-04-29 | Patillas | Puerto Rico | 72109 | 2365 | |
2456371 | 2456371 | 2022-04-29 | Penuelas | Puerto Rico | 72111 | 2438 | |
2456372 | 2456372 | 2022-04-29 | Ponce | Puerto Rico | 72113 | 19465 | |
2456373 | 2456373 | 2022-04-29 | Quebradillas | Puerto Rico | 72115 | 4257 | |
2456374 | 2456374 | 2022-04-29 | Rincon | Puerto Rico | 72117 | 2334 | |
2456375 | 2456375 | 2022-04-29 | Rio Grande | Puerto Rico | 72119 | 7947 | |
2456376 | 2456376 | 2022-04-29 | Sabana Grande | Puerto Rico | 72121 | 2519 | |
2456377 | 2456377 | 2022-04-29 | Salinas | Puerto Rico | 72123 | 3861 | |
2456378 | 2456378 | 2022-04-29 | San German | Puerto Rico | 72125 | 3987 | |
2456379 | 2456379 | 2022-04-29 | San Juan | Puerto Rico | 72127 | 63415 | |
2456380 | 2456380 | 2022-04-29 | San Lorenzo | Puerto Rico | 72129 | 5733 | |
2456381 | 2456381 | 2022-04-29 | San Sebastian | Puerto Rico | 72131 | 6534 | |
2456382 | 2456382 | 2022-04-29 | Santa Isabel | Puerto Rico | 72133 | 2878 | |
2456383 | 2456383 | 2022-04-29 | Toa Alta | Puerto Rico | 72135 | 12690 | |
2456384 | 2456384 | 2022-04-29 | Toa Baja | Puerto Rico | 72137 | 13697 | |
2456385 | 2456385 | 2022-04-29 | Trujillo Alto | Puerto Rico | 72139 | 10693 | |
2456386 | 2456386 | 2022-04-29 | Unknown | Puerto Rico | 18029 | 4201 | |
2456387 | 2456387 | 2022-04-29 | Utuado | Puerto Rico | 72141 | 3644 | |
2456388 | 2456388 | 2022-04-29 | Vega Alta | Puerto Rico | 72143 | 6542 | |
2456389 | 2456389 | 2022-04-29 | Vega Baja | Puerto Rico | 72145 | 10935 | |
2456390 | 2456390 | 2022-04-29 | Vieques | Puerto Rico | 72147 | 811 | |
2456391 | 2456391 | 2022-04-29 | Villalba | Puerto Rico | 72149 | 3461 | |
2456392 | 2456392 | 2022-04-29 | Yabucoa | Puerto Rico | 72151 | 4832 | |
2456393 | 2456393 | 2022-04-29 | Yauco | Puerto Rico | 72153 | 4674 |
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);