ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 85 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 25
county 25
- Vieques 5
- Maricao 4
- Patillas 4
- Guanica 3
- Adjuntas 2
- Caguas 2
- Penuelas 2
- Villalba 2
- Aguadilla 1
- Aguas Buenas 1
- Anasco 1
- Barranquitas 1
- Cidra 1
- Florida 1
- Guayama 1
- Gurabo 1
- Hormigueros 1
- Humacao 1
- Las Piedras 1
- Luquillo 1
- Orocovis 1
- Rio Grande 1
- Sabana Grande 1
- Toa Alta 1
- Yauco 1
state 1
- Puerto Rico · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
591860 | 591860 | 2020-10-02 | Maricao | Puerto Rico | 72093 | 85 | |
582139 | 582139 | 2020-09-29 | Maricao | Puerto Rico | 72093 | 85 | |
578899 | 578899 | 2020-09-28 | Maricao | Puerto Rico | 72093 | 85 | |
575658 | 575658 | 2020-09-27 | Maricao | Puerto Rico | 72093 | 85 | |
520592 | 520592 | 2020-09-10 | Guanica | Puerto Rico | 72055 | 85 | |
517356 | 517356 | 2020-09-09 | Guanica | Puerto Rico | 72055 | 85 | |
517403 | 517403 | 2020-09-09 | Vieques | Puerto Rico | 72147 | 85 | |
514121 | 514121 | 2020-09-08 | Guanica | Puerto Rico | 72055 | 85 | |
514168 | 514168 | 2020-09-08 | Vieques | Puerto Rico | 72147 | 85 | |
510935 | 510935 | 2020-09-07 | Vieques | Puerto Rico | 72147 | 85 | |
481834 | 481834 | 2020-08-29 | Vieques | Puerto Rico | 72147 | 85 | |
478600 | 478600 | 2020-08-28 | Vieques | Puerto Rico | 72147 | 85 | |
449513 | 449513 | 2020-08-19 | Penuelas | Puerto Rico | 72111 | 85 | |
446285 | 446285 | 2020-08-18 | Penuelas | Puerto Rico | 72111 | 85 | |
436627 | 436627 | 2020-08-15 | Villalba | Puerto Rico | 72149 | 85 | |
426949 | 426949 | 2020-08-12 | Villalba | Puerto Rico | 72149 | 85 | |
407580 | 407580 | 2020-08-06 | Hormigueros | Puerto Rico | 72067 | 85 | |
394677 | 394677 | 2020-08-02 | Adjuntas | Puerto Rico | 72001 | 85 | |
391461 | 391461 | 2020-08-01 | Adjuntas | Puerto Rico | 72001 | 85 | |
378637 | 378637 | 2020-07-28 | Luquillo | Puerto Rico | 72089 | 85 | |
375431 | 375431 | 2020-07-27 | Patillas | Puerto Rico | 72109 | 85 | |
372218 | 372218 | 2020-07-26 | Patillas | Puerto Rico | 72109 | 85 | |
369006 | 369006 | 2020-07-25 | Patillas | Puerto Rico | 72109 | 85 | |
365797 | 365797 | 2020-07-24 | Patillas | Puerto Rico | 72109 | 85 | |
362539 | 362539 | 2020-07-23 | Aguas Buenas | Puerto Rico | 72007 | 85 | |
356153 | 356153 | 2020-07-21 | Florida | Puerto Rico | 72054 | 85 | |
346525 | 346525 | 2020-07-18 | Anasco | Puerto Rico | 72011 | 85 | |
343381 | 343381 | 2020-07-17 | Sabana Grande | Puerto Rico | 72121 | 85 | |
340151 | 340151 | 2020-07-16 | Guayama | Puerto Rico | 72057 | 85 | |
336927 | 336927 | 2020-07-15 | Aguadilla | Puerto Rico | 72005 | 85 | |
330593 | 330593 | 2020-07-13 | Orocovis | Puerto Rico | 72107 | 85 | |
324188 | 324188 | 2020-07-11 | Cidra | Puerto Rico | 72041 | 85 | |
308339 | 308339 | 2020-07-06 | Las Piedras | Puerto Rico | 72085 | 85 | |
305138 | 305138 | 2020-07-05 | Barranquitas | Puerto Rico | 72019 | 85 | |
279928 | 279928 | 2020-06-27 | Humacao | Puerto Rico | 72069 | 85 | |
279971 | 279971 | 2020-06-27 | Yauco | Puerto Rico | 72153 | 85 | |
245505 | 245505 | 2020-06-16 | Gurabo | Puerto Rico | 72063 | 85 | |
226890 | 226890 | 2020-06-10 | Rio Grande | Puerto Rico | 72119 | 85 | |
186851 | 186851 | 2020-05-28 | Toa Alta | Puerto Rico | 72135 | 85 | |
165485 | 165485 | 2020-05-21 | Caguas | Puerto Rico | 72025 | 85 | |
162456 | 162456 | 2020-05-20 | Caguas | Puerto Rico | 72025 | 85 |
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);