ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 106 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 20
county 20
- Maricao 6
- Utuado 5
- Barranquitas 2
- Quebradillas 2
- Cabo Rojo 1
- Caguas 1
- Dorado 1
- Guaynabo 1
- Hatillo 1
- Humacao 1
- Isabela 1
- Juncos 1
- Lajas 1
- Las Marias 1
- Las Piedras 1
- Luquillo 1
- Morovis 1
- Naguabo 1
- Rincon 1
- Rio Grande 1
state 1
- Puerto Rico · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
977982 | 977982 | 2021-01-29 | Maricao | Puerto Rico | 72093 | 106 | |
974737 | 974737 | 2021-01-28 | Maricao | Puerto Rico | 72093 | 106 | |
971492 | 971492 | 2021-01-27 | Maricao | Puerto Rico | 72093 | 106 | |
968247 | 968247 | 2021-01-26 | Maricao | Puerto Rico | 72093 | 106 | |
965003 | 965003 | 2021-01-25 | Maricao | Puerto Rico | 72093 | 106 | |
961758 | 961758 | 2021-01-24 | Maricao | Puerto Rico | 72093 | 106 | |
572409 | 572409 | 2020-09-26 | Las Marias | Puerto Rico | 72083 | 106 | |
517400 | 517400 | 2020-09-09 | Utuado | Puerto Rico | 72141 | 106 | |
514165 | 514165 | 2020-09-08 | Utuado | Puerto Rico | 72141 | 106 | |
510932 | 510932 | 2020-09-07 | Utuado | Puerto Rico | 72141 | 106 | |
507699 | 507699 | 2020-09-06 | Utuado | Puerto Rico | 72141 | 106 | |
504467 | 504467 | 2020-09-05 | Utuado | Puerto Rico | 72141 | 106 | |
472116 | 472116 | 2020-08-26 | Quebradillas | Puerto Rico | 72115 | 106 | |
468884 | 468884 | 2020-08-25 | Quebradillas | Puerto Rico | 72115 | 106 | |
465638 | 465638 | 2020-08-24 | Lajas | Puerto Rico | 72079 | 106 | |
443055 | 443055 | 2020-08-17 | Naguabo | Puerto Rico | 72103 | 106 | |
433383 | 433383 | 2020-08-14 | Rincon | Puerto Rico | 72117 | 106 | |
417240 | 417240 | 2020-08-09 | Hatillo | Puerto Rico | 72065 | 106 | |
417252 | 417252 | 2020-08-09 | Luquillo | Puerto Rico | 72089 | 106 | |
397933 | 397933 | 2020-08-03 | Juncos | Puerto Rico | 72077 | 106 | |
381845 | 381845 | 2020-07-29 | Isabela | Puerto Rico | 72071 | 106 | |
352966 | 352966 | 2020-07-20 | Las Piedras | Puerto Rico | 72085 | 106 | |
343371 | 343371 | 2020-07-17 | Morovis | Puerto Rico | 72101 | 106 | |
330548 | 330548 | 2020-07-13 | Barranquitas | Puerto Rico | 72019 | 106 | |
327362 | 327362 | 2020-07-12 | Barranquitas | Puerto Rico | 72019 | 106 | |
327364 | 327364 | 2020-07-12 | Cabo Rojo | Puerto Rico | 72023 | 106 | |
317845 | 317845 | 2020-07-09 | Humacao | Puerto Rico | 72069 | 106 | |
305154 | 305154 | 2020-07-05 | Dorado | Puerto Rico | 72051 | 106 | |
295703 | 295703 | 2020-07-02 | Rio Grande | Puerto Rico | 72119 | 106 | |
183739 | 183739 | 2020-05-27 | Caguas | Puerto Rico | 72025 | 106 | |
117517 | 117517 | 2020-05-05 | Guaynabo | Puerto Rico | 72061 | 106 |
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);