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

6 rows where 1/25/20 = 0 and 3/3/20 = 3

View and edit SQL

Suggested facets: Province/State, 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/4/20, 3/5/20, 3/7/20, 3/9/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
13 South Australia Australia -34.9285 138.6007 0 0 0 0 0 0 0 0 0 0 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 5 5 7 7 7 7 7 9 9 16 19 20 29 29 37 42 50 67 100 134 170 170 235 257 287 299 305 337 367 367 396 407 407 411 411 415 420 428 429 429 429 433 433 433 435 435 435 435 437 438 438 438 438 438 438 438 438 438 438 438 438 438 438 438 439 439 439 439 439 439 439 439 439 439 439 439 439 439 439 439 439 439 439 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 443 443 443 443 443 443 443 443 443 443 443 443 443 443 443 443 444 444 444 444 444 444 444 446 447 447 447 447 447 448 448 449 451 453 455 457 457 456 459 459 459 459 459 459 459 460 460 460 461 462 462 462 462 462 462 463 463 463 463 463 463 463 463 463 463 463 463 463 464 464 464 465 465 465 466 466 466 466 466 466 466 466 466 466 466 466 468 468 468 468
18   Azerbaijan 40.1431 47.5769 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 0 0 0 0 3 3 3 3 6 6 9 9 9 11 11 11 15 15 23 28 28 28 44 44 53 65 72 87 93 122 165 182 209 273 298 359 400 443 521 584 641 717 822 926 991 1058 1098 1148 1197 1253 1283 1340 1373 1398 1436 1480 1518 1548 1592 1617 1645 1678 1717 1766 1804 1854 1894 1932 1984 2060 2127 2204 2279 2422 2519 2589 2693 2758 2879 2980 3138 3274 3387 3518 3631 3749 3855 3982 4122 4271 4403 4568 4759 4989 5246 5494 5662 5935 6260 6522 6860 7239 7553 7876 8191 8530 8882 9218 9570 9957 10324 10662 10991 11329 11767 12238 12729 13207 13715 14305 14852 15369 15890 16424 16968 17524 18112 18684 19267 19801 20324 20837 21374 21916 22464 22990 23521 24041 24570 25113 25672 26165 26636 27133 27521 27890 28242 28633 28980 29312 29633 30050 30446 30858 31221 31560 31878 32157 32443 32684 32910 33103 33247 33376 33481 33568 33647 33731 33824 33915 34018 34107 34219 34343 34474 34620 34759 34921 35105 35274 35426 35559 35707 35844 35986 36174 36309 36435 36578 36732 36899 37031 37192 37329 37418 37557 37732 37874 38037 38172 38327 38403 38517 38658 38777 38894 39042 39188 39280 39378 39524 39686 39787 39895
130   Georgia 42.3154 43.3569 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 1 1 1 3 3 3 3 4 4 4 13 15 15 24 24 25 30 33 33 34 38 40 43 49 54 61 70 75 79 83 90 91 103 110 117 134 155 162 174 188 196 211 218 234 242 257 272 300 306 348 370 388 394 402 408 416 425 444 456 486 497 511 517 539 566 582 589 593 604 610 615 623 626 635 638 642 647 667 671 683 695 701 707 713 721 723 728 730 731 732 735 738 746 757 783 794 796 800 801 805 808 809 812 818 827 831 843 851 864 879 879 888 893 896 898 906 908 911 914 917 919 921 924 926 928 931 939 943 948 951 953 958 963 968 973 981 986 995 999 1004 1006 1010 1018 1028 1039 1049 1073 1085 1104 1117 1131 1137 1145 1155 1160 1168 1171 1177 1179 1182 1197 1206 1213 1216 1225 1250 1264 1278 1283 1306 1321 1336 1341 1351 1361 1370 1385 1394 1411 1421 1429 1436 1447 1455 1462 1469 1487 1510 1548 1568 1596 1621 1650 1684 1729 1773 1830 1917 2075 2227 2392 2562 2758 2937 3119 3306 3502 3695 3913 4140 4399 4664 4960
204   Philippines 12.879721 121.77401699999999 0 0 0 0 0 0 0 0 1 1 1 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 5 6 10 20 33 49 52 64 111 140 142 187 202 217 230 307 380 462 552 636 707 803 1075 1418 1546 2084 2311 2633 3018 3094 3246 3660 3764 3870 4076 4195 4428 4648 4932 5223 5453 5660 5878 6087 6259 6459 6599 6710 6981 7192 7294 7579 7777 7958 8212 8488 8772 8928 9223 9485 9684 10004 10343 10463 10610 10794 11086 11350 11618 11876 12091 12305 12513 12718 12942 13221 13434 13597 13777 14035 14319 14669 15049 15588 16634 17224 18086 18638 18997 19748 20382 20626 21340 21895 22474 22992 23732 24175 24787 25392 25930 26420 26781 27238 27799 28459 29400 30052 30682 31825 32295 33069 34073 34803 35455 36438 37514 38511 38805 40336 41830 44254 46333 47873 50359 51754 52914 54222 56259 57006 57545 58850 61266 63001 65304 67456 68898 70764 72269 74390 76444 78412 80448 82040 83673 85486 89374 93354 98232 103185 106330 112593 115980 119460 122754 126885 129913 136638 139538 143749 147526 153660 157918 161253 164474 169213 173774 178022 182365 187249 189601 194252 197164 202361 205581 209544 213131 217396 220819 224264 226440 228403 232072 234570 237365 238727 241987 245143 248947 252964 257863 261216 265888 269407 272934 276289 279526 283460 286743 290190 291789 294591 296755 299361 301256
208   Romania 45.9432 24.9668 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 1 3 3 3 3 3 4 6 9 9 15 15 25 45 49 89 123 131 158 184 260 277 308 367 433 576 794 906 1029 1292 1452 1815 2109 2245 2460 2738 3183 3613 3864 4057 4417 4761 5202 5467 5990 6300 6633 6879 7216 7707 8067 8418 8746 8936 9242 9710 10096 10417 10635 11036 11339 11616 11978 12240 12567 12732 13163 13512 13837 14107 14499 14811 15131 15362 15588 15778 16002 16247 16437 16704 16871 17036 17191 17387 17585 17712 17857 18070 18283 18429 18594 18791 18982 19133 19257 19398 19517 19669 19907 20103 20290 20479 20604 20749 20945 21182 21404 21679 21999 22165 22415 22760 23080 23400 23730 24045 24291 24505 24826 25286 25697 26022 26313 26582 26970 27296 27746 28166 28582 28973 29223 29620 30175 30789 31381 32079 32535 32948 33585 34226 35003 35802 36691 37458 38139 39133 40163 41275 42394 43678 44798 45902 47053 48235 49591 50886 52111 53186 54009 55241 56550 57895 59273 60623 61768 62547 63762 65177 66631 68046 69374 70461 71194 72208 73617 74963 76355 77544 78505 79330 80390 81646 83150 84468 85833 86785 87540 88593 89891 91256 92595 93864 95014 95897 97033 98304 99684 101075 102386 103495 104187 105298 107011 108690 110217 111550 112781 113589 114648 116415 118054 119683 121235
209   Russia 61.52401 105.31875600000001 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 4 13 13 17 17 20 20 28 45 59 63 90 114 147 199 253 306 367 438 495 658 840 1036 1264 1534 1836 2337 2777 3548 4149 4731 5389 6343 7497 8672 10131 11917 13584 15770 18328 21102 24490 27938 32008 36793 42853 47121 52763 57999 62773 68622 74588 80949 87147 93558 99399 106498 114431 124054 134687 145268 155370 165929 177160 187859 198676 209688 221344 232243 242271 252245 262843 272043 281752 290678 299941 308705 317554 326448 335882 344481 353427 362342 370680 379051 387623 396575 405843 414328 423186 431715 440538 449256 458102 467073 476043 484630 493023 501800 510761 519458 528267 536484 544725 552549 560321 568292 576162 583879 591465 598878 606043 613148 619936 626779 633563 640246 646929 653479 660231 666941 673564 680283 686852 693215 699749 706240 712863 719449 726036 732547 738787 745197 751612 758001 764215 770311 776212 782040 787890 793720 799499 805332 811073 816680 822060 827509 832993 838461 843890 849277 854641 859762 864948 870187 875378 880563 885718 890799 895691 900745 905762 910778 915808 920719 925558 930276 935066 939833 944671 949531 954328 959016 963655 968297 972972 977730 982573 987470 992402 997072 1001965 1006923 1011987 1017131 1022228 1027334 1032354 1037526 1042836 1048257 1053663 1059024 1064438 1069873 1075485 1081152 1086955 1092915 1098958 1105048 1111157 1117487 1123976 1131088 1138509

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