ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
494694 | 494694 | 2020-09-02 | Adjuntas | Puerto Rico | 72001 | 124 | |
494695 | 494695 | 2020-09-02 | Aguada | Puerto Rico | 72003 | 227 | |
494696 | 494696 | 2020-09-02 | Aguadilla | Puerto Rico | 72005 | 328 | |
494697 | 494697 | 2020-09-02 | Aguas Buenas | Puerto Rico | 72007 | 204 | |
494698 | 494698 | 2020-09-02 | Aibonito | Puerto Rico | 72009 | 124 | |
494699 | 494699 | 2020-09-02 | Anasco | Puerto Rico | 72011 | 192 | |
494700 | 494700 | 2020-09-02 | Arecibo | Puerto Rico | 72013 | 519 | |
494701 | 494701 | 2020-09-02 | Arroyo | Puerto Rico | 72015 | 129 | |
494702 | 494702 | 2020-09-02 | Barceloneta | Puerto Rico | 72017 | 128 | |
494703 | 494703 | 2020-09-02 | Barranquitas | Puerto Rico | 72019 | 347 | |
494704 | 494704 | 2020-09-02 | Bayamon | Puerto Rico | 72021 | 2650 | |
494705 | 494705 | 2020-09-02 | Cabo Rojo | Puerto Rico | 72023 | 280 | |
494706 | 494706 | 2020-09-02 | Caguas | Puerto Rico | 72025 | 1120 | |
494707 | 494707 | 2020-09-02 | Camuy | Puerto Rico | 72027 | 196 | |
494708 | 494708 | 2020-09-02 | Canovanas | Puerto Rico | 72029 | 524 | |
494709 | 494709 | 2020-09-02 | Carolina | Puerto Rico | 72031 | 1946 | |
494710 | 494710 | 2020-09-02 | Catano | Puerto Rico | 72033 | 309 | |
494711 | 494711 | 2020-09-02 | Cayey | Puerto Rico | 72035 | 272 | |
494712 | 494712 | 2020-09-02 | Ceiba | Puerto Rico | 72037 | 88 | |
494713 | 494713 | 2020-09-02 | Ciales | Puerto Rico | 72039 | 192 | |
494714 | 494714 | 2020-09-02 | Cidra | Puerto Rico | 72041 | 240 | |
494715 | 494715 | 2020-09-02 | Coamo | Puerto Rico | 72043 | 215 | |
494716 | 494716 | 2020-09-02 | Comerio | Puerto Rico | 72045 | 174 | |
494717 | 494717 | 2020-09-02 | Corozal | Puerto Rico | 72047 | 421 | |
494718 | 494718 | 2020-09-02 | Culebra | Puerto Rico | 72049 | 21 | |
494719 | 494719 | 2020-09-02 | Dorado | Puerto Rico | 72051 | 535 | |
494720 | 494720 | 2020-09-02 | Fajardo | Puerto Rico | 72053 | 360 | |
494721 | 494721 | 2020-09-02 | Florida | Puerto Rico | 72054 | 209 | |
494722 | 494722 | 2020-09-02 | Guanica | Puerto Rico | 72055 | 83 | |
494723 | 494723 | 2020-09-02 | Guayama | Puerto Rico | 72057 | 233 | |
494724 | 494724 | 2020-09-02 | Guayanilla | Puerto Rico | 72059 | 147 | |
494725 | 494725 | 2020-09-02 | Guaynabo | Puerto Rico | 72061 | 1310 | |
494726 | 494726 | 2020-09-02 | Gurabo | Puerto Rico | 72063 | 366 | |
494727 | 494727 | 2020-09-02 | Hatillo | Puerto Rico | 72065 | 197 | |
494728 | 494728 | 2020-09-02 | Hormigueros | Puerto Rico | 72067 | 128 | |
494729 | 494729 | 2020-09-02 | Humacao | Puerto Rico | 72069 | 313 | |
494730 | 494730 | 2020-09-02 | Isabela | Puerto Rico | 72071 | 212 | |
494731 | 494731 | 2020-09-02 | Jayuya | Puerto Rico | 72073 | 206 | |
494732 | 494732 | 2020-09-02 | Juana Diaz | Puerto Rico | 72075 | 272 | |
494733 | 494733 | 2020-09-02 | Juncos | Puerto Rico | 72077 | 247 | |
494734 | 494734 | 2020-09-02 | Lajas | Puerto Rico | 72079 | 118 | |
494735 | 494735 | 2020-09-02 | Lares | Puerto Rico | 72081 | 249 | |
494736 | 494736 | 2020-09-02 | Las Marias | Puerto Rico | 72083 | 80 | |
494737 | 494737 | 2020-09-02 | Las Piedras | Puerto Rico | 72085 | 284 | |
494738 | 494738 | 2020-09-02 | Loiza | Puerto Rico | 72087 | 190 | |
494739 | 494739 | 2020-09-02 | Luquillo | Puerto Rico | 72089 | 178 | |
494740 | 494740 | 2020-09-02 | Manati | Puerto Rico | 72091 | 367 | |
494741 | 494741 | 2020-09-02 | Maricao | Puerto Rico | 72093 | 58 | |
494742 | 494742 | 2020-09-02 | Maunabo | Puerto Rico | 72095 | 90 | |
494743 | 494743 | 2020-09-02 | Mayaguez | Puerto Rico | 72097 | 656 | |
494744 | 494744 | 2020-09-02 | Moca | Puerto Rico | 72099 | 258 | |
494745 | 494745 | 2020-09-02 | Morovis | Puerto Rico | 72101 | 409 | |
494746 | 494746 | 2020-09-02 | Naguabo | Puerto Rico | 72103 | 140 | |
494747 | 494747 | 2020-09-02 | Naranjito | Puerto Rico | 72105 | 480 | |
494748 | 494748 | 2020-09-02 | Orocovis | Puerto Rico | 72107 | 276 | |
494749 | 494749 | 2020-09-02 | Patillas | Puerto Rico | 72109 | 136 | |
494750 | 494750 | 2020-09-02 | Penuelas | Puerto Rico | 72111 | 98 | |
494751 | 494751 | 2020-09-02 | Ponce | Puerto Rico | 72113 | 667 | |
494752 | 494752 | 2020-09-02 | Quebradillas | Puerto Rico | 72115 | 118 | |
494753 | 494753 | 2020-09-02 | Rincon | Puerto Rico | 72117 | 129 | |
494754 | 494754 | 2020-09-02 | Rio Grande | Puerto Rico | 72119 | 441 | |
494755 | 494755 | 2020-09-02 | Sabana Grande | Puerto Rico | 72121 | 165 | |
494756 | 494756 | 2020-09-02 | Salinas | Puerto Rico | 72123 | 314 | |
494757 | 494757 | 2020-09-02 | San German | Puerto Rico | 72125 | 198 | |
494758 | 494758 | 2020-09-02 | San Juan | Puerto Rico | 72127 | 5462 | |
494759 | 494759 | 2020-09-02 | San Lorenzo | Puerto Rico | 72129 | 281 | |
494760 | 494760 | 2020-09-02 | San Sebastian | Puerto Rico | 72131 | 279 | |
494761 | 494761 | 2020-09-02 | Santa Isabel | Puerto Rico | 72133 | 135 | |
494762 | 494762 | 2020-09-02 | Toa Alta | Puerto Rico | 72135 | 947 | |
494763 | 494763 | 2020-09-02 | Toa Baja | Puerto Rico | 72137 | 920 | |
494764 | 494764 | 2020-09-02 | Trujillo Alto | Puerto Rico | 72139 | 764 | |
494765 | 494765 | 2020-09-02 | Unknown | Puerto Rico | 1356 | 443 | |
494766 | 494766 | 2020-09-02 | Utuado | Puerto Rico | 72141 | 103 | |
494767 | 494767 | 2020-09-02 | Vega Alta | Puerto Rico | 72143 | 482 | |
494768 | 494768 | 2020-09-02 | Vega Baja | Puerto Rico | 72145 | 669 | |
494769 | 494769 | 2020-09-02 | Vieques | Puerto Rico | 72147 | 87 | |
494770 | 494770 | 2020-09-02 | Villalba | Puerto Rico | 72149 | 98 | |
494771 | 494771 | 2020-09-02 | Yabucoa | Puerto Rico | 72151 | 214 | |
494772 | 494772 | 2020-09-02 | Yauco | Puerto Rico | 72153 | 319 |
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);