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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701592 | 2701592 | 2020-11-20 | Mexico | Colima | 6963 | 735 | 0 | 6228 | 19.1223 | -104.0072 | 2020-11-21 05:25:51 | 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 | ||
122786 | 122786 | 2020-11-18 | Mexico | Colima | 6939 | 733 | 0 | 6206 | 19.1223 | -104.0072 | 2020-11-19 05:25:23 | Colima, Mexico | ||
3338674 | 3338674 | 2020-11-17 | Mexico | Colima | 6932 | 732 | 0 | 6200 | 19.1223 | -104.0072 | 2020-11-18 05:40:31 | Colima, Mexico | ||
3169719 | 3169719 | 2020-11-16 | Mexico | Colima | 6925 | 729 | 0 | 6196 | 19.1223 | -104.0072 | 2020-11-17 05:25:54 | Colima, Mexico | ||
2880287 | 2880287 | 2020-11-15 | Mexico | Colima | 6924 | 729 | 0 | 6195 | 19.1223 | -104.0072 | 2020-11-16 05:25:57 | Colima, Mexico | ||
2915265 | 2915265 | 2020-11-14 | Mexico | Colima | 6920 | 727 | 0 | 6193 | 19.1223 | -104.0072 | 2020-11-15 05:26:53 | Colima, Mexico | ||
2785087 | 2785087 | 2020-11-13 | Mexico | Colima | 6913 | 726 | 0 | 6187 | 19.1223 | -104.0072 | 2020-11-14 05:25:37 | Colima, Mexico | ||
864852 | 864852 | 2020-11-12 | Mexico | Colima | 6899 | 724 | 0 | 6175 | 19.1223 | -104.0072 | 2020-11-13 05:25:30 | Colima, Mexico | ||
3440897 | 3440897 | 2020-11-11 | Mexico | Colima | 6893 | 724 | 5791 | 378 | 19.1223 | -104.0072 | 2020-11-12 05:25:55 | Colima, Mexico | ||
272237 | 272237 | 2020-11-10 | Mexico | Colima | 6851 | 721 | 5791 | 339 | 19.1223 | -104.0072 | 2020-11-11 05:25:30 | Colima, Mexico | ||
1988714 | 1988714 | 2020-11-09 | Mexico | Colima | 6824 | 719 | 5791 | 314 | 19.1223 | -104.0072 | 2020-11-10 05:40:07 | Colima, Mexico | ||
1728566 | 1728566 | 2020-11-08 | Mexico | Colima | 6817 | 764 | 5791 | 262 | 19.1223 | -104.0072 | 2020-11-09 05:25:45 | Colima, Mexico | ||
1544026 | 1544026 | 2020-11-07 | Mexico | Colima | 6797 | 762 | 5751 | 284 | 19.1223 | -104.0072 | 2020-11-08 05:24:56 | Colima, Mexico | ||
376264 | 376264 | 2020-11-06 | Mexico | Colima | 6783 | 759 | 5739 | 285 | 19.1223 | -104.0072 | 2020-11-07 05:24:52 | Colima, Mexico | ||
892202 | 892202 | 2020-11-05 | Mexico | Colima | 6727 | 756 | 5670 | 301 | 19.1223 | -104.0072 | 2020-11-06 05:24:55 | Colima, Mexico | ||
2919264 | 2919264 | 2020-11-04 | Mexico | Colima | 6717 | 751 | 5698 | 268 | 19.1223 | -104.0072 | 2020-11-05 06:05:03 | Colima, Mexico | ||
2498101 | 2498101 | 2020-11-03 | Mexico | Colima | 6661 | 748 | 5621 | 292 | 19.1223 | -104.0072 | 2020-11-04 05:25:09 | Colima, Mexico | ||
3304276 | 3304276 | 2020-11-02 | Mexico | Colima | 6652 | 745 | 5603 | 304 | 19.1223 | -104.0072 | 2020-11-03 06:00:16 | Colima, Mexico | ||
3409525 | 3409525 | 2020-11-01 | Mexico | Colima | 6608 | 744 | 5525 | 339 | 19.1223 | -104.0072 | 2020-11-02 05:25:04 | Colima, Mexico | ||
2080014 | 2080014 | 2020-10-31 | Mexico | Colima | 6554 | 744 | 5467 | 343 | 19.1223 | -104.0072 | 2020-11-01 04:36:19 | Colima, Mexico | ||
2243467 | 2243467 | 2020-10-30 | Mexico | Colima | 6540 | 742 | 5448 | 350 | 19.1223 | -104.0072 | 2020-10-31 04:24:44 | Colima, Mexico | ||
210322 | 210322 | 2020-10-29 | Mexico | Colima | 6486 | 738 | 5386 | 362 | 19.1223 | -104.0072 | 2020-10-30 04:24:49 | 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 | ||
1452668 | 1452668 | 2020-10-27 | Mexico | Colima | 6451 | 728 | 5393 | 330 | 19.1223 | -104.0072 | 2020-10-28 04:24:39 | Colima, Mexico | ||
3480392 | 3480392 | 2020-10-26 | Mexico | Colima | 6417 | 726 | 5351 | 340 | 19.1223 | -104.0072 | 2020-10-27 04:24:45 | Colima, Mexico | ||
8413 | 8413 | 2020-10-25 | Mexico | Colima | 6403 | 721 | 5296 | 386 | 19.1223 | -104.0072 | 2020-10-26 04:25:02 | Colima, Mexico | ||
3651650 | 3651650 | 2020-10-24 | Mexico | Colima | 6367 | 715 | 5249 | 403 | 19.1223 | -104.0072 | 2020-10-25 04:24:36 | Colima, Mexico | ||
1053905 | 1053905 | 2020-10-23 | Mexico | Colima | 6358 | 702 | 5236 | 420 | 19.1223 | -104.0072 | 2020-10-24 04:24:46 | Colima, Mexico | ||
1177575 | 1177575 | 2020-10-22 | Mexico | Colima | 6278 | 689 | 5193 | 396 | 19.1223 | -104.0072 | 2020-10-23 04:24:46 | Colima, Mexico | ||
2191680 | 2191680 | 2020-10-21 | Mexico | Colima | 6248 | 689 | 5133 | 426 | 19.1223 | -104.0072 | 2020-10-22 04:24:27 | Colima, Mexico | ||
3990691 | 3990691 | 2020-10-20 | Mexico | Colima | 6182 | 684 | 5088 | 410 | 19.1223 | -104.0072 | 2020-10-21 04:24:14 | Colima, Mexico | ||
1794711 | 1794711 | 2020-10-19 | Mexico | Colima | 6157 | 674 | 5047 | 436 | 19.1223 | -104.0072 | 2020-10-20 04:24:22 | 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 | ||
1026433 | 1026433 | 2020-10-17 | Mexico | Colima | 6055 | 666 | 4916 | 473 | 19.1223 | -104.0072 | 2020-10-18 04:24:25 | Colima, Mexico | ||
2856928 | 2856928 | 2020-10-16 | Mexico | Colima | 5996 | 646 | 4895 | 455 | 19.1223 | -104.0072 | 2020-10-17 04:24:12 | 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 | ||
79169 | 79169 | 2020-10-14 | Mexico | Colima | 5933 | 635 | 4846 | 452 | 19.1223 | -104.0072 | 2020-10-15 04:24:28 | Colima, Mexico | ||
3781984 | 3781984 | 2020-10-13 | Mexico | Colima | 5852 | 630 | 4783 | 439 | 19.1223 | -104.0072 | 2020-10-14 04:24:05 | Colima, Mexico | ||
2291524 | 2291524 | 2020-10-12 | Mexico | Colima | 5810 | 623 | 4737 | 450 | 19.1223 | -104.0072 | 2020-10-13 04:24:02 | Colima, Mexico | ||
3785977 | 3785977 | 2020-10-11 | Mexico | Colima | 5762 | 619 | 4661 | 482 | 19.1223 | -104.0072 | 2020-10-12 04:23:45 | Colima, Mexico | ||
2602115 | 2602115 | 2020-10-10 | Mexico | Colima | 5706 | 618 | 4588 | 500 | 19.1223 | -104.0072 | 2020-10-11 04:23:46 | 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 | ||
2689763 | 2689763 | 2020-10-08 | Mexico | Colima | 5596 | 613 | 4470 | 513 | 19.1223 | -104.0072 | 2020-10-09 04:23:59 | Colima, Mexico | ||
1041905 | 1041905 | 2020-10-07 | Mexico | Colima | 5533 | 610 | 4431 | 492 | 19.1223 | -104.0072 | 2020-10-08 04:23:56 | Colima, Mexico | ||
3117566 | 3117566 | 2020-10-06 | Mexico | Colima | 5479 | 603 | 4410 | 466 | 19.1223 | -104.0072 | 2020-10-07 04:23:40 | Colima, Mexico | ||
3801978 | 3801978 | 2020-10-05 | Mexico | Colima | 5463 | 596 | 4360 | 507 | 19.1223 | -104.0072 | 2020-10-06 04:23:33 | Colima, Mexico | ||
1822868 | 1822868 | 2020-10-04 | Mexico | Colima | 5149 | 586 | 4062 | 501 | 19.1223 | -104.0072 | 2020-10-05 04:23:33 | Colima, Mexico | ||
2514252 | 2514252 | 2020-10-03 | Mexico | Colima | 5134 | 580 | 4028 | 526 | 19.1223 | -104.0072 | 2020-10-04 04:23:44 | Colima, Mexico | ||
3389470 | 3389470 | 2020-10-02 | Mexico | Colima | 5049 | 579 | 3947 | 523 | 19.1223 | -104.0072 | 2020-10-03 04:23:40 | Colima, Mexico | ||
2379711 | 2379711 | 2020-10-01 | Mexico | Colima | 4958 | 573 | 3902 | 483 | 19.1223 | -104.0072 | 2020-10-02 04:23:51 | Colima, Mexico | ||
1045897 | 1045897 | 2020-09-30 | Mexico | Colima | 4870 | 568 | 3889 | 413 | 19.1223 | -104.0072 | 2020-10-01 04:23:42 | Colima, Mexico | ||
966978 | 966978 | 2020-09-29 | Mexico | Colima | 4831 | 563 | 3864 | 404 | 19.1223 | -104.0072 | 2020-09-30 04:23:33 | Colima, Mexico | ||
1515475 | 1515475 | 2020-09-28 | Mexico | Colima | 4810 | 559 | 3856 | 395 | 19.1223 | -104.0072 | 2020-09-29 04:23:42 | Colima, Mexico | ||
2582063 | 2582063 | 2020-09-27 | Mexico | Colima | 4789 | 557 | 3806 | 426 | 19.1223 | -104.0072 | 2020-09-28 04:23:00 | Colima, Mexico | ||
2614115 | 2614115 | 2020-09-26 | Mexico | Colima | 4721 | 554 | 3738 | 429 | 19.1223 | -104.0072 | 2020-09-27 04:23:00 | Colima, Mexico | ||
2812830 | 2812830 | 2020-09-25 | Mexico | Colima | 4646 | 550 | 3695 | 401 | 19.1223 | -104.0072 | 2020-09-26 04:23:00 | Colima, Mexico | ||
2606107 | 2606107 | 2020-09-24 | Mexico | Colima | 4599 | 544 | 3666 | 389 | 19.1223 | -104.0072 | 2020-09-25 04:23:00 | Colima, Mexico | ||
2653850 | 2653850 | 2020-09-23 | Mexico | Colima | 4544 | 533 | 3661 | 350 | 19.1223 | -104.0072 | 2020-09-24 04:23:00 | Colima, Mexico | ||
3316299 | 3316299 | 2020-09-22 | Mexico | Colima | 4493 | 529 | 3651 | 313 | 19.1223 | -104.0072 | 2020-09-23 04:23:00 | Colima, Mexico | ||
2836898 | 2836898 | 2020-09-21 | Mexico | Colima | 4479 | 526 | 3647 | 306 | 19.1223 | -104.0072 | 2020-09-22 04:23:00 | Colima, Mexico | ||
3093502 | 3093502 | 2020-09-20 | Mexico | Colima | 4439 | 523 | 3609 | 307 | 19.1223 | -104.0072 | 2020-09-21 04:23:00 | Colima, Mexico | ||
2454852 | 2454852 | 2020-09-19 | Mexico | Colima | 4380 | 518 | 3567 | 295 | 19.1223 | -104.0072 | 2020-09-20 04:22:00 | Colima, Mexico | ||
2848921 | 2848921 | 2020-09-18 | Mexico | Colima | 4351 | 514 | 3549 | 288 | 19.1223 | -104.0072 | 2020-09-19 04:22:00 | Colima, Mexico | ||
1121670 | 1121670 | 2020-09-17 | Mexico | Colima | 4337 | 506 | 3535 | 296 | 19.1223 | -104.0072 | 2020-09-18 05:05:00 | 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 | ||
2729084 | 2729084 | 2020-09-15 | Mexico | Colima | 4239 | 499 | 3465 | 275 | 19.1223 | -104.0072 | 2020-09-16 04:22:53 | Colima, Mexico | ||
344356 | 344356 | 2020-09-14 | Mexico | Colima | 4231 | 493 | 3473 | 265 | 19.1223 | -104.0072 | 2020-09-15 03:22:50 | Colima, Mexico | ||
2868795 | 2868795 | 2020-09-13 | Mexico | Colima | 4188 | 490 | 3416 | 282 | 19.1223 | -104.0072 | 2020-09-14 04:26:00 | 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 | ||
1444663 | 1444663 | 2020-09-11 | Mexico | Colima | 4131 | 484 | 3354 | 293 | 19.1223 | -104.0072 | 2020-09-12 04:25:05 | Colima, Mexico | ||
1173264 | 1173264 | 2020-09-10 | Mexico | Colima | 4094 | 479 | 3285 | 330 | 19.1223 | -104.0072 | 2020-09-11 04:46:23 | Colima, Mexico | ||
2171629 | 2171629 | 2020-09-09 | Mexico | Colima | 4036 | 471 | 3245 | 320 | 19.1223 | -104.0072 | 2020-09-10 04:29:01 | Colima, Mexico | ||
1243838 | 1243838 | 2020-09-08 | Mexico | Colima | 3999 | 467 | 3215 | 317 | 19.1223 | -104.0072 | 2020-09-09 04:28:48 | 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 | ||
3161702 | 3161702 | 2020-09-06 | Mexico | Colima | 3951 | 460 | 3129 | 362 | 19.1223 | -104.0072 | 2020-09-07 04:28:30 | 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 | ||
2661857 | 2661857 | 2020-09-04 | Mexico | Colima | 3905 | 453 | 3031 | 421 | 19.1223 | -104.0072 | 2020-09-05 04:28:19 | Colima, Mexico | ||
1354397 | 1354397 | 2020-09-03 | Mexico | Colima | 3855 | 447 | 2948 | 460 | 19.1223 | -104.0072 | 2020-09-04 04:28:26 | Colima, Mexico | ||
1105634 | 1105634 | 2020-09-02 | Mexico | Colima | 3788 | 442 | 2860 | 486 | 19.1223 | -104.0072 | 2020-09-03 04:28:22 | Colima, Mexico | ||
2059963 | 2059963 | 2020-09-01 | Mexico | Colima | 3713 | 437 | 2795 | 481 | 19.1223 | -104.0072 | 2020-09-02 04:28:25 | Colima, Mexico | ||
194148 | 194148 | 2020-08-31 | Mexico | Colima | 3711 | 429 | 2787 | 495 | 19.1223 | -104.0072 | 2020-09-01 04:28:31 | Colima, Mexico | ||
3932107 | 3932107 | 2020-08-30 | Mexico | Colima | 3688 | 428 | 2725 | 535 | 19.1223 | -104.0072 | 2020-08-31 04:28:27 | 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 | ||
1523264 | 1523264 | 2020-08-28 | Mexico | Colima | 3542 | 414 | 2559 | 569 | 19.1223 | -104.0072 | 2020-08-29 04:28:19 | Colima, Mexico | ||
2510265 | 2510265 | 2020-08-27 | Mexico | Colima | 3468 | 407 | 2470 | 591 | 19.1223 | -104.0072 | 2020-08-28 04:28:11 | Colima, Mexico | ||
1996725 | 1996725 | 2020-08-26 | Mexico | Colima | 3413 | 401 | 2428 | 584 | 19.1223 | -104.0072 | 2020-08-27 04:28:15 | Colima, Mexico | ||
3562649 | 3562649 | 2020-08-25 | Mexico | Colima | 3330 | 387 | 2409 | 534 | 19.1223 | -104.0072 | 2020-08-26 04:28:11 | Colima, Mexico | ||
2991353 | 2991353 | 2020-08-24 | Mexico | Colima | 3320 | 375 | 2428 | 517 | 19.1223 | -104.0072 | 2020-08-25 04:28:02 | Colima, Mexico | ||
2215748 | 2215748 | 2020-08-23 | Mexico | Colima | 3265 | 365 | 2333 | 567 | 19.1223 | -104.0072 | 2020-08-24 04:27:56 | Colima, Mexico | ||
2299530 | 2299530 | 2020-08-22 | Mexico | Colima | 3181 | 361 | 2196 | 624 | 19.1223 | -104.0072 | 2020-08-23 04:27:48 | Colima, Mexico | ||
1479637 | 1479637 | 2020-08-21 | Mexico | Colima | 3110 | 349 | 2151 | 610 | 19.1223 | -104.0072 | 2020-08-22 04:27:49 | Colima, Mexico | ||
3484386 | 3484386 | 2020-08-20 | Mexico | Colima | 3044 | 345 | 2096 | 603 | 19.1223 | -104.0072 | 2020-08-21 04:27:41 | Colima, Mexico | ||
206335 | 206335 | 2020-08-19 | Mexico | Colima | 2910 | 336 | 1989 | 585 | 19.1223 | -104.0072 | 2020-08-20 04:27:43 | Colima, Mexico | ||
3178089 | 3178089 | 2020-08-18 | Mexico | Colima | 2828 | 330 | 1937 | 561 | 19.1223 | -104.0072 | 2020-08-19 04:27:00 | Colima, Mexico | ||
837693 | 837693 | 2020-08-17 | Mexico | Colima | 2777 | 322 | 1933 | 522 | 19.1223 | -104.0072 | 2020-08-18 04:27:56 | Colima, Mexico | ||
1556051 | 1556051 | 2020-08-16 | Mexico | Colima | 2728 | 317 | 1862 | 549 | 19.1223 | -104.0072 | 2020-08-17 04:27:20 | Colima, Mexico | ||
146053 | 146053 | 2020-08-15 | Mexico | Colima | 2658 | 314 | 1777 | 567 | 19.1223 | -104.0072 | 2020-08-16 04:27:42 | Colima, Mexico | ||
1612328 | 1612328 | 2020-08-14 | Mexico | Colima | 2577 | 308 | 1681 | 588 | 19.1223 | -104.0072 | 2020-08-15 04:27:31 | 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 |
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]);