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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
360420 | 360420 | 2022-05-07 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-08 04:20:49 | Baja California, Mexico | |||
1397771 | 1397771 | 2022-05-06 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-07 04:21:09 | Baja California, Mexico | |||
2598126 | 2598126 | 2022-05-05 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-06 04:21:00 | Baja California, Mexico | |||
3265575 | 3265575 | 2022-05-04 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-05 04:20:55 | Baja California, Mexico | |||
1572214 | 1572214 | 2022-05-03 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-04 04:20:59 | Baja California, Mexico | |||
463474 | 463474 | 2022-05-02 | Mexico | Baja California | 134120 | 12274 | 0 | 30.8406 | -115.2838 | 2022-05-03 04:21:00 | Baja California, Mexico | |||
3916113 | 3916113 | 2022-05-01 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-02 04:21:10 | Baja California, Mexico | |||
2840917 | 2840917 | 2022-04-30 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-01 04:20:57 | Baja California, Mexico | |||
1157230 | 1157230 | 2022-04-29 | Mexico | Baja California | 134082 | 12270 | 0 | 30.8406 | -115.2838 | 2022-04-30 04:21:05 | Baja California, Mexico | |||
1696412 | 1696412 | 2022-04-28 | Mexico | Baja California | 134057 | 12268 | 0 | 30.8406 | -115.2838 | 2022-04-29 04:20:59 | Baja California, Mexico | |||
3851895 | 3851895 | 2022-04-27 | Mexico | Baja California | 134031 | 12266 | 0 | 30.8406 | -115.2838 | 2022-04-28 04:20:47 | Baja California, Mexico | |||
1326325 | 1326325 | 2022-04-26 | Mexico | Baja California | 134008 | 12255 | 0 | 30.8406 | -115.2838 | 2022-04-27 04:20:52 | Baja California, Mexico | |||
3722279 | 3722279 | 2022-04-25 | Mexico | Baja California | 133988 | 12249 | 0 | 30.8406 | -115.2838 | 2022-04-26 04:20:51 | Baja California, Mexico | |||
2028847 | 2028847 | 2022-04-24 | Mexico | Baja California | 133987 | 12249 | 0 | 30.8406 | -115.2838 | 2022-04-25 04:20:56 | Baja California, Mexico | |||
746422 | 746422 | 2022-04-23 | Mexico | Baja California | 133984 | 12249 | 0 | 30.8406 | -115.2838 | 2022-04-24 04:20:56 | Baja California, Mexico | |||
3436907 | 3436907 | 2022-04-22 | Mexico | Baja California | 133962 | 12241 | 0 | 30.8406 | -115.2838 | 2022-04-23 04:20:50 | Baja California, Mexico | |||
2892492 | 2892492 | 2022-04-21 | Mexico | Baja California | 133962 | 12241 | 0 | 30.8406 | -115.2838 | 2022-04-22 04:20:45 | Baja California, Mexico | |||
2307364 | 2307364 | 2022-04-20 | Mexico | Baja California | 133935 | 12238 | 0 | 30.8406 | -115.2838 | 2022-04-21 04:20:46 | Baja California, Mexico | |||
2251503 | 2251503 | 2022-04-19 | Mexico | Baja California | 133903 | 12238 | 0 | 30.8406 | -115.2838 | 2022-04-20 04:20:45 | Baja California, Mexico | |||
1846053 | 1846053 | 2022-04-18 | Mexico | Baja California | 133871 | 12236 | 0 | 30.8406 | -115.2838 | 2022-04-19 04:21:00 | Baja California, Mexico | |||
3416997 | 3416997 | 2022-04-17 | Mexico | Baja California | 133871 | 12236 | 0 | 30.8406 | -115.2838 | 2022-04-18 04:21:12 | Baja California, Mexico | |||
303946 | 303946 | 2022-04-16 | Mexico | Baja California | 133826 | 12236 | 0 | 30.8406 | -115.2838 | 2022-04-17 04:20:59 | Baja California, Mexico | |||
2669891 | 2669891 | 2022-04-15 | Mexico | Baja California | 133780 | 12233 | 0 | 30.8406 | -115.2838 | 2022-04-16 04:20:48 | Baja California, Mexico | |||
1223676 | 1223676 | 2022-04-14 | Mexico | Baja California | 133773 | 12232 | 0 | 30.8406 | -115.2838 | 2022-04-15 04:20:57 | Baja California, Mexico | |||
2442834 | 2442834 | 2022-04-13 | Mexico | Baja California | 133771 | 12230 | 0 | 30.8406 | -115.2838 | 2022-04-13 23:21:06 | Baja California, Mexico | |||
1948591 | 1948591 | 2022-04-12 | Mexico | Baja California | 133756 | 12224 | 0 | 30.8406 | -115.2838 | 2022-04-13 04:21:03 | Baja California, Mexico | |||
3206344 | 3206344 | 2022-04-11 | Mexico | Baja California | 133750 | 12220 | 0 | 30.8406 | -115.2838 | 2022-04-12 04:20:49 | Baja California, Mexico | |||
1576230 | 1576230 | 2022-04-10 | Mexico | Baja California | 133750 | 12220 | 0 | 30.8406 | -115.2838 | 2022-04-11 04:21:02 | Baja California, Mexico | |||
1652472 | 1652472 | 2022-04-09 | Mexico | Baja California | 133750 | 12220 | 0 | 30.8406 | -115.2838 | 2022-04-10 04:20:52 | Baja California, Mexico | |||
2115794 | 2115794 | 2022-04-08 | Mexico | Baja California | 133699 | 12218 | 0 | 30.8406 | -115.2838 | 2022-04-09 04:20:42 | Baja California, Mexico | |||
3320318 | 3320318 | 2022-04-07 | Mexico | Baja California | 133400 | 12217 | 0 | 30.8406 | -115.2838 | 2022-04-08 04:20:48 | Baja California, Mexico | |||
2800854 | 2800854 | 2022-04-06 | Mexico | Baja California | 133139 | 12215 | 0 | 30.8406 | -115.2838 | 2022-04-07 04:20:53 | Baja California, Mexico | |||
3867623 | 3867623 | 2022-04-05 | Mexico | Baja California | 132816 | 12215 | 0 | 30.8406 | -115.2838 | 2022-04-06 04:20:49 | Baja California, Mexico | |||
2748965 | 2748965 | 2022-04-04 | Mexico | Baja California | 132555 | 12214 | 0 | 30.8406 | -115.2838 | 2022-04-05 04:20:48 | Baja California, Mexico | |||
3730311 | 3730311 | 2022-04-03 | Mexico | Baja California | 132546 | 12213 | 0 | 30.8406 | -115.2838 | 2022-04-04 04:20:51 | Baja California, Mexico | |||
499746 | 499746 | 2022-04-02 | Mexico | Baja California | 132540 | 12213 | 0 | 30.8406 | -115.2838 | 2022-04-03 04:20:48 | Baja California, Mexico | |||
3350731 | 3350731 | 2022-04-01 | Mexico | Baja California | 132371 | 12212 | 0 | 30.8406 | -115.2838 | 2022-04-02 04:20:47 | Baja California, Mexico | |||
1540036 | 1540036 | 2022-03-31 | Mexico | Baja California | 132318 | 12202 | 0 | 30.8406 | -115.2838 | 2022-04-01 04:20:28 | Baja California, Mexico | |||
2478049 | 2478049 | 2022-03-30 | Mexico | Baja California | 132174 | 12201 | 0 | 30.8406 | -115.2838 | 2022-03-31 04:20:56 | Baja California, Mexico | |||
158090 | 158090 | 2022-03-29 | Mexico | Baja California | 132174 | 12201 | 0 | 30.8406 | -115.2838 | 2022-03-30 04:20:45 | Baja California, Mexico | |||
1436661 | 1436661 | 2022-03-28 | Mexico | Baja California | 132039 | 12194 | 0 | 30.8406 | -115.2838 | 2022-03-29 04:20:46 | Baja California, Mexico | |||
876342 | 876342 | 2022-03-27 | Mexico | Baja California | 132033 | 12194 | 0 | 30.8406 | -115.2838 | 2022-03-28 04:20:33 | Baja California, Mexico | |||
2163625 | 2163625 | 2022-03-26 | Mexico | Baja California | 131919 | 12194 | 0 | 30.8406 | -115.2838 | 2022-03-27 04:20:47 | Baja California, Mexico | |||
1720561 | 1720561 | 2022-03-25 | Mexico | Baja California | 131919 | 12194 | 0 | 30.8406 | -115.2838 | 2022-03-26 04:20:23 | Baja California, Mexico | |||
1468178 | 1468178 | 2022-03-24 | Mexico | Baja California | 131642 | 12189 | 0 | 30.8406 | -115.2838 | 2022-03-25 04:20:46 | Baja California, Mexico | |||
3022352 | 3022352 | 2022-03-23 | Mexico | Baja California | 131464 | 12180 | 0 | 30.8406 | -115.2838 | 2022-03-24 04:20:43 | Baja California, Mexico | |||
1905274 | 1905274 | 2022-03-22 | Mexico | Baja California | 131464 | 12180 | 0 | 30.8406 | -115.2838 | 2022-03-23 04:20:48 | Baja California, Mexico | |||
3238405 | 3238405 | 2022-03-21 | Mexico | Baja California | 131461 | 12180 | 0 | 30.8406 | -115.2838 | 2022-03-22 04:20:54 | Baja California, Mexico | |||
24478 | 24478 | 2022-03-20 | Mexico | Baja California | 131450 | 12179 | 0 | 30.8406 | -115.2838 | 2022-03-21 04:20:50 | Baja California, Mexico | |||
1656488 | 1656488 | 2022-03-19 | Mexico | Baja California | 131299 | 12164 | 0 | 30.8406 | -115.2838 | 2022-03-20 04:20:45 | Baja California, Mexico | |||
336014 | 336014 | 2022-03-18 | Mexico | Baja California | 131131 | 12160 | 0 | 30.8406 | -115.2838 | 2022-03-19 04:20:47 | Baja California, Mexico | |||
694467 | 694467 | 2022-03-17 | Mexico | Baja California | 131131 | 12160 | 0 | 30.8406 | -115.2838 | 2022-03-18 04:20:55 | Baja California, Mexico | |||
2319410 | 2319410 | 2022-03-16 | Mexico | Baja California | 130945 | 12154 | 0 | 30.8406 | -115.2838 | 2022-03-17 04:20:56 | Baja California, Mexico | |||
261610 | 261610 | 2022-03-15 | Mexico | Baja California | 130850 | 12144 | 0 | 30.8406 | -115.2838 | 2022-03-16 04:20:50 | Baja California, Mexico | |||
2263969 | 2263969 | 2022-03-14 | Mexico | Baja California | 130850 | 12144 | 0 | 30.8406 | -115.2838 | 2022-03-15 04:20:47 | Baja California, Mexico | |||
3628035 | 3628035 | 2022-03-13 | Mexico | Baja California | 130845 | 12142 | 0 | 30.8406 | -115.2838 | 2022-03-14 04:20:46 | Baja California, Mexico | |||
950943 | 950943 | 2022-03-12 | Mexico | Baja California | 130823 | 12142 | 0 | 30.8406 | -115.2838 | 2022-03-13 04:20:49 | Baja California, Mexico | |||
356404 | 356404 | 2022-03-11 | Mexico | Baja California | 130524 | 12122 | 0 | 30.8406 | -115.2838 | 2022-03-12 04:20:50 | Baja California, Mexico | |||
1865556 | 1865556 | 2022-03-10 | Mexico | Baja California | 130524 | 12122 | 0 | 30.8406 | -115.2838 | 2022-03-11 04:20:50 | Baja California, Mexico | |||
2140251 | 2140251 | 2022-03-09 | Mexico | Baja California | 130298 | 12115 | 0 | 30.8406 | -115.2838 | 2022-03-10 04:20:48 | Baja California, Mexico | |||
919762 | 919762 | 2022-03-08 | Mexico | Baja California | 130194 | 12114 | 0 | 30.8406 | -115.2838 | 2022-03-09 04:20:59 | Baja California, Mexico | |||
1548049 | 1548049 | 2022-03-07 | Mexico | Baja California | 129999 | 12105 | 0 | 30.8406 | -115.2838 | 2022-03-08 04:20:54 | Baja California, Mexico | |||
2199718 | 2199718 | 2022-03-06 | Mexico | Baja California | 129988 | 12104 | 0 | 30.8406 | -115.2838 | 2022-03-07 04:20:47 | Baja California, Mexico | |||
2092175 | 2092175 | 2022-03-05 | Mexico | Baja California | 129801 | 12098 | 0 | 30.8406 | -115.2838 | 2022-03-06 04:20:49 | Baja California, Mexico | |||
2665875 | 2665875 | 2022-03-04 | Mexico | Baja California | 129625 | 12096 | 0 | 30.8406 | -115.2838 | 2022-03-05 04:21:10 | Baja California, Mexico | |||
1644440 | 1644440 | 2022-03-03 | Mexico | Baja California | 129391 | 12095 | 0 | 30.8406 | -115.2838 | 2022-03-04 04:21:09 | Baja California, Mexico | |||
2525443 | 2525443 | 2022-03-02 | Mexico | Baja California | 129134 | 12072 | 0 | 30.8406 | -115.2838 | 2022-03-03 04:21:01 | Baja California, Mexico | |||
1992737 | 1992737 | 2022-03-01 | Mexico | Baja California | 129134 | 12072 | 0 | 30.8406 | -115.2838 | 2022-03-02 04:21:07 | Baja California, Mexico | |||
942911 | 942911 | 2022-02-28 | Mexico | Baja California | 128907 | 12066 | 0 | 30.8406 | -115.2838 | 2022-03-01 04:21:09 | Baja California, Mexico | |||
2733102 | 2733102 | 2022-02-27 | Mexico | Baja California | 128899 | 12064 | 0 | 30.8406 | -115.2838 | 2022-02-28 04:21:05 | Baja California, Mexico | |||
3046255 | 3046255 | 2022-02-26 | Mexico | Baja California | 128847 | 12061 | 0 | 30.8406 | -115.2838 | 2022-02-27 04:21:04 | Baja California, Mexico | |||
574910 | 574910 | 2022-02-25 | Mexico | Baja California | 128602 | 12052 | 0 | 30.8406 | -115.2838 | 2022-02-26 04:21:12 | Baja California, Mexico | |||
1511486 | 1511486 | 2022-02-24 | Mexico | Baja California | 128290 | 12035 | 0 | 30.8406 | -115.2838 | 2022-02-25 04:21:11 | Baja California, Mexico | |||
1057927 | 1057927 | 2022-02-23 | Mexico | Baja California | 128200 | 12024 | 0 | 30.8406 | -115.2838 | 2022-02-24 04:21:14 | Baja California, Mexico | |||
2446850 | 2446850 | 2022-02-22 | Mexico | Baja California | 127760 | 11984 | 0 | 30.8406 | -115.2838 | 2022-02-23 04:21:09 | Baja California, Mexico | |||
3718263 | 3718263 | 2022-02-21 | Mexico | Baja California | 127738 | 11984 | 0 | 30.8406 | -115.2838 | 2022-02-22 04:21:01 | Baja California, Mexico | |||
3912097 | 3912097 | 2022-02-20 | Mexico | Baja California | 127738 | 11984 | 0 | 30.8406 | -115.2838 | 2022-02-21 04:21:05 | Baja California, Mexico | |||
3875655 | 3875655 | 2022-02-19 | Mexico | Baja California | 127679 | 11983 | 0 | 30.8406 | -115.2838 | 2022-02-20 04:21:00 | Baja California, Mexico | |||
3855911 | 3855911 | 2022-02-18 | Mexico | Baja California | 127021 | 11926 | 0 | 30.8406 | -115.2838 | 2022-02-19 04:21:11 | Baja California, Mexico | |||
1298130 | 1298130 | 2022-02-17 | Mexico | Baja California | 127021 | 11926 | 0 | 30.8406 | -115.2838 | 2022-02-18 04:21:04 | Baja California, Mexico | |||
3820516 | 3820516 | 2022-02-16 | Mexico | Baja California | 126727 | 11906 | 0 | 30.8406 | -115.2838 | 2022-02-17 04:20:56 | Baja California, Mexico | |||
3671730 | 3671730 | 2022-02-15 | Mexico | Baja California | 126140 | 11855 | 0 | 30.8406 | -115.2838 | 2022-02-16 04:21:10 | Baja California, Mexico | |||
2641831 | 2641831 | 2022-02-14 | Mexico | Baja California | 126091 | 11845 | 0 | 30.8406 | -115.2838 | 2022-02-15 04:21:09 | Baja California, Mexico | |||
186148 | 186148 | 2022-02-13 | Mexico | Baja California | 126013 | 11840 | 0 | 30.8406 | -115.2838 | 2022-02-14 04:20:51 | Baja California, Mexico | |||
315994 | 315994 | 2022-02-12 | Mexico | Baja California | 126013 | 11840 | 0 | 30.8406 | -115.2838 | 2022-02-13 04:21:00 | Baja California, Mexico | |||
233320 | 233320 | 2022-02-11 | Mexico | Baja California | 125140 | 11782 | 0 | 30.8406 | -115.2838 | 2022-02-12 04:21:06 | Baja California, Mexico | |||
1464162 | 1464162 | 2022-02-10 | Mexico | Baja California | 124626 | 11739 | 0 | 30.8406 | -115.2838 | 2022-02-11 04:21:09 | Baja California, Mexico | |||
3074123 | 3074123 | 2022-02-09 | Mexico | Baja California | 124626 | 11739 | 0 | 30.8406 | -115.2838 | 2022-02-10 04:21:14 | Baja California, Mexico | |||
1362430 | 1362430 | 2022-02-08 | Mexico | Baja California | 124207 | 11702 | 0 | 30.8406 | -115.2838 | 2022-02-09 04:21:04 | Baja California, Mexico | |||
71168 | 71168 | 2022-02-07 | Mexico | Baja California | 124182 | 11702 | 0 | 30.8406 | -115.2838 | 2022-02-08 04:21:15 | Baja California, Mexico | |||
2012784 | 2012784 | 2022-02-06 | Mexico | Baja California | 124110 | 11685 | 0 | 30.8406 | -115.2838 | 2022-02-07 04:21:05 | Baja California, Mexico | |||
1294113 | 1294113 | 2022-02-05 | Mexico | Baja California | 124016 | 11683 | 0 | 30.8406 | -115.2838 | 2022-02-06 04:21:00 | Baja California, Mexico | |||
2327441 | 2327441 | 2022-02-04 | Mexico | Baja California | 123435 | 11647 | 0 | 30.8406 | -115.2838 | 2022-02-05 04:21:05 | Baja California, Mexico | |||
2474032 | 2474032 | 2022-02-03 | Mexico | Baja California | 122152 | 11567 | 0 | 30.8406 | -115.2838 | 2022-02-04 04:21:10 | Baja California, Mexico | |||
459457 | 459457 | 2022-02-02 | Mexico | Baja California | 121190 | 11545 | 0 | 30.8406 | -115.2838 | 2022-02-03 04:21:21 | 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]);