ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-06-02 and state = "Puerto Rico" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
202127 | 202127 | 2020-06-02 | Adjuntas | Puerto Rico | 72001 | 25 | |
202128 | 202128 | 2020-06-02 | Aguada | Puerto Rico | 72003 | 20 | |
202129 | 202129 | 2020-06-02 | Aguadilla | Puerto Rico | 72005 | 21 | |
202130 | 202130 | 2020-06-02 | Aguas Buenas | Puerto Rico | 72007 | 39 | |
202131 | 202131 | 2020-06-02 | Aibonito | Puerto Rico | 72009 | 25 | |
202132 | 202132 | 2020-06-02 | Anasco | Puerto Rico | 72011 | 24 | |
202133 | 202133 | 2020-06-02 | Arecibo | Puerto Rico | 72013 | 64 | |
202134 | 202134 | 2020-06-02 | Arroyo | Puerto Rico | 72015 | 15 | |
202135 | 202135 | 2020-06-02 | Barceloneta | Puerto Rico | 72017 | 11 | |
202136 | 202136 | 2020-06-02 | Barranquitas | Puerto Rico | 72019 | 40 | |
202137 | 202137 | 2020-06-02 | Bayamon | Puerto Rico | 72021 | 239 | |
202138 | 202138 | 2020-06-02 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
202139 | 202139 | 2020-06-02 | Caguas | Puerto Rico | 72025 | 128 | |
202140 | 202140 | 2020-06-02 | Camuy | Puerto Rico | 72027 | 10 | |
202141 | 202141 | 2020-06-02 | Canovanas | Puerto Rico | 72029 | 74 | |
202142 | 202142 | 2020-06-02 | Carolina | Puerto Rico | 72031 | 168 | |
202143 | 202143 | 2020-06-02 | Catano | Puerto Rico | 72033 | 18 | |
202144 | 202144 | 2020-06-02 | Cayey | Puerto Rico | 72035 | 55 | |
202145 | 202145 | 2020-06-02 | Ceiba | Puerto Rico | 72037 | 15 | |
202146 | 202146 | 2020-06-02 | Ciales | Puerto Rico | 72039 | 20 | |
202147 | 202147 | 2020-06-02 | Cidra | Puerto Rico | 72041 | 46 | |
202148 | 202148 | 2020-06-02 | Coamo | Puerto Rico | 72043 | 15 | |
202149 | 202149 | 2020-06-02 | Comerio | Puerto Rico | 72045 | 24 | |
202150 | 202150 | 2020-06-02 | Corozal | Puerto Rico | 72047 | 30 | |
202151 | 202151 | 2020-06-02 | Culebra | Puerto Rico | 72049 | 1 | |
202152 | 202152 | 2020-06-02 | Dorado | Puerto Rico | 72051 | 62 | |
202153 | 202153 | 2020-06-02 | Fajardo | Puerto Rico | 72053 | 28 | |
202154 | 202154 | 2020-06-02 | Florida | Puerto Rico | 72054 | 14 | |
202155 | 202155 | 2020-06-02 | Guanica | Puerto Rico | 72055 | 22 | |
202156 | 202156 | 2020-06-02 | Guayama | Puerto Rico | 72057 | 40 | |
202157 | 202157 | 2020-06-02 | Guayanilla | Puerto Rico | 72059 | 21 | |
202158 | 202158 | 2020-06-02 | Guaynabo | Puerto Rico | 72061 | 202 | |
202159 | 202159 | 2020-06-02 | Gurabo | Puerto Rico | 72063 | 50 | |
202160 | 202160 | 2020-06-02 | Hatillo | Puerto Rico | 72065 | 18 | |
202161 | 202161 | 2020-06-02 | Hormigueros | Puerto Rico | 72067 | 18 | |
202162 | 202162 | 2020-06-02 | Humacao | Puerto Rico | 72069 | 44 | |
202163 | 202163 | 2020-06-02 | Isabela | Puerto Rico | 72071 | 24 | |
202164 | 202164 | 2020-06-02 | Jayuya | Puerto Rico | 72073 | 10 | |
202165 | 202165 | 2020-06-02 | Juana Diaz | Puerto Rico | 72075 | 43 | |
202166 | 202166 | 2020-06-02 | Juncos | Puerto Rico | 72077 | 21 | |
202167 | 202167 | 2020-06-02 | Lajas | Puerto Rico | 72079 | 18 | |
202168 | 202168 | 2020-06-02 | Lares | Puerto Rico | 72081 | 41 | |
202169 | 202169 | 2020-06-02 | Las Marias | Puerto Rico | 72083 | 11 | |
202170 | 202170 | 2020-06-02 | Las Piedras | Puerto Rico | 72085 | 26 | |
202171 | 202171 | 2020-06-02 | Loiza | Puerto Rico | 72087 | 22 | |
202172 | 202172 | 2020-06-02 | Luquillo | Puerto Rico | 72089 | 20 | |
202173 | 202173 | 2020-06-02 | Manati | Puerto Rico | 72091 | 26 | |
202174 | 202174 | 2020-06-02 | Maricao | Puerto Rico | 72093 | 3 | |
202175 | 202175 | 2020-06-02 | Maunabo | Puerto Rico | 72095 | 17 | |
202176 | 202176 | 2020-06-02 | Mayaguez | Puerto Rico | 72097 | 95 | |
202177 | 202177 | 2020-06-02 | Moca | Puerto Rico | 72099 | 25 | |
202178 | 202178 | 2020-06-02 | Morovis | Puerto Rico | 72101 | 40 | |
202179 | 202179 | 2020-06-02 | Naguabo | Puerto Rico | 72103 | 25 | |
202180 | 202180 | 2020-06-02 | Naranjito | Puerto Rico | 72105 | 53 | |
202181 | 202181 | 2020-06-02 | Orocovis | Puerto Rico | 72107 | 50 | |
202182 | 202182 | 2020-06-02 | Patillas | Puerto Rico | 72109 | 34 | |
202183 | 202183 | 2020-06-02 | Penuelas | Puerto Rico | 72111 | 14 | |
202184 | 202184 | 2020-06-02 | Ponce | Puerto Rico | 72113 | 115 | |
202185 | 202185 | 2020-06-02 | Quebradillas | Puerto Rico | 72115 | 28 | |
202186 | 202186 | 2020-06-02 | Rincon | Puerto Rico | 72117 | 18 | |
202187 | 202187 | 2020-06-02 | Rio Grande | Puerto Rico | 72119 | 56 | |
202188 | 202188 | 2020-06-02 | Sabana Grande | Puerto Rico | 72121 | 29 | |
202189 | 202189 | 2020-06-02 | Salinas | Puerto Rico | 72123 | 70 | |
202190 | 202190 | 2020-06-02 | San German | Puerto Rico | 72125 | 36 | |
202191 | 202191 | 2020-06-02 | San Juan | Puerto Rico | 72127 | 567 | |
202192 | 202192 | 2020-06-02 | San Lorenzo | Puerto Rico | 72129 | 42 | |
202193 | 202193 | 2020-06-02 | San Sebastian | Puerto Rico | 72131 | 47 | |
202194 | 202194 | 2020-06-02 | Santa Isabel | Puerto Rico | 72133 | 17 | |
202195 | 202195 | 2020-06-02 | Toa Alta | Puerto Rico | 72135 | 94 | |
202196 | 202196 | 2020-06-02 | Toa Baja | Puerto Rico | 72137 | 105 | |
202197 | 202197 | 2020-06-02 | Trujillo Alto | Puerto Rico | 72139 | 69 | |
202198 | 202198 | 2020-06-02 | Unknown | Puerto Rico | 133 | 138 | |
202199 | 202199 | 2020-06-02 | Utuado | Puerto Rico | 72141 | 3 | |
202200 | 202200 | 2020-06-02 | Vega Alta | Puerto Rico | 72143 | 40 | |
202201 | 202201 | 2020-06-02 | Vega Baja | Puerto Rico | 72145 | 46 | |
202202 | 202202 | 2020-06-02 | Vieques | Puerto Rico | 72147 | 20 | |
202203 | 202203 | 2020-06-02 | Villalba | Puerto Rico | 72149 | 29 | |
202204 | 202204 | 2020-06-02 | Yabucoa | Puerto Rico | 72151 | 12 | |
202205 | 202205 | 2020-06-02 | Yauco | Puerto Rico | 72153 | 53 |
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);