johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,634 rows where deaths = 116 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 4,949
- United Kingdom 144
- Japan 130
- Saint Vincent and the Grenadines 99
- Russia 53
- Spain 39
- Sweden 20
- Malaysia 18
- Ukraine 14
- Colombia 11
- Eswatini 11
- Netherlands 11
- Chile 9
- India 8
- Mexico 8
- Nicaragua 7
- Peru 7
- San Marino 7
- Suriname 7
- France 5
- Togo 5
- Australia 4
- Brazil 3
- Canada 3
- Chad 3
- Pakistan 3
- Saint Lucia 3
- Slovenia 3
- Germany 2
- Greece 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756570 | 2756570 | 2022-12-29 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-30 04:21:04 | Isle of Man, United Kingdom | |||
2755978 | 2755978 | 2022-12-29 | US | Texas | Deaf Smith | 48117 | 5656 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-30 04:21:04 | Deaf Smith, Texas, US | |
2754867 | 2754867 | 2022-12-29 | US | Missouri | Saline | 29195 | 7131 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-30 04:21:04 | Saline, Missouri, US | |
2754583 | 2754583 | 2022-12-29 | US | Michigan | Ogemaw | 26129 | 4977 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-30 04:21:04 | Ogemaw, Michigan, US | |
2754400 | 2754400 | 2022-12-29 | US | Louisiana | Bienville | 22013 | 4812 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-30 04:21:04 | Bienville, Louisiana, US | |
2754356 | 2754356 | 2022-12-29 | US | Kentucky | Mercer | 21167 | 9153 | 116 | 0 | 37.81474237 | -84.87488475 | 2022-12-30 04:21:04 | Mercer, Kentucky, US | |
1077576 | 1077576 | 2022-12-28 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-29 04:21:01 | Isle of Man, United Kingdom | |||
1076984 | 1076984 | 2022-12-28 | US | Texas | Deaf Smith | 48117 | 5656 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-29 04:21:01 | Deaf Smith, Texas, US | |
1076482 | 1076482 | 2022-12-28 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-29 04:21:01 | Le Flore, Oklahoma, US | |
1075873 | 1075873 | 2022-12-28 | US | Missouri | Saline | 29195 | 7131 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-29 04:21:01 | Saline, Missouri, US | |
1075618 | 1075618 | 2022-12-28 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-29 04:21:01 | Carlton, Minnesota, US | |
1075589 | 1075589 | 2022-12-28 | US | Michigan | Ogemaw | 26129 | 4977 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-29 04:21:01 | Ogemaw, Michigan, US | |
1075406 | 1075406 | 2022-12-28 | US | Louisiana | Bienville | 22013 | 4812 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-29 04:21:01 | Bienville, Louisiana, US | |
1075362 | 1075362 | 2022-12-28 | US | Kentucky | Mercer | 21167 | 9153 | 116 | 0 | 37.81474237 | -84.87488475 | 2022-12-29 04:21:01 | Mercer, Kentucky, US | |
331573 | 331573 | 2022-12-27 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-28 04:21:04 | Isle of Man, United Kingdom | |||
330981 | 330981 | 2022-12-27 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-28 04:21:04 | Deaf Smith, Texas, US | |
330585 | 330585 | 2022-12-27 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-28 04:21:04 | Greene, Pennsylvania, US | |
330479 | 330479 | 2022-12-27 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-28 04:21:04 | Le Flore, Oklahoma, US | |
329870 | 329870 | 2022-12-27 | US | Missouri | Saline | 29195 | 7131 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-28 04:21:04 | Saline, Missouri, US | |
329615 | 329615 | 2022-12-27 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-28 04:21:04 | Carlton, Minnesota, US | |
329586 | 329586 | 2022-12-27 | US | Michigan | Ogemaw | 26129 | 4977 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-28 04:21:04 | Ogemaw, Michigan, US | |
329403 | 329403 | 2022-12-27 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-28 04:21:04 | Bienville, Louisiana, US | |
329359 | 329359 | 2022-12-27 | US | Kentucky | Mercer | 21167 | 9153 | 116 | 0 | 37.81474237 | -84.87488475 | 2022-12-28 04:21:04 | Mercer, Kentucky, US | |
221646 | 221646 | 2022-12-26 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-27 04:21:07 | Isle of Man, United Kingdom | |||
221054 | 221054 | 2022-12-26 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-27 04:21:07 | Deaf Smith, Texas, US | |
220658 | 220658 | 2022-12-26 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-27 04:21:07 | Greene, Pennsylvania, US | |
220552 | 220552 | 2022-12-26 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-27 04:21:07 | Le Flore, Oklahoma, US | |
219943 | 219943 | 2022-12-26 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-27 04:21:07 | Saline, Missouri, US | |
219688 | 219688 | 2022-12-26 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-27 04:21:07 | Carlton, Minnesota, US | |
219659 | 219659 | 2022-12-26 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-27 04:21:07 | Ogemaw, Michigan, US | |
219476 | 219476 | 2022-12-26 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-27 04:21:07 | Bienville, Louisiana, US | |
3226103 | 3226103 | 2022-12-25 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-26 04:21:06 | Isle of Man, United Kingdom | |||
3225511 | 3225511 | 2022-12-25 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-26 04:21:06 | Deaf Smith, Texas, US | |
3225115 | 3225115 | 2022-12-25 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-26 04:21:06 | Greene, Pennsylvania, US | |
3225009 | 3225009 | 2022-12-25 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-26 04:21:06 | Le Flore, Oklahoma, US | |
3224400 | 3224400 | 2022-12-25 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-26 04:21:06 | Saline, Missouri, US | |
3224145 | 3224145 | 2022-12-25 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-26 04:21:06 | Carlton, Minnesota, US | |
3224116 | 3224116 | 2022-12-25 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-26 04:21:06 | Ogemaw, Michigan, US | |
3223933 | 3223933 | 2022-12-25 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-26 04:21:06 | Bienville, Louisiana, US | |
1022017 | 1022017 | 2022-12-24 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-25 04:21:04 | Isle of Man, United Kingdom | |||
1021425 | 1021425 | 2022-12-24 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-25 04:21:04 | Deaf Smith, Texas, US | |
1021029 | 1021029 | 2022-12-24 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-25 04:21:04 | Greene, Pennsylvania, US | |
1020923 | 1020923 | 2022-12-24 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-25 04:21:04 | Le Flore, Oklahoma, US | |
1020314 | 1020314 | 2022-12-24 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-25 04:21:04 | Saline, Missouri, US | |
1020059 | 1020059 | 2022-12-24 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-25 04:21:04 | Carlton, Minnesota, US | |
1020030 | 1020030 | 2022-12-24 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-25 04:21:04 | Ogemaw, Michigan, US | |
1019847 | 1019847 | 2022-12-24 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-25 04:21:04 | Bienville, Louisiana, US | |
694040 | 694040 | 2022-12-23 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-24 04:21:02 | Isle of Man, United Kingdom | |||
693448 | 693448 | 2022-12-23 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-24 04:21:02 | Deaf Smith, Texas, US | |
693052 | 693052 | 2022-12-23 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-24 04:21:02 | Greene, Pennsylvania, US | |
692946 | 692946 | 2022-12-23 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-24 04:21:02 | Le Flore, Oklahoma, US | |
692337 | 692337 | 2022-12-23 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-24 04:21:02 | Saline, Missouri, US | |
692082 | 692082 | 2022-12-23 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-24 04:21:02 | Carlton, Minnesota, US | |
692053 | 692053 | 2022-12-23 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-24 04:21:02 | Ogemaw, Michigan, US | |
691870 | 691870 | 2022-12-23 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-24 04:21:02 | Bienville, Louisiana, US | |
2183250 | 2183250 | 2022-12-22 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-23 04:21:04 | Isle of Man, United Kingdom | |||
2182658 | 2182658 | 2022-12-22 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-23 04:21:04 | Deaf Smith, Texas, US | |
2182262 | 2182262 | 2022-12-22 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-23 04:21:04 | Greene, Pennsylvania, US | |
2182156 | 2182156 | 2022-12-22 | US | Oklahoma | Le Flore | 40079 | 15016 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-23 04:21:04 | Le Flore, Oklahoma, US | |
2181547 | 2181547 | 2022-12-22 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-23 04:21:04 | Saline, Missouri, US | |
2181292 | 2181292 | 2022-12-22 | US | Minnesota | Carlton | 27017 | 11143 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-23 04:21:04 | Carlton, Minnesota, US | |
2181263 | 2181263 | 2022-12-22 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-23 04:21:04 | Ogemaw, Michigan, US | |
2181080 | 2181080 | 2022-12-22 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-23 04:21:04 | Bienville, Louisiana, US | |
455054 | 455054 | 2022-12-21 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-22 04:20:56 | Isle of Man, United Kingdom | |||
454462 | 454462 | 2022-12-21 | US | Texas | Deaf Smith | 48117 | 5632 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-22 04:20:56 | Deaf Smith, Texas, US | |
454066 | 454066 | 2022-12-21 | US | Pennsylvania | Greene | 42059 | 10348 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-22 04:20:56 | Greene, Pennsylvania, US | |
453960 | 453960 | 2022-12-21 | US | Oklahoma | Le Flore | 40079 | 14923 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-22 04:20:56 | Le Flore, Oklahoma, US | |
453351 | 453351 | 2022-12-21 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-22 04:20:56 | Saline, Missouri, US | |
453136 | 453136 | 2022-12-21 | US | Minnesota | Morrison | 27097 | 10830 | 116 | 0 | 46.01265363 | -94.27341528 | 2022-12-22 04:20:56 | Morrison, Minnesota, US | |
453096 | 453096 | 2022-12-21 | US | Minnesota | Carlton | 27017 | 11094 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-22 04:20:56 | Carlton, Minnesota, US | |
453067 | 453067 | 2022-12-21 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-22 04:20:56 | Ogemaw, Michigan, US | |
452884 | 452884 | 2022-12-21 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-22 04:20:56 | Bienville, Louisiana, US | |
2955053 | 2955053 | 2022-12-20 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-21 04:21:03 | Isle of Man, United Kingdom | |||
2954487 | 2954487 | 2022-12-20 | US | Texas | Gillespie | 48171 | 6071 | 116 | 0 | 30.31824095 | -98.94676915 | 2022-12-21 04:21:03 | Gillespie, Texas, US | |
2954461 | 2954461 | 2022-12-20 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-21 04:21:03 | Deaf Smith, Texas, US | |
2954065 | 2954065 | 2022-12-20 | US | Pennsylvania | Greene | 42059 | 10316 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-21 04:21:03 | Greene, Pennsylvania, US | |
2953959 | 2953959 | 2022-12-20 | US | Oklahoma | Le Flore | 40079 | 14923 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-21 04:21:03 | Le Flore, Oklahoma, US | |
2953350 | 2953350 | 2022-12-20 | US | Missouri | Saline | 29195 | 7118 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-21 04:21:03 | Saline, Missouri, US | |
2953135 | 2953135 | 2022-12-20 | US | Minnesota | Morrison | 27097 | 10830 | 116 | 0 | 46.01265363 | -94.27341528 | 2022-12-21 04:21:03 | Morrison, Minnesota, US | |
2953095 | 2953095 | 2022-12-20 | US | Minnesota | Carlton | 27017 | 11094 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-21 04:21:03 | Carlton, Minnesota, US | |
2953066 | 2953066 | 2022-12-20 | US | Michigan | Ogemaw | 26129 | 4968 | 116 | 0 | 44.33481032 | -84.12725175 | 2022-12-21 04:21:03 | Ogemaw, Michigan, US | |
2952883 | 2952883 | 2022-12-20 | US | Louisiana | Bienville | 22013 | 4788 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-21 04:21:03 | Bienville, Louisiana, US | |
2952362 | 2952362 | 2022-12-20 | US | Illinois | Christian | 17021 | 12625 | 116 | 0 | 39.54581621 | -89.27780482 | 2022-12-21 04:21:03 | Christian, Illinois, US | |
3177455 | 3177455 | 2022-12-19 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-20 04:21:04 | Isle of Man, United Kingdom | |||
3176889 | 3176889 | 2022-12-19 | US | Texas | Gillespie | 48171 | 6071 | 116 | 0 | 30.31824095 | -98.94676915 | 2022-12-20 04:21:04 | Gillespie, Texas, US | |
3176863 | 3176863 | 2022-12-19 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-20 04:21:04 | Deaf Smith, Texas, US | |
3176467 | 3176467 | 2022-12-19 | US | Pennsylvania | Greene | 42059 | 10316 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-20 04:21:04 | Greene, Pennsylvania, US | |
3176361 | 3176361 | 2022-12-19 | US | Oklahoma | Le Flore | 40079 | 14923 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-20 04:21:04 | Le Flore, Oklahoma, US | |
3175752 | 3175752 | 2022-12-19 | US | Missouri | Saline | 29195 | 7105 | 116 | 0 | 39.13734288 | -93.20259964 | 2022-12-20 04:21:04 | Saline, Missouri, US | |
3175537 | 3175537 | 2022-12-19 | US | Minnesota | Morrison | 27097 | 10830 | 116 | 0 | 46.01265363 | -94.27341528 | 2022-12-20 04:21:04 | Morrison, Minnesota, US | |
3175497 | 3175497 | 2022-12-19 | US | Minnesota | Carlton | 27017 | 11094 | 116 | 0 | 46.59180601 | -92.67601019 | 2022-12-20 04:21:04 | Carlton, Minnesota, US | |
3175418 | 3175418 | 2022-12-19 | US | Michigan | Chippewa | 26033 | 10033 | 116 | 0 | 46.29552653 | -84.54353449 | 2022-12-20 04:21:04 | Chippewa, Michigan, US | |
3175285 | 3175285 | 2022-12-19 | US | Louisiana | Bienville | 22013 | 4788 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-20 04:21:04 | Bienville, Louisiana, US | |
3174764 | 3174764 | 2022-12-19 | US | Illinois | Christian | 17021 | 12617 | 116 | 0 | 39.54581621 | -89.27780482 | 2022-12-20 04:21:04 | Christian, Illinois, US | |
3174063 | 3174063 | 2022-12-19 | Saint Vincent and the Grenadines | 9500 | 116 | 0 | 12.9843 | -61.2872 | 2022-12-20 04:21:04 | Saint Vincent and the Grenadines | ||||
1631972 | 1631972 | 2022-12-18 | United Kingdom | Isle of Man | 38008 | 116 | 0 | 54.2361 | -4.5481 | 2022-12-19 04:21:03 | Isle of Man, United Kingdom | |||
1631406 | 1631406 | 2022-12-18 | US | Texas | Gillespie | 48171 | 6071 | 116 | 0 | 30.31824095 | -98.94676915 | 2022-12-19 04:21:03 | Gillespie, Texas, US | |
1631380 | 1631380 | 2022-12-18 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-19 04:21:03 | Deaf Smith, Texas, US | |
1630984 | 1630984 | 2022-12-18 | US | Pennsylvania | Greene | 42059 | 10316 | 116 | 0 | 39.85746531 | -80.22357106 | 2022-12-19 04:21:03 | Greene, Pennsylvania, US | |
1630878 | 1630878 | 2022-12-18 | US | Oklahoma | Le Flore | 40079 | 14923 | 116 | 0 | 34.89851864 | -94.70392124 | 2022-12-19 04:21:03 | Le Flore, Oklahoma, 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]);