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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2494119 | 2494119 | 2022-08-15 | Mexico | Colima | 66652 | 2232 | 0 | 19.1223 | -104.0072 | 2022-08-16 04:20:58 | Colima, Mexico | |||
3647669 | 3647669 | 2022-08-14 | Mexico | Colima | 66644 | 2232 | 0 | 19.1223 | -104.0072 | 2022-08-15 04:20:59 | Colima, Mexico | |||
1968675 | 1968675 | 2022-08-13 | Mexico | Colima | 66636 | 2232 | 0 | 19.1223 | -104.0072 | 2022-08-14 04:20:55 | Colima, Mexico | |||
2888484 | 2888484 | 2022-08-12 | Mexico | Colima | 66393 | 2230 | 0 | 19.1223 | -104.0072 | 2022-08-13 04:20:52 | Colima, Mexico | |||
3908089 | 3908089 | 2022-08-11 | Mexico | Colima | 66393 | 2230 | 0 | 19.1223 | -104.0072 | 2022-08-12 04:20:54 | Colima, Mexico | |||
1346406 | 1346406 | 2022-08-10 | Mexico | Colima | 66393 | 2230 | 0 | 19.1223 | -104.0072 | 2022-08-11 04:20:49 | Colima, Mexico | |||
1086161 | 1086161 | 2022-08-09 | Mexico | Colima | 66393 | 2230 | 0 | 19.1223 | -104.0072 | 2022-08-10 04:20:57 | Colima, Mexico | |||
3543576 | 3543576 | 2022-08-08 | Mexico | Colima | 66264 | 2227 | 0 | 19.1223 | -104.0072 | 2022-08-09 04:20:34 | Colima, Mexico | |||
1069979 | 1069979 | 2022-08-07 | Mexico | Colima | 66257 | 2226 | 0 | 19.1223 | -104.0072 | 2022-08-08 04:21:08 | Colima, Mexico | |||
1940567 | 1940567 | 2022-08-06 | Mexico | Colima | 66241 | 2226 | 0 | 19.1223 | -104.0072 | 2022-08-07 04:20:54 | Colima, Mexico | |||
880366 | 880366 | 2022-08-05 | Mexico | Colima | 66044 | 2224 | 0 | 19.1223 | -104.0072 | 2022-08-06 04:20:56 | Colima, Mexico | |||
2008777 | 2008777 | 2022-08-04 | Mexico | Colima | 66044 | 2224 | 0 | 19.1223 | -104.0072 | 2022-08-05 04:20:52 | Colima, Mexico | |||
1098204 | 1098204 | 2022-08-03 | Mexico | Colima | 65939 | 2223 | 0 | 19.1223 | -104.0072 | 2022-08-04 04:20:58 | Colima, Mexico | |||
1405129 | 1405129 | 2022-08-02 | Mexico | Colima | 65802 | 2222 | 0 | 19.1223 | -104.0072 | 2022-08-03 04:20:59 | Colima, Mexico | |||
3617167 | 3617167 | 2022-08-01 | Mexico | Colima | 65620 | 2221 | 0 | 19.1223 | -104.0072 | 2022-08-02 04:20:53 | Colima, Mexico | |||
3871647 | 3871647 | 2022-07-31 | Mexico | Colima | 65273 | 2219 | 0 | 19.1223 | -104.0072 | 2022-08-01 04:21:03 | Colima, Mexico | |||
674401 | 674401 | 2022-07-30 | Mexico | Colima | 65273 | 2219 | 0 | 19.1223 | -104.0072 | 2022-07-31 04:21:02 | Colima, Mexico | |||
1783600 | 1783600 | 2022-07-29 | Mexico | Colima | 65273 | 2219 | 0 | 19.1223 | -104.0072 | 2022-07-30 04:20:42 | Colima, Mexico | |||
1065963 | 1065963 | 2022-07-28 | Mexico | Colima | 64992 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-29 04:20:45 | Colima, Mexico | |||
2335482 | 2335482 | 2022-07-27 | Mexico | Colima | 64992 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-28 04:20:56 | Colima, Mexico | |||
1487672 | 1487672 | 2022-07-26 | Mexico | Colima | 64439 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-27 04:21:04 | Colima, Mexico | |||
2594118 | 2594118 | 2022-07-25 | Mexico | Colima | 64439 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-26 04:20:58 | Colima, Mexico | |||
896233 | 896233 | 2022-07-24 | Mexico | Colima | 64373 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-25 04:20:51 | Colima, Mexico | |||
91227 | 91227 | 2022-07-23 | Mexico | Colima | 64330 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-24 04:20:47 | Colima, Mexico | |||
900249 | 900249 | 2022-07-22 | Mexico | Colima | 64030 | 2217 | 0 | 19.1223 | -104.0072 | 2022-07-23 04:20:53 | Colima, Mexico | |||
670385 | 670385 | 2022-07-21 | Mexico | Colima | 63703 | 2216 | 0 | 19.1223 | -104.0072 | 2022-07-22 04:21:15 | Colima, Mexico | |||
1608348 | 1608348 | 2022-07-20 | Mexico | Colima | 63417 | 2216 | 0 | 19.1223 | -104.0072 | 2022-07-21 04:21:10 | Colima, Mexico | |||
958981 | 958981 | 2022-07-19 | Mexico | Colima | 63046 | 2213 | 0 | 19.1223 | -104.0072 | 2022-07-20 04:20:59 | Colima, Mexico | |||
3210368 | 3210368 | 2022-07-18 | Mexico | Colima | 62533 | 2213 | 0 | 19.1223 | -104.0072 | 2022-07-19 04:20:58 | Colima, Mexico | |||
3405543 | 3405543 | 2022-07-17 | Mexico | Colima | 62533 | 2213 | 0 | 19.1223 | -104.0072 | 2022-07-18 04:20:59 | Colima, Mexico | |||
2151743 | 2151743 | 2022-07-16 | Mexico | Colima | 62481 | 2212 | 0 | 19.1223 | -104.0072 | 2022-07-17 04:21:15 | Colima, Mexico | |||
2418976 | 2418976 | 2022-07-15 | Mexico | Colima | 62066 | 2211 | 0 | 19.1223 | -104.0072 | 2022-07-16 04:21:05 | Colima, Mexico | |||
3429051 | 3429051 | 2022-07-14 | Mexico | Colima | 61607 | 2208 | 0 | 19.1223 | -104.0072 | 2022-07-15 04:20:53 | Colima, Mexico | |||
3109571 | 3109571 | 2022-07-13 | Mexico | Colima | 61195 | 2207 | 0 | 19.1223 | -104.0072 | 2022-07-14 04:20:57 | Colima, Mexico | |||
629994 | 629994 | 2022-07-12 | Mexico | Colima | 60737 | 2206 | 0 | 19.1223 | -104.0072 | 2022-07-13 04:20:58 | Colima, Mexico | |||
1211638 | 1211638 | 2022-07-11 | Mexico | Colima | 60259 | 2206 | 0 | 19.1223 | -104.0072 | 2022-07-12 04:20:51 | Colima, Mexico | |||
2789120 | 2789120 | 2022-07-10 | Mexico | Colima | 60211 | 2206 | 0 | 19.1223 | -104.0072 | 2022-07-11 04:20:46 | Colima, Mexico | |||
142073 | 142073 | 2022-07-09 | Mexico | Colima | 60137 | 2206 | 0 | 19.1223 | -104.0072 | 2022-07-10 04:20:54 | Colima, Mexico | |||
1417173 | 1417173 | 2022-07-08 | Mexico | Colima | 59327 | 2205 | 0 | 19.1223 | -104.0072 | 2022-07-09 04:20:59 | Colima, Mexico | |||
2741098 | 2741098 | 2022-07-07 | Mexico | Colima | 59327 | 2205 | 0 | 19.1223 | -104.0072 | 2022-07-08 04:20:56 | Colima, Mexico | |||
1199893 | 1199893 | 2022-07-06 | Mexico | Colima | 58846 | 2204 | 0 | 19.1223 | -104.0072 | 2022-07-07 04:20:55 | Colima, Mexico | |||
3966636 | 3966636 | 2022-07-05 | Mexico | Colima | 58403 | 2204 | 0 | 19.1223 | -104.0072 | 2022-07-06 04:20:58 | Colima, Mexico | |||
3078147 | 3078147 | 2022-07-04 | Mexico | Colima | 58114 | 2204 | 0 | 19.1223 | -104.0072 | 2022-07-05 04:20:45 | Colima, Mexico | |||
1767429 | 1767429 | 2022-07-03 | Mexico | Colima | 58034 | 2204 | 0 | 19.1223 | -104.0072 | 2022-07-04 04:20:54 | Colima, Mexico | |||
3365415 | 3365415 | 2022-07-02 | Mexico | Colima | 57758 | 2203 | 0 | 19.1223 | -104.0072 | 2022-07-03 04:20:59 | Colima, Mexico | |||
593744 | 593744 | 2022-07-01 | Mexico | Colima | 57758 | 2203 | 0 | 19.1223 | -104.0072 | 2022-07-02 04:21:16 | Colima, Mexico | |||
3940145 | 3940145 | 2022-06-30 | Mexico | Colima | 57535 | 2203 | 0 | 19.1223 | -104.0072 | 2022-07-01 04:21:10 | Colima, Mexico | |||
2490103 | 2490103 | 2022-06-29 | Mexico | Colima | 57082 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-30 04:21:01 | Colima, Mexico | |||
2239485 | 2239485 | 2022-06-28 | Mexico | Colima | 57082 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-29 04:20:59 | Colima, Mexico | |||
2147727 | 2147727 | 2022-06-27 | Mexico | Colima | 56809 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-28 04:20:58 | Colima, Mexico | |||
475528 | 475528 | 2022-06-26 | Mexico | Colima | 56766 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-27 04:21:00 | Colima, Mexico | |||
938903 | 938903 | 2022-06-25 | Mexico | Colima | 56744 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-26 04:21:02 | Colima, Mexico | |||
3346723 | 3346723 | 2022-06-24 | Mexico | Colima | 56470 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-25 04:20:57 | Colima, Mexico | |||
1648464 | 1648464 | 2022-06-23 | Mexico | Colima | 56314 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-24 04:20:58 | Colima, Mexico | |||
2187699 | 2187699 | 2022-06-22 | Mexico | Colima | 56175 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-23 04:20:55 | Colima, Mexico | |||
166130 | 166130 | 2022-06-21 | Mexico | Colima | 56175 | 2203 | 0 | 19.1223 | -104.0072 | 2022-06-22 04:20:54 | Colima, Mexico | |||
1763413 | 1763413 | 2022-06-20 | Mexico | Colima | 56053 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-21 04:20:56 | Colima, Mexico | |||
3269599 | 3269599 | 2022-06-19 | Mexico | Colima | 56024 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-20 04:21:01 | Colima, Mexico | |||
3397511 | 3397511 | 2022-06-18 | Mexico | Colima | 55877 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-19 04:20:51 | Colima, Mexico | |||
2311388 | 2311388 | 2022-06-17 | Mexico | Colima | 55877 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-18 04:21:10 | Colima, Mexico | |||
558892 | 558892 | 2022-06-16 | Mexico | Colima | 55877 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-17 04:20:56 | Colima, Mexico | |||
3982694 | 3982694 | 2022-06-15 | Mexico | Colima | 55784 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-16 04:20:55 | Colima, Mexico | |||
946935 | 946935 | 2022-06-14 | Mexico | Colima | 55713 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-15 04:20:54 | Colima, Mexico | |||
2979343 | 2979343 | 2022-06-13 | Mexico | Colima | 55609 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-14 04:20:52 | Colima, Mexico | |||
2235469 | 2235469 | 2022-06-12 | Mexico | Colima | 55609 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-13 04:21:14 | Colima, Mexico | |||
3141667 | 3141667 | 2022-06-11 | Mexico | Colima | 55596 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-12 04:20:53 | Colima, Mexico | |||
1944583 | 1944583 | 2022-06-10 | Mexico | Colima | 55528 | 2201 | 0 | 19.1223 | -104.0072 | 2022-06-11 04:21:01 | Colima, Mexico | |||
3157722 | 3157722 | 2022-06-09 | Mexico | Colima | 55409 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-10 04:20:55 | Colima, Mexico | |||
1421189 | 1421189 | 2022-06-08 | Mexico | Colima | 55409 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-09 04:20:54 | Colima, Mexico | |||
3726303 | 3726303 | 2022-06-07 | Mexico | Colima | 55363 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-08 04:20:55 | Colima, Mexico | |||
3887705 | 3887705 | 2022-06-06 | Mexico | Colima | 55312 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-07 04:21:08 | Colima, Mexico | |||
3507474 | 3507474 | 2022-06-05 | Mexico | Colima | 55295 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-06 04:20:57 | Colima, Mexico | |||
3527551 | 3527551 | 2022-06-04 | Mexico | Colima | 55281 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-05 04:20:55 | Colima, Mexico | |||
3133637 | 3133637 | 2022-06-03 | Mexico | Colima | 55217 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-04 04:20:58 | Colima, Mexico | |||
3578712 | 3578712 | 2022-06-02 | Mexico | Colima | 55217 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-03 04:20:58 | Colima, Mexico | |||
971005 | 971005 | 2022-06-01 | Mexico | Colima | 55164 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-02 05:20:39 | Colima, Mexico | |||
229312 | 229312 | 2022-05-31 | Mexico | Colima | 55126 | 2202 | 0 | 19.1223 | -104.0072 | 2022-06-01 04:20:55 | Colima, Mexico | |||
3186077 | 3186077 | 2022-05-30 | Mexico | Colima | 55086 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-31 04:20:51 | Colima, Mexico | |||
3198226 | 3198226 | 2022-05-29 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-30 04:20:50 | Colima, Mexico | |||
2725104 | 2725104 | 2022-05-28 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-29 04:20:53 | Colima, Mexico | |||
1314285 | 1314285 | 2022-05-27 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-28 04:21:07 | Colima, Mexico | |||
1850077 | 1850077 | 2022-05-26 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-27 04:20:56 | Colima, Mexico | |||
2047953 | 2047953 | 2022-05-25 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-26 04:20:50 | Colima, Mexico | |||
2999391 | 2999391 | 2022-05-24 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-25 04:20:56 | Colima, Mexico | |||
3593112 | 3593112 | 2022-05-23 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-24 04:20:57 | Colima, Mexico | |||
621964 | 621964 | 2022-05-22 | Mexico | Colima | 54924 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-26 04:20:50 | Colima, Mexico | |||
1109660 | 1109660 | 2022-05-21 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-22 04:20:52 | Colima, Mexico | |||
1169284 | 1169284 | 2022-05-20 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-21 04:20:58 | Colima, Mexico | |||
3896047 | 3896047 | 2022-05-19 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-20 04:20:57 | Colima, Mexico | |||
1184831 | 1184831 | 2022-05-18 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-19 04:20:54 | Colima, Mexico | |||
3582728 | 3582728 | 2022-05-17 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-18 04:20:50 | Colima, Mexico | |||
1503685 | 1503685 | 2022-05-16 | Mexico | Colima | 54853 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-17 04:20:59 | Colima, Mexico | |||
2084044 | 2084044 | 2022-05-15 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-16 04:20:47 | Colima, Mexico | |||
3354754 | 3354754 | 2022-05-14 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-15 04:20:53 | Colima, Mexico | |||
658399 | 658399 | 2022-05-13 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-14 04:20:48 | Colima, Mexico | |||
2533482 | 2533482 | 2022-05-12 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-13 04:20:51 | Colima, Mexico | |||
3444928 | 3444928 | 2022-05-11 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-12 04:20:54 | Colima, Mexico | |||
3535545 | 3535545 | 2022-05-10 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-11 04:20:48 | Colima, Mexico | |||
222080 | 222080 | 2022-05-09 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-10 04:20:50 | Colima, Mexico | |||
2331465 | 2331465 | 2022-05-08 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-09 04:20:54 | 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]);