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 = "Colima" sorted by rowid
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423435 | 423435 | 2021-10-10 | Mexico | Colima | 32479 | 1943 | 0 | 19.1223 | -104.0072 | 2021-10-11 04:21:31 | Colima, Mexico | |||
427417 | 427417 | 2020-09-07 | Mexico | Colima | 3953 | 462 | 3169 | 322 | 19.1223 | -104.0072 | 2020-09-08 04:28:25 | Colima, Mexico | ||
431443 | 431443 | 2022-11-03 | Mexico | Colima | 67375 | 2242 | 0 | 19.1223 | -104.0072 | 2022-11-04 04:22:11 | Colima, Mexico | |||
435438 | 435438 | 2021-01-21 | Mexico | Colima | 8841 | 858 | 0 | 7983 | 19.1223 | -104.0072 | 2021-01-22 05:22:10 | Colima, Mexico | ||
442399 | 442399 | 2020-07-26 | Mexico | Colima | 1572 | 181 | 832 | 559 | 19.1223 | -104.0072 | 2020-07-27 04:35:02 | Colima, Mexico | ||
443439 | 443439 | 2021-10-20 | Mexico | Colima | 32833 | 1967 | 0 | 19.1223 | -104.0072 | 2021-10-21 04:21:18 | Colima, Mexico | |||
447455 | 447455 | 2021-11-17 | Mexico | Colima | 33245 | 2019 | 0 | 19.1223 | -104.0072 | 2021-11-18 04:21:33 | Colima, Mexico | |||
451473 | 451473 | 2022-12-21 | Mexico | Colima | 67845 | 2244 | 0 | 19.1223 | -104.0072 | 2022-12-22 04:20:56 | Colima, Mexico | |||
458424 | 458424 | 2020-08-07 | Mexico | Colima | 2171 | 261 | 1418 | 492 | 19.1223 | -104.0072 | 2020-08-08 04:34:53 | Colima, Mexico | ||
459464 | 459464 | 2022-02-02 | Mexico | Colima | 46035 | 2078 | 0 | 19.1223 | -104.0072 | 2022-02-03 04:21:21 | Colima, Mexico | |||
463481 | 463481 | 2022-05-02 | Mexico | Colima | 54746 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-03 04:21:00 | Colima, Mexico | |||
467496 | 467496 | 2021-10-07 | Mexico | Colima | 32278 | 1931 | 0 | 19.1223 | -104.0072 | 2021-10-08 04:21:25 | Colima, Mexico | |||
471494 | 471494 | 2021-02-19 | Mexico | Colima | 10230 | 1032 | 0 | 9198 | 19.1223 | -104.0072 | 2021-02-20 05:22:51 | Colima, Mexico | ||
475528 | 475528 | 2022-06-26 | Mexico | Colima | 56766 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-27 04:21:00 | Colima, Mexico | |||
479676 | 479676 | 2022-11-08 | Mexico | Colima | 67402 | 2242 | 0 | 19.1223 | -104.0072 | 2022-11-09 04:21:22 | Colima, Mexico | |||
483673 | 483673 | 2021-07-19 | Mexico | Colima | 13207 | 1233 | 0 | 11974 | 19.1223 | -104.0072 | 2021-07-20 04:21:48 | Colima, Mexico | ||
487706 | 487706 | 2022-11-25 | Mexico | Colima | 67484 | 2242 | 0 | 19.1223 | -104.0072 | 2022-11-26 04:21:11 | Colima, Mexico | |||
491720 | 491720 | 2021-10-14 | Mexico | Colima | 32704 | 1953 | 0 | 19.1223 | -104.0072 | 2021-10-15 04:21:26 | Colima, Mexico | |||
495736 | 495736 | 2021-11-06 | Mexico | Colima | 33199 | 2002 | 0 | 19.1223 | -104.0072 | 2021-11-07 04:21:53 | Colima, Mexico | |||
499753 | 499753 | 2022-04-02 | Mexico | Colima | 54548 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-03 04:20:48 | Colima, Mexico | |||
503770 | 503770 | 2022-12-17 | Mexico | Colima | 67807 | 2243 | 0 | 19.1223 | -104.0072 | 2022-12-18 04:21:03 | Colima, Mexico | |||
507767 | 507767 | 2021-08-14 | Mexico | Colima | 20894 | 1376 | 0 | 19.1223 | -104.0072 | 2021-08-15 04:21:41 | Colima, Mexico | |||
511781 | 511781 | 2021-08-19 | Mexico | Colima | 22692 | 1446 | 0 | 19.1223 | -104.0072 | 2021-08-20 04:21:33 | Colima, Mexico | |||
515814 | 515814 | 2022-10-15 | Mexico | Colima | 67313 | 2242 | 0 | 19.1223 | -104.0072 | 2022-10-16 04:22:39 | Colima, Mexico | |||
522940 | 522940 | 2021-06-09 | Mexico | Colima | 12073 | 1204 | 0 | 10869 | 19.1223 | -104.0072 | 2021-06-10 04:23:17 | Colima, Mexico | ||
529783 | 529783 | 2020-07-04 | Mexico | Colima | 664 | 85 | 431 | 148 | 19.1223 | -104.0072 | 2020-07-05 04:33:46 | Colima, Mexico | ||
530788 | 530788 | 2021-02-22 | Mexico | Colima | 10240 | 1040 | 0 | 9200 | 19.1223 | -104.0072 | 2021-02-23 05:23:41 | Colima, Mexico | ||
534820 | 534820 | 2021-10-27 | Mexico | Colima | 32987 | 1978 | 0 | 19.1223 | -104.0072 | 2021-10-28 04:22:08 | Colima, Mexico | |||
538838 | 538838 | 2022-10-26 | Mexico | Colima | 67371 | 2242 | 0 | 19.1223 | -104.0072 | 2022-10-27 04:22:01 | Colima, Mexico | |||
542854 | 542854 | 2022-12-15 | Mexico | Colima | 67745 | 2243 | 0 | 19.1223 | -104.0072 | 2022-12-16 04:21:01 | Colima, Mexico | |||
546834 | 546834 | 2020-09-12 | Mexico | Colima | 4160 | 486 | 3391 | 283 | 19.1223 | -104.0072 | 2020-09-13 04:30:52 | Colima, Mexico | ||
550858 | 550858 | 2021-12-08 | Mexico | Colima | 33356 | 2036 | 0 | 19.1223 | -104.0072 | 2021-12-09 04:22:49 | Colima, Mexico | |||
554874 | 554874 | 2022-01-16 | Mexico | Colima | 37415 | 2041 | 0 | 19.1223 | -104.0072 | 2022-01-17 04:21:08 | Colima, Mexico | |||
558892 | 558892 | 2022-06-16 | Mexico | Colima | 55877 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-17 04:20:56 | Colima, Mexico | |||
563050 | 563050 | 2021-06-22 | Mexico | Colima | 12221 | 1210 | 0 | 11011 | 19.1223 | -104.0072 | 2021-06-23 04:21:46 | Colima, Mexico | ||
567188 | 567188 | 2021-10-29 | Mexico | Colima | 33074 | 1987 | 0 | 19.1223 | -104.0072 | 2021-10-30 04:22:03 | Colima, Mexico | |||
573925 | 573925 | 2020-06-06 | Mexico | Colima | 205 | 30 | 122 | 53 | 19.1223 | -104.0072 | 2020-06-07 03:53:30 | Colima, Mexico | ||
574917 | 574917 | 2022-02-25 | Mexico | Colima | 53864 | 2159 | 0 | 19.1223 | -104.0072 | 2022-02-26 04:21:12 | Colima, Mexico | |||
578915 | 578915 | 2021-07-13 | Mexico | Colima | 12744 | 1226 | 0 | 11518 | 19.1223 | -104.0072 | 2021-07-14 04:21:35 | Colima, Mexico | ||
582912 | 582912 | 2020-08-13 | Mexico | Colima | 2524 | 305 | 1654 | 565 | 19.1223 | -104.0072 | 2020-08-14 04:51:19 | Colima, Mexico | ||
589711 | 589711 | 2021-08-08 | Mexico | Colima | 18360 | 1300 | 0 | 19.1223 | -104.0072 | 2021-08-09 04:21:24 | Colima, Mexico | |||
593744 | 593744 | 2022-07-01 | Mexico | Colima | 57758 | 2203 | 0 | 19.1223 | -104.0072 | 2022-07-02 04:21:16 | Colima, Mexico | |||
597758 | 597758 | 2021-10-19 | Mexico | Colima | 32776 | 1966 | 0 | 19.1223 | -104.0072 | 2021-10-20 04:21:00 | Colima, Mexico | |||
601774 | 601774 | 2021-09-23 | Mexico | Colima | 30865 | 1856 | 0 | 19.1223 | -104.0072 | 2021-09-24 04:21:44 | Colima, Mexico | |||
605771 | 605771 | 2021-04-09 | Mexico | Colima | 10926 | 1156 | 0 | 9770 | 19.1223 | -104.0072 | 2021-04-10 04:20:59 | Colima, Mexico | ||
609769 | 609769 | 2020-08-29 | Mexico | Colima | 3604 | 422 | 2632 | 550 | 19.1223 | -104.0072 | 2020-08-30 04:28:22 | Colima, Mexico | ||
613770 | 613770 | 2021-02-08 | Mexico | Colima | 9803 | 979 | 0 | 8824 | 19.1223 | -104.0072 | 2021-02-09 05:23:30 | Colima, Mexico | ||
617948 | 617948 | 2022-11-05 | Mexico | Colima | 67391 | 2242 | 0 | 19.1223 | -104.0072 | 2022-11-06 04:21:24 | Colima, Mexico | |||
621964 | 621964 | 2022-05-22 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-26 04:20:50 | Colima, Mexico | |||
625961 | 625961 | 2021-07-10 | Mexico | Colima | 12645 | 1225 | 0 | 11420 | 19.1223 | -104.0072 | 2021-07-11 04:21:43 | Colima, Mexico | ||
629994 | 629994 | 2022-07-12 | Mexico | Colima | 60737 | 2206 | 0 | 19.1223 | -104.0072 | 2022-07-13 04:20:58 | Colima, Mexico | |||
634008 | 634008 | 2021-10-13 | Mexico | Colima | 32656 | 1950 | 0 | 19.1223 | -104.0072 | 2021-10-14 04:21:29 | Colima, Mexico | |||
638006 | 638006 | 2021-03-31 | Mexico | Colima | 10820 | 1142 | 0 | 9678 | 19.1223 | -104.0072 | 2021-04-01 04:27:05 | Colima, Mexico | ||
642021 | 642021 | 2021-09-07 | Mexico | Colima | 27929 | 1694 | 0 | 19.1223 | -104.0072 | 2021-09-08 04:21:31 | Colima, Mexico | |||
646034 | 646034 | 2021-05-05 | Mexico | Colima | 11374 | 1181 | 0 | 10193 | 19.1223 | -104.0072 | 2021-05-06 04:20:38 | Colima, Mexico | ||
650049 | 650049 | 2021-08-09 | Mexico | Colima | 18466 | 1307 | 0 | 19.1223 | -104.0072 | 2021-08-10 04:21:27 | Colima, Mexico | |||
654080 | 654080 | 2021-10-22 | Mexico | Colima | 32893 | 1968 | 0 | 19.1223 | -104.0072 | 2021-10-23 04:21:32 | Colima, Mexico | |||
658399 | 658399 | 2022-05-13 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-14 04:20:48 | Colima, Mexico | |||
662379 | 662379 | 2020-08-11 | Mexico | Colima | 2418 | 292 | 1644 | 482 | 19.1223 | -104.0072 | 2020-08-12 04:27:29 | Colima, Mexico | ||
666359 | 666359 | 2020-09-16 | Mexico | Colima | 4279 | 503 | 3477 | 299 | 19.1223 | -104.0072 | 2020-09-17 04:22:00 | Colima, Mexico | ||
670385 | 670385 | 2022-07-21 | Mexico | Colima | 63703 | 2216 | 0 | 19.1223 | -104.0072 | 2022-07-22 04:21:15 | Colima, Mexico | |||
674401 | 674401 | 2022-07-30 | Mexico | Colima | 65273 | 2219 | 0 | 19.1223 | -104.0072 | 2022-07-31 04:21:02 | Colima, Mexico | |||
678394 | 678394 | 2020-11-23 | Mexico | Colima | 7040 | 741 | 0 | 6299 | 19.1223 | -104.0072 | 2020-11-24 05:27:31 | Colima, Mexico | ||
682425 | 682425 | 2021-10-24 | Mexico | Colima | 32923 | 1969 | 0 | 19.1223 | -104.0072 | 2021-10-25 04:22:31 | Colima, Mexico | |||
686441 | 686441 | 2021-11-13 | Mexico | Colima | 33216 | 2016 | 0 | 19.1223 | -104.0072 | 2021-11-14 04:21:31 | Colima, Mexico | |||
690459 | 690459 | 2022-12-23 | Mexico | Colima | 67845 | 2244 | 0 | 19.1223 | -104.0072 | 2022-12-24 04:21:02 | Colima, Mexico | |||
694474 | 694474 | 2022-03-17 | Mexico | Colima | 54371 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-18 04:20:55 | Colima, Mexico | |||
698489 | 698489 | 2021-11-04 | Mexico | Colima | 33145 | 1993 | 0 | 19.1223 | -104.0072 | 2021-11-05 04:21:54 | Colima, Mexico | |||
702487 | 702487 | 2021-03-16 | Mexico | Colima | 10623 | 1116 | 0 | 9507 | 19.1223 | -104.0072 | 2021-03-17 05:25:07 | Colima, Mexico | ||
706519 | 706519 | 2021-09-29 | Mexico | Colima | 31643 | 1887 | 0 | 19.1223 | -104.0072 | 2021-09-30 04:21:20 | Colima, Mexico | |||
710536 | 710536 | 2022-11-01 | Mexico | Colima | 67369 | 2242 | 0 | 19.1223 | -104.0072 | 2022-11-02 04:22:09 | Colima, Mexico | |||
714550 | 714550 | 2021-11-12 | Mexico | Colima | 33224 | 2014 | 0 | 19.1223 | -104.0072 | 2021-11-13 04:21:38 | Colima, Mexico | |||
718568 | 718568 | 2022-12-04 | Mexico | Colima | 67484 | 2242 | 0 | 19.1223 | -104.0072 | 2022-12-05 04:20:58 | Colima, Mexico | |||
722582 | 722582 | 2021-11-20 | Mexico | Colima | 33259 | 2020 | 0 | 19.1223 | -104.0072 | 2021-11-21 04:22:13 | Colima, Mexico | |||
726580 | 726580 | 2021-05-22 | Mexico | Colima | 11773 | 1190 | 0 | 10583 | 19.1223 | -104.0072 | 2021-05-23 04:20:51 | Colima, Mexico | ||
730612 | 730612 | 2021-12-27 | Mexico | Colima | 33450 | 2039 | 0 | 19.1223 | -104.0072 | 2021-12-28 04:21:47 | Colima, Mexico | |||
737380 | 737380 | 2020-06-12 | Mexico | Colima | 264 | 36 | 151 | 77 | 19.1223 | -104.0072 | 2020-06-13 03:33:14 | Colima, Mexico | ||
738383 | 738383 | 2020-12-02 | Mexico | Colima | 7280 | 754 | 0 | 6526 | 19.1223 | -104.0072 | 2020-12-03 05:28:22 | Colima, Mexico | ||
742396 | 742396 | 2021-02-20 | Mexico | Colima | 10212 | 1036 | 0 | 9176 | 19.1223 | -104.0072 | 2021-02-21 05:24:33 | Colima, Mexico | ||
746429 | 746429 | 2022-04-23 | Mexico | Colima | 54713 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-24 04:20:56 | Colima, Mexico | |||
753378 | 753378 | 2020-08-01 | Mexico | Colima | 1875 | 212 | 1154 | 509 | 19.1223 | -104.0072 | 2020-08-02 04:34:47 | Colima, Mexico | ||
754384 | 754384 | 2020-10-28 | Mexico | Colima | 6465 | 733 | 5409 | 323 | 19.1223 | -104.0072 | 2020-10-29 04:24:49 | Colima, Mexico | ||
758412 | 758412 | 2021-11-26 | Mexico | Colima | 33303 | 2034 | 0 | 19.1223 | -104.0072 | 2021-11-27 04:22:45 | Colima, Mexico | |||
762395 | 762395 | 2020-10-18 | Mexico | Colima | 6113 | 668 | 4983 | 462 | 19.1223 | -104.0072 | 2020-10-19 04:24:16 | Colima, Mexico | ||
766402 | 766402 | 2020-12-29 | Mexico | Colima | 7832 | 795 | 0 | 7037 | 19.1223 | -104.0072 | 2020-12-30 05:22:34 | Colima, Mexico | ||
770433 | 770433 | 2021-10-23 | Mexico | Colima | 32923 | 1969 | 0 | 19.1223 | -104.0072 | 2021-10-24 04:21:22 | Colima, Mexico | |||
774430 | 774430 | 2021-01-12 | Mexico | Colima | 8368 | 826 | 0 | 7542 | 19.1223 | -104.0072 | 2021-01-13 05:22:15 | Colima, Mexico | ||
778444 | 778444 | 2021-07-08 | Mexico | Colima | 12554 | 1225 | 0 | 11329 | 19.1223 | -104.0072 | 2021-07-09 04:21:21 | Colima, Mexico | ||
782475 | 782475 | 2021-12-13 | Mexico | Colima | 33387 | 2040 | 0 | 19.1223 | -104.0072 | 2021-12-14 04:22:38 | Colima, Mexico | |||
786458 | 786458 | 2020-10-15 | Mexico | Colima | 5958 | 640 | 4864 | 454 | 19.1223 | -104.0072 | 2020-10-16 04:24:01 | Colima, Mexico | ||
790465 | 790465 | 2021-02-04 | Mexico | Colima | 9569 | 936 | 0 | 8633 | 19.1223 | -104.0072 | 2021-02-05 05:22:38 | Colima, Mexico | ||
794500 | 794500 | 2022-10-24 | Mexico | Colima | 67355 | 2242 | 0 | 19.1223 | -104.0072 | 2022-10-25 04:21:53 | Colima, Mexico | |||
798514 | 798514 | 2021-12-22 | Mexico | Colima | 33423 | 2039 | 0 | 19.1223 | -104.0072 | 2021-12-23 04:21:21 | Colima, Mexico | |||
805236 | 805236 | 2020-06-01 | Mexico | Colima | 154 | 21 | 95 | 38 | 19.1223 | -104.0072 | 2020-06-02 02:33:08 | Colima, Mexico | ||
809659 | 809659 | 2021-09-20 | Mexico | Colima | 30126 | 1818 | 0 | 19.1223 | -104.0072 | 2021-09-21 04:21:26 | Colima, Mexico | |||
813657 | 813657 | 2020-09-05 | Mexico | Colima | 3939 | 455 | 3099 | 385 | 19.1223 | -104.0072 | 2020-09-06 04:28:33 | Colima, Mexico | ||
817648 | 817648 | 2020-10-09 | Mexico | Colima | 5671 | 616 | 4556 | 499 | 19.1223 | -104.0072 | 2020-10-10 04:23:57 | Colima, Mexico | ||
821652 | 821652 | 2020-11-19 | Mexico | Colima | 6948 | 734 | 0 | 6214 | 19.1223 | -104.0072 | 2020-11-20 05:26:28 | Colima, Mexico | ||
825666 | 825666 | 2021-06-06 | Mexico | Colima | 12030 | 1200 | 0 | 10830 | 19.1223 | -104.0072 | 2021-06-07 04:22:51 | Colima, Mexico | ||
829680 | 829680 | 2021-07-09 | Mexico | Colima | 12602 | 1225 | 0 | 11377 | 19.1223 | -104.0072 | 2021-07-10 04:21:25 | Colima, 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]);