johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,021 rows where country_or_region = "Guatemala" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, active, day (date), last_update (date)
country_or_region 1
- Guatemala · 1,021 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1463696 | 1463696 | 2020-03-15 | Guatemala | 1 | 0 | 0 | 15.7835 | -90.2308 | 2020-03-14T01:33:03 | |||||
2111312 | 2111312 | 2020-03-14 | Guatemala | 1 | 0 | 0 | 15.7835 | -90.2308 | 2020-03-14T01:33:03 | |||||
2255337 | 2255337 | 2020-03-16 | Guatemala | 2 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-16T14:38:45 | |||||
1177088 | 1177088 | 2020-03-18 | Guatemala | 6 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-17T12:13:16 | |||||
3891516 | 3891516 | 2020-03-17 | Guatemala | 6 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-17T12:13:16 | |||||
1527082 | 1527082 | 2020-03-19 | Guatemala | 9 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-19T17:13:24 | |||||
3734129 | 3734129 | 2020-03-20 | Guatemala | 12 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-20T16:13:19 | |||||
339829 | 339829 | 2020-03-21 | Guatemala | 17 | 1 | 0 | 15.7835 | -90.2308 | 2020-03-21T21:13:14 | |||||
2147174 | 2147174 | 2020-03-23 | Guatemala | 20 | 1 | 0 | 19 | 15.7835 | -90.2308 | 2020-03-23 23:19:21 | Guatemala | |||
1479118 | 1479118 | 2020-03-24 | Guatemala | 21 | 1 | 0 | 20 | 15.7835 | -90.2308 | 2020-03-24 23:37:15 | Guatemala | |||
1132611 | 1132611 | 2020-03-25 | Guatemala | 24 | 1 | 4 | 19 | 15.7835 | -90.2308 | 2020-03-25 23:33:04 | Guatemala | |||
919210 | 919210 | 2020-03-26 | Guatemala | 25 | 1 | 4 | 20 | 15.7835 | -90.2308 | 2020-03-26 23:48:18 | Guatemala | |||
809118 | 809118 | 2020-03-27 | Guatemala | 28 | 1 | 4 | 23 | 15.7835 | -90.2308 | 2020-03-27 23:23:03 | Guatemala | |||
3815946 | 3815946 | 2020-03-31 | Guatemala | 38 | 1 | 12 | 25 | 15.7835 | -90.2308 | 2020-03-31 23:43:43 | Guatemala | |||
3364853 | 3364853 | 2020-04-01 | Guatemala | 39 | 1 | 12 | 26 | 15.7835 | -90.2308 | 2020-04-01 21:58:34 | Guatemala | |||
3740619 | 3740619 | 2020-04-03 | Guatemala | 50 | 1 | 12 | 37 | 15.7835 | -90.2308 | 2020-04-03 22:46:20 | Guatemala | |||
589165 | 589165 | 2020-04-05 | Guatemala | 61 | 2 | 15 | 44 | 15.7835 | -90.2308 | 2020-04-05 23:06:26 | Guatemala | |||
3021795 | 3021795 | 2020-04-07 | Guatemala | 77 | 3 | 17 | 57 | 15.7835 | -90.2308 | 2020-04-07 23:04:29 | Guatemala | |||
3562120 | 3562120 | 2020-04-08 | Guatemala | 87 | 3 | 17 | 67 | 15.7835 | -90.2308 | 2020-04-08 22:51:39 | Guatemala | |||
3950013 | 3950013 | 2020-04-09 | Guatemala | 95 | 3 | 17 | 75 | 15.7835 | -90.2308 | 2020-04-09 23:02:19 | Guatemala | |||
1250276 | 1250276 | 2020-04-10 | Guatemala | 126 | 3 | 17 | 106 | 15.7835 | -90.2308 | 2020-04-10 22:53:48 | Guatemala | |||
2567091 | 2567091 | 2020-04-11 | Guatemala | 137 | 3 | 19 | 115 | 15.7835 | -90.2308 | 2020-04-11 22:45:13 | Guatemala | |||
2578254 | 2578254 | 2020-04-12 | Guatemala | 155 | 5 | 19 | 131 | 15.7835 | -90.2308 | 2020-04-12 23:17:00 | Guatemala | |||
43228 | 43228 | 2020-04-13 | Guatemala | 156 | 5 | 19 | 132 | 15.7835 | -90.2308 | 2020-04-13 23:07:34 | Guatemala | |||
3338131 | 3338131 | 2020-04-14 | Guatemala | 167 | 5 | 19 | 143 | 15.7835 | -90.2308 | 2020-04-14 23:33:12 | Guatemala | |||
860215 | 860215 | 2020-04-15 | Guatemala | 180 | 5 | 19 | 156 | 15.7835 | -90.2308 | 2020-04-15 22:56:32 | Guatemala | |||
934321 | 934321 | 2020-04-16 | Guatemala | 196 | 5 | 19 | 172 | 15.7835 | -90.2308 | 2020-04-16 23:30:31 | Guatemala | |||
50327 | 50327 | 2020-04-17 | Guatemala | 214 | 7 | 21 | 186 | 15.7835 | -90.2308 | 2020-04-17 23:30:32 | Guatemala | |||
418855 | 418855 | 2020-04-18 | Guatemala | 235 | 7 | 21 | 207 | 15.7835 | -90.2308 | 2020-04-18 22:32:28 | Guatemala | |||
1385167 | 1385167 | 2020-04-19 | Guatemala | 257 | 7 | 21 | 229 | 15.7835 | -90.2308 | 2020-04-19 23:40:41 | Guatemala | |||
2473475 | 2473475 | 2020-04-20 | Guatemala | 289 | 7 | 21 | 261 | 15.7835 | -90.2308 | 2020-04-20 23:36:27 | Guatemala | |||
522393 | 522393 | 2020-04-21 | Guatemala | 294 | 7 | 24 | 263 | 15.7835 | -90.2308 | 2020-04-21 23:30:30 | Guatemala | |||
1199327 | 1199327 | 2020-04-22 | Guatemala | 316 | 8 | 24 | 284 | 15.7835 | -90.2308 | 2020-04-22 23:30:32 | Guatemala | |||
2524877 | 2524877 | 2020-04-23 | Guatemala | 384 | 11 | 30 | 343 | 15.7835 | -90.2308 | 2020-04-24 03:30:31 | Guatemala | |||
1459288 | 1459288 | 2020-04-24 | Guatemala | 430 | 11 | 30 | 389 | 15.7835 | -90.2308 | 2020-04-25 06:30:33 | Guatemala | |||
3502887 | 3502887 | 2020-04-25 | Guatemala | 473 | 13 | 45 | 415 | 15.7835 | -90.2308 | 2020-04-26 02:30:31 | Guatemala | |||
3592538 | 3592538 | 2020-04-26 | Guatemala | 500 | 15 | 49 | 436 | 15.7835 | -90.2308 | 2020-04-27 02:30:33 | Guatemala | |||
3589360 | 3589360 | 2020-04-27 | Guatemala | 530 | 15 | 49 | 466 | 15.7835 | -90.2308 | 2020-04-28 02:30:32 | Guatemala | |||
271705 | 271705 | 2020-04-28 | Guatemala | 530 | 15 | 49 | 466 | 15.7835 | -90.2308 | 2020-04-29 02:32:29 | Guatemala | |||
137491 | 137491 | 2020-04-29 | Guatemala | 557 | 16 | 62 | 479 | 15.7835 | -90.2308 | 2020-04-30 02:32:27 | Guatemala | |||
228745 | 228745 | 2020-04-30 | Guatemala | 599 | 16 | 66 | 517 | 15.7835 | -90.2308 | 2020-05-01 02:32:28 | Guatemala | |||
1184264 | 1184264 | 2020-05-01 | Guatemala | 644 | 16 | 72 | 556 | 15.7835 | -90.2308 | 2020-05-02 02:32:27 | Guatemala | |||
2043370 | 2043370 | 2020-05-02 | Guatemala | 688 | 17 | 72 | 599 | 15.7835 | -90.2308 | 2020-05-03 02:32:28 | Guatemala | |||
2278694 | 2278694 | 2020-05-03 | Guatemala | 703 | 17 | 72 | 614 | 15.7835 | -90.2308 | 2020-05-04 02:32:28 | Guatemala | |||
3084835 | 3084835 | 2020-05-04 | Guatemala | 730 | 19 | 79 | 632 | 15.7835 | -90.2308 | 2020-05-05 02:32:34 | Guatemala | |||
1931972 | 1931972 | 2020-05-05 | Guatemala | 763 | 19 | 79 | 665 | 15.7835 | -90.2308 | 2020-05-06 02:32:31 | Guatemala | |||
2110932 | 2110932 | 2020-05-06 | Guatemala | 798 | 21 | 86 | 691 | 15.7835 | -90.2308 | 2020-05-07 02:32:28 | Guatemala | |||
3295711 | 3295711 | 2020-05-07 | Guatemala | 832 | 23 | 90 | 719 | 15.7835 | -90.2308 | 2020-05-08 02:32:32 | Guatemala | |||
114268 | 114268 | 2020-05-08 | Guatemala | 900 | 24 | 101 | 775 | 15.7835 | -90.2308 | 2020-05-09 02:32:35 | Guatemala | |||
2899219 | 2899219 | 2020-05-09 | Guatemala | 967 | 24 | 104 | 839 | 15.7835 | -90.2308 | 2020-05-10 02:32:30 | Guatemala | |||
3459678 | 3459678 | 2020-05-10 | Guatemala | 1052 | 26 | 110 | 916 | 15.7835 | -90.2308 | 2020-05-11 02:32:30 | Guatemala | |||
3331063 | 3331063 | 2020-05-11 | Guatemala | 1114 | 26 | 111 | 977 | 15.7835 | -90.2308 | 2020-05-12 03:32:27 | Guatemala | |||
2581529 | 2581529 | 2020-05-12 | Guatemala | 1199 | 27 | 120 | 1052 | 15.7835 | -90.2308 | 2020-05-13 03:32:26 | Guatemala | |||
3847322 | 3847322 | 2020-05-13 | Guatemala | 1342 | 29 | 121 | 1192 | 15.7835 | -90.2308 | 2020-05-14 03:32:28 | Guatemala | |||
1404561 | 1404561 | 2020-05-14 | Guatemala | 1518 | 29 | 129 | 1360 | 15.7835 | -90.2308 | 2020-05-15 02:33:02 | Guatemala | |||
3276387 | 3276387 | 2020-05-15 | Guatemala | 1643 | 30 | 135 | 1478 | 15.7835 | -90.2308 | 2020-05-16 02:32:19 | Guatemala | |||
1829671 | 1829671 | 2020-05-16 | Guatemala | 1763 | 33 | 138 | 1592 | 15.7835 | -90.2308 | 2020-05-17 02:32:32 | Guatemala | |||
3416437 | 3416437 | 2020-05-17 | Guatemala | 1763 | 33 | 138 | 1592 | 15.7835 | -90.2308 | 2020-05-18 02:32:21 | Guatemala | |||
3261043 | 3261043 | 2020-05-18 | Guatemala | 1912 | 35 | 138 | 1739 | 15.7835 | -90.2308 | 2020-05-19 02:32:18 | Guatemala | |||
2390305 | 2390305 | 2020-05-19 | Guatemala | 2133 | 43 | 155 | 1935 | 15.7835 | -90.2308 | 2020-05-20 02:32:19 | Guatemala | |||
1432086 | 1432086 | 2020-05-20 | Guatemala | 2265 | 45 | 159 | 2061 | 15.7835 | -90.2308 | 2020-05-21 02:32:48 | Guatemala | |||
268503 | 268503 | 2020-05-21 | Guatemala | 2512 | 48 | 222 | 2242 | 15.7835 | -90.2308 | 2020-05-22 02:36:51 | Guatemala | |||
1864997 | 1864997 | 2020-05-22 | Guatemala | 2743 | 51 | 222 | 2470 | 15.7835 | -90.2308 | 2020-05-23 02:32:42 | Guatemala | |||
997974 | 997974 | 2020-05-23 | Guatemala | 3054 | 55 | 244 | 2755 | 15.7835 | -90.2308 | 2020-05-24 02:32:43 | Guatemala | |||
875783 | 875783 | 2020-05-24 | Guatemala | 3424 | 58 | 258 | 3108 | 15.7835 | -90.2308 | 2020-05-25 02:32:44 | Guatemala | |||
1105103 | 1105103 | 2020-05-25 | Guatemala | 3760 | 59 | 274 | 3427 | 15.7835 | -90.2308 | 2020-05-26 02:32:35 | Guatemala | |||
1041373 | 1041373 | 2020-05-26 | Guatemala | 3954 | 63 | 289 | 3602 | 15.7835 | -90.2308 | 2020-05-27 02:32:31 | Guatemala | |||
2548410 | 2548410 | 2020-05-27 | Guatemala | 4145 | 68 | 493 | 3584 | 15.7835 | -90.2308 | 2020-05-28 02:32:31 | Guatemala | |||
2712493 | 2712493 | 2020-05-28 | Guatemala | 4348 | 80 | 565 | 3703 | 15.7835 | -90.2308 | 2020-05-29 02:32:50 | Guatemala | |||
1790614 | 1790614 | 2020-05-29 | Guatemala | 4607 | 90 | 648 | 3869 | 15.7835 | -90.2308 | 2020-05-30 02:32:48 | Guatemala | |||
3639074 | 3639074 | 2020-05-30 | Guatemala | 4739 | 102 | 706 | 3931 | 15.7835 | -90.2308 | 2020-05-31 02:32:45 | Guatemala | |||
1794181 | 1794181 | 2020-05-31 | Guatemala | 5087 | 108 | 735 | 4244 | 15.7835 | -90.2308 | 2020-06-01 02:32:46 | Guatemala | |||
805647 | 805647 | 2020-06-01 | Guatemala | 5336 | 116 | 795 | 4425 | 15.7835 | -90.2308 | 2020-06-02 02:33:08 | Guatemala | |||
2556110 | 2556110 | 2020-06-02 | Guatemala | 5586 | 123 | 824 | 4639 | 15.7835 | -90.2308 | 2020-06-03 02:33:13 | Guatemala | |||
3867068 | 3867068 | 2020-06-03 | Guatemala | 5760 | 143 | 929 | 4688 | 15.7835 | -90.2308 | 2020-06-04 02:33:14 | Guatemala | |||
1281513 | 1281513 | 2020-06-04 | Guatemala | 6154 | 158 | 979 | 5017 | 15.7835 | -90.2308 | 2020-06-05 02:33:06 | Guatemala | |||
1270053 | 1270053 | 2020-06-05 | Guatemala | 6485 | 216 | 1053 | 5216 | 15.7835 | -90.2308 | 2020-06-06 02:33:00 | Guatemala | |||
574356 | 574356 | 2020-06-06 | Guatemala | 6792 | 230 | 1133 | 5429 | 15.7835 | -90.2308 | 2020-06-07 03:53:30 | Guatemala | |||
2800300 | 2800300 | 2020-06-07 | Guatemala | 7055 | 252 | 1261 | 5542 | 15.7835 | -90.2308 | 2020-06-08 03:33:22 | Guatemala | |||
217503 | 217503 | 2020-06-08 | Guatemala | 7502 | 267 | 1323 | 5912 | 15.7835 | -90.2308 | 2020-06-09 03:33:03 | Guatemala | |||
1211076 | 1211076 | 2020-06-09 | Guatemala | 7866 | 289 | 1413 | 6164 | 15.7835 | -90.2308 | 2020-06-10 04:07:00 | Guatemala | |||
2864259 | 2864259 | 2020-06-10 | Guatemala | 8221 | 316 | 1504 | 6401 | 15.7835 | -90.2308 | 2020-06-11 03:33:41 | Guatemala | |||
1273820 | 1273820 | 2020-06-11 | Guatemala | 8561 | 334 | 1567 | 6660 | 15.7835 | -90.2308 | 2020-06-12 05:09:52 | Guatemala | |||
737850 | 737850 | 2020-06-12 | Guatemala | 8982 | 351 | 1702 | 6929 | 15.7835 | -90.2308 | 2020-06-13 03:33:14 | Guatemala | |||
3061530 | 3061530 | 2020-06-13 | Guatemala | 9491 | 367 | 1804 | 7320 | 15.7835 | -90.2308 | 2020-06-14 03:33:15 | Guatemala | |||
1837478 | 1837478 | 2020-06-14 | Guatemala | 9845 | 384 | 1886 | 7575 | 15.7835 | -90.2308 | 2020-06-15 03:33:14 | Guatemala | |||
287527 | 287527 | 2020-06-15 | Guatemala | 10272 | 399 | 1966 | 7907 | 15.7835 | -90.2308 | 2020-06-16 04:33:09 | Guatemala | |||
2386964 | 2386964 | 2020-06-16 | Guatemala | 10706 | 418 | 2096 | 8192 | 15.7835 | -90.2308 | 2020-06-17 04:33:21 | Guatemala | |||
1196201 | 1196201 | 2020-06-17 | Guatemala | 11251 | 432 | 2200 | 8619 | 15.7835 | -90.2308 | 2020-06-18 04:33:18 | Guatemala | |||
3682998 | 3682998 | 2020-06-18 | Guatemala | 11868 | 449 | 2290 | 9129 | 15.7835 | -90.2308 | 2020-06-19 04:33:17 | Guatemala | |||
1691849 | 1691849 | 2020-06-19 | Guatemala | 12509 | 483 | 2419 | 9607 | 15.7835 | -90.2308 | 2020-06-20 04:33:19 | Guatemala | |||
2438271 | 2438271 | 2020-06-20 | Guatemala | 12755 | 514 | 2558 | 9683 | 15.7835 | -90.2308 | 2020-06-21 04:33:19 | Guatemala | |||
3249678 | 3249678 | 2020-06-21 | Guatemala | 13145 | 531 | 2711 | 9903 | 15.7835 | -90.2308 | 2020-06-22 04:33:20 | Guatemala | |||
1510939 | 1510939 | 2020-06-22 | Guatemala | 13769 | 547 | 2818 | 10404 | 15.7835 | -90.2308 | 2020-06-23 04:33:22 | Guatemala | |||
1522745 | 1522745 | 2020-06-23 | Guatemala | 14540 | 582 | 2897 | 11061 | 15.7835 | -90.2308 | 2020-06-24 04:33:28 | Guatemala | |||
2701060 | 2701060 | 2020-06-24 | Guatemala | 14819 | 601 | 2930 | 11288 | 15.7835 | -90.2308 | 2020-06-25 05:26:54 | Guatemala | |||
2625420 | 2625420 | 2020-06-25 | Guatemala | 15619 | 623 | 2949 | 12047 | 15.7835 | -90.2308 | 2020-06-26 04:33:43 | Guatemala | |||
1136433 | 1136433 | 2020-06-26 | Guatemala | 15828 | 672 | 3028 | 12128 | 15.7835 | -90.2308 | 2020-06-27 04:33:35 | Guatemala | |||
2040152 | 2040152 | 2020-06-27 | Guatemala | 16397 | 706 | 3123 | 12568 | 15.7835 | -90.2308 | 2020-06-28 04:34:04 | Guatemala | |||
2306817 | 2306817 | 2020-06-28 | Guatemala | 16930 | 727 | 3152 | 13051 | 15.7835 | -90.2308 | 2020-06-29 04:33:44 | Guatemala |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);