daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Sinaloa" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- …
province_or_state 1
- Sinaloa · 954 ✖
country_or_region 1
- Mexico · 954 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Mexico | Sinaloa | 74602 | 8835 | 0 | 25.1721 | -107.4795 | 2021-12-03 04:23:05 | Sinaloa, Mexico | |||
2021-10-28 | Mexico | Sinaloa | 73326 | 8695 | 0 | 25.1721 | -107.4795 | 2021-10-29 04:22:03 | Sinaloa, Mexico | |||
2020-10-25 | Mexico | Sinaloa | 21403 | 3533 | 17160 | 710 | 25.1721 | -107.4795 | 2020-10-26 04:25:02 | Sinaloa, Mexico | ||
2021-01-26 | Mexico | Sinaloa | 30497 | 4611 | 0 | 25886 | 25.1721 | -107.4795 | 2021-01-27 05:23:41 | Sinaloa, Mexico | ||
2021-09-18 | Mexico | Sinaloa | 70372 | 8325 | 0 | 25.1721 | -107.4795 | 2021-09-19 04:21:34 | Sinaloa, Mexico | |||
2021-05-28 | Mexico | Sinaloa | 39073 | 6145 | 0 | 32928 | 25.1721 | -107.4795 | 2021-05-29 04:20:41 | Sinaloa, Mexico | ||
2022-03-20 | Mexico | Sinaloa | 121042 | 9622 | 0 | 25.1721 | -107.4795 | 2022-03-21 04:20:50 | Sinaloa, Mexico | |||
2021-11-11 | Mexico | Sinaloa | 73853 | 8776 | 0 | 25.1721 | -107.4795 | 2021-11-12 04:22:01 | Sinaloa, Mexico | |||
2021-08-25 | Mexico | Sinaloa | 66638 | 7852 | 0 | 25.1721 | -107.4795 | 2021-08-26 04:21:28 | Sinaloa, Mexico | |||
2021-04-12 | Mexico | Sinaloa | 36838 | 5862 | 0 | 30976 | 25.1721 | -107.4795 | 2021-04-13 04:20:37 | Sinaloa, Mexico | ||
2021-11-02 | Mexico | Sinaloa | 73481 | 8722 | 0 | 25.1721 | -107.4795 | 2021-11-03 06:22:09 | Sinaloa, Mexico | |||
2021-05-29 | Mexico | Sinaloa | 39158 | 6154 | 0 | 33004 | 25.1721 | -107.4795 | 2021-05-30 04:20:55 | Sinaloa, Mexico | ||
2021-03-07 | Mexico | Sinaloa | 34493 | 5379 | 0 | 29114 | 25.1721 | -107.4795 | 2021-03-08 05:24:48 | Sinaloa, Mexico | ||
2020-07-23 | Mexico | Sinaloa | 11918 | 1970 | 9086 | 862 | 25.1721 | -107.4795 | 2020-07-24 03:34:53 | Sinaloa, Mexico | ||
2022-11-12 | Mexico | Sinaloa | 176698 | 9916 | 0 | 25.1721 | -107.4795 | 2022-11-13 04:21:14 | Sinaloa, Mexico | |||
2021-09-01 | Mexico | Sinaloa | 67950 | 7999 | 0 | 25.1721 | -107.4795 | 2021-09-02 04:21:15 | Sinaloa, Mexico | |||
2022-02-07 | Mexico | Sinaloa | 108124 | 9305 | 0 | 25.1721 | -107.4795 | 2022-02-08 04:21:15 | Sinaloa, Mexico | |||
2020-12-03 | Mexico | Sinaloa | 24702 | 4009 | 0 | 20693 | 25.1721 | -107.4795 | 2020-12-04 05:27:27 | Sinaloa, Mexico | ||
2020-10-14 | Mexico | Sinaloa | 20284 | 3429 | 16077 | 778 | 25.1721 | -107.4795 | 2020-10-15 04:24:28 | Sinaloa, Mexico | ||
2021-05-25 | Mexico | Sinaloa | 38850 | 6133 | 0 | 32717 | 25.1721 | -107.4795 | 2021-05-26 04:20:35 | Sinaloa, Mexico | ||
2021-11-09 | Mexico | Sinaloa | 73743 | 8768 | 0 | 25.1721 | -107.4795 | 2021-11-10 04:21:38 | Sinaloa, Mexico | |||
2022-07-23 | Mexico | Sinaloa | 160661 | 9830 | 0 | 25.1721 | -107.4795 | 2022-07-24 04:20:47 | Sinaloa, Mexico | |||
2020-08-04 | Mexico | Sinaloa | 13068 | 2272 | 10072 | 724 | 25.1721 | -107.4795 | 2020-08-05 04:34:43 | Sinaloa, Mexico | ||
2022-01-14 | Mexico | Sinaloa | 82852 | 9045 | 0 | 25.1721 | -107.4795 | 2022-01-15 04:21:07 | Sinaloa, Mexico | |||
2021-08-15 | Mexico | Sinaloa | 63510 | 7393 | 0 | 25.1721 | -107.4795 | 2021-08-16 04:21:31 | Sinaloa, Mexico | |||
2021-06-19 | Mexico | Sinaloa | 40839 | 6360 | 0 | 34479 | 25.1721 | -107.4795 | 2021-06-20 04:21:48 | Sinaloa, Mexico | ||
2022-09-06 | Mexico | Sinaloa | 174145 | 9895 | 0 | 25.1721 | -107.4795 | 2022-09-07 04:20:59 | Sinaloa, Mexico | |||
2020-07-19 | Mexico | Sinaloa | 11314 | 1830 | 8545 | 939 | 25.1721 | -107.4795 | 2020-07-20 05:34:40 | Sinaloa, Mexico | ||
2020-11-18 | Mexico | Sinaloa | 23185 | 3817 | 0 | 19368 | 25.1721 | -107.4795 | 2020-11-19 05:25:23 | Sinaloa, Mexico | ||
2022-01-09 | Mexico | Sinaloa | 79313 | 9037 | 0 | 25.1721 | -107.4795 | 2022-01-10 04:22:07 | Sinaloa, Mexico | |||
2022-10-04 | Mexico | Sinaloa | 175950 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-05 04:23:06 | Sinaloa, Mexico | |||
2021-12-04 | Mexico | Sinaloa | 74684 | 8853 | 0 | 25.1721 | -107.4795 | 2021-12-05 04:22:25 | Sinaloa, Mexico | |||
2022-07-09 | Mexico | Sinaloa | 148222 | 9801 | 0 | 25.1721 | -107.4795 | 2022-07-10 04:20:54 | Sinaloa, Mexico | |||
2020-08-15 | Mexico | Sinaloa | 14466 | 2545 | 11256 | 665 | 25.1721 | -107.4795 | 2020-08-16 04:27:42 | Sinaloa, Mexico | ||
2021-11-29 | Mexico | Sinaloa | 74502 | 8829 | 0 | 25.1721 | -107.4795 | 2021-11-30 04:22:53 | Sinaloa, Mexico | |||
2021-01-08 | Mexico | Sinaloa | 27513 | 4303 | 0 | 23210 | 25.1721 | -107.4795 | 2021-01-09 05:22:18 | Sinaloa, Mexico | ||
2022-03-29 | Mexico | Sinaloa | 121394 | 9639 | 0 | 25.1721 | -107.4795 | 2022-03-30 04:20:45 | Sinaloa, Mexico | |||
2021-11-19 | Mexico | Sinaloa | 74107 | 8799 | 0 | 25.1721 | -107.4795 | 2021-11-20 04:22:17 | Sinaloa, Mexico | |||
2022-06-21 | Mexico | Sinaloa | 133021 | 9777 | 0 | 25.1721 | -107.4795 | 2022-06-22 04:20:54 | Sinaloa, Mexico | |||
2021-04-16 | Mexico | Sinaloa | 37156 | 5923 | 0 | 31233 | 25.1721 | -107.4795 | 2021-04-17 04:20:40 | Sinaloa, Mexico | ||
2020-07-27 | Mexico | Sinaloa | 12338 | 2048 | 9550 | 740 | 25.1721 | -107.4795 | 2020-07-28 04:58:43 | Sinaloa, Mexico | ||
2021-09-02 | Mexico | Sinaloa | 68198 | 8017 | 0 | 25.1721 | -107.4795 | 2021-09-03 04:21:20 | Sinaloa, Mexico | |||
2021-02-21 | Mexico | Sinaloa | 33468 | 5097 | 0 | 28371 | 25.1721 | -107.4795 | 2021-02-22 05:24:21 | Sinaloa, Mexico | ||
2022-02-13 | Mexico | Sinaloa | 112009 | 9393 | 0 | 25.1721 | -107.4795 | 2022-02-14 04:20:51 | Sinaloa, Mexico | |||
2021-01-11 | Mexico | Sinaloa | 27828 | 4322 | 0 | 23506 | 25.1721 | -107.4795 | 2021-01-12 05:22:15 | Sinaloa, Mexico | ||
2020-08-31 | Mexico | Sinaloa | 16104 | 2758 | 12732 | 614 | 25.1721 | -107.4795 | 2020-09-01 04:28:31 | Sinaloa, Mexico | ||
2022-10-19 | Mexico | Sinaloa | 176277 | 9915 | 0 | 25.1721 | -107.4795 | 2022-10-20 04:22:59 | Sinaloa, Mexico | |||
2020-12-25 | Mexico | Sinaloa | 26349 | 4184 | 0 | 22165 | 25.1721 | -107.4795 | 2020-12-26 05:22:28 | Sinaloa, Mexico | ||
2020-08-19 | Mexico | Sinaloa | 14858 | 2594 | 11601 | 663 | 25.1721 | -107.4795 | 2020-08-20 04:27:43 | Sinaloa, Mexico | ||
2020-10-29 | Mexico | Sinaloa | 21745 | 3592 | 17367 | 786 | 25.1721 | -107.4795 | 2020-10-30 04:24:49 | Sinaloa, Mexico | ||
2020-06-08 | Mexico | Sinaloa | 4762 | 732 | 3376 | 654 | 25.1721 | -107.4795 | 2020-06-09 03:33:03 | Sinaloa, Mexico | ||
2022-12-26 | Mexico | Sinaloa | 178373 | 9930 | 0 | 25.1721 | -107.4795 | 2022-12-27 04:21:07 | Sinaloa, Mexico | |||
2022-05-09 | Mexico | Sinaloa | 122053 | 9724 | 0 | 25.1721 | -107.4795 | 2022-05-10 04:20:50 | Sinaloa, Mexico | |||
2022-05-31 | Mexico | Sinaloa | 123533 | 9750 | 0 | 25.1721 | -107.4795 | 2022-06-01 04:20:55 | Sinaloa, Mexico | |||
2022-02-11 | Mexico | Sinaloa | 110087 | 9357 | 0 | 25.1721 | -107.4795 | 2022-02-12 04:21:06 | Sinaloa, Mexico | |||
2021-01-18 | Mexico | Sinaloa | 28907 | 4413 | 0 | 24494 | 25.1721 | -107.4795 | 2021-01-19 05:22:15 | Sinaloa, Mexico | ||
2021-04-02 | Mexico | Sinaloa | 36290 | 5744 | 0 | 30546 | 25.1721 | -107.4795 | 2021-04-03 04:20:44 | Sinaloa, Mexico | ||
2021-08-17 | Mexico | Sinaloa | 64050 | 7469 | 0 | 25.1721 | -107.4795 | 2021-08-18 04:21:35 | Sinaloa, Mexico | |||
2021-09-04 | Mexico | Sinaloa | 68665 | 8052 | 0 | 25.1721 | -107.4795 | 2021-09-05 04:21:33 | Sinaloa, Mexico | |||
2022-09-08 | Mexico | Sinaloa | 174145 | 9895 | 0 | 25.1721 | -107.4795 | 2022-09-09 04:21:11 | Sinaloa, Mexico | |||
2022-12-10 | Mexico | Sinaloa | 177098 | 9926 | 0 | 25.1721 | -107.4795 | 2022-12-11 04:20:50 | Sinaloa, Mexico | |||
2022-03-15 | Mexico | Sinaloa | 120612 | 9594 | 0 | 25.1721 | -107.4795 | 2022-03-16 04:20:50 | Sinaloa, Mexico | |||
2020-05-21 | Mexico | Sinaloa | 2243 | 354 | 1525 | 364 | 25.1721 | -107.4795 | 2020-05-22 02:36:51 | Sinaloa, Mexico | ||
2020-11-10 | Mexico | Sinaloa | 22648 | 3716 | 18245 | 687 | 25.1721 | -107.4795 | 2020-11-11 05:25:30 | Sinaloa, Mexico | ||
2021-11-03 | Mexico | Sinaloa | 73519 | 8731 | 0 | 25.1721 | -107.4795 | 2021-11-04 04:22:20 | Sinaloa, Mexico | |||
2021-02-24 | Mexico | Sinaloa | 33701 | 5167 | 0 | 28534 | 25.1721 | -107.4795 | 2021-02-25 05:24:57 | Sinaloa, Mexico | ||
2020-06-15 | Mexico | Sinaloa | 5854 | 907 | 4307 | 640 | 25.1721 | -107.4795 | 2020-06-16 04:33:09 | Sinaloa, Mexico | ||
2021-10-31 | Mexico | Sinaloa | 73464 | 8723 | 0 | 25.1721 | -107.4795 | 2021-11-01 04:22:01 | Sinaloa, Mexico | |||
2022-11-15 | Mexico | Sinaloa | 176728 | 9917 | 0 | 25.1721 | -107.4795 | 2022-11-16 04:21:09 | Sinaloa, Mexico | |||
2021-07-15 | Mexico | Sinaloa | 48323 | 6579 | 0 | 41744 | 25.1721 | -107.4795 | 2021-07-16 04:21:22 | Sinaloa, Mexico | ||
2020-07-01 | Mexico | Sinaloa | 8456 | 1331 | 6680 | 445 | 25.1721 | -107.4795 | 2020-07-02 04:33:46 | Sinaloa, Mexico | ||
2022-04-16 | Mexico | Sinaloa | 121718 | 9661 | 0 | 25.1721 | -107.4795 | 2022-04-17 04:20:59 | Sinaloa, Mexico | |||
2022-12-13 | Mexico | Sinaloa | 177356 | 9928 | 0 | 25.1721 | -107.4795 | 2022-12-14 04:21:04 | Sinaloa, Mexico | |||
2022-11-13 | Mexico | Sinaloa | 176698 | 9916 | 0 | 25.1721 | -107.4795 | 2022-11-14 04:21:09 | Sinaloa, Mexico | |||
2022-02-12 | Mexico | Sinaloa | 112009 | 9393 | 0 | 25.1721 | -107.4795 | 2022-02-13 04:21:00 | Sinaloa, Mexico | |||
2022-10-30 | Mexico | Sinaloa | 176787 | 9916 | 0 | 25.1721 | -107.4795 | 2022-10-31 04:21:36 | Sinaloa, Mexico | |||
2020-07-20 | Mexico | Sinaloa | 11350 | 1843 | 8676 | 831 | 25.1721 | -107.4795 | 2020-07-21 04:38:46 | Sinaloa, Mexico | ||
2022-12-27 | Mexico | Sinaloa | 178462 | 9933 | 0 | 25.1721 | -107.4795 | 2022-12-28 04:21:04 | Sinaloa, Mexico | |||
2021-08-04 | Mexico | Sinaloa | 59046 | 7117 | 0 | 51929 | 25.1721 | -107.4795 | 2021-08-05 04:21:51 | Sinaloa, Mexico | ||
2022-03-18 | Mexico | Sinaloa | 120883 | 9608 | 0 | 25.1721 | -107.4795 | 2022-03-19 04:20:47 | Sinaloa, Mexico | |||
2021-02-03 | Mexico | Sinaloa | 31521 | 4798 | 0 | 26723 | 25.1721 | -107.4795 | 2021-02-04 05:22:26 | Sinaloa, Mexico | ||
2020-09-14 | Mexico | Sinaloa | 17354 | 2983 | 13850 | 521 | 25.1721 | -107.4795 | 2020-09-15 03:22:50 | Sinaloa, Mexico | ||
2022-12-14 | Mexico | Sinaloa | 177356 | 9928 | 0 | 25.1721 | -107.4795 | 2022-12-15 04:20:58 | Sinaloa, Mexico | |||
2021-03-11 | Mexico | Sinaloa | 34802 | 5423 | 0 | 29379 | 25.1721 | -107.4795 | 2021-03-12 05:26:50 | Sinaloa, Mexico | ||
2022-03-11 | Mexico | Sinaloa | 120325 | 9568 | 0 | 25.1721 | -107.4795 | 2022-03-12 04:20:50 | Sinaloa, Mexico | |||
2022-05-07 | Mexico | Sinaloa | 121933 | 9719 | 0 | 25.1721 | -107.4795 | 2022-05-08 04:20:49 | Sinaloa, Mexico | |||
2020-07-16 | Mexico | Sinaloa | 10859 | 1739 | 8572 | 548 | 25.1721 | -107.4795 | 2020-07-17 04:34:50 | Sinaloa, Mexico | ||
2020-08-08 | Mexico | Sinaloa | 13729 | 2380 | 10510 | 839 | 25.1721 | -107.4795 | 2020-08-09 04:34:54 | Sinaloa, Mexico | ||
2022-09-13 | Mexico | Sinaloa | 174630 | 9899 | 0 | 25.1721 | -107.4795 | 2022-09-14 04:20:44 | Sinaloa, Mexico | |||
2020-11-06 | Mexico | Sinaloa | 22403 | 3695 | 18099 | 609 | 25.1721 | -107.4795 | 2020-11-07 05:24:52 | Sinaloa, Mexico | ||
2021-04-30 | Mexico | Sinaloa | 37822 | 6029 | 0 | 31793 | 25.1721 | -107.4795 | 2021-05-01 04:20:47 | Sinaloa, Mexico | ||
2022-09-23 | Mexico | Sinaloa | 175414 | 9908 | 0 | 25.1721 | -107.4795 | 2022-09-24 04:21:40 | Sinaloa, Mexico | |||
2021-04-04 | Mexico | Sinaloa | 36310 | 5744 | 0 | 30566 | 25.1721 | -107.4795 | 2021-04-05 04:20:35 | Sinaloa, Mexico | ||
2020-11-27 | Mexico | Sinaloa | 24213 | 3956 | 0 | 20257 | 25.1721 | -107.4795 | 2020-11-28 05:25:50 | Sinaloa, Mexico | ||
2022-10-07 | Mexico | Sinaloa | 176172 | 9910 | 0 | 25.1721 | -107.4795 | 2022-10-08 04:22:56 | Sinaloa, Mexico | |||
2021-06-29 | Mexico | Sinaloa | 42398 | 6405 | 0 | 35993 | 25.1721 | -107.4795 | 2021-06-30 04:21:41 | Sinaloa, Mexico | ||
2021-12-07 | Mexico | Sinaloa | 74748 | 8859 | 0 | 25.1721 | -107.4795 | 2021-12-08 04:22:46 | Sinaloa, Mexico | |||
2021-07-28 | Mexico | Sinaloa | 55636 | 6925 | 0 | 48711 | 25.1721 | -107.4795 | 2021-07-29 04:21:33 | Sinaloa, Mexico | ||
2020-07-05 | Mexico | Sinaloa | 8961 | 1413 | 7245 | 303 | 25.1721 | -107.4795 | 2020-07-06 04:33:57 | Sinaloa, Mexico | ||
2022-09-18 | Mexico | Sinaloa | 175037 | 9901 | 0 | 25.1721 | -107.4795 | 2022-09-19 04:21:49 | Sinaloa, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;