johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Udmurt Republic" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, last_update, day (date)
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805542 | 805542 | 2020-06-01 | Russia | Udmurt Republic | 682 | 12 | 412 | 258 | 57.1961165 | 52.69598320000001 | 2020-06-02 02:33:08 | Udmurt Republic, Russia | ||
2556005 | 2556005 | 2020-06-02 | Russia | Udmurt Republic | 717 | 12 | 425 | 280 | 57.1961165 | 52.69598320000001 | 2020-06-03 02:33:13 | Udmurt Republic, Russia | ||
3866963 | 3866963 | 2020-06-03 | Russia | Udmurt Republic | 770 | 12 | 438 | 320 | 57.1961165 | 52.69598320000001 | 2020-06-04 02:33:14 | Udmurt Republic, Russia | ||
1281408 | 1281408 | 2020-06-04 | Russia | Udmurt Republic | 822 | 12 | 455 | 355 | 57.1961165 | 52.69598320000001 | 2020-06-05 02:33:06 | Udmurt Republic, Russia | ||
1269942 | 1269942 | 2020-06-05 | Russia | Udmurt Republic | 865 | 12 | 460 | 393 | 57.1961165 | 52.69598320000001 | 2020-06-06 02:33:00 | Udmurt Republic, Russia | ||
574245 | 574245 | 2020-06-06 | Russia | Udmurt Republic | 904 | 12 | 466 | 426 | 57.1961165 | 52.69598320000001 | 2020-06-07 03:53:30 | Udmurt Republic, Russia | ||
2800189 | 2800189 | 2020-06-07 | Russia | Udmurt Republic | 936 | 12 | 467 | 457 | 57.1961165 | 52.69598320000001 | 2020-06-08 03:33:22 | Udmurt Republic, Russia | ||
217393 | 217393 | 2020-06-08 | Russia | Udmurt Republic | 963 | 12 | 467 | 484 | 57.1961165 | 52.69598320000001 | 2020-06-09 03:33:03 | Udmurt Republic, Russia | ||
1210966 | 1210966 | 2020-06-09 | Russia | Udmurt Republic | 987 | 12 | 478 | 497 | 57.1961165 | 52.69598320000001 | 2020-06-10 04:07:00 | Udmurt Republic, Russia | ||
2864145 | 2864145 | 2020-06-10 | Russia | Udmurt Republic | 1011 | 12 | 502 | 497 | 57.1961165 | 52.69598320000001 | 2020-06-11 03:33:41 | Udmurt Republic, Russia | ||
1273704 | 1273704 | 2020-06-11 | Russia | Udmurt Republic | 1031 | 12 | 516 | 503 | 57.1961165 | 52.69598320000001 | 2020-06-12 05:09:52 | Udmurt Republic, Russia | ||
737734 | 737734 | 2020-06-12 | Russia | Udmurt Republic | 1053 | 12 | 551 | 490 | 57.1961165 | 52.69598320000001 | 2020-06-13 03:33:14 | Udmurt Republic, Russia | ||
3061414 | 3061414 | 2020-06-13 | Russia | Udmurt Republic | 1073 | 12 | 557 | 504 | 57.1961165 | 52.69598320000001 | 2020-06-14 03:33:15 | Udmurt Republic, Russia | ||
1837362 | 1837362 | 2020-06-14 | Russia | Udmurt Republic | 1094 | 12 | 559 | 523 | 57.1961165 | 52.69598320000001 | 2020-06-15 03:33:14 | Udmurt Republic, Russia | ||
287411 | 287411 | 2020-06-15 | Russia | Udmurt Republic | 1114 | 12 | 560 | 542 | 57.1961165 | 52.69598320000001 | 2020-06-16 04:33:09 | Udmurt Republic, Russia | ||
2386848 | 2386848 | 2020-06-16 | Russia | Udmurt Republic | 1133 | 12 | 626 | 495 | 57.1961165 | 52.69598320000001 | 2020-06-17 04:33:21 | Udmurt Republic, Russia | ||
1196085 | 1196085 | 2020-06-17 | Russia | Udmurt Republic | 1153 | 12 | 693 | 448 | 57.1961165 | 52.69598320000001 | 2020-06-18 04:33:18 | Udmurt Republic, Russia | ||
3682882 | 3682882 | 2020-06-18 | Russia | Udmurt Republic | 1175 | 12 | 720 | 443 | 57.1961165 | 52.69598320000001 | 2020-06-19 04:33:17 | Udmurt Republic, Russia | ||
1691733 | 1691733 | 2020-06-19 | Russia | Udmurt Republic | 1195 | 13 | 778 | 404 | 57.1961165 | 52.69598320000001 | 2020-06-20 04:33:19 | Udmurt Republic, Russia | ||
2438155 | 2438155 | 2020-06-20 | Russia | Udmurt Republic | 1216 | 15 | 827 | 374 | 57.1961165 | 52.69598320000001 | 2020-06-21 04:33:19 | Udmurt Republic, Russia | ||
3249562 | 3249562 | 2020-06-21 | Russia | Udmurt Republic | 1235 | 15 | 834 | 386 | 57.1961165 | 52.69598320000001 | 2020-06-22 04:33:20 | Udmurt Republic, Russia | ||
1510823 | 1510823 | 2020-06-22 | Russia | Udmurt Republic | 1254 | 15 | 848 | 391 | 57.1961165 | 52.69598320000001 | 2020-06-23 04:33:22 | Udmurt Republic, Russia | ||
1522629 | 1522629 | 2020-06-23 | Russia | Udmurt Republic | 1272 | 15 | 884 | 373 | 57.1961165 | 52.69598320000001 | 2020-06-24 04:33:28 | Udmurt Republic, Russia | ||
2700944 | 2700944 | 2020-06-24 | Russia | Udmurt Republic | 1294 | 15 | 941 | 338 | 57.1961165 | 52.69598320000001 | 2020-06-25 05:26:54 | Udmurt Republic, Russia | ||
2625304 | 2625304 | 2020-06-25 | Russia | Udmurt Republic | 1314 | 15 | 945 | 354 | 57.1961165 | 52.69598320000001 | 2020-06-26 04:33:43 | Udmurt Republic, Russia | ||
1136317 | 1136317 | 2020-06-26 | Russia | Udmurt Republic | 1334 | 15 | 969 | 350 | 57.1961165 | 52.69598320000001 | 2020-06-27 04:33:35 | Udmurt Republic, Russia | ||
2040036 | 2040036 | 2020-06-27 | Russia | Udmurt Republic | 1357 | 16 | 998 | 343 | 57.1961165 | 52.69598320000001 | 2020-06-28 04:34:04 | Udmurt Republic, Russia | ||
2306701 | 2306701 | 2020-06-28 | Russia | Udmurt Republic | 1379 | 16 | 999 | 364 | 57.1961165 | 52.69598320000001 | 2020-06-29 04:33:44 | Udmurt Republic, Russia | ||
2633138 | 2633138 | 2020-06-29 | Russia | Udmurt Republic | 1400 | 16 | 1000 | 384 | 57.1961165 | 52.69598320000001 | 2020-06-30 04:33:48 | Udmurt Republic, Russia | ||
2974661 | 2974661 | 2020-06-30 | Russia | Udmurt Republic | 1420 | 16 | 1028 | 376 | 57.1961165 | 52.69598320000001 | 2020-07-01 04:33:52 | Udmurt Republic, Russia | ||
303283 | 303283 | 2020-07-01 | Russia | Udmurt Republic | 1440 | 16 | 1068 | 356 | 57.1961165 | 52.69598320000001 | 2020-07-02 04:33:46 | Udmurt Republic, Russia | ||
3045592 | 3045592 | 2020-07-02 | Russia | Udmurt Republic | 1459 | 16 | 1069 | 374 | 57.1961165 | 52.69598320000001 | 2020-07-03 04:33:54 | Udmurt Republic, Russia | ||
2234798 | 2234798 | 2020-07-03 | Russia | Udmurt Republic | 1476 | 16 | 1098 | 362 | 57.1961165 | 52.69598320000001 | 2020-07-04 04:33:51 | Udmurt Republic, Russia | ||
530137 | 530137 | 2020-07-04 | Russia | Udmurt Republic | 1499 | 17 | 1137 | 345 | 57.1961165 | 52.69598320000001 | 2020-07-05 04:33:46 | Udmurt Republic, Russia | ||
415575 | 415575 | 2020-07-05 | Russia | Udmurt Republic | 1519 | 17 | 1139 | 363 | 57.1961165 | 52.69598320000001 | 2020-07-06 04:33:57 | Udmurt Republic, Russia | ||
2685110 | 2685110 | 2020-07-06 | Russia | Udmurt Republic | 1537 | 17 | 1139 | 381 | 57.1961165 | 52.69598320000001 | 2020-07-07 04:34:00 | Udmurt Republic, Russia | ||
887550 | 887550 | 2020-07-07 | Russia | Udmurt Republic | 1554 | 17 | 1210 | 327 | 57.1961165 | 52.69598320000001 | 2020-07-08 05:33:48 | Udmurt Republic, Russia | ||
2222941 | 2222941 | 2020-07-08 | Russia | Udmurt Republic | 1592 | 17 | 1252 | 323 | 57.1961165 | 52.69598320000001 | 2020-07-09 04:34:23 | Udmurt Republic, Russia | ||
1005725 | 1005725 | 2020-07-09 | Russia | Udmurt Republic | 1623 | 19 | 1300 | 304 | 57.1961165 | 52.69598320000001 | 2020-07-10 04:34:24 | Udmurt Republic, Russia | ||
3237740 | 3237740 | 2020-07-10 | Russia | Udmurt Republic | 1652 | 19 | 1329 | 304 | 57.1961165 | 52.69598320000001 | 2020-07-11 04:34:26 | Udmurt Republic, Russia | ||
3436242 | 3436242 | 2020-07-11 | Russia | Udmurt Republic | 1701 | 19 | 1358 | 324 | 57.1961165 | 52.69598320000001 | 2020-07-12 04:34:30 | Udmurt Republic, Russia | ||
3737847 | 3737847 | 2020-07-12 | Russia | Udmurt Republic | 1747 | 19 | 1360 | 368 | 57.1961165 | 52.69598320000001 | 2020-07-13 04:43:04 | Udmurt Republic, Russia | ||
3491584 | 3491584 | 2020-07-13 | Russia | Udmurt Republic | 1792 | 19 | 1360 | 413 | 57.1961165 | 52.69598320000001 | 2020-07-14 04:34:46 | Udmurt Republic, Russia | ||
2158943 | 2158943 | 2020-07-14 | Russia | Udmurt Republic | 1834 | 19 | 1380 | 435 | 57.1961165 | 52.69598320000001 | 2020-07-15 04:34:39 | Udmurt Republic, Russia | ||
2748299 | 2748299 | 2020-07-15 | Russia | Udmurt Republic | 1880 | 19 | 1394 | 467 | 57.1961165 | 52.69598320000001 | 2020-07-16 04:44:59 | Udmurt Republic, Russia | ||
367631 | 367631 | 2020-07-16 | Russia | Udmurt Republic | 1923 | 19 | 1406 | 498 | 57.1961165 | 52.69598320000001 | 2020-07-17 04:34:50 | Udmurt Republic, Russia | ||
2708821 | 2708821 | 2020-07-17 | Russia | Udmurt Republic | 1966 | 19 | 1420 | 527 | 57.1961165 | 52.69598320000001 | 2020-07-18 04:34:45 | Udmurt Republic, Russia | ||
3205519 | 3205519 | 2020-07-18 | Russia | Udmurt Republic | 2006 | 19 | 1456 | 531 | 57.1961165 | 52.69598320000001 | 2020-07-19 04:34:58 | Udmurt Republic, Russia | ||
122130 | 122130 | 2020-07-19 | Russia | Udmurt Republic | 2044 | 19 | 1456 | 569 | 57.1961165 | 52.69598320000001 | 2020-07-20 05:34:40 | Udmurt Republic, Russia | ||
327225 | 327225 | 2020-07-20 | Russia | Udmurt Republic | 2079 | 19 | 1456 | 604 | 57.1961165 | 52.69598320000001 | 2020-07-21 04:38:46 | Udmurt Republic, Russia | ||
1707734 | 1707734 | 2020-07-21 | Russia | Udmurt Republic | 2111 | 22 | 1493 | 596 | 57.1961165 | 52.69598320000001 | 2020-07-22 04:34:42 | Udmurt Republic, Russia | ||
844995 | 844995 | 2020-07-22 | Russia | Udmurt Republic | 2142 | 22 | 1560 | 560 | 57.1961165 | 52.69598320000001 | 2020-07-23 05:15:04 | Udmurt Republic, Russia | ||
62178 | 62178 | 2020-07-23 | Russia | Udmurt Republic | 2173 | 23 | 1597 | 553 | 57.1961165 | 52.69598320000001 | 2020-07-24 05:30:40 | Udmurt Republic, Russia | ||
2563975 | 2563975 | 2020-07-24 | Russia | Udmurt Republic | 2202 | 23 | 1662 | 517 | 57.1961165 | 52.69598320000001 | 2020-07-25 04:47:39 | Udmurt Republic, Russia | ||
1503004 | 1503004 | 2020-07-25 | Russia | Udmurt Republic | 2229 | 23 | 1717 | 489 | 57.1961165 | 52.69598320000001 | 2020-07-26 04:35:00 | Udmurt Republic, Russia | ||
442761 | 442761 | 2020-07-26 | Russia | Udmurt Republic | 2254 | 23 | 1725 | 506 | 57.1961165 | 52.69598320000001 | 2020-07-27 04:35:02 | Udmurt Republic, Russia | ||
177447 | 177447 | 2020-07-27 | Russia | Udmurt Republic | 2279 | 23 | 1742 | 514 | 57.1961165 | 52.69598320000001 | 2020-07-28 04:58:43 | Udmurt Republic, Russia | ||
3185397 | 3185397 | 2020-07-28 | Russia | Udmurt Republic | 2303 | 23 | 1768 | 512 | 57.1961165 | 52.69598320000001 | 2020-07-29 04:35:11 | Udmurt Republic, Russia | ||
2958780 | 2958780 | 2020-07-29 | Russia | Udmurt Republic | 2323 | 24 | 1859 | 440 | 57.1961165 | 52.69598320000001 | 2020-07-30 04:35:05 | Udmurt Republic, Russia | ||
1928612 | 1928612 | 2020-07-30 | Russia | Udmurt Republic | 2341 | 24 | 1898 | 419 | 57.1961165 | 52.69598320000001 | 2020-07-31 04:35:18 | Udmurt Republic, Russia | ||
3264906 | 3264906 | 2020-07-31 | Russia | Udmurt Republic | 2360 | 25 | 1918 | 417 | 57.1961165 | 52.69598320000001 | 2020-08-01 04:36:27 | Udmurt Republic, Russia | ||
753741 | 753741 | 2020-08-01 | Russia | Udmurt Republic | 2378 | 26 | 1975 | 377 | 57.1961165 | 52.69598320000001 | 2020-08-02 04:34:47 | Udmurt Republic, Russia | ||
2808173 | 2808173 | 2020-08-02 | Russia | Udmurt Republic | 2398 | 26 | 1975 | 397 | 57.1961165 | 52.69598320000001 | 2020-08-03 04:34:35 | Udmurt Republic, Russia | ||
2740421 | 2740421 | 2020-08-03 | Russia | Udmurt Republic | 2420 | 27 | 1975 | 418 | 57.1961165 | 52.69598320000001 | 2020-08-04 04:41:59 | Udmurt Republic, Russia | ||
98538 | 98538 | 2020-08-04 | Russia | Udmurt Republic | 2442 | 27 | 2021 | 394 | 57.1961165 | 52.69598320000001 | 2020-08-05 04:34:43 | Udmurt Republic, Russia | ||
3793302 | 3793302 | 2020-08-05 | Russia | Udmurt Republic | 2463 | 31 | 2056 | 376 | 57.1961165 | 52.69598320000001 | 2020-08-06 04:35:02 | Udmurt Republic, Russia | ||
3612472 | 3612472 | 2020-08-06 | Russia | Udmurt Republic | 2492 | 31 | 2099 | 362 | 57.1961165 | 52.69598320000001 | 2020-08-07 04:35:11 | Udmurt Republic, Russia | ||
458787 | 458787 | 2020-08-07 | Russia | Udmurt Republic | 2520 | 33 | 2128 | 359 | 57.1961165 | 52.69598320000001 | 2020-08-08 04:34:53 | Udmurt Republic, Russia | ||
371603 | 371603 | 2020-08-08 | Russia | Udmurt Republic | 2547 | 33 | 2149 | 365 | 57.1961165 | 52.69598320000001 | 2020-08-09 04:34:54 | Udmurt Republic, Russia | ||
3923435 | 3923435 | 2020-08-09 | Russia | Udmurt Republic | 2574 | 33 | 2149 | 392 | 57.1961165 | 52.69598320000001 | 2020-08-10 04:34:55 | Udmurt Republic, Russia | ||
1920626 | 1920626 | 2020-08-10 | Russia | Udmurt Republic | 2602 | 34 | 2155 | 413 | 57.1961165 | 52.69598320000001 | 2020-08-11 04:35:08 | Udmurt Republic, Russia | ||
662551 | 662551 | 2020-08-11 | Russia | Udmurt Republic | 2628 | 34 | 2180 | 414 | 57.1961165 | 52.69598320000001 | 2020-08-12 04:27:29 | Udmurt Republic, Russia | ||
3531702 | 3531702 | 2020-08-12 | Russia | Udmurt Republic | 2654 | 34 | 2207 | 413 | 57.1961165 | 52.69598320000001 | 2020-08-13 04:29:15 | Udmurt Republic, Russia | ||
583083 | 583083 | 2020-08-13 | Russia | Udmurt Republic | 2681 | 34 | 2236 | 411 | 57.1961165 | 52.69598320000001 | 2020-08-14 04:51:19 | Udmurt Republic, Russia | ||
1612499 | 1612499 | 2020-08-14 | Russia | Udmurt Republic | 2706 | 34 | 2262 | 410 | 57.1961165 | 52.69598320000001 | 2020-08-15 04:27:31 | Udmurt Republic, Russia | ||
146224 | 146224 | 2020-08-15 | Russia | Udmurt Republic | 2735 | 34 | 2279 | 422 | 57.1961165 | 52.69598320000001 | 2020-08-16 04:27:42 | Udmurt Republic, Russia | ||
1556222 | 1556222 | 2020-08-16 | Russia | Udmurt Republic | 2764 | 34 | 2282 | 448 | 57.1961165 | 52.69598320000001 | 2020-08-17 04:27:20 | Udmurt Republic, Russia | ||
837864 | 837864 | 2020-08-17 | Russia | Udmurt Republic | 2792 | 34 | 2286 | 472 | 57.1961165 | 52.69598320000001 | 2020-08-18 04:27:56 | Udmurt Republic, Russia | ||
3178260 | 3178260 | 2020-08-18 | Russia | Udmurt Republic | 2819 | 36 | 2314 | 469 | 57.1961165 | 52.6959832 | 2020-08-19 04:27:00 | Udmurt Republic, Russia | ||
206506 | 206506 | 2020-08-19 | Russia | Udmurt Republic | 2849 | 36 | 2347 | 466 | 57.1961165 | 52.69598320000001 | 2020-08-20 04:27:43 | Udmurt Republic, Russia | ||
3484557 | 3484557 | 2020-08-20 | Russia | Udmurt Republic | 2876 | 36 | 2387 | 453 | 57.1961165 | 52.69598320000001 | 2020-08-21 04:27:41 | Udmurt Republic, Russia | ||
1479808 | 1479808 | 2020-08-21 | Russia | Udmurt Republic | 2903 | 38 | 2404 | 461 | 57.1961165 | 52.69598320000001 | 2020-08-22 04:27:49 | Udmurt Republic, Russia | ||
2299701 | 2299701 | 2020-08-22 | Russia | Udmurt Republic | 2931 | 38 | 2444 | 449 | 57.1961165 | 52.69598320000001 | 2020-08-23 04:27:48 | Udmurt Republic, Russia | ||
2215919 | 2215919 | 2020-08-23 | Russia | Udmurt Republic | 2961 | 38 | 2444 | 479 | 57.1961165 | 52.69598320000001 | 2020-08-24 04:27:56 | Udmurt Republic, Russia | ||
2991524 | 2991524 | 2020-08-24 | Russia | Udmurt Republic | 2990 | 38 | 2444 | 508 | 57.1961165 | 52.69598320000001 | 2020-08-25 04:28:02 | Udmurt Republic, Russia | ||
3562820 | 3562820 | 2020-08-25 | Russia | Udmurt Republic | 3013 | 42 | 2497 | 474 | 57.1961165 | 52.69598320000001 | 2020-08-26 04:28:11 | Udmurt Republic, Russia | ||
1996896 | 1996896 | 2020-08-26 | Russia | Udmurt Republic | 3040 | 45 | 2534 | 461 | 57.1961165 | 52.69598320000001 | 2020-08-27 04:28:15 | Udmurt Republic, Russia | ||
2510436 | 2510436 | 2020-08-27 | Russia | Udmurt Republic | 3062 | 45 | 2561 | 456 | 57.1961165 | 52.69598320000001 | 2020-08-28 04:28:11 | Udmurt Republic, Russia | ||
1523435 | 1523435 | 2020-08-28 | Russia | Udmurt Republic | 3092 | 45 | 2587 | 460 | 57.1961165 | 52.69598320000001 | 2020-08-29 04:28:19 | Udmurt Republic, Russia | ||
609940 | 609940 | 2020-08-29 | Russia | Udmurt Republic | 3123 | 45 | 2611 | 467 | 57.1961165 | 52.69598320000001 | 2020-08-30 04:28:22 | Udmurt Republic, Russia | ||
3932278 | 3932278 | 2020-08-30 | Russia | Udmurt Republic | 3150 | 45 | 2621 | 484 | 57.1961165 | 52.69598320000001 | 2020-08-31 04:28:27 | Udmurt Republic, Russia | ||
194319 | 194319 | 2020-08-31 | Russia | Udmurt Republic | 3179 | 45 | 2621 | 513 | 57.1961165 | 52.69598320000001 | 2020-09-01 04:28:31 | Udmurt Republic, Russia | ||
2060134 | 2060134 | 2020-09-01 | Russia | Udmurt Republic | 3211 | 45 | 2656 | 510 | 57.1961165 | 52.69598320000001 | 2020-09-02 04:28:25 | Udmurt Republic, Russia | ||
1105805 | 1105805 | 2020-09-02 | Russia | Udmurt Republic | 3249 | 45 | 2698 | 506 | 57.1961165 | 52.69598320000001 | 2020-09-03 04:28:22 | Udmurt Republic, Russia | ||
1354568 | 1354568 | 2020-09-03 | Russia | Udmurt Republic | 3294 | 45 | 2715 | 534 | 57.1961165 | 52.69598320000001 | 2020-09-04 04:28:26 | Udmurt Republic, Russia | ||
2662028 | 2662028 | 2020-09-04 | Russia | Udmurt Republic | 3343 | 45 | 2764 | 534 | 57.1961165 | 52.69598320000001 | 2020-09-05 04:28:19 | Udmurt Republic, Russia | ||
813828 | 813828 | 2020-09-05 | Russia | Udmurt Republic | 3392 | 49 | 2788 | 555 | 57.1961165 | 52.69598320000001 | 2020-09-06 04:28:33 | Udmurt Republic, Russia | ||
3161873 | 3161873 | 2020-09-06 | Russia | Udmurt Republic | 3443 | 49 | 2788 | 606 | 57.1961165 | 52.69598320000001 | 2020-09-07 04:28:30 | Udmurt Republic, Russia | ||
427588 | 427588 | 2020-09-07 | Russia | Udmurt Republic | 3491 | 49 | 2788 | 654 | 57.1961165 | 52.69598320000001 | 2020-09-08 04:28:25 | Udmurt Republic, Russia | ||
1244009 | 1244009 | 2020-09-08 | Russia | Udmurt Republic | 3543 | 51 | 2824 | 668 | 57.1961165 | 52.69598320000001 | 2020-09-09 04:28:48 | Udmurt Republic, Russia |
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]);