johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Puebla" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, last_update, day (date), last_update (date)
recovered 174 ✖
- 0 778
- 30711 4
- 1038 1
- 1096 1
- 1141 1
- 1212 1
- 1278 1
- 1373 1
- 1478 1
- 1542 1
- 1637 1
- 1746 1
- 1827 1
- 1944 1
- 2073 1
- 2144 1
- 2280 1
- 2384 1
- 2474 1
- 2624 1
- 2763 1
- 2902 1
- 3010 1
- 3158 1
- 3315 1
- 3431 1
- 3550 1
- 3664 1
- 3910 1
- 4040 1
- 4208 1
- 4371 1
- 4604 1
- 4810 1
- 4982 1
- 5223 1
- 5462 1
- 5877 1
- 6071 1
- 6372 1
- 6630 1
- 6895 1
- 7354 1
- 7649 1
- 7933 1
- 8336 1
- 8790 1
- 9218 1
- 9430 1
- 9739 1
- 9974 1
- 10293 1
- 10585 1
- 10844 1
- 11094 1
- 11311 1
- 11545 1
- 11575 1
- 11852 1
- 12071 1
- 12134 1
- 12265 1
- 12369 1
- 12410 1
- 12690 1
- 12974 1
- 13076 1
- 13601 1
- 13931 1
- 14286 1
- 14657 1
- 14703 1
- 14880 1
- 15140 1
- 15322 1
- 15651 1
- 15751 1
- 16280 1
- 16617 1
- 16712 1
- 16954 1
- 17218 1
- 17433 1
- 17779 1
- 18350 1
- 18379 1
- 18544 1
- 18871 1
- 19087 1
- 19409 1
- 19674 1
- 19860 1
- 19922 1
- 19973 1
- 20314 1
- 20537 1
- 20629 1
- 20859 1
- 21042 1
- 21155 1
- 21209 1
- 21391 1
- 21537 1
- 21849 1
- 22000 1
- 22217 1
- 22222 1
- 22512 1
- 22836 1
- 22956 1
- 23137 1
- 23255 1
- 23439 1
- 23459 1
- 23601 1
- 23776 1
- 23943 1
- 24112 1
- 24293 1
- 24446 1
- 24622 1
- 24736 1
- 24937 1
- 24984 1
- 25066 1
- 25196 1
- 25340 1
- 25374 1
- 25503 1
- 25626 1
- 25717 1
- 25807 1
- 25953 1
- 26080 1
- 26113 1
- 26224 1
- 26285 1
- 26404 1
- 26463 1
- 26641 1
- 27181 1
- 27342 1
- 27396 1
- 27449 1
- 27590 1
- 27637 1
- 27751 1
- 27964 1
- 28003 1
- 28080 1
- 28269 1
- 28382 1
- 28432 1
- 28503 1
- 28642 1
- 28656 1
- 28772 1
- 28899 1
- 28961 1
- 29020 1
- 29148 1
- 29319 1
- 29359 1
- 29419 1
- 29664 1
- 29782 1
- 29871 1
- 29977 1
- 30121 1
- 30245 1
- 30296 1
- 30371 1
- 30462 1
- 30586 1
province_or_state 1
- Puebla · 954 ✖
country_or_region 1
- Mexico 954
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 | |||
8425 | 8425 | 2020-10-25 | Mexico | Puebla | 34864 | 4652 | 29148 | 1064 | 19.0414 | -98.2063 | 2020-10-26 04:25:02 | Puebla, Mexico | ||
12434 | 12434 | 2021-01-26 | Mexico | Puebla | 59274 | 6809 | 0 | 52465 | 19.0414 | -98.2063 | 2021-01-27 05:23:41 | Puebla, Mexico | ||
16450 | 16450 | 2021-09-18 | Mexico | Puebla | 114863 | 14008 | 0 | 19.0414 | -98.2063 | 2021-09-19 04:21:34 | Puebla, Mexico | |||
20465 | 20465 | 2021-05-28 | Mexico | Puebla | 85091 | 11836 | 0 | 73255 | 19.0414 | -98.2063 | 2021-05-29 04:20:41 | 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 | |||
36524 | 36524 | 2021-04-12 | Mexico | Puebla | 80608 | 10763 | 0 | 69845 | 19.0414 | -98.2063 | 2021-04-13 04:20:37 | Puebla, Mexico | ||
43804 | 43804 | 2021-11-02 | Mexico | Puebla | 123975 | 15312 | 0 | 19.0414 | -98.2063 | 2021-11-03 06:22:09 | Puebla, Mexico | |||
50886 | 50886 | 2021-05-29 | Mexico | Puebla | 85136 | 11865 | 0 | 73271 | 19.0414 | -98.2063 | 2021-05-30 04:20:55 | Puebla, Mexico | ||
54899 | 54899 | 2021-03-07 | Mexico | Puebla | 72826 | 9208 | 0 | 63618 | 19.0414 | -98.2063 | 2021-03-08 05:24:48 | Puebla, Mexico | ||
62417 | 62417 | 2020-07-23 | Mexico | Puebla | 17797 | 2116 | 13076 | 2605 | 19.0414 | -98.2063 | 2020-07-24 03:34:53 | 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 | |||
75183 | 75183 | 2020-12-03 | Mexico | Puebla | 40445 | 5205 | 0 | 35240 | 19.0414 | -98.2063 | 2020-12-04 05:27:27 | Puebla, Mexico | ||
79181 | 79181 | 2020-10-14 | Mexico | Puebla | 33406 | 4489 | 28080 | 837 | 19.0414 | -98.2063 | 2020-10-15 04:24:28 | Puebla, Mexico | ||
83189 | 83189 | 2021-05-25 | Mexico | Puebla | 84888 | 11751 | 0 | 73137 | 19.0414 | -98.2063 | 2021-05-26 04:20:35 | 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 | |||
98433 | 98433 | 2020-08-04 | Mexico | Puebla | 21019 | 2558 | 16617 | 1844 | 19.0414 | -98.2063 | 2020-08-05 04:34:43 | 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 | |||
107546 | 107546 | 2021-06-19 | Mexico | Puebla | 85901 | 12164 | 0 | 73737 | 19.0414 | -98.2063 | 2021-06-20 04:21:48 | Puebla, Mexico | ||
114849 | 114849 | 2022-09-06 | Mexico | Puebla | 207143 | 16642 | 0 | 19.0414 | -98.2063 | 2022-09-07 04:20:59 | Puebla, Mexico | |||
122025 | 122025 | 2020-07-19 | Mexico | Puebla | 16126 | 1986 | 11575 | 2565 | 19.0414 | -98.2063 | 2020-07-20 05:34:40 | Puebla, Mexico | ||
122798 | 122798 | 2020-11-18 | Mexico | Puebla | 37801 | 4987 | 0 | 32814 | 19.0414 | -98.2063 | 2020-11-19 05:25:23 | 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 | |||
146065 | 146065 | 2020-08-15 | Mexico | Puebla | 24118 | 3045 | 19409 | 1664 | 19.0414 | -98.2063 | 2020-08-16 04:27:42 | Puebla, Mexico | ||
150080 | 150080 | 2021-11-29 | Mexico | Puebla | 125753 | 15498 | 0 | 19.0414 | -98.2063 | 2021-11-30 04:22:53 | Puebla, Mexico | |||
154077 | 154077 | 2021-01-08 | Mexico | Puebla | 50104 | 5934 | 0 | 44170 | 19.0414 | -98.2063 | 2021-01-09 05:22:18 | 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 | |||
170138 | 170138 | 2021-04-16 | Mexico | Puebla | 81425 | 11017 | 0 | 70408 | 19.0414 | -98.2063 | 2021-04-17 04:20:40 | Puebla, Mexico | ||
177343 | 177343 | 2020-07-27 | Mexico | Puebla | 18831 | 2249 | 14657 | 1925 | 19.0414 | -98.2063 | 2020-07-28 04:58:43 | Puebla, Mexico | ||
178121 | 178121 | 2021-09-02 | Mexico | Puebla | 108330 | 13453 | 0 | 19.0414 | -98.2063 | 2021-09-03 04:21:20 | Puebla, Mexico | |||
182134 | 182134 | 2021-02-21 | Mexico | Puebla | 68704 | 8427 | 0 | 60277 | 19.0414 | -98.2063 | 2021-02-22 05:24:21 | Puebla, Mexico | ||
186167 | 186167 | 2022-02-13 | Mexico | Puebla | 157654 | 16003 | 0 | 19.0414 | -98.2063 | 2022-02-14 04:20:51 | Puebla, Mexico | |||
190163 | 190163 | 2021-01-11 | Mexico | Puebla | 51239 | 6025 | 0 | 45214 | 19.0414 | -98.2063 | 2021-01-12 05:22:15 | Puebla, Mexico | ||
194160 | 194160 | 2020-08-31 | Mexico | Puebla | 26899 | 3518 | 22222 | 1159 | 19.0414 | -98.2063 | 2020-09-01 04:28:31 | Puebla, Mexico | ||
198356 | 198356 | 2022-10-19 | Mexico | Puebla | 208257 | 16658 | 0 | 19.0414 | -98.2063 | 2022-10-20 04:22:59 | Puebla, Mexico | |||
202350 | 202350 | 2020-12-25 | Mexico | Puebla | 45359 | 5595 | 0 | 39764 | 19.0414 | -98.2063 | 2020-12-26 05:22:28 | Puebla, Mexico | ||
206347 | 206347 | 2020-08-19 | Mexico | Puebla | 24767 | 3213 | 19973 | 1581 | 19.0414 | -98.2063 | 2020-08-20 04:27:43 | Puebla, Mexico | ||
210334 | 210334 | 2020-10-29 | Mexico | Puebla | 35458 | 4729 | 29664 | 1065 | 19.0414 | -98.2063 | 2020-10-30 04:24:49 | Puebla, Mexico | ||
217296 | 217296 | 2020-06-08 | Mexico | Puebla | 4369 | 613 | 2902 | 854 | 19.0414 | -98.2063 | 2020-06-09 03:33:03 | 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 | |||
237335 | 237335 | 2021-01-18 | Mexico | Puebla | 54455 | 6305 | 0 | 48150 | 19.0414 | -98.2063 | 2021-01-19 05:22:15 | Puebla, Mexico | ||
241349 | 241349 | 2021-04-02 | Mexico | Puebla | 78985 | 10319 | 0 | 68666 | 19.0414 | -98.2063 | 2021-04-03 04:20:44 | 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 | |||
268370 | 268370 | 2020-05-21 | Mexico | Puebla | 1803 | 244 | 1096 | 463 | 19.0414 | -98.2063 | 2020-05-22 02:36:51 | Puebla, Mexico | ||
272249 | 272249 | 2020-11-10 | Mexico | Puebla | 36848 | 4883 | 30711 | 1254 | 19.0414 | -98.2063 | 2020-11-11 05:25:30 | Puebla, Mexico | ||
276279 | 276279 | 2021-11-03 | Mexico | Puebla | 124021 | 15319 | 0 | 19.0414 | -98.2063 | 2021-11-04 04:22:20 | Puebla, Mexico | |||
280277 | 280277 | 2021-02-24 | Mexico | Puebla | 69681 | 8610 | 0 | 61071 | 19.0414 | -98.2063 | 2021-02-25 05:24:57 | Puebla, Mexico | ||
287305 | 287305 | 2020-06-15 | Mexico | Puebla | 5672 | 735 | 3910 | 1027 | 19.0414 | -98.2063 | 2020-06-16 04:33:09 | 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 | |||
296107 | 296107 | 2021-07-15 | Mexico | Puebla | 87620 | 12375 | 0 | 75245 | 19.0414 | -98.2063 | 2021-07-16 04:21:22 | Puebla, Mexico | ||
303177 | 303177 | 2020-07-01 | Mexico | Puebla | 10719 | 1338 | 7933 | 1448 | 19.0414 | -98.2063 | 2020-07-02 04:33:46 | 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 | |||
327120 | 327120 | 2020-07-20 | Mexico | Puebla | 16386 | 1998 | 12071 | 2317 | 19.0414 | -98.2063 | 2020-07-21 04:38:46 | Puebla, Mexico | ||
328004 | 328004 | 2022-12-27 | Mexico | Puebla | 211162 | 16666 | 0 | 19.0414 | -98.2063 | 2022-12-28 04:21:04 | Puebla, Mexico | |||
332001 | 332001 | 2021-08-04 | Mexico | Puebla | 92228 | 12523 | 0 | 79705 | 19.0414 | -98.2063 | 2021-08-05 04:21:51 | Puebla, Mexico | ||
336033 | 336033 | 2022-03-18 | Mexico | Puebla | 168082 | 16369 | 0 | 19.0414 | -98.2063 | 2022-03-19 04:20:47 | Puebla, Mexico | |||
340369 | 340369 | 2021-02-03 | Mexico | Puebla | 62473 | 7200 | 0 | 55273 | 19.0414 | -98.2063 | 2021-02-04 05:22:26 | Puebla, Mexico | ||
344368 | 344368 | 2020-09-14 | Mexico | Puebla | 29259 | 3824 | 24446 | 989 | 19.0414 | -98.2063 | 2020-09-15 03:22:50 | Puebla, Mexico | ||
348394 | 348394 | 2022-12-14 | Mexico | Puebla | 209716 | 16661 | 0 | 19.0414 | -98.2063 | 2022-12-15 04:20:58 | Puebla, Mexico | |||
352390 | 352390 | 2021-03-11 | Mexico | Puebla | 73894 | 9395 | 0 | 64499 | 19.0414 | -98.2063 | 2021-03-12 05:26:50 | 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 | |||
367525 | 367525 | 2020-07-16 | Mexico | Puebla | 15182 | 1896 | 12410 | 876 | 19.0414 | -98.2063 | 2020-07-17 04:34:50 | Puebla, Mexico | ||
371498 | 371498 | 2020-08-08 | Mexico | Puebla | 22086 | 2797 | 17433 | 1856 | 19.0414 | -98.2063 | 2020-08-09 04:34:54 | Puebla, Mexico | ||
372294 | 372294 | 2022-09-13 | Mexico | Puebla | 207427 | 16648 | 0 | 19.0414 | -98.2063 | 2022-09-14 04:20:44 | Puebla, Mexico | |||
376276 | 376276 | 2020-11-06 | Mexico | Puebla | 36475 | 4857 | 30462 | 1156 | 19.0414 | -98.2063 | 2020-11-07 05:24:52 | Puebla, Mexico | ||
380287 | 380287 | 2021-04-30 | Mexico | Puebla | 83318 | 11384 | 0 | 71934 | 19.0414 | -98.2063 | 2021-05-01 04:20:47 | Puebla, Mexico | ||
384321 | 384321 | 2022-09-23 | Mexico | Puebla | 207887 | 16654 | 0 | 19.0414 | -98.2063 | 2022-09-24 04:21:40 | Puebla, Mexico | |||
388317 | 388317 | 2021-04-04 | Mexico | Puebla | 79238 | 10338 | 0 | 68900 | 19.0414 | -98.2063 | 2021-04-05 04:20:35 | Puebla, Mexico | ||
392329 | 392329 | 2020-11-27 | Mexico | Puebla | 39444 | 5136 | 0 | 34308 | 19.0414 | -98.2063 | 2020-11-28 05:25:50 | Puebla, Mexico | ||
396362 | 396362 | 2022-10-07 | Mexico | Puebla | 208139 | 16657 | 0 | 19.0414 | -98.2063 | 2022-10-08 04:22:56 | Puebla, Mexico | |||
400359 | 400359 | 2021-06-29 | Mexico | Puebla | 86325 | 12271 | 0 | 74054 | 19.0414 | -98.2063 | 2021-06-30 04:21:41 | Puebla, Mexico | ||
404390 | 404390 | 2021-12-07 | Mexico | Puebla | 125889 | 15577 | 0 | 19.0414 | -98.2063 | 2021-12-08 04:22:46 | Puebla, Mexico | |||
408389 | 408389 | 2021-07-28 | Mexico | Puebla | 90124 | 12455 | 0 | 77669 | 19.0414 | -98.2063 | 2021-07-29 04:21:33 | Puebla, Mexico | ||
415469 | 415469 | 2020-07-05 | Mexico | Puebla | 12049 | 1489 | 9430 | 1130 | 19.0414 | -98.2063 | 2020-07-06 04:33:57 | Puebla, Mexico | ||
419433 | 419433 | 2022-09-18 | Mexico | Puebla | 207617 | 16651 | 0 | 19.0414 | -98.2063 | 2022-09-19 04:21:49 | 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]);