ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-01-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 |
---|---|---|---|---|---|---|---|
2163515 | 2163515 | 2022-01-29 | Adjuntas | Puerto Rico | 72001 | 2031 | |
2163516 | 2163516 | 2022-01-29 | Aguada | Puerto Rico | 72003 | 5728 | |
2163517 | 2163517 | 2022-01-29 | Aguadilla | Puerto Rico | 72005 | 6632 | |
2163518 | 2163518 | 2022-01-29 | Aguas Buenas | Puerto Rico | 72007 | 3755 | |
2163519 | 2163519 | 2022-01-29 | Aibonito | Puerto Rico | 72009 | 3289 | |
2163520 | 2163520 | 2022-01-29 | Anasco | Puerto Rico | 72011 | 3268 | |
2163521 | 2163521 | 2022-01-29 | Arecibo | Puerto Rico | 72013 | 11685 | |
2163522 | 2163522 | 2022-01-29 | Arroyo | Puerto Rico | 72015 | 1714 | |
2163523 | 2163523 | 2022-01-29 | Barceloneta | Puerto Rico | 72017 | 2966 | |
2163524 | 2163524 | 2022-01-29 | Barranquitas | Puerto Rico | 72019 | 4373 | |
2163525 | 2163525 | 2022-01-29 | Bayamon | Puerto Rico | 72021 | 31977 | |
2163526 | 2163526 | 2022-01-29 | Cabo Rojo | Puerto Rico | 72023 | 4727 | |
2163527 | 2163527 | 2022-01-29 | Caguas | Puerto Rico | 72025 | 20302 | |
2163528 | 2163528 | 2022-01-29 | Camuy | Puerto Rico | 72027 | 4357 | |
2163529 | 2163529 | 2022-01-29 | Canovanas | Puerto Rico | 72029 | 6122 | |
2163530 | 2163530 | 2022-01-29 | Carolina | Puerto Rico | 72031 | 26239 | |
2163531 | 2163531 | 2022-01-29 | Catano | Puerto Rico | 72033 | 3906 | |
2163532 | 2163532 | 2022-01-29 | Cayey | Puerto Rico | 72035 | 5454 | |
2163533 | 2163533 | 2022-01-29 | Ceiba | Puerto Rico | 72037 | 1278 | |
2163534 | 2163534 | 2022-01-29 | Ciales | Puerto Rico | 72039 | 2366 | |
2163535 | 2163535 | 2022-01-29 | Cidra | Puerto Rico | 72041 | 5225 | |
2163536 | 2163536 | 2022-01-29 | Coamo | Puerto Rico | 72043 | 4119 | |
2163537 | 2163537 | 2022-01-29 | Comerio | Puerto Rico | 72045 | 2641 | |
2163538 | 2163538 | 2022-01-29 | Corozal | Puerto Rico | 72047 | 5810 | |
2163539 | 2163539 | 2022-01-29 | Culebra | Puerto Rico | 72049 | 159 | |
2163540 | 2163540 | 2022-01-29 | Dorado | Puerto Rico | 72051 | 6323 | |
2163541 | 2163541 | 2022-01-29 | Fajardo | Puerto Rico | 72053 | 4272 | |
2163542 | 2163542 | 2022-01-29 | Florida | Puerto Rico | 72054 | 2266 | |
2163543 | 2163543 | 2022-01-29 | Guanica | Puerto Rico | 72055 | 1353 | |
2163544 | 2163544 | 2022-01-29 | Guayama | Puerto Rico | 72057 | 4279 | |
2163545 | 2163545 | 2022-01-29 | Guayanilla | Puerto Rico | 72059 | 1872 | |
2163546 | 2163546 | 2022-01-29 | Guaynabo | Puerto Rico | 72061 | 14344 | |
2163547 | 2163547 | 2022-01-29 | Gurabo | Puerto Rico | 72063 | 6775 | |
2163548 | 2163548 | 2022-01-29 | Hatillo | Puerto Rico | 72065 | 4801 | |
2163549 | 2163549 | 2022-01-29 | Hormigueros | Puerto Rico | 72067 | 1679 | |
2163550 | 2163550 | 2022-01-29 | Humacao | Puerto Rico | 72069 | 7220 | |
2163551 | 2163551 | 2022-01-29 | Isabela | Puerto Rico | 72071 | 6031 | |
2163552 | 2163552 | 2022-01-29 | Jayuya | Puerto Rico | 72073 | 1916 | |
2163553 | 2163553 | 2022-01-29 | Juana Diaz | Puerto Rico | 72075 | 5348 | |
2163554 | 2163554 | 2022-01-29 | Juncos | Puerto Rico | 72077 | 5812 | |
2163555 | 2163555 | 2022-01-29 | Lajas | Puerto Rico | 72079 | 2276 | |
2163556 | 2163556 | 2022-01-29 | Lares | Puerto Rico | 72081 | 3451 | |
2163557 | 2163557 | 2022-01-29 | Las Marias | Puerto Rico | 72083 | 995 | |
2163558 | 2163558 | 2022-01-29 | Las Piedras | Puerto Rico | 72085 | 4945 | |
2163559 | 2163559 | 2022-01-29 | Loiza | Puerto Rico | 72087 | 3028 | |
2163560 | 2163560 | 2022-01-29 | Luquillo | Puerto Rico | 72089 | 2347 | |
2163561 | 2163561 | 2022-01-29 | Manati | Puerto Rico | 72091 | 5573 | |
2163562 | 2163562 | 2022-01-29 | Maricao | Puerto Rico | 72093 | 497 | |
2163563 | 2163563 | 2022-01-29 | Maunabo | Puerto Rico | 72095 | 1294 | |
2163564 | 2163564 | 2022-01-29 | Mayaguez | Puerto Rico | 72097 | 9010 | |
2163565 | 2163565 | 2022-01-29 | Moca | Puerto Rico | 72099 | 5394 | |
2163566 | 2163566 | 2022-01-29 | Morovis | Puerto Rico | 72101 | 4282 | |
2163567 | 2163567 | 2022-01-29 | Naguabo | Puerto Rico | 72103 | 3093 | |
2163568 | 2163568 | 2022-01-29 | Naranjito | Puerto Rico | 72105 | 4772 | |
2163569 | 2163569 | 2022-01-29 | Orocovis | Puerto Rico | 72107 | 2654 | |
2163570 | 2163570 | 2022-01-29 | Patillas | Puerto Rico | 72109 | 1878 | |
2163571 | 2163571 | 2022-01-29 | Penuelas | Puerto Rico | 72111 | 2053 | |
2163572 | 2163572 | 2022-01-29 | Ponce | Puerto Rico | 72113 | 16124 | |
2163573 | 2163573 | 2022-01-29 | Quebradillas | Puerto Rico | 72115 | 3374 | |
2163574 | 2163574 | 2022-01-29 | Rincon | Puerto Rico | 72117 | 2022 | |
2163575 | 2163575 | 2022-01-29 | Rio Grande | Puerto Rico | 72119 | 7031 | |
2163576 | 2163576 | 2022-01-29 | Sabana Grande | Puerto Rico | 72121 | 2089 | |
2163577 | 2163577 | 2022-01-29 | Salinas | Puerto Rico | 72123 | 3188 | |
2163578 | 2163578 | 2022-01-29 | San German | Puerto Rico | 72125 | 3264 | |
2163579 | 2163579 | 2022-01-29 | San Juan | Puerto Rico | 72127 | 57502 | |
2163580 | 2163580 | 2022-01-29 | San Lorenzo | Puerto Rico | 72129 | 5029 | |
2163581 | 2163581 | 2022-01-29 | San Sebastian | Puerto Rico | 72131 | 5768 | |
2163582 | 2163582 | 2022-01-29 | Santa Isabel | Puerto Rico | 72133 | 2346 | |
2163583 | 2163583 | 2022-01-29 | Toa Alta | Puerto Rico | 72135 | 11286 | |
2163584 | 2163584 | 2022-01-29 | Toa Baja | Puerto Rico | 72137 | 12078 | |
2163585 | 2163585 | 2022-01-29 | Trujillo Alto | Puerto Rico | 72139 | 9314 | |
2163586 | 2163586 | 2022-01-29 | Unknown | Puerto Rico | 16104 | 3837 | |
2163587 | 2163587 | 2022-01-29 | Utuado | Puerto Rico | 72141 | 3079 | |
2163588 | 2163588 | 2022-01-29 | Vega Alta | Puerto Rico | 72143 | 5825 | |
2163589 | 2163589 | 2022-01-29 | Vega Baja | Puerto Rico | 72145 | 9820 | |
2163590 | 2163590 | 2022-01-29 | Vieques | Puerto Rico | 72147 | 662 | |
2163591 | 2163591 | 2022-01-29 | Villalba | Puerto Rico | 72149 | 2805 | |
2163592 | 2163592 | 2022-01-29 | Yabucoa | Puerto Rico | 72151 | 4054 | |
2163593 | 2163593 | 2022-01-29 | Yauco | Puerto Rico | 72153 | 3903 |
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);