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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908273 | 908273 | 2021-01-19 | Mexico | Queretaro | 39150 | 2396 | 0 | 36754 | 20.5888 | -100.3899 | 2021-01-20 05:21:54 | Queretaro, Mexico | ||
237336 | 237336 | 2021-01-18 | Mexico | Queretaro | 38615 | 2375 | 0 | 36240 | 20.5888 | -100.3899 | 2021-01-19 05:22:15 | Queretaro, Mexico | ||
3503453 | 3503453 | 2021-01-17 | Mexico | Queretaro | 38273 | 2363 | 0 | 35910 | 20.5888 | -100.3899 | 2021-01-18 05:22:34 | Queretaro, Mexico | ||
3101536 | 3101536 | 2021-01-16 | Mexico | Queretaro | 37870 | 2335 | 0 | 35535 | 20.5888 | -100.3899 | 2021-01-17 05:22:17 | Queretaro, Mexico | ||
3515498 | 3515498 | 2021-01-15 | Mexico | Queretaro | 37319 | 2323 | 0 | 34996 | 20.5888 | -100.3899 | 2021-01-16 05:22:40 | Queretaro, Mexico | ||
3879671 | 3879671 | 2021-01-14 | Mexico | Queretaro | 36663 | 2300 | 0 | 34363 | 20.5888 | -100.3899 | 2021-01-15 05:22:24 | Queretaro, Mexico | ||
3308298 | 3308298 | 2021-01-13 | Mexico | Queretaro | 36317 | 2290 | 0 | 34027 | 20.5888 | -100.3899 | 2021-01-14 05:22:32 | Queretaro, Mexico | ||
774443 | 774443 | 2021-01-12 | Mexico | Queretaro | 35990 | 2235 | 0 | 33755 | 20.5888 | -100.3899 | 2021-01-13 05:22:15 | Queretaro, Mexico | ||
190164 | 190164 | 2021-01-11 | Mexico | Queretaro | 35606 | 2199 | 0 | 33407 | 20.5888 | -100.3899 | 2021-01-12 05:22:15 | Queretaro, Mexico | ||
2625967 | 2625967 | 2021-01-10 | Mexico | Queretaro | 35396 | 2182 | 0 | 33214 | 20.5888 | -100.3899 | 2021-01-11 05:21:50 | Queretaro, Mexico | ||
3900055 | 3900055 | 2021-01-09 | Mexico | Queretaro | 35123 | 2177 | 0 | 32946 | 20.5888 | -100.3899 | 2021-01-10 05:22:12 | Queretaro, Mexico | ||
154078 | 154078 | 2021-01-08 | Mexico | Queretaro | 34734 | 2142 | 0 | 32592 | 20.5888 | -100.3899 | 2021-01-09 05:22:18 | Queretaro, Mexico | ||
2541502 | 2541502 | 2021-01-07 | Mexico | Queretaro | 34343 | 2105 | 0 | 32238 | 20.5888 | -100.3899 | 2021-01-08 05:22:42 | Queretaro, Mexico | ||
2864811 | 2864811 | 2021-01-06 | Mexico | Queretaro | 33920 | 2059 | 0 | 31861 | 20.5888 | -100.3899 | 2021-01-07 05:22:03 | Queretaro, Mexico | ||
3034398 | 3034398 | 2021-01-05 | Mexico | Queretaro | 33557 | 2012 | 0 | 31545 | 20.5888 | -100.3899 | 2021-01-06 05:22:16 | Queretaro, Mexico | ||
1061943 | 1061943 | 2021-01-04 | Mexico | Queretaro | 33158 | 1944 | 0 | 31214 | 20.5888 | -100.3899 | 2021-01-05 05:21:49 | Queretaro, Mexico | ||
3230546 | 3230546 | 2021-01-03 | Mexico | Queretaro | 32927 | 1890 | 0 | 31037 | 20.5888 | -100.3899 | 2021-01-04 05:22:02 | Queretaro, Mexico | ||
2227615 | 2227615 | 2021-01-02 | Mexico | Queretaro | 32750 | 1890 | 0 | 30860 | 20.5888 | -100.3899 | 2021-01-03 05:22:52 | Queretaro, Mexico | ||
1136979 | 1136979 | 2021-01-01 | Mexico | Queretaro | 32582 | 1890 | 0 | 30692 | 20.5888 | -100.3899 | 2021-01-02 05:22:33 | Queretaro, Mexico | ||
3695585 | 3695585 | 2020-12-31 | Mexico | Queretaro | 32377 | 1885 | 0 | 30492 | 20.5888 | -100.3899 | 2021-01-01 05:23:07 | Queretaro, Mexico | ||
1010400 | 1010400 | 2020-12-30 | Mexico | Queretaro | 32039 | 1873 | 0 | 30166 | 20.5888 | -100.3899 | 2020-12-31 05:22:49 | Queretaro, Mexico | ||
766415 | 766415 | 2020-12-29 | Mexico | Queretaro | 31624 | 1862 | 0 | 29762 | 20.5888 | -100.3899 | 2020-12-30 05:22:34 | Queretaro, Mexico | ||
3761679 | 3761679 | 2020-12-28 | Mexico | Queretaro | 31079 | 1849 | 0 | 29230 | 20.5888 | -100.3899 | 2020-12-29 05:22:37 | Queretaro, Mexico | ||
3777999 | 3777999 | 2020-12-27 | Mexico | Queretaro | 30765 | 1832 | 0 | 28933 | 20.5888 | -100.3899 | 2020-12-28 05:22:06 | Queretaro, Mexico | ||
2223604 | 2223604 | 2020-12-26 | Mexico | Queretaro | 30517 | 1805 | 0 | 28712 | 20.5888 | -100.3899 | 2020-12-27 05:22:55 | Queretaro, Mexico | ||
202351 | 202351 | 2020-12-25 | Mexico | Queretaro | 30357 | 1803 | 0 | 28554 | 20.5888 | -100.3899 | 2020-12-26 05:22:28 | Queretaro, Mexico | ||
3691574 | 3691574 | 2020-12-24 | Mexico | Queretaro | 30150 | 1797 | 0 | 28353 | 20.5888 | -100.3899 | 2020-12-25 05:22:48 | Queretaro, Mexico | ||
2406926 | 2406926 | 2020-12-23 | Mexico | Queretaro | 29863 | 1787 | 0 | 28076 | 20.5888 | -100.3899 | 2020-12-24 05:23:04 | Queretaro, Mexico | ||
3769972 | 3769972 | 2020-12-22 | Mexico | Queretaro | 29527 | 1782 | 0 | 27745 | 20.5888 | -100.3899 | 2020-12-23 05:22:03 | Queretaro, Mexico | ||
927788 | 927788 | 2020-12-21 | Mexico | Queretaro | 29259 | 1771 | 0 | 27488 | 20.5888 | -100.3899 | 2020-12-22 05:22:33 | Queretaro, Mexico | ||
2119809 | 2119809 | 2020-12-20 | Mexico | Queretaro | 29051 | 1746 | 0 | 27305 | 20.5888 | -100.3899 | 2020-12-21 05:27:58 | Queretaro, Mexico | ||
2931316 | 2931316 | 2020-12-19 | Mexico | Queretaro | 28909 | 1732 | 0 | 27177 | 20.5888 | -100.3899 | 2020-12-20 05:27:32 | Queretaro, Mexico | ||
1901262 | 1901262 | 2020-12-18 | Mexico | Queretaro | 28534 | 1715 | 0 | 26819 | 20.5888 | -100.3899 | 2020-12-19 05:27:52 | Queretaro, Mexico | ||
2128088 | 2128088 | 2020-12-17 | Mexico | Queretaro | 28160 | 1679 | 0 | 26481 | 20.5888 | -100.3899 | 2020-12-18 05:28:18 | Queretaro, Mexico | ||
3149688 | 3149688 | 2020-12-16 | Mexico | Queretaro | 27715 | 1668 | 0 | 26047 | 20.5888 | -100.3899 | 2020-12-17 05:28:12 | Queretaro, Mexico | ||
1034469 | 1034469 | 2020-12-15 | Mexico | Queretaro | 27358 | 1652 | 0 | 25706 | 20.5888 | -100.3899 | 2020-12-16 05:28:04 | Queretaro, Mexico | ||
1751363 | 1751363 | 2020-12-14 | Mexico | Queretaro | 27036 | 1641 | 0 | 25395 | 20.5888 | -100.3899 | 2020-12-15 05:26:38 | Queretaro, Mexico | ||
3847883 | 3847883 | 2020-12-13 | Mexico | Queretaro | 26861 | 1630 | 0 | 25231 | 20.5888 | -100.3899 | 2020-12-14 05:26:27 | Queretaro, Mexico | ||
845665 | 845665 | 2020-12-12 | Mexico | Queretaro | 26536 | 1626 | 0 | 24910 | 20.5888 | -100.3899 | 2020-12-13 05:27:20 | Queretaro, Mexico | ||
860772 | 860772 | 2020-12-11 | Mexico | Queretaro | 26235 | 1587 | 0 | 24648 | 20.5888 | -100.3899 | 2020-12-12 05:26:19 | Queretaro, Mexico | ||
1600314 | 1600314 | 2020-12-10 | Mexico | Queretaro | 25852 | 1560 | 0 | 24292 | 20.5888 | -100.3899 | 2020-12-11 05:26:59 | Queretaro, Mexico | ||
2975323 | 2975323 | 2020-12-09 | Mexico | Queretaro | 25278 | 1544 | 0 | 23734 | 20.5888 | -100.3899 | 2020-12-10 05:26:19 | Queretaro, Mexico | ||
1818883 | 1818883 | 2020-12-08 | Mexico | Queretaro | 24788 | 1541 | 0 | 23247 | 20.5888 | -100.3899 | 2020-12-09 05:28:01 | Queretaro, Mexico | ||
2347519 | 2347519 | 2020-12-07 | Mexico | Queretaro | 24554 | 1533 | 0 | 23021 | 20.5888 | -100.3899 | 2020-12-08 05:27:42 | Queretaro, Mexico | ||
1006389 | 1006389 | 2020-12-06 | Mexico | Queretaro | 24159 | 1521 | 0 | 22638 | 20.5888 | -100.3899 | 2020-12-07 05:26:14 | 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 | ||
3859926 | 3859926 | 2020-12-04 | Mexico | Queretaro | 23397 | 1503 | 0 | 21894 | 20.5888 | -100.3899 | 2020-12-05 05:27:36 | 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 | ||
738396 | 738396 | 2020-12-02 | Mexico | Queretaro | 22760 | 1458 | 0 | 21302 | 20.5888 | -100.3899 | 2020-12-03 05:28:22 | 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 | ||
1584259 | 1584259 | 2020-11-30 | Mexico | Queretaro | 21885 | 1430 | 0 | 20455 | 20.5888 | -100.3899 | 2020-12-01 05:26:18 | 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 | ||
2935327 | 2935327 | 2020-11-28 | Mexico | Queretaro | 21354 | 1494 | 0 | 19860 | 20.5888 | -100.3899 | 2020-11-29 05:25:55 | 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 | ||
923777 | 923777 | 2020-11-26 | Mexico | Queretaro | 20574 | 1385 | 0 | 19189 | 20.5888 | -100.3899 | 2020-11-27 05:26:53 | 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 | ||
1350413 | 1350413 | 2020-11-24 | Mexico | Queretaro | 19518 | 1360 | 0 | 18158 | 20.5888 | -100.3899 | 2020-11-25 05:27:20 | 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 | ||
3190083 | 3190083 | 2020-11-22 | Mexico | Queretaro | 18664 | 1320 | 0 | 17344 | 20.5888 | -100.3899 | 2020-11-23 05:25:26 | 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 | ||
2701605 | 2701605 | 2020-11-20 | Mexico | Queretaro | 17804 | 1300 | 0 | 16504 | 20.5888 | -100.3899 | 2020-11-21 05:25:51 | 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 | ||
122799 | 122799 | 2020-11-18 | Mexico | Queretaro | 17532 | 1279 | 0 | 16253 | 20.5888 | -100.3899 | 2020-11-19 05:25:23 | 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 | ||
3169732 | 3169732 | 2020-11-16 | Mexico | Queretaro | 17481 | 1272 | 0 | 16209 | 20.5888 | -100.3899 | 2020-11-17 05:25:54 | 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 | ||
2915278 | 2915278 | 2020-11-14 | Mexico | Queretaro | 17178 | 1266 | 0 | 15912 | 20.5888 | -100.3899 | 2020-11-15 05:26:53 | 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 | ||
864865 | 864865 | 2020-11-12 | Mexico | Queretaro | 16776 | 1241 | 0 | 15535 | 20.5888 | -100.3899 | 2020-11-13 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 | ||
272250 | 272250 | 2020-11-10 | Mexico | Queretaro | 16306 | 1228 | 12483 | 2595 | 20.5888 | -100.3899 | 2020-11-11 05:25:30 | 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 | ||
1728579 | 1728579 | 2020-11-08 | Mexico | Queretaro | 15721 | 1282 | 12483 | 1956 | 20.5888 | -100.3899 | 2020-11-09 05:25:45 | 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 | ||
376277 | 376277 | 2020-11-06 | Mexico | Queretaro | 15238 | 1274 | 12069 | 1895 | 20.5888 | -100.3899 | 2020-11-07 05:24:52 | 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 | ||
2919277 | 2919277 | 2020-11-04 | Mexico | Queretaro | 14664 | 1251 | 11824 | 1589 | 20.5888 | -100.3899 | 2020-11-05 06:05:03 | 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 | ||
3304289 | 3304289 | 2020-11-02 | Mexico | Queretaro | 14176 | 1237 | 11298 | 1641 | 20.5888 | -100.3899 | 2020-11-03 06:00:16 | 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 | ||
2080027 | 2080027 | 2020-10-31 | Mexico | Queretaro | 13911 | 1221 | 10842 | 1848 | 20.5888 | -100.3899 | 2020-11-01 04:36:19 | 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 | ||
210335 | 210335 | 2020-10-29 | Mexico | Queretaro | 13490 | 1210 | 10490 | 1790 | 20.5888 | -100.3899 | 2020-10-30 04:24:49 | 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 | ||
1452681 | 1452681 | 2020-10-27 | Mexico | Queretaro | 13135 | 1173 | 10250 | 1712 | 20.5888 | -100.3899 | 2020-10-28 04:24:39 | 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 | ||
8426 | 8426 | 2020-10-25 | Mexico | Queretaro | 12777 | 1162 | 9905 | 1710 | 20.5888 | -100.3899 | 2020-10-26 04:25:02 | 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 | ||
1053918 | 1053918 | 2020-10-23 | Mexico | Queretaro | 12343 | 1143 | 9490 | 1710 | 20.5888 | -100.3899 | 2020-10-24 04:24:46 | 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 | ||
2191693 | 2191693 | 2020-10-21 | Mexico | Queretaro | 11953 | 1124 | 9217 | 1612 | 20.5888 | -100.3899 | 2020-10-22 04:24:27 | 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 | ||
1794724 | 1794724 | 2020-10-19 | Mexico | Queretaro | 11641 | 1109 | 9183 | 1349 | 20.5888 | -100.3899 | 2020-10-20 04:24:22 | 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 | ||
1026446 | 1026446 | 2020-10-17 | Mexico | Queretaro | 11314 | 1102 | 8812 | 1400 | 20.5888 | -100.3899 | 2020-10-18 04:24:25 | 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 | ||
786471 | 786471 | 2020-10-15 | Mexico | Queretaro | 10938 | 1094 | 8659 | 1185 | 20.5888 | -100.3899 | 2020-10-16 04:24:01 | 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 | ||
3781997 | 3781997 | 2020-10-13 | Mexico | Queretaro | 10601 | 1079 | 8482 | 1040 | 20.5888 | -100.3899 | 2020-10-14 04:24:05 | 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 |
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]);