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 = "Sonora" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
431 | 431 | 2021-12-02 | Mexico | Sonora | 118138 | 8746 | 0 | 29.2972 | -110.3309 | 2021-12-03 04:23:05 | Sonora, Mexico | |||
4447 | 4447 | 2021-10-28 | Mexico | Sonora | 111710 | 8438 | 0 | 29.2972 | -110.3309 | 2021-10-29 04:22:03 | Sonora, Mexico | |||
16455 | 16455 | 2021-09-18 | Mexico | Sonora | 105478 | 7910 | 0 | 29.2972 | -110.3309 | 2021-09-19 04:21:34 | Sonora, Mexico | |||
24502 | 24502 | 2022-03-20 | Mexico | Sonora | 163723 | 10053 | 0 | 29.2972 | -110.3309 | 2022-03-21 04:20:50 | Sonora, Mexico | |||
28517 | 28517 | 2021-11-11 | Mexico | Sonora | 113811 | 8571 | 0 | 29.2972 | -110.3309 | 2021-11-12 04:22:01 | Sonora, Mexico | |||
32516 | 32516 | 2021-08-25 | Mexico | Sonora | 98635 | 7420 | 0 | 29.2972 | -110.3309 | 2021-08-26 04:21:28 | Sonora, Mexico | |||
43809 | 43809 | 2021-11-02 | Mexico | Sonora | 112091 | 8482 | 0 | 29.2972 | -110.3309 | 2021-11-03 06:22:09 | Sonora, Mexico | |||
63164 | 63164 | 2022-11-12 | Mexico | Sonora | 195407 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-13 04:21:14 | Sonora, Mexico | |||
67161 | 67161 | 2021-09-01 | Mexico | Sonora | 101129 | 7585 | 0 | 29.2972 | -110.3309 | 2021-09-02 04:21:15 | Sonora, Mexico | |||
71192 | 71192 | 2022-02-07 | Mexico | Sonora | 152123 | 9657 | 0 | 29.2972 | -110.3309 | 2022-02-08 04:21:15 | Sonora, Mexico | |||
87226 | 87226 | 2021-11-09 | Mexico | Sonora | 113388 | 8545 | 0 | 29.2972 | -110.3309 | 2021-11-10 04:21:38 | Sonora, Mexico | |||
91244 | 91244 | 2022-07-23 | Mexico | Sonora | 184258 | 10215 | 0 | 29.2972 | -110.3309 | 2022-07-24 04:20:47 | Sonora, Mexico | |||
99427 | 99427 | 2022-01-14 | Mexico | Sonora | 130916 | 9253 | 0 | 29.2972 | -110.3309 | 2022-01-15 04:21:07 | Sonora, Mexico | |||
103426 | 103426 | 2021-08-15 | Mexico | Sonora | 94074 | 7244 | 0 | 29.2972 | -110.3309 | 2021-08-16 04:21:31 | Sonora, Mexico | |||
114854 | 114854 | 2022-09-06 | Mexico | Sonora | 193899 | 10278 | 0 | 29.2972 | -110.3309 | 2022-09-07 04:20:59 | Sonora, Mexico | |||
126834 | 126834 | 2022-01-09 | Mexico | Sonora | 127259 | 9220 | 0 | 29.2972 | -110.3309 | 2022-01-10 04:22:07 | Sonora, Mexico | |||
130852 | 130852 | 2022-10-04 | Mexico | Sonora | 195318 | 10296 | 0 | 29.2972 | -110.3309 | 2022-10-05 04:23:06 | Sonora, Mexico | |||
138072 | 138072 | 2021-12-04 | Mexico | Sonora | 118679 | 8766 | 0 | 29.2972 | -110.3309 | 2021-12-05 04:22:25 | Sonora, Mexico | |||
142090 | 142090 | 2022-07-09 | Mexico | Sonora | 175447 | 10182 | 0 | 29.2972 | -110.3309 | 2022-07-10 04:20:54 | Sonora, Mexico | |||
150085 | 150085 | 2021-11-29 | Mexico | Sonora | 117455 | 8716 | 0 | 29.2972 | -110.3309 | 2021-11-30 04:22:53 | Sonora, Mexico | |||
158114 | 158114 | 2022-03-29 | Mexico | Sonora | 164519 | 10080 | 0 | 29.2972 | -110.3309 | 2022-03-30 04:20:45 | Sonora, Mexico | |||
162129 | 162129 | 2021-11-19 | Mexico | Sonora | 114981 | 8622 | 0 | 29.2972 | -110.3309 | 2021-11-20 04:22:17 | Sonora, Mexico | |||
166147 | 166147 | 2022-06-21 | Mexico | Sonora | 167792 | 10159 | 0 | 29.2972 | -110.3309 | 2022-06-22 04:20:54 | Sonora, Mexico | |||
178126 | 178126 | 2021-09-02 | Mexico | Sonora | 101571 | 7611 | 0 | 29.2972 | -110.3309 | 2021-09-03 04:21:20 | Sonora, Mexico | |||
186172 | 186172 | 2022-02-13 | Mexico | Sonora | 155491 | 9770 | 0 | 29.2972 | -110.3309 | 2022-02-14 04:20:51 | Sonora, Mexico | |||
198361 | 198361 | 2022-10-19 | Mexico | Sonora | 195649 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-20 04:22:59 | Sonora, Mexico | |||
218082 | 218082 | 2022-12-26 | Mexico | Sonora | 198353 | 10314 | 0 | 29.2972 | -110.3309 | 2022-12-27 04:21:07 | Sonora, Mexico | |||
222097 | 222097 | 2022-05-09 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-10 04:20:50 | Sonora, Mexico | |||
229329 | 229329 | 2022-05-31 | Mexico | Sonora | 165112 | 10131 | 0 | 29.2972 | -110.3309 | 2022-06-01 04:20:55 | Sonora, Mexico | |||
233344 | 233344 | 2022-02-11 | Mexico | Sonora | 153833 | 9727 | 0 | 29.2972 | -110.3309 | 2022-02-12 04:21:06 | Sonora, Mexico | |||
245369 | 245369 | 2021-08-17 | Mexico | Sonora | 95082 | 7276 | 0 | 29.2972 | -110.3309 | 2021-08-18 04:21:35 | Sonora, Mexico | |||
249383 | 249383 | 2021-09-04 | Mexico | Sonora | 102494 | 7656 | 0 | 29.2972 | -110.3309 | 2021-09-05 04:21:33 | Sonora, Mexico | |||
253416 | 253416 | 2022-09-08 | Mexico | Sonora | 193899 | 10278 | 0 | 29.2972 | -110.3309 | 2022-09-09 04:21:11 | Sonora, Mexico | |||
257432 | 257432 | 2022-12-10 | Mexico | Sonora | 197089 | 10303 | 0 | 29.2972 | -110.3309 | 2022-12-11 04:20:50 | Sonora, Mexico | |||
261634 | 261634 | 2022-03-15 | Mexico | Sonora | 163324 | 10040 | 0 | 29.2972 | -110.3309 | 2022-03-16 04:20:50 | Sonora, Mexico | |||
276284 | 276284 | 2021-11-03 | Mexico | Sonora | 112259 | 8495 | 0 | 29.2972 | -110.3309 | 2021-11-04 04:22:20 | Sonora, Mexico | |||
288097 | 288097 | 2021-10-31 | Mexico | Sonora | 112063 | 8474 | 0 | 29.2972 | -110.3309 | 2021-11-01 04:22:01 | Sonora, Mexico | |||
292115 | 292115 | 2022-11-15 | Mexico | Sonora | 195485 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-16 04:21:09 | Sonora, Mexico | |||
303970 | 303970 | 2022-04-16 | Mexico | Sonora | 165444 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-17 04:20:59 | Sonora, Mexico | |||
307987 | 307987 | 2022-12-13 | Mexico | Sonora | 197500 | 10306 | 0 | 29.2972 | -110.3309 | 2022-12-14 04:21:04 | Sonora, Mexico | |||
312003 | 312003 | 2022-11-13 | Mexico | Sonora | 195407 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-14 04:21:09 | Sonora, Mexico | |||
316018 | 316018 | 2022-02-12 | Mexico | Sonora | 155491 | 9770 | 0 | 29.2972 | -110.3309 | 2022-02-13 04:21:00 | Sonora, Mexico | |||
320035 | 320035 | 2022-10-30 | Mexico | Sonora | 195154 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-31 04:21:36 | Sonora, Mexico | |||
328009 | 328009 | 2022-12-27 | Mexico | Sonora | 198438 | 10315 | 0 | 29.2972 | -110.3309 | 2022-12-28 04:21:04 | Sonora, Mexico | |||
336038 | 336038 | 2022-03-18 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-19 04:20:47 | Sonora, Mexico | |||
348399 | 348399 | 2022-12-14 | Mexico | Sonora | 197500 | 10306 | 0 | 29.2972 | -110.3309 | 2022-12-15 04:20:58 | Sonora, Mexico | |||
356428 | 356428 | 2022-03-11 | Mexico | Sonora | 162934 | 10008 | 0 | 29.2972 | -110.3309 | 2022-03-12 04:20:50 | Sonora, Mexico | |||
360444 | 360444 | 2022-05-07 | Mexico | Sonora | 165598 | 10118 | 0 | 29.2972 | -110.3309 | 2022-05-08 04:20:49 | Sonora, Mexico | |||
372299 | 372299 | 2022-09-13 | Mexico | Sonora | 194399 | 10284 | 0 | 29.2972 | -110.3309 | 2022-09-14 04:20:44 | Sonora, Mexico | |||
384326 | 384326 | 2022-09-23 | Mexico | Sonora | 195052 | 10290 | 0 | 29.2972 | -110.3309 | 2022-09-24 04:21:40 | Sonora, Mexico | |||
396367 | 396367 | 2022-10-07 | Mexico | Sonora | 195535 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-08 04:22:56 | Sonora, Mexico | |||
404395 | 404395 | 2021-12-07 | Mexico | Sonora | 119123 | 8811 | 0 | 29.2972 | -110.3309 | 2021-12-08 04:22:46 | Sonora, Mexico | |||
419438 | 419438 | 2022-09-18 | Mexico | Sonora | 194746 | 10287 | 0 | 29.2972 | -110.3309 | 2022-09-19 04:21:49 | Sonora, Mexico | |||
423452 | 423452 | 2021-10-10 | Mexico | Sonora | 109452 | 8300 | 0 | 29.2972 | -110.3309 | 2021-10-11 04:21:31 | Sonora, Mexico | |||
431460 | 431460 | 2022-11-03 | Mexico | Sonora | 195216 | 10297 | 0 | 29.2972 | -110.3309 | 2022-11-04 04:22:11 | Sonora, Mexico | |||
443456 | 443456 | 2021-10-20 | Mexico | Sonora | 110567 | 8359 | 0 | 29.2972 | -110.3309 | 2021-10-21 04:21:18 | Sonora, Mexico | |||
447472 | 447472 | 2021-11-17 | Mexico | Sonora | 114711 | 8606 | 0 | 29.2972 | -110.3309 | 2021-11-18 04:21:33 | Sonora, Mexico | |||
451490 | 451490 | 2022-12-21 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-22 04:20:56 | Sonora, Mexico | |||
459481 | 459481 | 2022-02-02 | Mexico | Sonora | 147655 | 9536 | 0 | 29.2972 | -110.3309 | 2022-02-03 04:21:21 | Sonora, Mexico | |||
463498 | 463498 | 2022-05-02 | Mexico | Sonora | 165608 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-03 04:21:00 | Sonora, Mexico | |||
467513 | 467513 | 2021-10-07 | Mexico | Sonora | 109120 | 8278 | 0 | 29.2972 | -110.3309 | 2021-10-08 04:21:25 | Sonora, Mexico | |||
475545 | 475545 | 2022-06-26 | Mexico | Sonora | 169383 | 10165 | 0 | 29.2972 | -110.3309 | 2022-06-27 04:21:00 | Sonora, Mexico | |||
479693 | 479693 | 2022-11-08 | Mexico | Sonora | 195303 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-09 04:21:22 | Sonora, Mexico | |||
487723 | 487723 | 2022-11-25 | Mexico | Sonora | 195683 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-26 04:21:11 | Sonora, Mexico | |||
491737 | 491737 | 2021-10-14 | Mexico | Sonora | 109919 | 8319 | 0 | 29.2972 | -110.3309 | 2021-10-15 04:21:26 | Sonora, Mexico | |||
495753 | 495753 | 2021-11-06 | Mexico | Sonora | 113040 | 8529 | 0 | 29.2972 | -110.3309 | 2021-11-07 04:21:53 | Sonora, Mexico | |||
499770 | 499770 | 2022-04-02 | Mexico | Sonora | 164905 | 10083 | 0 | 29.2972 | -110.3309 | 2022-04-03 04:20:48 | Sonora, Mexico | |||
503787 | 503787 | 2022-12-17 | Mexico | Sonora | 197826 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-18 04:21:03 | Sonora, Mexico | |||
507784 | 507784 | 2021-08-14 | Mexico | Sonora | 94074 | 7244 | 0 | 29.2972 | -110.3309 | 2021-08-15 04:21:41 | Sonora, Mexico | |||
511798 | 511798 | 2021-08-19 | Mexico | Sonora | 96372 | 7315 | 0 | 29.2972 | -110.3309 | 2021-08-20 04:21:33 | Sonora, Mexico | |||
515831 | 515831 | 2022-10-15 | Mexico | Sonora | 195646 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-16 04:22:39 | Sonora, Mexico | |||
534837 | 534837 | 2021-10-27 | Mexico | Sonora | 111346 | 8404 | 0 | 29.2972 | -110.3309 | 2021-10-28 04:22:08 | Sonora, Mexico | |||
538855 | 538855 | 2022-10-26 | Mexico | Sonora | 195106 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-27 04:22:01 | Sonora, Mexico | |||
542871 | 542871 | 2022-12-15 | Mexico | Sonora | 197602 | 10307 | 0 | 29.2972 | -110.3309 | 2022-12-16 04:21:01 | Sonora, Mexico | |||
550875 | 550875 | 2021-12-08 | Mexico | Sonora | 119351 | 8817 | 0 | 29.2972 | -110.3309 | 2021-12-09 04:22:49 | Sonora, Mexico | |||
554891 | 554891 | 2022-01-16 | Mexico | Sonora | 133879 | 9294 | 0 | 29.2972 | -110.3309 | 2022-01-17 04:21:08 | Sonora, Mexico | |||
558909 | 558909 | 2022-06-16 | Mexico | Sonora | 166972 | 10156 | 0 | 29.2972 | -110.3309 | 2022-06-17 04:20:56 | Sonora, Mexico | |||
567205 | 567205 | 2021-10-29 | Mexico | Sonora | 111851 | 8449 | 0 | 29.2972 | -110.3309 | 2021-10-30 04:22:03 | Sonora, Mexico | |||
574934 | 574934 | 2022-02-25 | Mexico | Sonora | 160610 | 9916 | 0 | 29.2972 | -110.3309 | 2022-02-26 04:21:12 | Sonora, Mexico | |||
589728 | 589728 | 2021-08-08 | Mexico | Sonora | 91700 | 7128 | 0 | 29.2972 | -110.3309 | 2021-08-09 04:21:24 | Sonora, Mexico | |||
593761 | 593761 | 2022-07-01 | Mexico | Sonora | 171405 | 10166 | 0 | 29.2972 | -110.3309 | 2022-07-02 04:21:16 | Sonora, Mexico | |||
597775 | 597775 | 2021-10-19 | Mexico | Sonora | 110413 | 8354 | 0 | 29.2972 | -110.3309 | 2021-10-20 04:21:00 | Sonora, Mexico | |||
601791 | 601791 | 2021-09-23 | Mexico | Sonora | 106810 | 8011 | 0 | 29.2972 | -110.3309 | 2021-09-24 04:21:44 | Sonora, Mexico | |||
617965 | 617965 | 2022-11-05 | Mexico | Sonora | 195264 | 10298 | 0 | 29.2972 | -110.3309 | 2022-11-06 04:21:24 | Sonora, Mexico | |||
621981 | 621981 | 2022-05-22 | Mexico | Sonora | 165220 | 10129 | 0 | 29.2972 | -110.3309 | 2022-05-26 04:20:50 | Sonora, Mexico | |||
630011 | 630011 | 2022-07-12 | Mexico | Sonora | 176647 | 10187 | 0 | 29.2972 | -110.3309 | 2022-07-13 04:20:58 | Sonora, Mexico | |||
634025 | 634025 | 2021-10-13 | Mexico | Sonora | 109781 | 8316 | 0 | 29.2972 | -110.3309 | 2021-10-14 04:21:29 | Sonora, Mexico | |||
642038 | 642038 | 2021-09-07 | Mexico | Sonora | 103059 | 7715 | 0 | 29.2972 | -110.3309 | 2021-09-08 04:21:31 | Sonora, Mexico | |||
650066 | 650066 | 2021-08-09 | Mexico | Sonora | 91887 | 7135 | 0 | 29.2972 | -110.3309 | 2021-08-10 04:21:27 | Sonora, Mexico | |||
654097 | 654097 | 2021-10-22 | Mexico | Sonora | 110907 | 8375 | 0 | 29.2972 | -110.3309 | 2021-10-23 04:21:32 | Sonora, Mexico | |||
658416 | 658416 | 2022-05-13 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-14 04:20:48 | Sonora, Mexico | |||
670402 | 670402 | 2022-07-21 | Mexico | Sonora | 182385 | 10208 | 0 | 29.2972 | -110.3309 | 2022-07-22 04:21:15 | Sonora, Mexico | |||
674418 | 674418 | 2022-07-30 | Mexico | Sonora | 186157 | 10229 | 0 | 29.2972 | -110.3309 | 2022-07-31 04:21:02 | Sonora, Mexico | |||
682442 | 682442 | 2021-10-24 | Mexico | Sonora | 111069 | 8389 | 0 | 29.2972 | -110.3309 | 2021-10-25 04:22:31 | Sonora, Mexico | |||
686458 | 686458 | 2021-11-13 | Mexico | Sonora | 114071 | 8581 | 0 | 29.2972 | -110.3309 | 2021-11-14 04:21:31 | Sonora, Mexico | |||
690476 | 690476 | 2022-12-23 | Mexico | Sonora | 197963 | 10310 | 0 | 29.2972 | -110.3309 | 2022-12-24 04:21:02 | Sonora, Mexico | |||
694491 | 694491 | 2022-03-17 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-18 04:20:55 | Sonora, Mexico | |||
698506 | 698506 | 2021-11-04 | Mexico | Sonora | 112358 | 8499 | 0 | 29.2972 | -110.3309 | 2021-11-05 04:21:54 | Sonora, Mexico | |||
706536 | 706536 | 2021-09-29 | Mexico | Sonora | 107849 | 8176 | 0 | 29.2972 | -110.3309 | 2021-09-30 04:21:20 | Sonora, Mexico | |||
710553 | 710553 | 2022-11-01 | Mexico | Sonora | 195154 | 10297 | 0 | 29.2972 | -110.3309 | 2022-11-02 04:22:09 | Sonora, 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]);