johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73,611 rows where province_or_state = "Wisconsin" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-03-27 73
- 2020-03-28 73
- 2020-03-29 73
- 2020-03-30 73
- 2020-05-22 73
- 2020-05-23 73
- 2020-05-24 73
- 2020-05-25 73
- 2020-05-26 73
- 2020-05-27 73
- 2020-05-28 73
- 2020-05-29 73
- 2020-05-30 73
- 2020-05-31 73
- 2020-06-01 73
- 2020-06-02 73
- 2020-06-03 73
- 2020-06-04 73
- 2020-06-05 73
- 2020-06-06 73
- 2020-06-07 73
- 2020-06-09 73
- 2020-06-10 73
- 2020-06-11 73
- 2020-06-12 73
- 2020-06-13 73
- 2020-06-14 73
- 2020-06-16 73
- 2020-06-17 73
- 2020-06-18 73
- …
province_or_state 1
- Wisconsin · 73,511 ✖
country_or_region 1
- US 73,511
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351827 | 351827 | 2022-12-14 | US | Wisconsin | Adams | 55001 | 5681 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-15 04:20:58 | Adams, Wisconsin, US | |
355812 | 355812 | 2021-03-11 | US | Wisconsin | Adams | 55001 | 1760 | 15 | 0 | 43.96974651 | -89.76782777 | 2021-03-12 05:26:50 | Adams, Wisconsin, US | |
359853 | 359853 | 2022-03-11 | US | Wisconsin | Adams | 55001 | 4609 | 54 | 0 | 43.96974651 | -89.76782777 | 2022-03-12 04:20:50 | Adams, Wisconsin, US | |
363869 | 363869 | 2022-05-07 | US | Wisconsin | Adams | 55001 | 4689 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-05-08 04:20:49 | Adams, Wisconsin, US | |
364047 | 364047 | 2020-07-16 | US | Wisconsin | Adams | 55001 | 46 | 2 | 0 | 44 | 43.96974651 | -89.76782777 | 2020-07-17 04:34:50 | Adams, Wisconsin, US |
367909 | 367909 | 2020-08-08 | US | Wisconsin | Adams | 55001 | 85 | 2 | 0 | 83 | 43.96974651 | -89.76782777 | 2020-08-09 04:34:54 | Adams, Wisconsin, US |
375727 | 375727 | 2022-09-13 | US | Wisconsin | Adams | 55001 | 5353 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-14 04:20:44 | Adams, Wisconsin, US | |
379695 | 379695 | 2020-11-06 | US | Wisconsin | Adams | 55001 | 735 | 6 | 0 | 729 | 43.96974651 | -89.76782777 | 2020-11-07 05:24:52 | Adams, Wisconsin, US |
383711 | 383711 | 2021-04-30 | US | Wisconsin | Adams | 55001 | 1889 | 17 | 0 | 43.96974651 | -89.76782777 | 2021-05-01 04:20:47 | Adams, Wisconsin, US | |
387754 | 387754 | 2022-09-23 | US | Wisconsin | Adams | 55001 | 5391 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-24 04:21:40 | Adams, Wisconsin, US | |
391741 | 391741 | 2021-04-04 | US | Wisconsin | Adams | 55001 | 1808 | 15 | 0 | 43.96974651 | -89.76782777 | 2021-04-05 04:20:35 | Adams, Wisconsin, US | |
395749 | 395749 | 2020-11-27 | US | Wisconsin | Adams | 55001 | 1082 | 7 | 0 | 1075 | 43.96974651 | -89.76782777 | 2020-11-28 05:25:50 | Adams, Wisconsin, US |
399795 | 399795 | 2022-10-07 | US | Wisconsin | Adams | 55001 | 5428 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-08 04:22:56 | Adams, Wisconsin, US | |
403786 | 403786 | 2021-06-29 | US | Wisconsin | Adams | 55001 | 1968 | 20 | 0 | 43.96974651 | -89.76782777 | 2021-06-30 04:21:41 | Adams, Wisconsin, US | |
407820 | 407820 | 2021-12-07 | US | Wisconsin | Adams | 55001 | 3117 | 37 | 0 | 43.96974651 | -89.76782777 | 2021-12-08 04:22:46 | Adams, Wisconsin, US | |
411816 | 411816 | 2021-07-28 | US | Wisconsin | Adams | 55001 | 1991 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-07-29 04:21:33 | Adams, Wisconsin, US | |
412013 | 412013 | 2020-07-05 | US | Wisconsin | Adams | 55001 | 32 | 2 | 0 | 30 | 43.96974651 | -89.76782777 | 2020-07-06 04:33:57 | Adams, Wisconsin, US |
415932 | 415932 | 2020-04-18 | US | Wisconsin | Adams | 55001 | 4 | 1 | 0 | 3 | 43.96974651 | -89.76782777 | 2020-04-18 22:32:47 | Adams, Wisconsin, US |
422866 | 422866 | 2022-09-18 | US | Wisconsin | Adams | 55001 | 5367 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-19 04:21:49 | Adams, Wisconsin, US | |
426876 | 426876 | 2021-10-10 | US | Wisconsin | Adams | 55001 | 2617 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-11 04:21:31 | Adams, Wisconsin, US | |
430843 | 430843 | 2020-09-07 | US | Wisconsin | Adams | 55001 | 149 | 3 | 0 | 146 | 43.96974651 | -89.76782777 | 2020-09-08 04:28:25 | Adams, Wisconsin, US |
434888 | 434888 | 2022-11-03 | US | Wisconsin | Adams | 55001 | 5547 | 67 | 0 | 43.96974651 | -89.76782777 | 2022-11-04 04:22:11 | Adams, Wisconsin, US | |
438872 | 438872 | 2021-01-21 | US | Wisconsin | Adams | 55001 | 1604 | 14 | 0 | 1590 | 43.96974651 | -89.76782777 | 2021-01-22 05:22:10 | Adams, Wisconsin, US |
439077 | 439077 | 2020-07-26 | US | Wisconsin | Adams | 55001 | 61 | 2 | 0 | 59 | 43.96974651 | -89.76782777 | 2020-07-27 04:35:02 | Adams, Wisconsin, US |
446880 | 446880 | 2021-10-20 | US | Wisconsin | Adams | 55001 | 2717 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-21 04:21:18 | Adams, Wisconsin, US | |
450897 | 450897 | 2021-11-17 | US | Wisconsin | Adams | 55001 | 2956 | 35 | 0 | 43.96974651 | -89.76782777 | 2021-11-18 04:21:33 | Adams, Wisconsin, US | |
454918 | 454918 | 2022-12-21 | US | Wisconsin | Adams | 55001 | 5696 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-22 04:20:56 | Adams, Wisconsin, US | |
455093 | 455093 | 2020-08-07 | US | Wisconsin | Adams | 55001 | 82 | 2 | 0 | 80 | 43.96974651 | -89.76782777 | 2020-08-08 04:34:53 | Adams, Wisconsin, US |
462906 | 462906 | 2022-02-02 | US | Wisconsin | Adams | 55001 | 4456 | 47 | 0 | 43.96974651 | -89.76782777 | 2022-02-03 04:21:21 | Adams, Wisconsin, US | |
466923 | 466923 | 2022-05-02 | US | Wisconsin | Adams | 55001 | 4658 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-05-03 04:21:00 | Adams, Wisconsin, US | |
470937 | 470937 | 2021-10-07 | US | Wisconsin | Adams | 55001 | 2595 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-08 04:21:25 | Adams, Wisconsin, US | |
474928 | 474928 | 2021-02-19 | US | Wisconsin | Adams | 55001 | 1723 | 15 | 0 | 1708 | 43.96974651 | -89.76782777 | 2021-02-20 05:22:51 | Adams, Wisconsin, US |
478970 | 478970 | 2022-06-26 | US | Wisconsin | Adams | 55001 | 4968 | 62 | 0 | 43.96974651 | -89.76782777 | 2022-06-27 04:21:00 | Adams, Wisconsin, US | |
483121 | 483121 | 2022-11-08 | US | Wisconsin | Adams | 55001 | 5559 | 67 | 0 | 43.96974651 | -89.76782777 | 2022-11-09 04:21:22 | Adams, Wisconsin, US | |
487112 | 487112 | 2021-07-19 | US | Wisconsin | Adams | 55001 | 1970 | 20 | 0 | 43.96974651 | -89.76782777 | 2021-07-20 04:21:48 | Adams, Wisconsin, US | |
491151 | 491151 | 2022-11-25 | US | Wisconsin | Adams | 55001 | 5599 | 68 | 0 | 43.96974651 | -89.76782777 | 2022-11-26 04:21:11 | Adams, Wisconsin, US | |
495161 | 495161 | 2021-10-14 | US | Wisconsin | Adams | 55001 | 2684 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-15 04:21:26 | Adams, Wisconsin, US | |
499178 | 499178 | 2021-11-06 | US | Wisconsin | Adams | 55001 | 2842 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-11-07 04:21:53 | Adams, Wisconsin, US | |
503195 | 503195 | 2022-04-02 | US | Wisconsin | Adams | 55001 | 4631 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-03 04:20:48 | Adams, Wisconsin, US | |
507215 | 507215 | 2022-12-17 | US | Wisconsin | Adams | 55001 | 5683 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-18 04:21:03 | Adams, Wisconsin, US | |
511206 | 511206 | 2021-08-14 | US | Wisconsin | Adams | 55001 | 2063 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-08-15 04:21:41 | Adams, Wisconsin, US | |
515220 | 515220 | 2021-08-19 | US | Wisconsin | Adams | 55001 | 2090 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-08-20 04:21:33 | Adams, Wisconsin, US | |
519259 | 519259 | 2022-10-15 | US | Wisconsin | Adams | 55001 | 5451 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-16 04:22:39 | Adams, Wisconsin, US | |
519432 | 519432 | 2020-04-21 | US | Wisconsin | Adams | 55001 | 4 | 1 | 0 | 3 | 43.96974651 | -89.76782777 | 2020-04-21 23:30:50 | Adams, Wisconsin, US |
526376 | 526376 | 2021-06-09 | US | Wisconsin | Adams | 55001 | 1958 | 19 | 0 | 43.96974651 | -89.76782777 | 2021-06-10 04:23:17 | Adams, Wisconsin, US | |
526576 | 526576 | 2020-07-04 | US | Wisconsin | Adams | 55001 | 27 | 2 | 0 | 25 | 43.96974651 | -89.76782777 | 2020-07-05 04:33:46 | Adams, Wisconsin, US |
534222 | 534222 | 2021-02-22 | US | Wisconsin | Adams | 55001 | 1731 | 15 | 0 | 1716 | 43.96974651 | -89.76782777 | 2021-02-23 05:23:41 | Adams, Wisconsin, US |
538261 | 538261 | 2021-10-27 | US | Wisconsin | Adams | 55001 | 2757 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-28 04:22:08 | Adams, Wisconsin, US | |
542283 | 542283 | 2022-10-26 | US | Wisconsin | Adams | 55001 | 5507 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-27 04:22:01 | Adams, Wisconsin, US | |
546299 | 546299 | 2022-12-15 | US | Wisconsin | Adams | 55001 | 5683 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-16 04:21:01 | Adams, Wisconsin, US | |
550260 | 550260 | 2020-09-12 | US | Wisconsin | Adams | 55001 | 160 | 3 | 0 | 157 | 43.96974651 | -89.76782777 | 2020-09-13 04:30:52 | Adams, Wisconsin, US |
554300 | 554300 | 2021-12-08 | US | Wisconsin | Adams | 55001 | 3133 | 37 | 0 | 43.96974651 | -89.76782777 | 2021-12-09 04:22:49 | Adams, Wisconsin, US | |
558316 | 558316 | 2022-01-16 | US | Wisconsin | Adams | 55001 | 3817 | 44 | 0 | 43.96974651 | -89.76782777 | 2022-01-17 04:21:08 | Adams, Wisconsin, US | |
562334 | 562334 | 2022-06-16 | US | Wisconsin | Adams | 55001 | 4917 | 62 | 0 | 43.96974651 | -89.76782777 | 2022-06-17 04:20:56 | Adams, Wisconsin, US | |
566488 | 566488 | 2021-06-22 | US | Wisconsin | Adams | 55001 | 1966 | 19 | 0 | 43.96974651 | -89.76782777 | 2021-06-23 04:21:46 | Adams, Wisconsin, US | |
570629 | 570629 | 2021-10-29 | US | Wisconsin | Adams | 55001 | 2783 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-30 04:22:03 | Adams, Wisconsin, US | |
570809 | 570809 | 2020-06-06 | US | Wisconsin | Adams | 55001 | 5 | 1 | 0 | 4 | 43.96974651 | -89.76782777 | 2020-06-07 03:53:30 | Adams, Wisconsin, US |
578359 | 578359 | 2022-02-25 | US | Wisconsin | Adams | 55001 | 4578 | 51 | 0 | 43.96974651 | -89.76782777 | 2022-02-26 04:21:12 | Adams, Wisconsin, US | |
582354 | 582354 | 2021-07-13 | US | Wisconsin | Adams | 55001 | 1970 | 20 | 0 | 43.96974651 | -89.76782777 | 2021-07-14 04:21:35 | Adams, Wisconsin, US | |
586329 | 586329 | 2020-08-13 | US | Wisconsin | Adams | 55001 | 91 | 2 | 0 | 89 | 43.96974651 | -89.76782777 | 2020-08-14 04:51:19 | Adams, Wisconsin, US |
586531 | 586531 | 2020-04-05 | US | Wisconsin | Adams | 55001 | 1 | 0 | 0 | 1 | 43.96974651 | -89.76782777 | 2020-04-05 23:06:45 | Adams, Wisconsin, US |
593150 | 593150 | 2021-08-08 | US | Wisconsin | Adams | 55001 | 2021 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-08-09 04:21:24 | Adams, Wisconsin, US | |
597186 | 597186 | 2022-07-01 | US | Wisconsin | Adams | 55001 | 5006 | 62 | 0 | 43.96974651 | -89.76782777 | 2022-07-02 04:21:16 | Adams, Wisconsin, US | |
601199 | 601199 | 2021-10-19 | US | Wisconsin | Adams | 55001 | 2709 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-20 04:21:00 | Adams, Wisconsin, US | |
605214 | 605214 | 2021-09-23 | US | Wisconsin | Adams | 55001 | 2421 | 31 | 0 | 43.96974651 | -89.76782777 | 2021-09-24 04:21:44 | Adams, Wisconsin, US | |
609207 | 609207 | 2021-04-09 | US | Wisconsin | Adams | 55001 | 1831 | 15 | 0 | 43.96974651 | -89.76782777 | 2021-04-10 04:20:59 | Adams, Wisconsin, US | |
613191 | 613191 | 2020-08-29 | US | Wisconsin | Adams | 55001 | 108 | 3 | 0 | 105 | 43.96974651 | -89.76782777 | 2020-08-30 04:28:22 | Adams, Wisconsin, US |
617204 | 617204 | 2021-02-08 | US | Wisconsin | Adams | 55001 | 1685 | 14 | 0 | 1671 | 43.96974651 | -89.76782777 | 2021-02-09 05:23:30 | Adams, Wisconsin, US |
621393 | 621393 | 2022-11-05 | US | Wisconsin | Adams | 55001 | 5550 | 67 | 0 | 43.96974651 | -89.76782777 | 2022-11-06 04:21:24 | Adams, Wisconsin, US | |
625406 | 625406 | 2022-05-22 | US | Wisconsin | Adams | 55001 | 4794 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-05-26 04:20:50 | Adams, Wisconsin, US | |
629400 | 629400 | 2021-07-10 | US | Wisconsin | Adams | 55001 | 1970 | 20 | 0 | 43.96974651 | -89.76782777 | 2021-07-11 04:21:43 | Adams, Wisconsin, US | |
633436 | 633436 | 2022-07-12 | US | Wisconsin | Adams | 55001 | 5037 | 63 | 0 | 43.96974651 | -89.76782777 | 2022-07-13 04:20:58 | Adams, Wisconsin, US | |
637449 | 637449 | 2021-10-13 | US | Wisconsin | Adams | 55001 | 2672 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-14 04:21:29 | Adams, Wisconsin, US | |
641440 | 641440 | 2021-03-31 | US | Wisconsin | Adams | 55001 | 1794 | 15 | 0 | 43.96974651 | -89.76782777 | 2021-04-01 04:27:05 | Adams, Wisconsin, US | |
645460 | 645460 | 2021-09-07 | US | Wisconsin | Adams | 55001 | 2250 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-09-08 04:21:31 | Adams, Wisconsin, US | |
649470 | 649470 | 2021-05-05 | US | Wisconsin | Adams | 55001 | 1905 | 17 | 0 | 43.96974651 | -89.76782777 | 2021-05-06 04:20:38 | Adams, Wisconsin, US | |
653488 | 653488 | 2021-08-09 | US | Wisconsin | Adams | 55001 | 2028 | 21 | 0 | 43.96974651 | -89.76782777 | 2021-08-10 04:21:27 | Adams, Wisconsin, US | |
657521 | 657521 | 2021-10-22 | US | Wisconsin | Adams | 55001 | 2721 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-23 04:21:32 | Adams, Wisconsin, US | |
661841 | 661841 | 2022-05-13 | US | Wisconsin | Adams | 55001 | 4738 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-05-14 04:20:48 | Adams, Wisconsin, US | |
665841 | 665841 | 2020-08-11 | US | Wisconsin | Adams | 55001 | 86 | 2 | 0 | 84 | 43.96974651 | -89.76782777 | 2020-08-12 04:27:29 | Adams, Wisconsin, US |
669785 | 669785 | 2020-09-16 | US | Wisconsin | Adams | 55001 | 174 | 3 | 0 | 171 | 43.96974651 | -89.76782777 | 2020-09-17 04:22:00 | Adams, Wisconsin, US |
673827 | 673827 | 2022-07-21 | US | Wisconsin | Adams | 55001 | 5084 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-07-22 04:21:15 | Adams, Wisconsin, US | |
677843 | 677843 | 2022-07-30 | US | Wisconsin | Adams | 55001 | 5142 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-07-31 04:21:02 | Adams, Wisconsin, US | |
681826 | 681826 | 2020-11-23 | US | Wisconsin | Adams | 55001 | 1052 | 7 | 0 | 1045 | 43.96974651 | -89.76782777 | 2020-11-24 05:27:31 | Adams, Wisconsin, US |
685866 | 685866 | 2021-10-24 | US | Wisconsin | Adams | 55001 | 2721 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-10-25 04:22:31 | Adams, Wisconsin, US | |
689883 | 689883 | 2021-11-13 | US | Wisconsin | Adams | 55001 | 2918 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-11-14 04:21:31 | Adams, Wisconsin, US | |
693904 | 693904 | 2022-12-23 | US | Wisconsin | Adams | 55001 | 5701 | 69 | 0 | 43.96974651 | -89.76782777 | 2022-12-24 04:21:02 | Adams, Wisconsin, US | |
697916 | 697916 | 2022-03-17 | US | Wisconsin | Adams | 55001 | 4612 | 55 | 0 | 43.96974651 | -89.76782777 | 2022-03-18 04:20:55 | Adams, Wisconsin, US | |
701931 | 701931 | 2021-11-04 | US | Wisconsin | Adams | 55001 | 2826 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-11-05 04:21:54 | Adams, Wisconsin, US | |
705921 | 705921 | 2021-03-16 | US | Wisconsin | Adams | 55001 | 1770 | 15 | 0 | 43.96974651 | -89.76782777 | 2021-03-17 05:25:07 | Adams, Wisconsin, US | |
709959 | 709959 | 2021-09-29 | US | Wisconsin | Adams | 55001 | 2508 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-09-30 04:21:20 | Adams, Wisconsin, US | |
713981 | 713981 | 2022-11-01 | US | Wisconsin | Adams | 55001 | 5538 | 67 | 0 | 43.96974651 | -89.76782777 | 2022-11-02 04:22:09 | Adams, Wisconsin, US | |
717992 | 717992 | 2021-11-12 | US | Wisconsin | Adams | 55001 | 2918 | 33 | 0 | 43.96974651 | -89.76782777 | 2021-11-13 04:21:38 | Adams, Wisconsin, US | |
722013 | 722013 | 2022-12-04 | US | Wisconsin | Adams | 55001 | 5631 | 68 | 0 | 43.96974651 | -89.76782777 | 2022-12-05 04:20:58 | Adams, Wisconsin, US | |
726024 | 726024 | 2021-11-20 | US | Wisconsin | Adams | 55001 | 2984 | 35 | 0 | 43.96974651 | -89.76782777 | 2021-11-21 04:22:13 | Adams, Wisconsin, US | |
730016 | 730016 | 2021-05-22 | US | Wisconsin | Adams | 55001 | 1952 | 17 | 0 | 43.96974651 | -89.76782777 | 2021-05-23 04:20:51 | Adams, Wisconsin, US | |
734054 | 734054 | 2021-12-27 | US | Wisconsin | Adams | 55001 | 3324 | 39 | 0 | 43.96974651 | -89.76782777 | 2021-12-28 04:21:47 | Adams, Wisconsin, US | |
734233 | 734233 | 2020-06-12 | US | Wisconsin | Adams | 55001 | 7 | 1 | 0 | 6 | 43.96974651 | -89.76782777 | 2020-06-13 03:33:14 | Adams, Wisconsin, US |
741815 | 741815 | 2020-12-02 | US | Wisconsin | Adams | 55001 | 1144 | 8 | 0 | 1136 | 43.96974651 | -89.76782777 | 2020-12-03 05:28:22 | Adams, Wisconsin, US |
745830 | 745830 | 2021-02-20 | US | Wisconsin | Adams | 55001 | 1729 | 15 | 0 | 1714 | 43.96974651 | -89.76782777 | 2021-02-21 05:24:33 | Adams, 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]);