johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Baden-Wurttemberg" sorted by latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221 | 221 | 2021-12-02 | Germany | Baden-Wurttemberg | 847047 | 11843 | 0 | 48.6616 | 9.3501 | 2021-12-03 04:23:05 | Baden-Wurttemberg, Germany | |||
4237 | 4237 | 2021-10-28 | Germany | Baden-Wurttemberg | 623792 | 10959 | 0 | 48.6616 | 9.3501 | 2021-10-29 04:22:03 | Baden-Wurttemberg, Germany | |||
8239 | 8239 | 2020-10-25 | Germany | Baden-Wurttemberg | 68482 | 1970 | 52638 | 14970 | 48.6616 | 9.3501 | 2020-10-26 04:25:02 | Baden-Wurttemberg, Germany | ||
12247 | 12247 | 2021-01-26 | Germany | Baden-Wurttemberg | 285615 | 6728 | 254332 | 25806 | 48.6616 | 9.3501 | 2021-01-27 05:23:41 | Baden-Wurttemberg, Germany | ||
16262 | 16262 | 2021-09-18 | Germany | Baden-Wurttemberg | 554341 | 10534 | 0 | 48.6616 | 9.3501 | 2021-09-19 04:21:34 | Baden-Wurttemberg, Germany | |||
20277 | 20277 | 2021-05-28 | Germany | Baden-Wurttemberg | 490373 | 9915 | 464000 | 17487 | 48.6616 | 9.3501 | 2021-05-29 04:20:41 | Baden-Wurttemberg, Germany | ||
24292 | 24292 | 2022-03-20 | Germany | Baden-Wurttemberg | 2637048 | 14758 | 0 | 48.6616 | 9.3501 | 2022-03-21 04:20:50 | Baden-Wurttemberg, Germany | |||
28307 | 28307 | 2021-11-11 | Germany | Baden-Wurttemberg | 681537 | 11179 | 0 | 48.6616 | 9.3501 | 2021-11-12 04:22:01 | Baden-Wurttemberg, Germany | |||
32323 | 32323 | 2021-08-25 | Germany | Baden-Wurttemberg | 518705 | 10456 | 0 | 48.6616 | 9.3501 | 2021-08-26 04:21:28 | Baden-Wurttemberg, Germany | |||
36337 | 36337 | 2021-04-12 | Germany | Baden-Wurttemberg | 388266 | 8927 | 349900 | 30602 | 48.6616 | 9.3501 | 2021-04-13 04:20:37 | Baden-Wurttemberg, Germany | ||
43599 | 43599 | 2021-11-02 | Germany | Baden-Wurttemberg | 637267 | 11003 | 0 | 48.6616 | 9.3501 | 2021-11-03 06:22:09 | Baden-Wurttemberg, Germany | |||
50698 | 50698 | 2021-05-29 | Germany | Baden-Wurttemberg | 491213 | 9933 | 465300 | 16941 | 48.6616 | 9.3501 | 2021-05-30 04:20:55 | Baden-Wurttemberg, Germany | ||
54712 | 54712 | 2021-03-07 | Germany | Baden-Wurttemberg | 323442 | 8264 | 302479 | 13187 | 48.6616 | 9.3501 | 2021-03-08 05:24:48 | Baden-Wurttemberg, Germany | ||
61782 | 61782 | 2020-07-23 | Germany | Baden-Wurttemberg | 36565 | 1838 | 34150 | 752 | 48.6616 | 9.3501 | 2020-07-24 05:30:40 | Baden-Wurttemberg, Germany | ||
62953 | 62953 | 2022-11-12 | Germany | Baden-Wurttemberg | 4850542 | 17897 | 0 | 48.6616 | 9.3501 | 2022-11-13 04:21:14 | Baden-Wurttemberg, Germany | |||
66968 | 66968 | 2021-09-01 | Germany | Baden-Wurttemberg | 528106 | 10474 | 0 | 48.6616 | 9.3501 | 2021-09-02 04:21:15 | Baden-Wurttemberg, Germany | |||
70982 | 70982 | 2022-02-07 | Germany | Baden-Wurttemberg | 1536323 | 13776 | 0 | 48.6616 | 9.3501 | 2022-02-08 04:21:15 | Baden-Wurttemberg, Germany | |||
74996 | 74996 | 2020-12-03 | Germany | Baden-Wurttemberg | 155941 | 2883 | 112448 | 43646 | 48.6616 | 9.3501 | 2020-12-04 05:27:27 | Baden-Wurttemberg, Germany | ||
78995 | 78995 | 2020-10-14 | Germany | Baden-Wurttemberg | 55639 | 1909 | 47737 | 6832 | 48.6616 | 9.3501 | 2020-10-15 04:24:28 | Baden-Wurttemberg, Germany | ||
83002 | 83002 | 2021-05-25 | Germany | Baden-Wurttemberg | 487776 | 9849 | 458800 | 19662 | 48.6616 | 9.3501 | 2021-05-26 04:20:35 | Baden-Wurttemberg, Germany | ||
87016 | 87016 | 2021-11-09 | Germany | Baden-Wurttemberg | 666582 | 11126 | 0 | 48.6616 | 9.3501 | 2021-11-10 04:21:38 | Baden-Wurttemberg, Germany | |||
91033 | 91033 | 2022-07-23 | Germany | Baden-Wurttemberg | 4150369 | 16504 | 0 | 48.6616 | 9.3501 | 2022-07-24 04:20:47 | Baden-Wurttemberg, Germany | |||
98113 | 98113 | 2020-08-04 | Germany | Baden-Wurttemberg | 37455 | 1847 | 34700 | 975 | 48.6616 | 9.3501 | 2020-08-05 04:34:43 | Baden-Wurttemberg, Germany | ||
99217 | 99217 | 2022-01-14 | Germany | Baden-Wurttemberg | 1103455 | 13386 | 0 | 48.6616 | 9.3501 | 2022-01-15 04:21:07 | Baden-Wurttemberg, Germany | |||
103233 | 103233 | 2021-08-15 | Germany | Baden-Wurttemberg | 509833 | 10433 | 0 | 48.6616 | 9.3501 | 2021-08-16 04:21:31 | Baden-Wurttemberg, Germany | |||
107358 | 107358 | 2021-06-19 | Germany | Baden-Wurttemberg | 499089 | 10145 | 484600 | 4874 | 48.6616 | 9.3501 | 2021-06-20 04:21:48 | Baden-Wurttemberg, Germany | ||
114643 | 114643 | 2022-09-06 | Germany | Baden-Wurttemberg | 4400998 | 16999 | 0 | 48.6616 | 9.3501 | 2022-09-07 04:20:59 | Baden-Wurttemberg, Germany | |||
121706 | 121706 | 2020-07-19 | Germany | Baden-Wurttemberg | 36342 | 1838 | 34050 | 464 | 48.6616 | 9.3501 | 2020-07-20 05:34:40 | Baden-Wurttemberg, Germany | ||
122611 | 122611 | 2020-11-18 | Germany | Baden-Wurttemberg | 120870 | 2333 | 79536 | 42036 | 48.6616 | 9.3501 | 2020-11-19 05:25:23 | Baden-Wurttemberg, Germany | ||
126624 | 126624 | 2022-01-09 | Germany | Baden-Wurttemberg | 1047480 | 13183 | 0 | 48.6616 | 9.3501 | 2022-01-10 04:22:07 | Baden-Wurttemberg, Germany | |||
130641 | 130641 | 2022-10-04 | Germany | Baden-Wurttemberg | 4520888 | 17308 | 0 | 48.6616 | 9.3501 | 2022-10-05 04:23:06 | Baden-Wurttemberg, Germany | |||
137862 | 137862 | 2021-12-04 | Germany | Baden-Wurttemberg | 857957 | 11883 | 0 | 48.6616 | 9.3501 | 2021-12-05 04:22:25 | Baden-Wurttemberg, Germany | |||
141879 | 141879 | 2022-07-09 | Germany | Baden-Wurttemberg | 3954862 | 16393 | 0 | 48.6616 | 9.3501 | 2022-07-10 04:20:54 | Baden-Wurttemberg, Germany | |||
145879 | 145879 | 2020-08-15 | Germany | Baden-Wurttemberg | 38422 | 1859 | 35400 | 1166 | 48.6616 | 9.3501 | 2020-08-16 04:27:42 | Baden-Wurttemberg, Germany | ||
149875 | 149875 | 2021-11-29 | Germany | Baden-Wurttemberg | 819228 | 11700 | 0 | 48.6616 | 9.3501 | 2021-11-30 04:22:53 | Baden-Wurttemberg, Germany | |||
153890 | 153890 | 2021-01-08 | Germany | Baden-Wurttemberg | 254652 | 5337 | 210300 | 41639 | 48.6616 | 9.3501 | 2021-01-09 05:22:18 | Baden-Wurttemberg, Germany | ||
157904 | 157904 | 2022-03-29 | Germany | Baden-Wurttemberg | 2958848 | 15005 | 0 | 48.6616 | 9.3501 | 2022-03-30 04:20:45 | Baden-Wurttemberg, Germany | |||
161919 | 161919 | 2021-11-19 | Germany | Baden-Wurttemberg | 738896 | 11411 | 0 | 48.6616 | 9.3501 | 2021-11-20 04:22:17 | Baden-Wurttemberg, Germany | |||
165936 | 165936 | 2022-06-21 | Germany | Baden-Wurttemberg | 3768735 | 16239 | 0 | 48.6616 | 9.3501 | 2022-06-22 04:20:54 | Baden-Wurttemberg, Germany | |||
169951 | 169951 | 2021-04-16 | Germany | Baden-Wurttemberg | 399982 | 9022 | 356100 | 38424 | 48.6616 | 9.3501 | 2021-04-17 04:20:40 | Baden-Wurttemberg, Germany | ||
177024 | 177024 | 2020-07-27 | Germany | Baden-Wurttemberg | 36819 | 1841 | 34260 | 825 | 48.6616 | 9.3501 | 2020-07-28 04:58:43 | Baden-Wurttemberg, Germany | ||
177933 | 177933 | 2021-09-02 | Germany | Baden-Wurttemberg | 530407 | 10480 | 0 | 48.6616 | 9.3501 | 2021-09-03 04:21:20 | Baden-Wurttemberg, Germany | |||
181947 | 181947 | 2021-02-21 | Germany | Baden-Wurttemberg | 310854 | 7939 | 290824 | 12423 | 48.6616 | 9.3501 | 2021-02-22 05:24:21 | Baden-Wurttemberg, Germany | ||
185962 | 185962 | 2022-02-13 | Germany | Baden-Wurttemberg | 1657536 | 13875 | 0 | 48.6616 | 9.3501 | 2022-02-14 04:20:51 | Baden-Wurttemberg, Germany | |||
189976 | 189976 | 2021-01-11 | Germany | Baden-Wurttemberg | 261487 | 5575 | 218170 | 38674 | 48.6616 | 9.3501 | 2021-01-12 05:22:15 | Baden-Wurttemberg, Germany | ||
193974 | 193974 | 2020-08-31 | Germany | Baden-Wurttemberg | 41942 | 1866 | 36976 | 3275 | 48.6616 | 9.3501 | 2020-09-01 04:28:31 | Baden-Wurttemberg, Germany | ||
198150 | 198150 | 2022-10-19 | Germany | Baden-Wurttemberg | 4725533 | 17512 | 0 | 48.6616 | 9.3501 | 2022-10-20 04:22:59 | Baden-Wurttemberg, Germany | |||
202163 | 202163 | 2020-12-25 | Germany | Baden-Wurttemberg | 221854 | 4331 | 169337 | 53568 | 48.6616 | 9.3501 | 2020-12-26 05:22:28 | Baden-Wurttemberg, Germany | ||
206161 | 206161 | 2020-08-19 | Germany | Baden-Wurttemberg | 38968 | 1860 | 35704 | 1666 | 48.6616 | 9.3501 | 2020-08-20 04:27:43 | Baden-Wurttemberg, Germany | ||
210147 | 210147 | 2020-10-29 | Germany | Baden-Wurttemberg | 75164 | 2000 | 54611 | 20828 | 48.6616 | 9.3501 | 2020-10-30 04:24:49 | Baden-Wurttemberg, Germany | ||
217014 | 217014 | 2020-06-08 | Germany | Baden-Wurttemberg | 34937 | 1791 | 32506 | 648 | 48.6616 | 9.3501 | 2020-06-09 03:33:03 | Baden-Wurttemberg, Germany | ||
217871 | 217871 | 2022-12-26 | Germany | Baden-Wurttemberg | 4953505 | 18482 | 0 | 48.6616 | 9.3501 | 2022-12-27 04:21:07 | Baden-Wurttemberg, Germany | |||
221887 | 221887 | 2022-05-09 | Germany | Baden-Wurttemberg | 3547527 | 15871 | 0 | 48.6616 | 9.3501 | 2022-05-10 04:20:50 | Baden-Wurttemberg, Germany | |||
229118 | 229118 | 2022-05-31 | Germany | Baden-Wurttemberg | 3669628 | 16113 | 0 | 48.6616 | 9.3501 | 2022-06-01 04:20:55 | Baden-Wurttemberg, Germany | |||
233134 | 233134 | 2022-02-11 | Germany | Baden-Wurttemberg | 1657536 | 13875 | 0 | 48.6616 | 9.3501 | 2022-02-12 04:21:06 | Baden-Wurttemberg, Germany | |||
237148 | 237148 | 2021-01-18 | Germany | Baden-Wurttemberg | 274829 | 6111 | 234191 | 35005 | 48.6616 | 9.3501 | 2021-01-19 05:22:15 | Baden-Wurttemberg, Germany | ||
241162 | 241162 | 2021-04-02 | Germany | Baden-Wurttemberg | 367675 | 8728 | 332700 | 28893 | 48.6616 | 9.3501 | 2021-04-03 04:20:44 | Baden-Wurttemberg, Germany | ||
245176 | 245176 | 2021-08-17 | Germany | Baden-Wurttemberg | 511490 | 10436 | 0 | 48.6616 | 9.3501 | 2021-08-18 04:21:35 | Baden-Wurttemberg, Germany | |||
249190 | 249190 | 2021-09-04 | Germany | Baden-Wurttemberg | 532254 | 10492 | 0 | 48.6616 | 9.3501 | 2021-09-05 04:21:33 | Baden-Wurttemberg, Germany | |||
253205 | 253205 | 2022-09-08 | Germany | Baden-Wurttemberg | 4409439 | 17026 | 0 | 48.6616 | 9.3501 | 2022-09-09 04:21:11 | Baden-Wurttemberg, Germany | |||
257221 | 257221 | 2022-12-10 | Germany | Baden-Wurttemberg | 4917977 | 18313 | 0 | 48.6616 | 9.3501 | 2022-12-11 04:20:50 | Baden-Wurttemberg, Germany | |||
261424 | 261424 | 2022-03-15 | Germany | Baden-Wurttemberg | 2513508 | 14672 | 0 | 48.6616 | 9.3501 | 2022-03-16 04:20:50 | Baden-Wurttemberg, Germany | |||
268233 | 268233 | 2020-05-21 | Germany | Baden-Wurttemberg | 34175 | 1680 | 30800 | 1728 | 48.6616 | 9.3501 | 2020-05-22 02:36:51 | Baden-Wurttemberg, Germany | ||
272062 | 272062 | 2020-11-10 | Germany | Baden-Wurttemberg | 102293 | 2133 | 66745 | 35795 | 48.6616 | 9.3501 | 2020-11-11 05:25:30 | Baden-Wurttemberg, Germany | ||
276074 | 276074 | 2021-11-03 | Germany | Baden-Wurttemberg | 639130 | 11019 | 0 | 48.6616 | 9.3501 | 2021-11-04 04:22:20 | Baden-Wurttemberg, Germany | |||
280090 | 280090 | 2021-02-24 | Germany | Baden-Wurttemberg | 312399 | 7985 | 293779 | 11766 | 48.6616 | 9.3501 | 2021-02-25 05:24:57 | Baden-Wurttemberg, Germany | ||
286995 | 286995 | 2020-06-15 | Germany | Baden-Wurttemberg | 35090 | 1805 | 32900 | 446 | 48.6616 | 9.3501 | 2020-06-16 04:33:09 | Baden-Wurttemberg, Germany | ||
287887 | 287887 | 2021-10-31 | Germany | Baden-Wurttemberg | 627721 | 10975 | 0 | 48.6616 | 9.3501 | 2021-11-01 04:22:01 | Baden-Wurttemberg, Germany | |||
291904 | 291904 | 2022-11-15 | Germany | Baden-Wurttemberg | 4859329 | 17954 | 0 | 48.6616 | 9.3501 | 2022-11-16 04:21:09 | Baden-Wurttemberg, Germany | |||
295919 | 295919 | 2021-07-15 | Germany | Baden-Wurttemberg | 502187 | 10328 | 490200 | 1953 | 48.6616 | 9.3501 | 2021-07-16 04:21:22 | Baden-Wurttemberg, Germany | ||
302867 | 302867 | 2020-07-01 | Germany | Baden-Wurttemberg | 35694 | 1838 | 33300 | 617 | 48.6616 | 9.3501 | 2020-07-02 04:33:46 | Baden-Wurttemberg, Germany | ||
303760 | 303760 | 2022-04-16 | Germany | Baden-Wurttemberg | 3291866 | 15482 | 0 | 48.6616 | 9.3501 | 2022-04-17 04:20:59 | Baden-Wurttemberg, Germany | |||
307776 | 307776 | 2022-12-13 | Germany | Baden-Wurttemberg | 4924857 | 18341 | 0 | 48.6616 | 9.3501 | 2022-12-14 04:21:04 | Baden-Wurttemberg, Germany | |||
311792 | 311792 | 2022-11-13 | Germany | Baden-Wurttemberg | 4850542 | 17897 | 0 | 48.6616 | 9.3501 | 2022-11-14 04:21:09 | Baden-Wurttemberg, Germany | |||
315808 | 315808 | 2022-02-12 | Germany | Baden-Wurttemberg | 1657536 | 13875 | 0 | 48.6616 | 9.3501 | 2022-02-13 04:21:00 | Baden-Wurttemberg, Germany | |||
319824 | 319824 | 2022-10-30 | Germany | Baden-Wurttemberg | 4802473 | 17687 | 0 | 48.6616 | 9.3501 | 2022-10-31 04:21:36 | Baden-Wurttemberg, Germany | |||
326801 | 326801 | 2020-07-20 | Germany | Baden-Wurttemberg | 36342 | 1838 | 34150 | 514 | 48.6616 | 9.3501 | 2020-07-21 04:38:46 | Baden-Wurttemberg, Germany | ||
327798 | 327798 | 2022-12-27 | Germany | Baden-Wurttemberg | 4955988 | 18494 | 0 | 48.6616 | 9.3501 | 2022-12-28 04:21:04 | Baden-Wurttemberg, Germany | |||
331813 | 331813 | 2021-08-04 | Germany | Baden-Wurttemberg | 506312 | 10411 | 493100 | 3365 | 48.6616 | 9.3501 | 2021-08-05 04:21:51 | Baden-Wurttemberg, Germany | ||
335828 | 335828 | 2022-03-18 | Germany | Baden-Wurttemberg | 2637048 | 14758 | 0 | 48.6616 | 9.3501 | 2022-03-19 04:20:47 | Baden-Wurttemberg, Germany | |||
340182 | 340182 | 2021-02-03 | Germany | Baden-Wurttemberg | 295395 | 7227 | 267688 | 21786 | 48.6616 | 9.3501 | 2021-02-04 05:22:26 | Baden-Wurttemberg, Germany | ||
344182 | 344182 | 2020-09-14 | Germany | Baden-Wurttemberg | 45254 | 1867 | 39954 | 3646 | 48.6616 | 9.3501 | 2020-09-15 03:22:50 | Baden-Wurttemberg, Germany | ||
348188 | 348188 | 2022-12-14 | Germany | Baden-Wurttemberg | 4928906 | 18357 | 0 | 48.6616 | 9.3501 | 2022-12-15 04:20:58 | Baden-Wurttemberg, Germany | |||
352203 | 352203 | 2021-03-11 | Germany | Baden-Wurttemberg | 327180 | 8346 | 305970 | 14429 | 48.6616 | 9.3501 | 2021-03-12 05:26:50 | Baden-Wurttemberg, Germany | ||
356218 | 356218 | 2022-03-11 | Germany | Baden-Wurttemberg | 2400070 | 14584 | 0 | 48.6616 | 9.3501 | 2022-03-12 04:20:50 | Baden-Wurttemberg, Germany | |||
360234 | 360234 | 2022-05-07 | Germany | Baden-Wurttemberg | 3538913 | 15855 | 0 | 48.6616 | 9.3501 | 2022-05-08 04:20:49 | Baden-Wurttemberg, Germany | |||
367216 | 367216 | 2020-07-16 | Germany | Baden-Wurttemberg | 36227 | 1838 | 33980 | 455 | 48.6616 | 9.3501 | 2020-07-17 04:34:50 | Baden-Wurttemberg, Germany | ||
371178 | 371178 | 2020-08-08 | Germany | Baden-Wurttemberg | 37749 | 1858 | 34889 | 1005 | 48.6616 | 9.3501 | 2020-08-09 04:34:54 | Baden-Wurttemberg, Germany | ||
372088 | 372088 | 2022-09-13 | Germany | Baden-Wurttemberg | 4421116 | 17052 | 0 | 48.6616 | 9.3501 | 2022-09-14 04:20:44 | Baden-Wurttemberg, Germany | |||
376089 | 376089 | 2020-11-06 | Germany | Baden-Wurttemberg | 93264 | 2092 | 62190 | 32305 | 48.6616 | 9.3501 | 2020-11-07 05:24:52 | Baden-Wurttemberg, Germany | ||
380100 | 380100 | 2021-04-30 | Germany | Baden-Wurttemberg | 443007 | 9340 | 389700 | 47335 | 48.6616 | 9.3501 | 2021-05-01 04:20:47 | Baden-Wurttemberg, Germany | ||
384115 | 384115 | 2022-09-23 | Germany | Baden-Wurttemberg | 4461205 | 17243 | 0 | 48.6616 | 9.3501 | 2022-09-24 04:21:40 | Baden-Wurttemberg, Germany | |||
388130 | 388130 | 2021-04-04 | Germany | Baden-Wurttemberg | 371389 | 8743 | 333900 | 29760 | 48.6616 | 9.3501 | 2021-04-05 04:20:35 | Baden-Wurttemberg, Germany | ||
392142 | 392142 | 2020-11-27 | Germany | Baden-Wurttemberg | 142878 | 2626 | 98910 | 44034 | 48.6616 | 9.3501 | 2020-11-28 05:25:50 | Baden-Wurttemberg, Germany | ||
396156 | 396156 | 2022-10-07 | Germany | Baden-Wurttemberg | 4578110 | 17341 | 0 | 48.6616 | 9.3501 | 2022-10-08 04:22:56 | Baden-Wurttemberg, Germany | |||
400171 | 400171 | 2021-06-29 | Germany | Baden-Wurttemberg | 500428 | 10235 | 488100 | 2475 | 48.6616 | 9.3501 | 2021-06-30 04:21:41 | Baden-Wurttemberg, Germany | ||
404185 | 404185 | 2021-12-07 | Germany | Baden-Wurttemberg | 885188 | 12026 | 0 | 48.6616 | 9.3501 | 2021-12-08 04:22:46 | Baden-Wurttemberg, Germany | |||
408201 | 408201 | 2021-07-28 | Germany | Baden-Wurttemberg | 504603 | 10385 | 492900 | 1831 | 48.6616 | 9.3501 | 2021-07-29 04:21:33 | Baden-Wurttemberg, Germany | ||
415159 | 415159 | 2020-07-05 | Germany | Baden-Wurttemberg | 35807 | 1837 | 33570 | 408 | 48.6616 | 9.3501 | 2020-07-06 04:33:57 | Baden-Wurttemberg, Germany | ||
419227 | 419227 | 2022-09-18 | Germany | Baden-Wurttemberg | 4434416 | 17193 | 0 | 48.6616 | 9.3501 | 2022-09-19 04:21:49 | Baden-Wurttemberg, Germany |
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]);