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 = "Michoacan" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
421 | 421 | 2021-12-02 | Mexico | Michoacan | 73623 | 8207 | 0 | 19.5665 | -101.7068 | 2021-12-03 04:23:05 | Michoacan, Mexico | |||
4437 | 4437 | 2021-10-28 | Mexico | Michoacan | 72845 | 8010 | 0 | 19.5665 | -101.7068 | 2021-10-29 04:22:03 | Michoacan, Mexico | |||
16445 | 16445 | 2021-09-18 | Mexico | Michoacan | 68743 | 7312 | 0 | 19.5665 | -101.7068 | 2021-09-19 04:21:34 | Michoacan, Mexico | |||
24492 | 24492 | 2022-03-20 | Mexico | Michoacan | 93609 | 8782 | 0 | 19.5665 | -101.7068 | 2022-03-21 04:20:50 | Michoacan, Mexico | |||
28507 | 28507 | 2021-11-11 | Mexico | Michoacan | 73189 | 8088 | 0 | 19.5665 | -101.7068 | 2021-11-12 04:22:01 | Michoacan, Mexico | |||
32506 | 32506 | 2021-08-25 | Mexico | Michoacan | 63117 | 6682 | 0 | 19.5665 | -101.7068 | 2021-08-26 04:21:28 | Michoacan, Mexico | |||
43799 | 43799 | 2021-11-02 | Mexico | Michoacan | 72982 | 8034 | 0 | 19.5665 | -101.7068 | 2021-11-03 06:22:09 | Michoacan, Mexico | |||
63154 | 63154 | 2022-11-12 | Mexico | Michoacan | 110032 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-13 04:21:14 | Michoacan, Mexico | |||
67151 | 67151 | 2021-09-01 | Mexico | Michoacan | 64996 | 6892 | 0 | 19.5665 | -101.7068 | 2021-09-02 04:21:15 | Michoacan, Mexico | |||
71182 | 71182 | 2022-02-07 | Mexico | Michoacan | 88515 | 8438 | 0 | 19.5665 | -101.7068 | 2022-02-08 04:21:15 | Michoacan, Mexico | |||
87216 | 87216 | 2021-11-09 | Mexico | Michoacan | 73182 | 8084 | 0 | 19.5665 | -101.7068 | 2021-11-10 04:21:38 | Michoacan, Mexico | |||
91234 | 91234 | 2022-07-23 | Mexico | Michoacan | 103137 | 8881 | 0 | 19.5665 | -101.7068 | 2022-07-24 04:20:47 | Michoacan, Mexico | |||
99417 | 99417 | 2022-01-14 | Mexico | Michoacan | 76156 | 8295 | 0 | 19.5665 | -101.7068 | 2022-01-15 04:21:07 | Michoacan, Mexico | |||
103416 | 103416 | 2021-08-15 | Mexico | Michoacan | 59160 | 6401 | 0 | 19.5665 | -101.7068 | 2021-08-16 04:21:31 | Michoacan, Mexico | |||
114844 | 114844 | 2022-09-06 | Mexico | Michoacan | 109439 | 8957 | 0 | 19.5665 | -101.7068 | 2022-09-07 04:20:59 | Michoacan, Mexico | |||
126824 | 126824 | 2022-01-09 | Mexico | Michoacan | 74817 | 8290 | 0 | 19.5665 | -101.7068 | 2022-01-10 04:22:07 | Michoacan, Mexico | |||
130842 | 130842 | 2022-10-04 | Mexico | Michoacan | 109839 | 8965 | 0 | 19.5665 | -101.7068 | 2022-10-05 04:23:06 | Michoacan, Mexico | |||
138062 | 138062 | 2021-12-04 | Mexico | Michoacan | 73654 | 8216 | 0 | 19.5665 | -101.7068 | 2021-12-05 04:22:25 | Michoacan, Mexico | |||
142080 | 142080 | 2022-07-09 | Mexico | Michoacan | 97754 | 8867 | 0 | 19.5665 | -101.7068 | 2022-07-10 04:20:54 | Michoacan, Mexico | |||
150075 | 150075 | 2021-11-29 | Mexico | Michoacan | 73593 | 8201 | 0 | 19.5665 | -101.7068 | 2021-11-30 04:22:53 | Michoacan, Mexico | |||
158104 | 158104 | 2022-03-29 | Mexico | Michoacan | 93852 | 8804 | 0 | 19.5665 | -101.7068 | 2022-03-30 04:20:45 | Michoacan, Mexico | |||
162119 | 162119 | 2021-11-19 | Mexico | Michoacan | 73368 | 8118 | 0 | 19.5665 | -101.7068 | 2021-11-20 04:22:17 | Michoacan, Mexico | |||
166137 | 166137 | 2022-06-21 | Mexico | Michoacan | 94849 | 8857 | 0 | 19.5665 | -101.7068 | 2022-06-22 04:20:54 | Michoacan, Mexico | |||
178116 | 178116 | 2021-09-02 | Mexico | Michoacan | 65349 | 6919 | 0 | 19.5665 | -101.7068 | 2021-09-03 04:21:20 | Michoacan, Mexico | |||
186162 | 186162 | 2022-02-13 | Mexico | Michoacan | 90174 | 8524 | 0 | 19.5665 | -101.7068 | 2022-02-14 04:20:51 | Michoacan, Mexico | |||
198351 | 198351 | 2022-10-19 | Mexico | Michoacan | 109925 | 8971 | 0 | 19.5665 | -101.7068 | 2022-10-20 04:22:59 | Michoacan, Mexico | |||
218072 | 218072 | 2022-12-26 | Mexico | Michoacan | 110650 | 8979 | 0 | 19.5665 | -101.7068 | 2022-12-27 04:21:07 | Michoacan, Mexico | |||
222087 | 222087 | 2022-05-09 | Mexico | Michoacan | 94180 | 8827 | 0 | 19.5665 | -101.7068 | 2022-05-10 04:20:50 | Michoacan, Mexico | |||
229319 | 229319 | 2022-05-31 | Mexico | Michoacan | 94308 | 8848 | 0 | 19.5665 | -101.7068 | 2022-06-01 04:20:55 | Michoacan, Mexico | |||
233334 | 233334 | 2022-02-11 | Mexico | Michoacan | 89402 | 8485 | 0 | 19.5665 | -101.7068 | 2022-02-12 04:21:06 | Michoacan, Mexico | |||
245359 | 245359 | 2021-08-17 | Mexico | Michoacan | 59783 | 6453 | 0 | 19.5665 | -101.7068 | 2021-08-18 04:21:35 | Michoacan, Mexico | |||
249373 | 249373 | 2021-09-04 | Mexico | Michoacan | 66121 | 6987 | 0 | 19.5665 | -101.7068 | 2021-09-05 04:21:33 | Michoacan, Mexico | |||
253406 | 253406 | 2022-09-08 | Mexico | Michoacan | 109439 | 8957 | 0 | 19.5665 | -101.7068 | 2022-09-09 04:21:11 | Michoacan, Mexico | |||
257422 | 257422 | 2022-12-10 | Mexico | Michoacan | 110266 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-11 04:20:50 | Michoacan, Mexico | |||
261624 | 261624 | 2022-03-15 | Mexico | Michoacan | 93381 | 8767 | 0 | 19.5665 | -101.7068 | 2022-03-16 04:20:50 | Michoacan, Mexico | |||
276274 | 276274 | 2021-11-03 | Mexico | Michoacan | 73014 | 8056 | 0 | 19.5665 | -101.7068 | 2021-11-04 04:22:20 | Michoacan, Mexico | |||
288087 | 288087 | 2021-10-31 | Mexico | Michoacan | 72977 | 8030 | 0 | 19.5665 | -101.7068 | 2021-11-01 04:22:01 | Michoacan, Mexico | |||
292105 | 292105 | 2022-11-15 | Mexico | Michoacan | 110044 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-16 04:21:09 | Michoacan, Mexico | |||
303960 | 303960 | 2022-04-16 | Mexico | Michoacan | 94026 | 8820 | 0 | 19.5665 | -101.7068 | 2022-04-17 04:20:59 | Michoacan, Mexico | |||
307977 | 307977 | 2022-12-13 | Mexico | Michoacan | 110374 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-14 04:21:04 | Michoacan, Mexico | |||
311993 | 311993 | 2022-11-13 | Mexico | Michoacan | 110032 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-14 04:21:09 | Michoacan, Mexico | |||
316008 | 316008 | 2022-02-12 | Mexico | Michoacan | 90174 | 8524 | 0 | 19.5665 | -101.7068 | 2022-02-13 04:21:00 | Michoacan, Mexico | |||
320025 | 320025 | 2022-10-30 | Mexico | Michoacan | 110041 | 8974 | 0 | 19.5665 | -101.7068 | 2022-10-31 04:21:36 | Michoacan, Mexico | |||
327999 | 327999 | 2022-12-27 | Mexico | Michoacan | 110685 | 8979 | 0 | 19.5665 | -101.7068 | 2022-12-28 04:21:04 | Michoacan, Mexico | |||
336028 | 336028 | 2022-03-18 | Mexico | Michoacan | 93561 | 8779 | 0 | 19.5665 | -101.7068 | 2022-03-19 04:20:47 | Michoacan, Mexico | |||
348389 | 348389 | 2022-12-14 | Mexico | Michoacan | 110374 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-15 04:20:58 | Michoacan, Mexico | |||
356418 | 356418 | 2022-03-11 | Mexico | Michoacan | 93334 | 8760 | 0 | 19.5665 | -101.7068 | 2022-03-12 04:20:50 | Michoacan, Mexico | |||
360434 | 360434 | 2022-05-07 | Mexico | Michoacan | 94128 | 8824 | 0 | 19.5665 | -101.7068 | 2022-05-08 04:20:49 | Michoacan, Mexico | |||
372289 | 372289 | 2022-09-13 | Mexico | Michoacan | 109601 | 8960 | 0 | 19.5665 | -101.7068 | 2022-09-14 04:20:44 | Michoacan, Mexico | |||
384316 | 384316 | 2022-09-23 | Mexico | Michoacan | 109735 | 8965 | 0 | 19.5665 | -101.7068 | 2022-09-24 04:21:40 | Michoacan, Mexico | |||
396357 | 396357 | 2022-10-07 | Mexico | Michoacan | 109874 | 8967 | 0 | 19.5665 | -101.7068 | 2022-10-08 04:22:56 | Michoacan, Mexico | |||
404385 | 404385 | 2021-12-07 | Mexico | Michoacan | 73686 | 8222 | 0 | 19.5665 | -101.7068 | 2021-12-08 04:22:46 | Michoacan, Mexico | |||
419428 | 419428 | 2022-09-18 | Mexico | Michoacan | 109675 | 8963 | 0 | 19.5665 | -101.7068 | 2022-09-19 04:21:49 | Michoacan, Mexico | |||
423442 | 423442 | 2021-10-10 | Mexico | Michoacan | 71879 | 7764 | 0 | 19.5665 | -101.7068 | 2021-10-11 04:21:31 | Michoacan, Mexico | |||
431450 | 431450 | 2022-11-03 | Mexico | Michoacan | 109972 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-04 04:22:11 | Michoacan, Mexico | |||
443446 | 443446 | 2021-10-20 | Mexico | Michoacan | 72474 | 7931 | 0 | 19.5665 | -101.7068 | 2021-10-21 04:21:18 | Michoacan, Mexico | |||
447462 | 447462 | 2021-11-17 | Mexico | Michoacan | 73347 | 8111 | 0 | 19.5665 | -101.7068 | 2021-11-18 04:21:33 | Michoacan, Mexico | |||
451480 | 451480 | 2022-12-21 | Mexico | Michoacan | 110529 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-22 04:20:56 | Michoacan, Mexico | |||
459471 | 459471 | 2022-02-02 | Mexico | Michoacan | 86200 | 8384 | 0 | 19.5665 | -101.7068 | 2022-02-03 04:21:21 | Michoacan, Mexico | |||
463488 | 463488 | 2022-05-02 | Mexico | Michoacan | 94133 | 8824 | 0 | 19.5665 | -101.7068 | 2022-05-03 04:21:00 | Michoacan, Mexico | |||
467503 | 467503 | 2021-10-07 | Mexico | Michoacan | 71657 | 7739 | 0 | 19.5665 | -101.7068 | 2021-10-08 04:21:25 | Michoacan, Mexico | |||
475535 | 475535 | 2022-06-26 | Mexico | Michoacan | 95190 | 8860 | 0 | 19.5665 | -101.7068 | 2022-06-27 04:21:00 | Michoacan, Mexico | |||
479683 | 479683 | 2022-11-08 | Mexico | Michoacan | 110015 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-09 04:21:22 | Michoacan, Mexico | |||
487713 | 487713 | 2022-11-25 | Mexico | Michoacan | 110091 | 8977 | 0 | 19.5665 | -101.7068 | 2022-11-26 04:21:11 | Michoacan, Mexico | |||
491727 | 491727 | 2021-10-14 | Mexico | Michoacan | 72188 | 7853 | 0 | 19.5665 | -101.7068 | 2021-10-15 04:21:26 | Michoacan, Mexico | |||
495743 | 495743 | 2021-11-06 | Mexico | Michoacan | 73123 | 8068 | 0 | 19.5665 | -101.7068 | 2021-11-07 04:21:53 | Michoacan, Mexico | |||
499760 | 499760 | 2022-04-02 | Mexico | Michoacan | 93918 | 8811 | 0 | 19.5665 | -101.7068 | 2022-04-03 04:20:48 | Michoacan, Mexico | |||
503777 | 503777 | 2022-12-17 | Mexico | Michoacan | 110497 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-18 04:21:03 | Michoacan, Mexico | |||
507774 | 507774 | 2021-08-14 | Mexico | Michoacan | 59160 | 6401 | 0 | 19.5665 | -101.7068 | 2021-08-15 04:21:41 | Michoacan, Mexico | |||
511788 | 511788 | 2021-08-19 | Mexico | Michoacan | 61034 | 6508 | 0 | 19.5665 | -101.7068 | 2021-08-20 04:21:33 | Michoacan, Mexico | |||
515821 | 515821 | 2022-10-15 | Mexico | Michoacan | 109923 | 8971 | 0 | 19.5665 | -101.7068 | 2022-10-16 04:22:39 | Michoacan, Mexico | |||
534827 | 534827 | 2021-10-27 | Mexico | Michoacan | 72740 | 7996 | 0 | 19.5665 | -101.7068 | 2021-10-28 04:22:08 | Michoacan, Mexico | |||
538845 | 538845 | 2022-10-26 | Mexico | Michoacan | 109992 | 8973 | 0 | 19.5665 | -101.7068 | 2022-10-27 04:22:01 | Michoacan, Mexico | |||
542861 | 542861 | 2022-12-15 | Mexico | Michoacan | 110410 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-16 04:21:01 | Michoacan, Mexico | |||
550865 | 550865 | 2021-12-08 | Mexico | Michoacan | 73700 | 8224 | 0 | 19.5665 | -101.7068 | 2021-12-09 04:22:49 | Michoacan, Mexico | |||
554881 | 554881 | 2022-01-16 | Mexico | Michoacan | 77636 | 8300 | 0 | 19.5665 | -101.7068 | 2022-01-17 04:21:08 | Michoacan, Mexico | |||
558899 | 558899 | 2022-06-16 | Mexico | Michoacan | 94647 | 8857 | 0 | 19.5665 | -101.7068 | 2022-06-17 04:20:56 | Michoacan, Mexico | |||
567195 | 567195 | 2021-10-29 | Mexico | Michoacan | 72890 | 8017 | 0 | 19.5665 | -101.7068 | 2021-10-30 04:22:03 | Michoacan, Mexico | |||
574924 | 574924 | 2022-02-25 | Mexico | Michoacan | 92333 | 8655 | 0 | 19.5665 | -101.7068 | 2022-02-26 04:21:12 | Michoacan, Mexico | |||
589718 | 589718 | 2021-08-08 | Mexico | Michoacan | 56497 | 6297 | 0 | 19.5665 | -101.7068 | 2021-08-09 04:21:24 | Michoacan, Mexico | |||
593751 | 593751 | 2022-07-01 | Mexico | Michoacan | 95921 | 8860 | 0 | 19.5665 | -101.7068 | 2022-07-02 04:21:16 | Michoacan, Mexico | |||
597765 | 597765 | 2021-10-19 | Mexico | Michoacan | 72421 | 7904 | 0 | 19.5665 | -101.7068 | 2021-10-20 04:21:00 | Michoacan, Mexico | |||
601781 | 601781 | 2021-09-23 | Mexico | Michoacan | 69858 | 7498 | 0 | 19.5665 | -101.7068 | 2021-09-24 04:21:44 | Michoacan, Mexico | |||
617955 | 617955 | 2022-11-05 | Mexico | Michoacan | 109995 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-06 04:21:24 | Michoacan, Mexico | |||
621971 | 621971 | 2022-05-22 | Mexico | Michoacan | 94237 | 8846 | 0 | 19.5665 | -101.7068 | 2022-05-26 04:20:50 | Michoacan, Mexico | |||
630001 | 630001 | 2022-07-12 | Mexico | Michoacan | 98319 | 8868 | 0 | 19.5665 | -101.7068 | 2022-07-13 04:20:58 | Michoacan, Mexico | |||
634015 | 634015 | 2021-10-13 | Mexico | Michoacan | 72091 | 7835 | 0 | 19.5665 | -101.7068 | 2021-10-14 04:21:29 | Michoacan, Mexico | |||
642028 | 642028 | 2021-09-07 | Mexico | Michoacan | 66617 | 7053 | 0 | 19.5665 | -101.7068 | 2021-09-08 04:21:31 | Michoacan, Mexico | |||
650056 | 650056 | 2021-08-09 | Mexico | Michoacan | 56560 | 6300 | 0 | 19.5665 | -101.7068 | 2021-08-10 04:21:27 | Michoacan, Mexico | |||
654087 | 654087 | 2021-10-22 | Mexico | Michoacan | 72597 | 7964 | 0 | 19.5665 | -101.7068 | 2021-10-23 04:21:32 | Michoacan, Mexico | |||
658406 | 658406 | 2022-05-13 | Mexico | Michoacan | 94180 | 8827 | 0 | 19.5665 | -101.7068 | 2022-05-14 04:20:48 | Michoacan, Mexico | |||
670392 | 670392 | 2022-07-21 | Mexico | Michoacan | 102177 | 8876 | 0 | 19.5665 | -101.7068 | 2022-07-22 04:21:15 | Michoacan, Mexico | |||
674408 | 674408 | 2022-07-30 | Mexico | Michoacan | 104708 | 8889 | 0 | 19.5665 | -101.7068 | 2022-07-31 04:21:02 | Michoacan, Mexico | |||
682432 | 682432 | 2021-10-24 | Mexico | Michoacan | 72683 | 7979 | 0 | 19.5665 | -101.7068 | 2021-10-25 04:22:31 | Michoacan, Mexico | |||
686448 | 686448 | 2021-11-13 | Mexico | Michoacan | 73232 | 8095 | 0 | 19.5665 | -101.7068 | 2021-11-14 04:21:31 | Michoacan, Mexico | |||
690466 | 690466 | 2022-12-23 | Mexico | Michoacan | 110529 | 8977 | 0 | 19.5665 | -101.7068 | 2022-12-24 04:21:02 | Michoacan, Mexico | |||
694481 | 694481 | 2022-03-17 | Mexico | Michoacan | 93561 | 8779 | 0 | 19.5665 | -101.7068 | 2022-03-18 04:20:55 | Michoacan, Mexico | |||
698496 | 698496 | 2021-11-04 | Mexico | Michoacan | 73036 | 8062 | 0 | 19.5665 | -101.7068 | 2021-11-05 04:21:54 | Michoacan, Mexico | |||
706526 | 706526 | 2021-09-29 | Mexico | Michoacan | 70754 | 7597 | 0 | 19.5665 | -101.7068 | 2021-09-30 04:21:20 | Michoacan, Mexico | |||
710543 | 710543 | 2022-11-01 | Mexico | Michoacan | 110041 | 8974 | 0 | 19.5665 | -101.7068 | 2022-11-02 04:22:09 | Michoacan, 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]);