daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 72, country_or_region = "US" and province_or_state = "Puerto Rico" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 33 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-15 | US | Puerto Rico | Maunabo | 72095 | 72 | 0 | 0 | 72 | 18.017889 | -65.922235 | 2020-11-16 05:25:57 | Maunabo, Puerto Rico, US |
2020-11-12 | US | Puerto Rico | Guanica | 72055 | 72 | 0 | 0 | 72 | 17.982429 | -66.91964300000001 | 2020-11-13 05:25:30 | Guanica, Puerto Rico, US |
2020-11-11 | US | Puerto Rico | Patillas | 72109 | 72 | 0 | 0 | 72 | 18.03174 | -66.012242 | 2020-11-12 05:25:55 | Patillas, Puerto Rico, US |
2020-11-10 | US | Puerto Rico | Patillas | 72109 | 72 | 0 | 0 | 72 | 18.03174 | -66.012242 | 2020-11-11 05:25:30 | Patillas, Puerto Rico, US |
2020-11-09 | US | Puerto Rico | Patillas | 72109 | 72 | 0 | 0 | 72 | 18.03174 | -66.012242 | 2020-11-10 05:40:07 | Patillas, Puerto Rico, US |
2020-08-20 | US | Puerto Rico | Guanica | 72055 | 72 | 0 | 0 | 72 | 17.982429 | -66.91964300000001 | 2020-08-21 04:27:41 | Guanica, Puerto Rico, US |
2020-08-18 | US | Puerto Rico | Maunabo | 72095 | 72 | 0 | 0 | 72 | 18.017889 | -65.922235 | 2020-08-19 04:27:00 | Maunabo, Puerto Rico, US |
2020-08-17 | US | Puerto Rico | Maunabo | 72095 | 72 | 0 | 0 | 72 | 18.017889 | -65.922235 | 2020-08-18 04:27:56 | Maunabo, Puerto Rico, US |
2020-08-16 | US | Puerto Rico | Maunabo | 72095 | 72 | 0 | 0 | 72 | 18.017889 | -65.922235 | 2020-08-17 04:27:20 | Maunabo, Puerto Rico, US |
2020-08-15 | US | Puerto Rico | Maunabo | 72095 | 72 | 0 | 0 | 72 | 18.017889 | -65.922235 | 2020-08-16 04:27:42 | Maunabo, Puerto Rico, US |
2020-08-12 | US | Puerto Rico | Ceiba | 72037 | 72 | 0 | 0 | 72 | 18.251818 | -65.666416 | 2020-08-13 04:29:15 | Ceiba, Puerto Rico, US |
2020-08-12 | US | Puerto Rico | Las Marias | 72083 | 72 | 0 | 0 | 72 | 18.23679 | -66.98362 | 2020-08-13 04:29:15 | Las Marias, Puerto Rico, US |
2020-08-11 | US | Puerto Rico | Ceiba | 72037 | 72 | 0 | 0 | 72 | 18.251818 | -65.666416 | 2020-08-12 04:27:29 | Ceiba, Puerto Rico, US |
2020-08-11 | US | Puerto Rico | Las Marias | 72083 | 72 | 0 | 0 | 72 | 18.23679 | -66.98362 | 2020-08-12 04:27:29 | Las Marias, Puerto Rico, US |
2020-08-10 | US | Puerto Rico | Las Marias | 72083 | 72 | 0 | 0 | 72 | 18.23679 | -66.98362 | 2020-08-11 04:35:08 | Las Marias, Puerto Rico, US |
2020-08-05 | US | Puerto Rico | Quebradillas | 72115 | 72 | 0 | 0 | 72 | 18.439692 | -66.926113 | 2020-08-06 04:35:02 | Quebradillas, Puerto Rico, US |
2020-08-04 | US | Puerto Rico | Quebradillas | 72115 | 72 | 0 | 0 | 72 | 18.439692 | -66.926113 | 2020-08-05 04:34:43 | Quebradillas, Puerto Rico, US |
2020-08-03 | US | Puerto Rico | Villalba | 72149 | 72 | 0 | 0 | 72 | 18.127951 | -66.473115 | 2020-08-04 04:41:59 | Villalba, Puerto Rico, US |
2020-08-02 | US | Puerto Rico | Barceloneta | 72017 | 72 | 0 | 0 | 72 | 18.445532999999998 | -66.56053100000001 | 2020-08-03 04:34:35 | Barceloneta, Puerto Rico, US |
2020-08-02 | US | Puerto Rico | Lajas | 72079 | 72 | 0 | 0 | 72 | 18.011661 | -67.040585 | 2020-08-03 04:34:35 | Lajas, Puerto Rico, US |
2020-08-02 | US | Puerto Rico | Villalba | 72149 | 72 | 0 | 0 | 72 | 18.127951 | -66.473115 | 2020-08-03 04:34:35 | Villalba, Puerto Rico, US |
2020-08-01 | US | Puerto Rico | Lajas | 72079 | 72 | 0 | 0 | 72 | 18.011661 | -67.040585 | 2020-08-02 04:34:47 | Lajas, Puerto Rico, US |
2020-07-29 | US | Puerto Rico | Arroyo | 72015 | 72 | 0 | 0 | 72 | 17.998457000000005 | -66.056546 | 2020-07-30 04:35:05 | Arroyo, Puerto Rico, US |
2020-07-27 | US | Puerto Rico | Loiza | 72087 | 72 | 0 | 0 | 72 | 18.425688 | -65.89943000000001 | 2020-07-28 04:58:43 | Loiza, Puerto Rico, US |
2020-07-26 | US | Puerto Rico | Hatillo | 72065 | 72 | 0 | 0 | 72 | 18.410928 | -66.79632600000001 | 2020-07-27 04:35:02 | Hatillo, Puerto Rico, US |
2020-07-25 | US | Puerto Rico | Hatillo | 72065 | 72 | 0 | 0 | 72 | 18.410928 | -66.79632600000001 | 2020-07-26 04:35:00 | Hatillo, Puerto Rico, US |
2020-07-23 | US | Puerto Rico | Adjuntas | 72001 | 72 | 0 | 0 | 72 | 18.180117000000006 | -66.754367 | 2020-07-24 05:30:40 | Adjuntas, Puerto Rico, US |
2020-07-22 | US | Puerto Rico | Adjuntas | 72001 | 72 | 0 | 0 | 72 | 18.180117000000006 | -66.754367 | 2020-07-23 05:15:04 | Adjuntas, Puerto Rico, US |
2020-07-21 | US | Puerto Rico | Adjuntas | 72001 | 72 | 0 | 0 | 72 | 18.180117000000006 | -66.754367 | 2020-07-22 04:34:42 | Adjuntas, Puerto Rico, US |
2020-07-20 | US | Puerto Rico | Adjuntas | 72001 | 72 | 0 | 0 | 72 | 18.180117000000006 | -66.754367 | 2020-07-21 04:38:46 | Adjuntas, Puerto Rico, US |
2020-07-20 | US | Puerto Rico | Luquillo | 72089 | 72 | 0 | 0 | 72 | 18.342114000000002 | -65.72509699999999 | 2020-07-21 04:38:46 | Luquillo, Puerto Rico, US |
2020-07-19 | US | Puerto Rico | Adjuntas | 72001 | 72 | 0 | 0 | 72 | 18.180117000000006 | -66.754367 | 2020-07-20 05:34:40 | Adjuntas, Puerto Rico, US |
2020-07-19 | US | Puerto Rico | Luquillo | 72089 | 72 | 0 | 0 | 72 | 18.342114000000002 | -65.72509699999999 | 2020-07-20 05:34:40 | Luquillo, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;