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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533495 | 2533495 | 2022-05-12 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-13 04:20:51 | Queretaro, Mexico | |||
3444941 | 3444941 | 2022-05-11 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-12 04:20:54 | Queretaro, Mexico | |||
3535558 | 3535558 | 2022-05-10 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-11 04:20:48 | Queretaro, Mexico | |||
222093 | 222093 | 2022-05-09 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-10 04:20:50 | Queretaro, Mexico | |||
2331478 | 2331478 | 2022-05-08 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-09 04:20:54 | Queretaro, Mexico | |||
360440 | 360440 | 2022-05-07 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-08 04:20:49 | Queretaro, Mexico | |||
1397791 | 1397791 | 2022-05-06 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-07 04:21:09 | Queretaro, Mexico | |||
2598146 | 2598146 | 2022-05-05 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-06 04:21:00 | Queretaro, Mexico | |||
3265595 | 3265595 | 2022-05-04 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-05 04:20:55 | Queretaro, Mexico | |||
1572234 | 1572234 | 2022-05-03 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-04 04:20:59 | Queretaro, Mexico | |||
463494 | 463494 | 2022-05-02 | Mexico | Queretaro | 142052 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-03 04:21:00 | Queretaro, Mexico | |||
3916133 | 3916133 | 2022-05-01 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-02 04:21:10 | Queretaro, Mexico | |||
2840937 | 2840937 | 2022-04-30 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-01 04:20:57 | Queretaro, Mexico | |||
1157250 | 1157250 | 2022-04-29 | Mexico | Queretaro | 142038 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-30 04:21:05 | Queretaro, Mexico | |||
1696432 | 1696432 | 2022-04-28 | Mexico | Queretaro | 142026 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-29 04:20:59 | Queretaro, Mexico | |||
3851915 | 3851915 | 2022-04-27 | Mexico | Queretaro | 142011 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-28 04:20:47 | Queretaro, Mexico | |||
1326345 | 1326345 | 2022-04-26 | Mexico | Queretaro | 141995 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-27 04:20:52 | Queretaro, Mexico | |||
3722299 | 3722299 | 2022-04-25 | Mexico | Queretaro | 141985 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-26 04:20:51 | Queretaro, Mexico | |||
2028867 | 2028867 | 2022-04-24 | Mexico | Queretaro | 141985 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-25 04:20:56 | Queretaro, Mexico | |||
746442 | 746442 | 2022-04-23 | Mexico | Queretaro | 141982 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-24 04:20:56 | Queretaro, Mexico | |||
3436927 | 3436927 | 2022-04-22 | Mexico | Queretaro | 141951 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-23 04:20:50 | Queretaro, Mexico | |||
2892512 | 2892512 | 2022-04-21 | Mexico | Queretaro | 141951 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-22 04:20:45 | Queretaro, Mexico | |||
2307384 | 2307384 | 2022-04-20 | Mexico | Queretaro | 141925 | 6197 | 0 | 20.5888 | -100.3899 | 2022-04-21 04:20:46 | Queretaro, Mexico | |||
2251523 | 2251523 | 2022-04-19 | Mexico | Queretaro | 141910 | 6196 | 0 | 20.5888 | -100.3899 | 2022-04-20 04:20:45 | Queretaro, Mexico | |||
1846073 | 1846073 | 2022-04-18 | Mexico | Queretaro | 141875 | 6196 | 0 | 20.5888 | -100.3899 | 2022-04-19 04:21:00 | Queretaro, Mexico | |||
3417017 | 3417017 | 2022-04-17 | Mexico | Queretaro | 141875 | 6196 | 0 | 20.5888 | -100.3899 | 2022-04-18 04:21:12 | Queretaro, Mexico | |||
303966 | 303966 | 2022-04-16 | Mexico | Queretaro | 141840 | 6196 | 0 | 20.5888 | -100.3899 | 2022-04-17 04:20:59 | Queretaro, Mexico | |||
2669911 | 2669911 | 2022-04-15 | Mexico | Queretaro | 141619 | 6195 | 0 | 20.5888 | -100.3899 | 2022-04-16 04:20:48 | Queretaro, Mexico | |||
1223696 | 1223696 | 2022-04-14 | Mexico | Queretaro | 141614 | 6195 | 0 | 20.5888 | -100.3899 | 2022-04-15 04:20:57 | Queretaro, Mexico | |||
2442854 | 2442854 | 2022-04-13 | Mexico | Queretaro | 141613 | 6195 | 0 | 20.5888 | -100.3899 | 2022-04-13 23:21:06 | Queretaro, Mexico | |||
1948611 | 1948611 | 2022-04-12 | Mexico | Queretaro | 141609 | 6195 | 0 | 20.5888 | -100.3899 | 2022-04-13 04:21:03 | Queretaro, Mexico | |||
3206364 | 3206364 | 2022-04-11 | Mexico | Queretaro | 141600 | 6193 | 0 | 20.5888 | -100.3899 | 2022-04-12 04:20:49 | Queretaro, Mexico | |||
1576250 | 1576250 | 2022-04-10 | Mexico | Queretaro | 141598 | 6193 | 0 | 20.5888 | -100.3899 | 2022-04-11 04:21:02 | Queretaro, Mexico | |||
1652492 | 1652492 | 2022-04-09 | Mexico | Queretaro | 141598 | 6193 | 0 | 20.5888 | -100.3899 | 2022-04-10 04:20:52 | Queretaro, Mexico | |||
2115814 | 2115814 | 2022-04-08 | Mexico | Queretaro | 141508 | 6193 | 0 | 20.5888 | -100.3899 | 2022-04-09 04:20:42 | Queretaro, Mexico | |||
3320338 | 3320338 | 2022-04-07 | Mexico | Queretaro | 141324 | 6192 | 0 | 20.5888 | -100.3899 | 2022-04-08 04:20:48 | Queretaro, Mexico | |||
2800874 | 2800874 | 2022-04-06 | Mexico | Queretaro | 141213 | 6192 | 0 | 20.5888 | -100.3899 | 2022-04-07 04:20:53 | Queretaro, Mexico | |||
3867643 | 3867643 | 2022-04-05 | Mexico | Queretaro | 141123 | 6189 | 0 | 20.5888 | -100.3899 | 2022-04-06 04:20:49 | Queretaro, Mexico | |||
2748985 | 2748985 | 2022-04-04 | Mexico | Queretaro | 141069 | 6189 | 0 | 20.5888 | -100.3899 | 2022-04-05 04:20:48 | Queretaro, Mexico | |||
3730331 | 3730331 | 2022-04-03 | Mexico | Queretaro | 141068 | 6189 | 0 | 20.5888 | -100.3899 | 2022-04-04 04:20:51 | Queretaro, Mexico | |||
499766 | 499766 | 2022-04-02 | Mexico | Queretaro | 141068 | 6188 | 0 | 20.5888 | -100.3899 | 2022-04-03 04:20:48 | Queretaro, Mexico | |||
3350751 | 3350751 | 2022-04-01 | Mexico | Queretaro | 141055 | 6185 | 0 | 20.5888 | -100.3899 | 2022-04-02 04:20:47 | Queretaro, Mexico | |||
1540056 | 1540056 | 2022-03-31 | Mexico | Queretaro | 141032 | 6184 | 0 | 20.5888 | -100.3899 | 2022-04-01 04:20:28 | Queretaro, Mexico | |||
2478069 | 2478069 | 2022-03-30 | Mexico | Queretaro | 140993 | 6182 | 0 | 20.5888 | -100.3899 | 2022-03-31 04:20:56 | Queretaro, Mexico | |||
158110 | 158110 | 2022-03-29 | Mexico | Queretaro | 140993 | 6182 | 0 | 20.5888 | -100.3899 | 2022-03-30 04:20:45 | Queretaro, Mexico | |||
1436681 | 1436681 | 2022-03-28 | Mexico | Queretaro | 140919 | 6179 | 0 | 20.5888 | -100.3899 | 2022-03-29 04:20:46 | Queretaro, Mexico | |||
876362 | 876362 | 2022-03-27 | Mexico | Queretaro | 140908 | 6179 | 0 | 20.5888 | -100.3899 | 2022-03-28 04:20:33 | Queretaro, Mexico | |||
2163645 | 2163645 | 2022-03-26 | Mexico | Queretaro | 140884 | 6178 | 0 | 20.5888 | -100.3899 | 2022-03-27 04:20:47 | Queretaro, Mexico | |||
1720581 | 1720581 | 2022-03-25 | Mexico | Queretaro | 140884 | 6178 | 0 | 20.5888 | -100.3899 | 2022-03-26 04:20:23 | Queretaro, Mexico | |||
1468198 | 1468198 | 2022-03-24 | Mexico | Queretaro | 140804 | 6175 | 0 | 20.5888 | -100.3899 | 2022-03-25 04:20:46 | Queretaro, Mexico | |||
3022372 | 3022372 | 2022-03-23 | Mexico | Queretaro | 140770 | 6173 | 0 | 20.5888 | -100.3899 | 2022-03-24 04:20:43 | Queretaro, Mexico | |||
1905294 | 1905294 | 2022-03-22 | Mexico | Queretaro | 140770 | 6173 | 0 | 20.5888 | -100.3899 | 2022-03-23 04:20:48 | Queretaro, Mexico | |||
3238425 | 3238425 | 2022-03-21 | Mexico | Queretaro | 140764 | 6173 | 0 | 20.5888 | -100.3899 | 2022-03-22 04:20:54 | Queretaro, Mexico | |||
24498 | 24498 | 2022-03-20 | Mexico | Queretaro | 140758 | 6173 | 0 | 20.5888 | -100.3899 | 2022-03-21 04:20:50 | Queretaro, Mexico | |||
1656508 | 1656508 | 2022-03-19 | Mexico | Queretaro | 140733 | 6172 | 0 | 20.5888 | -100.3899 | 2022-03-20 04:20:45 | Queretaro, Mexico | |||
336034 | 336034 | 2022-03-18 | Mexico | Queretaro | 140703 | 6168 | 0 | 20.5888 | -100.3899 | 2022-03-19 04:20:47 | Queretaro, Mexico | |||
694487 | 694487 | 2022-03-17 | Mexico | Queretaro | 140703 | 6168 | 0 | 20.5888 | -100.3899 | 2022-03-18 04:20:55 | Queretaro, Mexico | |||
2319430 | 2319430 | 2022-03-16 | Mexico | Queretaro | 140606 | 6159 | 0 | 20.5888 | -100.3899 | 2022-03-17 04:20:56 | Queretaro, Mexico | |||
261630 | 261630 | 2022-03-15 | Mexico | Queretaro | 140565 | 6151 | 0 | 20.5888 | -100.3899 | 2022-03-16 04:20:50 | Queretaro, Mexico | |||
2263989 | 2263989 | 2022-03-14 | Mexico | Queretaro | 140565 | 6151 | 0 | 20.5888 | -100.3899 | 2022-03-15 04:20:47 | Queretaro, Mexico | |||
3628055 | 3628055 | 2022-03-13 | Mexico | Queretaro | 140559 | 6151 | 0 | 20.5888 | -100.3899 | 2022-03-14 04:20:46 | Queretaro, Mexico | |||
950963 | 950963 | 2022-03-12 | Mexico | Queretaro | 140556 | 6151 | 0 | 20.5888 | -100.3899 | 2022-03-13 04:20:49 | Queretaro, Mexico | |||
356424 | 356424 | 2022-03-11 | Mexico | Queretaro | 140436 | 6148 | 0 | 20.5888 | -100.3899 | 2022-03-12 04:20:50 | Queretaro, Mexico | |||
1865576 | 1865576 | 2022-03-10 | Mexico | Queretaro | 140436 | 6148 | 0 | 20.5888 | -100.3899 | 2022-03-11 04:20:50 | Queretaro, Mexico | |||
2140271 | 2140271 | 2022-03-09 | Mexico | Queretaro | 140362 | 6139 | 0 | 20.5888 | -100.3899 | 2022-03-10 04:20:48 | Queretaro, Mexico | |||
919782 | 919782 | 2022-03-08 | Mexico | Queretaro | 140248 | 6135 | 0 | 20.5888 | -100.3899 | 2022-03-09 04:20:59 | Queretaro, Mexico | |||
1548069 | 1548069 | 2022-03-07 | Mexico | Queretaro | 140135 | 6127 | 0 | 20.5888 | -100.3899 | 2022-03-08 04:20:54 | Queretaro, Mexico | |||
2199738 | 2199738 | 2022-03-06 | Mexico | Queretaro | 140129 | 6127 | 0 | 20.5888 | -100.3899 | 2022-03-07 04:20:47 | Queretaro, Mexico | |||
2092195 | 2092195 | 2022-03-05 | Mexico | Queretaro | 140000 | 6123 | 0 | 20.5888 | -100.3899 | 2022-03-06 04:20:49 | Queretaro, Mexico | |||
2665895 | 2665895 | 2022-03-04 | Mexico | Queretaro | 139871 | 6116 | 0 | 20.5888 | -100.3899 | 2022-03-05 04:21:10 | Queretaro, Mexico | |||
1644460 | 1644460 | 2022-03-03 | Mexico | Queretaro | 139762 | 6110 | 0 | 20.5888 | -100.3899 | 2022-03-04 04:21:09 | Queretaro, Mexico | |||
2525463 | 2525463 | 2022-03-02 | Mexico | Queretaro | 139551 | 6102 | 0 | 20.5888 | -100.3899 | 2022-03-03 04:21:01 | Queretaro, Mexico | |||
1992757 | 1992757 | 2022-03-01 | Mexico | Queretaro | 139551 | 6102 | 0 | 20.5888 | -100.3899 | 2022-03-02 04:21:07 | Queretaro, Mexico | |||
942931 | 942931 | 2022-02-28 | Mexico | Queretaro | 139348 | 6092 | 0 | 20.5888 | -100.3899 | 2022-03-01 04:21:09 | Queretaro, Mexico | |||
2733122 | 2733122 | 2022-02-27 | Mexico | Queretaro | 139289 | 6092 | 0 | 20.5888 | -100.3899 | 2022-02-28 04:21:05 | Queretaro, Mexico | |||
3046275 | 3046275 | 2022-02-26 | Mexico | Queretaro | 139194 | 6092 | 0 | 20.5888 | -100.3899 | 2022-02-27 04:21:04 | Queretaro, Mexico | |||
574930 | 574930 | 2022-02-25 | Mexico | Queretaro | 138965 | 6076 | 0 | 20.5888 | -100.3899 | 2022-02-26 04:21:12 | Queretaro, Mexico | |||
1511506 | 1511506 | 2022-02-24 | Mexico | Queretaro | 138577 | 6064 | 0 | 20.5888 | -100.3899 | 2022-02-25 04:21:11 | Queretaro, Mexico | |||
1057947 | 1057947 | 2022-02-23 | Mexico | Queretaro | 138161 | 6057 | 0 | 20.5888 | -100.3899 | 2022-02-24 04:21:14 | Queretaro, Mexico | |||
2446870 | 2446870 | 2022-02-22 | Mexico | Queretaro | 137466 | 6019 | 0 | 20.5888 | -100.3899 | 2022-02-23 04:21:09 | Queretaro, Mexico | |||
3718283 | 3718283 | 2022-02-21 | Mexico | Queretaro | 137210 | 6019 | 0 | 20.5888 | -100.3899 | 2022-02-22 04:21:01 | Queretaro, Mexico | |||
3912117 | 3912117 | 2022-02-20 | Mexico | Queretaro | 137210 | 6019 | 0 | 20.5888 | -100.3899 | 2022-02-21 04:21:05 | Queretaro, Mexico | |||
3875675 | 3875675 | 2022-02-19 | Mexico | Queretaro | 137074 | 6018 | 0 | 20.5888 | -100.3899 | 2022-02-20 04:21:00 | Queretaro, Mexico | |||
3855931 | 3855931 | 2022-02-18 | Mexico | Queretaro | 135832 | 6009 | 0 | 20.5888 | -100.3899 | 2022-02-19 04:21:11 | Queretaro, Mexico | |||
1298150 | 1298150 | 2022-02-17 | Mexico | Queretaro | 135832 | 6009 | 0 | 20.5888 | -100.3899 | 2022-02-18 04:21:04 | Queretaro, Mexico | |||
3820536 | 3820536 | 2022-02-16 | Mexico | Queretaro | 135272 | 5994 | 0 | 20.5888 | -100.3899 | 2022-02-17 04:20:56 | Queretaro, Mexico | |||
3671750 | 3671750 | 2022-02-15 | Mexico | Queretaro | 134423 | 5936 | 0 | 20.5888 | -100.3899 | 2022-02-16 04:21:10 | Queretaro, Mexico | |||
2641851 | 2641851 | 2022-02-14 | Mexico | Queretaro | 134185 | 5933 | 0 | 20.5888 | -100.3899 | 2022-02-15 04:21:09 | Queretaro, Mexico | |||
186168 | 186168 | 2022-02-13 | Mexico | Queretaro | 133981 | 5932 | 0 | 20.5888 | -100.3899 | 2022-02-14 04:20:51 | Queretaro, Mexico | |||
316014 | 316014 | 2022-02-12 | Mexico | Queretaro | 133981 | 5932 | 0 | 20.5888 | -100.3899 | 2022-02-13 04:21:00 | Queretaro, Mexico | |||
233340 | 233340 | 2022-02-11 | Mexico | Queretaro | 132363 | 5899 | 0 | 20.5888 | -100.3899 | 2022-02-12 04:21:06 | Queretaro, Mexico | |||
1464182 | 1464182 | 2022-02-10 | Mexico | Queretaro | 131449 | 5860 | 0 | 20.5888 | -100.3899 | 2022-02-11 04:21:09 | Queretaro, Mexico | |||
3074143 | 3074143 | 2022-02-09 | Mexico | Queretaro | 131449 | 5860 | 0 | 20.5888 | -100.3899 | 2022-02-10 04:21:14 | Queretaro, Mexico | |||
1362450 | 1362450 | 2022-02-08 | Mexico | Queretaro | 130998 | 5845 | 0 | 20.5888 | -100.3899 | 2022-02-09 04:21:04 | Queretaro, Mexico | |||
71188 | 71188 | 2022-02-07 | Mexico | Queretaro | 130855 | 5837 | 0 | 20.5888 | -100.3899 | 2022-02-08 04:21:15 | Queretaro, Mexico | |||
2012804 | 2012804 | 2022-02-06 | Mexico | Queretaro | 130625 | 5834 | 0 | 20.5888 | -100.3899 | 2022-02-07 04:21:05 | Queretaro, Mexico | |||
1294133 | 1294133 | 2022-02-05 | Mexico | Queretaro | 130415 | 5834 | 0 | 20.5888 | -100.3899 | 2022-02-06 04:21:00 | Queretaro, Mexico | |||
2327461 | 2327461 | 2022-02-04 | Mexico | Queretaro | 129621 | 5820 | 0 | 20.5888 | -100.3899 | 2022-02-05 04:21:05 | Queretaro, Mexico | |||
2474052 | 2474052 | 2022-02-03 | Mexico | Queretaro | 127859 | 5789 | 0 | 20.5888 | -100.3899 | 2022-02-04 04:21:10 | Queretaro, Mexico | |||
459477 | 459477 | 2022-02-02 | Mexico | Queretaro | 126794 | 5780 | 0 | 20.5888 | -100.3899 | 2022-02-03 04:21:21 | 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]);