ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 377 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Patillas 6
- Juana Diaz 2
- Sabana Grande 2
- San German 2
- Aibonito 1
- Arecibo 1
- Barranquitas 1
- Ceiba 1
- Comerio 1
- Guayama 1
- Guayanilla 1
- Jayuya 1
- Lajas 1
- Lares 1
- Luquillo 1
state 1
- Puerto Rico · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1153276 | 1153276 | 2021-03-24 | Patillas | Puerto Rico | 72109 | 377 | |
1150029 | 1150029 | 2021-03-23 | Patillas | Puerto Rico | 72109 | 377 | |
1146782 | 1146782 | 2021-03-22 | Patillas | Puerto Rico | 72109 | 377 | |
1143535 | 1143535 | 2021-03-21 | Patillas | Puerto Rico | 72109 | 377 | |
1140288 | 1140288 | 2021-03-20 | Patillas | Puerto Rico | 72109 | 377 | |
1137042 | 1137042 | 2021-03-19 | Patillas | Puerto Rico | 72109 | 377 | |
1007191 | 1007191 | 2021-02-07 | Lajas | Puerto Rico | 72079 | 377 | |
981242 | 981242 | 2021-01-30 | Sabana Grande | Puerto Rico | 72121 | 377 | |
977996 | 977996 | 2021-01-29 | Sabana Grande | Puerto Rico | 72121 | 377 | |
974708 | 974708 | 2021-01-28 | Ceiba | Puerto Rico | 72037 | 377 | |
939022 | 939022 | 2021-01-17 | Guayanilla | Puerto Rico | 72059 | 377 | |
916313 | 916313 | 2021-01-10 | Jayuya | Puerto Rico | 72073 | 377 | |
818916 | 818916 | 2020-12-11 | Aibonito | Puerto Rico | 72009 | 377 | |
767012 | 767012 | 2020-11-25 | Comerio | Puerto Rico | 72045 | 377 | |
754053 | 754053 | 2020-11-21 | Luquillo | Puerto Rico | 72089 | 377 | |
741086 | 741086 | 2020-11-17 | San German | Puerto Rico | 72125 | 377 | |
737840 | 737840 | 2020-11-16 | San German | Puerto Rico | 72125 | 377 | |
669693 | 669693 | 2020-10-26 | Guayama | Puerto Rico | 72057 | 377 | |
617791 | 617791 | 2020-10-10 | Lares | Puerto Rico | 72081 | 377 | |
608063 | 608063 | 2020-10-07 | Juana Diaz | Puerto Rico | 72075 | 377 | |
604820 | 604820 | 2020-10-06 | Juana Diaz | Puerto Rico | 72075 | 377 | |
536753 | 536753 | 2020-09-15 | Barranquitas | Puerto Rico | 72019 | 377 | |
436557 | 436557 | 2020-08-15 | Arecibo | Puerto Rico | 72013 | 377 |
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);