home / thai-lottery

Prize

8 rows where round_id = 91

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
958 958 2010-09-16 91 FIRST_NEARBY 6 50000 017421 017423
959 959 2010-09-16 91 FIRST 1 2000000 017422
960 960 2010-09-16 91 SECOND 2 100000 335355 522445 671244 701372 846774
961 961 2010-09-16 91 THIRD 3 40000 016289 243891 283523 489012 588018 634202 653889 675685 724912 813645
962 962 2010-09-16 91 FOURTH 4 20000 032658 053201 069748 081024 082230 119120 132896 184872 195950 204945 213799 228747 259034 263045 302467 313316 316526 339271 345466 363440 380517 385965 389396 458325 466896 479861 512166 514332 550200 627319 632031 672432 674037 683791 693405 703633 706479 710422 734640 738824 762125 782838 794139 853471 875399 887174 892952 908466 929778 968953
963 963 2010-09-16 91 FIFTH 5 10000 013918 031692 071325 079703 093366 098938 110715 124743 182967 234046 259707 351403 367080 419061 442647 465741 473136 505120 558617 563586 597299 599195 614166 619344 626749 656089 661673 677832 681230 695676 698930 734372 735604 780080 783856 790767 797285 800505 809168 830930 837066 841960 849173 897468 909559 921787 926017 941230 951324 982162
964 964 2010-09-16 91 TWO 9 1000 66
965 965 2010-09-16 91 THREE 7 2000 103 316 431 075

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.519ms