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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3918 | 3918 | 2021-12-02 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Wisconsin, US | |
7933 | 7933 | 2021-10-28 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Wisconsin, US | |
11854 | 11854 | 2020-10-25 | US | Wisconsin | Crawford | 55023 | 323 | 0 | 0 | 323 | 43.23870316 | -90.93073686 | 2020-10-26 04:25:02 | Crawford, Wisconsin, US |
11882 | 11882 | 2020-10-25 | US | Wisconsin | Menominee | 55078 | 283 | 0 | 0 | 283 | 45.00422544 | -88.70950714 | 2020-10-26 04:25:02 | Menominee, Wisconsin, US |
11889 | 11889 | 2020-10-25 | US | Wisconsin | Pepin | 55091 | 135 | 0 | 0 | 135 | 44.58307413 | -91.99949611 | 2020-10-26 04:25:02 | Pepin, Wisconsin, US |
11905 | 11905 | 2020-10-25 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Wisconsin, US |
15918 | 15918 | 2021-01-26 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Wisconsin, US |
19940 | 19940 | 2021-09-18 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Wisconsin, US | |
23951 | 23951 | 2021-05-28 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Wisconsin, US | |
27989 | 27989 | 2022-03-20 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Wisconsin, US | |
32004 | 32004 | 2021-11-11 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Wisconsin, US | |
36000 | 36000 | 2021-08-25 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Wisconsin, US | |
40010 | 40010 | 2021-04-12 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Wisconsin, US | |
40357 | 40357 | 2020-04-13 | US | Wisconsin | Adams | 55001 | 3 | 0 | 0 | 3 | 43.96974651 | -89.76782777 | 2020-04-13 23:07:54 | Adams, Wisconsin, US |
40419 | 40419 | 2020-04-13 | US | Wisconsin | Ashland | 55003 | 2 | 0 | 0 | 2 | 46.31956891 | -90.67837132 | 2020-04-13 23:07:54 | Ashland, Wisconsin, US |
40459 | 40459 | 2020-04-13 | US | Wisconsin | Barron | 55005 | 6 | 0 | 0 | 6 | 45.42372701 | -91.84833627 | 2020-04-13 23:07:54 | Barron, Wisconsin, US |
40473 | 40473 | 2020-04-13 | US | Wisconsin | Bayfield | 55007 | 3 | 0 | 0 | 3 | 46.52868768 | -91.19716729 | 2020-04-13 23:07:54 | Bayfield, Wisconsin, US |
40649 | 40649 | 2020-04-13 | US | Wisconsin | Calumet | 55015 | 5 | 0 | 0 | 5 | 44.0816316 | -88.21780273 | 2020-04-13 23:07:54 | Calumet, Wisconsin, US |
40769 | 40769 | 2020-04-13 | US | Wisconsin | Chippewa | 55017 | 20 | 0 | 0 | 20 | 45.06939744 | -91.28068855 | 2020-04-13 23:07:54 | Chippewa, Wisconsin, US |
40798 | 40798 | 2020-04-13 | US | Wisconsin | Clark | 55019 | 8 | 0 | 0 | 8 | 44.73483377 | -90.61207486 | 2020-04-13 23:07:54 | Clark, Wisconsin, US |
40919 | 40919 | 2020-04-13 | US | Wisconsin | Crawford | 55023 | 3 | 0 | 0 | 3 | 43.23870316 | -90.93073686 | 2020-04-13 23:07:54 | Crawford, Wisconsin, US |
41026 | 41026 | 2020-04-13 | US | Wisconsin | Dodge | 55027 | 19 | 0 | 0 | 19 | 43.41576662 | -88.70928178 | 2020-04-13 23:07:54 | Dodge, Wisconsin, US |
41031 | 41031 | 2020-04-13 | US | Wisconsin | Door | 55029 | 9 | 0 | 0 | 9 | 44.95856458 | -87.30002707 | 2020-04-13 23:07:54 | Door, Wisconsin, US |
41044 | 41044 | 2020-04-13 | US | Wisconsin | Douglas | 55031 | 7 | 0 | 0 | 7 | 46.43222285 | -91.91595768 | 2020-04-13 23:07:54 | Douglas, Wisconsin, US |
41053 | 41053 | 2020-04-13 | US | Wisconsin | Dunn | 55033 | 9 | 0 | 0 | 9 | 44.94562799 | -91.8962481 | 2020-04-13 23:07:54 | Dunn, Wisconsin, US |
41066 | 41066 | 2020-04-13 | US | Wisconsin | Eau Claire | 55035 | 21 | 0 | 0 | 21 | 44.726614 | -91.28609183 | 2020-04-13 23:07:54 | Eau Claire, Wisconsin, US |
41142 | 41142 | 2020-04-13 | US | Wisconsin | Florence | 55037 | 2 | 0 | 0 | 2 | 45.84963535 | -88.39804137 | 2020-04-13 23:07:54 | Florence, Wisconsin, US |
41283 | 41283 | 2020-04-13 | US | Wisconsin | Green | 55045 | 9 | 0 | 0 | 9 | 42.6794956 | -89.60243287 | 2020-04-13 23:07:54 | Green, Wisconsin, US |
41284 | 41284 | 2020-04-13 | US | Wisconsin | Green Lake | 55047 | 1 | 0 | 0 | 1 | 43.80025981 | -89.04679553 | 2020-04-13 23:07:54 | Green Lake, Wisconsin, US |
41477 | 41477 | 2020-04-13 | US | Wisconsin | Iowa | 55049 | 5 | 0 | 0 | 5 | 43.00050278 | -90.13469017 | 2020-04-13 23:07:54 | Iowa, Wisconsin, US |
41547 | 41547 | 2020-04-13 | US | Wisconsin | Jefferson | 55055 | 24 | 0 | 0 | 24 | 43.02054068 | -88.77529134 | 2020-04-13 23:07:54 | Jefferson, Wisconsin, US |
41611 | 41611 | 2020-04-13 | US | Wisconsin | Kewaunee | 55061 | 4 | 0 | 0 | 4 | 44.51727459 | -87.61468386 | 2020-04-13 23:07:54 | Kewaunee, Wisconsin, US |
41640 | 41640 | 2020-04-13 | US | Wisconsin | La Crosse | 55063 | 25 | 0 | 0 | 25 | 43.90632465 | -91.11451093 | 2020-04-13 23:07:54 | La Crosse, Wisconsin, US |
41655 | 41655 | 2020-04-13 | US | Wisconsin | Lafayette | 55065 | 3 | 0 | 0 | 3 | 42.66005229 | -90.1317729 | 2020-04-13 23:07:54 | Lafayette, Wisconsin, US |
41855 | 41855 | 2020-04-13 | US | Wisconsin | Manitowoc | 55071 | 3 | 0 | 0 | 3 | 44.11946801 | -87.80928853 | 2020-04-13 23:07:54 | Manitowoc, Wisconsin, US |
41861 | 41861 | 2020-04-13 | US | Wisconsin | Marinette | 55075 | 3 | 0 | 0 | 3 | 45.38553432 | -88.03324599999998 | 2020-04-13 23:07:54 | Marinette, Wisconsin, US |
41879 | 41879 | 2020-04-13 | US | Wisconsin | Marquette | 55077 | 2 | 0 | 0 | 2 | 43.81911946 | -89.40073763 | 2020-04-13 23:07:54 | Marquette, Wisconsin, US |
41954 | 41954 | 2020-04-13 | US | Wisconsin | Menominee | 55078 | 1 | 0 | 0 | 1 | 45.00422544 | -88.70950714 | 2020-04-13 23:07:54 | Menominee, Wisconsin, US |
42020 | 42020 | 2020-04-13 | US | Wisconsin | Monroe | 55081 | 8 | 0 | 0 | 8 | 43.94641218 | -90.61881899999999 | 2020-04-13 23:07:54 | Monroe, Wisconsin, US |
42143 | 42143 | 2020-04-13 | US | Wisconsin | Oconto | 55083 | 3 | 0 | 0 | 3 | 45.02715345 | -88.26807503 | 2020-04-13 23:07:54 | Oconto, Wisconsin, US |
42163 | 42163 | 2020-04-13 | US | Wisconsin | Oneida | 55085 | 6 | 0 | 0 | 6 | 45.70677897 | -89.51944105 | 2020-04-13 23:07:54 | Oneida, Wisconsin, US |
42246 | 42246 | 2020-04-13 | US | Wisconsin | Pepin | 55091 | 0 | 0 | 0 | 0 | 44.58307413 | -91.99949611 | 2020-04-13 23:07:54 | Pepin, Wisconsin, US |
42277 | 42277 | 2020-04-13 | US | Wisconsin | Pierce | 55093 | 7 | 0 | 0 | 7 | 44.71850291 | -92.4224416 | 2020-04-13 23:07:54 | Pierce, Wisconsin, US |
42319 | 42319 | 2020-04-13 | US | Wisconsin | Polk | 55095 | 3 | 0 | 0 | 3 | 45.46130348 | -92.44182875 | 2020-04-13 23:07:54 | Polk, Wisconsin, US |
42325 | 42325 | 2020-04-13 | US | Wisconsin | Portage | 55097 | 4 | 0 | 0 | 4 | 44.47558711 | -89.50152965 | 2020-04-13 23:07:54 | Portage, Wisconsin, US |
42344 | 42344 | 2020-04-13 | US | Wisconsin | Price | 55099 | 1 | 0 | 0 | 1 | 45.68051754 | -90.36098879999999 | 2020-04-13 23:07:54 | Price, Wisconsin, US |
42410 | 42410 | 2020-04-13 | US | Wisconsin | Richland | 55103 | 5 | 0 | 0 | 5 | 43.3762778 | -90.43012729 | 2020-04-13 23:07:54 | Richland, Wisconsin, US |
42454 | 42454 | 2020-04-13 | US | Wisconsin | Rusk | 55107 | 3 | 0 | 0 | 3 | 45.47498854 | -91.1333012 | 2020-04-13 23:07:54 | Rusk, Wisconsin, US |
42507 | 42507 | 2020-04-13 | US | Wisconsin | Sawyer | 55113 | 1 | 0 | 0 | 1 | 45.87931905 | -91.14504927 | 2020-04-13 23:07:54 | Sawyer, Wisconsin, US |
42548 | 42548 | 2020-04-13 | US | Wisconsin | Shawano | 55115 | 5 | 0 | 0 | 5 | 44.78902246 | -88.76443896 | 2020-04-13 23:07:54 | Shawano, Wisconsin, US |
42604 | 42604 | 2020-04-13 | US | Wisconsin | St. Croix | 55109 | 10 | 0 | 0 | 10 | 45.03437474 | -92.45000068 | 2020-04-13 23:07:54 | St. Croix, Wisconsin, US |
42748 | 42748 | 2020-04-13 | US | Wisconsin | Trempealeau | 55121 | 1 | 0 | 0 | 1 | 44.30360275 | -91.35893614 | 2020-04-13 23:07:54 | Trempealeau, Wisconsin, US |
42815 | 42815 | 2020-04-13 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Wisconsin, US |
42859 | 42859 | 2020-04-13 | US | Wisconsin | Vilas | 55125 | 4 | 0 | 0 | 4 | 46.05467334 | -89.51719204 | 2020-04-13 23:07:54 | Vilas, Wisconsin, US |
42882 | 42882 | 2020-04-13 | US | Wisconsin | Walworth | 55127 | 38 | 0 | 0 | 38 | 42.66858202 | -88.54163073 | 2020-04-13 23:07:54 | Walworth, Wisconsin, US |
42941 | 42941 | 2020-04-13 | US | Wisconsin | Waushara | 55137 | 2 | 0 | 0 | 2 | 44.11324419 | -89.24317107 | 2020-04-13 23:07:54 | Waushara, Wisconsin, US |
43028 | 43028 | 2020-04-13 | US | Wisconsin | Wood | 55141 | 2 | 0 | 0 | 2 | 44.45537896 | -90.04158336 | 2020-04-13 23:07:54 | Wood, Wisconsin, US |
47296 | 47296 | 2021-11-02 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Wisconsin, US | |
47478 | 47478 | 2020-04-17 | US | Wisconsin | Ashland | 55003 | 2 | 0 | 0 | 2 | 46.31956891 | -90.67837132 | 2020-04-17 23:30:52 | Ashland, Wisconsin, US |
47519 | 47519 | 2020-04-17 | US | Wisconsin | Barron | 55005 | 6 | 0 | 0 | 6 | 45.42372701 | -91.84833627 | 2020-04-17 23:30:52 | Barron, Wisconsin, US |
47533 | 47533 | 2020-04-17 | US | Wisconsin | Bayfield | 55007 | 3 | 0 | 0 | 3 | 46.52868768 | -91.19716729 | 2020-04-17 23:30:52 | Bayfield, Wisconsin, US |
47709 | 47709 | 2020-04-17 | US | Wisconsin | Calumet | 55015 | 5 | 0 | 0 | 5 | 44.0816316 | -88.21780273 | 2020-04-17 23:30:52 | Calumet, Wisconsin, US |
47830 | 47830 | 2020-04-17 | US | Wisconsin | Chippewa | 55017 | 20 | 0 | 0 | 20 | 45.06939744 | -91.28068855 | 2020-04-17 23:30:52 | Chippewa, Wisconsin, US |
47860 | 47860 | 2020-04-17 | US | Wisconsin | Clark | 55019 | 12 | 0 | 0 | 12 | 44.73483377 | -90.61207486 | 2020-04-17 23:30:52 | Clark, Wisconsin, US |
47982 | 47982 | 2020-04-17 | US | Wisconsin | Crawford | 55023 | 3 | 0 | 0 | 3 | 43.23870316 | -90.93073686 | 2020-04-17 23:30:52 | Crawford, Wisconsin, US |
48109 | 48109 | 2020-04-17 | US | Wisconsin | Douglas | 55031 | 7 | 0 | 0 | 7 | 46.43222285 | -91.91595768 | 2020-04-17 23:30:52 | Douglas, Wisconsin, US |
48117 | 48117 | 2020-04-17 | US | Wisconsin | Dunn | 55033 | 9 | 0 | 0 | 9 | 44.94562799 | -91.8962481 | 2020-04-17 23:30:52 | Dunn, Wisconsin, US |
48131 | 48131 | 2020-04-17 | US | Wisconsin | Eau Claire | 55035 | 22 | 0 | 0 | 22 | 44.726614 | -91.28609183 | 2020-04-17 23:30:52 | Eau Claire, Wisconsin, US |
48206 | 48206 | 2020-04-17 | US | Wisconsin | Florence | 55037 | 2 | 0 | 0 | 2 | 45.84963535 | -88.39804137 | 2020-04-17 23:30:52 | Florence, Wisconsin, US |
48347 | 48347 | 2020-04-17 | US | Wisconsin | Green | 55045 | 9 | 0 | 0 | 9 | 42.6794956 | -89.60243287 | 2020-04-17 23:30:52 | Green, Wisconsin, US |
48348 | 48348 | 2020-04-17 | US | Wisconsin | Green Lake | 55047 | 1 | 0 | 0 | 1 | 43.80025981 | -89.04679553 | 2020-04-17 23:30:52 | Green Lake, Wisconsin, US |
48545 | 48545 | 2020-04-17 | US | Wisconsin | Iowa | 55049 | 6 | 0 | 0 | 6 | 43.00050278 | -90.13469017 | 2020-04-17 23:30:52 | Iowa, Wisconsin, US |
48616 | 48616 | 2020-04-17 | US | Wisconsin | Jefferson | 55055 | 27 | 0 | 0 | 27 | 43.02054068 | -88.77529134 | 2020-04-17 23:30:52 | Jefferson, Wisconsin, US |
48710 | 48710 | 2020-04-17 | US | Wisconsin | La Crosse | 55063 | 25 | 0 | 0 | 25 | 43.90632465 | -91.11451093 | 2020-04-17 23:30:52 | La Crosse, Wisconsin, US |
48726 | 48726 | 2020-04-17 | US | Wisconsin | Lafayette | 55065 | 3 | 0 | 0 | 3 | 42.66005229 | -90.1317729 | 2020-04-17 23:30:52 | Lafayette, Wisconsin, US |
48928 | 48928 | 2020-04-17 | US | Wisconsin | Manitowoc | 55071 | 5 | 0 | 0 | 5 | 44.11946801 | -87.80928853 | 2020-04-17 23:30:52 | Manitowoc, Wisconsin, US |
48953 | 48953 | 2020-04-17 | US | Wisconsin | Marquette | 55077 | 3 | 0 | 0 | 3 | 43.81911946 | -89.40073763 | 2020-04-17 23:30:52 | Marquette, Wisconsin, US |
49028 | 49028 | 2020-04-17 | US | Wisconsin | Menominee | 55078 | 1 | 0 | 0 | 1 | 45.00422544 | -88.70950714 | 2020-04-17 23:30:52 | Menominee, Wisconsin, US |
49096 | 49096 | 2020-04-17 | US | Wisconsin | Monroe | 55081 | 13 | 0 | 0 | 13 | 43.94641218 | -90.61881899999999 | 2020-04-17 23:30:52 | Monroe, Wisconsin, US |
49225 | 49225 | 2020-04-17 | US | Wisconsin | Oconto | 55083 | 4 | 0 | 0 | 4 | 45.02715345 | -88.26807503 | 2020-04-17 23:30:52 | Oconto, Wisconsin, US |
49245 | 49245 | 2020-04-17 | US | Wisconsin | Oneida | 55085 | 6 | 0 | 0 | 6 | 45.70677897 | -89.51944105 | 2020-04-17 23:30:52 | Oneida, Wisconsin, US |
49330 | 49330 | 2020-04-17 | US | Wisconsin | Pepin | 55091 | 0 | 0 | 0 | 0 | 44.58307413 | -91.99949611 | 2020-04-17 23:30:52 | Pepin, Wisconsin, US |
49361 | 49361 | 2020-04-17 | US | Wisconsin | Pierce | 55093 | 7 | 0 | 0 | 7 | 44.71850291 | -92.4224416 | 2020-04-17 23:30:52 | Pierce, Wisconsin, US |
49403 | 49403 | 2020-04-17 | US | Wisconsin | Polk | 55095 | 4 | 0 | 0 | 4 | 45.46130348 | -92.44182875 | 2020-04-17 23:30:52 | Polk, Wisconsin, US |
49410 | 49410 | 2020-04-17 | US | Wisconsin | Portage | 55097 | 4 | 0 | 0 | 4 | 44.47558711 | -89.50152965 | 2020-04-17 23:30:52 | Portage, Wisconsin, US |
49429 | 49429 | 2020-04-17 | US | Wisconsin | Price | 55099 | 1 | 0 | 0 | 1 | 45.68051754 | -90.36098879999999 | 2020-04-17 23:30:52 | Price, Wisconsin, US |
49541 | 49541 | 2020-04-17 | US | Wisconsin | Rusk | 55107 | 3 | 0 | 0 | 3 | 45.47498854 | -91.1333012 | 2020-04-17 23:30:52 | Rusk, Wisconsin, US |
49596 | 49596 | 2020-04-17 | US | Wisconsin | Sawyer | 55113 | 2 | 0 | 0 | 2 | 45.87931905 | -91.14504927 | 2020-04-17 23:30:52 | Sawyer, Wisconsin, US |
49637 | 49637 | 2020-04-17 | US | Wisconsin | Shawano | 55115 | 6 | 0 | 0 | 6 | 44.78902246 | -88.76443896 | 2020-04-17 23:30:52 | Shawano, Wisconsin, US |
49696 | 49696 | 2020-04-17 | US | Wisconsin | St. Croix | 55109 | 11 | 0 | 0 | 11 | 45.03437474 | -92.45000068 | 2020-04-17 23:30:52 | St. Croix, Wisconsin, US |
49840 | 49840 | 2020-04-17 | US | Wisconsin | Trempealeau | 55121 | 1 | 0 | 0 | 1 | 44.30360275 | -91.35893614 | 2020-04-17 23:30:52 | Trempealeau, Wisconsin, US |
49909 | 49909 | 2020-04-17 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Wisconsin, US |
49954 | 49954 | 2020-04-17 | US | Wisconsin | Vilas | 55125 | 4 | 0 | 0 | 4 | 46.05467334 | -89.51719204 | 2020-04-17 23:30:52 | Vilas, Wisconsin, US |
50000 | 50000 | 2020-04-17 | US | Wisconsin | Washburn | 55129 | 1 | 0 | 0 | 1 | 45.89838588 | -91.79050449 | 2020-04-17 23:30:52 | Washburn, Wisconsin, US |
50037 | 50037 | 2020-04-17 | US | Wisconsin | Waushara | 55137 | 2 | 0 | 0 | 2 | 44.11324419 | -89.24317107 | 2020-04-17 23:30:52 | Waushara, Wisconsin, US |
50126 | 50126 | 2020-04-17 | US | Wisconsin | Wood | 55141 | 2 | 0 | 0 | 2 | 44.45537896 | -90.04158336 | 2020-04-17 23:30:52 | Wood, Wisconsin, US |
54372 | 54372 | 2021-05-29 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Wisconsin, US | |
58383 | 58383 | 2021-03-07 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Wisconsin, US | |
58605 | 58605 | 2020-07-23 | US | Wisconsin | Ashland | 55003 | 13 | 0 | 0 | 13 | 46.31956891 | -90.67837132 | 2020-07-24 05:30:40 | Ashland, Wisconsin, US |
59016 | 59016 | 2020-07-23 | US | Wisconsin | Chippewa | 55017 | 177 | 0 | 0 | 177 | 45.06939744 | -91.28068855 | 2020-07-24 05:30:40 | Chippewa, 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]);