home / thai-lottery

Prize

8 rows where round_id = 188

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
83 83 2014-10-16 188 FIRST_NEARBY 6 50000 656408 656410
84 84 2014-10-16 188 FIRST 1 2000000 656409
85 85 2014-10-16 188 SECOND 2 100000 070861 181752 390493 691404 724660
86 86 2014-10-16 188 THIRD 3 40000 125537 349018 393451 415350 503961 537883 736403 752585 903889 987543
87 87 2014-10-16 188 FOURTH 4 20000 074043 051106 084715 115404 130303 177206 184200 210055 239185 283718 319341 390398 398195 413728 415565 437862 461738 480454 491439 503058 507891 511663 525740 533518 533861 547043 585146 618344 634169 644759 680218 713660 718179 757632 771136 777592 777971 779057 788465 849995 862507 888371 895245 901329 930233 943072 952468 957452 978171 983354
88 88 2014-10-16 188 FIFTH 5 10000 013541 054955 058308 062954 067617 080772 083295 109456 114185 132542 135664 148924 150344 163090 176132 178546 194319 199101 208484 212814 215709 229503 247058 258818 262902 268492 276925 287684 298554 307739 313556 316816 317333 324986 337167 339913 367648 370067 375872 378471 390666 398785 428460 451779 458064 459924 485122 491708 497305 510058 514564 515928 538902 546733 549918 568263 570871 610347 613128 616404 616625 617992 636422 640494 644024 652926 658981 692221 695250 714786 733487 741200 756938 757444 760272 772560 775307 785807 795452 816009 825371 828316 848339 854192 853159 858397 873748 878321 885415 892241 897304 916966 922053 934405 948713 949661 953196 960120 975909 996864
89 89 2014-10-16 188 TWO 9 1000 94
90 90 2014-10-16 188 THREE 7 2000 647 784 848 910

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 21.501ms