home / thai-lottery

Prize

8 rows where round_id = 107

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
803 803 2011-06-01 107 FIRST_NEARBY 6 50000 562369 562371
804 804 2011-06-01 107 FIRST 1 2000000 562370
805 805 2011-06-01 107 SECOND 2 100000 099772 161001 195474 971173 984513
806 806 2011-06-01 107 THIRD 3 40000 021916 083917 165077 280709 533764 570994 586177 753523 866945 950811
807 807 2011-06-01 107 FOURTH 4 20000 005027 148937 165877 269439 462112 535058 619968 698559 752774 897396 008778 150319 183706 326918 479027 544118 626063 708578 759918 906597 032164 163895 191490 363451 488078 551208 638369 719995 804705 918485 048290 164234 196892 392090 504779 562040 658044 735502 853116 935713 121058 164820 217351 428888 523457 572625 698145 750317 856516 999117
808 808 2011-06-01 107 FIFTH 5 10000 002941 007301 017997 035429 048883 050003 053101 055800 061806 093131 097682 110555 112690 115336 118797 146760 151198 171415 185342 187606 204974 207958 209247 218935 266780 271184 272099 287265 296457 311067 319263 326647 332040 338659 349098 358676 379173 381619 395999 409057 411008 437537 448046 463081 482455 486291 521355 532336 550504 561032 574563 578961 584995 596029 597486 597511 607168 610747 612892 620989 633338 634583 648782 654972 660900 683401 684605 691696 692984 696622 731853 738533 738610 743471 745371 750185 763241 772778 775151 778063 785644 787531 793317 801950 826814 840891 856434 887309 891746 916421 924630 926462 937713 938417 946165 955296 974022 978227 998755 999959
809 809 2011-06-01 107 TWO 9 1000 46
810 810 2011-06-01 107 THREE 7 2000 346 556 656 801

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE Prize(
    round_id integer not null,
    prize_id integer not null,
    amount integer not null,
    keys text not null,
    foreign key (round_id) references Round(id),
    foreign key (prize_id) references PrizeType(id)
);
Powered by Datasette · Queries took 20.578ms