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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- …
province_or_state 1
- Sonora · 954 ✖
country_or_region 1
- Mexico · 954 ✖
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 | |||
8430 | 8430 | 2020-10-25 | Mexico | Sonora | 37461 | 3119 | 33465 | 877 | 29.2972 | -110.3309 | 2020-10-26 04:25:02 | Sonora, Mexico | ||
12439 | 12439 | 2021-01-26 | Mexico | Sonora | 61003 | 5150 | 0 | 55853 | 29.2972 | -110.3309 | 2021-01-27 05:23:41 | Sonora, Mexico | ||
16455 | 16455 | 2021-09-18 | Mexico | Sonora | 105478 | 7910 | 0 | 29.2972 | -110.3309 | 2021-09-19 04:21:34 | Sonora, Mexico | |||
20470 | 20470 | 2021-05-28 | Mexico | Sonora | 75068 | 6612 | 0 | 68456 | 29.2972 | -110.3309 | 2021-05-29 04:20:41 | 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 | |||
36529 | 36529 | 2021-04-12 | Mexico | Sonora | 71492 | 6379 | 0 | 65113 | 29.2972 | -110.3309 | 2021-04-13 04:20:37 | Sonora, Mexico | ||
43809 | 43809 | 2021-11-02 | Mexico | Sonora | 112091 | 8482 | 0 | 29.2972 | -110.3309 | 2021-11-03 06:22:09 | Sonora, Mexico | |||
50891 | 50891 | 2021-05-29 | Mexico | Sonora | 75182 | 6628 | 0 | 68554 | 29.2972 | -110.3309 | 2021-05-30 04:20:55 | Sonora, Mexico | ||
54904 | 54904 | 2021-03-07 | Mexico | Sonora | 68435 | 6103 | 0 | 62332 | 29.2972 | -110.3309 | 2021-03-08 05:24:48 | Sonora, Mexico | ||
62422 | 62422 | 2020-07-23 | Mexico | Sonora | 15611 | 1621 | 12817 | 1173 | 29.2972 | -110.3309 | 2020-07-24 03:34:53 | 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 | |||
75188 | 75188 | 2020-12-03 | Mexico | Sonora | 44476 | 3472 | 0 | 41004 | 29.2972 | -110.3309 | 2020-12-04 05:27:27 | Sonora, Mexico | ||
79186 | 79186 | 2020-10-14 | Mexico | Sonora | 35836 | 3033 | 32025 | 778 | 29.2972 | -110.3309 | 2020-10-15 04:24:28 | Sonora, Mexico | ||
83194 | 83194 | 2021-05-25 | Mexico | Sonora | 74820 | 6597 | 0 | 68223 | 29.2972 | -110.3309 | 2021-05-26 04:20:35 | 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 | |||
98498 | 98498 | 2020-08-04 | Mexico | Sonora | 18238 | 2065 | 15283 | 890 | 29.2972 | -110.3309 | 2020-08-05 04:34:43 | 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 | |||
107551 | 107551 | 2021-06-19 | Mexico | Sonora | 77476 | 6731 | 0 | 70745 | 29.2972 | -110.3309 | 2021-06-20 04:21:48 | Sonora, Mexico | ||
114854 | 114854 | 2022-09-06 | Mexico | Sonora | 193899 | 10278 | 0 | 29.2972 | -110.3309 | 2022-09-07 04:20:59 | Sonora, Mexico | |||
122090 | 122090 | 2020-07-19 | Mexico | Sonora | 14485 | 1468 | 11798 | 1219 | 29.2972 | -110.3309 | 2020-07-20 05:34:40 | Sonora, Mexico | ||
122803 | 122803 | 2020-11-18 | Mexico | Sonora | 40757 | 3274 | 0 | 37483 | 29.2972 | -110.3309 | 2020-11-19 05:25:23 | 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 | |||
146070 | 146070 | 2020-08-15 | Mexico | Sonora | 19930 | 2402 | 16689 | 839 | 29.2972 | -110.3309 | 2020-08-16 04:27:42 | Sonora, Mexico | ||
150085 | 150085 | 2021-11-29 | Mexico | Sonora | 117455 | 8716 | 0 | 29.2972 | -110.3309 | 2021-11-30 04:22:53 | Sonora, Mexico | |||
154082 | 154082 | 2021-01-08 | Mexico | Sonora | 54186 | 4358 | 0 | 49828 | 29.2972 | -110.3309 | 2021-01-09 05:22:18 | 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 | |||
170143 | 170143 | 2021-04-16 | Mexico | Sonora | 72073 | 6433 | 0 | 65640 | 29.2972 | -110.3309 | 2021-04-17 04:20:40 | Sonora, Mexico | ||
177408 | 177408 | 2020-07-27 | Mexico | Sonora | 16617 | 1759 | 13907 | 951 | 29.2972 | -110.3309 | 2020-07-28 04:58:43 | Sonora, Mexico | ||
178126 | 178126 | 2021-09-02 | Mexico | Sonora | 101571 | 7611 | 0 | 29.2972 | -110.3309 | 2021-09-03 04:21:20 | Sonora, Mexico | |||
182139 | 182139 | 2021-02-21 | Mexico | Sonora | 66941 | 5875 | 0 | 61066 | 29.2972 | -110.3309 | 2021-02-22 05:24:21 | Sonora, Mexico | ||
186172 | 186172 | 2022-02-13 | Mexico | Sonora | 155491 | 9770 | 0 | 29.2972 | -110.3309 | 2022-02-14 04:20:51 | Sonora, Mexico | |||
190168 | 190168 | 2021-01-11 | Mexico | Sonora | 55279 | 4432 | 0 | 50847 | 29.2972 | -110.3309 | 2021-01-12 05:22:15 | Sonora, Mexico | ||
194165 | 194165 | 2020-08-31 | Mexico | Sonora | 21433 | 2646 | 18034 | 753 | 29.2972 | -110.3309 | 2020-09-01 04:28:31 | Sonora, Mexico | ||
198361 | 198361 | 2022-10-19 | Mexico | Sonora | 195649 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-20 04:22:59 | Sonora, Mexico | |||
202355 | 202355 | 2020-12-25 | Mexico | Sonora | 50081 | 3981 | 0 | 46100 | 29.2972 | -110.3309 | 2020-12-26 05:22:28 | Sonora, Mexico | ||
206352 | 206352 | 2020-08-19 | Mexico | Sonora | 20288 | 2444 | 17029 | 815 | 29.2972 | -110.3309 | 2020-08-20 04:27:43 | Sonora, Mexico | ||
210339 | 210339 | 2020-10-29 | Mexico | Sonora | 37896 | 3144 | 33793 | 959 | 29.2972 | -110.3309 | 2020-10-30 04:24:49 | Sonora, Mexico | ||
217356 | 217356 | 2020-06-08 | Mexico | Sonora | 3049 | 180 | 2514 | 355 | 29.2972 | -110.3309 | 2020-06-09 03:33:03 | 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 | |||
237340 | 237340 | 2021-01-18 | Mexico | Sonora | 57748 | 4692 | 0 | 53056 | 29.2972 | -110.3309 | 2021-01-19 05:22:15 | Sonora, Mexico | ||
241354 | 241354 | 2021-04-02 | Mexico | Sonora | 70639 | 6295 | 0 | 64344 | 29.2972 | -110.3309 | 2021-04-03 04:20:44 | 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 | |||
268407 | 268407 | 2020-05-21 | Mexico | Sonora | 1124 | 53 | 774 | 297 | 29.2972 | -110.3309 | 2020-05-22 02:36:51 | Sonora, Mexico | ||
272254 | 272254 | 2020-11-10 | Mexico | Sonora | 39635 | 3211 | 35026 | 1398 | 29.2972 | -110.3309 | 2020-11-11 05:25:30 | Sonora, Mexico | ||
276284 | 276284 | 2021-11-03 | Mexico | Sonora | 112259 | 8495 | 0 | 29.2972 | -110.3309 | 2021-11-04 04:22:20 | Sonora, Mexico | |||
280282 | 280282 | 2021-02-24 | Mexico | Sonora | 67245 | 5927 | 0 | 61318 | 29.2972 | -110.3309 | 2021-02-25 05:24:57 | Sonora, Mexico | ||
287371 | 287371 | 2020-06-15 | Mexico | Sonora | 4097 | 282 | 3638 | 177 | 29.2972 | -110.3309 | 2020-06-16 04:33:09 | 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 | |||
296112 | 296112 | 2021-07-15 | Mexico | Sonora | 82882 | 6878 | 0 | 76004 | 29.2972 | -110.3309 | 2021-07-16 04:21:22 | Sonora, Mexico | ||
303243 | 303243 | 2020-07-01 | Mexico | Sonora | 7876 | 737 | 6548 | 591 | 29.2972 | -110.3309 | 2020-07-02 04:33:46 | 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 | |||
327185 | 327185 | 2020-07-20 | Mexico | Sonora | 14608 | 1499 | 12057 | 1052 | 29.2972 | -110.3309 | 2020-07-21 04:38:46 | Sonora, Mexico | ||
328009 | 328009 | 2022-12-27 | Mexico | Sonora | 198438 | 10315 | 0 | 29.2972 | -110.3309 | 2022-12-28 04:21:04 | Sonora, Mexico | |||
332006 | 332006 | 2021-08-04 | Mexico | Sonora | 90022 | 7085 | 0 | 82937 | 29.2972 | -110.3309 | 2021-08-05 04:21:51 | Sonora, Mexico | ||
336038 | 336038 | 2022-03-18 | Mexico | Sonora | 163557 | 10046 | 0 | 29.2972 | -110.3309 | 2022-03-19 04:20:47 | Sonora, Mexico | |||
340374 | 340374 | 2021-02-03 | Mexico | Sonora | 63637 | 5345 | 0 | 58292 | 29.2972 | -110.3309 | 2021-02-04 05:22:26 | Sonora, Mexico | ||
344373 | 344373 | 2020-09-14 | Mexico | Sonora | 23275 | 2806 | 19721 | 748 | 29.2972 | -110.3309 | 2020-09-15 03:22:50 | Sonora, Mexico | ||
348399 | 348399 | 2022-12-14 | Mexico | Sonora | 197500 | 10306 | 0 | 29.2972 | -110.3309 | 2022-12-15 04:20:58 | Sonora, Mexico | |||
352395 | 352395 | 2021-03-11 | Mexico | Sonora | 68868 | 6127 | 0 | 62741 | 29.2972 | -110.3309 | 2021-03-12 05:26:50 | 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 | |||
367591 | 367591 | 2020-07-16 | Mexico | Sonora | 13315 | 1235 | 11423 | 657 | 29.2972 | -110.3309 | 2020-07-17 04:34:50 | Sonora, Mexico | ||
371563 | 371563 | 2020-08-08 | Mexico | Sonora | 18987 | 2277 | 15655 | 1055 | 29.2972 | -110.3309 | 2020-08-09 04:34:54 | Sonora, Mexico | ||
372299 | 372299 | 2022-09-13 | Mexico | Sonora | 194399 | 10284 | 0 | 29.2972 | -110.3309 | 2022-09-14 04:20:44 | Sonora, Mexico | |||
376281 | 376281 | 2020-11-06 | Mexico | Sonora | 38999 | 3211 | 34797 | 991 | 29.2972 | -110.3309 | 2020-11-07 05:24:52 | Sonora, Mexico | ||
380292 | 380292 | 2021-04-30 | Mexico | Sonora | 73360 | 6522 | 0 | 66838 | 29.2972 | -110.3309 | 2021-05-01 04:20:47 | Sonora, Mexico | ||
384326 | 384326 | 2022-09-23 | Mexico | Sonora | 195052 | 10290 | 0 | 29.2972 | -110.3309 | 2022-09-24 04:21:40 | Sonora, Mexico | |||
388322 | 388322 | 2021-04-04 | Mexico | Sonora | 70711 | 6299 | 0 | 64412 | 29.2972 | -110.3309 | 2021-04-05 04:20:35 | Sonora, Mexico | ||
392334 | 392334 | 2020-11-27 | Mexico | Sonora | 42540 | 3437 | 0 | 39103 | 29.2972 | -110.3309 | 2020-11-28 05:25:50 | Sonora, Mexico | ||
396367 | 396367 | 2022-10-07 | Mexico | Sonora | 195535 | 10297 | 0 | 29.2972 | -110.3309 | 2022-10-08 04:22:56 | Sonora, Mexico | |||
400364 | 400364 | 2021-06-29 | Mexico | Sonora | 79456 | 6775 | 0 | 72681 | 29.2972 | -110.3309 | 2021-06-30 04:21:41 | Sonora, Mexico | ||
404395 | 404395 | 2021-12-07 | Mexico | Sonora | 119123 | 8811 | 0 | 29.2972 | -110.3309 | 2021-12-08 04:22:46 | Sonora, Mexico | |||
408394 | 408394 | 2021-07-28 | Mexico | Sonora | 87198 | 6988 | 0 | 80210 | 29.2972 | -110.3309 | 2021-07-29 04:21:33 | Sonora, Mexico | ||
415535 | 415535 | 2020-07-05 | Mexico | Sonora | 9270 | 856 | 7778 | 636 | 29.2972 | -110.3309 | 2020-07-06 04:33:57 | Sonora, Mexico | ||
419438 | 419438 | 2022-09-18 | Mexico | Sonora | 194746 | 10287 | 0 | 29.2972 | -110.3309 | 2022-09-19 04:21:49 | 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]);