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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3785990 | 3785990 | 2020-10-11 | Mexico | Queretaro | 10323 | 1064 | 8235 | 1024 | 20.5888 | -100.3899 | 2020-10-12 04:23:45 | 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 | ||
817661 | 817661 | 2020-10-09 | Mexico | Queretaro | 10086 | 1051 | 8086 | 949 | 20.5888 | -100.3899 | 2020-10-10 04:23:57 | 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 | ||
1041918 | 1041918 | 2020-10-07 | Mexico | Queretaro | 9823 | 1036 | 7964 | 823 | 20.5888 | -100.3899 | 2020-10-08 04:23:56 | 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 | ||
3801991 | 3801991 | 2020-10-05 | Mexico | Queretaro | 9592 | 1018 | 7825 | 749 | 20.5888 | -100.3899 | 2020-10-06 04:23:33 | 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 | ||
2514265 | 2514265 | 2020-10-03 | Mexico | Queretaro | 9418 | 1010 | 7578 | 830 | 20.5888 | -100.3899 | 2020-10-04 04:23:44 | 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 | ||
2379724 | 2379724 | 2020-10-01 | Mexico | Queretaro | 9216 | 997 | 7441 | 778 | 20.5888 | -100.3899 | 2020-10-02 04:23:51 | 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 | ||
966991 | 966991 | 2020-09-29 | Mexico | Queretaro | 8992 | 988 | 7321 | 683 | 20.5888 | -100.3899 | 2020-09-30 04:23:33 | 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 | ||
2582076 | 2582076 | 2020-09-27 | Mexico | Queretaro | 8869 | 976 | 7198 | 695 | 20.5888 | -100.3899 | 2020-09-28 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 | ||
2812843 | 2812843 | 2020-09-25 | Mexico | Queretaro | 8708 | 963 | 7070 | 675 | 20.5888 | -100.3899 | 2020-09-26 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 | ||
2653863 | 2653863 | 2020-09-23 | Mexico | Queretaro | 8433 | 942 | 6944 | 547 | 20.5888 | -100.3899 | 2020-09-24 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 | ||
2836911 | 2836911 | 2020-09-21 | Mexico | Queretaro | 8232 | 928 | 6871 | 433 | 20.5888 | -100.3899 | 2020-09-22 04:23: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 | ||
2454865 | 2454865 | 2020-09-19 | Mexico | Queretaro | 8152 | 917 | 6702 | 533 | 20.5888 | -100.3899 | 2020-09-20 04:22: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 | ||
1121683 | 1121683 | 2020-09-17 | Mexico | Queretaro | 7970 | 909 | 6544 | 517 | 20.5888 | -100.3899 | 2020-09-18 05:05:00 | 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 | ||
2729097 | 2729097 | 2020-09-15 | Mexico | Queretaro | 7784 | 891 | 6348 | 545 | 20.5888 | -100.3899 | 2020-09-16 04:22:53 | 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 | ||
2868808 | 2868808 | 2020-09-13 | Mexico | Queretaro | 7669 | 875 | 6171 | 623 | 20.5888 | -100.3899 | 2020-09-14 04:26:00 | 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 | ||
1444676 | 1444676 | 2020-09-11 | Mexico | Queretaro | 7479 | 856 | 5917 | 706 | 20.5888 | -100.3899 | 2020-09-12 04:25:05 | 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 | ||
2171642 | 2171642 | 2020-09-09 | Mexico | Queretaro | 7298 | 813 | 5734 | 751 | 20.5888 | -100.3899 | 2020-09-10 04:29:01 | 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 | ||
427430 | 427430 | 2020-09-07 | Mexico | Queretaro | 7151 | 795 | 5609 | 747 | 20.5888 | -100.3899 | 2020-09-08 04:28:25 | 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 | ||
813670 | 813670 | 2020-09-05 | Mexico | Queretaro | 7010 | 781 | 5438 | 791 | 20.5888 | -100.3899 | 2020-09-06 04:28:33 | 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 | ||
1354410 | 1354410 | 2020-09-03 | Mexico | Queretaro | 6784 | 765 | 5263 | 756 | 20.5888 | -100.3899 | 2020-09-04 04:28:26 | 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 | ||
2059976 | 2059976 | 2020-09-01 | Mexico | Queretaro | 6480 | 739 | 5057 | 684 | 20.5888 | -100.3899 | 2020-09-02 04:28:25 | 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 | ||
3932120 | 3932120 | 2020-08-30 | Mexico | Queretaro | 6264 | 719 | 4874 | 671 | 20.5888 | -100.3899 | 2020-08-31 04:28:27 | 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 | ||
1523277 | 1523277 | 2020-08-28 | Mexico | Queretaro | 6125 | 702 | 4696 | 727 | 20.5888 | -100.3899 | 2020-08-29 04:28:19 | Queretaro, Mexico | ||
2510278 | 2510278 | 2020-08-27 | Mexico | Queretaro | 5985 | 695 | 4578 | 712 | 20.5888 | -100.3899 | 2020-08-28 04:28:11 | Queretaro, Mexico | ||
1996738 | 1996738 | 2020-08-26 | Mexico | Queretaro | 5848 | 682 | 4531 | 635 | 20.5888 | -100.3899 | 2020-08-27 04:28:15 | Queretaro, Mexico | ||
3562662 | 3562662 | 2020-08-25 | Mexico | Queretaro | 5723 | 675 | 4464 | 584 | 20.5888 | -100.3899 | 2020-08-26 04:28:11 | Queretaro, Mexico | ||
2991366 | 2991366 | 2020-08-24 | Mexico | Queretaro | 5650 | 668 | 4450 | 532 | 20.5888 | -100.3899 | 2020-08-25 04:28:02 | Queretaro, Mexico | ||
2215761 | 2215761 | 2020-08-23 | Mexico | Queretaro | 5591 | 655 | 4322 | 614 | 20.5888 | -100.3899 | 2020-08-24 04:27:56 | Queretaro, Mexico | ||
2299543 | 2299543 | 2020-08-22 | Mexico | Queretaro | 5542 | 653 | 4237 | 652 | 20.5888 | -100.3899 | 2020-08-23 04:27:48 | Queretaro, Mexico | ||
1479650 | 1479650 | 2020-08-21 | Mexico | Queretaro | 5407 | 646 | 4124 | 637 | 20.5888 | -100.3899 | 2020-08-22 04:27:49 | Queretaro, Mexico | ||
3484399 | 3484399 | 2020-08-20 | Mexico | Queretaro | 5278 | 627 | 4017 | 634 | 20.5888 | -100.3899 | 2020-08-21 04:27:41 | Queretaro, Mexico | ||
206348 | 206348 | 2020-08-19 | Mexico | Queretaro | 5158 | 620 | 3952 | 586 | 20.5888 | -100.3899 | 2020-08-20 04:27:43 | Queretaro, Mexico | ||
3178102 | 3178102 | 2020-08-18 | Mexico | Queretaro | 5051 | 613 | 3883 | 555 | 20.5888 | -100.3899 | 2020-08-19 04:27:00 | Queretaro, Mexico | ||
837706 | 837706 | 2020-08-17 | Mexico | Queretaro | 4915 | 608 | 3830 | 477 | 20.5888 | -100.3899 | 2020-08-18 04:27:56 | Queretaro, Mexico | ||
1556064 | 1556064 | 2020-08-16 | Mexico | Queretaro | 4862 | 599 | 3745 | 518 | 20.5888 | -100.3899 | 2020-08-17 04:27:20 | Queretaro, Mexico | ||
146066 | 146066 | 2020-08-15 | Mexico | Queretaro | 4797 | 591 | 3685 | 521 | 20.5888 | -100.3899 | 2020-08-16 04:27:42 | Queretaro, Mexico | ||
1612341 | 1612341 | 2020-08-14 | Mexico | Queretaro | 4703 | 584 | 3601 | 518 | 20.5888 | -100.3899 | 2020-08-15 04:27:31 | Queretaro, Mexico | ||
582925 | 582925 | 2020-08-13 | Mexico | Queretaro | 4660 | 581 | 3539 | 540 | 20.5888 | -100.3899 | 2020-08-14 04:51:19 | Queretaro, Mexico | ||
3531544 | 3531544 | 2020-08-12 | Mexico | Queretaro | 4548 | 578 | 3463 | 507 | 20.5888 | -100.3899 | 2020-08-13 04:29:15 | Queretaro, Mexico | ||
662392 | 662392 | 2020-08-11 | Mexico | Queretaro | 4467 | 567 | 3402 | 498 | 20.5888 | -100.3899 | 2020-08-12 04:27:29 | Queretaro, Mexico | ||
1920530 | 1920530 | 2020-08-10 | Mexico | Queretaro | 4361 | 552 | 3357 | 452 | 20.5888 | -100.3899 | 2020-08-11 04:35:08 | Queretaro, Mexico | ||
3923339 | 3923339 | 2020-08-09 | Mexico | Queretaro | 4333 | 545 | 3312 | 476 | 20.5888 | -100.3899 | 2020-08-10 04:34:55 | Queretaro, Mexico | ||
371507 | 371507 | 2020-08-08 | Mexico | Queretaro | 4294 | 541 | 3229 | 524 | 20.5888 | -100.3899 | 2020-08-09 04:34:54 | Queretaro, Mexico | ||
458691 | 458691 | 2020-08-07 | Mexico | Queretaro | 4158 | 535 | 3118 | 505 | 20.5888 | -100.3899 | 2020-08-08 04:34:53 | Queretaro, Mexico | ||
3612376 | 3612376 | 2020-08-06 | Mexico | Queretaro | 4015 | 526 | 3026 | 463 | 20.5888 | -100.3899 | 2020-08-07 04:35:11 | Queretaro, Mexico | ||
3793206 | 3793206 | 2020-08-05 | Mexico | Queretaro | 3952 | 517 | 2981 | 454 | 20.5888 | -100.3899 | 2020-08-06 04:35:02 | Queretaro, Mexico | ||
98442 | 98442 | 2020-08-04 | Mexico | Queretaro | 3882 | 513 | 2932 | 437 | 20.5888 | -100.3899 | 2020-08-05 04:34:43 | Queretaro, Mexico | ||
2740325 | 2740325 | 2020-08-03 | Mexico | Queretaro | 3793 | 505 | 2894 | 394 | 20.5888 | -100.3899 | 2020-08-04 04:41:59 | Queretaro, Mexico | ||
2808077 | 2808077 | 2020-08-02 | Mexico | Queretaro | 3759 | 496 | 2826 | 437 | 20.5888 | -100.3899 | 2020-08-03 04:34:35 | Queretaro, Mexico | ||
753645 | 753645 | 2020-08-01 | Mexico | Queretaro | 3726 | 490 | 2801 | 435 | 20.5888 | -100.3899 | 2020-08-02 04:34:47 | Queretaro, Mexico | ||
3264810 | 3264810 | 2020-07-31 | Mexico | Queretaro | 3606 | 477 | 2698 | 431 | 20.5888 | -100.3899 | 2020-08-01 04:36:27 | Queretaro, Mexico | ||
1928517 | 1928517 | 2020-07-30 | Mexico | Queretaro | 3567 | 472 | 2671 | 424 | 20.5888 | -100.3899 | 2020-07-31 04:35:18 | Queretaro, Mexico | ||
2958685 | 2958685 | 2020-07-29 | Mexico | Queretaro | 3457 | 463 | 2592 | 402 | 20.5888 | -100.3899 | 2020-07-30 04:35:05 | Queretaro, Mexico | ||
3185301 | 3185301 | 2020-07-28 | Mexico | Queretaro | 3412 | 464 | 2547 | 401 | 20.5888 | -100.3899 | 2020-07-29 04:35:11 | Queretaro, Mexico | ||
177352 | 177352 | 2020-07-27 | Mexico | Queretaro | 3370 | 456 | 2519 | 395 | 20.5888 | -100.3899 | 2020-07-28 04:58:43 | Queretaro, Mexico | ||
442665 | 442665 | 2020-07-26 | Mexico | Queretaro | 3317 | 452 | 2441 | 424 | 20.5888 | -100.3899 | 2020-07-27 04:35:02 | Queretaro, Mexico | ||
1502909 | 1502909 | 2020-07-25 | Mexico | Queretaro | 3272 | 451 | 2397 | 424 | 20.5888 | -100.3899 | 2020-07-26 04:35:00 | Queretaro, Mexico | ||
2563879 | 2563879 | 2020-07-24 | Mexico | Queretaro | 3225 | 448 | 2356 | 421 | 20.5888 | -100.3899 | 2020-07-25 04:47:39 | Queretaro, Mexico | ||
62418 | 62418 | 2020-07-23 | Mexico | Queretaro | 3155 | 440 | 2282 | 433 | 20.5888 | -100.3899 | 2020-07-24 03:34:53 | Queretaro, Mexico | ||
844899 | 844899 | 2020-07-22 | Mexico | Queretaro | 3086 | 430 | 2226 | 430 | 20.5888 | -100.3899 | 2020-07-23 05:15:04 | Queretaro, Mexico | ||
1707638 | 1707638 | 2020-07-21 | Mexico | Queretaro | 3008 | 419 | 2189 | 400 | 20.5888 | -100.3899 | 2020-07-22 04:34:42 | Queretaro, Mexico | ||
327129 | 327129 | 2020-07-20 | Mexico | Queretaro | 2959 | 409 | 2159 | 391 | 20.5888 | -100.3899 | 2020-07-21 04:38:46 | Queretaro, Mexico | ||
122034 | 122034 | 2020-07-19 | Mexico | Queretaro | 2896 | 403 | 2094 | 399 | 20.5888 | -100.3899 | 2020-07-20 05:34:40 | Queretaro, Mexico | ||
3205423 | 3205423 | 2020-07-18 | Mexico | Queretaro | 2859 | 403 | 2108 | 348 | 20.5888 | -100.3899 | 2020-07-19 04:34:58 | Queretaro, Mexico | ||
2708725 | 2708725 | 2020-07-17 | Mexico | Queretaro | 2790 | 398 | 2044 | 348 | 20.5888 | -100.3899 | 2020-07-18 04:34:45 | Queretaro, Mexico | ||
367535 | 367535 | 2020-07-16 | Mexico | Queretaro | 2741 | 390 | 2003 | 348 | 20.5888 | -100.3899 | 2020-07-17 04:34:50 | Queretaro, Mexico | ||
2748203 | 2748203 | 2020-07-15 | Mexico | Queretaro | 2667 | 389 | 1954 | 324 | 20.5888 | -100.3899 | 2020-07-16 04:44:59 | Queretaro, Mexico | ||
2158847 | 2158847 | 2020-07-14 | Mexico | Queretaro | 2599 | 385 | 1909 | 305 | 20.5888 | -100.3899 | 2020-07-15 04:34:39 | Queretaro, Mexico | ||
3491488 | 3491488 | 2020-07-13 | Mexico | Queretaro | 2539 | 375 | 1862 | 302 | 20.5888 | -100.3899 | 2020-07-14 04:34:46 | Queretaro, Mexico | ||
3737751 | 3737751 | 2020-07-12 | Mexico | Queretaro | 2494 | 371 | 1829 | 294 | 20.5888 | -100.3899 | 2020-07-13 04:43:04 | Queretaro, Mexico | ||
3436146 | 3436146 | 2020-07-11 | Mexico | Queretaro | 2473 | 369 | 1793 | 311 | 20.5888 | -100.3899 | 2020-07-12 04:34:30 | Queretaro, Mexico | ||
3237644 | 3237644 | 2020-07-10 | Mexico | Queretaro | 2407 | 366 | 1737 | 304 | 20.5888 | -100.3899 | 2020-07-11 04:34:26 | Queretaro, Mexico | ||
1005629 | 1005629 | 2020-07-09 | Mexico | Queretaro | 2343 | 359 | 1700 | 284 | 20.5888 | -100.3899 | 2020-07-10 04:34:24 | Queretaro, Mexico | ||
2222845 | 2222845 | 2020-07-08 | Mexico | Queretaro | 2290 | 349 | 1664 | 277 | 20.5888 | -100.3899 | 2020-07-09 04:34:23 | Queretaro, Mexico | ||
887454 | 887454 | 2020-07-07 | Mexico | Queretaro | 2262 | 341 | 1648 | 273 | 20.5888 | -100.3899 | 2020-07-08 05:33:48 | Queretaro, Mexico | ||
2685014 | 2685014 | 2020-07-06 | Mexico | Queretaro | 2216 | 332 | 1622 | 262 | 20.5888 | -100.3899 | 2020-07-07 04:34:00 | Queretaro, Mexico | ||
415479 | 415479 | 2020-07-05 | Mexico | Queretaro | 2170 | 325 | 1595 | 250 | 20.5888 | -100.3899 | 2020-07-06 04:33:57 | Queretaro, Mexico | ||
530041 | 530041 | 2020-07-04 | Mexico | Queretaro | 2135 | 323 | 1562 | 250 | 20.5888 | -100.3899 | 2020-07-05 04:33:46 | 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]);