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

6 rows where 1/24/20 = 0 and 2/28/20 = 4

View and edit SQL

Suggested facets: Province/State, Country/Region, 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/29/20, 3/1/20, 3/2/20, 3/3/20, 3/4/20, 3/9/20, 3/10/20, 6/15/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
10 New South Wales Australia -33.8688 151.2093 0 0 0 0 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 6 6 13 22 22 26 28 38 48 55 65 65 92 112 134 171 210 267 307 353 436 669 669 818 1029 1219 1405 1617 1791 2032 2032 2182 2298 2389 2493 2580 2637 2686 2734 2773 2822 2857 2857 2863 2870 2886 2897 2926 2936 2957 2963 2969 2971 2976 2982 2994 3002 3004 3016 3016 3025 3030 3035 3033 3035 3042 3044 3047 3051 3053 3053 3053 3059 3063 3071 3074 3075 3076 3078 3081 3082 3084 3086 3087 3090 3092 3089 3090 3092 3092 3095 3098 3104 3104 3106 3110 3110 3109 3112 3114 3117 3117 3115 3119 3128 3131 3134 3135 3137 3143 3144 3149 3151 3150 3159 3162 3168 3174 3177 3184 3189 3203 3211 3211 3405 3419 3429 3433 3440 3453 3467 3474 3478 3492 3505 3517 3527 3535 3550 3568 3588 3599 3614 3633 3640 3654 3668 3685 3699 3718 3736 3756 3773 3784 3797 3809 3820 3832 3842 3851 3861 3875 3897 3915 3927 3936 3945 3950 3957 3959 3966 3971 3972 3981 3985 3988 3991 3997 4006 4019 4033 4040 4050 4063 4079 4091 4099 4104 4114 4118 4126 4135 4142 4152 4157 4166 4170 4177 4185 4190 4196 4198 4200 4204 4206 4212 4213 4217 4218 4218
15 Victoria Australia -37.8136 144.9631 0 0 0 0 1 1 1 1 2 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 7 7 9 9 10 10 10 11 11 15 18 21 21 36 49 57 71 94 121 121 121 229 355 355 411 466 520 574 685 769 821 917 968 1036 1085 1115 1135 1158 1191 1212 1228 1241 1265 1268 1281 1291 1299 1299 1302 1319 1328 1329 1336 1336 1337 1343 1346 1349 1349 1354 1361 1364 1371 1384 1406 1423 1440 1454 1467 1468 1487 1496 1511 1514 1521 1540 1551 1558 1564 1573 1573 1581 1593 1593 1603 1605 1610 1618 1628 1634 1645 1649 1653 1663 1670 1678 1681 1681 1685 1687 1687 1691 1699 1703 1703 1720 1732 1741 1762 1780 1792 1792 1836 1847 1864 1884 1917 1947 1947 2028 2099 2159 2231 2303 2368 2368 2536 2660 2824 2942 3098 3397 3560 3799 3967 4224 4448 4750 5165 5353 5696 5942 6289 6739 7125 7405 7744 8181 8696 9049 9304 9998 10577 10931 11557 11937 12335 13035 13469 13867 14283 14659 14957 15251 15646 15863 16234 16517 16764 17027 17238 17446 17683 17852 18029 18231 18330 18464 18608 18714 18822 18903 19015 19080 19138 19224 19336 19415 19479 19538 19574 19615 19688 19739 19767 19800 19835 19872 19911 19943 19970 20012 20034 20042 20051 20076 20100 20105 20118 20130 20145
133   Greece 39.0742 21.8243 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 3 4 4 7 7 7 9 31 45 46 73 73 89 99 99 190 228 331 331 387 418 418 495 530 624 695 743 821 892 966 1061 1156 1212 1314 1415 1544 1613 1673 1735 1755 1832 1884 1955 2011 2081 2114 2145 2170 2192 2207 2224 2235 2235 2245 2401 2408 2463 2490 2506 2517 2534 2566 2576 2591 2612 2620 2626 2632 2642 2663 2678 2691 2710 2716 2726 2744 2760 2770 2810 2819 2834 2836 2840 2850 2853 2874 2876 2878 2882 2892 2903 2906 2909 2915 2917 2918 2937 2937 2952 2967 2980 2997 3049 3058 3068 3088 3108 3112 3121 3134 3148 3203 3227 3237 3256 3266 3287 3302 3310 3321 3343 3366 3376 3390 3409 3432 3458 3486 3511 3519 3562 3589 3622 3672 3732 3772 3803 3826 3883 3910 3939 3964 3983 4007 4012 4048 4077 4110 4135 4166 4193 4227 4279 4336 4401 4477 4587 4662 4737 4855 4974 5123 5270 5421 5623 5749 5942 6177 6381 6632 6858 7075 7222 7472 7684 7934 8138 8381 8664 8819 8987 9280 9531 9800 9977 10134 10317 10524 10757 10998 11200 11386 11524 11663 11832 12080 12452 12734 13036 13240 13420 13730 14041 14400 14738 14978 15142 15595 15928 16286 16627 16913 17228
149   Israel 31.046051000000002 34.851612 0 0 0 0 0 0 0 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 2 3 4 7 10 10 12 15 20 37 43 61 61 75 79 100 126 155 213 218 250 304 427 529 712 883 1071 1238 2369 2693 3035 3619 4247 4695 5358 6092 6857 7428 7851 8430 8904 9248 9404 9968 10408 10743 11145 11586 12046 12501 12758 12982 13265 13491 13713 13942 14498 14803 15058 15298 15443 15555 15728 15834 15946 16101 16185 16208 16246 16289 16310 16381 16436 16454 16477 16506 16529 16548 16579 16589 16608 16617 16643 16659 16667 16683 16690 16712 16717 16734 16757 16793 16872 16987 17012 17071 17169 17285 17377 17495 17562 17752 17863 18032 18180 18355 18569 18795 18972 19055 19237 19495 19783 20036 20339 20633 20778 21082 21512 22044 22400 22800 23421 23755 24441 25244 26257 27047 28055 29170 29958 30749 32222 33557 34825 36266 37464 38670 40632 42360 44188 46059 47459 49365 50289 52003 54042 56085 57982 59475 60678 61956 63985 66293 68299 70036 70970 72218 72815 74430 76198 77919 79559 80991 82324 83002 84722 86593 88151 89822 91080 92233 92680 94751 96409 97969 99599 100716 101933 102663 104472 106460 108403 110403 112000 113465 114020 116596 118538 121464 124455 126419 128936 130644 133975 137565 141097 145526 148564 152722 155604 160368 164402 170465 175256 179071 183602 187902 190929 193374 204690 212115 217899 227100
198   Oman 21.512583 55.923255000000005 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 4 4 4 6 6 6 12 15 16 16 16 16 16 18 18 18 19 19 22 22 24 39 48 48 52 55 66 84 99 109 131 152 167 179 192 210 231 252 277 298 331 371 419 457 484 546 599 727 813 910 1019 1069 1180 1266 1410 1508 1614 1716 1790 1905 1998 2049 2131 2274 2348 2447 2483 2568 2637 2735 2903 2958 3112 3224 3399 3573 3721 4019 4341 4625 5029 5186 5379 5671 6043 6370 6794 7257 7770 7770 8118 8373 9009 9820 10423 11437 12223 12799 13537 14316 15086 16016 16882 17486 18198 18887 19954 21071 22077 23481 24524 25269 26079 26818 27670 28566 29471 31076 32394 33536 34902 36034 36953 38150 39060 40070 41194 42555 43929 45106 46178 47735 48997 50207 51725 53614 54697 56015 58179 59568 61247 62574 64193 65504 66661 68400 69887 71547 72646 73791 74858 76005 77058 77904 78569 79159 79159 79159 79159 79159 79159 80286 80713 81067 81357 81580 81787 82050 82299 82531 82743 82924 83086 83226 83418 83606 83769 83769 83769 83769 84509 84652 84818 85005 85005 85005 85544 85722 85928 85928 86380 86380 86380 87072 87328 87590 87939 88337 88337 88337 89746 90222 90660 91196 91753 91753 91753 93475 94051 94711 95339 95907 95907 95907
199   Pakistan 30.3753 69.3451 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 4 4 4 5 5 5 6 6 6 6 16 19 20 28 31 53 136 236 299 454 501 730 776 875 972 1063 1201 1373 1495 1597 1717 1938 2118 2421 2686 2818 3157 3766 4035 4263 4489 4695 5011 5230 5496 5837 6383 6919 7025 7638 8348 8418 9565 10076 11155 11940 12723 13328 13915 14612 15525 16817 18114 19103 20084 20941 22049 24073 24644 26435 28736 30334 32081 34336 35298 35788 38799 38799 40151 42125 43966 45898 48091 50694 52437 54601 56349 57705 59151 61227 64028 66457 69496 72460 76398 80463 85264 89249 93983 98943 103671 108317 113702 119536 125933 125933 132405 144478 148921 154760 160118 165062 171666 176617 181088 185034 188926 192970 195745 198883 202955 206512 209337 213470 217809 221896 221896 225283 231818 234509 237489 240848 243599 246351 248872 251625 253604 255769 257914 257914 261917 263496 265083 266096 267428 269191 270400 271887 273113 273113 274289 275225 276288 277402 278305 278305 279699 280461 280461 281136 281863 282645 283487 284121 284660 285191 285921 286674 287300 288047 289215 289215 289832 290445 290958 291588 292174 293261 293261 293711 294193 294638 295053 295372 295636 295849 296149 297014 297512 298025 298025 298903 299233 299659 300030 300371 300955 301481 302020 302424 303089 303634 304386 305031 305671 306304 306886 307418 308217 309015 309581 310275

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
);