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 active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714559 | 714559 | 2021-11-12 | Mexico | Nayarit | 34009 | 2842 | 0 | 21.7514 | -104.8455 | 2021-11-13 04:21:38 | Nayarit, Mexico | |||
718577 | 718577 | 2022-12-04 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-05 04:20:58 | Nayarit, Mexico | |||
722591 | 722591 | 2021-11-20 | Mexico | Nayarit | 34095 | 2849 | 0 | 21.7514 | -104.8455 | 2021-11-21 04:22:13 | Nayarit, Mexico | |||
730621 | 730621 | 2021-12-27 | Mexico | Nayarit | 34529 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-28 04:21:47 | Nayarit, Mexico | |||
746438 | 746438 | 2022-04-23 | Mexico | Nayarit | 58151 | 3197 | 0 | 21.7514 | -104.8455 | 2022-04-24 04:20:56 | Nayarit, Mexico | |||
758421 | 758421 | 2021-11-26 | Mexico | Nayarit | 34176 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-27 04:22:45 | Nayarit, Mexico | |||
770442 | 770442 | 2021-10-23 | Mexico | Nayarit | 33772 | 2778 | 0 | 21.7514 | -104.8455 | 2021-10-24 04:21:22 | Nayarit, Mexico | |||
782484 | 782484 | 2021-12-13 | Mexico | Nayarit | 34355 | 2906 | 0 | 21.7514 | -104.8455 | 2021-12-14 04:22:38 | Nayarit, Mexico | |||
794509 | 794509 | 2022-10-24 | Mexico | Nayarit | 72159 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-25 04:21:53 | Nayarit, Mexico | |||
798523 | 798523 | 2021-12-22 | Mexico | Nayarit | 34481 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-23 04:21:21 | Nayarit, Mexico | |||
809668 | 809668 | 2021-09-20 | Mexico | Nayarit | 31888 | 2586 | 0 | 21.7514 | -104.8455 | 2021-09-21 04:21:26 | Nayarit, Mexico | |||
833722 | 833722 | 2022-12-02 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-12-03 04:21:02 | Nayarit, Mexico | |||
849694 | 849694 | 2022-11-02 | Mexico | Nayarit | 72157 | 3245 | 0 | 21.7514 | -104.8455 | 2022-11-03 04:22:05 | Nayarit, Mexico | |||
853710 | 853710 | 2022-09-30 | Mexico | Nayarit | 72048 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-01 04:23:01 | Nayarit, Mexico | |||
868894 | 868894 | 2022-12-11 | Mexico | Nayarit | 72384 | 3249 | 0 | 21.7514 | -104.8455 | 2022-12-12 04:21:01 | Nayarit, Mexico | |||
876358 | 876358 | 2022-03-27 | Mexico | Nayarit | 57949 | 3171 | 0 | 21.7514 | -104.8455 | 2022-03-28 04:20:33 | Nayarit, Mexico | |||
880375 | 880375 | 2022-08-05 | Mexico | Nayarit | 70234 | 3221 | 0 | 21.7514 | -104.8455 | 2022-08-06 04:20:56 | Nayarit, Mexico | |||
896242 | 896242 | 2022-07-24 | Mexico | Nayarit | 68394 | 3212 | 0 | 21.7514 | -104.8455 | 2022-07-25 04:20:51 | Nayarit, Mexico | |||
900258 | 900258 | 2022-07-22 | Mexico | Nayarit | 68011 | 3212 | 0 | 21.7514 | -104.8455 | 2022-07-23 04:20:53 | Nayarit, Mexico | |||
904272 | 904272 | 2021-11-24 | Mexico | Nayarit | 34137 | 2859 | 0 | 21.7514 | -104.8455 | 2021-11-25 04:22:33 | Nayarit, Mexico | |||
912303 | 912303 | 2022-10-29 | Mexico | Nayarit | 72114 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-30 04:22:14 | Nayarit, Mexico | |||
919778 | 919778 | 2022-03-08 | Mexico | Nayarit | 57733 | 3139 | 0 | 21.7514 | -104.8455 | 2022-03-09 04:20:59 | Nayarit, Mexico | |||
934894 | 934894 | 2021-10-16 | Mexico | Nayarit | 33568 | 2747 | 0 | 21.7514 | -104.8455 | 2021-10-17 04:21:29 | Nayarit, Mexico | |||
938912 | 938912 | 2022-06-25 | Mexico | Nayarit | 60696 | 3203 | 0 | 21.7514 | -104.8455 | 2022-06-26 04:21:02 | Nayarit, Mexico | |||
942927 | 942927 | 2022-02-28 | Mexico | Nayarit | 57433 | 3125 | 0 | 21.7514 | -104.8455 | 2022-03-01 04:21:09 | Nayarit, Mexico | |||
946944 | 946944 | 2022-06-14 | Mexico | Nayarit | 59445 | 3202 | 0 | 21.7514 | -104.8455 | 2022-06-15 04:20:54 | Nayarit, Mexico | |||
950959 | 950959 | 2022-03-12 | Mexico | Nayarit | 57817 | 3143 | 0 | 21.7514 | -104.8455 | 2022-03-13 04:20:49 | Nayarit, Mexico | |||
958990 | 958990 | 2022-07-19 | Mexico | Nayarit | 66893 | 3210 | 0 | 21.7514 | -104.8455 | 2022-07-20 04:20:59 | Nayarit, Mexico | |||
963006 | 963006 | 2022-09-09 | Mexico | Nayarit | 71809 | 3236 | 0 | 21.7514 | -104.8455 | 2022-09-10 04:21:10 | Nayarit, Mexico | |||
971014 | 971014 | 2022-06-01 | Mexico | Nayarit | 58736 | 3200 | 0 | 21.7514 | -104.8455 | 2022-06-02 05:20:39 | Nayarit, Mexico | |||
979042 | 979042 | 2022-02-01 | Mexico | Nayarit | 50944 | 2981 | 0 | 21.7514 | -104.8455 | 2022-02-02 04:21:09 | Nayarit, Mexico | |||
987072 | 987072 | 2021-10-04 | Mexico | Nayarit | 33030 | 2688 | 0 | 21.7514 | -104.8455 | 2021-10-05 04:21:27 | Nayarit, Mexico | |||
991089 | 991089 | 2022-08-16 | Mexico | Nayarit | 71243 | 3232 | 0 | 21.7514 | -104.8455 | 2022-08-17 04:20:59 | Nayarit, Mexico | |||
1014427 | 1014427 | 2021-11-21 | Mexico | Nayarit | 34106 | 2852 | 0 | 21.7514 | -104.8455 | 2021-11-22 04:22:20 | Nayarit, Mexico | |||
1018445 | 1018445 | 2022-12-24 | Mexico | Nayarit | 72798 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-25 04:21:04 | Nayarit, Mexico | |||
1022461 | 1022461 | 2022-11-04 | Mexico | Nayarit | 72164 | 3245 | 0 | 21.7514 | -104.8455 | 2022-11-05 04:21:52 | Nayarit, Mexico | |||
1030469 | 1030469 | 2021-12-06 | Mexico | Nayarit | 34278 | 2879 | 0 | 21.7514 | -104.8455 | 2021-12-07 04:22:34 | Nayarit, Mexico | |||
1049933 | 1049933 | 2022-11-06 | Mexico | Nayarit | 72164 | 3245 | 0 | 21.7514 | -104.8455 | 2022-11-07 04:21:26 | Nayarit, Mexico | |||
1057943 | 1057943 | 2022-02-23 | Mexico | Nayarit | 57131 | 3115 | 0 | 21.7514 | -104.8455 | 2022-02-24 04:21:14 | Nayarit, Mexico | |||
1065972 | 1065972 | 2022-07-28 | Mexico | Nayarit | 69101 | 3215 | 0 | 21.7514 | -104.8455 | 2022-07-29 04:20:45 | Nayarit, Mexico | |||
1069988 | 1069988 | 2022-08-07 | Mexico | Nayarit | 70512 | 3226 | 0 | 21.7514 | -104.8455 | 2022-08-08 04:21:08 | Nayarit, Mexico | |||
1074004 | 1074004 | 2022-12-28 | Mexico | Nayarit | 72859 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-29 04:21:01 | Nayarit, Mexico | |||
1078018 | 1078018 | 2021-12-09 | Mexico | Nayarit | 34324 | 2880 | 0 | 21.7514 | -104.8455 | 2021-12-10 04:22:28 | Nayarit, Mexico | |||
1086170 | 1086170 | 2022-08-09 | Mexico | Nayarit | 70712 | 3226 | 0 | 21.7514 | -104.8455 | 2022-08-10 04:20:57 | Nayarit, Mexico | |||
1098213 | 1098213 | 2022-08-03 | Mexico | Nayarit | 70050 | 3219 | 0 | 21.7514 | -104.8455 | 2022-08-04 04:20:58 | Nayarit, Mexico | |||
1109669 | 1109669 | 2022-05-21 | Mexico | Nayarit | 58350 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-22 04:20:52 | Nayarit, Mexico | |||
1113683 | 1113683 | 2022-01-11 | Mexico | Nayarit | 36893 | 2924 | 0 | 21.7514 | -104.8455 | 2022-01-12 04:21:44 | Nayarit, Mexico | |||
1117682 | 1117682 | 2021-08-06 | Mexico | Nayarit | 21562 | 2095 | 0 | 21.7514 | -104.8455 | 2021-08-07 04:21:30 | Nayarit, Mexico | |||
1141006 | 1141006 | 2022-01-23 | Mexico | Nayarit | 45639 | 2941 | 0 | 21.7514 | -104.8455 | 2022-01-24 04:21:12 | Nayarit, Mexico | |||
1145022 | 1145022 | 2021-12-01 | Mexico | Nayarit | 34216 | 2871 | 0 | 21.7514 | -104.8455 | 2021-12-02 04:22:37 | Nayarit, Mexico | |||
1149040 | 1149040 | 2022-12-12 | Mexico | Nayarit | 72422 | 3249 | 0 | 21.7514 | -104.8455 | 2022-12-13 04:21:01 | Nayarit, Mexico | |||
1157246 | 1157246 | 2022-04-29 | Mexico | Nayarit | 58196 | 3199 | 0 | 21.7514 | -104.8455 | 2022-04-30 04:21:05 | Nayarit, Mexico | |||
1161263 | 1161263 | 2022-08-18 | Mexico | Nayarit | 71313 | 3232 | 0 | 21.7514 | -104.8455 | 2022-08-19 04:20:54 | Nayarit, Mexico | |||
1169293 | 1169293 | 2022-05-20 | Mexico | Nayarit | 58350 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-21 04:20:58 | Nayarit, Mexico | |||
1184840 | 1184840 | 2022-05-18 | Mexico | Nayarit | 58350 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-19 04:20:54 | Nayarit, Mexico | |||
1199902 | 1199902 | 2022-07-06 | Mexico | Nayarit | 63006 | 3206 | 0 | 21.7514 | -104.8455 | 2022-07-07 04:20:55 | Nayarit, Mexico | |||
1211647 | 1211647 | 2022-07-11 | Mexico | Nayarit | 64155 | 3208 | 0 | 21.7514 | -104.8455 | 2022-07-12 04:20:51 | Nayarit, Mexico | |||
1215661 | 1215661 | 2022-01-08 | Mexico | Nayarit | 36269 | 2921 | 0 | 21.7514 | -104.8455 | 2022-01-09 04:21:46 | Nayarit, Mexico | |||
1223692 | 1223692 | 2022-04-14 | Mexico | Nayarit | 58076 | 3194 | 0 | 21.7514 | -104.8455 | 2022-04-15 04:20:57 | Nayarit, Mexico | |||
1227707 | 1227707 | 2022-01-24 | Mexico | Nayarit | 45742 | 2942 | 0 | 21.7514 | -104.8455 | 2022-01-25 04:21:05 | Nayarit, Mexico | |||
1231723 | 1231723 | 2021-11-28 | Mexico | Nayarit | 34188 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-29 04:22:30 | Nayarit, Mexico | |||
1235739 | 1235739 | 2021-09-27 | Mexico | Nayarit | 32558 | 2655 | 0 | 21.7514 | -104.8455 | 2021-09-28 04:21:28 | Nayarit, Mexico | |||
1239756 | 1239756 | 2022-11-28 | Mexico | Nayarit | 72241 | 3247 | 0 | 21.7514 | -104.8455 | 2022-11-29 04:21:05 | Nayarit, Mexico | |||
1250852 | 1250852 | 2022-08-23 | Mexico | Nayarit | 71489 | 3234 | 0 | 21.7514 | -104.8455 | 2022-08-24 04:20:46 | Nayarit, Mexico | |||
1254866 | 1254866 | 2021-12-20 | Mexico | Nayarit | 34444 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-21 03:21:27 | Nayarit, Mexico | |||
1258882 | 1258882 | 2021-12-18 | Mexico | Nayarit | 34425 | 2908 | 0 | 21.7514 | -104.8455 | 2021-12-19 04:21:11 | Nayarit, Mexico | |||
1262881 | 1262881 | 2021-09-09 | Mexico | Nayarit | 30896 | 2517 | 0 | 21.7514 | -104.8455 | 2021-09-10 04:21:20 | Nayarit, Mexico | |||
1274382 | 1274382 | 2021-10-03 | Mexico | Nayarit | 33017 | 2686 | 0 | 21.7514 | -104.8455 | 2021-10-04 04:21:31 | Nayarit, Mexico | |||
1282083 | 1282083 | 2022-01-05 | Mexico | Nayarit | 35107 | 2916 | 0 | 21.7514 | -104.8455 | 2022-01-06 04:22:09 | Nayarit, Mexico | |||
1286099 | 1286099 | 2022-01-04 | Mexico | Nayarit | 34911 | 2915 | 0 | 21.7514 | -104.8455 | 2022-01-05 04:21:59 | Nayarit, Mexico | |||
1294129 | 1294129 | 2022-02-05 | Mexico | Nayarit | 54001 | 3016 | 0 | 21.7514 | -104.8455 | 2022-02-06 04:21:00 | Nayarit, Mexico | |||
1298146 | 1298146 | 2022-02-17 | Mexico | Nayarit | 56492 | 3075 | 0 | 21.7514 | -104.8455 | 2022-02-18 04:21:04 | Nayarit, Mexico | |||
1314294 | 1314294 | 2022-05-27 | Mexico | Nayarit | 58464 | 3199 | 0 | 21.7514 | -104.8455 | 2022-05-28 04:21:07 | Nayarit, Mexico | |||
1318308 | 1318308 | 2022-01-26 | Mexico | Nayarit | 46664 | 2945 | 0 | 21.7514 | -104.8455 | 2022-01-27 04:21:19 | Nayarit, Mexico | |||
1322324 | 1322324 | 2021-11-14 | Mexico | Nayarit | 34027 | 2844 | 0 | 21.7514 | -104.8455 | 2021-11-15 04:21:36 | Nayarit, Mexico | |||
1326341 | 1326341 | 2022-04-26 | Mexico | Nayarit | 58162 | 3198 | 0 | 21.7514 | -104.8455 | 2022-04-27 04:20:52 | Nayarit, Mexico | |||
1334370 | 1334370 | 2021-09-28 | Mexico | Nayarit | 32677 | 2663 | 0 | 21.7514 | -104.8455 | 2021-09-29 04:21:45 | Nayarit, Mexico | |||
1342382 | 1342382 | 2021-08-11 | Mexico | Nayarit | 23296 | 2155 | 0 | 21.7514 | -104.8455 | 2021-08-12 04:21:25 | Nayarit, Mexico | |||
1346415 | 1346415 | 2022-08-10 | Mexico | Nayarit | 70712 | 3226 | 0 | 21.7514 | -104.8455 | 2022-08-11 04:20:49 | Nayarit, Mexico | |||
1358430 | 1358430 | 2021-11-27 | Mexico | Nayarit | 34176 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-28 04:22:43 | Nayarit, Mexico | |||
1362446 | 1362446 | 2022-02-08 | Mexico | Nayarit | 54181 | 3020 | 0 | 21.7514 | -104.8455 | 2022-02-09 04:21:04 | Nayarit, Mexico | |||
1366572 | 1366572 | 2022-10-28 | Mexico | Nayarit | 72114 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-29 04:21:13 | Nayarit, Mexico | |||
1370588 | 1370588 | 2022-09-21 | Mexico | Nayarit | 71969 | 3242 | 0 | 21.7514 | -104.8455 | 2022-09-22 04:22:56 | Nayarit, Mexico | |||
1374585 | 1374585 | 2021-09-15 | Mexico | Nayarit | 31548 | 2572 | 0 | 21.7514 | -104.8455 | 2021-09-16 04:22:19 | Nayarit, Mexico | |||
1385723 | 1385723 | 2021-09-13 | Mexico | Nayarit | 31207 | 2545 | 0 | 21.7514 | -104.8455 | 2021-09-14 04:21:41 | Nayarit, Mexico | |||
1389754 | 1389754 | 2022-01-07 | Mexico | Nayarit | 35767 | 2920 | 0 | 21.7514 | -104.8455 | 2022-01-08 04:21:53 | Nayarit, Mexico | |||
1393772 | 1393772 | 2022-09-02 | Mexico | Nayarit | 71749 | 3236 | 0 | 21.7514 | -104.8455 | 2022-09-03 04:21:04 | Nayarit, Mexico | |||
1397787 | 1397787 | 2022-05-06 | Mexico | Nayarit | 58205 | 3199 | 0 | 21.7514 | -104.8455 | 2022-05-07 04:21:09 | Nayarit, Mexico | |||
1405138 | 1405138 | 2022-08-02 | Mexico | Nayarit | 69906 | 3218 | 0 | 21.7514 | -104.8455 | 2022-08-03 04:20:59 | Nayarit, Mexico | |||
1417182 | 1417182 | 2022-07-08 | Mexico | Nayarit | 63425 | 3208 | 0 | 21.7514 | -104.8455 | 2022-07-09 04:20:59 | Nayarit, Mexico | |||
1421198 | 1421198 | 2022-06-08 | Mexico | Nayarit | 59027 | 3201 | 0 | 21.7514 | -104.8455 | 2022-06-09 04:20:54 | Nayarit, Mexico | |||
1432660 | 1432660 | 2021-12-28 | Mexico | Nayarit | 34532 | 2909 | 0 | 21.7514 | -104.8455 | 2021-12-29 03:21:43 | Nayarit, Mexico | |||
1436677 | 1436677 | 2022-03-28 | Mexico | Nayarit | 57949 | 3171 | 0 | 21.7514 | -104.8455 | 2022-03-29 04:20:46 | Nayarit, Mexico | |||
1464178 | 1464178 | 2022-02-10 | Mexico | Nayarit | 54626 | 3030 | 0 | 21.7514 | -104.8455 | 2022-02-11 04:21:09 | Nayarit, Mexico | |||
1468194 | 1468194 | 2022-03-24 | Mexico | Nayarit | 57909 | 3166 | 0 | 21.7514 | -104.8455 | 2022-03-25 04:20:46 | Nayarit, Mexico | |||
1472209 | 1472209 | 2022-01-17 | Mexico | Nayarit | 40471 | 2927 | 0 | 21.7514 | -104.8455 | 2022-01-18 04:21:04 | Nayarit, Mexico | |||
1483648 | 1483648 | 2021-08-13 | Mexico | Nayarit | 24402 | 2187 | 0 | 21.7514 | -104.8455 | 2021-08-14 04:21:25 | Nayarit, Mexico | |||
1487681 | 1487681 | 2022-07-26 | Mexico | Nayarit | 68506 | 3213 | 0 | 21.7514 | -104.8455 | 2022-07-27 04:21:04 | Nayarit, Mexico | |||
1491695 | 1491695 | 2021-10-12 | Mexico | Nayarit | 33384 | 2722 | 0 | 21.7514 | -104.8455 | 2021-10-13 04:20:51 | Nayarit, Mexico | |||
1503694 | 1503694 | 2022-05-16 | Mexico | Nayarit | 58350 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-17 04:20:59 | 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]);