johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Madre de Dios" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
deaths 177 ✖
- 883 41
- 151 26
- 773 25
- 859 22
- 881 22
- 871 21
- 878 21
- 768 20
- 761 15
- 789 14
- 810 14
- 852 14
- 861 14
- 882 14
- 857 13
- 858 13
- 867 13
- 129 12
- 149 12
- 739 12
- 774 12
- 167 11
- 738 11
- 744 10
- 771 10
- 835 10
- 136 9
- 139 9
- 772 9
- 775 9
- 782 9
- 865 9
- 776 8
- 780 8
- 845 8
- 847 8
- 854 8
- 6 7
- 168 7
- 743 7
- 753 7
- 757 7
- 827 7
- 841 7
- 846 7
- 860 7
- 877 7
- 128 6
- 132 6
- 142 6
- 154 6
- 155 6
- 171 6
- 755 6
- 765 6
- 769 6
- 844 6
- 849 6
- 862 6
- 96 5
- 131 5
- 138 5
- 157 5
- 162 5
- 764 5
- 81 4
- 97 4
- 106 4
- 143 4
- 145 4
- 146 4
- 164 4
- 170 4
- 174 4
- 186 4
- 194 4
- 203 4
- 206 4
- 223 4
- 231 4
- 232 4
- 235 4
- 242 4
- 731 4
- 746 4
- 749 4
- 751 4
- 767 4
- 831 4
- 884 4
- 11 3
- 15 3
- 19 3
- 24 3
- 104 3
- 109 3
- 137 3
- 144 3
- 150 3
- 159 3
- 181 3
- 182 3
- 183 3
- 244 3
- 735 3
- 763 3
- 778 3
- 22 2
- 25 2
- 27 2
- 70 2
- 73 2
- 78 2
- 80 2
- 107 2
- 124 2
- 134 2
- 147 2
- 148 2
- 153 2
- 160 2
- 161 2
- 163 2
- 178 2
- 179 2
- 180 2
- 190 2
- 191 2
- 192 2
- 193 2
- 195 2
- 217 2
- 219 2
- 220 2
- 224 2
- 226 2
- 228 2
- 229 2
- 234 2
- 238 2
- 239 2
- 240 2
- 737 2
- 762 2
- 8 1
- 10 1
- 12 1
- 13 1
- 18 1
- 20 1
- 21 1
- 30 1
- 31 1
- 32 1
- 42 1
- 58 1
- 75 1
- 76 1
- 79 1
- 82 1
- 83 1
- 84 1
- 85 1
- 94 1
- 126 1
- 127 1
- 135 1
- 169 1
- 172 1
- 173 1
- 198 1
- 205 1
- 207 1
- 211 1
- 214 1
- 216 1
- 241 1
province_or_state 1
- Madre de Dios · 946 ✖
country_or_region 1
- Peru 946
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753077 | 2753077 | 2022-12-29 | Peru | Madre de Dios | 21213 | 884 | 0 | -11.972699 | -70.53172 | 2022-12-30 04:21:04 | Madre de Dios, Peru | |||
1074083 | 1074083 | 2022-12-28 | Peru | Madre de Dios | 21213 | 884 | 0 | -11.972699 | -70.53172 | 2022-12-29 04:21:01 | Madre de Dios, Peru | |||
328080 | 328080 | 2022-12-27 | Peru | Madre de Dios | 21213 | 884 | 0 | -11.972699 | -70.53172 | 2022-12-28 04:21:04 | Madre de Dios, Peru | |||
218153 | 218153 | 2022-12-26 | Peru | Madre de Dios | 21213 | 884 | 0 | -11.972699 | -70.53172 | 2022-12-27 04:21:07 | Madre de Dios, Peru | |||
3222610 | 3222610 | 2022-12-25 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-26 04:21:06 | Madre de Dios, Peru | |||
1018524 | 1018524 | 2022-12-24 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-25 04:21:04 | Madre de Dios, Peru | |||
690547 | 690547 | 2022-12-23 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-24 04:21:02 | Madre de Dios, Peru | |||
2179757 | 2179757 | 2022-12-22 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-23 04:21:04 | Madre de Dios, Peru | |||
451561 | 451561 | 2022-12-21 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-22 04:20:56 | Madre de Dios, Peru | |||
2951560 | 2951560 | 2022-12-20 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-21 04:21:03 | Madre de Dios, Peru | |||
3173962 | 3173962 | 2022-12-19 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-20 04:21:04 | Madre de Dios, Peru | |||
1628479 | 1628479 | 2022-12-18 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-19 04:21:03 | Madre de Dios, Peru | |||
503858 | 503858 | 2022-12-17 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-18 04:21:03 | Madre de Dios, Peru | |||
3324430 | 3324430 | 2022-12-16 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-17 04:21:04 | Madre de Dios, Peru | |||
542942 | 542942 | 2022-12-15 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-16 04:21:01 | Madre de Dios, Peru | |||
348470 | 348470 | 2022-12-14 | Peru | Madre de Dios | 20980 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-15 04:20:58 | Madre de Dios, Peru | |||
308058 | 308058 | 2022-12-13 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-14 04:21:04 | Madre de Dios, Peru | |||
1149119 | 1149119 | 2022-12-12 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-13 04:21:01 | Madre de Dios, Peru | |||
868973 | 868973 | 2022-12-11 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-12 04:21:01 | Madre de Dios, Peru | |||
257503 | 257503 | 2022-12-10 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-11 04:20:50 | Madre de Dios, Peru | |||
3936217 | 3936217 | 2022-12-09 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-10 04:21:02 | Madre de Dios, Peru | |||
3377549 | 3377549 | 2022-12-08 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-09 04:21:05 | Madre de Dios, Peru | |||
1984820 | 1984820 | 2022-12-07 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-08 04:21:07 | Madre de Dios, Peru | |||
3714343 | 3714343 | 2022-12-06 | Peru | Madre de Dios | 20698 | 881 | 0 | -11.972699 | -70.53172 | 2022-12-07 04:20:58 | Madre de Dios, Peru | |||
2415048 | 2415048 | 2022-12-05 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-06 04:21:03 | Madre de Dios, Peru | |||
718656 | 718656 | 2022-12-04 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-05 04:20:58 | Madre de Dios, Peru | |||
2816945 | 2816945 | 2022-12-03 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-04 04:20:56 | Madre de Dios, Peru | |||
833801 | 833801 | 2022-12-02 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-03 04:21:02 | Madre de Dios, Peru | |||
2136331 | 2136331 | 2022-12-01 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-02 04:21:07 | Madre de Dios, Peru | |||
1964747 | 1964747 | 2022-11-30 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-12-01 04:21:03 | Madre de Dios, Peru | |||
2556761 | 2556761 | 2022-11-29 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-30 04:21:07 | Madre de Dios, Peru | |||
1239835 | 1239835 | 2022-11-28 | Peru | Madre de Dios | 20526 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-29 04:21:05 | Madre de Dios, Peru | |||
3551823 | 3551823 | 2022-11-27 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-28 04:21:02 | Madre de Dios, Peru | |||
2100303 | 2100303 | 2022-11-26 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-27 04:21:05 | Madre de Dios, Peru | |||
487794 | 487794 | 2022-11-25 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-26 04:21:11 | Madre de Dios, Peru | |||
3523623 | 3523623 | 2022-11-24 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-25 04:21:06 | Madre de Dios, Peru | |||
3312406 | 3312406 | 2022-11-23 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-24 04:21:09 | Madre de Dios, Peru | |||
1620447 | 1620447 | 2022-11-22 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-23 04:21:06 | Madre de Dios, Peru | |||
3460335 | 3460335 | 2022-11-21 | Peru | Madre de Dios | 20461 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-22 04:20:47 | Madre de Dios, Peru | |||
1640520 | 1640520 | 2022-11-20 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-21 04:21:05 | Madre de Dios, Peru | |||
2064077 | 2064077 | 2022-11-19 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-20 04:21:08 | Madre de Dios, Peru | |||
1755471 | 1755471 | 2022-11-18 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-19 04:21:14 | Madre de Dios, Peru | |||
3026464 | 3026464 | 2022-11-17 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-18 04:21:15 | Madre de Dios, Peru | |||
2486175 | 2486175 | 2022-11-16 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-17 04:21:11 | Madre de Dios, Peru | |||
292186 | 292186 | 2022-11-15 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-16 04:21:09 | Madre de Dios, Peru | |||
3597216 | 3597216 | 2022-11-14 | Peru | Madre de Dios | 20435 | 882 | 0 | -11.972699 | -70.53172 | 2022-11-15 04:21:16 | Madre de Dios, Peru | |||
312074 | 312074 | 2022-11-13 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-14 04:21:09 | Madre de Dios, Peru | |||
63235 | 63235 | 2022-11-12 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-13 04:21:14 | Madre de Dios, Peru | |||
2927397 | 2927397 | 2022-11-11 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-12 04:20:41 | Madre de Dios, Peru | |||
2506233 | 2506233 | 2022-11-10 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-11 04:21:22 | Madre de Dios, Peru | |||
2431108 | 2431108 | 2022-11-09 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-10 04:21:16 | Madre de Dios, Peru | |||
479764 | 479764 | 2022-11-08 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-09 04:21:22 | Madre de Dios, Peru | |||
2438914 | 2438914 | 2022-11-07 | Peru | Madre de Dios | 20419 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-08 04:21:21 | Madre de Dios, Peru | |||
1050012 | 1050012 | 2022-11-06 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-07 04:21:26 | Madre de Dios, Peru | |||
618036 | 618036 | 2022-11-05 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-06 04:21:24 | Madre de Dios, Peru | |||
1022540 | 1022540 | 2022-11-04 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-05 04:21:52 | Madre de Dios, Peru | |||
431531 | 431531 | 2022-11-03 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-04 04:22:11 | Madre de Dios, Peru | |||
849773 | 849773 | 2022-11-02 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-03 04:22:05 | Madre de Dios, Peru | |||
710624 | 710624 | 2022-11-01 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-02 04:22:09 | Madre de Dios, Peru | |||
3285073 | 3285073 | 2022-10-31 | Peru | Madre de Dios | 20410 | 883 | 0 | -11.972699 | -70.53172 | 2022-11-01 04:22:36 | Madre de Dios, Peru | |||
320106 | 320106 | 2022-10-30 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-31 04:21:36 | Madre de Dios, Peru | |||
912382 | 912382 | 2022-10-29 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-30 04:22:14 | Madre de Dios, Peru | |||
1366651 | 1366651 | 2022-10-28 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-29 04:21:13 | Madre de Dios, Peru | |||
3038506 | 3038506 | 2022-10-27 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-28 04:22:31 | Madre de Dios, Peru | |||
538926 | 538926 | 2022-10-26 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-27 04:22:01 | Madre de Dios, Peru | |||
1830327 | 1830327 | 2022-10-25 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-26 04:22:19 | Madre de Dios, Peru | |||
794588 | 794588 | 2022-10-24 | Peru | Madre de Dios | 20402 | 883 | 0 | -11.972699 | -70.53172 | 2022-10-25 04:21:53 | Madre de Dios, Peru | |||
3277043 | 3277043 | 2022-10-23 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-24 04:22:29 | Madre de Dios, Peru | |||
2268081 | 2268081 | 2022-10-22 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-23 04:22:46 | Madre de Dios, Peru | |||
1592381 | 1592381 | 2022-10-21 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-22 04:22:53 | Madre de Dios, Peru | |||
2272097 | 2272097 | 2022-10-20 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-21 04:22:23 | Madre de Dios, Peru | |||
198432 | 198432 | 2022-10-19 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-20 04:22:59 | Madre de Dios, Peru | |||
2757093 | 2757093 | 2022-10-18 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-19 04:22:26 | Madre de Dios, Peru | |||
2024927 | 2024927 | 2022-10-17 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-18 04:22:42 | Madre de Dios, Peru | |||
2159705 | 2159705 | 2022-10-16 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-17 04:20:31 | Madre de Dios, Peru | |||
515902 | 515902 | 2022-10-15 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-16 04:22:39 | Madre de Dios, Peru | |||
2032959 | 2032959 | 2022-10-14 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-15 04:22:00 | Madre de Dios, Peru | |||
3753647 | 3753647 | 2022-10-13 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-14 04:22:28 | Madre de Dios, Peru | |||
3214472 | 3214472 | 2022-10-12 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-13 04:22:39 | Madre de Dios, Peru | |||
3250321 | 3250321 | 2022-10-11 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-12 04:22:51 | Madre de Dios, Peru | |||
2967580 | 2967580 | 2022-10-10 | Peru | Madre de Dios | 20399 | 881 | 0 | -11.972699 | -70.53172 | 2022-10-11 04:23:05 | Madre de Dios, Peru | |||
3097616 | 3097616 | 2022-10-09 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-10 04:22:32 | Madre de Dios, Peru | |||
4002841 | 4002841 | 2022-10-08 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-09 04:21:16 | Madre de Dios, Peru | |||
396438 | 396438 | 2022-10-07 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-08 04:22:56 | Madre de Dios, Peru | |||
2529555 | 2529555 | 2022-10-06 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-07 04:23:08 | Madre de Dios, Peru | |||
1810949 | 1810949 | 2022-10-05 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-06 04:21:22 | Madre de Dios, Peru | |||
130923 | 130923 | 2022-10-04 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-05 04:23:06 | Madre de Dios, Peru | |||
2685870 | 2685870 | 2022-10-03 | Peru | Madre de Dios | 20399 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-04 04:22:55 | Madre de Dios, Peru | |||
2259937 | 2259937 | 2022-10-02 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-03 04:23:11 | Madre de Dios, Peru | |||
2995463 | 2995463 | 2022-10-01 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-02 04:21:23 | Madre de Dios, Peru | |||
853789 | 853789 | 2022-09-30 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-10-01 04:23:01 | Madre de Dios, Peru | |||
2375715 | 2375715 | 2022-09-29 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-30 04:23:09 | Madre de Dios, Peru | |||
1560266 | 1560266 | 2022-09-28 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-29 04:22:34 | Madre de Dios, Peru | |||
3994809 | 3994809 | 2022-09-27 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-28 04:23:01 | Madre de Dios, Peru | |||
2769137 | 2769137 | 2022-09-26 | Peru | Madre de Dios | 20394 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-27 04:23:01 | Madre de Dios, Peru | |||
1976790 | 1976790 | 2022-09-25 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-26 04:20:52 | Madre de Dios, Peru | |||
2649957 | 2649957 | 2022-09-24 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-25 04:23:31 | Madre de Dios, Peru | |||
384397 | 384397 | 2022-09-23 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-24 04:21:40 | Madre de Dios, Peru | |||
1624463 | 1624463 | 2022-09-22 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-23 04:23:13 | Madre de Dios, Peru | |||
1370667 | 1370667 | 2022-09-21 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-22 04:22:56 | Madre de Dios, Peru |
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]);