ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 1070 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Ciales 6
- Comerio 2
- Juana Diaz 2
- Salinas 1
- Trujillo Alto 1
- Unknown 1
- Vega Alta 1
- Yauco 1
state 1
- Puerto Rico · 15 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1896951 | 1896951 | 2021-11-08 | Comerio | Puerto Rico | 72045 | 1070 | |
1893701 | 1893701 | 2021-11-07 | Comerio | Puerto Rico | 72045 | 1070 | |
1835210 | 1835210 | 2021-10-20 | Ciales | Puerto Rico | 72039 | 1070 | |
1831961 | 1831961 | 2021-10-19 | Ciales | Puerto Rico | 72039 | 1070 | |
1828712 | 1828712 | 2021-10-18 | Ciales | Puerto Rico | 72039 | 1070 | |
1825463 | 1825463 | 2021-10-17 | Ciales | Puerto Rico | 72039 | 1070 | |
1822214 | 1822214 | 2021-10-16 | Ciales | Puerto Rico | 72039 | 1070 | |
1818965 | 1818965 | 2021-10-15 | Ciales | Puerto Rico | 72039 | 1070 | |
1218255 | 1218255 | 2021-04-13 | Yauco | Puerto Rico | 72153 | 1070 | |
1192253 | 1192253 | 2021-04-05 | Salinas | Puerto Rico | 72123 | 1070 | |
1039643 | 1039643 | 2021-02-17 | Juana Diaz | Puerto Rico | 72075 | 1070 | |
1036398 | 1036398 | 2021-02-16 | Juana Diaz | Puerto Rico | 72075 | 1070 | |
718386 | 718386 | 2020-11-10 | Vega Alta | Puerto Rico | 72143 | 1070 | |
575681 | 575681 | 2020-09-27 | Trujillo Alto | Puerto Rico | 72139 | 1070 | |
391532 | 391532 | 2020-08-01 | Unknown | Puerto Rico | 1070 | 225 |
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);