johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Puebla" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
426 | 426 | 2021-12-02 | Mexico | Puebla | 125812 | 15513 | 0 | 19.0414 | -98.2063 | 2021-12-03 04:23:05 | Puebla, Mexico | |||
4442 | 4442 | 2021-10-28 | Mexico | Puebla | 123706 | 15257 | 0 | 19.0414 | -98.2063 | 2021-10-29 04:22:03 | Puebla, Mexico | |||
16450 | 16450 | 2021-09-18 | Mexico | Puebla | 114863 | 14008 | 0 | 19.0414 | -98.2063 | 2021-09-19 04:21:34 | Puebla, Mexico | |||
24497 | 24497 | 2022-03-20 | Mexico | Puebla | 168255 | 16380 | 0 | 19.0414 | -98.2063 | 2022-03-21 04:20:50 | Puebla, Mexico | |||
28512 | 28512 | 2021-11-11 | Mexico | Puebla | 124476 | 15392 | 0 | 19.0414 | -98.2063 | 2021-11-12 04:22:01 | Puebla, Mexico | |||
32511 | 32511 | 2021-08-25 | Mexico | Puebla | 104067 | 13065 | 0 | 19.0414 | -98.2063 | 2021-08-26 04:21:28 | Puebla, Mexico | |||
43804 | 43804 | 2021-11-02 | Mexico | Puebla | 123975 | 15312 | 0 | 19.0414 | -98.2063 | 2021-11-03 06:22:09 | Puebla, Mexico | |||
63159 | 63159 | 2022-11-12 | Mexico | Puebla | 208540 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-13 04:21:14 | Puebla, Mexico | |||
67156 | 67156 | 2021-09-01 | Mexico | Puebla | 107725 | 13405 | 0 | 19.0414 | -98.2063 | 2021-09-02 04:21:15 | Puebla, Mexico | |||
71187 | 71187 | 2022-02-07 | Mexico | Puebla | 153403 | 15911 | 0 | 19.0414 | -98.2063 | 2022-02-08 04:21:15 | Puebla, Mexico | |||
87221 | 87221 | 2021-11-09 | Mexico | Puebla | 124373 | 15366 | 0 | 19.0414 | -98.2063 | 2021-11-10 04:21:38 | Puebla, Mexico | |||
91239 | 91239 | 2022-07-23 | Mexico | Puebla | 192420 | 16527 | 0 | 19.0414 | -98.2063 | 2022-07-24 04:20:47 | Puebla, Mexico | |||
99422 | 99422 | 2022-01-14 | Mexico | Puebla | 130891 | 15758 | 0 | 19.0414 | -98.2063 | 2022-01-15 04:21:07 | Puebla, Mexico | |||
103421 | 103421 | 2021-08-15 | Mexico | Puebla | 97477 | 12707 | 0 | 19.0414 | -98.2063 | 2021-08-16 04:21:31 | Puebla, Mexico | |||
114849 | 114849 | 2022-09-06 | Mexico | Puebla | 207143 | 16642 | 0 | 19.0414 | -98.2063 | 2022-09-07 04:20:59 | Puebla, Mexico | |||
126829 | 126829 | 2022-01-09 | Mexico | Puebla | 128564 | 15742 | 0 | 19.0414 | -98.2063 | 2022-01-10 04:22:07 | Puebla, Mexico | |||
130847 | 130847 | 2022-10-04 | Mexico | Puebla | 208055 | 16655 | 0 | 19.0414 | -98.2063 | 2022-10-05 04:23:06 | Puebla, Mexico | |||
138067 | 138067 | 2021-12-04 | Mexico | Puebla | 125854 | 15533 | 0 | 19.0414 | -98.2063 | 2021-12-05 04:22:25 | Puebla, Mexico | |||
142085 | 142085 | 2022-07-09 | Mexico | Puebla | 180322 | 16497 | 0 | 19.0414 | -98.2063 | 2022-07-10 04:20:54 | Puebla, Mexico | |||
150080 | 150080 | 2021-11-29 | Mexico | Puebla | 125753 | 15498 | 0 | 19.0414 | -98.2063 | 2021-11-30 04:22:53 | Puebla, Mexico | |||
158109 | 158109 | 2022-03-29 | Mexico | Puebla | 168677 | 16419 | 0 | 19.0414 | -98.2063 | 2022-03-30 04:20:45 | Puebla, Mexico | |||
162124 | 162124 | 2021-11-19 | Mexico | Puebla | 124699 | 15436 | 0 | 19.0414 | -98.2063 | 2021-11-20 04:22:17 | Puebla, Mexico | |||
166142 | 166142 | 2022-06-21 | Mexico | Puebla | 171826 | 16486 | 0 | 19.0414 | -98.2063 | 2022-06-22 04:20:54 | Puebla, Mexico | |||
178121 | 178121 | 2021-09-02 | Mexico | Puebla | 108330 | 13453 | 0 | 19.0414 | -98.2063 | 2021-09-03 04:21:20 | Puebla, Mexico | |||
186167 | 186167 | 2022-02-13 | Mexico | Puebla | 157654 | 16003 | 0 | 19.0414 | -98.2063 | 2022-02-14 04:20:51 | Puebla, Mexico | |||
198356 | 198356 | 2022-10-19 | Mexico | Puebla | 208257 | 16658 | 0 | 19.0414 | -98.2063 | 2022-10-20 04:22:59 | Puebla, Mexico | |||
218077 | 218077 | 2022-12-26 | Mexico | Puebla | 210969 | 16666 | 0 | 19.0414 | -98.2063 | 2022-12-27 04:21:07 | Puebla, Mexico | |||
222092 | 222092 | 2022-05-09 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-10 04:20:50 | Puebla, Mexico | |||
229324 | 229324 | 2022-05-31 | Mexico | Puebla | 170131 | 16465 | 0 | 19.0414 | -98.2063 | 2022-06-01 04:20:55 | Puebla, Mexico | |||
233339 | 233339 | 2022-02-11 | Mexico | Puebla | 155720 | 15963 | 0 | 19.0414 | -98.2063 | 2022-02-12 04:21:06 | Puebla, Mexico | |||
245364 | 245364 | 2021-08-17 | Mexico | Puebla | 98712 | 12754 | 0 | 19.0414 | -98.2063 | 2021-08-18 04:21:35 | Puebla, Mexico | |||
249378 | 249378 | 2021-09-04 | Mexico | Puebla | 109436 | 13547 | 0 | 19.0414 | -98.2063 | 2021-09-05 04:21:33 | Puebla, Mexico | |||
253411 | 253411 | 2022-09-08 | Mexico | Puebla | 207143 | 16642 | 0 | 19.0414 | -98.2063 | 2022-09-09 04:21:11 | Puebla, Mexico | |||
257427 | 257427 | 2022-12-10 | Mexico | Puebla | 209479 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-11 04:20:50 | Puebla, Mexico | |||
261629 | 261629 | 2022-03-15 | Mexico | Puebla | 167755 | 16347 | 0 | 19.0414 | -98.2063 | 2022-03-16 04:20:50 | Puebla, Mexico | |||
276279 | 276279 | 2021-11-03 | Mexico | Puebla | 124021 | 15319 | 0 | 19.0414 | -98.2063 | 2021-11-04 04:22:20 | Puebla, Mexico | |||
288092 | 288092 | 2021-10-31 | Mexico | Puebla | 123943 | 15308 | 0 | 19.0414 | -98.2063 | 2021-11-01 04:22:01 | Puebla, Mexico | |||
292110 | 292110 | 2022-11-15 | Mexico | Puebla | 208618 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-16 04:21:09 | Puebla, Mexico | |||
303965 | 303965 | 2022-04-16 | Mexico | Puebla | 169335 | 16451 | 0 | 19.0414 | -98.2063 | 2022-04-17 04:20:59 | Puebla, Mexico | |||
307982 | 307982 | 2022-12-13 | Mexico | Puebla | 209716 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-14 04:21:04 | Puebla, Mexico | |||
311998 | 311998 | 2022-11-13 | Mexico | Puebla | 208540 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-14 04:21:09 | Puebla, Mexico | |||
316013 | 316013 | 2022-02-12 | Mexico | Puebla | 157654 | 16003 | 0 | 19.0414 | -98.2063 | 2022-02-13 04:21:00 | Puebla, Mexico | |||
320030 | 320030 | 2022-10-30 | Mexico | Puebla | 208427 | 16660 | 0 | 19.0414 | -98.2063 | 2022-10-31 04:21:36 | Puebla, Mexico | |||
328004 | 328004 | 2022-12-27 | Mexico | Puebla | 211162 | 16666 | 0 | 19.0414 | -98.2063 | 2022-12-28 04:21:04 | Puebla, Mexico | |||
336033 | 336033 | 2022-03-18 | Mexico | Puebla | 168082 | 16369 | 0 | 19.0414 | -98.2063 | 2022-03-19 04:20:47 | Puebla, Mexico | |||
348394 | 348394 | 2022-12-14 | Mexico | Puebla | 209716 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-15 04:20:58 | Puebla, Mexico | |||
356423 | 356423 | 2022-03-11 | Mexico | Puebla | 167414 | 16311 | 0 | 19.0414 | -98.2063 | 2022-03-12 04:20:50 | Puebla, Mexico | |||
360439 | 360439 | 2022-05-07 | Mexico | Puebla | 169587 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-08 04:20:49 | Puebla, Mexico | |||
372294 | 372294 | 2022-09-13 | Mexico | Puebla | 207427 | 16648 | 0 | 19.0414 | -98.2063 | 2022-09-14 04:20:44 | Puebla, Mexico | |||
384321 | 384321 | 2022-09-23 | Mexico | Puebla | 207887 | 16654 | 0 | 19.0414 | -98.2063 | 2022-09-24 04:21:40 | Puebla, Mexico | |||
396362 | 396362 | 2022-10-07 | Mexico | Puebla | 208139 | 16657 | 0 | 19.0414 | -98.2063 | 2022-10-08 04:22:56 | Puebla, Mexico | |||
404390 | 404390 | 2021-12-07 | Mexico | Puebla | 125889 | 15577 | 0 | 19.0414 | -98.2063 | 2021-12-08 04:22:46 | Puebla, Mexico | |||
419433 | 419433 | 2022-09-18 | Mexico | Puebla | 207617 | 16651 | 0 | 19.0414 | -98.2063 | 2022-09-19 04:21:49 | Puebla, Mexico | |||
423447 | 423447 | 2021-10-10 | Mexico | Puebla | 121674 | 14790 | 0 | 19.0414 | -98.2063 | 2021-10-11 04:21:31 | Puebla, Mexico | |||
431455 | 431455 | 2022-11-03 | Mexico | Puebla | 208484 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-04 04:22:11 | Puebla, Mexico | |||
443451 | 443451 | 2021-10-20 | Mexico | Puebla | 122970 | 15089 | 0 | 19.0414 | -98.2063 | 2021-10-21 04:21:18 | Puebla, Mexico | |||
447467 | 447467 | 2021-11-17 | Mexico | Puebla | 124669 | 15425 | 0 | 19.0414 | -98.2063 | 2021-11-18 04:21:33 | Puebla, Mexico | |||
451485 | 451485 | 2022-12-21 | Mexico | Puebla | 210223 | 16662 | 0 | 19.0414 | -98.2063 | 2022-12-22 04:20:56 | Puebla, Mexico | |||
459476 | 459476 | 2022-02-02 | Mexico | Puebla | 148502 | 15882 | 0 | 19.0414 | -98.2063 | 2022-02-03 04:21:21 | Puebla, Mexico | |||
463493 | 463493 | 2022-05-02 | Mexico | Puebla | 169589 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-03 04:21:00 | Puebla, Mexico | |||
467508 | 467508 | 2021-10-07 | Mexico | Puebla | 121019 | 14727 | 0 | 19.0414 | -98.2063 | 2021-10-08 04:21:25 | Puebla, Mexico | |||
475540 | 475540 | 2022-06-26 | Mexico | Puebla | 173278 | 16490 | 0 | 19.0414 | -98.2063 | 2022-06-27 04:21:00 | Puebla, Mexico | |||
479688 | 479688 | 2022-11-08 | Mexico | Puebla | 208464 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-09 04:21:22 | Puebla, Mexico | |||
487718 | 487718 | 2022-11-25 | Mexico | Puebla | 208907 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-26 04:21:11 | Puebla, Mexico | |||
491732 | 491732 | 2021-10-14 | Mexico | Puebla | 122260 | 14927 | 0 | 19.0414 | -98.2063 | 2021-10-15 04:21:26 | Puebla, Mexico | |||
495748 | 495748 | 2021-11-06 | Mexico | Puebla | 124241 | 15357 | 0 | 19.0414 | -98.2063 | 2021-11-07 04:21:53 | Puebla, Mexico | |||
499765 | 499765 | 2022-04-02 | Mexico | Puebla | 168956 | 16426 | 0 | 19.0414 | -98.2063 | 2022-04-03 04:20:48 | Puebla, Mexico | |||
503782 | 503782 | 2022-12-17 | Mexico | Puebla | 210076 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-18 04:21:03 | Puebla, Mexico | |||
507779 | 507779 | 2021-08-14 | Mexico | Puebla | 97477 | 12707 | 0 | 19.0414 | -98.2063 | 2021-08-15 04:21:41 | Puebla, Mexico | |||
511793 | 511793 | 2021-08-19 | Mexico | Puebla | 100527 | 12874 | 0 | 19.0414 | -98.2063 | 2021-08-20 04:21:33 | Puebla, Mexico | |||
515826 | 515826 | 2022-10-15 | Mexico | Puebla | 208250 | 16658 | 0 | 19.0414 | -98.2063 | 2022-10-16 04:22:39 | Puebla, Mexico | |||
534832 | 534832 | 2021-10-27 | Mexico | Puebla | 123508 | 15200 | 0 | 19.0414 | -98.2063 | 2021-10-28 04:22:08 | Puebla, Mexico | |||
538850 | 538850 | 2022-10-26 | Mexico | Puebla | 208386 | 16660 | 0 | 19.0414 | -98.2063 | 2022-10-27 04:22:01 | Puebla, Mexico | |||
542866 | 542866 | 2022-12-15 | Mexico | Puebla | 209789 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-16 04:21:01 | Puebla, Mexico | |||
550870 | 550870 | 2021-12-08 | Mexico | Puebla | 125917 | 15580 | 0 | 19.0414 | -98.2063 | 2021-12-09 04:22:49 | Puebla, Mexico | |||
554886 | 554886 | 2022-01-16 | Mexico | Puebla | 133019 | 15782 | 0 | 19.0414 | -98.2063 | 2022-01-17 04:21:08 | Puebla, Mexico | |||
558904 | 558904 | 2022-06-16 | Mexico | Puebla | 171215 | 16465 | 0 | 19.0414 | -98.2063 | 2022-06-17 04:20:56 | Puebla, Mexico | |||
567200 | 567200 | 2021-10-29 | Mexico | Puebla | 123797 | 15273 | 0 | 19.0414 | -98.2063 | 2021-10-30 04:22:03 | Puebla, Mexico | |||
574929 | 574929 | 2022-02-25 | Mexico | Puebla | 164595 | 16199 | 0 | 19.0414 | -98.2063 | 2022-02-26 04:21:12 | Puebla, Mexico | |||
589723 | 589723 | 2021-08-08 | Mexico | Puebla | 94191 | 12584 | 0 | 19.0414 | -98.2063 | 2021-08-09 04:21:24 | Puebla, Mexico | |||
593756 | 593756 | 2022-07-01 | Mexico | Puebla | 175348 | 16492 | 0 | 19.0414 | -98.2063 | 2022-07-02 04:21:16 | Puebla, Mexico | |||
597770 | 597770 | 2021-10-19 | Mexico | Puebla | 122834 | 15034 | 0 | 19.0414 | -98.2063 | 2021-10-20 04:21:00 | Puebla, Mexico | |||
601786 | 601786 | 2021-09-23 | Mexico | Puebla | 116774 | 14308 | 0 | 19.0414 | -98.2063 | 2021-09-24 04:21:44 | Puebla, Mexico | |||
617960 | 617960 | 2022-11-05 | Mexico | Puebla | 208495 | 16661 | 0 | 19.0414 | -98.2063 | 2022-11-06 04:21:24 | Puebla, Mexico | |||
621976 | 621976 | 2022-05-22 | Mexico | Puebla | 169894 | 16463 | 0 | 19.0414 | -98.2063 | 2022-05-26 04:20:50 | Puebla, Mexico | |||
630006 | 630006 | 2022-07-12 | Mexico | Puebla | 182002 | 16502 | 0 | 19.0414 | -98.2063 | 2022-07-13 04:20:58 | Puebla, Mexico | |||
634020 | 634020 | 2021-10-13 | Mexico | Puebla | 122105 | 14904 | 0 | 19.0414 | -98.2063 | 2021-10-14 04:21:29 | Puebla, Mexico | |||
642033 | 642033 | 2021-09-07 | Mexico | Puebla | 110347 | 13669 | 0 | 19.0414 | -98.2063 | 2021-09-08 04:21:31 | Puebla, Mexico | |||
650061 | 650061 | 2021-08-09 | Mexico | Puebla | 94393 | 12588 | 0 | 19.0414 | -98.2063 | 2021-08-10 04:21:27 | Puebla, Mexico | |||
654092 | 654092 | 2021-10-22 | Mexico | Puebla | 123196 | 15127 | 0 | 19.0414 | -98.2063 | 2021-10-23 04:21:32 | Puebla, Mexico | |||
658411 | 658411 | 2022-05-13 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-14 04:20:48 | Puebla, Mexico | |||
670397 | 670397 | 2022-07-21 | Mexico | Puebla | 190238 | 16522 | 0 | 19.0414 | -98.2063 | 2022-07-22 04:21:15 | Puebla, Mexico | |||
674413 | 674413 | 2022-07-30 | Mexico | Puebla | 195917 | 16545 | 0 | 19.0414 | -98.2063 | 2022-07-31 04:21:02 | Puebla, Mexico | |||
682437 | 682437 | 2021-10-24 | Mexico | Puebla | 123281 | 15140 | 0 | 19.0414 | -98.2063 | 2021-10-25 04:22:31 | Puebla, Mexico | |||
686453 | 686453 | 2021-11-13 | Mexico | Puebla | 124516 | 15405 | 0 | 19.0414 | -98.2063 | 2021-11-14 04:21:31 | Puebla, Mexico | |||
690471 | 690471 | 2022-12-23 | Mexico | Puebla | 210223 | 16662 | 0 | 19.0414 | -98.2063 | 2022-12-24 04:21:02 | Puebla, Mexico | |||
694486 | 694486 | 2022-03-17 | Mexico | Puebla | 168082 | 16369 | 0 | 19.0414 | -98.2063 | 2022-03-18 04:20:55 | Puebla, Mexico | |||
698501 | 698501 | 2021-11-04 | Mexico | Puebla | 124044 | 15324 | 0 | 19.0414 | -98.2063 | 2021-11-05 04:21:54 | Puebla, Mexico | |||
706531 | 706531 | 2021-09-29 | Mexico | Puebla | 118876 | 14496 | 0 | 19.0414 | -98.2063 | 2021-09-30 04:21:20 | Puebla, Mexico | |||
710548 | 710548 | 2022-11-01 | Mexico | Puebla | 208427 | 16660 | 0 | 19.0414 | -98.2063 | 2022-11-02 04:22:09 | 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]);