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 = "Chihuahua" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070110 | 3070110 | 2021-11-23 | Mexico | Chihuahua | 71547 | 8222 | 0 | 28.63300000000001 | -106.0691 | 2021-11-24 04:22:14 | Chihuahua, Mexico | |||
3749208 | 3749208 | 2021-11-22 | Mexico | Chihuahua | 71547 | 8222 | 0 | 28.63300000000001 | -106.0691 | 2021-11-23 04:22:39 | Chihuahua, Mexico | |||
1014415 | 1014415 | 2021-11-21 | Mexico | Chihuahua | 71490 | 8220 | 0 | 28.63300000000001 | -106.0691 | 2021-11-22 04:22:20 | Chihuahua, Mexico | |||
722579 | 722579 | 2021-11-20 | Mexico | Chihuahua | 71261 | 8206 | 0 | 28.63300000000001 | -106.0691 | 2021-11-21 04:22:13 | Chihuahua, Mexico | |||
162109 | 162109 | 2021-11-19 | Mexico | Chihuahua | 71041 | 8201 | 0 | 28.63300000000001 | -106.0691 | 2021-11-20 04:22:17 | Chihuahua, Mexico | |||
3288996 | 3288996 | 2021-11-18 | Mexico | Chihuahua | 71041 | 8201 | 0 | 28.63300000000001 | -106.0691 | 2021-11-19 04:21:40 | Chihuahua, Mexico | |||
447452 | 447452 | 2021-11-17 | Mexico | Chihuahua | 70802 | 8188 | 0 | 28.63300000000001 | -106.0691 | 2021-11-18 04:21:33 | Chihuahua, Mexico | |||
3342702 | 3342702 | 2021-11-16 | Mexico | Chihuahua | 70545 | 8173 | 0 | 28.63300000000001 | -106.0691 | 2021-11-17 04:21:48 | Chihuahua, Mexico | |||
2287538 | 2287538 | 2021-11-15 | Mexico | Chihuahua | 70487 | 8172 | 0 | 28.63300000000001 | -106.0691 | 2021-11-16 04:21:10 | Chihuahua, Mexico | |||
1322312 | 1322312 | 2021-11-14 | Mexico | Chihuahua | 70472 | 8172 | 0 | 28.63300000000001 | -106.0691 | 2021-11-15 04:21:36 | Chihuahua, Mexico | |||
686438 | 686438 | 2021-11-13 | Mexico | Chihuahua | 70300 | 8160 | 0 | 28.63300000000001 | -106.0691 | 2021-11-14 04:21:31 | Chihuahua, Mexico | |||
714547 | 714547 | 2021-11-12 | Mexico | Chihuahua | 70149 | 8150 | 0 | 28.63300000000001 | -106.0691 | 2021-11-13 04:21:38 | Chihuahua, Mexico | |||
28497 | 28497 | 2021-11-11 | Mexico | Chihuahua | 70149 | 8150 | 0 | 28.63300000000001 | -106.0691 | 2021-11-12 04:22:01 | Chihuahua, Mexico | |||
2844936 | 2844936 | 2021-11-10 | Mexico | Chihuahua | 69757 | 8124 | 0 | 28.63300000000001 | -106.0691 | 2021-11-11 04:21:45 | Chihuahua, Mexico | |||
87206 | 87206 | 2021-11-09 | Mexico | Chihuahua | 69757 | 8124 | 0 | 28.63300000000001 | -106.0691 | 2021-11-10 04:21:38 | Chihuahua, Mexico | |||
3639634 | 3639634 | 2021-11-08 | Mexico | Chihuahua | 69513 | 8111 | 0 | 28.63300000000001 | -106.0691 | 2021-11-09 04:21:36 | Chihuahua, Mexico | |||
2000742 | 2000742 | 2021-11-07 | Mexico | Chihuahua | 69513 | 8111 | 0 | 28.63300000000001 | -106.0691 | 2021-11-08 04:21:43 | Chihuahua, Mexico | |||
495733 | 495733 | 2021-11-06 | Mexico | Chihuahua | 69468 | 8111 | 0 | 28.63300000000001 | -106.0691 | 2021-11-07 04:21:53 | Chihuahua, Mexico | |||
3121588 | 3121588 | 2021-11-05 | Mexico | Chihuahua | 69101 | 8093 | 0 | 28.63300000000001 | -106.0691 | 2021-11-06 04:21:51 | Chihuahua, Mexico | |||
698486 | 698486 | 2021-11-04 | Mexico | Chihuahua | 68891 | 8089 | 0 | 28.63300000000001 | -106.0691 | 2021-11-05 04:21:54 | Chihuahua, Mexico | |||
276264 | 276264 | 2021-11-03 | Mexico | Chihuahua | 68799 | 8086 | 0 | 28.63300000000001 | -106.0691 | 2021-11-04 04:22:20 | Chihuahua, Mexico | |||
43789 | 43789 | 2021-11-02 | Mexico | Chihuahua | 68665 | 8074 | 0 | 28.63300000000001 | -106.0691 | 2021-11-03 06:22:09 | Chihuahua, Mexico | |||
3511485 | 3511485 | 2021-11-01 | Mexico | Chihuahua | 68612 | 8073 | 0 | 28.63300000000001 | -106.0691 | 2021-11-02 04:22:03 | Chihuahua, Mexico | |||
288077 | 288077 | 2021-10-31 | Mexico | Chihuahua | 68612 | 8073 | 0 | 28.63300000000001 | -106.0691 | 2021-11-01 04:22:01 | Chihuahua, Mexico | |||
2721083 | 2721083 | 2021-10-30 | Mexico | Chihuahua | 68576 | 8073 | 0 | 28.63300000000001 | -106.0691 | 2021-10-31 04:22:08 | Chihuahua, Mexico | |||
567185 | 567185 | 2021-10-29 | Mexico | Chihuahua | 68430 | 8061 | 0 | 28.63300000000001 | -106.0691 | 2021-10-30 04:22:03 | Chihuahua, Mexico | |||
4427 | 4427 | 2021-10-28 | Mexico | Chihuahua | 68308 | 8057 | 0 | 28.63300000000001 | -106.0691 | 2021-10-29 04:22:03 | Chihuahua, Mexico | |||
534817 | 534817 | 2021-10-27 | Mexico | Chihuahua | 67888 | 8047 | 0 | 28.63300000000001 | -106.0691 | 2021-10-28 04:22:08 | Chihuahua, Mexico | |||
3492254 | 3492254 | 2021-10-26 | Mexico | Chihuahua | 67704 | 8045 | 0 | 28.63300000000001 | -106.0691 | 2021-10-27 04:22:32 | Chihuahua, Mexico | |||
3793976 | 3793976 | 2021-10-25 | Mexico | Chihuahua | 67704 | 8045 | 0 | 28.63300000000001 | -106.0691 | 2021-10-26 04:22:09 | Chihuahua, Mexico | |||
682422 | 682422 | 2021-10-24 | Mexico | Chihuahua | 67631 | 8043 | 0 | 28.63300000000001 | -106.0691 | 2021-10-25 04:22:31 | Chihuahua, Mexico | |||
770430 | 770430 | 2021-10-23 | Mexico | Chihuahua | 67631 | 8043 | 0 | 28.63300000000001 | -106.0691 | 2021-10-24 04:21:22 | Chihuahua, Mexico | |||
654077 | 654077 | 2021-10-22 | Mexico | Chihuahua | 67483 | 8032 | 0 | 28.63300000000001 | -106.0691 | 2021-10-23 04:21:32 | Chihuahua, Mexico | |||
2123824 | 2123824 | 2021-10-21 | Mexico | Chihuahua | 67346 | 8030 | 0 | 28.63300000000001 | -106.0691 | 2021-10-22 04:21:14 | Chihuahua, Mexico | |||
443436 | 443436 | 2021-10-20 | Mexico | Chihuahua | 67341 | 8027 | 0 | 28.63300000000001 | -106.0691 | 2021-10-21 04:21:18 | Chihuahua, Mexico | |||
597755 | 597755 | 2021-10-19 | Mexico | Chihuahua | 67172 | 8023 | 0 | 28.63300000000001 | -106.0691 | 2021-10-20 04:21:00 | Chihuahua, Mexico | |||
2043932 | 2043932 | 2021-10-18 | Mexico | Chihuahua | 67027 | 8010 | 0 | 28.63300000000001 | -106.0691 | 2021-10-19 04:20:54 | Chihuahua, Mexico | |||
1909293 | 1909293 | 2021-10-17 | Mexico | Chihuahua | 66977 | 8010 | 0 | 28.63300000000001 | -106.0691 | 2021-10-18 04:21:10 | Chihuahua, Mexico | |||
934882 | 934882 | 2021-10-16 | Mexico | Chihuahua | 66958 | 8011 | 0 | 28.63300000000001 | -106.0691 | 2021-10-17 04:21:29 | Chihuahua, Mexico | |||
2943437 | 2943437 | 2021-10-15 | Mexico | Chihuahua | 66866 | 8012 | 0 | 28.63300000000001 | -106.0691 | 2021-10-16 04:21:15 | Chihuahua, Mexico | |||
491717 | 491717 | 2021-10-14 | Mexico | Chihuahua | 66706 | 8000 | 0 | 28.63300000000001 | -106.0691 | 2021-10-15 04:21:26 | Chihuahua, Mexico | |||
634005 | 634005 | 2021-10-13 | Mexico | Chihuahua | 66596 | 7997 | 0 | 28.63300000000001 | -106.0691 | 2021-10-14 04:21:29 | Chihuahua, Mexico | |||
1491683 | 1491683 | 2021-10-12 | Mexico | Chihuahua | 66500 | 7988 | 0 | 28.63300000000001 | -106.0691 | 2021-10-13 04:20:51 | Chihuahua, Mexico | |||
3007416 | 3007416 | 2021-10-11 | Mexico | Chihuahua | 66389 | 7973 | 0 | 28.63300000000001 | -106.0691 | 2021-10-12 04:21:09 | Chihuahua, Mexico | |||
423432 | 423432 | 2021-10-10 | Mexico | Chihuahua | 66367 | 7972 | 0 | 28.63300000000001 | -106.0691 | 2021-10-11 04:21:31 | Chihuahua, Mexico | |||
2876289 | 2876289 | 2021-10-09 | Mexico | Chihuahua | 66238 | 7964 | 0 | 28.63300000000001 | -106.0691 | 2021-10-10 04:21:38 | Chihuahua, Mexico | |||
2959455 | 2959455 | 2021-10-08 | Mexico | Chihuahua | 66238 | 7964 | 0 | 28.63300000000001 | -106.0691 | 2021-10-09 04:21:34 | Chihuahua, Mexico | |||
467493 | 467493 | 2021-10-07 | Mexico | Chihuahua | 66109 | 7956 | 0 | 28.63300000000001 | -106.0691 | 2021-10-08 04:21:25 | Chihuahua, Mexico | |||
2458873 | 2458873 | 2021-10-06 | Mexico | Chihuahua | 65816 | 7937 | 0 | 28.63300000000001 | -106.0691 | 2021-10-07 04:21:36 | Chihuahua, Mexico | |||
3832567 | 3832567 | 2021-10-05 | Mexico | Chihuahua | 65691 | 7920 | 0 | 28.63300000000001 | -106.0691 | 2021-10-06 04:21:33 | Chihuahua, Mexico | |||
987060 | 987060 | 2021-10-04 | Mexico | Chihuahua | 65691 | 7920 | 0 | 28.63300000000001 | -106.0691 | 2021-10-05 04:21:27 | Chihuahua, Mexico | |||
1274370 | 1274370 | 2021-10-03 | Mexico | Chihuahua | 65646 | 7919 | 0 | 28.63300000000001 | -106.0691 | 2021-10-04 04:21:31 | Chihuahua, Mexico | |||
3928123 | 3928123 | 2021-10-02 | Mexico | Chihuahua | 65646 | 7919 | 0 | 28.63300000000001 | -106.0691 | 2021-10-03 04:21:24 | Chihuahua, Mexico | |||
2132103 | 2132103 | 2021-10-01 | Mexico | Chihuahua | 65557 | 7913 | 0 | 28.63300000000001 | -106.0691 | 2021-10-02 04:21:25 | Chihuahua, Mexico | |||
2773060 | 2773060 | 2021-09-30 | Mexico | Chihuahua | 65425 | 7910 | 0 | 28.63300000000001 | -106.0691 | 2021-10-01 04:21:35 | Chihuahua, Mexico | |||
706516 | 706516 | 2021-09-29 | Mexico | Chihuahua | 65315 | 7908 | 0 | 28.63300000000001 | -106.0691 | 2021-09-30 04:21:20 | Chihuahua, Mexico | |||
1334358 | 1334358 | 2021-09-28 | Mexico | Chihuahua | 65184 | 7897 | 0 | 28.63300000000001 | -106.0691 | 2021-09-29 04:21:45 | Chihuahua, Mexico | |||
1235727 | 1235727 | 2021-09-27 | Mexico | Chihuahua | 65014 | 7893 | 0 | 28.63300000000001 | -106.0691 | 2021-09-28 04:21:28 | Chihuahua, Mexico | |||
2076028 | 2076028 | 2021-09-26 | Mexico | Chihuahua | 64982 | 7893 | 0 | 28.63300000000001 | -106.0691 | 2021-09-27 04:21:16 | Chihuahua, Mexico | |||
1724580 | 1724580 | 2021-09-25 | Mexico | Chihuahua | 64836 | 7880 | 0 | 28.63300000000001 | -106.0691 | 2021-09-26 04:21:29 | Chihuahua, Mexico | |||
1921300 | 1921300 | 2021-09-24 | Mexico | Chihuahua | 64836 | 7880 | 0 | 28.63300000000001 | -106.0691 | 2021-09-25 04:21:31 | Chihuahua, Mexico | |||
601771 | 601771 | 2021-09-23 | Mexico | Chihuahua | 64743 | 7879 | 0 | 28.63300000000001 | -106.0691 | 2021-09-24 04:21:44 | Chihuahua, Mexico | |||
3011415 | 3011415 | 2021-09-22 | Mexico | Chihuahua | 64600 | 7870 | 0 | 28.63300000000001 | -106.0691 | 2021-09-23 04:21:43 | Chihuahua, Mexico | |||
3757553 | 3757553 | 2021-09-21 | Mexico | Chihuahua | 64517 | 7868 | 0 | 28.63300000000001 | -106.0691 | 2021-09-22 04:21:45 | Chihuahua, Mexico | |||
809656 | 809656 | 2021-09-20 | Mexico | Chihuahua | 64412 | 7852 | 0 | 28.63300000000001 | -106.0691 | 2021-09-21 04:21:26 | Chihuahua, Mexico | |||
1814855 | 1814855 | 2021-09-19 | Mexico | Chihuahua | 64386 | 7852 | 0 | 28.63300000000001 | -106.0691 | 2021-09-20 04:21:22 | Chihuahua, Mexico | |||
16435 | 16435 | 2021-09-18 | Mexico | Chihuahua | 64283 | 7848 | 0 | 28.63300000000001 | -106.0691 | 2021-09-19 04:21:34 | Chihuahua, Mexico | |||
2618120 | 2618120 | 2021-09-17 | Mexico | Chihuahua | 64283 | 7848 | 0 | 28.63300000000001 | -106.0691 | 2021-09-18 04:21:24 | Chihuahua, Mexico | |||
2808828 | 2808828 | 2021-09-16 | Mexico | Chihuahua | 64215 | 7848 | 0 | 28.63300000000001 | -106.0691 | 2021-09-17 04:21:46 | Chihuahua, Mexico | |||
1374573 | 1374573 | 2021-09-15 | Mexico | Chihuahua | 64166 | 7844 | 0 | 28.63300000000001 | -106.0691 | 2021-09-16 04:22:19 | Chihuahua, Mexico | |||
2462872 | 2462872 | 2021-09-14 | Mexico | Chihuahua | 64088 | 7835 | 0 | 28.63300000000001 | -106.0691 | 2021-09-15 03:22:37 | Chihuahua, Mexico | |||
1385711 | 1385711 | 2021-09-13 | Mexico | Chihuahua | 63995 | 7823 | 0 | 28.63300000000001 | -106.0691 | 2021-09-14 04:21:41 | Chihuahua, Mexico | |||
1885080 | 1885080 | 2021-09-12 | Mexico | Chihuahua | 63899 | 7823 | 0 | 28.63300000000001 | -106.0691 | 2021-09-13 04:21:15 | Chihuahua, Mexico | |||
3805983 | 3805983 | 2021-09-11 | Mexico | Chihuahua | 63849 | 7823 | 0 | 28.63300000000001 | -106.0691 | 2021-09-12 04:21:13 | Chihuahua, Mexico | |||
3448923 | 3448923 | 2021-09-10 | Mexico | Chihuahua | 63685 | 7805 | 0 | 28.63300000000001 | -106.0691 | 2021-09-11 04:21:30 | Chihuahua, Mexico | |||
1262869 | 1262869 | 2021-09-09 | Mexico | Chihuahua | 63685 | 7805 | 0 | 28.63300000000001 | -106.0691 | 2021-09-10 04:21:20 | Chihuahua, Mexico | |||
2279239 | 2279239 | 2021-09-08 | Mexico | Chihuahua | 63580 | 7798 | 0 | 28.63300000000001 | -106.0691 | 2021-09-09 04:21:27 | Chihuahua, Mexico | |||
642018 | 642018 | 2021-09-07 | Mexico | Chihuahua | 63489 | 7793 | 0 | 28.63300000000001 | -106.0691 | 2021-09-08 04:21:31 | Chihuahua, Mexico | |||
3194081 | 3194081 | 2021-09-06 | Mexico | Chihuahua | 63368 | 7786 | 0 | 28.63300000000001 | -106.0691 | 2021-09-07 04:21:35 | Chihuahua, Mexico | |||
3280949 | 3280949 | 2021-09-05 | Mexico | Chihuahua | 63328 | 7785 | 0 | 28.63300000000001 | -106.0691 | 2021-09-06 04:21:22 | Chihuahua, Mexico | |||
249363 | 249363 | 2021-09-04 | Mexico | Chihuahua | 63249 | 7785 | 0 | 28.63300000000001 | -106.0691 | 2021-09-05 04:21:33 | Chihuahua, Mexico | |||
3974644 | 3974644 | 2021-09-03 | Mexico | Chihuahua | 63152 | 7777 | 0 | 28.63300000000001 | -106.0691 | 2021-09-04 04:21:28 | Chihuahua, Mexico | |||
178106 | 178106 | 2021-09-02 | Mexico | Chihuahua | 63060 | 7776 | 0 | 28.63300000000001 | -106.0691 | 2021-09-03 04:21:20 | Chihuahua, Mexico | |||
67141 | 67141 | 2021-09-01 | Mexico | Chihuahua | 62955 | 7774 | 0 | 28.63300000000001 | -106.0691 | 2021-09-02 04:21:15 | Chihuahua, Mexico | |||
2067983 | 2067983 | 2021-08-31 | Mexico | Chihuahua | 62857 | 7769 | 0 | 28.63300000000001 | -106.0691 | 2021-09-01 04:21:38 | Chihuahua, Mexico | |||
1775437 | 1775437 | 2021-08-30 | Mexico | Chihuahua | 62788 | 7766 | 0 | 28.63300000000001 | -106.0691 | 2021-08-31 04:21:46 | Chihuahua, Mexico | |||
3892011 | 3892011 | 2021-08-29 | Mexico | Chihuahua | 62725 | 7766 | 0 | 28.63300000000001 | -106.0691 | 2021-08-30 04:21:23 | Chihuahua, Mexico | |||
2793114 | 2793114 | 2021-08-28 | Mexico | Chihuahua | 62704 | 7766 | 0 | 28.63300000000001 | -106.0691 | 2021-08-29 04:21:14 | Chihuahua, Mexico | |||
2923273 | 2923273 | 2021-08-27 | Mexico | Chihuahua | 62613 | 7766 | 0 | 28.63300000000001 | -106.0691 | 2021-08-28 04:21:28 | Chihuahua, Mexico | |||
1596287 | 1596287 | 2021-08-26 | Mexico | Chihuahua | 62537 | 7759 | 0 | 28.63300000000001 | -106.0691 | 2021-08-27 04:21:37 | Chihuahua, Mexico | |||
32496 | 32496 | 2021-08-25 | Mexico | Chihuahua | 62451 | 7756 | 0 | 28.63300000000001 | -106.0691 | 2021-08-26 04:21:28 | Chihuahua, Mexico | |||
3105535 | 3105535 | 2021-08-24 | Mexico | Chihuahua | 62328 | 7750 | 0 | 28.63300000000001 | -106.0691 | 2021-08-25 04:21:41 | Chihuahua, Mexico | |||
3165706 | 3165706 | 2021-08-23 | Mexico | Chihuahua | 62197 | 7747 | 0 | 28.63300000000001 | -106.0691 | 2021-08-24 04:21:19 | Chihuahua, Mexico | |||
2175633 | 2175633 | 2021-08-22 | Mexico | Chihuahua | 62188 | 7747 | 0 | 28.63300000000001 | -106.0691 | 2021-08-23 04:21:27 | Chihuahua, Mexico | |||
3555729 | 3555729 | 2021-08-21 | Mexico | Chihuahua | 62174 | 7747 | 0 | 28.63300000000001 | -106.0691 | 2021-08-22 04:21:29 | Chihuahua, Mexico | |||
1854071 | 1854071 | 2021-08-20 | Mexico | Chihuahua | 62075 | 7730 | 0 | 28.63300000000001 | -106.0691 | 2021-08-21 04:21:38 | Chihuahua, Mexico | |||
511778 | 511778 | 2021-08-19 | Mexico | Chihuahua | 61980 | 7727 | 0 | 28.63300000000001 | -106.0691 | 2021-08-20 04:21:33 | Chihuahua, Mexico | |||
2518257 | 2518257 | 2021-08-18 | Mexico | Chihuahua | 61883 | 7721 | 0 | 28.63300000000001 | -106.0691 | 2021-08-19 04:21:15 | Chihuahua, Mexico | |||
245349 | 245349 | 2021-08-17 | Mexico | Chihuahua | 61785 | 7717 | 0 | 28.63300000000001 | -106.0691 | 2021-08-18 04:21:35 | Chihuahua, Mexico | |||
1604312 | 1604312 | 2021-08-16 | Mexico | Chihuahua | 61686 | 7709 | 0 | 28.63300000000001 | -106.0691 | 2021-08-17 04:21:49 | Chihuahua, 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]);