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 country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- …
province_or_state 1
- Queretaro · 954 ✖
country_or_region 1
- Mexico · 954 ✖
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 | |||
8426 | 8426 | 2020-10-25 | Mexico | Queretaro | 12777 | 1162 | 9905 | 1710 | 20.5888 | -100.3899 | 2020-10-26 04:25:02 | Queretaro, Mexico | ||
12435 | 12435 | 2021-01-26 | Mexico | Queretaro | 44378 | 2614 | 0 | 41764 | 20.5888 | -100.3899 | 2021-01-27 05:23:41 | Queretaro, Mexico | ||
16451 | 16451 | 2021-09-18 | Mexico | Queretaro | 90512 | 5114 | 0 | 20.5888 | -100.3899 | 2021-09-19 04:21:34 | Queretaro, Mexico | |||
20466 | 20466 | 2021-05-28 | Mexico | Queretaro | 69056 | 4320 | 0 | 64736 | 20.5888 | -100.3899 | 2021-05-29 04:20:41 | 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 | |||
36525 | 36525 | 2021-04-12 | Mexico | Queretaro | 66308 | 3994 | 0 | 62314 | 20.5888 | -100.3899 | 2021-04-13 04:20:37 | Queretaro, Mexico | ||
43805 | 43805 | 2021-11-02 | Mexico | Queretaro | 97163 | 5516 | 0 | 20.5888 | -100.3899 | 2021-11-03 06:22:09 | Queretaro, Mexico | |||
50887 | 50887 | 2021-05-29 | Mexico | Queretaro | 69137 | 4376 | 0 | 64761 | 20.5888 | -100.3899 | 2021-05-30 04:20:55 | Queretaro, Mexico | ||
54900 | 54900 | 2021-03-07 | Mexico | Queretaro | 58912 | 3505 | 0 | 55407 | 20.5888 | -100.3899 | 2021-03-08 05:24:48 | 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 | ||
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 | |||
75184 | 75184 | 2020-12-03 | Mexico | Queretaro | 23076 | 1468 | 0 | 21608 | 20.5888 | -100.3899 | 2020-12-04 05:27:27 | 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 | ||
83190 | 83190 | 2021-05-25 | Mexico | Queretaro | 68887 | 4292 | 0 | 64595 | 20.5888 | -100.3899 | 2021-05-26 04:20:35 | 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 | |||
98442 | 98442 | 2020-08-04 | Mexico | Queretaro | 3882 | 513 | 2932 | 437 | 20.5888 | -100.3899 | 2020-08-05 04:34:43 | 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 | |||
107547 | 107547 | 2021-06-19 | Mexico | Queretaro | 69532 | 4452 | 0 | 65080 | 20.5888 | -100.3899 | 2021-06-20 04:21:48 | Queretaro, Mexico | ||
114850 | 114850 | 2022-09-06 | Mexico | Queretaro | 176315 | 6313 | 0 | 20.5888 | -100.3899 | 2022-09-07 04:20:59 | 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 | ||
122799 | 122799 | 2020-11-18 | Mexico | Queretaro | 17532 | 1279 | 0 | 16253 | 20.5888 | -100.3899 | 2020-11-19 05:25:23 | 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 | |||
146066 | 146066 | 2020-08-15 | Mexico | Queretaro | 4797 | 591 | 3685 | 521 | 20.5888 | -100.3899 | 2020-08-16 04:27:42 | Queretaro, Mexico | ||
150081 | 150081 | 2021-11-29 | Mexico | Queretaro | 99011 | 5599 | 0 | 20.5888 | -100.3899 | 2021-11-30 04:22:53 | 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 | ||
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 | |||
170139 | 170139 | 2021-04-16 | Mexico | Queretaro | 67117 | 4028 | 0 | 63089 | 20.5888 | -100.3899 | 2021-04-17 04:20:40 | 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 | ||
178122 | 178122 | 2021-09-02 | Mexico | Queretaro | 85864 | 4933 | 0 | 20.5888 | -100.3899 | 2021-09-03 04:21:20 | Queretaro, Mexico | |||
182135 | 182135 | 2021-02-21 | Mexico | Queretaro | 54750 | 3277 | 0 | 51473 | 20.5888 | -100.3899 | 2021-02-22 05:24:21 | Queretaro, Mexico | ||
186168 | 186168 | 2022-02-13 | Mexico | Queretaro | 133981 | 5932 | 0 | 20.5888 | -100.3899 | 2022-02-14 04:20:51 | 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 | ||
194161 | 194161 | 2020-08-31 | Mexico | Queretaro | 6320 | 721 | 4963 | 636 | 20.5888 | -100.3899 | 2020-09-01 04:28:31 | Queretaro, Mexico | ||
198357 | 198357 | 2022-10-19 | Mexico | Queretaro | 177223 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-20 04:22:59 | 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 | ||
206348 | 206348 | 2020-08-19 | Mexico | Queretaro | 5158 | 620 | 3952 | 586 | 20.5888 | -100.3899 | 2020-08-20 04:27:43 | 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 | ||
217304 | 217304 | 2020-06-08 | Mexico | Queretaro | 1218 | 158 | 816 | 244 | 20.5888 | -100.3899 | 2020-06-09 03:33:03 | 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 | |||
237336 | 237336 | 2021-01-18 | Mexico | Queretaro | 38615 | 2375 | 0 | 36240 | 20.5888 | -100.3899 | 2021-01-19 05:22:15 | Queretaro, Mexico | ||
241350 | 241350 | 2021-04-02 | Mexico | Queretaro | 64695 | 3886 | 0 | 60809 | 20.5888 | -100.3899 | 2021-04-03 04:20:44 | 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 | |||
268376 | 268376 | 2020-05-21 | Mexico | Queretaro | 592 | 61 | 247 | 284 | 20.5888 | -100.3899 | 2020-05-22 02:36:51 | 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 | ||
276280 | 276280 | 2021-11-03 | Mexico | Queretaro | 97242 | 5517 | 0 | 20.5888 | -100.3899 | 2021-11-04 04:22:20 | Queretaro, Mexico | |||
280278 | 280278 | 2021-02-24 | Mexico | Queretaro | 55689 | 3339 | 0 | 52350 | 20.5888 | -100.3899 | 2021-02-25 05:24:57 | Queretaro, Mexico | ||
287315 | 287315 | 2020-06-15 | Mexico | Queretaro | 1490 | 203 | 1019 | 268 | 20.5888 | -100.3899 | 2020-06-16 04:33:09 | 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 | |||
296108 | 296108 | 2021-07-15 | Mexico | Queretaro | 70991 | 4502 | 0 | 66489 | 20.5888 | -100.3899 | 2021-07-16 04:21:22 | Queretaro, Mexico | ||
303187 | 303187 | 2020-07-01 | Mexico | Queretaro | 2012 | 293 | 1472 | 247 | 20.5888 | -100.3899 | 2020-07-02 04:33:46 | 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 | |||
327129 | 327129 | 2020-07-20 | Mexico | Queretaro | 2959 | 409 | 2159 | 391 | 20.5888 | -100.3899 | 2020-07-21 04:38:46 | Queretaro, Mexico | ||
328005 | 328005 | 2022-12-27 | Mexico | Queretaro | 179157 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-28 04:21:04 | Queretaro, Mexico | |||
332002 | 332002 | 2021-08-04 | Mexico | Queretaro | 74460 | 4592 | 0 | 69868 | 20.5888 | -100.3899 | 2021-08-05 04:21:51 | Queretaro, Mexico | ||
336034 | 336034 | 2022-03-18 | Mexico | Queretaro | 140703 | 6168 | 0 | 20.5888 | -100.3899 | 2022-03-19 04:20:47 | Queretaro, Mexico | |||
340370 | 340370 | 2021-02-03 | Mexico | Queretaro | 48449 | 2878 | 0 | 45571 | 20.5888 | -100.3899 | 2021-02-04 05:22:26 | 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 | ||
348395 | 348395 | 2022-12-14 | Mexico | Queretaro | 178013 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-15 04:20:58 | Queretaro, Mexico | |||
352391 | 352391 | 2021-03-11 | Mexico | Queretaro | 60160 | 3558 | 0 | 56602 | 20.5888 | -100.3899 | 2021-03-12 05:26:50 | 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 | |||
367535 | 367535 | 2020-07-16 | Mexico | Queretaro | 2741 | 390 | 2003 | 348 | 20.5888 | -100.3899 | 2020-07-17 04:34:50 | 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 | ||
372295 | 372295 | 2022-09-13 | Mexico | Queretaro | 176470 | 6320 | 0 | 20.5888 | -100.3899 | 2022-09-14 04:20:44 | 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 | ||
380288 | 380288 | 2021-04-30 | Mexico | Queretaro | 68275 | 4165 | 0 | 64110 | 20.5888 | -100.3899 | 2021-05-01 04:20:47 | Queretaro, Mexico | ||
384322 | 384322 | 2022-09-23 | Mexico | Queretaro | 176770 | 6328 | 0 | 20.5888 | -100.3899 | 2022-09-24 04:21:40 | Queretaro, Mexico | |||
388318 | 388318 | 2021-04-04 | Mexico | Queretaro | 64936 | 3897 | 0 | 61039 | 20.5888 | -100.3899 | 2021-04-05 04:20:35 | 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 | ||
396363 | 396363 | 2022-10-07 | Mexico | Queretaro | 177160 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-08 04:22:56 | Queretaro, Mexico | |||
400360 | 400360 | 2021-06-29 | Mexico | Queretaro | 69764 | 4468 | 0 | 65296 | 20.5888 | -100.3899 | 2021-06-30 04:21:41 | Queretaro, Mexico | ||
404391 | 404391 | 2021-12-07 | Mexico | Queretaro | 99307 | 5615 | 0 | 20.5888 | -100.3899 | 2021-12-08 04:22:46 | Queretaro, Mexico | |||
408390 | 408390 | 2021-07-28 | Mexico | Queretaro | 73491 | 4547 | 0 | 68944 | 20.5888 | -100.3899 | 2021-07-29 04:21:33 | 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 | ||
419434 | 419434 | 2022-09-18 | Mexico | Queretaro | 176603 | 6325 | 0 | 20.5888 | -100.3899 | 2022-09-19 04:21:49 | 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]);