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 = "Nordrhein-Westfalen" sorted by recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
230 | 230 | 2021-12-02 | Germany | Nordrhein-Westfalen | 1191138 | 19075 | 0 | 51.4332 | 7.6616 | 2021-12-03 04:23:05 | Nordrhein-Westfalen, Germany | |||
4246 | 4246 | 2021-10-28 | Germany | Nordrhein-Westfalen | 1004653 | 18177 | 0 | 51.4332 | 7.6616 | 2021-10-29 04:22:03 | Nordrhein-Westfalen, Germany | |||
16271 | 16271 | 2021-09-18 | Germany | Nordrhein-Westfalen | 938040 | 17617 | 0 | 51.4332 | 7.6616 | 2021-09-19 04:21:34 | Nordrhein-Westfalen, Germany | |||
24301 | 24301 | 2022-03-20 | Germany | Nordrhein-Westfalen | 3728711 | 23054 | 0 | 51.4332 | 7.6616 | 2022-03-21 04:20:50 | Nordrhein-Westfalen, Germany | |||
28316 | 28316 | 2021-11-11 | Germany | Nordrhein-Westfalen | 1051982 | 18424 | 0 | 51.4332 | 7.6616 | 2021-11-12 04:22:01 | Nordrhein-Westfalen, Germany | |||
32332 | 32332 | 2021-08-25 | Germany | Nordrhein-Westfalen | 870356 | 17383 | 0 | 51.4332 | 7.6616 | 2021-08-26 04:21:28 | Nordrhein-Westfalen, Germany | |||
43608 | 43608 | 2021-11-02 | Germany | Nordrhein-Westfalen | 1016517 | 18222 | 0 | 51.4332 | 7.6616 | 2021-11-03 06:22:09 | Nordrhein-Westfalen, Germany | |||
62962 | 62962 | 2022-11-12 | Germany | Nordrhein-Westfalen | 7405099 | 28499 | 0 | 51.4332 | 7.6616 | 2022-11-13 04:21:14 | Nordrhein-Westfalen, Germany | |||
66977 | 66977 | 2021-09-01 | Germany | Nordrhein-Westfalen | 893502 | 17424 | 0 | 51.4332 | 7.6616 | 2021-09-02 04:21:15 | Nordrhein-Westfalen, Germany | |||
70991 | 70991 | 2022-02-07 | Germany | Nordrhein-Westfalen | 2274359 | 21281 | 0 | 51.4332 | 7.6616 | 2022-02-08 04:21:15 | Nordrhein-Westfalen, Germany | |||
87025 | 87025 | 2021-11-09 | Germany | Nordrhein-Westfalen | 1040402 | 18376 | 0 | 51.4332 | 7.6616 | 2021-11-10 04:21:38 | Nordrhein-Westfalen, Germany | |||
91042 | 91042 | 2022-07-23 | Germany | Nordrhein-Westfalen | 6144977 | 26169 | 0 | 51.4332 | 7.6616 | 2022-07-24 04:20:47 | Nordrhein-Westfalen, Germany | |||
99226 | 99226 | 2022-01-14 | Germany | Nordrhein-Westfalen | 1521697 | 20722 | 0 | 51.4332 | 7.6616 | 2022-01-15 04:21:07 | Nordrhein-Westfalen, Germany | |||
103242 | 103242 | 2021-08-15 | Germany | Nordrhein-Westfalen | 840295 | 17318 | 0 | 51.4332 | 7.6616 | 2021-08-16 04:21:31 | Nordrhein-Westfalen, Germany | |||
114652 | 114652 | 2022-09-06 | Germany | Nordrhein-Westfalen | 6625433 | 27109 | 0 | 51.4332 | 7.6616 | 2022-09-07 04:20:59 | Nordrhein-Westfalen, Germany | |||
126633 | 126633 | 2022-01-09 | Germany | Nordrhein-Westfalen | 1436484 | 20537 | 0 | 51.4332 | 7.6616 | 2022-01-10 04:22:07 | Nordrhein-Westfalen, Germany | |||
130650 | 130650 | 2022-10-04 | Germany | Nordrhein-Westfalen | 6828814 | 27508 | 0 | 51.4332 | 7.6616 | 2022-10-05 04:23:06 | Nordrhein-Westfalen, Germany | |||
137871 | 137871 | 2021-12-04 | Germany | Nordrhein-Westfalen | 1201564 | 19134 | 0 | 51.4332 | 7.6616 | 2021-12-05 04:22:25 | Nordrhein-Westfalen, Germany | |||
141888 | 141888 | 2022-07-09 | Germany | Nordrhein-Westfalen | 5909232 | 25873 | 0 | 51.4332 | 7.6616 | 2022-07-10 04:20:54 | Nordrhein-Westfalen, Germany | |||
149884 | 149884 | 2021-11-29 | Germany | Nordrhein-Westfalen | 1164535 | 18899 | 0 | 51.4332 | 7.6616 | 2021-11-30 04:22:53 | Nordrhein-Westfalen, Germany | |||
157913 | 157913 | 2022-03-29 | Germany | Nordrhein-Westfalen | 4124435 | 23477 | 0 | 51.4332 | 7.6616 | 2022-03-30 04:20:45 | Nordrhein-Westfalen, Germany | |||
161928 | 161928 | 2021-11-19 | Germany | Nordrhein-Westfalen | 1095261 | 18630 | 0 | 51.4332 | 7.6616 | 2021-11-20 04:22:17 | Nordrhein-Westfalen, Germany | |||
165945 | 165945 | 2022-06-21 | Germany | Nordrhein-Westfalen | 5531269 | 25605 | 0 | 51.4332 | 7.6616 | 2022-06-22 04:20:54 | Nordrhein-Westfalen, Germany | |||
177942 | 177942 | 2021-09-02 | Germany | Nordrhein-Westfalen | 897937 | 17437 | 0 | 51.4332 | 7.6616 | 2021-09-03 04:21:20 | Nordrhein-Westfalen, Germany | |||
185971 | 185971 | 2022-02-13 | Germany | Nordrhein-Westfalen | 2475864 | 21456 | 0 | 51.4332 | 7.6616 | 2022-02-14 04:20:51 | Nordrhein-Westfalen, Germany | |||
198159 | 198159 | 2022-10-19 | Germany | Nordrhein-Westfalen | 7113931 | 27816 | 0 | 51.4332 | 7.6616 | 2022-10-20 04:22:59 | Nordrhein-Westfalen, Germany | |||
217880 | 217880 | 2022-12-26 | Germany | Nordrhein-Westfalen | 7731379 | 29684 | 0 | 51.4332 | 7.6616 | 2022-12-27 04:21:07 | Nordrhein-Westfalen, Germany | |||
221896 | 221896 | 2022-05-09 | Germany | Nordrhein-Westfalen | 5055871 | 24931 | 0 | 51.4332 | 7.6616 | 2022-05-10 04:20:50 | Nordrhein-Westfalen, Germany | |||
229127 | 229127 | 2022-05-31 | Germany | Nordrhein-Westfalen | 5276525 | 25405 | 0 | 51.4332 | 7.6616 | 2022-06-01 04:20:55 | Nordrhein-Westfalen, Germany | |||
233143 | 233143 | 2022-02-11 | Germany | Nordrhein-Westfalen | 2475864 | 21456 | 0 | 51.4332 | 7.6616 | 2022-02-12 04:21:06 | Nordrhein-Westfalen, Germany | |||
245185 | 245185 | 2021-08-17 | Germany | Nordrhein-Westfalen | 846063 | 17333 | 0 | 51.4332 | 7.6616 | 2021-08-18 04:21:35 | Nordrhein-Westfalen, Germany | |||
249199 | 249199 | 2021-09-04 | Germany | Nordrhein-Westfalen | 901945 | 17452 | 0 | 51.4332 | 7.6616 | 2021-09-05 04:21:33 | Nordrhein-Westfalen, Germany | |||
253214 | 253214 | 2022-09-08 | Germany | Nordrhein-Westfalen | 6646450 | 27160 | 0 | 51.4332 | 7.6616 | 2022-09-09 04:21:11 | Nordrhein-Westfalen, Germany | |||
257230 | 257230 | 2022-12-10 | Germany | Nordrhein-Westfalen | 7599255 | 29249 | 0 | 51.4332 | 7.6616 | 2022-12-11 04:20:50 | Nordrhein-Westfalen, Germany | |||
261433 | 261433 | 2022-03-15 | Germany | Nordrhein-Westfalen | 3569737 | 22880 | 0 | 51.4332 | 7.6616 | 2022-03-16 04:20:50 | Nordrhein-Westfalen, Germany | |||
276083 | 276083 | 2021-11-03 | Germany | Nordrhein-Westfalen | 1018424 | 18257 | 0 | 51.4332 | 7.6616 | 2021-11-04 04:22:20 | Nordrhein-Westfalen, Germany | |||
287896 | 287896 | 2021-10-31 | Germany | Nordrhein-Westfalen | 1008481 | 18189 | 0 | 51.4332 | 7.6616 | 2021-11-01 04:22:01 | Nordrhein-Westfalen, Germany | |||
291913 | 291913 | 2022-11-15 | Germany | Nordrhein-Westfalen | 7427680 | 28582 | 0 | 51.4332 | 7.6616 | 2022-11-16 04:21:09 | Nordrhein-Westfalen, Germany | |||
303769 | 303769 | 2022-04-16 | Germany | Nordrhein-Westfalen | 4618594 | 24234 | 0 | 51.4332 | 7.6616 | 2022-04-17 04:20:59 | Nordrhein-Westfalen, Germany | |||
307785 | 307785 | 2022-12-13 | Germany | Nordrhein-Westfalen | 7622560 | 29331 | 0 | 51.4332 | 7.6616 | 2022-12-14 04:21:04 | Nordrhein-Westfalen, Germany | |||
311801 | 311801 | 2022-11-13 | Germany | Nordrhein-Westfalen | 7405099 | 28499 | 0 | 51.4332 | 7.6616 | 2022-11-14 04:21:09 | Nordrhein-Westfalen, Germany | |||
315817 | 315817 | 2022-02-12 | Germany | Nordrhein-Westfalen | 2475864 | 21456 | 0 | 51.4332 | 7.6616 | 2022-02-13 04:21:00 | Nordrhein-Westfalen, Germany | |||
319833 | 319833 | 2022-10-30 | Germany | Nordrhein-Westfalen | 7270270 | 28102 | 0 | 51.4332 | 7.6616 | 2022-10-31 04:21:36 | Nordrhein-Westfalen, Germany | |||
327807 | 327807 | 2022-12-27 | Germany | Nordrhein-Westfalen | 7741626 | 29730 | 0 | 51.4332 | 7.6616 | 2022-12-28 04:21:04 | Nordrhein-Westfalen, Germany | |||
335837 | 335837 | 2022-03-18 | Germany | Nordrhein-Westfalen | 3728711 | 23054 | 0 | 51.4332 | 7.6616 | 2022-03-19 04:20:47 | Nordrhein-Westfalen, Germany | |||
348197 | 348197 | 2022-12-14 | Germany | Nordrhein-Westfalen | 7635848 | 29375 | 0 | 51.4332 | 7.6616 | 2022-12-15 04:20:58 | Nordrhein-Westfalen, Germany | |||
356227 | 356227 | 2022-03-11 | Germany | Nordrhein-Westfalen | 3444060 | 22753 | 0 | 51.4332 | 7.6616 | 2022-03-12 04:20:50 | Nordrhein-Westfalen, Germany | |||
360243 | 360243 | 2022-05-07 | Germany | Nordrhein-Westfalen | 5032738 | 24909 | 0 | 51.4332 | 7.6616 | 2022-05-08 04:20:49 | Nordrhein-Westfalen, Germany | |||
372097 | 372097 | 2022-09-13 | Germany | Nordrhein-Westfalen | 6672564 | 27204 | 0 | 51.4332 | 7.6616 | 2022-09-14 04:20:44 | Nordrhein-Westfalen, Germany | |||
384124 | 384124 | 2022-09-23 | Germany | Nordrhein-Westfalen | 6746704 | 27338 | 0 | 51.4332 | 7.6616 | 2022-09-24 04:21:40 | Nordrhein-Westfalen, Germany | |||
396165 | 396165 | 2022-10-07 | Germany | Nordrhein-Westfalen | 6906724 | 27577 | 0 | 51.4332 | 7.6616 | 2022-10-08 04:22:56 | Nordrhein-Westfalen, Germany | |||
404194 | 404194 | 2021-12-07 | Germany | Nordrhein-Westfalen | 1228640 | 19260 | 0 | 51.4332 | 7.6616 | 2021-12-08 04:22:46 | Nordrhein-Westfalen, Germany | |||
419236 | 419236 | 2022-09-18 | Germany | Nordrhein-Westfalen | 6699076 | 27251 | 0 | 51.4332 | 7.6616 | 2022-09-19 04:21:49 | Nordrhein-Westfalen, Germany | |||
423251 | 423251 | 2021-10-10 | Germany | Nordrhein-Westfalen | 969554 | 17912 | 0 | 51.4332 | 7.6616 | 2021-10-11 04:21:31 | Nordrhein-Westfalen, Germany | |||
431258 | 431258 | 2022-11-03 | Germany | Nordrhein-Westfalen | 7326273 | 28249 | 0 | 51.4332 | 7.6616 | 2022-11-04 04:22:11 | Nordrhein-Westfalen, Germany | |||
443255 | 443255 | 2021-10-20 | Germany | Nordrhein-Westfalen | 985200 | 18054 | 0 | 51.4332 | 7.6616 | 2021-10-21 04:21:18 | Nordrhein-Westfalen, Germany | |||
447271 | 447271 | 2021-11-17 | Germany | Nordrhein-Westfalen | 1080319 | 18577 | 0 | 51.4332 | 7.6616 | 2021-11-18 04:21:33 | Nordrhein-Westfalen, Germany | |||
451288 | 451288 | 2022-12-21 | Germany | Nordrhein-Westfalen | 7703150 | 29584 | 0 | 51.4332 | 7.6616 | 2022-12-22 04:20:56 | Nordrhein-Westfalen, Germany | |||
459280 | 459280 | 2022-02-02 | Germany | Nordrhein-Westfalen | 2066527 | 21172 | 0 | 51.4332 | 7.6616 | 2022-02-03 04:21:21 | Nordrhein-Westfalen, Germany | |||
463297 | 463297 | 2022-05-02 | Germany | Nordrhein-Westfalen | 4957902 | 24749 | 0 | 51.4332 | 7.6616 | 2022-05-03 04:21:00 | Nordrhein-Westfalen, Germany | |||
467312 | 467312 | 2021-10-07 | Germany | Nordrhein-Westfalen | 967779 | 17897 | 0 | 51.4332 | 7.6616 | 2021-10-08 04:21:25 | Nordrhein-Westfalen, Germany | |||
475343 | 475343 | 2022-06-26 | Germany | Nordrhein-Westfalen | 5621816 | 25657 | 0 | 51.4332 | 7.6616 | 2022-06-27 04:21:00 | Nordrhein-Westfalen, Germany | |||
479491 | 479491 | 2022-11-08 | Germany | Nordrhein-Westfalen | 7371186 | 28379 | 0 | 51.4332 | 7.6616 | 2022-11-09 04:21:22 | Nordrhein-Westfalen, Germany | |||
487521 | 487521 | 2022-11-25 | Germany | Nordrhein-Westfalen | 7503070 | 28900 | 0 | 51.4332 | 7.6616 | 2022-11-26 04:21:11 | Nordrhein-Westfalen, Germany | |||
491536 | 491536 | 2021-10-14 | Germany | Nordrhein-Westfalen | 977115 | 17995 | 0 | 51.4332 | 7.6616 | 2021-10-15 04:21:26 | Nordrhein-Westfalen, Germany | |||
495552 | 495552 | 2021-11-06 | Germany | Nordrhein-Westfalen | 1028520 | 18305 | 0 | 51.4332 | 7.6616 | 2021-11-07 04:21:53 | Nordrhein-Westfalen, Germany | |||
499569 | 499569 | 2022-04-02 | Germany | Nordrhein-Westfalen | 4266992 | 23674 | 0 | 51.4332 | 7.6616 | 2022-04-03 04:20:48 | Nordrhein-Westfalen, Germany | |||
503585 | 503585 | 2022-12-17 | Germany | Nordrhein-Westfalen | 7660940 | 29464 | 0 | 51.4332 | 7.6616 | 2022-12-18 04:21:03 | Nordrhein-Westfalen, Germany | |||
507600 | 507600 | 2021-08-14 | Germany | Nordrhein-Westfalen | 840295 | 17318 | 0 | 51.4332 | 7.6616 | 2021-08-15 04:21:41 | Nordrhein-Westfalen, Germany | |||
511614 | 511614 | 2021-08-19 | Germany | Nordrhein-Westfalen | 851794 | 17348 | 0 | 51.4332 | 7.6616 | 2021-08-20 04:21:33 | Nordrhein-Westfalen, Germany | |||
515629 | 515629 | 2022-10-15 | Germany | Nordrhein-Westfalen | 7032122 | 27723 | 0 | 51.4332 | 7.6616 | 2022-10-16 04:22:39 | Nordrhein-Westfalen, Germany | |||
534636 | 534636 | 2021-10-27 | Germany | Nordrhein-Westfalen | 1000033 | 18157 | 0 | 51.4332 | 7.6616 | 2021-10-28 04:22:08 | Nordrhein-Westfalen, Germany | |||
538653 | 538653 | 2022-10-26 | Germany | Nordrhein-Westfalen | 7230564 | 28042 | 0 | 51.4332 | 7.6616 | 2022-10-27 04:22:01 | Nordrhein-Westfalen, Germany | |||
542669 | 542669 | 2022-12-15 | Germany | Nordrhein-Westfalen | 7648485 | 29446 | 0 | 51.4332 | 7.6616 | 2022-12-16 04:21:01 | Nordrhein-Westfalen, Germany | |||
550674 | 550674 | 2021-12-08 | Germany | Nordrhein-Westfalen | 1237349 | 19337 | 0 | 51.4332 | 7.6616 | 2021-12-09 04:22:49 | Nordrhein-Westfalen, Germany | |||
554690 | 554690 | 2022-01-16 | Germany | Nordrhein-Westfalen | 1521697 | 20722 | 0 | 51.4332 | 7.6616 | 2022-01-17 04:21:08 | Nordrhein-Westfalen, Germany | |||
558707 | 558707 | 2022-06-16 | Germany | Nordrhein-Westfalen | 5473994 | 25581 | 0 | 51.4332 | 7.6616 | 2022-06-17 04:20:56 | Nordrhein-Westfalen, Germany | |||
567004 | 567004 | 2021-10-29 | Germany | Nordrhein-Westfalen | 1008481 | 18189 | 0 | 51.4332 | 7.6616 | 2021-10-30 04:22:03 | Nordrhein-Westfalen, Germany | |||
574733 | 574733 | 2022-02-25 | Germany | Nordrhein-Westfalen | 2976909 | 22141 | 0 | 51.4332 | 7.6616 | 2022-02-26 04:21:12 | Nordrhein-Westfalen, Germany | |||
589544 | 589544 | 2021-08-08 | Germany | Nordrhein-Westfalen | 831773 | 17303 | 0 | 51.4332 | 7.6616 | 2021-08-09 04:21:24 | Nordrhein-Westfalen, Germany | |||
593559 | 593559 | 2022-07-01 | Germany | Nordrhein-Westfalen | 5771588 | 25763 | 0 | 51.4332 | 7.6616 | 2022-07-02 04:21:16 | Nordrhein-Westfalen, Germany | |||
597574 | 597574 | 2021-10-19 | Germany | Nordrhein-Westfalen | 983014 | 18036 | 0 | 51.4332 | 7.6616 | 2021-10-20 04:21:00 | Nordrhein-Westfalen, Germany | |||
601590 | 601590 | 2021-09-23 | Germany | Nordrhein-Westfalen | 947843 | 17694 | 0 | 51.4332 | 7.6616 | 2021-09-24 04:21:44 | Nordrhein-Westfalen, Germany | |||
617763 | 617763 | 2022-11-05 | Germany | Nordrhein-Westfalen | 7342235 | 28294 | 0 | 51.4332 | 7.6616 | 2022-11-06 04:21:24 | Nordrhein-Westfalen, Germany | |||
621779 | 621779 | 2022-05-22 | Germany | Nordrhein-Westfalen | 5202683 | 25244 | 0 | 51.4332 | 7.6616 | 2022-05-26 04:20:50 | Nordrhein-Westfalen, Germany | |||
629809 | 629809 | 2022-07-12 | Germany | Nordrhein-Westfalen | 5960016 | 25904 | 0 | 51.4332 | 7.6616 | 2022-07-13 04:20:58 | Nordrhein-Westfalen, Germany | |||
633824 | 633824 | 2021-10-13 | Germany | Nordrhein-Westfalen | 975243 | 17974 | 0 | 51.4332 | 7.6616 | 2021-10-14 04:21:29 | Nordrhein-Westfalen, Germany | |||
641854 | 641854 | 2021-09-07 | Germany | Nordrhein-Westfalen | 911550 | 17481 | 0 | 51.4332 | 7.6616 | 2021-09-08 04:21:31 | Nordrhein-Westfalen, Germany | |||
649882 | 649882 | 2021-08-09 | Germany | Nordrhein-Westfalen | 834235 | 17305 | 0 | 51.4332 | 7.6616 | 2021-08-10 04:21:27 | Nordrhein-Westfalen, Germany | |||
653896 | 653896 | 2021-10-22 | Germany | Nordrhein-Westfalen | 990051 | 18097 | 0 | 51.4332 | 7.6616 | 2021-10-23 04:21:32 | Nordrhein-Westfalen, Germany | |||
658215 | 658215 | 2022-05-13 | Germany | Nordrhein-Westfalen | 5126034 | 25089 | 0 | 51.4332 | 7.6616 | 2022-05-14 04:20:48 | Nordrhein-Westfalen, Germany | |||
670200 | 670200 | 2022-07-21 | Germany | Nordrhein-Westfalen | 6125946 | 26148 | 0 | 51.4332 | 7.6616 | 2022-07-22 04:21:15 | Nordrhein-Westfalen, Germany | |||
674216 | 674216 | 2022-07-30 | Germany | Nordrhein-Westfalen | 6243768 | 26348 | 0 | 51.4332 | 7.6616 | 2022-07-31 04:21:02 | Nordrhein-Westfalen, Germany | |||
682241 | 682241 | 2021-10-24 | Germany | Nordrhein-Westfalen | 990051 | 18097 | 0 | 51.4332 | 7.6616 | 2021-10-25 04:22:31 | Nordrhein-Westfalen, Germany | |||
686257 | 686257 | 2021-11-13 | Germany | Nordrhein-Westfalen | 1057847 | 18445 | 0 | 51.4332 | 7.6616 | 2021-11-14 04:21:31 | Nordrhein-Westfalen, Germany | |||
690274 | 690274 | 2022-12-23 | Germany | Nordrhein-Westfalen | 7731379 | 29684 | 0 | 51.4332 | 7.6616 | 2022-12-24 04:21:02 | Nordrhein-Westfalen, Germany | |||
694290 | 694290 | 2022-03-17 | Germany | Nordrhein-Westfalen | 3675329 | 23002 | 0 | 51.4332 | 7.6616 | 2022-03-18 04:20:55 | Nordrhein-Westfalen, Germany | |||
698305 | 698305 | 2021-11-04 | Germany | Nordrhein-Westfalen | 1022966 | 18283 | 0 | 51.4332 | 7.6616 | 2021-11-05 04:21:54 | Nordrhein-Westfalen, Germany | |||
706335 | 706335 | 2021-09-29 | Germany | Nordrhein-Westfalen | 955827 | 17802 | 0 | 51.4332 | 7.6616 | 2021-09-30 04:21:20 | Nordrhein-Westfalen, Germany | |||
710351 | 710351 | 2022-11-01 | Germany | Nordrhein-Westfalen | 7303275 | 28179 | 0 | 51.4332 | 7.6616 | 2022-11-02 04:22:09 | Nordrhein-Westfalen, 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]);