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 recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331833 | 331833 | 2021-08-04 | Guatemala | 377446 | 10524 | 331374 | 35548 | 15.7835 | -90.2308 | 2021-08-05 04:21:51 | Guatemala | |||
3468104 | 3468104 | 2021-08-03 | Guatemala | 373047 | 10483 | 328765 | 33799 | 15.7835 | -90.2308 | 2021-08-04 04:21:25 | Guatemala | |||
3683378 | 3683378 | 2021-08-02 | Guatemala | 370258 | 10448 | 326004 | 33806 | 15.7835 | -90.2308 | 2021-08-03 04:21:39 | Guatemala | |||
3015277 | 3015277 | 2021-08-01 | Guatemala | 369626 | 10413 | 324332 | 34881 | 15.7835 | -90.2308 | 2021-08-02 04:21:36 | Guatemala | |||
3903900 | 3903900 | 2021-07-31 | Guatemala | 368484 | 10339 | 321832 | 36313 | 15.7835 | -90.2308 | 2021-08-01 04:21:50 | Guatemala | |||
3296105 | 3296105 | 2021-07-30 | Guatemala | 365528 | 10289 | 319323 | 35916 | 15.7835 | -90.2308 | 2021-07-31 04:21:35 | Guatemala | |||
3385316 | 3385316 | 2021-07-29 | Guatemala | 362134 | 10248 | 316931 | 34955 | 15.7835 | -90.2308 | 2021-07-30 04:21:34 | Guatemala | |||
408221 | 408221 | 2021-07-28 | Guatemala | 358798 | 10224 | 314439 | 34135 | 15.7835 | -90.2308 | 2021-07-29 04:21:33 | Guatemala | |||
1306082 | 1306082 | 2021-07-27 | Guatemala | 355223 | 10176 | 311828 | 33219 | 15.7835 | -90.2308 | 2021-07-28 04:21:39 | Guatemala | |||
3218225 | 3218225 | 2021-07-26 | Guatemala | 352584 | 10112 | 308908 | 33564 | 15.7835 | -90.2308 | 2021-07-27 04:21:18 | Guatemala | |||
1378434 | 1378434 | 2021-07-25 | Guatemala | 352088 | 10100 | 307142 | 34846 | 15.7835 | -90.2308 | 2021-07-26 04:21:28 | Guatemala | |||
1330174 | 1330174 | 2021-07-24 | Guatemala | 350816 | 10093 | 305003 | 35720 | 15.7835 | -90.2308 | 2021-07-25 04:22:12 | Guatemala | |||
3137478 | 3137478 | 2021-07-23 | Guatemala | 347496 | 10063 | 302441 | 34992 | 15.7835 | -90.2308 | 2021-07-24 00:21:36 | Guatemala | |||
3476238 | 3476238 | 2021-07-22 | Guatemala | 344221 | 10029 | 299752 | 34440 | 15.7835 | -90.2308 | 2021-07-23 04:21:29 | Guatemala | |||
483517 | 483517 | 2021-07-19 | Guatemala | 334375 | 9927 | 293208 | 31240 | 15.7835 | -90.2308 | 2021-07-20 04:21:48 | Guatemala | |||
2371438 | 2371438 | 2021-07-20 | Guatemala | 337762 | 9927 | 293208 | 34627 | 15.7835 | -90.2308 | 2021-07-21 04:21:40 | Guatemala | |||
3331457 | 3331457 | 2021-07-21 | Guatemala | 340857 | 9927 | 293208 | 37722 | 15.7835 | -90.2308 | 2021-07-22 04:21:19 | Guatemala | |||
2673740 | 2673740 | 2021-07-18 | Guatemala | 333827 | 9914 | 291784 | 32129 | 15.7835 | -90.2308 | 2021-07-19 04:21:24 | Guatemala | |||
3706052 | 3706052 | 2021-07-17 | Guatemala | 333126 | 9898 | 290113 | 33115 | 15.7835 | -90.2308 | 2021-07-18 04:22:07 | Guatemala | |||
2947283 | 2947283 | 2021-07-16 | Guatemala | 330651 | 9871 | 288118 | 32662 | 15.7835 | -90.2308 | 2021-07-17 04:22:22 | Guatemala | |||
295939 | 295939 | 2021-07-15 | Guatemala | 327755 | 9834 | 286201 | 31720 | 15.7835 | -90.2308 | 2021-07-16 04:21:22 | Guatemala | |||
3631884 | 3631884 | 2021-07-14 | Guatemala | 325024 | 9798 | 284613 | 30613 | 15.7835 | -90.2308 | 2021-07-15 04:21:48 | Guatemala | |||
578759 | 578759 | 2021-07-13 | Guatemala | 322120 | 9756 | 282911 | 29453 | 15.7835 | -90.2308 | 2021-07-14 04:21:35 | Guatemala | |||
3741008 | 3741008 | 2021-07-12 | Guatemala | 319157 | 9721 | 280923 | 28513 | 15.7835 | -90.2308 | 2021-07-13 04:21:18 | Guatemala | |||
3659521 | 3659521 | 2021-07-11 | Guatemala | 318541 | 9713 | 279371 | 29457 | 15.7835 | -90.2308 | 2021-07-12 04:21:34 | Guatemala | |||
625805 | 625805 | 2021-07-10 | Guatemala | 317311 | 9688 | 277992 | 29631 | 15.7835 | -90.2308 | 2021-07-11 04:21:43 | Guatemala | |||
829524 | 829524 | 2021-07-09 | Guatemala | 314302 | 9643 | 276272 | 28387 | 15.7835 | -90.2308 | 2021-07-10 04:21:25 | Guatemala | |||
778288 | 778288 | 2021-07-08 | Guatemala | 311342 | 9609 | 274697 | 27036 | 15.7835 | -90.2308 | 2021-07-09 04:21:21 | Guatemala | |||
1440510 | 1440510 | 2021-07-07 | Guatemala | 308273 | 9573 | 273182 | 25518 | 15.7835 | -90.2308 | 2021-07-08 04:21:26 | Guatemala | |||
2693615 | 2693615 | 2021-07-06 | Guatemala | 305319 | 9548 | 271562 | 24209 | 15.7835 | -90.2308 | 2021-07-07 04:21:20 | Guatemala | |||
1932364 | 1932364 | 2021-07-05 | Guatemala | 302534 | 9498 | 269908 | 23128 | 15.7835 | -90.2308 | 2021-07-06 04:21:32 | Guatemala | |||
1165095 | 1165095 | 2021-07-04 | Guatemala | 302012 | 9461 | 269019 | 23532 | 15.7835 | -90.2308 | 2021-07-05 04:21:28 | Guatemala | |||
1495529 | 1495529 | 2021-07-03 | Guatemala | 301189 | 9419 | 267900 | 23870 | 15.7835 | -90.2308 | 2021-07-04 04:21:38 | Guatemala | |||
2071844 | 2071844 | 2021-07-02 | Guatemala | 298904 | 9350 | 266602 | 22952 | 15.7835 | -90.2308 | 2021-07-03 04:21:37 | Guatemala | |||
2764860 | 2764860 | 2021-07-01 | Guatemala | 296438 | 9282 | 265352 | 21804 | 15.7835 | -90.2308 | 2021-07-02 04:21:47 | Guatemala | |||
400191 | 400191 | 2021-06-29 | Guatemala | 292674 | 9147 | 264426 | 19101 | 15.7835 | -90.2308 | 2021-06-30 04:21:41 | Guatemala | |||
1893068 | 1893068 | 2021-06-30 | Guatemala | 293583 | 9215 | 264426 | 19942 | 15.7835 | -90.2308 | 2021-07-01 04:21:19 | Guatemala | |||
3125434 | 3125434 | 2021-06-28 | Guatemala | 291977 | 9089 | 263025 | 19863 | 15.7835 | -90.2308 | 2021-06-29 04:21:28 | Guatemala | |||
2589929 | 2589929 | 2021-06-27 | Guatemala | 291595 | 9050 | 262171 | 20374 | 15.7835 | -90.2308 | 2021-06-28 04:21:29 | Guatemala | |||
3958433 | 3958433 | 2021-06-26 | Guatemala | 290852 | 9008 | 261133 | 20711 | 15.7835 | -90.2308 | 2021-06-27 04:21:39 | Guatemala | |||
1712252 | 1712252 | 2021-06-25 | Guatemala | 288987 | 8960 | 259850 | 20177 | 15.7835 | -90.2308 | 2021-06-26 04:21:43 | Guatemala | |||
2295377 | 2295377 | 2021-06-24 | Guatemala | 286708 | 8894 | 258646 | 19168 | 15.7835 | -90.2308 | 2021-06-25 04:21:33 | Guatemala | |||
2422817 | 2422817 | 2021-06-23 | Guatemala | 284741 | 8845 | 257397 | 18499 | 15.7835 | -90.2308 | 2021-06-24 04:21:55 | Guatemala | |||
562894 | 562894 | 2021-06-22 | Guatemala | 282713 | 8785 | 255996 | 17932 | 15.7835 | -90.2308 | 2021-06-23 04:21:46 | Guatemala | |||
3358596 | 3358596 | 2021-06-21 | Guatemala | 280854 | 8735 | 254700 | 17419 | 15.7835 | -90.2308 | 2021-06-22 04:21:34 | Guatemala | |||
2884295 | 2884295 | 2021-06-20 | Guatemala | 280507 | 8694 | 253940 | 17873 | 15.7835 | -90.2308 | 2021-06-21 04:21:41 | Guatemala | |||
107378 | 107378 | 2021-06-19 | Guatemala | 279947 | 8645 | 252995 | 18307 | 15.7835 | -90.2308 | 2021-06-20 04:21:48 | Guatemala | |||
1125521 | 1125521 | 2021-06-18 | Guatemala | 278409 | 8595 | 251837 | 17977 | 15.7835 | -90.2308 | 2021-06-19 04:22:33 | Guatemala | |||
2911099 | 2911099 | 2021-06-17 | Guatemala | 276927 | 8549 | 250772 | 17606 | 15.7835 | -90.2308 | 2021-06-18 04:22:16 | Guatemala | |||
3030217 | 3030217 | 2021-06-16 | Guatemala | 275202 | 8527 | 249560 | 17115 | 15.7835 | -90.2308 | 2021-06-17 04:22:36 | Guatemala | |||
2339323 | 2339323 | 2021-06-15 | Guatemala | 273730 | 8500 | 248316 | 16914 | 15.7835 | -90.2308 | 2021-06-16 04:22:32 | Guatemala | |||
1564019 | 1564019 | 2021-06-14 | Guatemala | 271990 | 8465 | 247134 | 16391 | 15.7835 | -90.2308 | 2021-06-15 04:22:22 | Guatemala | |||
3381302 | 3381302 | 2021-06-13 | Guatemala | 271703 | 8455 | 246426 | 16822 | 15.7835 | -90.2308 | 2021-06-14 04:22:46 | Guatemala | |||
1736436 | 1736436 | 2021-06-12 | Guatemala | 271131 | 8439 | 245610 | 17082 | 15.7835 | -90.2308 | 2021-06-13 04:22:44 | Guatemala | |||
3970477 | 3970477 | 2021-06-11 | Guatemala | 269308 | 8416 | 244416 | 16476 | 15.7835 | -90.2308 | 2021-06-12 04:22:22 | Guatemala | |||
2716899 | 2716899 | 2021-06-10 | Guatemala | 267447 | 8388 | 243191 | 15868 | 15.7835 | -90.2308 | 2021-06-11 04:23:20 | Guatemala | |||
522784 | 522784 | 2021-06-09 | Guatemala | 265662 | 8361 | 242033 | 15268 | 15.7835 | -90.2308 | 2021-06-10 04:23:17 | Guatemala | |||
3472224 | 3472224 | 2021-06-08 | Guatemala | 263836 | 8331 | 240961 | 14544 | 15.7835 | -90.2308 | 2021-06-09 04:23:31 | Guatemala | |||
3145508 | 3145508 | 2021-06-07 | Guatemala | 262255 | 8305 | 239804 | 14146 | 15.7835 | -90.2308 | 2021-06-08 04:22:35 | Guatemala | |||
825510 | 825510 | 2021-06-06 | Guatemala | 261958 | 8294 | 239176 | 14488 | 15.7835 | -90.2308 | 2021-06-07 04:22:51 | Guatemala | |||
2585915 | 2585915 | 2021-06-05 | Guatemala | 261392 | 8280 | 238344 | 14768 | 15.7835 | -90.2308 | 2021-06-06 04:24:03 | Guatemala | |||
2315229 | 2315229 | 2021-06-04 | Guatemala | 259954 | 8258 | 237398 | 14298 | 15.7835 | -90.2308 | 2021-06-05 04:23:03 | Guatemala | |||
1448514 | 1448514 | 2021-06-03 | Guatemala | 258633 | 8238 | 236469 | 13926 | 15.7835 | -90.2308 | 2021-06-04 04:23:37 | Guatemala | |||
1708238 | 1708238 | 2021-06-02 | Guatemala | 257167 | 8214 | 235641 | 13312 | 15.7835 | -90.2308 | 2021-06-03 04:23:32 | Guatemala | |||
2104056 | 2104056 | 2021-06-01 | Guatemala | 255833 | 8183 | 234775 | 12875 | 15.7835 | -90.2308 | 2021-06-02 04:24:34 | Guatemala | |||
1188672 | 1188672 | 2021-05-31 | Guatemala | 254417 | 8165 | 233595 | 12657 | 15.7835 | -90.2308 | 2021-06-01 04:23:09 | Guatemala | |||
3089349 | 3089349 | 2021-05-30 | Guatemala | 254225 | 8137 | 233002 | 13086 | 15.7835 | -90.2308 | 2021-05-31 03:08:59 | Guatemala | |||
50718 | 50718 | 2021-05-29 | Guatemala | 253837 | 8121 | 232359 | 13357 | 15.7835 | -90.2308 | 2021-05-30 04:20:55 | Guatemala | |||
20297 | 20297 | 2021-05-28 | Guatemala | 252929 | 8094 | 231594 | 13241 | 15.7835 | -90.2308 | 2021-05-29 04:20:41 | Guatemala | |||
1806672 | 1806672 | 2021-05-27 | Guatemala | 251336 | 8070 | 230882 | 12384 | 15.7835 | -90.2308 | 2021-05-28 04:20:36 | Guatemala | |||
1310096 | 1310096 | 2021-05-26 | Guatemala | 250296 | 8058 | 230019 | 12219 | 15.7835 | -90.2308 | 2021-05-27 04:20:59 | Guatemala | |||
83022 | 83022 | 2021-05-25 | Guatemala | 248824 | 8022 | 229126 | 11676 | 15.7835 | -90.2308 | 2021-05-26 04:20:35 | Guatemala | |||
1412984 | 1412984 | 2021-05-24 | Guatemala | 247644 | 8009 | 228169 | 11466 | 15.7835 | -90.2308 | 2021-05-25 04:21:08 | Guatemala | |||
1771270 | 1771270 | 2021-05-23 | Guatemala | 247454 | 8000 | 227600 | 11854 | 15.7835 | -90.2308 | 2021-05-24 04:20:53 | Guatemala | |||
726425 | 726425 | 2021-05-22 | Guatemala | 247106 | 7996 | 226819 | 12291 | 15.7835 | -90.2308 | 2021-05-23 04:20:51 | Guatemala | |||
1952440 | 1952440 | 2021-05-21 | Guatemala | 246156 | 7977 | 226014 | 12165 | 15.7835 | -90.2308 | 2021-05-22 04:20:45 | Guatemala | |||
1913139 | 1913139 | 2021-05-20 | Guatemala | 245247 | 7952 | 225210 | 12085 | 15.7835 | -90.2308 | 2021-05-21 04:20:43 | Guatemala | |||
2255660 | 2255660 | 2021-05-19 | Guatemala | 243833 | 7928 | 224185 | 11720 | 15.7835 | -90.2308 | 2021-05-20 04:21:05 | Guatemala | |||
2390698 | 2390698 | 2021-05-18 | Guatemala | 242784 | 7913 | 223244 | 11627 | 15.7835 | -90.2308 | 2021-05-19 04:20:42 | Guatemala | |||
3574523 | 3574523 | 2021-05-17 | Guatemala | 241528 | 7893 | 222049 | 11586 | 15.7835 | -90.2308 | 2021-05-18 04:20:33 | Guatemala | |||
2939253 | 2939253 | 2021-05-16 | Guatemala | 241369 | 7887 | 221298 | 12184 | 15.7835 | -90.2308 | 2021-05-17 04:20:34 | Guatemala | |||
1872883 | 1872883 | 2021-05-15 | Guatemala | 241117 | 7872 | 220536 | 12709 | 15.7835 | -90.2308 | 2021-05-16 04:20:49 | Guatemala | |||
1081852 | 1081852 | 2021-05-14 | Guatemala | 240170 | 7845 | 219456 | 12869 | 15.7835 | -90.2308 | 2021-05-15 04:20:58 | Guatemala | |||
3054118 | 3054118 | 2021-05-13 | Guatemala | 238787 | 7832 | 218321 | 12634 | 15.7835 | -90.2308 | 2021-05-14 04:20:41 | Guatemala | |||
2004588 | 2004588 | 2021-05-12 | Guatemala | 237682 | 7815 | 217219 | 12648 | 15.7835 | -90.2308 | 2021-05-13 04:20:51 | Guatemala | |||
3954419 | 3954419 | 2021-05-11 | Guatemala | 236266 | 7776 | 215803 | 12687 | 15.7835 | -90.2308 | 2021-05-12 04:21:29 | Guatemala | |||
2820698 | 2820698 | 2021-05-10 | Guatemala | 235304 | 7736 | 214601 | 12967 | 15.7835 | -90.2308 | 2021-05-11 04:20:41 | Guatemala | |||
1425030 | 1425030 | 2021-05-09 | Guatemala | 235098 | 7733 | 213641 | 13724 | 15.7835 | -90.2308 | 2021-05-10 04:20:38 | Guatemala | |||
1551898 | 1551898 | 2021-05-08 | Guatemala | 234883 | 7717 | 212814 | 14352 | 15.7835 | -90.2308 | 2021-05-09 04:20:35 | Guatemala | |||
2501956 | 2501956 | 2021-05-07 | Guatemala | 233696 | 7695 | 211572 | 14429 | 15.7835 | -90.2308 | 2021-05-08 04:21:04 | Guatemala | |||
3113412 | 3113412 | 2021-05-06 | Guatemala | 232439 | 7677 | 210369 | 14393 | 15.7835 | -90.2308 | 2021-05-07 04:20:40 | Guatemala | |||
645879 | 645879 | 2021-05-05 | Guatemala | 231289 | 7642 | 209096 | 14551 | 15.7835 | -90.2308 | 2021-05-06 04:20:38 | Guatemala | |||
3675579 | 3675579 | 2021-05-04 | Guatemala | 230095 | 7606 | 207862 | 14627 | 15.7835 | -90.2308 | 2021-05-05 04:20:43 | Guatemala | |||
2760846 | 2760846 | 2021-05-03 | Guatemala | 228871 | 7578 | 206217 | 15076 | 15.7835 | -90.2308 | 2021-05-04 04:20:34 | Guatemala | |||
2450699 | 2450699 | 2021-05-02 | Guatemala | 228684 | 7558 | 205365 | 15761 | 15.7835 | -90.2308 | 2021-05-03 04:20:39 | Guatemala | |||
2824712 | 2824712 | 2021-05-01 | Guatemala | 228477 | 7543 | 204141 | 16793 | 15.7835 | -90.2308 | 2021-05-02 04:20:48 | Guatemala | |||
380120 | 380120 | 2021-04-30 | Guatemala | 227671 | 7524 | 202843 | 17304 | 15.7835 | -90.2308 | 2021-05-01 04:20:47 | Guatemala | |||
1636243 | 1636243 | 2021-04-29 | Guatemala | 226247 | 7500 | 201621 | 17126 | 15.7835 | -90.2308 | 2021-04-30 04:21:03 | Guatemala | |||
3393322 | 3393322 | 2021-04-28 | Guatemala | 224621 | 7478 | 200241 | 16902 | 15.7835 | -90.2308 | 2021-04-29 04:20:55 | Guatemala | |||
3702038 | 3702038 | 2021-04-27 | Guatemala | 223025 | 7453 | 199005 | 16567 | 15.7835 | -90.2308 | 2021-04-28 04:20:32 | 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]);