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)
fips >30
county >30
- Unknown 120
- Adjuntas 67
- Aguada 67
- Aguadilla 67
- Aguas Buenas 67
- Aibonito 67
- Anasco 67
- Arecibo 67
- Arroyo 67
- Barceloneta 67
- Barranquitas 67
- Bayamon 67
- Cabo Rojo 67
- Caguas 67
- Camuy 67
- Canovanas 67
- Carolina 67
- Catano 67
- Cayey 67
- Ceiba 67
- Ciales 67
- Cidra 67
- Coamo 67
- Comerio 67
- Corozal 67
- Dorado 67
- Fajardo 67
- Florida 67
- Guanica 67
- Guayama 67
- …
state 1
- Puerto Rico · 5,309 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320988 | 320988 | 2020-07-10 | Adjuntas | Puerto Rico | 72001 | 61 | |
320989 | 320989 | 2020-07-10 | Aguada | Puerto Rico | 72003 | 50 | |
320990 | 320990 | 2020-07-10 | Aguadilla | Puerto Rico | 72005 | 78 | |
320991 | 320991 | 2020-07-10 | Aguas Buenas | Puerto Rico | 72007 | 64 | |
320992 | 320992 | 2020-07-10 | Aibonito | Puerto Rico | 72009 | 50 | |
320993 | 320993 | 2020-07-10 | Anasco | Puerto Rico | 72011 | 66 | |
320994 | 320994 | 2020-07-10 | Arecibo | Puerto Rico | 72013 | 147 | |
320995 | 320995 | 2020-07-10 | Arroyo | Puerto Rico | 72015 | 49 | |
320996 | 320996 | 2020-07-10 | Barceloneta | Puerto Rico | 72017 | 30 | |
320997 | 320997 | 2020-07-10 | Barranquitas | Puerto Rico | 72019 | 101 | |
320998 | 320998 | 2020-07-10 | Bayamon | Puerto Rico | 72021 | 540 | |
320999 | 320999 | 2020-07-10 | Cabo Rojo | Puerto Rico | 72023 | 95 | |
321000 | 321000 | 2020-07-10 | Caguas | Puerto Rico | 72025 | 301 | |
321001 | 321001 | 2020-07-10 | Camuy | Puerto Rico | 72027 | 51 | |
321002 | 321002 | 2020-07-10 | Canovanas | Puerto Rico | 72029 | 169 | |
321003 | 321003 | 2020-07-10 | Carolina | Puerto Rico | 72031 | 425 | |
321004 | 321004 | 2020-07-10 | Catano | Puerto Rico | 72033 | 69 | |
321005 | 321005 | 2020-07-10 | Cayey | Puerto Rico | 72035 | 115 | |
321006 | 321006 | 2020-07-10 | Ceiba | Puerto Rico | 72037 | 34 | |
321007 | 321007 | 2020-07-10 | Ciales | Puerto Rico | 72039 | 65 | |
321008 | 321008 | 2020-07-10 | Cidra | Puerto Rico | 72041 | 83 | |
321009 | 321009 | 2020-07-10 | Coamo | Puerto Rico | 72043 | 48 | |
321010 | 321010 | 2020-07-10 | Comerio | Puerto Rico | 72045 | 55 | |
321011 | 321011 | 2020-07-10 | Corozal | Puerto Rico | 72047 | 59 | |
321012 | 321012 | 2020-07-10 | Culebra | Puerto Rico | 72049 | 4 | |
321013 | 321013 | 2020-07-10 | Dorado | Puerto Rico | 72051 | 120 | |
321014 | 321014 | 2020-07-10 | Fajardo | Puerto Rico | 72053 | 101 | |
321015 | 321015 | 2020-07-10 | Florida | Puerto Rico | 72054 | 54 | |
321016 | 321016 | 2020-07-10 | Guanica | Puerto Rico | 72055 | 43 | |
321017 | 321017 | 2020-07-10 | Guayama | Puerto Rico | 72057 | 80 | |
321018 | 321018 | 2020-07-10 | Guayanilla | Puerto Rico | 72059 | 76 | |
321019 | 321019 | 2020-07-10 | Guaynabo | Puerto Rico | 72061 | 410 | |
321020 | 321020 | 2020-07-10 | Gurabo | Puerto Rico | 72063 | 122 | |
321021 | 321021 | 2020-07-10 | Hatillo | Puerto Rico | 72065 | 49 | |
321022 | 321022 | 2020-07-10 | Hormigueros | Puerto Rico | 72067 | 38 | |
321023 | 321023 | 2020-07-10 | Humacao | Puerto Rico | 72069 | 107 | |
321024 | 321024 | 2020-07-10 | Isabela | Puerto Rico | 72071 | 50 | |
321025 | 321025 | 2020-07-10 | Jayuya | Puerto Rico | 72073 | 154 | |
321026 | 321026 | 2020-07-10 | Juana Diaz | Puerto Rico | 72075 | 98 | |
321027 | 321027 | 2020-07-10 | Juncos | Puerto Rico | 72077 | 58 | |
321028 | 321028 | 2020-07-10 | Lajas | Puerto Rico | 72079 | 48 | |
321029 | 321029 | 2020-07-10 | Lares | Puerto Rico | 72081 | 94 | |
321030 | 321030 | 2020-07-10 | Las Marias | Puerto Rico | 72083 | 26 | |
321031 | 321031 | 2020-07-10 | Las Piedras | Puerto Rico | 72085 | 89 | |
321032 | 321032 | 2020-07-10 | Loiza | Puerto Rico | 72087 | 53 | |
321033 | 321033 | 2020-07-10 | Luquillo | Puerto Rico | 72089 | 55 | |
321034 | 321034 | 2020-07-10 | Manati | Puerto Rico | 72091 | 64 | |
321035 | 321035 | 2020-07-10 | Maricao | Puerto Rico | 72093 | 29 | |
321036 | 321036 | 2020-07-10 | Maunabo | Puerto Rico | 72095 | 28 | |
321037 | 321037 | 2020-07-10 | Mayaguez | Puerto Rico | 72097 | 219 | |
321038 | 321038 | 2020-07-10 | Moca | Puerto Rico | 72099 | 64 | |
321039 | 321039 | 2020-07-10 | Morovis | Puerto Rico | 72101 | 80 | |
321040 | 321040 | 2020-07-10 | Naguabo | Puerto Rico | 72103 | 51 | |
321041 | 321041 | 2020-07-10 | Naranjito | Puerto Rico | 72105 | 84 | |
321042 | 321042 | 2020-07-10 | Orocovis | Puerto Rico | 72107 | 82 | |
321043 | 321043 | 2020-07-10 | Patillas | Puerto Rico | 72109 | 66 | |
321044 | 321044 | 2020-07-10 | Penuelas | Puerto Rico | 72111 | 28 | |
321045 | 321045 | 2020-07-10 | Ponce | Puerto Rico | 72113 | 251 | |
321046 | 321046 | 2020-07-10 | Quebradillas | Puerto Rico | 72115 | 47 | |
321047 | 321047 | 2020-07-10 | Rincon | Puerto Rico | 72117 | 40 | |
321048 | 321048 | 2020-07-10 | Rio Grande | Puerto Rico | 72119 | 120 | |
321049 | 321049 | 2020-07-10 | Sabana Grande | Puerto Rico | 72121 | 69 | |
321050 | 321050 | 2020-07-10 | Salinas | Puerto Rico | 72123 | 117 | |
321051 | 321051 | 2020-07-10 | San German | Puerto Rico | 72125 | 82 | |
321052 | 321052 | 2020-07-10 | San Juan | Puerto Rico | 72127 | 1177 | |
321053 | 321053 | 2020-07-10 | San Lorenzo | Puerto Rico | 72129 | 76 | |
321054 | 321054 | 2020-07-10 | San Sebastian | Puerto Rico | 72131 | 105 | |
321055 | 321055 | 2020-07-10 | Santa Isabel | Puerto Rico | 72133 | 59 | |
321056 | 321056 | 2020-07-10 | Toa Alta | Puerto Rico | 72135 | 198 | |
321057 | 321057 | 2020-07-10 | Toa Baja | Puerto Rico | 72137 | 224 | |
321058 | 321058 | 2020-07-10 | Trujillo Alto | Puerto Rico | 72139 | 204 | |
321059 | 321059 | 2020-07-10 | Unknown | Puerto Rico | 383 | 159 | |
321060 | 321060 | 2020-07-10 | Utuado | Puerto Rico | 72141 | 23 | |
321061 | 321061 | 2020-07-10 | Vega Alta | Puerto Rico | 72143 | 89 | |
321062 | 321062 | 2020-07-10 | Vega Baja | Puerto Rico | 72145 | 114 | |
321063 | 321063 | 2020-07-10 | Vieques | Puerto Rico | 72147 | 24 | |
321064 | 321064 | 2020-07-10 | Villalba | Puerto Rico | 72149 | 53 | |
321065 | 321065 | 2020-07-10 | Yabucoa | Puerto Rico | 72151 | 43 | |
321066 | 321066 | 2020-07-10 | Yauco | Puerto Rico | 72153 | 110 | |
317810 | 317810 | 2020-07-09 | Adjuntas | Puerto Rico | 72001 | 60 | |
317811 | 317811 | 2020-07-09 | Aguada | Puerto Rico | 72003 | 50 | |
317812 | 317812 | 2020-07-09 | Aguadilla | Puerto Rico | 72005 | 72 | |
317813 | 317813 | 2020-07-09 | Aguas Buenas | Puerto Rico | 72007 | 63 | |
317814 | 317814 | 2020-07-09 | Aibonito | Puerto Rico | 72009 | 49 | |
317815 | 317815 | 2020-07-09 | Anasco | Puerto Rico | 72011 | 66 | |
317816 | 317816 | 2020-07-09 | Arecibo | Puerto Rico | 72013 | 143 | |
317817 | 317817 | 2020-07-09 | Arroyo | Puerto Rico | 72015 | 42 | |
317818 | 317818 | 2020-07-09 | Barceloneta | Puerto Rico | 72017 | 28 | |
317819 | 317819 | 2020-07-09 | Barranquitas | Puerto Rico | 72019 | 99 | |
317820 | 317820 | 2020-07-09 | Bayamon | Puerto Rico | 72021 | 523 | |
317821 | 317821 | 2020-07-09 | Cabo Rojo | Puerto Rico | 72023 | 88 | |
317822 | 317822 | 2020-07-09 | Caguas | Puerto Rico | 72025 | 292 | |
317823 | 317823 | 2020-07-09 | Camuy | Puerto Rico | 72027 | 45 | |
317824 | 317824 | 2020-07-09 | Canovanas | Puerto Rico | 72029 | 163 | |
317825 | 317825 | 2020-07-09 | Carolina | Puerto Rico | 72031 | 409 | |
317826 | 317826 | 2020-07-09 | Catano | Puerto Rico | 72033 | 68 | |
317827 | 317827 | 2020-07-09 | Cayey | Puerto Rico | 72035 | 114 | |
317828 | 317828 | 2020-07-09 | Ceiba | Puerto Rico | 72037 | 29 | |
317829 | 317829 | 2020-07-09 | Ciales | Puerto Rico | 72039 | 64 | |
317830 | 317830 | 2020-07-09 | Cidra | Puerto Rico | 72041 | 80 |
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);