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 = "Coahuila" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533481 | 2533481 | 2022-05-12 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-13 04:20:51 | Coahuila, Mexico | |||
3444927 | 3444927 | 2022-05-11 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-12 04:20:54 | Coahuila, Mexico | |||
3535544 | 3535544 | 2022-05-10 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-11 04:20:48 | Coahuila, Mexico | |||
222079 | 222079 | 2022-05-09 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-10 04:20:50 | Coahuila, Mexico | |||
2331464 | 2331464 | 2022-05-08 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-09 04:20:54 | Coahuila, Mexico | |||
360426 | 360426 | 2022-05-07 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-08 04:20:49 | Coahuila, Mexico | |||
1397777 | 1397777 | 2022-05-06 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-07 04:21:09 | Coahuila, Mexico | |||
2598132 | 2598132 | 2022-05-05 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-06 04:21:00 | Coahuila, Mexico | |||
3265581 | 3265581 | 2022-05-04 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-05 04:20:55 | Coahuila, Mexico | |||
1572220 | 1572220 | 2022-05-03 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-04 04:20:59 | Coahuila, Mexico | |||
463480 | 463480 | 2022-05-02 | Mexico | Coahuila | 145491 | 8791 | 0 | 27.0587 | -101.7068 | 2022-05-03 04:21:00 | Coahuila, Mexico | |||
3916119 | 3916119 | 2022-05-01 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-02 04:21:10 | Coahuila, Mexico | |||
2840923 | 2840923 | 2022-04-30 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-01 04:20:57 | Coahuila, Mexico | |||
1157236 | 1157236 | 2022-04-29 | Mexico | Coahuila | 145489 | 8789 | 0 | 27.0587 | -101.7068 | 2022-04-30 04:21:05 | Coahuila, Mexico | |||
1696418 | 1696418 | 2022-04-28 | Mexico | Coahuila | 145482 | 8789 | 0 | 27.0587 | -101.7068 | 2022-04-29 04:20:59 | Coahuila, Mexico | |||
3851901 | 3851901 | 2022-04-27 | Mexico | Coahuila | 145479 | 8789 | 0 | 27.0587 | -101.7068 | 2022-04-28 04:20:47 | Coahuila, Mexico | |||
1326331 | 1326331 | 2022-04-26 | Mexico | Coahuila | 145472 | 8787 | 0 | 27.0587 | -101.7068 | 2022-04-27 04:20:52 | Coahuila, Mexico | |||
3722285 | 3722285 | 2022-04-25 | Mexico | Coahuila | 145467 | 8787 | 0 | 27.0587 | -101.7068 | 2022-04-26 04:20:51 | Coahuila, Mexico | |||
2028853 | 2028853 | 2022-04-24 | Mexico | Coahuila | 145465 | 8787 | 0 | 27.0587 | -101.7068 | 2022-04-25 04:20:56 | Coahuila, Mexico | |||
746428 | 746428 | 2022-04-23 | Mexico | Coahuila | 145463 | 8787 | 0 | 27.0587 | -101.7068 | 2022-04-24 04:20:56 | Coahuila, Mexico | |||
3436913 | 3436913 | 2022-04-22 | Mexico | Coahuila | 145443 | 8784 | 0 | 27.0587 | -101.7068 | 2022-04-23 04:20:50 | Coahuila, Mexico | |||
2892498 | 2892498 | 2022-04-21 | Mexico | Coahuila | 145443 | 8784 | 0 | 27.0587 | -101.7068 | 2022-04-22 04:20:45 | Coahuila, Mexico | |||
2307370 | 2307370 | 2022-04-20 | Mexico | Coahuila | 145452 | 8783 | 0 | 27.0587 | -101.7068 | 2022-04-21 04:20:46 | Coahuila, Mexico | |||
2251509 | 2251509 | 2022-04-19 | Mexico | Coahuila | 145448 | 8783 | 0 | 27.0587 | -101.7068 | 2022-04-20 04:20:45 | Coahuila, Mexico | |||
1846059 | 1846059 | 2022-04-18 | Mexico | Coahuila | 145436 | 8783 | 0 | 27.0587 | -101.7068 | 2022-04-19 04:21:00 | Coahuila, Mexico | |||
3417003 | 3417003 | 2022-04-17 | Mexico | Coahuila | 145436 | 8783 | 0 | 27.0587 | -101.7068 | 2022-04-18 04:21:12 | Coahuila, Mexico | |||
303952 | 303952 | 2022-04-16 | Mexico | Coahuila | 145427 | 8782 | 0 | 27.0587 | -101.7068 | 2022-04-17 04:20:59 | Coahuila, Mexico | |||
2669897 | 2669897 | 2022-04-15 | Mexico | Coahuila | 145413 | 8781 | 0 | 27.0587 | -101.7068 | 2022-04-16 04:20:48 | Coahuila, Mexico | |||
1223682 | 1223682 | 2022-04-14 | Mexico | Coahuila | 145413 | 8781 | 0 | 27.0587 | -101.7068 | 2022-04-15 04:20:57 | Coahuila, Mexico | |||
2442840 | 2442840 | 2022-04-13 | Mexico | Coahuila | 145413 | 8778 | 0 | 27.0587 | -101.7068 | 2022-04-13 23:21:06 | Coahuila, Mexico | |||
1948597 | 1948597 | 2022-04-12 | Mexico | Coahuila | 145410 | 8777 | 0 | 27.0587 | -101.7068 | 2022-04-13 04:21:03 | Coahuila, Mexico | |||
3206350 | 3206350 | 2022-04-11 | Mexico | Coahuila | 145407 | 8774 | 0 | 27.0587 | -101.7068 | 2022-04-12 04:20:49 | Coahuila, Mexico | |||
1576236 | 1576236 | 2022-04-10 | Mexico | Coahuila | 145404 | 8774 | 0 | 27.0587 | -101.7068 | 2022-04-11 04:21:02 | Coahuila, Mexico | |||
1652478 | 1652478 | 2022-04-09 | Mexico | Coahuila | 145400 | 8774 | 0 | 27.0587 | -101.7068 | 2022-04-10 04:20:52 | Coahuila, Mexico | |||
2115800 | 2115800 | 2022-04-08 | Mexico | Coahuila | 145395 | 8775 | 0 | 27.0587 | -101.7068 | 2022-04-09 04:20:42 | Coahuila, Mexico | |||
3320324 | 3320324 | 2022-04-07 | Mexico | Coahuila | 145354 | 8775 | 0 | 27.0587 | -101.7068 | 2022-04-08 04:20:48 | Coahuila, Mexico | |||
2800860 | 2800860 | 2022-04-06 | Mexico | Coahuila | 144663 | 8773 | 0 | 27.0587 | -101.7068 | 2022-04-07 04:20:53 | Coahuila, Mexico | |||
3867629 | 3867629 | 2022-04-05 | Mexico | Coahuila | 144462 | 8772 | 0 | 27.0587 | -101.7068 | 2022-04-06 04:20:49 | Coahuila, Mexico | |||
2748971 | 2748971 | 2022-04-04 | Mexico | Coahuila | 144413 | 8772 | 0 | 27.0587 | -101.7068 | 2022-04-05 04:20:48 | Coahuila, Mexico | |||
3730317 | 3730317 | 2022-04-03 | Mexico | Coahuila | 144342 | 8772 | 0 | 27.0587 | -101.7068 | 2022-04-04 04:20:51 | Coahuila, Mexico | |||
499752 | 499752 | 2022-04-02 | Mexico | Coahuila | 144336 | 8772 | 0 | 27.0587 | -101.7068 | 2022-04-03 04:20:48 | Coahuila, Mexico | |||
3350737 | 3350737 | 2022-04-01 | Mexico | Coahuila | 144284 | 8771 | 0 | 27.0587 | -101.7068 | 2022-04-02 04:20:47 | Coahuila, Mexico | |||
1540042 | 1540042 | 2022-03-31 | Mexico | Coahuila | 144268 | 8770 | 0 | 27.0587 | -101.7068 | 2022-04-01 04:20:28 | Coahuila, Mexico | |||
2478055 | 2478055 | 2022-03-30 | Mexico | Coahuila | 144253 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-31 04:20:56 | Coahuila, Mexico | |||
158096 | 158096 | 2022-03-29 | Mexico | Coahuila | 144253 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-30 04:20:45 | Coahuila, Mexico | |||
1436667 | 1436667 | 2022-03-28 | Mexico | Coahuila | 144237 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-29 04:20:46 | Coahuila, Mexico | |||
876348 | 876348 | 2022-03-27 | Mexico | Coahuila | 144234 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-28 04:20:33 | Coahuila, Mexico | |||
2163631 | 2163631 | 2022-03-26 | Mexico | Coahuila | 144211 | 8764 | 0 | 27.0587 | -101.7068 | 2022-03-27 04:20:47 | Coahuila, Mexico | |||
1720567 | 1720567 | 2022-03-25 | Mexico | Coahuila | 144211 | 8764 | 0 | 27.0587 | -101.7068 | 2022-03-26 04:20:23 | Coahuila, Mexico | |||
1468184 | 1468184 | 2022-03-24 | Mexico | Coahuila | 144167 | 8765 | 0 | 27.0587 | -101.7068 | 2022-03-25 04:20:46 | Coahuila, Mexico | |||
3022358 | 3022358 | 2022-03-23 | Mexico | Coahuila | 144170 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-24 04:20:43 | Coahuila, Mexico | |||
1905280 | 1905280 | 2022-03-22 | Mexico | Coahuila | 144170 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-23 04:20:48 | Coahuila, Mexico | |||
3238411 | 3238411 | 2022-03-21 | Mexico | Coahuila | 144167 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-22 04:20:54 | Coahuila, Mexico | |||
24484 | 24484 | 2022-03-20 | Mexico | Coahuila | 144163 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-21 04:20:50 | Coahuila, Mexico | |||
1656494 | 1656494 | 2022-03-19 | Mexico | Coahuila | 144134 | 8761 | 0 | 27.0587 | -101.7068 | 2022-03-20 04:20:45 | Coahuila, Mexico | |||
336020 | 336020 | 2022-03-18 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-19 04:20:47 | Coahuila, Mexico | |||
694473 | 694473 | 2022-03-17 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-18 04:20:55 | Coahuila, Mexico | |||
2319416 | 2319416 | 2022-03-16 | Mexico | Coahuila | 144000 | 8748 | 0 | 27.0587 | -101.7068 | 2022-03-17 04:20:56 | Coahuila, Mexico | |||
261616 | 261616 | 2022-03-15 | Mexico | Coahuila | 143886 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-16 04:20:50 | Coahuila, Mexico | |||
2263975 | 2263975 | 2022-03-14 | Mexico | Coahuila | 143886 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-15 04:20:47 | Coahuila, Mexico | |||
3628041 | 3628041 | 2022-03-13 | Mexico | Coahuila | 143877 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-14 04:20:46 | Coahuila, Mexico | |||
950949 | 950949 | 2022-03-12 | Mexico | Coahuila | 143871 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-13 04:20:49 | Coahuila, Mexico | |||
356410 | 356410 | 2022-03-11 | Mexico | Coahuila | 143800 | 8727 | 0 | 27.0587 | -101.7068 | 2022-03-12 04:20:50 | Coahuila, Mexico | |||
1865562 | 1865562 | 2022-03-10 | Mexico | Coahuila | 143800 | 8727 | 0 | 27.0587 | -101.7068 | 2022-03-11 04:20:50 | Coahuila, Mexico | |||
2140257 | 2140257 | 2022-03-09 | Mexico | Coahuila | 143749 | 8724 | 0 | 27.0587 | -101.7068 | 2022-03-10 04:20:48 | Coahuila, Mexico | |||
919768 | 919768 | 2022-03-08 | Mexico | Coahuila | 143702 | 8722 | 0 | 27.0587 | -101.7068 | 2022-03-09 04:20:59 | Coahuila, Mexico | |||
1548055 | 1548055 | 2022-03-07 | Mexico | Coahuila | 143635 | 8720 | 0 | 27.0587 | -101.7068 | 2022-03-08 04:20:54 | Coahuila, Mexico | |||
2199724 | 2199724 | 2022-03-06 | Mexico | Coahuila | 143618 | 8720 | 0 | 27.0587 | -101.7068 | 2022-03-07 04:20:47 | Coahuila, Mexico | |||
2092181 | 2092181 | 2022-03-05 | Mexico | Coahuila | 143559 | 8713 | 0 | 27.0587 | -101.7068 | 2022-03-06 04:20:49 | Coahuila, Mexico | |||
2665881 | 2665881 | 2022-03-04 | Mexico | Coahuila | 143519 | 8703 | 0 | 27.0587 | -101.7068 | 2022-03-05 04:21:10 | Coahuila, Mexico | |||
1644446 | 1644446 | 2022-03-03 | Mexico | Coahuila | 143460 | 8700 | 0 | 27.0587 | -101.7068 | 2022-03-04 04:21:09 | Coahuila, Mexico | |||
2525449 | 2525449 | 2022-03-02 | Mexico | Coahuila | 143365 | 8698 | 0 | 27.0587 | -101.7068 | 2022-03-03 04:21:01 | Coahuila, Mexico | |||
1992743 | 1992743 | 2022-03-01 | Mexico | Coahuila | 143365 | 8698 | 0 | 27.0587 | -101.7068 | 2022-03-02 04:21:07 | Coahuila, Mexico | |||
942917 | 942917 | 2022-02-28 | Mexico | Coahuila | 143296 | 8695 | 0 | 27.0587 | -101.7068 | 2022-03-01 04:21:09 | Coahuila, Mexico | |||
2733108 | 2733108 | 2022-02-27 | Mexico | Coahuila | 143287 | 8695 | 0 | 27.0587 | -101.7068 | 2022-02-28 04:21:05 | Coahuila, Mexico | |||
3046261 | 3046261 | 2022-02-26 | Mexico | Coahuila | 143268 | 8695 | 0 | 27.0587 | -101.7068 | 2022-02-27 04:21:04 | Coahuila, Mexico | |||
574916 | 574916 | 2022-02-25 | Mexico | Coahuila | 143218 | 8691 | 0 | 27.0587 | -101.7068 | 2022-02-26 04:21:12 | Coahuila, Mexico | |||
1511492 | 1511492 | 2022-02-24 | Mexico | Coahuila | 143100 | 8687 | 0 | 27.0587 | -101.7068 | 2022-02-25 04:21:11 | Coahuila, Mexico | |||
1057933 | 1057933 | 2022-02-23 | Mexico | Coahuila | 142954 | 8682 | 0 | 27.0587 | -101.7068 | 2022-02-24 04:21:14 | Coahuila, Mexico | |||
2446856 | 2446856 | 2022-02-22 | Mexico | Coahuila | 142535 | 8659 | 0 | 27.0587 | -101.7068 | 2022-02-23 04:21:09 | Coahuila, Mexico | |||
3718269 | 3718269 | 2022-02-21 | Mexico | Coahuila | 142519 | 8657 | 0 | 27.0587 | -101.7068 | 2022-02-22 04:21:01 | Coahuila, Mexico | |||
3912103 | 3912103 | 2022-02-20 | Mexico | Coahuila | 142519 | 8657 | 0 | 27.0587 | -101.7068 | 2022-02-21 04:21:05 | Coahuila, Mexico | |||
3875661 | 3875661 | 2022-02-19 | Mexico | Coahuila | 142459 | 8656 | 0 | 27.0587 | -101.7068 | 2022-02-20 04:21:00 | Coahuila, Mexico | |||
3855917 | 3855917 | 2022-02-18 | Mexico | Coahuila | 141996 | 8637 | 0 | 27.0587 | -101.7068 | 2022-02-19 04:21:11 | Coahuila, Mexico | |||
1298136 | 1298136 | 2022-02-17 | Mexico | Coahuila | 141996 | 8637 | 0 | 27.0587 | -101.7068 | 2022-02-18 04:21:04 | Coahuila, Mexico | |||
3820522 | 3820522 | 2022-02-16 | Mexico | Coahuila | 141778 | 8624 | 0 | 27.0587 | -101.7068 | 2022-02-17 04:20:56 | Coahuila, Mexico | |||
3671736 | 3671736 | 2022-02-15 | Mexico | Coahuila | 141298 | 8582 | 0 | 27.0587 | -101.7068 | 2022-02-16 04:21:10 | Coahuila, Mexico | |||
2641837 | 2641837 | 2022-02-14 | Mexico | Coahuila | 141180 | 8579 | 0 | 27.0587 | -101.7068 | 2022-02-15 04:21:09 | Coahuila, Mexico | |||
186154 | 186154 | 2022-02-13 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-14 04:20:51 | Coahuila, Mexico | |||
316000 | 316000 | 2022-02-12 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-13 04:21:00 | Coahuila, Mexico | |||
233326 | 233326 | 2022-02-11 | Mexico | Coahuila | 140174 | 8522 | 0 | 27.0587 | -101.7068 | 2022-02-12 04:21:06 | Coahuila, Mexico | |||
1464168 | 1464168 | 2022-02-10 | Mexico | Coahuila | 139702 | 8495 | 0 | 27.0587 | -101.7068 | 2022-02-11 04:21:09 | Coahuila, Mexico | |||
3074129 | 3074129 | 2022-02-09 | Mexico | Coahuila | 139702 | 8495 | 0 | 27.0587 | -101.7068 | 2022-02-10 04:21:14 | Coahuila, Mexico | |||
1362436 | 1362436 | 2022-02-08 | Mexico | Coahuila | 139357 | 8453 | 0 | 27.0587 | -101.7068 | 2022-02-09 04:21:04 | Coahuila, Mexico | |||
71174 | 71174 | 2022-02-07 | Mexico | Coahuila | 139337 | 8450 | 0 | 27.0587 | -101.7068 | 2022-02-08 04:21:15 | Coahuila, Mexico | |||
2012790 | 2012790 | 2022-02-06 | Mexico | Coahuila | 139166 | 8441 | 0 | 27.0587 | -101.7068 | 2022-02-07 04:21:05 | Coahuila, Mexico | |||
1294119 | 1294119 | 2022-02-05 | Mexico | Coahuila | 139058 | 8440 | 0 | 27.0587 | -101.7068 | 2022-02-06 04:21:00 | Coahuila, Mexico | |||
2327447 | 2327447 | 2022-02-04 | Mexico | Coahuila | 138460 | 8388 | 0 | 27.0587 | -101.7068 | 2022-02-05 04:21:05 | Coahuila, Mexico | |||
2474038 | 2474038 | 2022-02-03 | Mexico | Coahuila | 136836 | 8312 | 0 | 27.0587 | -101.7068 | 2022-02-04 04:21:10 | Coahuila, Mexico | |||
459463 | 459463 | 2022-02-02 | Mexico | Coahuila | 135941 | 8282 | 0 | 27.0587 | -101.7068 | 2022-02-03 04:21:21 | Coahuila, 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]);