johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Chesterfield, Virginia, US" and province_or_state = "Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756229 | 2756229 | 2022-12-29 | US | Virginia | Chesterfield | 51041 | 95837 | 860 | 0 | 37.37373208 | -77.5868014 | 2022-12-30 04:21:04 | Chesterfield, Virginia, US | |
1077235 | 1077235 | 2022-12-28 | US | Virginia | Chesterfield | 51041 | 95837 | 860 | 0 | 37.37373208 | -77.5868014 | 2022-12-29 04:21:01 | Chesterfield, Virginia, US | |
331232 | 331232 | 2022-12-27 | US | Virginia | Chesterfield | 51041 | 95717 | 859 | 0 | 37.37373208 | -77.5868014 | 2022-12-28 04:21:04 | Chesterfield, Virginia, US | |
221305 | 221305 | 2022-12-26 | US | Virginia | Chesterfield | 51041 | 95671 | 859 | 0 | 37.37373208 | -77.5868014 | 2022-12-27 04:21:07 | Chesterfield, Virginia, US | |
3225762 | 3225762 | 2022-12-25 | US | Virginia | Chesterfield | 51041 | 95412 | 859 | 0 | 37.37373208 | -77.5868014 | 2022-12-26 04:21:06 | Chesterfield, Virginia, US | |
1021676 | 1021676 | 2022-12-24 | US | Virginia | Chesterfield | 51041 | 95412 | 859 | 0 | 37.37373208 | -77.5868014 | 2022-12-25 04:21:04 | Chesterfield, Virginia, US | |
693699 | 693699 | 2022-12-23 | US | Virginia | Chesterfield | 51041 | 95412 | 859 | 0 | 37.37373208 | -77.5868014 | 2022-12-24 04:21:02 | Chesterfield, Virginia, US | |
2182909 | 2182909 | 2022-12-22 | US | Virginia | Chesterfield | 51041 | 95277 | 858 | 0 | 37.37373208 | -77.5868014 | 2022-12-23 04:21:04 | Chesterfield, Virginia, US | |
454713 | 454713 | 2022-12-21 | US | Virginia | Chesterfield | 51041 | 95160 | 858 | 0 | 37.37373208 | -77.5868014 | 2022-12-22 04:20:56 | Chesterfield, Virginia, US | |
2954712 | 2954712 | 2022-12-20 | US | Virginia | Chesterfield | 51041 | 95060 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-21 04:21:03 | Chesterfield, Virginia, US | |
3177114 | 3177114 | 2022-12-19 | US | Virginia | Chesterfield | 51041 | 94961 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-20 04:21:04 | Chesterfield, Virginia, US | |
1631631 | 1631631 | 2022-12-18 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-19 04:21:03 | Chesterfield, Virginia, US | |
507010 | 507010 | 2022-12-17 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-18 04:21:03 | Chesterfield, Virginia, US | |
3327582 | 3327582 | 2022-12-16 | US | Virginia | Chesterfield | 51041 | 94753 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-17 04:21:04 | Chesterfield, Virginia, US | |
546094 | 546094 | 2022-12-15 | US | Virginia | Chesterfield | 51041 | 94668 | 855 | 0 | 37.37373208 | -77.5868014 | 2022-12-16 04:21:01 | Chesterfield, Virginia, US | |
351622 | 351622 | 2022-12-14 | US | Virginia | Chesterfield | 51041 | 94589 | 854 | 0 | 37.37373208 | -77.5868014 | 2022-12-15 04:20:58 | Chesterfield, Virginia, US | |
311210 | 311210 | 2022-12-13 | US | Virginia | Chesterfield | 51041 | 94508 | 854 | 0 | 37.37373208 | -77.5868014 | 2022-12-14 04:21:04 | Chesterfield, Virginia, US | |
1152271 | 1152271 | 2022-12-12 | US | Virginia | Chesterfield | 51041 | 94439 | 853 | 0 | 37.37373208 | -77.5868014 | 2022-12-13 04:21:01 | Chesterfield, Virginia, US | |
872125 | 872125 | 2022-12-11 | US | Virginia | Chesterfield | 51041 | 94282 | 853 | 0 | 37.37373208 | -77.5868014 | 2022-12-12 04:21:01 | Chesterfield, Virginia, US | |
260655 | 260655 | 2022-12-10 | US | Virginia | Chesterfield | 51041 | 94282 | 853 | 0 | 37.37373208 | -77.5868014 | 2022-12-11 04:20:50 | Chesterfield, Virginia, US | |
3939369 | 3939369 | 2022-12-09 | US | Virginia | Chesterfield | 51041 | 94282 | 853 | 0 | 37.37373208 | -77.5868014 | 2022-12-10 04:21:02 | Chesterfield, Virginia, US | |
3380701 | 3380701 | 2022-12-08 | US | Virginia | Chesterfield | 51041 | 94210 | 851 | 0 | 37.37373208 | -77.5868014 | 2022-12-09 04:21:05 | Chesterfield, Virginia, US | |
1987972 | 1987972 | 2022-12-07 | US | Virginia | Chesterfield | 51041 | 94137 | 851 | 0 | 37.37373208 | -77.5868014 | 2022-12-08 04:21:07 | Chesterfield, Virginia, US | |
3717495 | 3717495 | 2022-12-06 | US | Virginia | Chesterfield | 51041 | 94085 | 849 | 0 | 37.37373208 | -77.5868014 | 2022-12-07 04:20:58 | Chesterfield, Virginia, US | |
2418200 | 2418200 | 2022-12-05 | US | Virginia | Chesterfield | 51041 | 94028 | 848 | 0 | 37.37373208 | -77.5868014 | 2022-12-06 04:21:03 | Chesterfield, Virginia, US | |
721808 | 721808 | 2022-12-04 | US | Virginia | Chesterfield | 51041 | 93903 | 848 | 0 | 37.37373208 | -77.5868014 | 2022-12-05 04:20:58 | Chesterfield, Virginia, US | |
2820097 | 2820097 | 2022-12-03 | US | Virginia | Chesterfield | 51041 | 93903 | 848 | 0 | 37.37373208 | -77.5868014 | 2022-12-04 04:20:56 | Chesterfield, Virginia, US | |
836953 | 836953 | 2022-12-02 | US | Virginia | Chesterfield | 51041 | 93903 | 848 | 0 | 37.37373208 | -77.5868014 | 2022-12-03 04:21:02 | Chesterfield, Virginia, US | |
2139483 | 2139483 | 2022-12-01 | US | Virginia | Chesterfield | 51041 | 93817 | 848 | 0 | 37.37373208 | -77.5868014 | 2022-12-02 04:21:07 | Chesterfield, Virginia, US | |
1967899 | 1967899 | 2022-11-30 | US | Virginia | Chesterfield | 51041 | 93742 | 846 | 0 | 37.37373208 | -77.5868014 | 2022-12-01 04:21:03 | Chesterfield, Virginia, US | |
2559913 | 2559913 | 2022-11-29 | US | Virginia | Chesterfield | 51041 | 93625 | 841 | 0 | 37.37373208 | -77.5868014 | 2022-11-30 04:21:07 | Chesterfield, Virginia, US | |
1242987 | 1242987 | 2022-11-28 | US | Virginia | Chesterfield | 51041 | 93581 | 839 | 0 | 37.37373208 | -77.5868014 | 2022-11-29 04:21:05 | Chesterfield, Virginia, US | |
3554975 | 3554975 | 2022-11-27 | US | Virginia | Chesterfield | 51041 | 93485 | 839 | 0 | 37.37373208 | -77.5868014 | 2022-11-28 04:21:02 | Chesterfield, Virginia, US | |
2103455 | 2103455 | 2022-11-26 | US | Virginia | Chesterfield | 51041 | 93485 | 839 | 0 | 37.37373208 | -77.5868014 | 2022-11-27 04:21:05 | Chesterfield, Virginia, US | |
490946 | 490946 | 2022-11-25 | US | Virginia | Chesterfield | 51041 | 93485 | 839 | 0 | 37.37373208 | -77.5868014 | 2022-11-26 04:21:11 | Chesterfield, Virginia, US | |
3526775 | 3526775 | 2022-11-24 | US | Virginia | Chesterfield | 51041 | 93386 | 837 | 0 | 37.37373208 | -77.5868014 | 2022-11-25 04:21:06 | Chesterfield, Virginia, US | |
3315558 | 3315558 | 2022-11-23 | US | Virginia | Chesterfield | 51041 | 93386 | 837 | 0 | 37.37373208 | -77.5868014 | 2022-11-24 04:21:09 | Chesterfield, Virginia, US | |
1623599 | 1623599 | 2022-11-22 | US | Virginia | Chesterfield | 51041 | 93338 | 837 | 0 | 37.37373208 | -77.5868014 | 2022-11-23 04:21:06 | Chesterfield, Virginia, US | |
3463487 | 3463487 | 2022-11-21 | US | Virginia | Chesterfield | 51041 | 93308 | 836 | 0 | 37.37373208 | -77.5868014 | 2022-11-22 04:20:47 | Chesterfield, Virginia, US | |
1643672 | 1643672 | 2022-11-20 | US | Virginia | Chesterfield | 51041 | 93215 | 836 | 0 | 37.37373208 | -77.5868014 | 2022-11-21 04:21:05 | Chesterfield, Virginia, US | |
2067229 | 2067229 | 2022-11-19 | US | Virginia | Chesterfield | 51041 | 93215 | 836 | 0 | 37.37373208 | -77.5868014 | 2022-11-20 04:21:08 | Chesterfield, Virginia, US | |
1758623 | 1758623 | 2022-11-18 | US | Virginia | Chesterfield | 51041 | 93215 | 836 | 0 | 37.37373208 | -77.5868014 | 2022-11-19 04:21:14 | Chesterfield, Virginia, US | |
3029616 | 3029616 | 2022-11-17 | US | Virginia | Chesterfield | 51041 | 93184 | 834 | 0 | 37.37373208 | -77.5868014 | 2022-11-18 04:21:15 | Chesterfield, Virginia, US | |
2489327 | 2489327 | 2022-11-16 | US | Virginia | Chesterfield | 51041 | 93146 | 832 | 0 | 37.37373208 | -77.5868014 | 2022-11-17 04:21:11 | Chesterfield, Virginia, US | |
295338 | 295338 | 2022-11-15 | US | Virginia | Chesterfield | 51041 | 93093 | 832 | 0 | 37.37373208 | -77.5868014 | 2022-11-16 04:21:09 | Chesterfield, Virginia, US | |
3600368 | 3600368 | 2022-11-14 | US | Virginia | Chesterfield | 51041 | 92967 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-15 04:21:16 | Chesterfield, Virginia, US | |
315226 | 315226 | 2022-11-13 | US | Virginia | Chesterfield | 51041 | 92967 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-14 04:21:09 | Chesterfield, Virginia, US | |
66387 | 66387 | 2022-11-12 | US | Virginia | Chesterfield | 51041 | 92967 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-13 04:21:14 | Chesterfield, Virginia, US | |
2930549 | 2930549 | 2022-11-11 | US | Virginia | Chesterfield | 51041 | 92967 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-12 04:20:41 | Chesterfield, Virginia, US | |
2509385 | 2509385 | 2022-11-10 | US | Virginia | Chesterfield | 51041 | 92928 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-11 04:21:22 | Chesterfield, Virginia, US | |
2434260 | 2434260 | 2022-11-09 | US | Virginia | Chesterfield | 51041 | 92877 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-10 04:21:16 | Chesterfield, Virginia, US | |
482916 | 482916 | 2022-11-08 | US | Virginia | Chesterfield | 51041 | 92844 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-09 04:21:22 | Chesterfield, Virginia, US | |
2442066 | 2442066 | 2022-11-07 | US | Virginia | Chesterfield | 51041 | 92796 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-08 04:21:21 | Chesterfield, Virginia, US | |
1053164 | 1053164 | 2022-11-06 | US | Virginia | Chesterfield | 51041 | 92663 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-07 04:21:26 | Chesterfield, Virginia, US | |
621188 | 621188 | 2022-11-05 | US | Virginia | Chesterfield | 51041 | 92663 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-06 04:21:24 | Chesterfield, Virginia, US | |
1025692 | 1025692 | 2022-11-04 | US | Virginia | Chesterfield | 51041 | 92663 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-05 04:21:52 | Chesterfield, Virginia, US | |
434683 | 434683 | 2022-11-03 | US | Virginia | Chesterfield | 51041 | 92619 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-04 04:22:11 | Chesterfield, Virginia, US | |
852925 | 852925 | 2022-11-02 | US | Virginia | Chesterfield | 51041 | 92576 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-03 04:22:05 | Chesterfield, Virginia, US | |
713776 | 713776 | 2022-11-01 | US | Virginia | Chesterfield | 51041 | 92527 | 830 | 0 | 37.37373208 | -77.5868014 | 2022-11-02 04:22:09 | Chesterfield, Virginia, US | |
3288225 | 3288225 | 2022-10-31 | US | Virginia | Chesterfield | 51041 | 92488 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-11-01 04:22:36 | Chesterfield, Virginia, US | |
323258 | 323258 | 2022-10-30 | US | Virginia | Chesterfield | 51041 | 92380 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-10-31 04:21:36 | Chesterfield, Virginia, US | |
915534 | 915534 | 2022-10-29 | US | Virginia | Chesterfield | 51041 | 92380 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-10-30 04:22:14 | Chesterfield, Virginia, US | |
1369803 | 1369803 | 2022-10-28 | US | Virginia | Chesterfield | 51041 | 92380 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-10-29 04:21:13 | Chesterfield, Virginia, US | |
3041658 | 3041658 | 2022-10-27 | US | Virginia | Chesterfield | 51041 | 92319 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-10-28 04:22:31 | Chesterfield, Virginia, US | |
542078 | 542078 | 2022-10-26 | US | Virginia | Chesterfield | 51041 | 92257 | 831 | 0 | 37.37373208 | -77.5868014 | 2022-10-27 04:22:01 | Chesterfield, Virginia, US | |
1833479 | 1833479 | 2022-10-25 | US | Virginia | Chesterfield | 51041 | 92217 | 829 | 0 | 37.37373208 | -77.5868014 | 2022-10-26 04:22:19 | Chesterfield, Virginia, US | |
797740 | 797740 | 2022-10-24 | US | Virginia | Chesterfield | 51041 | 92176 | 829 | 0 | 37.37373208 | -77.5868014 | 2022-10-25 04:21:53 | Chesterfield, Virginia, US | |
3280195 | 3280195 | 2022-10-23 | US | Virginia | Chesterfield | 51041 | 92058 | 828 | 0 | 37.37373208 | -77.5868014 | 2022-10-24 04:22:29 | Chesterfield, Virginia, US | |
2271233 | 2271233 | 2022-10-22 | US | Virginia | Chesterfield | 51041 | 92058 | 828 | 0 | 37.37373208 | -77.5868014 | 2022-10-23 04:22:46 | Chesterfield, Virginia, US | |
1595533 | 1595533 | 2022-10-21 | US | Virginia | Chesterfield | 51041 | 92058 | 828 | 0 | 37.37373208 | -77.5868014 | 2022-10-22 04:22:53 | Chesterfield, Virginia, US | |
2275249 | 2275249 | 2022-10-20 | US | Virginia | Chesterfield | 51041 | 92033 | 828 | 0 | 37.37373208 | -77.5868014 | 2022-10-21 04:22:23 | Chesterfield, Virginia, US | |
201584 | 201584 | 2022-10-19 | US | Virginia | Chesterfield | 51041 | 91973 | 828 | 0 | 37.37373208 | -77.5868014 | 2022-10-20 04:22:59 | Chesterfield, Virginia, US | |
2760245 | 2760245 | 2022-10-18 | US | Virginia | Chesterfield | 51041 | 91913 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-19 04:22:26 | Chesterfield, Virginia, US | |
2028079 | 2028079 | 2022-10-17 | US | Virginia | Chesterfield | 51041 | 91858 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-18 04:22:42 | Chesterfield, Virginia, US | |
2162857 | 2162857 | 2022-10-16 | US | Virginia | Chesterfield | 51041 | 91743 | 825 | 0 | 37.37373208 | -77.5868014 | 2022-10-17 04:20:31 | Chesterfield, Virginia, US | |
519054 | 519054 | 2022-10-15 | US | Virginia | Chesterfield | 51041 | 91743 | 825 | 0 | 37.37373208 | -77.5868014 | 2022-10-16 04:22:39 | Chesterfield, Virginia, US | |
2036111 | 2036111 | 2022-10-14 | US | Virginia | Chesterfield | 51041 | 91743 | 825 | 0 | 37.37373208 | -77.5868014 | 2022-10-15 04:22:00 | Chesterfield, Virginia, US | |
3756799 | 3756799 | 2022-10-13 | US | Virginia | Chesterfield | 51041 | 91693 | 825 | 0 | 37.37373208 | -77.5868014 | 2022-10-14 04:22:28 | Chesterfield, Virginia, US | |
3217624 | 3217624 | 2022-10-12 | US | Virginia | Chesterfield | 51041 | 91653 | 824 | 0 | 37.37373208 | -77.5868014 | 2022-10-13 04:22:39 | Chesterfield, Virginia, US | |
3253473 | 3253473 | 2022-10-11 | US | Virginia | Chesterfield | 51041 | 91599 | 823 | 0 | 37.37373208 | -77.5868014 | 2022-10-12 04:22:51 | Chesterfield, Virginia, US | |
2970732 | 2970732 | 2022-10-10 | US | Virginia | Chesterfield | 51041 | 91580 | 821 | 0 | 37.37373208 | -77.5868014 | 2022-10-11 04:23:05 | Chesterfield, Virginia, US | |
3100768 | 3100768 | 2022-10-09 | US | Virginia | Chesterfield | 51041 | 91457 | 821 | 0 | 37.37373208 | -77.5868014 | 2022-10-10 04:22:32 | Chesterfield, Virginia, US | |
4005993 | 4005993 | 2022-10-08 | US | Virginia | Chesterfield | 51041 | 91457 | 821 | 0 | 37.37373208 | -77.5868014 | 2022-10-09 04:21:16 | Chesterfield, Virginia, US | |
399590 | 399590 | 2022-10-07 | US | Virginia | Chesterfield | 51041 | 91457 | 821 | 0 | 37.37373208 | -77.5868014 | 2022-10-08 04:22:56 | Chesterfield, Virginia, US | |
2532707 | 2532707 | 2022-10-06 | US | Virginia | Chesterfield | 51041 | 91384 | 821 | 0 | 37.37373208 | -77.5868014 | 2022-10-07 04:23:08 | Chesterfield, Virginia, US | |
1814101 | 1814101 | 2022-10-05 | US | Virginia | Chesterfield | 51041 | 91266 | 820 | 0 | 37.37373208 | -77.5868014 | 2022-10-06 04:21:22 | Chesterfield, Virginia, US | |
134075 | 134075 | 2022-10-04 | US | Virginia | Chesterfield | 51041 | 91198 | 819 | 0 | 37.37373208 | -77.5868014 | 2022-10-05 04:23:06 | Chesterfield, Virginia, US | |
2689022 | 2689022 | 2022-10-03 | US | Virginia | Chesterfield | 51041 | 91161 | 818 | 0 | 37.37373208 | -77.5868014 | 2022-10-04 04:22:55 | Chesterfield, Virginia, US | |
2263089 | 2263089 | 2022-10-02 | US | Virginia | Chesterfield | 51041 | 91005 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-10-03 04:23:11 | Chesterfield, Virginia, US | |
2998615 | 2998615 | 2022-10-01 | US | Virginia | Chesterfield | 51041 | 91005 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-10-02 04:21:23 | Chesterfield, Virginia, US | |
856941 | 856941 | 2022-09-30 | US | Virginia | Chesterfield | 51041 | 91005 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-10-01 04:23:01 | Chesterfield, Virginia, US | |
2378867 | 2378867 | 2022-09-29 | US | Virginia | Chesterfield | 51041 | 91005 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-09-30 04:23:09 | Chesterfield, Virginia, US | |
1563418 | 1563418 | 2022-09-28 | US | Virginia | Chesterfield | 51041 | 90957 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-09-29 04:22:34 | Chesterfield, Virginia, US | |
3997961 | 3997961 | 2022-09-27 | US | Virginia | Chesterfield | 51041 | 90884 | 817 | 0 | 37.37373208 | -77.5868014 | 2022-09-28 04:23:01 | Chesterfield, Virginia, US | |
2772289 | 2772289 | 2022-09-26 | US | Virginia | Chesterfield | 51041 | 90831 | 815 | 0 | 37.37373208 | -77.5868014 | 2022-09-27 04:23:01 | Chesterfield, Virginia, US | |
1979942 | 1979942 | 2022-09-25 | US | Virginia | Chesterfield | 51041 | 90731 | 815 | 0 | 37.37373208 | -77.5868014 | 2022-09-26 04:20:52 | Chesterfield, Virginia, US | |
2653109 | 2653109 | 2022-09-24 | US | Virginia | Chesterfield | 51041 | 90731 | 815 | 0 | 37.37373208 | -77.5868014 | 2022-09-25 04:23:31 | Chesterfield, Virginia, US | |
387549 | 387549 | 2022-09-23 | US | Virginia | Chesterfield | 51041 | 90731 | 815 | 0 | 37.37373208 | -77.5868014 | 2022-09-24 04:21:40 | Chesterfield, Virginia, US | |
1627615 | 1627615 | 2022-09-22 | US | Virginia | Chesterfield | 51041 | 90651 | 815 | 0 | 37.37373208 | -77.5868014 | 2022-09-23 04:23:13 | Chesterfield, Virginia, US | |
1373819 | 1373819 | 2022-09-21 | US | Virginia | Chesterfield | 51041 | 90584 | 814 | 0 | 37.37373208 | -77.5868014 | 2022-09-22 04:22:56 | Chesterfield, Virginia, US |
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]);