johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
681 rows where latitude = "54.42267320000001" and province_or_state = "Ryazan Oblast" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1326491 | 1326491 | 2022-04-26 | Russia | Ryazan Oblast | 119135 | 3356 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-27 04:20:52 | Ryazan Oblast, Russia | |||
3722445 | 3722445 | 2022-04-25 | Russia | Ryazan Oblast | 119049 | 3355 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-26 04:20:51 | Ryazan Oblast, Russia | |||
2029013 | 2029013 | 2022-04-24 | Russia | Ryazan Oblast | 118961 | 3354 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-25 04:20:56 | Ryazan Oblast, Russia | |||
746588 | 746588 | 2022-04-23 | Russia | Ryazan Oblast | 118872 | 3353 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-24 04:20:56 | Ryazan Oblast, Russia | |||
3437073 | 3437073 | 2022-04-22 | Russia | Ryazan Oblast | 118779 | 3352 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-23 04:20:50 | Ryazan Oblast, Russia | |||
2892658 | 2892658 | 2022-04-21 | Russia | Ryazan Oblast | 118688 | 3349 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-22 04:20:45 | Ryazan Oblast, Russia | |||
2307530 | 2307530 | 2022-04-20 | Russia | Ryazan Oblast | 118593 | 3347 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-21 04:20:46 | Ryazan Oblast, Russia | |||
2251669 | 2251669 | 2022-04-19 | Russia | Ryazan Oblast | 118488 | 3345 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-20 04:20:45 | Ryazan Oblast, Russia | |||
1846219 | 1846219 | 2022-04-18 | Russia | Ryazan Oblast | 118377 | 3343 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-19 04:21:00 | Ryazan Oblast, Russia | |||
3417163 | 3417163 | 2022-04-17 | Russia | Ryazan Oblast | 118263 | 3341 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-18 04:21:12 | Ryazan Oblast, Russia | |||
304112 | 304112 | 2022-04-16 | Russia | Ryazan Oblast | 118148 | 3339 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-17 04:20:59 | Ryazan Oblast, Russia | |||
2670057 | 2670057 | 2022-04-15 | Russia | Ryazan Oblast | 118031 | 3337 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-16 04:20:48 | Ryazan Oblast, Russia | |||
1223842 | 1223842 | 2022-04-14 | Russia | Ryazan Oblast | 117911 | 3335 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-15 04:20:57 | Ryazan Oblast, Russia | |||
2443000 | 2443000 | 2022-04-13 | Russia | Ryazan Oblast | 117792 | 3332 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-13 23:21:06 | Ryazan Oblast, Russia | |||
1948757 | 1948757 | 2022-04-12 | Russia | Ryazan Oblast | 117665 | 3329 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-13 04:21:03 | Ryazan Oblast, Russia | |||
3206510 | 3206510 | 2022-04-11 | Russia | Ryazan Oblast | 117534 | 3326 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-12 04:20:49 | Ryazan Oblast, Russia | |||
1576396 | 1576396 | 2022-04-10 | Russia | Ryazan Oblast | 117400 | 3324 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-11 04:21:02 | Ryazan Oblast, Russia | |||
1652638 | 1652638 | 2022-04-09 | Russia | Ryazan Oblast | 117263 | 3322 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-10 04:20:52 | Ryazan Oblast, Russia | |||
2115960 | 2115960 | 2022-04-08 | Russia | Ryazan Oblast | 117123 | 3319 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-09 04:20:42 | Ryazan Oblast, Russia | |||
3320484 | 3320484 | 2022-04-07 | Russia | Ryazan Oblast | 116984 | 3316 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-08 04:20:48 | Ryazan Oblast, Russia | |||
2801020 | 2801020 | 2022-04-06 | Russia | Ryazan Oblast | 116840 | 3312 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-07 04:20:53 | Ryazan Oblast, Russia | |||
3867789 | 3867789 | 2022-04-05 | Russia | Ryazan Oblast | 116689 | 3307 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-06 04:20:49 | Ryazan Oblast, Russia | |||
2749131 | 2749131 | 2022-04-04 | Russia | Ryazan Oblast | 116497 | 3303 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-05 04:20:48 | Ryazan Oblast, Russia | |||
3730477 | 3730477 | 2022-04-03 | Russia | Ryazan Oblast | 116291 | 3300 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-04 04:20:51 | Ryazan Oblast, Russia | |||
499912 | 499912 | 2022-04-02 | Russia | Ryazan Oblast | 116080 | 3296 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-03 04:20:48 | Ryazan Oblast, Russia | |||
3350897 | 3350897 | 2022-04-01 | Russia | Ryazan Oblast | 115865 | 3291 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-02 04:20:47 | Ryazan Oblast, Russia | |||
1540202 | 1540202 | 2022-03-31 | Russia | Ryazan Oblast | 115644 | 3291 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-04-01 04:20:28 | Ryazan Oblast, Russia | |||
2478215 | 2478215 | 2022-03-30 | Russia | Ryazan Oblast | 115401 | 3286 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-31 04:20:56 | Ryazan Oblast, Russia | |||
158256 | 158256 | 2022-03-29 | Russia | Ryazan Oblast | 115152 | 3281 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-30 04:20:45 | Ryazan Oblast, Russia | |||
1436827 | 1436827 | 2022-03-28 | Russia | Ryazan Oblast | 114889 | 3275 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-29 04:20:46 | Ryazan Oblast, Russia | |||
876508 | 876508 | 2022-03-27 | Russia | Ryazan Oblast | 114624 | 3271 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-28 04:20:33 | Ryazan Oblast, Russia | |||
2163791 | 2163791 | 2022-03-26 | Russia | Ryazan Oblast | 114354 | 3267 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-27 04:20:47 | Ryazan Oblast, Russia | |||
1720727 | 1720727 | 2022-03-25 | Russia | Ryazan Oblast | 114085 | 3261 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-26 04:20:23 | Ryazan Oblast, Russia | |||
1468344 | 1468344 | 2022-03-24 | Russia | Ryazan Oblast | 113813 | 3254 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-25 04:20:46 | Ryazan Oblast, Russia | |||
3022518 | 3022518 | 2022-03-23 | Russia | Ryazan Oblast | 113542 | 3247 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-24 04:20:43 | Ryazan Oblast, Russia | |||
1905440 | 1905440 | 2022-03-22 | Russia | Ryazan Oblast | 113265 | 3241 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-23 04:20:48 | Ryazan Oblast, Russia | |||
3238571 | 3238571 | 2022-03-21 | Russia | Ryazan Oblast | 112979 | 3234 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-22 04:20:54 | Ryazan Oblast, Russia | |||
24644 | 24644 | 2022-03-20 | Russia | Ryazan Oblast | 112683 | 3231 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-21 04:20:50 | Ryazan Oblast, Russia | |||
1656654 | 1656654 | 2022-03-19 | Russia | Ryazan Oblast | 112382 | 3225 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-20 04:20:45 | Ryazan Oblast, Russia | |||
336180 | 336180 | 2022-03-18 | Russia | Ryazan Oblast | 112080 | 3217 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-19 04:20:47 | Ryazan Oblast, Russia | |||
694633 | 694633 | 2022-03-17 | Russia | Ryazan Oblast | 111766 | 3208 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-18 04:20:55 | Ryazan Oblast, Russia | |||
2319576 | 2319576 | 2022-03-16 | Russia | Ryazan Oblast | 111447 | 3198 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-17 04:20:56 | Ryazan Oblast, Russia | |||
261776 | 261776 | 2022-03-15 | Russia | Ryazan Oblast | 111094 | 3186 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-16 04:20:50 | Ryazan Oblast, Russia | |||
2264135 | 2264135 | 2022-03-14 | Russia | Ryazan Oblast | 110642 | 3175 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-15 04:20:47 | Ryazan Oblast, Russia | |||
3628201 | 3628201 | 2022-03-13 | Russia | Ryazan Oblast | 110181 | 3165 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-14 04:20:46 | Ryazan Oblast, Russia | |||
951109 | 951109 | 2022-03-12 | Russia | Ryazan Oblast | 109710 | 3155 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-13 04:20:49 | Ryazan Oblast, Russia | |||
356570 | 356570 | 2022-03-11 | Russia | Ryazan Oblast | 109226 | 3143 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-12 04:20:50 | Ryazan Oblast, Russia | |||
1865722 | 1865722 | 2022-03-10 | Russia | Ryazan Oblast | 108631 | 3133 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-11 04:20:50 | Ryazan Oblast, Russia | |||
2140417 | 2140417 | 2022-03-09 | Russia | Ryazan Oblast | 107975 | 3122 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-10 04:20:48 | Ryazan Oblast, Russia | |||
919928 | 919928 | 2022-03-08 | Russia | Ryazan Oblast | 107298 | 3112 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-09 04:20:59 | Ryazan Oblast, Russia | |||
1548215 | 1548215 | 2022-03-07 | Russia | Ryazan Oblast | 106611 | 3102 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-08 04:20:54 | Ryazan Oblast, Russia | |||
2199884 | 2199884 | 2022-03-06 | Russia | Ryazan Oblast | 105922 | 3093 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-07 04:20:47 | Ryazan Oblast, Russia | |||
2092341 | 2092341 | 2022-03-05 | Russia | Ryazan Oblast | 105230 | 3081 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-06 04:20:49 | Ryazan Oblast, Russia | |||
2666041 | 2666041 | 2022-03-04 | Russia | Ryazan Oblast | 104513 | 3070 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-05 04:21:10 | Ryazan Oblast, Russia | |||
1644606 | 1644606 | 2022-03-03 | Russia | Ryazan Oblast | 103792 | 3061 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-04 04:21:09 | Ryazan Oblast, Russia | |||
2525609 | 2525609 | 2022-03-02 | Russia | Ryazan Oblast | 103025 | 3053 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-03 04:21:01 | Ryazan Oblast, Russia | |||
1992903 | 1992903 | 2022-03-01 | Russia | Ryazan Oblast | 102150 | 3044 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-02 04:21:07 | Ryazan Oblast, Russia | |||
943077 | 943077 | 2022-02-28 | Russia | Ryazan Oblast | 101270 | 3034 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-03-01 04:21:09 | Ryazan Oblast, Russia | |||
2733268 | 2733268 | 2022-02-27 | Russia | Ryazan Oblast | 100359 | 3027 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-28 04:21:05 | Ryazan Oblast, Russia | |||
3046421 | 3046421 | 2022-02-26 | Russia | Ryazan Oblast | 99476 | 3020 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-27 04:21:04 | Ryazan Oblast, Russia | |||
575076 | 575076 | 2022-02-25 | Russia | Ryazan Oblast | 98567 | 3013 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-26 04:21:12 | Ryazan Oblast, Russia | |||
1511652 | 1511652 | 2022-02-24 | Russia | Ryazan Oblast | 97643 | 3005 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-25 04:21:11 | Ryazan Oblast, Russia | |||
1058093 | 1058093 | 2022-02-23 | Russia | Ryazan Oblast | 96761 | 3001 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-24 04:21:14 | Ryazan Oblast, Russia | |||
2447016 | 2447016 | 2022-02-22 | Russia | Ryazan Oblast | 95804 | 2996 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-23 04:21:09 | Ryazan Oblast, Russia | |||
3718429 | 3718429 | 2022-02-21 | Russia | Ryazan Oblast | 94721 | 2989 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-22 04:21:01 | Ryazan Oblast, Russia | |||
3912263 | 3912263 | 2022-02-20 | Russia | Ryazan Oblast | 93632 | 2983 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-21 04:21:05 | Ryazan Oblast, Russia | |||
3875821 | 3875821 | 2022-02-19 | Russia | Ryazan Oblast | 92334 | 2978 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-20 04:21:00 | Ryazan Oblast, Russia | |||
3856077 | 3856077 | 2022-02-18 | Russia | Ryazan Oblast | 91013 | 2972 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-19 04:21:11 | Ryazan Oblast, Russia | |||
1298296 | 1298296 | 2022-02-17 | Russia | Ryazan Oblast | 89656 | 2966 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-18 04:21:04 | Ryazan Oblast, Russia | |||
3820682 | 3820682 | 2022-02-16 | Russia | Ryazan Oblast | 88249 | 2961 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-17 04:20:56 | Ryazan Oblast, Russia | |||
3671896 | 3671896 | 2022-02-15 | Russia | Ryazan Oblast | 86630 | 2954 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-16 04:21:10 | Ryazan Oblast, Russia | |||
2641997 | 2641997 | 2022-02-14 | Russia | Ryazan Oblast | 85077 | 2949 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-15 04:21:09 | Ryazan Oblast, Russia | |||
186314 | 186314 | 2022-02-13 | Russia | Ryazan Oblast | 83562 | 2942 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-14 04:20:51 | Ryazan Oblast, Russia | |||
316160 | 316160 | 2022-02-12 | Russia | Ryazan Oblast | 82069 | 2937 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-13 04:21:00 | Ryazan Oblast, Russia | |||
233486 | 233486 | 2022-02-11 | Russia | Ryazan Oblast | 80668 | 2932 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-12 04:21:06 | Ryazan Oblast, Russia | |||
1464328 | 1464328 | 2022-02-10 | Russia | Ryazan Oblast | 79381 | 2926 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-11 04:21:09 | Ryazan Oblast, Russia | |||
3074289 | 3074289 | 2022-02-09 | Russia | Ryazan Oblast | 78091 | 2919 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-10 04:21:14 | Ryazan Oblast, Russia | |||
1362596 | 1362596 | 2022-02-08 | Russia | Ryazan Oblast | 76796 | 2913 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-09 04:21:04 | Ryazan Oblast, Russia | |||
71334 | 71334 | 2022-02-07 | Russia | Ryazan Oblast | 75504 | 2908 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-08 04:21:15 | Ryazan Oblast, Russia | |||
2012950 | 2012950 | 2022-02-06 | Russia | Ryazan Oblast | 74234 | 2902 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-07 04:21:05 | Ryazan Oblast, Russia | |||
1294279 | 1294279 | 2022-02-05 | Russia | Ryazan Oblast | 72953 | 2895 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-06 04:21:00 | Ryazan Oblast, Russia | |||
2327607 | 2327607 | 2022-02-04 | Russia | Ryazan Oblast | 71656 | 2889 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-05 04:21:05 | Ryazan Oblast, Russia | |||
2474198 | 2474198 | 2022-02-03 | Russia | Ryazan Oblast | 70455 | 2884 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-04 04:21:10 | Ryazan Oblast, Russia | |||
459623 | 459623 | 2022-02-02 | Russia | Ryazan Oblast | 69428 | 2878 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-03 04:21:21 | Ryazan Oblast, Russia | |||
979192 | 979192 | 2022-02-01 | Russia | Ryazan Oblast | 68456 | 2872 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-02 04:21:09 | Ryazan Oblast, Russia | |||
2658034 | 2658034 | 2022-01-31 | Russia | Ryazan Oblast | 67585 | 2865 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-01 04:21:11 | Ryazan Oblast, Russia | |||
3300451 | 3300451 | 2022-01-30 | Russia | Ryazan Oblast | 66760 | 2859 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-31 04:21:09 | Ryazan Oblast, Russia | |||
3062242 | 3062242 | 2022-01-29 | Russia | Ryazan Oblast | 66157 | 2851 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-30 04:21:26 | Ryazan Oblast, Russia | |||
3810176 | 3810176 | 2022-01-28 | Russia | Ryazan Oblast | 65674 | 2843 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-29 04:21:10 | Ryazan Oblast, Russia | |||
1779630 | 1779630 | 2022-01-27 | Russia | Ryazan Oblast | 65273 | 2836 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-28 04:21:09 | Ryazan Oblast, Russia | |||
1318458 | 1318458 | 2022-01-26 | Russia | Ryazan Oblast | 64902 | 2829 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-27 04:21:19 | Ryazan Oblast, Russia | |||
2052126 | 2052126 | 2022-01-25 | Russia | Ryazan Oblast | 64560 | 2821 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-26 04:21:07 | Ryazan Oblast, Russia | |||
1227857 | 1227857 | 2022-01-24 | Russia | Ryazan Oblast | 64233 | 2813 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-25 04:21:05 | Ryazan Oblast, Russia | |||
1141156 | 1141156 | 2022-01-23 | Russia | Ryazan Oblast | 63977 | 2800 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-24 04:21:12 | Ryazan Oblast, Russia | |||
2833074 | 2833074 | 2022-01-22 | Russia | Ryazan Oblast | 63772 | 2785 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-23 04:21:13 | Ryazan Oblast, Russia | |||
3425192 | 3425192 | 2022-01-21 | Russia | Ryazan Oblast | 63596 | 2772 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-22 04:21:13 | Ryazan Oblast, Russia | |||
1960800 | 1960800 | 2022-01-20 | Russia | Ryazan Oblast | 63435 | 2758 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-21 04:21:09 | Ryazan Oblast, Russia | |||
3226695 | 3226695 | 2022-01-19 | Russia | Ryazan Oblast | 63287 | 2743 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-20 04:21:07 | Ryazan Oblast, Russia | |||
3464420 | 3464420 | 2022-01-18 | Russia | Ryazan Oblast | 63152 | 2728 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-19 04:21:23 | Ryazan Oblast, Russia | |||
1472359 | 1472359 | 2022-01-17 | Russia | Ryazan Oblast | 63028 | 2716 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-01-18 04:21:04 | Ryazan 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]);