johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where longitude = "-76.70905141" and province_or_state = "Virginia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756333 | 2756333 | 2022-12-29 | US | Virginia | Williamsburg | 51830 | 2209 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-30 04:21:04 | Williamsburg, Virginia, US | |
1077339 | 1077339 | 2022-12-28 | US | Virginia | Williamsburg | 51830 | 2209 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-29 04:21:01 | Williamsburg, Virginia, US | |
331336 | 331336 | 2022-12-27 | US | Virginia | Williamsburg | 51830 | 2207 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-28 04:21:04 | Williamsburg, Virginia, US | |
221409 | 221409 | 2022-12-26 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-27 04:21:07 | Williamsburg, Virginia, US | |
3225866 | 3225866 | 2022-12-25 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-26 04:21:06 | Williamsburg, Virginia, US | |
1021780 | 1021780 | 2022-12-24 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-25 04:21:04 | Williamsburg, Virginia, US | |
693803 | 693803 | 2022-12-23 | US | Virginia | Williamsburg | 51830 | 2206 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-24 04:21:02 | Williamsburg, Virginia, US | |
2183013 | 2183013 | 2022-12-22 | US | Virginia | Williamsburg | 51830 | 2207 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-23 04:21:04 | Williamsburg, Virginia, US | |
454817 | 454817 | 2022-12-21 | US | Virginia | Williamsburg | 51830 | 2205 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-22 04:20:56 | Williamsburg, Virginia, US | |
2954816 | 2954816 | 2022-12-20 | US | Virginia | Williamsburg | 51830 | 2202 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-21 04:21:03 | Williamsburg, Virginia, US | |
3177218 | 3177218 | 2022-12-19 | US | Virginia | Williamsburg | 51830 | 2202 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-20 04:21:04 | Williamsburg, Virginia, US | |
1631735 | 1631735 | 2022-12-18 | US | Virginia | Williamsburg | 51830 | 2200 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-19 04:21:03 | Williamsburg, Virginia, US | |
507114 | 507114 | 2022-12-17 | US | Virginia | Williamsburg | 51830 | 2200 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-18 04:21:03 | Williamsburg, Virginia, US | |
3327686 | 3327686 | 2022-12-16 | US | Virginia | Williamsburg | 51830 | 2200 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-17 04:21:04 | Williamsburg, Virginia, US | |
546198 | 546198 | 2022-12-15 | US | Virginia | Williamsburg | 51830 | 2200 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-16 04:21:01 | Williamsburg, Virginia, US | |
351726 | 351726 | 2022-12-14 | US | Virginia | Williamsburg | 51830 | 2200 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-15 04:20:58 | Williamsburg, Virginia, US | |
311314 | 311314 | 2022-12-13 | US | Virginia | Williamsburg | 51830 | 2198 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-14 04:21:04 | Williamsburg, Virginia, US | |
1152375 | 1152375 | 2022-12-12 | US | Virginia | Williamsburg | 51830 | 2198 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-13 04:21:01 | Williamsburg, Virginia, US | |
872229 | 872229 | 2022-12-11 | US | Virginia | Williamsburg | 51830 | 2196 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-12 04:21:01 | Williamsburg, Virginia, US | |
260759 | 260759 | 2022-12-10 | US | Virginia | Williamsburg | 51830 | 2196 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-11 04:20:50 | Williamsburg, Virginia, US | |
3939473 | 3939473 | 2022-12-09 | US | Virginia | Williamsburg | 51830 | 2196 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-10 04:21:02 | Williamsburg, Virginia, US | |
3380805 | 3380805 | 2022-12-08 | US | Virginia | Williamsburg | 51830 | 2196 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-09 04:21:05 | Williamsburg, Virginia, US | |
1988076 | 1988076 | 2022-12-07 | US | Virginia | Williamsburg | 51830 | 2196 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-08 04:21:07 | Williamsburg, Virginia, US | |
3717599 | 3717599 | 2022-12-06 | US | Virginia | Williamsburg | 51830 | 2195 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-07 04:20:58 | Williamsburg, Virginia, US | |
2418304 | 2418304 | 2022-12-05 | US | Virginia | Williamsburg | 51830 | 2194 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-06 04:21:03 | Williamsburg, Virginia, US | |
721912 | 721912 | 2022-12-04 | US | Virginia | Williamsburg | 51830 | 2194 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-05 04:20:58 | Williamsburg, Virginia, US | |
2820201 | 2820201 | 2022-12-03 | US | Virginia | Williamsburg | 51830 | 2194 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-04 04:20:56 | Williamsburg, Virginia, US | |
837057 | 837057 | 2022-12-02 | US | Virginia | Williamsburg | 51830 | 2194 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-03 04:21:02 | Williamsburg, Virginia, US | |
2139587 | 2139587 | 2022-12-01 | US | Virginia | Williamsburg | 51830 | 2193 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-02 04:21:07 | Williamsburg, Virginia, US | |
1968003 | 1968003 | 2022-11-30 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-01 04:21:03 | Williamsburg, Virginia, US | |
2560017 | 2560017 | 2022-11-29 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-30 04:21:07 | Williamsburg, Virginia, US | |
1243091 | 1243091 | 2022-11-28 | US | Virginia | Williamsburg | 51830 | 2189 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-29 04:21:05 | Williamsburg, Virginia, US | |
3555079 | 3555079 | 2022-11-27 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-28 04:21:02 | Williamsburg, Virginia, US | |
2103559 | 2103559 | 2022-11-26 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-27 04:21:05 | Williamsburg, Virginia, US | |
491050 | 491050 | 2022-11-25 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-26 04:21:11 | Williamsburg, Virginia, US | |
3526879 | 3526879 | 2022-11-24 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-25 04:21:06 | Williamsburg, Virginia, US | |
3315662 | 3315662 | 2022-11-23 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-24 04:21:09 | Williamsburg, Virginia, US | |
1623703 | 1623703 | 2022-11-22 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-23 04:21:06 | Williamsburg, Virginia, US | |
3463591 | 3463591 | 2022-11-21 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-22 04:20:47 | Williamsburg, Virginia, US | |
1643776 | 1643776 | 2022-11-20 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-21 04:21:05 | Williamsburg, Virginia, US | |
2067333 | 2067333 | 2022-11-19 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-20 04:21:08 | Williamsburg, Virginia, US | |
1758727 | 1758727 | 2022-11-18 | US | Virginia | Williamsburg | 51830 | 2187 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-11-19 04:21:14 | Williamsburg, Virginia, US | |
3029720 | 3029720 | 2022-11-17 | US | Virginia | Williamsburg | 51830 | 2187 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-18 04:21:15 | Williamsburg, Virginia, US | |
2489431 | 2489431 | 2022-11-16 | US | Virginia | Williamsburg | 51830 | 2186 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-17 04:21:11 | Williamsburg, Virginia, US | |
295442 | 295442 | 2022-11-15 | US | Virginia | Williamsburg | 51830 | 2185 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-16 04:21:09 | Williamsburg, Virginia, US | |
3600472 | 3600472 | 2022-11-14 | US | Virginia | Williamsburg | 51830 | 2183 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-15 04:21:16 | Williamsburg, Virginia, US | |
315330 | 315330 | 2022-11-13 | US | Virginia | Williamsburg | 51830 | 2183 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-14 04:21:09 | Williamsburg, Virginia, US | |
66491 | 66491 | 2022-11-12 | US | Virginia | Williamsburg | 51830 | 2183 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-13 04:21:14 | Williamsburg, Virginia, US | |
2930653 | 2930653 | 2022-11-11 | US | Virginia | Williamsburg | 51830 | 2183 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-12 04:20:41 | Williamsburg, Virginia, US | |
2509489 | 2509489 | 2022-11-10 | US | Virginia | Williamsburg | 51830 | 2182 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-11 04:21:22 | Williamsburg, Virginia, US | |
2434364 | 2434364 | 2022-11-09 | US | Virginia | Williamsburg | 51830 | 2181 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-10 04:21:16 | Williamsburg, Virginia, US | |
483020 | 483020 | 2022-11-08 | US | Virginia | Williamsburg | 51830 | 2180 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-09 04:21:22 | Williamsburg, Virginia, US | |
2442170 | 2442170 | 2022-11-07 | US | Virginia | Williamsburg | 51830 | 2179 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-08 04:21:21 | Williamsburg, Virginia, US | |
1053268 | 1053268 | 2022-11-06 | US | Virginia | Williamsburg | 51830 | 2176 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-07 04:21:26 | Williamsburg, Virginia, US | |
621292 | 621292 | 2022-11-05 | US | Virginia | Williamsburg | 51830 | 2176 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-06 04:21:24 | Williamsburg, Virginia, US | |
1025796 | 1025796 | 2022-11-04 | US | Virginia | Williamsburg | 51830 | 2176 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-05 04:21:52 | Williamsburg, Virginia, US | |
434787 | 434787 | 2022-11-03 | US | Virginia | Williamsburg | 51830 | 2174 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-04 04:22:11 | Williamsburg, Virginia, US | |
853029 | 853029 | 2022-11-02 | US | Virginia | Williamsburg | 51830 | 2172 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-03 04:22:05 | Williamsburg, Virginia, US | |
713880 | 713880 | 2022-11-01 | US | Virginia | Williamsburg | 51830 | 2173 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-02 04:22:09 | Williamsburg, Virginia, US | |
3288329 | 3288329 | 2022-10-31 | US | Virginia | Williamsburg | 51830 | 2170 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-01 04:22:36 | Williamsburg, Virginia, US | |
323362 | 323362 | 2022-10-30 | US | Virginia | Williamsburg | 51830 | 2165 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-31 04:21:36 | Williamsburg, Virginia, US | |
915638 | 915638 | 2022-10-29 | US | Virginia | Williamsburg | 51830 | 2165 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-30 04:22:14 | Williamsburg, Virginia, US | |
1369907 | 1369907 | 2022-10-28 | US | Virginia | Williamsburg | 51830 | 2165 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-29 04:21:13 | Williamsburg, Virginia, US | |
3041762 | 3041762 | 2022-10-27 | US | Virginia | Williamsburg | 51830 | 2165 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-28 04:22:31 | Williamsburg, Virginia, US | |
542182 | 542182 | 2022-10-26 | US | Virginia | Williamsburg | 51830 | 2162 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-27 04:22:01 | Williamsburg, Virginia, US | |
1833583 | 1833583 | 2022-10-25 | US | Virginia | Williamsburg | 51830 | 2161 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-26 04:22:19 | Williamsburg, Virginia, US | |
797844 | 797844 | 2022-10-24 | US | Virginia | Williamsburg | 51830 | 2159 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-25 04:21:53 | Williamsburg, Virginia, US | |
3280299 | 3280299 | 2022-10-23 | US | Virginia | Williamsburg | 51830 | 2156 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-24 04:22:29 | Williamsburg, Virginia, US | |
2271337 | 2271337 | 2022-10-22 | US | Virginia | Williamsburg | 51830 | 2156 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-23 04:22:46 | Williamsburg, Virginia, US | |
1595637 | 1595637 | 2022-10-21 | US | Virginia | Williamsburg | 51830 | 2156 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-22 04:22:53 | Williamsburg, Virginia, US | |
2275353 | 2275353 | 2022-10-20 | US | Virginia | Williamsburg | 51830 | 2147 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-21 04:22:23 | Williamsburg, Virginia, US | |
201688 | 201688 | 2022-10-19 | US | Virginia | Williamsburg | 51830 | 2145 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-20 04:22:59 | Williamsburg, Virginia, US | |
2760349 | 2760349 | 2022-10-18 | US | Virginia | Williamsburg | 51830 | 2142 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-19 04:22:26 | Williamsburg, Virginia, US | |
2028183 | 2028183 | 2022-10-17 | US | Virginia | Williamsburg | 51830 | 2140 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-18 04:22:42 | Williamsburg, Virginia, US | |
2162961 | 2162961 | 2022-10-16 | US | Virginia | Williamsburg | 51830 | 2137 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-17 04:20:31 | Williamsburg, Virginia, US | |
519158 | 519158 | 2022-10-15 | US | Virginia | Williamsburg | 51830 | 2137 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-16 04:22:39 | Williamsburg, Virginia, US | |
2036215 | 2036215 | 2022-10-14 | US | Virginia | Williamsburg | 51830 | 2137 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-15 04:22:00 | Williamsburg, Virginia, US | |
3756903 | 3756903 | 2022-10-13 | US | Virginia | Williamsburg | 51830 | 2133 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-14 04:22:28 | Williamsburg, Virginia, US | |
3217728 | 3217728 | 2022-10-12 | US | Virginia | Williamsburg | 51830 | 2133 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-13 04:22:39 | Williamsburg, Virginia, US | |
3253577 | 3253577 | 2022-10-11 | US | Virginia | Williamsburg | 51830 | 2128 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-12 04:22:51 | Williamsburg, Virginia, US | |
2970836 | 2970836 | 2022-10-10 | US | Virginia | Williamsburg | 51830 | 2124 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-11 04:23:05 | Williamsburg, Virginia, US | |
3100872 | 3100872 | 2022-10-09 | US | Virginia | Williamsburg | 51830 | 2121 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-10 04:22:32 | Williamsburg, Virginia, US | |
4006097 | 4006097 | 2022-10-08 | US | Virginia | Williamsburg | 51830 | 2121 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-09 04:21:16 | Williamsburg, Virginia, US | |
399694 | 399694 | 2022-10-07 | US | Virginia | Williamsburg | 51830 | 2121 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-08 04:22:56 | Williamsburg, Virginia, US | |
2532811 | 2532811 | 2022-10-06 | US | Virginia | Williamsburg | 51830 | 2118 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-07 04:23:08 | Williamsburg, Virginia, US | |
1814205 | 1814205 | 2022-10-05 | US | Virginia | Williamsburg | 51830 | 2115 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-06 04:21:22 | Williamsburg, Virginia, US | |
134179 | 134179 | 2022-10-04 | US | Virginia | Williamsburg | 51830 | 2113 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-05 04:23:06 | Williamsburg, Virginia, US | |
2689126 | 2689126 | 2022-10-03 | US | Virginia | Williamsburg | 51830 | 2110 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-04 04:22:55 | Williamsburg, Virginia, US | |
2263193 | 2263193 | 2022-10-02 | US | Virginia | Williamsburg | 51830 | 2105 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-03 04:23:11 | Williamsburg, Virginia, US | |
2998719 | 2998719 | 2022-10-01 | US | Virginia | Williamsburg | 51830 | 2105 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-02 04:21:23 | Williamsburg, Virginia, US | |
857045 | 857045 | 2022-09-30 | US | Virginia | Williamsburg | 51830 | 2105 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-01 04:23:01 | Williamsburg, Virginia, US | |
2378971 | 2378971 | 2022-09-29 | US | Virginia | Williamsburg | 51830 | 2105 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-30 04:23:09 | Williamsburg, Virginia, US | |
1563522 | 1563522 | 2022-09-28 | US | Virginia | Williamsburg | 51830 | 2103 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-29 04:22:34 | Williamsburg, Virginia, US | |
3998065 | 3998065 | 2022-09-27 | US | Virginia | Williamsburg | 51830 | 2100 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-28 04:23:01 | Williamsburg, Virginia, US | |
2772393 | 2772393 | 2022-09-26 | US | Virginia | Williamsburg | 51830 | 2096 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-27 04:23:01 | Williamsburg, Virginia, US | |
1980046 | 1980046 | 2022-09-25 | US | Virginia | Williamsburg | 51830 | 2087 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-26 04:20:52 | Williamsburg, Virginia, US | |
2653213 | 2653213 | 2022-09-24 | US | Virginia | Williamsburg | 51830 | 2087 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-25 04:23:31 | Williamsburg, Virginia, US | |
387653 | 387653 | 2022-09-23 | US | Virginia | Williamsburg | 51830 | 2087 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-24 04:21:40 | Williamsburg, Virginia, US | |
1627719 | 1627719 | 2022-09-22 | US | Virginia | Williamsburg | 51830 | 2082 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-23 04:23:13 | Williamsburg, Virginia, US | |
1373923 | 1373923 | 2022-09-21 | US | Virginia | Williamsburg | 51830 | 2080 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-22 04:22:56 | Williamsburg, 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]);