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 = "Colima" sorted by day
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
- Colima · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431850 | 1431850 | 2020-05-20 | Mexico | Colima | 83 | 10 | 39 | 34 | 19.1223 | -104.0072 | 2020-05-21 02:32:48 | Colima, Mexico | ||
268267 | 268267 | 2020-05-21 | Mexico | Colima | 91 | 12 | 40 | 39 | 19.1223 | -104.0072 | 2020-05-22 02:36:51 | Colima, Mexico | ||
1864761 | 1864761 | 2020-05-22 | Mexico | Colima | 97 | 14 | 44 | 39 | 19.1223 | -104.0072 | 2020-05-23 02:32:42 | Colima, Mexico | ||
997738 | 997738 | 2020-05-23 | Mexico | Colima | 100 | 14 | 47 | 39 | 19.1223 | -104.0072 | 2020-05-24 02:32:43 | Colima, Mexico | ||
875547 | 875547 | 2020-05-24 | Mexico | Colima | 112 | 14 | 50 | 48 | 19.1223 | -104.0072 | 2020-05-25 02:32:44 | Colima, Mexico | ||
1104867 | 1104867 | 2020-05-25 | Mexico | Colima | 115 | 18 | 52 | 45 | 19.1223 | -104.0072 | 2020-05-26 02:32:35 | Colima, Mexico | ||
1041137 | 1041137 | 2020-05-26 | Mexico | Colima | 118 | 19 | 61 | 38 | 19.1223 | -104.0072 | 2020-05-27 02:32:31 | Colima, Mexico | ||
2548174 | 2548174 | 2020-05-27 | Mexico | Colima | 128 | 21 | 65 | 42 | 19.1223 | -104.0072 | 2020-05-28 02:32:31 | Colima, Mexico | ||
2712178 | 2712178 | 2020-05-28 | Mexico | Colima | 135 | 21 | 68 | 46 | 19.1223 | -104.0072 | 2020-05-29 02:32:50 | Colima, Mexico | ||
1790298 | 1790298 | 2020-05-29 | Mexico | Colima | 136 | 21 | 72 | 43 | 19.1223 | -104.0072 | 2020-05-30 02:32:48 | Colima, Mexico | ||
3638757 | 3638757 | 2020-05-30 | Mexico | Colima | 141 | 21 | 80 | 40 | 19.1223 | -104.0072 | 2020-05-31 02:32:45 | Colima, Mexico | ||
1793864 | 1793864 | 2020-05-31 | Mexico | Colima | 151 | 21 | 86 | 44 | 19.1223 | -104.0072 | 2020-06-01 02:32:46 | Colima, Mexico | ||
805236 | 805236 | 2020-06-01 | Mexico | Colima | 154 | 21 | 95 | 38 | 19.1223 | -104.0072 | 2020-06-02 02:33:08 | Colima, Mexico | ||
2555700 | 2555700 | 2020-06-02 | Mexico | Colima | 158 | 26 | 94 | 38 | 19.1223 | -104.0072 | 2020-06-03 02:33:13 | Colima, Mexico | ||
3866657 | 3866657 | 2020-06-03 | Mexico | Colima | 170 | 27 | 105 | 38 | 19.1223 | -104.0072 | 2020-06-04 02:33:14 | Colima, Mexico | ||
1281102 | 1281102 | 2020-06-04 | Mexico | Colima | 180 | 29 | 108 | 43 | 19.1223 | -104.0072 | 2020-06-05 02:33:06 | Colima, Mexico | ||
1269622 | 1269622 | 2020-06-05 | Mexico | Colima | 196 | 29 | 117 | 50 | 19.1223 | -104.0072 | 2020-06-06 02:33:00 | Colima, Mexico | ||
573925 | 573925 | 2020-06-06 | Mexico | Colima | 205 | 30 | 122 | 53 | 19.1223 | -104.0072 | 2020-06-07 03:53:30 | Colima, Mexico | ||
2799869 | 2799869 | 2020-06-07 | Mexico | Colima | 214 | 31 | 126 | 57 | 19.1223 | -104.0072 | 2020-06-08 03:33:22 | Colima, Mexico | ||
217072 | 217072 | 2020-06-08 | Mexico | Colima | 217 | 32 | 132 | 53 | 19.1223 | -104.0072 | 2020-06-09 03:33:03 | Colima, Mexico | ||
1210645 | 1210645 | 2020-06-09 | Mexico | Colima | 224 | 33 | 134 | 57 | 19.1223 | -104.0072 | 2020-06-10 04:07:00 | Colima, Mexico | ||
2863794 | 2863794 | 2020-06-10 | Mexico | Colima | 240 | 34 | 137 | 69 | 19.1223 | -104.0072 | 2020-06-11 03:33:41 | Colima, Mexico | ||
1273350 | 1273350 | 2020-06-11 | Mexico | Colima | 252 | 36 | 147 | 69 | 19.1223 | -104.0072 | 2020-06-12 05:09:52 | Colima, Mexico | ||
737380 | 737380 | 2020-06-12 | Mexico | Colima | 264 | 36 | 151 | 77 | 19.1223 | -104.0072 | 2020-06-13 03:33:14 | Colima, Mexico | ||
3061060 | 3061060 | 2020-06-13 | Mexico | Colima | 276 | 39 | 158 | 79 | 19.1223 | -104.0072 | 2020-06-14 03:33:15 | Colima, Mexico | ||
1837008 | 1837008 | 2020-06-14 | Mexico | Colima | 291 | 39 | 169 | 83 | 19.1223 | -104.0072 | 2020-06-15 03:33:14 | Colima, Mexico | ||
287057 | 287057 | 2020-06-15 | Mexico | Colima | 298 | 40 | 186 | 72 | 19.1223 | -104.0072 | 2020-06-16 04:33:09 | Colima, Mexico | ||
2386494 | 2386494 | 2020-06-16 | Mexico | Colima | 307 | 41 | 195 | 71 | 19.1223 | -104.0072 | 2020-06-17 04:33:21 | Colima, Mexico | ||
1195731 | 1195731 | 2020-06-17 | Mexico | Colima | 324 | 42 | 202 | 80 | 19.1223 | -104.0072 | 2020-06-18 04:33:18 | Colima, Mexico | ||
3682528 | 3682528 | 2020-06-18 | Mexico | Colima | 339 | 42 | 208 | 89 | 19.1223 | -104.0072 | 2020-06-19 04:33:17 | Colima, Mexico | ||
1691379 | 1691379 | 2020-06-19 | Mexico | Colima | 353 | 43 | 219 | 91 | 19.1223 | -104.0072 | 2020-06-20 04:33:19 | Colima, Mexico | ||
2437801 | 2437801 | 2020-06-20 | Mexico | Colima | 363 | 43 | 229 | 91 | 19.1223 | -104.0072 | 2020-06-21 04:33:19 | Colima, Mexico | ||
3249208 | 3249208 | 2020-06-21 | Mexico | Colima | 385 | 44 | 241 | 100 | 19.1223 | -104.0072 | 2020-06-22 04:33:20 | Colima, Mexico | ||
1510469 | 1510469 | 2020-06-22 | Mexico | Colima | 400 | 47 | 255 | 98 | 19.1223 | -104.0072 | 2020-06-23 04:33:22 | Colima, Mexico | ||
1522275 | 1522275 | 2020-06-23 | Mexico | Colima | 428 | 52 | 268 | 108 | 19.1223 | -104.0072 | 2020-06-24 04:33:28 | Colima, Mexico | ||
2700590 | 2700590 | 2020-06-24 | Mexico | Colima | 439 | 57 | 271 | 111 | 19.1223 | -104.0072 | 2020-06-25 05:26:54 | Colima, Mexico | ||
2624950 | 2624950 | 2020-06-25 | Mexico | Colima | 459 | 58 | 282 | 119 | 19.1223 | -104.0072 | 2020-06-26 04:33:43 | Colima, Mexico | ||
1135963 | 1135963 | 2020-06-26 | Mexico | Colima | 484 | 62 | 295 | 127 | 19.1223 | -104.0072 | 2020-06-27 04:33:35 | Colima, Mexico | ||
2039682 | 2039682 | 2020-06-27 | Mexico | Colima | 502 | 63 | 309 | 130 | 19.1223 | -104.0072 | 2020-06-28 04:34:04 | Colima, Mexico | ||
2306347 | 2306347 | 2020-06-28 | Mexico | Colima | 529 | 65 | 325 | 139 | 19.1223 | -104.0072 | 2020-06-29 04:33:44 | Colima, Mexico | ||
2632784 | 2632784 | 2020-06-29 | Mexico | Colima | 542 | 69 | 343 | 130 | 19.1223 | -104.0072 | 2020-06-30 04:33:48 | Colima, Mexico | ||
2974307 | 2974307 | 2020-06-30 | Mexico | Colima | 551 | 71 | 361 | 119 | 19.1223 | -104.0072 | 2020-07-01 04:33:52 | Colima, Mexico | ||
302929 | 302929 | 2020-07-01 | Mexico | Colima | 578 | 73 | 368 | 137 | 19.1223 | -104.0072 | 2020-07-02 04:33:46 | Colima, Mexico | ||
3045238 | 3045238 | 2020-07-02 | Mexico | Colima | 603 | 78 | 386 | 139 | 19.1223 | -104.0072 | 2020-07-03 04:33:54 | Colima, Mexico | ||
2234444 | 2234444 | 2020-07-03 | Mexico | Colima | 643 | 82 | 408 | 153 | 19.1223 | -104.0072 | 2020-07-04 04:33:51 | Colima, Mexico | ||
529783 | 529783 | 2020-07-04 | Mexico | Colima | 664 | 85 | 431 | 148 | 19.1223 | -104.0072 | 2020-07-05 04:33:46 | Colima, Mexico | ||
415221 | 415221 | 2020-07-05 | Mexico | Colima | 691 | 86 | 454 | 151 | 19.1223 | -104.0072 | 2020-07-06 04:33:57 | Colima, Mexico | ||
2684756 | 2684756 | 2020-07-06 | Mexico | Colima | 715 | 89 | 471 | 155 | 19.1223 | -104.0072 | 2020-07-07 04:34:00 | Colima, Mexico | ||
887196 | 887196 | 2020-07-07 | Mexico | Colima | 726 | 92 | 478 | 156 | 19.1223 | -104.0072 | 2020-07-08 05:33:48 | Colima, Mexico | ||
2222587 | 2222587 | 2020-07-08 | Mexico | Colima | 757 | 94 | 497 | 166 | 19.1223 | -104.0072 | 2020-07-09 04:34:23 | Colima, Mexico | ||
1005371 | 1005371 | 2020-07-09 | Mexico | Colima | 775 | 94 | 511 | 170 | 19.1223 | -104.0072 | 2020-07-10 04:34:24 | Colima, Mexico | ||
3237386 | 3237386 | 2020-07-10 | Mexico | Colima | 821 | 96 | 538 | 187 | 19.1223 | -104.0072 | 2020-07-11 04:34:26 | Colima, Mexico | ||
3435888 | 3435888 | 2020-07-11 | Mexico | Colima | 857 | 99 | 569 | 189 | 19.1223 | -104.0072 | 2020-07-12 04:34:30 | Colima, Mexico | ||
3737493 | 3737493 | 2020-07-12 | Mexico | Colima | 898 | 106 | 579 | 213 | 19.1223 | -104.0072 | 2020-07-13 04:43:04 | Colima, Mexico | ||
3491231 | 3491231 | 2020-07-13 | Mexico | Colima | 931 | 111 | 599 | 221 | 19.1223 | -104.0072 | 2020-07-14 04:34:46 | Colima, Mexico | ||
2158590 | 2158590 | 2020-07-14 | Mexico | Colima | 939 | 115 | 621 | 203 | 19.1223 | -104.0072 | 2020-07-15 04:34:39 | Colima, Mexico | ||
2747946 | 2747946 | 2020-07-15 | Mexico | Colima | 980 | 118 | 643 | 219 | 19.1223 | -104.0072 | 2020-07-16 04:44:59 | Colima, Mexico | ||
367278 | 367278 | 2020-07-16 | Mexico | Colima | 1051 | 129 | 660 | 262 | 19.1223 | -104.0072 | 2020-07-17 04:34:50 | Colima, Mexico | ||
2708459 | 2708459 | 2020-07-17 | Mexico | Colima | 1102 | 133 | 707 | 262 | 19.1223 | -104.0072 | 2020-07-18 04:34:45 | Colima, Mexico | ||
3205157 | 3205157 | 2020-07-18 | Mexico | Colima | 1168 | 139 | 767 | 262 | 19.1223 | -104.0072 | 2020-07-19 04:34:58 | Colima, Mexico | ||
121768 | 121768 | 2020-07-19 | Mexico | Colima | 1208 | 144 | 637 | 427 | 19.1223 | -104.0072 | 2020-07-20 05:34:40 | Colima, Mexico | ||
326863 | 326863 | 2020-07-20 | Mexico | Colima | 1232 | 144 | 664 | 424 | 19.1223 | -104.0072 | 2020-07-21 04:38:46 | Colima, Mexico | ||
1707372 | 1707372 | 2020-07-21 | Mexico | Colima | 1249 | 145 | 673 | 431 | 19.1223 | -104.0072 | 2020-07-22 04:34:42 | Colima, Mexico | ||
844633 | 844633 | 2020-07-22 | Mexico | Colima | 1288 | 152 | 668 | 468 | 19.1223 | -104.0072 | 2020-07-23 05:15:04 | Colima, Mexico | ||
62405 | 62405 | 2020-07-23 | Mexico | Colima | 1316 | 161 | 667 | 488 | 19.1223 | -104.0072 | 2020-07-24 03:34:53 | Colima, Mexico | ||
2563613 | 2563613 | 2020-07-24 | Mexico | Colima | 1429 | 170 | 737 | 522 | 19.1223 | -104.0072 | 2020-07-25 04:47:39 | Colima, Mexico | ||
1502643 | 1502643 | 2020-07-25 | Mexico | Colima | 1525 | 175 | 801 | 549 | 19.1223 | -104.0072 | 2020-07-26 04:35:00 | Colima, Mexico | ||
442399 | 442399 | 2020-07-26 | Mexico | Colima | 1572 | 181 | 832 | 559 | 19.1223 | -104.0072 | 2020-07-27 04:35:02 | Colima, Mexico | ||
177086 | 177086 | 2020-07-27 | Mexico | Colima | 1605 | 183 | 901 | 521 | 19.1223 | -104.0072 | 2020-07-28 04:58:43 | Colima, Mexico | ||
3185034 | 3185034 | 2020-07-28 | Mexico | Colima | 1649 | 194 | 925 | 530 | 19.1223 | -104.0072 | 2020-07-29 04:35:11 | Colima, Mexico | ||
2958418 | 2958418 | 2020-07-29 | Mexico | Colima | 1682 | 195 | 963 | 524 | 19.1223 | -104.0072 | 2020-07-30 04:35:05 | Colima, Mexico | ||
1928250 | 1928250 | 2020-07-30 | Mexico | Colima | 1748 | 200 | 1024 | 524 | 19.1223 | -104.0072 | 2020-07-31 04:35:18 | Colima, Mexico | ||
3264543 | 3264543 | 2020-07-31 | Mexico | Colima | 1802 | 206 | 1082 | 514 | 19.1223 | -104.0072 | 2020-08-01 04:36:27 | Colima, Mexico | ||
753378 | 753378 | 2020-08-01 | Mexico | Colima | 1875 | 212 | 1154 | 509 | 19.1223 | -104.0072 | 2020-08-02 04:34:47 | Colima, Mexico | ||
2807810 | 2807810 | 2020-08-02 | Mexico | Colima | 1929 | 220 | 1233 | 476 | 19.1223 | -104.0072 | 2020-08-03 04:34:35 | Colima, Mexico | ||
2740058 | 2740058 | 2020-08-03 | Mexico | Colima | 1990 | 228 | 1317 | 445 | 19.1223 | -104.0072 | 2020-08-04 04:41:59 | Colima, Mexico | ||
98175 | 98175 | 2020-08-04 | Mexico | Colima | 2000 | 240 | 1303 | 457 | 19.1223 | -104.0072 | 2020-08-05 04:34:43 | Colima, Mexico | ||
3792939 | 3792939 | 2020-08-05 | Mexico | Colima | 2060 | 241 | 1366 | 453 | 19.1223 | -104.0072 | 2020-08-06 04:35:02 | Colima, Mexico | ||
3612109 | 3612109 | 2020-08-06 | Mexico | Colima | 2104 | 251 | 1378 | 475 | 19.1223 | -104.0072 | 2020-08-07 04:35:11 | Colima, Mexico | ||
458424 | 458424 | 2020-08-07 | Mexico | Colima | 2171 | 261 | 1418 | 492 | 19.1223 | -104.0072 | 2020-08-08 04:34:53 | Colima, Mexico | ||
371240 | 371240 | 2020-08-08 | Mexico | Colima | 2237 | 265 | 1477 | 495 | 19.1223 | -104.0072 | 2020-08-09 04:34:54 | Colima, Mexico | ||
3923072 | 3923072 | 2020-08-09 | Mexico | Colima | 2275 | 272 | 1542 | 461 | 19.1223 | -104.0072 | 2020-08-10 04:34:55 | Colima, Mexico | ||
1920263 | 1920263 | 2020-08-10 | Mexico | Colima | 2393 | 279 | 1639 | 475 | 19.1223 | -104.0072 | 2020-08-11 04:35:08 | Colima, Mexico | ||
662379 | 662379 | 2020-08-11 | Mexico | Colima | 2418 | 292 | 1644 | 482 | 19.1223 | -104.0072 | 2020-08-12 04:27:29 | Colima, Mexico | ||
3531531 | 3531531 | 2020-08-12 | Mexico | Colima | 2475 | 299 | 1644 | 532 | 19.1223 | -104.0072 | 2020-08-13 04:29:15 | Colima, Mexico | ||
582912 | 582912 | 2020-08-13 | Mexico | Colima | 2524 | 305 | 1654 | 565 | 19.1223 | -104.0072 | 2020-08-14 04:51:19 | Colima, Mexico | ||
1612328 | 1612328 | 2020-08-14 | Mexico | Colima | 2577 | 308 | 1681 | 588 | 19.1223 | -104.0072 | 2020-08-15 04:27:31 | Colima, Mexico | ||
146053 | 146053 | 2020-08-15 | Mexico | Colima | 2658 | 314 | 1777 | 567 | 19.1223 | -104.0072 | 2020-08-16 04:27:42 | Colima, Mexico | ||
1556051 | 1556051 | 2020-08-16 | Mexico | Colima | 2728 | 317 | 1862 | 549 | 19.1223 | -104.0072 | 2020-08-17 04:27:20 | Colima, Mexico | ||
837693 | 837693 | 2020-08-17 | Mexico | Colima | 2777 | 322 | 1933 | 522 | 19.1223 | -104.0072 | 2020-08-18 04:27:56 | Colima, Mexico | ||
3178089 | 3178089 | 2020-08-18 | Mexico | Colima | 2828 | 330 | 1937 | 561 | 19.1223 | -104.0072 | 2020-08-19 04:27:00 | Colima, Mexico | ||
206335 | 206335 | 2020-08-19 | Mexico | Colima | 2910 | 336 | 1989 | 585 | 19.1223 | -104.0072 | 2020-08-20 04:27:43 | Colima, Mexico | ||
3484386 | 3484386 | 2020-08-20 | Mexico | Colima | 3044 | 345 | 2096 | 603 | 19.1223 | -104.0072 | 2020-08-21 04:27:41 | Colima, Mexico | ||
1479637 | 1479637 | 2020-08-21 | Mexico | Colima | 3110 | 349 | 2151 | 610 | 19.1223 | -104.0072 | 2020-08-22 04:27:49 | Colima, Mexico | ||
2299530 | 2299530 | 2020-08-22 | Mexico | Colima | 3181 | 361 | 2196 | 624 | 19.1223 | -104.0072 | 2020-08-23 04:27:48 | Colima, Mexico | ||
2215748 | 2215748 | 2020-08-23 | Mexico | Colima | 3265 | 365 | 2333 | 567 | 19.1223 | -104.0072 | 2020-08-24 04:27:56 | Colima, Mexico | ||
2991353 | 2991353 | 2020-08-24 | Mexico | Colima | 3320 | 375 | 2428 | 517 | 19.1223 | -104.0072 | 2020-08-25 04:28:02 | Colima, Mexico | ||
3562649 | 3562649 | 2020-08-25 | Mexico | Colima | 3330 | 387 | 2409 | 534 | 19.1223 | -104.0072 | 2020-08-26 04:28:11 | Colima, Mexico | ||
1996725 | 1996725 | 2020-08-26 | Mexico | Colima | 3413 | 401 | 2428 | 584 | 19.1223 | -104.0072 | 2020-08-27 04:28:15 | Colima, Mexico | ||
2510265 | 2510265 | 2020-08-27 | Mexico | Colima | 3468 | 407 | 2470 | 591 | 19.1223 | -104.0072 | 2020-08-28 04:28:11 | Colima, 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]);