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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
407 | 407 | 2021-12-02 | Mexico | Baja California | 81310 | 10386 | 0 | 30.8406 | -115.2838 | 2021-12-03 04:23:05 | Baja California, Mexico | |||
4423 | 4423 | 2021-10-28 | Mexico | Baja California | 68446 | 9704 | 0 | 30.8406 | -115.2838 | 2021-10-29 04:22:03 | Baja California, Mexico | |||
12415 | 12415 | 2021-01-26 | Mexico | Baja California | 41273 | 6634 | 0 | 34639 | 30.8406 | -115.2838 | 2021-01-27 05:23:41 | Baja California, Mexico | ||
16431 | 16431 | 2021-09-18 | Mexico | Baja California | 58769 | 9228 | 0 | 30.8406 | -115.2838 | 2021-09-19 04:21:34 | Baja California, Mexico | |||
20446 | 20446 | 2021-05-28 | Mexico | Baja California | 49035 | 8234 | 0 | 40801 | 30.8406 | -115.2838 | 2021-05-29 04:20:41 | 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 | |||
28493 | 28493 | 2021-11-11 | Mexico | Baja California | 73769 | 9955 | 0 | 30.8406 | -115.2838 | 2021-11-12 04:22:01 | Baja California, Mexico | |||
32492 | 32492 | 2021-08-25 | Mexico | Baja California | 56055 | 9044 | 0 | 30.8406 | -115.2838 | 2021-08-26 04:21:28 | Baja California, Mexico | |||
36505 | 36505 | 2021-04-12 | Mexico | Baja California | 46972 | 7975 | 0 | 38997 | 30.8406 | -115.2838 | 2021-04-13 04:20:37 | Baja California, Mexico | ||
43785 | 43785 | 2021-11-02 | Mexico | Baja California | 69575 | 9748 | 0 | 30.8406 | -115.2838 | 2021-11-03 06:22:09 | Baja California, Mexico | |||
50867 | 50867 | 2021-05-29 | Mexico | Baja California | 49091 | 8241 | 0 | 40850 | 30.8406 | -115.2838 | 2021-05-30 04:20:55 | Baja California, Mexico | ||
54880 | 54880 | 2021-03-07 | Mexico | Baja California | 45440 | 7566 | 0 | 37874 | 30.8406 | -115.2838 | 2021-03-08 05:24:48 | 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 | |||
67137 | 67137 | 2021-09-01 | Mexico | Baja California | 57000 | 9093 | 0 | 30.8406 | -115.2838 | 2021-09-02 04:21:15 | 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 | |||
75164 | 75164 | 2020-12-03 | Mexico | Baja California | 27478 | 4394 | 0 | 23084 | 30.8406 | -115.2838 | 2020-12-04 05:27:27 | Baja California, Mexico | ||
83170 | 83170 | 2021-05-25 | Mexico | Baja California | 48890 | 8223 | 0 | 40667 | 30.8406 | -115.2838 | 2021-05-26 04:20:35 | Baja California, Mexico | ||
87202 | 87202 | 2021-11-09 | Mexico | Baja California | 72711 | 9890 | 0 | 30.8406 | -115.2838 | 2021-11-10 04:21:38 | 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 | |||
99403 | 99403 | 2022-01-14 | Mexico | Baja California | 101788 | 11247 | 0 | 30.8406 | -115.2838 | 2022-01-15 04:21:07 | Baja California, Mexico | |||
103402 | 103402 | 2021-08-15 | Mexico | Baja California | 54414 | 8975 | 0 | 30.8406 | -115.2838 | 2021-08-16 04:21:31 | Baja California, Mexico | |||
107527 | 107527 | 2021-06-19 | Mexico | Baja California | 50226 | 8637 | 0 | 41589 | 30.8406 | -115.2838 | 2021-06-20 04:21:48 | 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 | |||
122779 | 122779 | 2020-11-18 | Mexico | Baja California | 24645 | 4108 | 0 | 20537 | 30.8406 | -115.2838 | 2020-11-19 05:25:23 | Baja California, Mexico | ||
126810 | 126810 | 2022-01-09 | Mexico | Baja California | 97621 | 11178 | 0 | 30.8406 | -115.2838 | 2022-01-10 04:22:07 | 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 | |||
138048 | 138048 | 2021-12-04 | Mexico | Baja California | 82361 | 10418 | 0 | 30.8406 | -115.2838 | 2021-12-05 04:22:25 | 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 | |||
150061 | 150061 | 2021-11-29 | Mexico | Baja California | 80255 | 10344 | 0 | 30.8406 | -115.2838 | 2021-11-30 04:22:53 | Baja California, Mexico | |||
154058 | 154058 | 2021-01-08 | Mexico | Baja California | 36563 | 5889 | 0 | 30674 | 30.8406 | -115.2838 | 2021-01-09 05:22:18 | 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 | |||
162105 | 162105 | 2021-11-19 | Mexico | Baja California | 75959 | 10108 | 0 | 30.8406 | -115.2838 | 2021-11-20 04:22:17 | 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 | |||
170119 | 170119 | 2021-04-16 | Mexico | Baja California | 47153 | 7999 | 0 | 39154 | 30.8406 | -115.2838 | 2021-04-17 04:20:40 | Baja California, Mexico | ||
178102 | 178102 | 2021-09-02 | Mexico | Baja California | 57141 | 9111 | 0 | 30.8406 | -115.2838 | 2021-09-03 04:21:20 | Baja California, Mexico | |||
182115 | 182115 | 2021-02-21 | Mexico | Baja California | 44246 | 7281 | 0 | 36965 | 30.8406 | -115.2838 | 2021-02-22 05:24:21 | 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 | |||
190144 | 190144 | 2021-01-11 | Mexico | Baja California | 37110 | 6003 | 0 | 31107 | 30.8406 | -115.2838 | 2021-01-12 05:22:15 | 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 | |||
202331 | 202331 | 2020-12-25 | Mexico | Baja California | 32914 | 5220 | 0 | 27694 | 30.8406 | -115.2838 | 2020-12-26 05:22:28 | 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 | |||
222073 | 222073 | 2022-05-09 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-10 04:20:50 | 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 | |||
233320 | 233320 | 2022-02-11 | Mexico | Baja California | 125140 | 11782 | 0 | 30.8406 | -115.2838 | 2022-02-12 04:21:06 | Baja California, Mexico | |||
237316 | 237316 | 2021-01-18 | Mexico | Baja California | 38784 | 6320 | 0 | 32464 | 30.8406 | -115.2838 | 2021-01-19 05:22:15 | Baja California, Mexico | ||
241330 | 241330 | 2021-04-02 | Mexico | Baja California | 46488 | 7802 | 0 | 38686 | 30.8406 | -115.2838 | 2021-04-03 04:20:44 | Baja California, Mexico | ||
245345 | 245345 | 2021-08-17 | Mexico | Baja California | 54577 | 8986 | 0 | 30.8406 | -115.2838 | 2021-08-18 04:21:35 | Baja California, Mexico | |||
249359 | 249359 | 2021-09-04 | Mexico | Baja California | 57434 | 9128 | 0 | 30.8406 | -115.2838 | 2021-09-05 04:21:33 | 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 | |||
257408 | 257408 | 2022-12-10 | Mexico | Baja California | 167685 | 12444 | 0 | 30.8406 | -115.2838 | 2022-12-11 04:20:50 | 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 | |||
276260 | 276260 | 2021-11-03 | Mexico | Baja California | 70127 | 9766 | 0 | 30.8406 | -115.2838 | 2021-11-04 04:22:20 | Baja California, Mexico | |||
280258 | 280258 | 2021-02-24 | Mexico | Baja California | 44545 | 7325 | 0 | 37220 | 30.8406 | -115.2838 | 2021-02-25 05:24:57 | Baja California, Mexico | ||
288073 | 288073 | 2021-10-31 | Mexico | Baja California | 69508 | 9745 | 0 | 30.8406 | -115.2838 | 2021-11-01 04:22:01 | 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 | |||
296088 | 296088 | 2021-07-15 | Mexico | Baja California | 51485 | 8779 | 0 | 42706 | 30.8406 | -115.2838 | 2021-07-16 04:21:22 | 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 | |||
307963 | 307963 | 2022-12-13 | Mexico | Baja California | 168103 | 12448 | 0 | 30.8406 | -115.2838 | 2022-12-14 04:21:04 | 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 | |||
315994 | 315994 | 2022-02-12 | Mexico | Baja California | 126013 | 11840 | 0 | 30.8406 | -115.2838 | 2022-02-13 04:21:00 | 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 | |||
327985 | 327985 | 2022-12-27 | Mexico | Baja California | 169575 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-28 04:21:04 | Baja California, Mexico | |||
331982 | 331982 | 2021-08-04 | Mexico | Baja California | 53025 | 8927 | 0 | 44098 | 30.8406 | -115.2838 | 2021-08-05 04:21:51 | 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 | |||
340350 | 340350 | 2021-02-03 | Mexico | Baja California | 42447 | 6860 | 0 | 35587 | 30.8406 | -115.2838 | 2021-02-04 05:22:26 | 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 | |||
352371 | 352371 | 2021-03-11 | Mexico | Baja California | 45694 | 7640 | 0 | 38054 | 30.8406 | -115.2838 | 2021-03-12 05:26:50 | 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 | |||
360420 | 360420 | 2022-05-07 | Mexico | Baja California | 134104 | 12273 | 0 | 30.8406 | -115.2838 | 2022-05-08 04:20:49 | 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 | |||
380268 | 380268 | 2021-04-30 | Mexico | Baja California | 47699 | 8051 | 0 | 39648 | 30.8406 | -115.2838 | 2021-05-01 04:20:47 | 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 | |||
388298 | 388298 | 2021-04-04 | Mexico | Baja California | 46510 | 7810 | 0 | 38700 | 30.8406 | -115.2838 | 2021-04-05 04:20:35 | Baja California, Mexico | ||
392310 | 392310 | 2020-11-27 | Mexico | Baja California | 26391 | 4233 | 0 | 22158 | 30.8406 | -115.2838 | 2020-11-28 05:25:50 | 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 | |||
400340 | 400340 | 2021-06-29 | Mexico | Baja California | 50697 | 8728 | 0 | 41969 | 30.8406 | -115.2838 | 2021-06-30 04:21:41 | Baja California, Mexico | ||
404371 | 404371 | 2021-12-07 | Mexico | Baja California | 83026 | 10459 | 0 | 30.8406 | -115.2838 | 2021-12-08 04:22:46 | Baja California, Mexico | |||
408370 | 408370 | 2021-07-28 | Mexico | Baja California | 52356 | 8885 | 0 | 43471 | 30.8406 | -115.2838 | 2021-07-29 04:21:33 | 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 | |||
423428 | 423428 | 2021-10-10 | Mexico | Baja California | 63058 | 9483 | 0 | 30.8406 | -115.2838 | 2021-10-11 04:21:31 | 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 | |||
435431 | 435431 | 2021-01-21 | Mexico | Baja California | 39917 | 6468 | 0 | 33449 | 30.8406 | -115.2838 | 2021-01-22 05:22:10 | Baja California, Mexico | ||
443432 | 443432 | 2021-10-20 | Mexico | Baja California | 65561 | 9577 | 0 | 30.8406 | -115.2838 | 2021-10-21 04:21:18 | Baja California, Mexico | |||
447448 | 447448 | 2021-11-17 | Mexico | Baja California | 75417 | 10068 | 0 | 30.8406 | -115.2838 | 2021-11-18 04:21:33 | 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 | |||
459457 | 459457 | 2022-02-02 | Mexico | Baja California | 121190 | 11545 | 0 | 30.8406 | -115.2838 | 2022-02-03 04:21:21 | 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 | |||
467489 | 467489 | 2021-10-07 | Mexico | Baja California | 62380 | 9462 | 0 | 30.8406 | -115.2838 | 2021-10-08 04:21:25 | Baja California, Mexico | |||
471487 | 471487 | 2021-02-19 | Mexico | Baja California | 44175 | 7251 | 0 | 36924 | 30.8406 | -115.2838 | 2021-02-20 05:22:51 | 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 | |||
479669 | 479669 | 2022-11-08 | Mexico | Baja California | 165677 | 12424 | 0 | 30.8406 | -115.2838 | 2022-11-09 04:21:22 | Baja California, Mexico | |||
483666 | 483666 | 2021-07-19 | Mexico | Baja California | 51641 | 8786 | 0 | 42855 | 30.8406 | -115.2838 | 2021-07-20 04:21:48 | 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 | |||
491713 | 491713 | 2021-10-14 | Mexico | Baja California | 64031 | 9545 | 0 | 30.8406 | -115.2838 | 2021-10-15 04:21:26 | Baja California, Mexico | |||
495729 | 495729 | 2021-11-06 | Mexico | Baja California | 72005 | 9845 | 0 | 30.8406 | -115.2838 | 2021-11-07 04:21:53 | 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 | |||
503763 | 503763 | 2022-12-17 | Mexico | Baja California | 168649 | 12451 | 0 | 30.8406 | -115.2838 | 2022-12-18 04:21:03 | Baja California, Mexico | |||
507760 | 507760 | 2021-08-14 | Mexico | Baja California | 54414 | 8975 | 0 | 30.8406 | -115.2838 | 2021-08-15 04:21:41 | Baja California, Mexico | |||
511774 | 511774 | 2021-08-19 | Mexico | Baja California | 55127 | 9004 | 0 | 30.8406 | -115.2838 | 2021-08-20 04:21:33 | 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 |
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]);