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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016802 | 2016802 | 2022-09-20 | Mexico | Baja California | 163980 | 12416 | 0 | 30.8406 | -115.2838 | 2022-09-21 04:23:22 | Baja California, Mexico | |||
3570675 | 3570675 | 2022-09-19 | Mexico | Baja California | 163871 | 12415 | 0 | 30.8406 | -115.2838 | 2022-09-20 04:22:48 | Baja California, Mexico | |||
419414 | 419414 | 2022-09-18 | Mexico | Baja California | 163871 | 12415 | 0 | 30.8406 | -115.2838 | 2022-09-19 04:21:49 | Baja California, Mexico | |||
3373438 | 3373438 | 2022-09-17 | Mexico | Baja California | 163871 | 12415 | 0 | 30.8406 | -115.2838 | 2022-09-18 04:22:50 | Baja California, Mexico | |||
2355546 | 2355546 | 2022-09-16 | Mexico | Baja California | 163395 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-17 04:20:19 | Baja California, Mexico | |||
3986703 | 3986703 | 2022-09-15 | Mexico | Baja California | 163395 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-16 04:21:19 | Baja California, Mexico | |||
1889220 | 1889220 | 2022-09-14 | Mexico | Baja California | 163395 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-15 04:21:02 | Baja California, Mexico | |||
372275 | 372275 | 2022-09-13 | Mexico | Baja California | 163395 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-14 04:20:44 | Baja California, Mexico | |||
2394880 | 2394880 | 2022-09-12 | Mexico | Baja California | 163389 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-13 04:20:57 | Baja California, Mexico | |||
3765958 | 3765958 | 2022-09-11 | Mexico | Baja California | 163389 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-12 04:20:58 | Baja California, Mexico | |||
3824533 | 3824533 | 2022-09-10 | Mexico | Baja California | 163289 | 12414 | 0 | 30.8406 | -115.2838 | 2022-09-11 04:20:50 | Baja California, Mexico | |||
962990 | 962990 | 2022-09-09 | Mexico | Baja California | 162796 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-10 04:21:10 | Baja California, Mexico | |||
253392 | 253392 | 2022-09-08 | Mexico | Baja California | 162796 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-09 04:21:11 | Baja California, Mexico | |||
3745190 | 3745190 | 2022-09-07 | Mexico | Baja California | 162796 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-08 04:21:02 | Baja California, Mexico | |||
114830 | 114830 | 2022-09-06 | Mexico | Baja California | 162796 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-07 04:20:59 | Baja California, Mexico | |||
2633802 | 2633802 | 2022-09-05 | Mexico | Baja California | 162577 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-06 04:21:02 | Baja California, Mexico | |||
2987366 | 2987366 | 2022-09-04 | Mexico | Baja California | 162577 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-05 04:21:01 | Baja California, Mexico | |||
2713051 | 2713051 | 2022-09-03 | Mexico | Baja California | 162391 | 12407 | 0 | 30.8406 | -115.2838 | 2022-09-04 04:21:22 | Baja California, Mexico | |||
1393756 | 1393756 | 2022-09-02 | Mexico | Baja California | 162391 | 12407 | 0 | 30.8406 | -115.2838 | 2022-09-03 04:21:04 | Baja California, Mexico | |||
3547585 | 3547585 | 2022-09-01 | Mexico | Baja California | 162205 | 12406 | 0 | 30.8406 | -115.2838 | 2022-09-02 04:21:07 | Baja California, Mexico | |||
2343505 | 2343505 | 2022-08-31 | Mexico | Baja California | 161328 | 12403 | 0 | 30.8406 | -115.2838 | 2022-09-01 04:21:03 | Baja California, Mexico | |||
3773985 | 3773985 | 2022-08-30 | Mexico | Baja California | 161328 | 12403 | 0 | 30.8406 | -115.2838 | 2022-08-31 04:20:57 | Baja California, Mexico | |||
1680581 | 1680581 | 2022-08-29 | Mexico | Baja California | 161328 | 12403 | 0 | 30.8406 | -115.2838 | 2022-08-30 04:21:03 | Baja California, Mexico | |||
1877065 | 1877065 | 2022-08-28 | Mexico | Baja California | 161328 | 12403 | 0 | 30.8406 | -115.2838 | 2022-08-29 04:21:06 | Baja California, Mexico | |||
2096192 | 2096192 | 2022-08-27 | Mexico | Baja California | 160863 | 12398 | 0 | 30.8406 | -115.2838 | 2022-08-28 04:21:02 | Baja California, Mexico | |||
1532007 | 1532007 | 2022-08-26 | Mexico | Baja California | 160863 | 12398 | 0 | 30.8406 | -115.2838 | 2022-08-27 04:20:57 | Baja California, Mexico | |||
2828894 | 2828894 | 2022-08-25 | Mexico | Baja California | 160863 | 12398 | 0 | 30.8406 | -115.2838 | 2022-08-26 04:21:02 | Baja California, Mexico | |||
2323427 | 2323427 | 2022-08-24 | Mexico | Baja California | 160555 | 12394 | 0 | 30.8406 | -115.2838 | 2022-08-25 04:21:13 | Baja California, Mexico | |||
1250836 | 1250836 | 2022-08-23 | Mexico | Baja California | 160124 | 12392 | 0 | 30.8406 | -115.2838 | 2022-08-24 04:20:46 | Baja California, Mexico | |||
2852940 | 2852940 | 2022-08-22 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-23 04:20:56 | Baja California, Mexico | |||
2402912 | 2402912 | 2022-08-21 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-22 04:20:38 | Baja California, Mexico | |||
3797990 | 3797990 | 2022-08-20 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-21 04:20:44 | Baja California, Mexico | |||
2363576 | 2363576 | 2022-08-19 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-20 04:21:01 | Baja California, Mexico | |||
1161247 | 1161247 | 2022-08-18 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-19 04:20:54 | Baja California, Mexico | |||
3950571 | 3950571 | 2022-08-17 | Mexico | Baja California | 158538 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-18 04:21:11 | Baja California, Mexico | |||
991073 | 991073 | 2022-08-16 | Mexico | Baja California | 158159 | 12382 | 0 | 30.8406 | -115.2838 | 2022-08-17 04:20:59 | Baja California, Mexico | |||
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 |
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]);