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 = "Baja California" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701585 | 2701585 | 2020-11-20 | Mexico | Baja California | 24840 | 4147 | 0 | 20693 | 30.8406 | -115.2838 | 2020-11-21 05:25:51 | Baja California, Mexico | ||
821645 | 821645 | 2020-11-19 | Mexico | Baja California | 24703 | 4119 | 0 | 20584 | 30.8406 | -115.2838 | 2020-11-20 05:26:28 | Baja California, Mexico | ||
122779 | 122779 | 2020-11-18 | Mexico | Baja California | 24645 | 4108 | 0 | 20537 | 30.8406 | -115.2838 | 2020-11-19 05:25:23 | Baja California, Mexico | ||
3338667 | 3338667 | 2020-11-17 | Mexico | Baja California | 24548 | 4094 | 0 | 20454 | 30.8406 | -115.2838 | 2020-11-18 05:40:31 | Baja California, Mexico | ||
3169712 | 3169712 | 2020-11-16 | Mexico | Baja California | 24534 | 4091 | 0 | 20443 | 30.8406 | -115.2838 | 2020-11-17 05:25:54 | Baja California, Mexico | ||
2880280 | 2880280 | 2020-11-15 | Mexico | Baja California | 24490 | 4085 | 0 | 20405 | 30.8406 | -115.2838 | 2020-11-16 05:25:57 | Baja California, Mexico | ||
2915258 | 2915258 | 2020-11-14 | Mexico | Baja California | 24465 | 4081 | 0 | 20384 | 30.8406 | -115.2838 | 2020-11-15 05:26:53 | Baja California, Mexico | ||
2785080 | 2785080 | 2020-11-13 | Mexico | Baja California | 24387 | 4054 | 0 | 20333 | 30.8406 | -115.2838 | 2020-11-14 05:25:37 | Baja California, Mexico | ||
864845 | 864845 | 2020-11-12 | Mexico | Baja California | 24259 | 4042 | 0 | 20217 | 30.8406 | -115.2838 | 2020-11-13 05:25:30 | Baja California, Mexico | ||
3440890 | 3440890 | 2020-11-11 | Mexico | Baja California | 24196 | 4026 | 18915 | 1255 | 30.8406 | -115.2838 | 2020-11-12 05:25:55 | Baja California, Mexico | ||
272230 | 272230 | 2020-11-10 | Mexico | Baja California | 24022 | 4010 | 18915 | 1097 | 30.8406 | -115.2838 | 2020-11-11 05:25:30 | Baja California, Mexico | ||
1988707 | 1988707 | 2020-11-09 | Mexico | Baja California | 24036 | 3995 | 18915 | 1126 | 30.8406 | -115.2838 | 2020-11-10 05:40:07 | Baja California, Mexico | ||
1728559 | 1728559 | 2020-11-08 | Mexico | Baja California | 23941 | 3938 | 18915 | 1088 | 30.8406 | -115.2838 | 2020-11-09 05:25:45 | Baja California, Mexico | ||
1544019 | 1544019 | 2020-11-07 | Mexico | Baja California | 23856 | 3936 | 18766 | 1154 | 30.8406 | -115.2838 | 2020-11-08 05:24:56 | Baja California, Mexico | ||
376257 | 376257 | 2020-11-06 | Mexico | Baja California | 23691 | 3922 | 18656 | 1113 | 30.8406 | -115.2838 | 2020-11-07 05:24:52 | Baja California, Mexico | ||
892195 | 892195 | 2020-11-05 | Mexico | Baja California | 23571 | 3906 | 18613 | 1052 | 30.8406 | -115.2838 | 2020-11-06 05:24:55 | Baja California, Mexico | ||
2919257 | 2919257 | 2020-11-04 | Mexico | Baja California | 23480 | 3893 | 18526 | 1061 | 30.8406 | -115.2838 | 2020-11-05 06:05:03 | Baja California, Mexico | ||
2498094 | 2498094 | 2020-11-03 | Mexico | Baja California | 23385 | 3873 | 18562 | 950 | 30.8406 | -115.2838 | 2020-11-04 05:25:09 | Baja California, Mexico | ||
3304269 | 3304269 | 2020-11-02 | Mexico | Baja California | 23250 | 3848 | 18449 | 953 | 30.8406 | -115.2838 | 2020-11-03 06:00:16 | Baja California, Mexico | ||
3409518 | 3409518 | 2020-11-01 | Mexico | Baja California | 23202 | 3841 | 18272 | 1089 | 30.8406 | -115.2838 | 2020-11-02 05:25:04 | Baja California, Mexico | ||
2080007 | 2080007 | 2020-10-31 | Mexico | Baja California | 23114 | 3838 | 18057 | 1219 | 30.8406 | -115.2838 | 2020-11-01 04:36:19 | Baja California, Mexico | ||
2243460 | 2243460 | 2020-10-30 | Mexico | Baja California | 23018 | 3829 | 18005 | 1184 | 30.8406 | -115.2838 | 2020-10-31 04:24:44 | Baja California, Mexico | ||
210315 | 210315 | 2020-10-29 | Mexico | Baja California | 22879 | 3816 | 17886 | 1177 | 30.8406 | -115.2838 | 2020-10-30 04:24:49 | Baja California, Mexico | ||
754377 | 754377 | 2020-10-28 | Mexico | Baja California | 22744 | 3807 | 17779 | 1158 | 30.8406 | -115.2838 | 2020-10-29 04:24:49 | Baja California, Mexico | ||
1452661 | 1452661 | 2020-10-27 | Mexico | Baja California | 22631 | 3795 | 17889 | 947 | 30.8406 | -115.2838 | 2020-10-28 04:24:39 | Baja California, Mexico | ||
3480385 | 3480385 | 2020-10-26 | Mexico | Baja California | 22560 | 3779 | 17861 | 920 | 30.8406 | -115.2838 | 2020-10-27 04:24:45 | Baja California, Mexico | ||
8406 | 8406 | 2020-10-25 | Mexico | Baja California | 22477 | 3772 | 17666 | 1039 | 30.8406 | -115.2838 | 2020-10-26 04:25:02 | Baja California, Mexico | ||
3651643 | 3651643 | 2020-10-24 | Mexico | Baja California | 22395 | 3771 | 17565 | 1059 | 30.8406 | -115.2838 | 2020-10-25 04:24:36 | Baja California, Mexico | ||
1053898 | 1053898 | 2020-10-23 | Mexico | Baja California | 22251 | 3753 | 17487 | 1011 | 30.8406 | -115.2838 | 2020-10-24 04:24:46 | Baja California, Mexico | ||
1177568 | 1177568 | 2020-10-22 | Mexico | Baja California | 22125 | 3733 | 17479 | 913 | 30.8406 | -115.2838 | 2020-10-23 04:24:46 | Baja California, Mexico | ||
2191673 | 2191673 | 2020-10-21 | Mexico | Baja California | 22040 | 3733 | 17415 | 892 | 30.8406 | -115.2838 | 2020-10-22 04:24:27 | Baja California, Mexico | ||
3990684 | 3990684 | 2020-10-20 | Mexico | Baja California | 21919 | 3730 | 17331 | 858 | 30.8406 | -115.2838 | 2020-10-21 04:24:14 | Baja California, Mexico | ||
1794704 | 1794704 | 2020-10-19 | Mexico | Baja California | 21853 | 3717 | 17344 | 792 | 30.8406 | -115.2838 | 2020-10-20 04:24:22 | Baja California, Mexico | ||
762388 | 762388 | 2020-10-18 | Mexico | Baja California | 21767 | 3710 | 17193 | 864 | 30.8406 | -115.2838 | 2020-10-19 04:24:16 | Baja California, Mexico | ||
1026426 | 1026426 | 2020-10-17 | Mexico | Baja California | 21656 | 3705 | 17030 | 921 | 30.8406 | -115.2838 | 2020-10-18 04:24:25 | Baja California, Mexico | ||
2856921 | 2856921 | 2020-10-16 | Mexico | Baja California | 21544 | 3692 | 17025 | 827 | 30.8406 | -115.2838 | 2020-10-17 04:24:12 | Baja California, Mexico | ||
786451 | 786451 | 2020-10-15 | Mexico | Baja California | 21444 | 3677 | 16942 | 825 | 30.8406 | -115.2838 | 2020-10-16 04:24:01 | Baja California, Mexico | ||
79162 | 79162 | 2020-10-14 | Mexico | Baja California | 21337 | 3667 | 16896 | 774 | 30.8406 | -115.2838 | 2020-10-15 04:24:28 | Baja California, Mexico | ||
3781977 | 3781977 | 2020-10-13 | Mexico | Baja California | 22443 | 3660 | 17989 | 794 | 30.8406 | -115.2838 | 2020-10-14 04:24:05 | Baja California, Mexico | ||
2291517 | 2291517 | 2020-10-12 | Mexico | Baja California | 22341 | 3646 | 17914 | 781 | 30.8406 | -115.2838 | 2020-10-13 04:24:02 | Baja California, Mexico | ||
3785970 | 3785970 | 2020-10-11 | Mexico | Baja California | 22304 | 3643 | 17720 | 941 | 30.8406 | -115.2838 | 2020-10-12 04:23:45 | Baja California, Mexico | ||
2602108 | 2602108 | 2020-10-10 | Mexico | Baja California | 22241 | 3640 | 17588 | 1013 | 30.8406 | -115.2838 | 2020-10-11 04:23:46 | Baja California, Mexico | ||
817641 | 817641 | 2020-10-09 | Mexico | Baja California | 22137 | 3631 | 17530 | 976 | 30.8406 | -115.2838 | 2020-10-10 04:23:57 | Baja California, Mexico | ||
2689756 | 2689756 | 2020-10-08 | Mexico | Baja California | 22016 | 3617 | 17548 | 851 | 30.8406 | -115.2838 | 2020-10-09 04:23:59 | Baja California, Mexico | ||
1041898 | 1041898 | 2020-10-07 | Mexico | Baja California | 21897 | 3599 | 17494 | 804 | 30.8406 | -115.2838 | 2020-10-08 04:23:56 | Baja California, Mexico | ||
3117559 | 3117559 | 2020-10-06 | Mexico | Baja California | 21793 | 3585 | 17462 | 746 | 30.8406 | -115.2838 | 2020-10-07 04:23:40 | Baja California, Mexico | ||
3801971 | 3801971 | 2020-10-05 | Mexico | Baja California | 21687 | 3577 | 17295 | 815 | 30.8406 | -115.2838 | 2020-10-06 04:23:33 | Baja California, Mexico | ||
1822861 | 1822861 | 2020-10-04 | Mexico | Baja California | 19787 | 3569 | 15471 | 747 | 30.8406 | -115.2838 | 2020-10-05 04:23:33 | Baja California, Mexico | ||
2514245 | 2514245 | 2020-10-03 | Mexico | Baja California | 19699 | 3563 | 15294 | 842 | 30.8406 | -115.2838 | 2020-10-04 04:23:44 | Baja California, Mexico | ||
3389463 | 3389463 | 2020-10-02 | Mexico | Baja California | 19584 | 3552 | 15086 | 946 | 30.8406 | -115.2838 | 2020-10-03 04:23:40 | Baja California, Mexico | ||
2379704 | 2379704 | 2020-10-01 | Mexico | Baja California | 19510 | 3539 | 15193 | 778 | 30.8406 | -115.2838 | 2020-10-02 04:23:51 | Baja California, Mexico | ||
1045890 | 1045890 | 2020-09-30 | Mexico | Baja California | 19421 | 3526 | 15295 | 600 | 30.8406 | -115.2838 | 2020-10-01 04:23:42 | Baja California, Mexico | ||
966971 | 966971 | 2020-09-29 | Mexico | Baja California | 19277 | 3510 | 15245 | 522 | 30.8406 | -115.2838 | 2020-09-30 04:23:33 | Baja California, Mexico | ||
1515468 | 1515468 | 2020-09-28 | Mexico | Baja California | 19207 | 3482 | 15217 | 508 | 30.8406 | -115.2838 | 2020-09-29 04:23:42 | Baja California, Mexico | ||
2582056 | 2582056 | 2020-09-27 | Mexico | Baja California | 19133 | 3479 | 15078 | 576 | 30.8406 | -115.2838 | 2020-09-28 04:23:00 | Baja California, Mexico | ||
2614108 | 2614108 | 2020-09-26 | Mexico | Baja California | 19093 | 3478 | 14964 | 651 | 30.8406 | -115.2838 | 2020-09-27 04:23:00 | Baja California, Mexico | ||
2812823 | 2812823 | 2020-09-25 | Mexico | Baja California | 18921 | 3463 | 14811 | 647 | 30.8406 | -115.2838 | 2020-09-26 04:23:00 | Baja California, Mexico | ||
2606100 | 2606100 | 2020-09-24 | Mexico | Baja California | 18822 | 3450 | 14733 | 639 | 30.8406 | -115.2838 | 2020-09-25 04:23:00 | Baja California, Mexico | ||
2653843 | 2653843 | 2020-09-23 | Mexico | Baja California | 18713 | 3434 | 14740 | 539 | 30.8406 | -115.2838 | 2020-09-24 04:23:00 | Baja California, Mexico | ||
3316292 | 3316292 | 2020-09-22 | Mexico | Baja California | 18619 | 3411 | 14743 | 465 | 30.8406 | -115.2838 | 2020-09-23 04:23:00 | Baja California, Mexico | ||
2836891 | 2836891 | 2020-09-21 | Mexico | Baja California | 18548 | 3383 | 14745 | 420 | 30.8406 | -115.2838 | 2020-09-22 04:23:00 | Baja California, Mexico | ||
3093495 | 3093495 | 2020-09-20 | Mexico | Baja California | 18529 | 3374 | 14683 | 472 | 30.8406 | -115.2838 | 2020-09-21 04:23:00 | Baja California, Mexico | ||
2454845 | 2454845 | 2020-09-19 | Mexico | Baja California | 18501 | 3367 | 14561 | 573 | 30.8406 | -115.2838 | 2020-09-20 04:22:00 | Baja California, Mexico | ||
2848914 | 2848914 | 2020-09-18 | Mexico | Baja California | 18465 | 3355 | 14604 | 506 | 30.8406 | -115.2838 | 2020-09-19 04:22:00 | Baja California, Mexico | ||
1121663 | 1121663 | 2020-09-17 | Mexico | Baja California | 18427 | 3334 | 14595 | 498 | 30.8406 | -115.2838 | 2020-09-18 05:05:00 | Baja California, Mexico | ||
666352 | 666352 | 2020-09-16 | Mexico | Baja California | 18386 | 3327 | 14497 | 562 | 30.8406 | -115.2838 | 2020-09-17 04:22:00 | Baja California, Mexico | ||
2729077 | 2729077 | 2020-09-15 | Mexico | Baja California | 18360 | 3322 | 14420 | 618 | 30.8406 | -115.2838 | 2020-09-16 04:22:53 | Baja California, Mexico | ||
344349 | 344349 | 2020-09-14 | Mexico | Baja California | 18346 | 3307 | 14363 | 676 | 30.8406 | -115.2838 | 2020-09-15 03:22:50 | Baja California, Mexico | ||
2868788 | 2868788 | 2020-09-13 | Mexico | Baja California | 18328 | 3302 | 14217 | 809 | 30.8406 | -115.2838 | 2020-09-14 04:26:00 | Baja California, Mexico | ||
546827 | 546827 | 2020-09-12 | Mexico | Baja California | 18299 | 3299 | 14059 | 941 | 30.8406 | -115.2838 | 2020-09-13 04:30:52 | Baja California, Mexico | ||
1444656 | 1444656 | 2020-09-11 | Mexico | Baja California | 18157 | 3284 | 13995 | 878 | 30.8406 | -115.2838 | 2020-09-12 04:25:05 | Baja California, Mexico | ||
1173257 | 1173257 | 2020-09-10 | Mexico | Baja California | 17990 | 3267 | 13826 | 897 | 30.8406 | -115.2838 | 2020-09-11 04:46:23 | Baja California, Mexico | ||
2171622 | 2171622 | 2020-09-09 | Mexico | Baja California | 17870 | 3260 | 13765 | 845 | 30.8406 | -115.2838 | 2020-09-10 04:29:01 | Baja California, Mexico | ||
1243831 | 1243831 | 2020-09-08 | Mexico | Baja California | 17687 | 3249 | 13674 | 764 | 30.8406 | -115.2838 | 2020-09-09 04:28:48 | Baja California, Mexico | ||
427410 | 427410 | 2020-09-07 | Mexico | Baja California | 17667 | 3238 | 13682 | 747 | 30.8406 | -115.2838 | 2020-09-08 04:28:25 | Baja California, Mexico | ||
3161695 | 3161695 | 2020-09-06 | Mexico | Baja California | 17647 | 3233 | 13569 | 845 | 30.8406 | -115.2838 | 2020-09-07 04:28:30 | Baja California, Mexico | ||
813650 | 813650 | 2020-09-05 | Mexico | Baja California | 17460 | 3223 | 13405 | 832 | 30.8406 | -115.2838 | 2020-09-06 04:28:33 | Baja California, Mexico | ||
2661850 | 2661850 | 2020-09-04 | Mexico | Baja California | 17325 | 3213 | 13262 | 850 | 30.8406 | -115.2838 | 2020-09-05 04:28:19 | Baja California, Mexico | ||
1354390 | 1354390 | 2020-09-03 | Mexico | Baja California | 17166 | 3196 | 13241 | 729 | 30.8406 | -115.2838 | 2020-09-04 04:28:26 | Baja California, Mexico | ||
1105627 | 1105627 | 2020-09-02 | Mexico | Baja California | 17069 | 3174 | 13197 | 698 | 30.8406 | -115.2838 | 2020-09-03 04:28:22 | Baja California, Mexico | ||
2059956 | 2059956 | 2020-09-01 | Mexico | Baja California | 16987 | 3164 | 13157 | 666 | 30.8406 | -115.2838 | 2020-09-02 04:28:25 | Baja California, Mexico | ||
194141 | 194141 | 2020-08-31 | Mexico | Baja California | 16875 | 3145 | 13082 | 648 | 30.8406 | -115.2838 | 2020-09-01 04:28:31 | Baja California, Mexico | ||
3932100 | 3932100 | 2020-08-30 | Mexico | Baja California | 16840 | 3130 | 12966 | 744 | 30.8406 | -115.2838 | 2020-08-31 04:28:27 | Baja California, Mexico | ||
609762 | 609762 | 2020-08-29 | Mexico | Baja California | 16681 | 3122 | 12806 | 753 | 30.8406 | -115.2838 | 2020-08-30 04:28:22 | Baja California, Mexico | ||
1523257 | 1523257 | 2020-08-28 | Mexico | Baja California | 16486 | 3101 | 12703 | 682 | 30.8406 | -115.2838 | 2020-08-29 04:28:19 | Baja California, Mexico | ||
2510258 | 2510258 | 2020-08-27 | Mexico | Baja California | 16326 | 3084 | 12566 | 676 | 30.8406 | -115.2838 | 2020-08-28 04:28:11 | Baja California, Mexico | ||
1996718 | 1996718 | 2020-08-26 | Mexico | Baja California | 16235 | 3078 | 12446 | 711 | 30.8406 | -115.2838 | 2020-08-27 04:28:15 | Baja California, Mexico | ||
3562642 | 3562642 | 2020-08-25 | Mexico | Baja California | 16192 | 3059 | 12463 | 670 | 30.8406 | -115.2838 | 2020-08-26 04:28:11 | Baja California, Mexico | ||
2991346 | 2991346 | 2020-08-24 | Mexico | Baja California | 16086 | 3035 | 12442 | 609 | 30.8406 | -115.2838 | 2020-08-25 04:28:02 | Baja California, Mexico | ||
2215741 | 2215741 | 2020-08-23 | Mexico | Baja California | 15997 | 3017 | 12309 | 671 | 30.8406 | -115.2838 | 2020-08-24 04:27:56 | Baja California, Mexico | ||
2299523 | 2299523 | 2020-08-22 | Mexico | Baja California | 15917 | 3013 | 12175 | 729 | 30.8406 | -115.2838 | 2020-08-23 04:27:48 | Baja California, Mexico | ||
1479630 | 1479630 | 2020-08-21 | Mexico | Baja California | 15754 | 2995 | 12020 | 739 | 30.8406 | -115.2838 | 2020-08-22 04:27:49 | Baja California, Mexico | ||
3484379 | 3484379 | 2020-08-20 | Mexico | Baja California | 15689 | 2968 | 11974 | 747 | 30.8406 | -115.2838 | 2020-08-21 04:27:41 | Baja California, Mexico | ||
206328 | 206328 | 2020-08-19 | Mexico | Baja California | 15549 | 2937 | 11979 | 633 | 30.8406 | -115.2838 | 2020-08-20 04:27:43 | Baja California, Mexico | ||
3178082 | 3178082 | 2020-08-18 | Mexico | Baja California | 15472 | 2921 | 11895 | 656 | 30.8406 | -115.2838 | 2020-08-19 04:27:00 | Baja California, Mexico | ||
837686 | 837686 | 2020-08-17 | Mexico | Baja California | 15379 | 2896 | 11803 | 680 | 30.8406 | -115.2838 | 2020-08-18 04:27:56 | Baja California, Mexico | ||
1556044 | 1556044 | 2020-08-16 | Mexico | Baja California | 15352 | 2883 | 11713 | 756 | 30.8406 | -115.2838 | 2020-08-17 04:27:20 | Baja California, Mexico | ||
146046 | 146046 | 2020-08-15 | Mexico | Baja California | 15296 | 2875 | 11608 | 813 | 30.8406 | -115.2838 | 2020-08-16 04:27:42 | Baja California, Mexico | ||
1612321 | 1612321 | 2020-08-14 | Mexico | Baja California | 15117 | 2862 | 11444 | 811 | 30.8406 | -115.2838 | 2020-08-15 04:27:31 | Baja California, Mexico | ||
582905 | 582905 | 2020-08-13 | Mexico | Baja California | 14993 | 2844 | 11370 | 779 | 30.8406 | -115.2838 | 2020-08-14 04:51:19 | Baja California, 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]);