johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Coahuila" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
413 | 413 | 2021-12-02 | Mexico | Coahuila | 98018 | 7602 | 0 | 27.0587 | -101.7068 | 2021-12-03 04:23:05 | Coahuila, Mexico | |||
4429 | 4429 | 2021-10-28 | Mexico | Coahuila | 92997 | 7377 | 0 | 27.0587 | -101.7068 | 2021-10-29 04:22:03 | Coahuila, Mexico | |||
12421 | 12421 | 2021-01-26 | Mexico | Coahuila | 58264 | 5049 | 0 | 53215 | 27.0587 | -101.7068 | 2021-01-27 05:23:41 | Coahuila, Mexico | ||
16437 | 16437 | 2021-09-18 | Mexico | Coahuila | 86478 | 7006 | 0 | 27.0587 | -101.7068 | 2021-09-19 04:21:34 | Coahuila, Mexico | |||
20452 | 20452 | 2021-05-28 | Mexico | Coahuila | 68755 | 6256 | 0 | 62499 | 27.0587 | -101.7068 | 2021-05-29 04:20:41 | Coahuila, Mexico | ||
24484 | 24484 | 2022-03-20 | Mexico | Coahuila | 144163 | 8766 | 0 | 27.0587 | -101.7068 | 2022-03-21 04:20:50 | Coahuila, Mexico | |||
28499 | 28499 | 2021-11-11 | Mexico | Coahuila | 94841 | 7458 | 0 | 27.0587 | -101.7068 | 2021-11-12 04:22:01 | Coahuila, Mexico | |||
32498 | 32498 | 2021-08-25 | Mexico | Coahuila | 80080 | 6754 | 0 | 27.0587 | -101.7068 | 2021-08-26 04:21:28 | Coahuila, Mexico | |||
36511 | 36511 | 2021-04-12 | Mexico | Coahuila | 67243 | 6124 | 0 | 61119 | 27.0587 | -101.7068 | 2021-04-13 04:20:37 | Coahuila, Mexico | ||
43791 | 43791 | 2021-11-02 | Mexico | Coahuila | 93345 | 7400 | 0 | 27.0587 | -101.7068 | 2021-11-03 06:22:09 | Coahuila, Mexico | |||
50873 | 50873 | 2021-05-29 | Mexico | Coahuila | 68802 | 6262 | 0 | 62540 | 27.0587 | -101.7068 | 2021-05-30 04:20:55 | Coahuila, Mexico | ||
54886 | 54886 | 2021-03-07 | Mexico | Coahuila | 65385 | 5725 | 0 | 59660 | 27.0587 | -101.7068 | 2021-03-08 05:24:48 | Coahuila, Mexico | ||
63146 | 63146 | 2022-11-12 | Mexico | Coahuila | 180646 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-13 04:21:14 | Coahuila, Mexico | |||
67143 | 67143 | 2021-09-01 | Mexico | Coahuila | 82112 | 6822 | 0 | 27.0587 | -101.7068 | 2021-09-02 04:21:15 | Coahuila, Mexico | |||
71174 | 71174 | 2022-02-07 | Mexico | Coahuila | 139337 | 8450 | 0 | 27.0587 | -101.7068 | 2022-02-08 04:21:15 | Coahuila, Mexico | |||
75170 | 75170 | 2020-12-03 | Mexico | Coahuila | 42693 | 3458 | 0 | 39235 | 27.0587 | -101.7068 | 2020-12-04 05:27:27 | Coahuila, Mexico | ||
83176 | 83176 | 2021-05-25 | Mexico | Coahuila | 68644 | 6252 | 0 | 62392 | 27.0587 | -101.7068 | 2021-05-26 04:20:35 | Coahuila, Mexico | ||
87208 | 87208 | 2021-11-09 | Mexico | Coahuila | 94441 | 7439 | 0 | 27.0587 | -101.7068 | 2021-11-10 04:21:38 | Coahuila, Mexico | |||
91226 | 91226 | 2022-07-23 | Mexico | Coahuila | 167497 | 8857 | 0 | 27.0587 | -101.7068 | 2022-07-24 04:20:47 | Coahuila, Mexico | |||
99409 | 99409 | 2022-01-14 | Mexico | Coahuila | 111858 | 7913 | 0 | 27.0587 | -101.7068 | 2022-01-15 04:21:07 | Coahuila, Mexico | |||
103408 | 103408 | 2021-08-15 | Mexico | Coahuila | 76892 | 6642 | 0 | 27.0587 | -101.7068 | 2021-08-16 04:21:31 | Coahuila, Mexico | |||
107533 | 107533 | 2021-06-19 | Mexico | Coahuila | 69342 | 6374 | 0 | 62968 | 27.0587 | -101.7068 | 2021-06-20 04:21:48 | Coahuila, Mexico | ||
114836 | 114836 | 2022-09-06 | Mexico | Coahuila | 179595 | 8948 | 0 | 27.0587 | -101.7068 | 2022-09-07 04:20:59 | Coahuila, Mexico | |||
122785 | 122785 | 2020-11-18 | Mexico | Coahuila | 37891 | 2925 | 0 | 34966 | 27.0587 | -101.7068 | 2020-11-19 05:25:23 | Coahuila, Mexico | ||
126816 | 126816 | 2022-01-09 | Mexico | Coahuila | 106844 | 7864 | 0 | 27.0587 | -101.7068 | 2022-01-10 04:22:07 | Coahuila, Mexico | |||
130834 | 130834 | 2022-10-04 | Mexico | Coahuila | 180376 | 8956 | 0 | 27.0587 | -101.7068 | 2022-10-05 04:23:06 | Coahuila, Mexico | |||
138054 | 138054 | 2021-12-04 | Mexico | Coahuila | 98417 | 7622 | 0 | 27.0587 | -101.7068 | 2021-12-05 04:22:25 | Coahuila, Mexico | |||
142072 | 142072 | 2022-07-09 | Mexico | Coahuila | 156088 | 8832 | 0 | 27.0587 | -101.7068 | 2022-07-10 04:20:54 | Coahuila, Mexico | |||
150067 | 150067 | 2021-11-29 | Mexico | Coahuila | 97577 | 7573 | 0 | 27.0587 | -101.7068 | 2021-11-30 04:22:53 | Coahuila, Mexico | |||
154064 | 154064 | 2021-01-08 | Mexico | Coahuila | 51755 | 4363 | 0 | 47392 | 27.0587 | -101.7068 | 2021-01-09 05:22:18 | Coahuila, Mexico | ||
158096 | 158096 | 2022-03-29 | Mexico | Coahuila | 144253 | 8767 | 0 | 27.0587 | -101.7068 | 2022-03-30 04:20:45 | Coahuila, Mexico | |||
162111 | 162111 | 2021-11-19 | Mexico | Coahuila | 95802 | 7504 | 0 | 27.0587 | -101.7068 | 2021-11-20 04:22:17 | Coahuila, Mexico | |||
166129 | 166129 | 2022-06-21 | Mexico | Coahuila | 147170 | 8814 | 0 | 27.0587 | -101.7068 | 2022-06-22 04:20:54 | Coahuila, Mexico | |||
170125 | 170125 | 2021-04-16 | Mexico | Coahuila | 67481 | 6148 | 0 | 61333 | 27.0587 | -101.7068 | 2021-04-17 04:20:40 | Coahuila, Mexico | ||
178108 | 178108 | 2021-09-02 | Mexico | Coahuila | 82590 | 6837 | 0 | 27.0587 | -101.7068 | 2021-09-03 04:21:20 | Coahuila, Mexico | |||
182121 | 182121 | 2021-02-21 | Mexico | Coahuila | 64016 | 5598 | 0 | 58418 | 27.0587 | -101.7068 | 2021-02-22 05:24:21 | Coahuila, Mexico | ||
186154 | 186154 | 2022-02-13 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-14 04:20:51 | Coahuila, Mexico | |||
190150 | 190150 | 2021-01-11 | Mexico | Coahuila | 52873 | 4438 | 0 | 48435 | 27.0587 | -101.7068 | 2021-01-12 05:22:15 | Coahuila, Mexico | ||
198343 | 198343 | 2022-10-19 | Mexico | Coahuila | 180479 | 8961 | 0 | 27.0587 | -101.7068 | 2022-10-20 04:22:59 | Coahuila, Mexico | |||
202337 | 202337 | 2020-12-25 | Mexico | Coahuila | 48093 | 4035 | 0 | 44058 | 27.0587 | -101.7068 | 2020-12-26 05:22:28 | Coahuila, Mexico | ||
218064 | 218064 | 2022-12-26 | Mexico | Coahuila | 181933 | 8975 | 0 | 27.0587 | -101.7068 | 2022-12-27 04:21:07 | Coahuila, Mexico | |||
222079 | 222079 | 2022-05-09 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-10 04:20:50 | Coahuila, Mexico | |||
229311 | 229311 | 2022-05-31 | Mexico | Coahuila | 145708 | 8805 | 0 | 27.0587 | -101.7068 | 2022-06-01 04:20:55 | Coahuila, Mexico | |||
233326 | 233326 | 2022-02-11 | Mexico | Coahuila | 140174 | 8522 | 0 | 27.0587 | -101.7068 | 2022-02-12 04:21:06 | Coahuila, Mexico | |||
237322 | 237322 | 2021-01-18 | Mexico | Coahuila | 55256 | 4705 | 0 | 50551 | 27.0587 | -101.7068 | 2021-01-19 05:22:15 | Coahuila, Mexico | ||
241336 | 241336 | 2021-04-02 | Mexico | Coahuila | 66735 | 5877 | 0 | 60858 | 27.0587 | -101.7068 | 2021-04-03 04:20:44 | Coahuila, Mexico | ||
245351 | 245351 | 2021-08-17 | Mexico | Coahuila | 77334 | 6662 | 0 | 27.0587 | -101.7068 | 2021-08-18 04:21:35 | Coahuila, Mexico | |||
249365 | 249365 | 2021-09-04 | Mexico | Coahuila | 83355 | 6873 | 0 | 27.0587 | -101.7068 | 2021-09-05 04:21:33 | Coahuila, Mexico | |||
253398 | 253398 | 2022-09-08 | Mexico | Coahuila | 179595 | 8948 | 0 | 27.0587 | -101.7068 | 2022-09-09 04:21:11 | Coahuila, Mexico | |||
257414 | 257414 | 2022-12-10 | Mexico | Coahuila | 181105 | 8970 | 0 | 27.0587 | -101.7068 | 2022-12-11 04:20:50 | Coahuila, Mexico | |||
261616 | 261616 | 2022-03-15 | Mexico | Coahuila | 143886 | 8731 | 0 | 27.0587 | -101.7068 | 2022-03-16 04:20:50 | Coahuila, Mexico | |||
276266 | 276266 | 2021-11-03 | Mexico | Coahuila | 93531 | 7410 | 0 | 27.0587 | -101.7068 | 2021-11-04 04:22:20 | Coahuila, Mexico | |||
280264 | 280264 | 2021-02-24 | Mexico | Coahuila | 64369 | 5639 | 0 | 58730 | 27.0587 | -101.7068 | 2021-02-25 05:24:57 | Coahuila, Mexico | ||
288079 | 288079 | 2021-10-31 | Mexico | Coahuila | 93338 | 7398 | 0 | 27.0587 | -101.7068 | 2021-11-01 04:22:01 | Coahuila, Mexico | |||
292097 | 292097 | 2022-11-15 | Mexico | Coahuila | 180688 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-16 04:21:09 | Coahuila, Mexico | |||
296094 | 296094 | 2021-07-15 | Mexico | Coahuila | 70498 | 6505 | 0 | 63993 | 27.0587 | -101.7068 | 2021-07-16 04:21:22 | Coahuila, Mexico | ||
303952 | 303952 | 2022-04-16 | Mexico | Coahuila | 145427 | 8782 | 0 | 27.0587 | -101.7068 | 2022-04-17 04:20:59 | Coahuila, Mexico | |||
307969 | 307969 | 2022-12-13 | Mexico | Coahuila | 181252 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-14 04:21:04 | Coahuila, Mexico | |||
311985 | 311985 | 2022-11-13 | Mexico | Coahuila | 180646 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-14 04:21:09 | Coahuila, Mexico | |||
316000 | 316000 | 2022-02-12 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-13 04:21:00 | Coahuila, Mexico | |||
320017 | 320017 | 2022-10-30 | Mexico | Coahuila | 180563 | 8962 | 0 | 27.0587 | -101.7068 | 2022-10-31 04:21:36 | Coahuila, Mexico | |||
327991 | 327991 | 2022-12-27 | Mexico | Coahuila | 182030 | 8975 | 0 | 27.0587 | -101.7068 | 2022-12-28 04:21:04 | Coahuila, Mexico | |||
331988 | 331988 | 2021-08-04 | Mexico | Coahuila | 73804 | 6561 | 0 | 67243 | 27.0587 | -101.7068 | 2021-08-05 04:21:51 | Coahuila, Mexico | ||
336020 | 336020 | 2022-03-18 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-19 04:20:47 | Coahuila, Mexico | |||
340356 | 340356 | 2021-02-03 | Mexico | Coahuila | 60789 | 5286 | 0 | 55503 | 27.0587 | -101.7068 | 2021-02-04 05:22:26 | Coahuila, Mexico | ||
348381 | 348381 | 2022-12-14 | Mexico | Coahuila | 181252 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-15 04:20:58 | Coahuila, Mexico | |||
352377 | 352377 | 2021-03-11 | Mexico | Coahuila | 65613 | 5751 | 0 | 59862 | 27.0587 | -101.7068 | 2021-03-12 05:26:50 | Coahuila, Mexico | ||
356410 | 356410 | 2022-03-11 | Mexico | Coahuila | 143800 | 8727 | 0 | 27.0587 | -101.7068 | 2022-03-12 04:20:50 | Coahuila, Mexico | |||
360426 | 360426 | 2022-05-07 | Mexico | Coahuila | 145491 | 8790 | 0 | 27.0587 | -101.7068 | 2022-05-08 04:20:49 | Coahuila, Mexico | |||
372281 | 372281 | 2022-09-13 | Mexico | Coahuila | 179809 | 8951 | 0 | 27.0587 | -101.7068 | 2022-09-14 04:20:44 | Coahuila, Mexico | |||
380274 | 380274 | 2021-04-30 | Mexico | Coahuila | 68025 | 6196 | 0 | 61829 | 27.0587 | -101.7068 | 2021-05-01 04:20:47 | Coahuila, Mexico | ||
384308 | 384308 | 2022-09-23 | Mexico | Coahuila | 180285 | 8956 | 0 | 27.0587 | -101.7068 | 2022-09-24 04:21:40 | Coahuila, Mexico | |||
388304 | 388304 | 2021-04-04 | Mexico | Coahuila | 66747 | 5877 | 0 | 60870 | 27.0587 | -101.7068 | 2021-04-05 04:20:35 | Coahuila, Mexico | ||
392316 | 392316 | 2020-11-27 | Mexico | Coahuila | 41112 | 3265 | 0 | 37847 | 27.0587 | -101.7068 | 2020-11-28 05:25:50 | Coahuila, Mexico | ||
396349 | 396349 | 2022-10-07 | Mexico | Coahuila | 180427 | 8960 | 0 | 27.0587 | -101.7068 | 2022-10-08 04:22:56 | Coahuila, Mexico | |||
400346 | 400346 | 2021-06-29 | Mexico | Coahuila | 69604 | 6414 | 0 | 63190 | 27.0587 | -101.7068 | 2021-06-30 04:21:41 | Coahuila, Mexico | ||
404377 | 404377 | 2021-12-07 | Mexico | Coahuila | 98632 | 7644 | 0 | 27.0587 | -101.7068 | 2021-12-08 04:22:46 | Coahuila, Mexico | |||
408376 | 408376 | 2021-07-28 | Mexico | Coahuila | 72253 | 6527 | 0 | 65726 | 27.0587 | -101.7068 | 2021-07-29 04:21:33 | Coahuila, Mexico | ||
419420 | 419420 | 2022-09-18 | Mexico | Coahuila | 180009 | 8953 | 0 | 27.0587 | -101.7068 | 2022-09-19 04:21:49 | Coahuila, Mexico | |||
423434 | 423434 | 2021-10-10 | Mexico | Coahuila | 90493 | 7232 | 0 | 27.0587 | -101.7068 | 2021-10-11 04:21:31 | Coahuila, Mexico | |||
431442 | 431442 | 2022-11-03 | Mexico | Coahuila | 180580 | 8963 | 0 | 27.0587 | -101.7068 | 2022-11-04 04:22:11 | Coahuila, Mexico | |||
435437 | 435437 | 2021-01-21 | Mexico | Coahuila | 56620 | 4878 | 0 | 51742 | 27.0587 | -101.7068 | 2021-01-22 05:22:10 | Coahuila, Mexico | ||
443438 | 443438 | 2021-10-20 | Mexico | Coahuila | 91910 | 7328 | 0 | 27.0587 | -101.7068 | 2021-10-21 04:21:18 | Coahuila, Mexico | |||
447454 | 447454 | 2021-11-17 | Mexico | Coahuila | 95529 | 7493 | 0 | 27.0587 | -101.7068 | 2021-11-18 04:21:33 | Coahuila, Mexico | |||
451472 | 451472 | 2022-12-21 | Mexico | Coahuila | 181576 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-22 04:20:56 | Coahuila, Mexico | |||
459463 | 459463 | 2022-02-02 | Mexico | Coahuila | 135941 | 8282 | 0 | 27.0587 | -101.7068 | 2022-02-03 04:21:21 | Coahuila, Mexico | |||
463480 | 463480 | 2022-05-02 | Mexico | Coahuila | 145491 | 8791 | 0 | 27.0587 | -101.7068 | 2022-05-03 04:21:00 | Coahuila, Mexico | |||
467495 | 467495 | 2021-10-07 | Mexico | Coahuila | 90060 | 7215 | 0 | 27.0587 | -101.7068 | 2021-10-08 04:21:25 | Coahuila, Mexico | |||
471493 | 471493 | 2021-02-19 | Mexico | Coahuila | 63764 | 5581 | 0 | 58183 | 27.0587 | -101.7068 | 2021-02-20 05:22:51 | Coahuila, Mexico | ||
475527 | 475527 | 2022-06-26 | Mexico | Coahuila | 148599 | 8818 | 0 | 27.0587 | -101.7068 | 2022-06-27 04:21:00 | Coahuila, Mexico | |||
479675 | 479675 | 2022-11-08 | Mexico | Coahuila | 180598 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-09 04:21:22 | Coahuila, Mexico | |||
483672 | 483672 | 2021-07-19 | Mexico | Coahuila | 70813 | 6507 | 0 | 64306 | 27.0587 | -101.7068 | 2021-07-20 04:21:48 | Coahuila, Mexico | ||
487705 | 487705 | 2022-11-25 | Mexico | Coahuila | 180756 | 8965 | 0 | 27.0587 | -101.7068 | 2022-11-26 04:21:11 | Coahuila, Mexico | |||
491719 | 491719 | 2021-10-14 | Mexico | Coahuila | 91157 | 7272 | 0 | 27.0587 | -101.7068 | 2021-10-15 04:21:26 | Coahuila, Mexico | |||
495735 | 495735 | 2021-11-06 | Mexico | Coahuila | 94151 | 7425 | 0 | 27.0587 | -101.7068 | 2021-11-07 04:21:53 | Coahuila, Mexico | |||
499752 | 499752 | 2022-04-02 | Mexico | Coahuila | 144336 | 8772 | 0 | 27.0587 | -101.7068 | 2022-04-03 04:20:48 | Coahuila, Mexico | |||
503769 | 503769 | 2022-12-17 | Mexico | Coahuila | 181491 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-18 04:21:03 | Coahuila, Mexico | |||
507766 | 507766 | 2021-08-14 | Mexico | Coahuila | 76892 | 6642 | 0 | 27.0587 | -101.7068 | 2021-08-15 04:21:41 | Coahuila, Mexico | |||
511780 | 511780 | 2021-08-19 | Mexico | Coahuila | 78351 | 6687 | 0 | 27.0587 | -101.7068 | 2021-08-20 04:21:33 | Coahuila, Mexico | |||
515813 | 515813 | 2022-10-15 | Mexico | Coahuila | 180478 | 8961 | 0 | 27.0587 | -101.7068 | 2022-10-16 04:22:39 | Coahuila, 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]);