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 = "Puebla" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533494 | 2533494 | 2022-05-12 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-13 04:20:51 | Puebla, Mexico | |||
3444940 | 3444940 | 2022-05-11 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-12 04:20:54 | Puebla, Mexico | |||
3535557 | 3535557 | 2022-05-10 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-11 04:20:48 | Puebla, Mexico | |||
222092 | 222092 | 2022-05-09 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-10 04:20:50 | Puebla, Mexico | |||
2331477 | 2331477 | 2022-05-08 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-09 04:20:54 | Puebla, Mexico | |||
360439 | 360439 | 2022-05-07 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-08 04:20:49 | Puebla, Mexico | |||
1397790 | 1397790 | 2022-05-06 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-07 04:21:09 | Puebla, Mexico | |||
2598145 | 2598145 | 2022-05-05 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-06 04:21:00 | Puebla, Mexico | |||
3265594 | 3265594 | 2022-05-04 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-05 04:20:55 | Puebla, Mexico | |||
1572233 | 1572233 | 2022-05-03 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-04 04:20:59 | Puebla, Mexico | |||
463493 | 463493 | 2022-05-02 | Mexico | Puebla | 169589 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-03 04:21:00 | Puebla, Mexico | |||
3916132 | 3916132 | 2022-05-01 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-02 04:21:10 | Puebla, Mexico | |||
2840936 | 2840936 | 2022-04-30 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-01 04:20:57 | Puebla, Mexico | |||
1157249 | 1157249 | 2022-04-29 | Mexico | Puebla | 169571 | 16452 | 0 | 19.0414 | -98.2063 | 2022-04-30 04:21:05 | Puebla, Mexico | |||
1696431 | 1696431 | 2022-04-28 | Mexico | Puebla | 169554 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-29 04:20:59 | Puebla, Mexico | |||
3851914 | 3851914 | 2022-04-27 | Mexico | Puebla | 169539 | 16452 | 0 | 19.0414 | -98.2063 | 2022-04-28 04:20:47 | Puebla, Mexico | |||
1326344 | 1326344 | 2022-04-26 | Mexico | Puebla | 169518 | 16452 | 0 | 19.0414 | -98.2063 | 2022-04-27 04:20:52 | Puebla, Mexico | |||
3722298 | 3722298 | 2022-04-25 | Mexico | Puebla | 169486 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-26 04:20:51 | Puebla, Mexico | |||
2028866 | 2028866 | 2022-04-24 | Mexico | Puebla | 169477 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-25 04:20:56 | Puebla, Mexico | |||
746441 | 746441 | 2022-04-23 | Mexico | Puebla | 169472 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-24 04:20:56 | Puebla, Mexico | |||
3436926 | 3436926 | 2022-04-22 | Mexico | Puebla | 169434 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-23 04:20:50 | Puebla, Mexico | |||
2892511 | 2892511 | 2022-04-21 | Mexico | Puebla | 169434 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-22 04:20:45 | Puebla, Mexico | |||
2307383 | 2307383 | 2022-04-20 | Mexico | Puebla | 169418 | 16453 | 0 | 19.0414 | -98.2063 | 2022-04-21 04:20:46 | Puebla, Mexico | |||
2251522 | 2251522 | 2022-04-19 | Mexico | Puebla | 169403 | 16451 | 0 | 19.0414 | -98.2063 | 2022-04-20 04:20:45 | Puebla, Mexico | |||
1846072 | 1846072 | 2022-04-18 | Mexico | Puebla | 169365 | 16451 | 0 | 19.0414 | -98.2063 | 2022-04-19 04:21:00 | Puebla, Mexico | |||
3417016 | 3417016 | 2022-04-17 | Mexico | Puebla | 169365 | 16451 | 0 | 19.0414 | -98.2063 | 2022-04-18 04:21:12 | Puebla, Mexico | |||
303965 | 303965 | 2022-04-16 | Mexico | Puebla | 169335 | 16451 | 0 | 19.0414 | -98.2063 | 2022-04-17 04:20:59 | Puebla, Mexico | |||
2669910 | 2669910 | 2022-04-15 | Mexico | Puebla | 169292 | 16450 | 0 | 19.0414 | -98.2063 | 2022-04-16 04:20:48 | Puebla, Mexico | |||
1223695 | 1223695 | 2022-04-14 | Mexico | Puebla | 169287 | 16450 | 0 | 19.0414 | -98.2063 | 2022-04-15 04:20:57 | Puebla, Mexico | |||
2442853 | 2442853 | 2022-04-13 | Mexico | Puebla | 169274 | 16440 | 0 | 19.0414 | -98.2063 | 2022-04-13 23:21:06 | Puebla, Mexico | |||
1948610 | 1948610 | 2022-04-12 | Mexico | Puebla | 169256 | 16439 | 0 | 19.0414 | -98.2063 | 2022-04-13 04:21:03 | Puebla, Mexico | |||
3206363 | 3206363 | 2022-04-11 | Mexico | Puebla | 169231 | 16439 | 0 | 19.0414 | -98.2063 | 2022-04-12 04:20:49 | Puebla, Mexico | |||
1576249 | 1576249 | 2022-04-10 | Mexico | Puebla | 169220 | 16439 | 0 | 19.0414 | -98.2063 | 2022-04-11 04:21:02 | Puebla, Mexico | |||
1652491 | 1652491 | 2022-04-09 | Mexico | Puebla | 169215 | 16439 | 0 | 19.0414 | -98.2063 | 2022-04-10 04:20:52 | Puebla, Mexico | |||
2115813 | 2115813 | 2022-04-08 | Mexico | Puebla | 169190 | 16436 | 0 | 19.0414 | -98.2063 | 2022-04-09 04:20:42 | Puebla, Mexico | |||
3320337 | 3320337 | 2022-04-07 | Mexico | Puebla | 169148 | 16434 | 0 | 19.0414 | -98.2063 | 2022-04-08 04:20:48 | Puebla, Mexico | |||
2800873 | 2800873 | 2022-04-06 | Mexico | Puebla | 169099 | 16430 | 0 | 19.0414 | -98.2063 | 2022-04-07 04:20:53 | Puebla, Mexico | |||
3867642 | 3867642 | 2022-04-05 | Mexico | Puebla | 169036 | 16429 | 0 | 19.0414 | -98.2063 | 2022-04-06 04:20:49 | Puebla, Mexico | |||
2748984 | 2748984 | 2022-04-04 | Mexico | Puebla | 168981 | 16428 | 0 | 19.0414 | -98.2063 | 2022-04-05 04:20:48 | Puebla, Mexico | |||
3730330 | 3730330 | 2022-04-03 | Mexico | Puebla | 168971 | 16426 | 0 | 19.0414 | -98.2063 | 2022-04-04 04:20:51 | Puebla, Mexico | |||
499765 | 499765 | 2022-04-02 | Mexico | Puebla | 168956 | 16426 | 0 | 19.0414 | -98.2063 | 2022-04-03 04:20:48 | Puebla, Mexico | |||
3350750 | 3350750 | 2022-04-01 | Mexico | Puebla | 168906 | 16424 | 0 | 19.0414 | -98.2063 | 2022-04-02 04:20:47 | Puebla, Mexico | |||
1540055 | 1540055 | 2022-03-31 | Mexico | Puebla | 168850 | 16423 | 0 | 19.0414 | -98.2063 | 2022-04-01 04:20:28 | Puebla, Mexico | |||
2478068 | 2478068 | 2022-03-30 | Mexico | Puebla | 168677 | 16419 | 0 | 19.0414 | -98.2063 | 2022-03-31 04:20:56 | Puebla, Mexico | |||
158109 | 158109 | 2022-03-29 | Mexico | Puebla | 168677 | 16419 | 0 | 19.0414 | -98.2063 | 2022-03-30 04:20:45 | Puebla, Mexico | |||
1436680 | 1436680 | 2022-03-28 | Mexico | Puebla | 168602 | 16418 | 0 | 19.0414 | -98.2063 | 2022-03-29 04:20:46 | Puebla, Mexico | |||
876361 | 876361 | 2022-03-27 | Mexico | Puebla | 168584 | 16418 | 0 | 19.0414 | -98.2063 | 2022-03-28 04:20:33 | Puebla, Mexico | |||
2163644 | 2163644 | 2022-03-26 | Mexico | Puebla | 168520 | 16409 | 0 | 19.0414 | -98.2063 | 2022-03-27 04:20:47 | Puebla, Mexico | |||
1720580 | 1720580 | 2022-03-25 | Mexico | Puebla | 168520 | 16409 | 0 | 19.0414 | -98.2063 | 2022-03-26 04:20:23 | Puebla, Mexico | |||
1468197 | 1468197 | 2022-03-24 | Mexico | Puebla | 168413 | 16384 | 0 | 19.0414 | -98.2063 | 2022-03-25 04:20:46 | Puebla, Mexico | |||
3022371 | 3022371 | 2022-03-23 | Mexico | Puebla | 168322 | 16380 | 0 | 19.0414 | -98.2063 | 2022-03-24 04:20:43 | Puebla, Mexico | |||
1905293 | 1905293 | 2022-03-22 | Mexico | Puebla | 168322 | 16380 | 0 | 19.0414 | -98.2063 | 2022-03-23 04:20:48 | Puebla, Mexico | |||
3238424 | 3238424 | 2022-03-21 | Mexico | Puebla | 168278 | 16380 | 0 | 19.0414 | -98.2063 | 2022-03-22 04:20:54 | Puebla, Mexico | |||
24497 | 24497 | 2022-03-20 | Mexico | Puebla | 168255 | 16380 | 0 | 19.0414 | -98.2063 | 2022-03-21 04:20:50 | Puebla, Mexico | |||
1656507 | 1656507 | 2022-03-19 | Mexico | Puebla | 168180 | 16375 | 0 | 19.0414 | -98.2063 | 2022-03-20 04:20:45 | Puebla, Mexico | |||
336033 | 336033 | 2022-03-18 | Mexico | Puebla | 168082 | 16369 | 0 | 19.0414 | -98.2063 | 2022-03-19 04:20:47 | Puebla, Mexico | |||
694486 | 694486 | 2022-03-17 | Mexico | Puebla | 168082 | 16369 | 0 | 19.0414 | -98.2063 | 2022-03-18 04:20:55 | Puebla, Mexico | |||
2319429 | 2319429 | 2022-03-16 | Mexico | Puebla | 167905 | 16355 | 0 | 19.0414 | -98.2063 | 2022-03-17 04:20:56 | Puebla, Mexico | |||
261629 | 261629 | 2022-03-15 | Mexico | Puebla | 167755 | 16347 | 0 | 19.0414 | -98.2063 | 2022-03-16 04:20:50 | Puebla, Mexico | |||
2263988 | 2263988 | 2022-03-14 | Mexico | Puebla | 167755 | 16347 | 0 | 19.0414 | -98.2063 | 2022-03-15 04:20:47 | Puebla, Mexico | |||
3628054 | 3628054 | 2022-03-13 | Mexico | Puebla | 167720 | 16347 | 0 | 19.0414 | -98.2063 | 2022-03-14 04:20:46 | Puebla, Mexico | |||
950962 | 950962 | 2022-03-12 | Mexico | Puebla | 167680 | 16347 | 0 | 19.0414 | -98.2063 | 2022-03-13 04:20:49 | Puebla, Mexico | |||
356423 | 356423 | 2022-03-11 | Mexico | Puebla | 167414 | 16311 | 0 | 19.0414 | -98.2063 | 2022-03-12 04:20:50 | Puebla, Mexico | |||
1865575 | 1865575 | 2022-03-10 | Mexico | Puebla | 167414 | 16311 | 0 | 19.0414 | -98.2063 | 2022-03-11 04:20:50 | Puebla, Mexico | |||
2140270 | 2140270 | 2022-03-09 | Mexico | Puebla | 167248 | 16302 | 0 | 19.0414 | -98.2063 | 2022-03-10 04:20:48 | Puebla, Mexico | |||
919781 | 919781 | 2022-03-08 | Mexico | Puebla | 167075 | 16294 | 0 | 19.0414 | -98.2063 | 2022-03-09 04:20:59 | Puebla, Mexico | |||
1548068 | 1548068 | 2022-03-07 | Mexico | Puebla | 166853 | 16277 | 0 | 19.0414 | -98.2063 | 2022-03-08 04:20:54 | Puebla, Mexico | |||
2199737 | 2199737 | 2022-03-06 | Mexico | Puebla | 166808 | 16276 | 0 | 19.0414 | -98.2063 | 2022-03-07 04:20:47 | Puebla, Mexico | |||
2092194 | 2092194 | 2022-03-05 | Mexico | Puebla | 166565 | 16264 | 0 | 19.0414 | -98.2063 | 2022-03-06 04:20:49 | Puebla, Mexico | |||
2665894 | 2665894 | 2022-03-04 | Mexico | Puebla | 166301 | 16253 | 0 | 19.0414 | -98.2063 | 2022-03-05 04:21:10 | Puebla, Mexico | |||
1644459 | 1644459 | 2022-03-03 | Mexico | Puebla | 166023 | 16235 | 0 | 19.0414 | -98.2063 | 2022-03-04 04:21:09 | Puebla, Mexico | |||
2525462 | 2525462 | 2022-03-02 | Mexico | Puebla | 165631 | 16230 | 0 | 19.0414 | -98.2063 | 2022-03-03 04:21:01 | Puebla, Mexico | |||
1992756 | 1992756 | 2022-03-01 | Mexico | Puebla | 165631 | 16230 | 0 | 19.0414 | -98.2063 | 2022-03-02 04:21:07 | Puebla, Mexico | |||
942930 | 942930 | 2022-02-28 | Mexico | Puebla | 165216 | 16214 | 0 | 19.0414 | -98.2063 | 2022-03-01 04:21:09 | Puebla, Mexico | |||
2733121 | 2733121 | 2022-02-27 | Mexico | Puebla | 165127 | 16214 | 0 | 19.0414 | -98.2063 | 2022-02-28 04:21:05 | Puebla, Mexico | |||
3046274 | 3046274 | 2022-02-26 | Mexico | Puebla | 164966 | 16212 | 0 | 19.0414 | -98.2063 | 2022-02-27 04:21:04 | Puebla, Mexico | |||
574929 | 574929 | 2022-02-25 | Mexico | Puebla | 164595 | 16199 | 0 | 19.0414 | -98.2063 | 2022-02-26 04:21:12 | Puebla, Mexico | |||
1511505 | 1511505 | 2022-02-24 | Mexico | Puebla | 163974 | 16186 | 0 | 19.0414 | -98.2063 | 2022-02-25 04:21:11 | Puebla, Mexico | |||
1057946 | 1057946 | 2022-02-23 | Mexico | Puebla | 163334 | 16170 | 0 | 19.0414 | -98.2063 | 2022-02-24 04:21:14 | Puebla, Mexico | |||
2446869 | 2446869 | 2022-02-22 | Mexico | Puebla | 162357 | 16097 | 0 | 19.0414 | -98.2063 | 2022-02-23 04:21:09 | Puebla, Mexico | |||
3718282 | 3718282 | 2022-02-21 | Mexico | Puebla | 162202 | 16090 | 0 | 19.0414 | -98.2063 | 2022-02-22 04:21:01 | Puebla, Mexico | |||
3912116 | 3912116 | 2022-02-20 | Mexico | Puebla | 162202 | 16090 | 0 | 19.0414 | -98.2063 | 2022-02-21 04:21:05 | Puebla, Mexico | |||
3875674 | 3875674 | 2022-02-19 | Mexico | Puebla | 161907 | 16090 | 0 | 19.0414 | -98.2063 | 2022-02-20 04:21:00 | Puebla, Mexico | |||
3855930 | 3855930 | 2022-02-18 | Mexico | Puebla | 160558 | 16053 | 0 | 19.0414 | -98.2063 | 2022-02-19 04:21:11 | Puebla, Mexico | |||
1298149 | 1298149 | 2022-02-17 | Mexico | Puebla | 160558 | 16053 | 0 | 19.0414 | -98.2063 | 2022-02-18 04:21:04 | Puebla, Mexico | |||
3820535 | 3820535 | 2022-02-16 | Mexico | Puebla | 159915 | 16043 | 0 | 19.0414 | -98.2063 | 2022-02-17 04:20:56 | Puebla, Mexico | |||
3671749 | 3671749 | 2022-02-15 | Mexico | Puebla | 158505 | 16015 | 0 | 19.0414 | -98.2063 | 2022-02-16 04:21:10 | Puebla, Mexico | |||
2641850 | 2641850 | 2022-02-14 | Mexico | Puebla | 158087 | 16009 | 0 | 19.0414 | -98.2063 | 2022-02-15 04:21:09 | Puebla, Mexico | |||
186167 | 186167 | 2022-02-13 | Mexico | Puebla | 157654 | 16003 | 0 | 19.0414 | -98.2063 | 2022-02-14 04:20:51 | Puebla, Mexico | |||
316013 | 316013 | 2022-02-12 | Mexico | Puebla | 157654 | 16003 | 0 | 19.0414 | -98.2063 | 2022-02-13 04:21:00 | Puebla, Mexico | |||
233339 | 233339 | 2022-02-11 | Mexico | Puebla | 155720 | 15963 | 0 | 19.0414 | -98.2063 | 2022-02-12 04:21:06 | Puebla, Mexico | |||
1464181 | 1464181 | 2022-02-10 | Mexico | Puebla | 154657 | 15937 | 0 | 19.0414 | -98.2063 | 2022-02-11 04:21:09 | Puebla, Mexico | |||
3074142 | 3074142 | 2022-02-09 | Mexico | Puebla | 154657 | 15937 | 0 | 19.0414 | -98.2063 | 2022-02-10 04:21:14 | Puebla, Mexico | |||
1362449 | 1362449 | 2022-02-08 | Mexico | Puebla | 153872 | 15913 | 0 | 19.0414 | -98.2063 | 2022-02-09 04:21:04 | Puebla, Mexico | |||
71187 | 71187 | 2022-02-07 | Mexico | Puebla | 153403 | 15911 | 0 | 19.0414 | -98.2063 | 2022-02-08 04:21:15 | Puebla, Mexico | |||
2012803 | 2012803 | 2022-02-06 | Mexico | Puebla | 152911 | 15911 | 0 | 19.0414 | -98.2063 | 2022-02-07 04:21:05 | Puebla, Mexico | |||
1294132 | 1294132 | 2022-02-05 | Mexico | Puebla | 152444 | 15910 | 0 | 19.0414 | -98.2063 | 2022-02-06 04:21:00 | Puebla, Mexico | |||
2327460 | 2327460 | 2022-02-04 | Mexico | Puebla | 151587 | 15903 | 0 | 19.0414 | -98.2063 | 2022-02-05 04:21:05 | Puebla, Mexico | |||
2474051 | 2474051 | 2022-02-03 | Mexico | Puebla | 149456 | 15895 | 0 | 19.0414 | -98.2063 | 2022-02-04 04:21:10 | Puebla, Mexico | |||
459476 | 459476 | 2022-02-02 | Mexico | Puebla | 148502 | 15882 | 0 | 19.0414 | -98.2063 | 2022-02-03 04:21:21 | Puebla, 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]);