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 = "Nayarit" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182131 | 182131 | 2021-02-21 | Mexico | Nayarit | 10683 | 1583 | 0 | 9100 | 21.7514 | -104.8455 | 2021-02-22 05:24:21 | Nayarit, Mexico | ||
742405 | 742405 | 2021-02-20 | Mexico | Nayarit | 10662 | 1581 | 0 | 9081 | 21.7514 | -104.8455 | 2021-02-21 05:24:33 | Nayarit, Mexico | ||
471503 | 471503 | 2021-02-19 | Mexico | Nayarit | 10628 | 1577 | 0 | 9051 | 21.7514 | -104.8455 | 2021-02-20 05:22:51 | Nayarit, Mexico | ||
1153212 | 1153212 | 2021-02-18 | Mexico | Nayarit | 10592 | 1572 | 0 | 9020 | 21.7514 | -104.8455 | 2021-02-19 05:24:16 | Nayarit, Mexico | ||
3601132 | 3601132 | 2021-02-17 | Mexico | Nayarit | 10570 | 1558 | 0 | 9012 | 21.7514 | -104.8455 | 2021-02-18 05:22:58 | Nayarit, Mexico | ||
3050267 | 3050267 | 2021-02-16 | Mexico | Nayarit | 10542 | 1533 | 0 | 9009 | 21.7514 | -104.8455 | 2021-02-17 05:23:10 | Nayarit, Mexico | ||
1338366 | 1338366 | 2021-02-15 | Mexico | Nayarit | 10510 | 1525 | 0 | 8985 | 21.7514 | -104.8455 | 2021-02-16 05:24:38 | Nayarit, Mexico | ||
2283517 | 2283517 | 2021-02-14 | Mexico | Nayarit | 10502 | 1520 | 0 | 8982 | 21.7514 | -104.8455 | 2021-02-15 05:24:49 | Nayarit, Mexico | ||
2677917 | 2677917 | 2021-02-13 | Mexico | Nayarit | 10477 | 1505 | 0 | 8972 | 21.7514 | -104.8455 | 2021-02-14 05:23:43 | Nayarit, Mexico | ||
3539550 | 3539550 | 2021-02-12 | Mexico | Nayarit | 10438 | 1486 | 0 | 8952 | 21.7514 | -104.8455 | 2021-02-13 05:22:12 | Nayarit, Mexico | ||
2637813 | 2637813 | 2021-02-11 | Mexico | Nayarit | 10407 | 1473 | 0 | 8934 | 21.7514 | -104.8455 | 2021-02-12 05:23:29 | Nayarit, Mexico | ||
3978668 | 3978668 | 2021-02-10 | Mexico | Nayarit | 10374 | 1463 | 0 | 8911 | 21.7514 | -104.8455 | 2021-02-11 05:23:55 | Nayarit, Mexico | ||
1527988 | 1527988 | 2021-02-09 | Mexico | Nayarit | 10326 | 1449 | 0 | 8877 | 21.7514 | -104.8455 | 2021-02-10 05:22:41 | Nayarit, Mexico | ||
613779 | 613779 | 2021-02-08 | Mexico | Nayarit | 10281 | 1435 | 0 | 8846 | 21.7514 | -104.8455 | 2021-02-09 05:23:30 | Nayarit, Mexico | ||
1672548 | 1672548 | 2021-02-07 | Mexico | Nayarit | 10259 | 1432 | 0 | 8827 | 21.7514 | -104.8455 | 2021-02-08 05:22:39 | Nayarit, Mexico | ||
975009 | 975009 | 2021-02-06 | Mexico | Nayarit | 10219 | 1419 | 0 | 8800 | 21.7514 | -104.8455 | 2021-02-07 05:23:00 | Nayarit, Mexico | ||
1588267 | 1588267 | 2021-02-05 | Mexico | Nayarit | 10183 | 1407 | 0 | 8776 | 21.7514 | -104.8455 | 2021-02-06 05:23:55 | Nayarit, Mexico | ||
790474 | 790474 | 2021-02-04 | Mexico | Nayarit | 10071 | 1378 | 0 | 8693 | 21.7514 | -104.8455 | 2021-02-05 05:22:38 | Nayarit, Mexico | ||
340366 | 340366 | 2021-02-03 | Mexico | Nayarit | 10071 | 1378 | 0 | 8693 | 21.7514 | -104.8455 | 2021-02-04 05:22:26 | Nayarit, Mexico | ||
1684592 | 1684592 | 2021-02-02 | Mexico | Nayarit | 10044 | 1353 | 0 | 8691 | 21.7514 | -104.8455 | 2021-02-03 05:22:52 | Nayarit, Mexico | ||
1676562 | 1676562 | 2021-02-01 | Mexico | Nayarit | 10021 | 1345 | 0 | 8676 | 21.7514 | -104.8455 | 2021-02-02 05:22:49 | Nayarit, Mexico | ||
1459850 | 1459850 | 2021-01-31 | Mexico | Nayarit | 10000 | 1335 | 0 | 8665 | 21.7514 | -104.8455 | 2021-02-01 05:22:53 | Nayarit, Mexico | ||
2211758 | 2211758 | 2021-01-30 | Mexico | Nayarit | 9965 | 1328 | 0 | 8637 | 21.7514 | -104.8455 | 2021-01-31 05:22:42 | Nayarit, Mexico | ||
1897245 | 1897245 | 2021-01-29 | Mexico | Nayarit | 9882 | 1310 | 0 | 8572 | 21.7514 | -104.8455 | 2021-01-30 05:22:49 | Nayarit, Mexico | ||
2482061 | 2482061 | 2021-01-28 | Mexico | Nayarit | 9782 | 1304 | 0 | 8478 | 21.7514 | -104.8455 | 2021-01-29 05:22:23 | Nayarit, Mexico | ||
3153696 | 3153696 | 2021-01-27 | Mexico | Nayarit | 9638 | 1294 | 0 | 8344 | 21.7514 | -104.8455 | 2021-01-28 05:22:24 | Nayarit, Mexico | ||
12431 | 12431 | 2021-01-26 | Mexico | Nayarit | 9540 | 1268 | 0 | 8272 | 21.7514 | -104.8455 | 2021-01-27 05:23:41 | Nayarit, Mexico | ||
2567755 | 2567755 | 2021-01-25 | Mexico | Nayarit | 9459 | 1259 | 0 | 8200 | 21.7514 | -104.8455 | 2021-01-26 05:22:02 | Nayarit, Mexico | ||
1759387 | 1759387 | 2021-01-24 | Mexico | Nayarit | 9390 | 1255 | 0 | 8135 | 21.7514 | -104.8455 | 2021-01-25 05:22:16 | Nayarit, Mexico | ||
2426994 | 2426994 | 2021-01-23 | Mexico | Nayarit | 9321 | 1244 | 0 | 8077 | 21.7514 | -104.8455 | 2021-01-24 05:22:35 | Nayarit, Mexico | ||
2466896 | 2466896 | 2021-01-22 | Mexico | Nayarit | 9234 | 1205 | 0 | 8029 | 21.7514 | -104.8455 | 2021-01-23 05:22:03 | Nayarit, Mexico | ||
435447 | 435447 | 2021-01-21 | Mexico | Nayarit | 9159 | 1189 | 0 | 7970 | 21.7514 | -104.8455 | 2021-01-22 05:22:10 | Nayarit, Mexico | ||
1094179 | 1094179 | 2021-01-20 | Mexico | Nayarit | 9053 | 1179 | 0 | 7874 | 21.7514 | -104.8455 | 2021-01-21 05:22:01 | Nayarit, Mexico | ||
908269 | 908269 | 2021-01-19 | Mexico | Nayarit | 8937 | 1167 | 0 | 7770 | 21.7514 | -104.8455 | 2021-01-20 05:21:54 | Nayarit, Mexico | ||
237332 | 237332 | 2021-01-18 | Mexico | Nayarit | 8859 | 1154 | 0 | 7705 | 21.7514 | -104.8455 | 2021-01-19 05:22:15 | Nayarit, Mexico | ||
3503449 | 3503449 | 2021-01-17 | Mexico | Nayarit | 8810 | 1136 | 0 | 7674 | 21.7514 | -104.8455 | 2021-01-18 05:22:34 | Nayarit, Mexico | ||
3101532 | 3101532 | 2021-01-16 | Mexico | Nayarit | 8729 | 1133 | 0 | 7596 | 21.7514 | -104.8455 | 2021-01-17 05:22:17 | Nayarit, Mexico | ||
3515494 | 3515494 | 2021-01-15 | Mexico | Nayarit | 8665 | 1121 | 0 | 7544 | 21.7514 | -104.8455 | 2021-01-16 05:22:40 | Nayarit, Mexico | ||
3879667 | 3879667 | 2021-01-14 | Mexico | Nayarit | 8573 | 1118 | 0 | 7455 | 21.7514 | -104.8455 | 2021-01-15 05:22:24 | Nayarit, Mexico | ||
3308294 | 3308294 | 2021-01-13 | Mexico | Nayarit | 8490 | 1113 | 0 | 7377 | 21.7514 | -104.8455 | 2021-01-14 05:22:32 | Nayarit, Mexico | ||
774439 | 774439 | 2021-01-12 | Mexico | Nayarit | 8410 | 1106 | 0 | 7304 | 21.7514 | -104.8455 | 2021-01-13 05:22:15 | Nayarit, Mexico | ||
190160 | 190160 | 2021-01-11 | Mexico | Nayarit | 8348 | 1088 | 0 | 7260 | 21.7514 | -104.8455 | 2021-01-12 05:22:15 | Nayarit, Mexico | ||
2625963 | 2625963 | 2021-01-10 | Mexico | Nayarit | 8313 | 1085 | 0 | 7228 | 21.7514 | -104.8455 | 2021-01-11 05:21:50 | Nayarit, Mexico | ||
3900051 | 3900051 | 2021-01-09 | Mexico | Nayarit | 8278 | 1084 | 0 | 7194 | 21.7514 | -104.8455 | 2021-01-10 05:22:12 | Nayarit, Mexico | ||
154074 | 154074 | 2021-01-08 | Mexico | Nayarit | 8202 | 1075 | 0 | 7127 | 21.7514 | -104.8455 | 2021-01-09 05:22:18 | Nayarit, Mexico | ||
2541498 | 2541498 | 2021-01-07 | Mexico | Nayarit | 8151 | 1071 | 0 | 7080 | 21.7514 | -104.8455 | 2021-01-08 05:22:42 | Nayarit, Mexico | ||
2864807 | 2864807 | 2021-01-06 | Mexico | Nayarit | 8084 | 1065 | 0 | 7019 | 21.7514 | -104.8455 | 2021-01-07 05:22:03 | Nayarit, Mexico | ||
3034394 | 3034394 | 2021-01-05 | Mexico | Nayarit | 8022 | 1062 | 0 | 6960 | 21.7514 | -104.8455 | 2021-01-06 05:22:16 | Nayarit, Mexico | ||
1061939 | 1061939 | 2021-01-04 | Mexico | Nayarit | 7981 | 1054 | 0 | 6927 | 21.7514 | -104.8455 | 2021-01-05 05:21:49 | Nayarit, Mexico | ||
3230542 | 3230542 | 2021-01-03 | Mexico | Nayarit | 7965 | 1054 | 0 | 6911 | 21.7514 | -104.8455 | 2021-01-04 05:22:02 | Nayarit, Mexico | ||
2227611 | 2227611 | 2021-01-02 | Mexico | Nayarit | 7948 | 1053 | 0 | 6895 | 21.7514 | -104.8455 | 2021-01-03 05:22:52 | Nayarit, Mexico | ||
1136975 | 1136975 | 2021-01-01 | Mexico | Nayarit | 7922 | 1053 | 0 | 6869 | 21.7514 | -104.8455 | 2021-01-02 05:22:33 | Nayarit, Mexico | ||
3695581 | 3695581 | 2020-12-31 | Mexico | Nayarit | 7874 | 1050 | 0 | 6824 | 21.7514 | -104.8455 | 2021-01-01 05:23:07 | Nayarit, Mexico | ||
1010396 | 1010396 | 2020-12-30 | Mexico | Nayarit | 7824 | 1048 | 0 | 6776 | 21.7514 | -104.8455 | 2020-12-31 05:22:49 | Nayarit, Mexico | ||
766411 | 766411 | 2020-12-29 | Mexico | Nayarit | 7798 | 1046 | 0 | 6752 | 21.7514 | -104.8455 | 2020-12-30 05:22:34 | Nayarit, Mexico | ||
3761675 | 3761675 | 2020-12-28 | Mexico | Nayarit | 7779 | 1039 | 0 | 6740 | 21.7514 | -104.8455 | 2020-12-29 05:22:37 | Nayarit, Mexico | ||
3777995 | 3777995 | 2020-12-27 | Mexico | Nayarit | 7773 | 1034 | 0 | 6739 | 21.7514 | -104.8455 | 2020-12-28 05:22:06 | Nayarit, Mexico | ||
2223600 | 2223600 | 2020-12-26 | Mexico | Nayarit | 7758 | 1034 | 0 | 6724 | 21.7514 | -104.8455 | 2020-12-27 05:22:55 | Nayarit, Mexico | ||
202347 | 202347 | 2020-12-25 | Mexico | Nayarit | 7740 | 1033 | 0 | 6707 | 21.7514 | -104.8455 | 2020-12-26 05:22:28 | Nayarit, Mexico | ||
3691570 | 3691570 | 2020-12-24 | Mexico | Nayarit | 7708 | 1030 | 0 | 6678 | 21.7514 | -104.8455 | 2020-12-25 05:22:48 | Nayarit, Mexico | ||
2406922 | 2406922 | 2020-12-23 | Mexico | Nayarit | 7675 | 1028 | 0 | 6647 | 21.7514 | -104.8455 | 2020-12-24 05:23:04 | Nayarit, Mexico | ||
3769968 | 3769968 | 2020-12-22 | Mexico | Nayarit | 7672 | 1022 | 0 | 6650 | 21.7514 | -104.8455 | 2020-12-23 05:22:03 | Nayarit, Mexico | ||
927784 | 927784 | 2020-12-21 | Mexico | Nayarit | 7642 | 1020 | 0 | 6622 | 21.7514 | -104.8455 | 2020-12-22 05:22:33 | Nayarit, Mexico | ||
2119805 | 2119805 | 2020-12-20 | Mexico | Nayarit | 7637 | 1016 | 0 | 6621 | 21.7514 | -104.8455 | 2020-12-21 05:27:58 | Nayarit, Mexico | ||
2931312 | 2931312 | 2020-12-19 | Mexico | Nayarit | 7613 | 1015 | 0 | 6598 | 21.7514 | -104.8455 | 2020-12-20 05:27:32 | Nayarit, Mexico | ||
1901258 | 1901258 | 2020-12-18 | Mexico | Nayarit | 7583 | 1013 | 0 | 6570 | 21.7514 | -104.8455 | 2020-12-19 05:27:52 | Nayarit, Mexico | ||
2128084 | 2128084 | 2020-12-17 | Mexico | Nayarit | 7572 | 1011 | 0 | 6561 | 21.7514 | -104.8455 | 2020-12-18 05:28:18 | Nayarit, Mexico | ||
3149684 | 3149684 | 2020-12-16 | Mexico | Nayarit | 7542 | 1008 | 0 | 6534 | 21.7514 | -104.8455 | 2020-12-17 05:28:12 | Nayarit, Mexico | ||
1034465 | 1034465 | 2020-12-15 | Mexico | Nayarit | 7527 | 1007 | 0 | 6520 | 21.7514 | -104.8455 | 2020-12-16 05:28:04 | Nayarit, Mexico | ||
1751359 | 1751359 | 2020-12-14 | Mexico | Nayarit | 7518 | 1000 | 0 | 6518 | 21.7514 | -104.8455 | 2020-12-15 05:26:38 | Nayarit, Mexico | ||
3847879 | 3847879 | 2020-12-13 | Mexico | Nayarit | 7498 | 998 | 0 | 6500 | 21.7514 | -104.8455 | 2020-12-14 05:26:27 | Nayarit, Mexico | ||
845661 | 845661 | 2020-12-12 | Mexico | Nayarit | 7472 | 998 | 0 | 6474 | 21.7514 | -104.8455 | 2020-12-13 05:27:20 | Nayarit, Mexico | ||
860768 | 860768 | 2020-12-11 | Mexico | Nayarit | 7457 | 975 | 0 | 6482 | 21.7514 | -104.8455 | 2020-12-12 05:26:19 | Nayarit, Mexico | ||
1600310 | 1600310 | 2020-12-10 | Mexico | Nayarit | 7433 | 971 | 0 | 6462 | 21.7514 | -104.8455 | 2020-12-11 05:26:59 | Nayarit, Mexico | ||
2975319 | 2975319 | 2020-12-09 | Mexico | Nayarit | 7419 | 966 | 0 | 6453 | 21.7514 | -104.8455 | 2020-12-10 05:26:19 | Nayarit, Mexico | ||
1818879 | 1818879 | 2020-12-08 | Mexico | Nayarit | 7386 | 956 | 0 | 6430 | 21.7514 | -104.8455 | 2020-12-09 05:28:01 | Nayarit, Mexico | ||
2347515 | 2347515 | 2020-12-07 | Mexico | Nayarit | 7369 | 943 | 0 | 6426 | 21.7514 | -104.8455 | 2020-12-08 05:27:42 | Nayarit, Mexico | ||
1006385 | 1006385 | 2020-12-06 | Mexico | Nayarit | 7342 | 943 | 0 | 6399 | 21.7514 | -104.8455 | 2020-12-07 05:26:14 | Nayarit, Mexico | ||
1632394 | 1632394 | 2020-12-05 | Mexico | Nayarit | 7318 | 942 | 0 | 6376 | 21.7514 | -104.8455 | 2020-12-06 05:26:18 | Nayarit, Mexico | ||
3859922 | 3859922 | 2020-12-04 | Mexico | Nayarit | 7294 | 939 | 0 | 6355 | 21.7514 | -104.8455 | 2020-12-05 05:27:36 | Nayarit, Mexico | ||
75180 | 75180 | 2020-12-03 | Mexico | Nayarit | 7265 | 939 | 0 | 6326 | 21.7514 | -104.8455 | 2020-12-04 05:27:27 | Nayarit, Mexico | ||
738392 | 738392 | 2020-12-02 | Mexico | Nayarit | 7253 | 935 | 0 | 6318 | 21.7514 | -104.8455 | 2020-12-03 05:28:22 | Nayarit, Mexico | ||
2537486 | 2537486 | 2020-12-01 | Mexico | Nayarit | 7208 | 932 | 0 | 6276 | 21.7514 | -104.8455 | 2020-12-02 05:27:41 | Nayarit, Mexico | ||
1584255 | 1584255 | 2020-11-30 | Mexico | Nayarit | 7192 | 930 | 0 | 6262 | 21.7514 | -104.8455 | 2020-12-01 05:26:18 | Nayarit, Mexico | ||
3566658 | 3566658 | 2020-11-29 | Mexico | Nayarit | 7178 | 929 | 0 | 6249 | 21.7514 | -104.8455 | 2020-11-30 05:26:13 | Nayarit, Mexico | ||
2935323 | 2935323 | 2020-11-28 | Mexico | Nayarit | 7157 | 978 | 0 | 6179 | 21.7514 | -104.8455 | 2020-11-29 05:25:55 | Nayarit, Mexico | ||
392326 | 392326 | 2020-11-27 | Mexico | Nayarit | 7143 | 927 | 0 | 6216 | 21.7514 | -104.8455 | 2020-11-28 05:25:50 | Nayarit, Mexico | ||
923773 | 923773 | 2020-11-26 | Mexico | Nayarit | 7127 | 916 | 0 | 6211 | 21.7514 | -104.8455 | 2020-11-27 05:26:53 | Nayarit, Mexico | ||
1972678 | 1972678 | 2020-11-25 | Mexico | Nayarit | 7107 | 914 | 0 | 6193 | 21.7514 | -104.8455 | 2020-11-26 05:27:44 | Nayarit, Mexico | ||
1350409 | 1350409 | 2020-11-24 | Mexico | Nayarit | 7088 | 912 | 0 | 6176 | 21.7514 | -104.8455 | 2020-11-25 05:27:20 | Nayarit, Mexico | ||
678403 | 678403 | 2020-11-23 | Mexico | Nayarit | 7072 | 907 | 0 | 6165 | 21.7514 | -104.8455 | 2020-11-24 05:27:31 | Nayarit, Mexico | ||
3190079 | 3190079 | 2020-11-22 | Mexico | Nayarit | 7042 | 905 | 0 | 6137 | 21.7514 | -104.8455 | 2020-11-23 05:25:26 | Nayarit, Mexico | ||
3836573 | 3836573 | 2020-11-21 | Mexico | Nayarit | 7015 | 914 | 0 | 6101 | 21.7514 | -104.8455 | 2020-11-22 05:25:45 | Nayarit, Mexico | ||
2701601 | 2701601 | 2020-11-20 | Mexico | Nayarit | 6997 | 902 | 0 | 6095 | 21.7514 | -104.8455 | 2020-11-21 05:25:51 | Nayarit, Mexico | ||
821661 | 821661 | 2020-11-19 | Mexico | Nayarit | 6987 | 901 | 0 | 6086 | 21.7514 | -104.8455 | 2020-11-20 05:26:28 | Nayarit, Mexico | ||
122795 | 122795 | 2020-11-18 | Mexico | Nayarit | 6966 | 899 | 0 | 6067 | 21.7514 | -104.8455 | 2020-11-19 05:25:23 | Nayarit, Mexico | ||
3338683 | 3338683 | 2020-11-17 | Mexico | Nayarit | 6953 | 897 | 0 | 6056 | 21.7514 | -104.8455 | 2020-11-18 05:40:31 | Nayarit, Mexico | ||
3169728 | 3169728 | 2020-11-16 | Mexico | Nayarit | 6946 | 897 | 0 | 6049 | 21.7514 | -104.8455 | 2020-11-17 05:25:54 | Nayarit, Mexico | ||
2880296 | 2880296 | 2020-11-15 | Mexico | Nayarit | 6943 | 896 | 0 | 6047 | 21.7514 | -104.8455 | 2020-11-16 05:25:57 | Nayarit, Mexico | ||
2915274 | 2915274 | 2020-11-14 | Mexico | Nayarit | 6935 | 896 | 0 | 6039 | 21.7514 | -104.8455 | 2020-11-15 05:26:53 | Nayarit, 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]);