ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 574 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Guayanilla 12
- Aibonito 3
- Santa Isabel 3
- Maunabo 2
- Morovis 2
- Rincon 2
- Adjuntas 1
- Arecibo 1
- Ciales 1
- Coamo 1
- Hormigueros 1
- Isabela 1
- Juana Diaz 1
- Penuelas 1
- San German 1
state 1
- Puerto Rico · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1997736 | 1997736 | 2021-12-09 | Maunabo | Puerto Rico | 72095 | 574 | |
1994485 | 1994485 | 2021-12-08 | Maunabo | Puerto Rico | 72095 | 574 | |
1617528 | 1617528 | 2021-08-14 | Adjuntas | Puerto Rico | 72001 | 574 | |
1552593 | 1552593 | 2021-07-25 | Hormigueros | Puerto Rico | 72067 | 574 | |
1438966 | 1438966 | 2021-06-20 | Guayanilla | Puerto Rico | 72059 | 574 | |
1435719 | 1435719 | 2021-06-19 | Guayanilla | Puerto Rico | 72059 | 574 | |
1432472 | 1432472 | 2021-06-18 | Guayanilla | Puerto Rico | 72059 | 574 | |
1429226 | 1429226 | 2021-06-17 | Guayanilla | Puerto Rico | 72059 | 574 | |
1425981 | 1425981 | 2021-06-16 | Guayanilla | Puerto Rico | 72059 | 574 | |
1422734 | 1422734 | 2021-06-15 | Guayanilla | Puerto Rico | 72059 | 574 | |
1419488 | 1419488 | 2021-06-14 | Guayanilla | Puerto Rico | 72059 | 574 | |
1416243 | 1416243 | 2021-06-13 | Guayanilla | Puerto Rico | 72059 | 574 | |
1412997 | 1412997 | 2021-06-12 | Guayanilla | Puerto Rico | 72059 | 574 | |
1409752 | 1409752 | 2021-06-11 | Guayanilla | Puerto Rico | 72059 | 574 | |
1406507 | 1406507 | 2021-06-10 | Guayanilla | Puerto Rico | 72059 | 574 | |
1387034 | 1387034 | 2021-06-04 | Guayanilla | Puerto Rico | 72059 | 574 | |
1244216 | 1244216 | 2021-04-21 | Rincon | Puerto Rico | 72117 | 574 | |
1240969 | 1240969 | 2021-04-20 | Rincon | Puerto Rico | 72117 | 574 | |
1221481 | 1221481 | 2021-04-14 | Penuelas | Puerto Rico | 72111 | 574 | |
1143547 | 1143547 | 2021-03-21 | Santa Isabel | Puerto Rico | 72133 | 574 | |
1140300 | 1140300 | 2021-03-20 | Santa Isabel | Puerto Rico | 72133 | 574 | |
1137054 | 1137054 | 2021-03-19 | Santa Isabel | Puerto Rico | 72133 | 574 | |
1065575 | 1065575 | 2021-02-25 | Aibonito | Puerto Rico | 72009 | 574 | |
1062330 | 1062330 | 2021-02-24 | Aibonito | Puerto Rico | 72009 | 574 | |
1059085 | 1059085 | 2021-02-23 | Aibonito | Puerto Rico | 72009 | 574 | |
977998 | 977998 | 2021-01-29 | San German | Puerto Rico | 72125 | 574 | |
844900 | 844900 | 2020-12-19 | Ciales | Puerto Rico | 72039 | 574 | |
799462 | 799462 | 2020-12-05 | Coamo | Puerto Rico | 72043 | 574 | |
760536 | 760536 | 2020-11-23 | Isabela | Puerto Rico | 72071 | 574 | |
747554 | 747554 | 2020-11-19 | Juana Diaz | Puerto Rico | 72075 | 574 | |
627529 | 627529 | 2020-10-13 | Morovis | Puerto Rico | 72101 | 574 | |
624287 | 624287 | 2020-10-12 | Morovis | Puerto Rico | 72101 | 574 | |
527042 | 527042 | 2020-09-12 | Arecibo | Puerto Rico | 72013 | 574 |
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);