johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Jamtland Harjedalen" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235701 | 2235701 | 2022-06-12 | Sweden | Jamtland Harjedalen | 32883 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-13 04:21:14 | Jamtland Harjedalen, Sweden | |||
3141899 | 3141899 | 2022-06-11 | Sweden | Jamtland Harjedalen | 32883 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-12 04:20:53 | Jamtland Harjedalen, Sweden | |||
1944815 | 1944815 | 2022-06-10 | Sweden | Jamtland Harjedalen | 32883 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-11 04:21:01 | Jamtland Harjedalen, Sweden | |||
3157954 | 3157954 | 2022-06-09 | Sweden | Jamtland Harjedalen | 32883 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-10 04:20:55 | Jamtland Harjedalen, Sweden | |||
1421421 | 1421421 | 2022-06-08 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-09 04:20:54 | Jamtland Harjedalen, Sweden | |||
3726535 | 3726535 | 2022-06-07 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-08 04:20:55 | Jamtland Harjedalen, Sweden | |||
3887937 | 3887937 | 2022-06-06 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-07 04:21:08 | Jamtland Harjedalen, Sweden | |||
3507706 | 3507706 | 2022-06-05 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-06 04:20:57 | Jamtland Harjedalen, Sweden | |||
3527783 | 3527783 | 2022-06-04 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-05 04:20:55 | Jamtland Harjedalen, Sweden | |||
3133869 | 3133869 | 2022-06-03 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-04 04:20:58 | Jamtland Harjedalen, Sweden | |||
3578944 | 3578944 | 2022-06-02 | Sweden | Jamtland Harjedalen | 32865 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-03 04:20:58 | Jamtland Harjedalen, Sweden | |||
971237 | 971237 | 2022-06-01 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-02 05:20:39 | Jamtland Harjedalen, Sweden | |||
229544 | 229544 | 2022-05-31 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-01 04:20:55 | Jamtland Harjedalen, Sweden | |||
3186309 | 3186309 | 2022-05-30 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-31 04:20:51 | Jamtland Harjedalen, Sweden | |||
3198458 | 3198458 | 2022-05-29 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-30 04:20:50 | Jamtland Harjedalen, Sweden | |||
2725336 | 2725336 | 2022-05-28 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-29 04:20:53 | Jamtland Harjedalen, Sweden | |||
1314517 | 1314517 | 2022-05-27 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-28 04:21:07 | Jamtland Harjedalen, Sweden | |||
1850309 | 1850309 | 2022-05-26 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-27 04:20:56 | Jamtland Harjedalen, Sweden | |||
2048185 | 2048185 | 2022-05-25 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-26 04:20:50 | Jamtland Harjedalen, Sweden | |||
2999623 | 2999623 | 2022-05-24 | Sweden | Jamtland Harjedalen | 32821 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-25 04:20:56 | Jamtland Harjedalen, Sweden | |||
3593344 | 3593344 | 2022-05-23 | Sweden | Jamtland Harjedalen | 32821 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-24 04:20:57 | Jamtland Harjedalen, Sweden | |||
622196 | 622196 | 2022-05-22 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-26 04:20:50 | Jamtland Harjedalen, Sweden | |||
1109892 | 1109892 | 2022-05-21 | Sweden | Jamtland Harjedalen | 32821 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-22 04:20:52 | Jamtland Harjedalen, Sweden | |||
1169516 | 1169516 | 2022-05-20 | Sweden | Jamtland Harjedalen | 32821 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-21 04:20:58 | Jamtland Harjedalen, Sweden | |||
3896279 | 3896279 | 2022-05-19 | Sweden | Jamtland Harjedalen | 32821 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-20 04:20:57 | Jamtland Harjedalen, Sweden | |||
1185063 | 1185063 | 2022-05-18 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-19 04:20:54 | Jamtland Harjedalen, Sweden | |||
3582960 | 3582960 | 2022-05-17 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-18 04:20:50 | Jamtland Harjedalen, Sweden | |||
1503917 | 1503917 | 2022-05-16 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-17 04:20:59 | Jamtland Harjedalen, Sweden | |||
2084276 | 2084276 | 2022-05-15 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-16 04:20:47 | Jamtland Harjedalen, Sweden | |||
3354986 | 3354986 | 2022-05-14 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-15 04:20:53 | Jamtland Harjedalen, Sweden | |||
658631 | 658631 | 2022-05-13 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-14 04:20:48 | Jamtland Harjedalen, Sweden | |||
2533714 | 2533714 | 2022-05-12 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-13 04:20:51 | Jamtland Harjedalen, Sweden | |||
3445160 | 3445160 | 2022-05-11 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-12 04:20:54 | Jamtland Harjedalen, Sweden | |||
3535777 | 3535777 | 2022-05-10 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-11 04:20:48 | Jamtland Harjedalen, Sweden | |||
222312 | 222312 | 2022-05-09 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-10 04:20:50 | Jamtland Harjedalen, Sweden | |||
2331697 | 2331697 | 2022-05-08 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-09 04:20:54 | Jamtland Harjedalen, Sweden | |||
360659 | 360659 | 2022-05-07 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-08 04:20:49 | Jamtland Harjedalen, Sweden | |||
1398010 | 1398010 | 2022-05-06 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-07 04:21:09 | Jamtland Harjedalen, Sweden | |||
2598365 | 2598365 | 2022-05-05 | Sweden | Jamtland Harjedalen | 32769 | 174 | 0 | 63.1712 | 14.9592 | 2022-05-06 04:21:00 | Jamtland Harjedalen, Sweden | |||
3265814 | 3265814 | 2022-05-04 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-05 04:20:55 | Jamtland Harjedalen, Sweden | |||
1572453 | 1572453 | 2022-05-03 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-04 04:20:59 | Jamtland Harjedalen, Sweden | |||
463713 | 463713 | 2022-05-02 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-03 04:21:00 | Jamtland Harjedalen, Sweden | |||
3916352 | 3916352 | 2022-05-01 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-02 04:21:10 | Jamtland Harjedalen, Sweden | |||
2841156 | 2841156 | 2022-04-30 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-01 04:20:57 | Jamtland Harjedalen, Sweden | |||
1157469 | 1157469 | 2022-04-29 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-30 04:21:05 | Jamtland Harjedalen, Sweden | |||
1696651 | 1696651 | 2022-04-28 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-29 04:20:59 | Jamtland Harjedalen, Sweden | |||
3852134 | 3852134 | 2022-04-27 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-28 04:20:47 | Jamtland Harjedalen, Sweden | |||
1326564 | 1326564 | 2022-04-26 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-27 04:20:52 | Jamtland Harjedalen, Sweden | |||
3722518 | 3722518 | 2022-04-25 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-26 04:20:51 | Jamtland Harjedalen, Sweden | |||
2029086 | 2029086 | 2022-04-24 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-25 04:20:56 | Jamtland Harjedalen, Sweden | |||
746661 | 746661 | 2022-04-23 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-24 04:20:56 | Jamtland Harjedalen, Sweden | |||
3437146 | 3437146 | 2022-04-22 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-23 04:20:50 | Jamtland Harjedalen, Sweden | |||
2892731 | 2892731 | 2022-04-21 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-22 04:20:45 | Jamtland Harjedalen, Sweden | |||
2307603 | 2307603 | 2022-04-20 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-21 04:20:46 | Jamtland Harjedalen, Sweden | |||
2251742 | 2251742 | 2022-04-19 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-20 04:20:45 | Jamtland Harjedalen, Sweden | |||
1846292 | 1846292 | 2022-04-18 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-19 04:21:00 | Jamtland Harjedalen, Sweden | |||
3417236 | 3417236 | 2022-04-17 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-18 04:21:12 | Jamtland Harjedalen, Sweden | |||
304185 | 304185 | 2022-04-16 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-17 04:20:59 | Jamtland Harjedalen, Sweden | |||
2670130 | 2670130 | 2022-04-15 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-16 04:20:48 | Jamtland Harjedalen, Sweden | |||
1223915 | 1223915 | 2022-04-14 | Sweden | Jamtland Harjedalen | 32662 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-15 04:20:57 | Jamtland Harjedalen, Sweden | |||
2443073 | 2443073 | 2022-04-13 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-13 23:21:06 | Jamtland Harjedalen, Sweden | |||
1948830 | 1948830 | 2022-04-12 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-13 04:21:03 | Jamtland Harjedalen, Sweden | |||
3206583 | 3206583 | 2022-04-11 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-12 04:20:49 | Jamtland Harjedalen, Sweden | |||
1576469 | 1576469 | 2022-04-10 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-11 04:21:02 | Jamtland Harjedalen, Sweden | |||
1652711 | 1652711 | 2022-04-09 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-10 04:20:52 | Jamtland Harjedalen, Sweden | |||
2116033 | 2116033 | 2022-04-08 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-09 04:20:42 | Jamtland Harjedalen, Sweden | |||
3320557 | 3320557 | 2022-04-07 | Sweden | Jamtland Harjedalen | 32612 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-08 04:20:48 | Jamtland Harjedalen, Sweden | |||
2801093 | 2801093 | 2022-04-06 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-07 04:20:53 | Jamtland Harjedalen, Sweden | |||
3867862 | 3867862 | 2022-04-05 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-06 04:20:49 | Jamtland Harjedalen, Sweden | |||
2749204 | 2749204 | 2022-04-04 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-05 04:20:48 | Jamtland Harjedalen, Sweden | |||
3730550 | 3730550 | 2022-04-03 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-04 04:20:51 | Jamtland Harjedalen, Sweden | |||
499985 | 499985 | 2022-04-02 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-03 04:20:48 | Jamtland Harjedalen, Sweden | |||
3350970 | 3350970 | 2022-04-01 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-02 04:20:47 | Jamtland Harjedalen, Sweden | |||
1540275 | 1540275 | 2022-03-31 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-01 04:20:28 | Jamtland Harjedalen, Sweden | |||
2478288 | 2478288 | 2022-03-30 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-31 04:20:56 | Jamtland Harjedalen, Sweden | |||
158329 | 158329 | 2022-03-29 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-30 04:20:45 | Jamtland Harjedalen, Sweden | |||
1436900 | 1436900 | 2022-03-28 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-29 04:20:46 | Jamtland Harjedalen, Sweden | |||
876581 | 876581 | 2022-03-27 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-28 04:20:33 | Jamtland Harjedalen, Sweden | |||
2163864 | 2163864 | 2022-03-26 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-27 04:20:47 | Jamtland Harjedalen, Sweden | |||
1720800 | 1720800 | 2022-03-25 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-26 04:20:23 | Jamtland Harjedalen, Sweden | |||
1468417 | 1468417 | 2022-03-24 | Sweden | Jamtland Harjedalen | 32492 | 168 | 0 | 63.1712 | 14.9592 | 2022-03-25 04:20:46 | Jamtland Harjedalen, Sweden | |||
3022591 | 3022591 | 2022-03-23 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-24 04:20:43 | Jamtland Harjedalen, Sweden | |||
1905513 | 1905513 | 2022-03-22 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-23 04:20:48 | Jamtland Harjedalen, Sweden | |||
3238644 | 3238644 | 2022-03-21 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-22 04:20:54 | Jamtland Harjedalen, Sweden | |||
24717 | 24717 | 2022-03-20 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-21 04:20:50 | Jamtland Harjedalen, Sweden | |||
1656727 | 1656727 | 2022-03-19 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-20 04:20:45 | Jamtland Harjedalen, Sweden | |||
336253 | 336253 | 2022-03-18 | Sweden | Jamtland Harjedalen | 32406 | 167 | 0 | 63.1712 | 14.9592 | 2022-03-19 04:20:47 | Jamtland Harjedalen, Sweden | |||
694706 | 694706 | 2022-03-17 | Sweden | Jamtland Harjedalen | 32385 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-18 04:20:55 | Jamtland Harjedalen, Sweden | |||
2319649 | 2319649 | 2022-03-16 | Sweden | Jamtland Harjedalen | 32360 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-17 04:20:56 | Jamtland Harjedalen, Sweden | |||
261849 | 261849 | 2022-03-15 | Sweden | Jamtland Harjedalen | 32334 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-16 04:20:50 | Jamtland Harjedalen, Sweden | |||
2264208 | 2264208 | 2022-03-14 | Sweden | Jamtland Harjedalen | 32255 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-15 04:20:47 | Jamtland Harjedalen, Sweden | |||
3628274 | 3628274 | 2022-03-13 | Sweden | Jamtland Harjedalen | 32255 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-14 04:20:46 | Jamtland Harjedalen, Sweden | |||
951182 | 951182 | 2022-03-12 | Sweden | Jamtland Harjedalen | 32255 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-13 04:20:49 | Jamtland Harjedalen, Sweden | |||
356643 | 356643 | 2022-03-11 | Sweden | Jamtland Harjedalen | 32255 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-12 04:20:50 | Jamtland Harjedalen, Sweden | |||
1865795 | 1865795 | 2022-03-10 | Sweden | Jamtland Harjedalen | 32236 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-11 04:20:50 | Jamtland Harjedalen, Sweden | |||
2140490 | 2140490 | 2022-03-09 | Sweden | Jamtland Harjedalen | 32209 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-10 04:20:48 | Jamtland Harjedalen, Sweden | |||
920001 | 920001 | 2022-03-08 | Sweden | Jamtland Harjedalen | 32176 | 147 | 0 | 63.1712 | 14.9592 | 2022-03-09 04:20:59 | Jamtland Harjedalen, Sweden | |||
1548288 | 1548288 | 2022-03-07 | Sweden | Jamtland Harjedalen | 32099 | 147 | 0 | 63.1712 | 14.9592 | 2022-03-08 04:20:54 | Jamtland Harjedalen, Sweden | |||
2199957 | 2199957 | 2022-03-06 | Sweden | Jamtland Harjedalen | 32099 | 147 | 0 | 63.1712 | 14.9592 | 2022-03-07 04:20:47 | Jamtland Harjedalen, Sweden | |||
2092414 | 2092414 | 2022-03-05 | Sweden | Jamtland Harjedalen | 32099 | 147 | 0 | 63.1712 | 14.9592 | 2022-03-06 04:20:49 | Jamtland Harjedalen, Sweden |
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]);