ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8 rows where cases = 463 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Barceloneta 1
- Cabo Rojo 1
- Camuy 1
- Hormigueros 1
- Naguabo 1
- Naranjito 1
- Orocovis 1
- Vega Baja 1
state 1
- Puerto Rico · 8 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1231202 | 1231202 | 2021-04-17 | Hormigueros | Puerto Rico | 72067 | 463 | |
786469 | 786469 | 2020-12-01 | Barceloneta | Puerto Rico | 72017 | 463 | |
757307 | 757307 | 2020-11-22 | Naguabo | Puerto Rico | 72103 | 463 | |
715124 | 715124 | 2020-11-09 | Orocovis | Puerto Rico | 72107 | 463 | |
711839 | 711839 | 2020-11-08 | Camuy | Puerto Rico | 72027 | 463 | |
640470 | 640470 | 2020-10-17 | Cabo Rojo | Puerto Rico | 72023 | 463 | |
485047 | 485047 | 2020-08-30 | Naranjito | Puerto Rico | 72105 | 463 | |
433398 | 433398 | 2020-08-14 | Vega Baja | Puerto Rico | 72145 | 463 |
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);