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

6 rows where 2/7/20 = 1

View and edit SQL

Suggested facets: Province/State, 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/9/20, 2/10/20, 2/11/20, 2/13/20, 2/14/20, 2/15/20, 2/16/20, 2/17/20, 2/18/20, 2/24/20, 2/25/20, 2/26/20, 2/27/20, 2/28/20

2/7/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
64 Macau China 22.1667 113.55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 2 3 3 3 5 5 5 5 6 6 6 6 6 7 7 8 8 8 8 8 9 9 9 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 13 13 13 16 16 16 17 20 22 24 26 27 27 28 31 32 33 34 35 35 37 39 39 39 40 40 40 40 41 42 42 43 43 43 44 44 44 44 44 44 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46
139   Japan 36.204824 138.252924 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 9 9 9 9 12 12 12 13 18 18 22 22 22 22 22 22 22 22 32 32 32 43 43 43 46 76 76 76 101 118 118 118 118 118 144 144 144 150 191 232 235 235 285 310 359 372 404 424 424 424 472 472 514 514 514 575 592 622 632 685 762 762 784 799 853 901 935 1069 1159 1159 1239 1356 1494 1530 1656 1809 1899 1899 2368 2460 2975 3205 3981 4156 4496 4496 4918 5146 5906 8127 8293 8531 8920 9868 10338 10338 11153 11564 11564 11564 12672 13005 13244 13413 13612 13810 13973 14096 14213 14267 14342 14463 14585 14702 14785 14925 14927 14990 15043 15141 15217 15233 15362 15458 15514 15567 15652 15753 15753 15844 15948 15948 15957 16096 16101 16142 16224 16293 16327 16388 16458 16563 16615 16721 16832 16870 17007 17057 17057 17412 17494 17494 17845 18058 18126 18126 18641 18944 19211 19211 19603 20001 20482 20878 21173 21464 21606 21970 22636 23351 24024 24774 25347 25748 26476 27187 28020 28858 30241 31248 32867 33450 34136 34969 36191 35498 39439 40560 41591 42965 43786 45110 46264 47418 48319 49089 50092 51407 52542 53691 54883 55700 56338 57503 58108 58200 60093 61099 61730 62190 62936 63734 64489 65244 65934 66524 66901 66901 68110 68827 69468 70051 70604 70970 71214 71547 72066 73016 73677
143   Korea, South 35.90775700000001 127.766922 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 3 3 3 7 7 7 9 9 10 12 12 16 16 16 18 18 22 22 22 22 27 30 30 30 41 41 135 135 118 118 247 288 333 510 510 510 1137 1407 1540 1540 1540 1540 2909 2909 3507 3730 4144 4528 4811 5033 5228 5408 5567 5828 6021 6325 6463 6598 6694 6776 6973 7117 7243 7368 7447 7534 7616 7757 7829 7937 8042 8114 8213 8277 8501 8635 8717 8764 8854 8922 9059 9072 9123 9183 9217 9283 9333 9419 9484 9568 9610 9632 9670 9695 9762 9821 9851 9888 9904 9938 10066 10135 10162 10194 10213 10226 10275 10295 10340 10363 10398 10405 10422 10446 10467 10499 10506 10531 10552 10563 10589 10611 10654 10669 10691 10718 10730 10760 10774 10800 10835 10856 10868 10881 10908 10930 10974 11172 11317 11364 11429 11537 11613 11684 11759 11811 11832 11848 11914 11970 12019 12065 12144 12178 12204 12282 12348 12396 12460 12519 12556 12572 12643 12698 12758 12817 12866 12890 12905 13007 13069 13132 13183 13233 13259 13280 13352 13406 13501 13543 13629 13642 13658 13729 13786 13817 13863 13901 13910 13917 13934 14006 14063 14120 14169 14200 14219 14286 14368 14461 14551 14765 14903 14973 15198 15356 15529 15783 16009 16146 16297 16636 17023 17360 17616 18029 18226 18489 18878 19310 19543 19771 19970 20158 20248 20441 20650 20832 20978 21166 21248
159   Malaysia 4.210483999999999 101.97576600000001 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 3 3 3 3 7 7 7 13 15 15 15 15 15 18 18 18 18 18 18 18 18 22 22 22 22 23 24 24 24 26 26 26 35 42 42 49 60 75 87 114 139 139 183 199 215 259 320 388 479 537 645 767 827 915 1005 1241 1321 1487 1608 1830 1995 2108 2276 2478 2647 2766 2967 3102 3197 3295 3349 3452 3542 3663 3762 3862 3957 4032 4087 4171 4210 4326 4413 4484 4567 4702 4776 4864 4929 5025 5113 5223 5281 5351 5439 5512 5571 5615 5646 5706 5796 5859 5912 5945 5979 6041 6083 6169 6235 6330 6353 6404 6470 6531 6559 6610 6635 6674 6694 6975 7014 7065 7168 7311 7346 7400 7733 7873 8000 8070 8146 8156 8177 8186 8231 8271 8294 8308 8318 8334 8354 8375 8437 8446 8461 8465 8476 8481 8486 8499 8511 8515 8519 8520 8524 8526 8538 8541 8546 8553 8555 8562 8566 8574 8577 8594 8600 8601 8607 8612 8617 8644 8647 8664 8668 8684 8702 8713 8728 8775 8784 8803 8809 8817 8821 8828 8831 8859 8876 8902 8925 8932 8945 8949 8959 8965 8971 8978 8994 9030 9038 9048 9054 9075 9079 9083 9092 9113 9115 9124 9136 9143 9167 9181 9189 9196 9203 9209 9235 9250 9264 9315 9355 9395 9563 9602 9666 9696 9785
221   Taiwan* 23.7 121.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 5 5 5 5 6 9 9 12 12 12 12 12 12 13 15 17 17 20 20 20 20 20 22 22 26 26 28 28 28 29 29 29 29 30 30 39 39 39 45 50 50 50 57 57 61 67 91 99 109 109 124 124 155 166 178 189 203 217 236 253 264 275 281 290 307 311 322 324 324 332 334 334 339 347 355 361 366 368 372 375 383 387 389 395 398 398 398 398 408 411 414 415 416 419 420 420 421 423 427 427 428 428 429 429 430 430 431 431 431 431 431 431 433 433 434 434 434 434 434 435 435 435 435 435 435 435 435 437 438 438 438 438 438 438 438 438 438 438 438 438 438 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 440 441 441 441 441 441 441 441 441 441 441 443 450 450 450 450 450 450 450 457 457 457 457 457 457 457 462 462 462 462 462 462 462 471 471 471 473 473 475 475 475 475 475 475 475 476 476 477 478 478 479 479 479 479 480 480 480 480
248   Vietnam 14.058323999999999 108.277199 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 6 6 7 7 7 7 7 7 7 7 14 14 14 14 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 17 17 17 17 17 20 20 21 25 55 58 63 75 85 90 90 95 123 126 128 144 144 144 146 169 171 177 198 201 202 214 216 223 224 220 225 225 225 222 222 219 219 219 219 219 232 232 233 241 241 241 249 252 252 260 260 260 260 263 263 263 266 267 267 267 272 272 278 278 279 279 279 293 298 302 302 307 307 307 316 316 320 321 323 323 323 323 325 325 325 326 327 327 328 329 329 329 330 330 330 335 335 336 340 340 340 340 341 342 347 347 350 350 350 352 352 353 356 356 357 357 360 365 365 365 365 365 365 365 369 369 373 373 373 373 374 378 381 392 395 395 395 399 451 409 425 437 447 456 467 526 533 542 545 563 568 587 592 632 637 663 677 695 707 735 746 755 772 805 815 853 868 890 893 902 910 918 926 931 936 940 941 942 942 947 957 991 991 999 999

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [time_series_covid19_recovered_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
);