daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Coahuila" sorted by latitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▲ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Mexico | Coahuila | 98018 | 7602 | 0 | 27.0587 | -101.7068 | 2021-12-03 04:23:05 | Coahuila, Mexico | |||
2021-10-28 | Mexico | Coahuila | 92997 | 7377 | 0 | 27.0587 | -101.7068 | 2021-10-29 04:22:03 | Coahuila, Mexico | |||
2020-10-25 | Mexico | Coahuila | 32032 | 2236 | 27058 | 2738 | 27.0587 | -101.7068 | 2020-10-26 04:25:02 | Coahuila, Mexico | ||
2021-01-26 | Mexico | Coahuila | 58264 | 5049 | 0 | 53215 | 27.0587 | -101.7068 | 2021-01-27 05:23:41 | Coahuila, Mexico | ||
2021-09-18 | Mexico | Coahuila | 86478 | 7006 | 0 | 27.0587 | -101.7068 | 2021-09-19 04:21:34 | Coahuila, Mexico | |||
2021-05-28 | Mexico | Coahuila | 68755 | 6256 | 0 | 62499 | 27.0587 | -101.7068 | 2021-05-29 04:20:41 | Coahuila, Mexico | ||
2022-03-20 | Mexico | Coahuila | 144163 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-21 04:20:50 | Coahuila, Mexico | |||
2021-11-11 | Mexico | Coahuila | 94841 | 7458 | 0 | 27.0587 | -101.7068 | 2021-11-12 04:22:01 | Coahuila, Mexico | |||
2021-08-25 | Mexico | Coahuila | 80080 | 6754 | 0 | 27.0587 | -101.7068 | 2021-08-26 04:21:28 | Coahuila, Mexico | |||
2021-04-12 | Mexico | Coahuila | 67243 | 6124 | 0 | 61119 | 27.0587 | -101.7068 | 2021-04-13 04:20:37 | Coahuila, Mexico | ||
2021-11-02 | Mexico | Coahuila | 93345 | 7400 | 0 | 27.0587 | -101.7068 | 2021-11-03 06:22:09 | Coahuila, Mexico | |||
2021-05-29 | Mexico | Coahuila | 68802 | 6262 | 0 | 62540 | 27.0587 | -101.7068 | 2021-05-30 04:20:55 | Coahuila, Mexico | ||
2021-03-07 | Mexico | Coahuila | 65385 | 5725 | 0 | 59660 | 27.0587 | -101.7068 | 2021-03-08 05:24:48 | Coahuila, Mexico | ||
2020-07-23 | Mexico | Coahuila | 10404 | 530 | 7373 | 2501 | 27.0587 | -101.7068 | 2020-07-24 03:34:53 | Coahuila, Mexico | ||
2022-11-12 | Mexico | Coahuila | 180646 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-13 04:21:14 | Coahuila, Mexico | |||
2021-09-01 | Mexico | Coahuila | 82112 | 6822 | 0 | 27.0587 | -101.7068 | 2021-09-02 04:21:15 | Coahuila, Mexico | |||
2022-02-07 | Mexico | Coahuila | 139337 | 8450 | 0 | 27.0587 | -101.7068 | 2022-02-08 04:21:15 | Coahuila, Mexico | |||
2020-12-03 | Mexico | Coahuila | 42693 | 3458 | 0 | 39235 | 27.0587 | -101.7068 | 2020-12-04 05:27:27 | Coahuila, Mexico | ||
2020-10-14 | Mexico | Coahuila | 29343 | 2060 | 25167 | 2116 | 27.0587 | -101.7068 | 2020-10-15 04:24:28 | Coahuila, Mexico | ||
2021-05-25 | Mexico | Coahuila | 68644 | 6252 | 0 | 62392 | 27.0587 | -101.7068 | 2021-05-26 04:20:35 | Coahuila, Mexico | ||
2021-11-09 | Mexico | Coahuila | 94441 | 7439 | 0 | 27.0587 | -101.7068 | 2021-11-10 04:21:38 | Coahuila, Mexico | |||
2022-07-23 | Mexico | Coahuila | 167497 | 8857 | 0 | 27.0587 | -101.7068 | 2022-07-24 04:20:47 | Coahuila, Mexico | |||
2020-08-04 | Mexico | Coahuila | 13749 | 695 | 10873 | 2181 | 27.0587 | -101.7068 | 2020-08-05 04:34:43 | Coahuila, Mexico | ||
2022-01-14 | Mexico | Coahuila | 111858 | 7913 | 0 | 27.0587 | -101.7068 | 2022-01-15 04:21:07 | Coahuila, Mexico | |||
2021-08-15 | Mexico | Coahuila | 76892 | 6642 | 0 | 27.0587 | -101.7068 | 2021-08-16 04:21:31 | Coahuila, Mexico | |||
2021-06-19 | Mexico | Coahuila | 69342 | 6374 | 0 | 62968 | 27.0587 | -101.7068 | 2021-06-20 04:21:48 | Coahuila, Mexico | ||
2022-09-06 | Mexico | Coahuila | 179595 | 8948 | 0 | 27.0587 | -101.7068 | 2022-09-07 04:20:59 | Coahuila, Mexico | |||
2020-07-19 | Mexico | Coahuila | 8995 | 459 | 5960 | 2576 | 27.0587 | -101.7068 | 2020-07-20 05:34:40 | Coahuila, Mexico | ||
2020-11-18 | Mexico | Coahuila | 37891 | 2925 | 0 | 34966 | 27.0587 | -101.7068 | 2020-11-19 05:25:23 | Coahuila, Mexico | ||
2022-01-09 | Mexico | Coahuila | 106844 | 7864 | 0 | 27.0587 | -101.7068 | 2022-01-10 04:22:07 | Coahuila, Mexico | |||
2022-10-04 | Mexico | Coahuila | 180376 | 8956 | 0 | 27.0587 | -101.7068 | 2022-10-05 04:23:06 | Coahuila, Mexico | |||
2021-12-04 | Mexico | Coahuila | 98417 | 7622 | 0 | 27.0587 | -101.7068 | 2021-12-05 04:22:25 | Coahuila, Mexico | |||
2022-07-09 | Mexico | Coahuila | 156088 | 8832 | 0 | 27.0587 | -101.7068 | 2022-07-10 04:20:54 | Coahuila, Mexico | |||
2020-08-15 | Mexico | Coahuila | 17447 | 1090 | 13824 | 2533 | 27.0587 | -101.7068 | 2020-08-16 04:27:42 | Coahuila, Mexico | ||
2021-11-29 | Mexico | Coahuila | 97577 | 7573 | 0 | 27.0587 | -101.7068 | 2021-11-30 04:22:53 | Coahuila, Mexico | |||
2021-01-08 | Mexico | Coahuila | 51755 | 4363 | 0 | 47392 | 27.0587 | -101.7068 | 2021-01-09 05:22:18 | Coahuila, Mexico | ||
2022-03-29 | Mexico | Coahuila | 144253 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-30 04:20:45 | Coahuila, Mexico | |||
2021-11-19 | Mexico | Coahuila | 95802 | 7504 | 0 | 27.0587 | -101.7068 | 2021-11-20 04:22:17 | Coahuila, Mexico | |||
2022-06-21 | Mexico | Coahuila | 147170 | 8814 | 0 | 27.0587 | -101.7068 | 2022-06-22 04:20:54 | Coahuila, Mexico | |||
2021-04-16 | Mexico | Coahuila | 67481 | 6148 | 0 | 61333 | 27.0587 | -101.7068 | 2021-04-17 04:20:40 | Coahuila, Mexico | ||
2020-07-27 | Mexico | Coahuila | 11487 | 582 | 8678 | 2227 | 27.0587 | -101.7068 | 2020-07-28 04:58:43 | Coahuila, Mexico | ||
2021-09-02 | Mexico | Coahuila | 82590 | 6837 | 0 | 27.0587 | -101.7068 | 2021-09-03 04:21:20 | Coahuila, Mexico | |||
2021-02-21 | Mexico | Coahuila | 64016 | 5598 | 0 | 58418 | 27.0587 | -101.7068 | 2021-02-22 05:24:21 | Coahuila, Mexico | ||
2022-02-13 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-14 04:20:51 | Coahuila, Mexico | |||
2021-01-11 | Mexico | Coahuila | 52873 | 4438 | 0 | 48435 | 27.0587 | -101.7068 | 2021-01-12 05:22:15 | Coahuila, Mexico | ||
2020-08-31 | Mexico | Coahuila | 21607 | 1379 | 18394 | 1834 | 27.0587 | -101.7068 | 2020-09-01 04:28:31 | Coahuila, Mexico | ||
2022-10-19 | Mexico | Coahuila | 180479 | 8961 | 0 | 27.0587 | -101.7068 | 2022-10-20 04:22:59 | Coahuila, Mexico | |||
2020-12-25 | Mexico | Coahuila | 48093 | 4035 | 0 | 44058 | 27.0587 | -101.7068 | 2020-12-26 05:22:28 | Coahuila, Mexico | ||
2020-08-19 | Mexico | Coahuila | 18580 | 1161 | 15094 | 2325 | 27.0587 | -101.7068 | 2020-08-20 04:27:43 | Coahuila, Mexico | ||
2020-10-29 | Mexico | Coahuila | 33241 | 2348 | 27830 | 3063 | 27.0587 | -101.7068 | 2020-10-30 04:24:49 | Coahuila, Mexico | ||
2020-06-08 | Mexico | Coahuila | 1560 | 100 | 1137 | 323 | 27.0587 | -101.7068 | 2020-06-09 03:33:03 | Coahuila, Mexico | ||
2022-12-26 | Mexico | Coahuila | 181933 | 8975 | 0 | 27.0587 | -101.7068 | 2022-12-27 04:21:07 | Coahuila, Mexico | |||
2022-05-09 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-10 04:20:50 | Coahuila, Mexico | |||
2022-05-31 | Mexico | Coahuila | 145708 | 8805 | 0 | 27.0587 | -101.7068 | 2022-06-01 04:20:55 | Coahuila, Mexico | |||
2022-02-11 | Mexico | Coahuila | 140174 | 8522 | 0 | 27.0587 | -101.7068 | 2022-02-12 04:21:06 | Coahuila, Mexico | |||
2021-01-18 | Mexico | Coahuila | 55256 | 4705 | 0 | 50551 | 27.0587 | -101.7068 | 2021-01-19 05:22:15 | Coahuila, Mexico | ||
2021-04-02 | Mexico | Coahuila | 66735 | 5877 | 0 | 60858 | 27.0587 | -101.7068 | 2021-04-03 04:20:44 | Coahuila, Mexico | ||
2021-08-17 | Mexico | Coahuila | 77334 | 6662 | 0 | 27.0587 | -101.7068 | 2021-08-18 04:21:35 | Coahuila, Mexico | |||
2021-09-04 | Mexico | Coahuila | 83355 | 6873 | 0 | 27.0587 | -101.7068 | 2021-09-05 04:21:33 | Coahuila, Mexico | |||
2022-09-08 | Mexico | Coahuila | 179595 | 8948 | 0 | 27.0587 | -101.7068 | 2022-09-09 04:21:11 | Coahuila, Mexico | |||
2022-12-10 | Mexico | Coahuila | 181105 | 8970 | 0 | 27.0587 | -101.7068 | 2022-12-11 04:20:50 | Coahuila, Mexico | |||
2022-03-15 | Mexico | Coahuila | 143886 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-16 04:20:50 | Coahuila, Mexico | |||
2020-05-21 | Mexico | Coahuila | 772 | 62 | 578 | 132 | 27.0587 | -101.7068 | 2020-05-22 02:36:51 | Coahuila, Mexico | ||
2020-11-10 | Mexico | Coahuila | 36643 | 2665 | 30938 | 3040 | 27.0587 | -101.7068 | 2020-11-11 05:25:30 | Coahuila, Mexico | ||
2021-11-03 | Mexico | Coahuila | 93531 | 7410 | 0 | 27.0587 | -101.7068 | 2021-11-04 04:22:20 | Coahuila, Mexico | |||
2021-02-24 | Mexico | Coahuila | 64369 | 5639 | 0 | 58730 | 27.0587 | -101.7068 | 2021-02-25 05:24:57 | Coahuila, Mexico | ||
2020-06-15 | Mexico | Coahuila | 2053 | 135 | 1561 | 357 | 27.0587 | -101.7068 | 2020-06-16 04:33:09 | Coahuila, Mexico | ||
2021-10-31 | Mexico | Coahuila | 93338 | 7398 | 0 | 27.0587 | -101.7068 | 2021-11-01 04:22:01 | Coahuila, Mexico | |||
2022-11-15 | Mexico | Coahuila | 180688 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-16 04:21:09 | Coahuila, Mexico | |||
2021-07-15 | Mexico | Coahuila | 70498 | 6505 | 0 | 63993 | 27.0587 | -101.7068 | 2021-07-16 04:21:22 | Coahuila, Mexico | ||
2020-07-01 | Mexico | Coahuila | 4883 | 233 | 3517 | 1133 | 27.0587 | -101.7068 | 2020-07-02 04:33:46 | Coahuila, Mexico | ||
2022-04-16 | Mexico | Coahuila | 145427 | 8782 | 0 | 27.0587 | -101.7068 | 2022-04-17 04:20:59 | Coahuila, Mexico | |||
2022-12-13 | Mexico | Coahuila | 181252 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-14 04:21:04 | Coahuila, Mexico | |||
2022-11-13 | Mexico | Coahuila | 180646 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-14 04:21:09 | Coahuila, Mexico | |||
2022-02-12 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-13 04:21:00 | Coahuila, Mexico | |||
2022-10-30 | Mexico | Coahuila | 180563 | 8962 | 0 | 27.0587 | -101.7068 | 2022-10-31 04:21:36 | Coahuila, Mexico | |||
2020-07-20 | Mexico | Coahuila | 9300 | 467 | 6376 | 2457 | 27.0587 | -101.7068 | 2020-07-21 04:38:46 | Coahuila, Mexico | ||
2022-12-27 | Mexico | Coahuila | 182030 | 8975 | 0 | 27.0587 | -101.7068 | 2022-12-28 04:21:04 | Coahuila, Mexico | |||
2021-08-04 | Mexico | Coahuila | 73804 | 6561 | 0 | 67243 | 27.0587 | -101.7068 | 2021-08-05 04:21:51 | Coahuila, Mexico | ||
2022-03-18 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-19 04:20:47 | Coahuila, Mexico | |||
2021-02-03 | Mexico | Coahuila | 60789 | 5286 | 0 | 55503 | 27.0587 | -101.7068 | 2021-02-04 05:22:26 | Coahuila, Mexico | ||
2020-09-14 | Mexico | Coahuila | 24267 | 1641 | 21361 | 1265 | 27.0587 | -101.7068 | 2020-09-15 03:22:50 | Coahuila, Mexico | ||
2022-12-14 | Mexico | Coahuila | 181252 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-15 04:20:58 | Coahuila, Mexico | |||
2021-03-11 | Mexico | Coahuila | 65613 | 5751 | 0 | 59862 | 27.0587 | -101.7068 | 2021-03-12 05:26:50 | Coahuila, Mexico | ||
2022-03-11 | Mexico | Coahuila | 143800 | 8727 | 0 | 27.0587 | -101.7068 | 2022-03-12 04:20:50 | Coahuila, Mexico | |||
2022-05-07 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-08 04:20:49 | Coahuila, Mexico | |||
2020-07-16 | Mexico | Coahuila | 8163 | 412 | 6619 | 1132 | 27.0587 | -101.7068 | 2020-07-17 04:34:50 | Coahuila, Mexico | ||
2020-08-08 | Mexico | Coahuila | 15262 | 859 | 11928 | 2475 | 27.0587 | -101.7068 | 2020-08-09 04:34:54 | Coahuila, Mexico | ||
2022-09-13 | Mexico | Coahuila | 179809 | 8951 | 0 | 27.0587 | -101.7068 | 2022-09-14 04:20:44 | Coahuila, Mexico | |||
2020-11-06 | Mexico | Coahuila | 35526 | 2581 | 30299 | 2646 | 27.0587 | -101.7068 | 2020-11-07 05:24:52 | Coahuila, Mexico | ||
2021-04-30 | Mexico | Coahuila | 68025 | 6196 | 0 | 61829 | 27.0587 | -101.7068 | 2021-05-01 04:20:47 | Coahuila, Mexico | ||
2022-09-23 | Mexico | Coahuila | 180285 | 8956 | 0 | 27.0587 | -101.7068 | 2022-09-24 04:21:40 | Coahuila, Mexico | |||
2021-04-04 | Mexico | Coahuila | 66747 | 5877 | 0 | 60870 | 27.0587 | -101.7068 | 2021-04-05 04:20:35 | Coahuila, Mexico | ||
2020-11-27 | Mexico | Coahuila | 41112 | 3265 | 0 | 37847 | 27.0587 | -101.7068 | 2020-11-28 05:25:50 | Coahuila, Mexico | ||
2022-10-07 | Mexico | Coahuila | 180427 | 8960 | 0 | 27.0587 | -101.7068 | 2022-10-08 04:22:56 | Coahuila, Mexico | |||
2021-06-29 | Mexico | Coahuila | 69604 | 6414 | 0 | 63190 | 27.0587 | -101.7068 | 2021-06-30 04:21:41 | Coahuila, Mexico | ||
2021-12-07 | Mexico | Coahuila | 98632 | 7644 | 0 | 27.0587 | -101.7068 | 2021-12-08 04:22:46 | Coahuila, Mexico | |||
2021-07-28 | Mexico | Coahuila | 72253 | 6527 | 0 | 65726 | 27.0587 | -101.7068 | 2021-07-29 04:21:33 | Coahuila, Mexico | ||
2020-07-05 | Mexico | Coahuila | 5776 | 268 | 4301 | 1207 | 27.0587 | -101.7068 | 2020-07-06 04:33:57 | Coahuila, Mexico | ||
2022-09-18 | Mexico | Coahuila | 180009 | 8953 | 0 | 27.0587 | -101.7068 | 2022-09-19 04:21:49 | Coahuila, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;