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 = "Guerrero" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1858090 | 1858090 | 2021-02-25 | Mexico | Guerrero | 35067 | 3589 | 0 | 31478 | 17.4392 | -99.5451 | 2021-02-26 05:22:40 | Guerrero, Mexico | ||
280268 | 280268 | 2021-02-24 | Mexico | Guerrero | 34986 | 3571 | 0 | 31415 | 17.4392 | -99.5451 | 2021-02-25 05:24:57 | Guerrero, Mexico | ||
1936536 | 1936536 | 2021-02-23 | Mexico | Guerrero | 34868 | 3555 | 0 | 31313 | 17.4392 | -99.5451 | 2021-02-24 05:29:16 | Guerrero, Mexico | ||
530791 | 530791 | 2021-02-22 | Mexico | Guerrero | 34755 | 3530 | 0 | 31225 | 17.4392 | -99.5451 | 2021-02-23 05:23:41 | Guerrero, Mexico | ||
182125 | 182125 | 2021-02-21 | Mexico | Guerrero | 34707 | 3516 | 0 | 31191 | 17.4392 | -99.5451 | 2021-02-22 05:24:21 | Guerrero, Mexico | ||
742399 | 742399 | 2021-02-20 | Mexico | Guerrero | 34658 | 3513 | 0 | 31145 | 17.4392 | -99.5451 | 2021-02-21 05:24:33 | Guerrero, Mexico | ||
471497 | 471497 | 2021-02-19 | Mexico | Guerrero | 34548 | 3483 | 0 | 31065 | 17.4392 | -99.5451 | 2021-02-20 05:22:51 | Guerrero, Mexico | ||
1153206 | 1153206 | 2021-02-18 | Mexico | Guerrero | 34398 | 3444 | 0 | 30954 | 17.4392 | -99.5451 | 2021-02-19 05:24:16 | Guerrero, Mexico | ||
3601126 | 3601126 | 2021-02-17 | Mexico | Guerrero | 34280 | 3428 | 0 | 30852 | 17.4392 | -99.5451 | 2021-02-18 05:22:58 | Guerrero, Mexico | ||
3050261 | 3050261 | 2021-02-16 | Mexico | Guerrero | 34153 | 3411 | 0 | 30742 | 17.4392 | -99.5451 | 2021-02-17 05:23:10 | Guerrero, Mexico | ||
1338360 | 1338360 | 2021-02-15 | Mexico | Guerrero | 34019 | 3400 | 0 | 30619 | 17.4392 | -99.5451 | 2021-02-16 05:24:38 | Guerrero, Mexico | ||
2283511 | 2283511 | 2021-02-14 | Mexico | Guerrero | 33913 | 3392 | 0 | 30521 | 17.4392 | -99.5451 | 2021-02-15 05:24:49 | Guerrero, Mexico | ||
2677911 | 2677911 | 2021-02-13 | Mexico | Guerrero | 33796 | 3378 | 0 | 30418 | 17.4392 | -99.5451 | 2021-02-14 05:23:43 | Guerrero, Mexico | ||
3539544 | 3539544 | 2021-02-12 | Mexico | Guerrero | 33599 | 3335 | 0 | 30264 | 17.4392 | -99.5451 | 2021-02-13 05:22:12 | Guerrero, Mexico | ||
2637807 | 2637807 | 2021-02-11 | Mexico | Guerrero | 33402 | 3307 | 0 | 30095 | 17.4392 | -99.5451 | 2021-02-12 05:23:29 | Guerrero, Mexico | ||
3978662 | 3978662 | 2021-02-10 | Mexico | Guerrero | 33211 | 3290 | 0 | 29921 | 17.4392 | -99.5451 | 2021-02-11 05:23:55 | Guerrero, Mexico | ||
1527982 | 1527982 | 2021-02-09 | Mexico | Guerrero | 33040 | 3262 | 0 | 29778 | 17.4392 | -99.5451 | 2021-02-10 05:22:41 | Guerrero, Mexico | ||
613773 | 613773 | 2021-02-08 | Mexico | Guerrero | 32827 | 3240 | 0 | 29587 | 17.4392 | -99.5451 | 2021-02-09 05:23:30 | Guerrero, Mexico | ||
1672542 | 1672542 | 2021-02-07 | Mexico | Guerrero | 32656 | 3219 | 0 | 29437 | 17.4392 | -99.5451 | 2021-02-08 05:22:39 | Guerrero, Mexico | ||
975003 | 975003 | 2021-02-06 | Mexico | Guerrero | 32511 | 3210 | 0 | 29301 | 17.4392 | -99.5451 | 2021-02-07 05:23:00 | Guerrero, Mexico | ||
1588261 | 1588261 | 2021-02-05 | Mexico | Guerrero | 32299 | 3197 | 0 | 29102 | 17.4392 | -99.5451 | 2021-02-06 05:23:55 | Guerrero, Mexico | ||
790468 | 790468 | 2021-02-04 | Mexico | Guerrero | 31867 | 3163 | 0 | 28704 | 17.4392 | -99.5451 | 2021-02-05 05:22:38 | Guerrero, Mexico | ||
340360 | 340360 | 2021-02-03 | Mexico | Guerrero | 31867 | 3163 | 0 | 28704 | 17.4392 | -99.5451 | 2021-02-04 05:22:26 | Guerrero, Mexico | ||
1684586 | 1684586 | 2021-02-02 | Mexico | Guerrero | 31691 | 3130 | 0 | 28561 | 17.4392 | -99.5451 | 2021-02-03 05:22:52 | Guerrero, Mexico | ||
1676556 | 1676556 | 2021-02-01 | Mexico | Guerrero | 31599 | 3126 | 0 | 28473 | 17.4392 | -99.5451 | 2021-02-02 05:22:49 | Guerrero, Mexico | ||
1459844 | 1459844 | 2021-01-31 | Mexico | Guerrero | 31457 | 3114 | 0 | 28343 | 17.4392 | -99.5451 | 2021-02-01 05:22:53 | Guerrero, Mexico | ||
2211752 | 2211752 | 2021-01-30 | Mexico | Guerrero | 31330 | 3102 | 0 | 28228 | 17.4392 | -99.5451 | 2021-01-31 05:22:42 | Guerrero, Mexico | ||
1897239 | 1897239 | 2021-01-29 | Mexico | Guerrero | 31103 | 3091 | 0 | 28012 | 17.4392 | -99.5451 | 2021-01-30 05:22:49 | Guerrero, Mexico | ||
2482055 | 2482055 | 2021-01-28 | Mexico | Guerrero | 30856 | 3070 | 0 | 27786 | 17.4392 | -99.5451 | 2021-01-29 05:22:23 | Guerrero, Mexico | ||
3153690 | 3153690 | 2021-01-27 | Mexico | Guerrero | 30486 | 3048 | 0 | 27438 | 17.4392 | -99.5451 | 2021-01-28 05:22:24 | Guerrero, Mexico | ||
12425 | 12425 | 2021-01-26 | Mexico | Guerrero | 30204 | 3003 | 0 | 27201 | 17.4392 | -99.5451 | 2021-01-27 05:23:41 | Guerrero, Mexico | ||
2567749 | 2567749 | 2021-01-25 | Mexico | Guerrero | 29895 | 2970 | 0 | 26925 | 17.4392 | -99.5451 | 2021-01-26 05:22:02 | Guerrero, Mexico | ||
1759381 | 1759381 | 2021-01-24 | Mexico | Guerrero | 29773 | 2962 | 0 | 26811 | 17.4392 | -99.5451 | 2021-01-25 05:22:16 | Guerrero, Mexico | ||
2426988 | 2426988 | 2021-01-23 | Mexico | Guerrero | 29656 | 2954 | 0 | 26702 | 17.4392 | -99.5451 | 2021-01-24 05:22:35 | Guerrero, Mexico | ||
2466890 | 2466890 | 2021-01-22 | Mexico | Guerrero | 29406 | 2939 | 0 | 26467 | 17.4392 | -99.5451 | 2021-01-23 05:22:03 | Guerrero, Mexico | ||
435441 | 435441 | 2021-01-21 | Mexico | Guerrero | 29163 | 2923 | 0 | 26240 | 17.4392 | -99.5451 | 2021-01-22 05:22:10 | Guerrero, Mexico | ||
1094173 | 1094173 | 2021-01-20 | Mexico | Guerrero | 28772 | 2903 | 0 | 25869 | 17.4392 | -99.5451 | 2021-01-21 05:22:01 | Guerrero, Mexico | ||
908263 | 908263 | 2021-01-19 | Mexico | Guerrero | 28547 | 2886 | 0 | 25661 | 17.4392 | -99.5451 | 2021-01-20 05:21:54 | Guerrero, Mexico | ||
237326 | 237326 | 2021-01-18 | Mexico | Guerrero | 28257 | 2867 | 0 | 25390 | 17.4392 | -99.5451 | 2021-01-19 05:22:15 | Guerrero, Mexico | ||
3503443 | 3503443 | 2021-01-17 | Mexico | Guerrero | 28125 | 2864 | 0 | 25261 | 17.4392 | -99.5451 | 2021-01-18 05:22:34 | Guerrero, Mexico | ||
3101526 | 3101526 | 2021-01-16 | Mexico | Guerrero | 27956 | 2855 | 0 | 25101 | 17.4392 | -99.5451 | 2021-01-17 05:22:17 | Guerrero, Mexico | ||
3515488 | 3515488 | 2021-01-15 | Mexico | Guerrero | 27748 | 2848 | 0 | 24900 | 17.4392 | -99.5451 | 2021-01-16 05:22:40 | Guerrero, Mexico | ||
3879661 | 3879661 | 2021-01-14 | Mexico | Guerrero | 27527 | 2831 | 0 | 24696 | 17.4392 | -99.5451 | 2021-01-15 05:22:24 | Guerrero, Mexico | ||
3308288 | 3308288 | 2021-01-13 | Mexico | Guerrero | 27307 | 2814 | 0 | 24493 | 17.4392 | -99.5451 | 2021-01-14 05:22:32 | Guerrero, Mexico | ||
774433 | 774433 | 2021-01-12 | Mexico | Guerrero | 27170 | 2798 | 0 | 24372 | 17.4392 | -99.5451 | 2021-01-13 05:22:15 | Guerrero, Mexico | ||
190154 | 190154 | 2021-01-11 | Mexico | Guerrero | 27052 | 2783 | 0 | 24269 | 17.4392 | -99.5451 | 2021-01-12 05:22:15 | Guerrero, Mexico | ||
2625957 | 2625957 | 2021-01-10 | Mexico | Guerrero | 26944 | 2775 | 0 | 24169 | 17.4392 | -99.5451 | 2021-01-11 05:21:50 | Guerrero, Mexico | ||
3900045 | 3900045 | 2021-01-09 | Mexico | Guerrero | 26775 | 2765 | 0 | 24010 | 17.4392 | -99.5451 | 2021-01-10 05:22:12 | Guerrero, Mexico | ||
154068 | 154068 | 2021-01-08 | Mexico | Guerrero | 26624 | 2757 | 0 | 23867 | 17.4392 | -99.5451 | 2021-01-09 05:22:18 | Guerrero, Mexico | ||
2541492 | 2541492 | 2021-01-07 | Mexico | Guerrero | 26524 | 2748 | 0 | 23776 | 17.4392 | -99.5451 | 2021-01-08 05:22:42 | Guerrero, Mexico | ||
2864801 | 2864801 | 2021-01-06 | Mexico | Guerrero | 26481 | 2746 | 0 | 23735 | 17.4392 | -99.5451 | 2021-01-07 05:22:03 | Guerrero, Mexico | ||
3034388 | 3034388 | 2021-01-05 | Mexico | Guerrero | 26353 | 2739 | 0 | 23614 | 17.4392 | -99.5451 | 2021-01-06 05:22:16 | Guerrero, Mexico | ||
1061933 | 1061933 | 2021-01-04 | Mexico | Guerrero | 26308 | 2733 | 0 | 23575 | 17.4392 | -99.5451 | 2021-01-05 05:21:49 | Guerrero, Mexico | ||
3230536 | 3230536 | 2021-01-03 | Mexico | Guerrero | 26197 | 2728 | 0 | 23469 | 17.4392 | -99.5451 | 2021-01-04 05:22:02 | Guerrero, Mexico | ||
2227605 | 2227605 | 2021-01-02 | Mexico | Guerrero | 26125 | 2722 | 0 | 23403 | 17.4392 | -99.5451 | 2021-01-03 05:22:52 | Guerrero, Mexico | ||
1136969 | 1136969 | 2021-01-01 | Mexico | Guerrero | 26024 | 2716 | 0 | 23308 | 17.4392 | -99.5451 | 2021-01-02 05:22:33 | Guerrero, Mexico | ||
3695575 | 3695575 | 2020-12-31 | Mexico | Guerrero | 25974 | 2703 | 0 | 23271 | 17.4392 | -99.5451 | 2021-01-01 05:23:07 | Guerrero, Mexico | ||
1010390 | 1010390 | 2020-12-30 | Mexico | Guerrero | 25925 | 2701 | 0 | 23224 | 17.4392 | -99.5451 | 2020-12-31 05:22:49 | Guerrero, Mexico | ||
766405 | 766405 | 2020-12-29 | Mexico | Guerrero | 25869 | 2689 | 0 | 23180 | 17.4392 | -99.5451 | 2020-12-30 05:22:34 | Guerrero, Mexico | ||
3761669 | 3761669 | 2020-12-28 | Mexico | Guerrero | 25746 | 2679 | 0 | 23067 | 17.4392 | -99.5451 | 2020-12-29 05:22:37 | Guerrero, Mexico | ||
3777989 | 3777989 | 2020-12-27 | Mexico | Guerrero | 25685 | 2675 | 0 | 23010 | 17.4392 | -99.5451 | 2020-12-28 05:22:06 | Guerrero, Mexico | ||
2223594 | 2223594 | 2020-12-26 | Mexico | Guerrero | 25640 | 2673 | 0 | 22967 | 17.4392 | -99.5451 | 2020-12-27 05:22:55 | Guerrero, Mexico | ||
202341 | 202341 | 2020-12-25 | Mexico | Guerrero | 25593 | 2671 | 0 | 22922 | 17.4392 | -99.5451 | 2020-12-26 05:22:28 | Guerrero, Mexico | ||
3691564 | 3691564 | 2020-12-24 | Mexico | Guerrero | 25539 | 2667 | 0 | 22872 | 17.4392 | -99.5451 | 2020-12-25 05:22:48 | Guerrero, Mexico | ||
2406916 | 2406916 | 2020-12-23 | Mexico | Guerrero | 25474 | 2659 | 0 | 22815 | 17.4392 | -99.5451 | 2020-12-24 05:23:04 | Guerrero, Mexico | ||
3769962 | 3769962 | 2020-12-22 | Mexico | Guerrero | 25424 | 2650 | 0 | 22774 | 17.4392 | -99.5451 | 2020-12-23 05:22:03 | Guerrero, Mexico | ||
927778 | 927778 | 2020-12-21 | Mexico | Guerrero | 25301 | 2635 | 0 | 22666 | 17.4392 | -99.5451 | 2020-12-22 05:22:33 | Guerrero, Mexico | ||
2119799 | 2119799 | 2020-12-20 | Mexico | Guerrero | 25249 | 2631 | 0 | 22618 | 17.4392 | -99.5451 | 2020-12-21 05:27:58 | Guerrero, Mexico | ||
2931306 | 2931306 | 2020-12-19 | Mexico | Guerrero | 25144 | 2628 | 0 | 22516 | 17.4392 | -99.5451 | 2020-12-20 05:27:32 | Guerrero, Mexico | ||
1901252 | 1901252 | 2020-12-18 | Mexico | Guerrero | 25012 | 2618 | 0 | 22394 | 17.4392 | -99.5451 | 2020-12-19 05:27:52 | Guerrero, Mexico | ||
2128078 | 2128078 | 2020-12-17 | Mexico | Guerrero | 24978 | 2614 | 0 | 22364 | 17.4392 | -99.5451 | 2020-12-18 05:28:18 | Guerrero, Mexico | ||
3149678 | 3149678 | 2020-12-16 | Mexico | Guerrero | 24864 | 2598 | 0 | 22266 | 17.4392 | -99.5451 | 2020-12-17 05:28:12 | Guerrero, Mexico | ||
1034459 | 1034459 | 2020-12-15 | Mexico | Guerrero | 24773 | 2591 | 0 | 22182 | 17.4392 | -99.5451 | 2020-12-16 05:28:04 | Guerrero, Mexico | ||
1751353 | 1751353 | 2020-12-14 | Mexico | Guerrero | 24723 | 2581 | 0 | 22142 | 17.4392 | -99.5451 | 2020-12-15 05:26:38 | Guerrero, Mexico | ||
3847873 | 3847873 | 2020-12-13 | Mexico | Guerrero | 24670 | 2575 | 0 | 22095 | 17.4392 | -99.5451 | 2020-12-14 05:26:27 | Guerrero, Mexico | ||
845655 | 845655 | 2020-12-12 | Mexico | Guerrero | 24588 | 2569 | 0 | 22019 | 17.4392 | -99.5451 | 2020-12-13 05:27:20 | Guerrero, Mexico | ||
860762 | 860762 | 2020-12-11 | Mexico | Guerrero | 24501 | 2560 | 0 | 21941 | 17.4392 | -99.5451 | 2020-12-12 05:26:19 | Guerrero, Mexico | ||
1600304 | 1600304 | 2020-12-10 | Mexico | Guerrero | 24417 | 2549 | 0 | 21868 | 17.4392 | -99.5451 | 2020-12-11 05:26:59 | Guerrero, Mexico | ||
2975313 | 2975313 | 2020-12-09 | Mexico | Guerrero | 24353 | 2543 | 0 | 21810 | 17.4392 | -99.5451 | 2020-12-10 05:26:19 | Guerrero, Mexico | ||
1818873 | 1818873 | 2020-12-08 | Mexico | Guerrero | 24303 | 2536 | 0 | 21767 | 17.4392 | -99.5451 | 2020-12-09 05:28:01 | Guerrero, Mexico | ||
2347509 | 2347509 | 2020-12-07 | Mexico | Guerrero | 24243 | 2525 | 0 | 21718 | 17.4392 | -99.5451 | 2020-12-08 05:27:42 | Guerrero, Mexico | ||
1006379 | 1006379 | 2020-12-06 | Mexico | Guerrero | 24165 | 2521 | 0 | 21644 | 17.4392 | -99.5451 | 2020-12-07 05:26:14 | Guerrero, Mexico | ||
1632388 | 1632388 | 2020-12-05 | Mexico | Guerrero | 24109 | 2517 | 0 | 21592 | 17.4392 | -99.5451 | 2020-12-06 05:26:18 | Guerrero, Mexico | ||
3859916 | 3859916 | 2020-12-04 | Mexico | Guerrero | 24057 | 2503 | 0 | 21554 | 17.4392 | -99.5451 | 2020-12-05 05:27:36 | Guerrero, Mexico | ||
75174 | 75174 | 2020-12-03 | Mexico | Guerrero | 23980 | 2498 | 0 | 21482 | 17.4392 | -99.5451 | 2020-12-04 05:27:27 | Guerrero, Mexico | ||
738386 | 738386 | 2020-12-02 | Mexico | Guerrero | 23901 | 2487 | 0 | 21414 | 17.4392 | -99.5451 | 2020-12-03 05:28:22 | Guerrero, Mexico | ||
2537480 | 2537480 | 2020-12-01 | Mexico | Guerrero | 23850 | 2481 | 0 | 21369 | 17.4392 | -99.5451 | 2020-12-02 05:27:41 | Guerrero, Mexico | ||
1584249 | 1584249 | 2020-11-30 | Mexico | Guerrero | 23811 | 2474 | 0 | 21337 | 17.4392 | -99.5451 | 2020-12-01 05:26:18 | Guerrero, Mexico | ||
3566652 | 3566652 | 2020-11-29 | Mexico | Guerrero | 23701 | 2473 | 0 | 21228 | 17.4392 | -99.5451 | 2020-11-30 05:26:13 | Guerrero, Mexico | ||
2935317 | 2935317 | 2020-11-28 | Mexico | Guerrero | 23608 | 2378 | 0 | 21230 | 17.4392 | -99.5451 | 2020-11-29 05:25:55 | Guerrero, Mexico | ||
392320 | 392320 | 2020-11-27 | Mexico | Guerrero | 23572 | 2375 | 0 | 21197 | 17.4392 | -99.5451 | 2020-11-28 05:25:50 | Guerrero, Mexico | ||
923767 | 923767 | 2020-11-26 | Mexico | Guerrero | 23518 | 2462 | 0 | 21056 | 17.4392 | -99.5451 | 2020-11-27 05:26:53 | Guerrero, Mexico | ||
1972672 | 1972672 | 2020-11-25 | Mexico | Guerrero | 23455 | 2457 | 0 | 20998 | 17.4392 | -99.5451 | 2020-11-26 05:27:44 | Guerrero, Mexico | ||
1350403 | 1350403 | 2020-11-24 | Mexico | Guerrero | 23371 | 2455 | 0 | 20916 | 17.4392 | -99.5451 | 2020-11-25 05:27:20 | Guerrero, Mexico | ||
678397 | 678397 | 2020-11-23 | Mexico | Guerrero | 23314 | 2442 | 0 | 20872 | 17.4392 | -99.5451 | 2020-11-24 05:27:31 | Guerrero, Mexico | ||
3190073 | 3190073 | 2020-11-22 | Mexico | Guerrero | 23251 | 2437 | 0 | 20814 | 17.4392 | -99.5451 | 2020-11-23 05:25:26 | Guerrero, Mexico | ||
3836567 | 3836567 | 2020-11-21 | Mexico | Guerrero | 23164 | 2339 | 0 | 20825 | 17.4392 | -99.5451 | 2020-11-22 05:25:45 | Guerrero, Mexico | ||
2701595 | 2701595 | 2020-11-20 | Mexico | Guerrero | 23112 | 2429 | 0 | 20683 | 17.4392 | -99.5451 | 2020-11-21 05:25:51 | Guerrero, Mexico | ||
821655 | 821655 | 2020-11-19 | Mexico | Guerrero | 23104 | 2421 | 0 | 20683 | 17.4392 | -99.5451 | 2020-11-20 05:26:28 | Guerrero, Mexico | ||
122789 | 122789 | 2020-11-18 | Mexico | Guerrero | 23094 | 2416 | 0 | 20678 | 17.4392 | -99.5451 | 2020-11-19 05:25:23 | Guerrero, 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]);