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 = "Campeche" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533477 | 2533477 | 2022-05-12 | Mexico | Campeche | 34111 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-13 04:20:51 | Campeche, Mexico | |||
3444923 | 3444923 | 2022-05-11 | Mexico | Campeche | 34111 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-12 04:20:54 | Campeche, Mexico | |||
3535540 | 3535540 | 2022-05-10 | Mexico | Campeche | 34111 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-11 04:20:48 | Campeche, Mexico | |||
222075 | 222075 | 2022-05-09 | Mexico | Campeche | 34111 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-10 04:20:50 | Campeche, Mexico | |||
2331460 | 2331460 | 2022-05-08 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-09 04:20:54 | Campeche, Mexico | |||
360422 | 360422 | 2022-05-07 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-08 04:20:49 | Campeche, Mexico | |||
1397773 | 1397773 | 2022-05-06 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-07 04:21:09 | Campeche, Mexico | |||
2598128 | 2598128 | 2022-05-05 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-06 04:21:00 | Campeche, Mexico | |||
3265577 | 3265577 | 2022-05-04 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-05 04:20:55 | Campeche, Mexico | |||
1572216 | 1572216 | 2022-05-03 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-04 04:20:59 | Campeche, Mexico | |||
463476 | 463476 | 2022-05-02 | Mexico | Campeche | 34091 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-03 04:21:00 | Campeche, Mexico | |||
3916115 | 3916115 | 2022-05-01 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-02 04:21:10 | Campeche, Mexico | |||
2840919 | 2840919 | 2022-04-30 | Mexico | Campeche | 34089 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-01 04:20:57 | Campeche, Mexico | |||
1157232 | 1157232 | 2022-04-29 | Mexico | Campeche | 34084 | 2242 | 0 | 19.8301 | -90.5349 | 2022-04-30 04:21:05 | Campeche, Mexico | |||
1696414 | 1696414 | 2022-04-28 | Mexico | Campeche | 34078 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-29 04:20:59 | Campeche, Mexico | |||
3851897 | 3851897 | 2022-04-27 | Mexico | Campeche | 34073 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-28 04:20:47 | Campeche, Mexico | |||
1326327 | 1326327 | 2022-04-26 | Mexico | Campeche | 34059 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-27 04:20:52 | Campeche, Mexico | |||
3722281 | 3722281 | 2022-04-25 | Mexico | Campeche | 34054 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-26 04:20:51 | Campeche, Mexico | |||
2028849 | 2028849 | 2022-04-24 | Mexico | Campeche | 34053 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-25 04:20:56 | Campeche, Mexico | |||
746424 | 746424 | 2022-04-23 | Mexico | Campeche | 34053 | 2241 | 0 | 19.8301 | -90.5349 | 2022-04-24 04:20:56 | Campeche, Mexico | |||
3436909 | 3436909 | 2022-04-22 | Mexico | Campeche | 34047 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-23 04:20:50 | Campeche, Mexico | |||
2892494 | 2892494 | 2022-04-21 | Mexico | Campeche | 34047 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-22 04:20:45 | Campeche, Mexico | |||
2307366 | 2307366 | 2022-04-20 | Mexico | Campeche | 34044 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-21 04:20:46 | Campeche, Mexico | |||
2251505 | 2251505 | 2022-04-19 | Mexico | Campeche | 34038 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-20 04:20:45 | Campeche, Mexico | |||
1846055 | 1846055 | 2022-04-18 | Mexico | Campeche | 34029 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-19 04:21:00 | Campeche, Mexico | |||
3416999 | 3416999 | 2022-04-17 | Mexico | Campeche | 34029 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-18 04:21:12 | Campeche, Mexico | |||
303948 | 303948 | 2022-04-16 | Mexico | Campeche | 34019 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-17 04:20:59 | Campeche, Mexico | |||
2669893 | 2669893 | 2022-04-15 | Mexico | Campeche | 34010 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-16 04:20:48 | Campeche, Mexico | |||
1223678 | 1223678 | 2022-04-14 | Mexico | Campeche | 34009 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-15 04:20:57 | Campeche, Mexico | |||
2442836 | 2442836 | 2022-04-13 | Mexico | Campeche | 34008 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-13 23:21:06 | Campeche, Mexico | |||
1948593 | 1948593 | 2022-04-12 | Mexico | Campeche | 34008 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-13 04:21:03 | Campeche, Mexico | |||
3206346 | 3206346 | 2022-04-11 | Mexico | Campeche | 34007 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-12 04:20:49 | Campeche, Mexico | |||
1576232 | 1576232 | 2022-04-10 | Mexico | Campeche | 34006 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-11 04:21:02 | Campeche, Mexico | |||
1652474 | 1652474 | 2022-04-09 | Mexico | Campeche | 34005 | 2240 | 0 | 19.8301 | -90.5349 | 2022-04-10 04:20:52 | Campeche, Mexico | |||
2115796 | 2115796 | 2022-04-08 | Mexico | Campeche | 34001 | 2236 | 0 | 19.8301 | -90.5349 | 2022-04-09 04:20:42 | Campeche, Mexico | |||
3320320 | 3320320 | 2022-04-07 | Mexico | Campeche | 33995 | 2235 | 0 | 19.8301 | -90.5349 | 2022-04-08 04:20:48 | Campeche, Mexico | |||
2800856 | 2800856 | 2022-04-06 | Mexico | Campeche | 33991 | 2235 | 0 | 19.8301 | -90.5349 | 2022-04-07 04:20:53 | Campeche, Mexico | |||
3867625 | 3867625 | 2022-04-05 | Mexico | Campeche | 33963 | 2235 | 0 | 19.8301 | -90.5349 | 2022-04-06 04:20:49 | Campeche, Mexico | |||
2748967 | 2748967 | 2022-04-04 | Mexico | Campeche | 33942 | 2235 | 0 | 19.8301 | -90.5349 | 2022-04-05 04:20:48 | Campeche, Mexico | |||
3730313 | 3730313 | 2022-04-03 | Mexico | Campeche | 33942 | 2235 | 0 | 19.8301 | -90.5349 | 2022-04-04 04:20:51 | Campeche, Mexico | |||
499748 | 499748 | 2022-04-02 | Mexico | Campeche | 33939 | 2234 | 0 | 19.8301 | -90.5349 | 2022-04-03 04:20:48 | Campeche, Mexico | |||
3350733 | 3350733 | 2022-04-01 | Mexico | Campeche | 33924 | 2234 | 0 | 19.8301 | -90.5349 | 2022-04-02 04:20:47 | Campeche, Mexico | |||
1540038 | 1540038 | 2022-03-31 | Mexico | Campeche | 33913 | 2234 | 0 | 19.8301 | -90.5349 | 2022-04-01 04:20:28 | Campeche, Mexico | |||
2478051 | 2478051 | 2022-03-30 | Mexico | Campeche | 33884 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-31 04:20:56 | Campeche, Mexico | |||
158092 | 158092 | 2022-03-29 | Mexico | Campeche | 33884 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-30 04:20:45 | Campeche, Mexico | |||
1436663 | 1436663 | 2022-03-28 | Mexico | Campeche | 33859 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-29 04:20:46 | Campeche, Mexico | |||
876344 | 876344 | 2022-03-27 | Mexico | Campeche | 33849 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-28 04:20:33 | Campeche, Mexico | |||
2163627 | 2163627 | 2022-03-26 | Mexico | Campeche | 33840 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-27 04:20:47 | Campeche, Mexico | |||
1720563 | 1720563 | 2022-03-25 | Mexico | Campeche | 33840 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-26 04:20:23 | Campeche, Mexico | |||
1468180 | 1468180 | 2022-03-24 | Mexico | Campeche | 33816 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-25 04:20:46 | Campeche, Mexico | |||
3022354 | 3022354 | 2022-03-23 | Mexico | Campeche | 33795 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-24 04:20:43 | Campeche, Mexico | |||
1905276 | 1905276 | 2022-03-22 | Mexico | Campeche | 33795 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-23 04:20:48 | Campeche, Mexico | |||
3238407 | 3238407 | 2022-03-21 | Mexico | Campeche | 33790 | 2234 | 0 | 19.8301 | -90.5349 | 2022-03-22 04:20:54 | Campeche, Mexico | |||
24480 | 24480 | 2022-03-20 | Mexico | Campeche | 33789 | 2233 | 0 | 19.8301 | -90.5349 | 2022-03-21 04:20:50 | Campeche, Mexico | |||
1656490 | 1656490 | 2022-03-19 | Mexico | Campeche | 33782 | 2233 | 0 | 19.8301 | -90.5349 | 2022-03-20 04:20:45 | Campeche, Mexico | |||
336016 | 336016 | 2022-03-18 | Mexico | Campeche | 33766 | 2232 | 0 | 19.8301 | -90.5349 | 2022-03-19 04:20:47 | Campeche, Mexico | |||
694469 | 694469 | 2022-03-17 | Mexico | Campeche | 33766 | 2232 | 0 | 19.8301 | -90.5349 | 2022-03-18 04:20:55 | Campeche, Mexico | |||
2319412 | 2319412 | 2022-03-16 | Mexico | Campeche | 33724 | 2232 | 0 | 19.8301 | -90.5349 | 2022-03-17 04:20:56 | Campeche, Mexico | |||
261612 | 261612 | 2022-03-15 | Mexico | Campeche | 33697 | 2230 | 0 | 19.8301 | -90.5349 | 2022-03-16 04:20:50 | Campeche, Mexico | |||
2263971 | 2263971 | 2022-03-14 | Mexico | Campeche | 33697 | 2230 | 0 | 19.8301 | -90.5349 | 2022-03-15 04:20:47 | Campeche, Mexico | |||
3628037 | 3628037 | 2022-03-13 | Mexico | Campeche | 33695 | 2230 | 0 | 19.8301 | -90.5349 | 2022-03-14 04:20:46 | Campeche, Mexico | |||
950945 | 950945 | 2022-03-12 | Mexico | Campeche | 33689 | 2229 | 0 | 19.8301 | -90.5349 | 2022-03-13 04:20:49 | Campeche, Mexico | |||
356406 | 356406 | 2022-03-11 | Mexico | Campeche | 33597 | 2228 | 0 | 19.8301 | -90.5349 | 2022-03-12 04:20:50 | Campeche, Mexico | |||
1865558 | 1865558 | 2022-03-10 | Mexico | Campeche | 33597 | 2228 | 0 | 19.8301 | -90.5349 | 2022-03-11 04:20:50 | Campeche, Mexico | |||
2140253 | 2140253 | 2022-03-09 | Mexico | Campeche | 33570 | 2227 | 0 | 19.8301 | -90.5349 | 2022-03-10 04:20:48 | Campeche, Mexico | |||
919764 | 919764 | 2022-03-08 | Mexico | Campeche | 33489 | 2226 | 0 | 19.8301 | -90.5349 | 2022-03-09 04:20:59 | Campeche, Mexico | |||
1548051 | 1548051 | 2022-03-07 | Mexico | Campeche | 33446 | 2226 | 0 | 19.8301 | -90.5349 | 2022-03-08 04:20:54 | Campeche, Mexico | |||
2199720 | 2199720 | 2022-03-06 | Mexico | Campeche | 33445 | 2226 | 0 | 19.8301 | -90.5349 | 2022-03-07 04:20:47 | Campeche, Mexico | |||
2092177 | 2092177 | 2022-03-05 | Mexico | Campeche | 33392 | 2226 | 0 | 19.8301 | -90.5349 | 2022-03-06 04:20:49 | Campeche, Mexico | |||
2665877 | 2665877 | 2022-03-04 | Mexico | Campeche | 33341 | 2223 | 0 | 19.8301 | -90.5349 | 2022-03-05 04:21:10 | Campeche, Mexico | |||
1644442 | 1644442 | 2022-03-03 | Mexico | Campeche | 33309 | 2220 | 0 | 19.8301 | -90.5349 | 2022-03-04 04:21:09 | Campeche, Mexico | |||
2525445 | 2525445 | 2022-03-02 | Mexico | Campeche | 33261 | 2217 | 0 | 19.8301 | -90.5349 | 2022-03-03 04:21:01 | Campeche, Mexico | |||
1992739 | 1992739 | 2022-03-01 | Mexico | Campeche | 33261 | 2217 | 0 | 19.8301 | -90.5349 | 2022-03-02 04:21:07 | Campeche, Mexico | |||
942913 | 942913 | 2022-02-28 | Mexico | Campeche | 33228 | 2216 | 0 | 19.8301 | -90.5349 | 2022-03-01 04:21:09 | Campeche, Mexico | |||
2733104 | 2733104 | 2022-02-27 | Mexico | Campeche | 33225 | 2216 | 0 | 19.8301 | -90.5349 | 2022-02-28 04:21:05 | Campeche, Mexico | |||
3046257 | 3046257 | 2022-02-26 | Mexico | Campeche | 33196 | 2215 | 0 | 19.8301 | -90.5349 | 2022-02-27 04:21:04 | Campeche, Mexico | |||
574912 | 574912 | 2022-02-25 | Mexico | Campeche | 33119 | 2212 | 0 | 19.8301 | -90.5349 | 2022-02-26 04:21:12 | Campeche, Mexico | |||
1511488 | 1511488 | 2022-02-24 | Mexico | Campeche | 33055 | 2208 | 0 | 19.8301 | -90.5349 | 2022-02-25 04:21:11 | Campeche, Mexico | |||
1057929 | 1057929 | 2022-02-23 | Mexico | Campeche | 32973 | 2204 | 0 | 19.8301 | -90.5349 | 2022-02-24 04:21:14 | Campeche, Mexico | |||
2446852 | 2446852 | 2022-02-22 | Mexico | Campeche | 32797 | 2191 | 0 | 19.8301 | -90.5349 | 2022-02-23 04:21:09 | Campeche, Mexico | |||
3718265 | 3718265 | 2022-02-21 | Mexico | Campeche | 32780 | 2189 | 0 | 19.8301 | -90.5349 | 2022-02-22 04:21:01 | Campeche, Mexico | |||
3912099 | 3912099 | 2022-02-20 | Mexico | Campeche | 32780 | 2189 | 0 | 19.8301 | -90.5349 | 2022-02-21 04:21:05 | Campeche, Mexico | |||
3875657 | 3875657 | 2022-02-19 | Mexico | Campeche | 32752 | 2188 | 0 | 19.8301 | -90.5349 | 2022-02-20 04:21:00 | Campeche, Mexico | |||
3855913 | 3855913 | 2022-02-18 | Mexico | Campeche | 32535 | 2170 | 0 | 19.8301 | -90.5349 | 2022-02-19 04:21:11 | Campeche, Mexico | |||
1298132 | 1298132 | 2022-02-17 | Mexico | Campeche | 32535 | 2170 | 0 | 19.8301 | -90.5349 | 2022-02-18 04:21:04 | Campeche, Mexico | |||
3820518 | 3820518 | 2022-02-16 | Mexico | Campeche | 32425 | 2158 | 0 | 19.8301 | -90.5349 | 2022-02-17 04:20:56 | Campeche, Mexico | |||
3671732 | 3671732 | 2022-02-15 | Mexico | Campeche | 32267 | 2152 | 0 | 19.8301 | -90.5349 | 2022-02-16 04:21:10 | Campeche, Mexico | |||
2641833 | 2641833 | 2022-02-14 | Mexico | Campeche | 32233 | 2149 | 0 | 19.8301 | -90.5349 | 2022-02-15 04:21:09 | Campeche, Mexico | |||
186150 | 186150 | 2022-02-13 | Mexico | Campeche | 32138 | 2147 | 0 | 19.8301 | -90.5349 | 2022-02-14 04:20:51 | Campeche, Mexico | |||
315996 | 315996 | 2022-02-12 | Mexico | Campeche | 32138 | 2147 | 0 | 19.8301 | -90.5349 | 2022-02-13 04:21:00 | Campeche, Mexico | |||
233322 | 233322 | 2022-02-11 | Mexico | Campeche | 31815 | 2140 | 0 | 19.8301 | -90.5349 | 2022-02-12 04:21:06 | Campeche, Mexico | |||
1464164 | 1464164 | 2022-02-10 | Mexico | Campeche | 31657 | 2138 | 0 | 19.8301 | -90.5349 | 2022-02-11 04:21:09 | Campeche, Mexico | |||
3074125 | 3074125 | 2022-02-09 | Mexico | Campeche | 31657 | 2138 | 0 | 19.8301 | -90.5349 | 2022-02-10 04:21:14 | Campeche, Mexico | |||
1362432 | 1362432 | 2022-02-08 | Mexico | Campeche | 31488 | 2136 | 0 | 19.8301 | -90.5349 | 2022-02-09 04:21:04 | Campeche, Mexico | |||
71170 | 71170 | 2022-02-07 | Mexico | Campeche | 31440 | 2135 | 0 | 19.8301 | -90.5349 | 2022-02-08 04:21:15 | Campeche, Mexico | |||
2012786 | 2012786 | 2022-02-06 | Mexico | Campeche | 31393 | 2135 | 0 | 19.8301 | -90.5349 | 2022-02-07 04:21:05 | Campeche, Mexico | |||
1294115 | 1294115 | 2022-02-05 | Mexico | Campeche | 31286 | 2132 | 0 | 19.8301 | -90.5349 | 2022-02-06 04:21:00 | Campeche, Mexico | |||
2327443 | 2327443 | 2022-02-04 | Mexico | Campeche | 31042 | 2131 | 0 | 19.8301 | -90.5349 | 2022-02-05 04:21:05 | Campeche, Mexico | |||
2474034 | 2474034 | 2022-02-03 | Mexico | Campeche | 30423 | 2126 | 0 | 19.8301 | -90.5349 | 2022-02-04 04:21:10 | Campeche, Mexico | |||
459459 | 459459 | 2022-02-02 | Mexico | Campeche | 30108 | 2124 | 0 | 19.8301 | -90.5349 | 2022-02-03 04:21:21 | Campeche, 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]);