johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and longitude = "-115.2838" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 1
- Baja California 954
country_or_region 1
- Mexico · 954 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752982 | 2752982 | 2022-12-29 | Mexico | Baja California | 169744 | 12456 | 0 | 30.8406 | -115.2838 | 2022-12-30 04:21:04 | Baja California, Mexico | |||
1073988 | 1073988 | 2022-12-28 | Mexico | Baja California | 169744 | 12456 | 0 | 30.8406 | -115.2838 | 2022-12-29 04:21:01 | Baja California, Mexico | |||
327985 | 327985 | 2022-12-27 | Mexico | Baja California | 169575 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-28 04:21:04 | Baja California, Mexico | |||
218058 | 218058 | 2022-12-26 | Mexico | Baja California | 169431 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-27 04:21:07 | Baja California, Mexico | |||
3222515 | 3222515 | 2022-12-25 | Mexico | Baja California | 169422 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-26 04:21:06 | Baja California, Mexico | |||
1018429 | 1018429 | 2022-12-24 | Mexico | Baja California | 169422 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-25 04:21:04 | Baja California, Mexico | |||
690452 | 690452 | 2022-12-23 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-24 04:21:02 | Baja California, Mexico | |||
2179662 | 2179662 | 2022-12-22 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-23 04:21:04 | Baja California, Mexico | |||
451466 | 451466 | 2022-12-21 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-22 04:20:56 | Baja California, Mexico | |||
2951465 | 2951465 | 2022-12-20 | Mexico | Baja California | 168812 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-21 04:21:03 | Baja California, Mexico | |||
3173867 | 3173867 | 2022-12-19 | Mexico | Baja California | 168692 | 12452 | 0 | 30.8406 | -115.2838 | 2022-12-20 04:21:04 | Baja California, Mexico | |||
1628384 | 1628384 | 2022-12-18 | Mexico | Baja California | 168649 | 12451 | 0 | 30.8406 | -115.2838 | 2022-12-19 04:21:03 | Baja California, Mexico | |||
503763 | 503763 | 2022-12-17 | Mexico | Baja California | 168649 | 12451 | 0 | 30.8406 | -115.2838 | 2022-12-18 04:21:03 | Baja California, Mexico | |||
3324335 | 3324335 | 2022-12-16 | Mexico | Baja California | 168238 | 12449 | 0 | 30.8406 | -115.2838 | 2022-12-17 04:21:04 | Baja California, Mexico | |||
542847 | 542847 | 2022-12-15 | Mexico | Baja California | 168238 | 12449 | 0 | 30.8406 | -115.2838 | 2022-12-16 04:21:01 | Baja California, Mexico | |||
348375 | 348375 | 2022-12-14 | Mexico | Baja California | 168103 | 12448 | 0 | 30.8406 | -115.2838 | 2022-12-15 04:20:58 | Baja California, Mexico | |||
307963 | 307963 | 2022-12-13 | Mexico | Baja California | 168103 | 12448 | 0 | 30.8406 | -115.2838 | 2022-12-14 04:21:04 | Baja California, Mexico | |||
1149024 | 1149024 | 2022-12-12 | Mexico | Baja California | 167963 | 12447 | 0 | 30.8406 | -115.2838 | 2022-12-13 04:21:01 | Baja California, Mexico | |||
868878 | 868878 | 2022-12-11 | Mexico | Baja California | 167685 | 12444 | 0 | 30.8406 | -115.2838 | 2022-12-12 04:21:01 | Baja California, Mexico | |||
257408 | 257408 | 2022-12-10 | Mexico | Baja California | 167685 | 12444 | 0 | 30.8406 | -115.2838 | 2022-12-11 04:20:50 | Baja California, Mexico | |||
3936122 | 3936122 | 2022-12-09 | Mexico | Baja California | 167685 | 12444 | 0 | 30.8406 | -115.2838 | 2022-12-10 04:21:02 | Baja California, Mexico | |||
3377454 | 3377454 | 2022-12-08 | Mexico | Baja California | 167685 | 12444 | 0 | 30.8406 | -115.2838 | 2022-12-09 04:21:05 | Baja California, Mexico | |||
1984725 | 1984725 | 2022-12-07 | Mexico | Baja California | 167553 | 12438 | 0 | 30.8406 | -115.2838 | 2022-12-08 04:21:07 | Baja California, Mexico | |||
3714248 | 3714248 | 2022-12-06 | Mexico | Baja California | 167344 | 12438 | 0 | 30.8406 | -115.2838 | 2022-12-07 04:20:58 | Baja California, Mexico | |||
2414953 | 2414953 | 2022-12-05 | Mexico | Baja California | 167229 | 12438 | 0 | 30.8406 | -115.2838 | 2022-12-06 04:21:03 | Baja California, Mexico | |||
718561 | 718561 | 2022-12-04 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-12-05 04:20:58 | Baja California, Mexico | |||
2816850 | 2816850 | 2022-12-03 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-12-04 04:20:56 | Baja California, Mexico | |||
833706 | 833706 | 2022-12-02 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-12-03 04:21:02 | Baja California, Mexico | |||
2136236 | 2136236 | 2022-12-01 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-12-02 04:21:07 | Baja California, Mexico | |||
1964652 | 1964652 | 2022-11-30 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-12-01 04:21:03 | Baja California, Mexico | |||
2556666 | 2556666 | 2022-11-29 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-30 04:21:07 | Baja California, Mexico | |||
1239740 | 1239740 | 2022-11-28 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-29 04:21:05 | Baja California, Mexico | |||
3551728 | 3551728 | 2022-11-27 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-28 04:21:02 | Baja California, Mexico | |||
2100208 | 2100208 | 2022-11-26 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-27 04:21:05 | Baja California, Mexico | |||
487699 | 487699 | 2022-11-25 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-26 04:21:11 | Baja California, Mexico | |||
3523528 | 3523528 | 2022-11-24 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-25 04:21:06 | Baja California, Mexico | |||
3312311 | 3312311 | 2022-11-23 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-24 04:21:09 | Baja California, Mexico | |||
1620352 | 1620352 | 2022-11-22 | Mexico | Baja California | 166262 | 12433 | 0 | 30.8406 | -115.2838 | 2022-11-23 04:21:06 | Baja California, Mexico | |||
3460240 | 3460240 | 2022-11-21 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-22 04:20:47 | Baja California, Mexico | |||
1640425 | 1640425 | 2022-11-20 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-21 04:21:05 | Baja California, Mexico | |||
2063982 | 2063982 | 2022-11-19 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-20 04:21:08 | Baja California, Mexico | |||
1755376 | 1755376 | 2022-11-18 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-19 04:21:14 | Baja California, Mexico | |||
3026369 | 3026369 | 2022-11-17 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-18 04:21:15 | Baja California, Mexico | |||
2486080 | 2486080 | 2022-11-16 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-17 04:21:11 | Baja California, Mexico | |||
292091 | 292091 | 2022-11-15 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-16 04:21:09 | Baja California, Mexico | |||
3597121 | 3597121 | 2022-11-14 | Mexico | Baja California | 165957 | 12427 | 0 | 30.8406 | -115.2838 | 2022-11-15 04:21:16 | Baja California, Mexico | |||
311979 | 311979 | 2022-11-13 | Mexico | Baja California | 165819 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-14 04:21:09 | Baja California, Mexico | |||
63140 | 63140 | 2022-11-12 | Mexico | Baja California | 165819 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-13 04:21:14 | Baja California, Mexico | |||
2927302 | 2927302 | 2022-11-11 | Mexico | Baja California | 165819 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-12 04:20:41 | Baja California, Mexico | |||
2506138 | 2506138 | 2022-11-10 | Mexico | Baja California | 165819 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-11 04:21:22 | Baja California, Mexico | |||
2431013 | 2431013 | 2022-11-09 | Mexico | Baja California | 165770 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-10 04:21:16 | Baja California, Mexico | |||
479669 | 479669 | 2022-11-08 | Mexico | Baja California | 165677 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-09 04:21:22 | Baja California, Mexico | |||
2438819 | 2438819 | 2022-11-07 | Mexico | Baja California | 165677 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-08 04:21:21 | Baja California, Mexico | |||
1049917 | 1049917 | 2022-11-06 | Mexico | Baja California | 165625 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-07 04:21:26 | Baja California, Mexico | |||
617941 | 617941 | 2022-11-05 | Mexico | Baja California | 165625 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-06 04:21:24 | Baja California, Mexico | |||
1022445 | 1022445 | 2022-11-04 | Mexico | Baja California | 165625 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-05 04:21:52 | Baja California, Mexico | |||
431436 | 431436 | 2022-11-03 | Mexico | Baja California | 165550 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-04 04:22:11 | Baja California, Mexico | |||
849678 | 849678 | 2022-11-02 | Mexico | Baja California | 165550 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-03 04:22:05 | Baja California, Mexico | |||
710529 | 710529 | 2022-11-01 | Mexico | Baja California | 165466 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-02 04:22:09 | Baja California, Mexico | |||
3284978 | 3284978 | 2022-10-31 | Mexico | Baja California | 165466 | 12423 | 0 | 30.8406 | -115.2838 | 2022-11-01 04:22:36 | Baja California, Mexico | |||
320011 | 320011 | 2022-10-30 | Mexico | Baja California | 165466 | 12423 | 0 | 30.8406 | -115.2838 | 2022-10-31 04:21:36 | Baja California, Mexico | |||
912287 | 912287 | 2022-10-29 | Mexico | Baja California | 165380 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-30 04:22:14 | Baja California, Mexico | |||
1366556 | 1366556 | 2022-10-28 | Mexico | Baja California | 165380 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-29 04:21:13 | Baja California, Mexico | |||
3038411 | 3038411 | 2022-10-27 | Mexico | Baja California | 165380 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-28 04:22:31 | Baja California, Mexico | |||
538831 | 538831 | 2022-10-26 | Mexico | Baja California | 165380 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-27 04:22:01 | Baja California, Mexico | |||
1830232 | 1830232 | 2022-10-25 | Mexico | Baja California | 165335 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-26 04:22:19 | Baja California, Mexico | |||
794493 | 794493 | 2022-10-24 | Mexico | Baja California | 165281 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-25 04:21:53 | Baja California, Mexico | |||
3276948 | 3276948 | 2022-10-23 | Mexico | Baja California | 165281 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-24 04:22:29 | Baja California, Mexico | |||
2267986 | 2267986 | 2022-10-22 | Mexico | Baja California | 165245 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-23 04:22:46 | Baja California, Mexico | |||
1592286 | 1592286 | 2022-10-21 | Mexico | Baja California | 165245 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-22 04:22:53 | Baja California, Mexico | |||
2272002 | 2272002 | 2022-10-20 | Mexico | Baja California | 165175 | 12422 | 0 | 30.8406 | -115.2838 | 2022-10-21 04:22:23 | Baja California, Mexico | |||
198337 | 198337 | 2022-10-19 | Mexico | Baja California | 165090 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-20 04:22:59 | Baja California, Mexico | |||
2756998 | 2756998 | 2022-10-18 | Mexico | Baja California | 165090 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-19 04:22:26 | Baja California, Mexico | |||
2024832 | 2024832 | 2022-10-17 | Mexico | Baja California | 165090 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-18 04:22:42 | Baja California, Mexico | |||
2159610 | 2159610 | 2022-10-16 | Mexico | Baja California | 165081 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-17 04:20:31 | Baja California, Mexico | |||
515807 | 515807 | 2022-10-15 | Mexico | Baja California | 165081 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-16 04:22:39 | Baja California, Mexico | |||
2032864 | 2032864 | 2022-10-14 | Mexico | Baja California | 165016 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-15 04:22:00 | Baja California, Mexico | |||
3753552 | 3753552 | 2022-10-13 | Mexico | Baja California | 165016 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-14 04:22:28 | Baja California, Mexico | |||
3214377 | 3214377 | 2022-10-12 | Mexico | Baja California | 164979 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-13 04:22:39 | Baja California, Mexico | |||
3250226 | 3250226 | 2022-10-11 | Mexico | Baja California | 164922 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-12 04:22:51 | Baja California, Mexico | |||
2967485 | 2967485 | 2022-10-10 | Mexico | Baja California | 164880 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-11 04:23:05 | Baja California, Mexico | |||
3097521 | 3097521 | 2022-10-09 | Mexico | Baja California | 164880 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-10 04:22:32 | Baja California, Mexico | |||
4002746 | 4002746 | 2022-10-08 | Mexico | Baja California | 164824 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-09 04:21:16 | Baja California, Mexico | |||
396343 | 396343 | 2022-10-07 | Mexico | Baja California | 164824 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-08 04:22:56 | Baja California, Mexico | |||
2529460 | 2529460 | 2022-10-06 | Mexico | Baja California | 164624 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-07 04:23:08 | Baja California, Mexico | |||
1810854 | 1810854 | 2022-10-05 | Mexico | Baja California | 164624 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-06 04:21:22 | Baja California, Mexico | |||
130828 | 130828 | 2022-10-04 | Mexico | Baja California | 164624 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-05 04:23:06 | Baja California, Mexico | |||
2685775 | 2685775 | 2022-10-03 | Mexico | Baja California | 164624 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-04 04:22:55 | Baja California, Mexico | |||
2259842 | 2259842 | 2022-10-02 | Mexico | Baja California | 164609 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-03 04:23:11 | Baja California, Mexico | |||
2995368 | 2995368 | 2022-10-01 | Mexico | Baja California | 164609 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-02 04:21:23 | Baja California, Mexico | |||
853694 | 853694 | 2022-09-30 | Mexico | Baja California | 164544 | 12418 | 0 | 30.8406 | -115.2838 | 2022-10-01 04:23:01 | Baja California, Mexico | |||
2375620 | 2375620 | 2022-09-29 | Mexico | Baja California | 164502 | 12418 | 0 | 30.8406 | -115.2838 | 2022-09-30 04:23:09 | Baja California, Mexico | |||
1560171 | 1560171 | 2022-09-28 | Mexico | Baja California | 164300 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-29 04:22:34 | Baja California, Mexico | |||
3994714 | 3994714 | 2022-09-27 | Mexico | Baja California | 164300 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-28 04:23:01 | Baja California, Mexico | |||
2769042 | 2769042 | 2022-09-26 | Mexico | Baja California | 164300 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-27 04:23:01 | Baja California, Mexico | |||
1976695 | 1976695 | 2022-09-25 | Mexico | Baja California | 164293 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-26 04:20:52 | Baja California, Mexico | |||
2649862 | 2649862 | 2022-09-24 | Mexico | Baja California | 164293 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-25 04:23:31 | Baja California, Mexico | |||
384302 | 384302 | 2022-09-23 | Mexico | Baja California | 164215 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-24 04:21:40 | Baja California, Mexico | |||
1624368 | 1624368 | 2022-09-22 | Mexico | Baja California | 164081 | 12416 | 0 | 30.8406 | -115.2838 | 2022-09-23 04:23:13 | Baja California, Mexico | |||
1370572 | 1370572 | 2022-09-21 | Mexico | Baja California | 164081 | 12416 | 0 | 30.8406 | -115.2838 | 2022-09-22 04:22:56 | Baja California, 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]);