Data source: Big Local News · About: big-local-datasette

7 rows where 1/25/20 = 0 and 2/15/20 = 1

View and edit SQL

Suggested facets: Province/State, 1/27/20, 1/28/20, 1/29/20, 1/30/20, 1/31/20, 2/1/20, 2/2/20, 2/3/20, 2/4/20, 2/5/20, 2/6/20, 2/7/20, 2/8/20, 2/9/20, 2/10/20, 2/11/20, 2/12/20, 2/13/20, 2/26/20, 2/27/20, 2/28/20, 2/29/20, 3/1/20, 3/2/20, 3/3/20, 3/4/20, 3/5/20, 3/6/20, 3/7/20, 3/8/20, 3/9/20, 3/10/20

Link rowid ▼ Province/State Country/Region Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 1/30/20 1/31/20 2/1/20 2/2/20 2/3/20 2/4/20 2/5/20 2/6/20 2/7/20 2/8/20 2/9/20 2/10/20 2/11/20 2/12/20 2/13/20 2/14/20 2/15/20 2/16/20 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 3/29/20 3/30/20 3/31/20 4/1/20 4/2/20 4/3/20 4/4/20 4/5/20 4/6/20 4/7/20 4/8/20 4/9/20 4/10/20 4/11/20 4/12/20 4/13/20 4/14/20 4/15/20 4/16/20 4/17/20 4/18/20 4/19/20 4/20/20 4/21/20 4/22/20 4/23/20 4/24/20 4/25/20 4/26/20 4/27/20 4/28/20 4/29/20 4/30/20 5/1/20 5/2/20 5/3/20 5/4/20 5/5/20 5/6/20 5/7/20 5/8/20 5/9/20 5/10/20 5/11/20 5/12/20 5/13/20 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/20 5/26/20 5/27/20 5/28/20 5/29/20 5/30/20 5/31/20 6/1/20 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 6/10/20 6/11/20 6/12/20 6/13/20 6/14/20 6/15/20 6/16/20 6/17/20 6/18/20 6/19/20 6/20/20 6/21/20 6/22/20 6/23/20 6/24/20 6/25/20 6/26/20 6/27/20 6/28/20 6/29/20 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/20 7/17/20 7/18/20 7/19/20 7/20/20 7/21/20 7/22/20 7/23/20 7/24/20 7/25/20 7/26/20 7/27/20 7/28/20 7/29/20 7/30/20 7/31/20 8/1/20 8/2/20 8/3/20 8/4/20 8/5/20 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 8/18/20 8/19/20 8/20/20 8/21/20 8/22/20 8/23/20 8/24/20 8/25/20 8/26/20 8/27/20 8/28/20 8/29/20 8/30/20 8/31/20 9/1/20 9/2/20 9/3/20 9/4/20 9/5/20 9/6/20 9/7/20 9/8/20 9/9/20 9/10/20 9/11/20 9/12/20 9/13/20 9/14/20 9/15/20 9/16/20 9/17/20 9/18/20 9/19/20 9/20/20 9/21/20 9/22/20 9/23/20 9/24/20 9/25/20 9/26/20
24   Belgium 50.8333 4.469936 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 8 13 23 50 109 169 200 239 267 314 314 559 689 886 1058 1243 1486 1795 2257 2815 3401 3743 4269 4937 6235 7284 9134 10836 11899 12775 13964 15348 16770 18431 19691 20814 22194 23403 24983 26667 28018 29647 30589 31119 33573 34809 36138 37183 38496 39983 40956 41889 42797 44293 45325 46134 46687 47334 47859 48519 49032 49517 49906 50267 50509 50781 51420 52011 52596 53081 53449 53779 53981 54288 54644 54989 55280 55559 55791 55983 56235 56511 56810 57092 57342 57455 57592 57849 58061 58186 58381 58517 58615 58685 58767 58907 59072 59226 59348 59437 59569 59711 59819 59918 60029 60100 60155 60244 60348 60476 60550 60550 60550 60810 60898 61007 61106 61209 61295 61361 61427 61509 61598 61727 61838 62016 62058 62058 62123 62210 62357 62469 62707 62707 62781 62872 63238 63499 63706 63706 64094 64258 64627 64847 65199 65727 66026 66428 66662 67335 68006 68751 69402 69849 70314 70648 71158 72016 72784 73401 74152 74620 75008 75647 76191 77113 77869 78323 78534 78897 79479 80178 80894 81468 81936 82092 82447 83030 83500 83952 84599 85042 85236 85487 85911 86544 87174 87825 88367 88769 89141 89691 90568 91537 92478 93455 94306 94795 95948 97976 99649 100748 102295 103392 105226 106887 108768 110976 112803
38   Cambodia 11.55 104.9167 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 3 3 5 7 7 7 33 35 37 51 53 84 87 91 96 96 99 99 103 107 109 109 110 114 114 114 114 115 117 119 119 120 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 122 123 123 124 124 124 124 124 124 124 125 125 125 125 125 125 125 125 126 126 126 126 126 126 128 128 128 128 128 129 129 129 129 130 130 130 130 139 141 141 141 141 141 141 141 141 141 141 141 141 141 141 156 156 165 165 166 171 171 171 171 171 197 198 202 202 225 225 226 226 226 234 239 240 240 240 243 243 243 246 248 251 251 268 272 273 273 273 273 273 273 273 273 273 273 273 273 273 273 273 273 273 273 274 274 274 274 274 274 274 274 274 274 274 274 275 275 275 275 275 275 275 275 275 275 275 275 275 275 276
86 Tibet China 31.6927 88.0924 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
108   Egypt 26.820553000000004 30.802497999999996 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 3 15 15 49 55 59 60 67 80 109 110 150 196 196 256 285 294 327 366 402 456 495 536 576 609 656 710 779 865 985 1070 1173 1322 1450 1560 1699 1794 1939 2065 2190 2350 2505 2673 2844 3032 3144 3333 3490 3659 3891 4092 4319 4534 4782 5042 5268 5537 5895 6193 6465 6813 7201 7588 7981 8476 8964 9400 9746 10093 10431 10829 11228 11719 12229 12764 13484 14229 15003 15786 16513 17265 17967 18756 19666 20793 22082 23449 24985 26384 27536 28615 29767 31115 32612 34079 35444 36829 38284 39726 41303 42980 44598 46289 47856 49219 50437 52211 53758 55233 56809 58141 59561 61130 62755 63923 65188 66754 68311 69814 71299 72711 74035 75253 76222 77279 78304 79254 80235 81158 82070 83001 83930 84843 85771 86474 87172 87775 88402 89078 89745 90413 91072 91583 92062 92482 92947 93356 93757 94078 94316 94483 94640 94752 94875 95006 95147 95314 95492 95666 95834 95963 96108 96220 96336 96475 96590 96753 96914 97025 97148 97237 97340 97478 97619 97825 98062 98285 98497 98727 98939 99115 99280 99425 99582 99712 99863 100041 100228 100403 100557 100708 100856 101009 101177 101340 101500 101641 101772 101900 102015 102141 102254 102375 102513 102625 102736
116   Finland 61.92411 25.748151 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 3 6 6 6 6 12 15 15 23 30 40 59 59 155 225 244 277 321 336 400 450 523 626 700 792 880 958 1041 1167 1240 1352 1418 1446 1518 1615 1882 1927 2176 2308 2487 2605 2769 2905 2974 3064 3161 3237 3369 3489 3681 3783 3868 4014 4129 4284 4395 4475 4576 4695 4740 4906 4995 5051 5176 5254 5327 5412 5573 5673 5738 5880 5962 5984 6003 6054 6145 6228 6286 6347 6380 6399 6443 6493 6537 6568 6579 6599 6628 6692 6743 6776 6826 6859 6885 6887 6911 6911 6941 6964 6981 7001 7025 7040 7064 7073 7087 7104 7108 7112 7117 7119 7133 7142 7143 7144 7155 7167 7172 7191 7198 7198 7209 7214 7236 7241 7242 7248 7253 7257 7262 7265 7273 7279 7291 7294 7295 7301 7296 7293 7301 7318 7335 7340 7351 7362 7372 7380 7388 7393 7398 7404 7414 7423 7432 7443 7453 7466 7483 7512 7532 7554 7568 7584 7601 7623 7642 7683 7700 7720 7731 7752 7776 7805 7842 7871 7906 7920 7938 7981 8002 8019 8042 8049 8077 8086 8142 8161 8200 8225 8261 8291 8327 8337 8430 8469 8512 8557 8580 8627 8725 8750 8799 8858 8922 8980 9046 9195 9288 9379 9484 9577
228   Sri Lanka 7.873054 80.77179699999999 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 6 10 18 28 44 51 60 73 77 82 97 102 102 106 106 113 117 122 143 146 151 159 166 176 178 185 189 190 190 198 210 217 233 238 238 244 254 271 304 310 330 368 420 460 523 588 619 649 663 690 705 718 751 771 797 824 835 847 863 869 889 915 925 935 960 981 992 1027 1028 1055 1068 1089 1141 1182 1319 1469 1530 1558 1620 1633 1643 1683 1749 1797 1801 1814 1835 1857 1859 1869 1877 1880 1884 1889 1905 1915 1924 1947 1950 1950 1950 1951 1991 2001 2010 2014 2033 2037 2039 2047 2054 2066 2069 2074 2076 2077 2081 2094 2154 2454 2511 2617 2646 2665 2671 2687 2697 2703 2724 2730 2730 2752 2753 2764 2770 2782 2805 2810 2810 2814 2815 2815 2823 2828 2834 2839 2839 2839 2841 2844 2871 2880 2881 2882 2886 2890 2893 2900 2902 2902 2918 2941 2947 2953 2959 2971 2984 2986 2989 2995 3012 3049 3092 3101 3111 3115 3121 3123 3123 3140 3147 3155 3169 3195 3234 3262 3271 3271 3276 3281 3283 3287 3299 3313 3324 3333 3345 3349
231   Sweden 60.128161 18.643501 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 3 11 14 14 19 32 62 87 146 179 225 326 424 620 771 923 994 1063 1146 1265 1410 1553 1733 1868 1986 2168 2398 2712 2998 3363 3663 3943 4359 4834 5320 5874 6475 6832 7172 7561 8299 8954 9599 10053 10448 10912 11349 11828 12432 13055 13743 14275 14663 15124 15831 16553 17311 18090 18563 18863 19426 20168 20966 21601 22133 22432 22693 23169 23826 24572 25359 26059 26568 26846 27301 28055 28755 29415 30103 30461 30720 31151 31818 32626 33236 33768 34171 34381 34871 35617 36417 37191 37964 38396 38661 39309 40210 41256 42295 43441 44224 44686 45363 46299 47736 49030 50367 51409 51827 52511 53729 55186 56682 57895 58597 58918 59718 61030 62728 64009 65212 65972 66392 67119 67924 68608 69297 69996 70366 70681 70932 71210 71747 72082 72459 72773 72879 73049 73364 73663 73936 74235 74435 74545 74676 74902 75199 75419 75681 75819 75861 75932 76215 76516 76818 77076 77379 77417 77582 77916 78341 78719 79099 79359 79432 79628 80045 80489 80851 81195 81421 81484 81658 81972 82323 82656 82954 83114 83171 83353 83578 83824 83958 83958 83958 83958 84379 84521 84532 84729 84985 84985 84985 85558 85707 85880 86194 86505 86505 86505 86505 87345 87575 87885 88237 88237 88237 88237 89436 89756 90289 90923 90923

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [time_series_covid19_confirmed_global] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Lat] TEXT,
   [Long] TEXT,
   [1/22/20] INTEGER,
   [1/23/20] INTEGER,
   [1/24/20] INTEGER,
   [1/25/20] INTEGER,
   [1/26/20] INTEGER,
   [1/27/20] INTEGER,
   [1/28/20] INTEGER,
   [1/29/20] INTEGER,
   [1/30/20] INTEGER,
   [1/31/20] INTEGER,
   [2/1/20] INTEGER,
   [2/2/20] INTEGER,
   [2/3/20] INTEGER,
   [2/4/20] INTEGER,
   [2/5/20] INTEGER,
   [2/6/20] INTEGER,
   [2/7/20] INTEGER,
   [2/8/20] INTEGER,
   [2/9/20] INTEGER,
   [2/10/20] INTEGER,
   [2/11/20] INTEGER,
   [2/12/20] INTEGER,
   [2/13/20] INTEGER,
   [2/14/20] INTEGER,
   [2/15/20] INTEGER,
   [2/16/20] INTEGER,
   [2/17/20] INTEGER,
   [2/18/20] INTEGER,
   [2/19/20] INTEGER,
   [2/20/20] INTEGER,
   [2/21/20] INTEGER,
   [2/22/20] INTEGER,
   [2/23/20] INTEGER,
   [2/24/20] INTEGER,
   [2/25/20] INTEGER,
   [2/26/20] INTEGER,
   [2/27/20] INTEGER,
   [2/28/20] INTEGER,
   [2/29/20] INTEGER,
   [3/1/20] INTEGER,
   [3/2/20] INTEGER,
   [3/3/20] INTEGER,
   [3/4/20] INTEGER,
   [3/5/20] INTEGER,
   [3/6/20] INTEGER,
   [3/7/20] INTEGER,
   [3/8/20] INTEGER,
   [3/9/20] INTEGER,
   [3/10/20] INTEGER,
   [3/11/20] INTEGER,
   [3/12/20] INTEGER,
   [3/13/20] INTEGER,
   [3/14/20] INTEGER,
   [3/15/20] INTEGER,
   [3/16/20] INTEGER,
   [3/17/20] INTEGER,
   [3/18/20] INTEGER,
   [3/19/20] INTEGER,
   [3/20/20] INTEGER,
   [3/21/20] INTEGER,
   [3/22/20] INTEGER,
   [3/23/20] INTEGER,
   [3/24/20] INTEGER,
   [3/25/20] INTEGER,
   [3/26/20] INTEGER,
   [3/27/20] INTEGER,
   [3/28/20] INTEGER,
   [3/29/20] INTEGER,
   [3/30/20] INTEGER,
   [3/31/20] INTEGER,
   [4/1/20] INTEGER,
   [4/2/20] INTEGER,
   [4/3/20] INTEGER,
   [4/4/20] INTEGER,
   [4/5/20] INTEGER,
   [4/6/20] INTEGER,
   [4/7/20] INTEGER,
   [4/8/20] INTEGER,
   [4/9/20] INTEGER,
   [4/10/20] INTEGER,
   [4/11/20] INTEGER,
   [4/12/20] INTEGER,
   [4/13/20] INTEGER,
   [4/14/20] INTEGER,
   [4/15/20] INTEGER,
   [4/16/20] INTEGER,
   [4/17/20] INTEGER,
   [4/18/20] INTEGER,
   [4/19/20] INTEGER,
   [4/20/20] INTEGER,
   [4/21/20] INTEGER,
   [4/22/20] INTEGER,
   [4/23/20] INTEGER,
   [4/24/20] INTEGER,
   [4/25/20] INTEGER,
   [4/26/20] INTEGER,
   [4/27/20] INTEGER,
   [4/28/20] INTEGER,
   [4/29/20] INTEGER,
   [4/30/20] INTEGER,
   [5/1/20] INTEGER,
   [5/2/20] INTEGER,
   [5/3/20] INTEGER,
   [5/4/20] INTEGER,
   [5/5/20] INTEGER,
   [5/6/20] INTEGER,
   [5/7/20] INTEGER,
   [5/8/20] INTEGER,
   [5/9/20] INTEGER,
   [5/10/20] INTEGER,
   [5/11/20] INTEGER,
   [5/12/20] INTEGER,
   [5/13/20] INTEGER,
   [5/14/20] INTEGER,
   [5/15/20] INTEGER,
   [5/16/20] INTEGER,
   [5/17/20] INTEGER,
   [5/18/20] INTEGER,
   [5/19/20] INTEGER,
   [5/20/20] INTEGER,
   [5/21/20] INTEGER,
   [5/22/20] INTEGER,
   [5/23/20] INTEGER,
   [5/24/20] INTEGER,
   [5/25/20] INTEGER,
   [5/26/20] INTEGER,
   [5/27/20] INTEGER,
   [5/28/20] INTEGER,
   [5/29/20] INTEGER,
   [5/30/20] INTEGER,
   [5/31/20] INTEGER,
   [6/1/20] INTEGER,
   [6/2/20] INTEGER,
   [6/3/20] INTEGER,
   [6/4/20] INTEGER,
   [6/5/20] INTEGER,
   [6/6/20] INTEGER,
   [6/7/20] INTEGER,
   [6/8/20] INTEGER,
   [6/9/20] INTEGER,
   [6/10/20] INTEGER,
   [6/11/20] INTEGER,
   [6/12/20] INTEGER,
   [6/13/20] INTEGER,
   [6/14/20] INTEGER,
   [6/15/20] INTEGER,
   [6/16/20] INTEGER,
   [6/17/20] INTEGER,
   [6/18/20] INTEGER,
   [6/19/20] INTEGER,
   [6/20/20] INTEGER,
   [6/21/20] INTEGER,
   [6/22/20] INTEGER,
   [6/23/20] INTEGER,
   [6/24/20] INTEGER,
   [6/25/20] INTEGER,
   [6/26/20] INTEGER,
   [6/27/20] INTEGER,
   [6/28/20] INTEGER,
   [6/29/20] INTEGER,
   [6/30/20] INTEGER,
   [7/1/20] INTEGER,
   [7/2/20] INTEGER,
   [7/3/20] INTEGER,
   [7/4/20] INTEGER,
   [7/5/20] INTEGER,
   [7/6/20] INTEGER,
   [7/7/20] INTEGER,
   [7/8/20] INTEGER,
   [7/9/20] INTEGER,
   [7/10/20] INTEGER,
   [7/11/20] INTEGER,
   [7/12/20] INTEGER,
   [7/13/20] INTEGER,
   [7/14/20] INTEGER,
   [7/15/20] INTEGER,
   [7/16/20] INTEGER,
   [7/17/20] INTEGER,
   [7/18/20] INTEGER,
   [7/19/20] INTEGER,
   [7/20/20] INTEGER,
   [7/21/20] INTEGER,
   [7/22/20] INTEGER,
   [7/23/20] INTEGER,
   [7/24/20] INTEGER,
   [7/25/20] INTEGER,
   [7/26/20] INTEGER,
   [7/27/20] INTEGER,
   [7/28/20] INTEGER,
   [7/29/20] INTEGER,
   [7/30/20] INTEGER,
   [7/31/20] INTEGER,
   [8/1/20] INTEGER,
   [8/2/20] INTEGER,
   [8/3/20] INTEGER,
   [8/4/20] INTEGER,
   [8/5/20] INTEGER,
   [8/6/20] INTEGER,
   [8/7/20] INTEGER,
   [8/8/20] INTEGER,
   [8/9/20] INTEGER,
   [8/10/20] INTEGER,
   [8/11/20] INTEGER,
   [8/12/20] INTEGER,
   [8/13/20] INTEGER,
   [8/14/20] INTEGER,
   [8/15/20] INTEGER,
   [8/16/20] INTEGER,
   [8/17/20] INTEGER,
   [8/18/20] INTEGER,
   [8/19/20] INTEGER,
   [8/20/20] INTEGER,
   [8/21/20] INTEGER,
   [8/22/20] INTEGER,
   [8/23/20] INTEGER,
   [8/24/20] INTEGER,
   [8/25/20] INTEGER,
   [8/26/20] INTEGER,
   [8/27/20] INTEGER,
   [8/28/20] INTEGER,
   [8/29/20] INTEGER,
   [8/30/20] INTEGER,
   [8/31/20] INTEGER,
   [9/1/20] INTEGER,
   [9/2/20] INTEGER,
   [9/3/20] INTEGER,
   [9/4/20] INTEGER,
   [9/5/20] INTEGER,
   [9/6/20] INTEGER,
   [9/7/20] INTEGER,
   [9/8/20] INTEGER,
   [9/9/20] INTEGER,
   [9/10/20] INTEGER,
   [9/11/20] INTEGER,
   [9/12/20] INTEGER,
   [9/13/20] INTEGER,
   [9/14/20] INTEGER,
   [9/15/20] INTEGER,
   [9/16/20] INTEGER,
   [9/17/20] INTEGER,
   [9/18/20] INTEGER,
   [9/19/20] INTEGER,
   [9/20/20] INTEGER,
   [9/21/20] INTEGER,
   [9/22/20] INTEGER,
   [9/23/20] INTEGER,
   [9/24/20] INTEGER,
   [9/25/20] INTEGER,
   [9/26/20] INTEGER
);