ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 80 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
- Las Marias 13
- Mayaguez 4
- Cabo Rojo 3
- Ceiba 3
- Cidra 3
- Cayey 2
- Fajardo 2
- Isabela 2
- Juana Diaz 2
- Utuado 2
- Aguas Buenas 1
- Arecibo 1
- Catano 1
- Guayama 1
- Gurabo 1
- Hatillo 1
- Hormigueros 1
- Humacao 1
- Lares 1
- Maricao 1
- Morovis 1
- Naranjito 1
- Orocovis 1
- Penuelas 1
- Ponce 1
- Quebradillas 1
- Rincon 1
- Rio Grande 1
- San Lorenzo 1
- Toa Alta 1
- …
state 1
- Puerto Rico · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
565931 | 565931 | 2020-09-24 | Maricao | Puerto Rico | 72093 | 80 | |
497969 | 497969 | 2020-09-03 | Las Marias | Puerto Rico | 72083 | 80 | |
494736 | 494736 | 2020-09-02 | Las Marias | Puerto Rico | 72083 | 80 | |
491502 | 491502 | 2020-09-01 | Las Marias | Puerto Rico | 72083 | 80 | |
488269 | 488269 | 2020-08-31 | Las Marias | Puerto Rico | 72083 | 80 | |
475334 | 475334 | 2020-08-27 | Las Marias | Puerto Rico | 72083 | 80 | |
472100 | 472100 | 2020-08-26 | Las Marias | Puerto Rico | 72083 | 80 | |
468868 | 468868 | 2020-08-25 | Las Marias | Puerto Rico | 72083 | 80 | |
465640 | 465640 | 2020-08-24 | Las Marias | Puerto Rico | 72083 | 80 | |
462387 | 462387 | 2020-08-23 | Ceiba | Puerto Rico | 72037 | 80 | |
462411 | 462411 | 2020-08-23 | Las Marias | Puerto Rico | 72083 | 80 | |
459159 | 459159 | 2020-08-22 | Ceiba | Puerto Rico | 72037 | 80 | |
459183 | 459183 | 2020-08-22 | Las Marias | Puerto Rico | 72083 | 80 | |
459216 | 459216 | 2020-08-22 | Vieques | Puerto Rico | 72147 | 80 | |
455931 | 455931 | 2020-08-21 | Ceiba | Puerto Rico | 72037 | 80 | |
455955 | 455955 | 2020-08-21 | Las Marias | Puerto Rico | 72083 | 80 | |
446271 | 446271 | 2020-08-18 | Las Marias | Puerto Rico | 72083 | 80 | |
443045 | 443045 | 2020-08-17 | Las Marias | Puerto Rico | 72083 | 80 | |
436623 | 436623 | 2020-08-15 | Utuado | Puerto Rico | 72141 | 80 | |
433380 | 433380 | 2020-08-14 | Penuelas | Puerto Rico | 72111 | 80 | |
433396 | 433396 | 2020-08-14 | Utuado | Puerto Rico | 72141 | 80 | |
430156 | 430156 | 2020-08-13 | Quebradillas | Puerto Rico | 72115 | 80 | |
417283 | 417283 | 2020-08-09 | Villalba | Puerto Rico | 72149 | 80 | |
391495 | 391495 | 2020-08-01 | Hormigueros | Puerto Rico | 72067 | 80 | |
388277 | 388277 | 2020-07-31 | Hatillo | Puerto Rico | 72065 | 80 | |
385086 | 385086 | 2020-07-30 | Rincon | Puerto Rico | 72117 | 80 | |
352959 | 352959 | 2020-07-20 | Isabela | Puerto Rico | 72071 | 80 | |
349723 | 349723 | 2020-07-19 | Aguas Buenas | Puerto Rico | 72007 | 80 | |
349756 | 349756 | 2020-07-19 | Isabela | Puerto Rico | 72071 | 80 | |
343336 | 343336 | 2020-07-17 | Catano | Puerto Rico | 72033 | 80 | |
343385 | 343385 | 2020-07-17 | San Lorenzo | Puerto Rico | 72129 | 80 | |
321017 | 321017 | 2020-07-10 | Guayama | Puerto Rico | 72057 | 80 | |
321039 | 321039 | 2020-07-10 | Morovis | Puerto Rico | 72101 | 80 | |
317830 | 317830 | 2020-07-09 | Cidra | Puerto Rico | 72041 | 80 | |
317864 | 317864 | 2020-07-09 | Orocovis | Puerto Rico | 72107 | 80 | |
314657 | 314657 | 2020-07-08 | Cidra | Puerto Rico | 72041 | 80 | |
311485 | 311485 | 2020-07-07 | Cidra | Puerto Rico | 72041 | 80 | |
311518 | 311518 | 2020-07-07 | Naranjito | Puerto Rico | 72105 | 80 | |
298813 | 298813 | 2020-07-03 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
295654 | 295654 | 2020-07-02 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
295669 | 295669 | 2020-07-02 | Fajardo | Puerto Rico | 72053 | 80 | |
292498 | 292498 | 2020-07-01 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
292513 | 292513 | 2020-07-01 | Fajardo | Puerto Rico | 72053 | 80 | |
292528 | 292528 | 2020-07-01 | Lares | Puerto Rico | 72081 | 80 | |
286222 | 286222 | 2020-06-29 | Juana Diaz | Puerto Rico | 72075 | 80 | |
283077 | 283077 | 2020-06-28 | Juana Diaz | Puerto Rico | 72075 | 80 | |
270494 | 270494 | 2020-06-24 | Humacao | Puerto Rico | 72069 | 80 | |
264275 | 264275 | 2020-06-22 | Yauco | Puerto Rico | 72153 | 80 | |
236176 | 236176 | 2020-06-13 | Gurabo | Puerto Rico | 72063 | 80 | |
217603 | 217603 | 2020-06-07 | Rio Grande | Puerto Rico | 72119 | 80 | |
214459 | 214459 | 2020-06-06 | Arecibo | Puerto Rico | 72013 | 80 | |
211384 | 211384 | 2020-06-05 | Cayey | Puerto Rico | 72035 | 80 | |
208302 | 208302 | 2020-06-04 | Cayey | Puerto Rico | 72035 | 80 | |
183775 | 183775 | 2020-05-27 | Mayaguez | Puerto Rico | 72097 | 80 | |
180725 | 180725 | 2020-05-26 | Mayaguez | Puerto Rico | 72097 | 80 | |
177682 | 177682 | 2020-05-25 | Mayaguez | Puerto Rico | 72097 | 80 | |
174638 | 174638 | 2020-05-24 | Mayaguez | Puerto Rico | 72097 | 80 | |
174657 | 174657 | 2020-05-24 | Toa Alta | Puerto Rico | 72135 | 80 | |
165529 | 165529 | 2020-05-21 | Ponce | Puerto Rico | 72113 | 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);