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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
360427 | 360427 | 2022-05-07 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-08 04:20:49 | Colima, Mexico | |||
1397778 | 1397778 | 2022-05-06 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-07 04:21:09 | Colima, Mexico | |||
2598133 | 2598133 | 2022-05-05 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-06 04:21:00 | Colima, Mexico | |||
3265582 | 3265582 | 2022-05-04 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-05 04:20:55 | Colima, Mexico | |||
1572221 | 1572221 | 2022-05-03 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-04 04:20:59 | Colima, Mexico | |||
463481 | 463481 | 2022-05-02 | Mexico | Colima | 54746 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-03 04:21:00 | Colima, Mexico | |||
3916120 | 3916120 | 2022-05-01 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-02 04:21:10 | Colima, Mexico | |||
2840924 | 2840924 | 2022-04-30 | Mexico | Colima | 54741 | 2197 | 0 | 19.1223 | -104.0072 | 2022-05-01 04:20:57 | Colima, Mexico | |||
1157237 | 1157237 | 2022-04-29 | Mexico | Colima | 54738 | 2197 | 0 | 19.1223 | -104.0072 | 2022-04-30 04:21:05 | Colima, Mexico | |||
1696419 | 1696419 | 2022-04-28 | Mexico | Colima | 54732 | 2197 | 0 | 19.1223 | -104.0072 | 2022-04-29 04:20:59 | Colima, Mexico | |||
3851902 | 3851902 | 2022-04-27 | Mexico | Colima | 54719 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-28 04:20:47 | Colima, Mexico | |||
1326332 | 1326332 | 2022-04-26 | Mexico | Colima | 54719 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-27 04:20:52 | Colima, Mexico | |||
3722286 | 3722286 | 2022-04-25 | Mexico | Colima | 54714 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-26 04:20:51 | Colima, Mexico | |||
2028854 | 2028854 | 2022-04-24 | Mexico | Colima | 54714 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-25 04:20:56 | Colima, Mexico | |||
746429 | 746429 | 2022-04-23 | Mexico | Colima | 54713 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-24 04:20:56 | Colima, Mexico | |||
3436914 | 3436914 | 2022-04-22 | Mexico | Colima | 54700 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-23 04:20:50 | Colima, Mexico | |||
2892499 | 2892499 | 2022-04-21 | Mexico | Colima | 54700 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-22 04:20:45 | Colima, Mexico | |||
2307371 | 2307371 | 2022-04-20 | Mexico | Colima | 54694 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-21 04:20:46 | Colima, Mexico | |||
2251510 | 2251510 | 2022-04-19 | Mexico | Colima | 54685 | 2198 | 0 | 19.1223 | -104.0072 | 2022-04-20 04:20:45 | Colima, Mexico | |||
1846060 | 1846060 | 2022-04-18 | Mexico | Colima | 54669 | 2197 | 0 | 19.1223 | -104.0072 | 2022-04-19 04:21:00 | Colima, Mexico | |||
3417004 | 3417004 | 2022-04-17 | Mexico | Colima | 54669 | 2197 | 0 | 19.1223 | -104.0072 | 2022-04-18 04:21:12 | Colima, Mexico | |||
303953 | 303953 | 2022-04-16 | Mexico | Colima | 54649 | 2197 | 0 | 19.1223 | -104.0072 | 2022-04-17 04:20:59 | Colima, Mexico | |||
2669898 | 2669898 | 2022-04-15 | Mexico | Colima | 54631 | 2195 | 0 | 19.1223 | -104.0072 | 2022-04-16 04:20:48 | Colima, Mexico | |||
1223683 | 1223683 | 2022-04-14 | Mexico | Colima | 54631 | 2195 | 0 | 19.1223 | -104.0072 | 2022-04-15 04:20:57 | Colima, Mexico | |||
2442841 | 2442841 | 2022-04-13 | Mexico | Colima | 54631 | 2194 | 0 | 19.1223 | -104.0072 | 2022-04-13 23:21:06 | Colima, Mexico | |||
1948598 | 1948598 | 2022-04-12 | Mexico | Colima | 54629 | 2194 | 0 | 19.1223 | -104.0072 | 2022-04-13 04:21:03 | Colima, Mexico | |||
3206351 | 3206351 | 2022-04-11 | Mexico | Colima | 54630 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-12 04:20:49 | Colima, Mexico | |||
1576237 | 1576237 | 2022-04-10 | Mexico | Colima | 54629 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-11 04:21:02 | Colima, Mexico | |||
1652479 | 1652479 | 2022-04-09 | Mexico | Colima | 54628 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-10 04:20:52 | Colima, Mexico | |||
2115801 | 2115801 | 2022-04-08 | Mexico | Colima | 54614 | 2191 | 0 | 19.1223 | -104.0072 | 2022-04-09 04:20:42 | Colima, Mexico | |||
3320325 | 3320325 | 2022-04-07 | Mexico | Colima | 54606 | 2191 | 0 | 19.1223 | -104.0072 | 2022-04-08 04:20:48 | Colima, Mexico | |||
2800861 | 2800861 | 2022-04-06 | Mexico | Colima | 54596 | 2190 | 0 | 19.1223 | -104.0072 | 2022-04-07 04:20:53 | Colima, Mexico | |||
3867630 | 3867630 | 2022-04-05 | Mexico | Colima | 54572 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-06 04:20:49 | Colima, Mexico | |||
2748972 | 2748972 | 2022-04-04 | Mexico | Colima | 54556 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-05 04:20:48 | Colima, Mexico | |||
3730318 | 3730318 | 2022-04-03 | Mexico | Colima | 54550 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-04 04:20:51 | Colima, Mexico | |||
499753 | 499753 | 2022-04-02 | Mexico | Colima | 54548 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-03 04:20:48 | Colima, Mexico | |||
3350738 | 3350738 | 2022-04-01 | Mexico | Colima | 54534 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-02 04:20:47 | Colima, Mexico | |||
1540043 | 1540043 | 2022-03-31 | Mexico | Colima | 54516 | 2189 | 0 | 19.1223 | -104.0072 | 2022-04-01 04:20:28 | Colima, Mexico | |||
2478056 | 2478056 | 2022-03-30 | Mexico | Colima | 54502 | 2187 | 0 | 19.1223 | -104.0072 | 2022-03-31 04:20:56 | Colima, Mexico | |||
158097 | 158097 | 2022-03-29 | Mexico | Colima | 54502 | 2187 | 0 | 19.1223 | -104.0072 | 2022-03-30 04:20:45 | Colima, Mexico | |||
1436668 | 1436668 | 2022-03-28 | Mexico | Colima | 54488 | 2186 | 0 | 19.1223 | -104.0072 | 2022-03-29 04:20:46 | Colima, Mexico | |||
876349 | 876349 | 2022-03-27 | Mexico | Colima | 54480 | 2186 | 0 | 19.1223 | -104.0072 | 2022-03-28 04:20:33 | Colima, Mexico | |||
2163632 | 2163632 | 2022-03-26 | Mexico | Colima | 54470 | 2185 | 0 | 19.1223 | -104.0072 | 2022-03-27 04:20:47 | Colima, Mexico | |||
1720568 | 1720568 | 2022-03-25 | Mexico | Colima | 54470 | 2185 | 0 | 19.1223 | -104.0072 | 2022-03-26 04:20:23 | Colima, Mexico | |||
1468185 | 1468185 | 2022-03-24 | Mexico | Colima | 54429 | 2184 | 0 | 19.1223 | -104.0072 | 2022-03-25 04:20:46 | Colima, Mexico | |||
3022359 | 3022359 | 2022-03-23 | Mexico | Colima | 54408 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-24 04:20:43 | Colima, Mexico | |||
1905281 | 1905281 | 2022-03-22 | Mexico | Colima | 54408 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-23 04:20:48 | Colima, Mexico | |||
3238412 | 3238412 | 2022-03-21 | Mexico | Colima | 54398 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-22 04:20:54 | Colima, Mexico | |||
24485 | 24485 | 2022-03-20 | Mexico | Colima | 54394 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-21 04:20:50 | Colima, Mexico | |||
1656495 | 1656495 | 2022-03-19 | Mexico | Colima | 54384 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-20 04:20:45 | Colima, Mexico | |||
336021 | 336021 | 2022-03-18 | Mexico | Colima | 54371 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-19 04:20:47 | Colima, Mexico | |||
694474 | 694474 | 2022-03-17 | Mexico | Colima | 54371 | 2183 | 0 | 19.1223 | -104.0072 | 2022-03-18 04:20:55 | Colima, Mexico | |||
2319417 | 2319417 | 2022-03-16 | Mexico | Colima | 54353 | 2182 | 0 | 19.1223 | -104.0072 | 2022-03-17 04:20:56 | Colima, Mexico | |||
261617 | 261617 | 2022-03-15 | Mexico | Colima | 54318 | 2182 | 0 | 19.1223 | -104.0072 | 2022-03-16 04:20:50 | Colima, Mexico | |||
2263976 | 2263976 | 2022-03-14 | Mexico | Colima | 54318 | 2182 | 0 | 19.1223 | -104.0072 | 2022-03-15 04:20:47 | Colima, Mexico | |||
3628042 | 3628042 | 2022-03-13 | Mexico | Colima | 54315 | 2182 | 0 | 19.1223 | -104.0072 | 2022-03-14 04:20:46 | Colima, Mexico | |||
950950 | 950950 | 2022-03-12 | Mexico | Colima | 54309 | 2182 | 0 | 19.1223 | -104.0072 | 2022-03-13 04:20:49 | Colima, Mexico | |||
356411 | 356411 | 2022-03-11 | Mexico | Colima | 54272 | 2181 | 0 | 19.1223 | -104.0072 | 2022-03-12 04:20:50 | Colima, Mexico | |||
1865563 | 1865563 | 2022-03-10 | Mexico | Colima | 54272 | 2181 | 0 | 19.1223 | -104.0072 | 2022-03-11 04:20:50 | Colima, Mexico | |||
2140258 | 2140258 | 2022-03-09 | Mexico | Colima | 54254 | 2181 | 0 | 19.1223 | -104.0072 | 2022-03-10 04:20:48 | Colima, Mexico | |||
919769 | 919769 | 2022-03-08 | Mexico | Colima | 54225 | 2176 | 0 | 19.1223 | -104.0072 | 2022-03-09 04:20:59 | Colima, Mexico | |||
1548056 | 1548056 | 2022-03-07 | Mexico | Colima | 54182 | 2176 | 0 | 19.1223 | -104.0072 | 2022-03-08 04:20:54 | Colima, Mexico | |||
2199725 | 2199725 | 2022-03-06 | Mexico | Colima | 54178 | 2174 | 0 | 19.1223 | -104.0072 | 2022-03-07 04:20:47 | Colima, Mexico | |||
2092182 | 2092182 | 2022-03-05 | Mexico | Colima | 54163 | 2173 | 0 | 19.1223 | -104.0072 | 2022-03-06 04:20:49 | Colima, Mexico | |||
2665882 | 2665882 | 2022-03-04 | Mexico | Colima | 54137 | 2173 | 0 | 19.1223 | -104.0072 | 2022-03-05 04:21:10 | Colima, Mexico | |||
1644447 | 1644447 | 2022-03-03 | Mexico | Colima | 54094 | 2172 | 0 | 19.1223 | -104.0072 | 2022-03-04 04:21:09 | Colima, Mexico | |||
2525450 | 2525450 | 2022-03-02 | Mexico | Colima | 54038 | 2171 | 0 | 19.1223 | -104.0072 | 2022-03-03 04:21:01 | Colima, Mexico | |||
1992744 | 1992744 | 2022-03-01 | Mexico | Colima | 54038 | 2171 | 0 | 19.1223 | -104.0072 | 2022-03-02 04:21:07 | Colima, Mexico | |||
942918 | 942918 | 2022-02-28 | Mexico | Colima | 53975 | 2168 | 0 | 19.1223 | -104.0072 | 2022-03-01 04:21:09 | Colima, Mexico | |||
2733109 | 2733109 | 2022-02-27 | Mexico | Colima | 53962 | 2168 | 0 | 19.1223 | -104.0072 | 2022-02-28 04:21:05 | Colima, Mexico | |||
3046262 | 3046262 | 2022-02-26 | Mexico | Colima | 53943 | 2165 | 0 | 19.1223 | -104.0072 | 2022-02-27 04:21:04 | Colima, Mexico | |||
574917 | 574917 | 2022-02-25 | Mexico | Colima | 53864 | 2159 | 0 | 19.1223 | -104.0072 | 2022-02-26 04:21:12 | Colima, Mexico | |||
1511493 | 1511493 | 2022-02-24 | Mexico | Colima | 53774 | 2155 | 0 | 19.1223 | -104.0072 | 2022-02-25 04:21:11 | Colima, Mexico | |||
1057934 | 1057934 | 2022-02-23 | Mexico | Colima | 53657 | 2153 | 0 | 19.1223 | -104.0072 | 2022-02-24 04:21:14 | Colima, Mexico | |||
2446857 | 2446857 | 2022-02-22 | Mexico | Colima | 53420 | 2148 | 0 | 19.1223 | -104.0072 | 2022-02-23 04:21:09 | Colima, Mexico | |||
3718270 | 3718270 | 2022-02-21 | Mexico | Colima | 53396 | 2147 | 0 | 19.1223 | -104.0072 | 2022-02-22 04:21:01 | Colima, Mexico | |||
3912104 | 3912104 | 2022-02-20 | Mexico | Colima | 53396 | 2147 | 0 | 19.1223 | -104.0072 | 2022-02-21 04:21:05 | Colima, Mexico | |||
3875662 | 3875662 | 2022-02-19 | Mexico | Colima | 53345 | 2146 | 0 | 19.1223 | -104.0072 | 2022-02-20 04:21:00 | Colima, Mexico | |||
3855918 | 3855918 | 2022-02-18 | Mexico | Colima | 53044 | 2140 | 0 | 19.1223 | -104.0072 | 2022-02-19 04:21:11 | Colima, Mexico | |||
1298137 | 1298137 | 2022-02-17 | Mexico | Colima | 53044 | 2140 | 0 | 19.1223 | -104.0072 | 2022-02-18 04:21:04 | Colima, Mexico | |||
3820523 | 3820523 | 2022-02-16 | Mexico | Colima | 52845 | 2131 | 0 | 19.1223 | -104.0072 | 2022-02-17 04:20:56 | Colima, Mexico | |||
3671737 | 3671737 | 2022-02-15 | Mexico | Colima | 52390 | 2122 | 0 | 19.1223 | -104.0072 | 2022-02-16 04:21:10 | Colima, Mexico | |||
2641838 | 2641838 | 2022-02-14 | Mexico | Colima | 52276 | 2120 | 0 | 19.1223 | -104.0072 | 2022-02-15 04:21:09 | Colima, Mexico | |||
186155 | 186155 | 2022-02-13 | Mexico | Colima | 52165 | 2116 | 0 | 19.1223 | -104.0072 | 2022-02-14 04:20:51 | Colima, Mexico | |||
316001 | 316001 | 2022-02-12 | Mexico | Colima | 52165 | 2116 | 0 | 19.1223 | -104.0072 | 2022-02-13 04:21:00 | Colima, Mexico | |||
233327 | 233327 | 2022-02-11 | Mexico | Colima | 51344 | 2114 | 0 | 19.1223 | -104.0072 | 2022-02-12 04:21:06 | Colima, Mexico | |||
1464169 | 1464169 | 2022-02-10 | Mexico | Colima | 50672 | 2104 | 0 | 19.1223 | -104.0072 | 2022-02-11 04:21:09 | Colima, Mexico | |||
3074130 | 3074130 | 2022-02-09 | Mexico | Colima | 50672 | 2104 | 0 | 19.1223 | -104.0072 | 2022-02-10 04:21:14 | Colima, Mexico | |||
1362437 | 1362437 | 2022-02-08 | Mexico | Colima | 50130 | 2101 | 0 | 19.1223 | -104.0072 | 2022-02-09 04:21:04 | Colima, Mexico | |||
71175 | 71175 | 2022-02-07 | Mexico | Colima | 50046 | 2100 | 0 | 19.1223 | -104.0072 | 2022-02-08 04:21:15 | Colima, Mexico | |||
2012791 | 2012791 | 2022-02-06 | Mexico | Colima | 49729 | 2099 | 0 | 19.1223 | -104.0072 | 2022-02-07 04:21:05 | Colima, Mexico | |||
1294120 | 1294120 | 2022-02-05 | Mexico | Colima | 49568 | 2096 | 0 | 19.1223 | -104.0072 | 2022-02-06 04:21:00 | Colima, Mexico | |||
2327448 | 2327448 | 2022-02-04 | Mexico | Colima | 48768 | 2089 | 0 | 19.1223 | -104.0072 | 2022-02-05 04:21:05 | Colima, Mexico | |||
2474039 | 2474039 | 2022-02-03 | Mexico | Colima | 46835 | 2081 | 0 | 19.1223 | -104.0072 | 2022-02-04 04:21:10 | Colima, Mexico | |||
459464 | 459464 | 2022-02-02 | Mexico | Colima | 46035 | 2078 | 0 | 19.1223 | -104.0072 | 2022-02-03 04:21:21 | 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]);