johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Russia" and province_or_state = "Bryansk Oblast" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
654189 | 654189 | 2021-10-22 | Russia | Bryansk Oblast | 72194 | 1720 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-23 04:21:32 | Bryansk Oblast, Russia | |||
2123936 | 2123936 | 2021-10-21 | Russia | Bryansk Oblast | 71805 | 1704 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-22 04:21:14 | Bryansk Oblast, Russia | |||
443548 | 443548 | 2021-10-20 | Russia | Bryansk Oblast | 71428 | 1689 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-21 04:21:18 | Bryansk Oblast, Russia | |||
597867 | 597867 | 2021-10-19 | Russia | Bryansk Oblast | 71059 | 1674 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-20 04:21:00 | Bryansk Oblast, Russia | |||
2044044 | 2044044 | 2021-10-18 | Russia | Bryansk Oblast | 70702 | 1660 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-19 04:20:54 | Bryansk Oblast, Russia | |||
1909405 | 1909405 | 2021-10-17 | Russia | Bryansk Oblast | 70353 | 1649 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-18 04:21:10 | Bryansk Oblast, Russia | |||
934994 | 934994 | 2021-10-16 | Russia | Bryansk Oblast | 70009 | 1639 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-17 04:21:29 | Bryansk Oblast, Russia | |||
2943549 | 2943549 | 2021-10-15 | Russia | Bryansk Oblast | 69677 | 1627 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-16 04:21:15 | Bryansk Oblast, Russia | |||
491829 | 491829 | 2021-10-14 | Russia | Bryansk Oblast | 69355 | 1614 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-15 04:21:26 | Bryansk Oblast, Russia | |||
634117 | 634117 | 2021-10-13 | Russia | Bryansk Oblast | 69040 | 1601 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-14 04:21:29 | Bryansk Oblast, Russia | |||
1491795 | 1491795 | 2021-10-12 | Russia | Bryansk Oblast | 68730 | 1589 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-13 04:20:51 | Bryansk Oblast, Russia | |||
3007528 | 3007528 | 2021-10-11 | Russia | Bryansk Oblast | 68427 | 1577 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-12 04:21:09 | Bryansk Oblast, Russia | |||
423544 | 423544 | 2021-10-10 | Russia | Bryansk Oblast | 68128 | 1565 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-11 04:21:31 | Bryansk Oblast, Russia | |||
2876401 | 2876401 | 2021-10-09 | Russia | Bryansk Oblast | 67831 | 1551 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-10 04:21:38 | Bryansk Oblast, Russia | |||
2959567 | 2959567 | 2021-10-08 | Russia | Bryansk Oblast | 67540 | 1538 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-09 04:21:34 | Bryansk Oblast, Russia | |||
467605 | 467605 | 2021-10-07 | Russia | Bryansk Oblast | 67260 | 1528 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-08 04:21:25 | Bryansk Oblast, Russia | |||
2458985 | 2458985 | 2021-10-06 | Russia | Bryansk Oblast | 66985 | 1515 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-07 04:21:36 | Bryansk Oblast, Russia | |||
3832679 | 3832679 | 2021-10-05 | Russia | Bryansk Oblast | 66721 | 1503 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-06 04:21:33 | Bryansk Oblast, Russia | |||
987172 | 987172 | 2021-10-04 | Russia | Bryansk Oblast | 66461 | 1492 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-05 04:21:27 | Bryansk Oblast, Russia | |||
1274482 | 1274482 | 2021-10-03 | Russia | Bryansk Oblast | 66212 | 1479 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-04 04:21:31 | Bryansk Oblast, Russia | |||
3928235 | 3928235 | 2021-10-02 | Russia | Bryansk Oblast | 65977 | 1465 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-03 04:21:24 | Bryansk Oblast, Russia | |||
2132215 | 2132215 | 2021-10-01 | Russia | Bryansk Oblast | 65750 | 1454 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-02 04:21:25 | Bryansk Oblast, Russia | |||
2773172 | 2773172 | 2021-09-30 | Russia | Bryansk Oblast | 65531 | 1442 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-01 04:21:35 | Bryansk Oblast, Russia | |||
706628 | 706628 | 2021-09-29 | Russia | Bryansk Oblast | 65321 | 1432 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-30 04:21:20 | Bryansk Oblast, Russia | |||
1334470 | 1334470 | 2021-09-28 | Russia | Bryansk Oblast | 65125 | 1424 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-29 04:21:45 | Bryansk Oblast, Russia | |||
1235839 | 1235839 | 2021-09-27 | Russia | Bryansk Oblast | 64932 | 1418 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-28 04:21:28 | Bryansk Oblast, Russia | |||
2076140 | 2076140 | 2021-09-26 | Russia | Bryansk Oblast | 64738 | 1413 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-27 04:21:16 | Bryansk Oblast, Russia | |||
1724692 | 1724692 | 2021-09-25 | Russia | Bryansk Oblast | 64549 | 1399 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-26 04:21:29 | Bryansk Oblast, Russia | |||
1921412 | 1921412 | 2021-09-24 | Russia | Bryansk Oblast | 64367 | 1386 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-25 04:21:31 | Bryansk Oblast, Russia | |||
601883 | 601883 | 2021-09-23 | Russia | Bryansk Oblast | 64192 | 1373 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-24 04:21:44 | Bryansk Oblast, Russia | |||
3011527 | 3011527 | 2021-09-22 | Russia | Bryansk Oblast | 64023 | 1360 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-23 04:21:43 | Bryansk Oblast, Russia | |||
3757665 | 3757665 | 2021-09-21 | Russia | Bryansk Oblast | 63853 | 1350 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-22 04:21:45 | Bryansk Oblast, Russia | |||
809768 | 809768 | 2021-09-20 | Russia | Bryansk Oblast | 63685 | 1339 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-21 04:21:26 | Bryansk Oblast, Russia | |||
1814967 | 1814967 | 2021-09-19 | Russia | Bryansk Oblast | 63518 | 1327 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-20 04:21:22 | Bryansk Oblast, Russia | |||
16547 | 16547 | 2021-09-18 | Russia | Bryansk Oblast | 63358 | 1316 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-19 04:21:34 | Bryansk Oblast, Russia | |||
2618232 | 2618232 | 2021-09-17 | Russia | Bryansk Oblast | 63200 | 1306 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-18 04:21:24 | Bryansk Oblast, Russia | |||
2808940 | 2808940 | 2021-09-16 | Russia | Bryansk Oblast | 63049 | 1297 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-17 04:21:46 | Bryansk Oblast, Russia | |||
1374685 | 1374685 | 2021-09-15 | Russia | Bryansk Oblast | 62899 | 1286 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-16 04:22:19 | Bryansk Oblast, Russia | |||
2462984 | 2462984 | 2021-09-14 | Russia | Bryansk Oblast | 62747 | 1275 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-15 03:22:37 | Bryansk Oblast, Russia | |||
1385823 | 1385823 | 2021-09-13 | Russia | Bryansk Oblast | 62596 | 1265 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-14 04:21:41 | Bryansk Oblast, Russia | |||
1885192 | 1885192 | 2021-09-12 | Russia | Bryansk Oblast | 62441 | 1256 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-13 04:21:15 | Bryansk Oblast, Russia | |||
3806095 | 3806095 | 2021-09-11 | Russia | Bryansk Oblast | 62288 | 1246 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-12 04:21:13 | Bryansk Oblast, Russia | |||
3449035 | 3449035 | 2021-09-10 | Russia | Bryansk Oblast | 62134 | 1235 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-11 04:21:30 | Bryansk Oblast, Russia | |||
1262981 | 1262981 | 2021-09-09 | Russia | Bryansk Oblast | 61983 | 1226 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-10 04:21:20 | Bryansk Oblast, Russia | |||
2279351 | 2279351 | 2021-09-08 | Russia | Bryansk Oblast | 61835 | 1214 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-09 04:21:27 | Bryansk Oblast, Russia | |||
642130 | 642130 | 2021-09-07 | Russia | Bryansk Oblast | 61685 | 1204 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-08 04:21:31 | Bryansk Oblast, Russia | |||
3194193 | 3194193 | 2021-09-06 | Russia | Bryansk Oblast | 61534 | 1192 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-07 04:21:35 | Bryansk Oblast, Russia | |||
3281061 | 3281061 | 2021-09-05 | Russia | Bryansk Oblast | 61377 | 1181 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-06 04:21:22 | Bryansk Oblast, Russia | |||
249475 | 249475 | 2021-09-04 | Russia | Bryansk Oblast | 61221 | 1168 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-05 04:21:33 | Bryansk Oblast, Russia | |||
3974756 | 3974756 | 2021-09-03 | Russia | Bryansk Oblast | 61064 | 1158 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-04 04:21:28 | Bryansk Oblast, Russia | |||
178218 | 178218 | 2021-09-02 | Russia | Bryansk Oblast | 60905 | 1145 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-03 04:21:20 | Bryansk Oblast, Russia | |||
67253 | 67253 | 2021-09-01 | Russia | Bryansk Oblast | 60743 | 1135 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-02 04:21:15 | Bryansk Oblast, Russia | |||
2068095 | 2068095 | 2021-08-31 | Russia | Bryansk Oblast | 60576 | 1125 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-09-01 04:21:38 | Bryansk Oblast, Russia | |||
1775549 | 1775549 | 2021-08-30 | Russia | Bryansk Oblast | 60408 | 1112 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-31 04:21:46 | Bryansk Oblast, Russia | |||
3892123 | 3892123 | 2021-08-29 | Russia | Bryansk Oblast | 60241 | 1100 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-30 04:21:23 | Bryansk Oblast, Russia | |||
2793226 | 2793226 | 2021-08-28 | Russia | Bryansk Oblast | 60072 | 1088 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-29 04:21:14 | Bryansk Oblast, Russia | |||
2923385 | 2923385 | 2021-08-27 | Russia | Bryansk Oblast | 59905 | 1080 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-28 04:21:28 | Bryansk Oblast, Russia | |||
1596399 | 1596399 | 2021-08-26 | Russia | Bryansk Oblast | 59735 | 1069 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-27 04:21:37 | Bryansk Oblast, Russia | |||
32608 | 32608 | 2021-08-25 | Russia | Bryansk Oblast | 59557 | 1058 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-26 04:21:28 | Bryansk Oblast, Russia | |||
3105647 | 3105647 | 2021-08-24 | Russia | Bryansk Oblast | 59374 | 1044 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-25 04:21:41 | Bryansk Oblast, Russia | |||
3165818 | 3165818 | 2021-08-23 | Russia | Bryansk Oblast | 59195 | 1031 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-24 04:21:19 | Bryansk Oblast, Russia | |||
2175745 | 2175745 | 2021-08-22 | Russia | Bryansk Oblast | 59015 | 1019 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-23 04:21:27 | Bryansk Oblast, Russia | |||
3555841 | 3555841 | 2021-08-21 | Russia | Bryansk Oblast | 58832 | 1006 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-22 04:21:29 | Bryansk Oblast, Russia | |||
1854183 | 1854183 | 2021-08-20 | Russia | Bryansk Oblast | 58641 | 994 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-21 04:21:38 | Bryansk Oblast, Russia | |||
511890 | 511890 | 2021-08-19 | Russia | Bryansk Oblast | 58447 | 981 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-20 04:21:33 | Bryansk Oblast, Russia | |||
2518369 | 2518369 | 2021-08-18 | Russia | Bryansk Oblast | 58247 | 968 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-19 04:21:15 | Bryansk Oblast, Russia | |||
245461 | 245461 | 2021-08-17 | Russia | Bryansk Oblast | 58046 | 956 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-18 04:21:35 | Bryansk Oblast, Russia | |||
1604424 | 1604424 | 2021-08-16 | Russia | Bryansk Oblast | 57839 | 945 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-17 04:21:49 | Bryansk Oblast, Russia | |||
103518 | 103518 | 2021-08-15 | Russia | Bryansk Oblast | 57629 | 934 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-16 04:21:31 | Bryansk Oblast, Russia | |||
507876 | 507876 | 2021-08-14 | Russia | Bryansk Oblast | 57414 | 924 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-15 04:21:41 | Bryansk Oblast, Russia | |||
1483748 | 1483748 | 2021-08-13 | Russia | Bryansk Oblast | 57197 | 915 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-14 04:21:25 | Bryansk Oblast, Russia | |||
2899878 | 2899878 | 2021-08-12 | Russia | Bryansk Oblast | 56977 | 907 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-13 04:21:24 | Bryansk Oblast, Russia | |||
1342482 | 1342482 | 2021-08-11 | Russia | Bryansk Oblast | 56753 | 896 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-12 04:21:25 | Bryansk Oblast, Russia | |||
2351629 | 2351629 | 2021-08-10 | Russia | Bryansk Oblast | 56524 | 886 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-11 04:21:58 | Bryansk Oblast, Russia | |||
650158 | 650158 | 2021-08-09 | Russia | Bryansk Oblast | 56296 | 876 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-08-10 04:21:27 | Bryansk Oblast, Russia | |||
589820 | 589820 | 2021-08-08 | Russia | Bryansk Oblast | 56064 | 868 | 0 | 52.8873315 | 33.41585300000001 | 2021-08-09 04:21:24 | Bryansk Oblast, Russia | |||
2203832 | 2203832 | 2021-08-07 | Russia | Bryansk Oblast | 55834 | 859 | 0 | 52.8873315 | 33.41585300000001 | 2021-08-08 04:21:33 | Bryansk Oblast, Russia | |||
1117782 | 1117782 | 2021-08-06 | Russia | Bryansk Oblast | 55599 | 851 | 0 | 52.8873315 | 33.41585300000001 | 2021-08-07 04:21:30 | Bryansk Oblast, Russia | |||
1956719 | 1956719 | 2021-08-05 | Russia | Bryansk Oblast | 55358 | 842 | 0 | 52.8873315 | 33.41585300000001 | 2021-08-06 04:21:18 | Bryansk Oblast, Russia | |||
332098 | 332098 | 2021-08-04 | Russia | Bryansk Oblast | 55115 | 832 | 50001 | 4282 | 52.8873315 | 33.41585300000001 | 2021-08-05 04:21:51 | Bryansk Oblast, Russia | ||
3468369 | 3468369 | 2021-08-03 | Russia | Bryansk Oblast | 54865 | 824 | 49788 | 4253 | 52.8873315 | 33.41585300000001 | 2021-08-04 04:21:25 | Bryansk Oblast, Russia | ||
3683643 | 3683643 | 2021-08-02 | Russia | Bryansk Oblast | 54613 | 817 | 49593 | 4203 | 52.8873315 | 33.41585300000001 | 2021-08-03 04:21:39 | Bryansk Oblast, Russia | ||
3015542 | 3015542 | 2021-08-01 | Russia | Bryansk Oblast | 54362 | 808 | 49398 | 4156 | 52.8873315 | 33.41585300000001 | 2021-08-02 04:21:36 | Bryansk Oblast, Russia | ||
3904165 | 3904165 | 2021-07-31 | Russia | Bryansk Oblast | 54108 | 801 | 49145 | 4162 | 52.8873315 | 33.41585300000001 | 2021-08-01 04:21:50 | Bryansk Oblast, Russia | ||
3296370 | 3296370 | 2021-07-30 | Russia | Bryansk Oblast | 53846 | 792 | 48896 | 4158 | 52.8873315 | 33.41585300000001 | 2021-07-31 04:21:35 | Bryansk Oblast, Russia | ||
3385581 | 3385581 | 2021-07-29 | Russia | Bryansk Oblast | 53587 | 782 | 48610 | 4195 | 52.8873315 | 33.41585300000001 | 2021-07-30 04:21:34 | Bryansk Oblast, Russia | ||
408486 | 408486 | 2021-07-28 | Russia | Bryansk Oblast | 53322 | 773 | 48404 | 4145 | 52.8873315 | 33.41585300000001 | 2021-07-29 04:21:33 | Bryansk Oblast, Russia | ||
1306347 | 1306347 | 2021-07-27 | Russia | Bryansk Oblast | 53040 | 763 | 48120 | 4157 | 52.8873315 | 33.41585300000001 | 2021-07-28 04:21:39 | Bryansk Oblast, Russia | ||
3218490 | 3218490 | 2021-07-26 | Russia | Bryansk Oblast | 52747 | 751 | 47906 | 4090 | 52.8873315 | 33.41585300000001 | 2021-07-27 04:21:18 | Bryansk Oblast, Russia | ||
1378699 | 1378699 | 2021-07-25 | Russia | Bryansk Oblast | 52448 | 740 | 47679 | 4029 | 52.8873315 | 33.41585300000001 | 2021-07-26 04:21:28 | Bryansk Oblast, Russia | ||
1330439 | 1330439 | 2021-07-24 | Russia | Bryansk Oblast | 52151 | 730 | 47301 | 4120 | 52.8873315 | 33.41585300000001 | 2021-07-25 04:22:12 | Bryansk Oblast, Russia | ||
3137743 | 3137743 | 2021-07-23 | Russia | Bryansk Oblast | 51853 | 719 | 46948 | 4186 | 52.8873315 | 33.41585300000001 | 2021-07-24 00:21:36 | Bryansk Oblast, Russia | ||
3476503 | 3476503 | 2021-07-22 | Russia | Bryansk Oblast | 51553 | 709 | 46650 | 4194 | 52.8873315 | 33.41585300000001 | 2021-07-23 04:21:29 | Bryansk Oblast, Russia | ||
3331722 | 3331722 | 2021-07-21 | Russia | Bryansk Oblast | 51250 | 701 | 46413 | 4136 | 52.8873315 | 33.41585300000001 | 2021-07-22 04:21:19 | Bryansk Oblast, Russia | ||
2371703 | 2371703 | 2021-07-20 | Russia | Bryansk Oblast | 50937 | 694 | 46201 | 4042 | 52.8873315 | 33.41585300000001 | 2021-07-21 04:21:40 | Bryansk Oblast, Russia | ||
483782 | 483782 | 2021-07-19 | Russia | Bryansk Oblast | 50627 | 688 | 46058 | 3881 | 52.8873315 | 33.41585300000001 | 2021-07-20 04:21:48 | Bryansk Oblast, Russia | ||
2674005 | 2674005 | 2021-07-18 | Russia | Bryansk Oblast | 50319 | 679 | 45803 | 3837 | 52.8873315 | 33.41585300000001 | 2021-07-19 04:21:24 | Bryansk Oblast, Russia | ||
3706317 | 3706317 | 2021-07-17 | Russia | Bryansk Oblast | 50009 | 672 | 45421 | 3916 | 52.8873315 | 33.41585300000001 | 2021-07-18 04:22:07 | Bryansk Oblast, Russia | ||
2947548 | 2947548 | 2021-07-16 | Russia | Bryansk Oblast | 49698 | 663 | 45212 | 3823 | 52.8873315 | 33.41585300000001 | 2021-07-17 04:22:22 | Bryansk Oblast, Russia | ||
296204 | 296204 | 2021-07-15 | Russia | Bryansk Oblast | 49381 | 655 | 44947 | 3779 | 52.8873315 | 33.41585300000001 | 2021-07-16 04:21:22 | Bryansk Oblast, 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]);