johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Queretaro" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
427 | 427 | 2021-12-02 | Mexico | Queretaro | 99153 | 5610 | 0 | 20.5888 | -100.3899 | 2021-12-03 04:23:05 | Queretaro, Mexico | |||
4443 | 4443 | 2021-10-28 | Mexico | Queretaro | 96935 | 5498 | 0 | 20.5888 | -100.3899 | 2021-10-29 04:22:03 | Queretaro, Mexico | |||
16451 | 16451 | 2021-09-18 | Mexico | Queretaro | 90512 | 5114 | 0 | 20.5888 | -100.3899 | 2021-09-19 04:21:34 | Queretaro, Mexico | |||
24498 | 24498 | 2022-03-20 | Mexico | Queretaro | 140758 | 6173 | 0 | 20.5888 | -100.3899 | 2022-03-21 04:20:50 | Queretaro, Mexico | |||
28513 | 28513 | 2021-11-11 | Mexico | Queretaro | 98047 | 5553 | 0 | 20.5888 | -100.3899 | 2021-11-12 04:22:01 | Queretaro, Mexico | |||
32512 | 32512 | 2021-08-25 | Mexico | Queretaro | 82411 | 4799 | 0 | 20.5888 | -100.3899 | 2021-08-26 04:21:28 | Queretaro, Mexico | |||
43805 | 43805 | 2021-11-02 | Mexico | Queretaro | 97163 | 5516 | 0 | 20.5888 | -100.3899 | 2021-11-03 06:22:09 | Queretaro, Mexico | |||
63160 | 63160 | 2022-11-12 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-13 04:21:14 | Queretaro, Mexico | |||
67157 | 67157 | 2021-09-01 | Mexico | Queretaro | 85320 | 4913 | 0 | 20.5888 | -100.3899 | 2021-09-02 04:21:15 | Queretaro, Mexico | |||
71188 | 71188 | 2022-02-07 | Mexico | Queretaro | 130855 | 5837 | 0 | 20.5888 | -100.3899 | 2022-02-08 04:21:15 | Queretaro, Mexico | |||
87222 | 87222 | 2021-11-09 | Mexico | Queretaro | 97801 | 5548 | 0 | 20.5888 | -100.3899 | 2021-11-10 04:21:38 | Queretaro, Mexico | |||
91240 | 91240 | 2022-07-23 | Mexico | Queretaro | 165022 | 6235 | 0 | 20.5888 | -100.3899 | 2022-07-24 04:20:47 | Queretaro, Mexico | |||
99423 | 99423 | 2022-01-14 | Mexico | Queretaro | 106012 | 5677 | 0 | 20.5888 | -100.3899 | 2022-01-15 04:21:07 | Queretaro, Mexico | |||
103422 | 103422 | 2021-08-15 | Mexico | Queretaro | 78207 | 4693 | 0 | 20.5888 | -100.3899 | 2021-08-16 04:21:31 | Queretaro, Mexico | |||
114850 | 114850 | 2022-09-06 | Mexico | Queretaro | 176315 | 6313 | 0 | 20.5888 | -100.3899 | 2022-09-07 04:20:59 | Queretaro, Mexico | |||
126830 | 126830 | 2022-01-09 | Mexico | Queretaro | 103439 | 5675 | 0 | 20.5888 | -100.3899 | 2022-01-10 04:22:07 | Queretaro, Mexico | |||
130848 | 130848 | 2022-10-04 | Mexico | Queretaro | 177088 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-05 04:23:06 | Queretaro, Mexico | |||
138068 | 138068 | 2021-12-04 | Mexico | Queretaro | 99269 | 5614 | 0 | 20.5888 | -100.3899 | 2021-12-05 04:22:25 | Queretaro, Mexico | |||
142086 | 142086 | 2022-07-09 | Mexico | Queretaro | 153149 | 6225 | 0 | 20.5888 | -100.3899 | 2022-07-10 04:20:54 | Queretaro, Mexico | |||
150081 | 150081 | 2021-11-29 | Mexico | Queretaro | 99011 | 5599 | 0 | 20.5888 | -100.3899 | 2021-11-30 04:22:53 | Queretaro, Mexico | |||
158110 | 158110 | 2022-03-29 | Mexico | Queretaro | 140993 | 6182 | 0 | 20.5888 | -100.3899 | 2022-03-30 04:20:45 | Queretaro, Mexico | |||
162125 | 162125 | 2021-11-19 | Mexico | Queretaro | 98486 | 5574 | 0 | 20.5888 | -100.3899 | 2021-11-20 04:22:17 | Queretaro, Mexico | |||
166143 | 166143 | 2022-06-21 | Mexico | Queretaro | 144724 | 6218 | 0 | 20.5888 | -100.3899 | 2022-06-22 04:20:54 | Queretaro, Mexico | |||
178122 | 178122 | 2021-09-02 | Mexico | Queretaro | 85864 | 4933 | 0 | 20.5888 | -100.3899 | 2021-09-03 04:21:20 | Queretaro, Mexico | |||
186168 | 186168 | 2022-02-13 | Mexico | Queretaro | 133981 | 5932 | 0 | 20.5888 | -100.3899 | 2022-02-14 04:20:51 | Queretaro, Mexico | |||
198357 | 198357 | 2022-10-19 | Mexico | Queretaro | 177223 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-20 04:22:59 | Queretaro, Mexico | |||
218078 | 218078 | 2022-12-26 | Mexico | Queretaro | 179013 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-27 04:21:07 | Queretaro, Mexico | |||
222093 | 222093 | 2022-05-09 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-10 04:20:50 | Queretaro, Mexico | |||
229325 | 229325 | 2022-05-31 | Mexico | Queretaro | 142675 | 6214 | 0 | 20.5888 | -100.3899 | 2022-06-01 04:20:55 | Queretaro, Mexico | |||
233340 | 233340 | 2022-02-11 | Mexico | Queretaro | 132363 | 5899 | 0 | 20.5888 | -100.3899 | 2022-02-12 04:21:06 | Queretaro, Mexico | |||
245365 | 245365 | 2021-08-17 | Mexico | Queretaro | 78730 | 4727 | 0 | 20.5888 | -100.3899 | 2021-08-18 04:21:35 | Queretaro, Mexico | |||
249379 | 249379 | 2021-09-04 | Mexico | Queretaro | 86907 | 4962 | 0 | 20.5888 | -100.3899 | 2021-09-05 04:21:33 | Queretaro, Mexico | |||
253412 | 253412 | 2022-09-08 | Mexico | Queretaro | 176315 | 6313 | 0 | 20.5888 | -100.3899 | 2022-09-09 04:21:11 | Queretaro, Mexico | |||
257428 | 257428 | 2022-12-10 | Mexico | Queretaro | 177868 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-11 04:20:50 | Queretaro, Mexico | |||
261630 | 261630 | 2022-03-15 | Mexico | Queretaro | 140565 | 6151 | 0 | 20.5888 | -100.3899 | 2022-03-16 04:20:50 | Queretaro, Mexico | |||
276280 | 276280 | 2021-11-03 | Mexico | Queretaro | 97242 | 5517 | 0 | 20.5888 | -100.3899 | 2021-11-04 04:22:20 | Queretaro, Mexico | |||
288093 | 288093 | 2021-10-31 | Mexico | Queretaro | 97145 | 5513 | 0 | 20.5888 | -100.3899 | 2021-11-01 04:22:01 | Queretaro, Mexico | |||
292111 | 292111 | 2022-11-15 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-16 04:21:09 | Queretaro, Mexico | |||
303966 | 303966 | 2022-04-16 | Mexico | Queretaro | 141840 | 6196 | 0 | 20.5888 | -100.3899 | 2022-04-17 04:20:59 | Queretaro, Mexico | |||
307983 | 307983 | 2022-12-13 | Mexico | Queretaro | 178013 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-14 04:21:04 | Queretaro, Mexico | |||
311999 | 311999 | 2022-11-13 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-14 04:21:09 | Queretaro, Mexico | |||
316014 | 316014 | 2022-02-12 | Mexico | Queretaro | 133981 | 5932 | 0 | 20.5888 | -100.3899 | 2022-02-13 04:21:00 | Queretaro, Mexico | |||
320031 | 320031 | 2022-10-30 | Mexico | Queretaro | 177305 | 6343 | 0 | 20.5888 | -100.3899 | 2022-10-31 04:21:36 | Queretaro, Mexico | |||
328005 | 328005 | 2022-12-27 | Mexico | Queretaro | 179157 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-28 04:21:04 | Queretaro, Mexico | |||
336034 | 336034 | 2022-03-18 | Mexico | Queretaro | 140703 | 6168 | 0 | 20.5888 | -100.3899 | 2022-03-19 04:20:47 | Queretaro, Mexico | |||
348395 | 348395 | 2022-12-14 | Mexico | Queretaro | 178013 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-15 04:20:58 | Queretaro, Mexico | |||
356424 | 356424 | 2022-03-11 | Mexico | Queretaro | 140436 | 6148 | 0 | 20.5888 | -100.3899 | 2022-03-12 04:20:50 | Queretaro, Mexico | |||
360440 | 360440 | 2022-05-07 | Mexico | Queretaro | 142048 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-08 04:20:49 | Queretaro, Mexico | |||
372295 | 372295 | 2022-09-13 | Mexico | Queretaro | 176470 | 6320 | 0 | 20.5888 | -100.3899 | 2022-09-14 04:20:44 | Queretaro, Mexico | |||
384322 | 384322 | 2022-09-23 | Mexico | Queretaro | 176770 | 6328 | 0 | 20.5888 | -100.3899 | 2022-09-24 04:21:40 | Queretaro, Mexico | |||
396363 | 396363 | 2022-10-07 | Mexico | Queretaro | 177160 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-08 04:22:56 | Queretaro, Mexico | |||
404391 | 404391 | 2021-12-07 | Mexico | Queretaro | 99307 | 5615 | 0 | 20.5888 | -100.3899 | 2021-12-08 04:22:46 | Queretaro, Mexico | |||
419434 | 419434 | 2022-09-18 | Mexico | Queretaro | 176603 | 6325 | 0 | 20.5888 | -100.3899 | 2022-09-19 04:21:49 | Queretaro, Mexico | |||
423448 | 423448 | 2021-10-10 | Mexico | Queretaro | 94880 | 5380 | 0 | 20.5888 | -100.3899 | 2021-10-11 04:21:31 | Queretaro, Mexico | |||
431456 | 431456 | 2022-11-03 | Mexico | Queretaro | 177320 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-04 04:22:11 | Queretaro, Mexico | |||
443452 | 443452 | 2021-10-20 | Mexico | Queretaro | 96060 | 5460 | 0 | 20.5888 | -100.3899 | 2021-10-21 04:21:18 | Queretaro, Mexico | |||
447468 | 447468 | 2021-11-17 | Mexico | Queretaro | 98422 | 5572 | 0 | 20.5888 | -100.3899 | 2021-11-18 04:21:33 | Queretaro, Mexico | |||
451486 | 451486 | 2022-12-21 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-22 04:20:56 | Queretaro, Mexico | |||
459477 | 459477 | 2022-02-02 | Mexico | Queretaro | 126794 | 5780 | 0 | 20.5888 | -100.3899 | 2022-02-03 04:21:21 | Queretaro, Mexico | |||
463494 | 463494 | 2022-05-02 | Mexico | Queretaro | 142052 | 6197 | 0 | 20.5888 | -100.3899 | 2022-05-03 04:21:00 | Queretaro, Mexico | |||
467509 | 467509 | 2021-10-07 | Mexico | Queretaro | 94502 | 5363 | 0 | 20.5888 | -100.3899 | 2021-10-08 04:21:25 | Queretaro, Mexico | |||
475541 | 475541 | 2022-06-26 | Mexico | Queretaro | 146009 | 6221 | 0 | 20.5888 | -100.3899 | 2022-06-27 04:21:00 | Queretaro, Mexico | |||
479689 | 479689 | 2022-11-08 | Mexico | Queretaro | 177349 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-09 04:21:22 | Queretaro, Mexico | |||
487719 | 487719 | 2022-11-25 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-26 04:21:11 | Queretaro, Mexico | |||
491733 | 491733 | 2021-10-14 | Mexico | Queretaro | 95449 | 5413 | 0 | 20.5888 | -100.3899 | 2021-10-15 04:21:26 | Queretaro, Mexico | |||
495749 | 495749 | 2021-11-06 | Mexico | Queretaro | 97624 | 5541 | 0 | 20.5888 | -100.3899 | 2021-11-07 04:21:53 | Queretaro, Mexico | |||
499766 | 499766 | 2022-04-02 | Mexico | Queretaro | 141068 | 6188 | 0 | 20.5888 | -100.3899 | 2022-04-03 04:20:48 | Queretaro, Mexico | |||
503783 | 503783 | 2022-12-17 | Mexico | Queretaro | 178263 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-18 04:21:03 | Queretaro, Mexico | |||
507780 | 507780 | 2021-08-14 | Mexico | Queretaro | 78207 | 4693 | 0 | 20.5888 | -100.3899 | 2021-08-15 04:21:41 | Queretaro, Mexico | |||
511794 | 511794 | 2021-08-19 | Mexico | Queretaro | 80053 | 4751 | 0 | 20.5888 | -100.3899 | 2021-08-20 04:21:33 | Queretaro, Mexico | |||
515827 | 515827 | 2022-10-15 | Mexico | Queretaro | 177221 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-16 04:22:39 | Queretaro, Mexico | |||
534833 | 534833 | 2021-10-27 | Mexico | Queretaro | 96699 | 5482 | 0 | 20.5888 | -100.3899 | 2021-10-28 04:22:08 | Queretaro, Mexico | |||
538851 | 538851 | 2022-10-26 | Mexico | Queretaro | 177283 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-27 04:22:01 | Queretaro, Mexico | |||
542867 | 542867 | 2022-12-15 | Mexico | Queretaro | 178062 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-16 04:21:01 | Queretaro, Mexico | |||
550871 | 550871 | 2021-12-08 | Mexico | Queretaro | 99350 | 5621 | 0 | 20.5888 | -100.3899 | 2021-12-09 04:22:49 | Queretaro, Mexico | |||
554887 | 554887 | 2022-01-16 | Mexico | Queretaro | 108713 | 5688 | 0 | 20.5888 | -100.3899 | 2022-01-17 04:21:08 | Queretaro, Mexico | |||
558905 | 558905 | 2022-06-16 | Mexico | Queretaro | 144152 | 6215 | 0 | 20.5888 | -100.3899 | 2022-06-17 04:20:56 | Queretaro, Mexico | |||
567201 | 567201 | 2021-10-29 | Mexico | Queretaro | 97036 | 5502 | 0 | 20.5888 | -100.3899 | 2021-10-30 04:22:03 | Queretaro, Mexico | |||
574930 | 574930 | 2022-02-25 | Mexico | Queretaro | 138965 | 6076 | 0 | 20.5888 | -100.3899 | 2022-02-26 04:21:12 | Queretaro, Mexico | |||
589724 | 589724 | 2021-08-08 | Mexico | Queretaro | 75756 | 4625 | 0 | 20.5888 | -100.3899 | 2021-08-09 04:21:24 | Queretaro, Mexico | |||
593757 | 593757 | 2022-07-01 | Mexico | Queretaro | 147966 | 6222 | 0 | 20.5888 | -100.3899 | 2022-07-02 04:21:16 | Queretaro, Mexico | |||
597771 | 597771 | 2021-10-19 | Mexico | Queretaro | 95928 | 5452 | 0 | 20.5888 | -100.3899 | 2021-10-20 04:21:00 | Queretaro, Mexico | |||
601787 | 601787 | 2021-09-23 | Mexico | Queretaro | 92039 | 5207 | 0 | 20.5888 | -100.3899 | 2021-09-24 04:21:44 | Queretaro, Mexico | |||
617961 | 617961 | 2022-11-05 | Mexico | Queretaro | 177339 | 6344 | 0 | 20.5888 | -100.3899 | 2022-11-06 04:21:24 | Queretaro, Mexico | |||
621977 | 621977 | 2022-05-22 | Mexico | Queretaro | 142402 | 6211 | 0 | 20.5888 | -100.3899 | 2022-05-26 04:20:50 | Queretaro, Mexico | |||
630007 | 630007 | 2022-07-12 | Mexico | Queretaro | 154769 | 6226 | 0 | 20.5888 | -100.3899 | 2022-07-13 04:20:58 | Queretaro, Mexico | |||
634021 | 634021 | 2021-10-13 | Mexico | Queretaro | 95297 | 5407 | 0 | 20.5888 | -100.3899 | 2021-10-14 04:21:29 | Queretaro, Mexico | |||
642034 | 642034 | 2021-09-07 | Mexico | Queretaro | 87610 | 4998 | 0 | 20.5888 | -100.3899 | 2021-09-08 04:21:31 | Queretaro, Mexico | |||
650062 | 650062 | 2021-08-09 | Mexico | Queretaro | 75823 | 4625 | 0 | 20.5888 | -100.3899 | 2021-08-10 04:21:27 | Queretaro, Mexico | |||
654093 | 654093 | 2021-10-22 | Mexico | Queretaro | 96354 | 5472 | 0 | 20.5888 | -100.3899 | 2021-10-23 04:21:32 | Queretaro, Mexico | |||
658412 | 658412 | 2022-05-13 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-14 04:20:48 | Queretaro, Mexico | |||
670398 | 670398 | 2022-07-21 | Mexico | Queretaro | 163174 | 6232 | 0 | 20.5888 | -100.3899 | 2022-07-22 04:21:15 | Queretaro, Mexico | |||
674414 | 674414 | 2022-07-30 | Mexico | Queretaro | 167753 | 6236 | 0 | 20.5888 | -100.3899 | 2022-07-31 04:21:02 | Queretaro, Mexico | |||
682438 | 682438 | 2021-10-24 | Mexico | Queretaro | 96499 | 5476 | 0 | 20.5888 | -100.3899 | 2021-10-25 04:22:31 | Queretaro, Mexico | |||
686454 | 686454 | 2021-11-13 | Mexico | Queretaro | 98173 | 5553 | 0 | 20.5888 | -100.3899 | 2021-11-14 04:21:31 | Queretaro, Mexico | |||
690472 | 690472 | 2022-12-23 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-24 04:21:02 | Queretaro, Mexico | |||
694487 | 694487 | 2022-03-17 | Mexico | Queretaro | 140703 | 6168 | 0 | 20.5888 | -100.3899 | 2022-03-18 04:20:55 | Queretaro, Mexico | |||
698502 | 698502 | 2021-11-04 | Mexico | Queretaro | 97312 | 5519 | 0 | 20.5888 | -100.3899 | 2021-11-05 04:21:54 | Queretaro, Mexico | |||
706532 | 706532 | 2021-09-29 | Mexico | Queretaro | 93191 | 5266 | 0 | 20.5888 | -100.3899 | 2021-09-30 04:21:20 | Queretaro, Mexico | |||
710549 | 710549 | 2022-11-01 | Mexico | Queretaro | 177305 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-02 04:22:09 | 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]);