johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
635 rows where country_or_region = "Netherlands" and latitude = "52.60090600000001" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
province_or_state 1
- Noord-Holland 635
country_or_region 1
- Netherlands · 635 ✖
Link | rowid ▼ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
458 | 458 | 2021-12-02 | Netherlands | Noord-Holland | 444156 | 2887 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-12-03 04:23:05 | Noord-Holland, Netherlands | |||
4474 | 4474 | 2021-10-28 | Netherlands | Noord-Holland | 359313 | 2753 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-29 04:22:03 | Noord-Holland, Netherlands | |||
8455 | 8455 | 2020-10-25 | Netherlands | Noord-Holland | 57369 | 965 | 0 | 56325 | 52.60090600000001 | 4.918688 | 2020-10-26 04:25:02 | Noord-Holland, Netherlands | ||
12466 | 12466 | 2021-01-26 | Netherlands | Noord-Holland | 161577 | 1960 | 0 | 159403 | 52.60090600000001 | 4.918688 | 2021-01-27 05:23:41 | Noord-Holland, Netherlands | ||
16482 | 16482 | 2021-09-18 | Netherlands | Noord-Holland | 343458 | 2721 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-09-19 04:21:34 | Noord-Holland, Netherlands | |||
20497 | 20497 | 2021-05-28 | Netherlands | Noord-Holland | 272369 | 2592 | 0 | 269292 | 52.60090600000001 | 4.918688 | 2021-05-29 04:20:41 | Noord-Holland, Netherlands | ||
24529 | 24529 | 2022-03-20 | Netherlands | Noord-Holland | 1229747 | 3287 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-21 04:20:50 | Noord-Holland, Netherlands | |||
28544 | 28544 | 2021-11-11 | Netherlands | Noord-Holland | 379211 | 2785 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-12 04:22:01 | Noord-Holland, Netherlands | |||
32543 | 32543 | 2021-08-25 | Netherlands | Noord-Holland | 332794 | 2685 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-08-26 04:21:28 | Noord-Holland, Netherlands | |||
36556 | 36556 | 2021-04-12 | Netherlands | Noord-Holland | 233695 | 2464 | 0 | 230861 | 52.60090600000001 | 4.918688 | 2021-04-13 04:20:37 | Noord-Holland, Netherlands | ||
43836 | 43836 | 2021-11-02 | Netherlands | Noord-Holland | 364337 | 2757 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-03 06:22:09 | Noord-Holland, Netherlands | |||
50918 | 50918 | 2021-05-29 | Netherlands | Noord-Holland | 272868 | 2592 | 0 | 269789 | 52.60090600000001 | 4.918688 | 2021-05-30 04:20:55 | Noord-Holland, Netherlands | ||
54931 | 54931 | 2021-03-07 | Netherlands | Noord-Holland | 193640 | 2290 | 0 | 191158 | 52.60090600000001 | 4.918688 | 2021-03-08 05:24:48 | Noord-Holland, Netherlands | ||
62035 | 62035 | 2020-07-23 | Netherlands | Noord-Holland | 7689 | 817 | 0 | 6844 | 52.60090600000001 | 4.918688 | 2020-07-24 05:30:40 | Noord-Holland, Netherlands | ||
67188 | 67188 | 2021-09-01 | Netherlands | Noord-Holland | 336184 | 2700 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-09-02 04:21:15 | Noord-Holland, Netherlands | |||
71219 | 71219 | 2022-02-07 | Netherlands | Noord-Holland | 872343 | 3192 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-08 04:21:15 | Noord-Holland, Netherlands | |||
75214 | 75214 | 2020-12-03 | Netherlands | Noord-Holland | 96835 | 1317 | 0 | 95505 | 52.60090600000001 | 4.918688 | 2020-12-04 05:27:27 | Noord-Holland, Netherlands | ||
79211 | 79211 | 2020-10-14 | Netherlands | Noord-Holland | 39386 | 911 | 0 | 38398 | 52.60090600000001 | 4.918688 | 2020-10-15 04:24:28 | Noord-Holland, Netherlands | ||
83221 | 83221 | 2021-05-25 | Netherlands | Noord-Holland | 271072 | 2586 | 0 | 268014 | 52.60090600000001 | 4.918688 | 2021-05-26 04:20:35 | Noord-Holland, Netherlands | ||
87253 | 87253 | 2021-11-09 | Netherlands | Noord-Holland | 374818 | 2782 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-10 04:21:38 | Noord-Holland, Netherlands | |||
98384 | 98384 | 2020-08-04 | Netherlands | Noord-Holland | 8534 | 817 | 0 | 7686 | 52.60090600000001 | 4.918688 | 2020-08-05 04:34:43 | Noord-Holland, Netherlands | ||
99454 | 99454 | 2022-01-14 | Netherlands | Noord-Holland | 600185 | 3142 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-01-15 04:21:07 | Noord-Holland, Netherlands | |||
103453 | 103453 | 2021-08-15 | Netherlands | Noord-Holland | 327670 | 2665 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-08-16 04:21:31 | Noord-Holland, Netherlands | |||
107578 | 107578 | 2021-06-19 | Netherlands | Noord-Holland | 277584 | 2624 | 0 | 274375 | 52.60090600000001 | 4.918688 | 2021-06-20 04:21:48 | Noord-Holland, Netherlands | ||
121976 | 121976 | 2020-07-19 | Netherlands | Noord-Holland | 7543 | 816 | 0 | 6709 | 52.60090600000001 | 4.9186879999999995 | 2020-07-20 05:34:40 | Noord-Holland, Netherlands | ||
122829 | 122829 | 2020-11-18 | Netherlands | Noord-Holland | 84699 | 1199 | 0 | 83468 | 52.60090600000001 | 4.918688 | 2020-11-19 05:25:23 | Noord-Holland, Netherlands | ||
126861 | 126861 | 2022-01-09 | Netherlands | Noord-Holland | 565573 | 3136 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-01-10 04:22:07 | Noord-Holland, Netherlands | |||
138099 | 138099 | 2021-12-04 | Netherlands | Noord-Holland | 450952 | 2904 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-12-05 04:22:25 | Noord-Holland, Netherlands | |||
146095 | 146095 | 2020-08-15 | Netherlands | Noord-Holland | 10262 | 822 | 0 | 9405 | 52.60090600000001 | 4.918688 | 2020-08-16 04:27:42 | Noord-Holland, Netherlands | ||
150112 | 150112 | 2021-11-29 | Netherlands | Noord-Holland | 435138 | 2865 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-30 04:22:53 | Noord-Holland, Netherlands | |||
154108 | 154108 | 2021-01-08 | Netherlands | Noord-Holland | 146153 | 1767 | 0 | 144171 | 52.60090600000001 | 4.918688 | 2021-01-09 05:22:18 | Noord-Holland, Netherlands | ||
158141 | 158141 | 2022-03-29 | Netherlands | Noord-Holland | 1275429 | 3307 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-30 04:20:45 | Noord-Holland, Netherlands | |||
162156 | 162156 | 2021-11-19 | Netherlands | Noord-Holland | 401251 | 2812 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-20 04:22:17 | Noord-Holland, Netherlands | |||
170170 | 170170 | 2021-04-16 | Netherlands | Noord-Holland | 237852 | 2477 | 0 | 234992 | 52.60090600000001 | 4.918688 | 2021-04-17 04:20:40 | Noord-Holland, Netherlands | ||
177294 | 177294 | 2020-07-27 | Netherlands | Noord-Holland | 7868 | 817 | 0 | 7023 | 52.60090600000001 | 4.918688 | 2020-07-28 04:58:43 | Noord-Holland, Netherlands | ||
178153 | 178153 | 2021-09-02 | Netherlands | Noord-Holland | 336726 | 2700 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-09-03 04:21:20 | Noord-Holland, Netherlands | |||
182166 | 182166 | 2021-02-21 | Netherlands | Noord-Holland | 179963 | 2203 | 0 | 177555 | 52.60090600000001 | 4.918688 | 2021-02-22 05:24:21 | Noord-Holland, Netherlands | ||
186199 | 186199 | 2022-02-13 | Netherlands | Noord-Holland | 983642 | 3213 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-14 04:20:51 | Noord-Holland, Netherlands | |||
190194 | 190194 | 2021-01-11 | Netherlands | Noord-Holland | 148892 | 1801 | 0 | 146854 | 52.60090600000001 | 4.918688 | 2021-01-12 05:22:15 | Noord-Holland, Netherlands | ||
194190 | 194190 | 2020-08-31 | Netherlands | Noord-Holland | 12459 | 829 | 0 | 11597 | 52.60090600000001 | 4.918688 | 2020-09-01 04:28:31 | Noord-Holland, Netherlands | ||
202381 | 202381 | 2020-12-25 | Netherlands | Noord-Holland | 128344 | 1552 | 0 | 126597 | 52.60090600000001 | 4.918688 | 2020-12-26 05:22:28 | Noord-Holland, Netherlands | ||
206377 | 206377 | 2020-08-19 | Netherlands | Noord-Holland | 10869 | 825 | 0 | 10007 | 52.60090600000001 | 4.918688 | 2020-08-20 04:27:43 | Noord-Holland, Netherlands | ||
210364 | 210364 | 2020-10-29 | Netherlands | Noord-Holland | 63815 | 1005 | 0 | 62742 | 52.60090600000001 | 4.918688 | 2020-10-30 04:24:49 | Noord-Holland, Netherlands | ||
233371 | 233371 | 2022-02-11 | Netherlands | Noord-Holland | 965592 | 3209 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-12 04:21:06 | Noord-Holland, Netherlands | |||
237366 | 237366 | 2021-01-18 | Netherlands | Noord-Holland | 154976 | 1891 | 0 | 152855 | 52.60090600000001 | 4.918688 | 2021-01-19 05:22:15 | Noord-Holland, Netherlands | ||
241381 | 241381 | 2021-04-02 | Netherlands | Noord-Holland | 223315 | 2428 | 0 | 220565 | 52.60090600000001 | 4.918688 | 2021-04-03 04:20:44 | Noord-Holland, Netherlands | ||
245396 | 245396 | 2021-08-17 | Netherlands | Noord-Holland | 328643 | 2668 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-08-18 04:21:35 | Noord-Holland, Netherlands | |||
249410 | 249410 | 2021-09-04 | Netherlands | Noord-Holland | 337720 | 2705 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-09-05 04:21:33 | Noord-Holland, Netherlands | |||
261661 | 261661 | 2022-03-15 | Netherlands | Noord-Holland | 1192509 | 3278 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-16 04:20:50 | Noord-Holland, Netherlands | |||
272279 | 272279 | 2020-11-10 | Netherlands | Noord-Holland | 77776 | 1124 | 0 | 76584 | 52.60090600000001 | 4.918688 | 2020-11-11 05:25:30 | Noord-Holland, Netherlands | ||
276311 | 276311 | 2021-11-03 | Netherlands | Noord-Holland | 365469 | 2763 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-04 04:22:20 | Noord-Holland, Netherlands | |||
280309 | 280309 | 2021-02-24 | Netherlands | Noord-Holland | 182526 | 2237 | 0 | 180070 | 52.60090600000001 | 4.918688 | 2021-02-25 05:24:57 | Noord-Holland, Netherlands | ||
288124 | 288124 | 2021-10-31 | Netherlands | Noord-Holland | 362368 | 2755 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-01 04:22:01 | Noord-Holland, Netherlands | |||
296139 | 296139 | 2021-07-15 | Netherlands | Noord-Holland | 299328 | 2635 | 0 | 296009 | 52.60090600000001 | 4.918688 | 2021-07-16 04:21:22 | Noord-Holland, Netherlands | ||
303997 | 303997 | 2022-04-16 | Netherlands | Noord-Holland | 1310542 | 3348 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-04-17 04:20:59 | Noord-Holland, Netherlands | |||
316045 | 316045 | 2022-02-12 | Netherlands | Noord-Holland | 975504 | 3211 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-13 04:21:00 | Noord-Holland, Netherlands | |||
327071 | 327071 | 2020-07-20 | Netherlands | Noord-Holland | 7578 | 816 | 0 | 6709 | 52.60090600000001 | 4.9186879999999995 | 2020-07-21 04:38:46 | Noord-Holland, Netherlands | ||
332033 | 332033 | 2021-08-04 | Netherlands | Noord-Holland | 322181 | 2652 | 0 | 318526 | 52.60090600000001 | 4.918688 | 2021-08-05 04:21:51 | Noord-Holland, Netherlands | ||
336065 | 336065 | 2022-03-18 | Netherlands | Noord-Holland | 1218356 | 3281 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-19 04:20:47 | Noord-Holland, Netherlands | |||
340401 | 340401 | 2021-02-03 | Netherlands | Noord-Holland | 167072 | 2032 | 0 | 164814 | 52.60090600000001 | 4.918688 | 2021-02-04 05:22:26 | Noord-Holland, Netherlands | ||
344398 | 344398 | 2020-09-14 | Netherlands | Noord-Holland | 15824 | 836 | 0 | 14921 | 52.60090600000001 | 4.918688 | 2020-09-15 03:22:50 | Noord-Holland, Netherlands | ||
352422 | 352422 | 2021-03-11 | Netherlands | Noord-Holland | 197168 | 2310 | 0 | 194632 | 52.60090600000001 | 4.918688 | 2021-03-12 05:26:50 | Noord-Holland, Netherlands | ||
356455 | 356455 | 2022-03-11 | Netherlands | Noord-Holland | 1160786 | 3268 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-03-12 04:20:50 | Noord-Holland, Netherlands | |||
371449 | 371449 | 2020-08-08 | Netherlands | Noord-Holland | 9072 | 818 | 0 | 8224 | 52.60090600000001 | 4.918688 | 2020-08-09 04:34:54 | Noord-Holland, Netherlands | ||
376306 | 376306 | 2020-11-06 | Netherlands | Noord-Holland | 74069 | 1084 | 0 | 72911 | 52.60090600000001 | 4.918688 | 2020-11-07 05:24:52 | Noord-Holland, Netherlands | ||
380319 | 380319 | 2021-04-30 | Netherlands | Noord-Holland | 252628 | 2513 | 0 | 249686 | 52.60090600000001 | 4.918688 | 2021-05-01 04:20:47 | Noord-Holland, Netherlands | ||
388349 | 388349 | 2021-04-04 | Netherlands | Noord-Holland | 225532 | 2433 | 0 | 222799 | 52.60090600000001 | 4.918688 | 2021-04-05 04:20:35 | Noord-Holland, Netherlands | ||
392360 | 392360 | 2020-11-27 | Netherlands | Noord-Holland | 92153 | 1279 | 0 | 90858 | 52.60090600000001 | 4.918688 | 2020-11-28 05:25:50 | Noord-Holland, Netherlands | ||
400391 | 400391 | 2021-06-29 | Netherlands | Noord-Holland | 278707 | 2628 | 0 | 275483 | 52.60090600000001 | 4.918688 | 2021-06-30 04:21:41 | Noord-Holland, Netherlands | ||
404422 | 404422 | 2021-12-07 | Netherlands | Noord-Holland | 460602 | 2919 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-12-08 04:22:46 | Noord-Holland, Netherlands | |||
408421 | 408421 | 2021-07-28 | Netherlands | Noord-Holland | 318390 | 2644 | 0 | 314805 | 52.60090600000001 | 4.918688 | 2021-07-29 04:21:33 | Noord-Holland, Netherlands | ||
423479 | 423479 | 2021-10-10 | Netherlands | Noord-Holland | 348688 | 2735 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-11 04:21:31 | Noord-Holland, Netherlands | |||
427459 | 427459 | 2020-09-07 | Netherlands | Noord-Holland | 13754 | 832 | 0 | 12882 | 52.60090600000001 | 4.918688 | 2020-09-08 04:28:25 | Noord-Holland, Netherlands | ||
435482 | 435482 | 2021-01-21 | Netherlands | Noord-Holland | 157553 | 1919 | 0 | 155409 | 52.60090600000001 | 4.918688 | 2021-01-22 05:22:10 | Noord-Holland, Netherlands | ||
442607 | 442607 | 2020-07-26 | Netherlands | Noord-Holland | 7807 | 817 | 0 | 6916 | 52.60090600000001 | 4.918688 | 2020-07-27 04:35:02 | Noord-Holland, Netherlands | ||
443483 | 443483 | 2021-10-20 | Netherlands | Noord-Holland | 352990 | 2746 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-21 04:21:18 | Noord-Holland, Netherlands | |||
447499 | 447499 | 2021-11-17 | Netherlands | Noord-Holland | 394655 | 2802 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-18 04:21:33 | Noord-Holland, Netherlands | |||
458633 | 458633 | 2020-08-07 | Netherlands | Noord-Holland | 8941 | 817 | 0 | 8091 | 52.60090600000001 | 4.918688 | 2020-08-08 04:34:53 | Noord-Holland, Netherlands | ||
459508 | 459508 | 2022-02-02 | Netherlands | Noord-Holland | 811880 | 3179 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-03 04:21:21 | Noord-Holland, Netherlands | |||
467540 | 467540 | 2021-10-07 | Netherlands | Noord-Holland | 347658 | 2734 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-08 04:21:25 | Noord-Holland, Netherlands | |||
471538 | 471538 | 2021-02-19 | Netherlands | Noord-Holland | 178163 | 2193 | 0 | 175759 | 52.60090600000001 | 4.918688 | 2021-02-20 05:22:51 | Noord-Holland, Netherlands | ||
483717 | 483717 | 2021-07-19 | Netherlands | Noord-Holland | 308613 | 2637 | 0 | 305173 | 52.60090600000001 | 4.918688 | 2021-07-20 04:21:48 | Noord-Holland, Netherlands | ||
491764 | 491764 | 2021-10-14 | Netherlands | Noord-Holland | 350186 | 2739 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-15 04:21:26 | Noord-Holland, Netherlands | |||
495780 | 495780 | 2021-11-06 | Netherlands | Noord-Holland | 370094 | 2770 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-11-07 04:21:53 | Noord-Holland, Netherlands | |||
499797 | 499797 | 2022-04-02 | Netherlands | Noord-Holland | 1289781 | 3321 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-04-03 04:20:48 | Noord-Holland, Netherlands | |||
507811 | 507811 | 2021-08-14 | Netherlands | Noord-Holland | 327205 | 2664 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-08-15 04:21:41 | Noord-Holland, Netherlands | |||
511825 | 511825 | 2021-08-19 | Netherlands | Noord-Holland | 329641 | 2670 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-08-20 04:21:33 | Noord-Holland, Netherlands | |||
522984 | 522984 | 2021-06-09 | Netherlands | Noord-Holland | 275845 | 2615 | 0 | 272698 | 52.60090600000001 | 4.918688 | 2021-06-10 04:23:17 | Noord-Holland, Netherlands | ||
530832 | 530832 | 2021-02-22 | Netherlands | Noord-Holland | 180807 | 2211 | 0 | 178370 | 52.60090600000001 | 4.918688 | 2021-02-23 05:23:41 | Noord-Holland, Netherlands | ||
534864 | 534864 | 2021-10-27 | Netherlands | Noord-Holland | 358530 | 2753 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-28 04:22:08 | Noord-Holland, Netherlands | |||
546876 | 546876 | 2020-09-12 | Netherlands | Noord-Holland | 15181 | 834 | 0 | 14282 | 52.60090600000001 | 4.918688 | 2020-09-13 04:30:52 | Noord-Holland, Netherlands | ||
550902 | 550902 | 2021-12-08 | Netherlands | Noord-Holland | 463549 | 2927 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-12-09 04:22:49 | Noord-Holland, Netherlands | |||
554918 | 554918 | 2022-01-16 | Netherlands | Noord-Holland | 614762 | 3143 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-01-17 04:21:08 | Noord-Holland, Netherlands | |||
563094 | 563094 | 2021-06-22 | Netherlands | Noord-Holland | 277947 | 2626 | 0 | 274733 | 52.60090600000001 | 4.918688 | 2021-06-23 04:21:46 | Noord-Holland, Netherlands | ||
567232 | 567232 | 2021-10-29 | Netherlands | Noord-Holland | 360268 | 2754 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-30 04:22:03 | Noord-Holland, Netherlands | |||
574961 | 574961 | 2022-02-25 | Netherlands | Noord-Holland | 1061078 | 3245 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-26 04:21:12 | Noord-Holland, Netherlands | |||
578959 | 578959 | 2021-07-13 | Netherlands | Noord-Holland | 293837 | 2631 | 0 | 290583 | 52.60090600000001 | 4.918688 | 2021-07-14 04:21:35 | Noord-Holland, Netherlands | ||
582954 | 582954 | 2020-08-13 | Netherlands | Noord-Holland | 9872 | 821 | 0 | 9018 | 52.60090600000001 | 4.918688 | 2020-08-14 04:51:19 | Noord-Holland, Netherlands | ||
589755 | 589755 | 2021-08-08 | Netherlands | Noord-Holland | 324359 | 2659 | 0 | 52.60090600000001 | 4.918688 | 2021-08-09 04:21:24 | Noord-Holland, Netherlands | |||
597802 | 597802 | 2021-10-19 | Netherlands | Noord-Holland | 352350 | 2745 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-10-20 04:21:00 | Noord-Holland, Netherlands |
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]);