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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
222189 | 222189 | 2022-05-09 | Russia | Bryansk Oblast | 161343 | 3995 | 0 | 52.8873315 | 33.415853 | 2022-05-10 04:20:50 | Bryansk Oblast, Russia | |||
2331574 | 2331574 | 2022-05-08 | Russia | Bryansk Oblast | 161315 | 3994 | 0 | 52.8873315 | 33.415853 | 2022-05-09 04:20:54 | Bryansk Oblast, Russia | |||
360536 | 360536 | 2022-05-07 | Russia | Bryansk Oblast | 161288 | 3993 | 0 | 52.8873315 | 33.415853 | 2022-05-08 04:20:49 | Bryansk Oblast, Russia | |||
1397887 | 1397887 | 2022-05-06 | Russia | Bryansk Oblast | 161258 | 3990 | 0 | 52.8873315 | 33.415853 | 2022-05-07 04:21:09 | Bryansk Oblast, Russia | |||
2598242 | 2598242 | 2022-05-05 | Russia | Bryansk Oblast | 161225 | 3987 | 0 | 52.8873315 | 33.415853 | 2022-05-06 04:21:00 | Bryansk Oblast, Russia | |||
3265691 | 3265691 | 2022-05-04 | Russia | Bryansk Oblast | 161189 | 3985 | 0 | 52.8873315 | 33.415853 | 2022-05-05 04:20:55 | Bryansk Oblast, Russia | |||
1572330 | 1572330 | 2022-05-03 | Russia | Bryansk Oblast | 161156 | 3982 | 0 | 52.8873315 | 33.415853 | 2022-05-04 04:20:59 | Bryansk Oblast, Russia | |||
463590 | 463590 | 2022-05-02 | Russia | Bryansk Oblast | 161124 | 3979 | 0 | 52.8873315 | 33.415853 | 2022-05-03 04:21:00 | Bryansk Oblast, Russia | |||
3916229 | 3916229 | 2022-05-01 | Russia | Bryansk Oblast | 161089 | 3977 | 0 | 52.8873315 | 33.415853 | 2022-05-02 04:21:10 | Bryansk Oblast, Russia | |||
2841033 | 2841033 | 2022-04-30 | Russia | Bryansk Oblast | 161054 | 3974 | 0 | 52.8873315 | 33.415853 | 2022-05-01 04:20:57 | Bryansk Oblast, Russia | |||
1157346 | 1157346 | 2022-04-29 | Russia | Bryansk Oblast | 161017 | 3970 | 0 | 52.8873315 | 33.415853 | 2022-04-30 04:21:05 | Bryansk Oblast, Russia | |||
1696528 | 1696528 | 2022-04-28 | Russia | Bryansk Oblast | 160977 | 3967 | 0 | 52.8873315 | 33.415853 | 2022-04-29 04:20:59 | Bryansk Oblast, Russia | |||
3852011 | 3852011 | 2022-04-27 | Russia | Bryansk Oblast | 160936 | 3963 | 0 | 52.8873315 | 33.415853 | 2022-04-28 04:20:47 | Bryansk Oblast, Russia | |||
1326441 | 1326441 | 2022-04-26 | Russia | Bryansk Oblast | 160887 | 3960 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-27 04:20:52 | Bryansk Oblast, Russia | |||
3722395 | 3722395 | 2022-04-25 | Russia | Bryansk Oblast | 160833 | 3957 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-26 04:20:51 | Bryansk Oblast, Russia | |||
2028963 | 2028963 | 2022-04-24 | Russia | Bryansk Oblast | 160779 | 3952 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-25 04:20:56 | Bryansk Oblast, Russia | |||
746538 | 746538 | 2022-04-23 | Russia | Bryansk Oblast | 160731 | 3946 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-24 04:20:56 | Bryansk Oblast, Russia | |||
3437023 | 3437023 | 2022-04-22 | Russia | Bryansk Oblast | 160666 | 3942 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-23 04:20:50 | Bryansk Oblast, Russia | |||
2892608 | 2892608 | 2022-04-21 | Russia | Bryansk Oblast | 160596 | 3937 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-22 04:20:45 | Bryansk Oblast, Russia | |||
2307480 | 2307480 | 2022-04-20 | Russia | Bryansk Oblast | 160519 | 3933 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-21 04:20:46 | Bryansk Oblast, Russia | |||
2251619 | 2251619 | 2022-04-19 | Russia | Bryansk Oblast | 160439 | 3931 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-20 04:20:45 | Bryansk Oblast, Russia | |||
1846169 | 1846169 | 2022-04-18 | Russia | Bryansk Oblast | 160354 | 3927 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-19 04:21:00 | Bryansk Oblast, Russia | |||
3417113 | 3417113 | 2022-04-17 | Russia | Bryansk Oblast | 160268 | 3921 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-18 04:21:12 | Bryansk Oblast, Russia | |||
304062 | 304062 | 2022-04-16 | Russia | Bryansk Oblast | 160188 | 3914 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-17 04:20:59 | Bryansk Oblast, Russia | |||
2670007 | 2670007 | 2022-04-15 | Russia | Bryansk Oblast | 160104 | 3908 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-16 04:20:48 | Bryansk Oblast, Russia | |||
1223792 | 1223792 | 2022-04-14 | Russia | Bryansk Oblast | 160010 | 3899 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-15 04:20:57 | Bryansk Oblast, Russia | |||
2442950 | 2442950 | 2022-04-13 | Russia | Bryansk Oblast | 159913 | 3890 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-13 23:21:06 | Bryansk Oblast, Russia | |||
1948707 | 1948707 | 2022-04-12 | Russia | Bryansk Oblast | 159808 | 3880 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-13 04:21:03 | Bryansk Oblast, Russia | |||
3206460 | 3206460 | 2022-04-11 | Russia | Bryansk Oblast | 159705 | 3871 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-12 04:20:49 | Bryansk Oblast, Russia | |||
1576346 | 1576346 | 2022-04-10 | Russia | Bryansk Oblast | 159585 | 3861 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-11 04:21:02 | Bryansk Oblast, Russia | |||
1652588 | 1652588 | 2022-04-09 | Russia | Bryansk Oblast | 159449 | 3851 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-10 04:20:52 | Bryansk Oblast, Russia | |||
2115910 | 2115910 | 2022-04-08 | Russia | Bryansk Oblast | 159328 | 3841 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-09 04:20:42 | Bryansk Oblast, Russia | |||
3320434 | 3320434 | 2022-04-07 | Russia | Bryansk Oblast | 159198 | 3832 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-08 04:20:48 | Bryansk Oblast, Russia | |||
2800970 | 2800970 | 2022-04-06 | Russia | Bryansk Oblast | 159061 | 3825 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-07 04:20:53 | Bryansk Oblast, Russia | |||
3867739 | 3867739 | 2022-04-05 | Russia | Bryansk Oblast | 158906 | 3819 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-06 04:20:49 | Bryansk Oblast, Russia | |||
2749081 | 2749081 | 2022-04-04 | Russia | Bryansk Oblast | 158741 | 3811 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-05 04:20:48 | Bryansk Oblast, Russia | |||
3730427 | 3730427 | 2022-04-03 | Russia | Bryansk Oblast | 158571 | 3805 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-04 04:20:51 | Bryansk Oblast, Russia | |||
499862 | 499862 | 2022-04-02 | Russia | Bryansk Oblast | 158397 | 3795 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-03 04:20:48 | Bryansk Oblast, Russia | |||
3350847 | 3350847 | 2022-04-01 | Russia | Bryansk Oblast | 158189 | 3786 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-02 04:20:47 | Bryansk Oblast, Russia | |||
1540152 | 1540152 | 2022-03-31 | Russia | Bryansk Oblast | 157969 | 3778 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-04-01 04:20:28 | Bryansk Oblast, Russia | |||
2478165 | 2478165 | 2022-03-30 | Russia | Bryansk Oblast | 157764 | 3770 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-31 04:20:56 | Bryansk Oblast, Russia | |||
158206 | 158206 | 2022-03-29 | Russia | Bryansk Oblast | 157486 | 3762 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-30 04:20:45 | Bryansk Oblast, Russia | |||
1436777 | 1436777 | 2022-03-28 | Russia | Bryansk Oblast | 157205 | 3753 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-29 04:20:46 | Bryansk Oblast, Russia | |||
876458 | 876458 | 2022-03-27 | Russia | Bryansk Oblast | 156921 | 3744 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-28 04:20:33 | Bryansk Oblast, Russia | |||
2163741 | 2163741 | 2022-03-26 | Russia | Bryansk Oblast | 156636 | 3734 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-27 04:20:47 | Bryansk Oblast, Russia | |||
1720677 | 1720677 | 2022-03-25 | Russia | Bryansk Oblast | 156346 | 3725 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-26 04:20:23 | Bryansk Oblast, Russia | |||
1468294 | 1468294 | 2022-03-24 | Russia | Bryansk Oblast | 156052 | 3716 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-25 04:20:46 | Bryansk Oblast, Russia | |||
3022468 | 3022468 | 2022-03-23 | Russia | Bryansk Oblast | 155752 | 3706 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-24 04:20:43 | Bryansk Oblast, Russia | |||
1905390 | 1905390 | 2022-03-22 | Russia | Bryansk Oblast | 155440 | 3697 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-23 04:20:48 | Bryansk Oblast, Russia | |||
3238521 | 3238521 | 2022-03-21 | Russia | Bryansk Oblast | 155126 | 3688 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-22 04:20:54 | Bryansk Oblast, Russia | |||
24594 | 24594 | 2022-03-20 | Russia | Bryansk Oblast | 154811 | 3678 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-21 04:20:50 | Bryansk Oblast, Russia | |||
1656604 | 1656604 | 2022-03-19 | Russia | Bryansk Oblast | 154495 | 3670 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-20 04:20:45 | Bryansk Oblast, Russia | |||
336130 | 336130 | 2022-03-18 | Russia | Bryansk Oblast | 154176 | 3662 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-19 04:20:47 | Bryansk Oblast, Russia | |||
694583 | 694583 | 2022-03-17 | Russia | Bryansk Oblast | 153866 | 3652 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-18 04:20:55 | Bryansk Oblast, Russia | |||
2319526 | 2319526 | 2022-03-16 | Russia | Bryansk Oblast | 153556 | 3641 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-17 04:20:56 | Bryansk Oblast, Russia | |||
261726 | 261726 | 2022-03-15 | Russia | Bryansk Oblast | 153236 | 3631 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-16 04:20:50 | Bryansk Oblast, Russia | |||
2264085 | 2264085 | 2022-03-14 | Russia | Bryansk Oblast | 152911 | 3622 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-15 04:20:47 | Bryansk Oblast, Russia | |||
3628151 | 3628151 | 2022-03-13 | Russia | Bryansk Oblast | 152587 | 3613 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-14 04:20:46 | Bryansk Oblast, Russia | |||
951059 | 951059 | 2022-03-12 | Russia | Bryansk Oblast | 152246 | 3603 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-13 04:20:49 | Bryansk Oblast, Russia | |||
356520 | 356520 | 2022-03-11 | Russia | Bryansk Oblast | 151876 | 3595 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-12 04:20:50 | Bryansk Oblast, Russia | |||
1865672 | 1865672 | 2022-03-10 | Russia | Bryansk Oblast | 151441 | 3586 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-11 04:20:50 | Bryansk Oblast, Russia | |||
2140367 | 2140367 | 2022-03-09 | Russia | Bryansk Oblast | 150934 | 3575 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-10 04:20:48 | Bryansk Oblast, Russia | |||
919878 | 919878 | 2022-03-08 | Russia | Bryansk Oblast | 150361 | 3564 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-09 04:20:59 | Bryansk Oblast, Russia | |||
1548165 | 1548165 | 2022-03-07 | Russia | Bryansk Oblast | 149742 | 3553 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-08 04:20:54 | Bryansk Oblast, Russia | |||
2199834 | 2199834 | 2022-03-06 | Russia | Bryansk Oblast | 149065 | 3545 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-07 04:20:47 | Bryansk Oblast, Russia | |||
2092291 | 2092291 | 2022-03-05 | Russia | Bryansk Oblast | 148281 | 3535 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-06 04:20:49 | Bryansk Oblast, Russia | |||
2665991 | 2665991 | 2022-03-04 | Russia | Bryansk Oblast | 147451 | 3524 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-05 04:21:10 | Bryansk Oblast, Russia | |||
1644556 | 1644556 | 2022-03-03 | Russia | Bryansk Oblast | 146594 | 3514 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-04 04:21:09 | Bryansk Oblast, Russia | |||
2525559 | 2525559 | 2022-03-02 | Russia | Bryansk Oblast | 145551 | 3505 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-03 04:21:01 | Bryansk Oblast, Russia | |||
1992853 | 1992853 | 2022-03-01 | Russia | Bryansk Oblast | 144434 | 3494 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-02 04:21:07 | Bryansk Oblast, Russia | |||
943027 | 943027 | 2022-02-28 | Russia | Bryansk Oblast | 143312 | 3483 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-03-01 04:21:09 | Bryansk Oblast, Russia | |||
2733218 | 2733218 | 2022-02-27 | Russia | Bryansk Oblast | 142198 | 3473 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-28 04:21:05 | Bryansk Oblast, Russia | |||
3046371 | 3046371 | 2022-02-26 | Russia | Bryansk Oblast | 141083 | 3461 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-27 04:21:04 | Bryansk Oblast, Russia | |||
575026 | 575026 | 2022-02-25 | Russia | Bryansk Oblast | 139870 | 3451 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-26 04:21:12 | Bryansk Oblast, Russia | |||
1511602 | 1511602 | 2022-02-24 | Russia | Bryansk Oblast | 138603 | 3442 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-25 04:21:11 | Bryansk Oblast, Russia | |||
1058043 | 1058043 | 2022-02-23 | Russia | Bryansk Oblast | 137325 | 3431 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-24 04:21:14 | Bryansk Oblast, Russia | |||
2446966 | 2446966 | 2022-02-22 | Russia | Bryansk Oblast | 136085 | 3421 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-23 04:21:09 | Bryansk Oblast, Russia | |||
3718379 | 3718379 | 2022-02-21 | Russia | Bryansk Oblast | 135286 | 3410 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-22 04:21:01 | Bryansk Oblast, Russia | |||
3912213 | 3912213 | 2022-02-20 | Russia | Bryansk Oblast | 134076 | 3401 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-21 04:21:05 | Bryansk Oblast, Russia | |||
3875771 | 3875771 | 2022-02-19 | Russia | Bryansk Oblast | 132775 | 3392 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-20 04:21:00 | Bryansk Oblast, Russia | |||
3856027 | 3856027 | 2022-02-18 | Russia | Bryansk Oblast | 131319 | 3382 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-19 04:21:11 | Bryansk Oblast, Russia | |||
1298246 | 1298246 | 2022-02-17 | Russia | Bryansk Oblast | 129717 | 3374 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-18 04:21:04 | Bryansk Oblast, Russia | |||
3820632 | 3820632 | 2022-02-16 | Russia | Bryansk Oblast | 128031 | 3365 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-17 04:20:56 | Bryansk Oblast, Russia | |||
3671846 | 3671846 | 2022-02-15 | Russia | Bryansk Oblast | 126334 | 3356 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-16 04:21:10 | Bryansk Oblast, Russia | |||
2641947 | 2641947 | 2022-02-14 | Russia | Bryansk Oblast | 125314 | 3350 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-15 04:21:09 | Bryansk Oblast, Russia | |||
186264 | 186264 | 2022-02-13 | Russia | Bryansk Oblast | 124206 | 3343 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-14 04:20:51 | Bryansk Oblast, Russia | |||
316110 | 316110 | 2022-02-12 | Russia | Bryansk Oblast | 122456 | 3336 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-13 04:21:00 | Bryansk Oblast, Russia | |||
233436 | 233436 | 2022-02-11 | Russia | Bryansk Oblast | 120766 | 3330 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-12 04:21:06 | Bryansk Oblast, Russia | |||
1464278 | 1464278 | 2022-02-10 | Russia | Bryansk Oblast | 118999 | 3324 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-11 04:21:09 | Bryansk Oblast, Russia | |||
3074239 | 3074239 | 2022-02-09 | Russia | Bryansk Oblast | 117237 | 3317 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-10 04:21:14 | Bryansk Oblast, Russia | |||
1362546 | 1362546 | 2022-02-08 | Russia | Bryansk Oblast | 115595 | 3310 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-09 04:21:04 | Bryansk Oblast, Russia | |||
71284 | 71284 | 2022-02-07 | Russia | Bryansk Oblast | 114395 | 3304 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-08 04:21:15 | Bryansk Oblast, Russia | |||
2012900 | 2012900 | 2022-02-06 | Russia | Bryansk Oblast | 112987 | 3299 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-07 04:21:05 | Bryansk Oblast, Russia | |||
1294229 | 1294229 | 2022-02-05 | Russia | Bryansk Oblast | 111379 | 3293 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-06 04:21:00 | Bryansk Oblast, Russia | |||
2327557 | 2327557 | 2022-02-04 | Russia | Bryansk Oblast | 109934 | 3287 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-05 04:21:05 | Bryansk Oblast, Russia | |||
2474148 | 2474148 | 2022-02-03 | Russia | Bryansk Oblast | 108265 | 3281 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-04 04:21:10 | Bryansk Oblast, Russia | |||
459573 | 459573 | 2022-02-02 | Russia | Bryansk Oblast | 106728 | 3275 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-03 04:21:21 | Bryansk Oblast, Russia | |||
979142 | 979142 | 2022-02-01 | Russia | Bryansk Oblast | 105477 | 3261 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-02 04:21:09 | Bryansk Oblast, Russia | |||
2657984 | 2657984 | 2022-01-31 | Russia | Bryansk Oblast | 104377 | 3249 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-01 04:21:11 | Bryansk Oblast, Russia | |||
3300401 | 3300401 | 2022-01-30 | Russia | Bryansk Oblast | 103447 | 3234 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-01-31 04:21:09 | 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]);