daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Sinaloa" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-28 | Mexico | Sinaloa | 15848 | 2733 | 12400 | 715 | 25.1721 | -107.4795 | 2020-08-29 04:28:19 | Sinaloa, Mexico | ||
2020-08-29 | Mexico | Sinaloa | 15988 | 2747 | 12460 | 781 | 25.1721 | -107.4795 | 2020-08-30 04:28:22 | Sinaloa, Mexico | ||
2020-08-30 | Mexico | Sinaloa | 16016 | 2753 | 12539 | 724 | 25.1721 | -107.4795 | 2020-08-31 04:28:27 | Sinaloa, Mexico | ||
2020-08-31 | Mexico | Sinaloa | 16104 | 2758 | 12732 | 614 | 25.1721 | -107.4795 | 2020-09-01 04:28:31 | Sinaloa, Mexico | ||
2020-09-01 | Mexico | Sinaloa | 16244 | 2801 | 12821 | 622 | 25.1721 | -107.4795 | 2020-09-02 04:28:25 | Sinaloa, Mexico | ||
2020-09-02 | Mexico | Sinaloa | 16385 | 2831 | 12856 | 698 | 25.1721 | -107.4795 | 2020-09-03 04:28:22 | Sinaloa, Mexico | ||
2020-09-03 | Mexico | Sinaloa | 16443 | 2840 | 12889 | 714 | 25.1721 | -107.4795 | 2020-09-04 04:28:26 | Sinaloa, Mexico | ||
2020-09-04 | Mexico | Sinaloa | 16589 | 2855 | 13009 | 725 | 25.1721 | -107.4795 | 2020-09-05 04:28:19 | Sinaloa, Mexico | ||
2020-09-05 | Mexico | Sinaloa | 16671 | 2868 | 13055 | 748 | 25.1721 | -107.4795 | 2020-09-06 04:28:33 | Sinaloa, Mexico | ||
2020-09-06 | Mexico | Sinaloa | 16713 | 2872 | 13146 | 695 | 25.1721 | -107.4795 | 2020-09-07 04:28:30 | Sinaloa, Mexico | ||
2020-09-07 | Mexico | Sinaloa | 16752 | 2879 | 13235 | 638 | 25.1721 | -107.4795 | 2020-09-08 04:28:25 | Sinaloa, Mexico | ||
2020-09-08 | Mexico | Sinaloa | 16925 | 2895 | 13389 | 641 | 25.1721 | -107.4795 | 2020-09-09 04:28:48 | Sinaloa, Mexico | ||
2020-09-09 | Mexico | Sinaloa | 16996 | 2914 | 13435 | 647 | 25.1721 | -107.4795 | 2020-09-10 04:29:01 | Sinaloa, Mexico | ||
2020-09-10 | Mexico | Sinaloa | 17124 | 2949 | 13481 | 694 | 25.1721 | -107.4795 | 2020-09-11 04:46:23 | Sinaloa, Mexico | ||
2020-09-11 | Mexico | Sinaloa | 17211 | 2957 | 13600 | 654 | 25.1721 | -107.4795 | 2020-09-12 04:25:05 | Sinaloa, Mexico | ||
2020-09-12 | Mexico | Sinaloa | 17289 | 2969 | 13635 | 685 | 25.1721 | -107.4795 | 2020-09-13 04:30:52 | Sinaloa, Mexico | ||
2020-09-13 | Mexico | Sinaloa | 17330 | 2975 | 13716 | 639 | 25.1721 | -107.4795 | 2020-09-14 04:26:00 | Sinaloa, Mexico | ||
2020-09-14 | Mexico | Sinaloa | 17354 | 2983 | 13850 | 521 | 25.1721 | -107.4795 | 2020-09-15 03:22:50 | Sinaloa, Mexico | ||
2020-09-15 | Mexico | Sinaloa | 17482 | 2993 | 13983 | 506 | 25.1721 | -107.4795 | 2020-09-16 04:22:53 | Sinaloa, Mexico | ||
2020-09-16 | Mexico | Sinaloa | 17498 | 3004 | 13977 | 517 | 25.1721 | -107.4795 | 2020-09-17 04:22:00 | Sinaloa, Mexico | ||
2020-09-17 | Mexico | Sinaloa | 17513 | 3004 | 14074 | 435 | 25.1721 | -107.4795 | 2020-09-18 05:05:00 | Sinaloa, Mexico | ||
2020-09-18 | Mexico | Sinaloa | 17669 | 3019 | 14136 | 514 | 25.1721 | -107.4795 | 2020-09-19 04:22:00 | Sinaloa, Mexico | ||
2020-09-19 | Mexico | Sinaloa | 17772 | 3031 | 14186 | 555 | 25.1721 | -107.4795 | 2020-09-20 04:22:00 | Sinaloa, Mexico | ||
2020-09-20 | Mexico | Sinaloa | 17853 | 3052 | 14261 | 540 | 25.1721 | -107.4795 | 2020-09-21 04:23:00 | Sinaloa, Mexico | ||
2020-09-21 | Mexico | Sinaloa | 17872 | 3065 | 14350 | 457 | 25.1721 | -107.4795 | 2020-09-22 04:23:00 | Sinaloa, Mexico | ||
2020-09-22 | Mexico | Sinaloa | 18041 | 3082 | 14478 | 481 | 25.1721 | -107.4795 | 2020-09-23 04:23:00 | Sinaloa, Mexico | ||
2020-09-23 | Mexico | Sinaloa | 18138 | 3096 | 14470 | 572 | 25.1721 | -107.4795 | 2020-09-24 04:23:00 | Sinaloa, Mexico | ||
2020-09-24 | Mexico | Sinaloa | 18197 | 3106 | 14527 | 564 | 25.1721 | -107.4795 | 2020-09-25 04:23:00 | Sinaloa, Mexico | ||
2020-09-25 | Mexico | Sinaloa | 18341 | 3119 | 14614 | 608 | 25.1721 | -107.4795 | 2020-09-26 04:23:00 | Sinaloa, Mexico | ||
2020-09-26 | Mexico | Sinaloa | 18443 | 3128 | 14677 | 638 | 25.1721 | -107.4795 | 2020-09-27 04:23:00 | Sinaloa, Mexico | ||
2020-09-27 | Mexico | Sinaloa | 18495 | 3142 | 14751 | 602 | 25.1721 | -107.4795 | 2020-09-28 04:23:00 | Sinaloa, Mexico | ||
2020-09-28 | Mexico | Sinaloa | 18518 | 3150 | 14860 | 508 | 25.1721 | -107.4795 | 2020-09-29 04:23:42 | Sinaloa, Mexico | ||
2020-09-29 | Mexico | Sinaloa | 18619 | 3167 | 14953 | 499 | 25.1721 | -107.4795 | 2020-09-30 04:23:33 | Sinaloa, Mexico | ||
2020-09-30 | Mexico | Sinaloa | 18683 | 3194 | 14976 | 513 | 25.1721 | -107.4795 | 2020-10-01 04:23:42 | Sinaloa, Mexico | ||
2020-10-01 | Mexico | Sinaloa | 18795 | 3196 | 14944 | 655 | 25.1721 | -107.4795 | 2020-10-02 04:23:51 | Sinaloa, Mexico | ||
2020-10-02 | Mexico | Sinaloa | 18914 | 3218 | 14993 | 703 | 25.1721 | -107.4795 | 2020-10-03 04:23:40 | Sinaloa, Mexico | ||
2020-10-03 | Mexico | Sinaloa | 19032 | 3230 | 15054 | 748 | 25.1721 | -107.4795 | 2020-10-04 04:23:44 | Sinaloa, Mexico | ||
2020-10-04 | Mexico | Sinaloa | 19063 | 3250 | 15161 | 652 | 25.1721 | -107.4795 | 2020-10-05 04:23:33 | Sinaloa, Mexico | ||
2020-10-05 | Mexico | Sinaloa | 19378 | 3317 | 15405 | 656 | 25.1721 | -107.4795 | 2020-10-06 04:23:33 | Sinaloa, Mexico | ||
2020-10-06 | Mexico | Sinaloa | 19551 | 3335 | 15606 | 610 | 25.1721 | -107.4795 | 2020-10-07 04:23:40 | Sinaloa, Mexico | ||
2020-10-07 | Mexico | Sinaloa | 19665 | 3345 | 15638 | 682 | 25.1721 | -107.4795 | 2020-10-08 04:23:56 | Sinaloa, Mexico | ||
2020-10-08 | Mexico | Sinaloa | 19731 | 3357 | 15705 | 669 | 25.1721 | -107.4795 | 2020-10-09 04:23:59 | Sinaloa, Mexico | ||
2020-10-09 | Mexico | Sinaloa | 19791 | 3368 | 15771 | 652 | 25.1721 | -107.4795 | 2020-10-10 04:23:57 | Sinaloa, Mexico | ||
2020-10-10 | Mexico | Sinaloa | 19880 | 3378 | 15836 | 666 | 25.1721 | -107.4795 | 2020-10-11 04:23:46 | Sinaloa, Mexico | ||
2020-10-11 | Mexico | Sinaloa | 19996 | 3398 | 15948 | 650 | 25.1721 | -107.4795 | 2020-10-12 04:23:45 | Sinaloa, Mexico | ||
2020-10-12 | Mexico | Sinaloa | 20108 | 3403 | 16103 | 602 | 25.1721 | -107.4795 | 2020-10-13 04:24:02 | Sinaloa, Mexico | ||
2020-10-13 | Mexico | Sinaloa | 20176 | 3417 | 16105 | 654 | 25.1721 | -107.4795 | 2020-10-14 04:24:05 | Sinaloa, Mexico | ||
2020-10-14 | Mexico | Sinaloa | 20284 | 3429 | 16077 | 778 | 25.1721 | -107.4795 | 2020-10-15 04:24:28 | Sinaloa, Mexico | ||
2020-10-15 | Mexico | Sinaloa | 20394 | 3438 | 16214 | 742 | 25.1721 | -107.4795 | 2020-10-16 04:24:01 | Sinaloa, Mexico | ||
2020-10-16 | Mexico | Sinaloa | 20488 | 3449 | 16326 | 713 | 25.1721 | -107.4795 | 2020-10-17 04:24:12 | Sinaloa, Mexico | ||
2020-10-17 | Mexico | Sinaloa | 20702 | 3476 | 16435 | 791 | 25.1721 | -107.4795 | 2020-10-18 04:24:25 | Sinaloa, Mexico | ||
2020-10-18 | Mexico | Sinaloa | 20779 | 3480 | 16569 | 730 | 25.1721 | -107.4795 | 2020-10-19 04:24:16 | Sinaloa, Mexico | ||
2020-10-19 | Mexico | Sinaloa | 20855 | 3482 | 16708 | 665 | 25.1721 | -107.4795 | 2020-10-20 04:24:22 | Sinaloa, Mexico | ||
2020-10-20 | Mexico | Sinaloa | 20929 | 3494 | 16748 | 687 | 25.1721 | -107.4795 | 2020-10-21 04:24:14 | Sinaloa, Mexico | ||
2020-10-21 | Mexico | Sinaloa | 20997 | 3504 | 16773 | 720 | 25.1721 | -107.4795 | 2020-10-22 04:24:27 | Sinaloa, Mexico | ||
2020-10-22 | Mexico | Sinaloa | 21077 | 3504 | 16801 | 772 | 25.1721 | -107.4795 | 2020-10-23 04:24:46 | Sinaloa, Mexico | ||
2020-10-23 | Mexico | Sinaloa | 21219 | 3524 | 16879 | 816 | 25.1721 | -107.4795 | 2020-10-24 04:24:46 | Sinaloa, Mexico | ||
2020-10-24 | Mexico | Sinaloa | 21324 | 3533 | 17024 | 767 | 25.1721 | -107.4795 | 2020-10-25 04:24:36 | Sinaloa, Mexico | ||
2020-10-25 | Mexico | Sinaloa | 21403 | 3533 | 17160 | 710 | 25.1721 | -107.4795 | 2020-10-26 04:25:02 | Sinaloa, Mexico | ||
2020-10-26 | Mexico | Sinaloa | 21464 | 3542 | 17262 | 660 | 25.1721 | -107.4795 | 2020-10-27 04:24:45 | Sinaloa, Mexico | ||
2020-10-27 | Mexico | Sinaloa | 21591 | 3556 | 17307 | 728 | 25.1721 | -107.4795 | 2020-10-28 04:24:39 | Sinaloa, Mexico | ||
2020-10-28 | Mexico | Sinaloa | 21669 | 3571 | 17315 | 783 | 25.1721 | -107.4795 | 2020-10-29 04:24:49 | Sinaloa, Mexico | ||
2020-10-29 | Mexico | Sinaloa | 21745 | 3592 | 17367 | 786 | 25.1721 | -107.4795 | 2020-10-30 04:24:49 | Sinaloa, Mexico | ||
2020-10-30 | Mexico | Sinaloa | 21818 | 3597 | 17440 | 781 | 25.1721 | -107.4795 | 2020-10-31 04:24:44 | Sinaloa, Mexico | ||
2020-10-31 | Mexico | Sinaloa | 21890 | 3607 | 17536 | 747 | 25.1721 | -107.4795 | 2020-11-01 04:36:19 | Sinaloa, Mexico | ||
2020-11-01 | Mexico | Sinaloa | 21942 | 3607 | 17622 | 713 | 25.1721 | -107.4795 | 2020-11-02 05:25:04 | Sinaloa, Mexico | ||
2020-11-02 | Mexico | Sinaloa | 21974 | 3613 | 17751 | 610 | 25.1721 | -107.4795 | 2020-11-03 06:00:16 | Sinaloa, Mexico | ||
2020-11-03 | Mexico | Sinaloa | 22076 | 3632 | 17864 | 580 | 25.1721 | -107.4795 | 2020-11-04 05:25:09 | Sinaloa, Mexico | ||
2020-11-04 | Mexico | Sinaloa | 22233 | 3651 | 17979 | 603 | 25.1721 | -107.4795 | 2020-11-05 06:05:03 | Sinaloa, Mexico | ||
2020-11-05 | Mexico | Sinaloa | 22314 | 3669 | 18058 | 587 | 25.1721 | -107.4795 | 2020-11-06 05:24:55 | Sinaloa, Mexico | ||
2020-11-06 | Mexico | Sinaloa | 22403 | 3695 | 18099 | 609 | 25.1721 | -107.4795 | 2020-11-07 05:24:52 | Sinaloa, Mexico | ||
2020-11-07 | Mexico | Sinaloa | 22471 | 3704 | 18140 | 627 | 25.1721 | -107.4795 | 2020-11-08 05:24:56 | Sinaloa, Mexico | ||
2020-11-08 | Mexico | Sinaloa | 22509 | 3704 | 18245 | 560 | 25.1721 | -107.4795 | 2020-11-09 05:25:45 | Sinaloa, Mexico | ||
2020-11-09 | Mexico | Sinaloa | 22575 | 3704 | 18245 | 626 | 25.1721 | -107.4795 | 2020-11-10 05:40:07 | Sinaloa, Mexico | ||
2020-11-10 | Mexico | Sinaloa | 22648 | 3716 | 18245 | 687 | 25.1721 | -107.4795 | 2020-11-11 05:25:30 | Sinaloa, Mexico | ||
2020-11-11 | Mexico | Sinaloa | 22766 | 3733 | 18245 | 788 | 25.1721 | -107.4795 | 2020-11-12 05:25:55 | Sinaloa, Mexico | ||
2020-11-12 | Mexico | Sinaloa | 22812 | 3753 | 0 | 19059 | 25.1721 | -107.4795 | 2020-11-13 05:25:30 | Sinaloa, Mexico | ||
2020-11-13 | Mexico | Sinaloa | 22899 | 3783 | 0 | 19116 | 25.1721 | -107.4795 | 2020-11-14 05:25:37 | Sinaloa, Mexico | ||
2020-11-14 | Mexico | Sinaloa | 22966 | 3790 | 0 | 19176 | 25.1721 | -107.4795 | 2020-11-15 05:26:53 | Sinaloa, Mexico | ||
2020-11-15 | Mexico | Sinaloa | 23030 | 3796 | 0 | 19234 | 25.1721 | -107.4795 | 2020-11-16 05:25:57 | Sinaloa, Mexico | ||
2020-11-16 | Mexico | Sinaloa | 23091 | 3801 | 0 | 19290 | 25.1721 | -107.4795 | 2020-11-17 05:25:54 | Sinaloa, Mexico | ||
2020-11-17 | Mexico | Sinaloa | 23095 | 3801 | 0 | 19294 | 25.1721 | -107.4795 | 2020-11-18 05:40:31 | Sinaloa, Mexico | ||
2020-11-18 | Mexico | Sinaloa | 23185 | 3817 | 0 | 19368 | 25.1721 | -107.4795 | 2020-11-19 05:25:23 | Sinaloa, Mexico | ||
2020-11-19 | Mexico | Sinaloa | 23232 | 3829 | 0 | 19403 | 25.1721 | -107.4795 | 2020-11-20 05:26:28 | Sinaloa, Mexico | ||
2020-11-20 | Mexico | Sinaloa | 23308 | 3848 | 0 | 19460 | 25.1721 | -107.4795 | 2020-11-21 05:25:51 | Sinaloa, Mexico | ||
2020-11-21 | Mexico | Sinaloa | 23408 | 3851 | 0 | 19557 | 25.1721 | -107.4795 | 2020-11-22 05:25:45 | Sinaloa, Mexico | ||
2020-11-22 | Mexico | Sinaloa | 23497 | 3855 | 0 | 19642 | 25.1721 | -107.4795 | 2020-11-23 05:25:26 | Sinaloa, Mexico | ||
2020-11-23 | Mexico | Sinaloa | 23659 | 3863 | 0 | 19796 | 25.1721 | -107.4795 | 2020-11-24 05:27:31 | Sinaloa, Mexico | ||
2020-11-24 | Mexico | Sinaloa | 23871 | 3892 | 0 | 19979 | 25.1721 | -107.4795 | 2020-11-25 05:27:20 | Sinaloa, Mexico | ||
2020-11-25 | Mexico | Sinaloa | 24037 | 3913 | 0 | 20124 | 25.1721 | -107.4795 | 2020-11-26 05:27:44 | Sinaloa, Mexico | ||
2020-11-26 | Mexico | Sinaloa | 24155 | 3942 | 0 | 20213 | 25.1721 | -107.4795 | 2020-11-27 05:26:53 | Sinaloa, Mexico | ||
2020-11-27 | Mexico | Sinaloa | 24213 | 3956 | 0 | 20257 | 25.1721 | -107.4795 | 2020-11-28 05:25:50 | Sinaloa, Mexico | ||
2020-11-28 | Mexico | Sinaloa | 24337 | 3965 | 0 | 20372 | 25.1721 | -107.4795 | 2020-11-29 05:25:55 | Sinaloa, Mexico | ||
2020-11-29 | Mexico | Sinaloa | 24391 | 3966 | 0 | 20425 | 25.1721 | -107.4795 | 2020-11-30 05:26:13 | Sinaloa, Mexico | ||
2020-11-30 | Mexico | Sinaloa | 24486 | 3971 | 0 | 20515 | 25.1721 | -107.4795 | 2020-12-01 05:26:18 | Sinaloa, Mexico | ||
2020-12-01 | Mexico | Sinaloa | 24556 | 3989 | 0 | 20567 | 25.1721 | -107.4795 | 2020-12-02 05:27:41 | Sinaloa, Mexico | ||
2020-12-02 | Mexico | Sinaloa | 24625 | 4002 | 0 | 20623 | 25.1721 | -107.4795 | 2020-12-03 05:28:22 | Sinaloa, Mexico | ||
2020-12-03 | Mexico | Sinaloa | 24702 | 4009 | 0 | 20693 | 25.1721 | -107.4795 | 2020-12-04 05:27:27 | Sinaloa, Mexico | ||
2020-12-04 | Mexico | Sinaloa | 24785 | 4019 | 0 | 20766 | 25.1721 | -107.4795 | 2020-12-05 05:27:36 | Sinaloa, Mexico | ||
2020-12-05 | Mexico | Sinaloa | 24863 | 4020 | 0 | 20843 | 25.1721 | -107.4795 | 2020-12-06 05:26:18 | Sinaloa, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;