ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 87 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 24
county 24
- Guanica 5
- Maricao 5
- Vieques 4
- Las Piedras 3
- Orocovis 3
- Cabo Rojo 2
- Ceiba 2
- San German 2
- Aguas Buenas 1
- Camuy 1
- Carolina 1
- Dorado 1
- Gurabo 1
- Humacao 1
- Maunabo 1
- Moca 1
- Morovis 1
- Naranjito 1
- Penuelas 1
- Rincon 1
- Sabana Grande 1
- Salinas 1
- San Lorenzo 1
- Santa Isabel 1
state 1
- Puerto Rico · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
608072 | 608072 | 2020-10-07 | Maricao | Puerto Rico | 72093 | 87 | |
604829 | 604829 | 2020-10-06 | Maricao | Puerto Rico | 72093 | 87 | |
601587 | 601587 | 2020-10-05 | Maricao | Puerto Rico | 72093 | 87 | |
598344 | 598344 | 2020-10-04 | Maricao | Puerto Rico | 72093 | 87 | |
595101 | 595101 | 2020-10-03 | Maricao | Puerto Rico | 72093 | 87 | |
540056 | 540056 | 2020-09-16 | Vieques | Puerto Rico | 72147 | 87 | |
536772 | 536772 | 2020-09-15 | Guanica | Puerto Rico | 72055 | 87 | |
536819 | 536819 | 2020-09-15 | Vieques | Puerto Rico | 72147 | 87 | |
533536 | 533536 | 2020-09-14 | Guanica | Puerto Rico | 72055 | 87 | |
530301 | 530301 | 2020-09-13 | Guanica | Puerto Rico | 72055 | 87 | |
527064 | 527064 | 2020-09-12 | Guanica | Puerto Rico | 72055 | 87 | |
523828 | 523828 | 2020-09-11 | Guanica | Puerto Rico | 72055 | 87 | |
498002 | 498002 | 2020-09-03 | Vieques | Puerto Rico | 72147 | 87 | |
494769 | 494769 | 2020-09-02 | Vieques | Puerto Rico | 72147 | 87 | |
485012 | 485012 | 2020-08-30 | Ceiba | Puerto Rico | 72037 | 87 | |
485042 | 485042 | 2020-08-30 | Maunabo | Puerto Rico | 72095 | 87 | |
481777 | 481777 | 2020-08-29 | Ceiba | Puerto Rico | 72037 | 87 | |
452741 | 452741 | 2020-08-20 | Penuelas | Puerto Rico | 72111 | 87 | |
397953 | 397953 | 2020-08-03 | Rincon | Puerto Rico | 72117 | 87 | |
391528 | 391528 | 2020-08-01 | Santa Isabel | Puerto Rico | 72133 | 87 | |
375389 | 375389 | 2020-07-27 | Camuy | Puerto Rico | 72027 | 87 | |
365745 | 365745 | 2020-07-24 | Aguas Buenas | Puerto Rico | 72007 | 87 | |
349785 | 349785 | 2020-07-19 | San Lorenzo | Puerto Rico | 72129 | 87 | |
346570 | 346570 | 2020-07-18 | Moca | Puerto Rico | 72099 | 87 | |
346581 | 346581 | 2020-07-18 | Sabana Grande | Puerto Rico | 72121 | 87 | |
340176 | 340176 | 2020-07-16 | Orocovis | Puerto Rico | 72107 | 87 | |
336979 | 336979 | 2020-07-15 | Orocovis | Puerto Rico | 72107 | 87 | |
336988 | 336988 | 2020-07-15 | San German | Puerto Rico | 72125 | 87 | |
333785 | 333785 | 2020-07-14 | Orocovis | Puerto Rico | 72107 | 87 | |
333794 | 333794 | 2020-07-14 | San German | Puerto Rico | 72125 | 87 | |
327404 | 327404 | 2020-07-12 | Morovis | Puerto Rico | 72101 | 87 | |
324221 | 324221 | 2020-07-11 | Naranjito | Puerto Rico | 72105 | 87 | |
317853 | 317853 | 2020-07-09 | Las Piedras | Puerto Rico | 72085 | 87 | |
314680 | 314680 | 2020-07-08 | Las Piedras | Puerto Rico | 72085 | 87 | |
311476 | 311476 | 2020-07-07 | Cabo Rojo | Puerto Rico | 72023 | 87 | |
311508 | 311508 | 2020-07-07 | Las Piedras | Puerto Rico | 72085 | 87 | |
308307 | 308307 | 2020-07-06 | Cabo Rojo | Puerto Rico | 72023 | 87 | |
289370 | 289370 | 2020-06-30 | Humacao | Puerto Rico | 72069 | 87 | |
254841 | 254841 | 2020-06-19 | Dorado | Puerto Rico | 72051 | 87 | |
251733 | 251733 | 2020-06-18 | Gurabo | Puerto Rico | 72063 | 87 | |
233101 | 233101 | 2020-06-12 | Salinas | Puerto Rico | 72123 | 87 | |
117502 | 117502 | 2020-05-05 | Carolina | Puerto Rico | 72031 | 87 |
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);