johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where province_or_state = "Queretaro" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, last_update, day (date), last_update (date)
recovered 174 ✖
- 0 778
- 12483 4
- 213 1
- 247 1
- 273 1
- 298 1
- 332 1
- 371 1
- 402 1
- 429 1
- 453 1
- 494 1
- 546 1
- 570 1
- 595 1
- 625 1
- 660 1
- 698 1
- 724 1
- 747 1
- 777 1
- 816 1
- 833 1
- 855 1
- 879 1
- 911 1
- 946 1
- 968 1
- 1019 1
- 1067 1
- 1100 1
- 1110 1
- 1147 1
- 1190 1
- 1219 1
- 1242 1
- 1264 1
- 1289 1
- 1326 1
- 1367 1
- 1375 1
- 1405 1
- 1436 1
- 1455 1
- 1472 1
- 1501 1
- 1529 1
- 1562 1
- 1595 1
- 1622 1
- 1648 1
- 1664 1
- 1700 1
- 1737 1
- 1793 1
- 1829 1
- 1862 1
- 1909 1
- 1954 1
- 2003 1
- 2044 1
- 2094 1
- 2108 1
- 2159 1
- 2189 1
- 2226 1
- 2282 1
- 2356 1
- 2397 1
- 2441 1
- 2519 1
- 2547 1
- 2592 1
- 2671 1
- 2698 1
- 2801 1
- 2826 1
- 2894 1
- 2932 1
- 2981 1
- 3026 1
- 3118 1
- 3229 1
- 3312 1
- 3357 1
- 3402 1
- 3463 1
- 3539 1
- 3601 1
- 3685 1
- 3745 1
- 3830 1
- 3883 1
- 3952 1
- 4017 1
- 4124 1
- 4237 1
- 4322 1
- 4450 1
- 4464 1
- 4531 1
- 4578 1
- 4696 1
- 4799 1
- 4874 1
- 4963 1
- 5057 1
- 5110 1
- 5263 1
- 5323 1
- 5438 1
- 5493 1
- 5609 1
- 5681 1
- 5734 1
- 5790 1
- 5917 1
- 6075 1
- 6171 1
- 6281 1
- 6348 1
- 6485 1
- 6544 1
- 6578 1
- 6702 1
- 6771 1
- 6871 1
- 6903 1
- 6944 1
- 7005 1
- 7070 1
- 7128 1
- 7198 1
- 7275 1
- 7321 1
- 7386 1
- 7441 1
- 7512 1
- 7578 1
- 7737 1
- 7825 1
- 7912 1
- 7964 1
- 7984 1
- 8086 1
- 8153 1
- 8235 1
- 8400 1
- 8482 1
- 8498 1
- 8659 1
- 8741 1
- 8812 1
- 8899 1
- 9183 1
- 9208 1
- 9217 1
- 9348 1
- 9490 1
- 9724 1
- 9905 1
- 10144 1
- 10250 1
- 10404 1
- 10490 1
- 10623 1
- 10842 1
- 11023 1
- 11298 1
- 11504 1
- 11824 1
- 11922 1
- 12069 1
- 12220 1
province_or_state 1
- Queretaro · 954 ✖
country_or_region 1
- Mexico 954
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753002 | 2753002 | 2022-12-29 | Mexico | Queretaro | 179287 | 6357 | 0 | 20.5888 | -100.3899 | 2022-12-30 04:21:04 | Queretaro, Mexico | |||
1074008 | 1074008 | 2022-12-28 | Mexico | Queretaro | 179287 | 6357 | 0 | 20.5888 | -100.3899 | 2022-12-29 04:21:01 | Queretaro, Mexico | |||
328005 | 328005 | 2022-12-27 | Mexico | Queretaro | 179157 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-28 04:21:04 | Queretaro, Mexico | |||
218078 | 218078 | 2022-12-26 | Mexico | Queretaro | 179013 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-27 04:21:07 | Queretaro, Mexico | |||
3222535 | 3222535 | 2022-12-25 | Mexico | Queretaro | 178998 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-26 04:21:06 | Queretaro, Mexico | |||
1018449 | 1018449 | 2022-12-24 | Mexico | Queretaro | 178998 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-25 04:21:04 | Queretaro, Mexico | |||
690472 | 690472 | 2022-12-23 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-24 04:21:02 | Queretaro, Mexico | |||
2179682 | 2179682 | 2022-12-22 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-23 04:21:04 | Queretaro, Mexico | |||
451486 | 451486 | 2022-12-21 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-22 04:20:56 | Queretaro, Mexico | |||
2951485 | 2951485 | 2022-12-20 | Mexico | Queretaro | 178439 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-21 04:21:03 | Queretaro, Mexico | |||
3173887 | 3173887 | 2022-12-19 | Mexico | Queretaro | 178309 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-20 04:21:04 | Queretaro, Mexico | |||
1628404 | 1628404 | 2022-12-18 | Mexico | Queretaro | 178263 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-19 04:21:03 | Queretaro, Mexico | |||
503783 | 503783 | 2022-12-17 | Mexico | Queretaro | 178263 | 6352 | 0 | 20.5888 | -100.3899 | 2022-12-18 04:21:03 | Queretaro, Mexico | |||
3324355 | 3324355 | 2022-12-16 | Mexico | Queretaro | 178062 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-17 04:21:04 | Queretaro, Mexico | |||
542867 | 542867 | 2022-12-15 | Mexico | Queretaro | 178062 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-16 04:21:01 | Queretaro, Mexico | |||
348395 | 348395 | 2022-12-14 | Mexico | Queretaro | 178013 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-15 04:20:58 | Queretaro, Mexico | |||
307983 | 307983 | 2022-12-13 | Mexico | Queretaro | 178013 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-14 04:21:04 | Queretaro, Mexico | |||
1149044 | 1149044 | 2022-12-12 | Mexico | Queretaro | 177950 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-13 04:21:01 | Queretaro, Mexico | |||
868898 | 868898 | 2022-12-11 | Mexico | Queretaro | 177868 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-12 04:21:01 | Queretaro, Mexico | |||
257428 | 257428 | 2022-12-10 | Mexico | Queretaro | 177868 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-11 04:20:50 | Queretaro, Mexico | |||
3936142 | 3936142 | 2022-12-09 | Mexico | Queretaro | 177868 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-10 04:21:02 | Queretaro, Mexico | |||
3377474 | 3377474 | 2022-12-08 | Mexico | Queretaro | 177868 | 6350 | 0 | 20.5888 | -100.3899 | 2022-12-09 04:21:05 | Queretaro, Mexico | |||
1984745 | 1984745 | 2022-12-07 | Mexico | Queretaro | 177821 | 6349 | 0 | 20.5888 | -100.3899 | 2022-12-08 04:21:07 | Queretaro, Mexico | |||
3714268 | 3714268 | 2022-12-06 | Mexico | Queretaro | 177766 | 6349 | 0 | 20.5888 | -100.3899 | 2022-12-07 04:20:58 | Queretaro, Mexico | |||
2414973 | 2414973 | 2022-12-05 | Mexico | Queretaro | 177733 | 6349 | 0 | 20.5888 | -100.3899 | 2022-12-06 04:21:03 | Queretaro, Mexico | |||
718581 | 718581 | 2022-12-04 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-12-05 04:20:58 | Queretaro, Mexico | |||
2816870 | 2816870 | 2022-12-03 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-12-04 04:20:56 | Queretaro, Mexico | |||
833726 | 833726 | 2022-12-02 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-12-03 04:21:02 | Queretaro, Mexico | |||
2136256 | 2136256 | 2022-12-01 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-12-02 04:21:07 | Queretaro, Mexico | |||
1964672 | 1964672 | 2022-11-30 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-12-01 04:21:03 | Queretaro, Mexico | |||
2556686 | 2556686 | 2022-11-29 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-30 04:21:07 | Queretaro, Mexico | |||
1239760 | 1239760 | 2022-11-28 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-29 04:21:05 | Queretaro, Mexico | |||
3551748 | 3551748 | 2022-11-27 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-28 04:21:02 | Queretaro, Mexico | |||
2100228 | 2100228 | 2022-11-26 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-27 04:21:05 | Queretaro, Mexico | |||
487719 | 487719 | 2022-11-25 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-26 04:21:11 | Queretaro, Mexico | |||
3523548 | 3523548 | 2022-11-24 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-25 04:21:06 | Queretaro, Mexico | |||
3312331 | 3312331 | 2022-11-23 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-24 04:21:09 | Queretaro, Mexico | |||
1620372 | 1620372 | 2022-11-22 | Mexico | Queretaro | 177500 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-23 04:21:06 | Queretaro, Mexico | |||
3460260 | 3460260 | 2022-11-21 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-22 04:20:47 | Queretaro, Mexico | |||
1640445 | 1640445 | 2022-11-20 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-21 04:21:05 | Queretaro, Mexico | |||
2064002 | 2064002 | 2022-11-19 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-20 04:21:08 | Queretaro, Mexico | |||
1755396 | 1755396 | 2022-11-18 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-19 04:21:14 | Queretaro, Mexico | |||
3026389 | 3026389 | 2022-11-17 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-18 04:21:15 | Queretaro, Mexico | |||
2486100 | 2486100 | 2022-11-16 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-17 04:21:11 | Queretaro, Mexico | |||
292111 | 292111 | 2022-11-15 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-16 04:21:09 | Queretaro, Mexico | |||
3597141 | 3597141 | 2022-11-14 | Mexico | Queretaro | 177438 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-15 04:21:16 | Queretaro, Mexico | |||
311999 | 311999 | 2022-11-13 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-14 04:21:09 | Queretaro, Mexico | |||
63160 | 63160 | 2022-11-12 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-13 04:21:14 | Queretaro, Mexico | |||
2927322 | 2927322 | 2022-11-11 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-12 04:20:41 | Queretaro, Mexico | |||
2506158 | 2506158 | 2022-11-10 | Mexico | Queretaro | 177390 | 6346 | 0 | 20.5888 | -100.3899 | 2022-11-11 04:21:22 | Queretaro, Mexico | |||
2431033 | 2431033 | 2022-11-09 | Mexico | Queretaro | 177374 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-10 04:21:16 | Queretaro, Mexico | |||
479689 | 479689 | 2022-11-08 | Mexico | Queretaro | 177349 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-09 04:21:22 | Queretaro, Mexico | |||
2438839 | 2438839 | 2022-11-07 | Mexico | Queretaro | 177349 | 6345 | 0 | 20.5888 | -100.3899 | 2022-11-08 04:21:21 | Queretaro, Mexico | |||
1049937 | 1049937 | 2022-11-06 | Mexico | Queretaro | 177339 | 6344 | 0 | 20.5888 | -100.3899 | 2022-11-07 04:21:26 | Queretaro, Mexico | |||
617961 | 617961 | 2022-11-05 | Mexico | Queretaro | 177339 | 6344 | 0 | 20.5888 | -100.3899 | 2022-11-06 04:21:24 | Queretaro, Mexico | |||
1022465 | 1022465 | 2022-11-04 | Mexico | Queretaro | 177339 | 6344 | 0 | 20.5888 | -100.3899 | 2022-11-05 04:21:52 | Queretaro, Mexico | |||
431456 | 431456 | 2022-11-03 | Mexico | Queretaro | 177320 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-04 04:22:11 | Queretaro, Mexico | |||
849698 | 849698 | 2022-11-02 | Mexico | Queretaro | 177320 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-03 04:22:05 | Queretaro, Mexico | |||
710549 | 710549 | 2022-11-01 | Mexico | Queretaro | 177305 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-02 04:22:09 | Queretaro, Mexico | |||
3284998 | 3284998 | 2022-10-31 | Mexico | Queretaro | 177305 | 6343 | 0 | 20.5888 | -100.3899 | 2022-11-01 04:22:36 | Queretaro, Mexico | |||
320031 | 320031 | 2022-10-30 | Mexico | Queretaro | 177305 | 6343 | 0 | 20.5888 | -100.3899 | 2022-10-31 04:21:36 | Queretaro, Mexico | |||
912307 | 912307 | 2022-10-29 | Mexico | Queretaro | 177283 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-30 04:22:14 | Queretaro, Mexico | |||
1366576 | 1366576 | 2022-10-28 | Mexico | Queretaro | 177283 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-29 04:21:13 | Queretaro, Mexico | |||
3038431 | 3038431 | 2022-10-27 | Mexico | Queretaro | 177283 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-28 04:22:31 | Queretaro, Mexico | |||
538851 | 538851 | 2022-10-26 | Mexico | Queretaro | 177283 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-27 04:22:01 | Queretaro, Mexico | |||
1830252 | 1830252 | 2022-10-25 | Mexico | Queretaro | 177269 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-26 04:22:19 | Queretaro, Mexico | |||
794513 | 794513 | 2022-10-24 | Mexico | Queretaro | 177256 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-25 04:21:53 | Queretaro, Mexico | |||
3276968 | 3276968 | 2022-10-23 | Mexico | Queretaro | 177256 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-24 04:22:29 | Queretaro, Mexico | |||
2268006 | 2268006 | 2022-10-22 | Mexico | Queretaro | 177248 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-23 04:22:46 | Queretaro, Mexico | |||
1592306 | 1592306 | 2022-10-21 | Mexico | Queretaro | 177248 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-22 04:22:53 | Queretaro, Mexico | |||
2272022 | 2272022 | 2022-10-20 | Mexico | Queretaro | 177237 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-21 04:22:23 | Queretaro, Mexico | |||
198357 | 198357 | 2022-10-19 | Mexico | Queretaro | 177223 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-20 04:22:59 | Queretaro, Mexico | |||
2757018 | 2757018 | 2022-10-18 | Mexico | Queretaro | 177223 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-19 04:22:26 | Queretaro, Mexico | |||
2024852 | 2024852 | 2022-10-17 | Mexico | Queretaro | 177223 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-18 04:22:42 | Queretaro, Mexico | |||
2159630 | 2159630 | 2022-10-16 | Mexico | Queretaro | 177221 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-17 04:20:31 | Queretaro, Mexico | |||
515827 | 515827 | 2022-10-15 | Mexico | Queretaro | 177221 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-16 04:22:39 | Queretaro, Mexico | |||
2032884 | 2032884 | 2022-10-14 | Mexico | Queretaro | 177210 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-15 04:22:00 | Queretaro, Mexico | |||
3753572 | 3753572 | 2022-10-13 | Mexico | Queretaro | 177210 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-14 04:22:28 | Queretaro, Mexico | |||
3214397 | 3214397 | 2022-10-12 | Mexico | Queretaro | 177202 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-13 04:22:39 | Queretaro, Mexico | |||
3250246 | 3250246 | 2022-10-11 | Mexico | Queretaro | 177191 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-12 04:22:51 | Queretaro, Mexico | |||
2967505 | 2967505 | 2022-10-10 | Mexico | Queretaro | 177178 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-11 04:23:05 | Queretaro, Mexico | |||
3097541 | 3097541 | 2022-10-09 | Mexico | Queretaro | 177178 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-10 04:22:32 | Queretaro, Mexico | |||
4002766 | 4002766 | 2022-10-08 | Mexico | Queretaro | 177160 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-09 04:21:16 | Queretaro, Mexico | |||
396363 | 396363 | 2022-10-07 | Mexico | Queretaro | 177160 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-08 04:22:56 | Queretaro, Mexico | |||
2529480 | 2529480 | 2022-10-06 | Mexico | Queretaro | 177088 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-07 04:23:08 | Queretaro, Mexico | |||
1810874 | 1810874 | 2022-10-05 | Mexico | Queretaro | 177088 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-06 04:21:22 | Queretaro, Mexico | |||
130848 | 130848 | 2022-10-04 | Mexico | Queretaro | 177088 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-05 04:23:06 | Queretaro, Mexico | |||
2685795 | 2685795 | 2022-10-03 | Mexico | Queretaro | 177088 | 6342 | 0 | 20.5888 | -100.3899 | 2022-10-04 04:22:55 | Queretaro, Mexico | |||
2259862 | 2259862 | 2022-10-02 | Mexico | Queretaro | 176972 | 6341 | 0 | 20.5888 | -100.3899 | 2022-10-03 04:23:11 | Queretaro, Mexico | |||
2995388 | 2995388 | 2022-10-01 | Mexico | Queretaro | 176972 | 6341 | 0 | 20.5888 | -100.3899 | 2022-10-02 04:21:23 | Queretaro, Mexico | |||
853714 | 853714 | 2022-09-30 | Mexico | Queretaro | 176950 | 6338 | 0 | 20.5888 | -100.3899 | 2022-10-01 04:23:01 | Queretaro, Mexico | |||
2375640 | 2375640 | 2022-09-29 | Mexico | Queretaro | 176895 | 6334 | 0 | 20.5888 | -100.3899 | 2022-09-30 04:23:09 | Queretaro, Mexico | |||
1560191 | 1560191 | 2022-09-28 | Mexico | Queretaro | 176822 | 6331 | 0 | 20.5888 | -100.3899 | 2022-09-29 04:22:34 | Queretaro, Mexico | |||
3994734 | 3994734 | 2022-09-27 | Mexico | Queretaro | 176822 | 6331 | 0 | 20.5888 | -100.3899 | 2022-09-28 04:23:01 | Queretaro, Mexico | |||
2769062 | 2769062 | 2022-09-26 | Mexico | Queretaro | 176822 | 6331 | 0 | 20.5888 | -100.3899 | 2022-09-27 04:23:01 | Queretaro, Mexico | |||
1976715 | 1976715 | 2022-09-25 | Mexico | Queretaro | 176815 | 6329 | 0 | 20.5888 | -100.3899 | 2022-09-26 04:20:52 | Queretaro, Mexico | |||
2649882 | 2649882 | 2022-09-24 | Mexico | Queretaro | 176815 | 6329 | 0 | 20.5888 | -100.3899 | 2022-09-25 04:23:31 | Queretaro, Mexico | |||
384322 | 384322 | 2022-09-23 | Mexico | Queretaro | 176770 | 6328 | 0 | 20.5888 | -100.3899 | 2022-09-24 04:21:40 | Queretaro, Mexico | |||
1624388 | 1624388 | 2022-09-22 | Mexico | Queretaro | 176703 | 6327 | 0 | 20.5888 | -100.3899 | 2022-09-23 04:23:13 | Queretaro, Mexico | |||
1370592 | 1370592 | 2022-09-21 | Mexico | Queretaro | 176703 | 6327 | 0 | 20.5888 | -100.3899 | 2022-09-22 04:22:56 | Queretaro, Mexico |
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]);