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 active
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 | |||
16431 | 16431 | 2021-09-18 | Mexico | Baja California | 58769 | 9228 | 0 | 30.8406 | -115.2838 | 2021-09-19 04:21:34 | 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 | |||
43785 | 43785 | 2021-11-02 | Mexico | Baja California | 69575 | 9748 | 0 | 30.8406 | -115.2838 | 2021-11-03 06:22: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 | |||
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 | |||
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 | |||
114830 | 114830 | 2022-09-06 | Mexico | Baja California | 162796 | 12410 | 0 | 30.8406 | -115.2838 | 2022-09-07 04:20:59 | 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 | |||
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 | |||
178102 | 178102 | 2021-09-02 | Mexico | Baja California | 57141 | 9111 | 0 | 30.8406 | -115.2838 | 2021-09-03 04:21:20 | 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 | |||
198337 | 198337 | 2022-10-19 | Mexico | Baja California | 165090 | 12419 | 0 | 30.8406 | -115.2838 | 2022-10-20 04:22:59 | 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 | |||
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 | |||
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 | |||
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 | |||
336014 | 336014 | 2022-03-18 | Mexico | Baja California | 131131 | 12160 | 0 | 30.8406 | -115.2838 | 2022-03-19 04:20:47 | 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 | |||
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 | |||
384302 | 384302 | 2022-09-23 | Mexico | Baja California | 164215 | 12417 | 0 | 30.8406 | -115.2838 | 2022-09-24 04:21:40 | 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 | |||
404371 | 404371 | 2021-12-07 | Mexico | Baja California | 83026 | 10459 | 0 | 30.8406 | -115.2838 | 2021-12-08 04:22:46 | 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 | |||
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 | |||
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 | |||
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 | |||
534813 | 534813 | 2021-10-27 | Mexico | Baja California | 67350 | 9643 | 0 | 30.8406 | -115.2838 | 2021-10-28 04:22:08 | 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 | |||
542847 | 542847 | 2022-12-15 | Mexico | Baja California | 168238 | 12449 | 0 | 30.8406 | -115.2838 | 2022-12-16 04:21:01 | Baja California, Mexico | |||
550851 | 550851 | 2021-12-08 | Mexico | Baja California | 83480 | 10503 | 0 | 30.8406 | -115.2838 | 2021-12-09 04:22:49 | Baja California, Mexico | |||
554867 | 554867 | 2022-01-16 | Mexico | Baja California | 105109 | 11313 | 0 | 30.8406 | -115.2838 | 2022-01-17 04:21:08 | 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 | |||
567181 | 567181 | 2021-10-29 | Mexico | Baja California | 68957 | 9722 | 0 | 30.8406 | -115.2838 | 2021-10-30 04:22:03 | 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 | |||
589704 | 589704 | 2021-08-08 | Mexico | Baja California | 53517 | 8940 | 0 | 30.8406 | -115.2838 | 2021-08-09 04:21:24 | 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 | |||
597751 | 597751 | 2021-10-19 | Mexico | Baja California | 65097 | 9565 | 0 | 30.8406 | -115.2838 | 2021-10-20 04:21:00 | Baja California, Mexico | |||
601767 | 601767 | 2021-09-23 | Mexico | Baja California | 59724 | 9297 | 0 | 30.8406 | -115.2838 | 2021-09-24 04:21:44 | 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 | |||
621957 | 621957 | 2022-05-22 | Mexico | Baja California | 134542 | 12289 | 0 | 30.8406 | -115.2838 | 2022-05-26 04:20:50 | 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 | |||
634001 | 634001 | 2021-10-13 | Mexico | Baja California | 63754 | 9529 | 0 | 30.8406 | -115.2838 | 2021-10-14 04:21:29 | Baja California, Mexico | |||
642014 | 642014 | 2021-09-07 | Mexico | Baja California | 57646 | 9143 | 0 | 30.8406 | -115.2838 | 2021-09-08 04:21:31 | Baja California, Mexico | |||
650042 | 650042 | 2021-08-09 | Mexico | Baja California | 53536 | 8941 | 0 | 30.8406 | -115.2838 | 2021-08-10 04:21:27 | Baja California, Mexico | |||
654073 | 654073 | 2021-10-22 | Mexico | Baja California | 66319 | 9608 | 0 | 30.8406 | -115.2838 | 2021-10-23 04:21:32 | 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 | |||
670378 | 670378 | 2022-07-21 | Mexico | Baja California | 150094 | 12335 | 0 | 30.8406 | -115.2838 | 2022-07-22 04:21:15 | 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 | |||
682418 | 682418 | 2021-10-24 | Mexico | Baja California | 66753 | 9617 | 0 | 30.8406 | -115.2838 | 2021-10-25 04:22:31 | Baja California, Mexico | |||
686434 | 686434 | 2021-11-13 | Mexico | Baja California | 74292 | 9982 | 0 | 30.8406 | -115.2838 | 2021-11-14 04:21:31 | 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 | |||
694467 | 694467 | 2022-03-17 | Mexico | Baja California | 131131 | 12160 | 0 | 30.8406 | -115.2838 | 2022-03-18 04:20:55 | Baja California, Mexico | |||
698482 | 698482 | 2021-11-04 | Mexico | Baja California | 70662 | 9782 | 0 | 30.8406 | -115.2838 | 2021-11-05 04:21:54 | Baja California, Mexico | |||
706512 | 706512 | 2021-09-29 | Mexico | Baja California | 60822 | 9374 | 0 | 30.8406 | -115.2838 | 2021-09-30 04:21:20 | 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 |
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]);