home / thai-lottery

Prize

8 rows where round_id = 184

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
115 115 2014-08-16 184 FIRST_NEARBY 6 50000 662841 662843
116 116 2014-08-16 184 FIRST 1 2000000 662842
117 117 2014-08-16 184 SECOND 2 100000 222402 317839 879563 918905 678678
118 118 2014-08-16 184 THIRD 3 40000 685076 784839 701763 126666 537167 056323 282197 567280 050275 123839
119 119 2014-08-16 184 FOURTH 4 20000 898007 538030 135908 484577 932484 599906 527122 357274 520911 151095 393046 561542 744461 956328 375024 836224 747592 949268 462261 800125 256840 572079 410699 521456 011033 732003 956780 670074 811527 859546 907436 970286 242520 041617 926248 158159 682462 445433 016559 287892 034164 803811 159209 889636 530052 164700 494410 083503 973565 796472
120 120 2014-08-16 184 FIFTH 5 10000 863117 414505 643340 151804 788387 813367 199186 911172 192677 289776 725489 971198 138136 416562 500666 099398 494537 205198 399652 451141 145750 004452 882727 544758 370098 830625 910168 666593 581841 906605 876866 784364 343249 924834 919107 790118 675399 485354 417280 600820 953602 489178 700459 269662 638907 086916 884835 673057 397228 051708 161607 567684 759086 798778 650538 959153 430476 531097 042960 121382 511149 103396 481576 105868 250684 129763 606228 848477 842798 477382 955130 616877 076851 538527 686414 443875 909207 660904 891561 282183 435102 530794 998182 621454 227778 824969 148788 498152 685311 819441 854098 056703 254893 194909 995198 919447 926863 331670 361323 098831
121 121 2014-08-16 184 TWO 9 1000 91
122 122 2014-08-16 184 THREE 7 2000 639 912 187 633

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