ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 224 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Guayanilla 3
- Hormigueros 2
- Aguas Buenas 1
- Aibonito 1
- Arecibo 1
- Bayamon 1
- Dorado 1
- Juana Diaz 1
- Moca 1
- Rincon 1
- Toa Baja 1
- Utuado 1
- Vega Alta 1
- Vega Baja 1
state 1
- Puerto Rico · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
702100 | 702100 | 2020-11-05 | Aibonito | Puerto Rico | 72009 | 224 | |
692401 | 692401 | 2020-11-02 | Hormigueros | Puerto Rico | 72067 | 224 | |
689157 | 689157 | 2020-11-01 | Hormigueros | Puerto Rico | 72067 | 224 | |
660003 | 660003 | 2020-10-23 | Utuado | Puerto Rico | 72141 | 224 | |
640489 | 640489 | 2020-10-17 | Guayanilla | Puerto Rico | 72059 | 224 | |
637243 | 637243 | 2020-10-16 | Guayanilla | Puerto Rico | 72059 | 224 | |
633997 | 633997 | 2020-10-15 | Guayanilla | Puerto Rico | 72059 | 224 | |
621052 | 621052 | 2020-10-11 | Rincon | Puerto Rico | 72117 | 224 | |
530276 | 530276 | 2020-09-13 | Aguas Buenas | Puerto Rico | 72007 | 224 | |
452735 | 452735 | 2020-08-20 | Moca | Puerto Rico | 72099 | 224 | |
443041 | 443041 | 2020-08-17 | Juana Diaz | Puerto Rico | 72075 | 224 | |
414059 | 414059 | 2020-08-08 | Vega Alta | Puerto Rico | 72143 | 224 | |
381834 | 381834 | 2020-07-29 | Dorado | Puerto Rico | 72051 | 224 | |
368957 | 368957 | 2020-07-25 | Arecibo | Puerto Rico | 72013 | 224 | |
362610 | 362610 | 2020-07-23 | Vega Baja | Puerto Rico | 72145 | 224 | |
321057 | 321057 | 2020-07-10 | Toa Baja | Puerto Rico | 72137 | 224 | |
192920 | 192920 | 2020-05-30 | Bayamon | Puerto Rico | 72021 | 224 |
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);