ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
754008 | 754008 | 2020-11-21 | Adjuntas | Puerto Rico | 72001 | 226 | |
754009 | 754009 | 2020-11-21 | Aguada | Puerto Rico | 72003 | 590 | |
754010 | 754010 | 2020-11-21 | Aguadilla | Puerto Rico | 72005 | 794 | |
754011 | 754011 | 2020-11-21 | Aguas Buenas | Puerto Rico | 72007 | 482 | |
754012 | 754012 | 2020-11-21 | Aibonito | Puerto Rico | 72009 | 276 | |
754013 | 754013 | 2020-11-21 | Anasco | Puerto Rico | 72011 | 448 | |
754014 | 754014 | 2020-11-21 | Arecibo | Puerto Rico | 72013 | 1422 | |
754015 | 754015 | 2020-11-21 | Arroyo | Puerto Rico | 72015 | 232 | |
754016 | 754016 | 2020-11-21 | Barceloneta | Puerto Rico | 72017 | 415 | |
754017 | 754017 | 2020-11-21 | Barranquitas | Puerto Rico | 72019 | 775 | |
754018 | 754018 | 2020-11-21 | Bayamon | Puerto Rico | 72021 | 6040 | |
754019 | 754019 | 2020-11-21 | Cabo Rojo | Puerto Rico | 72023 | 605 | |
754020 | 754020 | 2020-11-21 | Caguas | Puerto Rico | 72025 | 2940 | |
754021 | 754021 | 2020-11-21 | Camuy | Puerto Rico | 72027 | 564 | |
754022 | 754022 | 2020-11-21 | Canovanas | Puerto Rico | 72029 | 1096 | |
754023 | 754023 | 2020-11-21 | Carolina | Puerto Rico | 72031 | 4896 | |
754024 | 754024 | 2020-11-21 | Catano | Puerto Rico | 72033 | 744 | |
754025 | 754025 | 2020-11-21 | Cayey | Puerto Rico | 72035 | 655 | |
754026 | 754026 | 2020-11-21 | Ceiba | Puerto Rico | 72037 | 231 | |
754027 | 754027 | 2020-11-21 | Ciales | Puerto Rico | 72039 | 456 | |
754028 | 754028 | 2020-11-21 | Cidra | Puerto Rico | 72041 | 569 | |
754029 | 754029 | 2020-11-21 | Coamo | Puerto Rico | 72043 | 521 | |
754030 | 754030 | 2020-11-21 | Comerio | Puerto Rico | 72045 | 369 | |
754031 | 754031 | 2020-11-21 | Corozal | Puerto Rico | 72047 | 1082 | |
754032 | 754032 | 2020-11-21 | Culebra | Puerto Rico | 72049 | 25 | |
754033 | 754033 | 2020-11-21 | Dorado | Puerto Rico | 72051 | 1364 | |
754034 | 754034 | 2020-11-21 | Fajardo | Puerto Rico | 72053 | 835 | |
754035 | 754035 | 2020-11-21 | Florida | Puerto Rico | 72054 | 480 | |
754036 | 754036 | 2020-11-21 | Guanica | Puerto Rico | 72055 | 193 | |
754037 | 754037 | 2020-11-21 | Guayama | Puerto Rico | 72057 | 483 | |
754038 | 754038 | 2020-11-21 | Guayanilla | Puerto Rico | 72059 | 294 | |
754039 | 754039 | 2020-11-21 | Guaynabo | Puerto Rico | 72061 | 2786 | |
754040 | 754040 | 2020-11-21 | Gurabo | Puerto Rico | 72063 | 985 | |
754041 | 754041 | 2020-11-21 | Hatillo | Puerto Rico | 72065 | 547 | |
754042 | 754042 | 2020-11-21 | Hormigueros | Puerto Rico | 72067 | 261 | |
754043 | 754043 | 2020-11-21 | Humacao | Puerto Rico | 72069 | 952 | |
754044 | 754044 | 2020-11-21 | Isabela | Puerto Rico | 72071 | 552 | |
754045 | 754045 | 2020-11-21 | Jayuya | Puerto Rico | 72073 | 343 | |
754046 | 754046 | 2020-11-21 | Juana Diaz | Puerto Rico | 72075 | 601 | |
754047 | 754047 | 2020-11-21 | Juncos | Puerto Rico | 72077 | 772 | |
754048 | 754048 | 2020-11-21 | Lajas | Puerto Rico | 72079 | 249 | |
754049 | 754049 | 2020-11-21 | Lares | Puerto Rico | 72081 | 582 | |
754050 | 754050 | 2020-11-21 | Las Marias | Puerto Rico | 72083 | 149 | |
754051 | 754051 | 2020-11-21 | Las Piedras | Puerto Rico | 72085 | 821 | |
754052 | 754052 | 2020-11-21 | Loiza | Puerto Rico | 72087 | 497 | |
754053 | 754053 | 2020-11-21 | Luquillo | Puerto Rico | 72089 | 377 | |
754054 | 754054 | 2020-11-21 | Manati | Puerto Rico | 72091 | 931 | |
754055 | 754055 | 2020-11-21 | Maricao | Puerto Rico | 72093 | 97 | |
754056 | 754056 | 2020-11-21 | Maunabo | Puerto Rico | 72095 | 195 | |
754057 | 754057 | 2020-11-21 | Mayaguez | Puerto Rico | 72097 | 1223 | |
754058 | 754058 | 2020-11-21 | Moca | Puerto Rico | 72099 | 690 | |
754059 | 754059 | 2020-11-21 | Morovis | Puerto Rico | 72101 | 750 | |
754060 | 754060 | 2020-11-21 | Naguabo | Puerto Rico | 72103 | 453 | |
754061 | 754061 | 2020-11-21 | Naranjito | Puerto Rico | 72105 | 969 | |
754062 | 754062 | 2020-11-21 | Orocovis | Puerto Rico | 72107 | 509 | |
754063 | 754063 | 2020-11-21 | Patillas | Puerto Rico | 72109 | 238 | |
754064 | 754064 | 2020-11-21 | Penuelas | Puerto Rico | 72111 | 230 | |
754065 | 754065 | 2020-11-21 | Ponce | Puerto Rico | 72113 | 1561 | |
754066 | 754066 | 2020-11-21 | Quebradillas | Puerto Rico | 72115 | 369 | |
754067 | 754067 | 2020-11-21 | Rincon | Puerto Rico | 72117 | 266 | |
754068 | 754068 | 2020-11-21 | Rio Grande | Puerto Rico | 72119 | 1019 | |
754069 | 754069 | 2020-11-21 | Sabana Grande | Puerto Rico | 72121 | 262 | |
754070 | 754070 | 2020-11-21 | Salinas | Puerto Rico | 72123 | 681 | |
754071 | 754071 | 2020-11-21 | San German | Puerto Rico | 72125 | 387 | |
754072 | 754072 | 2020-11-21 | San Juan | Puerto Rico | 72127 | 12253 | |
754073 | 754073 | 2020-11-21 | San Lorenzo | Puerto Rico | 72129 | 881 | |
754074 | 754074 | 2020-11-21 | San Sebastian | Puerto Rico | 72131 | 1075 | |
754075 | 754075 | 2020-11-21 | Santa Isabel | Puerto Rico | 72133 | 339 | |
754076 | 754076 | 2020-11-21 | Toa Alta | Puerto Rico | 72135 | 2216 | |
754077 | 754077 | 2020-11-21 | Toa Baja | Puerto Rico | 72137 | 2435 | |
754078 | 754078 | 2020-11-21 | Trujillo Alto | Puerto Rico | 72139 | 1937 | |
754079 | 754079 | 2020-11-21 | Unknown | Puerto Rico | 2597 | 1012 | |
754080 | 754080 | 2020-11-21 | Utuado | Puerto Rico | 72141 | 392 | |
754081 | 754081 | 2020-11-21 | Vega Alta | Puerto Rico | 72143 | 1171 | |
754082 | 754082 | 2020-11-21 | Vega Baja | Puerto Rico | 72145 | 1529 | |
754083 | 754083 | 2020-11-21 | Vieques | Puerto Rico | 72147 | 108 | |
754084 | 754084 | 2020-11-21 | Villalba | Puerto Rico | 72149 | 444 | |
754085 | 754085 | 2020-11-21 | Yabucoa | Puerto Rico | 72151 | 557 | |
754086 | 754086 | 2020-11-21 | Yauco | Puerto Rico | 72153 | 709 |
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);