ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 79
- - 792
- 72001 739
- 72003 739
- 72005 739
- 72007 739
- 72009 739
- 72011 739
- 72013 739
- 72015 739
- 72017 739
- 72019 739
- 72021 739
- 72023 739
- 72025 739
- 72027 739
- 72029 739
- 72031 739
- 72033 739
- 72035 739
- 72037 739
- 72039 739
- 72041 739
- 72043 739
- 72045 739
- 72047 739
- 72051 739
- 72053 739
- 72054 739
- 72055 739
- 72057 739
- 72059 739
- 72061 739
- 72063 739
- 72065 739
- 72067 739
- 72069 739
- 72071 739
- 72073 739
- 72075 739
- 72077 739
- 72079 739
- 72081 739
- 72083 739
- 72085 739
- 72087 739
- 72089 739
- 72091 739
- 72095 739
- 72097 739
- 72099 739
- 72101 739
- 72103 739
- 72105 739
- 72107 739
- 72109 739
- 72111 739
- 72113 739
- 72115 739
- 72117 739
- 72119 739
- 72121 739
- 72123 739
- 72125 739
- 72127 739
- 72129 739
- 72131 739
- 72133 739
- 72135 739
- 72137 739
- 72139 739
- 72141 739
- 72143 739
- 72145 739
- 72149 739
- 72151 739
- 72153 739
- 72147 737
- 72093 728
- 72049 715
county 79
- Unknown 792
- Adjuntas 739
- Aguada 739
- Aguadilla 739
- Aguas Buenas 739
- Aibonito 739
- Anasco 739
- Arecibo 739
- Arroyo 739
- Barceloneta 739
- Barranquitas 739
- Bayamon 739
- Cabo Rojo 739
- Caguas 739
- Camuy 739
- Canovanas 739
- Carolina 739
- Catano 739
- Cayey 739
- Ceiba 739
- Ciales 739
- Cidra 739
- Coamo 739
- Comerio 739
- Corozal 739
- Dorado 739
- Fajardo 739
- Florida 739
- Guanica 739
- Guayama 739
- Guayanilla 739
- Guaynabo 739
- Gurabo 739
- Hatillo 739
- Hormigueros 739
- Humacao 739
- Isabela 739
- Jayuya 739
- Juana Diaz 739
- Juncos 739
- Lajas 739
- Lares 739
- Las Marias 739
- Las Piedras 739
- Loiza 739
- Luquillo 739
- Manati 739
- Maunabo 739
- Mayaguez 739
- Moca 739
- Morovis 739
- Naguabo 739
- Naranjito 739
- Orocovis 739
- Patillas 739
- Penuelas 739
- Ponce 739
- Quebradillas 739
- Rincon 739
- Rio Grande 739
- Sabana Grande 739
- Salinas 739
- San German 739
- San Juan 739
- San Lorenzo 739
- San Sebastian 739
- Santa Isabel 739
- Toa Alta 739
- Toa Baja 739
- Trujillo Alto 739
- Utuado 739
- Vega Alta 739
- Vega Baja 739
- Villalba 739
- Yabucoa 739
- Yauco 739
- Vieques 737
- Maricao 728
- Culebra 715
state 1
- Puerto Rico · 58,397 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501914 | 2501914 | 2022-05-13 | Adjuntas | Puerto Rico | 72001 | 2814 | |
2501915 | 2501915 | 2022-05-13 | Aguada | Puerto Rico | 72003 | 7628 |
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);