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 = "Queretaro" sorted by day
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1523277 | 1523277 | 2020-08-28 | Mexico | Queretaro | 6125 | 702 | 4696 | 727 | 20.5888 | -100.3899 | 2020-08-29 04:28:19 | Queretaro, Mexico | ||
609782 | 609782 | 2020-08-29 | Mexico | Queretaro | 6211 | 712 | 4799 | 700 | 20.5888 | -100.3899 | 2020-08-30 04:28:22 | Queretaro, Mexico | ||
3932120 | 3932120 | 2020-08-30 | Mexico | Queretaro | 6264 | 719 | 4874 | 671 | 20.5888 | -100.3899 | 2020-08-31 04:28:27 | Queretaro, Mexico | ||
194161 | 194161 | 2020-08-31 | Mexico | Queretaro | 6320 | 721 | 4963 | 636 | 20.5888 | -100.3899 | 2020-09-01 04:28:31 | Queretaro, Mexico | ||
2059976 | 2059976 | 2020-09-01 | Mexico | Queretaro | 6480 | 739 | 5057 | 684 | 20.5888 | -100.3899 | 2020-09-02 04:28:25 | Queretaro, Mexico | ||
1105647 | 1105647 | 2020-09-02 | Mexico | Queretaro | 6606 | 754 | 5110 | 742 | 20.5888 | -100.3899 | 2020-09-03 04:28:22 | Queretaro, Mexico | ||
1354410 | 1354410 | 2020-09-03 | Mexico | Queretaro | 6784 | 765 | 5263 | 756 | 20.5888 | -100.3899 | 2020-09-04 04:28:26 | Queretaro, Mexico | ||
2661870 | 2661870 | 2020-09-04 | Mexico | Queretaro | 6882 | 774 | 5323 | 785 | 20.5888 | -100.3899 | 2020-09-05 04:28:19 | Queretaro, Mexico | ||
813670 | 813670 | 2020-09-05 | Mexico | Queretaro | 7010 | 781 | 5438 | 791 | 20.5888 | -100.3899 | 2020-09-06 04:28:33 | Queretaro, Mexico | ||
3161715 | 3161715 | 2020-09-06 | Mexico | Queretaro | 7086 | 792 | 5493 | 801 | 20.5888 | -100.3899 | 2020-09-07 04:28:30 | Queretaro, Mexico | ||
427430 | 427430 | 2020-09-07 | Mexico | Queretaro | 7151 | 795 | 5609 | 747 | 20.5888 | -100.3899 | 2020-09-08 04:28:25 | Queretaro, Mexico | ||
1243851 | 1243851 | 2020-09-08 | Mexico | Queretaro | 7225 | 810 | 5681 | 734 | 20.5888 | -100.3899 | 2020-09-09 04:28:48 | Queretaro, Mexico | ||
2171642 | 2171642 | 2020-09-09 | Mexico | Queretaro | 7298 | 813 | 5734 | 751 | 20.5888 | -100.3899 | 2020-09-10 04:29:01 | Queretaro, Mexico | ||
1173277 | 1173277 | 2020-09-10 | Mexico | Queretaro | 7357 | 834 | 5790 | 733 | 20.5888 | -100.3899 | 2020-09-11 04:46:23 | Queretaro, Mexico | ||
1444676 | 1444676 | 2020-09-11 | Mexico | Queretaro | 7479 | 856 | 5917 | 706 | 20.5888 | -100.3899 | 2020-09-12 04:25:05 | Queretaro, Mexico | ||
546847 | 546847 | 2020-09-12 | Mexico | Queretaro | 7626 | 871 | 6075 | 680 | 20.5888 | -100.3899 | 2020-09-13 04:30:52 | Queretaro, Mexico | ||
2868808 | 2868808 | 2020-09-13 | Mexico | Queretaro | 7669 | 875 | 6171 | 623 | 20.5888 | -100.3899 | 2020-09-14 04:26:00 | Queretaro, Mexico | ||
344369 | 344369 | 2020-09-14 | Mexico | Queretaro | 7722 | 882 | 6281 | 559 | 20.5888 | -100.3899 | 2020-09-15 03:22:50 | Queretaro, Mexico | ||
2729097 | 2729097 | 2020-09-15 | Mexico | Queretaro | 7784 | 891 | 6348 | 545 | 20.5888 | -100.3899 | 2020-09-16 04:22:53 | Queretaro, Mexico | ||
666372 | 666372 | 2020-09-16 | Mexico | Queretaro | 7929 | 907 | 6485 | 537 | 20.5888 | -100.3899 | 2020-09-17 04:22:00 | Queretaro, Mexico | ||
1121683 | 1121683 | 2020-09-17 | Mexico | Queretaro | 7970 | 909 | 6544 | 517 | 20.5888 | -100.3899 | 2020-09-18 05:05:00 | Queretaro, Mexico | ||
2848934 | 2848934 | 2020-09-18 | Mexico | Queretaro | 8041 | 912 | 6578 | 551 | 20.5888 | -100.3899 | 2020-09-19 04:22:00 | Queretaro, Mexico | ||
2454865 | 2454865 | 2020-09-19 | Mexico | Queretaro | 8152 | 917 | 6702 | 533 | 20.5888 | -100.3899 | 2020-09-20 04:22:00 | Queretaro, Mexico | ||
3093515 | 3093515 | 2020-09-20 | Mexico | Queretaro | 8195 | 920 | 6771 | 504 | 20.5888 | -100.3899 | 2020-09-21 04:23:00 | Queretaro, Mexico | ||
2836911 | 2836911 | 2020-09-21 | Mexico | Queretaro | 8232 | 928 | 6871 | 433 | 20.5888 | -100.3899 | 2020-09-22 04:23:00 | Queretaro, Mexico | ||
3316312 | 3316312 | 2020-09-22 | Mexico | Queretaro | 8337 | 938 | 6903 | 496 | 20.5888 | -100.3899 | 2020-09-23 04:23:00 | Queretaro, Mexico | ||
2653863 | 2653863 | 2020-09-23 | Mexico | Queretaro | 8433 | 942 | 6944 | 547 | 20.5888 | -100.3899 | 2020-09-24 04:23:00 | Queretaro, Mexico | ||
2606120 | 2606120 | 2020-09-24 | Mexico | Queretaro | 8552 | 958 | 7005 | 589 | 20.5888 | -100.3899 | 2020-09-25 04:23:00 | Queretaro, Mexico | ||
2812843 | 2812843 | 2020-09-25 | Mexico | Queretaro | 8708 | 963 | 7070 | 675 | 20.5888 | -100.3899 | 2020-09-26 04:23:00 | Queretaro, Mexico | ||
2614128 | 2614128 | 2020-09-26 | Mexico | Queretaro | 8806 | 973 | 7128 | 705 | 20.5888 | -100.3899 | 2020-09-27 04:23:00 | Queretaro, Mexico | ||
2582076 | 2582076 | 2020-09-27 | Mexico | Queretaro | 8869 | 976 | 7198 | 695 | 20.5888 | -100.3899 | 2020-09-28 04:23:00 | Queretaro, Mexico | ||
1515488 | 1515488 | 2020-09-28 | Mexico | Queretaro | 8907 | 978 | 7275 | 654 | 20.5888 | -100.3899 | 2020-09-29 04:23:42 | Queretaro, Mexico | ||
966991 | 966991 | 2020-09-29 | Mexico | Queretaro | 8992 | 988 | 7321 | 683 | 20.5888 | -100.3899 | 2020-09-30 04:23:33 | Queretaro, Mexico | ||
1045910 | 1045910 | 2020-09-30 | Mexico | Queretaro | 9122 | 992 | 7386 | 744 | 20.5888 | -100.3899 | 2020-10-01 04:23:42 | Queretaro, Mexico | ||
2379724 | 2379724 | 2020-10-01 | Mexico | Queretaro | 9216 | 997 | 7441 | 778 | 20.5888 | -100.3899 | 2020-10-02 04:23:51 | Queretaro, Mexico | ||
3389483 | 3389483 | 2020-10-02 | Mexico | Queretaro | 9320 | 999 | 7512 | 809 | 20.5888 | -100.3899 | 2020-10-03 04:23:40 | Queretaro, Mexico | ||
2514265 | 2514265 | 2020-10-03 | Mexico | Queretaro | 9418 | 1010 | 7578 | 830 | 20.5888 | -100.3899 | 2020-10-04 04:23:44 | Queretaro, Mexico | ||
1822881 | 1822881 | 2020-10-04 | Mexico | Queretaro | 9499 | 1013 | 7737 | 749 | 20.5888 | -100.3899 | 2020-10-05 04:23:33 | Queretaro, Mexico | ||
3801991 | 3801991 | 2020-10-05 | Mexico | Queretaro | 9592 | 1018 | 7825 | 749 | 20.5888 | -100.3899 | 2020-10-06 04:23:33 | Queretaro, Mexico | ||
3117579 | 3117579 | 2020-10-06 | Mexico | Queretaro | 9667 | 1032 | 7912 | 723 | 20.5888 | -100.3899 | 2020-10-07 04:23:40 | Queretaro, Mexico | ||
1041918 | 1041918 | 2020-10-07 | Mexico | Queretaro | 9823 | 1036 | 7964 | 823 | 20.5888 | -100.3899 | 2020-10-08 04:23:56 | Queretaro, Mexico | ||
2689776 | 2689776 | 2020-10-08 | Mexico | Queretaro | 9911 | 1041 | 7984 | 886 | 20.5888 | -100.3899 | 2020-10-09 04:23:59 | Queretaro, Mexico | ||
817661 | 817661 | 2020-10-09 | Mexico | Queretaro | 10086 | 1051 | 8086 | 949 | 20.5888 | -100.3899 | 2020-10-10 04:23:57 | Queretaro, Mexico | ||
2602128 | 2602128 | 2020-10-10 | Mexico | Queretaro | 10208 | 1064 | 8153 | 991 | 20.5888 | -100.3899 | 2020-10-11 04:23:46 | Queretaro, Mexico | ||
3785990 | 3785990 | 2020-10-11 | Mexico | Queretaro | 10323 | 1064 | 8235 | 1024 | 20.5888 | -100.3899 | 2020-10-12 04:23:45 | Queretaro, Mexico | ||
2291537 | 2291537 | 2020-10-12 | Mexico | Queretaro | 10441 | 1067 | 8400 | 974 | 20.5888 | -100.3899 | 2020-10-13 04:24:02 | Queretaro, Mexico | ||
3781997 | 3781997 | 2020-10-13 | Mexico | Queretaro | 10601 | 1079 | 8482 | 1040 | 20.5888 | -100.3899 | 2020-10-14 04:24:05 | Queretaro, Mexico | ||
79182 | 79182 | 2020-10-14 | Mexico | Queretaro | 10756 | 1087 | 8498 | 1171 | 20.5888 | -100.3899 | 2020-10-15 04:24:28 | Queretaro, Mexico | ||
786471 | 786471 | 2020-10-15 | Mexico | Queretaro | 10938 | 1094 | 8659 | 1185 | 20.5888 | -100.3899 | 2020-10-16 04:24:01 | Queretaro, Mexico | ||
2856941 | 2856941 | 2020-10-16 | Mexico | Queretaro | 11118 | 1096 | 8741 | 1281 | 20.5888 | -100.3899 | 2020-10-17 04:24:12 | Queretaro, Mexico | ||
1026446 | 1026446 | 2020-10-17 | Mexico | Queretaro | 11314 | 1102 | 8812 | 1400 | 20.5888 | -100.3899 | 2020-10-18 04:24:25 | Queretaro, Mexico | ||
762408 | 762408 | 2020-10-18 | Mexico | Queretaro | 11425 | 1108 | 8899 | 1418 | 20.5888 | -100.3899 | 2020-10-19 04:24:16 | Queretaro, Mexico | ||
1794724 | 1794724 | 2020-10-19 | Mexico | Queretaro | 11641 | 1109 | 9183 | 1349 | 20.5888 | -100.3899 | 2020-10-20 04:24:22 | Queretaro, Mexico | ||
3990704 | 3990704 | 2020-10-20 | Mexico | Queretaro | 11765 | 1113 | 9208 | 1444 | 20.5888 | -100.3899 | 2020-10-21 04:24:14 | Queretaro, Mexico | ||
2191693 | 2191693 | 2020-10-21 | Mexico | Queretaro | 11953 | 1124 | 9217 | 1612 | 20.5888 | -100.3899 | 2020-10-22 04:24:27 | Queretaro, Mexico | ||
1177588 | 1177588 | 2020-10-22 | Mexico | Queretaro | 12170 | 1124 | 9348 | 1698 | 20.5888 | -100.3899 | 2020-10-23 04:24:46 | Queretaro, Mexico | ||
1053918 | 1053918 | 2020-10-23 | Mexico | Queretaro | 12343 | 1143 | 9490 | 1710 | 20.5888 | -100.3899 | 2020-10-24 04:24:46 | Queretaro, Mexico | ||
3651663 | 3651663 | 2020-10-24 | Mexico | Queretaro | 12646 | 1156 | 9724 | 1766 | 20.5888 | -100.3899 | 2020-10-25 04:24:36 | Queretaro, Mexico | ||
8426 | 8426 | 2020-10-25 | Mexico | Queretaro | 12777 | 1162 | 9905 | 1710 | 20.5888 | -100.3899 | 2020-10-26 04:25:02 | Queretaro, Mexico | ||
3480405 | 3480405 | 2020-10-26 | Mexico | Queretaro | 12926 | 1166 | 10144 | 1616 | 20.5888 | -100.3899 | 2020-10-27 04:24:45 | Queretaro, Mexico | ||
1452681 | 1452681 | 2020-10-27 | Mexico | Queretaro | 13135 | 1173 | 10250 | 1712 | 20.5888 | -100.3899 | 2020-10-28 04:24:39 | Queretaro, Mexico | ||
754397 | 754397 | 2020-10-28 | Mexico | Queretaro | 13372 | 1203 | 10404 | 1765 | 20.5888 | -100.3899 | 2020-10-29 04:24:49 | Queretaro, Mexico | ||
210335 | 210335 | 2020-10-29 | Mexico | Queretaro | 13490 | 1210 | 10490 | 1790 | 20.5888 | -100.3899 | 2020-10-30 04:24:49 | Queretaro, Mexico | ||
2243480 | 2243480 | 2020-10-30 | Mexico | Queretaro | 13729 | 1220 | 10623 | 1886 | 20.5888 | -100.3899 | 2020-10-31 04:24:44 | Queretaro, Mexico | ||
2080027 | 2080027 | 2020-10-31 | Mexico | Queretaro | 13911 | 1221 | 10842 | 1848 | 20.5888 | -100.3899 | 2020-11-01 04:36:19 | Queretaro, Mexico | ||
3409538 | 3409538 | 2020-11-01 | Mexico | Queretaro | 14034 | 1230 | 11023 | 1781 | 20.5888 | -100.3899 | 2020-11-02 05:25:04 | Queretaro, Mexico | ||
3304289 | 3304289 | 2020-11-02 | Mexico | Queretaro | 14176 | 1237 | 11298 | 1641 | 20.5888 | -100.3899 | 2020-11-03 06:00:16 | Queretaro, Mexico | ||
2498114 | 2498114 | 2020-11-03 | Mexico | Queretaro | 14370 | 1240 | 11504 | 1626 | 20.5888 | -100.3899 | 2020-11-04 05:25:09 | Queretaro, Mexico | ||
2919277 | 2919277 | 2020-11-04 | Mexico | Queretaro | 14664 | 1251 | 11824 | 1589 | 20.5888 | -100.3899 | 2020-11-05 06:05:03 | Queretaro, Mexico | ||
892215 | 892215 | 2020-11-05 | Mexico | Queretaro | 14953 | 1268 | 11922 | 1763 | 20.5888 | -100.3899 | 2020-11-06 05:24:55 | Queretaro, Mexico | ||
376277 | 376277 | 2020-11-06 | Mexico | Queretaro | 15238 | 1274 | 12069 | 1895 | 20.5888 | -100.3899 | 2020-11-07 05:24:52 | Queretaro, Mexico | ||
1544039 | 1544039 | 2020-11-07 | Mexico | Queretaro | 15498 | 1277 | 12220 | 2001 | 20.5888 | -100.3899 | 2020-11-08 05:24:56 | Queretaro, Mexico | ||
1728579 | 1728579 | 2020-11-08 | Mexico | Queretaro | 15721 | 1282 | 12483 | 1956 | 20.5888 | -100.3899 | 2020-11-09 05:25:45 | Queretaro, Mexico | ||
1988727 | 1988727 | 2020-11-09 | Mexico | Queretaro | 15969 | 1220 | 12483 | 2266 | 20.5888 | -100.3899 | 2020-11-10 05:40:07 | Queretaro, Mexico | ||
272250 | 272250 | 2020-11-10 | Mexico | Queretaro | 16306 | 1228 | 12483 | 2595 | 20.5888 | -100.3899 | 2020-11-11 05:25:30 | Queretaro, Mexico | ||
3440910 | 3440910 | 2020-11-11 | Mexico | Queretaro | 16524 | 1238 | 12483 | 2803 | 20.5888 | -100.3899 | 2020-11-12 05:25:55 | Queretaro, Mexico | ||
864865 | 864865 | 2020-11-12 | Mexico | Queretaro | 16776 | 1241 | 0 | 15535 | 20.5888 | -100.3899 | 2020-11-13 05:25:30 | Queretaro, Mexico | ||
2785100 | 2785100 | 2020-11-13 | Mexico | Queretaro | 16975 | 1252 | 0 | 15723 | 20.5888 | -100.3899 | 2020-11-14 05:25:37 | Queretaro, Mexico | ||
2915278 | 2915278 | 2020-11-14 | Mexico | Queretaro | 17178 | 1266 | 0 | 15912 | 20.5888 | -100.3899 | 2020-11-15 05:26:53 | Queretaro, Mexico | ||
2880300 | 2880300 | 2020-11-15 | Mexico | Queretaro | 17308 | 1267 | 0 | 16041 | 20.5888 | -100.3899 | 2020-11-16 05:25:57 | Queretaro, Mexico | ||
3169732 | 3169732 | 2020-11-16 | Mexico | Queretaro | 17481 | 1272 | 0 | 16209 | 20.5888 | -100.3899 | 2020-11-17 05:25:54 | Queretaro, Mexico | ||
3338687 | 3338687 | 2020-11-17 | Mexico | Queretaro | 17503 | 1273 | 0 | 16230 | 20.5888 | -100.3899 | 2020-11-18 05:40:31 | Queretaro, Mexico | ||
122799 | 122799 | 2020-11-18 | Mexico | Queretaro | 17532 | 1279 | 0 | 16253 | 20.5888 | -100.3899 | 2020-11-19 05:25:23 | Queretaro, Mexico | ||
821665 | 821665 | 2020-11-19 | Mexico | Queretaro | 17563 | 1292 | 0 | 16271 | 20.5888 | -100.3899 | 2020-11-20 05:26:28 | Queretaro, Mexico | ||
2701605 | 2701605 | 2020-11-20 | Mexico | Queretaro | 17804 | 1300 | 0 | 16504 | 20.5888 | -100.3899 | 2020-11-21 05:25:51 | Queretaro, Mexico | ||
3836577 | 3836577 | 2020-11-21 | Mexico | Queretaro | 18157 | 1380 | 0 | 16777 | 20.5888 | -100.3899 | 2020-11-22 05:25:45 | Queretaro, Mexico | ||
3190083 | 3190083 | 2020-11-22 | Mexico | Queretaro | 18664 | 1320 | 0 | 17344 | 20.5888 | -100.3899 | 2020-11-23 05:25:26 | Queretaro, Mexico | ||
678407 | 678407 | 2020-11-23 | Mexico | Queretaro | 19067 | 1333 | 0 | 17734 | 20.5888 | -100.3899 | 2020-11-24 05:27:31 | Queretaro, Mexico | ||
1350413 | 1350413 | 2020-11-24 | Mexico | Queretaro | 19518 | 1360 | 0 | 18158 | 20.5888 | -100.3899 | 2020-11-25 05:27:20 | Queretaro, Mexico | ||
1972682 | 1972682 | 2020-11-25 | Mexico | Queretaro | 20076 | 1380 | 0 | 18696 | 20.5888 | -100.3899 | 2020-11-26 05:27:44 | Queretaro, Mexico | ||
923777 | 923777 | 2020-11-26 | Mexico | Queretaro | 20574 | 1385 | 0 | 19189 | 20.5888 | -100.3899 | 2020-11-27 05:26:53 | Queretaro, Mexico | ||
392330 | 392330 | 2020-11-27 | Mexico | Queretaro | 20989 | 1471 | 0 | 19518 | 20.5888 | -100.3899 | 2020-11-28 05:25:50 | Queretaro, Mexico | ||
2935327 | 2935327 | 2020-11-28 | Mexico | Queretaro | 21354 | 1494 | 0 | 19860 | 20.5888 | -100.3899 | 2020-11-29 05:25:55 | Queretaro, Mexico | ||
3566662 | 3566662 | 2020-11-29 | Mexico | Queretaro | 21593 | 1428 | 0 | 20165 | 20.5888 | -100.3899 | 2020-11-30 05:26:13 | Queretaro, Mexico | ||
1584259 | 1584259 | 2020-11-30 | Mexico | Queretaro | 21885 | 1430 | 0 | 20455 | 20.5888 | -100.3899 | 2020-12-01 05:26:18 | Queretaro, Mexico | ||
2537490 | 2537490 | 2020-12-01 | Mexico | Queretaro | 22228 | 1441 | 0 | 20787 | 20.5888 | -100.3899 | 2020-12-02 05:27:41 | Queretaro, Mexico | ||
738396 | 738396 | 2020-12-02 | Mexico | Queretaro | 22760 | 1458 | 0 | 21302 | 20.5888 | -100.3899 | 2020-12-03 05:28:22 | Queretaro, Mexico | ||
75184 | 75184 | 2020-12-03 | Mexico | Queretaro | 23076 | 1468 | 0 | 21608 | 20.5888 | -100.3899 | 2020-12-04 05:27:27 | Queretaro, Mexico | ||
3859926 | 3859926 | 2020-12-04 | Mexico | Queretaro | 23397 | 1503 | 0 | 21894 | 20.5888 | -100.3899 | 2020-12-05 05:27:36 | Queretaro, Mexico | ||
1632398 | 1632398 | 2020-12-05 | Mexico | Queretaro | 23864 | 1509 | 0 | 22355 | 20.5888 | -100.3899 | 2020-12-06 05:26:18 | Queretaro, 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]);