johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Iowa, Wisconsin, US" and province_or_state = "Wisconsin" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756458 | 2756458 | 2022-12-29 | US | Wisconsin | Iowa | 55049 | 6749 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-30 04:21:04 | Iowa, Wisconsin, US | |
1077464 | 1077464 | 2022-12-28 | US | Wisconsin | Iowa | 55049 | 6747 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-29 04:21:01 | Iowa, Wisconsin, US | |
331461 | 331461 | 2022-12-27 | US | Wisconsin | Iowa | 55049 | 6738 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-28 04:21:04 | Iowa, Wisconsin, US | |
221534 | 221534 | 2022-12-26 | US | Wisconsin | Iowa | 55049 | 6733 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-27 04:21:07 | Iowa, Wisconsin, US | |
3225991 | 3225991 | 2022-12-25 | US | Wisconsin | Iowa | 55049 | 6723 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-26 04:21:06 | Iowa, Wisconsin, US | |
1021905 | 1021905 | 2022-12-24 | US | Wisconsin | Iowa | 55049 | 6723 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-25 04:21:04 | Iowa, Wisconsin, US | |
693928 | 693928 | 2022-12-23 | US | Wisconsin | Iowa | 55049 | 6723 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-24 04:21:02 | Iowa, Wisconsin, US | |
2183138 | 2183138 | 2022-12-22 | US | Wisconsin | Iowa | 55049 | 6717 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-23 04:21:04 | Iowa, Wisconsin, US | |
454942 | 454942 | 2022-12-21 | US | Wisconsin | Iowa | 55049 | 6709 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-22 04:20:56 | Iowa, Wisconsin, US | |
2954941 | 2954941 | 2022-12-20 | US | Wisconsin | Iowa | 55049 | 6702 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-21 04:21:03 | Iowa, Wisconsin, US | |
3177343 | 3177343 | 2022-12-19 | US | Wisconsin | Iowa | 55049 | 6700 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-20 04:21:04 | Iowa, Wisconsin, US | |
1631860 | 1631860 | 2022-12-18 | US | Wisconsin | Iowa | 55049 | 6690 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-19 04:21:03 | Iowa, Wisconsin, US | |
507239 | 507239 | 2022-12-17 | US | Wisconsin | Iowa | 55049 | 6690 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-18 04:21:03 | Iowa, Wisconsin, US | |
3327811 | 3327811 | 2022-12-16 | US | Wisconsin | Iowa | 55049 | 6690 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-17 04:21:04 | Iowa, Wisconsin, US | |
546323 | 546323 | 2022-12-15 | US | Wisconsin | Iowa | 55049 | 6682 | 32 | 0 | 43.00050278 | -90.13469017 | 2022-12-16 04:21:01 | Iowa, Wisconsin, US | |
351851 | 351851 | 2022-12-14 | US | Wisconsin | Iowa | 55049 | 6673 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-15 04:20:58 | Iowa, Wisconsin, US | |
311439 | 311439 | 2022-12-13 | US | Wisconsin | Iowa | 55049 | 6665 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-14 04:21:04 | Iowa, Wisconsin, US | |
1152500 | 1152500 | 2022-12-12 | US | Wisconsin | Iowa | 55049 | 6660 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-13 04:21:01 | Iowa, Wisconsin, US | |
872354 | 872354 | 2022-12-11 | US | Wisconsin | Iowa | 55049 | 6651 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-12 04:21:01 | Iowa, Wisconsin, US | |
260884 | 260884 | 2022-12-10 | US | Wisconsin | Iowa | 55049 | 6651 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-11 04:20:50 | Iowa, Wisconsin, US | |
3939598 | 3939598 | 2022-12-09 | US | Wisconsin | Iowa | 55049 | 6651 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-10 04:21:02 | Iowa, Wisconsin, US | |
3380930 | 3380930 | 2022-12-08 | US | Wisconsin | Iowa | 55049 | 6647 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-09 04:21:05 | Iowa, Wisconsin, US | |
1988201 | 1988201 | 2022-12-07 | US | Wisconsin | Iowa | 55049 | 6637 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-08 04:21:07 | Iowa, Wisconsin, US | |
3717724 | 3717724 | 2022-12-06 | US | Wisconsin | Iowa | 55049 | 6632 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-07 04:20:58 | Iowa, Wisconsin, US | |
2418429 | 2418429 | 2022-12-05 | US | Wisconsin | Iowa | 55049 | 6631 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-06 04:21:03 | Iowa, Wisconsin, US | |
722037 | 722037 | 2022-12-04 | US | Wisconsin | Iowa | 55049 | 6619 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-05 04:20:58 | Iowa, Wisconsin, US | |
2820326 | 2820326 | 2022-12-03 | US | Wisconsin | Iowa | 55049 | 6619 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-04 04:20:56 | Iowa, Wisconsin, US | |
837182 | 837182 | 2022-12-02 | US | Wisconsin | Iowa | 55049 | 6619 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-03 04:21:02 | Iowa, Wisconsin, US | |
2139712 | 2139712 | 2022-12-01 | US | Wisconsin | Iowa | 55049 | 6609 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-02 04:21:07 | Iowa, Wisconsin, US | |
1968128 | 1968128 | 2022-11-30 | US | Wisconsin | Iowa | 55049 | 6604 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-12-01 04:21:03 | Iowa, Wisconsin, US | |
2560142 | 2560142 | 2022-11-29 | US | Wisconsin | Iowa | 55049 | 6602 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-30 04:21:07 | Iowa, Wisconsin, US | |
1243216 | 1243216 | 2022-11-28 | US | Wisconsin | Iowa | 55049 | 6596 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-29 04:21:05 | Iowa, Wisconsin, US | |
3555204 | 3555204 | 2022-11-27 | US | Wisconsin | Iowa | 55049 | 6588 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-28 04:21:02 | Iowa, Wisconsin, US | |
2103684 | 2103684 | 2022-11-26 | US | Wisconsin | Iowa | 55049 | 6588 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-27 04:21:05 | Iowa, Wisconsin, US | |
491175 | 491175 | 2022-11-25 | US | Wisconsin | Iowa | 55049 | 6588 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-26 04:21:11 | Iowa, Wisconsin, US | |
3527004 | 3527004 | 2022-11-24 | US | Wisconsin | Iowa | 55049 | 6587 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-25 04:21:06 | Iowa, Wisconsin, US | |
3315787 | 3315787 | 2022-11-23 | US | Wisconsin | Iowa | 55049 | 6584 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-24 04:21:09 | Iowa, Wisconsin, US | |
1623828 | 1623828 | 2022-11-22 | US | Wisconsin | Iowa | 55049 | 6577 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-23 04:21:06 | Iowa, Wisconsin, US | |
3463716 | 3463716 | 2022-11-21 | US | Wisconsin | Iowa | 55049 | 6573 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-22 04:20:47 | Iowa, Wisconsin, US | |
1643901 | 1643901 | 2022-11-20 | US | Wisconsin | Iowa | 55049 | 6566 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-21 04:21:05 | Iowa, Wisconsin, US | |
2067458 | 2067458 | 2022-11-19 | US | Wisconsin | Iowa | 55049 | 6566 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-20 04:21:08 | Iowa, Wisconsin, US | |
1758852 | 1758852 | 2022-11-18 | US | Wisconsin | Iowa | 55049 | 6566 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-19 04:21:14 | Iowa, Wisconsin, US | |
3029845 | 3029845 | 2022-11-17 | US | Wisconsin | Iowa | 55049 | 6563 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-18 04:21:15 | Iowa, Wisconsin, US | |
2489556 | 2489556 | 2022-11-16 | US | Wisconsin | Iowa | 55049 | 6560 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-17 04:21:11 | Iowa, Wisconsin, US | |
295567 | 295567 | 2022-11-15 | US | Wisconsin | Iowa | 55049 | 6551 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-16 04:21:09 | Iowa, Wisconsin, US | |
3600597 | 3600597 | 2022-11-14 | US | Wisconsin | Iowa | 55049 | 6547 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-15 04:21:16 | Iowa, Wisconsin, US | |
315455 | 315455 | 2022-11-13 | US | Wisconsin | Iowa | 55049 | 6541 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-14 04:21:09 | Iowa, Wisconsin, US | |
66616 | 66616 | 2022-11-12 | US | Wisconsin | Iowa | 55049 | 6541 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-13 04:21:14 | Iowa, Wisconsin, US | |
2930778 | 2930778 | 2022-11-11 | US | Wisconsin | Iowa | 55049 | 6541 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-12 04:20:41 | Iowa, Wisconsin, US | |
2509614 | 2509614 | 2022-11-10 | US | Wisconsin | Iowa | 55049 | 6538 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-11 04:21:22 | Iowa, Wisconsin, US | |
2434489 | 2434489 | 2022-11-09 | US | Wisconsin | Iowa | 55049 | 6534 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-10 04:21:16 | Iowa, Wisconsin, US | |
483145 | 483145 | 2022-11-08 | US | Wisconsin | Iowa | 55049 | 6526 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-09 04:21:22 | Iowa, Wisconsin, US | |
2442295 | 2442295 | 2022-11-07 | US | Wisconsin | Iowa | 55049 | 6520 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-08 04:21:21 | Iowa, Wisconsin, US | |
1053393 | 1053393 | 2022-11-06 | US | Wisconsin | Iowa | 55049 | 6513 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-07 04:21:26 | Iowa, Wisconsin, US | |
621417 | 621417 | 2022-11-05 | US | Wisconsin | Iowa | 55049 | 6513 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-06 04:21:24 | Iowa, Wisconsin, US | |
1025921 | 1025921 | 2022-11-04 | US | Wisconsin | Iowa | 55049 | 6513 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-05 04:21:52 | Iowa, Wisconsin, US | |
434912 | 434912 | 2022-11-03 | US | Wisconsin | Iowa | 55049 | 6511 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-04 04:22:11 | Iowa, Wisconsin, US | |
853154 | 853154 | 2022-11-02 | US | Wisconsin | Iowa | 55049 | 6502 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-03 04:22:05 | Iowa, Wisconsin, US | |
714005 | 714005 | 2022-11-01 | US | Wisconsin | Iowa | 55049 | 6501 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-02 04:22:09 | Iowa, Wisconsin, US | |
3288454 | 3288454 | 2022-10-31 | US | Wisconsin | Iowa | 55049 | 6501 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-11-01 04:22:36 | Iowa, Wisconsin, US | |
323487 | 323487 | 2022-10-30 | US | Wisconsin | Iowa | 55049 | 6494 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-31 04:21:36 | Iowa, Wisconsin, US | |
915763 | 915763 | 2022-10-29 | US | Wisconsin | Iowa | 55049 | 6494 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-30 04:22:14 | Iowa, Wisconsin, US | |
1370032 | 1370032 | 2022-10-28 | US | Wisconsin | Iowa | 55049 | 6494 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-29 04:21:13 | Iowa, Wisconsin, US | |
3041887 | 3041887 | 2022-10-27 | US | Wisconsin | Iowa | 55049 | 6490 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-28 04:22:31 | Iowa, Wisconsin, US | |
542307 | 542307 | 2022-10-26 | US | Wisconsin | Iowa | 55049 | 6483 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-27 04:22:01 | Iowa, Wisconsin, US | |
1833708 | 1833708 | 2022-10-25 | US | Wisconsin | Iowa | 55049 | 6479 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-26 04:22:19 | Iowa, Wisconsin, US | |
797969 | 797969 | 2022-10-24 | US | Wisconsin | Iowa | 55049 | 6477 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-25 04:21:53 | Iowa, Wisconsin, US | |
3280424 | 3280424 | 2022-10-23 | US | Wisconsin | Iowa | 55049 | 6469 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-24 04:22:29 | Iowa, Wisconsin, US | |
2271462 | 2271462 | 2022-10-22 | US | Wisconsin | Iowa | 55049 | 6469 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-23 04:22:46 | Iowa, Wisconsin, US | |
1595762 | 1595762 | 2022-10-21 | US | Wisconsin | Iowa | 55049 | 6469 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-22 04:22:53 | Iowa, Wisconsin, US | |
2275478 | 2275478 | 2022-10-20 | US | Wisconsin | Iowa | 55049 | 6463 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-21 04:22:23 | Iowa, Wisconsin, US | |
201813 | 201813 | 2022-10-19 | US | Wisconsin | Iowa | 55049 | 6454 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-20 04:22:59 | Iowa, Wisconsin, US | |
2760474 | 2760474 | 2022-10-18 | US | Wisconsin | Iowa | 55049 | 6445 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-19 04:22:26 | Iowa, Wisconsin, US | |
2028308 | 2028308 | 2022-10-17 | US | Wisconsin | Iowa | 55049 | 6439 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-18 04:22:42 | Iowa, Wisconsin, US | |
2163086 | 2163086 | 2022-10-16 | US | Wisconsin | Iowa | 55049 | 6432 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-17 04:20:31 | Iowa, Wisconsin, US | |
519283 | 519283 | 2022-10-15 | US | Wisconsin | Iowa | 55049 | 6432 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-16 04:22:39 | Iowa, Wisconsin, US | |
2036340 | 2036340 | 2022-10-14 | US | Wisconsin | Iowa | 55049 | 6432 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-15 04:22:00 | Iowa, Wisconsin, US | |
3757028 | 3757028 | 2022-10-13 | US | Wisconsin | Iowa | 55049 | 6428 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-14 04:22:28 | Iowa, Wisconsin, US | |
3217853 | 3217853 | 2022-10-12 | US | Wisconsin | Iowa | 55049 | 6420 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-13 04:22:39 | Iowa, Wisconsin, US | |
3253702 | 3253702 | 2022-10-11 | US | Wisconsin | Iowa | 55049 | 6419 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-12 04:22:51 | Iowa, Wisconsin, US | |
2970961 | 2970961 | 2022-10-10 | US | Wisconsin | Iowa | 55049 | 6416 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-11 04:23:05 | Iowa, Wisconsin, US | |
3100997 | 3100997 | 2022-10-09 | US | Wisconsin | Iowa | 55049 | 6409 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-10 04:22:32 | Iowa, Wisconsin, US | |
4006222 | 4006222 | 2022-10-08 | US | Wisconsin | Iowa | 55049 | 6409 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-09 04:21:16 | Iowa, Wisconsin, US | |
399819 | 399819 | 2022-10-07 | US | Wisconsin | Iowa | 55049 | 6409 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-08 04:22:56 | Iowa, Wisconsin, US | |
2532936 | 2532936 | 2022-10-06 | US | Wisconsin | Iowa | 55049 | 6403 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-07 04:23:08 | Iowa, Wisconsin, US | |
1814330 | 1814330 | 2022-10-05 | US | Wisconsin | Iowa | 55049 | 6401 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-06 04:21:22 | Iowa, Wisconsin, US | |
134304 | 134304 | 2022-10-04 | US | Wisconsin | Iowa | 55049 | 6396 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-05 04:23:06 | Iowa, Wisconsin, US | |
2689251 | 2689251 | 2022-10-03 | US | Wisconsin | Iowa | 55049 | 6394 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-04 04:22:55 | Iowa, Wisconsin, US | |
2263318 | 2263318 | 2022-10-02 | US | Wisconsin | Iowa | 55049 | 6387 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-03 04:23:11 | Iowa, Wisconsin, US | |
2998844 | 2998844 | 2022-10-01 | US | Wisconsin | Iowa | 55049 | 6387 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-02 04:21:23 | Iowa, Wisconsin, US | |
857170 | 857170 | 2022-09-30 | US | Wisconsin | Iowa | 55049 | 6387 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-10-01 04:23:01 | Iowa, Wisconsin, US | |
2379096 | 2379096 | 2022-09-29 | US | Wisconsin | Iowa | 55049 | 6385 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-30 04:23:09 | Iowa, Wisconsin, US | |
1563647 | 1563647 | 2022-09-28 | US | Wisconsin | Iowa | 55049 | 6382 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-29 04:22:34 | Iowa, Wisconsin, US | |
3998190 | 3998190 | 2022-09-27 | US | Wisconsin | Iowa | 55049 | 6382 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-28 04:23:01 | Iowa, Wisconsin, US | |
2772518 | 2772518 | 2022-09-26 | US | Wisconsin | Iowa | 55049 | 6378 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-27 04:23:01 | Iowa, Wisconsin, US | |
1980171 | 1980171 | 2022-09-25 | US | Wisconsin | Iowa | 55049 | 6367 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-26 04:20:52 | Iowa, Wisconsin, US | |
2653338 | 2653338 | 2022-09-24 | US | Wisconsin | Iowa | 55049 | 6367 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-25 04:23:31 | Iowa, Wisconsin, US | |
387778 | 387778 | 2022-09-23 | US | Wisconsin | Iowa | 55049 | 6367 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-24 04:21:40 | Iowa, Wisconsin, US | |
1627844 | 1627844 | 2022-09-22 | US | Wisconsin | Iowa | 55049 | 6363 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-23 04:23:13 | Iowa, Wisconsin, US | |
1374048 | 1374048 | 2022-09-21 | US | Wisconsin | Iowa | 55049 | 6359 | 31 | 0 | 43.00050278 | -90.13469017 | 2022-09-22 04:22:56 | Iowa, Wisconsin, US |
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]);