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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Guatemala · 921 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392162 | 392162 | 2020-11-27 | Guatemala | 121132 | 4141 | 109619 | 7372 | 15.7835 | -90.2308 | 2020-11-28 05:25:50 | Guatemala | |||
396176 | 396176 | 2022-10-07 | Guatemala | 1128715 | 19824 | 0 | 15.7835 | -90.2308 | 2022-10-08 04:22:56 | Guatemala | ||||
400191 | 400191 | 2021-06-29 | Guatemala | 292674 | 9147 | 264426 | 19101 | 15.7835 | -90.2308 | 2021-06-30 04:21:41 | Guatemala | |||
404205 | 404205 | 2021-12-07 | Guatemala | 620435 | 15999 | 0 | 15.7835 | -90.2308 | 2021-12-08 04:22:46 | Guatemala | ||||
408221 | 408221 | 2021-07-28 | Guatemala | 358798 | 10224 | 314439 | 34135 | 15.7835 | -90.2308 | 2021-07-29 04:21:33 | Guatemala | |||
415690 | 415690 | 2020-07-05 | Guatemala | 23248 | 947 | 3382 | 18919 | 15.7835 | -90.2308 | 2020-07-06 04:33:57 | Guatemala | |||
418855 | 418855 | 2020-04-18 | Guatemala | 235 | 7 | 21 | 207 | 15.7835 | -90.2308 | 2020-04-18 22:32:28 | Guatemala | |||
419247 | 419247 | 2022-09-18 | Guatemala | 1114951 | 19714 | 0 | 15.7835 | -90.2308 | 2022-09-19 04:21:49 | Guatemala | ||||
423262 | 423262 | 2021-10-10 | Guatemala | 579489 | 14027 | 0 | 15.7835 | -90.2308 | 2021-10-11 04:21:31 | Guatemala | ||||
427263 | 427263 | 2020-09-07 | Guatemala | 77828 | 2862 | 66584 | 8382 | 15.7835 | -90.2308 | 2020-09-08 04:28:25 | Guatemala | |||
431269 | 431269 | 2022-11-03 | Guatemala | 1141290 | 19897 | 0 | 15.7835 | -90.2308 | 2022-11-04 04:22:11 | Guatemala | ||||
435283 | 435283 | 2021-01-21 | Guatemala | 152395 | 5389 | 136980 | 10026 | 15.7835 | -90.2308 | 2021-01-22 05:22:10 | Guatemala | |||
442879 | 442879 | 2020-07-26 | Guatemala | 45053 | 1734 | 31612 | 11707 | 15.7835 | -90.2308 | 2020-07-27 04:35:02 | Guatemala | |||
443266 | 443266 | 2021-10-20 | Guatemala | 591460 | 14515 | 0 | 15.7835 | -90.2308 | 2021-10-21 04:21:18 | Guatemala | ||||
447282 | 447282 | 2021-11-17 | Guatemala | 611374 | 15775 | 0 | 15.7835 | -90.2308 | 2021-11-18 04:21:33 | Guatemala | ||||
451299 | 451299 | 2022-12-21 | Guatemala | 1190610 | 19987 | 0 | 15.7835 | -90.2308 | 2022-12-22 04:20:56 | Guatemala | ||||
458906 | 458906 | 2020-08-07 | Guatemala | 55270 | 2168 | 43135 | 9967 | 15.7835 | -90.2308 | 2020-08-08 04:34:53 | Guatemala | |||
459291 | 459291 | 2022-02-02 | Guatemala | 698385 | 16421 | 0 | 15.7835 | -90.2308 | 2022-02-03 04:21:21 | Guatemala | ||||
463308 | 463308 | 2022-05-02 | Guatemala | 846632 | 17613 | 0 | 15.7835 | -90.2308 | 2022-05-03 04:21:00 | Guatemala | ||||
467323 | 467323 | 2021-10-07 | Guatemala | 574713 | 13902 | 0 | 15.7835 | -90.2308 | 2021-10-08 04:21:25 | Guatemala | ||||
471339 | 471339 | 2021-02-19 | Guatemala | 170275 | 6220 | 157198 | 6857 | 15.7835 | -90.2308 | 2021-02-20 05:22:51 | Guatemala | |||
475354 | 475354 | 2022-06-26 | Guatemala | 896850 | 18497 | 0 | 15.7835 | -90.2308 | 2022-06-27 04:21:00 | Guatemala | ||||
479502 | 479502 | 2022-11-08 | Guatemala | 1143218 | 19910 | 0 | 15.7835 | -90.2308 | 2022-11-09 04:21:22 | Guatemala | ||||
483517 | 483517 | 2021-07-19 | Guatemala | 334375 | 9927 | 293208 | 31240 | 15.7835 | -90.2308 | 2021-07-20 04:21:48 | Guatemala | |||
487532 | 487532 | 2022-11-25 | Guatemala | 1152798 | 19944 | 0 | 15.7835 | -90.2308 | 2022-11-26 04:21:11 | Guatemala | ||||
491547 | 491547 | 2021-10-14 | Guatemala | 584613 | 14204 | 0 | 15.7835 | -90.2308 | 2021-10-15 04:21:26 | Guatemala | ||||
495563 | 495563 | 2021-11-06 | Guatemala | 605415 | 15389 | 0 | 15.7835 | -90.2308 | 2021-11-07 04:21:53 | Guatemala | ||||
499580 | 499580 | 2022-04-02 | Guatemala | 830745 | 17325 | 0 | 15.7835 | -90.2308 | 2022-04-03 04:20:48 | Guatemala | ||||
503596 | 503596 | 2022-12-17 | Guatemala | 1184147 | 19982 | 0 | 15.7835 | -90.2308 | 2022-12-18 04:21:03 | Guatemala | ||||
507611 | 507611 | 2021-08-14 | Guatemala | 411731 | 11085 | 0 | 15.7835 | -90.2308 | 2021-08-15 04:21:41 | Guatemala | ||||
511625 | 511625 | 2021-08-19 | Guatemala | 428096 | 11339 | 0 | 15.7835 | -90.2308 | 2021-08-20 04:21:33 | Guatemala | ||||
515640 | 515640 | 2022-10-15 | Guatemala | 1133367 | 19851 | 0 | 15.7835 | -90.2308 | 2022-10-16 04:22:39 | Guatemala | ||||
522393 | 522393 | 2020-04-21 | Guatemala | 294 | 7 | 24 | 263 | 15.7835 | -90.2308 | 2020-04-21 23:30:30 | Guatemala | |||
522784 | 522784 | 2021-06-09 | Guatemala | 265662 | 8361 | 242033 | 15268 | 15.7835 | -90.2308 | 2021-06-10 04:23:17 | Guatemala | |||
530252 | 530252 | 2020-07-04 | Guatemala | 22501 | 920 | 3330 | 18251 | 15.7835 | -90.2308 | 2020-07-05 04:33:46 | Guatemala | |||
530633 | 530633 | 2021-02-22 | Guatemala | 171289 | 6306 | 158501 | 6482 | 15.7835 | -90.2308 | 2021-02-23 05:23:41 | Guatemala | |||
534647 | 534647 | 2021-10-27 | Guatemala | 597768 | 14862 | 0 | 15.7835 | -90.2308 | 2021-10-28 04:22:08 | Guatemala | ||||
538664 | 538664 | 2022-10-26 | Guatemala | 1138242 | 19878 | 0 | 15.7835 | -90.2308 | 2022-10-27 04:22:01 | Guatemala | ||||
542680 | 542680 | 2022-12-15 | Guatemala | 1179809 | 19973 | 0 | 15.7835 | -90.2308 | 2022-12-16 04:21:01 | Guatemala | ||||
546680 | 546680 | 2020-09-12 | Guatemala | 81658 | 2949 | 70403 | 8306 | 15.7835 | -90.2308 | 2020-09-13 04:30:52 | Guatemala | |||
550685 | 550685 | 2021-12-08 | Guatemala | 620853 | 16008 | 0 | 15.7835 | -90.2308 | 2021-12-09 04:22:49 | Guatemala | ||||
554701 | 554701 | 2022-01-16 | Guatemala | 653171 | 16176 | 0 | 15.7835 | -90.2308 | 2022-01-17 04:21:08 | Guatemala | ||||
558718 | 558718 | 2022-06-16 | Guatemala | 876499 | 18351 | 0 | 15.7835 | -90.2308 | 2022-06-17 04:20:56 | Guatemala | ||||
562894 | 562894 | 2021-06-22 | Guatemala | 282713 | 8785 | 255996 | 17932 | 15.7835 | -90.2308 | 2021-06-23 04:21:46 | Guatemala | |||
567015 | 567015 | 2021-10-29 | Guatemala | 600419 | 14993 | 0 | 15.7835 | -90.2308 | 2021-10-30 04:22:03 | Guatemala | ||||
574356 | 574356 | 2020-06-06 | Guatemala | 6792 | 230 | 1133 | 5429 | 15.7835 | -90.2308 | 2020-06-07 03:53:30 | Guatemala | |||
574744 | 574744 | 2022-02-25 | Guatemala | 773575 | 16939 | 0 | 15.7835 | -90.2308 | 2022-02-26 04:21:12 | Guatemala | ||||
578759 | 578759 | 2021-07-13 | Guatemala | 322120 | 9756 | 282911 | 29453 | 15.7835 | -90.2308 | 2021-07-14 04:21:35 | Guatemala | |||
582758 | 582758 | 2020-08-13 | Guatemala | 60284 | 2296 | 48305 | 9683 | 15.7835 | -90.2308 | 2020-08-14 04:51:19 | Guatemala | |||
589165 | 589165 | 2020-04-05 | Guatemala | 61 | 2 | 15 | 44 | 15.7835 | -90.2308 | 2020-04-05 23:06:26 | Guatemala | |||
589555 | 589555 | 2021-08-08 | Guatemala | 390514 | 10771 | 0 | 15.7835 | -90.2308 | 2021-08-09 04:21:24 | Guatemala | ||||
593570 | 593570 | 2022-07-01 | Guatemala | 915321 | 18572 | 0 | 15.7835 | -90.2308 | 2022-07-02 04:21:16 | Guatemala | ||||
597585 | 597585 | 2021-10-19 | Guatemala | 589986 | 14436 | 0 | 15.7835 | -90.2308 | 2021-10-20 04:21:00 | Guatemala | ||||
601601 | 601601 | 2021-09-23 | Guatemala | 542024 | 13241 | 0 | 15.7835 | -90.2308 | 2021-09-24 04:21:44 | Guatemala | ||||
605616 | 605616 | 2021-04-09 | Guatemala | 201295 | 6977 | 183917 | 10401 | 15.7835 | -90.2308 | 2021-04-10 04:20:59 | Guatemala | |||
609615 | 609615 | 2020-08-29 | Guatemala | 73679 | 2728 | 61163 | 9788 | 15.7835 | -90.2308 | 2020-08-30 04:28:22 | Guatemala | |||
613615 | 613615 | 2021-02-08 | Guatemala | 163247 | 5922 | 149745 | 7580 | 15.7835 | -90.2308 | 2021-02-09 05:23:30 | Guatemala | |||
617774 | 617774 | 2022-11-05 | Guatemala | 1142470 | 19905 | 0 | 15.7835 | -90.2308 | 2022-11-06 04:21:24 | Guatemala | ||||
621790 | 621790 | 2022-05-22 | Guatemala | 858015 | 18024 | 0 | 15.7835 | -90.2308 | 2022-05-26 04:20:50 | Guatemala | ||||
625805 | 625805 | 2021-07-10 | Guatemala | 317311 | 9688 | 277992 | 29631 | 15.7835 | -90.2308 | 2021-07-11 04:21:43 | Guatemala | |||
629820 | 629820 | 2022-07-12 | Guatemala | 955370 | 18748 | 0 | 15.7835 | -90.2308 | 2022-07-13 04:20:58 | Guatemala | ||||
633835 | 633835 | 2021-10-13 | Guatemala | 583201 | 14177 | 0 | 15.7835 | -90.2308 | 2021-10-14 04:21:29 | Guatemala | ||||
637851 | 637851 | 2021-03-31 | Guatemala | 193834 | 6840 | 177235 | 9759 | 15.7835 | -90.2308 | 2021-04-01 04:27:05 | Guatemala | |||
641865 | 641865 | 2021-09-07 | Guatemala | 492570 | 12388 | 0 | 15.7835 | -90.2308 | 2021-09-08 04:21:31 | Guatemala | ||||
645879 | 645879 | 2021-05-05 | Guatemala | 231289 | 7642 | 209096 | 14551 | 15.7835 | -90.2308 | 2021-05-06 04:20:38 | Guatemala | |||
649893 | 649893 | 2021-08-09 | Guatemala | 391118 | 10808 | 0 | 15.7835 | -90.2308 | 2021-08-10 04:21:27 | Guatemala | ||||
653907 | 653907 | 2021-10-22 | Guatemala | 593459 | 14615 | 0 | 15.7835 | -90.2308 | 2021-10-23 04:21:32 | Guatemala | ||||
658226 | 658226 | 2022-05-13 | Guatemala | 851877 | 17792 | 0 | 15.7835 | -90.2308 | 2022-05-14 04:20:48 | Guatemala | ||||
662226 | 662226 | 2020-08-11 | Guatemala | 57966 | 2233 | 46442 | 9291 | 15.7835 | -90.2308 | 2020-08-12 04:27:29 | Guatemala | |||
666205 | 666205 | 2020-09-16 | Guatemala | 82924 | 3009 | 72562 | 7353 | 15.7835 | -90.2308 | 2020-09-17 04:22:00 | Guatemala | |||
670211 | 670211 | 2022-07-21 | Guatemala | 1004311 | 18881 | 0 | 15.7835 | -90.2308 | 2022-07-22 04:21:15 | Guatemala | ||||
674227 | 674227 | 2022-07-30 | Guatemala | 1041274 | 19027 | 0 | 15.7835 | -90.2308 | 2022-07-31 04:21:02 | Guatemala | ||||
678239 | 678239 | 2020-11-23 | Guatemala | 118722 | 4092 | 107819 | 6811 | 15.7835 | -90.2308 | 2020-11-24 05:27:31 | Guatemala | |||
682252 | 682252 | 2021-10-24 | Guatemala | 595008 | 14700 | 0 | 15.7835 | -90.2308 | 2021-10-25 04:22:31 | Guatemala | ||||
686268 | 686268 | 2021-11-13 | Guatemala | 609729 | 15698 | 0 | 15.7835 | -90.2308 | 2021-11-14 04:21:31 | Guatemala | ||||
690285 | 690285 | 2022-12-23 | Guatemala | 1195644 | 19990 | 0 | 15.7835 | -90.2308 | 2022-12-24 04:21:02 | Guatemala | ||||
694301 | 694301 | 2022-03-17 | Guatemala | 812125 | 17191 | 0 | 15.7835 | -90.2308 | 2022-03-18 04:20:55 | Guatemala | ||||
698316 | 698316 | 2021-11-04 | Guatemala | 603641 | 15281 | 0 | 15.7835 | -90.2308 | 2021-11-05 04:21:54 | Guatemala | ||||
702332 | 702332 | 2021-03-16 | Guatemala | 183985 | 6599 | 169149 | 8237 | 15.7835 | -90.2308 | 2021-03-17 05:25:07 | Guatemala | |||
706346 | 706346 | 2021-09-29 | Guatemala | 557244 | 13525 | 0 | 15.7835 | -90.2308 | 2021-09-30 04:21:20 | Guatemala | ||||
710362 | 710362 | 2022-11-01 | Guatemala | 1140602 | 19892 | 0 | 15.7835 | -90.2308 | 2022-11-02 04:22:09 | Guatemala | ||||
714377 | 714377 | 2021-11-12 | Guatemala | 609136 | 15675 | 0 | 15.7835 | -90.2308 | 2021-11-13 04:21:38 | Guatemala | ||||
718394 | 718394 | 2022-12-04 | Guatemala | 1160002 | 19956 | 0 | 15.7835 | -90.2308 | 2022-12-05 04:20:58 | Guatemala | ||||
722409 | 722409 | 2021-11-20 | Guatemala | 613713 | 15837 | 0 | 15.7835 | -90.2308 | 2021-11-21 04:22:13 | Guatemala | ||||
726425 | 726425 | 2021-05-22 | Guatemala | 247106 | 7996 | 226819 | 12291 | 15.7835 | -90.2308 | 2021-05-23 04:20:51 | Guatemala | |||
730439 | 730439 | 2021-12-27 | Guatemala | 625257 | 16098 | 0 | 15.7835 | -90.2308 | 2021-12-28 04:21:47 | Guatemala | ||||
737850 | 737850 | 2020-06-12 | Guatemala | 8982 | 351 | 1702 | 6929 | 15.7835 | -90.2308 | 2020-06-13 03:33:14 | Guatemala | |||
738228 | 738228 | 2020-12-02 | Guatemala | 123460 | 4191 | 112181 | 7088 | 15.7835 | -90.2308 | 2020-12-03 05:28:22 | Guatemala | |||
742241 | 742241 | 2021-02-20 | Guatemala | 170931 | 6249 | 157794 | 6888 | 15.7835 | -90.2308 | 2021-02-21 05:24:33 | Guatemala | |||
746256 | 746256 | 2022-04-23 | Guatemala | 842369 | 17514 | 0 | 15.7835 | -90.2308 | 2022-04-24 04:20:56 | Guatemala | ||||
753860 | 753860 | 2020-08-01 | Guatemala | 50979 | 1959 | 37873 | 11147 | 15.7835 | -90.2308 | 2020-08-02 04:34:47 | Guatemala | |||
754229 | 754229 | 2020-10-28 | Guatemala | 106320 | 3682 | 95752 | 6886 | 15.7835 | -90.2308 | 2020-10-29 04:24:49 | Guatemala | |||
758239 | 758239 | 2021-11-26 | Guatemala | 617037 | 15898 | 0 | 15.7835 | -90.2308 | 2021-11-27 04:22:45 | Guatemala | ||||
762241 | 762241 | 2020-10-18 | Guatemala | 101360 | 3530 | 90610 | 7220 | 15.7835 | -90.2308 | 2020-10-19 04:24:16 | Guatemala | |||
766247 | 766247 | 2020-12-29 | Guatemala | 136287 | 4781 | 125161 | 6345 | 15.7835 | -90.2308 | 2020-12-30 05:22:34 | Guatemala | |||
770260 | 770260 | 2021-10-23 | Guatemala | 594665 | 14655 | 0 | 15.7835 | -90.2308 | 2021-10-24 04:21:22 | Guatemala | ||||
774275 | 774275 | 2021-01-12 | Guatemala | 144982 | 5080 | 131974 | 7928 | 15.7835 | -90.2308 | 2021-01-13 05:22:15 | Guatemala | |||
778288 | 778288 | 2021-07-08 | Guatemala | 311342 | 9609 | 274697 | 27036 | 15.7835 | -90.2308 | 2021-07-09 04:21:21 | Guatemala | |||
782302 | 782302 | 2021-12-13 | Guatemala | 622237 | 16048 | 0 | 15.7835 | -90.2308 | 2021-12-14 04:22:38 | Guatemala | ||||
786304 | 786304 | 2020-10-15 | Guatemala | 99765 | 3453 | 88931 | 7381 | 15.7835 | -90.2308 | 2020-10-16 04:24:01 | 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]);