daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
71,726 rows where province_or_state = "Puerto Rico" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-15 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-08-16 04:21:31 | Out of PR, Puerto Rico, US | |
2021-08-14 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-08-15 04:21:41 | Out of PR, Puerto Rico, US | |
2021-07-24 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-07-25 04:22:12 | Out of PR, Puerto Rico, US | |
2021-07-25 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-07-26 04:21:28 | Out of PR, Puerto Rico, US | |
2021-08-16 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-08-17 04:21:49 | Out of PR, Puerto Rico, US | |
2021-07-23 | US | Puerto Rico | Out of PR | 72888 | 0 | 0 | 0 | 18.459681 | -67.336525 | 2021-07-24 00:21:36 | Out of PR, Puerto Rico, US | |
2020-03-14 | US | Puerto Rico | 3 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-14T18:33:03 | ||||
2020-03-18 | US | Puerto Rico | 5 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-16T00:22:11 | ||||
2020-03-15 | US | Puerto Rico | 5 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-14T18:33:03 | ||||
2020-03-19 | US | Puerto Rico | 5 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-16T00:22:11 | ||||
2020-03-16 | US | Puerto Rico | 5 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-16T00:22:11 | ||||
2020-03-17 | US | Puerto Rico | 5 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-16T00:22:11 | ||||
2020-07-18 | US | Puerto Rico | Culebra | 72049 | 10 | 0 | 0 | 10 | 18.31586 | -65.28813000000001 | 2020-07-19 04:34:58 | Culebra, Puerto Rico, US |
2020-07-19 | US | Puerto Rico | Culebra | 72049 | 11 | 0 | 0 | 11 | 18.31586 | -65.28813000000001 | 2020-07-20 05:34:40 | Culebra, Puerto Rico, US |
2020-07-20 | US | Puerto Rico | Culebra | 72049 | 11 | 0 | 0 | 11 | 18.31586 | -65.28813000000001 | 2020-07-21 04:38:46 | Culebra, Puerto Rico, US |
2020-07-21 | US | Puerto Rico | Culebra | 72049 | 11 | 0 | 0 | 11 | 18.31586 | -65.28813000000001 | 2020-07-22 04:34:42 | Culebra, Puerto Rico, US |
2020-07-23 | US | Puerto Rico | Culebra | 72049 | 13 | 0 | 0 | 13 | 18.31586 | -65.28813000000001 | 2020-07-24 05:30:40 | Culebra, Puerto Rico, US |
2020-07-22 | US | Puerto Rico | Culebra | 72049 | 13 | 0 | 0 | 13 | 18.31586 | -65.28813000000001 | 2020-07-23 05:15:04 | Culebra, Puerto Rico, US |
2020-07-24 | US | Puerto Rico | Culebra | 72049 | 13 | 0 | 0 | 13 | 18.31586 | -65.28813000000001 | 2020-07-25 04:47:39 | Culebra, Puerto Rico, US |
2020-07-27 | US | Puerto Rico | Culebra | 72049 | 14 | 0 | 0 | 14 | 18.31586 | -65.28813000000001 | 2020-07-28 04:58:43 | Culebra, Puerto Rico, US |
2020-07-26 | US | Puerto Rico | Culebra | 72049 | 14 | 0 | 0 | 14 | 18.31586 | -65.28813000000001 | 2020-07-27 04:35:02 | Culebra, Puerto Rico, US |
2020-07-25 | US | Puerto Rico | Culebra | 72049 | 14 | 0 | 0 | 14 | 18.31586 | -65.28813000000001 | 2020-07-26 04:35:00 | Culebra, Puerto Rico, US |
2020-03-20 | US | Puerto Rico | 14 | 0 | 0 | 18.2208 | -66.5901 | 2020-03-20T22:13:55 | ||||
2020-07-29 | US | Puerto Rico | Culebra | 72049 | 16 | 0 | 0 | 16 | 18.31586 | -65.28813000000001 | 2020-07-30 04:35:05 | Culebra, Puerto Rico, US |
2020-07-28 | US | Puerto Rico | Culebra | 72049 | 16 | 0 | 0 | 16 | 18.31586 | -65.28813000000001 | 2020-07-29 04:35:11 | Culebra, Puerto Rico, US |
2020-08-04 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-08-05 04:34:43 | Culebra, Puerto Rico, US |
2020-08-01 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-08-02 04:34:47 | Culebra, Puerto Rico, US |
2020-07-30 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-07-31 04:35:18 | Culebra, Puerto Rico, US |
2020-08-03 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-08-04 04:41:59 | Culebra, Puerto Rico, US |
2020-08-02 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-08-03 04:34:35 | Culebra, Puerto Rico, US |
2020-07-31 | US | Puerto Rico | Culebra | 72049 | 17 | 0 | 0 | 17 | 18.31586 | -65.28813000000001 | 2020-08-01 04:36:27 | Culebra, Puerto Rico, US |
2020-11-10 | US | Puerto Rico | Culebra | 72049 | 18 | 0 | 0 | 18 | 18.31586 | -65.28813000000001 | 2020-11-11 05:25:30 | Culebra, Puerto Rico, US |
2020-11-07 | US | Puerto Rico | Culebra | 72049 | 18 | 0 | 0 | 18 | 18.31586 | -65.28813000000001 | 2020-11-08 05:24:56 | Culebra, Puerto Rico, US |
2020-11-08 | US | Puerto Rico | Culebra | 72049 | 18 | 0 | 0 | 18 | 18.31586 | -65.28813000000001 | 2020-11-09 05:25:45 | Culebra, Puerto Rico, US |
2020-11-09 | US | Puerto Rico | Culebra | 72049 | 18 | 0 | 0 | 18 | 18.31586 | -65.28813000000001 | 2020-11-10 05:40:07 | Culebra, Puerto Rico, US |
2020-08-05 | US | Puerto Rico | Culebra | 72049 | 18 | 0 | 0 | 18 | 18.31586 | -65.28813000000001 | 2020-08-06 04:35:02 | Culebra, Puerto Rico, US |
2020-11-18 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-19 05:25:23 | Culebra, Puerto Rico, US |
2020-08-15 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-16 04:27:42 | Culebra, Puerto Rico, US |
2020-08-19 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-20 04:27:43 | Culebra, Puerto Rico, US |
2020-08-08 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-09 04:34:54 | Culebra, Puerto Rico, US |
2020-08-07 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-08 04:34:53 | Culebra, Puerto Rico, US |
2020-08-13 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-14 04:51:19 | Culebra, Puerto Rico, US |
2020-08-11 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-12 04:27:29 | Culebra, Puerto Rico, US |
2020-08-17 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-18 04:27:56 | Culebra, Puerto Rico, US |
2020-11-12 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-13 05:25:30 | Culebra, Puerto Rico, US |
2020-08-21 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-22 04:27:49 | Culebra, Puerto Rico, US |
2020-08-16 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-17 04:27:20 | Culebra, Puerto Rico, US |
2020-08-14 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-15 04:27:31 | Culebra, Puerto Rico, US |
2020-08-10 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-11 04:35:08 | Culebra, Puerto Rico, US |
2020-08-26 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-27 04:28:15 | Culebra, Puerto Rico, US |
2020-08-23 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-24 04:27:56 | Culebra, Puerto Rico, US |
2020-08-22 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-23 04:27:48 | Culebra, Puerto Rico, US |
2020-11-13 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-14 05:25:37 | Culebra, Puerto Rico, US |
2020-11-15 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-16 05:25:57 | Culebra, Puerto Rico, US |
2020-11-14 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-15 05:26:53 | Culebra, Puerto Rico, US |
2020-08-24 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-25 04:28:02 | Culebra, Puerto Rico, US |
2020-11-16 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-17 05:25:54 | Culebra, Puerto Rico, US |
2020-08-18 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813 | 2020-08-19 04:27:00 | Culebra, Puerto Rico, US |
2020-11-17 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-18 05:40:31 | Culebra, Puerto Rico, US |
2020-11-11 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-11-12 05:25:55 | Culebra, Puerto Rico, US |
2020-08-20 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-21 04:27:41 | Culebra, Puerto Rico, US |
2020-08-12 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-13 04:29:15 | Culebra, Puerto Rico, US |
2020-08-25 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-26 04:28:11 | Culebra, Puerto Rico, US |
2020-08-06 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-07 04:35:11 | Culebra, Puerto Rico, US |
2020-08-09 | US | Puerto Rico | Culebra | 72049 | 19 | 0 | 0 | 19 | 18.31586 | -65.28813000000001 | 2020-08-10 04:34:55 | Culebra, Puerto Rico, US |
2020-12-03 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-04 05:27:27 | Culebra, Puerto Rico, US |
2020-08-31 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-09-01 04:28:31 | Culebra, Puerto Rico, US |
2020-11-27 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-28 05:25:50 | Culebra, Puerto Rico, US |
2020-08-29 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-08-30 04:28:22 | Culebra, Puerto Rico, US |
2020-11-23 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-24 05:27:31 | Culebra, Puerto Rico, US |
2020-12-02 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-03 05:28:22 | Culebra, Puerto Rico, US |
2020-11-19 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-20 05:26:28 | Culebra, Puerto Rico, US |
2020-12-12 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-13 05:27:20 | Culebra, Puerto Rico, US |
2020-12-11 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-12 05:26:19 | Culebra, Puerto Rico, US |
2020-11-26 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-27 05:26:53 | Culebra, Puerto Rico, US |
2020-12-06 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-07 05:26:14 | Culebra, Puerto Rico, US |
2020-12-15 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-16 05:28:04 | Culebra, Puerto Rico, US |
2020-11-24 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-25 05:27:20 | Culebra, Puerto Rico, US |
2020-08-28 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-08-29 04:28:19 | Culebra, Puerto Rico, US |
2020-11-30 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-01 05:26:18 | Culebra, Puerto Rico, US |
2020-12-10 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-11 05:26:59 | Culebra, Puerto Rico, US |
2020-12-05 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-06 05:26:18 | Culebra, Puerto Rico, US |
2020-12-14 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-15 05:26:38 | Culebra, Puerto Rico, US |
2020-12-08 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-09 05:28:01 | Culebra, Puerto Rico, US |
2020-12-18 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-19 05:27:52 | Culebra, Puerto Rico, US |
2020-11-25 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-26 05:27:44 | Culebra, Puerto Rico, US |
2020-09-01 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-09-02 04:28:25 | Culebra, Puerto Rico, US |
2020-12-17 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-18 05:28:18 | Culebra, Puerto Rico, US |
2020-12-07 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-08 05:27:42 | Culebra, Puerto Rico, US |
2020-08-27 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-08-28 04:28:11 | Culebra, Puerto Rico, US |
2020-12-01 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-02 05:27:41 | Culebra, Puerto Rico, US |
2020-11-20 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-21 05:25:51 | Culebra, Puerto Rico, US |
2020-12-19 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-20 05:27:32 | Culebra, Puerto Rico, US |
2020-11-28 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-29 05:25:55 | Culebra, Puerto Rico, US |
2020-12-09 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-10 05:26:19 | Culebra, Puerto Rico, US |
2020-12-16 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-17 05:28:12 | Culebra, Puerto Rico, US |
2020-11-22 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-23 05:25:26 | Culebra, Puerto Rico, US |
2020-11-29 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-30 05:26:13 | Culebra, Puerto Rico, US |
2020-11-21 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-11-22 05:25:45 | Culebra, Puerto Rico, US |
2020-12-13 | US | Puerto Rico | Culebra | 72049 | 20 | 0 | 0 | 20 | 18.31586 | -65.28813000000001 | 2020-12-14 05:26:27 | Culebra, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;