johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and longitude = "-102.5832" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753013 | 2753013 | 2022-12-29 | Mexico | Zacatecas | 80643 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-30 04:21:04 | Zacatecas, Mexico | |||
1074019 | 1074019 | 2022-12-28 | Mexico | Zacatecas | 80643 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-29 04:21:01 | Zacatecas, Mexico | |||
328016 | 328016 | 2022-12-27 | Mexico | Zacatecas | 80578 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-28 04:21:04 | Zacatecas, Mexico | |||
218089 | 218089 | 2022-12-26 | Mexico | Zacatecas | 80531 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-27 04:21:07 | Zacatecas, Mexico | |||
3222546 | 3222546 | 2022-12-25 | Mexico | Zacatecas | 80521 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-26 04:21:06 | Zacatecas, Mexico | |||
1018460 | 1018460 | 2022-12-24 | Mexico | Zacatecas | 80521 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-25 04:21:04 | Zacatecas, Mexico | |||
690483 | 690483 | 2022-12-23 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-24 04:21:02 | Zacatecas, Mexico | |||
2179693 | 2179693 | 2022-12-22 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-23 04:21:04 | Zacatecas, Mexico | |||
451497 | 451497 | 2022-12-21 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-22 04:20:56 | Zacatecas, Mexico | |||
2951496 | 2951496 | 2022-12-20 | Mexico | Zacatecas | 80362 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-21 04:21:03 | Zacatecas, Mexico | |||
3173898 | 3173898 | 2022-12-19 | Mexico | Zacatecas | 80322 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-20 04:21:04 | Zacatecas, Mexico | |||
1628415 | 1628415 | 2022-12-18 | Mexico | Zacatecas | 80308 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-19 04:21:03 | Zacatecas, Mexico | |||
503794 | 503794 | 2022-12-17 | Mexico | Zacatecas | 80308 | 3934 | 0 | 22.7709 | -102.5832 | 2022-12-18 04:21:03 | Zacatecas, Mexico | |||
3324366 | 3324366 | 2022-12-16 | Mexico | Zacatecas | 80213 | 3932 | 0 | 22.7709 | -102.5832 | 2022-12-17 04:21:04 | Zacatecas, Mexico | |||
542878 | 542878 | 2022-12-15 | Mexico | Zacatecas | 80213 | 3932 | 0 | 22.7709 | -102.5832 | 2022-12-16 04:21:01 | Zacatecas, Mexico | |||
348406 | 348406 | 2022-12-14 | Mexico | Zacatecas | 80185 | 3932 | 0 | 22.7709 | -102.5832 | 2022-12-15 04:20:58 | Zacatecas, Mexico | |||
307994 | 307994 | 2022-12-13 | Mexico | Zacatecas | 80185 | 3932 | 0 | 22.7709 | -102.5832 | 2022-12-14 04:21:04 | Zacatecas, Mexico | |||
1149055 | 1149055 | 2022-12-12 | Mexico | Zacatecas | 80161 | 3931 | 0 | 22.7709 | -102.5832 | 2022-12-13 04:21:01 | Zacatecas, Mexico | |||
868909 | 868909 | 2022-12-11 | Mexico | Zacatecas | 80130 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-12 04:21:01 | Zacatecas, Mexico | |||
257439 | 257439 | 2022-12-10 | Mexico | Zacatecas | 80130 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-11 04:20:50 | Zacatecas, Mexico | |||
3936153 | 3936153 | 2022-12-09 | Mexico | Zacatecas | 80130 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-10 04:21:02 | Zacatecas, Mexico | |||
3377485 | 3377485 | 2022-12-08 | Mexico | Zacatecas | 80130 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-09 04:21:05 | Zacatecas, Mexico | |||
1984756 | 1984756 | 2022-12-07 | Mexico | Zacatecas | 80114 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-08 04:21:07 | Zacatecas, Mexico | |||
3714279 | 3714279 | 2022-12-06 | Mexico | Zacatecas | 80088 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-07 04:20:58 | Zacatecas, Mexico | |||
2414984 | 2414984 | 2022-12-05 | Mexico | Zacatecas | 80080 | 3929 | 0 | 22.7709 | -102.5832 | 2022-12-06 04:21:03 | Zacatecas, Mexico | |||
718592 | 718592 | 2022-12-04 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-05 04:20:58 | Zacatecas, Mexico | |||
2816881 | 2816881 | 2022-12-03 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-04 04:20:56 | Zacatecas, Mexico | |||
833737 | 833737 | 2022-12-02 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-03 04:21:02 | Zacatecas, Mexico | |||
2136267 | 2136267 | 2022-12-01 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-02 04:21:07 | Zacatecas, Mexico | |||
1964683 | 1964683 | 2022-11-30 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-12-01 04:21:03 | Zacatecas, Mexico | |||
2556697 | 2556697 | 2022-11-29 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-30 04:21:07 | Zacatecas, Mexico | |||
1239771 | 1239771 | 2022-11-28 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-29 04:21:05 | Zacatecas, Mexico | |||
3551759 | 3551759 | 2022-11-27 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-28 04:21:02 | Zacatecas, Mexico | |||
2100239 | 2100239 | 2022-11-26 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-27 04:21:05 | Zacatecas, Mexico | |||
487730 | 487730 | 2022-11-25 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-26 04:21:11 | Zacatecas, Mexico | |||
3523559 | 3523559 | 2022-11-24 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-25 04:21:06 | Zacatecas, Mexico | |||
3312342 | 3312342 | 2022-11-23 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-24 04:21:09 | Zacatecas, Mexico | |||
1620383 | 1620383 | 2022-11-22 | Mexico | Zacatecas | 79986 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-23 04:21:06 | Zacatecas, Mexico | |||
3460271 | 3460271 | 2022-11-21 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-22 04:20:47 | Zacatecas, Mexico | |||
1640456 | 1640456 | 2022-11-20 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-21 04:21:05 | Zacatecas, Mexico | |||
2064013 | 2064013 | 2022-11-19 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-20 04:21:08 | Zacatecas, Mexico | |||
1755407 | 1755407 | 2022-11-18 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-19 04:21:14 | Zacatecas, Mexico | |||
3026400 | 3026400 | 2022-11-17 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-18 04:21:15 | Zacatecas, Mexico | |||
2486111 | 2486111 | 2022-11-16 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-17 04:21:11 | Zacatecas, Mexico | |||
292122 | 292122 | 2022-11-15 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-16 04:21:09 | Zacatecas, Mexico | |||
3597152 | 3597152 | 2022-11-14 | Mexico | Zacatecas | 79928 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-15 04:21:16 | Zacatecas, Mexico | |||
312010 | 312010 | 2022-11-13 | Mexico | Zacatecas | 79907 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-14 04:21:09 | Zacatecas, Mexico | |||
63171 | 63171 | 2022-11-12 | Mexico | Zacatecas | 79907 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-13 04:21:14 | Zacatecas, Mexico | |||
2927333 | 2927333 | 2022-11-11 | Mexico | Zacatecas | 79907 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-12 04:20:41 | Zacatecas, Mexico | |||
2506169 | 2506169 | 2022-11-10 | Mexico | Zacatecas | 79907 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-11 04:21:22 | Zacatecas, Mexico | |||
2431044 | 2431044 | 2022-11-09 | Mexico | Zacatecas | 79900 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-10 04:21:16 | Zacatecas, Mexico | |||
479700 | 479700 | 2022-11-08 | Mexico | Zacatecas | 79881 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-09 04:21:22 | Zacatecas, Mexico | |||
2438850 | 2438850 | 2022-11-07 | Mexico | Zacatecas | 79881 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-08 04:21:21 | Zacatecas, Mexico | |||
1049948 | 1049948 | 2022-11-06 | Mexico | Zacatecas | 79864 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-07 04:21:26 | Zacatecas, Mexico | |||
617972 | 617972 | 2022-11-05 | Mexico | Zacatecas | 79864 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-06 04:21:24 | Zacatecas, Mexico | |||
1022476 | 1022476 | 2022-11-04 | Mexico | Zacatecas | 79864 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-05 04:21:52 | Zacatecas, Mexico | |||
431467 | 431467 | 2022-11-03 | Mexico | Zacatecas | 79845 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-04 04:22:11 | Zacatecas, Mexico | |||
849709 | 849709 | 2022-11-02 | Mexico | Zacatecas | 79845 | 3925 | 0 | 22.7709 | -102.5832 | 2022-11-03 04:22:05 | Zacatecas, Mexico | |||
710560 | 710560 | 2022-11-01 | Mexico | Zacatecas | 79821 | 3924 | 0 | 22.7709 | -102.5832 | 2022-11-02 04:22:09 | Zacatecas, Mexico | |||
3285009 | 3285009 | 2022-10-31 | Mexico | Zacatecas | 79821 | 3924 | 0 | 22.7709 | -102.5832 | 2022-11-01 04:22:36 | Zacatecas, Mexico | |||
320042 | 320042 | 2022-10-30 | Mexico | Zacatecas | 79821 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-31 04:21:36 | Zacatecas, Mexico | |||
912318 | 912318 | 2022-10-29 | Mexico | Zacatecas | 79808 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-30 04:22:14 | Zacatecas, Mexico | |||
1366587 | 1366587 | 2022-10-28 | Mexico | Zacatecas | 79808 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-29 04:21:13 | Zacatecas, Mexico | |||
3038442 | 3038442 | 2022-10-27 | Mexico | Zacatecas | 79808 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-28 04:22:31 | Zacatecas, Mexico | |||
538862 | 538862 | 2022-10-26 | Mexico | Zacatecas | 79808 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-27 04:22:01 | Zacatecas, Mexico | |||
1830263 | 1830263 | 2022-10-25 | Mexico | Zacatecas | 79894 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-26 04:22:19 | Zacatecas, Mexico | |||
794524 | 794524 | 2022-10-24 | Mexico | Zacatecas | 79891 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-25 04:21:53 | Zacatecas, Mexico | |||
3276979 | 3276979 | 2022-10-23 | Mexico | Zacatecas | 79891 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-24 04:22:29 | Zacatecas, Mexico | |||
2268017 | 2268017 | 2022-10-22 | Mexico | Zacatecas | 79886 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-23 04:22:46 | Zacatecas, Mexico | |||
1592317 | 1592317 | 2022-10-21 | Mexico | Zacatecas | 79886 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-22 04:22:53 | Zacatecas, Mexico | |||
2272033 | 2272033 | 2022-10-20 | Mexico | Zacatecas | 79947 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-21 04:22:23 | Zacatecas, Mexico | |||
198368 | 198368 | 2022-10-19 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-20 04:22:59 | Zacatecas, Mexico | |||
2757029 | 2757029 | 2022-10-18 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-19 04:22:26 | Zacatecas, Mexico | |||
2024863 | 2024863 | 2022-10-17 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-18 04:22:42 | Zacatecas, Mexico | |||
2159641 | 2159641 | 2022-10-16 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-17 04:20:31 | Zacatecas, Mexico | |||
515838 | 515838 | 2022-10-15 | Mexico | Zacatecas | 79938 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-16 04:22:39 | Zacatecas, Mexico | |||
2032895 | 2032895 | 2022-10-14 | Mexico | Zacatecas | 79930 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-15 04:22:00 | Zacatecas, Mexico | |||
3753583 | 3753583 | 2022-10-13 | Mexico | Zacatecas | 79930 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-14 04:22:28 | Zacatecas, Mexico | |||
3214408 | 3214408 | 2022-10-12 | Mexico | Zacatecas | 79923 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-13 04:22:39 | Zacatecas, Mexico | |||
3250257 | 3250257 | 2022-10-11 | Mexico | Zacatecas | 79914 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-12 04:22:51 | Zacatecas, Mexico | |||
2967516 | 2967516 | 2022-10-10 | Mexico | Zacatecas | 79903 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-11 04:23:05 | Zacatecas, Mexico | |||
3097552 | 3097552 | 2022-10-09 | Mexico | Zacatecas | 79903 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-10 04:22:32 | Zacatecas, Mexico | |||
4002777 | 4002777 | 2022-10-08 | Mexico | Zacatecas | 79884 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-09 04:21:16 | Zacatecas, Mexico | |||
396374 | 396374 | 2022-10-07 | Mexico | Zacatecas | 79884 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-08 04:22:56 | Zacatecas, Mexico | |||
2529491 | 2529491 | 2022-10-06 | Mexico | Zacatecas | 79845 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-07 04:23:08 | Zacatecas, Mexico | |||
1810885 | 1810885 | 2022-10-05 | Mexico | Zacatecas | 79845 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-06 04:21:22 | Zacatecas, Mexico | |||
130859 | 130859 | 2022-10-04 | Mexico | Zacatecas | 79845 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-05 04:23:06 | Zacatecas, Mexico | |||
2685806 | 2685806 | 2022-10-03 | Mexico | Zacatecas | 79845 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-04 04:22:55 | Zacatecas, Mexico | |||
2259873 | 2259873 | 2022-10-02 | Mexico | Zacatecas | 79837 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-03 04:23:11 | Zacatecas, Mexico | |||
2995399 | 2995399 | 2022-10-01 | Mexico | Zacatecas | 79837 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-02 04:21:23 | Zacatecas, Mexico | |||
853725 | 853725 | 2022-09-30 | Mexico | Zacatecas | 79814 | 3924 | 0 | 22.7709 | -102.5832 | 2022-10-01 04:23:01 | Zacatecas, Mexico | |||
2375651 | 2375651 | 2022-09-29 | Mexico | Zacatecas | 79793 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-30 04:23:09 | Zacatecas, Mexico | |||
1560202 | 1560202 | 2022-09-28 | Mexico | Zacatecas | 79709 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-29 04:22:34 | Zacatecas, Mexico | |||
3994745 | 3994745 | 2022-09-27 | Mexico | Zacatecas | 79709 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-28 04:23:01 | Zacatecas, Mexico | |||
2769073 | 2769073 | 2022-09-26 | Mexico | Zacatecas | 79709 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-27 04:23:01 | Zacatecas, Mexico | |||
1976726 | 1976726 | 2022-09-25 | Mexico | Zacatecas | 79701 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-26 04:20:52 | Zacatecas, Mexico | |||
2649893 | 2649893 | 2022-09-24 | Mexico | Zacatecas | 79701 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-25 04:23:31 | Zacatecas, Mexico | |||
384333 | 384333 | 2022-09-23 | Mexico | Zacatecas | 79673 | 3924 | 0 | 22.7709 | -102.5832 | 2022-09-24 04:21:40 | Zacatecas, Mexico | |||
1624399 | 1624399 | 2022-09-22 | Mexico | Zacatecas | 79615 | 3923 | 0 | 22.7709 | -102.5832 | 2022-09-23 04:23:13 | Zacatecas, Mexico | |||
1370603 | 1370603 | 2022-09-21 | Mexico | Zacatecas | 79615 | 3923 | 0 | 22.7709 | -102.5832 | 2022-09-22 04:22:56 | Zacatecas, 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]);