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-05-31 and state = "Puerto Rico" sorted by date descending
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 |
---|---|---|---|---|---|---|---|
195979 | 195979 | 2020-05-31 | Adjuntas | Puerto Rico | 72001 | 23 | |
195980 | 195980 | 2020-05-31 | Aguada | Puerto Rico | 72003 | 20 | |
195981 | 195981 | 2020-05-31 | Aguadilla | Puerto Rico | 72005 | 21 | |
195982 | 195982 | 2020-05-31 | Aguas Buenas | Puerto Rico | 72007 | 38 | |
195983 | 195983 | 2020-05-31 | Aibonito | Puerto Rico | 72009 | 24 | |
195984 | 195984 | 2020-05-31 | Anasco | Puerto Rico | 72011 | 22 | |
195985 | 195985 | 2020-05-31 | Arecibo | Puerto Rico | 72013 | 64 | |
195986 | 195986 | 2020-05-31 | Arroyo | Puerto Rico | 72015 | 15 | |
195987 | 195987 | 2020-05-31 | Barceloneta | Puerto Rico | 72017 | 11 | |
195988 | 195988 | 2020-05-31 | Barranquitas | Puerto Rico | 72019 | 39 | |
195989 | 195989 | 2020-05-31 | Bayamon | Puerto Rico | 72021 | 225 | |
195990 | 195990 | 2020-05-31 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
195991 | 195991 | 2020-05-31 | Caguas | Puerto Rico | 72025 | 119 | |
195992 | 195992 | 2020-05-31 | Camuy | Puerto Rico | 72027 | 9 | |
195993 | 195993 | 2020-05-31 | Canovanas | Puerto Rico | 72029 | 72 | |
195994 | 195994 | 2020-05-31 | Carolina | Puerto Rico | 72031 | 160 | |
195995 | 195995 | 2020-05-31 | Catano | Puerto Rico | 72033 | 18 | |
195996 | 195996 | 2020-05-31 | Cayey | Puerto Rico | 72035 | 52 | |
195997 | 195997 | 2020-05-31 | Ceiba | Puerto Rico | 72037 | 14 | |
195998 | 195998 | 2020-05-31 | Ciales | Puerto Rico | 72039 | 20 | |
195999 | 195999 | 2020-05-31 | Cidra | Puerto Rico | 72041 | 46 | |
196000 | 196000 | 2020-05-31 | Coamo | Puerto Rico | 72043 | 14 | |
196001 | 196001 | 2020-05-31 | Comerio | Puerto Rico | 72045 | 24 | |
196002 | 196002 | 2020-05-31 | Corozal | Puerto Rico | 72047 | 30 | |
196003 | 196003 | 2020-05-31 | Culebra | Puerto Rico | 72049 | 1 | |
196004 | 196004 | 2020-05-31 | Dorado | Puerto Rico | 72051 | 62 | |
196005 | 196005 | 2020-05-31 | Fajardo | Puerto Rico | 72053 | 22 | |
196006 | 196006 | 2020-05-31 | Florida | Puerto Rico | 72054 | 14 | |
196007 | 196007 | 2020-05-31 | Guanica | Puerto Rico | 72055 | 22 | |
196008 | 196008 | 2020-05-31 | Guayama | Puerto Rico | 72057 | 40 | |
196009 | 196009 | 2020-05-31 | Guayanilla | Puerto Rico | 72059 | 21 | |
196010 | 196010 | 2020-05-31 | Guaynabo | Puerto Rico | 72061 | 198 | |
196011 | 196011 | 2020-05-31 | Gurabo | Puerto Rico | 72063 | 48 | |
196012 | 196012 | 2020-05-31 | Hatillo | Puerto Rico | 72065 | 17 | |
196013 | 196013 | 2020-05-31 | Hormigueros | Puerto Rico | 72067 | 18 | |
196014 | 196014 | 2020-05-31 | Humacao | Puerto Rico | 72069 | 44 | |
196015 | 196015 | 2020-05-31 | Isabela | Puerto Rico | 72071 | 24 | |
196016 | 196016 | 2020-05-31 | Jayuya | Puerto Rico | 72073 | 9 | |
196017 | 196017 | 2020-05-31 | Juana Diaz | Puerto Rico | 72075 | 43 | |
196018 | 196018 | 2020-05-31 | Juncos | Puerto Rico | 72077 | 21 | |
196019 | 196019 | 2020-05-31 | Lajas | Puerto Rico | 72079 | 15 | |
196020 | 196020 | 2020-05-31 | Lares | Puerto Rico | 72081 | 38 | |
196021 | 196021 | 2020-05-31 | Las Marias | Puerto Rico | 72083 | 12 | |
196022 | 196022 | 2020-05-31 | Las Piedras | Puerto Rico | 72085 | 25 | |
196023 | 196023 | 2020-05-31 | Loiza | Puerto Rico | 72087 | 20 | |
196024 | 196024 | 2020-05-31 | Luquillo | Puerto Rico | 72089 | 19 | |
196025 | 196025 | 2020-05-31 | Manati | Puerto Rico | 72091 | 26 | |
196026 | 196026 | 2020-05-31 | Maricao | Puerto Rico | 72093 | 3 | |
196027 | 196027 | 2020-05-31 | Maunabo | Puerto Rico | 72095 | 15 | |
196028 | 196028 | 2020-05-31 | Mayaguez | Puerto Rico | 72097 | 92 | |
196029 | 196029 | 2020-05-31 | Moca | Puerto Rico | 72099 | 25 | |
196030 | 196030 | 2020-05-31 | Morovis | Puerto Rico | 72101 | 38 | |
196031 | 196031 | 2020-05-31 | Naguabo | Puerto Rico | 72103 | 24 | |
196032 | 196032 | 2020-05-31 | Naranjito | Puerto Rico | 72105 | 51 | |
196033 | 196033 | 2020-05-31 | Orocovis | Puerto Rico | 72107 | 50 | |
196034 | 196034 | 2020-05-31 | Patillas | Puerto Rico | 72109 | 33 | |
196035 | 196035 | 2020-05-31 | Penuelas | Puerto Rico | 72111 | 13 | |
196036 | 196036 | 2020-05-31 | Ponce | Puerto Rico | 72113 | 111 | |
196037 | 196037 | 2020-05-31 | Quebradillas | Puerto Rico | 72115 | 28 | |
196038 | 196038 | 2020-05-31 | Rincon | Puerto Rico | 72117 | 17 | |
196039 | 196039 | 2020-05-31 | Rio Grande | Puerto Rico | 72119 | 52 | |
196040 | 196040 | 2020-05-31 | Sabana Grande | Puerto Rico | 72121 | 29 | |
196041 | 196041 | 2020-05-31 | Salinas | Puerto Rico | 72123 | 69 | |
196042 | 196042 | 2020-05-31 | San German | Puerto Rico | 72125 | 36 | |
196043 | 196043 | 2020-05-31 | San Juan | Puerto Rico | 72127 | 532 | |
196044 | 196044 | 2020-05-31 | San Lorenzo | Puerto Rico | 72129 | 41 | |
196045 | 196045 | 2020-05-31 | San Sebastian | Puerto Rico | 72131 | 47 | |
196046 | 196046 | 2020-05-31 | Santa Isabel | Puerto Rico | 72133 | 17 | |
196047 | 196047 | 2020-05-31 | Toa Alta | Puerto Rico | 72135 | 92 | |
196048 | 196048 | 2020-05-31 | Toa Baja | Puerto Rico | 72137 | 100 | |
196049 | 196049 | 2020-05-31 | Trujillo Alto | Puerto Rico | 72139 | 64 | |
196050 | 196050 | 2020-05-31 | Unknown | Puerto Rico | 122 | 136 | |
196051 | 196051 | 2020-05-31 | Utuado | Puerto Rico | 72141 | 3 | |
196052 | 196052 | 2020-05-31 | Vega Alta | Puerto Rico | 72143 | 39 | |
196053 | 196053 | 2020-05-31 | Vega Baja | Puerto Rico | 72145 | 42 | |
196054 | 196054 | 2020-05-31 | Vieques | Puerto Rico | 72147 | 20 | |
196055 | 196055 | 2020-05-31 | Villalba | Puerto Rico | 72149 | 25 | |
196056 | 196056 | 2020-05-31 | Yabucoa | Puerto Rico | 72151 | 12 | |
196057 | 196057 | 2020-05-31 | 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);