ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 24 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Culebra 8
- Comerio 7
- Villalba 7
- Hormigueros 6
- Barceloneta 5
- Sabana Grande 5
- Vieques 5
- Naguabo 4
- Ceiba 3
- Isabela 3
- Las Piedras 3
- Santa Isabel 3
- Aguadilla 2
- Aibonito 2
- Anasco 2
- Barranquitas 2
- Camuy 2
- Guayama 2
- Quebradillas 2
- Utuado 2
- Cabo Rojo 1
- Coamo 1
- Corozal 1
- Hatillo 1
- Manati 1
- Maricao 1
- Maunabo 1
- Morovis 1
- Orocovis 1
- Patillas 1
- …
state 1
- Puerto Rico · 87 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
744294 | 744294 | 2020-11-18 | Culebra | Puerto Rico | 72049 | 24 | |
741047 | 741047 | 2020-11-17 | Culebra | Puerto Rico | 72049 | 24 | |
737801 | 737801 | 2020-11-16 | Culebra | Puerto Rico | 72049 | 24 | |
734557 | 734557 | 2020-11-15 | Culebra | Puerto Rico | 72049 | 24 | |
731311 | 731311 | 2020-11-14 | Culebra | Puerto Rico | 72049 | 24 | |
728067 | 728067 | 2020-11-13 | Culebra | Puerto Rico | 72049 | 24 | |
724823 | 724823 | 2020-11-12 | Culebra | Puerto Rico | 72049 | 24 | |
721580 | 721580 | 2020-11-11 | Culebra | Puerto Rico | 72049 | 24 | |
327425 | 327425 | 2020-07-12 | Utuado | Puerto Rico | 72141 | 24 | |
324240 | 324240 | 2020-07-11 | Utuado | Puerto Rico | 72141 | 24 | |
321063 | 321063 | 2020-07-10 | Vieques | Puerto Rico | 72147 | 24 | |
317885 | 317885 | 2020-07-09 | Vieques | Puerto Rico | 72147 | 24 | |
314712 | 314712 | 2020-07-08 | Vieques | Puerto Rico | 72147 | 24 | |
311512 | 311512 | 2020-07-07 | Maricao | Puerto Rico | 72093 | 24 | |
311540 | 311540 | 2020-07-07 | Vieques | Puerto Rico | 72147 | 24 | |
308371 | 308371 | 2020-07-06 | Vieques | Puerto Rico | 72147 | 24 | |
286232 | 286232 | 2020-06-29 | Maunabo | Puerto Rico | 72095 | 24 | |
279949 | 279949 | 2020-06-27 | Penuelas | Puerto Rico | 72111 | 24 | |
267333 | 267333 | 2020-06-23 | Barceloneta | Puerto Rico | 72017 | 24 | |
264205 | 264205 | 2020-06-22 | Barceloneta | Puerto Rico | 72017 | 24 | |
261077 | 261077 | 2020-06-21 | Barceloneta | Puerto Rico | 72017 | 24 | |
257950 | 257950 | 2020-06-20 | Barceloneta | Puerto Rico | 72017 | 24 | |
254824 | 254824 | 2020-06-19 | Barceloneta | Puerto Rico | 72017 | 24 | |
233052 | 233052 | 2020-06-12 | Camuy | Puerto Rico | 72027 | 24 | |
233073 | 233073 | 2020-06-12 | Hormigueros | Puerto Rico | 72067 | 24 | |
229967 | 229967 | 2020-06-11 | Hatillo | Puerto Rico | 72065 | 24 | |
229968 | 229968 | 2020-06-11 | Hormigueros | Puerto Rico | 72067 | 24 | |
226843 | 226843 | 2020-06-10 | Camuy | Puerto Rico | 72027 | 24 | |
226864 | 226864 | 2020-06-10 | Hormigueros | Puerto Rico | 72067 | 24 | |
226889 | 226889 | 2020-06-10 | Rincon | Puerto Rico | 72117 | 24 | |
223764 | 223764 | 2020-06-09 | Hormigueros | Puerto Rico | 72067 | 24 | |
223797 | 223797 | 2020-06-09 | Santa Isabel | Puerto Rico | 72133 | 24 | |
220653 | 220653 | 2020-06-08 | Ceiba | Puerto Rico | 72037 | 24 | |
220669 | 220669 | 2020-06-08 | Hormigueros | Puerto Rico | 72067 | 24 | |
220702 | 220702 | 2020-06-08 | Santa Isabel | Puerto Rico | 72133 | 24 | |
217561 | 217561 | 2020-06-07 | Ceiba | Puerto Rico | 72037 | 24 | |
217577 | 217577 | 2020-06-07 | Hormigueros | Puerto Rico | 72067 | 24 | |
217610 | 217610 | 2020-06-07 | Santa Isabel | Puerto Rico | 72133 | 24 | |
214471 | 214471 | 2020-06-06 | Ceiba | Puerto Rico | 72037 | 24 | |
211369 | 211369 | 2020-06-05 | Aguadilla | Puerto Rico | 72005 | 24 | |
211388 | 211388 | 2020-06-05 | Coamo | Puerto Rico | 72043 | 24 | |
208287 | 208287 | 2020-06-04 | Aguadilla | Puerto Rico | 72005 | 24 | |
205209 | 205209 | 2020-06-03 | Anasco | Puerto Rico | 72011 | 24 | |
202132 | 202132 | 2020-06-02 | Anasco | Puerto Rico | 72011 | 24 | |
202149 | 202149 | 2020-06-02 | Comerio | Puerto Rico | 72045 | 24 | |
202163 | 202163 | 2020-06-02 | Isabela | Puerto Rico | 72071 | 24 | |
199056 | 199056 | 2020-06-01 | Aibonito | Puerto Rico | 72009 | 24 | |
199074 | 199074 | 2020-06-01 | Comerio | Puerto Rico | 72045 | 24 | |
199088 | 199088 | 2020-06-01 | Isabela | Puerto Rico | 72071 | 24 | |
199104 | 199104 | 2020-06-01 | Naguabo | Puerto Rico | 72103 | 24 | |
195983 | 195983 | 2020-05-31 | Aibonito | Puerto Rico | 72009 | 24 | |
196001 | 196001 | 2020-05-31 | Comerio | Puerto Rico | 72045 | 24 | |
196015 | 196015 | 2020-05-31 | Isabela | Puerto Rico | 72071 | 24 | |
196031 | 196031 | 2020-05-31 | Naguabo | Puerto Rico | 72103 | 24 | |
192932 | 192932 | 2020-05-30 | Comerio | Puerto Rico | 72045 | 24 | |
192962 | 192962 | 2020-05-30 | Naguabo | Puerto Rico | 72103 | 24 | |
192986 | 192986 | 2020-05-30 | Villalba | Puerto Rico | 72149 | 24 | |
189867 | 189867 | 2020-05-29 | Comerio | Puerto Rico | 72045 | 24 | |
189897 | 189897 | 2020-05-29 | Naguabo | Puerto Rico | 72103 | 24 | |
189921 | 189921 | 2020-05-29 | Villalba | Puerto Rico | 72149 | 24 | |
186806 | 186806 | 2020-05-28 | Comerio | Puerto Rico | 72045 | 24 | |
186859 | 186859 | 2020-05-28 | Villalba | Puerto Rico | 72149 | 24 | |
183749 | 183749 | 2020-05-27 | Comerio | Puerto Rico | 72045 | 24 | |
183802 | 183802 | 2020-05-27 | Villalba | Puerto Rico | 72149 | 24 | |
180752 | 180752 | 2020-05-26 | Villalba | Puerto Rico | 72149 | 24 | |
177709 | 177709 | 2020-05-25 | Villalba | Puerto Rico | 72149 | 24 | |
174632 | 174632 | 2020-05-24 | Las Piedras | Puerto Rico | 72085 | 24 | |
174635 | 174635 | 2020-05-24 | Manati | Puerto Rico | 72091 | 24 | |
174650 | 174650 | 2020-05-24 | Sabana Grande | Puerto Rico | 72121 | 24 | |
174665 | 174665 | 2020-05-24 | Villalba | Puerto Rico | 72149 | 24 | |
171590 | 171590 | 2020-05-23 | Las Piedras | Puerto Rico | 72085 | 24 | |
171608 | 171608 | 2020-05-23 | Sabana Grande | Puerto Rico | 72121 | 24 | |
168532 | 168532 | 2020-05-22 | Corozal | Puerto Rico | 72047 | 24 | |
168551 | 168551 | 2020-05-22 | Las Piedras | Puerto Rico | 72085 | 24 | |
168559 | 168559 | 2020-05-22 | Morovis | Puerto Rico | 72101 | 24 | |
168569 | 168569 | 2020-05-22 | Sabana Grande | Puerto Rico | 72121 | 24 | |
165533 | 165533 | 2020-05-21 | Sabana Grande | Puerto Rico | 72121 | 24 | |
162472 | 162472 | 2020-05-20 | Guayama | Puerto Rico | 72057 | 24 | |
162504 | 162504 | 2020-05-20 | Sabana Grande | Puerto Rico | 72121 | 24 | |
159445 | 159445 | 2020-05-19 | Guayama | Puerto Rico | 72057 | 24 | |
156407 | 156407 | 2020-05-18 | Cabo Rojo | Puerto Rico | 72023 | 24 | |
156450 | 156450 | 2020-05-18 | Patillas | Puerto Rico | 72109 | 24 | |
141373 | 141373 | 2020-05-13 | Barranquitas | Puerto Rico | 72019 | 24 | |
138377 | 138377 | 2020-05-12 | Barranquitas | Puerto Rico | 72019 | 24 | |
135434 | 135434 | 2020-05-11 | Quebradillas | Puerto Rico | 72115 | 24 | |
132443 | 132443 | 2020-05-10 | Quebradillas | Puerto Rico | 72115 | 24 | |
117539 | 117539 | 2020-05-05 | Orocovis | Puerto Rico | 72107 | 24 |
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);