ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 27 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Quebradillas 13
- Isabela 8
- Humacao 7
- Barceloneta 6
- Hormigueros 6
- Rio Grande 6
- San German 6
- Aguada 4
- Vieques 4
- Culebra 3
- Patillas 3
- Ciales 2
- Hatillo 2
- Lares 2
- Vega Alta 2
- Yabucoa 2
- Adjuntas 1
- Aguadilla 1
- Aguas Buenas 1
- Arroyo 1
- Barranquitas 1
- Cabo Rojo 1
- Coamo 1
- Comerio 1
- Corozal 1
- Florida 1
- Gurabo 1
- Lajas 1
- Las Marias 1
- Moca 1
- …
state 1
- Puerto Rico · 99 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
857885 | 857885 | 2020-12-23 | Culebra | Puerto Rico | 72049 | 27 | |
854640 | 854640 | 2020-12-22 | Culebra | Puerto Rico | 72049 | 27 | |
851395 | 851395 | 2020-12-21 | Culebra | Puerto Rico | 72049 | 27 | |
349795 | 349795 | 2020-07-19 | Vieques | Puerto Rico | 72147 | 27 | |
346595 | 346595 | 2020-07-18 | Vieques | Puerto Rico | 72147 | 27 | |
340197 | 340197 | 2020-07-16 | Vieques | Puerto Rico | 72147 | 27 | |
337000 | 337000 | 2020-07-15 | Vieques | Puerto Rico | 72147 | 27 | |
324210 | 324210 | 2020-07-11 | Las Marias | Puerto Rico | 72083 | 27 | |
317866 | 317866 | 2020-07-09 | Penuelas | Puerto Rico | 72111 | 27 | |
305137 | 305137 | 2020-07-05 | Barceloneta | Puerto Rico | 72017 | 27 | |
301974 | 301974 | 2020-07-04 | Barceloneta | Puerto Rico | 72017 | 27 | |
298810 | 298810 | 2020-07-03 | Barceloneta | Puerto Rico | 72017 | 27 | |
295651 | 295651 | 2020-07-02 | Barceloneta | Puerto Rico | 72017 | 27 | |
292495 | 292495 | 2020-07-01 | Barceloneta | Puerto Rico | 72017 | 27 | |
289343 | 289343 | 2020-06-30 | Barceloneta | Puerto Rico | 72017 | 27 | |
267332 | 267332 | 2020-06-23 | Arroyo | Puerto Rico | 72015 | 27 | |
254850 | 254850 | 2020-06-19 | Hormigueros | Puerto Rico | 72067 | 27 | |
251728 | 251728 | 2020-06-18 | Florida | Puerto Rico | 72054 | 27 | |
251735 | 251735 | 2020-06-18 | Hormigueros | Puerto Rico | 72067 | 27 | |
248620 | 248620 | 2020-06-17 | Hormigueros | Puerto Rico | 72067 | 27 | |
245507 | 245507 | 2020-06-16 | Hormigueros | Puerto Rico | 72067 | 27 | |
242395 | 242395 | 2020-06-15 | Hormigueros | Puerto Rico | 72067 | 27 | |
239285 | 239285 | 2020-06-14 | Hatillo | Puerto Rico | 72065 | 27 | |
239286 | 239286 | 2020-06-14 | Hormigueros | Puerto Rico | 72067 | 27 | |
236177 | 236177 | 2020-06-13 | Hatillo | Puerto Rico | 72065 | 27 | |
236180 | 236180 | 2020-06-13 | Isabela | Puerto Rico | 72071 | 27 | |
233040 | 233040 | 2020-06-12 | Aguada | Puerto Rico | 72003 | 27 | |
233075 | 233075 | 2020-06-12 | Isabela | Puerto Rico | 72071 | 27 | |
233106 | 233106 | 2020-06-12 | Santa Isabel | Puerto Rico | 72133 | 27 | |
229935 | 229935 | 2020-06-11 | Aguada | Puerto Rico | 72003 | 27 | |
229970 | 229970 | 2020-06-11 | Isabela | Puerto Rico | 72071 | 27 | |
230011 | 230011 | 2020-06-11 | Yabucoa | Puerto Rico | 72151 | 27 | |
226831 | 226831 | 2020-06-10 | Aguada | Puerto Rico | 72003 | 27 | |
226866 | 226866 | 2020-06-10 | Isabela | Puerto Rico | 72071 | 27 | |
226907 | 226907 | 2020-06-10 | Yabucoa | Puerto Rico | 72151 | 27 | |
223731 | 223731 | 2020-06-09 | Aguada | Puerto Rico | 72003 | 27 | |
223766 | 223766 | 2020-06-09 | Isabela | Puerto Rico | 72071 | 27 | |
220671 | 220671 | 2020-06-08 | Isabela | Puerto Rico | 72071 | 27 | |
220675 | 220675 | 2020-06-08 | Lajas | Puerto Rico | 72079 | 27 | |
217579 | 217579 | 2020-06-07 | Isabela | Puerto Rico | 72071 | 27 | |
214455 | 214455 | 2020-06-06 | Aguadilla | Puerto Rico | 72005 | 27 | |
214474 | 214474 | 2020-06-06 | Coamo | Puerto Rico | 72043 | 27 | |
214489 | 214489 | 2020-06-06 | Isabela | Puerto Rico | 72071 | 27 | |
211386 | 211386 | 2020-06-05 | Ciales | Puerto Rico | 72039 | 27 | |
208304 | 208304 | 2020-06-04 | Ciales | Puerto Rico | 72039 | 27 | |
208307 | 208307 | 2020-06-04 | Comerio | Puerto Rico | 72045 | 27 | |
205204 | 205204 | 2020-06-03 | Adjuntas | Puerto Rico | 72001 | 27 | |
205254 | 205254 | 2020-06-03 | Moca | Puerto Rico | 72099 | 27 | |
186807 | 186807 | 2020-05-28 | Corozal | Puerto Rico | 72047 | 27 | |
186841 | 186841 | 2020-05-28 | Quebradillas | Puerto Rico | 72115 | 27 | |
183787 | 183787 | 2020-05-27 | Sabana Grande | Puerto Rico | 72121 | 27 | |
180734 | 180734 | 2020-05-26 | Quebradillas | Puerto Rico | 72115 | 27 | |
177674 | 177674 | 2020-05-25 | Lares | Puerto Rico | 72081 | 27 | |
177691 | 177691 | 2020-05-25 | Quebradillas | Puerto Rico | 72115 | 27 | |
174630 | 174630 | 2020-05-24 | Lares | Puerto Rico | 72081 | 27 | |
174640 | 174640 | 2020-05-24 | Morovis | Puerto Rico | 72101 | 27 | |
174647 | 174647 | 2020-05-24 | Quebradillas | Puerto Rico | 72115 | 27 | |
171559 | 171559 | 2020-05-23 | Cabo Rojo | Puerto Rico | 72023 | 27 | |
171605 | 171605 | 2020-05-23 | Quebradillas | Puerto Rico | 72115 | 27 | |
168563 | 168563 | 2020-05-22 | Patillas | Puerto Rico | 72109 | 27 | |
168566 | 168566 | 2020-05-22 | Quebradillas | Puerto Rico | 72115 | 27 | |
165527 | 165527 | 2020-05-21 | Patillas | Puerto Rico | 72109 | 27 | |
165530 | 165530 | 2020-05-21 | Quebradillas | Puerto Rico | 72115 | 27 | |
162498 | 162498 | 2020-05-20 | Patillas | Puerto Rico | 72109 | 27 | |
162501 | 162501 | 2020-05-20 | Quebradillas | Puerto Rico | 72115 | 27 | |
159474 | 159474 | 2020-05-19 | Quebradillas | Puerto Rico | 72115 | 27 | |
159481 | 159481 | 2020-05-19 | San Lorenzo | Puerto Rico | 72129 | 27 | |
156453 | 156453 | 2020-05-18 | Quebradillas | Puerto Rico | 72115 | 27 | |
156455 | 156455 | 2020-05-18 | Rio Grande | Puerto Rico | 72119 | 27 | |
153436 | 153436 | 2020-05-17 | Quebradillas | Puerto Rico | 72115 | 27 | |
153438 | 153438 | 2020-05-17 | Rio Grande | Puerto Rico | 72119 | 27 | |
150425 | 150425 | 2020-05-16 | Quebradillas | Puerto Rico | 72115 | 27 | |
150427 | 150427 | 2020-05-16 | Rio Grande | Puerto Rico | 72119 | 27 | |
147370 | 147370 | 2020-05-15 | Barranquitas | Puerto Rico | 72019 | 27 | |
147417 | 147417 | 2020-05-15 | Quebradillas | Puerto Rico | 72115 | 27 | |
147419 | 147419 | 2020-05-15 | Rio Grande | Puerto Rico | 72119 | 27 | |
144394 | 144394 | 2020-05-14 | Humacao | Puerto Rico | 72069 | 27 | |
144418 | 144418 | 2020-05-14 | Rio Grande | Puerto Rico | 72119 | 27 | |
144421 | 144421 | 2020-05-14 | San German | Puerto Rico | 72125 | 27 | |
144436 | 144436 | 2020-05-14 | Yauco | Puerto Rico | 72153 | 27 | |
141398 | 141398 | 2020-05-13 | Humacao | Puerto Rico | 72069 | 27 | |
141425 | 141425 | 2020-05-13 | San German | Puerto Rico | 72125 | 27 | |
138402 | 138402 | 2020-05-12 | Humacao | Puerto Rico | 72069 | 27 | |
138429 | 138429 | 2020-05-12 | San German | Puerto Rico | 72125 | 27 | |
135381 | 135381 | 2020-05-11 | Aguas Buenas | Puerto Rico | 72007 | 27 | |
135412 | 135412 | 2020-05-11 | Humacao | Puerto Rico | 72069 | 27 | |
135430 | 135430 | 2020-05-11 | Orocovis | Puerto Rico | 72107 | 27 | |
135439 | 135439 | 2020-05-11 | San German | Puerto Rico | 72125 | 27 | |
132421 | 132421 | 2020-05-10 | Humacao | Puerto Rico | 72069 | 27 | |
132448 | 132448 | 2020-05-10 | San German | Puerto Rico | 72125 | 27 | |
129432 | 129432 | 2020-05-09 | Humacao | Puerto Rico | 72069 | 27 | |
129458 | 129458 | 2020-05-09 | Salinas | Puerto Rico | 72123 | 27 | |
129459 | 129459 | 2020-05-09 | San German | Puerto Rico | 72125 | 27 | |
126443 | 126443 | 2020-05-08 | Humacao | Puerto Rico | 72069 | 27 | |
126467 | 126467 | 2020-05-08 | Rio Grande | Puerto Rico | 72119 | 27 | |
123498 | 123498 | 2020-05-07 | Vega Baja | Puerto Rico | 72145 | 27 | |
120520 | 120520 | 2020-05-06 | Vega Alta | Puerto Rico | 72143 | 27 | |
117518 | 117518 | 2020-05-05 | Gurabo | Puerto Rico | 72063 | 27 | |
117558 | 117558 | 2020-05-05 | Vega Alta | Puerto Rico | 72143 | 27 |
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);