daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Guanajuato" sorted by last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-20 | Mexico | Guanajuato | 821 | 80 | 481 | 260 | 21.019000000000002 | -101.2574 | 2020-05-21 02:32:48 | Guanajuato, Mexico | ||
2020-05-21 | Mexico | Guanajuato | 897 | 84 | 517 | 296 | 21.019000000000002 | -101.2574 | 2020-05-22 02:36:51 | Guanajuato, Mexico | ||
2020-05-22 | Mexico | Guanajuato | 948 | 85 | 556 | 307 | 21.019000000000002 | -101.2574 | 2020-05-23 02:32:42 | Guanajuato, Mexico | ||
2020-05-23 | Mexico | Guanajuato | 1028 | 85 | 595 | 348 | 21.019000000000002 | -101.2574 | 2020-05-24 02:32:43 | Guanajuato, Mexico | ||
2020-05-24 | Mexico | Guanajuato | 1054 | 88 | 620 | 346 | 21.019000000000002 | -101.2574 | 2020-05-25 02:32:44 | Guanajuato, Mexico | ||
2020-05-25 | Mexico | Guanajuato | 1127 | 91 | 666 | 370 | 21.019000000000002 | -101.2574 | 2020-05-26 02:32:35 | Guanajuato, Mexico | ||
2020-05-26 | Mexico | Guanajuato | 1184 | 96 | 710 | 378 | 21.019000000000002 | -101.2574 | 2020-05-27 02:32:31 | Guanajuato, Mexico | ||
2020-05-27 | Mexico | Guanajuato | 1238 | 101 | 734 | 403 | 21.019000000000002 | -101.2574 | 2020-05-28 02:32:31 | Guanajuato, Mexico | ||
2020-05-28 | Mexico | Guanajuato | 1320 | 101 | 764 | 455 | 21.019 | -101.2574 | 2020-05-29 02:32:50 | Guanajuato, Mexico | ||
2020-05-29 | Mexico | Guanajuato | 1384 | 105 | 823 | 456 | 21.019 | -101.2574 | 2020-05-30 02:32:48 | Guanajuato, Mexico | ||
2020-05-30 | Mexico | Guanajuato | 1463 | 107 | 871 | 485 | 21.019 | -101.2574 | 2020-05-31 02:32:45 | Guanajuato, Mexico | ||
2020-05-31 | Mexico | Guanajuato | 1633 | 107 | 932 | 594 | 21.019 | -101.2574 | 2020-06-01 02:32:46 | Guanajuato, Mexico | ||
2020-06-01 | Mexico | Guanajuato | 1680 | 112 | 992 | 576 | 21.019 | -101.2574 | 2020-06-02 02:33:08 | Guanajuato, Mexico | ||
2020-06-02 | Mexico | Guanajuato | 1872 | 116 | 1052 | 704 | 21.019 | -101.2574 | 2020-06-03 02:33:13 | Guanajuato, Mexico | ||
2020-06-03 | Mexico | Guanajuato | 2009 | 122 | 1108 | 779 | 21.019 | -101.2574 | 2020-06-04 02:33:14 | Guanajuato, Mexico | ||
2020-06-04 | Mexico | Guanajuato | 2135 | 125 | 1134 | 876 | 21.019 | -101.2574 | 2020-06-05 02:33:06 | Guanajuato, Mexico | ||
2020-06-05 | Mexico | Guanajuato | 2278 | 134 | 1218 | 926 | 21.019000000000002 | -101.2574 | 2020-06-06 02:33:00 | Guanajuato, Mexico | ||
2020-06-06 | Mexico | Guanajuato | 2389 | 136 | 1313 | 940 | 21.019000000000002 | -101.2574 | 2020-06-07 03:53:30 | Guanajuato, Mexico | ||
2020-06-07 | Mexico | Guanajuato | 2500 | 138 | 1420 | 942 | 21.019000000000002 | -101.2574 | 2020-06-08 03:33:22 | Guanajuato, Mexico | ||
2020-06-08 | Mexico | Guanajuato | 2556 | 141 | 1556 | 859 | 21.019000000000002 | -101.2574 | 2020-06-09 03:33:03 | Guanajuato, Mexico | ||
2020-06-09 | Mexico | Guanajuato | 2718 | 145 | 1656 | 917 | 21.019000000000002 | -101.2574 | 2020-06-10 04:07:00 | Guanajuato, Mexico | ||
2020-06-10 | Mexico | Guanajuato | 2936 | 159 | 1778 | 999 | 21.019000000000002 | -101.2574 | 2020-06-11 03:33:41 | Guanajuato, Mexico | ||
2020-06-11 | Mexico | Guanajuato | 3053 | 171 | 1875 | 1007 | 21.019 | -101.2574 | 2020-06-12 05:09:52 | Guanajuato, Mexico | ||
2020-06-12 | Mexico | Guanajuato | 3221 | 178 | 2022 | 1021 | 21.019 | -101.2574 | 2020-06-13 03:33:14 | Guanajuato, Mexico | ||
2020-06-13 | Mexico | Guanajuato | 3367 | 184 | 2178 | 1005 | 21.019 | -101.2574 | 2020-06-14 03:33:15 | Guanajuato, Mexico | ||
2020-06-14 | Mexico | Guanajuato | 3470 | 189 | 2325 | 956 | 21.019 | -101.2574 | 2020-06-15 03:33:14 | Guanajuato, Mexico | ||
2020-06-15 | Mexico | Guanajuato | 3540 | 196 | 2504 | 840 | 21.019 | -101.2574 | 2020-06-16 04:33:09 | Guanajuato, Mexico | ||
2020-06-16 | Mexico | Guanajuato | 3876 | 204 | 2644 | 1028 | 21.019 | -101.2574 | 2020-06-17 04:33:21 | Guanajuato, Mexico | ||
2020-06-17 | Mexico | Guanajuato | 4061 | 215 | 2794 | 1052 | 21.019 | -101.2574 | 2020-06-18 04:33:18 | Guanajuato, Mexico | ||
2020-06-18 | Mexico | Guanajuato | 4319 | 221 | 2938 | 1160 | 21.019 | -101.2574 | 2020-06-19 04:33:17 | Guanajuato, Mexico | ||
2020-06-19 | Mexico | Guanajuato | 4563 | 232 | 3109 | 1222 | 21.019 | -101.2574 | 2020-06-20 04:33:19 | Guanajuato, Mexico | ||
2020-06-20 | Mexico | Guanajuato | 4797 | 247 | 3305 | 1245 | 21.019 | -101.2574 | 2020-06-21 04:33:19 | Guanajuato, Mexico | ||
2020-06-21 | Mexico | Guanajuato | 4931 | 250 | 3445 | 1236 | 21.019 | -101.2574 | 2020-06-22 04:33:20 | Guanajuato, Mexico | ||
2020-06-22 | Mexico | Guanajuato | 5014 | 257 | 3624 | 1133 | 21.019 | -101.2574 | 2020-06-23 04:33:22 | Guanajuato, Mexico | ||
2020-06-23 | Mexico | Guanajuato | 5449 | 280 | 3802 | 1367 | 21.019 | -101.2574 | 2020-06-24 04:33:28 | Guanajuato, Mexico | ||
2020-06-24 | Mexico | Guanajuato | 5703 | 282 | 4021 | 1400 | 21.019 | -101.2574 | 2020-06-25 05:26:54 | Guanajuato, Mexico | ||
2020-06-25 | Mexico | Guanajuato | 6126 | 301 | 4178 | 1647 | 21.019 | -101.2574 | 2020-06-26 04:33:43 | Guanajuato, Mexico | ||
2020-06-26 | Mexico | Guanajuato | 6402 | 327 | 4405 | 1670 | 21.019 | -101.2574 | 2020-06-27 04:33:35 | Guanajuato, Mexico | ||
2020-06-27 | Mexico | Guanajuato | 6611 | 334 | 4635 | 1642 | 21.019 | -101.2574 | 2020-06-28 04:34:04 | Guanajuato, Mexico | ||
2020-06-28 | Mexico | Guanajuato | 6785 | 342 | 4959 | 1484 | 21.019 | -101.2574 | 2020-06-29 04:33:44 | Guanajuato, Mexico | ||
2020-06-29 | Mexico | Guanajuato | 6995 | 348 | 5289 | 1358 | 21.019000000000002 | -101.2574 | 2020-06-30 04:33:48 | Guanajuato, Mexico | ||
2020-06-30 | Mexico | Guanajuato | 7336 | 357 | 5567 | 1412 | 21.019 | -101.2574 | 2020-07-01 04:33:52 | Guanajuato, Mexico | ||
2020-07-01 | Mexico | Guanajuato | 7744 | 370 | 5792 | 1582 | 21.019 | -101.2574 | 2020-07-02 04:33:46 | Guanajuato, Mexico | ||
2020-07-02 | Mexico | Guanajuato | 8062 | 390 | 6014 | 1658 | 21.019000000000002 | -101.2574 | 2020-07-03 04:33:54 | Guanajuato, Mexico | ||
2020-07-03 | Mexico | Guanajuato | 8465 | 399 | 6322 | 1744 | 21.019 | -101.2574 | 2020-07-04 04:33:51 | Guanajuato, Mexico | ||
2020-07-04 | Mexico | Guanajuato | 8914 | 413 | 6736 | 1765 | 21.019 | -101.2574 | 2020-07-05 04:33:46 | Guanajuato, Mexico | ||
2020-07-05 | Mexico | Guanajuato | 9271 | 419 | 7013 | 1839 | 21.019 | -101.2574 | 2020-07-06 04:33:57 | Guanajuato, Mexico | ||
2020-07-06 | Mexico | Guanajuato | 9596 | 435 | 7288 | 1873 | 21.019 | -101.2574 | 2020-07-07 04:34:00 | Guanajuato, Mexico | ||
2020-07-07 | Mexico | Guanajuato | 9893 | 451 | 7565 | 1877 | 21.019 | -101.2574 | 2020-07-08 05:33:48 | Guanajuato, Mexico | ||
2020-07-08 | Mexico | Guanajuato | 10295 | 473 | 7849 | 1973 | 21.019 | -101.2574 | 2020-07-09 04:34:23 | Guanajuato, Mexico | ||
2020-07-09 | Mexico | Guanajuato | 10707 | 506 | 8113 | 2088 | 21.019 | -101.2574 | 2020-07-10 04:34:24 | Guanajuato, Mexico | ||
2020-07-10 | Mexico | Guanajuato | 11239 | 533 | 8404 | 2302 | 21.019 | -101.2574 | 2020-07-11 04:34:26 | Guanajuato, Mexico | ||
2020-07-11 | Mexico | Guanajuato | 11807 | 553 | 8686 | 2568 | 21.019 | -101.2574 | 2020-07-12 04:34:30 | Guanajuato, Mexico | ||
2020-07-12 | Mexico | Guanajuato | 12285 | 582 | 9039 | 2664 | 21.019 | -101.2574 | 2020-07-13 04:43:04 | Guanajuato, Mexico | ||
2020-07-13 | Mexico | Guanajuato | 12541 | 621 | 9390 | 2530 | 21.019 | -101.2574 | 2020-07-14 04:34:46 | Guanajuato, Mexico | ||
2020-07-14 | Mexico | Guanajuato | 12942 | 649 | 9749 | 2544 | 21.019 | -101.2574 | 2020-07-15 04:34:39 | Guanajuato, Mexico | ||
2020-07-15 | Mexico | Guanajuato | 13329 | 668 | 10198 | 2463 | 21.019000000000002 | -101.2574 | 2020-07-16 04:44:59 | Guanajuato, Mexico | ||
2020-07-16 | Mexico | Guanajuato | 13535 | 683 | 10483 | 2369 | 21.019000000000002 | -101.2574 | 2020-07-17 04:34:50 | Guanajuato, Mexico | ||
2020-07-17 | Mexico | Guanajuato | 14021 | 705 | 10947 | 2369 | 21.019 | -101.2574 | 2020-07-18 04:34:45 | Guanajuato, Mexico | ||
2020-07-18 | Mexico | Guanajuato | 14430 | 713 | 11348 | 2369 | 21.019 | -101.2574 | 2020-07-19 04:34:58 | Guanajuato, Mexico | ||
2020-07-19 | Mexico | Guanajuato | 14752 | 716 | 10686 | 3350 | 21.019 | -101.2574 | 2020-07-20 05:34:40 | Guanajuato, Mexico | ||
2020-07-20 | Mexico | Guanajuato | 15198 | 725 | 11418 | 3055 | 21.019 | -101.2574 | 2020-07-21 04:38:46 | Guanajuato, Mexico | ||
2020-07-21 | Mexico | Guanajuato | 15564 | 761 | 11629 | 3174 | 21.019 | -101.2574 | 2020-07-22 04:34:42 | Guanajuato, Mexico | ||
2020-07-22 | Mexico | Guanajuato | 15860 | 786 | 11791 | 3283 | 21.019000000000002 | -101.2574 | 2020-07-23 05:15:04 | Guanajuato, Mexico | ||
2020-07-23 | Mexico | Guanajuato | 16270 | 814 | 12040 | 3416 | 21.019 | -101.2574 | 2020-07-24 03:34:53 | Guanajuato, Mexico | ||
2020-07-24 | Mexico | Guanajuato | 16902 | 835 | 12600 | 3467 | 21.019000000000002 | -101.2574 | 2020-07-25 04:47:39 | Guanajuato, Mexico | ||
2020-07-25 | Mexico | Guanajuato | 17543 | 851 | 13107 | 3585 | 21.019000000000002 | -101.2574 | 2020-07-26 04:35:00 | Guanajuato, Mexico | ||
2020-07-26 | Mexico | Guanajuato | 18058 | 857 | 13813 | 3388 | 21.019000000000002 | -101.2574 | 2020-07-27 04:35:02 | Guanajuato, Mexico | ||
2020-07-27 | Mexico | Guanajuato | 18463 | 863 | 14475 | 3125 | 21.019000000000002 | -101.2574 | 2020-07-28 04:58:43 | Guanajuato, Mexico | ||
2020-07-28 | Mexico | Guanajuato | 19110 | 915 | 14612 | 3583 | 21.019000000000002 | -101.2574 | 2020-07-29 04:35:11 | Guanajuato, Mexico | ||
2020-07-29 | Mexico | Guanajuato | 19648 | 923 | 15081 | 3644 | 21.019000000000002 | -101.2574 | 2020-07-30 04:35:05 | Guanajuato, Mexico | ||
2020-07-30 | Mexico | Guanajuato | 20155 | 948 | 15463 | 3744 | 21.019000000000002 | -101.2574 | 2020-07-31 04:35:18 | Guanajuato, Mexico | ||
2020-07-31 | Mexico | Guanajuato | 20770 | 971 | 16045 | 3754 | 21.019000000000002 | -101.2574 | 2020-08-01 04:36:27 | Guanajuato, Mexico | ||
2020-08-01 | Mexico | Guanajuato | 21378 | 999 | 16558 | 3821 | 21.019000000000002 | -101.2574 | 2020-08-02 04:34:47 | Guanajuato, Mexico | ||
2020-08-02 | Mexico | Guanajuato | 21722 | 1003 | 17141 | 3578 | 21.019000000000002 | -101.2574 | 2020-08-03 04:34:35 | Guanajuato, Mexico | ||
2020-08-03 | Mexico | Guanajuato | 22009 | 1009 | 17838 | 3162 | 21.019000000000002 | -101.2574 | 2020-08-04 04:41:59 | Guanajuato, Mexico | ||
2020-08-04 | Mexico | Guanajuato | 22267 | 1070 | 17950 | 3247 | 21.019000000000002 | -101.2574 | 2020-08-05 04:34:43 | Guanajuato, Mexico | ||
2020-08-05 | Mexico | Guanajuato | 22565 | 1111 | 18158 | 3296 | 21.019000000000002 | -101.2574 | 2020-08-06 04:35:02 | Guanajuato, Mexico | ||
2020-08-06 | Mexico | Guanajuato | 22860 | 1141 | 18262 | 3457 | 21.019000000000002 | -101.2574 | 2020-08-07 04:35:11 | Guanajuato, Mexico | ||
2020-08-07 | Mexico | Guanajuato | 23527 | 1168 | 19009 | 3350 | 21.019000000000002 | -101.2574 | 2020-08-08 04:34:53 | Guanajuato, Mexico | ||
2020-08-08 | Mexico | Guanajuato | 23918 | 1189 | 19778 | 2951 | 21.019000000000002 | -101.2574 | 2020-08-09 04:34:54 | Guanajuato, Mexico | ||
2020-08-09 | Mexico | Guanajuato | 24241 | 1199 | 20289 | 2753 | 21.019000000000002 | -101.2574 | 2020-08-10 04:34:55 | Guanajuato, Mexico | ||
2020-08-10 | Mexico | Guanajuato | 24561 | 1252 | 20766 | 2543 | 21.019000000000002 | -101.2574 | 2020-08-11 04:35:08 | Guanajuato, Mexico | ||
2020-08-11 | Mexico | Guanajuato | 24975 | 1310 | 21014 | 2651 | 21.019 | -101.2574 | 2020-08-12 04:27:29 | Guanajuato, Mexico | ||
2020-08-12 | Mexico | Guanajuato | 25244 | 1328 | 21246 | 2670 | 21.019 | -101.2574 | 2020-08-13 04:29:15 | Guanajuato, Mexico | ||
2020-08-13 | Mexico | Guanajuato | 25523 | 1335 | 21479 | 2709 | 21.019 | -101.2574 | 2020-08-14 04:51:19 | Guanajuato, Mexico | ||
2020-08-14 | Mexico | Guanajuato | 25978 | 1349 | 21833 | 2796 | 21.019 | -101.2574 | 2020-08-15 04:27:31 | Guanajuato, Mexico | ||
2020-08-15 | Mexico | Guanajuato | 26313 | 1358 | 22289 | 2666 | 21.019 | -101.2574 | 2020-08-16 04:27:42 | Guanajuato, Mexico | ||
2020-08-16 | Mexico | Guanajuato | 26625 | 1365 | 22616 | 2644 | 21.019 | -101.2574 | 2020-08-17 04:27:20 | Guanajuato, Mexico | ||
2020-08-17 | Mexico | Guanajuato | 26948 | 1375 | 23090 | 2483 | 21.019 | -101.2574 | 2020-08-18 04:27:56 | Guanajuato, Mexico | ||
2020-08-18 | Mexico | Guanajuato | 27387 | 1393 | 23353 | 2641 | 21.019 | -101.2574 | 2020-08-19 04:27:00 | Guanajuato, Mexico | ||
2020-08-19 | Mexico | Guanajuato | 27666 | 1427 | 23506 | 2733 | 21.019 | -101.2574 | 2020-08-20 04:27:43 | Guanajuato, Mexico | ||
2020-08-20 | Mexico | Guanajuato | 28023 | 1482 | 23801 | 2740 | 21.019 | -101.2574 | 2020-08-21 04:27:41 | Guanajuato, Mexico | ||
2020-08-21 | Mexico | Guanajuato | 28337 | 1513 | 24069 | 2755 | 21.019 | -101.2574 | 2020-08-22 04:27:49 | Guanajuato, Mexico | ||
2020-08-22 | Mexico | Guanajuato | 28512 | 1572 | 24202 | 2738 | 21.019 | -101.2574 | 2020-08-23 04:27:48 | Guanajuato, Mexico | ||
2020-08-23 | Mexico | Guanajuato | 28620 | 1582 | 24477 | 2561 | 21.019 | -101.2574 | 2020-08-24 04:27:56 | Guanajuato, Mexico | ||
2020-08-24 | Mexico | Guanajuato | 28900 | 1592 | 24951 | 2357 | 21.019 | -101.2574 | 2020-08-25 04:28:02 | Guanajuato, Mexico | ||
2020-08-25 | Mexico | Guanajuato | 29324 | 1616 | 25101 | 2607 | 21.019 | -101.2574 | 2020-08-26 04:28:11 | Guanajuato, Mexico | ||
2020-08-26 | Mexico | Guanajuato | 29602 | 1639 | 25028 | 2935 | 21.019 | -101.2574 | 2020-08-27 04:28:15 | Guanajuato, Mexico | ||
2020-08-27 | Mexico | Guanajuato | 29912 | 1653 | 25214 | 3045 | 21.019 | -101.2574 | 2020-08-28 04:28:11 | Guanajuato, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;