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 = "Luhansk Oblast" sorted by last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805355 | 805355 | 2020-06-01 | Ukraine | Luhansk Oblast | 47 | 0 | 40 | 7 | 48.574 | 39.3078 | 2020-06-02 02:33:08 | Luhansk Oblast, Ukraine | ||
2555818 | 2555818 | 2020-06-02 | Ukraine | Luhansk Oblast | 47 | 0 | 40 | 7 | 48.574 | 39.3078 | 2020-06-03 02:33:13 | Luhansk Oblast, Ukraine | ||
3866776 | 3866776 | 2020-06-03 | Ukraine | Luhansk Oblast | 49 | 0 | 40 | 9 | 48.574 | 39.3078 | 2020-06-04 02:33:14 | Luhansk Oblast, Ukraine | ||
1281221 | 1281221 | 2020-06-04 | Ukraine | Luhansk Oblast | 51 | 0 | 41 | 10 | 48.574 | 39.3078 | 2020-06-05 02:33:06 | Luhansk Oblast, Ukraine | ||
1269749 | 1269749 | 2020-06-05 | Ukraine | Luhansk Oblast | 51 | 0 | 43 | 8 | 48.574 | 39.3078 | 2020-06-06 02:33:00 | Luhansk Oblast, Ukraine | ||
574052 | 574052 | 2020-06-06 | Ukraine | Luhansk Oblast | 52 | 0 | 43 | 9 | 48.574 | 39.3078 | 2020-06-07 03:53:30 | Luhansk Oblast, Ukraine | ||
2799996 | 2799996 | 2020-06-07 | Ukraine | Luhansk Oblast | 54 | 0 | 43 | 11 | 48.574 | 39.3078 | 2020-06-08 03:33:22 | Luhansk Oblast, Ukraine | ||
217200 | 217200 | 2020-06-08 | Ukraine | Luhansk Oblast | 54 | 0 | 43 | 11 | 48.574 | 39.3078 | 2020-06-09 03:33:03 | Luhansk Oblast, Ukraine | ||
1210773 | 1210773 | 2020-06-09 | Ukraine | Luhansk Oblast | 54 | 0 | 43 | 11 | 48.574 | 39.3078 | 2020-06-10 04:07:00 | Luhansk Oblast, Ukraine | ||
2863936 | 2863936 | 2020-06-10 | Ukraine | Luhansk Oblast | 54 | 0 | 43 | 11 | 48.574 | 39.3078 | 2020-06-11 03:33:41 | Luhansk Oblast, Ukraine | ||
1273493 | 1273493 | 2020-06-11 | Ukraine | Luhansk Oblast | 54 | 0 | 44 | 10 | 48.574 | 39.3078 | 2020-06-12 05:09:52 | Luhansk Oblast, Ukraine | ||
737523 | 737523 | 2020-06-12 | Ukraine | Luhansk Oblast | 54 | 0 | 45 | 9 | 48.574 | 39.3078 | 2020-06-13 03:33:14 | Luhansk Oblast, Ukraine | ||
3061203 | 3061203 | 2020-06-13 | Ukraine | Luhansk Oblast | 56 | 0 | 46 | 10 | 48.574 | 39.3078 | 2020-06-14 03:33:15 | Luhansk Oblast, Ukraine | ||
1837151 | 1837151 | 2020-06-14 | Ukraine | Luhansk Oblast | 56 | 0 | 47 | 9 | 48.574 | 39.3078 | 2020-06-15 03:33:14 | Luhansk Oblast, Ukraine | ||
287200 | 287200 | 2020-06-15 | Ukraine | Luhansk Oblast | 57 | 0 | 47 | 10 | 48.574 | 39.3078 | 2020-06-16 04:33:09 | Luhansk Oblast, Ukraine | ||
2386637 | 2386637 | 2020-06-16 | Ukraine | Luhansk Oblast | 60 | 0 | 47 | 13 | 48.574 | 39.3078 | 2020-06-17 04:33:21 | Luhansk Oblast, Ukraine | ||
1195874 | 1195874 | 2020-06-17 | Ukraine | Luhansk Oblast | 66 | 0 | 49 | 17 | 48.574 | 39.3078 | 2020-06-18 04:33:18 | Luhansk Oblast, Ukraine | ||
3682671 | 3682671 | 2020-06-18 | Ukraine | Luhansk Oblast | 68 | 0 | 49 | 19 | 48.574 | 39.3078 | 2020-06-19 04:33:17 | Luhansk Oblast, Ukraine | ||
1691522 | 1691522 | 2020-06-19 | Ukraine | Luhansk Oblast | 71 | 0 | 52 | 19 | 48.574 | 39.3078 | 2020-06-20 04:33:19 | Luhansk Oblast, Ukraine | ||
2437944 | 2437944 | 2020-06-20 | Ukraine | Luhansk Oblast | 72 | 0 | 53 | 19 | 48.574 | 39.3078 | 2020-06-21 04:33:19 | Luhansk Oblast, Ukraine | ||
3249351 | 3249351 | 2020-06-21 | Ukraine | Luhansk Oblast | 72 | 0 | 53 | 19 | 48.574 | 39.3078 | 2020-06-22 04:33:20 | Luhansk Oblast, Ukraine | ||
1510612 | 1510612 | 2020-06-22 | Ukraine | Luhansk Oblast | 72 | 0 | 53 | 19 | 48.574 | 39.3078 | 2020-06-23 04:33:22 | Luhansk Oblast, Ukraine | ||
1522418 | 1522418 | 2020-06-23 | Ukraine | Luhansk Oblast | 73 | 0 | 53 | 20 | 48.574 | 39.3078 | 2020-06-24 04:33:28 | Luhansk Oblast, Ukraine | ||
2700733 | 2700733 | 2020-06-24 | Ukraine | Luhansk Oblast | 75 | 0 | 54 | 21 | 48.574 | 39.3078 | 2020-06-25 05:26:54 | Luhansk Oblast, Ukraine | ||
2625093 | 2625093 | 2020-06-25 | Ukraine | Luhansk Oblast | 75 | 0 | 54 | 21 | 48.574 | 39.3078 | 2020-06-26 04:33:43 | Luhansk Oblast, Ukraine | ||
1136106 | 1136106 | 2020-06-26 | Ukraine | Luhansk Oblast | 76 | 0 | 55 | 21 | 48.574 | 39.3078 | 2020-06-27 04:33:35 | Luhansk Oblast, Ukraine | ||
2039825 | 2039825 | 2020-06-27 | Ukraine | Luhansk Oblast | 76 | 0 | 58 | 18 | 48.574 | 39.3078 | 2020-06-28 04:34:04 | Luhansk Oblast, Ukraine | ||
2306490 | 2306490 | 2020-06-28 | Ukraine | Luhansk Oblast | 80 | 0 | 58 | 22 | 48.574 | 39.3078 | 2020-06-29 04:33:44 | Luhansk Oblast, Ukraine | ||
2632927 | 2632927 | 2020-06-29 | Ukraine | Luhansk Oblast | 80 | 0 | 58 | 22 | 48.574 | 39.3078 | 2020-06-30 04:33:48 | Luhansk Oblast, Ukraine | ||
2974450 | 2974450 | 2020-06-30 | Ukraine | Luhansk Oblast | 80 | 0 | 58 | 22 | 48.574 | 39.3078 | 2020-07-01 04:33:52 | Luhansk Oblast, Ukraine | ||
303072 | 303072 | 2020-07-01 | Ukraine | Luhansk Oblast | 80 | 0 | 59 | 21 | 48.574 | 39.3078 | 2020-07-02 04:33:46 | Luhansk Oblast, Ukraine | ||
3045381 | 3045381 | 2020-07-02 | Ukraine | Luhansk Oblast | 83 | 0 | 59 | 24 | 48.574 | 39.3078 | 2020-07-03 04:33:54 | Luhansk Oblast, Ukraine | ||
2234587 | 2234587 | 2020-07-03 | Ukraine | Luhansk Oblast | 84 | 0 | 60 | 24 | 48.574 | 39.3078 | 2020-07-04 04:33:51 | Luhansk Oblast, Ukraine | ||
529926 | 529926 | 2020-07-04 | Ukraine | Luhansk Oblast | 84 | 0 | 61 | 23 | 48.574 | 39.3078 | 2020-07-05 04:33:46 | Luhansk Oblast, Ukraine | ||
415364 | 415364 | 2020-07-05 | Ukraine | Luhansk Oblast | 84 | 0 | 64 | 20 | 48.574 | 39.3078 | 2020-07-06 04:33:57 | Luhansk Oblast, Ukraine | ||
2684899 | 2684899 | 2020-07-06 | Ukraine | Luhansk Oblast | 84 | 0 | 64 | 20 | 48.574 | 39.3078 | 2020-07-07 04:34:00 | Luhansk Oblast, Ukraine | ||
887339 | 887339 | 2020-07-07 | Ukraine | Luhansk Oblast | 85 | 0 | 64 | 21 | 48.574 | 39.3078 | 2020-07-08 05:33:48 | Luhansk Oblast, Ukraine | ||
2222730 | 2222730 | 2020-07-08 | Ukraine | Luhansk Oblast | 87 | 0 | 69 | 18 | 48.574 | 39.3078 | 2020-07-09 04:34:23 | Luhansk Oblast, Ukraine | ||
1005514 | 1005514 | 2020-07-09 | Ukraine | Luhansk Oblast | 90 | 0 | 70 | 20 | 48.574 | 39.3078 | 2020-07-10 04:34:24 | Luhansk Oblast, Ukraine | ||
3237529 | 3237529 | 2020-07-10 | Ukraine | Luhansk Oblast | 90 | 0 | 73 | 17 | 48.574 | 39.3078 | 2020-07-11 04:34:26 | Luhansk Oblast, Ukraine | ||
3436031 | 3436031 | 2020-07-11 | Ukraine | Luhansk Oblast | 93 | 0 | 73 | 20 | 48.574 | 39.3078 | 2020-07-12 04:34:30 | Luhansk Oblast, Ukraine | ||
3737636 | 3737636 | 2020-07-12 | Ukraine | Luhansk Oblast | 93 | 0 | 73 | 20 | 48.574 | 39.3078 | 2020-07-13 04:43:04 | Luhansk Oblast, Ukraine | ||
3491373 | 3491373 | 2020-07-13 | Ukraine | Luhansk Oblast | 93 | 0 | 73 | 20 | 48.574 | 39.3078 | 2020-07-14 04:34:46 | Luhansk Oblast, Ukraine | ||
2158732 | 2158732 | 2020-07-14 | Ukraine | Luhansk Oblast | 95 | 1 | 73 | 21 | 48.574 | 39.3078 | 2020-07-15 04:34:39 | Luhansk Oblast, Ukraine | ||
2748088 | 2748088 | 2020-07-15 | Ukraine | Luhansk Oblast | 97 | 1 | 74 | 22 | 48.574 | 39.3078 | 2020-07-16 04:44:59 | Luhansk Oblast, Ukraine | ||
367420 | 367420 | 2020-07-16 | Ukraine | Luhansk Oblast | 98 | 1 | 74 | 23 | 48.574 | 39.3078 | 2020-07-17 04:34:50 | Luhansk Oblast, Ukraine | ||
2708607 | 2708607 | 2020-07-17 | Ukraine | Luhansk Oblast | 100 | 1 | 76 | 23 | 48.574 | 39.3078 | 2020-07-18 04:34:45 | Luhansk Oblast, Ukraine | ||
3205306 | 3205306 | 2020-07-18 | Ukraine | Luhansk Oblast | 105 | 1 | 79 | 25 | 48.574 | 39.3078 | 2020-07-19 04:34:58 | Luhansk Oblast, Ukraine | ||
121917 | 121917 | 2020-07-19 | Ukraine | Luhansk Oblast | 106 | 1 | 81 | 24 | 48.574 | 39.3078 | 2020-07-20 05:34:40 | Luhansk Oblast, Ukraine | ||
327012 | 327012 | 2020-07-20 | Ukraine | Luhansk Oblast | 106 | 1 | 81 | 24 | 48.574 | 39.3078 | 2020-07-21 04:38:46 | Luhansk Oblast, Ukraine | ||
1707521 | 1707521 | 2020-07-21 | Ukraine | Luhansk Oblast | 110 | 1 | 83 | 26 | 48.574 | 39.3078 | 2020-07-22 04:34:42 | Luhansk Oblast, Ukraine | ||
844782 | 844782 | 2020-07-22 | Ukraine | Luhansk Oblast | 110 | 1 | 83 | 26 | 48.574 | 39.3078 | 2020-07-23 05:15:04 | Luhansk Oblast, Ukraine | ||
61980 | 61980 | 2020-07-23 | Ukraine | Luhansk Oblast | 116 | 1 | 84 | 31 | 48.574 | 39.3078 | 2020-07-24 05:30:40 | Luhansk Oblast, Ukraine | ||
2563762 | 2563762 | 2020-07-24 | Ukraine | Luhansk Oblast | 118 | 1 | 84 | 33 | 48.574 | 39.3078 | 2020-07-25 04:47:39 | Luhansk Oblast, Ukraine | ||
1502792 | 1502792 | 2020-07-25 | Ukraine | Luhansk Oblast | 119 | 1 | 87 | 31 | 48.574 | 39.3078 | 2020-07-26 04:35:00 | Luhansk Oblast, Ukraine | ||
442548 | 442548 | 2020-07-26 | Ukraine | Luhansk Oblast | 120 | 1 | 88 | 31 | 48.574 | 39.3078 | 2020-07-27 04:35:02 | Luhansk Oblast, Ukraine | ||
177235 | 177235 | 2020-07-27 | Ukraine | Luhansk Oblast | 120 | 1 | 88 | 31 | 48.574 | 39.3078 | 2020-07-28 04:58:43 | Luhansk Oblast, Ukraine | ||
3185184 | 3185184 | 2020-07-28 | Ukraine | Luhansk Oblast | 121 | 1 | 89 | 31 | 48.574 | 39.3078 | 2020-07-29 04:35:11 | Luhansk Oblast, Ukraine | ||
2958568 | 2958568 | 2020-07-29 | Ukraine | Luhansk Oblast | 122 | 1 | 89 | 32 | 48.574 | 39.3078 | 2020-07-30 04:35:05 | Luhansk Oblast, Ukraine | ||
1928400 | 1928400 | 2020-07-30 | Ukraine | Luhansk Oblast | 122 | 1 | 94 | 27 | 48.574 | 39.3078 | 2020-07-31 04:35:18 | Luhansk Oblast, Ukraine | ||
3264693 | 3264693 | 2020-07-31 | Ukraine | Luhansk Oblast | 126 | 1 | 94 | 31 | 48.574 | 39.3078 | 2020-08-01 04:36:27 | Luhansk Oblast, Ukraine | ||
753528 | 753528 | 2020-08-01 | Ukraine | Luhansk Oblast | 127 | 1 | 100 | 26 | 48.574 | 39.3078 | 2020-08-02 04:34:47 | Luhansk Oblast, Ukraine | ||
2807960 | 2807960 | 2020-08-02 | Ukraine | Luhansk Oblast | 128 | 1 | 102 | 25 | 48.574 | 39.3078 | 2020-08-03 04:34:35 | Luhansk Oblast, Ukraine | ||
2740208 | 2740208 | 2020-08-03 | Ukraine | Luhansk Oblast | 128 | 1 | 102 | 25 | 48.574 | 39.3078 | 2020-08-04 04:41:59 | Luhansk Oblast, Ukraine | ||
98325 | 98325 | 2020-08-04 | Ukraine | Luhansk Oblast | 130 | 1 | 104 | 25 | 48.574 | 39.3078 | 2020-08-05 04:34:43 | Luhansk Oblast, Ukraine | ||
3793089 | 3793089 | 2020-08-05 | Ukraine | Luhansk Oblast | 135 | 1 | 105 | 29 | 48.574 | 39.3078 | 2020-08-06 04:35:02 | Luhansk Oblast, Ukraine | ||
3612259 | 3612259 | 2020-08-06 | Ukraine | Luhansk Oblast | 135 | 1 | 113 | 21 | 48.574 | 39.3078 | 2020-08-07 04:35:11 | Luhansk Oblast, Ukraine | ||
458574 | 458574 | 2020-08-07 | Ukraine | Luhansk Oblast | 146 | 1 | 115 | 30 | 48.574 | 39.3078 | 2020-08-08 04:34:53 | Luhansk Oblast, Ukraine | ||
371390 | 371390 | 2020-08-08 | Ukraine | Luhansk Oblast | 152 | 1 | 115 | 36 | 48.574 | 39.3078 | 2020-08-09 04:34:54 | Luhansk Oblast, Ukraine | ||
3923222 | 3923222 | 2020-08-09 | Ukraine | Luhansk Oblast | 153 | 1 | 116 | 36 | 48.574 | 39.3078 | 2020-08-10 04:34:55 | Luhansk Oblast, Ukraine | ||
1920413 | 1920413 | 2020-08-10 | Ukraine | Luhansk Oblast | 155 | 1 | 116 | 38 | 48.574 | 39.3078 | 2020-08-11 04:35:08 | Luhansk Oblast, Ukraine | ||
662647 | 662647 | 2020-08-11 | Ukraine | Luhansk Oblast | 157 | 1 | 116 | 40 | 48.574 | 39.3078 | 2020-08-12 04:27:29 | Luhansk Oblast, Ukraine | ||
3535057 | 3535057 | 2020-08-12 | Ukraine | Luhansk Oblast | 160 | 1 | 117 | 42 | 48.574 | 39.3078 | 2020-08-13 04:29:15 | Luhansk Oblast, Ukraine | ||
586440 | 586440 | 2020-08-13 | Ukraine | Luhansk Oblast | 170 | 1 | 120 | 49 | 48.574 | 39.3078 | 2020-08-14 04:51:19 | Luhansk Oblast, Ukraine | ||
1615856 | 1615856 | 2020-08-14 | Ukraine | Luhansk Oblast | 171 | 1 | 120 | 50 | 48.574 | 39.3078 | 2020-08-15 04:27:31 | Luhansk Oblast, Ukraine | ||
149581 | 149581 | 2020-08-15 | Ukraine | Luhansk Oblast | 178 | 1 | 124 | 53 | 48.574 | 39.3078 | 2020-08-16 04:27:42 | Luhansk Oblast, Ukraine | ||
1559579 | 1559579 | 2020-08-16 | Ukraine | Luhansk Oblast | 178 | 1 | 124 | 53 | 48.574 | 39.3078 | 2020-08-17 04:27:20 | Luhansk Oblast, Ukraine | ||
841223 | 841223 | 2020-08-17 | Ukraine | Luhansk Oblast | 184 | 1 | 124 | 59 | 48.574 | 39.3078 | 2020-08-18 04:27:56 | Luhansk Oblast, Ukraine | ||
3181619 | 3181619 | 2020-08-18 | Ukraine | Luhansk Oblast | 185 | 1 | 124 | 60 | 48.574 | 39.3078 | 2020-08-19 04:27:00 | Luhansk Oblast, Ukraine | ||
209867 | 209867 | 2020-08-19 | Ukraine | Luhansk Oblast | 194 | 1 | 133 | 60 | 48.574 | 39.3078 | 2020-08-20 04:27:43 | Luhansk Oblast, Ukraine | ||
3487918 | 3487918 | 2020-08-20 | Ukraine | Luhansk Oblast | 204 | 1 | 133 | 70 | 48.574 | 39.3078 | 2020-08-21 04:27:41 | Luhansk Oblast, Ukraine | ||
1483169 | 1483169 | 2020-08-21 | Ukraine | Luhansk Oblast | 213 | 1 | 140 | 72 | 48.574 | 39.3078 | 2020-08-22 04:27:49 | Luhansk Oblast, Ukraine | ||
2303063 | 2303063 | 2020-08-22 | Ukraine | Luhansk Oblast | 232 | 1 | 149 | 82 | 48.574 | 39.3078 | 2020-08-23 04:27:48 | Luhansk Oblast, Ukraine | ||
2219281 | 2219281 | 2020-08-23 | Ukraine | Luhansk Oblast | 243 | 1 | 153 | 89 | 48.574 | 39.3078 | 2020-08-24 04:27:56 | Luhansk Oblast, Ukraine | ||
2994886 | 2994886 | 2020-08-24 | Ukraine | Luhansk Oblast | 244 | 1 | 153 | 90 | 48.574 | 39.3078 | 2020-08-25 04:28:02 | Luhansk Oblast, Ukraine | ||
3566182 | 3566182 | 2020-08-25 | Ukraine | Luhansk Oblast | 244 | 1 | 153 | 90 | 48.574 | 39.3078 | 2020-08-26 04:28:11 | Luhansk Oblast, Ukraine | ||
2000258 | 2000258 | 2020-08-26 | Ukraine | Luhansk Oblast | 247 | 2 | 153 | 92 | 48.574 | 39.3078 | 2020-08-27 04:28:15 | Luhansk Oblast, Ukraine | ||
2513798 | 2513798 | 2020-08-27 | Ukraine | Luhansk Oblast | 264 | 2 | 167 | 95 | 48.574 | 39.3078 | 2020-08-28 04:28:11 | Luhansk Oblast, Ukraine | ||
1526797 | 1526797 | 2020-08-28 | Ukraine | Luhansk Oblast | 274 | 2 | 178 | 94 | 48.574 | 39.3078 | 2020-08-29 04:28:19 | Luhansk Oblast, Ukraine | ||
613302 | 613302 | 2020-08-29 | Ukraine | Luhansk Oblast | 295 | 2 | 185 | 108 | 48.574 | 39.3078 | 2020-08-30 04:28:22 | Luhansk Oblast, Ukraine | ||
3935640 | 3935640 | 2020-08-30 | Ukraine | Luhansk Oblast | 312 | 2 | 186 | 124 | 48.574 | 39.3078 | 2020-08-31 04:28:27 | Luhansk Oblast, Ukraine | ||
197685 | 197685 | 2020-08-31 | Ukraine | Luhansk Oblast | 315 | 2 | 187 | 126 | 48.574 | 39.3078 | 2020-09-01 04:28:31 | Luhansk Oblast, Ukraine | ||
2063500 | 2063500 | 2020-09-01 | Ukraine | Luhansk Oblast | 320 | 3 | 190 | 127 | 48.574 | 39.3078 | 2020-09-02 04:28:25 | Luhansk Oblast, Ukraine | ||
1109171 | 1109171 | 2020-09-02 | Ukraine | Luhansk Oblast | 346 | 3 | 193 | 150 | 48.574 | 39.3078 | 2020-09-03 04:28:22 | Luhansk Oblast, Ukraine | ||
1357934 | 1357934 | 2020-09-03 | Ukraine | Luhansk Oblast | 373 | 3 | 202 | 168 | 48.574 | 39.3078 | 2020-09-04 04:28:26 | Luhansk Oblast, Ukraine | ||
2665394 | 2665394 | 2020-09-04 | Ukraine | Luhansk Oblast | 393 | 3 | 215 | 175 | 48.574 | 39.3078 | 2020-09-05 04:28:19 | Luhansk Oblast, Ukraine | ||
817194 | 817194 | 2020-09-05 | Ukraine | Luhansk Oblast | 415 | 3 | 224 | 188 | 48.574 | 39.3078 | 2020-09-06 04:28:33 | Luhansk Oblast, Ukraine | ||
3165239 | 3165239 | 2020-09-06 | Ukraine | Luhansk Oblast | 431 | 3 | 225 | 203 | 48.574 | 39.3078 | 2020-09-07 04:28:30 | Luhansk Oblast, Ukraine | ||
430954 | 430954 | 2020-09-07 | Ukraine | Luhansk Oblast | 434 | 3 | 225 | 206 | 48.574 | 39.3078 | 2020-09-08 04:28:25 | Luhansk Oblast, Ukraine | ||
1247375 | 1247375 | 2020-09-08 | Ukraine | Luhansk Oblast | 448 | 4 | 227 | 217 | 48.574 | 39.3078 | 2020-09-09 04:28:48 | Luhansk 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]);