johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Aguascalientes" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
406 | 406 | 2021-12-02 | Mexico | Aguascalientes | 37220 | 2941 | 0 | 21.8853 | -102.2916 | 2021-12-03 04:23:05 | Aguascalientes, Mexico | |||
4422 | 4422 | 2021-10-28 | Mexico | Aguascalientes | 35722 | 2853 | 0 | 21.8853 | -102.2916 | 2021-10-29 04:22:03 | Aguascalientes, Mexico | |||
8405 | 8405 | 2020-10-25 | Mexico | Aguascalientes | 9040 | 810 | 7310 | 920 | 21.8853 | -102.2916 | 2020-10-26 04:25:02 | Aguascalientes, Mexico | ||
12414 | 12414 | 2021-01-26 | Mexico | Aguascalientes | 20172 | 1624 | 0 | 18548 | 21.8853 | -102.2916 | 2021-01-27 05:23:41 | Aguascalientes, Mexico | ||
16430 | 16430 | 2021-09-18 | Mexico | Aguascalientes | 32664 | 2676 | 0 | 21.8853 | -102.2916 | 2021-09-19 04:21:34 | Aguascalientes, Mexico | |||
20445 | 20445 | 2021-05-28 | Mexico | Aguascalientes | 26492 | 2418 | 0 | 24074 | 21.8853 | -102.2916 | 2021-05-29 04:20:41 | Aguascalientes, Mexico | ||
24477 | 24477 | 2022-03-20 | Mexico | Aguascalientes | 63293 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-21 04:20:50 | Aguascalientes, Mexico | |||
28492 | 28492 | 2021-11-11 | Mexico | Aguascalientes | 36280 | 2891 | 0 | 21.8853 | -102.2916 | 2021-11-12 04:22:01 | Aguascalientes, Mexico | |||
32491 | 32491 | 2021-08-25 | Mexico | Aguascalientes | 30389 | 2572 | 0 | 21.8853 | -102.2916 | 2021-08-26 04:21:28 | Aguascalientes, Mexico | |||
36504 | 36504 | 2021-04-12 | Mexico | Aguascalientes | 25353 | 2273 | 0 | 23080 | 21.8853 | -102.2916 | 2021-04-13 04:20:37 | Aguascalientes, Mexico | ||
43784 | 43784 | 2021-11-02 | Mexico | Aguascalientes | 35846 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-03 06:22:09 | Aguascalientes, Mexico | |||
50866 | 50866 | 2021-05-29 | Mexico | Aguascalientes | 26501 | 2418 | 0 | 24083 | 21.8853 | -102.2916 | 2021-05-30 04:20:55 | Aguascalientes, Mexico | ||
54879 | 54879 | 2021-03-07 | Mexico | Aguascalientes | 23462 | 2035 | 0 | 21427 | 21.8853 | -102.2916 | 2021-03-08 05:24:48 | Aguascalientes, Mexico | ||
62397 | 62397 | 2020-07-23 | Mexico | Aguascalientes | 3620 | 224 | 2889 | 507 | 21.8853 | -102.2916 | 2020-07-24 03:34:53 | Aguascalientes, Mexico | ||
63139 | 63139 | 2022-11-12 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-13 04:21:14 | Aguascalientes, Mexico | |||
67136 | 67136 | 2021-09-01 | Mexico | Aguascalientes | 31186 | 2611 | 0 | 21.8853 | -102.2916 | 2021-09-02 04:21:15 | Aguascalientes, Mexico | |||
71167 | 71167 | 2022-02-07 | Mexico | Aguascalientes | 53290 | 3282 | 0 | 21.8853 | -102.2916 | 2022-02-08 04:21:15 | Aguascalientes, Mexico | |||
75163 | 75163 | 2020-12-03 | Mexico | Aguascalientes | 14083 | 1123 | 0 | 12960 | 21.8853 | -102.2916 | 2020-12-04 05:27:27 | Aguascalientes, Mexico | ||
79161 | 79161 | 2020-10-14 | Mexico | Aguascalientes | 8054 | 725 | 6741 | 588 | 21.8853 | -102.2916 | 2020-10-15 04:24:28 | Aguascalientes, Mexico | ||
83169 | 83169 | 2021-05-25 | Mexico | Aguascalientes | 26454 | 2409 | 0 | 24045 | 21.8853 | -102.2916 | 2021-05-26 04:20:35 | Aguascalientes, Mexico | ||
87201 | 87201 | 2021-11-09 | Mexico | Aguascalientes | 36148 | 2888 | 0 | 21.8853 | -102.2916 | 2021-11-10 04:21:38 | Aguascalientes, Mexico | |||
91219 | 91219 | 2022-07-23 | Mexico | Aguascalientes | 77059 | 3526 | 0 | 21.8853 | -102.2916 | 2022-07-24 04:20:47 | Aguascalientes, Mexico | |||
98074 | 98074 | 2020-08-04 | Mexico | Aguascalientes | 4229 | 269 | 3600 | 360 | 21.8853 | -102.2916 | 2020-08-05 04:34:43 | Aguascalientes, Mexico | ||
99402 | 99402 | 2022-01-14 | Mexico | Aguascalientes | 42387 | 3070 | 0 | 21.8853 | -102.2916 | 2022-01-15 04:21:07 | Aguascalientes, Mexico | |||
103401 | 103401 | 2021-08-15 | Mexico | Aguascalientes | 29239 | 2529 | 0 | 21.8853 | -102.2916 | 2021-08-16 04:21:31 | Aguascalientes, Mexico | |||
107526 | 107526 | 2021-06-19 | Mexico | Aguascalientes | 26688 | 2456 | 0 | 24232 | 21.8853 | -102.2916 | 2021-06-20 04:21:48 | Aguascalientes, Mexico | ||
114829 | 114829 | 2022-09-06 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-07 04:20:59 | Aguascalientes, Mexico | |||
121667 | 121667 | 2020-07-19 | Mexico | Aguascalientes | 3417 | 207 | 2654 | 556 | 21.8853 | -102.2916 | 2020-07-20 05:34:40 | Aguascalientes, Mexico | ||
122778 | 122778 | 2020-11-18 | Mexico | Aguascalientes | 11235 | 962 | 0 | 10273 | 21.8853 | -102.2916 | 2020-11-19 05:25:23 | Aguascalientes, Mexico | ||
126809 | 126809 | 2022-01-09 | Mexico | Aguascalientes | 41186 | 3048 | 0 | 21.8853 | -102.2916 | 2022-01-10 04:22:07 | Aguascalientes, Mexico | |||
130827 | 130827 | 2022-10-04 | Mexico | Aguascalientes | 84529 | 3585 | 0 | 21.8853 | -102.2916 | 2022-10-05 04:23:06 | Aguascalientes, Mexico | |||
138047 | 138047 | 2021-12-04 | Mexico | Aguascalientes | 37363 | 2946 | 0 | 21.8853 | -102.2916 | 2021-12-05 04:22:25 | Aguascalientes, Mexico | |||
142065 | 142065 | 2022-07-09 | Mexico | Aguascalientes | 72104 | 3522 | 0 | 21.8853 | -102.2916 | 2022-07-10 04:20:54 | Aguascalientes, Mexico | |||
146045 | 146045 | 2020-08-15 | Mexico | Aguascalientes | 4771 | 324 | 4087 | 360 | 21.8853 | -102.2916 | 2020-08-16 04:27:42 | Aguascalientes, Mexico | ||
150060 | 150060 | 2021-11-29 | Mexico | Aguascalientes | 37083 | 2929 | 0 | 21.8853 | -102.2916 | 2021-11-30 04:22:53 | Aguascalientes, Mexico | |||
154057 | 154057 | 2021-01-08 | Mexico | Aguascalientes | 17612 | 1428 | 0 | 16184 | 21.8853 | -102.2916 | 2021-01-09 05:22:18 | Aguascalientes, Mexico | ||
158089 | 158089 | 2022-03-29 | Mexico | Aguascalientes | 63836 | 3485 | 0 | 21.8853 | -102.2916 | 2022-03-30 04:20:45 | Aguascalientes, Mexico | |||
162104 | 162104 | 2021-11-19 | Mexico | Aguascalientes | 36579 | 2902 | 0 | 21.8853 | -102.2916 | 2021-11-20 04:22:17 | Aguascalientes, Mexico | |||
166122 | 166122 | 2022-06-21 | Mexico | Aguascalientes | 68954 | 3519 | 0 | 21.8853 | -102.2916 | 2022-06-22 04:20:54 | Aguascalientes, Mexico | |||
170118 | 170118 | 2021-04-16 | Mexico | Aguascalientes | 25605 | 2309 | 0 | 23296 | 21.8853 | -102.2916 | 2021-04-17 04:20:40 | Aguascalientes, Mexico | ||
176985 | 176985 | 2020-07-27 | Mexico | Aguascalientes | 3777 | 243 | 3122 | 412 | 21.8853 | -102.2916 | 2020-07-28 04:58:43 | Aguascalientes, Mexico | ||
178101 | 178101 | 2021-09-02 | Mexico | Aguascalientes | 31341 | 2621 | 0 | 21.8853 | -102.2916 | 2021-09-03 04:21:20 | Aguascalientes, Mexico | |||
182114 | 182114 | 2021-02-21 | Mexico | Aguascalientes | 22621 | 1950 | 0 | 20671 | 21.8853 | -102.2916 | 2021-02-22 05:24:21 | Aguascalientes, Mexico | ||
186147 | 186147 | 2022-02-13 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-14 04:20:51 | Aguascalientes, Mexico | |||
190143 | 190143 | 2021-01-11 | Mexico | Aguascalientes | 17752 | 1447 | 0 | 16305 | 21.8853 | -102.2916 | 2021-01-12 05:22:15 | Aguascalientes, Mexico | ||
194140 | 194140 | 2020-08-31 | Mexico | Aguascalientes | 5631 | 405 | 4847 | 379 | 21.8853 | -102.2916 | 2020-09-01 04:28:31 | Aguascalientes, Mexico | ||
198336 | 198336 | 2022-10-19 | Mexico | Aguascalientes | 84615 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-20 04:22:59 | Aguascalientes, Mexico | |||
202330 | 202330 | 2020-12-25 | Mexico | Aguascalientes | 16499 | 1330 | 0 | 15169 | 21.8853 | -102.2916 | 2020-12-26 05:22:28 | Aguascalientes, Mexico | ||
206327 | 206327 | 2020-08-19 | Mexico | Aguascalientes | 4928 | 347 | 4206 | 375 | 21.8853 | -102.2916 | 2020-08-20 04:27:43 | Aguascalientes, Mexico | ||
210314 | 210314 | 2020-10-29 | Mexico | Aguascalientes | 9450 | 842 | 7719 | 889 | 21.8853 | -102.2916 | 2020-10-30 04:24:49 | Aguascalientes, Mexico | ||
216980 | 216980 | 2020-06-08 | Mexico | Aguascalientes | 1160 | 53 | 792 | 315 | 21.8853 | -102.2916 | 2020-06-09 03:33:03 | Aguascalientes, Mexico | ||
218057 | 218057 | 2022-12-26 | Mexico | Aguascalientes | 85637 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-27 04:21:07 | Aguascalientes, Mexico | |||
222072 | 222072 | 2022-05-09 | Mexico | Aguascalientes | 66137 | 3502 | 0 | 21.8853 | -102.2916 | 2022-05-10 04:20:50 | Aguascalientes, Mexico | |||
229304 | 229304 | 2022-05-31 | Mexico | Aguascalientes | 67535 | 3509 | 0 | 21.8853 | -102.2916 | 2022-06-01 04:20:55 | Aguascalientes, Mexico | |||
233319 | 233319 | 2022-02-11 | Mexico | Aguascalientes | 54439 | 3334 | 0 | 21.8853 | -102.2916 | 2022-02-12 04:21:06 | Aguascalientes, Mexico | |||
237315 | 237315 | 2021-01-18 | Mexico | Aguascalientes | 18519 | 1498 | 0 | 17021 | 21.8853 | -102.2916 | 2021-01-19 05:22:15 | Aguascalientes, Mexico | ||
241329 | 241329 | 2021-04-02 | Mexico | Aguascalientes | 24936 | 2162 | 0 | 22774 | 21.8853 | -102.2916 | 2021-04-03 04:20:44 | Aguascalientes, Mexico | ||
245344 | 245344 | 2021-08-17 | Mexico | Aguascalientes | 29348 | 2534 | 0 | 21.8853 | -102.2916 | 2021-08-18 04:21:35 | Aguascalientes, Mexico | |||
249358 | 249358 | 2021-09-04 | Mexico | Aguascalientes | 31675 | 2639 | 0 | 21.8853 | -102.2916 | 2021-09-05 04:21:33 | Aguascalientes, Mexico | |||
253391 | 253391 | 2022-09-08 | Mexico | Aguascalientes | 84093 | 3558 | 0 | 21.8853 | -102.2916 | 2022-09-09 04:21:11 | Aguascalientes, Mexico | |||
257407 | 257407 | 2022-12-10 | Mexico | Aguascalientes | 84925 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-11 04:20:50 | Aguascalientes, Mexico | |||
261609 | 261609 | 2022-03-15 | Mexico | Aguascalientes | 62441 | 3479 | 0 | 21.8853 | -102.2916 | 2022-03-16 04:20:50 | Aguascalientes, Mexico | |||
268216 | 268216 | 2020-05-21 | Mexico | Aguascalientes | 586 | 21 | 402 | 163 | 21.8853 | -102.2916 | 2020-05-22 02:36:51 | Aguascalientes, Mexico | ||
272229 | 272229 | 2020-11-10 | Mexico | Aguascalientes | 10866 | 902 | 8450 | 1514 | 21.8853 | -102.2916 | 2020-11-11 05:25:30 | Aguascalientes, Mexico | ||
276259 | 276259 | 2021-11-03 | Mexico | Aguascalientes | 35896 | 2876 | 0 | 21.8853 | -102.2916 | 2021-11-04 04:22:20 | Aguascalientes, Mexico | |||
280257 | 280257 | 2021-02-24 | Mexico | Aguascalientes | 22870 | 1984 | 0 | 20886 | 21.8853 | -102.2916 | 2021-02-25 05:24:57 | Aguascalientes, Mexico | ||
286956 | 286956 | 2020-06-15 | Mexico | Aguascalientes | 1467 | 71 | 1078 | 318 | 21.8853 | -102.2916 | 2020-06-16 04:33:09 | Aguascalientes, Mexico | ||
288072 | 288072 | 2021-10-31 | Mexico | Aguascalientes | 35837 | 2868 | 0 | 21.8853 | -102.2916 | 2021-11-01 04:22:01 | Aguascalientes, Mexico | |||
292090 | 292090 | 2022-11-15 | Mexico | Aguascalientes | 84638 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-16 04:21:09 | Aguascalientes, Mexico | |||
296087 | 296087 | 2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
302828 | 302828 | 2020-07-01 | Mexico | Aguascalientes | 2363 | 151 | 1877 | 335 | 21.8853 | -102.2916 | 2020-07-02 04:33:46 | Aguascalientes, Mexico | ||
303945 | 303945 | 2022-04-16 | Mexico | Aguascalientes | 65451 | 3497 | 0 | 21.8853 | -102.2916 | 2022-04-17 04:20:59 | Aguascalientes, Mexico | |||
307962 | 307962 | 2022-12-13 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-14 04:21:04 | Aguascalientes, Mexico | |||
311978 | 311978 | 2022-11-13 | Mexico | Aguascalientes | 84631 | 3591 | 0 | 21.8853 | -102.2916 | 2022-11-14 04:21:09 | Aguascalientes, Mexico | |||
315993 | 315993 | 2022-02-12 | Mexico | Aguascalientes | 55525 | 3374 | 0 | 21.8853 | -102.2916 | 2022-02-13 04:21:00 | Aguascalientes, Mexico | |||
320010 | 320010 | 2022-10-30 | Mexico | Aguascalientes | 84545 | 3591 | 0 | 21.8853 | -102.2916 | 2022-10-31 04:21:36 | Aguascalientes, Mexico | |||
326762 | 326762 | 2020-07-20 | Mexico | Aguascalientes | 3486 | 209 | 2745 | 532 | 21.8853 | -102.2916 | 2020-07-21 04:38:46 | Aguascalientes, Mexico | ||
327984 | 327984 | 2022-12-27 | Mexico | Aguascalientes | 85740 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-28 04:21:04 | Aguascalientes, Mexico | |||
331981 | 331981 | 2021-08-04 | Mexico | Aguascalientes | 28189 | 2497 | 0 | 25692 | 21.8853 | -102.2916 | 2021-08-05 04:21:51 | Aguascalientes, Mexico | ||
336013 | 336013 | 2022-03-18 | Mexico | Aguascalientes | 63055 | 3482 | 0 | 21.8853 | -102.2916 | 2022-03-19 04:20:47 | Aguascalientes, Mexico | |||
340349 | 340349 | 2021-02-03 | Mexico | Aguascalientes | 21251 | 1771 | 0 | 19480 | 21.8853 | -102.2916 | 2021-02-04 05:22:26 | Aguascalientes, Mexico | ||
344348 | 344348 | 2020-09-14 | Mexico | Aguascalientes | 6441 | 508 | 5620 | 313 | 21.8853 | -102.2916 | 2020-09-15 03:22:50 | Aguascalientes, Mexico | ||
348374 | 348374 | 2022-12-14 | Mexico | Aguascalientes | 85042 | 3592 | 0 | 21.8853 | -102.2916 | 2022-12-15 04:20:58 | Aguascalientes, Mexico | |||
352370 | 352370 | 2021-03-11 | Mexico | Aguascalientes | 23708 | 2060 | 0 | 21648 | 21.8853 | -102.2916 | 2021-03-12 05:26:50 | Aguascalientes, Mexico | ||
356403 | 356403 | 2022-03-11 | Mexico | Aguascalientes | 62073 | 3472 | 0 | 21.8853 | -102.2916 | 2022-03-12 04:20:50 | Aguascalientes, Mexico | |||
360419 | 360419 | 2022-05-07 | Mexico | Aguascalientes | 65865 | 3501 | 0 | 21.8853 | -102.2916 | 2022-05-08 04:20:49 | Aguascalientes, Mexico | |||
367177 | 367177 | 2020-07-16 | Mexico | Aguascalientes | 3207 | 201 | 2605 | 401 | 21.8853 | -102.2916 | 2020-07-17 04:34:50 | Aguascalientes, Mexico | ||
371139 | 371139 | 2020-08-08 | Mexico | Aguascalientes | 4504 | 284 | 3786 | 434 | 21.8853 | -102.2916 | 2020-08-09 04:34:54 | Aguascalientes, Mexico | ||
372274 | 372274 | 2022-09-13 | Mexico | Aguascalientes | 84249 | 3560 | 0 | 21.8853 | -102.2916 | 2022-09-14 04:20:44 | Aguascalientes, Mexico | |||
376256 | 376256 | 2020-11-06 | Mexico | Aguascalientes | 10133 | 896 | 8360 | 877 | 21.8853 | -102.2916 | 2020-11-07 05:24:52 | Aguascalientes, Mexico | ||
380267 | 380267 | 2021-04-30 | Mexico | Aguascalientes | 26037 | 2371 | 0 | 23666 | 21.8853 | -102.2916 | 2021-05-01 04:20:47 | Aguascalientes, Mexico | ||
384301 | 384301 | 2022-09-23 | Mexico | Aguascalientes | 84419 | 3579 | 0 | 21.8853 | -102.2916 | 2022-09-24 04:21:40 | Aguascalientes, Mexico | |||
388297 | 388297 | 2021-04-04 | Mexico | Aguascalientes | 24951 | 2162 | 0 | 22789 | 21.8853 | -102.2916 | 2021-04-05 04:20:35 | Aguascalientes, Mexico | ||
392309 | 392309 | 2020-11-27 | Mexico | Aguascalientes | 12998 | 1099 | 0 | 11899 | 21.8853 | -102.2916 | 2020-11-28 05:25:50 | Aguascalientes, Mexico | ||
396342 | 396342 | 2022-10-07 | Mexico | Aguascalientes | 84585 | 3590 | 0 | 21.8853 | -102.2916 | 2022-10-08 04:22:56 | Aguascalientes, Mexico | |||
400339 | 400339 | 2021-06-29 | Mexico | Aguascalientes | 26770 | 2469 | 0 | 24301 | 21.8853 | -102.2916 | 2021-06-30 04:21:41 | Aguascalientes, Mexico | ||
404370 | 404370 | 2021-12-07 | Mexico | Aguascalientes | 37416 | 2955 | 0 | 21.8853 | -102.2916 | 2021-12-08 04:22:46 | Aguascalientes, Mexico | |||
408369 | 408369 | 2021-07-28 | Mexico | Aguascalientes | 27672 | 2488 | 0 | 25184 | 21.8853 | -102.2916 | 2021-07-29 04:21:33 | Aguascalientes, Mexico | ||
415120 | 415120 | 2020-07-05 | Mexico | Aguascalientes | 2440 | 158 | 2065 | 217 | 21.8853 | -102.2916 | 2020-07-06 04:33:57 | Aguascalientes, Mexico | ||
419413 | 419413 | 2022-09-18 | Mexico | Aguascalientes | 84329 | 3569 | 0 | 21.8853 | -102.2916 | 2022-09-19 04:21:49 | Aguascalientes, 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]);