johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
302 rows where latitude = "50.053000000000004" and province_or_state = "Kiev Oblast" sorted by day 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1329883 | 1329883 | 2022-04-26 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3725837 | 3725837 | 2022-04-25 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2032405 | 2032405 | 2022-04-24 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
749980 | 749980 | 2022-04-23 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3440465 | 3440465 | 2022-04-22 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2896050 | 2896050 | 2022-04-21 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2310922 | 2310922 | 2022-04-20 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2255061 | 2255061 | 2022-04-19 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1849611 | 1849611 | 2022-04-18 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3420555 | 3420555 | 2022-04-17 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
307504 | 307504 | 2022-04-16 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2673449 | 2673449 | 2022-04-15 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1227234 | 1227234 | 2022-04-14 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2446392 | 2446392 | 2022-04-13 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1952149 | 1952149 | 2022-04-12 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3209902 | 3209902 | 2022-04-11 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1579788 | 1579788 | 2022-04-10 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1656030 | 1656030 | 2022-04-09 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2119352 | 2119352 | 2022-04-08 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3323876 | 3323876 | 2022-04-07 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2804412 | 2804412 | 2022-04-06 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3871181 | 3871181 | 2022-04-05 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2752523 | 2752523 | 2022-04-04 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3733869 | 3733869 | 2022-04-03 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
503304 | 503304 | 2022-04-02 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3354289 | 3354289 | 2022-04-01 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1543594 | 1543594 | 2022-03-31 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2481607 | 2481607 | 2022-03-30 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
161648 | 161648 | 2022-03-29 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1440219 | 1440219 | 2022-03-28 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
879900 | 879900 | 2022-03-27 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2167183 | 2167183 | 2022-03-26 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1724119 | 1724119 | 2022-03-25 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1471736 | 1471736 | 2022-03-24 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3025910 | 3025910 | 2022-03-23 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1908832 | 1908832 | 2022-03-22 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3241963 | 3241963 | 2022-03-21 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
28036 | 28036 | 2022-03-20 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1660046 | 1660046 | 2022-03-19 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
339572 | 339572 | 2022-03-18 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
698025 | 698025 | 2022-03-17 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2322968 | 2322968 | 2022-03-16 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
265168 | 265168 | 2022-03-15 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2267527 | 2267527 | 2022-03-14 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
3631593 | 3631593 | 2022-03-13 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
954501 | 954501 | 2022-03-12 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
359962 | 359962 | 2022-03-11 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1869114 | 1869114 | 2022-03-10 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2143809 | 2143809 | 2022-03-09 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
923320 | 923320 | 2022-03-08 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1551607 | 1551607 | 2022-03-07 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2203276 | 2203276 | 2022-03-06 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2095733 | 2095733 | 2022-03-05 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2669433 | 2669433 | 2022-03-04 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1647998 | 1647998 | 2022-03-03 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
2529001 | 2529001 | 2022-03-02 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
1996295 | 1996295 | 2022-03-01 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 23:21:04 | Kiev Oblast, Ukraine | |||
946469 | 946469 | 2022-02-28 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-03-01 04:21:09 | Kiev Oblast, Ukraine | |||
2736660 | 2736660 | 2022-02-27 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-02-28 04:21:05 | Kiev Oblast, Ukraine | |||
3049813 | 3049813 | 2022-02-26 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-02-27 04:21:04 | Kiev Oblast, Ukraine | |||
578468 | 578468 | 2022-02-25 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-02-26 04:21:12 | Kiev Oblast, Ukraine | |||
1515044 | 1515044 | 2022-02-24 | Ukraine | Kiev Oblast | 226220 | 5019 | 0 | 50.053000000000004 | 30.7667 | 2022-02-25 04:21:11 | Kiev Oblast, Ukraine | |||
1061485 | 1061485 | 2022-02-23 | Ukraine | Kiev Oblast | 224983 | 5003 | 0 | 50.053000000000004 | 30.7667 | 2022-02-24 04:21:14 | Kiev Oblast, Ukraine | |||
2450408 | 2450408 | 2022-02-22 | Ukraine | Kiev Oblast | 223666 | 4989 | 0 | 50.053000000000004 | 30.7667 | 2022-02-23 04:21:09 | Kiev Oblast, Ukraine | |||
3721821 | 3721821 | 2022-02-21 | Ukraine | Kiev Oblast | 222517 | 4979 | 0 | 50.053000000000004 | 30.7667 | 2022-02-22 04:21:01 | Kiev Oblast, Ukraine | |||
3915655 | 3915655 | 2022-02-20 | Ukraine | Kiev Oblast | 222033 | 4974 | 0 | 50.053000000000004 | 30.7667 | 2022-02-21 04:21:05 | Kiev Oblast, Ukraine | |||
3879213 | 3879213 | 2022-02-19 | Ukraine | Kiev Oblast | 221459 | 4964 | 0 | 50.053000000000004 | 30.7667 | 2022-02-20 04:21:00 | Kiev Oblast, Ukraine | |||
3859469 | 3859469 | 2022-02-18 | Ukraine | Kiev Oblast | 220202 | 4951 | 0 | 50.053000000000004 | 30.7667 | 2022-02-19 04:21:11 | Kiev Oblast, Ukraine | |||
1301688 | 1301688 | 2022-02-17 | Ukraine | Kiev Oblast | 218886 | 4937 | 0 | 50.053000000000004 | 30.7667 | 2022-02-18 04:21:04 | Kiev Oblast, Ukraine | |||
3824074 | 3824074 | 2022-02-16 | Ukraine | Kiev Oblast | 217420 | 4924 | 0 | 50.053000000000004 | 30.7667 | 2022-02-17 04:20:56 | Kiev Oblast, Ukraine | |||
3675288 | 3675288 | 2022-02-15 | Ukraine | Kiev Oblast | 216161 | 4912 | 0 | 50.053000000000004 | 30.7667 | 2022-02-16 04:21:10 | Kiev Oblast, Ukraine | |||
2645389 | 2645389 | 2022-02-14 | Ukraine | Kiev Oblast | 214933 | 4903 | 0 | 50.053000000000004 | 30.7667 | 2022-02-15 04:21:09 | Kiev Oblast, Ukraine | |||
189706 | 189706 | 2022-02-13 | Ukraine | Kiev Oblast | 214403 | 4898 | 0 | 50.053000000000004 | 30.7667 | 2022-02-14 04:20:51 | Kiev Oblast, Ukraine | |||
319552 | 319552 | 2022-02-12 | Ukraine | Kiev Oblast | 213614 | 4894 | 0 | 50.053000000000004 | 30.7667 | 2022-02-13 04:21:00 | Kiev Oblast, Ukraine | |||
236878 | 236878 | 2022-02-11 | Ukraine | Kiev Oblast | 212288 | 4888 | 0 | 50.053000000000004 | 30.7667 | 2022-02-12 04:21:06 | Kiev Oblast, Ukraine | |||
1467720 | 1467720 | 2022-02-10 | Ukraine | Kiev Oblast | 211009 | 4884 | 0 | 50.053000000000004 | 30.7667 | 2022-02-11 04:21:09 | Kiev Oblast, Ukraine | |||
3077681 | 3077681 | 2022-02-09 | Ukraine | Kiev Oblast | 209636 | 4878 | 0 | 50.053000000000004 | 30.7667 | 2022-02-10 04:21:14 | Kiev Oblast, Ukraine | |||
1365988 | 1365988 | 2022-02-08 | Ukraine | Kiev Oblast | 208322 | 4870 | 0 | 50.053000000000004 | 30.7667 | 2022-02-09 04:21:04 | Kiev Oblast, Ukraine | |||
74726 | 74726 | 2022-02-07 | Ukraine | Kiev Oblast | 207209 | 4861 | 0 | 50.053000000000004 | 30.7667 | 2022-02-08 04:21:15 | Kiev Oblast, Ukraine | |||
2016342 | 2016342 | 2022-02-06 | Ukraine | Kiev Oblast | 206623 | 4861 | 0 | 50.053000000000004 | 30.7667 | 2022-02-07 04:21:05 | Kiev Oblast, Ukraine | |||
1297671 | 1297671 | 2022-02-05 | Ukraine | Kiev Oblast | 205919 | 4859 | 0 | 50.053000000000004 | 30.7667 | 2022-02-06 04:21:00 | Kiev Oblast, Ukraine | |||
2330999 | 2330999 | 2022-02-04 | Ukraine | Kiev Oblast | 204473 | 4851 | 0 | 50.053000000000004 | 30.7667 | 2022-02-05 04:21:05 | Kiev Oblast, Ukraine | |||
2477590 | 2477590 | 2022-02-03 | Ukraine | Kiev Oblast | 202922 | 4843 | 0 | 50.053000000000004 | 30.7667 | 2022-02-04 04:21:10 | Kiev Oblast, Ukraine | |||
463015 | 463015 | 2022-02-02 | Ukraine | Kiev Oblast | 201483 | 4841 | 0 | 50.053000000000004 | 30.7667 | 2022-02-03 04:21:21 | Kiev Oblast, Ukraine | |||
982584 | 982584 | 2022-02-01 | Ukraine | Kiev Oblast | 200074 | 4837 | 0 | 50.053000000000004 | 30.7667 | 2022-02-02 04:21:09 | Kiev Oblast, Ukraine | |||
2661426 | 2661426 | 2022-01-31 | Ukraine | Kiev Oblast | 198900 | 4831 | 0 | 50.053000000000004 | 30.7667 | 2022-02-01 04:21:11 | Kiev Oblast, Ukraine | |||
3303843 | 3303843 | 2022-01-30 | Ukraine | Kiev Oblast | 198309 | 4831 | 0 | 50.053000000000004 | 30.7667 | 2022-01-31 04:21:09 | Kiev Oblast, Ukraine | |||
3065634 | 3065634 | 2022-01-29 | Ukraine | Kiev Oblast | 197665 | 4831 | 0 | 50.053000000000004 | 30.7667 | 2022-01-30 04:21:26 | Kiev Oblast, Ukraine | |||
3813568 | 3813568 | 2022-01-28 | Ukraine | Kiev Oblast | 196438 | 4821 | 0 | 50.053000000000004 | 30.7667 | 2022-01-29 04:21:10 | Kiev Oblast, Ukraine | |||
1783022 | 1783022 | 2022-01-27 | Ukraine | Kiev Oblast | 195250 | 4816 | 0 | 50.053000000000004 | 30.7667 | 2022-01-28 04:21:09 | Kiev Oblast, Ukraine | |||
1321850 | 1321850 | 2022-01-26 | Ukraine | Kiev Oblast | 194270 | 4813 | 0 | 50.053000000000004 | 30.7667 | 2022-01-27 04:21:19 | Kiev Oblast, Ukraine | |||
2055518 | 2055518 | 2022-01-25 | Ukraine | Kiev Oblast | 193398 | 4806 | 0 | 50.053000000000004 | 30.7667 | 2022-01-26 04:21:07 | Kiev Oblast, Ukraine | |||
1231249 | 1231249 | 2022-01-24 | Ukraine | Kiev Oblast | 192653 | 4799 | 0 | 50.053000000000004 | 30.7667 | 2022-01-25 04:21:05 | Kiev Oblast, Ukraine | |||
1144548 | 1144548 | 2022-01-23 | Ukraine | Kiev Oblast | 192397 | 4799 | 0 | 50.053000000000004 | 30.7667 | 2022-01-24 04:21:12 | Kiev Oblast, Ukraine | |||
2836466 | 2836466 | 2022-01-22 | Ukraine | Kiev Oblast | 192021 | 4799 | 0 | 50.053000000000004 | 30.7667 | 2022-01-23 04:21:13 | Kiev Oblast, Ukraine | |||
3428584 | 3428584 | 2022-01-21 | Ukraine | Kiev Oblast | 191278 | 4794 | 0 | 50.053000000000004 | 30.7667 | 2022-01-22 04:21:13 | Kiev Oblast, Ukraine | |||
1964192 | 1964192 | 2022-01-20 | Ukraine | Kiev Oblast | 190606 | 4792 | 0 | 50.053000000000004 | 30.7667 | 2022-01-21 04:21:09 | Kiev Oblast, Ukraine | |||
3230087 | 3230087 | 2022-01-19 | Ukraine | Kiev Oblast | 190072 | 4790 | 0 | 50.053000000000004 | 30.7667 | 2022-01-20 04:21:07 | Kiev Oblast, Ukraine | |||
3467812 | 3467812 | 2022-01-18 | Ukraine | Kiev Oblast | 189581 | 4781 | 0 | 50.053000000000004 | 30.7667 | 2022-01-19 04:21:23 | Kiev Oblast, Ukraine | |||
1475751 | 1475751 | 2022-01-17 | Ukraine | Kiev Oblast | 189236 | 4778 | 0 | 50.053000000000004 | 30.7667 | 2022-01-18 04:21:04 | Kiev 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]);