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 confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431990 | 1431990 | 2020-05-20 | Mexico | Sonora | 1020 | 49 | 712 | 259 | 29.2972 | -110.3309 | 2020-05-21 02:32:48 | Sonora, Mexico | ||
268407 | 268407 | 2020-05-21 | Mexico | Sonora | 1124 | 53 | 774 | 297 | 29.2972 | -110.3309 | 2020-05-22 02:36:51 | Sonora, Mexico | ||
1864901 | 1864901 | 2020-05-22 | Mexico | Sonora | 1194 | 56 | 825 | 313 | 29.2972 | -110.3309 | 2020-05-23 02:32:42 | Sonora, Mexico | ||
997878 | 997878 | 2020-05-23 | Mexico | Sonora | 1264 | 63 | 879 | 322 | 29.2972 | -110.3309 | 2020-05-24 02:32:43 | Sonora, Mexico | ||
875687 | 875687 | 2020-05-24 | Mexico | Sonora | 1440 | 69 | 956 | 415 | 29.2972 | -110.3309 | 2020-05-25 02:32:44 | Sonora, Mexico | ||
1105007 | 1105007 | 2020-05-25 | Mexico | Sonora | 1451 | 72 | 1019 | 360 | 29.2972 | -110.3309 | 2020-05-26 02:32:35 | Sonora, Mexico | ||
1041277 | 1041277 | 2020-05-26 | Mexico | Sonora | 1576 | 84 | 1087 | 405 | 29.2972 | -110.3309 | 2020-05-27 02:32:31 | Sonora, Mexico | ||
2548314 | 2548314 | 2020-05-27 | Mexico | Sonora | 1613 | 88 | 1156 | 369 | 29.2972 | -110.3309 | 2020-05-28 02:32:31 | Sonora, Mexico | ||
2712380 | 2712380 | 2020-05-28 | Mexico | Sonora | 1650 | 91 | 1216 | 343 | 29.2972 | -110.3309 | 2020-05-29 02:32:50 | Sonora, Mexico | ||
1790501 | 1790501 | 2020-05-29 | Mexico | Sonora | 1803 | 102 | 1317 | 384 | 29.2972 | -110.3309 | 2020-05-30 02:32:48 | Sonora, Mexico | ||
3638960 | 3638960 | 2020-05-30 | Mexico | Sonora | 1865 | 109 | 1409 | 347 | 29.2972 | -110.3309 | 2020-05-31 02:32:45 | Sonora, Mexico | ||
1794067 | 1794067 | 2020-05-31 | Mexico | Sonora | 2091 | 111 | 1539 | 441 | 29.2972 | -110.3309 | 2020-06-01 02:32:46 | Sonora, Mexico | ||
805507 | 805507 | 2020-06-01 | Mexico | Sonora | 2142 | 116 | 1640 | 386 | 29.2972 | -110.3309 | 2020-06-02 02:33:08 | Sonora, Mexico | ||
2555970 | 2555970 | 2020-06-02 | Mexico | Sonora | 2334 | 132 | 1741 | 461 | 29.2972 | -110.3309 | 2020-06-03 02:33:13 | Sonora, Mexico | ||
3866928 | 3866928 | 2020-06-03 | Mexico | Sonora | 2467 | 142 | 1875 | 450 | 29.2972 | -110.3309 | 2020-06-04 02:33:14 | Sonora, Mexico | ||
1281373 | 1281373 | 2020-06-04 | Mexico | Sonora | 2676 | 156 | 2013 | 507 | 29.2972 | -110.3309 | 2020-06-05 02:33:06 | Sonora, Mexico | ||
1269905 | 1269905 | 2020-06-05 | Mexico | Sonora | 2727 | 165 | 2120 | 442 | 29.2972 | -110.3309 | 2020-06-06 02:33:00 | Sonora, Mexico | ||
574208 | 574208 | 2020-06-06 | Mexico | Sonora | 2865 | 176 | 2246 | 443 | 29.2972 | -110.3309 | 2020-06-07 03:53:30 | Sonora, Mexico | ||
2800152 | 2800152 | 2020-06-07 | Mexico | Sonora | 2984 | 177 | 2378 | 429 | 29.2972 | -110.3309 | 2020-06-08 03:33:22 | Sonora, Mexico | ||
217356 | 217356 | 2020-06-08 | Mexico | Sonora | 3049 | 180 | 2514 | 355 | 29.2972 | -110.3309 | 2020-06-09 03:33:03 | Sonora, Mexico | ||
1210929 | 1210929 | 2020-06-09 | Mexico | Sonora | 3310 | 203 | 2682 | 425 | 29.2972 | -110.3309 | 2020-06-10 04:07:00 | Sonora, Mexico | ||
2864105 | 2864105 | 2020-06-10 | Mexico | Sonora | 3376 | 216 | 2821 | 339 | 29.2972 | -110.3309 | 2020-06-11 03:33:41 | Sonora, Mexico | ||
1273664 | 1273664 | 2020-06-11 | Mexico | Sonora | 3548 | 230 | 2986 | 332 | 29.2972 | -110.3309 | 2020-06-12 05:09:52 | Sonora, Mexico | ||
737694 | 737694 | 2020-06-12 | Mexico | Sonora | 3715 | 244 | 3132 | 339 | 29.2972 | -110.3309 | 2020-06-13 03:33:14 | Sonora, Mexico | ||
3061374 | 3061374 | 2020-06-13 | Mexico | Sonora | 3837 | 256 | 3337 | 244 | 29.2972 | -110.3309 | 2020-06-14 03:33:15 | Sonora, Mexico | ||
1837322 | 1837322 | 2020-06-14 | Mexico | Sonora | 3983 | 273 | 3464 | 246 | 29.2972 | -110.3309 | 2020-06-15 03:33:14 | Sonora, Mexico | ||
287371 | 287371 | 2020-06-15 | Mexico | Sonora | 4097 | 282 | 3638 | 177 | 29.2972 | -110.3309 | 2020-06-16 04:33:09 | Sonora, Mexico | ||
2386808 | 2386808 | 2020-06-16 | Mexico | Sonora | 4134 | 306 | 3711 | 117 | 29.2972 | -110.3309 | 2020-06-17 04:33:21 | Sonora, Mexico | ||
1196045 | 1196045 | 2020-06-17 | Mexico | Sonora | 4192 | 312 | 3782 | 98 | 29.2972 | -110.3309 | 2020-06-18 04:33:18 | Sonora, Mexico | ||
3682842 | 3682842 | 2020-06-18 | Mexico | Sonora | 4530 | 331 | 3974 | 225 | 29.2972 | -110.3309 | 2020-06-19 04:33:17 | Sonora, Mexico | ||
1691693 | 1691693 | 2020-06-19 | Mexico | Sonora | 4779 | 356 | 4197 | 226 | 29.2972 | -110.3309 | 2020-06-20 04:33:19 | Sonora, Mexico | ||
2438115 | 2438115 | 2020-06-20 | Mexico | Sonora | 4958 | 365 | 4371 | 222 | 29.2972 | -110.3309 | 2020-06-21 04:33:19 | Sonora, Mexico | ||
3249522 | 3249522 | 2020-06-21 | Mexico | Sonora | 5098 | 372 | 4520 | 206 | 29.2972 | -110.3309 | 2020-06-22 04:33:20 | Sonora, Mexico | ||
1510783 | 1510783 | 2020-06-22 | Mexico | Sonora | 5520 | 388 | 4824 | 308 | 29.2972 | -110.3309 | 2020-06-23 04:33:22 | Sonora, Mexico | ||
1522589 | 1522589 | 2020-06-23 | Mexico | Sonora | 6188 | 484 | 5108 | 596 | 29.2972 | -110.3309 | 2020-06-24 04:33:28 | Sonora, Mexico | ||
2700904 | 2700904 | 2020-06-24 | Mexico | Sonora | 6303 | 554 | 5237 | 512 | 29.2972 | -110.3309 | 2020-06-25 05:26:54 | Sonora, Mexico | ||
2625264 | 2625264 | 2020-06-25 | Mexico | Sonora | 6491 | 572 | 5448 | 471 | 29.2972 | -110.3309 | 2020-06-26 04:33:43 | Sonora, Mexico | ||
1136277 | 1136277 | 2020-06-26 | Mexico | Sonora | 6677 | 596 | 5607 | 474 | 29.2972 | -110.3309 | 2020-06-27 04:33:35 | Sonora, Mexico | ||
2039996 | 2039996 | 2020-06-27 | Mexico | Sonora | 6943 | 648 | 5763 | 532 | 29.2972 | -110.3309 | 2020-06-28 04:34:04 | Sonora, Mexico | ||
2306661 | 2306661 | 2020-06-28 | Mexico | Sonora | 7064 | 664 | 5901 | 499 | 29.2972 | -110.3309 | 2020-06-29 04:33:44 | Sonora, Mexico | ||
2633098 | 2633098 | 2020-06-29 | Mexico | Sonora | 7407 | 689 | 6125 | 593 | 29.2972 | -110.3309 | 2020-06-30 04:33:48 | Sonora, Mexico | ||
2974621 | 2974621 | 2020-06-30 | Mexico | Sonora | 7587 | 708 | 6309 | 570 | 29.2972 | -110.3309 | 2020-07-01 04:33:52 | Sonora, Mexico | ||
303243 | 303243 | 2020-07-01 | Mexico | Sonora | 7876 | 737 | 6548 | 591 | 29.2972 | -110.3309 | 2020-07-02 04:33:46 | Sonora, Mexico | ||
3045552 | 3045552 | 2020-07-02 | Mexico | Sonora | 8337 | 773 | 6941 | 623 | 29.2972 | -110.3309 | 2020-07-03 04:33:54 | Sonora, Mexico | ||
2234758 | 2234758 | 2020-07-03 | Mexico | Sonora | 8857 | 810 | 7290 | 757 | 29.2972 | -110.3309 | 2020-07-04 04:33:51 | Sonora, Mexico | ||
530097 | 530097 | 2020-07-04 | Mexico | Sonora | 9093 | 830 | 7617 | 646 | 29.2972 | -110.3309 | 2020-07-05 04:33:46 | Sonora, Mexico | ||
415535 | 415535 | 2020-07-05 | Mexico | Sonora | 9270 | 856 | 7778 | 636 | 29.2972 | -110.3309 | 2020-07-06 04:33:57 | Sonora, Mexico | ||
2685070 | 2685070 | 2020-07-06 | Mexico | Sonora | 9520 | 884 | 7974 | 662 | 29.2972 | -110.3309 | 2020-07-07 04:34:00 | Sonora, Mexico | ||
887510 | 887510 | 2020-07-07 | Mexico | Sonora | 10101 | 937 | 8381 | 783 | 29.2972 | -110.3309 | 2020-07-08 05:33:48 | Sonora, Mexico | ||
2222901 | 2222901 | 2020-07-08 | Mexico | Sonora | 10421 | 960 | 8682 | 779 | 29.2972 | -110.3309 | 2020-07-09 04:34:23 | Sonora, Mexico | ||
1005685 | 1005685 | 2020-07-09 | Mexico | Sonora | 10782 | 998 | 9105 | 679 | 29.2972 | -110.3309 | 2020-07-10 04:34:24 | 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 | ||
3436202 | 3436202 | 2020-07-11 | Mexico | Sonora | 11491 | 1080 | 9749 | 662 | 29.2972 | -110.3309 | 2020-07-12 04:34:30 | 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 | ||
3491544 | 3491544 | 2020-07-13 | Mexico | Sonora | 11806 | 1113 | 10208 | 485 | 29.2972 | -110.3309 | 2020-07-14 04:34:46 | 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 | ||
2748259 | 2748259 | 2020-07-15 | Mexico | Sonora | 12712 | 1198 | 10952 | 562 | 29.2972 | -110.3309 | 2020-07-16 04:44:59 | 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 | ||
2708781 | 2708781 | 2020-07-17 | Mexico | Sonora | 13721 | 1271 | 11793 | 657 | 29.2972 | -110.3309 | 2020-07-18 04:34:45 | 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 | ||
122090 | 122090 | 2020-07-19 | Mexico | Sonora | 14485 | 1468 | 11798 | 1219 | 29.2972 | -110.3309 | 2020-07-20 05:34:40 | 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 | ||
1707694 | 1707694 | 2020-07-21 | Mexico | Sonora | 14947 | 1539 | 12329 | 1079 | 29.2972 | -110.3309 | 2020-07-22 04:34:42 | 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 | ||
62422 | 62422 | 2020-07-23 | Mexico | Sonora | 15611 | 1621 | 12817 | 1173 | 29.2972 | -110.3309 | 2020-07-24 03:34:53 | 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 | ||
1502965 | 1502965 | 2020-07-25 | Mexico | Sonora | 16365 | 1733 | 13615 | 1017 | 29.2972 | -110.3309 | 2020-07-26 04:35:00 | 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 | ||
177408 | 177408 | 2020-07-27 | Mexico | Sonora | 16617 | 1759 | 13907 | 951 | 29.2972 | -110.3309 | 2020-07-28 04:58:43 | 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 | ||
2958741 | 2958741 | 2020-07-29 | Mexico | Sonora | 17259 | 1879 | 14424 | 956 | 29.2972 | -110.3309 | 2020-07-30 04:35:05 | 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 | ||
3264866 | 3264866 | 2020-07-31 | Mexico | Sonora | 17545 | 1951 | 14748 | 846 | 29.2972 | -110.3309 | 2020-08-01 04:36:27 | 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 | ||
2808133 | 2808133 | 2020-08-02 | Mexico | Sonora | 17951 | 1988 | 15019 | 944 | 29.2972 | -110.3309 | 2020-08-03 04:34:35 | 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 | ||
98498 | 98498 | 2020-08-04 | Mexico | Sonora | 18238 | 2065 | 15283 | 890 | 29.2972 | -110.3309 | 2020-08-05 04:34:43 | 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 | ||
3612432 | 3612432 | 2020-08-06 | Mexico | Sonora | 18597 | 2186 | 15382 | 1029 | 29.2972 | -110.3309 | 2020-08-07 04:35:11 | 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 | ||
371563 | 371563 | 2020-08-08 | Mexico | Sonora | 18987 | 2277 | 15655 | 1055 | 29.2972 | -110.3309 | 2020-08-09 04:34:54 | 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 | ||
1920586 | 1920586 | 2020-08-10 | Mexico | Sonora | 19123 | 2316 | 15900 | 907 | 29.2972 | -110.3309 | 2020-08-11 04:35:08 | 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 | ||
3531548 | 3531548 | 2020-08-12 | Mexico | Sonora | 19531 | 2361 | 16279 | 891 | 29.2972 | -110.3309 | 2020-08-13 04:29:15 | 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 | ||
1612345 | 1612345 | 2020-08-14 | Mexico | Sonora | 19744 | 2390 | 16431 | 923 | 29.2972 | -110.3309 | 2020-08-15 04:27:31 | 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 | ||
1556068 | 1556068 | 2020-08-16 | Mexico | Sonora | 19972 | 2408 | 16777 | 787 | 29.2972 | -110.3309 | 2020-08-17 04:27:20 | 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 | ||
3178106 | 3178106 | 2020-08-18 | Mexico | Sonora | 20280 | 2432 | 17023 | 825 | 29.2972 | -110.3309 | 2020-08-19 04:27:00 | 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 | ||
3484403 | 3484403 | 2020-08-20 | Mexico | Sonora | 20385 | 2461 | 17146 | 778 | 29.2972 | -110.3309 | 2020-08-21 04:27:41 | 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 | ||
2299547 | 2299547 | 2020-08-22 | Mexico | Sonora | 20693 | 2512 | 17172 | 1009 | 29.2972 | -110.3309 | 2020-08-23 04:27:48 | 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 | ||
2991370 | 2991370 | 2020-08-24 | Mexico | Sonora | 20734 | 2518 | 17312 | 904 | 29.2972 | -110.3309 | 2020-08-25 04:28:02 | 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 | ||
1996742 | 1996742 | 2020-08-26 | Mexico | Sonora | 21027 | 2579 | 17541 | 907 | 29.2972 | -110.3309 | 2020-08-27 04:28:15 | 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 |
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]);