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 = "Sonora" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026450 | 1026450 | 2020-10-17 | Mexico | Sonora | 36359 | 3059 | 32444 | 856 | 29.2972 | -110.3309 | 2020-10-18 04:24:25 | Sonora, Mexico | ||
2856945 | 2856945 | 2020-10-16 | Mexico | Sonora | 36229 | 3054 | 32346 | 829 | 29.2972 | -110.3309 | 2020-10-17 04:24:12 | Sonora, Mexico | ||
786475 | 786475 | 2020-10-15 | Mexico | Sonora | 35949 | 3042 | 32106 | 801 | 29.2972 | -110.3309 | 2020-10-16 04:24:01 | Sonora, Mexico | ||
79186 | 79186 | 2020-10-14 | Mexico | Sonora | 35836 | 3033 | 32025 | 778 | 29.2972 | -110.3309 | 2020-10-15 04:24:28 | Sonora, Mexico | ||
3782001 | 3782001 | 2020-10-13 | Mexico | Sonora | 35727 | 3029 | 31959 | 739 | 29.2972 | -110.3309 | 2020-10-14 04:24:05 | Sonora, Mexico | ||
2291541 | 2291541 | 2020-10-12 | Mexico | Sonora | 35593 | 3017 | 31837 | 739 | 29.2972 | -110.3309 | 2020-10-13 04:24:02 | Sonora, Mexico | ||
3785994 | 3785994 | 2020-10-11 | Mexico | Sonora | 35501 | 3012 | 31672 | 817 | 29.2972 | -110.3309 | 2020-10-12 04:23:45 | Sonora, Mexico | ||
2602132 | 2602132 | 2020-10-10 | Mexico | Sonora | 35397 | 3010 | 31559 | 828 | 29.2972 | -110.3309 | 2020-10-11 04:23:46 | Sonora, Mexico | ||
817665 | 817665 | 2020-10-09 | Mexico | Sonora | 35177 | 3005 | 31400 | 772 | 29.2972 | -110.3309 | 2020-10-10 04:23:57 | Sonora, Mexico | ||
2689780 | 2689780 | 2020-10-08 | Mexico | Sonora | 35005 | 3000 | 31153 | 852 | 29.2972 | -110.3309 | 2020-10-09 04:23:59 | Sonora, Mexico | ||
1041922 | 1041922 | 2020-10-07 | Mexico | Sonora | 34869 | 2988 | 31122 | 759 | 29.2972 | -110.3309 | 2020-10-08 04:23:56 | Sonora, Mexico | ||
3117583 | 3117583 | 2020-10-06 | Mexico | Sonora | 34738 | 2987 | 30978 | 773 | 29.2972 | -110.3309 | 2020-10-07 04:23:40 | Sonora, Mexico | ||
3801995 | 3801995 | 2020-10-05 | Mexico | Sonora | 34581 | 2963 | 30826 | 792 | 29.2972 | -110.3309 | 2020-10-06 04:23:33 | Sonora, Mexico | ||
1822885 | 1822885 | 2020-10-04 | Mexico | Sonora | 24972 | 2925 | 21329 | 718 | 29.2972 | -110.3309 | 2020-10-05 04:23:33 | Sonora, Mexico | ||
2514269 | 2514269 | 2020-10-03 | Mexico | Sonora | 24925 | 2918 | 21188 | 819 | 29.2972 | -110.3309 | 2020-10-04 04:23:44 | Sonora, Mexico | ||
3389487 | 3389487 | 2020-10-02 | Mexico | Sonora | 24788 | 2914 | 21029 | 845 | 29.2972 | -110.3309 | 2020-10-03 04:23:40 | Sonora, Mexico | ||
2379728 | 2379728 | 2020-10-01 | Mexico | Sonora | 24728 | 2904 | 21029 | 795 | 29.2972 | -110.3309 | 2020-10-02 04:23:51 | Sonora, Mexico | ||
1045914 | 1045914 | 2020-09-30 | Mexico | Sonora | 24684 | 2899 | 21057 | 728 | 29.2972 | -110.3309 | 2020-10-01 04:23:42 | Sonora, Mexico | ||
966995 | 966995 | 2020-09-29 | Mexico | Sonora | 24525 | 2897 | 20984 | 644 | 29.2972 | -110.3309 | 2020-09-30 04:23:33 | Sonora, Mexico | ||
1515492 | 1515492 | 2020-09-28 | Mexico | Sonora | 24418 | 2886 | 20778 | 754 | 29.2972 | -110.3309 | 2020-09-29 04:23:42 | Sonora, Mexico | ||
2582080 | 2582080 | 2020-09-27 | Mexico | Sonora | 24401 | 2884 | 20702 | 815 | 29.2972 | -110.3309 | 2020-09-28 04:23:00 | Sonora, Mexico | ||
2614132 | 2614132 | 2020-09-26 | Mexico | Sonora | 24382 | 2883 | 20668 | 831 | 29.2972 | -110.3309 | 2020-09-27 04:23:00 | Sonora, Mexico | ||
2812847 | 2812847 | 2020-09-25 | Mexico | Sonora | 24238 | 2879 | 20665 | 694 | 29.2972 | -110.3309 | 2020-09-26 04:23:00 | Sonora, Mexico | ||
2606124 | 2606124 | 2020-09-24 | Mexico | Sonora | 24148 | 2873 | 20682 | 593 | 29.2972 | -110.3309 | 2020-09-25 04:23:00 | Sonora, Mexico | ||
2653867 | 2653867 | 2020-09-23 | Mexico | Sonora | 24103 | 2868 | 20594 | 641 | 29.2972 | -110.3309 | 2020-09-24 04:23:00 | Sonora, Mexico | ||
3316316 | 3316316 | 2020-09-22 | Mexico | Sonora | 24006 | 2850 | 20535 | 621 | 29.2972 | -110.3309 | 2020-09-23 04:23:00 | Sonora, Mexico | ||
2836915 | 2836915 | 2020-09-21 | Mexico | Sonora | 23923 | 2837 | 20501 | 585 | 29.2972 | -110.3309 | 2020-09-22 04:23:00 | Sonora, Mexico | ||
3093519 | 3093519 | 2020-09-20 | Mexico | Sonora | 23861 | 2832 | 20387 | 642 | 29.2972 | -110.3309 | 2020-09-21 04:23:00 | Sonora, Mexico | ||
2454869 | 2454869 | 2020-09-19 | Mexico | Sonora | 23749 | 2827 | 20240 | 682 | 29.2972 | -110.3309 | 2020-09-20 04:22:00 | Sonora, Mexico | ||
2848938 | 2848938 | 2020-09-18 | Mexico | Sonora | 23677 | 2817 | 20131 | 729 | 29.2972 | -110.3309 | 2020-09-19 04:22:00 | Sonora, Mexico | ||
1121687 | 1121687 | 2020-09-17 | Mexico | Sonora | 23495 | 2814 | 20053 | 628 | 29.2972 | -110.3309 | 2020-09-18 05:05:00 | Sonora, Mexico | ||
666376 | 666376 | 2020-09-16 | Mexico | Sonora | 23445 | 2812 | 19939 | 694 | 29.2972 | -110.3309 | 2020-09-17 04:22:00 | Sonora, Mexico | ||
2729101 | 2729101 | 2020-09-15 | Mexico | Sonora | 23350 | 2810 | 19820 | 720 | 29.2972 | -110.3309 | 2020-09-16 04:22:53 | Sonora, Mexico | ||
344373 | 344373 | 2020-09-14 | Mexico | Sonora | 23275 | 2806 | 19721 | 748 | 29.2972 | -110.3309 | 2020-09-15 03:22:50 | Sonora, Mexico | ||
2868812 | 2868812 | 2020-09-13 | Mexico | Sonora | 23160 | 2804 | 19505 | 851 | 29.2972 | -110.3309 | 2020-09-14 04:26:00 | Sonora, Mexico | ||
546851 | 546851 | 2020-09-12 | Mexico | Sonora | 23057 | 2803 | 19357 | 897 | 29.2972 | -110.3309 | 2020-09-13 04:30:52 | Sonora, Mexico | ||
1444680 | 1444680 | 2020-09-11 | Mexico | Sonora | 22873 | 2794 | 19246 | 833 | 29.2972 | -110.3309 | 2020-09-12 04:25:05 | Sonora, Mexico | ||
1173281 | 1173281 | 2020-09-10 | Mexico | Sonora | 22716 | 2778 | 19067 | 871 | 29.2972 | -110.3309 | 2020-09-11 04:46:23 | Sonora, Mexico | ||
2171646 | 2171646 | 2020-09-09 | Mexico | Sonora | 22601 | 2771 | 19043 | 787 | 29.2972 | -110.3309 | 2020-09-10 04:29:01 | Sonora, Mexico | ||
1243855 | 1243855 | 2020-09-08 | Mexico | Sonora | 22540 | 2755 | 19036 | 749 | 29.2972 | -110.3309 | 2020-09-09 04:28:48 | Sonora, Mexico | ||
427434 | 427434 | 2020-09-07 | Mexico | Sonora | 22307 | 2699 | 18878 | 730 | 29.2972 | -110.3309 | 2020-09-08 04:28:25 | Sonora, Mexico | ||
3161719 | 3161719 | 2020-09-06 | Mexico | Sonora | 22275 | 2697 | 18758 | 820 | 29.2972 | -110.3309 | 2020-09-07 04:28:30 | Sonora, Mexico | ||
813674 | 813674 | 2020-09-05 | Mexico | Sonora | 22163 | 2693 | 18593 | 877 | 29.2972 | -110.3309 | 2020-09-06 04:28:33 | Sonora, Mexico | ||
2661874 | 2661874 | 2020-09-04 | Mexico | Sonora | 21923 | 2681 | 18395 | 847 | 29.2972 | -110.3309 | 2020-09-05 04:28:19 | Sonora, Mexico | ||
1354414 | 1354414 | 2020-09-03 | Mexico | Sonora | 21761 | 2678 | 18331 | 752 | 29.2972 | -110.3309 | 2020-09-04 04:28:26 | Sonora, Mexico | ||
1105651 | 1105651 | 2020-09-02 | Mexico | Sonora | 21713 | 2665 | 18243 | 805 | 29.2972 | -110.3309 | 2020-09-03 04:28:22 | Sonora, Mexico | ||
2059980 | 2059980 | 2020-09-01 | Mexico | Sonora | 21659 | 2657 | 18196 | 806 | 29.2972 | -110.3309 | 2020-09-02 04:28:25 | Sonora, Mexico | ||
194165 | 194165 | 2020-08-31 | Mexico | Sonora | 21433 | 2646 | 18034 | 753 | 29.2972 | -110.3309 | 2020-09-01 04:28:31 | Sonora, Mexico | ||
3932124 | 3932124 | 2020-08-30 | Mexico | Sonora | 21379 | 2643 | 17874 | 862 | 29.2972 | -110.3309 | 2020-08-31 04:28:27 | Sonora, Mexico | ||
609786 | 609786 | 2020-08-29 | Mexico | Sonora | 21331 | 2637 | 17830 | 864 | 29.2972 | -110.3309 | 2020-08-30 04:28:22 | Sonora, Mexico | ||
1523281 | 1523281 | 2020-08-28 | Mexico | Sonora | 21202 | 2621 | 17820 | 761 | 29.2972 | -110.3309 | 2020-08-29 04:28:19 | Sonora, Mexico | ||
2510282 | 2510282 | 2020-08-27 | Mexico | Sonora | 21110 | 2595 | 17681 | 834 | 29.2972 | -110.3309 | 2020-08-28 04:28:11 | Sonora, Mexico | ||
1996742 | 1996742 | 2020-08-26 | Mexico | Sonora | 21027 | 2579 | 17541 | 907 | 29.2972 | -110.3309 | 2020-08-27 04:28:15 | Sonora, Mexico | ||
3562666 | 3562666 | 2020-08-25 | Mexico | Sonora | 20915 | 2543 | 17620 | 752 | 29.2972 | -110.3309 | 2020-08-26 04:28:11 | Sonora, Mexico | ||
2991370 | 2991370 | 2020-08-24 | Mexico | Sonora | 20734 | 2518 | 17312 | 904 | 29.2972 | -110.3309 | 2020-08-25 04:28:02 | Sonora, Mexico | ||
2215765 | 2215765 | 2020-08-23 | Mexico | Sonora | 20705 | 2518 | 17223 | 964 | 29.2972 | -110.3309 | 2020-08-24 04:27:56 | Sonora, Mexico | ||
2299547 | 2299547 | 2020-08-22 | Mexico | Sonora | 20693 | 2512 | 17172 | 1009 | 29.2972 | -110.3309 | 2020-08-23 04:27:48 | Sonora, Mexico | ||
1479654 | 1479654 | 2020-08-21 | Mexico | Sonora | 20537 | 2478 | 17064 | 995 | 29.2972 | -110.3309 | 2020-08-22 04:27:49 | Sonora, Mexico | ||
3484403 | 3484403 | 2020-08-20 | Mexico | Sonora | 20385 | 2461 | 17146 | 778 | 29.2972 | -110.3309 | 2020-08-21 04:27:41 | Sonora, Mexico | ||
206352 | 206352 | 2020-08-19 | Mexico | Sonora | 20288 | 2444 | 17029 | 815 | 29.2972 | -110.3309 | 2020-08-20 04:27:43 | Sonora, Mexico | ||
3178106 | 3178106 | 2020-08-18 | Mexico | Sonora | 20280 | 2432 | 17023 | 825 | 29.2972 | -110.3309 | 2020-08-19 04:27:00 | Sonora, Mexico | ||
837710 | 837710 | 2020-08-17 | Mexico | Sonora | 20003 | 2411 | 16904 | 688 | 29.2972 | -110.3309 | 2020-08-18 04:27:56 | Sonora, Mexico | ||
1556068 | 1556068 | 2020-08-16 | Mexico | Sonora | 19972 | 2408 | 16777 | 787 | 29.2972 | -110.3309 | 2020-08-17 04:27:20 | Sonora, Mexico | ||
146070 | 146070 | 2020-08-15 | Mexico | Sonora | 19930 | 2402 | 16689 | 839 | 29.2972 | -110.3309 | 2020-08-16 04:27:42 | Sonora, Mexico | ||
1612345 | 1612345 | 2020-08-14 | Mexico | Sonora | 19744 | 2390 | 16431 | 923 | 29.2972 | -110.3309 | 2020-08-15 04:27:31 | Sonora, Mexico | ||
582929 | 582929 | 2020-08-13 | Mexico | Sonora | 19625 | 2381 | 16414 | 830 | 29.2972 | -110.3309 | 2020-08-14 04:51:19 | Sonora, Mexico | ||
3531548 | 3531548 | 2020-08-12 | Mexico | Sonora | 19531 | 2361 | 16279 | 891 | 29.2972 | -110.3309 | 2020-08-13 04:29:15 | Sonora, Mexico | ||
662396 | 662396 | 2020-08-11 | Mexico | Sonora | 19403 | 2344 | 16172 | 887 | 29.2972 | -110.3309 | 2020-08-12 04:27:29 | Sonora, Mexico | ||
1920586 | 1920586 | 2020-08-10 | Mexico | Sonora | 19123 | 2316 | 15900 | 907 | 29.2972 | -110.3309 | 2020-08-11 04:35:08 | Sonora, Mexico | ||
3923395 | 3923395 | 2020-08-09 | Mexico | Sonora | 19040 | 2295 | 15758 | 987 | 29.2972 | -110.3309 | 2020-08-10 04:34:55 | Sonora, Mexico | ||
371563 | 371563 | 2020-08-08 | Mexico | Sonora | 18987 | 2277 | 15655 | 1055 | 29.2972 | -110.3309 | 2020-08-09 04:34:54 | Sonora, Mexico | ||
458747 | 458747 | 2020-08-07 | Mexico | Sonora | 18835 | 2248 | 15496 | 1091 | 29.2972 | -110.3309 | 2020-08-08 04:34:53 | Sonora, Mexico | ||
3612432 | 3612432 | 2020-08-06 | Mexico | Sonora | 18597 | 2186 | 15382 | 1029 | 29.2972 | -110.3309 | 2020-08-07 04:35:11 | Sonora, Mexico | ||
3793262 | 3793262 | 2020-08-05 | Mexico | Sonora | 18448 | 2124 | 15444 | 880 | 29.2972 | -110.3309 | 2020-08-06 04:35:02 | Sonora, Mexico | ||
98498 | 98498 | 2020-08-04 | Mexico | Sonora | 18238 | 2065 | 15283 | 890 | 29.2972 | -110.3309 | 2020-08-05 04:34:43 | Sonora, Mexico | ||
2740381 | 2740381 | 2020-08-03 | Mexico | Sonora | 17953 | 2001 | 15111 | 841 | 29.2972 | -110.3309 | 2020-08-04 04:41:59 | Sonora, Mexico | ||
2808133 | 2808133 | 2020-08-02 | Mexico | Sonora | 17951 | 1988 | 15019 | 944 | 29.2972 | -110.3309 | 2020-08-03 04:34:35 | Sonora, Mexico | ||
753701 | 753701 | 2020-08-01 | Mexico | Sonora | 17890 | 1974 | 14902 | 1014 | 29.2972 | -110.3309 | 2020-08-02 04:34:47 | Sonora, Mexico | ||
3264866 | 3264866 | 2020-07-31 | Mexico | Sonora | 17545 | 1951 | 14748 | 846 | 29.2972 | -110.3309 | 2020-08-01 04:36:27 | Sonora, Mexico | ||
1928573 | 1928573 | 2020-07-30 | Mexico | Sonora | 17464 | 1911 | 14644 | 909 | 29.2972 | -110.3309 | 2020-07-31 04:35:18 | Sonora, Mexico | ||
2958741 | 2958741 | 2020-07-29 | Mexico | Sonora | 17259 | 1879 | 14424 | 956 | 29.2972 | -110.3309 | 2020-07-30 04:35:05 | Sonora, Mexico | ||
3185357 | 3185357 | 2020-07-28 | Mexico | Sonora | 16893 | 1820 | 14043 | 1030 | 29.2972 | -110.3309 | 2020-07-29 04:35:11 | Sonora, Mexico | ||
177408 | 177408 | 2020-07-27 | Mexico | Sonora | 16617 | 1759 | 13907 | 951 | 29.2972 | -110.3309 | 2020-07-28 04:58:43 | Sonora, Mexico | ||
442721 | 442721 | 2020-07-26 | Mexico | Sonora | 16521 | 1745 | 13756 | 1020 | 29.2972 | -110.3309 | 2020-07-27 04:35:02 | Sonora, Mexico | ||
1502965 | 1502965 | 2020-07-25 | Mexico | Sonora | 16365 | 1733 | 13615 | 1017 | 29.2972 | -110.3309 | 2020-07-26 04:35:00 | Sonora, Mexico | ||
2563935 | 2563935 | 2020-07-24 | Mexico | Sonora | 16034 | 1685 | 13292 | 1057 | 29.2972 | -110.3309 | 2020-07-25 04:47:39 | Sonora, Mexico | ||
62422 | 62422 | 2020-07-23 | Mexico | Sonora | 15611 | 1621 | 12817 | 1173 | 29.2972 | -110.3309 | 2020-07-24 03:34:53 | Sonora, Mexico | ||
844955 | 844955 | 2020-07-22 | Mexico | Sonora | 15105 | 1581 | 12425 | 1099 | 29.2972 | -110.3309 | 2020-07-23 05:15:04 | Sonora, Mexico | ||
1707694 | 1707694 | 2020-07-21 | Mexico | Sonora | 14947 | 1539 | 12329 | 1079 | 29.2972 | -110.3309 | 2020-07-22 04:34:42 | Sonora, Mexico | ||
327185 | 327185 | 2020-07-20 | Mexico | Sonora | 14608 | 1499 | 12057 | 1052 | 29.2972 | -110.3309 | 2020-07-21 04:38:46 | Sonora, Mexico | ||
122090 | 122090 | 2020-07-19 | Mexico | Sonora | 14485 | 1468 | 11798 | 1219 | 29.2972 | -110.3309 | 2020-07-20 05:34:40 | Sonora, Mexico | ||
3205479 | 3205479 | 2020-07-18 | Mexico | Sonora | 14261 | 1301 | 12303 | 657 | 29.2972 | -110.3309 | 2020-07-19 04:34:58 | Sonora, Mexico | ||
2708781 | 2708781 | 2020-07-17 | Mexico | Sonora | 13721 | 1271 | 11793 | 657 | 29.2972 | -110.3309 | 2020-07-18 04:34:45 | Sonora, Mexico | ||
367591 | 367591 | 2020-07-16 | Mexico | Sonora | 13315 | 1235 | 11423 | 657 | 29.2972 | -110.3309 | 2020-07-17 04:34:50 | Sonora, Mexico | ||
2748259 | 2748259 | 2020-07-15 | Mexico | Sonora | 12712 | 1198 | 10952 | 562 | 29.2972 | -110.3309 | 2020-07-16 04:44:59 | Sonora, Mexico | ||
2158903 | 2158903 | 2020-07-14 | Mexico | Sonora | 12347 | 1170 | 10550 | 627 | 29.2972 | -110.3309 | 2020-07-15 04:34:39 | Sonora, Mexico | ||
3491544 | 3491544 | 2020-07-13 | Mexico | Sonora | 11806 | 1113 | 10208 | 485 | 29.2972 | -110.3309 | 2020-07-14 04:34:46 | Sonora, Mexico | ||
3737807 | 3737807 | 2020-07-12 | Mexico | Sonora | 11576 | 1087 | 9987 | 502 | 29.2972 | -110.3309 | 2020-07-13 04:43:04 | Sonora, Mexico | ||
3436202 | 3436202 | 2020-07-11 | Mexico | Sonora | 11491 | 1080 | 9749 | 662 | 29.2972 | -110.3309 | 2020-07-12 04:34:30 | Sonora, Mexico | ||
3237700 | 3237700 | 2020-07-10 | Mexico | Sonora | 11220 | 1027 | 9525 | 668 | 29.2972 | -110.3309 | 2020-07-11 04:34:26 | Sonora, 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]);