johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Pais Vasco" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- …
province_or_state 1
- Pais Vasco · 393 ✖
country_or_region 1
- Spain · 393 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2717274 | 2717274 | 2021-06-10 | Spain | Pais Vasco | 201300 | 4493 | 16160 | 180647 | 42.9896 | -2.6189 | 2021-06-11 04:23:20 | Pais Vasco, Spain | ||
523159 | 523159 | 2021-06-09 | Spain | Pais Vasco | 201063 | 4472 | 16160 | 180431 | 42.9896 | -2.6189 | 2021-06-10 04:23:17 | Pais Vasco, Spain | ||
3472599 | 3472599 | 2021-06-08 | Spain | Pais Vasco | 200836 | 4470 | 16160 | 180206 | 42.9896 | -2.6189 | 2021-06-09 04:23:31 | Pais Vasco, Spain | ||
3145883 | 3145883 | 2021-06-07 | Spain | Pais Vasco | 200615 | 4470 | 16160 | 179985 | 42.9896 | -2.6189 | 2021-06-08 04:22:35 | Pais Vasco, Spain | ||
825885 | 825885 | 2021-06-06 | Spain | Pais Vasco | 199976 | 4467 | 16160 | 179349 | 42.9896 | -2.6189 | 2021-06-07 04:22:51 | Pais Vasco, Spain | ||
2586290 | 2586290 | 2021-06-05 | Spain | Pais Vasco | 199976 | 4467 | 16160 | 179349 | 42.9896 | -2.6189 | 2021-06-06 04:24:03 | Pais Vasco, Spain | ||
2315604 | 2315604 | 2021-06-04 | Spain | Pais Vasco | 199976 | 4467 | 16160 | 179349 | 42.9896 | -2.6189 | 2021-06-05 04:23:03 | Pais Vasco, Spain | ||
1448889 | 1448889 | 2021-06-03 | Spain | Pais Vasco | 199658 | 4441 | 16160 | 179057 | 42.9896 | -2.6189 | 2021-06-04 04:23:37 | Pais Vasco, Spain | ||
1708613 | 1708613 | 2021-06-02 | Spain | Pais Vasco | 199347 | 4441 | 16160 | 178746 | 42.9896 | -2.6189 | 2021-06-03 04:23:32 | Pais Vasco, Spain | ||
2104431 | 2104431 | 2021-06-01 | Spain | Pais Vasco | 199008 | 4433 | 16160 | 178415 | 42.9896 | -2.6189 | 2021-06-02 04:24:34 | Pais Vasco, Spain | ||
1189047 | 1189047 | 2021-05-31 | Spain | Pais Vasco | 198674 | 4429 | 16160 | 178085 | 42.9896 | -2.6189 | 2021-06-01 04:23:09 | Pais Vasco, Spain | ||
3089724 | 3089724 | 2021-05-30 | Spain | Pais Vasco | 197812 | 4429 | 16160 | 177223 | 42.9896 | -2.6189 | 2021-05-31 03:08:59 | Pais Vasco, Spain | ||
51093 | 51093 | 2021-05-29 | Spain | Pais Vasco | 197812 | 4429 | 16160 | 177223 | 42.9896 | -2.6189 | 2021-05-30 04:20:55 | Pais Vasco, Spain | ||
20672 | 20672 | 2021-05-28 | Spain | Pais Vasco | 197812 | 4429 | 16160 | 177223 | 42.9896 | -2.6189 | 2021-05-29 04:20:41 | Pais Vasco, Spain | ||
1807047 | 1807047 | 2021-05-27 | Spain | Pais Vasco | 197471 | 4428 | 16160 | 176883 | 42.9896 | -2.6189 | 2021-05-28 04:20:36 | Pais Vasco, Spain | ||
1310470 | 1310470 | 2021-05-26 | Spain | Pais Vasco | 197142 | 4425 | 16160 | 176557 | 42.9896 | -2.6189 | 2021-05-27 04:20:59 | Pais Vasco, Spain | ||
83396 | 83396 | 2021-05-25 | Spain | Pais Vasco | 196767 | 4425 | 16160 | 176182 | 42.9896 | -2.6189 | 2021-05-26 04:20:35 | Pais Vasco, Spain | ||
1413358 | 1413358 | 2021-05-24 | Spain | Pais Vasco | 196491 | 4398 | 16160 | 175933 | 42.9896 | -2.6189 | 2021-05-25 04:21:08 | Pais Vasco, Spain | ||
1771644 | 1771644 | 2021-05-23 | Spain | Pais Vasco | 195265 | 4395 | 16160 | 174710 | 42.9896 | -2.6189 | 2021-05-24 04:20:53 | Pais Vasco, Spain | ||
726799 | 726799 | 2021-05-22 | Spain | Pais Vasco | 195265 | 4395 | 16160 | 174710 | 42.9896 | -2.6189 | 2021-05-23 04:20:51 | Pais Vasco, Spain | ||
1952814 | 1952814 | 2021-05-21 | Spain | Pais Vasco | 195265 | 4395 | 16160 | 174710 | 42.9896 | -2.6189 | 2021-05-22 04:20:45 | Pais Vasco, Spain | ||
1913513 | 1913513 | 2021-05-20 | Spain | Pais Vasco | 195258 | 4395 | 16160 | 174703 | 42.9896 | -2.6189 | 2021-05-21 04:20:43 | Pais Vasco, Spain | ||
2256034 | 2256034 | 2021-05-19 | Spain | Pais Vasco | 194915 | 4393 | 16160 | 174362 | 42.9896 | -2.6189 | 2021-05-20 04:21:05 | Pais Vasco, Spain | ||
2391072 | 2391072 | 2021-05-18 | Spain | Pais Vasco | 194551 | 4365 | 16160 | 174026 | 42.9896 | -2.6189 | 2021-05-19 04:20:42 | Pais Vasco, Spain | ||
3574897 | 3574897 | 2021-05-17 | Spain | Pais Vasco | 194255 | 4363 | 16160 | 173732 | 42.9896 | -2.6189 | 2021-05-18 04:20:33 | Pais Vasco, Spain | ||
2939627 | 2939627 | 2021-05-16 | Spain | Pais Vasco | 193326 | 4359 | 16160 | 172807 | 42.9896 | -2.6189 | 2021-05-17 04:20:34 | Pais Vasco, Spain | ||
1873257 | 1873257 | 2021-05-15 | Spain | Pais Vasco | 193326 | 4359 | 16160 | 172807 | 42.9896 | -2.6189 | 2021-05-16 04:20:49 | Pais Vasco, Spain | ||
1082226 | 1082226 | 2021-05-14 | Spain | Pais Vasco | 193326 | 4359 | 16160 | 172807 | 42.9896 | -2.6189 | 2021-05-15 04:20:58 | Pais Vasco, Spain | ||
3054492 | 3054492 | 2021-05-13 | Spain | Pais Vasco | 192490 | 4353 | 16160 | 171977 | 42.9896 | -2.6189 | 2021-05-14 04:20:41 | Pais Vasco, Spain | ||
2004962 | 2004962 | 2021-05-12 | Spain | Pais Vasco | 192477 | 4353 | 16160 | 171964 | 42.9896 | -2.6189 | 2021-05-13 04:20:51 | Pais Vasco, Spain | ||
3954793 | 3954793 | 2021-05-11 | Spain | Pais Vasco | 191974 | 4349 | 16160 | 171465 | 42.9896 | -2.6189 | 2021-05-12 04:21:29 | Pais Vasco, Spain | ||
2821072 | 2821072 | 2021-05-10 | Spain | Pais Vasco | 191513 | 4281 | 16160 | 171072 | 42.9896 | -2.6189 | 2021-05-11 04:20:41 | Pais Vasco, Spain | ||
1425404 | 1425404 | 2021-05-09 | Spain | Pais Vasco | 190197 | 4274 | 16160 | 169763 | 42.9896 | -2.6189 | 2021-05-10 04:20:38 | Pais Vasco, Spain | ||
1552272 | 1552272 | 2021-05-08 | Spain | Pais Vasco | 190197 | 4274 | 16160 | 169763 | 42.9896 | -2.6189 | 2021-05-09 04:20:35 | Pais Vasco, Spain | ||
2502330 | 2502330 | 2021-05-07 | Spain | Pais Vasco | 190197 | 4274 | 16160 | 169763 | 42.9896 | -2.6189 | 2021-05-08 04:21:04 | Pais Vasco, Spain | ||
3113786 | 3113786 | 2021-05-06 | Spain | Pais Vasco | 189580 | 4273 | 16160 | 169147 | 42.9896 | -2.6189 | 2021-05-07 04:20:40 | Pais Vasco, Spain | ||
646253 | 646253 | 2021-05-05 | Spain | Pais Vasco | 188890 | 4191 | 16160 | 168539 | 42.9896 | -2.6189 | 2021-05-06 04:20:38 | Pais Vasco, Spain | ||
3675953 | 3675953 | 2021-05-04 | Spain | Pais Vasco | 188197 | 4189 | 16160 | 167848 | 42.9896 | -2.6189 | 2021-05-05 04:20:43 | Pais Vasco, Spain | ||
2761220 | 2761220 | 2021-05-03 | Spain | Pais Vasco | 187530 | 4186 | 16160 | 167184 | 42.9896 | -2.6189 | 2021-05-04 04:20:34 | Pais Vasco, Spain | ||
2451073 | 2451073 | 2021-05-02 | Spain | Pais Vasco | 185771 | 4182 | 16160 | 165429 | 42.9896 | -2.6189 | 2021-05-03 04:20:39 | Pais Vasco, Spain | ||
2825086 | 2825086 | 2021-05-01 | Spain | Pais Vasco | 185771 | 4182 | 16160 | 165429 | 42.9896 | -2.6189 | 2021-05-02 04:20:48 | Pais Vasco, Spain | ||
380494 | 380494 | 2021-04-30 | Spain | Pais Vasco | 185771 | 4182 | 16160 | 165429 | 42.9896 | -2.6189 | 2021-05-01 04:20:47 | Pais Vasco, Spain | ||
1636617 | 1636617 | 2021-04-29 | Spain | Pais Vasco | 184868 | 4157 | 16160 | 164551 | 42.9896 | -2.6189 | 2021-04-30 04:21:03 | Pais Vasco, Spain | ||
3393696 | 3393696 | 2021-04-28 | Spain | Pais Vasco | 183227 | 4131 | 16160 | 162936 | 42.9896 | -2.6189 | 2021-04-29 04:20:55 | Pais Vasco, Spain | ||
3702412 | 3702412 | 2021-04-27 | Spain | Pais Vasco | 183203 | 4131 | 16160 | 162912 | 42.9896 | -2.6189 | 2021-04-28 04:20:32 | Pais Vasco, Spain | ||
888421 | 888421 | 2021-04-26 | Spain | Pais Vasco | 182435 | 4129 | 16160 | 162146 | 42.9896 | -2.6189 | 2021-04-27 04:20:52 | Pais Vasco, Spain | ||
955166 | 955166 | 2021-04-25 | Spain | Pais Vasco | 180127 | 4124 | 16160 | 159843 | 42.9896 | -2.6189 | 2021-04-26 04:21:04 | Pais Vasco, Spain | ||
3924313 | 3924313 | 2021-04-24 | Spain | Pais Vasco | 180127 | 4124 | 16160 | 159843 | 42.9896 | -2.6189 | 2021-04-25 04:20:32 | Pais Vasco, Spain | ||
1409344 | 1409344 | 2021-04-23 | Spain | Pais Vasco | 180127 | 4124 | 16160 | 159843 | 42.9896 | -2.6189 | 2021-04-24 04:20:38 | Pais Vasco, Spain | ||
1568407 | 1568407 | 2021-04-22 | Spain | Pais Vasco | 179136 | 4123 | 16160 | 158853 | 42.9896 | -2.6189 | 2021-04-23 04:20:52 | Pais Vasco, Spain | ||
3242628 | 3242628 | 2021-04-21 | Spain | Pais Vasco | 178117 | 4089 | 16160 | 157868 | 42.9896 | -2.6189 | 2021-04-22 04:20:53 | Pais Vasco, Spain | ||
2021024 | 2021024 | 2021-04-20 | Spain | Pais Vasco | 176248 | 4077 | 16160 | 156011 | 42.9896 | -2.6189 | 2021-04-21 04:21:14 | Pais Vasco, Spain | ||
2411145 | 2411145 | 2021-04-19 | Spain | Pais Vasco | 176248 | 4077 | 16160 | 156011 | 42.9896 | -2.6189 | 2021-04-20 04:20:41 | Pais Vasco, Spain | ||
3129822 | 3129822 | 2021-04-18 | Spain | Pais Vasco | 174111 | 4075 | 16160 | 153876 | 42.9896 | -2.6189 | 2021-04-19 04:20:57 | Pais Vasco, Spain | ||
983250 | 983250 | 2021-04-17 | Spain | Pais Vasco | 174111 | 4075 | 16160 | 153876 | 42.9896 | -2.6189 | 2021-04-18 04:20:41 | Pais Vasco, Spain | ||
170345 | 170345 | 2021-04-16 | Spain | Pais Vasco | 174111 | 4075 | 16160 | 153876 | 42.9896 | -2.6189 | 2021-04-17 04:20:40 | Pais Vasco, Spain | ||
2549176 | 2549176 | 2021-04-15 | Spain | Pais Vasco | 173185 | 4064 | 16160 | 152961 | 42.9896 | -2.6189 | 2021-04-16 04:20:46 | Pais Vasco, Spain | ||
1842246 | 1842246 | 2021-04-14 | Spain | Pais Vasco | 172237 | 4028 | 16160 | 152049 | 42.9896 | -2.6189 | 2021-04-15 04:20:54 | Pais Vasco, Spain | ||
2571980 | 2571980 | 2021-04-13 | Spain | Pais Vasco | 171232 | 4026 | 16160 | 151046 | 42.9896 | -2.6189 | 2021-04-14 04:20:41 | Pais Vasco, Spain | ||
36731 | 36731 | 2021-04-12 | Spain | Pais Vasco | 170488 | 4022 | 16160 | 150306 | 42.9896 | -2.6189 | 2021-04-13 04:20:37 | Pais Vasco, Spain | ||
3883890 | 3883890 | 2021-04-11 | Spain | Pais Vasco | 168334 | 4020 | 16160 | 148154 | 42.9896 | -2.6189 | 2021-04-12 04:21:00 | Pais Vasco, Spain | ||
2983558 | 2983558 | 2021-04-10 | Spain | Pais Vasco | 168334 | 4020 | 16160 | 148154 | 42.9896 | -2.6189 | 2021-04-11 04:20:56 | Pais Vasco, Spain | ||
605990 | 605990 | 2021-04-09 | Spain | Pais Vasco | 168334 | 4020 | 16160 | 148154 | 42.9896 | -2.6189 | 2021-04-10 04:20:59 | Pais Vasco, Spain | ||
2646054 | 2646054 | 2021-04-08 | Spain | Pais Vasco | 167551 | 3954 | 16160 | 147437 | 42.9896 | -2.6189 | 2021-04-09 04:21:13 | Pais Vasco, Spain | ||
2247696 | 2247696 | 2021-04-07 | Spain | Pais Vasco | 166773 | 3947 | 16160 | 146666 | 42.9896 | -2.6189 | 2021-04-08 04:21:13 | Pais Vasco, Spain | ||
3003606 | 3003606 | 2021-04-06 | Spain | Pais Vasco | 166088 | 3946 | 16160 | 145982 | 42.9896 | -2.6189 | 2021-04-07 04:20:53 | Pais Vasco, Spain | ||
3085601 | 3085601 | 2021-04-05 | Spain | Pais Vasco | 165595 | 3946 | 16160 | 145489 | 42.9896 | -2.6189 | 2021-04-06 04:20:32 | Pais Vasco, Spain | ||
388524 | 388524 | 2021-04-04 | Spain | Pais Vasco | 164609 | 3946 | 16160 | 144503 | 42.9896 | -2.6189 | 2021-04-05 04:20:35 | Pais Vasco, Spain | ||
3710440 | 3710440 | 2021-04-03 | Spain | Pais Vasco | 164609 | 3946 | 16160 | 144503 | 42.9896 | -2.6189 | 2021-04-04 04:20:49 | Pais Vasco, Spain | ||
241556 | 241556 | 2021-04-02 | Spain | Pais Vasco | 163360 | 3946 | 16160 | 143254 | 42.9896 | -2.6189 | 2021-04-03 04:20:44 | Pais Vasco, Spain | ||
1302353 | 1302353 | 2021-04-01 | Spain | Pais Vasco | 163360 | 3946 | 16160 | 143254 | 42.9896 | -2.6189 | 2021-04-02 04:20:36 | Pais Vasco, Spain | ||
638225 | 638225 | 2021-03-31 | Spain | Pais Vasco | 162872 | 3944 | 16160 | 142768 | 42.9896 | -2.6189 | 2021-04-01 04:27:05 | Pais Vasco, Spain | ||
3643854 | 3643854 | 2021-03-30 | Spain | Pais Vasco | 162240 | 3944 | 16160 | 142136 | 42.9896 | -2.6189 | 2021-03-31 04:26:25 | Pais Vasco, Spain | ||
1290307 | 1290307 | 2021-03-29 | Spain | Pais Vasco | 161823 | 3942 | 16160 | 141721 | 42.9896 | -2.6189 | 2021-03-30 04:26:23 | Pais Vasco, Spain | ||
1536229 | 1536229 | 2021-03-28 | Spain | Pais Vasco | 160437 | 3942 | 16160 | 140335 | 42.9896 | -2.6189 | 2021-03-29 04:28:35 | Pais Vasco, Spain | ||
1219869 | 1219869 | 2021-03-27 | Spain | Pais Vasco | 160437 | 3942 | 16160 | 140335 | 42.9896 | -2.6189 | 2021-03-28 05:28:10 | Pais Vasco, Spain | ||
1881287 | 1881287 | 2021-03-26 | Spain | Pais Vasco | 160437 | 3942 | 16160 | 140335 | 42.9896 | -2.6189 | 2021-03-27 05:25:04 | Pais Vasco, Spain | ||
1980917 | 1980917 | 2021-03-25 | Spain | Pais Vasco | 159853 | 3932 | 16160 | 139761 | 42.9896 | -2.6189 | 2021-03-26 05:26:55 | Pais Vasco, Spain | ||
2781295 | 2781295 | 2021-03-24 | Spain | Pais Vasco | 158812 | 3925 | 16160 | 138727 | 42.9896 | -2.6189 | 2021-03-25 05:27:00 | Pais Vasco, Spain | ||
1798940 | 1798940 | 2021-03-23 | Spain | Pais Vasco | 158812 | 3925 | 16160 | 138727 | 42.9896 | -2.6189 | 2021-03-24 05:25:40 | Pais Vasco, Spain | ||
1204108 | 1204108 | 2021-03-22 | Spain | Pais Vasco | 158403 | 3891 | 16160 | 138352 | 42.9896 | -2.6189 | 2021-03-23 05:26:18 | Pais Vasco, Spain | ||
3369630 | 3369630 | 2021-03-21 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-22 05:25:43 | Pais Vasco, Spain | ||
1744840 | 1744840 | 2021-03-20 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-21 05:25:44 | Pais Vasco, Spain | ||
3421220 | 3421220 | 2021-03-19 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-20 05:25:46 | Pais Vasco, Spain | ||
3453158 | 3453158 | 2021-03-18 | Spain | Pais Vasco | 157008 | 3877 | 16160 | 136971 | 42.9896 | -2.6189 | 2021-03-19 05:26:09 | Pais Vasco, Spain | ||
3621382 | 3621382 | 2021-03-17 | Spain | Pais Vasco | 156594 | 3876 | 16160 | 136558 | 42.9896 | -2.6189 | 2021-03-18 05:26:22 | Pais Vasco, Spain | ||
702706 | 702706 | 2021-03-16 | Spain | Pais Vasco | 156199 | 3842 | 16160 | 136197 | 42.9896 | -2.6189 | 2021-03-17 05:25:07 | Pais Vasco, Spain | ||
2056184 | 2056184 | 2021-03-15 | Spain | Pais Vasco | 155799 | 3840 | 16160 | 135799 | 42.9896 | -2.6189 | 2021-03-16 05:25:13 | Pais Vasco, Spain | ||
1732796 | 1732796 | 2021-03-14 | Spain | Pais Vasco | 154945 | 3839 | 16160 | 134946 | 42.9896 | -2.6189 | 2021-03-15 05:25:51 | Pais Vasco, Spain | ||
1580453 | 1580453 | 2021-03-13 | Spain | Pais Vasco | 154945 | 3839 | 16160 | 134946 | 42.9896 | -2.6189 | 2021-03-14 05:25:37 | Pais Vasco, Spain | ||
1838232 | 1838232 | 2021-03-12 | Spain | Pais Vasco | 154945 | 3839 | 16160 | 134946 | 42.9896 | -2.6189 | 2021-03-13 05:25:15 | Pais Vasco, Spain | ||
352597 | 352597 | 2021-03-11 | Spain | Pais Vasco | 154579 | 3819 | 16160 | 134600 | 42.9896 | -2.6189 | 2021-03-12 05:26:50 | Pais Vasco, Spain | ||
3962821 | 3962821 | 2021-03-10 | Spain | Pais Vasco | 154224 | 3817 | 16160 | 134247 | 42.9896 | -2.6189 | 2021-03-11 05:25:48 | Pais Vasco, Spain | ||
3663909 | 3663909 | 2021-03-09 | Spain | Pais Vasco | 153937 | 3796 | 16160 | 133981 | 42.9896 | -2.6189 | 2021-03-10 05:24:35 | Pais Vasco, Spain | ||
2359768 | 2359768 | 2021-03-08 | Spain | Pais Vasco | 153596 | 3785 | 16160 | 133651 | 42.9896 | -2.6189 | 2021-03-09 05:28:19 | Pais Vasco, Spain | ||
55106 | 55106 | 2021-03-07 | Spain | Pais Vasco | 152850 | 3784 | 16160 | 132906 | 42.9896 | -2.6189 | 2021-03-08 05:24:48 | Pais Vasco, Spain | ||
3667923 | 3667923 | 2021-03-06 | Spain | Pais Vasco | 152850 | 3784 | 16160 | 132906 | 42.9896 | -2.6189 | 2021-03-07 05:21:54 | Pais Vasco, Spain | ||
1616544 | 1616544 | 2021-03-05 | Spain | Pais Vasco | 152850 | 3784 | 16160 | 132906 | 42.9896 | -2.6189 | 2021-03-06 04:23:41 | Pais Vasco, Spain | ||
2207955 | 2207955 | 2021-03-04 | Spain | Pais Vasco | 152230 | 3782 | 16160 | 132288 | 42.9896 | -2.6189 | 2021-03-05 05:26:29 | Pais Vasco, Spain | ||
1090376 | 1090376 | 2021-03-03 | Spain | Pais Vasco | 152199 | 3782 | 16160 | 132257 | 42.9896 | -2.6189 | 2021-03-04 05:24:24 | Pais Vasco, Spain |
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]);