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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, 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 | |||
8418 | 8418 | 2020-10-25 | Mexico | Jalisco | 32895 | 3887 | 26711 | 2297 | 20.6595 | -103.3494 | 2020-10-26 04:25:02 | Jalisco, Mexico | ||
12427 | 12427 | 2021-01-26 | Mexico | Jalisco | 67024 | 8100 | 0 | 58924 | 20.6595 | -103.3494 | 2021-01-27 05:23:41 | Jalisco, Mexico | ||
16443 | 16443 | 2021-09-18 | Mexico | Jalisco | 147126 | 15585 | 0 | 20.6595 | -103.3494 | 2021-09-19 04:21:34 | Jalisco, Mexico | |||
20458 | 20458 | 2021-05-28 | Mexico | Jalisco | 86984 | 12340 | 0 | 74644 | 20.6595 | -103.3494 | 2021-05-29 04:20:41 | 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 | |||
36517 | 36517 | 2021-04-12 | Mexico | Jalisco | 83734 | 11575 | 0 | 72159 | 20.6595 | -103.3494 | 2021-04-13 04:20:37 | Jalisco, Mexico | ||
43797 | 43797 | 2021-11-02 | Mexico | Jalisco | 161033 | 17108 | 0 | 20.6595 | -103.3494 | 2021-11-03 06:22:09 | Jalisco, Mexico | |||
50879 | 50879 | 2021-05-29 | Mexico | Jalisco | 87048 | 12375 | 0 | 74673 | 20.6595 | -103.3494 | 2021-05-30 04:20:55 | Jalisco, Mexico | ||
54892 | 54892 | 2021-03-07 | Mexico | Jalisco | 79429 | 10720 | 0 | 68709 | 20.6595 | -103.3494 | 2021-03-08 05:24:48 | Jalisco, Mexico | ||
62410 | 62410 | 2020-07-23 | Mexico | Jalisco | 11473 | 1340 | 7970 | 2163 | 20.6595 | -103.3494 | 2020-07-24 03:34:53 | 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 | |||
75176 | 75176 | 2020-12-03 | Mexico | Jalisco | 42477 | 4928 | 0 | 37549 | 20.6595 | -103.3494 | 2020-12-04 05:27:27 | Jalisco, Mexico | ||
79174 | 79174 | 2020-10-14 | Mexico | Jalisco | 30256 | 3611 | 24548 | 2097 | 20.6595 | -103.3494 | 2020-10-15 04:24:28 | Jalisco, Mexico | ||
83182 | 83182 | 2021-05-25 | Mexico | Jalisco | 86777 | 12210 | 0 | 74567 | 20.6595 | -103.3494 | 2021-05-26 04:20:35 | 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 | |||
98263 | 98263 | 2020-08-04 | Mexico | Jalisco | 13876 | 1627 | 10730 | 1519 | 20.6595 | -103.3494 | 2020-08-05 04:34:43 | 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 | |||
107539 | 107539 | 2021-06-19 | Mexico | Jalisco | 88037 | 12597 | 0 | 75440 | 20.6595 | -103.3494 | 2021-06-20 04:21:48 | Jalisco, Mexico | ||
114842 | 114842 | 2022-09-06 | Mexico | Jalisco | 282488 | 19950 | 0 | 20.6595 | -103.3494 | 2022-09-07 04:20:59 | Jalisco, Mexico | |||
121856 | 121856 | 2020-07-19 | Mexico | Jalisco | 10508 | 1233 | 7175 | 2100 | 20.6595 | -103.3494 | 2020-07-20 05:34:40 | Jalisco, Mexico | ||
122791 | 122791 | 2020-11-18 | Mexico | Jalisco | 37785 | 4531 | 0 | 33254 | 20.6595 | -103.3494 | 2020-11-19 05:25:23 | 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 | |||
146058 | 146058 | 2020-08-15 | Mexico | Jalisco | 16223 | 2004 | 12472 | 1747 | 20.6595 | -103.3494 | 2020-08-16 04:27:42 | Jalisco, Mexico | ||
150073 | 150073 | 2021-11-29 | Mexico | Jalisco | 163245 | 17559 | 0 | 20.6595 | -103.3494 | 2021-11-30 04:22:53 | Jalisco, Mexico | |||
154070 | 154070 | 2021-01-08 | Mexico | Jalisco | 55162 | 6499 | 0 | 48663 | 20.6595 | -103.3494 | 2021-01-09 05:22:18 | 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 | |||
170131 | 170131 | 2021-04-16 | Mexico | Jalisco | 84179 | 11668 | 0 | 72511 | 20.6595 | -103.3494 | 2021-04-17 04:20:40 | Jalisco, Mexico | ||
177174 | 177174 | 2020-07-27 | Mexico | Jalisco | 12235 | 1429 | 9053 | 1753 | 20.6595 | -103.3494 | 2020-07-28 04:58:43 | Jalisco, Mexico | ||
178114 | 178114 | 2021-09-02 | Mexico | Jalisco | 135613 | 14875 | 0 | 20.6595 | -103.3494 | 2021-09-03 04:21:20 | Jalisco, Mexico | |||
182127 | 182127 | 2021-02-21 | Mexico | Jalisco | 76298 | 10141 | 0 | 66157 | 20.6595 | -103.3494 | 2021-02-22 05:24:21 | Jalisco, Mexico | ||
186160 | 186160 | 2022-02-13 | Mexico | Jalisco | 218155 | 18665 | 0 | 20.6595 | -103.3494 | 2022-02-14 04:20:51 | Jalisco, Mexico | |||
190156 | 190156 | 2021-01-11 | Mexico | Jalisco | 56595 | 6721 | 0 | 49874 | 20.6595 | -103.3494 | 2021-01-12 05:22:15 | Jalisco, Mexico | ||
194153 | 194153 | 2020-08-31 | Mexico | Jalisco | 20324 | 2428 | 16219 | 1677 | 20.6595 | -103.3494 | 2020-09-01 04:28:31 | Jalisco, Mexico | ||
198349 | 198349 | 2022-10-19 | Mexico | Jalisco | 284574 | 19985 | 0 | 20.6595 | -103.3494 | 2022-10-20 04:22:59 | Jalisco, Mexico | |||
202343 | 202343 | 2020-12-25 | Mexico | Jalisco | 49941 | 5785 | 0 | 44156 | 20.6595 | -103.3494 | 2020-12-26 05:22:28 | Jalisco, Mexico | ||
206340 | 206340 | 2020-08-19 | Mexico | Jalisco | 17056 | 2087 | 13259 | 1710 | 20.6595 | -103.3494 | 2020-08-20 04:27:43 | Jalisco, Mexico | ||
210327 | 210327 | 2020-10-29 | Mexico | Jalisco | 33857 | 4014 | 27583 | 2260 | 20.6595 | -103.3494 | 2020-10-30 04:24:49 | Jalisco, Mexico | ||
217146 | 217146 | 2020-06-08 | Mexico | Jalisco | 2988 | 257 | 1629 | 1102 | 20.6595 | -103.3494 | 2020-06-09 03:33:03 | 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 | |||
237328 | 237328 | 2021-01-18 | Mexico | Jalisco | 60907 | 7179 | 0 | 53728 | 20.6595 | -103.3494 | 2021-01-19 05:22:15 | Jalisco, Mexico | ||
241342 | 241342 | 2021-04-02 | Mexico | Jalisco | 82782 | 11376 | 0 | 71406 | 20.6595 | -103.3494 | 2021-04-03 04:20:44 | 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 | |||
268309 | 268309 | 2020-05-21 | Mexico | Jalisco | 1028 | 96 | 620 | 312 | 20.6595 | -103.3494 | 2020-05-22 02:36:51 | Jalisco, Mexico | ||
272242 | 272242 | 2020-11-10 | Mexico | Jalisco | 36648 | 4359 | 29846 | 2443 | 20.6595 | -103.3494 | 2020-11-11 05:25:30 | Jalisco, Mexico | ||
276272 | 276272 | 2021-11-03 | Mexico | Jalisco | 161179 | 17138 | 0 | 20.6595 | -103.3494 | 2021-11-04 04:22:20 | Jalisco, Mexico | |||
280270 | 280270 | 2021-02-24 | Mexico | Jalisco | 77028 | 10297 | 0 | 66731 | 20.6595 | -103.3494 | 2021-02-25 05:24:57 | Jalisco, Mexico | ||
287140 | 287140 | 2020-06-15 | Mexico | Jalisco | 4139 | 348 | 2675 | 1116 | 20.6595 | -103.3494 | 2020-06-16 04:33:09 | 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 | |||
296100 | 296100 | 2021-07-15 | Mexico | Jalisco | 92884 | 12810 | 0 | 80074 | 20.6595 | -103.3494 | 2021-07-16 04:21:22 | Jalisco, Mexico | ||
303012 | 303012 | 2020-07-01 | Mexico | Jalisco | 6873 | 729 | 5188 | 956 | 20.6595 | -103.3494 | 2020-07-02 04:33:46 | 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 | |||
326951 | 326951 | 2020-07-20 | Mexico | Jalisco | 10642 | 1252 | 7473 | 1917 | 20.6595 | -103.3494 | 2020-07-21 04:38:46 | Jalisco, Mexico | ||
327997 | 327997 | 2022-12-27 | Mexico | Jalisco | 287766 | 20011 | 0 | 20.6595 | -103.3494 | 2022-12-28 04:21:04 | Jalisco, Mexico | |||
331994 | 331994 | 2021-08-04 | Mexico | Jalisco | 109128 | 13246 | 0 | 95882 | 20.6595 | -103.3494 | 2021-08-05 04:21:51 | Jalisco, Mexico | ||
336026 | 336026 | 2022-03-18 | Mexico | Jalisco | 237694 | 19316 | 0 | 20.6595 | -103.3494 | 2022-03-19 04:20:47 | Jalisco, Mexico | |||
340362 | 340362 | 2021-02-03 | Mexico | Jalisco | 70974 | 8728 | 0 | 62246 | 20.6595 | -103.3494 | 2021-02-04 05:22:26 | Jalisco, Mexico | ||
344361 | 344361 | 2020-09-14 | Mexico | Jalisco | 23346 | 2835 | 18749 | 1762 | 20.6595 | -103.3494 | 2020-09-15 03:22:50 | Jalisco, Mexico | ||
348387 | 348387 | 2022-12-14 | Mexico | Jalisco | 286128 | 20002 | 0 | 20.6595 | -103.3494 | 2022-12-15 04:20:58 | Jalisco, Mexico | |||
352383 | 352383 | 2021-03-11 | Mexico | Jalisco | 80158 | 10874 | 0 | 69284 | 20.6595 | -103.3494 | 2021-03-12 05:26:50 | 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 | |||
367360 | 367360 | 2020-07-16 | Mexico | Jalisco | 9921 | 1147 | 7433 | 1341 | 20.6595 | -103.3494 | 2020-07-17 04:34:50 | Jalisco, Mexico | ||
371328 | 371328 | 2020-08-08 | Mexico | Jalisco | 14847 | 1754 | 11298 | 1795 | 20.6595 | -103.3494 | 2020-08-09 04:34:54 | Jalisco, Mexico | ||
372287 | 372287 | 2022-09-13 | Mexico | Jalisco | 283088 | 19959 | 0 | 20.6595 | -103.3494 | 2022-09-14 04:20:44 | Jalisco, Mexico | |||
376269 | 376269 | 2020-11-06 | Mexico | Jalisco | 35860 | 4257 | 29318 | 2285 | 20.6595 | -103.3494 | 2020-11-07 05:24:52 | Jalisco, Mexico | ||
380280 | 380280 | 2021-04-30 | Mexico | Jalisco | 85436 | 11886 | 0 | 73550 | 20.6595 | -103.3494 | 2021-05-01 04:20:47 | Jalisco, Mexico | ||
384314 | 384314 | 2022-09-23 | Mexico | Jalisco | 283894 | 19972 | 0 | 20.6595 | -103.3494 | 2022-09-24 04:21:40 | Jalisco, Mexico | |||
388310 | 388310 | 2021-04-04 | Mexico | Jalisco | 82825 | 11388 | 0 | 71437 | 20.6595 | -103.3494 | 2021-04-05 04:20:35 | Jalisco, Mexico | ||
392322 | 392322 | 2020-11-27 | Mexico | Jalisco | 40276 | 4735 | 0 | 35541 | 20.6595 | -103.3494 | 2020-11-28 05:25:50 | Jalisco, Mexico | ||
396355 | 396355 | 2022-10-07 | Mexico | Jalisco | 284436 | 19981 | 0 | 20.6595 | -103.3494 | 2022-10-08 04:22:56 | Jalisco, Mexico | |||
400352 | 400352 | 2021-06-29 | Mexico | Jalisco | 88801 | 12681 | 0 | 76120 | 20.6595 | -103.3494 | 2021-06-30 04:21:41 | Jalisco, Mexico | ||
404383 | 404383 | 2021-12-07 | Mexico | Jalisco | 163823 | 17632 | 0 | 20.6595 | -103.3494 | 2021-12-08 04:22:46 | Jalisco, Mexico | |||
408382 | 408382 | 2021-07-28 | Mexico | Jalisco | 102355 | 13012 | 0 | 89343 | 20.6595 | -103.3494 | 2021-07-29 04:21:33 | Jalisco, Mexico | ||
415304 | 415304 | 2020-07-05 | Mexico | Jalisco | 7686 | 848 | 5792 | 1046 | 20.6595 | -103.3494 | 2020-07-06 04:33:57 | Jalisco, Mexico | ||
419426 | 419426 | 2022-09-18 | Mexico | Jalisco | 283503 | 19966 | 0 | 20.6595 | -103.3494 | 2022-09-19 04:21:49 | 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]);