johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Ukraine" and province_or_state = "Chernihiv Oblast" sorted by confirmed descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28026 | 28026 | 2022-03-20 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
66691 | 66691 | 2022-11-12 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-13 04:21:14 | Chernihiv Oblast, Ukraine | |||
94768 | 94768 | 2022-07-23 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-24 04:20:47 | Chernihiv Oblast, Ukraine | |||
118378 | 118378 | 2022-09-06 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-07 04:20:59 | Chernihiv Oblast, Ukraine | |||
134379 | 134379 | 2022-10-04 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-05 04:23:06 | Chernihiv Oblast, Ukraine | |||
145614 | 145614 | 2022-07-09 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
161638 | 161638 | 2022-03-29 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
169671 | 169671 | 2022-06-21 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
201888 | 201888 | 2022-10-19 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-20 04:22:59 | Chernihiv Oblast, Ukraine | |||
221609 | 221609 | 2022-12-26 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-27 04:21:07 | Chernihiv Oblast, Ukraine | |||
225621 | 225621 | 2022-05-09 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
232853 | 232853 | 2022-05-31 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
256940 | 256940 | 2022-09-08 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-09 04:21:11 | Chernihiv Oblast, Ukraine | |||
260959 | 260959 | 2022-12-10 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-11 04:20:50 | Chernihiv Oblast, Ukraine | |||
265158 | 265158 | 2022-03-15 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
295642 | 295642 | 2022-11-15 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-16 04:21:09 | Chernihiv Oblast, Ukraine | |||
307494 | 307494 | 2022-04-16 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
311514 | 311514 | 2022-12-13 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-14 04:21:04 | Chernihiv Oblast, Ukraine | |||
315530 | 315530 | 2022-11-13 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-14 04:21:09 | Chernihiv Oblast, Ukraine | |||
323562 | 323562 | 2022-10-30 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-31 04:21:36 | Chernihiv Oblast, Ukraine | |||
331536 | 331536 | 2022-12-27 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-28 04:21:04 | Chernihiv Oblast, Ukraine | |||
339562 | 339562 | 2022-03-18 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
351926 | 351926 | 2022-12-14 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-15 04:20:58 | Chernihiv Oblast, Ukraine | |||
359952 | 359952 | 2022-03-11 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
363968 | 363968 | 2022-05-07 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
375826 | 375826 | 2022-09-13 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-14 04:20:44 | Chernihiv Oblast, Ukraine | |||
387853 | 387853 | 2022-09-23 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-24 04:21:40 | Chernihiv Oblast, Ukraine | |||
399894 | 399894 | 2022-10-07 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-08 04:22:56 | Chernihiv Oblast, Ukraine | |||
422965 | 422965 | 2022-09-18 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-19 04:21:49 | Chernihiv Oblast, Ukraine | |||
434987 | 434987 | 2022-11-03 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-04 04:22:11 | Chernihiv Oblast, Ukraine | |||
455017 | 455017 | 2022-12-21 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-22 04:20:56 | Chernihiv Oblast, Ukraine | |||
467022 | 467022 | 2022-05-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
479069 | 479069 | 2022-06-26 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
483220 | 483220 | 2022-11-08 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-09 04:21:22 | Chernihiv Oblast, Ukraine | |||
491250 | 491250 | 2022-11-25 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-26 04:21:11 | Chernihiv Oblast, Ukraine | |||
503294 | 503294 | 2022-04-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
507314 | 507314 | 2022-12-17 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-18 04:21:03 | Chernihiv Oblast, Ukraine | |||
519358 | 519358 | 2022-10-15 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-16 04:22:39 | Chernihiv Oblast, Ukraine | |||
542382 | 542382 | 2022-10-26 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-27 04:22:01 | Chernihiv Oblast, Ukraine | |||
546398 | 546398 | 2022-12-15 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-16 04:21:01 | Chernihiv Oblast, Ukraine | |||
562433 | 562433 | 2022-06-16 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
578458 | 578458 | 2022-02-25 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-02-26 04:21:12 | Chernihiv Oblast, Ukraine | |||
597285 | 597285 | 2022-07-01 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
621492 | 621492 | 2022-11-05 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-06 04:21:24 | Chernihiv Oblast, Ukraine | |||
625505 | 625505 | 2022-05-22 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
633535 | 633535 | 2022-07-12 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
661940 | 661940 | 2022-05-13 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
673926 | 673926 | 2022-07-21 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-22 04:21:15 | Chernihiv Oblast, Ukraine | |||
677942 | 677942 | 2022-07-30 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-31 04:21:02 | Chernihiv Oblast, Ukraine | |||
694003 | 694003 | 2022-12-23 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-24 04:21:02 | Chernihiv Oblast, Ukraine | |||
698015 | 698015 | 2022-03-17 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
714080 | 714080 | 2022-11-01 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-02 04:22:09 | Chernihiv Oblast, Ukraine | |||
722112 | 722112 | 2022-12-04 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-05 04:20:58 | Chernihiv Oblast, Ukraine | |||
749970 | 749970 | 2022-04-23 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
798044 | 798044 | 2022-10-24 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-25 04:21:53 | Chernihiv Oblast, Ukraine | |||
837257 | 837257 | 2022-12-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-03 04:21:02 | Chernihiv Oblast, Ukraine | |||
853229 | 853229 | 2022-11-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-03 04:22:05 | Chernihiv Oblast, Ukraine | |||
857245 | 857245 | 2022-09-30 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-01 04:23:01 | Chernihiv Oblast, Ukraine | |||
872429 | 872429 | 2022-12-11 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-12 04:21:01 | Chernihiv Oblast, Ukraine | |||
879890 | 879890 | 2022-03-27 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
883907 | 883907 | 2022-08-05 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-06 04:20:56 | Chernihiv Oblast, Ukraine | |||
899774 | 899774 | 2022-07-24 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-25 04:20:51 | Chernihiv Oblast, Ukraine | |||
903790 | 903790 | 2022-07-22 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-23 04:20:53 | Chernihiv Oblast, Ukraine | |||
915838 | 915838 | 2022-10-29 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-30 04:22:14 | Chernihiv Oblast, Ukraine | |||
923310 | 923310 | 2022-03-08 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
942444 | 942444 | 2022-06-25 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
946459 | 946459 | 2022-02-28 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 04:21:09 | Chernihiv Oblast, Ukraine | |||
950476 | 950476 | 2022-06-14 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
954491 | 954491 | 2022-03-12 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
962522 | 962522 | 2022-07-19 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-20 04:20:59 | Chernihiv Oblast, Ukraine | |||
966538 | 966538 | 2022-09-09 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-10 04:21:10 | Chernihiv Oblast, Ukraine | |||
974546 | 974546 | 2022-06-01 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
994621 | 994621 | 2022-08-16 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-17 04:20:59 | Chernihiv Oblast, Ukraine | |||
1021980 | 1021980 | 2022-12-24 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-25 04:21:04 | Chernihiv Oblast, Ukraine | |||
1025996 | 1025996 | 2022-11-04 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-05 04:21:52 | Chernihiv Oblast, Ukraine | |||
1053468 | 1053468 | 2022-11-06 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-07 04:21:26 | Chernihiv Oblast, Ukraine | |||
1069504 | 1069504 | 2022-07-28 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-07-29 04:20:45 | Chernihiv Oblast, Ukraine | |||
1073520 | 1073520 | 2022-08-07 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-08 04:21:08 | Chernihiv Oblast, Ukraine | |||
1077539 | 1077539 | 2022-12-28 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-29 04:21:01 | Chernihiv Oblast, Ukraine | |||
1089702 | 1089702 | 2022-08-09 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-10 04:20:57 | Chernihiv Oblast, Ukraine | |||
1101745 | 1101745 | 2022-08-03 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-04 04:20:58 | Chernihiv Oblast, Ukraine | |||
1113201 | 1113201 | 2022-05-21 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1152575 | 1152575 | 2022-12-12 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-12-13 04:21:01 | Chernihiv Oblast, Ukraine | |||
1160778 | 1160778 | 2022-04-29 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1164795 | 1164795 | 2022-08-18 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-19 04:20:54 | Chernihiv Oblast, Ukraine | |||
1172825 | 1172825 | 2022-05-20 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1188372 | 1188372 | 2022-05-18 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1203434 | 1203434 | 2022-07-06 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1215179 | 1215179 | 2022-07-11 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1227224 | 1227224 | 2022-04-14 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1243291 | 1243291 | 2022-11-28 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-11-29 04:21:05 | Chernihiv Oblast, Ukraine | |||
1254384 | 1254384 | 2022-08-23 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-24 04:20:46 | Chernihiv Oblast, Ukraine | |||
1317826 | 1317826 | 2022-05-27 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1329873 | 1329873 | 2022-04-26 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1349947 | 1349947 | 2022-08-10 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-11 04:20:49 | Chernihiv Oblast, Ukraine | |||
1370107 | 1370107 | 2022-10-28 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-10-29 04:21:13 | Chernihiv Oblast, Ukraine | |||
1374123 | 1374123 | 2022-09-21 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-22 04:22:56 | Chernihiv Oblast, Ukraine | |||
1397304 | 1397304 | 2022-09-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-09-03 04:21:04 | Chernihiv Oblast, Ukraine | |||
1401319 | 1401319 | 2022-05-06 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-03-01 23:21:04 | Chernihiv Oblast, Ukraine | |||
1408670 | 1408670 | 2022-08-02 | Ukraine | Chernihiv Oblast | 126202 | 2751 | 0 | 51.4982 | 31.2893 | 2022-08-03 04:20:59 | Chernihiv Oblast, Ukraine |
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]);