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 = "Coahuila" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
16437 | 16437 | 2021-09-18 | Mexico | Coahuila | 86478 | 7006 | 0 | 27.0587 | -101.7068 | 2021-09-19 04:21:34 | 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 | |||
43791 | 43791 | 2021-11-02 | Mexico | Coahuila | 93345 | 7400 | 0 | 27.0587 | -101.7068 | 2021-11-03 06:22:09 | 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 | |||
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 | |||
114836 | 114836 | 2022-09-06 | Mexico | Coahuila | 179595 | 8948 | 0 | 27.0587 | -101.7068 | 2022-09-07 04:20:59 | 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 | |||
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 | |||
178108 | 178108 | 2021-09-02 | Mexico | Coahuila | 82590 | 6837 | 0 | 27.0587 | -101.7068 | 2021-09-03 04:21:20 | Coahuila, Mexico | |||
186154 | 186154 | 2022-02-13 | Mexico | Coahuila | 140977 | 8578 | 0 | 27.0587 | -101.7068 | 2022-02-14 04:20:51 | Coahuila, Mexico | |||
198343 | 198343 | 2022-10-19 | Mexico | Coahuila | 180479 | 8961 | 0 | 27.0587 | -101.7068 | 2022-10-20 04:22:59 | 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 | |||
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 | |||
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 | |||
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 | |||
336020 | 336020 | 2022-03-18 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-19 04:20:47 | Coahuila, Mexico | |||
348381 | 348381 | 2022-12-14 | Mexico | Coahuila | 181252 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-15 04:20:58 | 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 | |||
384308 | 384308 | 2022-09-23 | Mexico | Coahuila | 180285 | 8956 | 0 | 27.0587 | -101.7068 | 2022-09-24 04:21:40 | Coahuila, Mexico | |||
396349 | 396349 | 2022-10-07 | Mexico | Coahuila | 180427 | 8960 | 0 | 27.0587 | -101.7068 | 2022-10-08 04:22:56 | Coahuila, Mexico | |||
404377 | 404377 | 2021-12-07 | Mexico | Coahuila | 98632 | 7644 | 0 | 27.0587 | -101.7068 | 2021-12-08 04:22:46 | 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 | |||
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 | |||
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 | |||
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 | |||
534819 | 534819 | 2021-10-27 | Mexico | Coahuila | 92640 | 7367 | 0 | 27.0587 | -101.7068 | 2021-10-28 04:22:08 | Coahuila, Mexico | |||
538837 | 538837 | 2022-10-26 | Mexico | Coahuila | 180541 | 8962 | 0 | 27.0587 | -101.7068 | 2022-10-27 04:22:01 | Coahuila, Mexico | |||
542853 | 542853 | 2022-12-15 | Mexico | Coahuila | 181320 | 8973 | 0 | 27.0587 | -101.7068 | 2022-12-16 04:21:01 | Coahuila, Mexico | |||
550857 | 550857 | 2021-12-08 | Mexico | Coahuila | 98824 | 7653 | 0 | 27.0587 | -101.7068 | 2021-12-09 04:22:49 | Coahuila, Mexico | |||
554873 | 554873 | 2022-01-16 | Mexico | Coahuila | 116537 | 7932 | 0 | 27.0587 | -101.7068 | 2022-01-17 04:21:08 | Coahuila, Mexico | |||
558891 | 558891 | 2022-06-16 | Mexico | Coahuila | 146516 | 8811 | 0 | 27.0587 | -101.7068 | 2022-06-17 04:20:56 | Coahuila, Mexico | |||
567187 | 567187 | 2021-10-29 | Mexico | Coahuila | 93167 | 7390 | 0 | 27.0587 | -101.7068 | 2021-10-30 04:22:03 | Coahuila, Mexico | |||
574916 | 574916 | 2022-02-25 | Mexico | Coahuila | 143218 | 8691 | 0 | 27.0587 | -101.7068 | 2022-02-26 04:21:12 | Coahuila, Mexico | |||
589710 | 589710 | 2021-08-08 | Mexico | Coahuila | 74949 | 6586 | 0 | 27.0587 | -101.7068 | 2021-08-09 04:21:24 | Coahuila, Mexico | |||
593743 | 593743 | 2022-07-01 | Mexico | Coahuila | 150965 | 8821 | 0 | 27.0587 | -101.7068 | 2022-07-02 04:21:16 | Coahuila, Mexico | |||
597757 | 597757 | 2021-10-19 | Mexico | Coahuila | 91725 | 7318 | 0 | 27.0587 | -101.7068 | 2021-10-20 04:21:00 | Coahuila, Mexico | |||
601773 | 601773 | 2021-09-23 | Mexico | Coahuila | 87619 | 7078 | 0 | 27.0587 | -101.7068 | 2021-09-24 04:21:44 | Coahuila, Mexico | |||
617947 | 617947 | 2022-11-05 | Mexico | Coahuila | 180587 | 8964 | 0 | 27.0587 | -101.7068 | 2022-11-06 04:21:24 | Coahuila, Mexico | |||
621963 | 621963 | 2022-05-22 | Mexico | Coahuila | 145605 | 8799 | 0 | 27.0587 | -101.7068 | 2022-05-26 04:20:50 | Coahuila, Mexico | |||
629993 | 629993 | 2022-07-12 | Mexico | Coahuila | 157484 | 8836 | 0 | 27.0587 | -101.7068 | 2022-07-13 04:20:58 | Coahuila, Mexico | |||
634007 | 634007 | 2021-10-13 | Mexico | Coahuila | 90992 | 7265 | 0 | 27.0587 | -101.7068 | 2021-10-14 04:21:29 | Coahuila, Mexico | |||
642020 | 642020 | 2021-09-07 | Mexico | Coahuila | 84005 | 6920 | 0 | 27.0587 | -101.7068 | 2021-09-08 04:21:31 | Coahuila, Mexico | |||
650048 | 650048 | 2021-08-09 | Mexico | Coahuila | 75048 | 6588 | 0 | 27.0587 | -101.7068 | 2021-08-10 04:21:27 | Coahuila, Mexico | |||
654079 | 654079 | 2021-10-22 | Mexico | Coahuila | 92217 | 7346 | 0 | 27.0587 | -101.7068 | 2021-10-23 04:21:32 | Coahuila, Mexico | |||
658398 | 658398 | 2022-05-13 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-14 04:20:48 | Coahuila, Mexico | |||
670384 | 670384 | 2022-07-21 | Mexico | Coahuila | 165342 | 8853 | 0 | 27.0587 | -101.7068 | 2022-07-22 04:21:15 | Coahuila, Mexico | |||
674400 | 674400 | 2022-07-30 | Mexico | Coahuila | 170929 | 8869 | 0 | 27.0587 | -101.7068 | 2022-07-31 04:21:02 | Coahuila, Mexico | |||
682424 | 682424 | 2021-10-24 | Mexico | Coahuila | 92363 | 7349 | 0 | 27.0587 | -101.7068 | 2021-10-25 04:22:31 | Coahuila, Mexico | |||
686440 | 686440 | 2021-11-13 | Mexico | Coahuila | 95042 | 7465 | 0 | 27.0587 | -101.7068 | 2021-11-14 04:21:31 | Coahuila, Mexico | |||
690458 | 690458 | 2022-12-23 | Mexico | Coahuila | 181576 | 8974 | 0 | 27.0587 | -101.7068 | 2022-12-24 04:21:02 | Coahuila, Mexico | |||
694473 | 694473 | 2022-03-17 | Mexico | Coahuila | 144097 | 8752 | 0 | 27.0587 | -101.7068 | 2022-03-18 04:20:55 | Coahuila, Mexico | |||
698488 | 698488 | 2021-11-04 | Mexico | Coahuila | 93652 | 7414 | 0 | 27.0587 | -101.7068 | 2021-11-05 04:21:54 | Coahuila, Mexico | |||
706518 | 706518 | 2021-09-29 | Mexico | Coahuila | 88684 | 7135 | 0 | 27.0587 | -101.7068 | 2021-09-30 04:21:20 | Coahuila, Mexico | |||
710535 | 710535 | 2022-11-01 | Mexico | Coahuila | 180563 | 8962 | 0 | 27.0587 | -101.7068 | 2022-11-02 04:22:09 | 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]);