johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,016 rows where country_or_region = "Canada" and province_or_state = "Nova Scotia" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-12-02 5
- 2022-04-13 2
- 2022-05-26 2
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
day (date) >30 ✖
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- …
province_or_state 1
- Nova Scotia · 1,016 ✖
country_or_region 1
- Canada · 1,016 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85 | 85 | 2021-12-02 | Canada | Nova Scotia | 8362 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-03 04:23:05 | Nova Scotia, Canada | |||
4101 | 4101 | 2021-10-28 | Canada | Nova Scotia | 7328 | 100 | 0 | 44.681999999999995 | -63.7443 | 2021-10-29 04:22:03 | Nova Scotia, Canada | |||
16126 | 16126 | 2021-09-18 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-19 04:21:34 | Nova Scotia, Canada | |||
24156 | 24156 | 2022-03-20 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-21 04:20:50 | Nova Scotia, Canada | |||
28171 | 28171 | 2021-11-11 | Canada | Nova Scotia | 7746 | 102 | 0 | 44.681999999999995 | -63.7443 | 2021-11-12 04:22:01 | Nova Scotia, Canada | |||
32187 | 32187 | 2021-08-25 | Canada | Nova Scotia | 5989 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-26 04:21:28 | Nova Scotia, Canada | |||
43128 | 43128 | 2020-04-13 | Canada | Nova Scotia | 474 | 3 | 0 | 471 | 44.681999999999995 | -63.7443 | 2020-04-13 23:15:25 | Nova Scotia, Canada | ||
43463 | 43463 | 2021-11-02 | Canada | Nova Scotia | 7424 | 101 | 0 | 44.681999999999995 | -63.7443 | 2021-11-03 06:22:09 | Nova Scotia, Canada | |||
50227 | 50227 | 2020-04-17 | Canada | Nova Scotia | 606 | 4 | 0 | 602 | 44.681999999999995 | -63.7443 | 2020-04-17 23:38:31 | Nova Scotia, Canada | ||
62044 | 62044 | 2020-07-23 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-24 05:30:40 | Nova Scotia, Canada | ||
66832 | 66832 | 2021-09-01 | Canada | Nova Scotia | 6038 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-02 04:21:15 | Nova Scotia, Canada | |||
70846 | 70846 | 2022-02-07 | Canada | Nova Scotia | 40454 | 158 | 0 | 44.681999999999995 | -63.7443 | 2022-02-08 04:21:15 | Nova Scotia, Canada | |||
86880 | 86880 | 2021-11-09 | Canada | Nova Scotia | 7717 | 102 | 0 | 44.681999999999995 | -63.7443 | 2021-11-10 04:21:38 | Nova Scotia, Canada | |||
98393 | 98393 | 2020-08-04 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-05 04:34:43 | Nova Scotia, Canada | ||
99081 | 99081 | 2022-01-14 | Canada | Nova Scotia | 28736 | 117 | 0 | 44.681999999999995 | -63.7443 | 2022-01-15 04:21:07 | Nova Scotia, Canada | |||
103097 | 103097 | 2021-08-15 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-16 04:21:31 | Nova Scotia, Canada | |||
114167 | 114167 | 2020-05-08 | Canada | Nova Scotia | 1008 | 46 | 0 | 962 | 44.681999999999995 | -63.7443 | 2020-05-09 02:32:35 | Nova Scotia, Canada | ||
121985 | 121985 | 2020-07-19 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-20 05:34:40 | Nova Scotia, Canada | ||
126488 | 126488 | 2022-01-09 | Canada | Nova Scotia | 23265 | 111 | 0 | 44.681999999999995 | -63.7443 | 2022-01-10 04:22:07 | Nova Scotia, Canada | |||
137391 | 137391 | 2020-04-29 | Canada | Nova Scotia | 935 | 28 | 0 | 907 | 44.681999999999995 | -63.7443 | 2020-04-30 02:32:27 | Nova Scotia, Canada | ||
137726 | 137726 | 2021-12-04 | Canada | Nova Scotia | 8381 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-05 04:22:25 | Nova Scotia, Canada | |||
149739 | 149739 | 2021-11-29 | Canada | Nova Scotia | 8227 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-11-30 04:22:53 | Nova Scotia, Canada | |||
157768 | 157768 | 2022-03-29 | Canada | Nova Scotia | 54812 | 245 | 0 | 44.681999999999995 | -63.7443 | 2022-03-30 04:20:45 | Nova Scotia, Canada | |||
161783 | 161783 | 2021-11-19 | Canada | Nova Scotia | 8012 | 106 | 0 | 44.681999999999995 | -63.7443 | 2021-11-20 04:22:17 | Nova Scotia, Canada | |||
177303 | 177303 | 2020-07-27 | Canada | Nova Scotia | 1067 | 63 | 1004 | 0 | 44.681999999999995 | -63.7443 | 2020-07-28 04:58:43 | Nova Scotia, Canada | ||
177797 | 177797 | 2021-09-02 | Canada | Nova Scotia | 6042 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-03 04:21:20 | Nova Scotia, Canada | |||
185826 | 185826 | 2022-02-13 | Canada | Nova Scotia | 41716 | 167 | 0 | 44.681999999999995 | -63.7443 | 2022-02-14 04:20:51 | Nova Scotia, Canada | |||
217259 | 217259 | 2020-06-08 | Canada | Nova Scotia | 1059 | 61 | 999 | 0 | 44.681999999999995 | -63.7443 | 2020-06-09 03:33:03 | Nova Scotia, Canada | ||
228644 | 228644 | 2020-04-30 | Canada | Nova Scotia | 947 | 28 | 0 | 919 | 44.681999999999995 | -63.7443 | 2020-05-01 02:32:28 | Nova Scotia, Canada | ||
232998 | 232998 | 2022-02-11 | Canada | Nova Scotia | 41716 | 167 | 0 | 44.681999999999995 | -63.7443 | 2022-02-12 04:21:06 | Nova Scotia, Canada | |||
245040 | 245040 | 2021-08-17 | Canada | Nova Scotia | 5929 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-18 04:21:35 | Nova Scotia, Canada | |||
249054 | 249054 | 2021-09-04 | Canada | Nova Scotia | 6054 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-05 04:21:33 | Nova Scotia, Canada | |||
261288 | 261288 | 2022-03-15 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-16 04:20:50 | Nova Scotia, Canada | |||
268353 | 268353 | 2020-05-21 | Canada | Nova Scotia | 1046 | 58 | 959 | 29 | 44.681999999999995 | -63.7443 | 2020-05-22 02:36:51 | Nova Scotia, Canada | ||
271605 | 271605 | 2020-04-28 | Canada | Nova Scotia | 915 | 27 | 0 | 888 | 44.681999999999995 | -63.7443 | 2020-04-29 02:32:29 | Nova Scotia, Canada | ||
275938 | 275938 | 2021-11-03 | Canada | Nova Scotia | 7462 | 101 | 0 | 44.681999999999995 | -63.7443 | 2021-11-04 04:22:20 | Nova Scotia, Canada | |||
287266 | 287266 | 2020-06-15 | Canada | Nova Scotia | 1061 | 62 | 996 | 3 | 44.681999999999995 | -63.7443 | 2020-06-16 04:33:09 | Nova Scotia, Canada | ||
287751 | 287751 | 2021-10-31 | Canada | Nova Scotia | 7354 | 100 | 0 | 44.681999999999995 | -63.7443 | 2021-11-01 04:22:01 | Nova Scotia, Canada | |||
303138 | 303138 | 2020-07-01 | Canada | Nova Scotia | 1062 | 63 | 998 | 2 | 44.681999999999995 | -63.7443 | 2020-07-02 04:33:46 | Nova Scotia, Canada | ||
303624 | 303624 | 2022-04-16 | Canada | Nova Scotia | 72903 | 277 | 0 | 44.681999999999995 | -63.7443 | 2022-04-17 04:20:59 | Nova Scotia, Canada | |||
315672 | 315672 | 2022-02-12 | Canada | Nova Scotia | 41716 | 167 | 0 | 44.681999999999995 | -63.7443 | 2022-02-13 04:21:00 | Nova Scotia, Canada | |||
327080 | 327080 | 2020-07-20 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-21 04:38:46 | Nova Scotia, Canada | ||
335692 | 335692 | 2022-03-18 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-19 04:20:47 | Nova Scotia, Canada | |||
356082 | 356082 | 2022-03-11 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-12 04:20:50 | Nova Scotia, Canada | |||
367486 | 367486 | 2020-07-16 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-17 04:34:50 | Nova Scotia, Canada | ||
371458 | 371458 | 2020-08-08 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-09 04:34:54 | Nova Scotia, Canada | ||
404049 | 404049 | 2021-12-07 | Canada | Nova Scotia | 8448 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-08 04:22:46 | Nova Scotia, Canada | |||
415430 | 415430 | 2020-07-05 | Canada | Nova Scotia | 1064 | 63 | 998 | 3 | 44.681999999999995 | -63.7443 | 2020-07-06 04:33:57 | Nova Scotia, Canada | ||
423106 | 423106 | 2021-10-10 | Canada | Nova Scotia | 6961 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-11 04:21:31 | Nova Scotia, Canada | |||
442616 | 442616 | 2020-07-26 | Canada | Nova Scotia | 1067 | 63 | 1004 | 0 | 44.681999999999995 | -63.7443 | 2020-07-27 04:35:02 | Nova Scotia, Canada | ||
443110 | 443110 | 2021-10-20 | Canada | Nova Scotia | 7166 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-21 04:21:18 | Nova Scotia, Canada | |||
447126 | 447126 | 2021-11-17 | Canada | Nova Scotia | 7963 | 105 | 0 | 44.681999999999995 | -63.7443 | 2021-11-18 04:21:33 | Nova Scotia, Canada | |||
458642 | 458642 | 2020-08-07 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-08 04:34:53 | Nova Scotia, Canada | ||
459135 | 459135 | 2022-02-02 | Canada | Nova Scotia | 38333 | 147 | 0 | 44.681999999999995 | -63.7443 | 2022-02-03 04:21:21 | Nova Scotia, Canada | |||
467167 | 467167 | 2021-10-07 | Canada | Nova Scotia | 6893 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-08 04:21:25 | Nova Scotia, Canada | |||
491391 | 491391 | 2021-10-14 | Canada | Nova Scotia | 7059 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-15 04:21:26 | Nova Scotia, Canada | |||
495407 | 495407 | 2021-11-06 | Canada | Nova Scotia | 7550 | 101 | 0 | 44.681999999999995 | -63.7443 | 2021-11-07 04:21:53 | Nova Scotia, Canada | |||
499424 | 499424 | 2022-04-02 | Canada | Nova Scotia | 59000 | 255 | 0 | 44.681999999999995 | -63.7443 | 2022-04-03 04:20:48 | Nova Scotia, Canada | |||
507455 | 507455 | 2021-08-14 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-15 04:21:41 | Nova Scotia, Canada | |||
511469 | 511469 | 2021-08-19 | Canada | Nova Scotia | 5946 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-20 04:21:33 | Nova Scotia, Canada | |||
522293 | 522293 | 2020-04-21 | Canada | Nova Scotia | 737 | 10 | 0 | 727 | 44.681999999999995 | -63.7443 | 2020-04-21 23:38:53 | Nova Scotia, Canada | ||
529992 | 529992 | 2020-07-04 | Canada | Nova Scotia | 1064 | 63 | 998 | 3 | 44.681999999999995 | -63.7443 | 2020-07-05 04:33:46 | Nova Scotia, Canada | ||
534491 | 534491 | 2021-10-27 | Canada | Nova Scotia | 7298 | 100 | 0 | 44.681999999999995 | -63.7443 | 2021-10-28 04:22:08 | Nova Scotia, Canada | |||
550529 | 550529 | 2021-12-08 | Canada | Nova Scotia | 8481 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-09 04:22:49 | Nova Scotia, Canada | |||
554545 | 554545 | 2022-01-16 | Canada | Nova Scotia | 28736 | 117 | 0 | 44.681999999999995 | -63.7443 | 2022-01-17 04:21:08 | Nova Scotia, Canada | |||
566859 | 566859 | 2021-10-29 | Canada | Nova Scotia | 7354 | 100 | 0 | 44.681999999999995 | -63.7443 | 2021-10-30 04:22:03 | Nova Scotia, Canada | |||
574111 | 574111 | 2020-06-06 | Canada | Nova Scotia | 1058 | 61 | 999 | 0 | 44.681999999999995 | -63.7443 | 2020-06-07 03:53:30 | Nova Scotia, Canada | ||
574588 | 574588 | 2022-02-25 | Canada | Nova Scotia | 44738 | 191 | 0 | 44.681999999999995 | -63.7443 | 2022-02-26 04:21:12 | Nova Scotia, Canada | |||
589065 | 589065 | 2020-04-05 | Canada | Nova Scotia | 262 | 0 | 0 | 262 | 44.681999999999995 | -63.7443 | 2020-04-05 23:13:28 | Nova Scotia, Canada | ||
597429 | 597429 | 2021-10-19 | Canada | Nova Scotia | 7161 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-20 04:21:00 | Nova Scotia, Canada | |||
601445 | 601445 | 2021-09-23 | Canada | Nova Scotia | 6452 | 95 | 0 | 44.681999999999995 | -63.7443 | 2021-09-24 04:21:44 | Nova Scotia, Canada | |||
633679 | 633679 | 2021-10-13 | Canada | Nova Scotia | 7033 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-14 04:21:29 | Nova Scotia, Canada | |||
641709 | 641709 | 2021-09-07 | Canada | Nova Scotia | 6076 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-08 04:21:31 | Nova Scotia, Canada | |||
649737 | 649737 | 2021-08-09 | Canada | Nova Scotia | 5907 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-10 04:21:27 | Nova Scotia, Canada | |||
653751 | 653751 | 2021-10-22 | Canada | Nova Scotia | 7208 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-23 04:21:32 | Nova Scotia, Canada | |||
682096 | 682096 | 2021-10-24 | Canada | Nova Scotia | 7208 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-25 04:22:31 | Nova Scotia, Canada | |||
686112 | 686112 | 2021-11-13 | Canada | Nova Scotia | 7815 | 102 | 0 | 44.681999999999995 | -63.7443 | 2021-11-14 04:21:31 | Nova Scotia, Canada | |||
694145 | 694145 | 2022-03-17 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-18 04:20:55 | Nova Scotia, Canada | |||
698160 | 698160 | 2021-11-04 | Canada | Nova Scotia | 7512 | 101 | 0 | 44.681999999999995 | -63.7443 | 2021-11-05 04:21:54 | Nova Scotia, Canada | |||
706190 | 706190 | 2021-09-29 | Canada | Nova Scotia | 6638 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-09-30 04:21:20 | Nova Scotia, Canada | |||
714221 | 714221 | 2021-11-12 | Canada | Nova Scotia | 7815 | 102 | 0 | 44.681999999999995 | -63.7443 | 2021-11-13 04:21:38 | Nova Scotia, Canada | |||
722253 | 722253 | 2021-11-20 | Canada | Nova Scotia | 8012 | 106 | 0 | 44.681999999999995 | -63.7443 | 2021-11-21 04:22:13 | Nova Scotia, Canada | |||
730283 | 730283 | 2021-12-27 | Canada | Nova Scotia | 15469 | 111 | 0 | 44.681999999999995 | -63.7443 | 2021-12-28 04:21:47 | Nova Scotia, Canada | |||
737589 | 737589 | 2020-06-12 | Canada | Nova Scotia | 1061 | 62 | 995 | 4 | 44.681999999999995 | -63.7443 | 2020-06-13 03:33:14 | Nova Scotia, Canada | ||
746100 | 746100 | 2022-04-23 | Canada | Nova Scotia | 80411 | 290 | 0 | 44.681999999999995 | -63.7443 | 2022-04-24 04:20:56 | Nova Scotia, Canada | |||
753596 | 753596 | 2020-08-01 | Canada | Nova Scotia | 1069 | 64 | 1003 | 2 | 44.681999999999995 | -63.7443 | 2020-08-02 04:34:47 | Nova Scotia, Canada | ||
758083 | 758083 | 2021-11-26 | Canada | Nova Scotia | 8169 | 108 | 0 | 44.681999999999995 | -63.7443 | 2021-11-27 04:22:45 | Nova Scotia, Canada | |||
770104 | 770104 | 2021-10-23 | Canada | Nova Scotia | 7208 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-24 04:21:22 | Nova Scotia, Canada | |||
782146 | 782146 | 2021-12-13 | Canada | Nova Scotia | 9009 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-12-14 04:22:38 | Nova Scotia, Canada | |||
798185 | 798185 | 2021-12-22 | Canada | Nova Scotia | 12441 | 111 | 0 | 44.681999999999995 | -63.7443 | 2021-12-23 04:21:21 | Nova Scotia, Canada | |||
805413 | 805413 | 2020-06-01 | Canada | Nova Scotia | 1057 | 60 | 984 | 13 | 44.681999999999995 | -63.7443 | 2020-06-02 02:33:08 | Nova Scotia, Canada | ||
809022 | 809022 | 2020-03-27 | Canada | Nova Scotia | 90 | 0 | 0 | 90 | 44.681999999999995 | -63.7443 | 2020-03-27 23:27:32 | Nova Scotia, Canada | ||
809347 | 809347 | 2021-09-20 | Canada | Nova Scotia | 6367 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-21 04:21:26 | Nova Scotia, Canada | |||
844850 | 844850 | 2020-07-22 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-23 05:15:04 | Nova Scotia, Canada | ||
860115 | 860115 | 2020-04-15 | Canada | Nova Scotia | 549 | 3 | 0 | 546 | 44.681999999999995 | -63.7443 | 2020-04-15 23:04:09 | Nova Scotia, Canada | ||
875633 | 875633 | 2020-05-24 | Canada | Nova Scotia | 1050 | 58 | 973 | 19 | 44.681999999999995 | -63.7443 | 2020-05-25 02:32:44 | Nova Scotia, Canada | ||
876020 | 876020 | 2022-03-27 | Canada | Nova Scotia | 54812 | 245 | 0 | 44.681999999999995 | -63.7443 | 2022-03-28 04:20:33 | Nova Scotia, Canada | |||
887405 | 887405 | 2020-07-07 | Canada | Nova Scotia | 1065 | 63 | 998 | 4 | 44.681999999999995 | -63.7443 | 2020-07-08 05:33:48 | Nova Scotia, Canada | ||
903934 | 903934 | 2021-11-24 | Canada | Nova Scotia | 8119 | 107 | 0 | 44.681999999999995 | -63.7443 | 2021-11-25 04:22:33 | Nova Scotia, Canada | |||
919115 | 919115 | 2020-03-26 | Canada | Nova Scotia | 73 | 0 | 0 | 73 | 44.681999999999995 | -63.7443 | 2020-03-26 23:53:11 | Nova Scotia, Canada |
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]);