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 = "Nayarit" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687574 | 3687574 | 2022-01-13 | Mexico | Nayarit | 38385 | 2926 | 0 | 21.7514 | -104.8455 | 2022-01-14 04:21:54 | Nayarit, Mexico | |||
3613158 | 3613158 | 2022-01-12 | Mexico | Nayarit | 37598 | 2925 | 0 | 21.7514 | -104.8455 | 2022-01-13 08:00:09 | Nayarit, Mexico | |||
1113683 | 1113683 | 2022-01-11 | Mexico | Nayarit | 36893 | 2924 | 0 | 21.7514 | -104.8455 | 2022-01-12 04:21:44 | Nayarit, Mexico | |||
1692411 | 1692411 | 2022-01-10 | Mexico | Nayarit | 36329 | 2921 | 0 | 21.7514 | -104.8455 | 2022-01-11 04:22:01 | Nayarit, Mexico | |||
126826 | 126826 | 2022-01-09 | Mexico | Nayarit | 36329 | 2921 | 0 | 21.7514 | -104.8455 | 2022-01-10 04:22:07 | Nayarit, Mexico | |||
1215661 | 1215661 | 2022-01-08 | Mexico | Nayarit | 36269 | 2921 | 0 | 21.7514 | -104.8455 | 2022-01-09 04:21:46 | Nayarit, Mexico | |||
1389754 | 1389754 | 2022-01-07 | Mexico | Nayarit | 35767 | 2920 | 0 | 21.7514 | -104.8455 | 2022-01-08 04:21:53 | Nayarit, Mexico | |||
2610141 | 2610141 | 2022-01-06 | Mexico | Nayarit | 35392 | 2919 | 0 | 21.7514 | -104.8455 | 2022-01-07 04:22:09 | Nayarit, Mexico | |||
1282083 | 1282083 | 2022-01-05 | Mexico | Nayarit | 35107 | 2916 | 0 | 21.7514 | -104.8455 | 2022-01-06 04:22:09 | Nayarit, Mexico | |||
1286099 | 1286099 | 2022-01-04 | Mexico | Nayarit | 34911 | 2915 | 0 | 21.7514 | -104.8455 | 2022-01-05 04:21:59 | Nayarit, Mexico | |||
1700443 | 1700443 | 2022-01-03 | Mexico | Nayarit | 34745 | 2915 | 0 | 21.7514 | -104.8455 | 2022-01-04 04:22:17 | Nayarit, Mexico | |||
3519526 | 3519526 | 2022-01-02 | Mexico | Nayarit | 34740 | 2914 | 0 | 21.7514 | -104.8455 | 2022-01-03 02:22:25 | Nayarit, Mexico | |||
2167656 | 2167656 | 2022-01-01 | Mexico | Nayarit | 34738 | 2914 | 0 | 21.7514 | -104.8455 | 2022-01-02 04:20:52 | Nayarit, Mexico | |||
2777087 | 2777087 | 2021-12-31 | Mexico | Nayarit | 34693 | 2910 | 0 | 21.7514 | -104.8455 | 2022-01-01 04:22:14 | Nayarit, Mexico | |||
3998744 | 3998744 | 2021-12-30 | Mexico | Nayarit | 34592 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-31 04:21:50 | Nayarit, Mexico | |||
1668551 | 1668551 | 2021-12-29 | Mexico | Nayarit | 34564 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-30 04:21:25 | Nayarit, Mexico | |||
1432660 | 1432660 | 2021-12-28 | Mexico | Nayarit | 34532 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-29 03:21:43 | Nayarit, Mexico | |||
730621 | 730621 | 2021-12-27 | Mexico | Nayarit | 34529 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-28 04:21:47 | Nayarit, Mexico | |||
2111793 | 2111793 | 2021-12-26 | Mexico | Nayarit | 34527 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-27 04:21:58 | Nayarit, Mexico | |||
3605165 | 3605165 | 2021-12-25 | Mexico | Nayarit | 34527 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-26 04:21:50 | Nayarit, Mexico | |||
2963483 | 2963483 | 2021-12-24 | Mexico | Nayarit | 34516 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-25 04:21:37 | Nayarit, Mexico | |||
3816515 | 3816515 | 2021-12-23 | Mexico | Nayarit | 34494 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-24 04:21:34 | Nayarit, Mexico | |||
798523 | 798523 | 2021-12-22 | Mexico | Nayarit | 34481 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-23 04:21:21 | Nayarit, Mexico | |||
3828563 | 3828563 | 2021-12-21 | Mexico | Nayarit | 34444 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-22 04:21:54 | Nayarit, Mexico | |||
1254866 | 1254866 | 2021-12-20 | Mexico | Nayarit | 34444 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-21 03:21:27 | Nayarit, Mexico | |||
2903809 | 2903809 | 2021-12-19 | Mexico | Nayarit | 34440 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-20 04:21:43 | Nayarit, Mexico | |||
1258882 | 1258882 | 2021-12-18 | Mexico | Nayarit | 34425 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-19 04:21:11 | Nayarit, Mexico | |||
2398910 | 2398910 | 2021-12-17 | Mexico | Nayarit | 34406 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-18 02:22:20 | Nayarit, Mexico | |||
1716448 | 1716448 | 2021-12-16 | Mexico | Nayarit | 34406 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-17 04:22:14 | Nayarit, Mexico | |||
3496282 | 3496282 | 2021-12-15 | Mexico | Nayarit | 34398 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-16 04:22:11 | Nayarit, Mexico | |||
2088067 | 2088067 | 2021-12-14 | Mexico | Nayarit | 34358 | 2906 | 0 | 21.7514 | -104.8455 | 2021-12-15 03:22:16 | Nayarit, Mexico | |||
782484 | 782484 | 2021-12-13 | Mexico | Nayarit | 34355 | 2906 | 0 | 21.7514 | -104.8455 | 2021-12-14 04:22:38 | Nayarit, Mexico | |||
1660519 | 1660519 | 2021-12-12 | Mexico | Nayarit | 34354 | 2906 | 0 | 21.7514 | -104.8455 | 2021-12-13 04:22:02 | Nayarit, Mexico | |||
1664535 | 1664535 | 2021-12-11 | Mexico | Nayarit | 34339 | 2884 | 0 | 21.7514 | -104.8455 | 2021-12-12 04:22:12 | Nayarit, Mexico | |||
3655687 | 3655687 | 2021-12-10 | Mexico | Nayarit | 34324 | 2880 | 0 | 21.7514 | -104.8455 | 2021-12-11 04:22:45 | Nayarit, Mexico | |||
1078018 | 1078018 | 2021-12-09 | Mexico | Nayarit | 34324 | 2880 | 0 | 21.7514 | -104.8455 | 2021-12-10 04:22:28 | Nayarit, Mexico | |||
550867 | 550867 | 2021-12-08 | Mexico | Nayarit | 34292 | 2879 | 0 | 21.7514 | -104.8455 | 2021-12-09 04:22:49 | Nayarit, Mexico | |||
404387 | 404387 | 2021-12-07 | Mexico | Nayarit | 34278 | 2879 | 0 | 21.7514 | -104.8455 | 2021-12-08 04:22:46 | Nayarit, Mexico | |||
1030469 | 1030469 | 2021-12-06 | Mexico | Nayarit | 34278 | 2879 | 0 | 21.7514 | -104.8455 | 2021-12-07 04:22:34 | Nayarit, Mexico | |||
1740632 | 1740632 | 2021-12-05 | Mexico | Nayarit | 34275 | 2878 | 0 | 21.7514 | -104.8455 | 2021-12-06 04:22:34 | Nayarit, Mexico | |||
138064 | 138064 | 2021-12-04 | Mexico | Nayarit | 34253 | 2876 | 0 | 21.7514 | -104.8455 | 2021-12-05 04:22:25 | Nayarit, Mexico | |||
2195717 | 2195717 | 2021-12-03 | Mexico | Nayarit | 34253 | 2876 | 0 | 21.7514 | -104.8455 | 2021-12-04 04:22:18 | Nayarit, Mexico | |||
423 | 423 | 2021-12-02 | Mexico | Nayarit | 34216 | 2871 | 0 | 21.7514 | -104.8455 | 2021-12-03 04:23:05 | Nayarit, Mexico | |||
1145022 | 1145022 | 2021-12-01 | Mexico | Nayarit | 34216 | 2871 | 0 | 21.7514 | -104.8455 | 2021-12-02 04:22:37 | Nayarit, Mexico | |||
3401534 | 3401534 | 2021-11-30 | Mexico | Nayarit | 34193 | 2865 | 0 | 21.7514 | -104.8455 | 2021-12-01 04:22:29 | Nayarit, Mexico | |||
150077 | 150077 | 2021-11-29 | Mexico | Nayarit | 34193 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-30 04:22:53 | Nayarit, Mexico | |||
1231723 | 1231723 | 2021-11-28 | Mexico | Nayarit | 34188 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-29 04:22:30 | Nayarit, Mexico | |||
1358430 | 1358430 | 2021-11-27 | Mexico | Nayarit | 34176 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-28 04:22:43 | Nayarit, Mexico | |||
758421 | 758421 | 2021-11-26 | Mexico | Nayarit | 34176 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-27 04:22:45 | Nayarit, Mexico | |||
1802838 | 1802838 | 2021-11-25 | Mexico | Nayarit | 34167 | 2864 | 0 | 21.7514 | -104.8455 | 2021-11-26 04:22:33 | Nayarit, Mexico | |||
904272 | 904272 | 2021-11-24 | Mexico | Nayarit | 34137 | 2859 | 0 | 21.7514 | -104.8455 | 2021-11-25 04:22:33 | Nayarit, Mexico | |||
3070122 | 3070122 | 2021-11-23 | Mexico | Nayarit | 34108 | 2853 | 0 | 21.7514 | -104.8455 | 2021-11-24 04:22:14 | Nayarit, Mexico | |||
3749220 | 3749220 | 2021-11-22 | Mexico | Nayarit | 34108 | 2853 | 0 | 21.7514 | -104.8455 | 2021-11-23 04:22:39 | Nayarit, Mexico | |||
1014427 | 1014427 | 2021-11-21 | Mexico | Nayarit | 34106 | 2852 | 0 | 21.7514 | -104.8455 | 2021-11-22 04:22:20 | Nayarit, Mexico | |||
722591 | 722591 | 2021-11-20 | Mexico | Nayarit | 34095 | 2849 | 0 | 21.7514 | -104.8455 | 2021-11-21 04:22:13 | Nayarit, Mexico | |||
162121 | 162121 | 2021-11-19 | Mexico | Nayarit | 34079 | 2848 | 0 | 21.7514 | -104.8455 | 2021-11-20 04:22:17 | Nayarit, Mexico | |||
3289008 | 3289008 | 2021-11-18 | Mexico | Nayarit | 34079 | 2848 | 0 | 21.7514 | -104.8455 | 2021-11-19 04:21:40 | Nayarit, Mexico | |||
447464 | 447464 | 2021-11-17 | Mexico | Nayarit | 34058 | 2846 | 0 | 21.7514 | -104.8455 | 2021-11-18 04:21:33 | Nayarit, Mexico | |||
3342714 | 3342714 | 2021-11-16 | Mexico | Nayarit | 34029 | 2845 | 0 | 21.7514 | -104.8455 | 2021-11-17 04:21:48 | Nayarit, Mexico | |||
2287550 | 2287550 | 2021-11-15 | Mexico | Nayarit | 34028 | 2844 | 0 | 21.7514 | -104.8455 | 2021-11-16 04:21:10 | Nayarit, Mexico | |||
1322324 | 1322324 | 2021-11-14 | Mexico | Nayarit | 34027 | 2844 | 0 | 21.7514 | -104.8455 | 2021-11-15 04:21:36 | Nayarit, Mexico | |||
686450 | 686450 | 2021-11-13 | Mexico | Nayarit | 34008 | 2844 | 0 | 21.7514 | -104.8455 | 2021-11-14 04:21:31 | Nayarit, Mexico | |||
714559 | 714559 | 2021-11-12 | Mexico | Nayarit | 34009 | 2842 | 0 | 21.7514 | -104.8455 | 2021-11-13 04:21:38 | Nayarit, Mexico | |||
28509 | 28509 | 2021-11-11 | Mexico | Nayarit | 34009 | 2842 | 0 | 21.7514 | -104.8455 | 2021-11-12 04:22:01 | Nayarit, Mexico | |||
2844948 | 2844948 | 2021-11-10 | Mexico | Nayarit | 34000 | 2836 | 0 | 21.7514 | -104.8455 | 2021-11-11 04:21:45 | Nayarit, Mexico | |||
87218 | 87218 | 2021-11-09 | Mexico | Nayarit | 34000 | 2836 | 0 | 21.7514 | -104.8455 | 2021-11-10 04:21:38 | Nayarit, Mexico | |||
3639646 | 3639646 | 2021-11-08 | Mexico | Nayarit | 33991 | 2832 | 0 | 21.7514 | -104.8455 | 2021-11-09 04:21:36 | Nayarit, Mexico | |||
2000754 | 2000754 | 2021-11-07 | Mexico | Nayarit | 33991 | 2832 | 0 | 21.7514 | -104.8455 | 2021-11-08 04:21:43 | Nayarit, Mexico | |||
495745 | 495745 | 2021-11-06 | Mexico | Nayarit | 33990 | 2832 | 0 | 21.7514 | -104.8455 | 2021-11-07 04:21:53 | Nayarit, Mexico | |||
3121600 | 3121600 | 2021-11-05 | Mexico | Nayarit | 34015 | 2818 | 0 | 21.7514 | -104.8455 | 2021-11-06 04:21:51 | Nayarit, Mexico | |||
698498 | 698498 | 2021-11-04 | Mexico | Nayarit | 33997 | 2813 | 0 | 21.7514 | -104.8455 | 2021-11-05 04:21:54 | Nayarit, Mexico | |||
276276 | 276276 | 2021-11-03 | Mexico | Nayarit | 33974 | 2813 | 0 | 21.7514 | -104.8455 | 2021-11-04 04:22:20 | Nayarit, Mexico | |||
43801 | 43801 | 2021-11-02 | Mexico | Nayarit | 33946 | 2803 | 0 | 21.7514 | -104.8455 | 2021-11-03 06:22:09 | Nayarit, Mexico | |||
3511497 | 3511497 | 2021-11-01 | Mexico | Nayarit | 33940 | 2803 | 0 | 21.7514 | -104.8455 | 2021-11-02 04:22:03 | Nayarit, Mexico | |||
288089 | 288089 | 2021-10-31 | Mexico | Nayarit | 33940 | 2803 | 0 | 21.7514 | -104.8455 | 2021-11-01 04:22:01 | Nayarit, Mexico | |||
2721095 | 2721095 | 2021-10-30 | Mexico | Nayarit | 33937 | 2801 | 0 | 21.7514 | -104.8455 | 2021-10-31 04:22:08 | Nayarit, Mexico | |||
567197 | 567197 | 2021-10-29 | Mexico | Nayarit | 33913 | 2795 | 0 | 21.7514 | -104.8455 | 2021-10-30 04:22:03 | Nayarit, Mexico | |||
4439 | 4439 | 2021-10-28 | Mexico | Nayarit | 33888 | 2793 | 0 | 21.7514 | -104.8455 | 2021-10-29 04:22:03 | Nayarit, Mexico | |||
534829 | 534829 | 2021-10-27 | Mexico | Nayarit | 33810 | 2785 | 0 | 21.7514 | -104.8455 | 2021-10-28 04:22:08 | Nayarit, Mexico | |||
3492266 | 3492266 | 2021-10-26 | Mexico | Nayarit | 33783 | 2781 | 0 | 21.7514 | -104.8455 | 2021-10-27 04:22:32 | Nayarit, Mexico | |||
3793988 | 3793988 | 2021-10-25 | Mexico | Nayarit | 33783 | 2781 | 0 | 21.7514 | -104.8455 | 2021-10-26 04:22:09 | Nayarit, Mexico | |||
682434 | 682434 | 2021-10-24 | Mexico | Nayarit | 33772 | 2778 | 0 | 21.7514 | -104.8455 | 2021-10-25 04:22:31 | Nayarit, Mexico | |||
770442 | 770442 | 2021-10-23 | Mexico | Nayarit | 33772 | 2778 | 0 | 21.7514 | -104.8455 | 2021-10-24 04:21:22 | Nayarit, Mexico | |||
654089 | 654089 | 2021-10-22 | Mexico | Nayarit | 33735 | 2777 | 0 | 21.7514 | -104.8455 | 2021-10-23 04:21:32 | Nayarit, Mexico | |||
2123836 | 2123836 | 2021-10-21 | Mexico | Nayarit | 33709 | 2774 | 0 | 21.7514 | -104.8455 | 2021-10-22 04:21:14 | Nayarit, Mexico | |||
443448 | 443448 | 2021-10-20 | Mexico | Nayarit | 33678 | 2766 | 0 | 21.7514 | -104.8455 | 2021-10-21 04:21:18 | Nayarit, Mexico | |||
597767 | 597767 | 2021-10-19 | Mexico | Nayarit | 33645 | 2759 | 0 | 21.7514 | -104.8455 | 2021-10-20 04:21:00 | Nayarit, Mexico | |||
2043944 | 2043944 | 2021-10-18 | Mexico | Nayarit | 33589 | 2748 | 0 | 21.7514 | -104.8455 | 2021-10-19 04:20:54 | Nayarit, Mexico | |||
1909305 | 1909305 | 2021-10-17 | Mexico | Nayarit | 33577 | 2748 | 0 | 21.7514 | -104.8455 | 2021-10-18 04:21:10 | Nayarit, Mexico | |||
934894 | 934894 | 2021-10-16 | Mexico | Nayarit | 33568 | 2747 | 0 | 21.7514 | -104.8455 | 2021-10-17 04:21:29 | Nayarit, Mexico | |||
2943449 | 2943449 | 2021-10-15 | Mexico | Nayarit | 33528 | 2728 | 0 | 21.7514 | -104.8455 | 2021-10-16 04:21:15 | Nayarit, Mexico | |||
491729 | 491729 | 2021-10-14 | Mexico | Nayarit | 33483 | 2725 | 0 | 21.7514 | -104.8455 | 2021-10-15 04:21:26 | Nayarit, Mexico | |||
634017 | 634017 | 2021-10-13 | Mexico | Nayarit | 33449 | 2722 | 0 | 21.7514 | -104.8455 | 2021-10-14 04:21:29 | Nayarit, Mexico | |||
1491695 | 1491695 | 2021-10-12 | Mexico | Nayarit | 33384 | 2722 | 0 | 21.7514 | -104.8455 | 2021-10-13 04:20:51 | Nayarit, Mexico | |||
3007428 | 3007428 | 2021-10-11 | Mexico | Nayarit | 33325 | 2714 | 0 | 21.7514 | -104.8455 | 2021-10-12 04:21:09 | Nayarit, Mexico | |||
423444 | 423444 | 2021-10-10 | Mexico | Nayarit | 33314 | 2713 | 0 | 21.7514 | -104.8455 | 2021-10-11 04:21:31 | Nayarit, Mexico | |||
2876301 | 2876301 | 2021-10-09 | Mexico | Nayarit | 33248 | 2708 | 0 | 21.7514 | -104.8455 | 2021-10-10 04:21:38 | Nayarit, Mexico | |||
2959467 | 2959467 | 2021-10-08 | Mexico | Nayarit | 33248 | 2708 | 0 | 21.7514 | -104.8455 | 2021-10-09 04:21:34 | Nayarit, Mexico | |||
467505 | 467505 | 2021-10-07 | Mexico | Nayarit | 33190 | 2707 | 0 | 21.7514 | -104.8455 | 2021-10-08 04:21:25 | Nayarit, Mexico | |||
2458885 | 2458885 | 2021-10-06 | Mexico | Nayarit | 33064 | 2693 | 0 | 21.7514 | -104.8455 | 2021-10-07 04:21:36 | Nayarit, 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]);