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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533487 | 2533487 | 2022-05-12 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-13 04:20:51 | Jalisco, Mexico | |||
3444933 | 3444933 | 2022-05-11 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-12 04:20:54 | Jalisco, Mexico | |||
3535550 | 3535550 | 2022-05-10 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-11 04:20:48 | Jalisco, Mexico | |||
222085 | 222085 | 2022-05-09 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-10 04:20:50 | Jalisco, Mexico | |||
2331470 | 2331470 | 2022-05-08 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-09 04:20:54 | Jalisco, Mexico | |||
360432 | 360432 | 2022-05-07 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-08 04:20:49 | Jalisco, Mexico | |||
1397783 | 1397783 | 2022-05-06 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-07 04:21:09 | Jalisco, Mexico | |||
2598138 | 2598138 | 2022-05-05 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-06 04:21:00 | Jalisco, Mexico | |||
3265587 | 3265587 | 2022-05-04 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-05 04:20:55 | Jalisco, Mexico | |||
1572226 | 1572226 | 2022-05-03 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-04 04:20:59 | Jalisco, Mexico | |||
463486 | 463486 | 2022-05-02 | Mexico | Jalisco | 245477 | 19597 | 0 | 20.6595 | -103.3494 | 2022-05-03 04:21:00 | Jalisco, Mexico | |||
3916125 | 3916125 | 2022-05-01 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-02 04:21:10 | Jalisco, Mexico | |||
2840929 | 2840929 | 2022-04-30 | Mexico | Jalisco | 245442 | 19594 | 0 | 20.6595 | -103.3494 | 2022-05-01 04:20:57 | Jalisco, Mexico | |||
1157242 | 1157242 | 2022-04-29 | Mexico | Jalisco | 245428 | 19583 | 0 | 20.6595 | -103.3494 | 2022-04-30 04:21:05 | Jalisco, Mexico | |||
1696424 | 1696424 | 2022-04-28 | Mexico | Jalisco | 245396 | 19579 | 0 | 20.6595 | -103.3494 | 2022-04-29 04:20:59 | Jalisco, Mexico | |||
3851907 | 3851907 | 2022-04-27 | Mexico | Jalisco | 245366 | 19578 | 0 | 20.6595 | -103.3494 | 2022-04-28 04:20:47 | Jalisco, Mexico | |||
1326337 | 1326337 | 2022-04-26 | Mexico | Jalisco | 245298 | 19576 | 0 | 20.6595 | -103.3494 | 2022-04-27 04:20:52 | Jalisco, Mexico | |||
3722291 | 3722291 | 2022-04-25 | Mexico | Jalisco | 245256 | 19574 | 0 | 20.6595 | -103.3494 | 2022-04-26 04:20:51 | Jalisco, Mexico | |||
2028859 | 2028859 | 2022-04-24 | Mexico | Jalisco | 245255 | 19574 | 0 | 20.6595 | -103.3494 | 2022-04-25 04:20:56 | Jalisco, Mexico | |||
746434 | 746434 | 2022-04-23 | Mexico | Jalisco | 245247 | 19574 | 0 | 20.6595 | -103.3494 | 2022-04-24 04:20:56 | Jalisco, Mexico | |||
3436919 | 3436919 | 2022-04-22 | Mexico | Jalisco | 245185 | 19571 | 0 | 20.6595 | -103.3494 | 2022-04-23 04:20:50 | Jalisco, Mexico | |||
2892504 | 2892504 | 2022-04-21 | Mexico | Jalisco | 245185 | 19571 | 0 | 20.6595 | -103.3494 | 2022-04-22 04:20:45 | Jalisco, Mexico | |||
2307376 | 2307376 | 2022-04-20 | Mexico | Jalisco | 245142 | 19567 | 0 | 20.6595 | -103.3494 | 2022-04-21 04:20:46 | Jalisco, Mexico | |||
2251515 | 2251515 | 2022-04-19 | Mexico | Jalisco | 245107 | 19565 | 0 | 20.6595 | -103.3494 | 2022-04-20 04:20:45 | Jalisco, Mexico | |||
1846065 | 1846065 | 2022-04-18 | Mexico | Jalisco | 245074 | 19564 | 0 | 20.6595 | -103.3494 | 2022-04-19 04:21:00 | Jalisco, Mexico | |||
3417009 | 3417009 | 2022-04-17 | Mexico | Jalisco | 245074 | 19564 | 0 | 20.6595 | -103.3494 | 2022-04-18 04:21:12 | Jalisco, Mexico | |||
303958 | 303958 | 2022-04-16 | Mexico | Jalisco | 245040 | 19564 | 0 | 20.6595 | -103.3494 | 2022-04-17 04:20:59 | Jalisco, Mexico | |||
2669903 | 2669903 | 2022-04-15 | Mexico | Jalisco | 244976 | 19564 | 0 | 20.6595 | -103.3494 | 2022-04-16 04:20:48 | Jalisco, Mexico | |||
1223688 | 1223688 | 2022-04-14 | Mexico | Jalisco | 244953 | 19562 | 0 | 20.6595 | -103.3494 | 2022-04-15 04:20:57 | Jalisco, Mexico | |||
2442846 | 2442846 | 2022-04-13 | Mexico | Jalisco | 244939 | 19562 | 0 | 20.6595 | -103.3494 | 2022-04-13 23:21:06 | Jalisco, Mexico | |||
1948603 | 1948603 | 2022-04-12 | Mexico | Jalisco | 244928 | 19561 | 0 | 20.6595 | -103.3494 | 2022-04-13 04:21:03 | Jalisco, Mexico | |||
3206356 | 3206356 | 2022-04-11 | Mexico | Jalisco | 244923 | 19552 | 0 | 20.6595 | -103.3494 | 2022-04-12 04:20:49 | Jalisco, Mexico | |||
1576242 | 1576242 | 2022-04-10 | Mexico | Jalisco | 244921 | 19552 | 0 | 20.6595 | -103.3494 | 2022-04-11 04:21:02 | Jalisco, Mexico | |||
1652484 | 1652484 | 2022-04-09 | Mexico | Jalisco | 244914 | 19552 | 0 | 20.6595 | -103.3494 | 2022-04-10 04:20:52 | Jalisco, Mexico | |||
2115806 | 2115806 | 2022-04-08 | Mexico | Jalisco | 244395 | 19527 | 0 | 20.6595 | -103.3494 | 2022-04-09 04:20:42 | Jalisco, Mexico | |||
3320330 | 3320330 | 2022-04-07 | Mexico | Jalisco | 243628 | 19525 | 0 | 20.6595 | -103.3494 | 2022-04-08 04:20:48 | Jalisco, Mexico | |||
2800866 | 2800866 | 2022-04-06 | Mexico | Jalisco | 242704 | 19512 | 0 | 20.6595 | -103.3494 | 2022-04-07 04:20:53 | Jalisco, Mexico | |||
3867635 | 3867635 | 2022-04-05 | Mexico | Jalisco | 241992 | 19505 | 0 | 20.6595 | -103.3494 | 2022-04-06 04:20:49 | Jalisco, Mexico | |||
2748977 | 2748977 | 2022-04-04 | Mexico | Jalisco | 241140 | 19500 | 0 | 20.6595 | -103.3494 | 2022-04-05 04:20:48 | Jalisco, Mexico | |||
3730323 | 3730323 | 2022-04-03 | Mexico | Jalisco | 241029 | 19497 | 0 | 20.6595 | -103.3494 | 2022-04-04 04:20:51 | Jalisco, Mexico | |||
499758 | 499758 | 2022-04-02 | Mexico | Jalisco | 240895 | 19492 | 0 | 20.6595 | -103.3494 | 2022-04-03 04:20:48 | Jalisco, Mexico | |||
3350743 | 3350743 | 2022-04-01 | Mexico | Jalisco | 240328 | 19488 | 0 | 20.6595 | -103.3494 | 2022-04-02 04:20:47 | Jalisco, Mexico | |||
1540048 | 1540048 | 2022-03-31 | Mexico | Jalisco | 240138 | 19471 | 0 | 20.6595 | -103.3494 | 2022-04-01 04:20:28 | Jalisco, Mexico | |||
2478061 | 2478061 | 2022-03-30 | Mexico | Jalisco | 239806 | 19447 | 0 | 20.6595 | -103.3494 | 2022-03-31 04:20:56 | Jalisco, Mexico | |||
158102 | 158102 | 2022-03-29 | Mexico | Jalisco | 239806 | 19447 | 0 | 20.6595 | -103.3494 | 2022-03-30 04:20:45 | Jalisco, Mexico | |||
1436673 | 1436673 | 2022-03-28 | Mexico | Jalisco | 239569 | 19435 | 0 | 20.6595 | -103.3494 | 2022-03-29 04:20:46 | Jalisco, Mexico | |||
876354 | 876354 | 2022-03-27 | Mexico | Jalisco | 239477 | 19432 | 0 | 20.6595 | -103.3494 | 2022-03-28 04:20:33 | Jalisco, Mexico | |||
2163637 | 2163637 | 2022-03-26 | Mexico | Jalisco | 239191 | 19407 | 0 | 20.6595 | -103.3494 | 2022-03-27 04:20:47 | Jalisco, Mexico | |||
1720573 | 1720573 | 2022-03-25 | Mexico | Jalisco | 239191 | 19407 | 0 | 20.6595 | -103.3494 | 2022-03-26 04:20:23 | Jalisco, Mexico | |||
1468190 | 1468190 | 2022-03-24 | Mexico | Jalisco | 238663 | 19352 | 0 | 20.6595 | -103.3494 | 2022-03-25 04:20:46 | Jalisco, Mexico | |||
3022364 | 3022364 | 2022-03-23 | Mexico | Jalisco | 238385 | 19337 | 0 | 20.6595 | -103.3494 | 2022-03-24 04:20:43 | Jalisco, Mexico | |||
1905286 | 1905286 | 2022-03-22 | Mexico | Jalisco | 238385 | 19337 | 0 | 20.6595 | -103.3494 | 2022-03-23 04:20:48 | Jalisco, Mexico | |||
3238417 | 3238417 | 2022-03-21 | Mexico | Jalisco | 238374 | 19336 | 0 | 20.6595 | -103.3494 | 2022-03-22 04:20:54 | Jalisco, Mexico | |||
24490 | 24490 | 2022-03-20 | Mexico | Jalisco | 238333 | 19331 | 0 | 20.6595 | -103.3494 | 2022-03-21 04:20:50 | Jalisco, Mexico | |||
1656500 | 1656500 | 2022-03-19 | Mexico | Jalisco | 238002 | 19323 | 0 | 20.6595 | -103.3494 | 2022-03-20 04:20:45 | Jalisco, Mexico | |||
336026 | 336026 | 2022-03-18 | Mexico | Jalisco | 237694 | 19316 | 0 | 20.6595 | -103.3494 | 2022-03-19 04:20:47 | Jalisco, Mexico | |||
694479 | 694479 | 2022-03-17 | Mexico | Jalisco | 237694 | 19316 | 0 | 20.6595 | -103.3494 | 2022-03-18 04:20:55 | Jalisco, Mexico | |||
2319422 | 2319422 | 2022-03-16 | Mexico | Jalisco | 236989 | 19293 | 0 | 20.6595 | -103.3494 | 2022-03-17 04:20:56 | Jalisco, Mexico | |||
261622 | 261622 | 2022-03-15 | Mexico | Jalisco | 236515 | 19273 | 0 | 20.6595 | -103.3494 | 2022-03-16 04:20:50 | Jalisco, Mexico | |||
2263981 | 2263981 | 2022-03-14 | Mexico | Jalisco | 236515 | 19273 | 0 | 20.6595 | -103.3494 | 2022-03-15 04:20:47 | Jalisco, Mexico | |||
3628047 | 3628047 | 2022-03-13 | Mexico | Jalisco | 236435 | 19273 | 0 | 20.6595 | -103.3494 | 2022-03-14 04:20:46 | Jalisco, Mexico | |||
950955 | 950955 | 2022-03-12 | Mexico | Jalisco | 236273 | 19273 | 0 | 20.6595 | -103.3494 | 2022-03-13 04:20:49 | Jalisco, Mexico | |||
356416 | 356416 | 2022-03-11 | Mexico | Jalisco | 235314 | 19261 | 0 | 20.6595 | -103.3494 | 2022-03-12 04:20:50 | Jalisco, Mexico | |||
1865568 | 1865568 | 2022-03-10 | Mexico | Jalisco | 235314 | 19261 | 0 | 20.6595 | -103.3494 | 2022-03-11 04:20:50 | Jalisco, Mexico | |||
2140263 | 2140263 | 2022-03-09 | Mexico | Jalisco | 234773 | 19252 | 0 | 20.6595 | -103.3494 | 2022-03-10 04:20:48 | Jalisco, Mexico | |||
919774 | 919774 | 2022-03-08 | Mexico | Jalisco | 234286 | 19241 | 0 | 20.6595 | -103.3494 | 2022-03-09 04:20:59 | Jalisco, Mexico | |||
1548061 | 1548061 | 2022-03-07 | Mexico | Jalisco | 233631 | 19235 | 0 | 20.6595 | -103.3494 | 2022-03-08 04:20:54 | Jalisco, Mexico | |||
2199730 | 2199730 | 2022-03-06 | Mexico | Jalisco | 233473 | 19228 | 0 | 20.6595 | -103.3494 | 2022-03-07 04:20:47 | Jalisco, Mexico | |||
2092187 | 2092187 | 2022-03-05 | Mexico | Jalisco | 232698 | 19211 | 0 | 20.6595 | -103.3494 | 2022-03-06 04:20:49 | Jalisco, Mexico | |||
2665887 | 2665887 | 2022-03-04 | Mexico | Jalisco | 231996 | 19189 | 0 | 20.6595 | -103.3494 | 2022-03-05 04:21:10 | Jalisco, Mexico | |||
1644452 | 1644452 | 2022-03-03 | Mexico | Jalisco | 231229 | 19125 | 0 | 20.6595 | -103.3494 | 2022-03-04 04:21:09 | Jalisco, Mexico | |||
2525455 | 2525455 | 2022-03-02 | Mexico | Jalisco | 230426 | 19088 | 0 | 20.6595 | -103.3494 | 2022-03-03 04:21:01 | Jalisco, Mexico | |||
1992749 | 1992749 | 2022-03-01 | Mexico | Jalisco | 230426 | 19088 | 0 | 20.6595 | -103.3494 | 2022-03-02 04:21:07 | Jalisco, Mexico | |||
942923 | 942923 | 2022-02-28 | Mexico | Jalisco | 229602 | 19057 | 0 | 20.6595 | -103.3494 | 2022-03-01 04:21:09 | Jalisco, Mexico | |||
2733114 | 2733114 | 2022-02-27 | Mexico | Jalisco | 229469 | 19048 | 0 | 20.6595 | -103.3494 | 2022-02-28 04:21:05 | Jalisco, Mexico | |||
3046267 | 3046267 | 2022-02-26 | Mexico | Jalisco | 229284 | 19045 | 0 | 20.6595 | -103.3494 | 2022-02-27 04:21:04 | Jalisco, Mexico | |||
574922 | 574922 | 2022-02-25 | Mexico | Jalisco | 228530 | 19033 | 0 | 20.6595 | -103.3494 | 2022-02-26 04:21:12 | Jalisco, Mexico | |||
1511498 | 1511498 | 2022-02-24 | Mexico | Jalisco | 227571 | 19006 | 0 | 20.6595 | -103.3494 | 2022-02-25 04:21:11 | Jalisco, Mexico | |||
1057939 | 1057939 | 2022-02-23 | Mexico | Jalisco | 226573 | 18974 | 0 | 20.6595 | -103.3494 | 2022-02-24 04:21:14 | Jalisco, Mexico | |||
2446862 | 2446862 | 2022-02-22 | Mexico | Jalisco | 224639 | 18868 | 0 | 20.6595 | -103.3494 | 2022-02-23 04:21:09 | Jalisco, Mexico | |||
3718275 | 3718275 | 2022-02-21 | Mexico | Jalisco | 224403 | 18864 | 0 | 20.6595 | -103.3494 | 2022-02-22 04:21:01 | Jalisco, Mexico | |||
3912109 | 3912109 | 2022-02-20 | Mexico | Jalisco | 224403 | 18864 | 0 | 20.6595 | -103.3494 | 2022-02-21 04:21:05 | Jalisco, Mexico | |||
3875667 | 3875667 | 2022-02-19 | Mexico | Jalisco | 224087 | 18854 | 0 | 20.6595 | -103.3494 | 2022-02-20 04:21:00 | Jalisco, Mexico | |||
3855923 | 3855923 | 2022-02-18 | Mexico | Jalisco | 221712 | 18789 | 0 | 20.6595 | -103.3494 | 2022-02-19 04:21:11 | Jalisco, Mexico | |||
1298142 | 1298142 | 2022-02-17 | Mexico | Jalisco | 221712 | 18789 | 0 | 20.6595 | -103.3494 | 2022-02-18 04:21:04 | Jalisco, Mexico | |||
3820528 | 3820528 | 2022-02-16 | Mexico | Jalisco | 220569 | 18736 | 0 | 20.6595 | -103.3494 | 2022-02-17 04:20:56 | Jalisco, Mexico | |||
3671742 | 3671742 | 2022-02-15 | Mexico | Jalisco | 218746 | 18674 | 0 | 20.6595 | -103.3494 | 2022-02-16 04:21:10 | Jalisco, Mexico | |||
2641843 | 2641843 | 2022-02-14 | Mexico | Jalisco | 218488 | 18673 | 0 | 20.6595 | -103.3494 | 2022-02-15 04:21:09 | Jalisco, Mexico | |||
186160 | 186160 | 2022-02-13 | Mexico | Jalisco | 218155 | 18665 | 0 | 20.6595 | -103.3494 | 2022-02-14 04:20:51 | Jalisco, Mexico | |||
316006 | 316006 | 2022-02-12 | Mexico | Jalisco | 218155 | 18665 | 0 | 20.6595 | -103.3494 | 2022-02-13 04:21:00 | Jalisco, Mexico | |||
233332 | 233332 | 2022-02-11 | Mexico | Jalisco | 215505 | 18589 | 0 | 20.6595 | -103.3494 | 2022-02-12 04:21:06 | Jalisco, Mexico | |||
1464174 | 1464174 | 2022-02-10 | Mexico | Jalisco | 213747 | 18535 | 0 | 20.6595 | -103.3494 | 2022-02-11 04:21:09 | Jalisco, Mexico | |||
3074135 | 3074135 | 2022-02-09 | Mexico | Jalisco | 213747 | 18535 | 0 | 20.6595 | -103.3494 | 2022-02-10 04:21:14 | Jalisco, Mexico | |||
1362442 | 1362442 | 2022-02-08 | Mexico | Jalisco | 212765 | 18468 | 0 | 20.6595 | -103.3494 | 2022-02-09 04:21:04 | Jalisco, Mexico | |||
71180 | 71180 | 2022-02-07 | Mexico | Jalisco | 212577 | 18463 | 0 | 20.6595 | -103.3494 | 2022-02-08 04:21:15 | Jalisco, Mexico | |||
2012796 | 2012796 | 2022-02-06 | Mexico | Jalisco | 212148 | 18453 | 0 | 20.6595 | -103.3494 | 2022-02-07 04:21:05 | Jalisco, Mexico | |||
1294125 | 1294125 | 2022-02-05 | Mexico | Jalisco | 211642 | 18447 | 0 | 20.6595 | -103.3494 | 2022-02-06 04:21:00 | Jalisco, Mexico | |||
2327453 | 2327453 | 2022-02-04 | Mexico | Jalisco | 210101 | 18403 | 0 | 20.6595 | -103.3494 | 2022-02-05 04:21:05 | Jalisco, Mexico | |||
2474044 | 2474044 | 2022-02-03 | Mexico | Jalisco | 206393 | 18301 | 0 | 20.6595 | -103.3494 | 2022-02-04 04:21:10 | Jalisco, Mexico | |||
459469 | 459469 | 2022-02-02 | Mexico | Jalisco | 204587 | 18243 | 0 | 20.6595 | -103.3494 | 2022-02-03 04:21:21 | 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]);