ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 680 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Adjuntas 9
- Florida 4
- Ceiba 3
- Luquillo 2
- Aguadilla 1
- Anasco 1
- Barceloneta 1
- Fajardo 1
- Hormigueros 1
- Jayuya 1
- Juana Diaz 1
- Lajas 1
- Manati 1
- Maricao 1
- Naguabo 1
- Quebradillas 1
- Rincon 1
- San German 1
- San Juan 1
state 1
- Puerto Rico · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495445 | 2495445 | 2022-05-11 | Maricao | Puerto Rico | 72093 | 680 | |
2030233 | 2030233 | 2021-12-19 | Jayuya | Puerto Rico | 72073 | 680 | |
1991204 | 1991204 | 2021-12-07 | Ceiba | Puerto Rico | 72037 | 680 | |
1987953 | 1987953 | 2021-12-06 | Ceiba | Puerto Rico | 72037 | 680 | |
1984703 | 1984703 | 2021-12-05 | Ceiba | Puerto Rico | 72037 | 680 | |
1932677 | 1932677 | 2021-11-19 | Adjuntas | Puerto Rico | 72001 | 680 | |
1929426 | 1929426 | 2021-11-18 | Adjuntas | Puerto Rico | 72001 | 680 | |
1926176 | 1926176 | 2021-11-17 | Adjuntas | Puerto Rico | 72001 | 680 | |
1922926 | 1922926 | 2021-11-16 | Adjuntas | Puerto Rico | 72001 | 680 | |
1919677 | 1919677 | 2021-11-15 | Adjuntas | Puerto Rico | 72001 | 680 | |
1916427 | 1916427 | 2021-11-14 | Adjuntas | Puerto Rico | 72001 | 680 | |
1913177 | 1913177 | 2021-11-13 | Adjuntas | Puerto Rico | 72001 | 680 | |
1909927 | 1909927 | 2021-11-12 | Adjuntas | Puerto Rico | 72001 | 680 | |
1906678 | 1906678 | 2021-11-11 | Adjuntas | Puerto Rico | 72001 | 680 | |
1708517 | 1708517 | 2021-09-11 | Hormigueros | Puerto Rico | 72067 | 680 | |
1611071 | 1611071 | 2021-08-12 | Lajas | Puerto Rico | 72079 | 680 | |
1542877 | 1542877 | 2021-07-22 | Rincon | Puerto Rico | 72117 | 680 | |
1214992 | 1214992 | 2021-04-12 | San German | Puerto Rico | 72125 | 680 | |
1175999 | 1175999 | 2021-03-31 | Luquillo | Puerto Rico | 72089 | 680 | |
1172752 | 1172752 | 2021-03-30 | Luquillo | Puerto Rico | 72089 | 680 | |
1111041 | 1111041 | 2021-03-11 | Florida | Puerto Rico | 72054 | 680 | |
1107795 | 1107795 | 2021-03-10 | Florida | Puerto Rico | 72054 | 680 | |
1104549 | 1104549 | 2021-03-09 | Florida | Puerto Rico | 72054 | 680 | |
1101303 | 1101303 | 2021-03-08 | Florida | Puerto Rico | 72054 | 680 | |
1003963 | 1003963 | 2021-02-06 | Quebradillas | Puerto Rico | 72115 | 680 | |
974698 | 974698 | 2021-01-28 | Barceloneta | Puerto Rico | 72017 | 680 | |
935799 | 935799 | 2021-01-16 | Naguabo | Puerto Rico | 72103 | 680 | |
890318 | 890318 | 2021-01-02 | Anasco | Puerto Rico | 72011 | 680 | |
802724 | 802724 | 2020-12-06 | Juana Diaz | Puerto Rico | 72075 | 680 | |
702098 | 702098 | 2020-11-05 | Aguadilla | Puerto Rico | 72005 | 680 | |
646979 | 646979 | 2020-10-19 | Fajardo | Puerto Rico | 72053 | 680 | |
634013 | 634013 | 2020-10-15 | Manati | Puerto Rico | 72091 | 680 | |
217607 | 217607 | 2020-06-07 | San Juan | Puerto Rico | 72127 | 680 |
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);