ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 453 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1922954 | 1922954 | 2021-11-16 | Guanica | Puerto Rico | 72055 | 453 | |
1919705 | 1919705 | 2021-11-15 | Guanica | Puerto Rico | 72055 | 453 | |
1370784 | 1370784 | 2021-05-30 | Arroyo | Puerto Rico | 72015 | 453 | |
1312386 | 1312386 | 2021-05-12 | Maunabo | Puerto Rico | 72095 | 453 | |
1309139 | 1309139 | 2021-05-11 | Maunabo | Puerto Rico | 72095 | 453 | |
1305893 | 1305893 | 2021-05-10 | Maunabo | Puerto Rico | 72095 | 453 | |
1234434 | 1234434 | 2021-04-18 | Ceiba | Puerto Rico | 72037 | 453 | |
1214963 | 1214963 | 2021-04-12 | Hormigueros | Puerto Rico | 72067 | 453 | |
1175984 | 1175984 | 2021-03-31 | Guayanilla | Puerto Rico | 72059 | 453 | |
1172737 | 1172737 | 2021-03-30 | Guayanilla | Puerto Rico | 72059 | 453 | |
1169490 | 1169490 | 2021-03-29 | Guayanilla | Puerto Rico | 72059 | 453 | |
1166242 | 1166242 | 2021-03-28 | Guayanilla | Puerto Rico | 72059 | 453 | |
1003905 | 1003905 | 2021-02-06 | Adjuntas | Puerto Rico | 72001 | 453 | |
958522 | 958522 | 2021-01-23 | Penuelas | Puerto Rico | 72111 | 453 | |
903299 | 903299 | 2021-01-06 | Aibonito | Puerto Rico | 72009 | 453 | |
900054 | 900054 | 2021-01-05 | Aibonito | Puerto Rico | 72009 | 453 | |
754060 | 754060 | 2020-11-21 | Naguabo | Puerto Rico | 72103 | 453 | |
731316 | 731316 | 2020-11-14 | Guayama | Puerto Rico | 72057 | 453 | |
682676 | 682676 | 2020-10-30 | Lares | Puerto Rico | 72081 | 453 | |
556204 | 556204 | 2020-09-21 | Humacao | Puerto Rico | 72069 | 453 | |
546486 | 546486 | 2020-09-18 | Gurabo | Puerto Rico | 72063 | 453 | |
510920 | 510920 | 2020-09-07 | Rio Grande | Puerto Rico | 72119 | 453 | |
478578 | 478578 | 2020-08-28 | Naranjito | Puerto Rico | 72105 | 453 |
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);