johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
778 rows where country_or_region = "Belgium" and province_or_state = "Namur" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, last_update, day (date), last_update (date)
active 250 ✖
- 59739 3
- 59799 3
- 60028 3
- 60198 3
- 60385 3
- 60603 3
- 33294 2
- 44007 2
- 59132 2
- 60289 2
- 29488 1
- 29703 1
- 30043 1
- 30287 1
- 30425 1
- 30517 1
- 30779 1
- 30990 1
- 31164 1
- 31346 1
- 31467 1
- 31538 1
- 31618 1
- 31782 1
- 31933 1
- 32118 1
- 32240 1
- 32325 1
- 32352 1
- 32434 1
- 32543 1
- 32642 1
- 32746 1
- 32877 1
- 32948 1
- 32988 1
- 33053 1
- 33188 1
- 33442 1
- 33685 1
- 33739 1
- 33803 1
- 34047 1
- 34194 1
- 34289 1
- 34433 1
- 34540 1
- 34578 1
- 34661 1
- 34800 1
- 34916 1
- 35030 1
- 35072 1
- 35110 1
- 35140 1
- 35196 1
- 35312 1
- 35386 1
- 35462 1
- 35495 1
- 35520 1
- 35554 1
- 35611 1
- 35734 1
- 35854 1
- 35953 1
- 36034 1
- 36067 1
- 36123 1
- 36178 1
- 36275 1
- 36377 1
- 36425 1
- 36477 1
- 36556 1
- 36602 1
- 36627 1
- 36718 1
- 36781 1
- 36889 1
- 36948 1
- 37015 1
- 37063 1
- 37108 1
- 37203 1
- 37290 1
- 37390 1
- 37488 1
- 37579 1
- 37635 1
- 37678 1
- 37820 1
- 37890 1
- 38046 1
- 38168 1
- 38265 1
- 38326 1
- 38406 1
- 38514 1
- 38593 1
- 38690 1
- 38748 1
- 38845 1
- 38892 1
- 38942 1
- 39069 1
- 39150 1
- 39330 1
- 39436 1
- 39537 1
- 39631 1
- 39760 1
- 39922 1
- 40013 1
- 40185 1
- 40351 1
- 40407 1
- 40451 1
- 40532 1
- 40731 1
- 40874 1
- 41030 1
- 41211 1
- 41347 1
- 41448 1
- 41574 1
- 41834 1
- 42009 1
- 42263 1
- 42513 1
- 42693 1
- 42792 1
- 42954 1
- 43289 1
- 43636 1
- 44747 1
- 44958 1
- 45198 1
- 45721 1
- 46103 1
- 46634 1
- 47079 1
- 47409 1
- 47580 1
- 47895 1
- 48274 1
- 48679 1
- 49067 1
- 49387 1
- 49575 1
- 49764 1
- 49836 1
- 50091 1
- 50409 1
- 50734 1
- 50993 1
- 51157 1
- 51288 1
- 51546 1
- 51822 1
- 52065 1
- 52306 1
- 52546 1
- 52667 1
- 52782 1
- 53033 1
- 53305 1
- 53547 1
- 53730 1
- 54013 1
- 54143 1
- 54268 1
- 54472 1
- 54702 1
- 54880 1
- 55153 1
- 55329 1
- 55434 1
- 55513 1
- 55632 1
- 55894 1
- 56159 1
- 56330 1
- 56483 1
- 56522 1
- 56540 1
- 56855 1
- 57009 1
- 57161 1
- 57209 1
- 57329 1
- 57412 1
- 57450 1
- 57528 1
- 57685 1
- 57857 1
- 57967 1
- 58073 1
- 58117 1
- 58161 1
- 58209 1
- 58302 1
- 58399 1
- 58466 1
- 58543 1
- 58587 1
- 58610 1
- 58699 1
- 58761 1
- 58829 1
- 58863 1
- 58907 1
- 58922 1
- 58932 1
- 58963 1
- 59006 1
- 59022 1
- 59052 1
- 59075 1
- 59087 1
- 59091 1
- 59107 1
- 59120 1
- 59167 1
- 59171 1
- 59172 1
- 59177 1
- 59638 1
- 59710 1
- 59762 1
- 59772 1
- 59782 1
- 59789 1
- 59835 1
- 59848 1
- 59937 1
- 60001 1
- 60077 1
- 60105 1
- 60135 1
- 60167 1
- 60267 1
- 60353 1
- 60461 1
- 60497 1
- 60537 1
- 60560 1
- 60680 1
- 60725 1
- 60776 1
province_or_state 1
- Namur · 778 ✖
country_or_region 1
- Belgium · 778 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752606 | 2752606 | 2022-12-29 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-30 04:21:04 | Namur, Belgium | |||
1073612 | 1073612 | 2022-12-28 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-29 04:21:01 | Namur, Belgium | |||
327609 | 327609 | 2022-12-27 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-28 04:21:04 | Namur, Belgium | |||
217682 | 217682 | 2022-12-26 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-27 04:21:07 | Namur, Belgium | |||
3222139 | 3222139 | 2022-12-25 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-26 04:21:06 | Namur, Belgium | |||
1018053 | 1018053 | 2022-12-24 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-25 04:21:04 | Namur, Belgium | |||
690076 | 690076 | 2022-12-23 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-24 04:21:02 | Namur, Belgium | |||
2179286 | 2179286 | 2022-12-22 | Belgium | Namur | 201053 | 0 | 0 | 50.331 | 4.8221 | 2022-12-23 04:21:04 | Namur, Belgium | |||
451090 | 451090 | 2022-12-21 | Belgium | Namur | 200902 | 0 | 0 | 50.331 | 4.8221 | 2022-12-22 04:20:56 | Namur, Belgium | |||
2951089 | 2951089 | 2022-12-20 | Belgium | Namur | 200902 | 0 | 0 | 50.331 | 4.8221 | 2022-12-21 04:21:03 | Namur, Belgium | |||
3173491 | 3173491 | 2022-12-19 | Belgium | Namur | 200608 | 0 | 0 | 50.331 | 4.8221 | 2022-12-20 04:21:04 | Namur, Belgium | |||
1628008 | 1628008 | 2022-12-18 | Belgium | Namur | 200608 | 0 | 0 | 50.331 | 4.8221 | 2022-12-19 04:21:03 | Namur, Belgium | |||
503387 | 503387 | 2022-12-17 | Belgium | Namur | 200608 | 0 | 0 | 50.331 | 4.8221 | 2022-12-18 04:21:03 | Namur, Belgium | |||
3323959 | 3323959 | 2022-12-16 | Belgium | Namur | 200608 | 0 | 0 | 50.331 | 4.8221 | 2022-12-17 04:21:04 | Namur, Belgium | |||
542471 | 542471 | 2022-12-15 | Belgium | Namur | 200608 | 0 | 0 | 50.331 | 4.8221 | 2022-12-16 04:21:01 | Namur, Belgium | |||
347999 | 347999 | 2022-12-14 | Belgium | Namur | 200410 | 0 | 0 | 50.331 | 4.8221 | 2022-12-15 04:20:58 | Namur, Belgium | |||
307587 | 307587 | 2022-12-13 | Belgium | Namur | 200410 | 0 | 0 | 50.331 | 4.8221 | 2022-12-14 04:21:04 | Namur, Belgium | |||
1148648 | 1148648 | 2022-12-12 | Belgium | Namur | 200410 | 0 | 0 | 50.331 | 4.8221 | 2022-12-13 04:21:01 | Namur, Belgium | |||
868502 | 868502 | 2022-12-11 | Belgium | Namur | 200092 | 0 | 0 | 50.331 | 4.8221 | 2022-12-12 04:21:01 | Namur, Belgium | |||
257032 | 257032 | 2022-12-10 | Belgium | Namur | 200092 | 0 | 0 | 50.331 | 4.8221 | 2022-12-11 04:20:50 | Namur, Belgium | |||
3935746 | 3935746 | 2022-12-09 | Belgium | Namur | 200092 | 0 | 0 | 50.331 | 4.8221 | 2022-12-10 04:21:02 | Namur, Belgium | |||
3377078 | 3377078 | 2022-12-08 | Belgium | Namur | 200092 | 0 | 0 | 50.331 | 4.8221 | 2022-12-09 04:21:05 | Namur, Belgium | |||
1984349 | 1984349 | 2022-12-07 | Belgium | Namur | 199877 | 0 | 0 | 50.331 | 4.8221 | 2022-12-08 04:21:07 | Namur, Belgium | |||
3713872 | 3713872 | 2022-12-06 | Belgium | Namur | 199877 | 0 | 0 | 50.331 | 4.8221 | 2022-12-07 04:20:58 | Namur, Belgium | |||
2414577 | 2414577 | 2022-12-05 | Belgium | Namur | 199877 | 0 | 0 | 50.331 | 4.8221 | 2022-12-06 04:21:03 | Namur, Belgium | |||
718185 | 718185 | 2022-12-04 | Belgium | Namur | 199669 | 0 | 0 | 50.331 | 4.8221 | 2022-12-05 04:20:58 | Namur, Belgium | |||
2816474 | 2816474 | 2022-12-03 | Belgium | Namur | 199669 | 0 | 0 | 50.331 | 4.8221 | 2022-12-04 04:20:56 | Namur, Belgium | |||
833330 | 833330 | 2022-12-02 | Belgium | Namur | 199669 | 0 | 0 | 50.331 | 4.8221 | 2022-12-03 04:21:02 | Namur, Belgium | |||
2135860 | 2135860 | 2022-12-01 | Belgium | Namur | 199669 | 0 | 0 | 50.331 | 4.8221 | 2022-12-02 04:21:07 | Namur, Belgium | |||
1964276 | 1964276 | 2022-11-30 | Belgium | Namur | 199669 | 0 | 0 | 50.331 | 4.8221 | 2022-12-01 04:21:03 | Namur, Belgium | |||
2556290 | 2556290 | 2022-11-29 | Belgium | Namur | 199549 | 0 | 0 | 50.331 | 4.8221 | 2022-11-30 04:21:07 | Namur, Belgium | |||
1239364 | 1239364 | 2022-11-28 | Belgium | Namur | 199549 | 0 | 0 | 50.331 | 4.8221 | 2022-11-29 04:21:05 | Namur, Belgium | |||
3551352 | 3551352 | 2022-11-27 | Belgium | Namur | 199410 | 0 | 0 | 50.331 | 4.8221 | 2022-11-28 04:21:02 | Namur, Belgium | |||
2099832 | 2099832 | 2022-11-26 | Belgium | Namur | 199410 | 0 | 0 | 50.331 | 4.8221 | 2022-11-27 04:21:05 | Namur, Belgium | |||
487323 | 487323 | 2022-11-25 | Belgium | Namur | 199410 | 0 | 0 | 50.331 | 4.8221 | 2022-11-26 04:21:11 | Namur, Belgium | |||
3523152 | 3523152 | 2022-11-24 | Belgium | Namur | 199410 | 0 | 0 | 50.331 | 4.8221 | 2022-11-25 04:21:06 | Namur, Belgium | |||
3311935 | 3311935 | 2022-11-23 | Belgium | Namur | 199251 | 0 | 0 | 50.331 | 4.8221 | 2022-11-24 04:21:09 | Namur, Belgium | |||
1619976 | 1619976 | 2022-11-22 | Belgium | Namur | 199251 | 0 | 0 | 50.331 | 4.8221 | 2022-11-23 04:21:06 | Namur, Belgium | |||
3459864 | 3459864 | 2022-11-21 | Belgium | Namur | 199147 | 0 | 0 | 50.331 | 4.8221 | 2022-11-22 04:20:47 | Namur, Belgium | |||
1640049 | 1640049 | 2022-11-20 | Belgium | Namur | 199147 | 0 | 0 | 50.331 | 4.8221 | 2022-11-21 04:21:05 | Namur, Belgium | |||
2063606 | 2063606 | 2022-11-19 | Belgium | Namur | 199147 | 0 | 0 | 50.331 | 4.8221 | 2022-11-20 04:21:08 | Namur, Belgium | |||
1755000 | 1755000 | 2022-11-18 | Belgium | Namur | 199147 | 0 | 0 | 50.331 | 4.8221 | 2022-11-19 04:21:14 | Namur, Belgium | |||
3025993 | 3025993 | 2022-11-17 | Belgium | Namur | 199147 | 0 | 0 | 50.331 | 4.8221 | 2022-11-18 04:21:15 | Namur, Belgium | |||
2485704 | 2485704 | 2022-11-16 | Belgium | Namur | 199006 | 0 | 0 | 50.331 | 4.8221 | 2022-11-17 04:21:11 | Namur, Belgium | |||
291715 | 291715 | 2022-11-15 | Belgium | Namur | 199006 | 0 | 0 | 50.331 | 4.8221 | 2022-11-16 04:21:09 | Namur, Belgium | |||
3596745 | 3596745 | 2022-11-14 | Belgium | Namur | 199006 | 0 | 0 | 50.331 | 4.8221 | 2022-11-15 04:21:16 | Namur, Belgium | |||
311603 | 311603 | 2022-11-13 | Belgium | Namur | 198951 | 0 | 0 | 50.331 | 4.8221 | 2022-11-14 04:21:09 | Namur, Belgium | |||
62764 | 62764 | 2022-11-12 | Belgium | Namur | 198951 | 0 | 0 | 50.331 | 4.8221 | 2022-11-13 04:21:14 | Namur, Belgium | |||
2926926 | 2926926 | 2022-11-11 | Belgium | Namur | 198951 | 0 | 0 | 50.331 | 4.8221 | 2022-11-12 04:20:41 | Namur, Belgium | |||
2505762 | 2505762 | 2022-11-10 | Belgium | Namur | 198951 | 0 | 0 | 50.331 | 4.8221 | 2022-11-11 04:21:22 | Namur, Belgium | |||
2430637 | 2430637 | 2022-11-09 | Belgium | Namur | 198843 | 0 | 0 | 50.331 | 4.8221 | 2022-11-10 04:21:16 | Namur, Belgium | |||
479293 | 479293 | 2022-11-08 | Belgium | Namur | 198843 | 0 | 0 | 50.331 | 4.8221 | 2022-11-09 04:21:22 | Namur, Belgium | |||
2438443 | 2438443 | 2022-11-07 | Belgium | Namur | 198843 | 0 | 0 | 50.331 | 4.8221 | 2022-11-08 04:21:21 | Namur, Belgium | |||
1049541 | 1049541 | 2022-11-06 | Belgium | Namur | 198766 | 0 | 0 | 50.331 | 4.8221 | 2022-11-07 04:21:26 | Namur, Belgium | |||
617565 | 617565 | 2022-11-05 | Belgium | Namur | 198766 | 0 | 0 | 50.331 | 4.8221 | 2022-11-06 04:21:24 | Namur, Belgium | |||
1022069 | 1022069 | 2022-11-04 | Belgium | Namur | 198766 | 0 | 0 | 50.331 | 4.8221 | 2022-11-05 04:21:52 | Namur, Belgium | |||
431060 | 431060 | 2022-11-03 | Belgium | Namur | 198766 | 0 | 0 | 50.331 | 4.8221 | 2022-11-04 04:22:11 | Namur, Belgium | |||
849302 | 849302 | 2022-11-02 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-11-03 04:22:05 | Namur, Belgium | |||
710153 | 710153 | 2022-11-01 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-11-02 04:22:09 | Namur, Belgium | |||
3284602 | 3284602 | 2022-10-31 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-11-01 04:22:36 | Namur, Belgium | |||
319635 | 319635 | 2022-10-30 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-10-31 04:21:36 | Namur, Belgium | |||
911911 | 911911 | 2022-10-29 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-10-30 04:22:14 | Namur, Belgium | |||
1366180 | 1366180 | 2022-10-28 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-10-29 04:21:13 | Namur, Belgium | |||
3038035 | 3038035 | 2022-10-27 | Belgium | Namur | 198563 | 0 | 0 | 50.331 | 4.8221 | 2022-10-28 04:22:31 | Namur, Belgium | |||
538455 | 538455 | 2022-10-26 | Belgium | Namur | 198356 | 0 | 0 | 50.331 | 4.8221 | 2022-10-27 04:22:01 | Namur, Belgium | |||
1829856 | 1829856 | 2022-10-25 | Belgium | Namur | 198356 | 0 | 0 | 50.331 | 4.8221 | 2022-10-26 04:22:19 | Namur, Belgium | |||
794117 | 794117 | 2022-10-24 | Belgium | Namur | 198356 | 0 | 0 | 50.331 | 4.8221 | 2022-10-25 04:21:53 | Namur, Belgium | |||
3276572 | 3276572 | 2022-10-23 | Belgium | Namur | 198122 | 0 | 0 | 50.331 | 4.8221 | 2022-10-24 04:22:29 | Namur, Belgium | |||
2267610 | 2267610 | 2022-10-22 | Belgium | Namur | 198122 | 0 | 0 | 50.331 | 4.8221 | 2022-10-23 04:22:46 | Namur, Belgium | |||
1591910 | 1591910 | 2022-10-21 | Belgium | Namur | 198122 | 0 | 0 | 50.331 | 4.8221 | 2022-10-22 04:22:53 | Namur, Belgium | |||
2271626 | 2271626 | 2022-10-20 | Belgium | Namur | 198122 | 0 | 0 | 50.331 | 4.8221 | 2022-10-21 04:22:23 | Namur, Belgium | |||
197961 | 197961 | 2022-10-19 | Belgium | Namur | 197756 | 0 | 0 | 50.331 | 4.8221 | 2022-10-20 04:22:59 | Namur, Belgium | |||
2756622 | 2756622 | 2022-10-18 | Belgium | Namur | 197756 | 0 | 0 | 50.331 | 4.8221 | 2022-10-19 04:22:26 | Namur, Belgium | |||
2024456 | 2024456 | 2022-10-17 | Belgium | Namur | 197756 | 0 | 0 | 50.331 | 4.8221 | 2022-10-18 04:22:42 | Namur, Belgium | |||
2159234 | 2159234 | 2022-10-16 | Belgium | Namur | 197348 | 0 | 0 | 50.331 | 4.8221 | 2022-10-17 04:20:31 | Namur, Belgium | |||
515431 | 515431 | 2022-10-15 | Belgium | Namur | 197348 | 0 | 0 | 50.331 | 4.8221 | 2022-10-16 04:22:39 | Namur, Belgium | |||
2032488 | 2032488 | 2022-10-14 | Belgium | Namur | 197348 | 0 | 0 | 50.331 | 4.8221 | 2022-10-15 04:22:00 | Namur, Belgium | |||
3753176 | 3753176 | 2022-10-13 | Belgium | Namur | 197348 | 0 | 0 | 50.331 | 4.8221 | 2022-10-14 04:22:28 | Namur, Belgium | |||
3214001 | 3214001 | 2022-10-12 | Belgium | Namur | 196778 | 0 | 0 | 50.331 | 4.8221 | 2022-10-13 04:22:39 | Namur, Belgium | |||
3249850 | 3249850 | 2022-10-11 | Belgium | Namur | 196778 | 0 | 0 | 50.331 | 4.8221 | 2022-10-12 04:22:51 | Namur, Belgium | |||
2967109 | 2967109 | 2022-10-10 | Belgium | Namur | 196778 | 0 | 0 | 50.331 | 4.8221 | 2022-10-11 04:23:05 | Namur, Belgium | |||
3097145 | 3097145 | 2022-10-09 | Belgium | Namur | 196302 | 0 | 0 | 50.331 | 4.8221 | 2022-10-10 04:22:32 | Namur, Belgium | |||
4002370 | 4002370 | 2022-10-08 | Belgium | Namur | 196302 | 0 | 0 | 50.331 | 4.8221 | 2022-10-09 04:21:16 | Namur, Belgium | |||
395967 | 395967 | 2022-10-07 | Belgium | Namur | 196302 | 0 | 0 | 50.331 | 4.8221 | 2022-10-08 04:22:56 | Namur, Belgium | |||
2529084 | 2529084 | 2022-10-06 | Belgium | Namur | 196302 | 0 | 0 | 50.331 | 4.8221 | 2022-10-07 04:23:08 | Namur, Belgium | |||
1810478 | 1810478 | 2022-10-05 | Belgium | Namur | 195580 | 0 | 0 | 50.331 | 4.8221 | 2022-10-06 04:21:22 | Namur, Belgium | |||
130452 | 130452 | 2022-10-04 | Belgium | Namur | 195580 | 0 | 0 | 50.331 | 4.8221 | 2022-10-05 04:23:06 | Namur, Belgium | |||
2685399 | 2685399 | 2022-10-03 | Belgium | Namur | 195580 | 0 | 0 | 50.331 | 4.8221 | 2022-10-04 04:22:55 | Namur, Belgium | |||
2259466 | 2259466 | 2022-10-02 | Belgium | Namur | 195055 | 0 | 0 | 50.331 | 4.8221 | 2022-10-03 04:23:11 | Namur, Belgium | |||
2994992 | 2994992 | 2022-10-01 | Belgium | Namur | 195055 | 0 | 0 | 50.331 | 4.8221 | 2022-10-02 04:21:23 | Namur, Belgium | |||
853318 | 853318 | 2022-09-30 | Belgium | Namur | 195055 | 0 | 0 | 50.331 | 4.8221 | 2022-10-01 04:23:01 | Namur, Belgium | |||
2375244 | 2375244 | 2022-09-29 | Belgium | Namur | 195055 | 0 | 0 | 50.331 | 4.8221 | 2022-09-30 04:23:09 | Namur, Belgium | |||
1559795 | 1559795 | 2022-09-28 | Belgium | Namur | 194413 | 0 | 0 | 50.331 | 4.8221 | 2022-09-29 04:22:34 | Namur, Belgium | |||
3994338 | 3994338 | 2022-09-27 | Belgium | Namur | 194413 | 0 | 0 | 50.331 | 4.8221 | 2022-09-28 04:23:01 | Namur, Belgium | |||
2768666 | 2768666 | 2022-09-26 | Belgium | Namur | 194413 | 0 | 0 | 50.331 | 4.8221 | 2022-09-27 04:23:01 | Namur, Belgium | |||
1976319 | 1976319 | 2022-09-25 | Belgium | Namur | 193994 | 0 | 0 | 50.331 | 4.8221 | 2022-09-26 04:20:52 | Namur, Belgium | |||
2649486 | 2649486 | 2022-09-24 | Belgium | Namur | 193994 | 0 | 0 | 50.331 | 4.8221 | 2022-09-25 04:23:31 | Namur, Belgium | |||
383926 | 383926 | 2022-09-23 | Belgium | Namur | 193994 | 0 | 0 | 50.331 | 4.8221 | 2022-09-24 04:21:40 | Namur, Belgium | |||
1623992 | 1623992 | 2022-09-22 | Belgium | Namur | 193994 | 0 | 0 | 50.331 | 4.8221 | 2022-09-23 04:23:13 | Namur, Belgium | |||
1370196 | 1370196 | 2022-09-21 | Belgium | Namur | 193494 | 0 | 0 | 50.331 | 4.8221 | 2022-09-22 04:22:56 | Namur, Belgium |
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]);