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 = "Jalisco" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
419 | 419 | 2021-12-02 | Mexico | Jalisco | 163415 | 17571 | 0 | 20.6595 | -103.3494 | 2021-12-03 04:23:05 | Jalisco, Mexico | |||
4435 | 4435 | 2021-10-28 | Mexico | Jalisco | 160607 | 17042 | 0 | 20.6595 | -103.3494 | 2021-10-29 04:22:03 | Jalisco, Mexico | |||
16443 | 16443 | 2021-09-18 | Mexico | Jalisco | 147126 | 15585 | 0 | 20.6595 | -103.3494 | 2021-09-19 04:21:34 | Jalisco, Mexico | |||
24490 | 24490 | 2022-03-20 | Mexico | Jalisco | 238333 | 19331 | 0 | 20.6595 | -103.3494 | 2022-03-21 04:20:50 | Jalisco, Mexico | |||
28505 | 28505 | 2021-11-11 | Mexico | Jalisco | 162036 | 17351 | 0 | 20.6595 | -103.3494 | 2021-11-12 04:22:01 | Jalisco, Mexico | |||
32504 | 32504 | 2021-08-25 | Mexico | Jalisco | 129544 | 14400 | 0 | 20.6595 | -103.3494 | 2021-08-26 04:21:28 | Jalisco, Mexico | |||
43797 | 43797 | 2021-11-02 | Mexico | Jalisco | 161033 | 17108 | 0 | 20.6595 | -103.3494 | 2021-11-03 06:22:09 | Jalisco, Mexico | |||
63152 | 63152 | 2022-11-12 | Mexico | Jalisco | 284881 | 19993 | 0 | 20.6595 | -103.3494 | 2022-11-13 04:21:14 | Jalisco, Mexico | |||
67149 | 67149 | 2021-09-01 | Mexico | Jalisco | 134418 | 14790 | 0 | 20.6595 | -103.3494 | 2021-09-02 04:21:15 | Jalisco, Mexico | |||
71180 | 71180 | 2022-02-07 | Mexico | Jalisco | 212577 | 18463 | 0 | 20.6595 | -103.3494 | 2022-02-08 04:21:15 | Jalisco, Mexico | |||
87214 | 87214 | 2021-11-09 | Mexico | Jalisco | 161817 | 17324 | 0 | 20.6595 | -103.3494 | 2021-11-10 04:21:38 | Jalisco, Mexico | |||
91232 | 91232 | 2022-07-23 | Mexico | Jalisco | 268498 | 19817 | 0 | 20.6595 | -103.3494 | 2022-07-24 04:20:47 | Jalisco, Mexico | |||
99415 | 99415 | 2022-01-14 | Mexico | Jalisco | 177459 | 17869 | 0 | 20.6595 | -103.3494 | 2022-01-15 04:21:07 | Jalisco, Mexico | |||
103414 | 103414 | 2021-08-15 | Mexico | Jalisco | 119525 | 13782 | 0 | 20.6595 | -103.3494 | 2021-08-16 04:21:31 | Jalisco, Mexico | |||
114842 | 114842 | 2022-09-06 | Mexico | Jalisco | 282488 | 19950 | 0 | 20.6595 | -103.3494 | 2022-09-07 04:20:59 | Jalisco, Mexico | |||
126822 | 126822 | 2022-01-09 | Mexico | Jalisco | 171837 | 17836 | 0 | 20.6595 | -103.3494 | 2022-01-10 04:22:07 | Jalisco, Mexico | |||
130840 | 130840 | 2022-10-04 | Mexico | Jalisco | 284367 | 19978 | 0 | 20.6595 | -103.3494 | 2022-10-05 04:23:06 | Jalisco, Mexico | |||
138060 | 138060 | 2021-12-04 | Mexico | Jalisco | 163698 | 17615 | 0 | 20.6595 | -103.3494 | 2021-12-05 04:22:25 | Jalisco, Mexico | |||
142078 | 142078 | 2022-07-09 | Mexico | Jalisco | 259051 | 19766 | 0 | 20.6595 | -103.3494 | 2022-07-10 04:20:54 | Jalisco, Mexico | |||
150073 | 150073 | 2021-11-29 | Mexico | Jalisco | 163245 | 17559 | 0 | 20.6595 | -103.3494 | 2021-11-30 04:22:53 | Jalisco, Mexico | |||
158102 | 158102 | 2022-03-29 | Mexico | Jalisco | 239806 | 19447 | 0 | 20.6595 | -103.3494 | 2022-03-30 04:20:45 | Jalisco, Mexico | |||
162117 | 162117 | 2021-11-19 | Mexico | Jalisco | 162523 | 17468 | 0 | 20.6595 | -103.3494 | 2021-11-20 04:22:17 | Jalisco, Mexico | |||
166135 | 166135 | 2022-06-21 | Mexico | Jalisco | 250280 | 19734 | 0 | 20.6595 | -103.3494 | 2022-06-22 04:20:54 | Jalisco, Mexico | |||
178114 | 178114 | 2021-09-02 | Mexico | Jalisco | 135613 | 14875 | 0 | 20.6595 | -103.3494 | 2021-09-03 04:21:20 | Jalisco, Mexico | |||
186160 | 186160 | 2022-02-13 | Mexico | Jalisco | 218155 | 18665 | 0 | 20.6595 | -103.3494 | 2022-02-14 04:20:51 | Jalisco, Mexico | |||
198349 | 198349 | 2022-10-19 | Mexico | Jalisco | 284574 | 19985 | 0 | 20.6595 | -103.3494 | 2022-10-20 04:22:59 | Jalisco, Mexico | |||
218070 | 218070 | 2022-12-26 | Mexico | Jalisco | 287514 | 20010 | 0 | 20.6595 | -103.3494 | 2022-12-27 04:21:07 | Jalisco, Mexico | |||
222085 | 222085 | 2022-05-09 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-10 04:20:50 | Jalisco, Mexico | |||
229317 | 229317 | 2022-05-31 | Mexico | Jalisco | 247001 | 19684 | 0 | 20.6595 | -103.3494 | 2022-06-01 04:20:55 | Jalisco, Mexico | |||
233332 | 233332 | 2022-02-11 | Mexico | Jalisco | 215505 | 18589 | 0 | 20.6595 | -103.3494 | 2022-02-12 04:21:06 | Jalisco, Mexico | |||
245357 | 245357 | 2021-08-17 | Mexico | Jalisco | 120822 | 13908 | 0 | 20.6595 | -103.3494 | 2021-08-18 04:21:35 | Jalisco, Mexico | |||
249371 | 249371 | 2021-09-04 | Mexico | Jalisco | 137912 | 14976 | 0 | 20.6595 | -103.3494 | 2021-09-05 04:21:33 | Jalisco, Mexico | |||
253404 | 253404 | 2022-09-08 | Mexico | Jalisco | 282488 | 19950 | 0 | 20.6595 | -103.3494 | 2022-09-09 04:21:11 | Jalisco, Mexico | |||
257420 | 257420 | 2022-12-10 | Mexico | Jalisco | 285777 | 20001 | 0 | 20.6595 | -103.3494 | 2022-12-11 04:20:50 | Jalisco, Mexico | |||
261622 | 261622 | 2022-03-15 | Mexico | Jalisco | 236515 | 19273 | 0 | 20.6595 | -103.3494 | 2022-03-16 04:20:50 | Jalisco, Mexico | |||
276272 | 276272 | 2021-11-03 | Mexico | Jalisco | 161179 | 17138 | 0 | 20.6595 | -103.3494 | 2021-11-04 04:22:20 | Jalisco, Mexico | |||
288085 | 288085 | 2021-10-31 | Mexico | Jalisco | 161006 | 17104 | 0 | 20.6595 | -103.3494 | 2021-11-01 04:22:01 | Jalisco, Mexico | |||
292103 | 292103 | 2022-11-15 | Mexico | Jalisco | 284951 | 19993 | 0 | 20.6595 | -103.3494 | 2022-11-16 04:21:09 | Jalisco, Mexico | |||
303958 | 303958 | 2022-04-16 | Mexico | Jalisco | 245040 | 19564 | 0 | 20.6595 | -103.3494 | 2022-04-17 04:20:59 | Jalisco, Mexico | |||
307975 | 307975 | 2022-12-13 | Mexico | Jalisco | 286128 | 20002 | 0 | 20.6595 | -103.3494 | 2022-12-14 04:21:04 | Jalisco, Mexico | |||
311991 | 311991 | 2022-11-13 | Mexico | Jalisco | 284881 | 19993 | 0 | 20.6595 | -103.3494 | 2022-11-14 04:21:09 | Jalisco, Mexico | |||
316006 | 316006 | 2022-02-12 | Mexico | Jalisco | 218155 | 18665 | 0 | 20.6595 | -103.3494 | 2022-02-13 04:21:00 | Jalisco, Mexico | |||
320023 | 320023 | 2022-10-30 | Mexico | Jalisco | 284758 | 19988 | 0 | 20.6595 | -103.3494 | 2022-10-31 04:21:36 | Jalisco, Mexico | |||
327997 | 327997 | 2022-12-27 | Mexico | Jalisco | 287766 | 20011 | 0 | 20.6595 | -103.3494 | 2022-12-28 04:21:04 | Jalisco, Mexico | |||
336026 | 336026 | 2022-03-18 | Mexico | Jalisco | 237694 | 19316 | 0 | 20.6595 | -103.3494 | 2022-03-19 04:20:47 | Jalisco, Mexico | |||
348387 | 348387 | 2022-12-14 | Mexico | Jalisco | 286128 | 20002 | 0 | 20.6595 | -103.3494 | 2022-12-15 04:20:58 | Jalisco, Mexico | |||
356416 | 356416 | 2022-03-11 | Mexico | Jalisco | 235314 | 19261 | 0 | 20.6595 | -103.3494 | 2022-03-12 04:20:50 | Jalisco, Mexico | |||
360432 | 360432 | 2022-05-07 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-08 04:20:49 | Jalisco, Mexico | |||
372287 | 372287 | 2022-09-13 | Mexico | Jalisco | 283088 | 19959 | 0 | 20.6595 | -103.3494 | 2022-09-14 04:20:44 | Jalisco, Mexico | |||
384314 | 384314 | 2022-09-23 | Mexico | Jalisco | 283894 | 19972 | 0 | 20.6595 | -103.3494 | 2022-09-24 04:21:40 | Jalisco, Mexico | |||
396355 | 396355 | 2022-10-07 | Mexico | Jalisco | 284436 | 19981 | 0 | 20.6595 | -103.3494 | 2022-10-08 04:22:56 | Jalisco, Mexico | |||
404383 | 404383 | 2021-12-07 | Mexico | Jalisco | 163823 | 17632 | 0 | 20.6595 | -103.3494 | 2021-12-08 04:22:46 | Jalisco, Mexico | |||
419426 | 419426 | 2022-09-18 | Mexico | Jalisco | 283503 | 19966 | 0 | 20.6595 | -103.3494 | 2022-09-19 04:21:49 | Jalisco, Mexico | |||
423440 | 423440 | 2021-10-10 | Mexico | Jalisco | 157375 | 16492 | 0 | 20.6595 | -103.3494 | 2021-10-11 04:21:31 | Jalisco, Mexico | |||
431448 | 431448 | 2022-11-03 | Mexico | Jalisco | 284788 | 19989 | 0 | 20.6595 | -103.3494 | 2022-11-04 04:22:11 | Jalisco, Mexico | |||
443444 | 443444 | 2021-10-20 | Mexico | Jalisco | 159281 | 16809 | 0 | 20.6595 | -103.3494 | 2021-10-21 04:21:18 | Jalisco, Mexico | |||
447460 | 447460 | 2021-11-17 | Mexico | Jalisco | 162413 | 17432 | 0 | 20.6595 | -103.3494 | 2021-11-18 04:21:33 | Jalisco, Mexico | |||
451478 | 451478 | 2022-12-21 | Mexico | Jalisco | 286815 | 20006 | 0 | 20.6595 | -103.3494 | 2022-12-22 04:20:56 | Jalisco, Mexico | |||
459469 | 459469 | 2022-02-02 | Mexico | Jalisco | 204587 | 18243 | 0 | 20.6595 | -103.3494 | 2022-02-03 04:21:21 | Jalisco, Mexico | |||
463486 | 463486 | 2022-05-02 | Mexico | Jalisco | 245477 | 19597 | 0 | 20.6595 | -103.3494 | 2022-05-03 04:21:00 | Jalisco, Mexico | |||
467501 | 467501 | 2021-10-07 | Mexico | Jalisco | 156654 | 16388 | 0 | 20.6595 | -103.3494 | 2021-10-08 04:21:25 | Jalisco, Mexico | |||
475533 | 475533 | 2022-06-26 | Mexico | Jalisco | 251897 | 19740 | 0 | 20.6595 | -103.3494 | 2022-06-27 04:21:00 | Jalisco, Mexico | |||
479681 | 479681 | 2022-11-08 | Mexico | Jalisco | 284819 | 19991 | 0 | 20.6595 | -103.3494 | 2022-11-09 04:21:22 | Jalisco, Mexico | |||
487711 | 487711 | 2022-11-25 | Mexico | Jalisco | 285109 | 19995 | 0 | 20.6595 | -103.3494 | 2022-11-26 04:21:11 | Jalisco, Mexico | |||
491725 | 491725 | 2021-10-14 | Mexico | Jalisco | 158247 | 16612 | 0 | 20.6595 | -103.3494 | 2021-10-15 04:21:26 | Jalisco, Mexico | |||
495741 | 495741 | 2021-11-06 | Mexico | Jalisco | 161673 | 17293 | 0 | 20.6595 | -103.3494 | 2021-11-07 04:21:53 | Jalisco, Mexico | |||
499758 | 499758 | 2022-04-02 | Mexico | Jalisco | 240895 | 19492 | 0 | 20.6595 | -103.3494 | 2022-04-03 04:20:48 | Jalisco, Mexico | |||
503775 | 503775 | 2022-12-17 | Mexico | Jalisco | 286620 | 20005 | 0 | 20.6595 | -103.3494 | 2022-12-18 04:21:03 | Jalisco, Mexico | |||
507772 | 507772 | 2021-08-14 | Mexico | Jalisco | 119525 | 13782 | 0 | 20.6595 | -103.3494 | 2021-08-15 04:21:41 | Jalisco, Mexico | |||
511786 | 511786 | 2021-08-19 | Mexico | Jalisco | 124007 | 14048 | 0 | 20.6595 | -103.3494 | 2021-08-20 04:21:33 | Jalisco, Mexico | |||
515819 | 515819 | 2022-10-15 | Mexico | Jalisco | 284565 | 19985 | 0 | 20.6595 | -103.3494 | 2022-10-16 04:22:39 | Jalisco, Mexico | |||
534825 | 534825 | 2021-10-27 | Mexico | Jalisco | 160213 | 16987 | 0 | 20.6595 | -103.3494 | 2021-10-28 04:22:08 | Jalisco, Mexico | |||
538843 | 538843 | 2022-10-26 | Mexico | Jalisco | 284696 | 19988 | 0 | 20.6595 | -103.3494 | 2022-10-27 04:22:01 | Jalisco, Mexico | |||
542859 | 542859 | 2022-12-15 | Mexico | Jalisco | 286240 | 20003 | 0 | 20.6595 | -103.3494 | 2022-12-16 04:21:01 | Jalisco, Mexico | |||
550863 | 550863 | 2021-12-08 | Mexico | Jalisco | 163946 | 17654 | 0 | 20.6595 | -103.3494 | 2021-12-09 04:22:49 | Jalisco, Mexico | |||
554879 | 554879 | 2022-01-16 | Mexico | Jalisco | 181936 | 17887 | 0 | 20.6595 | -103.3494 | 2022-01-17 04:21:08 | Jalisco, Mexico | |||
558897 | 558897 | 2022-06-16 | Mexico | Jalisco | 249430 | 19729 | 0 | 20.6595 | -103.3494 | 2022-06-17 04:20:56 | Jalisco, Mexico | |||
567193 | 567193 | 2021-10-29 | Mexico | Jalisco | 160815 | 17064 | 0 | 20.6595 | -103.3494 | 2021-10-30 04:22:03 | Jalisco, Mexico | |||
574922 | 574922 | 2022-02-25 | Mexico | Jalisco | 228530 | 19033 | 0 | 20.6595 | -103.3494 | 2022-02-26 04:21:12 | Jalisco, Mexico | |||
589716 | 589716 | 2021-08-08 | Mexico | Jalisco | 113193 | 13427 | 0 | 20.6595 | -103.3494 | 2021-08-09 04:21:24 | Jalisco, Mexico | |||
593749 | 593749 | 2022-07-01 | Mexico | Jalisco | 254250 | 19744 | 0 | 20.6595 | -103.3494 | 2022-07-02 04:21:16 | Jalisco, Mexico | |||
597763 | 597763 | 2021-10-19 | Mexico | Jalisco | 158960 | 16738 | 0 | 20.6595 | -103.3494 | 2021-10-20 04:21:00 | Jalisco, Mexico | |||
601779 | 601779 | 2021-09-23 | Mexico | Jalisco | 151123 | 15915 | 0 | 20.6595 | -103.3494 | 2021-09-24 04:21:44 | Jalisco, Mexico | |||
617953 | 617953 | 2022-11-05 | Mexico | Jalisco | 284813 | 19990 | 0 | 20.6595 | -103.3494 | 2022-11-06 04:21:24 | Jalisco, Mexico | |||
621969 | 621969 | 2022-05-22 | Mexico | Jalisco | 246414 | 19660 | 0 | 20.6595 | -103.3494 | 2022-05-26 04:20:50 | Jalisco, Mexico | |||
629999 | 629999 | 2022-07-12 | Mexico | Jalisco | 260746 | 19770 | 0 | 20.6595 | -103.3494 | 2022-07-13 04:20:58 | Jalisco, Mexico | |||
634013 | 634013 | 2021-10-13 | Mexico | Jalisco | 157965 | 16575 | 0 | 20.6595 | -103.3494 | 2021-10-14 04:21:29 | Jalisco, Mexico | |||
642026 | 642026 | 2021-09-07 | Mexico | Jalisco | 140711 | 15076 | 0 | 20.6595 | -103.3494 | 2021-09-08 04:21:31 | Jalisco, Mexico | |||
650054 | 650054 | 2021-08-09 | Mexico | Jalisco | 113373 | 13434 | 0 | 20.6595 | -103.3494 | 2021-08-10 04:21:27 | Jalisco, Mexico | |||
654085 | 654085 | 2021-10-22 | Mexico | Jalisco | 159675 | 16893 | 0 | 20.6595 | -103.3494 | 2021-10-23 04:21:32 | Jalisco, Mexico | |||
658404 | 658404 | 2022-05-13 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-14 04:20:48 | Jalisco, Mexico | |||
670390 | 670390 | 2022-07-21 | Mexico | Jalisco | 266988 | 19809 | 0 | 20.6595 | -103.3494 | 2022-07-22 04:21:15 | Jalisco, Mexico | |||
674406 | 674406 | 2022-07-30 | Mexico | Jalisco | 270574 | 19846 | 0 | 20.6595 | -103.3494 | 2022-07-31 04:21:02 | Jalisco, Mexico | |||
682430 | 682430 | 2021-10-24 | Mexico | Jalisco | 159897 | 16944 | 0 | 20.6595 | -103.3494 | 2021-10-25 04:22:31 | Jalisco, Mexico | |||
686446 | 686446 | 2021-11-13 | Mexico | Jalisco | 162153 | 17377 | 0 | 20.6595 | -103.3494 | 2021-11-14 04:21:31 | Jalisco, Mexico | |||
690464 | 690464 | 2022-12-23 | Mexico | Jalisco | 286815 | 20006 | 0 | 20.6595 | -103.3494 | 2022-12-24 04:21:02 | Jalisco, Mexico | |||
694479 | 694479 | 2022-03-17 | Mexico | Jalisco | 237694 | 19316 | 0 | 20.6595 | -103.3494 | 2022-03-18 04:20:55 | Jalisco, Mexico | |||
698494 | 698494 | 2021-11-04 | Mexico | Jalisco | 161331 | 17160 | 0 | 20.6595 | -103.3494 | 2021-11-05 04:21:54 | Jalisco, Mexico | |||
706524 | 706524 | 2021-09-29 | Mexico | Jalisco | 153879 | 16129 | 0 | 20.6595 | -103.3494 | 2021-09-30 04:21:20 | Jalisco, Mexico | |||
710541 | 710541 | 2022-11-01 | Mexico | Jalisco | 284758 | 19988 | 0 | 20.6595 | -103.3494 | 2022-11-02 04:22:09 | Jalisco, 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]);