ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
10 rows where cases = 1680 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
- Barranquitas 1
- Cabo Rojo 1
- Canovanas 1
- Catano 1
- Ciales 1
- Hatillo 1
- Humacao 1
- Isabela 1
- Moca 1
- Rio Grande 1
state 1
- Puerto Rico · 10 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2088721 | 2088721 | 2022-01-06 | Ciales | Puerto Rico | 72039 | 1680 | |
1659788 | 1659788 | 2021-08-27 | Hatillo | Puerto Rico | 72065 | 1680 | |
1633775 | 1633775 | 2021-08-19 | Cabo Rojo | Puerto Rico | 72023 | 1680 | |
1627286 | 1627286 | 2021-08-17 | Catano | Puerto Rico | 72033 | 1680 | |
1604543 | 1604543 | 2021-08-10 | Barranquitas | Puerto Rico | 72019 | 1680 | |
1536359 | 1536359 | 2021-07-20 | Isabela | Puerto Rico | 72071 | 1680 | |
1344857 | 1344857 | 2021-05-22 | Moca | Puerto Rico | 72099 | 1680 | |
1101311 | 1101311 | 2021-03-08 | Humacao | Puerto Rico | 72069 | 1680 | |
977995 | 977995 | 2021-01-29 | Rio Grande | Puerto Rico | 72119 | 1680 | |
971459 | 971459 | 2021-01-27 | Canovanas | Puerto Rico | 72029 | 1680 |
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);