ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 79 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Las Marias 6
- Maricao 4
- Maunabo 4
- Dorado 3
- Aibonito 2
- Hormigueros 2
- Humacao 2
- Quebradillas 2
- Rincon 2
- Aguadilla 1
- Arroyo 1
- Caguas 1
- Camuy 1
- Coamo 1
- Guayanilla 1
- Lares 1
- Naranjito 1
- Orocovis 1
- Ponce 1
- Salinas 1
- San Lorenzo 1
- Unknown 1
- Utuado 1
- Vega Alta 1
- Yabucoa 1
state 1
- Puerto Rico · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
562690 | 562690 | 2020-09-23 | Maricao | Puerto Rico | 72093 | 79 | |
559453 | 559453 | 2020-09-22 | Maricao | Puerto Rico | 72093 | 79 | |
556216 | 556216 | 2020-09-21 | Maricao | Puerto Rico | 72093 | 79 | |
552979 | 552979 | 2020-09-20 | Maricao | Puerto Rico | 72093 | 79 | |
485036 | 485036 | 2020-08-30 | Las Marias | Puerto Rico | 72083 | 79 | |
481801 | 481801 | 2020-08-29 | Las Marias | Puerto Rico | 72083 | 79 | |
478567 | 478567 | 2020-08-28 | Las Marias | Puerto Rico | 72083 | 79 | |
472106 | 472106 | 2020-08-26 | Maunabo | Puerto Rico | 72095 | 79 | |
468874 | 468874 | 2020-08-25 | Maunabo | Puerto Rico | 72095 | 79 | |
465646 | 465646 | 2020-08-24 | Maunabo | Puerto Rico | 72095 | 79 | |
462417 | 462417 | 2020-08-23 | Maunabo | Puerto Rico | 72095 | 79 | |
452727 | 452727 | 2020-08-20 | Las Marias | Puerto Rico | 72083 | 79 | |
449499 | 449499 | 2020-08-19 | Las Marias | Puerto Rico | 72083 | 79 | |
439818 | 439818 | 2020-08-16 | Las Marias | Puerto Rico | 72083 | 79 | |
430170 | 430170 | 2020-08-13 | Utuado | Puerto Rico | 72141 | 79 | |
417265 | 417265 | 2020-08-09 | Quebradillas | Puerto Rico | 72115 | 79 | |
414044 | 414044 | 2020-08-08 | Quebradillas | Puerto Rico | 72115 | 79 | |
404334 | 404334 | 2020-08-05 | Arroyo | Puerto Rico | 72015 | 79 | |
401113 | 401113 | 2020-08-04 | Aibonito | Puerto Rico | 72009 | 79 | |
397898 | 397898 | 2020-08-03 | Aibonito | Puerto Rico | 72009 | 79 | |
388278 | 388278 | 2020-07-31 | Hormigueros | Puerto Rico | 72067 | 79 | |
385061 | 385061 | 2020-07-30 | Hormigueros | Puerto Rico | 72067 | 79 | |
381868 | 381868 | 2020-07-29 | Rincon | Puerto Rico | 72117 | 79 | |
378651 | 378651 | 2020-07-28 | Rincon | Puerto Rico | 72117 | 79 | |
372176 | 372176 | 2020-07-26 | Camuy | Puerto Rico | 72027 | 79 | |
372240 | 372240 | 2020-07-26 | Yabucoa | Puerto Rico | 72151 | 79 | |
362557 | 362557 | 2020-07-23 | Coamo | Puerto Rico | 72043 | 79 | |
340187 | 340187 | 2020-07-16 | San Lorenzo | Puerto Rico | 72129 | 79 | |
333761 | 333761 | 2020-07-14 | Guayanilla | Puerto Rico | 72059 | 79 | |
324170 | 324170 | 2020-07-11 | Aguadilla | Puerto Rico | 72005 | 79 | |
314691 | 314691 | 2020-07-08 | Orocovis | Puerto Rico | 72107 | 79 | |
308349 | 308349 | 2020-07-06 | Naranjito | Puerto Rico | 72105 | 79 | |
295716 | 295716 | 2020-07-02 | Vega Alta | Puerto Rico | 72143 | 79 | |
289376 | 289376 | 2020-06-30 | Lares | Puerto Rico | 72081 | 79 | |
267360 | 267360 | 2020-06-23 | Humacao | Puerto Rico | 72069 | 79 | |
264232 | 264232 | 2020-06-22 | Humacao | Puerto Rico | 72069 | 79 | |
229959 | 229959 | 2020-06-11 | Dorado | Puerto Rico | 72051 | 79 | |
226855 | 226855 | 2020-06-10 | Dorado | Puerto Rico | 72051 | 79 | |
223755 | 223755 | 2020-06-09 | Dorado | Puerto Rico | 72051 | 79 | |
211429 | 211429 | 2020-06-05 | Salinas | Puerto Rico | 72123 | 79 | |
162500 | 162500 | 2020-05-20 | Ponce | Puerto Rico | 72113 | 79 | |
150380 | 150380 | 2020-05-16 | Caguas | Puerto Rico | 72025 | 79 | |
15367 | 15367 | 2020-03-27 | Unknown | Puerto Rico | 79 | 3 |
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);