johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Puebla" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701604 | 2701604 | 2020-11-20 | Mexico | Puebla | 38125 | 5013 | 0 | 33112 | 19.0414 | -98.2063 | 2020-11-21 05:25:51 | Puebla, Mexico | ||
821664 | 821664 | 2020-11-19 | Mexico | Puebla | 37937 | 5005 | 0 | 32932 | 19.0414 | -98.2063 | 2020-11-20 05:26:28 | Puebla, Mexico | ||
122798 | 122798 | 2020-11-18 | Mexico | Puebla | 37801 | 4987 | 0 | 32814 | 19.0414 | -98.2063 | 2020-11-19 05:25:23 | Puebla, Mexico | ||
3338686 | 3338686 | 2020-11-17 | Mexico | Puebla | 37700 | 4971 | 0 | 32729 | 19.0414 | -98.2063 | 2020-11-18 05:40:31 | Puebla, Mexico | ||
3169731 | 3169731 | 2020-11-16 | Mexico | Puebla | 37676 | 4970 | 0 | 32706 | 19.0414 | -98.2063 | 2020-11-17 05:25:54 | Puebla, Mexico | ||
2880299 | 2880299 | 2020-11-15 | Mexico | Puebla | 37628 | 4969 | 0 | 32659 | 19.0414 | -98.2063 | 2020-11-16 05:25:57 | Puebla, Mexico | ||
2915277 | 2915277 | 2020-11-14 | Mexico | Puebla | 37575 | 4964 | 0 | 32611 | 19.0414 | -98.2063 | 2020-11-15 05:26:53 | Puebla, Mexico | ||
2785099 | 2785099 | 2020-11-13 | Mexico | Puebla | 37424 | 4956 | 0 | 32468 | 19.0414 | -98.2063 | 2020-11-14 05:25:37 | Puebla, Mexico | ||
864864 | 864864 | 2020-11-12 | Mexico | Puebla | 37186 | 4943 | 0 | 32243 | 19.0414 | -98.2063 | 2020-11-13 05:25:30 | Puebla, Mexico | ||
3440909 | 3440909 | 2020-11-11 | Mexico | Puebla | 36999 | 4903 | 30711 | 1385 | 19.0414 | -98.2063 | 2020-11-12 05:25:55 | Puebla, Mexico | ||
272249 | 272249 | 2020-11-10 | Mexico | Puebla | 36848 | 4883 | 30711 | 1254 | 19.0414 | -98.2063 | 2020-11-11 05:25:30 | Puebla, Mexico | ||
1988726 | 1988726 | 2020-11-09 | Mexico | Puebla | 36753 | 4853 | 30711 | 1189 | 19.0414 | -98.2063 | 2020-11-10 05:40:07 | Puebla, Mexico | ||
1728578 | 1728578 | 2020-11-08 | Mexico | Puebla | 36683 | 4875 | 30711 | 1097 | 19.0414 | -98.2063 | 2020-11-09 05:25:45 | Puebla, Mexico | ||
1544038 | 1544038 | 2020-11-07 | Mexico | Puebla | 36591 | 4869 | 30586 | 1136 | 19.0414 | -98.2063 | 2020-11-08 05:24:56 | Puebla, Mexico | ||
376276 | 376276 | 2020-11-06 | Mexico | Puebla | 36475 | 4857 | 30462 | 1156 | 19.0414 | -98.2063 | 2020-11-07 05:24:52 | Puebla, Mexico | ||
892214 | 892214 | 2020-11-05 | Mexico | Puebla | 36290 | 4845 | 30371 | 1074 | 19.0414 | -98.2063 | 2020-11-06 05:24:55 | Puebla, Mexico | ||
2919276 | 2919276 | 2020-11-04 | Mexico | Puebla | 36163 | 4824 | 30245 | 1094 | 19.0414 | -98.2063 | 2020-11-05 06:05:03 | Puebla, Mexico | ||
2498113 | 2498113 | 2020-11-03 | Mexico | Puebla | 36016 | 4792 | 30296 | 928 | 19.0414 | -98.2063 | 2020-11-04 05:25:09 | Puebla, Mexico | ||
3304288 | 3304288 | 2020-11-02 | Mexico | Puebla | 35845 | 4782 | 30121 | 942 | 19.0414 | -98.2063 | 2020-11-03 06:00:16 | Puebla, Mexico | ||
3409537 | 3409537 | 2020-11-01 | Mexico | Puebla | 35787 | 4779 | 29977 | 1031 | 19.0414 | -98.2063 | 2020-11-02 05:25:04 | Puebla, Mexico | ||
2080026 | 2080026 | 2020-10-31 | Mexico | Puebla | 35726 | 4777 | 29871 | 1078 | 19.0414 | -98.2063 | 2020-11-01 04:36:19 | Puebla, Mexico | ||
2243479 | 2243479 | 2020-10-30 | Mexico | Puebla | 35547 | 4756 | 29782 | 1009 | 19.0414 | -98.2063 | 2020-10-31 04:24:44 | Puebla, Mexico | ||
210334 | 210334 | 2020-10-29 | Mexico | Puebla | 35458 | 4729 | 29664 | 1065 | 19.0414 | -98.2063 | 2020-10-30 04:24:49 | Puebla, Mexico | ||
754396 | 754396 | 2020-10-28 | Mexico | Puebla | 35254 | 4713 | 29419 | 1122 | 19.0414 | -98.2063 | 2020-10-29 04:24:49 | Puebla, Mexico | ||
1452680 | 1452680 | 2020-10-27 | Mexico | Puebla | 35047 | 4688 | 29359 | 1000 | 19.0414 | -98.2063 | 2020-10-28 04:24:39 | Puebla, Mexico | ||
3480404 | 3480404 | 2020-10-26 | Mexico | Puebla | 34920 | 4653 | 29319 | 948 | 19.0414 | -98.2063 | 2020-10-27 04:24:45 | Puebla, Mexico | ||
8425 | 8425 | 2020-10-25 | Mexico | Puebla | 34864 | 4652 | 29148 | 1064 | 19.0414 | -98.2063 | 2020-10-26 04:25:02 | Puebla, Mexico | ||
3651662 | 3651662 | 2020-10-24 | Mexico | Puebla | 34761 | 4651 | 29020 | 1090 | 19.0414 | -98.2063 | 2020-10-25 04:24:36 | Puebla, Mexico | ||
1053917 | 1053917 | 2020-10-23 | Mexico | Puebla | 34683 | 4643 | 28961 | 1079 | 19.0414 | -98.2063 | 2020-10-24 04:24:46 | Puebla, Mexico | ||
1177587 | 1177587 | 2020-10-22 | Mexico | Puebla | 34532 | 4582 | 28899 | 1051 | 19.0414 | -98.2063 | 2020-10-23 04:24:46 | Puebla, Mexico | ||
2191692 | 2191692 | 2020-10-21 | Mexico | Puebla | 34420 | 4582 | 28772 | 1066 | 19.0414 | -98.2063 | 2020-10-22 04:24:27 | Puebla, Mexico | ||
3990703 | 3990703 | 2020-10-20 | Mexico | Puebla | 34174 | 4558 | 28656 | 960 | 19.0414 | -98.2063 | 2020-10-21 04:24:14 | Puebla, Mexico | ||
1794723 | 1794723 | 2020-10-19 | Mexico | Puebla | 34013 | 4543 | 28642 | 828 | 19.0414 | -98.2063 | 2020-10-20 04:24:22 | Puebla, Mexico | ||
762407 | 762407 | 2020-10-18 | Mexico | Puebla | 33942 | 4540 | 28503 | 899 | 19.0414 | -98.2063 | 2020-10-19 04:24:16 | Puebla, Mexico | ||
1026445 | 1026445 | 2020-10-17 | Mexico | Puebla | 33884 | 4539 | 28432 | 913 | 19.0414 | -98.2063 | 2020-10-18 04:24:25 | Puebla, Mexico | ||
2856940 | 2856940 | 2020-10-16 | Mexico | Puebla | 33780 | 4528 | 28382 | 870 | 19.0414 | -98.2063 | 2020-10-17 04:24:12 | Puebla, Mexico | ||
786470 | 786470 | 2020-10-15 | Mexico | Puebla | 33591 | 4520 | 28269 | 802 | 19.0414 | -98.2063 | 2020-10-16 04:24:01 | Puebla, Mexico | ||
79181 | 79181 | 2020-10-14 | Mexico | Puebla | 33406 | 4489 | 28080 | 837 | 19.0414 | -98.2063 | 2020-10-15 04:24:28 | Puebla, Mexico | ||
3781996 | 3781996 | 2020-10-13 | Mexico | Puebla | 33275 | 4479 | 28003 | 793 | 19.0414 | -98.2063 | 2020-10-14 04:24:05 | Puebla, Mexico | ||
2291536 | 2291536 | 2020-10-12 | Mexico | Puebla | 33227 | 4454 | 27964 | 809 | 19.0414 | -98.2063 | 2020-10-13 04:24:02 | Puebla, Mexico | ||
3785989 | 3785989 | 2020-10-11 | Mexico | Puebla | 33161 | 4450 | 27751 | 960 | 19.0414 | -98.2063 | 2020-10-12 04:23:45 | Puebla, Mexico | ||
2602127 | 2602127 | 2020-10-10 | Mexico | Puebla | 33091 | 4449 | 27637 | 1005 | 19.0414 | -98.2063 | 2020-10-11 04:23:46 | Puebla, Mexico | ||
817660 | 817660 | 2020-10-09 | Mexico | Puebla | 32922 | 4402 | 27590 | 930 | 19.0414 | -98.2063 | 2020-10-10 04:23:57 | Puebla, Mexico | ||
2689775 | 2689775 | 2020-10-08 | Mexico | Puebla | 32754 | 4388 | 27449 | 917 | 19.0414 | -98.2063 | 2020-10-09 04:23:59 | Puebla, Mexico | ||
1041917 | 1041917 | 2020-10-07 | Mexico | Puebla | 32664 | 4374 | 27396 | 894 | 19.0414 | -98.2063 | 2020-10-08 04:23:56 | Puebla, Mexico | ||
3117578 | 3117578 | 2020-10-06 | Mexico | Puebla | 32503 | 4360 | 27342 | 801 | 19.0414 | -98.2063 | 2020-10-07 04:23:40 | Puebla, Mexico | ||
3801990 | 3801990 | 2020-10-05 | Mexico | Puebla | 32391 | 4320 | 27181 | 890 | 19.0414 | -98.2063 | 2020-10-06 04:23:33 | Puebla, Mexico | ||
1822880 | 1822880 | 2020-10-04 | Mexico | Puebla | 31649 | 4129 | 26641 | 879 | 19.0414 | -98.2063 | 2020-10-05 04:23:33 | Puebla, Mexico | ||
2514264 | 2514264 | 2020-10-03 | Mexico | Puebla | 31574 | 4128 | 26463 | 983 | 19.0414 | -98.2063 | 2020-10-04 04:23:44 | Puebla, Mexico | ||
3389482 | 3389482 | 2020-10-02 | Mexico | Puebla | 31493 | 4115 | 26404 | 974 | 19.0414 | -98.2063 | 2020-10-03 04:23:40 | Puebla, Mexico | ||
2379723 | 2379723 | 2020-10-01 | Mexico | Puebla | 31380 | 4097 | 26285 | 998 | 19.0414 | -98.2063 | 2020-10-02 04:23:51 | Puebla, Mexico | ||
1045909 | 1045909 | 2020-09-30 | Mexico | Puebla | 31257 | 4073 | 26224 | 960 | 19.0414 | -98.2063 | 2020-10-01 04:23:42 | Puebla, Mexico | ||
966990 | 966990 | 2020-09-29 | Mexico | Puebla | 31052 | 4054 | 26113 | 885 | 19.0414 | -98.2063 | 2020-09-30 04:23:33 | Puebla, Mexico | ||
1515487 | 1515487 | 2020-09-28 | Mexico | Puebla | 31005 | 4016 | 26080 | 909 | 19.0414 | -98.2063 | 2020-09-29 04:23:42 | Puebla, Mexico | ||
2582075 | 2582075 | 2020-09-27 | Mexico | Puebla | 30919 | 4010 | 25953 | 956 | 19.0414 | -98.2063 | 2020-09-28 04:23:00 | Puebla, Mexico | ||
2614127 | 2614127 | 2020-09-26 | Mexico | Puebla | 30808 | 4008 | 25807 | 993 | 19.0414 | -98.2063 | 2020-09-27 04:23:00 | Puebla, Mexico | ||
2812842 | 2812842 | 2020-09-25 | Mexico | Puebla | 30665 | 3995 | 25717 | 953 | 19.0414 | -98.2063 | 2020-09-26 04:23:00 | Puebla, Mexico | ||
2606119 | 2606119 | 2020-09-24 | Mexico | Puebla | 30548 | 3984 | 25626 | 938 | 19.0414 | -98.2063 | 2020-09-25 04:23:00 | Puebla, Mexico | ||
2653862 | 2653862 | 2020-09-23 | Mexico | Puebla | 30372 | 3968 | 25503 | 901 | 19.0414 | -98.2063 | 2020-09-24 04:23:00 | Puebla, Mexico | ||
3316311 | 3316311 | 2020-09-22 | Mexico | Puebla | 30175 | 3947 | 25374 | 854 | 19.0414 | -98.2063 | 2020-09-23 04:23:00 | Puebla, Mexico | ||
2836910 | 2836910 | 2020-09-21 | Mexico | Puebla | 30078 | 3923 | 25340 | 815 | 19.0414 | -98.2063 | 2020-09-22 04:23:00 | Puebla, Mexico | ||
3093514 | 3093514 | 2020-09-20 | Mexico | Puebla | 29998 | 3918 | 25196 | 884 | 19.0414 | -98.2063 | 2020-09-21 04:23:00 | Puebla, Mexico | ||
2454864 | 2454864 | 2020-09-19 | Mexico | Puebla | 29938 | 3916 | 25066 | 956 | 19.0414 | -98.2063 | 2020-09-20 04:22:00 | Puebla, Mexico | ||
2848933 | 2848933 | 2020-09-18 | Mexico | Puebla | 29803 | 3896 | 24984 | 923 | 19.0414 | -98.2063 | 2020-09-19 04:22:00 | Puebla, Mexico | ||
1121682 | 1121682 | 2020-09-17 | Mexico | Puebla | 29647 | 3862 | 24937 | 848 | 19.0414 | -98.2063 | 2020-09-18 05:05:00 | Puebla, Mexico | ||
666371 | 666371 | 2020-09-16 | Mexico | Puebla | 29524 | 3857 | 24736 | 931 | 19.0414 | -98.2063 | 2020-09-17 04:22:00 | Puebla, Mexico | ||
2729096 | 2729096 | 2020-09-15 | Mexico | Puebla | 29380 | 3845 | 24622 | 913 | 19.0414 | -98.2063 | 2020-09-16 04:22:53 | Puebla, Mexico | ||
344368 | 344368 | 2020-09-14 | Mexico | Puebla | 29259 | 3824 | 24446 | 989 | 19.0414 | -98.2063 | 2020-09-15 03:22:50 | Puebla, Mexico | ||
2868807 | 2868807 | 2020-09-13 | Mexico | Puebla | 29129 | 3816 | 24293 | 1020 | 19.0414 | -98.2063 | 2020-09-14 04:26:00 | Puebla, Mexico | ||
546846 | 546846 | 2020-09-12 | Mexico | Puebla | 29046 | 3805 | 24112 | 1129 | 19.0414 | -98.2063 | 2020-09-13 04:30:52 | Puebla, Mexico | ||
1444675 | 1444675 | 2020-09-11 | Mexico | Puebla | 28820 | 3788 | 23943 | 1089 | 19.0414 | -98.2063 | 2020-09-12 04:25:05 | Puebla, Mexico | ||
1173276 | 1173276 | 2020-09-10 | Mexico | Puebla | 28665 | 3767 | 23776 | 1122 | 19.0414 | -98.2063 | 2020-09-11 04:46:23 | Puebla, Mexico | ||
2171641 | 2171641 | 2020-09-09 | Mexico | Puebla | 28426 | 3733 | 23601 | 1092 | 19.0414 | -98.2063 | 2020-09-10 04:29:01 | Puebla, Mexico | ||
1243850 | 1243850 | 2020-09-08 | Mexico | Puebla | 28357 | 3715 | 23459 | 1183 | 19.0414 | -98.2063 | 2020-09-09 04:28:48 | Puebla, Mexico | ||
427429 | 427429 | 2020-09-07 | Mexico | Puebla | 28275 | 3681 | 23439 | 1155 | 19.0414 | -98.2063 | 2020-09-08 04:28:25 | Puebla, Mexico | ||
3161714 | 3161714 | 2020-09-06 | Mexico | Puebla | 28133 | 3677 | 23255 | 1201 | 19.0414 | -98.2063 | 2020-09-07 04:28:30 | Puebla, Mexico | ||
813669 | 813669 | 2020-09-05 | Mexico | Puebla | 28055 | 3670 | 23137 | 1248 | 19.0414 | -98.2063 | 2020-09-06 04:28:33 | Puebla, Mexico | ||
2661869 | 2661869 | 2020-09-04 | Mexico | Puebla | 27704 | 3635 | 22956 | 1113 | 19.0414 | -98.2063 | 2020-09-05 04:28:19 | Puebla, Mexico | ||
1354409 | 1354409 | 2020-09-03 | Mexico | Puebla | 27527 | 3620 | 22836 | 1071 | 19.0414 | -98.2063 | 2020-09-04 04:28:26 | Puebla, Mexico | ||
1105646 | 1105646 | 2020-09-02 | Mexico | Puebla | 27348 | 3597 | 22512 | 1239 | 19.0414 | -98.2063 | 2020-09-03 04:28:22 | Puebla, Mexico | ||
2059975 | 2059975 | 2020-09-01 | Mexico | Puebla | 27070 | 3575 | 22217 | 1278 | 19.0414 | -98.2063 | 2020-09-02 04:28:25 | Puebla, Mexico | ||
194160 | 194160 | 2020-08-31 | Mexico | Puebla | 26899 | 3518 | 22222 | 1159 | 19.0414 | -98.2063 | 2020-09-01 04:28:31 | Puebla, Mexico | ||
3932119 | 3932119 | 2020-08-30 | Mexico | Puebla | 26791 | 3494 | 22000 | 1297 | 19.0414 | -98.2063 | 2020-08-31 04:28:27 | Puebla, Mexico | ||
609781 | 609781 | 2020-08-29 | Mexico | Puebla | 26660 | 3461 | 21849 | 1350 | 19.0414 | -98.2063 | 2020-08-30 04:28:22 | Puebla, Mexico | ||
1523276 | 1523276 | 2020-08-28 | Mexico | Puebla | 26451 | 3445 | 21537 | 1469 | 19.0414 | -98.2063 | 2020-08-29 04:28:19 | Puebla, Mexico | ||
2510277 | 2510277 | 2020-08-27 | Mexico | Puebla | 26286 | 3413 | 21391 | 1482 | 19.0414 | -98.2063 | 2020-08-28 04:28:11 | Puebla, Mexico | ||
1996737 | 1996737 | 2020-08-26 | Mexico | Puebla | 25951 | 3397 | 21209 | 1345 | 19.0414 | -98.2063 | 2020-08-27 04:28:15 | Puebla, Mexico | ||
3562661 | 3562661 | 2020-08-25 | Mexico | Puebla | 25785 | 3366 | 21042 | 1377 | 19.0414 | -98.2063 | 2020-08-26 04:28:11 | Puebla, Mexico | ||
2991365 | 2991365 | 2020-08-24 | Mexico | Puebla | 25705 | 3337 | 21155 | 1213 | 19.0414 | -98.2063 | 2020-08-25 04:28:02 | Puebla, Mexico | ||
2215760 | 2215760 | 2020-08-23 | Mexico | Puebla | 25586 | 3321 | 20859 | 1406 | 19.0414 | -98.2063 | 2020-08-24 04:27:56 | Puebla, Mexico | ||
2299542 | 2299542 | 2020-08-22 | Mexico | Puebla | 25435 | 3303 | 20629 | 1503 | 19.0414 | -98.2063 | 2020-08-23 04:27:48 | Puebla, Mexico | ||
1479649 | 1479649 | 2020-08-21 | Mexico | Puebla | 25252 | 3262 | 20537 | 1453 | 19.0414 | -98.2063 | 2020-08-22 04:27:49 | Puebla, Mexico | ||
3484398 | 3484398 | 2020-08-20 | Mexico | Puebla | 25064 | 3236 | 20314 | 1514 | 19.0414 | -98.2063 | 2020-08-21 04:27:41 | Puebla, Mexico | ||
206347 | 206347 | 2020-08-19 | Mexico | Puebla | 24767 | 3213 | 19973 | 1581 | 19.0414 | -98.2063 | 2020-08-20 04:27:43 | Puebla, Mexico | ||
3178101 | 3178101 | 2020-08-18 | Mexico | Puebla | 24605 | 3165 | 19860 | 1580 | 19.0414 | -98.2063 | 2020-08-19 04:27:00 | Puebla, Mexico | ||
837705 | 837705 | 2020-08-17 | Mexico | Puebla | 24487 | 3082 | 19922 | 1483 | 19.0414 | -98.2063 | 2020-08-18 04:27:56 | Puebla, Mexico | ||
1556063 | 1556063 | 2020-08-16 | Mexico | Puebla | 24383 | 3057 | 19674 | 1652 | 19.0414 | -98.2063 | 2020-08-17 04:27:20 | Puebla, Mexico | ||
146065 | 146065 | 2020-08-15 | Mexico | Puebla | 24118 | 3045 | 19409 | 1664 | 19.0414 | -98.2063 | 2020-08-16 04:27:42 | Puebla, Mexico | ||
1612340 | 1612340 | 2020-08-14 | Mexico | Puebla | 23879 | 3018 | 19087 | 1774 | 19.0414 | -98.2063 | 2020-08-15 04:27:31 | Puebla, Mexico | ||
582924 | 582924 | 2020-08-13 | Mexico | Puebla | 23599 | 2985 | 18871 | 1743 | 19.0414 | -98.2063 | 2020-08-14 04:51:19 | Puebla, Mexico |
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]);