johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "United Kingdom" and province_or_state = "Northern Ireland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193719 | 193719 | 2021-01-11 | United Kingdom | Northern Ireland | 89459 | 2106 | 0 | 87983 | 54.7877 | -6.4923 | 2021-01-12 05:22:15 | Northern Ireland, United Kingdom | ||
2629522 | 2629522 | 2021-01-10 | United Kingdom | Northern Ireland | 88700 | 2075 | 0 | 87240 | 54.7877 | -6.4923 | 2021-01-11 05:21:50 | Northern Ireland, United Kingdom | ||
3903610 | 3903610 | 2021-01-09 | United Kingdom | Northern Ireland | 87588 | 2060 | 0 | 86145 | 54.7877 | -6.4923 | 2021-01-10 05:22:12 | Northern Ireland, United Kingdom | ||
157633 | 157633 | 2021-01-08 | United Kingdom | Northern Ireland | 86146 | 2038 | 0 | 84712 | 54.7877 | -6.4923 | 2021-01-09 05:22:18 | Northern Ireland, United Kingdom | ||
2545057 | 2545057 | 2021-01-07 | United Kingdom | Northern Ireland | 84646 | 2024 | 0 | 83232 | 54.7877 | -6.4923 | 2021-01-08 05:22:42 | Northern Ireland, United Kingdom | ||
2868366 | 2868366 | 2021-01-06 | United Kingdom | Northern Ireland | 83236 | 1996 | 0 | 81839 | 54.7877 | -6.4923 | 2021-01-07 05:22:03 | Northern Ireland, United Kingdom | ||
3037953 | 3037953 | 2021-01-05 | United Kingdom | Northern Ireland | 81251 | 1984 | 0 | 79867 | 54.7877 | -6.4923 | 2021-01-06 05:22:16 | Northern Ireland, United Kingdom | ||
1065498 | 1065498 | 2021-01-04 | United Kingdom | Northern Ireland | 79873 | 1968 | 0 | 78507 | 54.7877 | -6.4923 | 2021-01-05 05:21:49 | Northern Ireland, United Kingdom | ||
3234101 | 3234101 | 2021-01-03 | United Kingdom | Northern Ireland | 78072 | 1954 | 0 | 76718 | 54.7877 | -6.4923 | 2021-01-04 05:22:02 | Northern Ireland, United Kingdom | ||
2231170 | 2231170 | 2021-01-02 | United Kingdom | Northern Ireland | 76410 | 1939 | 0 | 75062 | 54.7877 | -6.4923 | 2021-01-03 05:22:52 | Northern Ireland, United Kingdom | ||
1140534 | 1140534 | 2021-01-01 | United Kingdom | Northern Ireland | 72834 | 1922 | 0 | 71512 | 54.7877 | -6.4923 | 2021-01-02 05:22:33 | Northern Ireland, United Kingdom | ||
3699140 | 3699140 | 2020-12-31 | United Kingdom | Northern Ireland | 72834 | 1905 | 0 | 71512 | 54.7877 | -6.4923 | 2021-01-01 05:23:07 | Northern Ireland, United Kingdom | ||
1013955 | 1013955 | 2020-12-30 | United Kingdom | Northern Ireland | 70905 | 1889 | 0 | 69594 | 54.7877 | -6.4923 | 2020-12-31 05:22:49 | Northern Ireland, United Kingdom | ||
769970 | 769970 | 2020-12-29 | United Kingdom | Northern Ireland | 68762 | 1875 | 0 | 67457 | 54.7877 | -6.4923 | 2020-12-30 05:22:34 | Northern Ireland, United Kingdom | ||
3765234 | 3765234 | 2020-12-28 | United Kingdom | Northern Ireland | 67196 | 1863 | 0 | 65905 | 54.7877 | -6.4923 | 2020-12-29 05:22:37 | Northern Ireland, United Kingdom | ||
3781554 | 3781554 | 2020-12-27 | United Kingdom | Northern Ireland | 65562 | 1849 | 0 | 64291 | 54.7877 | -6.4923 | 2020-12-28 05:22:06 | Northern Ireland, United Kingdom | ||
2227159 | 2227159 | 2020-12-26 | United Kingdom | Northern Ireland | 63723 | 1833 | 0 | 62483 | 54.7877 | -6.4923 | 2020-12-27 05:22:55 | Northern Ireland, United Kingdom | ||
205906 | 205906 | 2020-12-25 | United Kingdom | Northern Ireland | 63723 | 1819 | 0 | 62483 | 54.7877 | -6.4923 | 2020-12-26 05:22:28 | Northern Ireland, United Kingdom | ||
3695129 | 3695129 | 2020-12-24 | United Kingdom | Northern Ireland | 63723 | 1809 | 0 | 62483 | 54.7877 | -6.4923 | 2020-12-25 05:22:48 | Northern Ireland, United Kingdom | ||
2410481 | 2410481 | 2020-12-23 | United Kingdom | Northern Ireland | 63723 | 1792 | 0 | 62483 | 54.7877 | -6.4923 | 2020-12-24 05:23:04 | Northern Ireland, United Kingdom | ||
3773527 | 3773527 | 2020-12-22 | United Kingdom | Northern Ireland | 62936 | 1769 | 0 | 61717 | 54.7877 | -6.4923 | 2020-12-23 05:22:03 | Northern Ireland, United Kingdom | ||
931343 | 931343 | 2020-12-21 | United Kingdom | Northern Ireland | 62497 | 1756 | 0 | 61294 | 54.7877 | -6.4923 | 2020-12-22 05:22:33 | Northern Ireland, United Kingdom | ||
2123364 | 2123364 | 2020-12-20 | United Kingdom | Northern Ireland | 61942 | 1734 | 0 | 60746 | 54.7877 | -6.4923 | 2020-12-21 05:27:58 | Northern Ireland, United Kingdom | ||
2934871 | 2934871 | 2020-12-19 | United Kingdom | Northern Ireland | 61437 | 1714 | 0 | 60254 | 54.7877 | -6.4923 | 2020-12-20 05:27:32 | Northern Ireland, United Kingdom | ||
1904817 | 1904817 | 2020-12-18 | United Kingdom | Northern Ireland | 60797 | 1698 | 0 | 59631 | 54.7877 | -6.4923 | 2020-12-19 05:27:52 | Northern Ireland, United Kingdom | ||
2131643 | 2131643 | 2020-12-17 | United Kingdom | Northern Ireland | 60287 | 1681 | 0 | 59133 | 54.7877 | -6.4923 | 2020-12-18 05:28:18 | Northern Ireland, United Kingdom | ||
3153243 | 3153243 | 2020-12-16 | United Kingdom | Northern Ireland | 59631 | 1666 | 0 | 58488 | 54.7877 | -6.4923 | 2020-12-17 05:28:12 | Northern Ireland, United Kingdom | ||
1038024 | 1038024 | 2020-12-15 | United Kingdom | Northern Ireland | 59121 | 1652 | 0 | 57986 | 54.7877 | -6.4923 | 2020-12-16 05:28:04 | Northern Ireland, United Kingdom | ||
1754918 | 1754918 | 2020-12-14 | United Kingdom | Northern Ireland | 58635 | 1643 | 0 | 57506 | 54.7877 | -6.4923 | 2020-12-15 05:26:38 | Northern Ireland, United Kingdom | ||
3851438 | 3851438 | 2020-12-13 | United Kingdom | Northern Ireland | 58216 | 1632 | 0 | 57092 | 54.7877 | -6.4923 | 2020-12-14 05:26:27 | Northern Ireland, United Kingdom | ||
849220 | 849220 | 2020-12-12 | United Kingdom | Northern Ireland | 57733 | 1620 | 0 | 56613 | 54.7877 | -6.4923 | 2020-12-13 05:27:20 | Northern Ireland, United Kingdom | ||
864327 | 864327 | 2020-12-11 | United Kingdom | Northern Ireland | 57257 | 1612 | 0 | 56146 | 54.7877 | -6.4923 | 2020-12-12 05:26:19 | Northern Ireland, United Kingdom | ||
1603869 | 1603869 | 2020-12-10 | United Kingdom | Northern Ireland | 56719 | 1598 | 0 | 55620 | 54.7877 | -6.4923 | 2020-12-11 05:26:59 | Northern Ireland, United Kingdom | ||
2978878 | 2978878 | 2020-12-09 | United Kingdom | Northern Ireland | 56278 | 1582 | 0 | 55193 | 54.7877 | -6.4923 | 2020-12-10 05:26:19 | Northern Ireland, United Kingdom | ||
1822438 | 1822438 | 2020-12-08 | United Kingdom | Northern Ireland | 55795 | 1571 | 0 | 54722 | 54.7877 | -6.4923 | 2020-12-09 05:28:01 | Northern Ireland, United Kingdom | ||
2351074 | 2351074 | 2020-12-07 | United Kingdom | Northern Ireland | 55444 | 1561 | 0 | 54385 | 54.7877 | -6.4923 | 2020-12-08 05:27:42 | Northern Ireland, United Kingdom | ||
1009944 | 1009944 | 2020-12-06 | United Kingdom | Northern Ireland | 55047 | 1542 | 0 | 53997 | 54.7877 | -6.4923 | 2020-12-07 05:26:14 | Northern Ireland, United Kingdom | ||
1635953 | 1635953 | 2020-12-05 | United Kingdom | Northern Ireland | 54628 | 1527 | 0 | 53589 | 54.7877 | -6.4923 | 2020-12-06 05:26:18 | Northern Ireland, United Kingdom | ||
3863481 | 3863481 | 2020-12-04 | United Kingdom | Northern Ireland | 54177 | 1513 | 0 | 53145 | 54.7877 | -6.4923 | 2020-12-05 05:27:36 | Northern Ireland, United Kingdom | ||
78739 | 78739 | 2020-12-03 | United Kingdom | Northern Ireland | 53728 | 1502 | 0 | 52702 | 54.7877 | -6.4923 | 2020-12-04 05:27:27 | Northern Ireland, United Kingdom | ||
741951 | 741951 | 2020-12-02 | United Kingdom | Northern Ireland | 53272 | 1491 | 0 | 52257 | 54.7877 | -6.4923 | 2020-12-03 05:28:22 | Northern Ireland, United Kingdom | ||
2541045 | 2541045 | 2020-12-01 | United Kingdom | Northern Ireland | 52856 | 1479 | 0 | 51845 | 54.7877 | -6.4923 | 2020-12-02 05:27:41 | Northern Ireland, United Kingdom | ||
1587814 | 1587814 | 2020-11-30 | United Kingdom | Northern Ireland | 52465 | 1470 | 0 | 51469 | 54.7877 | -6.4923 | 2020-12-01 05:26:18 | Northern Ireland, United Kingdom | ||
3570217 | 3570217 | 2020-11-29 | United Kingdom | Northern Ireland | 52175 | 1455 | 0 | 51189 | 54.7877 | -6.4923 | 2020-11-30 05:26:13 | Northern Ireland, United Kingdom | ||
2938882 | 2938882 | 2020-11-28 | United Kingdom | Northern Ireland | 51824 | 1443 | 0 | 50841 | 54.7877 | -6.4923 | 2020-11-29 05:25:55 | Northern Ireland, United Kingdom | ||
395885 | 395885 | 2020-11-27 | United Kingdom | Northern Ireland | 51509 | 1429 | 0 | 50535 | 54.7877 | -6.4923 | 2020-11-28 05:25:50 | Northern Ireland, United Kingdom | ||
927332 | 927332 | 2020-11-26 | United Kingdom | Northern Ireland | 51118 | 1414 | 0 | 50156 | 54.7877 | -6.4923 | 2020-11-27 05:26:53 | Northern Ireland, United Kingdom | ||
1976237 | 1976237 | 2020-11-25 | United Kingdom | Northern Ireland | 50676 | 1400 | 0 | 49722 | 54.7877 | -6.4923 | 2020-11-26 05:27:44 | Northern Ireland, United Kingdom | ||
1353968 | 1353968 | 2020-11-24 | United Kingdom | Northern Ireland | 50143 | 1394 | 0 | 49196 | 54.7877 | -6.4923 | 2020-11-25 05:27:20 | Northern Ireland, United Kingdom | ||
681962 | 681962 | 2020-11-23 | United Kingdom | Northern Ireland | 50064 | 1384 | 0 | 49128 | 54.7877 | -6.4923 | 2020-11-24 05:27:31 | Northern Ireland, United Kingdom | ||
3193638 | 3193638 | 2020-11-22 | United Kingdom | Northern Ireland | 49784 | 1375 | 0 | 48851 | 54.7877 | -6.4923 | 2020-11-23 05:25:26 | Northern Ireland, United Kingdom | ||
3840132 | 3840132 | 2020-11-21 | United Kingdom | Northern Ireland | 49442 | 1361 | 0 | 48519 | 54.7877 | -6.4923 | 2020-11-22 05:25:45 | Northern Ireland, United Kingdom | ||
2705160 | 2705160 | 2020-11-20 | United Kingdom | Northern Ireland | 49085 | 1352 | 0 | 48172 | 54.7877 | -6.4923 | 2020-11-21 05:25:51 | Northern Ireland, United Kingdom | ||
825220 | 825220 | 2020-11-19 | United Kingdom | Northern Ireland | 48716 | 1335 | 0 | 47815 | 54.7877 | -6.4923 | 2020-11-20 05:26:28 | Northern Ireland, United Kingdom | ||
126354 | 126354 | 2020-11-18 | United Kingdom | Northern Ireland | 48229 | 1319 | 0 | 47340 | 54.7877 | -6.4923 | 2020-11-19 05:25:23 | Northern Ireland, United Kingdom | ||
3342242 | 3342242 | 2020-11-17 | United Kingdom | Northern Ireland | 47711 | 1305 | 0 | 46833 | 54.7877 | -6.4923 | 2020-11-18 05:40:31 | Northern Ireland, United Kingdom | ||
3173287 | 3173287 | 2020-11-16 | United Kingdom | Northern Ireland | 47162 | 1288 | 0 | 46293 | 54.7877 | -6.4923 | 2020-11-17 05:25:54 | Northern Ireland, United Kingdom | ||
2883855 | 2883855 | 2020-11-15 | United Kingdom | Northern Ireland | 46831 | 1279 | 0 | 45976 | 54.7877 | -6.4923 | 2020-11-16 05:25:57 | Northern Ireland, United Kingdom | ||
2918833 | 2918833 | 2020-11-14 | United Kingdom | Northern Ireland | 46359 | 1262 | 0 | 45513 | 54.7877 | -6.4923 | 2020-11-15 05:26:53 | Northern Ireland, United Kingdom | ||
2788655 | 2788655 | 2020-11-13 | United Kingdom | Northern Ireland | 45848 | 1246 | 0 | 45012 | 54.7877 | -6.4923 | 2020-11-14 05:25:37 | Northern Ireland, United Kingdom | ||
868420 | 868420 | 2020-11-12 | United Kingdom | Northern Ireland | 45241 | 1226 | 0 | 44416 | 54.7877 | -6.4923 | 2020-11-13 05:25:30 | Northern Ireland, United Kingdom | ||
3444464 | 3444464 | 2020-11-11 | United Kingdom | Northern Ireland | 44693 | 1217 | 0 | 43883 | 54.7877 | -6.4923 | 2020-11-12 05:25:55 | Northern Ireland, United Kingdom | ||
275804 | 275804 | 2020-11-10 | United Kingdom | Northern Ireland | 43902 | 1200 | 0 | 43100 | 54.7877 | -6.4923 | 2020-11-11 05:25:30 | Northern Ireland, United Kingdom | ||
1992281 | 1992281 | 2020-11-09 | United Kingdom | Northern Ireland | 43388 | 1188 | 0 | 42597 | 54.7877 | -6.4923 | 2020-11-10 05:40:07 | Northern Ireland, United Kingdom | ||
1732133 | 1732133 | 2020-11-08 | United Kingdom | Northern Ireland | 42917 | 1179 | 0 | 42136 | 54.7877 | -6.4923 | 2020-11-09 05:25:45 | Northern Ireland, United Kingdom | ||
1547593 | 1547593 | 2020-11-07 | United Kingdom | Northern Ireland | 42497 | 1166 | 0 | 41723 | 54.7877 | -6.4923 | 2020-11-08 05:24:56 | Northern Ireland, United Kingdom | ||
379831 | 379831 | 2020-11-06 | United Kingdom | Northern Ireland | 41969 | 1154 | 0 | 41209 | 54.7877 | -6.4923 | 2020-11-07 05:24:52 | Northern Ireland, United Kingdom | ||
895769 | 895769 | 2020-11-05 | United Kingdom | Northern Ireland | 41374 | 1133 | 0 | 40622 | 54.7877 | -6.4923 | 2020-11-06 05:24:55 | Northern Ireland, United Kingdom | ||
2922831 | 2922831 | 2020-11-04 | United Kingdom | Northern Ireland | 40858 | 1125 | 0 | 40118 | 54.7877 | -6.4923 | 2020-11-05 06:05:03 | Northern Ireland, United Kingdom | ||
2501667 | 2501667 | 2020-11-03 | United Kingdom | Northern Ireland | 40179 | 1113 | 0 | 39449 | 54.7877 | -6.4923 | 2020-11-04 05:25:09 | Northern Ireland, United Kingdom | ||
3307842 | 3307842 | 2020-11-02 | United Kingdom | Northern Ireland | 39609 | 1098 | 0 | 38885 | 54.7877 | -6.4923 | 2020-11-03 06:00:16 | Northern Ireland, United Kingdom | ||
3413091 | 3413091 | 2020-11-01 | United Kingdom | Northern Ireland | 39116 | 1091 | 0 | 38400 | 54.7877 | -6.4923 | 2020-11-02 05:25:04 | Northern Ireland, United Kingdom | ||
2083580 | 2083580 | 2020-10-31 | United Kingdom | Northern Ireland | 38431 | 1079 | 0 | 37723 | 54.7877 | -6.4923 | 2020-11-01 04:36:19 | Northern Ireland, United Kingdom | ||
2247033 | 2247033 | 2020-10-30 | United Kingdom | Northern Ireland | 37782 | 1069 | 0 | 37085 | 54.7877 | -6.4923 | 2020-10-31 04:24:44 | Northern Ireland, United Kingdom | ||
213888 | 213888 | 2020-10-29 | United Kingdom | Northern Ireland | 37216 | 1055 | 0 | 36528 | 54.7877 | -6.4923 | 2020-10-30 04:24:49 | Northern Ireland, United Kingdom | ||
757950 | 757950 | 2020-10-28 | United Kingdom | Northern Ireland | 36394 | 1040 | 0 | 35714 | 54.7877 | -6.4923 | 2020-10-29 04:24:49 | Northern Ireland, United Kingdom | ||
1456234 | 1456234 | 2020-10-27 | United Kingdom | Northern Ireland | 35554 | 1032 | 0 | 34883 | 54.7877 | -6.4923 | 2020-10-28 04:24:39 | Northern Ireland, United Kingdom | ||
3483958 | 3483958 | 2020-10-26 | United Kingdom | Northern Ireland | 34832 | 1020 | 0 | 34174 | 54.7877 | -6.4923 | 2020-10-27 04:24:45 | Northern Ireland, United Kingdom | ||
11979 | 11979 | 2020-10-25 | United Kingdom | Northern Ireland | 34105 | 1006 | 0 | 33452 | 54.7877 | -6.4923 | 2020-10-26 04:25:02 | Northern Ireland, United Kingdom | ||
3655216 | 3655216 | 2020-10-24 | United Kingdom | Northern Ireland | 33209 | 998 | 0 | 32564 | 54.7877 | -6.4923 | 2020-10-25 04:24:36 | Northern Ireland, United Kingdom | ||
1057471 | 1057471 | 2020-10-23 | United Kingdom | Northern Ireland | 32286 | 989 | 0 | 31647 | 54.7877 | -6.4923 | 2020-10-24 04:24:46 | Northern Ireland, United Kingdom | ||
1181141 | 1181141 | 2020-10-22 | United Kingdom | Northern Ireland | 31034 | 982 | 0 | 30400 | 54.7877 | -6.4923 | 2020-10-23 04:24:46 | Northern Ireland, United Kingdom | ||
2195246 | 2195246 | 2020-10-21 | United Kingdom | Northern Ireland | 29992 | 975 | 0 | 29363 | 54.7877 | -6.4923 | 2020-10-22 04:24:27 | Northern Ireland, United Kingdom | ||
3994257 | 3994257 | 2020-10-20 | United Kingdom | Northern Ireland | 28953 | 968 | 0 | 28329 | 54.7877 | -6.4923 | 2020-10-21 04:24:14 | Northern Ireland, United Kingdom | ||
1798277 | 1798277 | 2020-10-19 | United Kingdom | Northern Ireland | 28040 | 963 | 0 | 27419 | 54.7877 | -6.4923 | 2020-10-20 04:24:22 | Northern Ireland, United Kingdom | ||
765960 | 765960 | 2020-10-18 | United Kingdom | Northern Ireland | 27220 | 955 | 0 | 26605 | 54.7877 | -6.4923 | 2020-10-19 04:24:16 | Northern Ireland, United Kingdom | ||
1029998 | 1029998 | 2020-10-17 | United Kingdom | Northern Ireland | 26208 | 946 | 0 | 25598 | 54.7877 | -6.4923 | 2020-10-18 04:24:25 | Northern Ireland, United Kingdom | ||
2860493 | 2860493 | 2020-10-16 | United Kingdom | Northern Ireland | 25177 | 942 | 0 | 24569 | 54.7877 | -6.4923 | 2020-10-17 04:24:12 | Northern Ireland, United Kingdom | ||
790022 | 790022 | 2020-10-15 | United Kingdom | Northern Ireland | 23878 | 940 | 0 | 23272 | 54.7877 | -6.4923 | 2020-10-16 04:24:01 | Northern Ireland, United Kingdom | ||
82733 | 82733 | 2020-10-14 | United Kingdom | Northern Ireland | 23115 | 938 | 0 | 22513 | 54.7877 | -6.4923 | 2020-10-15 04:24:28 | Northern Ireland, United Kingdom | ||
3785548 | 3785548 | 2020-10-13 | United Kingdom | Northern Ireland | 21898 | 934 | 0 | 21300 | 54.7877 | -6.4923 | 2020-10-14 04:24:05 | Northern Ireland, United Kingdom | ||
2295088 | 2295088 | 2020-10-12 | United Kingdom | Northern Ireland | 21035 | 929 | 0 | 20444 | 54.7877 | -6.4923 | 2020-10-13 04:24:02 | Northern Ireland, United Kingdom | ||
3789540 | 3789540 | 2020-10-11 | United Kingdom | Northern Ireland | 20158 | 923 | 0 | 19570 | 54.7877 | -6.4923 | 2020-10-12 04:23:45 | Northern Ireland, United Kingdom | ||
2605678 | 2605678 | 2020-10-10 | United Kingdom | Northern Ireland | 19092 | 917 | 0 | 18505 | 54.7877 | -6.4923 | 2020-10-11 04:23:46 | Northern Ireland, United Kingdom | ||
821211 | 821211 | 2020-10-09 | United Kingdom | Northern Ireland | 18190 | 915 | 0 | 17603 | 54.7877 | -6.4923 | 2020-10-10 04:23:57 | Northern Ireland, United Kingdom | ||
2693326 | 2693326 | 2020-10-08 | United Kingdom | Northern Ireland | 17110 | 915 | 0 | 16523 | 54.7877 | -6.4923 | 2020-10-09 04:23:59 | Northern Ireland, United Kingdom | ||
1045468 | 1045468 | 2020-10-07 | United Kingdom | Northern Ireland | 16187 | 915 | 0 | 15601 | 54.7877 | -6.4923 | 2020-10-08 04:23:56 | Northern Ireland, United Kingdom | ||
3121129 | 3121129 | 2020-10-06 | United Kingdom | Northern Ireland | 15359 | 913 | 0 | 14774 | 54.7877 | -6.4923 | 2020-10-07 04:23:40 | Northern Ireland, United Kingdom | ||
3805541 | 3805541 | 2020-10-05 | United Kingdom | Northern Ireland | 14690 | 912 | 0 | 14106 | 54.7877 | -6.4923 | 2020-10-06 04:23:33 | Northern Ireland, United Kingdom | ||
1826431 | 1826431 | 2020-10-04 | United Kingdom | Northern Ireland | 14074 | 910 | 0 | 13490 | 54.7877 | -6.4923 | 2020-10-05 04:23:33 | Northern Ireland, United Kingdom |
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]);