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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423 | 423 | 2021-12-02 | Mexico | Nayarit | 34216 | 2871 | 0 | 21.7514 | -104.8455 | 2021-12-03 04:23:05 | Nayarit, Mexico | |||
4439 | 4439 | 2021-10-28 | Mexico | Nayarit | 33888 | 2793 | 0 | 21.7514 | -104.8455 | 2021-10-29 04:22:03 | Nayarit, Mexico | |||
8422 | 8422 | 2020-10-25 | Mexico | Nayarit | 6642 | 838 | 5522 | 282 | 21.7514 | -104.8455 | 2020-10-26 04:25:02 | 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 | ||
16447 | 16447 | 2021-09-18 | Mexico | Nayarit | 31660 | 2575 | 0 | 21.7514 | -104.8455 | 2021-09-19 04:21:34 | Nayarit, Mexico | |||
20462 | 20462 | 2021-05-28 | Mexico | Nayarit | 12162 | 1826 | 0 | 10336 | 21.7514 | -104.8455 | 2021-05-29 04:20:41 | Nayarit, Mexico | ||
24494 | 24494 | 2022-03-20 | Mexico | Nayarit | 57900 | 3161 | 0 | 21.7514 | -104.8455 | 2022-03-21 04:20:50 | Nayarit, Mexico | |||
28509 | 28509 | 2021-11-11 | Mexico | Nayarit | 34009 | 2842 | 0 | 21.7514 | -104.8455 | 2021-11-12 04:22:01 | Nayarit, Mexico | |||
32508 | 32508 | 2021-08-25 | Mexico | Nayarit | 28271 | 2339 | 0 | 21.7514 | -104.8455 | 2021-08-26 04:21:28 | Nayarit, Mexico | |||
36521 | 36521 | 2021-04-12 | Mexico | Nayarit | 11485 | 1761 | 0 | 9724 | 21.7514 | -104.8455 | 2021-04-13 04:20:37 | Nayarit, Mexico | ||
43801 | 43801 | 2021-11-02 | Mexico | Nayarit | 33946 | 2803 | 0 | 21.7514 | -104.8455 | 2021-11-03 06:22:09 | Nayarit, Mexico | |||
50883 | 50883 | 2021-05-29 | Mexico | Nayarit | 12170 | 1829 | 0 | 10341 | 21.7514 | -104.8455 | 2021-05-30 04:20:55 | Nayarit, Mexico | ||
54896 | 54896 | 2021-03-07 | Mexico | Nayarit | 10978 | 1651 | 0 | 9327 | 21.7514 | -104.8455 | 2021-03-08 05:24:48 | Nayarit, Mexico | ||
62414 | 62414 | 2020-07-23 | Mexico | Nayarit | 3003 | 309 | 2101 | 593 | 21.7514 | -104.8455 | 2020-07-24 03:34:53 | Nayarit, Mexico | ||
63156 | 63156 | 2022-11-12 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-13 04:21:14 | Nayarit, Mexico | |||
67153 | 67153 | 2021-09-01 | Mexico | Nayarit | 29564 | 2425 | 0 | 21.7514 | -104.8455 | 2021-09-02 04:21:15 | Nayarit, Mexico | |||
71184 | 71184 | 2022-02-07 | Mexico | Nayarit | 54143 | 3020 | 0 | 21.7514 | -104.8455 | 2022-02-08 04:21:15 | 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 | ||
79178 | 79178 | 2020-10-14 | Mexico | Nayarit | 6364 | 795 | 5196 | 373 | 21.7514 | -104.8455 | 2020-10-15 04:24:28 | Nayarit, Mexico | ||
83186 | 83186 | 2021-05-25 | Mexico | Nayarit | 12129 | 1819 | 0 | 10310 | 21.7514 | -104.8455 | 2021-05-26 04:20:35 | Nayarit, Mexico | ||
87218 | 87218 | 2021-11-09 | Mexico | Nayarit | 34000 | 2836 | 0 | 21.7514 | -104.8455 | 2021-11-10 04:21:38 | Nayarit, Mexico | |||
91236 | 91236 | 2022-07-23 | Mexico | Nayarit | 68319 | 3212 | 0 | 21.7514 | -104.8455 | 2022-07-24 04:20:47 | Nayarit, Mexico | |||
98373 | 98373 | 2020-08-04 | Mexico | Nayarit | 3645 | 410 | 2738 | 497 | 21.7514 | -104.8455 | 2020-08-05 04:34:43 | Nayarit, Mexico | ||
99419 | 99419 | 2022-01-14 | Mexico | Nayarit | 38385 | 2926 | 0 | 21.7514 | -104.8455 | 2022-01-15 04:21:07 | Nayarit, Mexico | |||
103418 | 103418 | 2021-08-15 | Mexico | Nayarit | 24982 | 2208 | 0 | 21.7514 | -104.8455 | 2021-08-16 04:21:31 | Nayarit, Mexico | |||
107543 | 107543 | 2021-06-19 | Mexico | Nayarit | 12491 | 1866 | 0 | 10625 | 21.7514 | -104.8455 | 2021-06-20 04:21:48 | Nayarit, Mexico | ||
114846 | 114846 | 2022-09-06 | Mexico | Nayarit | 71809 | 3236 | 0 | 21.7514 | -104.8455 | 2022-09-07 04:20:59 | Nayarit, Mexico | |||
121965 | 121965 | 2020-07-19 | Mexico | Nayarit | 2775 | 285 | 1947 | 543 | 21.7514 | -104.8455 | 2020-07-20 05:34:40 | 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 | ||
126826 | 126826 | 2022-01-09 | Mexico | Nayarit | 36329 | 2921 | 0 | 21.7514 | -104.8455 | 2022-01-10 04:22:07 | Nayarit, Mexico | |||
130844 | 130844 | 2022-10-04 | Mexico | Nayarit | 72057 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-05 04:23:06 | Nayarit, Mexico | |||
138064 | 138064 | 2021-12-04 | Mexico | Nayarit | 34253 | 2876 | 0 | 21.7514 | -104.8455 | 2021-12-05 04:22:25 | Nayarit, Mexico | |||
142082 | 142082 | 2022-07-09 | Mexico | Nayarit | 64045 | 3208 | 0 | 21.7514 | -104.8455 | 2022-07-10 04:20:54 | Nayarit, Mexico | |||
146062 | 146062 | 2020-08-15 | Mexico | Nayarit | 4275 | 484 | 3252 | 539 | 21.7514 | -104.8455 | 2020-08-16 04:27:42 | Nayarit, Mexico | ||
150077 | 150077 | 2021-11-29 | Mexico | Nayarit | 34193 | 2865 | 0 | 21.7514 | -104.8455 | 2021-11-30 04:22:53 | 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 | ||
158106 | 158106 | 2022-03-29 | Mexico | Nayarit | 57960 | 3172 | 0 | 21.7514 | -104.8455 | 2022-03-30 04:20:45 | Nayarit, Mexico | |||
162121 | 162121 | 2021-11-19 | Mexico | Nayarit | 34079 | 2848 | 0 | 21.7514 | -104.8455 | 2021-11-20 04:22:17 | Nayarit, Mexico | |||
166139 | 166139 | 2022-06-21 | Mexico | Nayarit | 60137 | 3202 | 0 | 21.7514 | -104.8455 | 2022-06-22 04:20:54 | Nayarit, Mexico | |||
170135 | 170135 | 2021-04-16 | Mexico | Nayarit | 11568 | 1767 | 0 | 9801 | 21.7514 | -104.8455 | 2021-04-17 04:20:40 | Nayarit, Mexico | ||
177283 | 177283 | 2020-07-27 | Mexico | Nayarit | 3219 | 347 | 2286 | 586 | 21.7514 | -104.8455 | 2020-07-28 04:58:43 | Nayarit, Mexico | ||
178118 | 178118 | 2021-09-02 | Mexico | Nayarit | 29872 | 2439 | 0 | 21.7514 | -104.8455 | 2021-09-03 04:21:20 | Nayarit, Mexico | |||
182131 | 182131 | 2021-02-21 | Mexico | Nayarit | 10683 | 1583 | 0 | 9100 | 21.7514 | -104.8455 | 2021-02-22 05:24:21 | Nayarit, Mexico | ||
186164 | 186164 | 2022-02-13 | Mexico | Nayarit | 55797 | 3042 | 0 | 21.7514 | -104.8455 | 2022-02-14 04:20:51 | 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 | ||
194157 | 194157 | 2020-08-31 | Mexico | Nayarit | 5003 | 579 | 4046 | 378 | 21.7514 | -104.8455 | 2020-09-01 04:28:31 | Nayarit, Mexico | ||
198353 | 198353 | 2022-10-19 | Mexico | Nayarit | 72128 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-20 04:22:59 | 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 | ||
206344 | 206344 | 2020-08-19 | Mexico | Nayarit | 4457 | 511 | 3462 | 484 | 21.7514 | -104.8455 | 2020-08-20 04:27:43 | Nayarit, Mexico | ||
210331 | 210331 | 2020-10-29 | Mexico | Nayarit | 6674 | 859 | 5579 | 236 | 21.7514 | -104.8455 | 2020-10-30 04:24:49 | Nayarit, Mexico | ||
217242 | 217242 | 2020-06-08 | Mexico | Nayarit | 814 | 87 | 518 | 209 | 21.7514 | -104.8455 | 2020-06-09 03:33:03 | Nayarit, Mexico | ||
218074 | 218074 | 2022-12-26 | Mexico | Nayarit | 72801 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-27 04:21:07 | Nayarit, Mexico | |||
222089 | 222089 | 2022-05-09 | Mexico | Nayarit | 58266 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-10 04:20:50 | Nayarit, Mexico | |||
229321 | 229321 | 2022-05-31 | Mexico | Nayarit | 58693 | 3200 | 0 | 21.7514 | -104.8455 | 2022-06-01 04:20:55 | Nayarit, Mexico | |||
233336 | 233336 | 2022-02-11 | Mexico | Nayarit | 55168 | 3036 | 0 | 21.7514 | -104.8455 | 2022-02-12 04:21:06 | 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 | ||
241346 | 241346 | 2021-04-02 | Mexico | Nayarit | 11333 | 1742 | 0 | 9591 | 21.7514 | -104.8455 | 2021-04-03 04:20:44 | Nayarit, Mexico | ||
245361 | 245361 | 2021-08-17 | Mexico | Nayarit | 25477 | 2243 | 0 | 21.7514 | -104.8455 | 2021-08-18 04:21:35 | Nayarit, Mexico | |||
249375 | 249375 | 2021-09-04 | Mexico | Nayarit | 30277 | 2465 | 0 | 21.7514 | -104.8455 | 2021-09-05 04:21:33 | Nayarit, Mexico | |||
253408 | 253408 | 2022-09-08 | Mexico | Nayarit | 71809 | 3236 | 0 | 21.7514 | -104.8455 | 2022-09-09 04:21:11 | Nayarit, Mexico | |||
257424 | 257424 | 2022-12-10 | Mexico | Nayarit | 72384 | 3249 | 0 | 21.7514 | -104.8455 | 2022-12-11 04:20:50 | Nayarit, Mexico | |||
261626 | 261626 | 2022-03-15 | Mexico | Nayarit | 57822 | 3143 | 0 | 21.7514 | -104.8455 | 2022-03-16 04:20:50 | Nayarit, Mexico | |||
268342 | 268342 | 2020-05-21 | Mexico | Nayarit | 362 | 38 | 212 | 112 | 21.7514 | -104.8455 | 2020-05-22 02:36:51 | Nayarit, Mexico | ||
272246 | 272246 | 2020-11-10 | Mexico | Nayarit | 6873 | 884 | 5745 | 244 | 21.7514 | -104.8455 | 2020-11-11 05:25:30 | Nayarit, Mexico | ||
276276 | 276276 | 2021-11-03 | Mexico | Nayarit | 33974 | 2813 | 0 | 21.7514 | -104.8455 | 2021-11-04 04:22:20 | Nayarit, Mexico | |||
280274 | 280274 | 2021-02-24 | Mexico | Nayarit | 10740 | 1604 | 0 | 9136 | 21.7514 | -104.8455 | 2021-02-25 05:24:57 | Nayarit, Mexico | ||
287248 | 287248 | 2020-06-15 | Mexico | Nayarit | 1039 | 113 | 690 | 236 | 21.7514 | -104.8455 | 2020-06-16 04:33:09 | Nayarit, Mexico | ||
288089 | 288089 | 2021-10-31 | Mexico | Nayarit | 33940 | 2803 | 0 | 21.7514 | -104.8455 | 2021-11-01 04:22:01 | Nayarit, Mexico | |||
292107 | 292107 | 2022-11-15 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-16 04:21:09 | Nayarit, Mexico | |||
296104 | 296104 | 2021-07-15 | Mexico | Nayarit | 13904 | 1900 | 0 | 12004 | 21.7514 | -104.8455 | 2021-07-16 04:21:22 | Nayarit, Mexico | ||
303120 | 303120 | 2020-07-01 | Mexico | Nayarit | 1776 | 208 | 1192 | 376 | 21.7514 | -104.8455 | 2020-07-02 04:33:46 | Nayarit, Mexico | ||
303962 | 303962 | 2022-04-16 | Mexico | Nayarit | 58106 | 3194 | 0 | 21.7514 | -104.8455 | 2022-04-17 04:20:59 | Nayarit, Mexico | |||
307979 | 307979 | 2022-12-13 | Mexico | Nayarit | 72459 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-14 04:21:04 | Nayarit, Mexico | |||
311995 | 311995 | 2022-11-13 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-14 04:21:09 | Nayarit, Mexico | |||
316010 | 316010 | 2022-02-12 | Mexico | Nayarit | 55797 | 3042 | 0 | 21.7514 | -104.8455 | 2022-02-13 04:21:00 | Nayarit, Mexico | |||
320027 | 320027 | 2022-10-30 | Mexico | Nayarit | 72147 | 3245 | 0 | 21.7514 | -104.8455 | 2022-10-31 04:21:36 | Nayarit, Mexico | |||
327060 | 327060 | 2020-07-20 | Mexico | Nayarit | 2802 | 287 | 1997 | 518 | 21.7514 | -104.8455 | 2020-07-21 04:38:46 | Nayarit, Mexico | ||
328001 | 328001 | 2022-12-27 | Mexico | Nayarit | 72833 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-28 04:21:04 | Nayarit, Mexico | |||
331998 | 331998 | 2021-08-04 | Mexico | Nayarit | 20362 | 2063 | 0 | 18299 | 21.7514 | -104.8455 | 2021-08-05 04:21:51 | Nayarit, Mexico | ||
336030 | 336030 | 2022-03-18 | Mexico | Nayarit | 57870 | 3161 | 0 | 21.7514 | -104.8455 | 2022-03-19 04:20:47 | 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 | ||
344365 | 344365 | 2020-09-14 | Mexico | Nayarit | 5502 | 660 | 4559 | 283 | 21.7514 | -104.8455 | 2020-09-15 03:22:50 | Nayarit, Mexico | ||
348391 | 348391 | 2022-12-14 | Mexico | Nayarit | 72459 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-15 04:20:58 | Nayarit, Mexico | |||
352387 | 352387 | 2021-03-11 | Mexico | Nayarit | 11055 | 1667 | 0 | 9388 | 21.7514 | -104.8455 | 2021-03-12 05:26:50 | Nayarit, Mexico | ||
356420 | 356420 | 2022-03-11 | Mexico | Nayarit | 57769 | 3140 | 0 | 21.7514 | -104.8455 | 2022-03-12 04:20:50 | Nayarit, Mexico | |||
360436 | 360436 | 2022-05-07 | Mexico | Nayarit | 58205 | 3199 | 0 | 21.7514 | -104.8455 | 2022-05-08 04:20:49 | Nayarit, Mexico | |||
367468 | 367468 | 2020-07-16 | Mexico | Nayarit | 2594 | 271 | 1845 | 478 | 21.7514 | -104.8455 | 2020-07-17 04:34:50 | Nayarit, Mexico | ||
371438 | 371438 | 2020-08-08 | Mexico | Nayarit | 3890 | 443 | 2912 | 535 | 21.7514 | -104.8455 | 2020-08-09 04:34:54 | Nayarit, Mexico | ||
372291 | 372291 | 2022-09-13 | Mexico | Nayarit | 71879 | 3238 | 0 | 21.7514 | -104.8455 | 2022-09-14 04:20:44 | Nayarit, Mexico | |||
376273 | 376273 | 2020-11-06 | Mexico | Nayarit | 6834 | 875 | 5722 | 237 | 21.7514 | -104.8455 | 2020-11-07 05:24:52 | Nayarit, Mexico | ||
380284 | 380284 | 2021-04-30 | Mexico | Nayarit | 11782 | 1793 | 0 | 9989 | 21.7514 | -104.8455 | 2021-05-01 04:20:47 | Nayarit, Mexico | ||
384318 | 384318 | 2022-09-23 | Mexico | Nayarit | 71996 | 3243 | 0 | 21.7514 | -104.8455 | 2022-09-24 04:21:40 | Nayarit, Mexico | |||
388314 | 388314 | 2021-04-04 | Mexico | Nayarit | 11350 | 1746 | 0 | 9604 | 21.7514 | -104.8455 | 2021-04-05 04:20:35 | 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 | ||
396359 | 396359 | 2022-10-07 | Mexico | Nayarit | 72085 | 3244 | 0 | 21.7514 | -104.8455 | 2022-10-08 04:22:56 | Nayarit, Mexico | |||
400356 | 400356 | 2021-06-29 | Mexico | Nayarit | 12704 | 1873 | 0 | 10831 | 21.7514 | -104.8455 | 2021-06-30 04:21:41 | Nayarit, Mexico | ||
404387 | 404387 | 2021-12-07 | Mexico | Nayarit | 34278 | 2879 | 0 | 21.7514 | -104.8455 | 2021-12-08 04:22:46 | Nayarit, Mexico | |||
408386 | 408386 | 2021-07-28 | Mexico | Nayarit | 17462 | 1972 | 0 | 15490 | 21.7514 | -104.8455 | 2021-07-29 04:21:33 | Nayarit, Mexico | ||
415412 | 415412 | 2020-07-05 | Mexico | Nayarit | 2024 | 214 | 1374 | 436 | 21.7514 | -104.8455 | 2020-07-06 04:33:57 | Nayarit, Mexico | ||
419430 | 419430 | 2022-09-18 | Mexico | Nayarit | 71926 | 3241 | 0 | 21.7514 | -104.8455 | 2022-09-19 04:21:49 | 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]);