johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,020 rows where country_or_region = "Canada" and province_or_state = "Newfoundland and Labrador" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386690 | 2386690 | 2020-06-16 | Canada | Newfoundland and Labrador | 261 | 3 | 257 | 1 | 53.1355 | -57.6604 | 2020-06-17 04:33:21 | Newfoundland and Labrador, Canada | ||
2437997 | 2437997 | 2020-06-20 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-21 04:33:19 | Newfoundland and Labrador, Canada | ||
2555865 | 2555865 | 2020-06-02 | Canada | Newfoundland and Labrador | 261 | 3 | 256 | 2 | 53.1355 | -57.6604 | 2020-06-03 02:33:13 | Newfoundland and Labrador, Canada | ||
2625146 | 2625146 | 2020-06-25 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-26 04:33:43 | Newfoundland and Labrador, Canada | ||
2632980 | 2632980 | 2020-06-29 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-30 04:33:48 | Newfoundland and Labrador, Canada | ||
2684952 | 2684952 | 2020-07-06 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-07-07 04:34:00 | Newfoundland and Labrador, Canada | ||
2700786 | 2700786 | 2020-06-24 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-25 05:26:54 | Newfoundland and Labrador, Canada | ||
2712298 | 2712298 | 2020-05-28 | Canada | Newfoundland and Labrador | 261 | 3 | 255 | 3 | 53.1355 | -57.6604 | 2020-05-29 02:32:50 | Newfoundland and Labrador, Canada | ||
2800043 | 2800043 | 2020-06-07 | Canada | Newfoundland and Labrador | 261 | 3 | 256 | 2 | 53.1355 | -57.6604 | 2020-06-08 03:33:22 | Newfoundland and Labrador, Canada | ||
2863989 | 2863989 | 2020-06-10 | Canada | Newfoundland and Labrador | 261 | 3 | 256 | 2 | 53.1355 | -57.6604 | 2020-06-11 03:33:41 | Newfoundland and Labrador, Canada | ||
2974503 | 2974503 | 2020-06-30 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-07-01 04:33:52 | Newfoundland and Labrador, Canada | ||
3045434 | 3045434 | 2020-07-02 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-07-03 04:33:54 | Newfoundland and Labrador, Canada | ||
3061256 | 3061256 | 2020-06-13 | Canada | Newfoundland and Labrador | 261 | 3 | 256 | 2 | 53.1355 | -57.6604 | 2020-06-14 03:33:15 | Newfoundland and Labrador, Canada | ||
3249404 | 3249404 | 2020-06-21 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-22 04:33:20 | Newfoundland and Labrador, Canada | ||
3638878 | 3638878 | 2020-05-30 | Canada | Newfoundland and Labrador | 261 | 3 | 255 | 3 | 53.1355 | -57.6604 | 2020-05-31 02:32:45 | Newfoundland and Labrador, Canada | ||
3682724 | 3682724 | 2020-06-18 | Canada | Newfoundland and Labrador | 261 | 3 | 258 | 0 | 53.1355 | -57.6604 | 2020-06-19 04:33:17 | Newfoundland and Labrador, Canada | ||
3866823 | 3866823 | 2020-06-03 | Canada | Newfoundland and Labrador | 261 | 3 | 256 | 2 | 53.1355 | -57.6604 | 2020-06-04 02:33:14 | Newfoundland and Labrador, Canada | ||
121970 | 121970 | 2020-07-19 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-20 05:34:40 | Newfoundland and Labrador, Canada | ||
327065 | 327065 | 2020-07-20 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-21 04:38:46 | Newfoundland and Labrador, Canada | ||
367473 | 367473 | 2020-07-16 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-17 04:34:50 | Newfoundland and Labrador, Canada | ||
2158785 | 2158785 | 2020-07-14 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-15 04:34:39 | Newfoundland and Labrador, Canada | ||
2708660 | 2708660 | 2020-07-17 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-18 04:34:45 | Newfoundland and Labrador, Canada | ||
2748141 | 2748141 | 2020-07-15 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-16 04:44:59 | Newfoundland and Labrador, Canada | ||
3205359 | 3205359 | 2020-07-18 | Canada | Newfoundland and Labrador | 262 | 3 | 259 | 0 | 53.1355 | -57.6604 | 2020-07-19 04:34:58 | Newfoundland and Labrador, Canada | ||
3237582 | 3237582 | 2020-07-10 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-11 04:34:26 | Newfoundland and Labrador, Canada | ||
3436084 | 3436084 | 2020-07-11 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-12 04:34:30 | Newfoundland and Labrador, Canada | ||
3491426 | 3491426 | 2020-07-13 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-14 04:34:46 | Newfoundland and Labrador, Canada | ||
3737689 | 3737689 | 2020-07-12 | Canada | Newfoundland and Labrador | 262 | 3 | 258 | 1 | 53.1355 | -57.6604 | 2020-07-13 04:43:04 | Newfoundland and Labrador, Canada | ||
1707574 | 1707574 | 2020-07-21 | Canada | Newfoundland and Labrador | 263 | 3 | 259 | 1 | 53.1355 | -57.6604 | 2020-07-22 04:34:42 | Newfoundland and Labrador, Canada | ||
62029 | 62029 | 2020-07-23 | Canada | Newfoundland and Labrador | 264 | 3 | 259 | 2 | 53.1355 | -57.6604 | 2020-07-24 05:30:40 | Newfoundland and Labrador, Canada | ||
844835 | 844835 | 2020-07-22 | Canada | Newfoundland and Labrador | 264 | 3 | 259 | 2 | 53.1355 | -57.6604 | 2020-07-23 05:15:04 | Newfoundland and Labrador, Canada | ||
1502845 | 1502845 | 2020-07-25 | Canada | Newfoundland and Labrador | 265 | 3 | 259 | 3 | 53.1355 | -57.6604 | 2020-07-26 04:35:00 | Newfoundland and Labrador, Canada | ||
2563815 | 2563815 | 2020-07-24 | Canada | Newfoundland and Labrador | 265 | 3 | 259 | 3 | 53.1355 | -57.6604 | 2020-07-25 04:47:39 | Newfoundland and Labrador, Canada | ||
98378 | 98378 | 2020-08-04 | Canada | Newfoundland and Labrador | 266 | 3 | 260 | 3 | 53.1355 | -57.6604 | 2020-08-05 04:34:43 | Newfoundland and Labrador, Canada | ||
177288 | 177288 | 2020-07-27 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-28 04:58:43 | Newfoundland and Labrador, Canada | ||
442601 | 442601 | 2020-07-26 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-27 04:35:02 | Newfoundland and Labrador, Canada | ||
753581 | 753581 | 2020-08-01 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-02 04:34:47 | Newfoundland and Labrador, Canada | ||
1928453 | 1928453 | 2020-07-30 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-31 04:35:18 | Newfoundland and Labrador, Canada | ||
2740261 | 2740261 | 2020-08-03 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-04 04:41:59 | Newfoundland and Labrador, Canada | ||
2808013 | 2808013 | 2020-08-02 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-03 04:34:35 | Newfoundland and Labrador, Canada | ||
2958621 | 2958621 | 2020-07-29 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-30 04:35:05 | Newfoundland and Labrador, Canada | ||
3185237 | 3185237 | 2020-07-28 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-07-29 04:35:11 | Newfoundland and Labrador, Canada | ||
3264746 | 3264746 | 2020-07-31 | Canada | Newfoundland and Labrador | 266 | 3 | 259 | 4 | 53.1355 | -57.6604 | 2020-08-01 04:36:27 | Newfoundland and Labrador, Canada | ||
3612312 | 3612312 | 2020-08-06 | Canada | Newfoundland and Labrador | 266 | 3 | 263 | 0 | 53.1355 | -57.6604 | 2020-08-07 04:35:11 | Newfoundland and Labrador, Canada | ||
3793142 | 3793142 | 2020-08-05 | Canada | Newfoundland and Labrador | 266 | 3 | 263 | 0 | 53.1355 | -57.6604 | 2020-08-06 04:35:02 | Newfoundland and Labrador, Canada | ||
371443 | 371443 | 2020-08-08 | Canada | Newfoundland and Labrador | 267 | 3 | 263 | 1 | 53.1355 | -57.6604 | 2020-08-09 04:34:54 | Newfoundland and Labrador, Canada | ||
458627 | 458627 | 2020-08-07 | Canada | Newfoundland and Labrador | 267 | 3 | 263 | 1 | 53.1355 | -57.6604 | 2020-08-08 04:34:53 | Newfoundland and Labrador, Canada | ||
3923275 | 3923275 | 2020-08-09 | Canada | Newfoundland and Labrador | 267 | 3 | 263 | 1 | 53.1355 | -57.6604 | 2020-08-10 04:34:55 | Newfoundland and Labrador, Canada | ||
145745 | 145745 | 2020-08-15 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-16 04:27:42 | Newfoundland and Labrador, Canada | ||
206027 | 206027 | 2020-08-19 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-20 04:27:43 | Newfoundland and Labrador, Canada | ||
582604 | 582604 | 2020-08-13 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-14 04:51:19 | Newfoundland and Labrador, Canada | ||
662072 | 662072 | 2020-08-11 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-12 04:27:29 | Newfoundland and Labrador, Canada | ||
837385 | 837385 | 2020-08-17 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-18 04:27:56 | Newfoundland and Labrador, Canada | ||
1479329 | 1479329 | 2020-08-21 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-22 04:27:49 | Newfoundland and Labrador, Canada | ||
1555743 | 1555743 | 2020-08-16 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-17 04:27:20 | Newfoundland and Labrador, Canada | ||
1612020 | 1612020 | 2020-08-14 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-15 04:27:31 | Newfoundland and Labrador, Canada | ||
1920466 | 1920466 | 2020-08-10 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-11 04:35:08 | Newfoundland and Labrador, Canada | ||
1996417 | 1996417 | 2020-08-26 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-27 04:28:15 | Newfoundland and Labrador, Canada | ||
2215440 | 2215440 | 2020-08-23 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-24 04:27:56 | Newfoundland and Labrador, Canada | ||
2299222 | 2299222 | 2020-08-22 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-23 04:27:48 | Newfoundland and Labrador, Canada | ||
2509957 | 2509957 | 2020-08-27 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-28 04:28:11 | Newfoundland and Labrador, Canada | ||
2991045 | 2991045 | 2020-08-24 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-25 04:28:02 | Newfoundland and Labrador, Canada | ||
3177781 | 3177781 | 2020-08-18 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-19 04:27:00 | Newfoundland and Labrador, Canada | ||
3484078 | 3484078 | 2020-08-20 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-21 04:27:41 | Newfoundland and Labrador, Canada | ||
3531223 | 3531223 | 2020-08-12 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-13 04:29:15 | Newfoundland and Labrador, Canada | ||
3562341 | 3562341 | 2020-08-25 | Canada | Newfoundland and Labrador | 268 | 3 | 265 | 0 | 53.1355 | -57.6604 | 2020-08-26 04:28:11 | Newfoundland and Labrador, Canada | ||
193840 | 193840 | 2020-08-31 | Canada | Newfoundland and Labrador | 269 | 3 | 265 | 1 | 53.1355 | -57.6604 | 2020-09-01 04:28:31 | Newfoundland and Labrador, Canada | ||
609461 | 609461 | 2020-08-29 | Canada | Newfoundland and Labrador | 269 | 3 | 265 | 1 | 53.1355 | -57.6604 | 2020-08-30 04:28:22 | Newfoundland and Labrador, Canada | ||
1105326 | 1105326 | 2020-09-02 | Canada | Newfoundland and Labrador | 269 | 3 | 266 | 0 | 53.1355 | -57.6604 | 2020-09-03 04:28:22 | Newfoundland and Labrador, Canada | ||
1354089 | 1354089 | 2020-09-03 | Canada | Newfoundland and Labrador | 269 | 3 | 266 | 0 | 53.1355 | -57.6604 | 2020-09-04 04:28:26 | Newfoundland and Labrador, Canada | ||
1522956 | 1522956 | 2020-08-28 | Canada | Newfoundland and Labrador | 269 | 3 | 265 | 1 | 53.1355 | -57.6604 | 2020-08-29 04:28:19 | Newfoundland and Labrador, Canada | ||
2059655 | 2059655 | 2020-09-01 | Canada | Newfoundland and Labrador | 269 | 3 | 266 | 0 | 53.1355 | -57.6604 | 2020-09-02 04:28:25 | Newfoundland and Labrador, Canada | ||
2661549 | 2661549 | 2020-09-04 | Canada | Newfoundland and Labrador | 269 | 3 | 266 | 0 | 53.1355 | -57.6604 | 2020-09-05 04:28:19 | Newfoundland and Labrador, Canada | ||
3931799 | 3931799 | 2020-08-30 | Canada | Newfoundland and Labrador | 269 | 3 | 265 | 1 | 53.1355 | -57.6604 | 2020-08-31 04:28:27 | Newfoundland and Labrador, Canada | ||
427109 | 427109 | 2020-09-07 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-08 04:28:25 | Newfoundland and Labrador, Canada | ||
813349 | 813349 | 2020-09-05 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-06 04:28:33 | Newfoundland and Labrador, Canada | ||
1172956 | 1172956 | 2020-09-10 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-11 04:46:23 | Newfoundland and Labrador, Canada | ||
1243530 | 1243530 | 2020-09-08 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-09 04:28:48 | Newfoundland and Labrador, Canada | ||
1444355 | 1444355 | 2020-09-11 | Canada | Newfoundland and Labrador | 270 | 3 | 267 | 0 | 53.1355 | -57.6604 | 2020-09-12 04:25:05 | Newfoundland and Labrador, Canada | ||
2171321 | 2171321 | 2020-09-09 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-10 04:29:01 | Newfoundland and Labrador, Canada | ||
3161394 | 3161394 | 2020-09-06 | Canada | Newfoundland and Labrador | 270 | 3 | 266 | 1 | 53.1355 | -57.6604 | 2020-09-07 04:28:30 | Newfoundland and Labrador, Canada | ||
344048 | 344048 | 2020-09-14 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-15 03:22:50 | Newfoundland and Labrador, Canada | ||
546526 | 546526 | 2020-09-12 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-13 04:30:52 | Newfoundland and Labrador, Canada | ||
666051 | 666051 | 2020-09-16 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-17 04:22:00 | Newfoundland and Labrador, Canada | ||
1121362 | 1121362 | 2020-09-17 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-18 05:05:00 | Newfoundland and Labrador, Canada | ||
2728776 | 2728776 | 2020-09-15 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-16 04:22:53 | Newfoundland and Labrador, Canada | ||
2868487 | 2868487 | 2020-09-13 | Canada | Newfoundland and Labrador | 271 | 3 | 267 | 1 | 53.1355 | -57.6604 | 2020-09-14 04:26:00 | Newfoundland and Labrador, Canada | ||
2454544 | 2454544 | 2020-09-19 | Canada | Newfoundland and Labrador | 272 | 3 | 267 | 2 | 53.1355 | -57.6604 | 2020-09-20 04:22:00 | Newfoundland and Labrador, Canada | ||
2605798 | 2605798 | 2020-09-24 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-25 04:23:00 | Newfoundland and Labrador, Canada | ||
2613806 | 2613806 | 2020-09-26 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-27 04:23:00 | Newfoundland and Labrador, Canada | ||
2653541 | 2653541 | 2020-09-23 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-24 04:23:00 | Newfoundland and Labrador, Canada | ||
2812521 | 2812521 | 2020-09-25 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-26 04:23:00 | Newfoundland and Labrador, Canada | ||
2836589 | 2836589 | 2020-09-21 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-22 04:23:00 | Newfoundland and Labrador, Canada | ||
2848613 | 2848613 | 2020-09-18 | Canada | Newfoundland and Labrador | 272 | 3 | 267 | 2 | 53.1355 | -57.6604 | 2020-09-19 04:22:00 | Newfoundland and Labrador, Canada | ||
3093194 | 3093194 | 2020-09-20 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-21 04:23:00 | Newfoundland and Labrador, Canada | ||
3315990 | 3315990 | 2020-09-22 | Canada | Newfoundland and Labrador | 272 | 3 | 268 | 1 | 53.1355 | -57.6604 | 2020-09-23 04:23:00 | Newfoundland and Labrador, Canada | ||
966669 | 966669 | 2020-09-29 | Canada | Newfoundland and Labrador | 273 | 3 | 268 | 2 | 53.1355 | -57.6604 | 2020-09-30 04:23:33 | Newfoundland and Labrador, Canada | ||
1515166 | 1515166 | 2020-09-28 | Canada | Newfoundland and Labrador | 273 | 3 | 268 | 2 | 53.1355 | -57.6604 | 2020-09-29 04:23:42 | Newfoundland and Labrador, Canada | ||
2581754 | 2581754 | 2020-09-27 | Canada | Newfoundland and Labrador | 273 | 3 | 268 | 2 | 53.1355 | -57.6604 | 2020-09-28 04:23:00 | Newfoundland and Labrador, Canada | ||
1045588 | 1045588 | 2020-09-30 | Canada | Newfoundland and Labrador | 274 | 3 | 269 | 2 | 53.1355 | -57.6604 | 2020-10-01 04:23:42 | Newfoundland and Labrador, 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]);