johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "San Luis Potosi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423450 | 423450 | 2021-10-10 | Mexico | San Luis Potosi | 100797 | 6469 | 0 | 22.1565 | -100.9855 | 2021-10-11 04:21:31 | San Luis Potosi, Mexico | |||
427432 | 427432 | 2020-09-07 | Mexico | San Luis Potosi | 19660 | 1298 | 17019 | 1343 | 22.1565 | -100.9855 | 2020-09-08 04:28:25 | San Luis Potosi, Mexico | ||
431458 | 431458 | 2022-11-03 | Mexico | San Luis Potosi | 241296 | 7609 | 0 | 22.1565 | -100.9855 | 2022-11-04 04:22:11 | San Luis Potosi, Mexico | |||
435453 | 435453 | 2021-01-21 | Mexico | San Luis Potosi | 46753 | 3506 | 0 | 43247 | 22.1565 | -100.9855 | 2021-01-22 05:22:10 | San Luis Potosi, Mexico | ||
442694 | 442694 | 2020-07-26 | Mexico | San Luis Potosi | 7588 | 401 | 4293 | 2894 | 22.1565 | -100.9855 | 2020-07-27 04:35:02 | San Luis Potosi, Mexico | ||
443454 | 443454 | 2021-10-20 | Mexico | San Luis Potosi | 102158 | 6536 | 0 | 22.1565 | -100.9855 | 2021-10-21 04:21:18 | San Luis Potosi, Mexico | |||
447470 | 447470 | 2021-11-17 | Mexico | San Luis Potosi | 104337 | 6658 | 0 | 22.1565 | -100.9855 | 2021-11-18 04:21:33 | San Luis Potosi, Mexico | |||
451488 | 451488 | 2022-12-21 | Mexico | San Luis Potosi | 244092 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-22 04:20:56 | San Luis Potosi, Mexico | |||
458720 | 458720 | 2020-08-07 | Mexico | San Luis Potosi | 11688 | 599 | 8853 | 2236 | 22.1565 | -100.9855 | 2020-08-08 04:34:53 | San Luis Potosi, Mexico | ||
459479 | 459479 | 2022-02-02 | Mexico | San Luis Potosi | 155938 | 7104 | 0 | 22.1565 | -100.9855 | 2022-02-03 04:21:21 | San Luis Potosi, Mexico | |||
463496 | 463496 | 2022-05-02 | Mexico | San Luis Potosi | 186174 | 7485 | 0 | 22.1565 | -100.9855 | 2022-05-03 04:21:00 | San Luis Potosi, Mexico | |||
467511 | 467511 | 2021-10-07 | Mexico | San Luis Potosi | 100310 | 6455 | 0 | 22.1565 | -100.9855 | 2021-10-08 04:21:25 | San Luis Potosi, Mexico | |||
471509 | 471509 | 2021-02-19 | Mexico | San Luis Potosi | 55747 | 4340 | 0 | 51407 | 22.1565 | -100.9855 | 2021-02-20 05:22:51 | San Luis Potosi, Mexico | ||
475543 | 475543 | 2022-06-26 | Mexico | San Luis Potosi | 191641 | 7507 | 0 | 22.1565 | -100.9855 | 2022-06-27 04:21:00 | San Luis Potosi, Mexico | |||
479691 | 479691 | 2022-11-08 | Mexico | San Luis Potosi | 241223 | 7609 | 0 | 22.1565 | -100.9855 | 2022-11-09 04:21:22 | San Luis Potosi, Mexico | |||
483688 | 483688 | 2021-07-19 | Mexico | San Luis Potosi | 67100 | 5480 | 0 | 61620 | 22.1565 | -100.9855 | 2021-07-20 04:21:48 | San Luis Potosi, Mexico | ||
487721 | 487721 | 2022-11-25 | Mexico | San Luis Potosi | 241982 | 7613 | 0 | 22.1565 | -100.9855 | 2022-11-26 04:21:11 | San Luis Potosi, Mexico | |||
491735 | 491735 | 2021-10-14 | Mexico | San Luis Potosi | 101438 | 6495 | 0 | 22.1565 | -100.9855 | 2021-10-15 04:21:26 | San Luis Potosi, Mexico | |||
495751 | 495751 | 2021-11-06 | Mexico | San Luis Potosi | 103599 | 6605 | 0 | 22.1565 | -100.9855 | 2021-11-07 04:21:53 | San Luis Potosi, Mexico | |||
499768 | 499768 | 2022-04-02 | Mexico | San Luis Potosi | 185008 | 7459 | 0 | 22.1565 | -100.9855 | 2022-04-03 04:20:48 | San Luis Potosi, Mexico | |||
503785 | 503785 | 2022-12-17 | Mexico | San Luis Potosi | 243857 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-18 04:21:03 | San Luis Potosi, Mexico | |||
507782 | 507782 | 2021-08-14 | Mexico | San Luis Potosi | 79452 | 5610 | 0 | 22.1565 | -100.9855 | 2021-08-15 04:21:41 | San Luis Potosi, Mexico | |||
511796 | 511796 | 2021-08-19 | Mexico | San Luis Potosi | 82996 | 5679 | 0 | 22.1565 | -100.9855 | 2021-08-20 04:21:33 | San Luis Potosi, Mexico | |||
515829 | 515829 | 2022-10-15 | Mexico | San Luis Potosi | 240389 | 7601 | 0 | 22.1565 | -100.9855 | 2022-10-16 04:22:39 | San Luis Potosi, Mexico | |||
522955 | 522955 | 2021-06-09 | Mexico | San Luis Potosi | 64634 | 5407 | 0 | 59227 | 22.1565 | -100.9855 | 2021-06-10 04:23:17 | San Luis Potosi, Mexico | ||
530070 | 530070 | 2020-07-04 | Mexico | San Luis Potosi | 3541 | 172 | 2657 | 712 | 22.1565 | -100.9855 | 2020-07-05 04:33:46 | San Luis Potosi, Mexico | ||
530803 | 530803 | 2021-02-22 | Mexico | San Luis Potosi | 56212 | 4401 | 0 | 51811 | 22.1565 | -100.9855 | 2021-02-23 05:23:41 | San Luis Potosi, Mexico | ||
534835 | 534835 | 2021-10-27 | Mexico | San Luis Potosi | 102706 | 6559 | 0 | 22.1565 | -100.9855 | 2021-10-28 04:22:08 | San Luis Potosi, Mexico | |||
538853 | 538853 | 2022-10-26 | Mexico | San Luis Potosi | 240952 | 7611 | 0 | 22.1565 | -100.9855 | 2022-10-27 04:22:01 | San Luis Potosi, Mexico | |||
542869 | 542869 | 2022-12-15 | Mexico | San Luis Potosi | 243419 | 7618 | 0 | 22.1565 | -100.9855 | 2022-12-16 04:21:01 | San Luis Potosi, Mexico | |||
546849 | 546849 | 2020-09-12 | Mexico | San Luis Potosi | 20585 | 1421 | 17935 | 1229 | 22.1565 | -100.9855 | 2020-09-13 04:30:52 | San Luis Potosi, Mexico | ||
550873 | 550873 | 2021-12-08 | Mexico | San Luis Potosi | 105860 | 6729 | 0 | 22.1565 | -100.9855 | 2021-12-09 04:22:49 | San Luis Potosi, Mexico | |||
554889 | 554889 | 2022-01-16 | Mexico | San Luis Potosi | 127277 | 6871 | 0 | 22.1565 | -100.9855 | 2022-01-17 04:21:08 | San Luis Potosi, Mexico | |||
558907 | 558907 | 2022-06-16 | Mexico | San Luis Potosi | 189007 | 7504 | 0 | 22.1565 | -100.9855 | 2022-06-17 04:20:56 | San Luis Potosi, Mexico | |||
563065 | 563065 | 2021-06-22 | Mexico | San Luis Potosi | 65105 | 5428 | 0 | 59677 | 22.1565 | -100.9855 | 2021-06-23 04:21:46 | San Luis Potosi, Mexico | ||
567203 | 567203 | 2021-10-29 | Mexico | San Luis Potosi | 103008 | 6581 | 0 | 22.1565 | -100.9855 | 2021-10-30 04:22:03 | San Luis Potosi, Mexico | |||
574184 | 574184 | 2020-06-06 | Mexico | San Luis Potosi | 1192 | 65 | 810 | 317 | 22.1565 | -100.9855 | 2020-06-07 03:53:30 | San Luis Potosi, Mexico | ||
574932 | 574932 | 2022-02-25 | Mexico | San Luis Potosi | 177565 | 7380 | 0 | 22.1565 | -100.9855 | 2022-02-26 04:21:12 | San Luis Potosi, Mexico | |||
578930 | 578930 | 2021-07-13 | Mexico | San Luis Potosi | 66366 | 5466 | 0 | 60900 | 22.1565 | -100.9855 | 2021-07-14 04:21:35 | San Luis Potosi, Mexico | ||
582927 | 582927 | 2020-08-13 | Mexico | San Luis Potosi | 13479 | 802 | 10720 | 1957 | 22.1565 | -100.9855 | 2020-08-14 04:51:19 | San Luis Potosi, Mexico | ||
589726 | 589726 | 2021-08-08 | Mexico | San Luis Potosi | 74987 | 5562 | 0 | 22.1565 | -100.9855 | 2021-08-09 04:21:24 | San Luis Potosi, Mexico | |||
593759 | 593759 | 2022-07-01 | Mexico | San Luis Potosi | 194176 | 7517 | 0 | 22.1565 | -100.9855 | 2022-07-02 04:21:16 | San Luis Potosi, Mexico | |||
597773 | 597773 | 2021-10-19 | Mexico | San Luis Potosi | 101993 | 6525 | 0 | 22.1565 | -100.9855 | 2021-10-20 04:21:00 | San Luis Potosi, Mexico | |||
601789 | 601789 | 2021-09-23 | Mexico | San Luis Potosi | 97732 | 6311 | 0 | 22.1565 | -100.9855 | 2021-09-24 04:21:44 | San Luis Potosi, Mexico | |||
605786 | 605786 | 2021-04-09 | Mexico | San Luis Potosi | 60975 | 5046 | 0 | 55929 | 22.1565 | -100.9855 | 2021-04-10 04:20:59 | San Luis Potosi, Mexico | ||
609784 | 609784 | 2020-08-29 | Mexico | San Luis Potosi | 17711 | 1134 | 15017 | 1560 | 22.1565 | -100.9855 | 2020-08-30 04:28:22 | San Luis Potosi, Mexico | ||
613785 | 613785 | 2021-02-08 | Mexico | San Luis Potosi | 53170 | 4034 | 0 | 49136 | 22.1565 | -100.9855 | 2021-02-09 05:23:30 | San Luis Potosi, Mexico | ||
617963 | 617963 | 2022-11-05 | Mexico | San Luis Potosi | 241313 | 7609 | 0 | 22.1565 | -100.9855 | 2022-11-06 04:21:24 | San Luis Potosi, Mexico | |||
621979 | 621979 | 2022-05-22 | Mexico | San Luis Potosi | 187137 | 7487 | 0 | 22.1565 | -100.9855 | 2022-05-26 04:20:50 | San Luis Potosi, Mexico | |||
625976 | 625976 | 2021-07-10 | Mexico | San Luis Potosi | 66200 | 5462 | 0 | 60738 | 22.1565 | -100.9855 | 2021-07-11 04:21:43 | San Luis Potosi, Mexico | ||
630009 | 630009 | 2022-07-12 | Mexico | San Luis Potosi | 201563 | 7526 | 0 | 22.1565 | -100.9855 | 2022-07-13 04:20:58 | San Luis Potosi, Mexico | |||
634023 | 634023 | 2021-10-13 | Mexico | San Luis Potosi | 101253 | 6489 | 0 | 22.1565 | -100.9855 | 2021-10-14 04:21:29 | San Luis Potosi, Mexico | |||
638021 | 638021 | 2021-03-31 | Mexico | San Luis Potosi | 60223 | 4993 | 0 | 55230 | 22.1565 | -100.9855 | 2021-04-01 04:27:05 | San Luis Potosi, Mexico | ||
642036 | 642036 | 2021-09-07 | Mexico | San Luis Potosi | 92920 | 6062 | 0 | 22.1565 | -100.9855 | 2021-09-08 04:21:31 | San Luis Potosi, Mexico | |||
646049 | 646049 | 2021-05-05 | Mexico | San Luis Potosi | 62739 | 5186 | 0 | 57553 | 22.1565 | -100.9855 | 2021-05-06 04:20:38 | San Luis Potosi, Mexico | ||
650064 | 650064 | 2021-08-09 | Mexico | San Luis Potosi | 75220 | 5564 | 0 | 22.1565 | -100.9855 | 2021-08-10 04:21:27 | San Luis Potosi, Mexico | |||
654095 | 654095 | 2021-10-22 | Mexico | San Luis Potosi | 102372 | 6547 | 0 | 22.1565 | -100.9855 | 2021-10-23 04:21:32 | San Luis Potosi, Mexico | |||
658414 | 658414 | 2022-05-13 | Mexico | San Luis Potosi | 186388 | 7484 | 0 | 22.1565 | -100.9855 | 2022-05-14 04:20:48 | San Luis Potosi, Mexico | |||
662394 | 662394 | 2020-08-11 | Mexico | San Luis Potosi | 12851 | 738 | 10204 | 1909 | 22.1565 | -100.9855 | 2020-08-12 04:27:29 | San Luis Potosi, Mexico | ||
666374 | 666374 | 2020-09-16 | Mexico | San Luis Potosi | 21114 | 1457 | 18734 | 923 | 22.1565 | -100.9855 | 2020-09-17 04:22:00 | San Luis Potosi, Mexico | ||
670400 | 670400 | 2022-07-21 | Mexico | San Luis Potosi | 211651 | 7538 | 0 | 22.1565 | -100.9855 | 2022-07-22 04:21:15 | San Luis Potosi, Mexico | |||
674416 | 674416 | 2022-07-30 | Mexico | San Luis Potosi | 218823 | 7544 | 0 | 22.1565 | -100.9855 | 2022-07-31 04:21:02 | San Luis Potosi, Mexico | |||
678409 | 678409 | 2020-11-23 | Mexico | San Luis Potosi | 33149 | 2362 | 0 | 30787 | 22.1565 | -100.9855 | 2020-11-24 05:27:31 | San Luis Potosi, Mexico | ||
682440 | 682440 | 2021-10-24 | Mexico | San Luis Potosi | 102507 | 6551 | 0 | 22.1565 | -100.9855 | 2021-10-25 04:22:31 | San Luis Potosi, Mexico | |||
686456 | 686456 | 2021-11-13 | Mexico | San Luis Potosi | 104076 | 6641 | 0 | 22.1565 | -100.9855 | 2021-11-14 04:21:31 | San Luis Potosi, Mexico | |||
690474 | 690474 | 2022-12-23 | Mexico | San Luis Potosi | 244092 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-24 04:21:02 | San Luis Potosi, Mexico | |||
694489 | 694489 | 2022-03-17 | Mexico | San Luis Potosi | 183015 | 7441 | 0 | 22.1565 | -100.9855 | 2022-03-18 04:20:55 | San Luis Potosi, Mexico | |||
698504 | 698504 | 2021-11-04 | Mexico | San Luis Potosi | 103307 | 6591 | 0 | 22.1565 | -100.9855 | 2021-11-05 04:21:54 | San Luis Potosi, Mexico | |||
702502 | 702502 | 2021-03-16 | Mexico | San Luis Potosi | 59227 | 4758 | 0 | 54469 | 22.1565 | -100.9855 | 2021-03-17 05:25:07 | San Luis Potosi, Mexico | ||
706534 | 706534 | 2021-09-29 | Mexico | San Luis Potosi | 98954 | 6386 | 0 | 22.1565 | -100.9855 | 2021-09-30 04:21:20 | San Luis Potosi, Mexico | |||
710551 | 710551 | 2022-11-01 | Mexico | San Luis Potosi | 241190 | 7609 | 0 | 22.1565 | -100.9855 | 2022-11-02 04:22:09 | San Luis Potosi, Mexico | |||
714565 | 714565 | 2021-11-12 | Mexico | San Luis Potosi | 103993 | 6631 | 0 | 22.1565 | -100.9855 | 2021-11-13 04:21:38 | San Luis Potosi, Mexico | |||
718583 | 718583 | 2022-12-04 | Mexico | San Luis Potosi | 241982 | 7613 | 0 | 22.1565 | -100.9855 | 2022-12-05 04:20:58 | San Luis Potosi, Mexico | |||
722597 | 722597 | 2021-11-20 | Mexico | San Luis Potosi | 104549 | 6666 | 0 | 22.1565 | -100.9855 | 2021-11-21 04:22:13 | San Luis Potosi, Mexico | |||
726595 | 726595 | 2021-05-22 | Mexico | San Luis Potosi | 63933 | 5283 | 0 | 58650 | 22.1565 | -100.9855 | 2021-05-23 04:20:51 | San Luis Potosi, Mexico | ||
730627 | 730627 | 2021-12-27 | Mexico | San Luis Potosi | 107378 | 6808 | 0 | 22.1565 | -100.9855 | 2021-12-28 04:21:47 | San Luis Potosi, Mexico | |||
737667 | 737667 | 2020-06-12 | Mexico | San Luis Potosi | 1570 | 86 | 1045 | 439 | 22.1565 | -100.9855 | 2020-06-13 03:33:14 | San Luis Potosi, Mexico | ||
738398 | 738398 | 2020-12-02 | Mexico | San Luis Potosi | 35160 | 2559 | 0 | 32601 | 22.1565 | -100.9855 | 2020-12-03 05:28:22 | San Luis Potosi, Mexico | ||
742411 | 742411 | 2021-02-20 | Mexico | San Luis Potosi | 55982 | 4378 | 0 | 51604 | 22.1565 | -100.9855 | 2021-02-21 05:24:33 | San Luis Potosi, Mexico | ||
746444 | 746444 | 2022-04-23 | Mexico | San Luis Potosi | 185981 | 7481 | 0 | 22.1565 | -100.9855 | 2022-04-24 04:20:56 | San Luis Potosi, Mexico | |||
753674 | 753674 | 2020-08-01 | Mexico | San Luis Potosi | 9921 | 525 | 6721 | 2675 | 22.1565 | -100.9855 | 2020-08-02 04:34:47 | San Luis Potosi, Mexico | ||
754399 | 754399 | 2020-10-28 | Mexico | San Luis Potosi | 28264 | 1953 | 24968 | 1343 | 22.1565 | -100.9855 | 2020-10-29 04:24:49 | San Luis Potosi, Mexico | ||
758427 | 758427 | 2021-11-26 | Mexico | San Luis Potosi | 105074 | 6689 | 0 | 22.1565 | -100.9855 | 2021-11-27 04:22:45 | San Luis Potosi, Mexico | |||
762410 | 762410 | 2020-10-18 | Mexico | San Luis Potosi | 26190 | 1850 | 23041 | 1299 | 22.1565 | -100.9855 | 2020-10-19 04:24:16 | San Luis Potosi, Mexico | ||
766417 | 766417 | 2020-12-29 | Mexico | San Luis Potosi | 39556 | 3014 | 0 | 36542 | 22.1565 | -100.9855 | 2020-12-30 05:22:34 | San Luis Potosi, Mexico | ||
770448 | 770448 | 2021-10-23 | Mexico | San Luis Potosi | 102507 | 6551 | 0 | 22.1565 | -100.9855 | 2021-10-24 04:21:22 | San Luis Potosi, Mexico | |||
774445 | 774445 | 2021-01-12 | Mexico | San Luis Potosi | 42874 | 3244 | 0 | 39630 | 22.1565 | -100.9855 | 2021-01-13 05:22:15 | San Luis Potosi, Mexico | ||
778459 | 778459 | 2021-07-08 | Mexico | San Luis Potosi | 66044 | 5457 | 0 | 60587 | 22.1565 | -100.9855 | 2021-07-09 04:21:21 | San Luis Potosi, Mexico | ||
782490 | 782490 | 2021-12-13 | Mexico | San Luis Potosi | 106318 | 6745 | 0 | 22.1565 | -100.9855 | 2021-12-14 04:22:38 | San Luis Potosi, Mexico | |||
786473 | 786473 | 2020-10-15 | Mexico | San Luis Potosi | 25437 | 1825 | 22388 | 1224 | 22.1565 | -100.9855 | 2020-10-16 04:24:01 | San Luis Potosi, Mexico | ||
790480 | 790480 | 2021-02-04 | Mexico | San Luis Potosi | 51465 | 3841 | 0 | 47624 | 22.1565 | -100.9855 | 2021-02-05 05:22:38 | San Luis Potosi, Mexico | ||
794515 | 794515 | 2022-10-24 | Mexico | San Luis Potosi | 240799 | 7602 | 0 | 22.1565 | -100.9855 | 2022-10-25 04:21:53 | San Luis Potosi, Mexico | |||
798529 | 798529 | 2021-12-22 | Mexico | San Luis Potosi | 106938 | 6793 | 0 | 22.1565 | -100.9855 | 2021-12-23 04:21:21 | San Luis Potosi, Mexico | |||
805484 | 805484 | 2020-06-01 | Mexico | San Luis Potosi | 957 | 54 | 612 | 291 | 22.1565 | -100.9855 | 2020-06-02 02:33:08 | San Luis Potosi, Mexico | ||
809674 | 809674 | 2021-09-20 | Mexico | San Luis Potosi | 96834 | 6257 | 0 | 22.1565 | -100.9855 | 2021-09-21 04:21:26 | San Luis Potosi, Mexico | |||
813672 | 813672 | 2020-09-05 | Mexico | San Luis Potosi | 19216 | 1289 | 16594 | 1333 | 22.1565 | -100.9855 | 2020-09-06 04:28:33 | San Luis Potosi, Mexico | ||
817663 | 817663 | 2020-10-09 | Mexico | San Luis Potosi | 24279 | 1778 | 21556 | 945 | 22.1565 | -100.9855 | 2020-10-10 04:23:57 | San Luis Potosi, Mexico | ||
821667 | 821667 | 2020-11-19 | Mexico | San Luis Potosi | 32116 | 2309 | 0 | 29807 | 22.1565 | -100.9855 | 2020-11-20 05:26:28 | San Luis Potosi, Mexico | ||
825681 | 825681 | 2021-06-06 | Mexico | San Luis Potosi | 64527 | 5401 | 0 | 59126 | 22.1565 | -100.9855 | 2021-06-07 04:22:51 | San Luis Potosi, Mexico | ||
829695 | 829695 | 2021-07-09 | Mexico | San Luis Potosi | 66122 | 5461 | 0 | 60661 | 22.1565 | -100.9855 | 2021-07-10 04:21:25 | San Luis Potosi, 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]);