ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 628 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- Guayanilla 5
- Luquillo 5
- Jayuya 2
- Adjuntas 1
- Arecibo 1
- Ceiba 1
- Ciales 1
- Cidra 1
- Comerio 1
- Hormigueros 1
- Juncos 1
- Lajas 1
- Naranjito 1
- San German 1
- San Lorenzo 1
- Villalba 1
state 1
- Puerto Rico · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1679278 | 1679278 | 2021-09-02 | Jayuya | Puerto Rico | 72073 | 628 | |
1676030 | 1676030 | 2021-09-01 | Jayuya | Puerto Rico | 72073 | 628 | |
1672746 | 1672746 | 2021-08-31 | Adjuntas | Puerto Rico | 72001 | 628 | |
1666269 | 1666269 | 2021-08-29 | Ceiba | Puerto Rico | 72037 | 628 | |
1630547 | 1630547 | 2021-08-18 | Guayanilla | Puerto Rico | 72059 | 628 | |
1627300 | 1627300 | 2021-08-17 | Guayanilla | Puerto Rico | 72059 | 628 | |
1624053 | 1624053 | 2021-08-16 | Guayanilla | Puerto Rico | 72059 | 628 | |
1620806 | 1620806 | 2021-08-15 | Guayanilla | Puerto Rico | 72059 | 628 | |
1617558 | 1617558 | 2021-08-14 | Guayanilla | Puerto Rico | 72059 | 628 | |
1598071 | 1598071 | 2021-08-08 | Hormigueros | Puerto Rico | 72067 | 628 | |
1552599 | 1552599 | 2021-07-25 | Lajas | Puerto Rico | 72079 | 628 | |
1172770 | 1172770 | 2021-03-30 | San German | Puerto Rico | 72125 | 628 | |
1003950 | 1003950 | 2021-02-06 | Luquillo | Puerto Rico | 72089 | 628 | |
1000704 | 1000704 | 2021-02-05 | Luquillo | Puerto Rico | 72089 | 628 | |
997458 | 997458 | 2021-02-04 | Luquillo | Puerto Rico | 72089 | 628 | |
994212 | 994212 | 2021-02-03 | Luquillo | Puerto Rico | 72089 | 628 | |
990966 | 990966 | 2021-02-02 | Luquillo | Puerto Rico | 72089 | 628 | |
929333 | 929333 | 2021-01-14 | Villalba | Puerto Rico | 72149 | 628 | |
922785 | 922785 | 2021-01-12 | Ciales | Puerto Rico | 72039 | 628 | |
909808 | 909808 | 2021-01-08 | Comerio | Puerto Rico | 72045 | 628 | |
792971 | 792971 | 2020-12-03 | Cidra | Puerto Rico | 72041 | 628 | |
698891 | 698891 | 2020-11-04 | Juncos | Puerto Rico | 72077 | 628 | |
634032 | 634032 | 2020-10-15 | San Lorenzo | Puerto Rico | 72129 | 628 | |
578905 | 578905 | 2020-09-28 | Naranjito | Puerto Rico | 72105 | 628 | |
543223 | 543223 | 2020-09-17 | Arecibo | Puerto Rico | 72013 | 628 |
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);