ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 468 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 |
---|---|---|---|---|---|---|---|
1542825 | 1542825 | 2021-07-22 | Arroyo | Puerto Rico | 72015 | 468 | |
1539577 | 1539577 | 2021-07-21 | Arroyo | Puerto Rico | 72015 | 468 | |
1536330 | 1536330 | 2021-07-20 | Arroyo | Puerto Rico | 72015 | 468 | |
1533082 | 1533082 | 2021-07-19 | Arroyo | Puerto Rico | 72015 | 468 | |
1529835 | 1529835 | 2021-07-18 | Arroyo | Puerto Rico | 72015 | 468 | |
1526588 | 1526588 | 2021-07-17 | Arroyo | Puerto Rico | 72015 | 468 | |
1523341 | 1523341 | 2021-07-16 | Arroyo | Puerto Rico | 72015 | 468 | |
1520093 | 1520093 | 2021-07-15 | Arroyo | Puerto Rico | 72015 | 468 | |
1516845 | 1516845 | 2021-07-14 | Arroyo | Puerto Rico | 72015 | 468 | |
1513598 | 1513598 | 2021-07-13 | Arroyo | Puerto Rico | 72015 | 468 | |
1510352 | 1510352 | 2021-07-12 | Arroyo | Puerto Rico | 72015 | 468 | |
1201974 | 1201974 | 2021-04-08 | Jayuya | Puerto Rico | 72073 | 468 | |
1198718 | 1198718 | 2021-04-07 | Guayanilla | Puerto Rico | 72059 | 468 | |
1195469 | 1195469 | 2021-04-06 | Guayanilla | Puerto Rico | 72059 | 468 | |
1192221 | 1192221 | 2021-04-05 | Guayanilla | Puerto Rico | 72059 | 468 | |
1166271 | 1166271 | 2021-03-28 | Rincon | Puerto Rico | 72117 | 468 | |
1124000 | 1124000 | 2021-03-15 | Adjuntas | Puerto Rico | 72001 | 468 | |
1120754 | 1120754 | 2021-03-14 | Adjuntas | Puerto Rico | 72001 | 468 | |
1117507 | 1117507 | 2021-03-13 | Adjuntas | Puerto Rico | 72001 | 468 | |
1114260 | 1114260 | 2021-03-12 | Adjuntas | Puerto Rico | 72001 | 468 | |
763750 | 763750 | 2020-11-24 | Anasco | Puerto Rico | 72011 | 468 | |
763821 | 763821 | 2020-11-24 | Villalba | Puerto Rico | 72149 | 468 | |
721610 | 721610 | 2020-11-11 | Orocovis | Puerto Rico | 72107 | 468 | |
702116 | 702116 | 2020-11-05 | Cidra | Puerto Rico | 72041 | 468 | |
702129 | 702129 | 2020-11-05 | Hatillo | Puerto Rico | 72065 | 468 | |
666497 | 666497 | 2020-10-25 | Yabucoa | Puerto Rico | 72151 | 468 | |
520624 | 520624 | 2020-09-10 | Rio Grande | Puerto Rico | 72119 | 468 | |
491513 | 491513 | 2020-09-01 | Naranjito | Puerto Rico | 72105 | 468 | |
177697 | 177697 | 2020-05-25 | San Juan | Puerto Rico | 72127 | 468 |
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);