johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Sakhalin Oblast" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805481 | 805481 | 2020-06-01 | Russia | Sakhalin Oblast | 118 | 0 | 53 | 65 | 49.7219665 | 143.448533 | 2020-06-02 02:33:08 | Sakhalin Oblast, Russia | ||
2555944 | 2555944 | 2020-06-02 | Russia | Sakhalin Oblast | 133 | 0 | 54 | 79 | 49.7219665 | 143.448533 | 2020-06-03 02:33:13 | Sakhalin Oblast, Russia | ||
3866902 | 3866902 | 2020-06-03 | Russia | Sakhalin Oblast | 143 | 0 | 62 | 81 | 49.7219665 | 143.448533 | 2020-06-04 02:33:14 | Sakhalin Oblast, Russia | ||
1281347 | 1281347 | 2020-06-04 | Russia | Sakhalin Oblast | 147 | 0 | 62 | 85 | 49.7219665 | 143.448533 | 2020-06-05 02:33:06 | Sakhalin Oblast, Russia | ||
1269878 | 1269878 | 2020-06-05 | Russia | Sakhalin Oblast | 160 | 0 | 63 | 97 | 49.7219665 | 143.448533 | 2020-06-06 02:33:00 | Sakhalin Oblast, Russia | ||
574181 | 574181 | 2020-06-06 | Russia | Sakhalin Oblast | 170 | 0 | 63 | 107 | 49.7219665 | 143.448533 | 2020-06-07 03:53:30 | Sakhalin Oblast, Russia | ||
2800125 | 2800125 | 2020-06-07 | Russia | Sakhalin Oblast | 188 | 0 | 71 | 117 | 49.7219665 | 143.448533 | 2020-06-08 03:33:22 | Sakhalin Oblast, Russia | ||
217329 | 217329 | 2020-06-08 | Russia | Sakhalin Oblast | 204 | 0 | 71 | 133 | 49.7219665 | 143.448533 | 2020-06-09 03:33:03 | Sakhalin Oblast, Russia | ||
1210902 | 1210902 | 2020-06-09 | Russia | Sakhalin Oblast | 216 | 0 | 71 | 145 | 49.7219665 | 143.448533 | 2020-06-10 04:07:00 | Sakhalin Oblast, Russia | ||
2864076 | 2864076 | 2020-06-10 | Russia | Sakhalin Oblast | 250 | 0 | 71 | 179 | 49.7219665 | 143.448533 | 2020-06-11 03:33:41 | Sakhalin Oblast, Russia | ||
1273634 | 1273634 | 2020-06-11 | Russia | Sakhalin Oblast | 264 | 0 | 71 | 193 | 49.7219665 | 143.448533 | 2020-06-12 05:09:52 | Sakhalin Oblast, Russia | ||
737664 | 737664 | 2020-06-12 | Russia | Sakhalin Oblast | 305 | 0 | 71 | 234 | 49.7219665 | 143.448533 | 2020-06-13 03:33:14 | Sakhalin Oblast, Russia | ||
3061344 | 3061344 | 2020-06-13 | Russia | Sakhalin Oblast | 320 | 0 | 98 | 222 | 49.7219665 | 143.448533 | 2020-06-14 03:33:15 | Sakhalin Oblast, Russia | ||
1837292 | 1837292 | 2020-06-14 | Russia | Sakhalin Oblast | 330 | 0 | 98 | 232 | 49.7219665 | 143.448533 | 2020-06-15 03:33:14 | Sakhalin Oblast, Russia | ||
287341 | 287341 | 2020-06-15 | Russia | Sakhalin Oblast | 343 | 0 | 98 | 245 | 49.7219665 | 143.448533 | 2020-06-16 04:33:09 | Sakhalin Oblast, Russia | ||
2386778 | 2386778 | 2020-06-16 | Russia | Sakhalin Oblast | 362 | 0 | 98 | 264 | 49.7219665 | 143.448533 | 2020-06-17 04:33:21 | Sakhalin Oblast, Russia | ||
1196015 | 1196015 | 2020-06-17 | Russia | Sakhalin Oblast | 394 | 0 | 98 | 296 | 49.7219665 | 143.448533 | 2020-06-18 04:33:18 | Sakhalin Oblast, Russia | ||
3682812 | 3682812 | 2020-06-18 | Russia | Sakhalin Oblast | 423 | 0 | 100 | 323 | 49.7219665 | 143.448533 | 2020-06-19 04:33:17 | Sakhalin Oblast, Russia | ||
1691663 | 1691663 | 2020-06-19 | Russia | Sakhalin Oblast | 447 | 0 | 100 | 347 | 49.7219665 | 143.448533 | 2020-06-20 04:33:19 | Sakhalin Oblast, Russia | ||
2438085 | 2438085 | 2020-06-20 | Russia | Sakhalin Oblast | 495 | 0 | 102 | 393 | 49.7219665 | 143.448533 | 2020-06-21 04:33:19 | Sakhalin Oblast, Russia | ||
3249492 | 3249492 | 2020-06-21 | Russia | Sakhalin Oblast | 525 | 0 | 102 | 423 | 49.7219665 | 143.448533 | 2020-06-22 04:33:20 | Sakhalin Oblast, Russia | ||
1510753 | 1510753 | 2020-06-22 | Russia | Sakhalin Oblast | 566 | 0 | 103 | 463 | 49.7219665 | 143.448533 | 2020-06-23 04:33:22 | Sakhalin Oblast, Russia | ||
1522559 | 1522559 | 2020-06-23 | Russia | Sakhalin Oblast | 567 | 0 | 103 | 464 | 49.7219665 | 143.448533 | 2020-06-24 04:33:28 | Sakhalin Oblast, Russia | ||
2700874 | 2700874 | 2020-06-24 | Russia | Sakhalin Oblast | 628 | 0 | 115 | 513 | 49.7219665 | 143.448533 | 2020-06-25 05:26:54 | Sakhalin Oblast, Russia | ||
2625234 | 2625234 | 2020-06-25 | Russia | Sakhalin Oblast | 663 | 0 | 119 | 544 | 49.7219665 | 143.448533 | 2020-06-26 04:33:43 | Sakhalin Oblast, Russia | ||
1136247 | 1136247 | 2020-06-26 | Russia | Sakhalin Oblast | 702 | 0 | 120 | 582 | 49.7219665 | 143.448533 | 2020-06-27 04:33:35 | Sakhalin Oblast, Russia | ||
2039966 | 2039966 | 2020-06-27 | Russia | Sakhalin Oblast | 721 | 0 | 120 | 601 | 49.7219665 | 143.448533 | 2020-06-28 04:34:04 | Sakhalin Oblast, Russia | ||
2306631 | 2306631 | 2020-06-28 | Russia | Sakhalin Oblast | 742 | 0 | 245 | 497 | 49.7219665 | 143.448533 | 2020-06-29 04:33:44 | Sakhalin Oblast, Russia | ||
2633068 | 2633068 | 2020-06-29 | Russia | Sakhalin Oblast | 771 | 0 | 275 | 496 | 49.7219665 | 143.448533 | 2020-06-30 04:33:48 | Sakhalin Oblast, Russia | ||
2974591 | 2974591 | 2020-06-30 | Russia | Sakhalin Oblast | 800 | 0 | 332 | 468 | 49.7219665 | 143.448533 | 2020-07-01 04:33:52 | Sakhalin Oblast, Russia | ||
303213 | 303213 | 2020-07-01 | Russia | Sakhalin Oblast | 828 | 0 | 338 | 490 | 49.7219665 | 143.448533 | 2020-07-02 04:33:46 | Sakhalin Oblast, Russia | ||
3045522 | 3045522 | 2020-07-02 | Russia | Sakhalin Oblast | 853 | 0 | 339 | 514 | 49.7219665 | 143.448533 | 2020-07-03 04:33:54 | Sakhalin Oblast, Russia | ||
2234728 | 2234728 | 2020-07-03 | Russia | Sakhalin Oblast | 885 | 0 | 348 | 537 | 49.7219665 | 143.448533 | 2020-07-04 04:33:51 | Sakhalin Oblast, Russia | ||
530067 | 530067 | 2020-07-04 | Russia | Sakhalin Oblast | 918 | 0 | 357 | 561 | 49.7219665 | 143.448533 | 2020-07-05 04:33:46 | Sakhalin Oblast, Russia | ||
415505 | 415505 | 2020-07-05 | Russia | Sakhalin Oblast | 953 | 0 | 360 | 593 | 49.7219665 | 143.448533 | 2020-07-06 04:33:57 | Sakhalin Oblast, Russia | ||
2685040 | 2685040 | 2020-07-06 | Russia | Sakhalin Oblast | 993 | 0 | 364 | 629 | 49.7219665 | 143.448533 | 2020-07-07 04:34:00 | Sakhalin Oblast, Russia | ||
887480 | 887480 | 2020-07-07 | Russia | Sakhalin Oblast | 1035 | 0 | 385 | 650 | 49.7219665 | 143.448533 | 2020-07-08 05:33:48 | Sakhalin Oblast, Russia | ||
2222871 | 2222871 | 2020-07-08 | Russia | Sakhalin Oblast | 1103 | 0 | 436 | 667 | 49.7219665 | 143.448533 | 2020-07-09 04:34:23 | Sakhalin Oblast, Russia | ||
1005655 | 1005655 | 2020-07-09 | Russia | Sakhalin Oblast | 1172 | 0 | 451 | 721 | 49.7219665 | 143.448533 | 2020-07-10 04:34:24 | Sakhalin Oblast, Russia | ||
3237670 | 3237670 | 2020-07-10 | Russia | Sakhalin Oblast | 1240 | 0 | 472 | 768 | 49.7219665 | 143.448533 | 2020-07-11 04:34:26 | Sakhalin Oblast, Russia | ||
3436172 | 3436172 | 2020-07-11 | Russia | Sakhalin Oblast | 1307 | 0 | 510 | 797 | 49.7219665 | 143.448533 | 2020-07-12 04:34:30 | Sakhalin Oblast, Russia | ||
3737777 | 3737777 | 2020-07-12 | Russia | Sakhalin Oblast | 1376 | 0 | 513 | 863 | 49.7219665 | 143.448533 | 2020-07-13 04:43:04 | Sakhalin Oblast, Russia | ||
3491514 | 3491514 | 2020-07-13 | Russia | Sakhalin Oblast | 1443 | 0 | 521 | 922 | 49.7219665 | 143.448533 | 2020-07-14 04:34:46 | Sakhalin Oblast, Russia | ||
2158873 | 2158873 | 2020-07-14 | Russia | Sakhalin Oblast | 1507 | 0 | 542 | 965 | 49.7219665 | 143.448533 | 2020-07-15 04:34:39 | Sakhalin Oblast, Russia | ||
2748229 | 2748229 | 2020-07-15 | Russia | Sakhalin Oblast | 1568 | 0 | 564 | 1004 | 49.7219665 | 143.448533 | 2020-07-16 04:44:59 | Sakhalin Oblast, Russia | ||
367561 | 367561 | 2020-07-16 | Russia | Sakhalin Oblast | 1628 | 0 | 568 | 1060 | 49.7219665 | 143.448533 | 2020-07-17 04:34:50 | Sakhalin Oblast, Russia | ||
2708751 | 2708751 | 2020-07-17 | Russia | Sakhalin Oblast | 1687 | 0 | 572 | 1115 | 49.7219665 | 143.448533 | 2020-07-18 04:34:45 | Sakhalin Oblast, Russia | ||
3205449 | 3205449 | 2020-07-18 | Russia | Sakhalin Oblast | 1747 | 0 | 584 | 1163 | 49.7219665 | 143.448533 | 2020-07-19 04:34:58 | Sakhalin Oblast, Russia | ||
122060 | 122060 | 2020-07-19 | Russia | Sakhalin Oblast | 1806 | 0 | 584 | 1222 | 49.7219665 | 143.448533 | 2020-07-20 05:34:40 | Sakhalin Oblast, Russia | ||
327155 | 327155 | 2020-07-20 | Russia | Sakhalin Oblast | 1863 | 0 | 599 | 1264 | 49.7219665 | 143.448533 | 2020-07-21 04:38:46 | Sakhalin Oblast, Russia | ||
1707664 | 1707664 | 2020-07-21 | Russia | Sakhalin Oblast | 1926 | 0 | 627 | 1299 | 49.7219665 | 143.448533 | 2020-07-22 04:34:42 | Sakhalin Oblast, Russia | ||
844925 | 844925 | 2020-07-22 | Russia | Sakhalin Oblast | 1994 | 0 | 651 | 1343 | 49.7219665 | 143.448533 | 2020-07-23 05:15:04 | Sakhalin Oblast, Russia | ||
62114 | 62114 | 2020-07-23 | Russia | Sakhalin Oblast | 2061 | 0 | 685 | 1376 | 49.7219665 | 143.448533 | 2020-07-24 05:30:40 | Sakhalin Oblast, Russia | ||
2563905 | 2563905 | 2020-07-24 | Russia | Sakhalin Oblast | 2126 | 0 | 701 | 1425 | 49.7219665 | 143.448533 | 2020-07-25 04:47:39 | Sakhalin Oblast, Russia | ||
1502935 | 1502935 | 2020-07-25 | Russia | Sakhalin Oblast | 2185 | 0 | 771 | 1414 | 49.7219665 | 143.448533 | 2020-07-26 04:35:00 | Sakhalin Oblast, Russia | ||
442691 | 442691 | 2020-07-26 | Russia | Sakhalin Oblast | 2235 | 0 | 788 | 1447 | 49.7219665 | 143.448533 | 2020-07-27 04:35:02 | Sakhalin Oblast, Russia | ||
177378 | 177378 | 2020-07-27 | Russia | Sakhalin Oblast | 2294 | 0 | 822 | 1472 | 49.7219665 | 143.448533 | 2020-07-28 04:58:43 | Sakhalin Oblast, Russia | ||
3185327 | 3185327 | 2020-07-28 | Russia | Sakhalin Oblast | 2362 | 0 | 893 | 1469 | 49.7219665 | 143.448533 | 2020-07-29 04:35:11 | Sakhalin Oblast, Russia | ||
2958711 | 2958711 | 2020-07-29 | Russia | Sakhalin Oblast | 2431 | 0 | 932 | 1499 | 49.7219665 | 143.448533 | 2020-07-30 04:35:05 | Sakhalin Oblast, Russia | ||
1928543 | 1928543 | 2020-07-30 | Russia | Sakhalin Oblast | 2498 | 0 | 970 | 1528 | 49.7219665 | 143.448533 | 2020-07-31 04:35:18 | Sakhalin Oblast, Russia | ||
3264836 | 3264836 | 2020-07-31 | Russia | Sakhalin Oblast | 2559 | 0 | 1031 | 1528 | 49.7219665 | 143.448533 | 2020-08-01 04:36:27 | Sakhalin Oblast, Russia | ||
753671 | 753671 | 2020-08-01 | Russia | Sakhalin Oblast | 2625 | 0 | 1098 | 1527 | 49.7219665 | 143.448533 | 2020-08-02 04:34:47 | Sakhalin Oblast, Russia | ||
2808103 | 2808103 | 2020-08-02 | Russia | Sakhalin Oblast | 2685 | 0 | 1233 | 1452 | 49.7219665 | 143.448533 | 2020-08-03 04:34:35 | Sakhalin Oblast, Russia | ||
2740351 | 2740351 | 2020-08-03 | Russia | Sakhalin Oblast | 2744 | 0 | 1238 | 1506 | 49.7219665 | 143.448533 | 2020-08-04 04:41:59 | Sakhalin Oblast, Russia | ||
98468 | 98468 | 2020-08-04 | Russia | Sakhalin Oblast | 2811 | 0 | 1340 | 1471 | 49.7219665 | 143.448533 | 2020-08-05 04:34:43 | Sakhalin Oblast, Russia | ||
3793232 | 3793232 | 2020-08-05 | Russia | Sakhalin Oblast | 2876 | 0 | 1418 | 1458 | 49.7219665 | 143.448533 | 2020-08-06 04:35:02 | Sakhalin Oblast, Russia | ||
3612402 | 3612402 | 2020-08-06 | Russia | Sakhalin Oblast | 2944 | 0 | 1506 | 1438 | 49.7219665 | 143.448533 | 2020-08-07 04:35:11 | Sakhalin Oblast, Russia | ||
458717 | 458717 | 2020-08-07 | Russia | Sakhalin Oblast | 3010 | 0 | 1548 | 1462 | 49.7219665 | 143.448533 | 2020-08-08 04:34:53 | Sakhalin Oblast, Russia | ||
371533 | 371533 | 2020-08-08 | Russia | Sakhalin Oblast | 3075 | 0 | 1569 | 1506 | 49.7219665 | 143.448533 | 2020-08-09 04:34:54 | Sakhalin Oblast, Russia | ||
3923365 | 3923365 | 2020-08-09 | Russia | Sakhalin Oblast | 3137 | 0 | 1579 | 1558 | 49.7219665 | 143.448533 | 2020-08-10 04:34:55 | Sakhalin Oblast, Russia | ||
1920556 | 1920556 | 2020-08-10 | Russia | Sakhalin Oblast | 3204 | 0 | 1585 | 1619 | 49.7219665 | 143.448533 | 2020-08-11 04:35:08 | Sakhalin Oblast, Russia | ||
662538 | 662538 | 2020-08-11 | Russia | Sakhalin Oblast | 3267 | 0 | 1670 | 1597 | 49.7219665 | 143.448533 | 2020-08-12 04:27:29 | Sakhalin Oblast, Russia | ||
3531689 | 3531689 | 2020-08-12 | Russia | Sakhalin Oblast | 3326 | 0 | 1720 | 1606 | 49.7219665 | 143.448533 | 2020-08-13 04:29:15 | Sakhalin Oblast, Russia | ||
583070 | 583070 | 2020-08-13 | Russia | Sakhalin Oblast | 3390 | 0 | 1778 | 1612 | 49.7219665 | 143.448533 | 2020-08-14 04:51:19 | Sakhalin Oblast, Russia | ||
1612486 | 1612486 | 2020-08-14 | Russia | Sakhalin Oblast | 3458 | 0 | 1855 | 1603 | 49.7219665 | 143.448533 | 2020-08-15 04:27:31 | Sakhalin Oblast, Russia | ||
146211 | 146211 | 2020-08-15 | Russia | Sakhalin Oblast | 3519 | 0 | 1913 | 1606 | 49.7219665 | 143.448533 | 2020-08-16 04:27:42 | Sakhalin Oblast, Russia | ||
1556209 | 1556209 | 2020-08-16 | Russia | Sakhalin Oblast | 3578 | 0 | 1924 | 1654 | 49.7219665 | 143.448533 | 2020-08-17 04:27:20 | Sakhalin Oblast, Russia | ||
837851 | 837851 | 2020-08-17 | Russia | Sakhalin Oblast | 3635 | 0 | 1934 | 1701 | 49.7219665 | 143.448533 | 2020-08-18 04:27:56 | Sakhalin Oblast, Russia | ||
3178247 | 3178247 | 2020-08-18 | Russia | Sakhalin Oblast | 3695 | 0 | 2074 | 1621 | 49.7219665 | 143.448533 | 2020-08-19 04:27:00 | Sakhalin Oblast, Russia | ||
206493 | 206493 | 2020-08-19 | Russia | Sakhalin Oblast | 3752 | 0 | 2113 | 1639 | 49.7219665 | 143.448533 | 2020-08-20 04:27:43 | Sakhalin Oblast, Russia | ||
3484544 | 3484544 | 2020-08-20 | Russia | Sakhalin Oblast | 3811 | 0 | 2141 | 1670 | 49.7219665 | 143.448533 | 2020-08-21 04:27:41 | Sakhalin Oblast, Russia | ||
1479795 | 1479795 | 2020-08-21 | Russia | Sakhalin Oblast | 3867 | 0 | 2180 | 1687 | 49.7219665 | 143.448533 | 2020-08-22 04:27:49 | Sakhalin Oblast, Russia | ||
2299688 | 2299688 | 2020-08-22 | Russia | Sakhalin Oblast | 3925 | 0 | 2228 | 1697 | 49.7219665 | 143.448533 | 2020-08-23 04:27:48 | Sakhalin Oblast, Russia | ||
2215906 | 2215906 | 2020-08-23 | Russia | Sakhalin Oblast | 3980 | 0 | 2235 | 1745 | 49.7219665 | 143.448533 | 2020-08-24 04:27:56 | Sakhalin Oblast, Russia | ||
2991511 | 2991511 | 2020-08-24 | Russia | Sakhalin Oblast | 4037 | 0 | 2251 | 1786 | 49.7219665 | 143.448533 | 2020-08-25 04:28:02 | Sakhalin Oblast, Russia | ||
3562807 | 3562807 | 2020-08-25 | Russia | Sakhalin Oblast | 4096 | 0 | 2315 | 1781 | 49.7219665 | 143.448533 | 2020-08-26 04:28:11 | Sakhalin Oblast, Russia | ||
1996883 | 1996883 | 2020-08-26 | Russia | Sakhalin Oblast | 4152 | 0 | 2379 | 1773 | 49.7219665 | 143.448533 | 2020-08-27 04:28:15 | Sakhalin Oblast, Russia | ||
2510423 | 2510423 | 2020-08-27 | Russia | Sakhalin Oblast | 4210 | 0 | 2485 | 1725 | 49.7219665 | 143.448533 | 2020-08-28 04:28:11 | Sakhalin Oblast, Russia | ||
1523422 | 1523422 | 2020-08-28 | Russia | Sakhalin Oblast | 4265 | 0 | 2519 | 1746 | 49.7219665 | 143.448533 | 2020-08-29 04:28:19 | Sakhalin Oblast, Russia | ||
609927 | 609927 | 2020-08-29 | Russia | Sakhalin Oblast | 4319 | 0 | 2581 | 1738 | 49.7219665 | 143.448533 | 2020-08-30 04:28:22 | Sakhalin Oblast, Russia | ||
3932265 | 3932265 | 2020-08-30 | Russia | Sakhalin Oblast | 4371 | 0 | 2602 | 1769 | 49.7219665 | 143.448533 | 2020-08-31 04:28:27 | Sakhalin Oblast, Russia | ||
194306 | 194306 | 2020-08-31 | Russia | Sakhalin Oblast | 4420 | 0 | 2617 | 1803 | 49.7219665 | 143.448533 | 2020-09-01 04:28:31 | Sakhalin Oblast, Russia | ||
2060121 | 2060121 | 2020-09-01 | Russia | Sakhalin Oblast | 4473 | 0 | 2650 | 1823 | 49.7219665 | 143.448533 | 2020-09-02 04:28:25 | Sakhalin Oblast, Russia | ||
1105792 | 1105792 | 2020-09-02 | Russia | Sakhalin Oblast | 4524 | 0 | 2693 | 1831 | 49.7219665 | 143.448533 | 2020-09-03 04:28:22 | Sakhalin Oblast, Russia | ||
1354555 | 1354555 | 2020-09-03 | Russia | Sakhalin Oblast | 4572 | 0 | 2744 | 1828 | 49.7219665 | 143.448533 | 2020-09-04 04:28:26 | Sakhalin Oblast, Russia | ||
2662015 | 2662015 | 2020-09-04 | Russia | Sakhalin Oblast | 4622 | 0 | 2795 | 1827 | 49.7219665 | 143.448533 | 2020-09-05 04:28:19 | Sakhalin Oblast, Russia | ||
813815 | 813815 | 2020-09-05 | Russia | Sakhalin Oblast | 4671 | 0 | 2858 | 1813 | 49.7219665 | 143.448533 | 2020-09-06 04:28:33 | Sakhalin Oblast, Russia | ||
3161860 | 3161860 | 2020-09-06 | Russia | Sakhalin Oblast | 4718 | 0 | 2870 | 1848 | 49.7219665 | 143.448533 | 2020-09-07 04:28:30 | Sakhalin Oblast, Russia | ||
427575 | 427575 | 2020-09-07 | Russia | Sakhalin Oblast | 4762 | 0 | 2886 | 1876 | 49.7219665 | 143.448533 | 2020-09-08 04:28:25 | Sakhalin Oblast, Russia | ||
1243996 | 1243996 | 2020-09-08 | Russia | Sakhalin Oblast | 4808 | 0 | 2991 | 1817 | 49.7219665 | 143.448533 | 2020-09-09 04:28:48 | Sakhalin Oblast, Russia |
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]);