daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,020 rows where province_or_state = "Guam" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, confirmed, deaths, active, 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-12-02 | US | Guam | 66 | 19227 | 266 | 0 | 13.4443 | 144.7937 | 2021-12-03 04:23:05 | Guam, US | ||
2021-10-28 | US | Guam | 66 | 18040 | 235 | 0 | 13.4443 | 144.7937 | 2021-10-29 04:22:03 | Guam, US | ||
2021-09-18 | US | Guam | 66 | 13438 | 179 | 0 | 13.4443 | 144.7937 | 2021-09-19 04:21:34 | Guam, US | ||
2021-05-28 | US | Guam | 66 | 8156 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-29 04:20:41 | Guam, US | ||
2022-03-20 | US | Guam | 66 | 46730 | 341 | 0 | 13.4443 | 144.7937 | 2022-03-21 04:20:50 | Guam, US | ||
2021-11-11 | US | Guam | 66 | 18840 | 258 | 0 | 13.4443 | 144.7937 | 2021-11-12 04:22:01 | Guam, US | ||
2021-08-25 | US | Guam | 66 | 9759 | 145 | 0 | 13.4443 | 144.7937 | 2021-08-26 04:21:28 | Guam, US | ||
2021-04-12 | US | Guam | 66 | 7842 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-13 04:20:37 | Guam, US | ||
2021-11-02 | US | Guam | 66 | 18321 | 242 | 0 | 13.4443 | 144.7937 | 2021-11-03 06:22:09 | Guam, US | ||
2021-05-29 | US | Guam | 66 | 8156 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-30 04:20:55 | Guam, US | ||
2021-03-07 | US | Guam | 66 | 7749 | 133 | 0 | 13.4443 | 144.7937 | 2021-03-08 05:24:48 | Guam, US | ||
2022-11-12 | US | Guam | 66 | 58990 | 406 | 0 | 13.4443 | 144.7937 | 2022-11-13 04:21:14 | Guam, US | ||
2021-09-01 | US | Guam | 66 | 10740 | 150 | 0 | 13.4443 | 144.7937 | 2021-09-02 04:21:15 | Guam, US | ||
2022-02-07 | US | Guam | 66 | 36612 | 298 | 0 | 13.4443 | 144.7937 | 2022-02-08 04:21:15 | Guam, US | ||
2021-05-25 | US | Guam | 66 | 8141 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-26 04:20:35 | Guam, US | ||
2021-11-09 | US | Guam | 66 | 18752 | 255 | 0 | 13.4443 | 144.7937 | 2021-11-10 04:21:38 | Guam, US | ||
2022-07-23 | US | Guam | 66 | 54163 | 377 | 0 | 13.4443 | 144.7937 | 2022-07-24 04:20:47 | Guam, US | ||
2022-01-14 | US | Guam | 66 | 23115 | 274 | 0 | 13.4443 | 144.7937 | 2022-01-15 04:21:07 | Guam, US | ||
2021-08-15 | US | Guam | 66 | 8911 | 143 | 0 | 13.4443 | 144.7937 | 2021-08-16 04:21:31 | Guam, US | ||
2021-06-19 | US | Guam | 66 | 8267 | 139 | 0 | 13.4443 | 144.7937 | 2021-06-20 04:21:48 | Guam, US | ||
2022-09-06 | US | Guam | 66 | 58035 | 390 | 0 | 13.4443 | 144.7937 | 2022-09-07 04:20:59 | Guam, US | ||
2022-01-09 | US | Guam | 66 | 20809 | 274 | 0 | 13.4443 | 144.7937 | 2022-01-10 04:22:07 | Guam, US | ||
2022-10-04 | US | Guam | 66 | 58600 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-05 04:23:06 | Guam, US | ||
2021-12-04 | US | Guam | 66 | 19247 | 266 | 0 | 13.4443 | 144.7937 | 2021-12-05 04:22:25 | Guam, US | ||
2022-07-09 | US | Guam | 66 | 52823 | 371 | 0 | 13.4443 | 144.7937 | 2022-07-10 04:20:54 | Guam, US | ||
2021-11-29 | US | Guam | 66 | 19179 | 263 | 0 | 13.4443 | 144.7937 | 2021-11-30 04:22:53 | Guam, US | ||
2022-03-29 | US | Guam | 66 | 47181 | 343 | 0 | 13.4443 | 144.7937 | 2022-03-30 04:20:45 | Guam, US | ||
2021-11-19 | US | Guam | 66 | 19065 | 262 | 0 | 13.4443 | 144.7937 | 2021-11-20 04:22:17 | Guam, US | ||
2022-06-21 | US | Guam | 66 | 50887 | 371 | 0 | 13.4443 | 144.7937 | 2022-06-22 04:20:54 | Guam, US | ||
2021-04-16 | US | Guam | 66 | 7859 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-17 04:20:40 | Guam, US | ||
2021-09-02 | US | Guam | 66 | 10909 | 150 | 0 | 13.4443 | 144.7937 | 2021-09-03 04:21:20 | Guam, US | ||
2022-02-13 | US | Guam | 66 | 39985 | 306 | 0 | 13.4443 | 144.7937 | 2022-02-14 04:20:51 | Guam, US | ||
2022-10-19 | US | Guam | 66 | 58703 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-20 04:22:59 | Guam, US | ||
2022-12-26 | US | Guam | 66 | 59827 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-27 04:21:07 | Guam, US | ||
2022-05-09 | US | Guam | 66 | 48369 | 357 | 0 | 13.4443 | 144.7937 | 2022-05-10 04:20:50 | Guam, US | ||
2022-05-31 | US | Guam | 66 | 49056 | 363 | 0 | 13.4443 | 144.7937 | 2022-06-01 04:20:55 | Guam, US | ||
2022-02-11 | US | Guam | 66 | 39640 | 306 | 0 | 13.4443 | 144.7937 | 2022-02-12 04:21:06 | Guam, US | ||
2021-04-02 | US | Guam | 66 | 7812 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-03 04:20:44 | Guam, US | ||
2021-08-17 | US | Guam | 66 | 9081 | 144 | 0 | 13.4443 | 144.7937 | 2021-08-18 04:21:35 | Guam, US | ||
2021-09-04 | US | Guam | 66 | 11106 | 151 | 0 | 13.4443 | 144.7937 | 2021-09-05 04:21:33 | Guam, US | ||
2022-09-08 | US | Guam | 66 | 58179 | 394 | 0 | 13.4443 | 144.7937 | 2022-09-09 04:21:11 | Guam, US | ||
2022-12-10 | US | Guam | 66 | 59460 | 409 | 0 | 13.4443 | 144.7937 | 2022-12-11 04:20:50 | Guam, US | ||
2022-03-15 | US | Guam | 66 | 46528 | 339 | 0 | 13.4443 | 144.7937 | 2022-03-16 04:20:50 | Guam, US | ||
2021-11-03 | US | Guam | 66 | 18410 | 245 | 0 | 13.4443 | 144.7937 | 2021-11-04 04:22:20 | Guam, US | ||
2021-10-31 | US | Guam | 66 | 18208 | 238 | 0 | 13.4443 | 144.7937 | 2021-11-01 04:22:01 | Guam, US | ||
2022-11-15 | US | Guam | 66 | 59039 | 406 | 0 | 13.4443 | 144.7937 | 2022-11-16 04:21:09 | Guam, US | ||
2021-07-15 | US | Guam | 66 | 8473 | 142 | 0 | 13.4443 | 144.7937 | 2021-07-16 04:21:22 | Guam, US | ||
2022-04-16 | US | Guam | 66 | 47725 | 354 | 0 | 13.4443 | 144.7937 | 2022-04-17 04:20:59 | Guam, US | ||
2022-12-13 | US | Guam | 66 | 59574 | 410 | 0 | 13.4443 | 144.7937 | 2022-12-14 04:21:04 | Guam, US | ||
2022-11-13 | US | Guam | 66 | 58990 | 406 | 0 | 13.4443 | 144.7937 | 2022-11-14 04:21:09 | Guam, US | ||
2022-02-12 | US | Guam | 66 | 39640 | 306 | 0 | 13.4443 | 144.7937 | 2022-02-13 04:21:00 | Guam, US | ||
2022-10-30 | US | Guam | 66 | 58807 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-31 04:21:36 | Guam, US | ||
2022-12-27 | US | Guam | 66 | 59876 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-28 04:21:04 | Guam, US | ||
2021-08-04 | US | Guam | 66 | 8623 | 143 | 0 | 13.4443 | 144.7937 | 2021-08-05 04:21:51 | Guam, US | ||
2022-03-18 | US | Guam | 66 | 46723 | 341 | 0 | 13.4443 | 144.7937 | 2022-03-19 04:20:47 | Guam, US | ||
2020-03-21 | US | Guam | 15 | 0 | 0 | 13.4443 | 144.7937 | 2020-03-21T17:43:03 | ||||
2022-12-14 | US | Guam | 66 | 59574 | 410 | 0 | 13.4443 | 144.7937 | 2022-12-15 04:20:58 | Guam, US | ||
2021-03-11 | US | Guam | 66 | 7758 | 133 | 0 | 13.4443 | 144.7937 | 2021-03-12 05:26:50 | Guam, US | ||
2022-03-11 | US | Guam | 66 | 46299 | 337 | 0 | 13.4443 | 144.7937 | 2022-03-12 04:20:50 | Guam, US | ||
2022-05-07 | US | Guam | 66 | 48323 | 355 | 0 | 13.4443 | 144.7937 | 2022-05-08 04:20:49 | Guam, US | ||
2022-09-13 | US | Guam | 66 | 58308 | 394 | 0 | 13.4443 | 144.7937 | 2022-09-14 04:20:44 | Guam, US | ||
2021-04-30 | US | Guam | 66 | 7964 | 136 | 0 | 13.4443 | 144.7937 | 2021-05-01 04:20:47 | Guam, US | ||
2022-09-23 | US | Guam | 66 | 58489 | 401 | 0 | 13.4443 | 144.7937 | 2022-09-24 04:21:40 | Guam, US | ||
2021-04-04 | US | Guam | 66 | 7816 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-05 04:20:35 | Guam, US | ||
2022-10-07 | US | Guam | 66 | 58631 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-08 04:22:56 | Guam, US | ||
2021-06-29 | US | Guam | 66 | 8348 | 140 | 0 | 13.4443 | 144.7937 | 2021-06-30 04:21:41 | Guam, US | ||
2021-12-07 | US | Guam | 66 | 19287 | 267 | 0 | 13.4443 | 144.7937 | 2021-12-08 04:22:46 | Guam, US | ||
2021-07-28 | US | Guam | 66 | 8522 | 143 | 0 | 13.4443 | 144.7937 | 2021-07-29 04:21:33 | Guam, US | ||
2022-09-18 | US | Guam | 66 | 58370 | 394 | 0 | 13.4443 | 144.7937 | 2022-09-19 04:21:49 | Guam, US | ||
2021-10-10 | US | Guam | 66 | 16058 | 212 | 0 | 13.4443 | 144.7937 | 2021-10-11 04:21:31 | Guam, US | ||
2022-11-03 | US | Guam | 66 | 58850 | 403 | 0 | 13.4443 | 144.7937 | 2022-11-04 04:22:11 | Guam, US | ||
2021-10-20 | US | Guam | 66 | 17276 | 226 | 0 | 13.4443 | 144.7937 | 2021-10-21 04:21:18 | Guam, US | ||
2021-11-17 | US | Guam | 66 | 19015 | 260 | 0 | 13.4443 | 144.7937 | 2021-11-18 04:21:33 | Guam, US | ||
2022-12-21 | US | Guam | 66 | 59758 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-22 04:20:56 | Guam, US | ||
2022-02-02 | US | Guam | 66 | 33788 | 296 | 0 | 13.4443 | 144.7937 | 2022-02-03 04:21:21 | Guam, US | ||
2022-05-02 | US | Guam | 66 | 48142 | 354 | 0 | 13.4443 | 144.7937 | 2022-05-03 04:21:00 | Guam, US | ||
2021-10-07 | US | Guam | 66 | 15927 | 210 | 0 | 13.4443 | 144.7937 | 2021-10-08 04:21:25 | Guam, US | ||
2022-06-26 | US | Guam | 66 | 51234 | 371 | 0 | 13.4443 | 144.7937 | 2022-06-27 04:21:00 | Guam, US | ||
2022-11-08 | US | Guam | 66 | 58939 | 404 | 0 | 13.4443 | 144.7937 | 2022-11-09 04:21:22 | Guam, US | ||
2021-07-19 | US | Guam | 66 | 8478 | 143 | 0 | 13.4443 | 144.7937 | 2021-07-20 04:21:48 | Guam, US | ||
2022-11-25 | US | Guam | 66 | 59189 | 407 | 0 | 13.4443 | 144.7937 | 2022-11-26 04:21:11 | Guam, US | ||
2021-10-14 | US | Guam | 66 | 16690 | 222 | 0 | 13.4443 | 144.7937 | 2021-10-15 04:21:26 | Guam, US | ||
2021-11-06 | US | Guam | 66 | 18624 | 248 | 0 | 13.4443 | 144.7937 | 2021-11-07 04:21:53 | Guam, US | ||
2022-04-02 | US | Guam | 66 | 47337 | 349 | 0 | 13.4443 | 144.7937 | 2022-04-03 04:20:48 | Guam, US | ||
2022-12-17 | US | Guam | 66 | 59677 | 411 | 0 | 13.4443 | 144.7937 | 2022-12-18 04:21:03 | Guam, US | ||
2021-08-14 | US | Guam | 66 | 8911 | 143 | 0 | 13.4443 | 144.7937 | 2021-08-15 04:21:41 | Guam, US | ||
2021-08-19 | US | Guam | 66 | 9200 | 144 | 0 | 13.4443 | 144.7937 | 2021-08-20 04:21:33 | Guam, US | ||
2022-10-15 | US | Guam | 66 | 58695 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-16 04:22:39 | Guam, US | ||
2021-06-09 | US | Guam | 66 | 8224 | 139 | 0 | 13.4443 | 144.7937 | 2021-06-10 04:23:17 | Guam, US | ||
2021-10-27 | US | Guam | 66 | 17944 | 232 | 0 | 13.4443 | 144.7937 | 2021-10-28 04:22:08 | Guam, US | ||
2022-10-26 | US | Guam | 66 | 58751 | 401 | 0 | 13.4443 | 144.7937 | 2022-10-27 04:22:01 | Guam, US | ||
2022-12-15 | US | Guam | 66 | 59574 | 410 | 0 | 13.4443 | 144.7937 | 2022-12-16 04:21:01 | Guam, US | ||
2021-12-08 | US | Guam | 66 | 19287 | 267 | 0 | 13.4443 | 144.7937 | 2021-12-09 04:22:49 | Guam, US | ||
2022-01-16 | US | Guam | 66 | 23318 | 274 | 0 | 13.4443 | 144.7937 | 2022-01-17 04:21:08 | Guam, US | ||
2022-06-16 | US | Guam | 66 | 50485 | 370 | 0 | 13.4443 | 144.7937 | 2022-06-17 04:20:56 | Guam, US | ||
2021-06-22 | US | Guam | 66 | 8304 | 139 | 0 | 13.4443 | 144.7937 | 2021-06-23 04:21:46 | Guam, US | ||
2021-10-29 | US | Guam | 66 | 18151 | 238 | 0 | 13.4443 | 144.7937 | 2021-10-30 04:22:03 | Guam, US | ||
2022-02-25 | US | Guam | 66 | 44111 | 322 | 0 | 13.4443 | 144.7937 | 2022-02-26 04:21:12 | Guam, US | ||
2021-07-13 | US | Guam | 66 | 8467 | 142 | 0 | 13.4443 | 144.7937 | 2021-07-14 04:21:35 | Guam, US | ||
2021-08-08 | US | Guam | 66 | 8673 | 143 | 0 | 13.4443 | 144.7937 | 2021-08-09 04:21:24 | Guam, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;