johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Mordovia Republic" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805385 | 805385 | 2020-06-01 | Russia | Mordovia Republic | 1931 | 12 | 827 | 1092 | 54.4419829 | 44.4661144 | 2020-06-02 02:33:08 | Mordovia Republic, Russia | ||
2555848 | 2555848 | 2020-06-02 | Russia | Mordovia Republic | 1970 | 13 | 898 | 1059 | 54.4419829 | 44.4661144 | 2020-06-03 02:33:13 | Mordovia Republic, Russia | ||
3866806 | 3866806 | 2020-06-03 | Russia | Mordovia Republic | 2012 | 14 | 954 | 1044 | 54.4419829 | 44.4661144 | 2020-06-04 02:33:14 | Mordovia Republic, Russia | ||
1281251 | 1281251 | 2020-06-04 | Russia | Mordovia Republic | 2051 | 14 | 1016 | 1021 | 54.4419829 | 44.4661144 | 2020-06-05 02:33:06 | Mordovia Republic, Russia | ||
1269779 | 1269779 | 2020-06-05 | Russia | Mordovia Republic | 2098 | 15 | 1064 | 1019 | 54.4419829 | 44.466114399999995 | 2020-06-06 02:33:00 | Mordovia Republic, Russia | ||
574082 | 574082 | 2020-06-06 | Russia | Mordovia Republic | 2138 | 18 | 1111 | 1009 | 54.4419829 | 44.466114399999995 | 2020-06-07 03:53:30 | Mordovia Republic, Russia | ||
2800026 | 2800026 | 2020-06-07 | Russia | Mordovia Republic | 2185 | 18 | 1123 | 1044 | 54.4419829 | 44.466114399999995 | 2020-06-08 03:33:22 | Mordovia Republic, Russia | ||
217230 | 217230 | 2020-06-08 | Russia | Mordovia Republic | 2230 | 18 | 1155 | 1057 | 54.4419829 | 44.466114399999995 | 2020-06-09 03:33:03 | Mordovia Republic, Russia | ||
1210803 | 1210803 | 2020-06-09 | Russia | Mordovia Republic | 2296 | 18 | 1191 | 1087 | 54.4419829 | 44.466114399999995 | 2020-06-10 04:07:00 | Mordovia Republic, Russia | ||
2863971 | 2863971 | 2020-06-10 | Russia | Mordovia Republic | 2360 | 18 | 1225 | 1117 | 54.4419829 | 44.466114399999995 | 2020-06-11 03:33:41 | Mordovia Republic, Russia | ||
1273528 | 1273528 | 2020-06-11 | Russia | Mordovia Republic | 2418 | 20 | 1297 | 1101 | 54.4419829 | 44.4661144 | 2020-06-12 05:09:52 | Mordovia Republic, Russia | ||
737558 | 737558 | 2020-06-12 | Russia | Mordovia Republic | 2480 | 20 | 1327 | 1133 | 54.4419829 | 44.4661144 | 2020-06-13 03:33:14 | Mordovia Republic, Russia | ||
3061238 | 3061238 | 2020-06-13 | Russia | Mordovia Republic | 2538 | 20 | 1351 | 1167 | 54.4419829 | 44.4661144 | 2020-06-14 03:33:15 | Mordovia Republic, Russia | ||
1837186 | 1837186 | 2020-06-14 | Russia | Mordovia Republic | 2596 | 21 | 1470 | 1105 | 54.4419829 | 44.4661144 | 2020-06-15 03:33:14 | Mordovia Republic, Russia | ||
287235 | 287235 | 2020-06-15 | Russia | Mordovia Republic | 2652 | 21 | 1471 | 1160 | 54.4419829 | 44.4661144 | 2020-06-16 04:33:09 | Mordovia Republic, Russia | ||
2386672 | 2386672 | 2020-06-16 | Russia | Mordovia Republic | 2707 | 22 | 1680 | 1005 | 54.4419829 | 44.4661144 | 2020-06-17 04:33:21 | Mordovia Republic, Russia | ||
1195909 | 1195909 | 2020-06-17 | Russia | Mordovia Republic | 2762 | 22 | 1697 | 1043 | 54.4419829 | 44.4661144 | 2020-06-18 04:33:18 | Mordovia Republic, Russia | ||
3682706 | 3682706 | 2020-06-18 | Russia | Mordovia Republic | 2818 | 22 | 1755 | 1041 | 54.4419829 | 44.4661144 | 2020-06-19 04:33:17 | Mordovia Republic, Russia | ||
1691557 | 1691557 | 2020-06-19 | Russia | Mordovia Republic | 2874 | 23 | 1812 | 1039 | 54.4419829 | 44.4661144 | 2020-06-20 04:33:19 | Mordovia Republic, Russia | ||
2437979 | 2437979 | 2020-06-20 | Russia | Mordovia Republic | 2931 | 23 | 1817 | 1091 | 54.4419829 | 44.4661144 | 2020-06-21 04:33:19 | Mordovia Republic, Russia | ||
3249386 | 3249386 | 2020-06-21 | Russia | Mordovia Republic | 2986 | 23 | 1858 | 1105 | 54.4419829 | 44.4661144 | 2020-06-22 04:33:20 | Mordovia Republic, Russia | ||
1510647 | 1510647 | 2020-06-22 | Russia | Mordovia Republic | 3040 | 23 | 1862 | 1155 | 54.4419829 | 44.4661144 | 2020-06-23 04:33:22 | Mordovia Republic, Russia | ||
1522453 | 1522453 | 2020-06-23 | Russia | Mordovia Republic | 3094 | 24 | 1915 | 1155 | 54.4419829 | 44.4661144 | 2020-06-24 04:33:28 | Mordovia Republic, Russia | ||
2700768 | 2700768 | 2020-06-24 | Russia | Mordovia Republic | 3143 | 24 | 2007 | 1112 | 54.4419829 | 44.4661144 | 2020-06-25 05:26:54 | Mordovia Republic, Russia | ||
2625128 | 2625128 | 2020-06-25 | Russia | Mordovia Republic | 3192 | 24 | 2029 | 1139 | 54.4419829 | 44.4661144 | 2020-06-26 04:33:43 | Mordovia Republic, Russia | ||
1136141 | 1136141 | 2020-06-26 | Russia | Mordovia Republic | 3240 | 25 | 2083 | 1132 | 54.4419829 | 44.4661144 | 2020-06-27 04:33:35 | Mordovia Republic, Russia | ||
2039860 | 2039860 | 2020-06-27 | Russia | Mordovia Republic | 3284 | 26 | 2106 | 1152 | 54.4419829 | 44.4661144 | 2020-06-28 04:34:04 | Mordovia Republic, Russia | ||
2306525 | 2306525 | 2020-06-28 | Russia | Mordovia Republic | 3324 | 26 | 2119 | 1179 | 54.4419829 | 44.4661144 | 2020-06-29 04:33:44 | Mordovia Republic, Russia | ||
2632962 | 2632962 | 2020-06-29 | Russia | Mordovia Republic | 3359 | 26 | 2158 | 1175 | 54.4419829 | 44.466114399999995 | 2020-06-30 04:33:48 | Mordovia Republic, Russia | ||
2974485 | 2974485 | 2020-06-30 | Russia | Mordovia Republic | 3394 | 26 | 2200 | 1168 | 54.4419829 | 44.4661144 | 2020-07-01 04:33:52 | Mordovia Republic, Russia | ||
303107 | 303107 | 2020-07-01 | Russia | Mordovia Republic | 3431 | 27 | 2250 | 1154 | 54.4419829 | 44.4661144 | 2020-07-02 04:33:46 | Mordovia Republic, Russia | ||
3045416 | 3045416 | 2020-07-02 | Russia | Mordovia Republic | 3467 | 27 | 2303 | 1137 | 54.4419829 | 44.466114399999995 | 2020-07-03 04:33:54 | Mordovia Republic, Russia | ||
2234622 | 2234622 | 2020-07-03 | Russia | Mordovia Republic | 3505 | 27 | 2370 | 1108 | 54.4419829 | 44.4661144 | 2020-07-04 04:33:51 | Mordovia Republic, Russia | ||
529961 | 529961 | 2020-07-04 | Russia | Mordovia Republic | 3542 | 27 | 2397 | 1118 | 54.4419829 | 44.4661144 | 2020-07-05 04:33:46 | Mordovia Republic, Russia | ||
415399 | 415399 | 2020-07-05 | Russia | Mordovia Republic | 3577 | 27 | 2408 | 1142 | 54.4419829 | 44.4661144 | 2020-07-06 04:33:57 | Mordovia Republic, Russia | ||
2684934 | 2684934 | 2020-07-06 | Russia | Mordovia Republic | 3611 | 27 | 2437 | 1147 | 54.4419829 | 44.4661144 | 2020-07-07 04:34:00 | Mordovia Republic, Russia | ||
887374 | 887374 | 2020-07-07 | Russia | Mordovia Republic | 3646 | 27 | 2495 | 1124 | 54.4419829 | 44.4661144 | 2020-07-08 05:33:48 | Mordovia Republic, Russia | ||
2222765 | 2222765 | 2020-07-08 | Russia | Mordovia Republic | 3680 | 27 | 2559 | 1094 | 54.4419829 | 44.4661144 | 2020-07-09 04:34:23 | Mordovia Republic, Russia | ||
1005549 | 1005549 | 2020-07-09 | Russia | Mordovia Republic | 3717 | 28 | 2605 | 1084 | 54.4419829 | 44.4661144 | 2020-07-10 04:34:24 | Mordovia Republic, Russia | ||
3237564 | 3237564 | 2020-07-10 | Russia | Mordovia Republic | 3755 | 28 | 2660 | 1067 | 54.4419829 | 44.4661144 | 2020-07-11 04:34:26 | Mordovia Republic, Russia | ||
3436066 | 3436066 | 2020-07-11 | Russia | Mordovia Republic | 3792 | 28 | 2708 | 1056 | 54.4419829 | 44.4661144 | 2020-07-12 04:34:30 | Mordovia Republic, Russia | ||
3737671 | 3737671 | 2020-07-12 | Russia | Mordovia Republic | 3829 | 29 | 2741 | 1059 | 54.4419829 | 44.4661144 | 2020-07-13 04:43:04 | Mordovia Republic, Russia | ||
3491408 | 3491408 | 2020-07-13 | Russia | Mordovia Republic | 3865 | 29 | 2755 | 1081 | 54.4419829 | 44.4661144 | 2020-07-14 04:34:46 | Mordovia Republic, Russia | ||
2158767 | 2158767 | 2020-07-14 | Russia | Mordovia Republic | 3901 | 29 | 2799 | 1073 | 54.4419829 | 44.4661144 | 2020-07-15 04:34:39 | Mordovia Republic, Russia | ||
2748123 | 2748123 | 2020-07-15 | Russia | Mordovia Republic | 3938 | 29 | 2847 | 1062 | 54.4419829 | 44.466114399999995 | 2020-07-16 04:44:59 | Mordovia Republic, Russia | ||
367455 | 367455 | 2020-07-16 | Russia | Mordovia Republic | 3976 | 30 | 2887 | 1059 | 54.4419829 | 44.466114399999995 | 2020-07-17 04:34:50 | Mordovia Republic, Russia | ||
2708642 | 2708642 | 2020-07-17 | Russia | Mordovia Republic | 4014 | 30 | 2926 | 1058 | 54.4419829 | 44.4661144 | 2020-07-18 04:34:45 | Mordovia Republic, Russia | ||
3205341 | 3205341 | 2020-07-18 | Russia | Mordovia Republic | 4051 | 32 | 2950 | 1069 | 54.4419829 | 44.4661144 | 2020-07-19 04:34:58 | Mordovia Republic, Russia | ||
121952 | 121952 | 2020-07-19 | Russia | Mordovia Republic | 4086 | 32 | 2973 | 1081 | 54.4419829 | 44.4661144 | 2020-07-20 05:34:40 | Mordovia Republic, Russia | ||
327047 | 327047 | 2020-07-20 | Russia | Mordovia Republic | 4121 | 32 | 2990 | 1099 | 54.4419829 | 44.4661144 | 2020-07-21 04:38:46 | Mordovia Republic, Russia | ||
1707556 | 1707556 | 2020-07-21 | Russia | Mordovia Republic | 4157 | 32 | 3046 | 1079 | 54.4419829 | 44.4661144 | 2020-07-22 04:34:42 | Mordovia Republic, Russia | ||
844817 | 844817 | 2020-07-22 | Russia | Mordovia Republic | 4192 | 32 | 3087 | 1073 | 54.4419829 | 44.466114399999995 | 2020-07-23 05:15:04 | Mordovia Republic, Russia | ||
62013 | 62013 | 2020-07-23 | Russia | Mordovia Republic | 4227 | 32 | 3132 | 1063 | 54.4419829 | 44.466114399999995 | 2020-07-24 05:30:40 | Mordovia Republic, Russia | ||
2563797 | 2563797 | 2020-07-24 | Russia | Mordovia Republic | 4261 | 32 | 3173 | 1056 | 54.4419829 | 44.466114399999995 | 2020-07-25 04:47:39 | Mordovia Republic, Russia | ||
1502827 | 1502827 | 2020-07-25 | Russia | Mordovia Republic | 4295 | 33 | 3213 | 1049 | 54.4419829 | 44.466114399999995 | 2020-07-26 04:35:00 | Mordovia Republic, Russia | ||
442583 | 442583 | 2020-07-26 | Russia | Mordovia Republic | 4328 | 33 | 3237 | 1058 | 54.4419829 | 44.466114399999995 | 2020-07-27 04:35:02 | Mordovia Republic, Russia | ||
177270 | 177270 | 2020-07-27 | Russia | Mordovia Republic | 4360 | 33 | 3270 | 1057 | 54.4419829 | 44.466114399999995 | 2020-07-28 04:58:43 | Mordovia Republic, Russia | ||
3185219 | 3185219 | 2020-07-28 | Russia | Mordovia Republic | 4392 | 34 | 3309 | 1049 | 54.4419829 | 44.466114399999995 | 2020-07-29 04:35:11 | Mordovia Republic, Russia | ||
2958603 | 2958603 | 2020-07-29 | Russia | Mordovia Republic | 4424 | 34 | 3348 | 1042 | 54.4419829 | 44.466114399999995 | 2020-07-30 04:35:05 | Mordovia Republic, Russia | ||
1928435 | 1928435 | 2020-07-30 | Russia | Mordovia Republic | 4457 | 34 | 3389 | 1034 | 54.4419829 | 44.466114399999995 | 2020-07-31 04:35:18 | Mordovia Republic, Russia | ||
3264728 | 3264728 | 2020-07-31 | Russia | Mordovia Republic | 4490 | 34 | 3429 | 1027 | 54.4419829 | 44.466114399999995 | 2020-08-01 04:36:27 | Mordovia Republic, Russia | ||
753563 | 753563 | 2020-08-01 | Russia | Mordovia Republic | 4522 | 38 | 3474 | 1010 | 54.4419829 | 44.466114399999995 | 2020-08-02 04:34:47 | Mordovia Republic, Russia | ||
2807995 | 2807995 | 2020-08-02 | Russia | Mordovia Republic | 4553 | 38 | 3478 | 1037 | 54.4419829 | 44.466114399999995 | 2020-08-03 04:34:35 | Mordovia Republic, Russia | ||
2740243 | 2740243 | 2020-08-03 | Russia | Mordovia Republic | 4585 | 38 | 3502 | 1045 | 54.4419829 | 44.466114399999995 | 2020-08-04 04:41:59 | Mordovia Republic, Russia | ||
98360 | 98360 | 2020-08-04 | Russia | Mordovia Republic | 4616 | 38 | 3542 | 1036 | 54.4419829 | 44.466114399999995 | 2020-08-05 04:34:43 | Mordovia Republic, Russia | ||
3793124 | 3793124 | 2020-08-05 | Russia | Mordovia Republic | 4647 | 38 | 3574 | 1035 | 54.4419829 | 44.466114399999995 | 2020-08-06 04:35:02 | Mordovia Republic, Russia | ||
3612294 | 3612294 | 2020-08-06 | Russia | Mordovia Republic | 4679 | 38 | 3606 | 1035 | 54.4419829 | 44.466114399999995 | 2020-08-07 04:35:11 | Mordovia Republic, Russia | ||
458609 | 458609 | 2020-08-07 | Russia | Mordovia Republic | 4709 | 38 | 3627 | 1044 | 54.4419829 | 44.466114399999995 | 2020-08-08 04:34:53 | Mordovia Republic, Russia | ||
371425 | 371425 | 2020-08-08 | Russia | Mordovia Republic | 4739 | 38 | 3642 | 1059 | 54.4419829 | 44.466114399999995 | 2020-08-09 04:34:54 | Mordovia Republic, Russia | ||
3923257 | 3923257 | 2020-08-09 | Russia | Mordovia Republic | 4768 | 38 | 3671 | 1059 | 54.4419829 | 44.466114399999995 | 2020-08-10 04:34:55 | Mordovia Republic, Russia | ||
1920448 | 1920448 | 2020-08-10 | Russia | Mordovia Republic | 4798 | 38 | 3697 | 1063 | 54.4419829 | 44.466114399999995 | 2020-08-11 04:35:08 | Mordovia Republic, Russia | ||
662518 | 662518 | 2020-08-11 | Russia | Mordovia Republic | 4828 | 38 | 3713 | 1077 | 54.4419829 | 44.4661144 | 2020-08-12 04:27:29 | Mordovia Republic, Russia | ||
3531669 | 3531669 | 2020-08-12 | Russia | Mordovia Republic | 4857 | 38 | 3737 | 1082 | 54.4419829 | 44.4661144 | 2020-08-13 04:29:15 | Mordovia Republic, Russia | ||
583050 | 583050 | 2020-08-13 | Russia | Mordovia Republic | 4888 | 38 | 3768 | 1082 | 54.4419829 | 44.4661144 | 2020-08-14 04:51:19 | Mordovia Republic, Russia | ||
1612466 | 1612466 | 2020-08-14 | Russia | Mordovia Republic | 4920 | 38 | 3809 | 1073 | 54.4419829 | 44.4661144 | 2020-08-15 04:27:31 | Mordovia Republic, Russia | ||
146191 | 146191 | 2020-08-15 | Russia | Mordovia Republic | 4952 | 38 | 3827 | 1087 | 54.4419829 | 44.4661144 | 2020-08-16 04:27:42 | Mordovia Republic, Russia | ||
1556189 | 1556189 | 2020-08-16 | Russia | Mordovia Republic | 4983 | 38 | 3877 | 1068 | 54.4419829 | 44.4661144 | 2020-08-17 04:27:20 | Mordovia Republic, Russia | ||
837831 | 837831 | 2020-08-17 | Russia | Mordovia Republic | 5015 | 38 | 3901 | 1076 | 54.4419829 | 44.4661144 | 2020-08-18 04:27:56 | Mordovia Republic, Russia | ||
3178227 | 3178227 | 2020-08-18 | Russia | Mordovia Republic | 5047 | 38 | 3916 | 1093 | 54.4419829 | 44.4661144 | 2020-08-19 04:27:00 | Mordovia Republic, Russia | ||
206473 | 206473 | 2020-08-19 | Russia | Mordovia Republic | 5078 | 38 | 3952 | 1088 | 54.4419829 | 44.4661144 | 2020-08-20 04:27:43 | Mordovia Republic, Russia | ||
3484524 | 3484524 | 2020-08-20 | Russia | Mordovia Republic | 5109 | 38 | 3987 | 1084 | 54.4419829 | 44.4661144 | 2020-08-21 04:27:41 | Mordovia Republic, Russia | ||
1479775 | 1479775 | 2020-08-21 | Russia | Mordovia Republic | 5141 | 38 | 4028 | 1075 | 54.4419829 | 44.4661144 | 2020-08-22 04:27:49 | Mordovia Republic, Russia | ||
2299668 | 2299668 | 2020-08-22 | Russia | Mordovia Republic | 5174 | 38 | 4062 | 1074 | 54.4419829 | 44.4661144 | 2020-08-23 04:27:48 | Mordovia Republic, Russia | ||
2215886 | 2215886 | 2020-08-23 | Russia | Mordovia Republic | 5207 | 38 | 4093 | 1076 | 54.4419829 | 44.4661144 | 2020-08-24 04:27:56 | Mordovia Republic, Russia | ||
2991491 | 2991491 | 2020-08-24 | Russia | Mordovia Republic | 5238 | 38 | 4099 | 1101 | 54.4419829 | 44.4661144 | 2020-08-25 04:28:02 | Mordovia Republic, Russia | ||
3562787 | 3562787 | 2020-08-25 | Russia | Mordovia Republic | 5269 | 38 | 4139 | 1092 | 54.4419829 | 44.4661144 | 2020-08-26 04:28:11 | Mordovia Republic, Russia | ||
1996863 | 1996863 | 2020-08-26 | Russia | Mordovia Republic | 5301 | 38 | 4165 | 1098 | 54.4419829 | 44.4661144 | 2020-08-27 04:28:15 | Mordovia Republic, Russia | ||
2510403 | 2510403 | 2020-08-27 | Russia | Mordovia Republic | 5334 | 38 | 4192 | 1104 | 54.4419829 | 44.4661144 | 2020-08-28 04:28:11 | Mordovia Republic, Russia | ||
1523402 | 1523402 | 2020-08-28 | Russia | Mordovia Republic | 5367 | 38 | 4218 | 1111 | 54.4419829 | 44.4661144 | 2020-08-29 04:28:19 | Mordovia Republic, Russia | ||
609907 | 609907 | 2020-08-29 | Russia | Mordovia Republic | 5399 | 38 | 4239 | 1122 | 54.4419829 | 44.4661144 | 2020-08-30 04:28:22 | Mordovia Republic, Russia | ||
3932245 | 3932245 | 2020-08-30 | Russia | Mordovia Republic | 5430 | 38 | 4263 | 1129 | 54.4419829 | 44.4661144 | 2020-08-31 04:28:27 | Mordovia Republic, Russia | ||
194286 | 194286 | 2020-08-31 | Russia | Mordovia Republic | 5462 | 38 | 4287 | 1137 | 54.4419829 | 44.4661144 | 2020-09-01 04:28:31 | Mordovia Republic, Russia | ||
2060101 | 2060101 | 2020-09-01 | Russia | Mordovia Republic | 5493 | 38 | 4310 | 1145 | 54.4419829 | 44.4661144 | 2020-09-02 04:28:25 | Mordovia Republic, Russia | ||
1105772 | 1105772 | 2020-09-02 | Russia | Mordovia Republic | 5524 | 38 | 4330 | 1156 | 54.4419829 | 44.4661144 | 2020-09-03 04:28:22 | Mordovia Republic, Russia | ||
1354535 | 1354535 | 2020-09-03 | Russia | Mordovia Republic | 5556 | 38 | 4365 | 1153 | 54.4419829 | 44.4661144 | 2020-09-04 04:28:26 | Mordovia Republic, Russia | ||
2661995 | 2661995 | 2020-09-04 | Russia | Mordovia Republic | 5587 | 38 | 4403 | 1146 | 54.4419829 | 44.4661144 | 2020-09-05 04:28:19 | Mordovia Republic, Russia | ||
813795 | 813795 | 2020-09-05 | Russia | Mordovia Republic | 5620 | 38 | 4433 | 1149 | 54.4419829 | 44.4661144 | 2020-09-06 04:28:33 | Mordovia Republic, Russia | ||
3161840 | 3161840 | 2020-09-06 | Russia | Mordovia Republic | 5652 | 38 | 4476 | 1138 | 54.4419829 | 44.4661144 | 2020-09-07 04:28:30 | Mordovia Republic, Russia | ||
427555 | 427555 | 2020-09-07 | Russia | Mordovia Republic | 5683 | 38 | 4522 | 1123 | 54.4419829 | 44.4661144 | 2020-09-08 04:28:25 | Mordovia Republic, Russia | ||
1243976 | 1243976 | 2020-09-08 | Russia | Mordovia Republic | 5714 | 38 | 4562 | 1114 | 54.4419829 | 44.4661144 | 2020-09-09 04:28:48 | Mordovia 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]);