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 = "Baja California" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2494112 | 2494112 | 2022-08-15 | Mexico | Baja California | 157865 | 12381 | 0 | 30.8406 | -115.2838 | 2022-08-16 04:20:58 | Baja California, Mexico | |||
3647662 | 3647662 | 2022-08-14 | Mexico | Baja California | 157815 | 12381 | 0 | 30.8406 | -115.2838 | 2022-08-15 04:20:59 | Baja California, Mexico | |||
1968668 | 1968668 | 2022-08-13 | Mexico | Baja California | 157801 | 12381 | 0 | 30.8406 | -115.2838 | 2022-08-14 04:20:55 | Baja California, Mexico | |||
2888477 | 2888477 | 2022-08-12 | Mexico | Baja California | 156751 | 12377 | 0 | 30.8406 | -115.2838 | 2022-08-13 04:20:52 | Baja California, Mexico | |||
3908082 | 3908082 | 2022-08-11 | Mexico | Baja California | 156751 | 12377 | 0 | 30.8406 | -115.2838 | 2022-08-12 04:20:54 | Baja California, Mexico | |||
1346399 | 1346399 | 2022-08-10 | Mexico | Baja California | 156751 | 12377 | 0 | 30.8406 | -115.2838 | 2022-08-11 04:20:49 | Baja California, Mexico | |||
1086154 | 1086154 | 2022-08-09 | Mexico | Baja California | 156751 | 12377 | 0 | 30.8406 | -115.2838 | 2022-08-10 04:20:57 | Baja California, Mexico | |||
3543569 | 3543569 | 2022-08-08 | Mexico | Baja California | 156387 | 12375 | 0 | 30.8406 | -115.2838 | 2022-08-09 04:20:34 | Baja California, Mexico | |||
1069972 | 1069972 | 2022-08-07 | Mexico | Baja California | 156333 | 12375 | 0 | 30.8406 | -115.2838 | 2022-08-08 04:21:08 | Baja California, Mexico | |||
1940560 | 1940560 | 2022-08-06 | Mexico | Baja California | 156322 | 12375 | 0 | 30.8406 | -115.2838 | 2022-08-07 04:20:54 | Baja California, Mexico | |||
880359 | 880359 | 2022-08-05 | Mexico | Baja California | 155697 | 12368 | 0 | 30.8406 | -115.2838 | 2022-08-06 04:20:56 | Baja California, Mexico | |||
2008770 | 2008770 | 2022-08-04 | Mexico | Baja California | 155697 | 12368 | 0 | 30.8406 | -115.2838 | 2022-08-05 04:20:52 | Baja California, Mexico | |||
1098197 | 1098197 | 2022-08-03 | Mexico | Baja California | 155282 | 12364 | 0 | 30.8406 | -115.2838 | 2022-08-04 04:20:58 | Baja California, Mexico | |||
1405122 | 1405122 | 2022-08-02 | Mexico | Baja California | 154759 | 12363 | 0 | 30.8406 | -115.2838 | 2022-08-03 04:20:59 | Baja California, Mexico | |||
3617160 | 3617160 | 2022-08-01 | Mexico | Baja California | 154322 | 12358 | 0 | 30.8406 | -115.2838 | 2022-08-02 04:20:53 | Baja California, Mexico | |||
3871640 | 3871640 | 2022-07-31 | Mexico | Baja California | 153285 | 12352 | 0 | 30.8406 | -115.2838 | 2022-08-01 04:21:03 | Baja California, Mexico | |||
674394 | 674394 | 2022-07-30 | Mexico | Baja California | 153285 | 12352 | 0 | 30.8406 | -115.2838 | 2022-07-31 04:21:02 | Baja California, Mexico | |||
1783593 | 1783593 | 2022-07-29 | Mexico | Baja California | 153285 | 12352 | 0 | 30.8406 | -115.2838 | 2022-07-30 04:20:42 | Baja California, Mexico | |||
1065956 | 1065956 | 2022-07-28 | Mexico | Baja California | 152720 | 12346 | 0 | 30.8406 | -115.2838 | 2022-07-29 04:20:45 | Baja California, Mexico | |||
2335475 | 2335475 | 2022-07-27 | Mexico | Baja California | 152720 | 12346 | 0 | 30.8406 | -115.2838 | 2022-07-28 04:20:56 | Baja California, Mexico | |||
1487665 | 1487665 | 2022-07-26 | Mexico | Baja California | 151330 | 12343 | 0 | 30.8406 | -115.2838 | 2022-07-27 04:21:04 | Baja California, Mexico | |||
2594111 | 2594111 | 2022-07-25 | Mexico | Baja California | 151330 | 12343 | 0 | 30.8406 | -115.2838 | 2022-07-26 04:20:58 | Baja California, Mexico | |||
896226 | 896226 | 2022-07-24 | Mexico | Baja California | 151292 | 12343 | 0 | 30.8406 | -115.2838 | 2022-07-25 04:20:51 | Baja California, Mexico | |||
91220 | 91220 | 2022-07-23 | Mexico | Baja California | 151232 | 12343 | 0 | 30.8406 | -115.2838 | 2022-07-24 04:20:47 | Baja California, Mexico | |||
900242 | 900242 | 2022-07-22 | Mexico | Baja California | 150745 | 12342 | 0 | 30.8406 | -115.2838 | 2022-07-23 04:20:53 | Baja California, Mexico | |||
670378 | 670378 | 2022-07-21 | Mexico | Baja California | 150094 | 12335 | 0 | 30.8406 | -115.2838 | 2022-07-22 04:21:15 | Baja California, Mexico | |||
1608341 | 1608341 | 2022-07-20 | Mexico | Baja California | 149319 | 12332 | 0 | 30.8406 | -115.2838 | 2022-07-21 04:21:10 | Baja California, Mexico | |||
958974 | 958974 | 2022-07-19 | Mexico | Baja California | 148496 | 12328 | 0 | 30.8406 | -115.2838 | 2022-07-20 04:20:59 | Baja California, Mexico | |||
3210361 | 3210361 | 2022-07-18 | Mexico | Baja California | 147606 | 12327 | 0 | 30.8406 | -115.2838 | 2022-07-19 04:20:58 | Baja California, Mexico | |||
3405536 | 3405536 | 2022-07-17 | Mexico | Baja California | 147606 | 12327 | 0 | 30.8406 | -115.2838 | 2022-07-18 04:20:59 | Baja California, Mexico | |||
2151736 | 2151736 | 2022-07-16 | Mexico | Baja California | 147476 | 12327 | 0 | 30.8406 | -115.2838 | 2022-07-17 04:21:15 | Baja California, Mexico | |||
2418969 | 2418969 | 2022-07-15 | Mexico | Baja California | 146828 | 12326 | 0 | 30.8406 | -115.2838 | 2022-07-16 04:21:05 | Baja California, Mexico | |||
3429044 | 3429044 | 2022-07-14 | Mexico | Baja California | 146113 | 12326 | 0 | 30.8406 | -115.2838 | 2022-07-15 04:20:53 | Baja California, Mexico | |||
3109564 | 3109564 | 2022-07-13 | Mexico | Baja California | 145380 | 12325 | 0 | 30.8406 | -115.2838 | 2022-07-14 04:20:57 | Baja California, Mexico | |||
629987 | 629987 | 2022-07-12 | Mexico | Baja California | 144707 | 12324 | 0 | 30.8406 | -115.2838 | 2022-07-13 04:20:58 | Baja California, Mexico | |||
1211631 | 1211631 | 2022-07-11 | Mexico | Baja California | 143946 | 12323 | 0 | 30.8406 | -115.2838 | 2022-07-12 04:20:51 | Baja California, Mexico | |||
2789113 | 2789113 | 2022-07-10 | Mexico | Baja California | 143892 | 12323 | 0 | 30.8406 | -115.2838 | 2022-07-11 04:20:46 | Baja California, Mexico | |||
142066 | 142066 | 2022-07-09 | Mexico | Baja California | 143804 | 12323 | 0 | 30.8406 | -115.2838 | 2022-07-10 04:20:54 | Baja California, Mexico | |||
1417166 | 1417166 | 2022-07-08 | Mexico | Baja California | 142660 | 12321 | 0 | 30.8406 | -115.2838 | 2022-07-09 04:20:59 | Baja California, Mexico | |||
2741091 | 2741091 | 2022-07-07 | Mexico | Baja California | 142660 | 12321 | 0 | 30.8406 | -115.2838 | 2022-07-08 04:20:56 | Baja California, Mexico | |||
1199886 | 1199886 | 2022-07-06 | Mexico | Baja California | 142130 | 12320 | 0 | 30.8406 | -115.2838 | 2022-07-07 04:20:55 | Baja California, Mexico | |||
3966629 | 3966629 | 2022-07-05 | Mexico | Baja California | 141464 | 12320 | 0 | 30.8406 | -115.2838 | 2022-07-06 04:20:58 | Baja California, Mexico | |||
3078140 | 3078140 | 2022-07-04 | Mexico | Baja California | 140899 | 12317 | 0 | 30.8406 | -115.2838 | 2022-07-05 04:20:45 | Baja California, Mexico | |||
1767422 | 1767422 | 2022-07-03 | Mexico | Baja California | 140875 | 12317 | 0 | 30.8406 | -115.2838 | 2022-07-04 04:20:54 | Baja California, Mexico | |||
3365408 | 3365408 | 2022-07-02 | Mexico | Baja California | 140466 | 12316 | 0 | 30.8406 | -115.2838 | 2022-07-03 04:20:59 | Baja California, Mexico | |||
593737 | 593737 | 2022-07-01 | Mexico | Baja California | 140466 | 12316 | 0 | 30.8406 | -115.2838 | 2022-07-02 04:21:16 | Baja California, Mexico | |||
3940138 | 3940138 | 2022-06-30 | Mexico | Baja California | 140061 | 12315 | 0 | 30.8406 | -115.2838 | 2022-07-01 04:21:10 | Baja California, Mexico | |||
2490096 | 2490096 | 2022-06-29 | Mexico | Baja California | 139141 | 12312 | 0 | 30.8406 | -115.2838 | 2022-06-30 04:21:01 | Baja California, Mexico | |||
2239478 | 2239478 | 2022-06-28 | Mexico | Baja California | 139141 | 12312 | 0 | 30.8406 | -115.2838 | 2022-06-29 04:20:59 | Baja California, Mexico | |||
2147720 | 2147720 | 2022-06-27 | Mexico | Baja California | 138706 | 12311 | 0 | 30.8406 | -115.2838 | 2022-06-28 04:20:58 | Baja California, Mexico | |||
475521 | 475521 | 2022-06-26 | Mexico | Baja California | 138678 | 12311 | 0 | 30.8406 | -115.2838 | 2022-06-27 04:21:00 | Baja California, Mexico | |||
938896 | 938896 | 2022-06-25 | Mexico | Baja California | 138639 | 12311 | 0 | 30.8406 | -115.2838 | 2022-06-26 04:21:02 | Baja California, Mexico | |||
3346716 | 3346716 | 2022-06-24 | Mexico | Baja California | 137996 | 12309 | 0 | 30.8406 | -115.2838 | 2022-06-25 04:20:57 | Baja California, Mexico | |||
1648457 | 1648457 | 2022-06-23 | Mexico | Baja California | 137673 | 12309 | 0 | 30.8406 | -115.2838 | 2022-06-24 04:20:58 | Baja California, Mexico | |||
2187692 | 2187692 | 2022-06-22 | Mexico | Baja California | 137318 | 12308 | 0 | 30.8406 | -115.2838 | 2022-06-23 04:20:55 | Baja California, Mexico | |||
166123 | 166123 | 2022-06-21 | Mexico | Baja California | 137318 | 12308 | 0 | 30.8406 | -115.2838 | 2022-06-22 04:20:54 | Baja California, Mexico | |||
1763406 | 1763406 | 2022-06-20 | Mexico | Baja California | 137021 | 12307 | 0 | 30.8406 | -115.2838 | 2022-06-21 04:20:56 | Baja California, Mexico | |||
3269592 | 3269592 | 2022-06-19 | Mexico | Baja California | 137019 | 12307 | 0 | 30.8406 | -115.2838 | 2022-06-20 04:21:01 | Baja California, Mexico | |||
3397504 | 3397504 | 2022-06-18 | Mexico | Baja California | 136606 | 12304 | 0 | 30.8406 | -115.2838 | 2022-06-19 04:20:51 | Baja California, Mexico | |||
2311381 | 2311381 | 2022-06-17 | Mexico | Baja California | 136606 | 12304 | 0 | 30.8406 | -115.2838 | 2022-06-18 04:21:10 | Baja California, Mexico | |||
558885 | 558885 | 2022-06-16 | Mexico | Baja California | 136606 | 12304 | 0 | 30.8406 | -115.2838 | 2022-06-17 04:20:56 | Baja California, Mexico | |||
3982687 | 3982687 | 2022-06-15 | Mexico | Baja California | 136439 | 12302 | 0 | 30.8406 | -115.2838 | 2022-06-16 04:20:55 | Baja California, Mexico | |||
946928 | 946928 | 2022-06-14 | Mexico | Baja California | 136259 | 12300 | 0 | 30.8406 | -115.2838 | 2022-06-15 04:20:54 | Baja California, Mexico | |||
2979336 | 2979336 | 2022-06-13 | Mexico | Baja California | 136054 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-14 04:20:52 | Baja California, Mexico | |||
2235462 | 2235462 | 2022-06-12 | Mexico | Baja California | 136054 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-13 04:21:14 | Baja California, Mexico | |||
3141660 | 3141660 | 2022-06-11 | Mexico | Baja California | 136044 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-12 04:20:53 | Baja California, Mexico | |||
1944576 | 1944576 | 2022-06-10 | Mexico | Baja California | 135905 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-11 04:21:01 | Baja California, Mexico | |||
3157715 | 3157715 | 2022-06-09 | Mexico | Baja California | 135582 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-10 04:20:55 | Baja California, Mexico | |||
1421182 | 1421182 | 2022-06-08 | Mexico | Baja California | 135582 | 12299 | 0 | 30.8406 | -115.2838 | 2022-06-09 04:20:54 | Baja California, Mexico | |||
3726296 | 3726296 | 2022-06-07 | Mexico | Baja California | 135427 | 12297 | 0 | 30.8406 | -115.2838 | 2022-06-08 04:20:55 | Baja California, Mexico | |||
3887698 | 3887698 | 2022-06-06 | Mexico | Baja California | 135294 | 12295 | 0 | 30.8406 | -115.2838 | 2022-06-07 04:21:08 | Baja California, Mexico | |||
3507467 | 3507467 | 2022-06-05 | Mexico | Baja California | 135291 | 12295 | 0 | 30.8406 | -115.2838 | 2022-06-06 04:20:57 | Baja California, Mexico | |||
3527544 | 3527544 | 2022-06-04 | Mexico | Baja California | 135289 | 12295 | 0 | 30.8406 | -115.2838 | 2022-06-05 04:20:55 | Baja California, Mexico | |||
3133630 | 3133630 | 2022-06-03 | Mexico | Baja California | 135087 | 12295 | 0 | 30.8406 | -115.2838 | 2022-06-04 04:20:58 | Baja California, Mexico | |||
3578705 | 3578705 | 2022-06-02 | Mexico | Baja California | 135087 | 12295 | 0 | 30.8406 | -115.2838 | 2022-06-03 04:20:58 | Baja California, Mexico | |||
970998 | 970998 | 2022-06-01 | Mexico | Baja California | 135030 | 12296 | 0 | 30.8406 | -115.2838 | 2022-06-02 05:20:39 | Baja California, Mexico | |||
229305 | 229305 | 2022-05-31 | Mexico | Baja California | 134957 | 12296 | 0 | 30.8406 | -115.2838 | 2022-06-01 04:20:55 | Baja California, Mexico | |||
3186070 | 3186070 | 2022-05-30 | Mexico | Baja California | 134858 | 12296 | 0 | 30.8406 | -115.2838 | 2022-05-31 04:20:51 | Baja California, Mexico | |||
3198219 | 3198219 | 2022-05-29 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-30 04:20:50 | Baja California, Mexico | |||
2725097 | 2725097 | 2022-05-28 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-29 04:20:53 | Baja California, Mexico | |||
1314278 | 1314278 | 2022-05-27 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-28 04:21:07 | Baja California, Mexico | |||
1850070 | 1850070 | 2022-05-26 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-27 04:20:56 | Baja California, Mexico | |||
2047946 | 2047946 | 2022-05-25 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-26 04:20:50 | Baja California, Mexico | |||
2999384 | 2999384 | 2022-05-24 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-25 04:20:56 | Baja California, Mexico | |||
3593105 | 3593105 | 2022-05-23 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-24 04:20:57 | Baja California, Mexico | |||
621957 | 621957 | 2022-05-22 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-26 04:20:50 | Baja California, Mexico | |||
1109653 | 1109653 | 2022-05-21 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-22 04:20:52 | Baja California, Mexico | |||
1169277 | 1169277 | 2022-05-20 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-21 04:20:58 | Baja California, Mexico | |||
3896040 | 3896040 | 2022-05-19 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-20 04:20:57 | Baja California, Mexico | |||
1184824 | 1184824 | 2022-05-18 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-19 04:20:54 | Baja California, Mexico | |||
3582721 | 3582721 | 2022-05-17 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-18 04:20:50 | Baja California, Mexico | |||
1503678 | 1503678 | 2022-05-16 | Mexico | Baja California | 134376 | 12285 | 0 | 30.8406 | -115.2838 | 2022-05-17 04:20:59 | Baja California, Mexico | |||
2084037 | 2084037 | 2022-05-15 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-16 04:20:47 | Baja California, Mexico | |||
3354747 | 3354747 | 2022-05-14 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-15 04:20:53 | Baja California, Mexico | |||
658392 | 658392 | 2022-05-13 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-14 04:20:48 | Baja California, Mexico | |||
2533475 | 2533475 | 2022-05-12 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-13 04:20:51 | Baja California, Mexico | |||
3444921 | 3444921 | 2022-05-11 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-12 04:20:54 | Baja California, Mexico | |||
3535538 | 3535538 | 2022-05-10 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-11 04:20:48 | Baja California, Mexico | |||
222073 | 222073 | 2022-05-09 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-10 04:20:50 | Baja California, Mexico | |||
2331458 | 2331458 | 2022-05-08 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-09 04:20:54 | 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]);