johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "San Andres y Providencia" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1089933 | 1089933 | 2021-03-03 | Colombia | San Andres y Providencia | 2709 | 45 | 2653 | 11 | 12.5567 | -81.7185 | 2021-03-04 05:24:24 | San Andres y Providencia, Colombia | ||
3254005 | 3254005 | 2021-03-02 | Colombia | San Andres y Providencia | 2709 | 45 | 2652 | 12 | 12.5567 | -81.7185 | 2021-03-03 05:23:28 | San Andres y Providencia, Colombia | ||
998297 | 998297 | 2021-03-01 | Colombia | San Andres y Providencia | 2708 | 45 | 2648 | 15 | 12.5567 | -81.7185 | 2021-03-02 05:23:30 | San Andres y Providencia, Colombia | ||
2367355 | 2367355 | 2021-02-28 | Colombia | San Andres y Providencia | 2704 | 45 | 2647 | 12 | 12.5567 | -81.7185 | 2021-03-01 05:23:01 | San Andres y Providencia, Colombia | ||
3065857 | 3065857 | 2021-02-27 | Colombia | San Andres y Providencia | 2704 | 45 | 2646 | 13 | 12.5567 | -81.7185 | 2021-02-28 05:22:20 | San Andres y Providencia, Colombia | ||
2183441 | 2183441 | 2021-02-26 | Colombia | San Andres y Providencia | 2702 | 45 | 2644 | 13 | 12.5567 | -81.7185 | 2021-02-27 05:22:28 | San Andres y Providencia, Colombia | ||
1857863 | 1857863 | 2021-02-25 | Colombia | San Andres y Providencia | 2699 | 45 | 2644 | 10 | 12.5567 | -81.7185 | 2021-02-26 05:22:40 | San Andres y Providencia, Colombia | ||
280041 | 280041 | 2021-02-24 | Colombia | San Andres y Providencia | 2699 | 45 | 2643 | 11 | 12.5567 | -81.7185 | 2021-02-25 05:24:57 | San Andres y Providencia, Colombia | ||
1936309 | 1936309 | 2021-02-23 | Colombia | San Andres y Providencia | 2697 | 45 | 2641 | 11 | 12.5567 | -81.7185 | 2021-02-24 05:29:16 | San Andres y Providencia, Colombia | ||
530564 | 530564 | 2021-02-22 | Colombia | San Andres y Providencia | 2697 | 45 | 2640 | 12 | 12.5567 | -81.7185 | 2021-02-23 05:23:41 | San Andres y Providencia, Colombia | ||
181898 | 181898 | 2021-02-21 | Colombia | San Andres y Providencia | 2697 | 45 | 2638 | 14 | 12.5567 | -81.7185 | 2021-02-22 05:24:21 | San Andres y Providencia, Colombia | ||
742172 | 742172 | 2021-02-20 | Colombia | San Andres y Providencia | 2697 | 45 | 2637 | 15 | 12.5567 | -81.7185 | 2021-02-21 05:24:33 | San Andres y Providencia, Colombia | ||
471270 | 471270 | 2021-02-19 | Colombia | San Andres y Providencia | 2696 | 44 | 2637 | 15 | 12.5567 | -81.7185 | 2021-02-20 05:22:51 | San Andres y Providencia, Colombia | ||
1152979 | 1152979 | 2021-02-18 | Colombia | San Andres y Providencia | 2696 | 44 | 2637 | 15 | 12.5567 | -81.7185 | 2021-02-19 05:24:16 | San Andres y Providencia, Colombia | ||
3600899 | 3600899 | 2021-02-17 | Colombia | San Andres y Providencia | 2694 | 43 | 2629 | 22 | 12.5567 | -81.7185 | 2021-02-18 05:22:58 | San Andres y Providencia, Colombia | ||
3050034 | 3050034 | 2021-02-16 | Colombia | San Andres y Providencia | 2687 | 43 | 2629 | 15 | 12.5567 | -81.7185 | 2021-02-17 05:23:10 | San Andres y Providencia, Colombia | ||
1338133 | 1338133 | 2021-02-15 | Colombia | San Andres y Providencia | 2686 | 43 | 2622 | 21 | 12.5567 | -81.7185 | 2021-02-16 05:24:38 | San Andres y Providencia, Colombia | ||
2283284 | 2283284 | 2021-02-14 | Colombia | San Andres y Providencia | 2676 | 43 | 2622 | 11 | 12.5567 | -81.7185 | 2021-02-15 05:24:49 | San Andres y Providencia, Colombia | ||
2677684 | 2677684 | 2021-02-13 | Colombia | San Andres y Providencia | 2673 | 43 | 2621 | 9 | 12.5567 | -81.7185 | 2021-02-14 05:23:43 | San Andres y Providencia, Colombia | ||
3539317 | 3539317 | 2021-02-12 | Colombia | San Andres y Providencia | 2672 | 43 | 2620 | 9 | 12.5567 | -81.7185 | 2021-02-13 05:22:12 | San Andres y Providencia, Colombia | ||
2637580 | 2637580 | 2021-02-11 | Colombia | San Andres y Providencia | 2671 | 43 | 2609 | 19 | 12.5567 | -81.7185 | 2021-02-12 05:23:29 | San Andres y Providencia, Colombia | ||
3978435 | 3978435 | 2021-02-10 | Colombia | San Andres y Providencia | 2665 | 43 | 2603 | 19 | 12.5567 | -81.7185 | 2021-02-11 05:23:55 | San Andres y Providencia, Colombia | ||
1527755 | 1527755 | 2021-02-09 | Colombia | San Andres y Providencia | 2655 | 43 | 2602 | 10 | 12.5567 | -81.7185 | 2021-02-10 05:22:41 | San Andres y Providencia, Colombia | ||
613546 | 613546 | 2021-02-08 | Colombia | San Andres y Providencia | 2654 | 43 | 2584 | 27 | 12.5567 | -81.7185 | 2021-02-09 05:23:30 | San Andres y Providencia, Colombia | ||
1672315 | 1672315 | 2021-02-07 | Colombia | San Andres y Providencia | 2651 | 43 | 2577 | 31 | 12.5567 | -81.7185 | 2021-02-08 05:22:39 | San Andres y Providencia, Colombia | ||
974776 | 974776 | 2021-02-06 | Colombia | San Andres y Providencia | 2646 | 43 | 2577 | 26 | 12.5567 | -81.7185 | 2021-02-07 05:23:00 | San Andres y Providencia, Colombia | ||
1588034 | 1588034 | 2021-02-05 | Colombia | San Andres y Providencia | 2641 | 43 | 2569 | 29 | 12.5567 | -81.7185 | 2021-02-06 05:23:55 | San Andres y Providencia, Colombia | ||
790241 | 790241 | 2021-02-04 | Colombia | San Andres y Providencia | 2637 | 43 | 2566 | 28 | 12.5567 | -81.7185 | 2021-02-05 05:22:38 | San Andres y Providencia, Colombia | ||
340133 | 340133 | 2021-02-03 | Colombia | San Andres y Providencia | 2628 | 42 | 2562 | 24 | 12.5567 | -81.7185 | 2021-02-04 05:22:26 | San Andres y Providencia, Colombia | ||
1684359 | 1684359 | 2021-02-02 | Colombia | San Andres y Providencia | 2624 | 42 | 2558 | 24 | 12.5567 | -81.7185 | 2021-02-03 05:22:52 | San Andres y Providencia, Colombia | ||
1676329 | 1676329 | 2021-02-01 | Colombia | San Andres y Providencia | 2622 | 42 | 2550 | 30 | 12.5567 | -81.7185 | 2021-02-02 05:22:49 | San Andres y Providencia, Colombia | ||
1459617 | 1459617 | 2021-01-31 | Colombia | San Andres y Providencia | 2621 | 42 | 2547 | 32 | 12.5567 | -81.7185 | 2021-02-01 05:22:53 | San Andres y Providencia, Colombia | ||
2211525 | 2211525 | 2021-01-30 | Colombia | San Andres y Providencia | 2620 | 42 | 2544 | 34 | 12.5567 | -81.7185 | 2021-01-31 05:22:42 | San Andres y Providencia, Colombia | ||
1897012 | 1897012 | 2021-01-29 | Colombia | San Andres y Providencia | 2615 | 42 | 2539 | 34 | 12.5567 | -81.7185 | 2021-01-30 05:22:49 | San Andres y Providencia, Colombia | ||
2481828 | 2481828 | 2021-01-28 | Colombia | San Andres y Providencia | 2612 | 42 | 2530 | 40 | 12.5567 | -81.7185 | 2021-01-29 05:22:23 | San Andres y Providencia, Colombia | ||
3153463 | 3153463 | 2021-01-27 | Colombia | San Andres y Providencia | 2605 | 42 | 2523 | 40 | 12.5567 | -81.7185 | 2021-01-28 05:22:24 | San Andres y Providencia, Colombia | ||
12198 | 12198 | 2021-01-26 | Colombia | San Andres y Providencia | 2586 | 42 | 2503 | 41 | 12.5567 | -81.7185 | 2021-01-27 05:23:41 | San Andres y Providencia, Colombia | ||
2567522 | 2567522 | 2021-01-25 | Colombia | San Andres y Providencia | 2586 | 42 | 2503 | 41 | 12.5567 | -81.7185 | 2021-01-26 05:22:02 | San Andres y Providencia, Colombia | ||
1759154 | 1759154 | 2021-01-24 | Colombia | San Andres y Providencia | 2584 | 42 | 2502 | 40 | 12.5567 | -81.7185 | 2021-01-25 05:22:16 | San Andres y Providencia, Colombia | ||
2426761 | 2426761 | 2021-01-23 | Colombia | San Andres y Providencia | 2580 | 42 | 2499 | 39 | 12.5567 | -81.7185 | 2021-01-24 05:22:35 | San Andres y Providencia, Colombia | ||
2466663 | 2466663 | 2021-01-22 | Colombia | San Andres y Providencia | 2578 | 42 | 2499 | 37 | 12.5567 | -81.7185 | 2021-01-23 05:22:03 | San Andres y Providencia, Colombia | ||
435214 | 435214 | 2021-01-21 | Colombia | San Andres y Providencia | 2577 | 42 | 2486 | 49 | 12.5567 | -81.7185 | 2021-01-22 05:22:10 | San Andres y Providencia, Colombia | ||
1093946 | 1093946 | 2021-01-20 | Colombia | San Andres y Providencia | 2564 | 42 | 2477 | 45 | 12.5567 | -81.7185 | 2021-01-21 05:22:01 | San Andres y Providencia, Colombia | ||
908036 | 908036 | 2021-01-19 | Colombia | San Andres y Providencia | 2557 | 42 | 2472 | 43 | 12.5567 | -81.7185 | 2021-01-20 05:21:54 | San Andres y Providencia, Colombia | ||
237099 | 237099 | 2021-01-18 | Colombia | San Andres y Providencia | 2552 | 42 | 2466 | 44 | 12.5567 | -81.7185 | 2021-01-19 05:22:15 | San Andres y Providencia, Colombia | ||
3503216 | 3503216 | 2021-01-17 | Colombia | San Andres y Providencia | 2548 | 42 | 2463 | 43 | 12.5567 | -81.7185 | 2021-01-18 05:22:34 | San Andres y Providencia, Colombia | ||
3101299 | 3101299 | 2021-01-16 | Colombia | San Andres y Providencia | 2546 | 42 | 2461 | 43 | 12.5567 | -81.7185 | 2021-01-17 05:22:17 | San Andres y Providencia, Colombia | ||
3515261 | 3515261 | 2021-01-15 | Colombia | San Andres y Providencia | 2531 | 42 | 2457 | 32 | 12.5567 | -81.7185 | 2021-01-16 05:22:40 | San Andres y Providencia, Colombia | ||
3879434 | 3879434 | 2021-01-14 | Colombia | San Andres y Providencia | 2525 | 42 | 2448 | 35 | 12.5567 | -81.7185 | 2021-01-15 05:22:24 | San Andres y Providencia, Colombia | ||
3308061 | 3308061 | 2021-01-13 | Colombia | San Andres y Providencia | 2514 | 42 | 2445 | 27 | 12.5567 | -81.7185 | 2021-01-14 05:22:32 | San Andres y Providencia, Colombia | ||
774206 | 774206 | 2021-01-12 | Colombia | San Andres y Providencia | 2511 | 42 | 2440 | 29 | 12.5567 | -81.7185 | 2021-01-13 05:22:15 | San Andres y Providencia, Colombia | ||
189927 | 189927 | 2021-01-11 | Colombia | San Andres y Providencia | 2507 | 42 | 2432 | 33 | 12.5567 | -81.7185 | 2021-01-12 05:22:15 | San Andres y Providencia, Colombia | ||
2625730 | 2625730 | 2021-01-10 | Colombia | San Andres y Providencia | 2503 | 42 | 2430 | 31 | 12.5567 | -81.7185 | 2021-01-11 05:21:50 | San Andres y Providencia, Colombia | ||
3899818 | 3899818 | 2021-01-09 | Colombia | San Andres y Providencia | 2499 | 41 | 2426 | 32 | 12.5567 | -81.7185 | 2021-01-10 05:22:12 | San Andres y Providencia, Colombia | ||
153841 | 153841 | 2021-01-08 | Colombia | San Andres y Providencia | 2497 | 41 | 2419 | 37 | 12.5567 | -81.7185 | 2021-01-09 05:22:18 | San Andres y Providencia, Colombia | ||
2541265 | 2541265 | 2021-01-07 | Colombia | San Andres y Providencia | 2490 | 40 | 2416 | 34 | 12.5567 | -81.7185 | 2021-01-08 05:22:42 | San Andres y Providencia, Colombia | ||
2864574 | 2864574 | 2021-01-06 | Colombia | San Andres y Providencia | 2490 | 40 | 2408 | 42 | 12.5567 | -81.7185 | 2021-01-07 05:22:03 | San Andres y Providencia, Colombia | ||
3034161 | 3034161 | 2021-01-05 | Colombia | San Andres y Providencia | 2484 | 40 | 2404 | 40 | 12.5567 | -81.7185 | 2021-01-06 05:22:16 | San Andres y Providencia, Colombia | ||
1061706 | 1061706 | 2021-01-04 | Colombia | San Andres y Providencia | 2477 | 40 | 2402 | 35 | 12.5567 | -81.7185 | 2021-01-05 05:21:49 | San Andres y Providencia, Colombia | ||
3230309 | 3230309 | 2021-01-03 | Colombia | San Andres y Providencia | 2476 | 39 | 2401 | 36 | 12.5567 | -81.7185 | 2021-01-04 05:22:02 | San Andres y Providencia, Colombia | ||
2227379 | 2227379 | 2021-01-02 | Colombia | San Andres y Providencia | 2475 | 39 | 2398 | 38 | 12.5567 | -81.7185 | 2021-01-03 05:22:52 | San Andres y Providencia, Colombia | ||
1136743 | 1136743 | 2021-01-01 | Colombia | San Andres y Providencia | 2471 | 39 | 2391 | 41 | 12.5567 | -81.7185 | 2021-01-02 05:22:33 | San Andres y Providencia, Colombia | ||
3695349 | 3695349 | 2020-12-31 | Colombia | San Andres y Providencia | 2465 | 39 | 2387 | 39 | 12.5567 | -81.7185 | 2021-01-01 05:23:07 | San Andres y Providencia, Colombia | ||
1010164 | 1010164 | 2020-12-30 | Colombia | San Andres y Providencia | 2462 | 39 | 2383 | 40 | 12.5567 | -81.7185 | 2020-12-31 05:22:49 | San Andres y Providencia, Colombia | ||
766179 | 766179 | 2020-12-29 | Colombia | San Andres y Providencia | 2445 | 38 | 2372 | 35 | 12.5567 | -81.7185 | 2020-12-30 05:22:34 | San Andres y Providencia, Colombia | ||
3761443 | 3761443 | 2020-12-28 | Colombia | San Andres y Providencia | 2439 | 38 | 2366 | 35 | 12.5567 | -81.7185 | 2020-12-29 05:22:37 | San Andres y Providencia, Colombia | ||
3777763 | 3777763 | 2020-12-27 | Colombia | San Andres y Providencia | 2432 | 38 | 2354 | 40 | 12.5567 | -81.7185 | 2020-12-28 05:22:06 | San Andres y Providencia, Colombia | ||
2223368 | 2223368 | 2020-12-26 | Colombia | San Andres y Providencia | 2429 | 37 | 2349 | 43 | 12.5567 | -81.7185 | 2020-12-27 05:22:55 | San Andres y Providencia, Colombia | ||
202115 | 202115 | 2020-12-25 | Colombia | San Andres y Providencia | 2428 | 37 | 2345 | 46 | 12.5567 | -81.7185 | 2020-12-26 05:22:28 | San Andres y Providencia, Colombia | ||
3691338 | 3691338 | 2020-12-24 | Colombia | San Andres y Providencia | 2427 | 37 | 2334 | 56 | 12.5567 | -81.7185 | 2020-12-25 05:22:48 | San Andres y Providencia, Colombia | ||
2406690 | 2406690 | 2020-12-23 | Colombia | San Andres y Providencia | 2412 | 37 | 2324 | 51 | 12.5567 | -81.7185 | 2020-12-24 05:23:04 | San Andres y Providencia, Colombia | ||
3769736 | 3769736 | 2020-12-22 | Colombia | San Andres y Providencia | 2406 | 37 | 2322 | 47 | 12.5567 | -81.7185 | 2020-12-23 05:22:03 | San Andres y Providencia, Colombia | ||
927552 | 927552 | 2020-12-21 | Colombia | San Andres y Providencia | 2404 | 36 | 2320 | 48 | 12.5567 | -81.7185 | 2020-12-22 05:22:33 | San Andres y Providencia, Colombia | ||
2119573 | 2119573 | 2020-12-20 | Colombia | San Andres y Providencia | 2403 | 36 | 2311 | 56 | 12.5567 | -81.7185 | 2020-12-21 05:27:58 | San Andres y Providencia, Colombia | ||
2931080 | 2931080 | 2020-12-19 | Colombia | San Andres y Providencia | 2398 | 36 | 2311 | 51 | 12.5567 | -81.7185 | 2020-12-20 05:27:32 | San Andres y Providencia, Colombia | ||
1901026 | 1901026 | 2020-12-18 | Colombia | San Andres y Providencia | 2393 | 36 | 2306 | 51 | 12.5567 | -81.7185 | 2020-12-19 05:27:52 | San Andres y Providencia, Colombia | ||
2127852 | 2127852 | 2020-12-17 | Colombia | San Andres y Providencia | 2389 | 36 | 2284 | 69 | 12.5567 | -81.7185 | 2020-12-18 05:28:18 | San Andres y Providencia, Colombia | ||
3149452 | 3149452 | 2020-12-16 | Colombia | San Andres y Providencia | 2380 | 36 | 2281 | 63 | 12.5567 | -81.7185 | 2020-12-17 05:28:12 | San Andres y Providencia, Colombia | ||
1034233 | 1034233 | 2020-12-15 | Colombia | San Andres y Providencia | 2364 | 36 | 2271 | 57 | 12.5567 | -81.7185 | 2020-12-16 05:28:04 | San Andres y Providencia, Colombia | ||
1751127 | 1751127 | 2020-12-14 | Colombia | San Andres y Providencia | 2360 | 36 | 2262 | 62 | 12.5567 | -81.7185 | 2020-12-15 05:26:38 | San Andres y Providencia, Colombia | ||
3847647 | 3847647 | 2020-12-13 | Colombia | San Andres y Providencia | 2355 | 36 | 2255 | 64 | 12.5567 | -81.7185 | 2020-12-14 05:26:27 | San Andres y Providencia, Colombia | ||
845429 | 845429 | 2020-12-12 | Colombia | San Andres y Providencia | 2345 | 36 | 2244 | 65 | 12.5567 | -81.7185 | 2020-12-13 05:27:20 | San Andres y Providencia, Colombia | ||
860536 | 860536 | 2020-12-11 | Colombia | San Andres y Providencia | 2331 | 36 | 2238 | 57 | 12.5567 | -81.7185 | 2020-12-12 05:26:19 | San Andres y Providencia, Colombia | ||
1600078 | 1600078 | 2020-12-10 | Colombia | San Andres y Providencia | 2323 | 35 | 2215 | 73 | 12.5567 | -81.7185 | 2020-12-11 05:26:59 | San Andres y Providencia, Colombia | ||
2975087 | 2975087 | 2020-12-09 | Colombia | San Andres y Providencia | 2319 | 34 | 2203 | 82 | 12.5567 | -81.7185 | 2020-12-10 05:26:19 | San Andres y Providencia, Colombia | ||
1818647 | 1818647 | 2020-12-08 | Colombia | San Andres y Providencia | 2307 | 34 | 2159 | 114 | 12.5567 | -81.7185 | 2020-12-09 05:28:01 | San Andres y Providencia, Colombia | ||
2347283 | 2347283 | 2020-12-07 | Colombia | San Andres y Providencia | 2281 | 34 | 2110 | 137 | 12.5567 | -81.7185 | 2020-12-08 05:27:42 | San Andres y Providencia, Colombia | ||
1006153 | 1006153 | 2020-12-06 | Colombia | San Andres y Providencia | 2259 | 34 | 2096 | 129 | 12.5567 | -81.7185 | 2020-12-07 05:26:14 | San Andres y Providencia, Colombia | ||
1632162 | 1632162 | 2020-12-05 | Colombia | San Andres y Providencia | 2239 | 33 | 2086 | 120 | 12.5567 | -81.7185 | 2020-12-06 05:26:18 | San Andres y Providencia, Colombia | ||
3859690 | 3859690 | 2020-12-04 | Colombia | San Andres y Providencia | 2219 | 33 | 2063 | 123 | 12.5567 | -81.7185 | 2020-12-05 05:27:36 | San Andres y Providencia, Colombia | ||
74948 | 74948 | 2020-12-03 | Colombia | San Andres y Providencia | 2204 | 33 | 2043 | 128 | 12.5567 | -81.7185 | 2020-12-04 05:27:27 | San Andres y Providencia, Colombia | ||
738160 | 738160 | 2020-12-02 | Colombia | San Andres y Providencia | 2187 | 33 | 2015 | 139 | 12.5567 | -81.7185 | 2020-12-03 05:28:22 | San Andres y Providencia, Colombia | ||
2537254 | 2537254 | 2020-12-01 | Colombia | San Andres y Providencia | 2155 | 33 | 2008 | 114 | 12.5567 | -81.7185 | 2020-12-02 05:27:41 | San Andres y Providencia, Colombia | ||
1584023 | 1584023 | 2020-11-30 | Colombia | San Andres y Providencia | 2138 | 33 | 2008 | 97 | 12.5567 | -81.7185 | 2020-12-01 05:26:18 | San Andres y Providencia, Colombia | ||
3566426 | 3566426 | 2020-11-29 | Colombia | San Andres y Providencia | 2129 | 33 | 2004 | 92 | 12.5567 | -81.7185 | 2020-11-30 05:26:13 | San Andres y Providencia, Colombia | ||
2935091 | 2935091 | 2020-11-28 | Colombia | San Andres y Providencia | 2126 | 33 | 2001 | 92 | 12.5567 | -81.7185 | 2020-11-29 05:25:55 | San Andres y Providencia, Colombia | ||
392094 | 392094 | 2020-11-27 | Colombia | San Andres y Providencia | 2110 | 33 | 1996 | 81 | 12.5567 | -81.7185 | 2020-11-28 05:25:50 | San Andres y Providencia, Colombia | ||
923541 | 923541 | 2020-11-26 | Colombia | San Andres y Providencia | 2084 | 33 | 1988 | 63 | 12.5567 | -81.7185 | 2020-11-27 05:26:53 | San Andres y Providencia, Colombia | ||
1972446 | 1972446 | 2020-11-25 | Colombia | San Andres y Providencia | 2076 | 33 | 1951 | 92 | 12.5567 | -81.7185 | 2020-11-26 05:27:44 | San Andres y Providencia, Colombia | ||
1350177 | 1350177 | 2020-11-24 | Colombia | San Andres y Providencia | 2071 | 33 | 1939 | 99 | 12.5567 | -81.7185 | 2020-11-25 05:27:20 | San Andres y Providencia, Colombia |
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]);