home / thai-lottery

Prize

8 rows where round_id = 113

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
755 755 2011-09-01 113 FIRST_NEARBY 6 50000 724532 724534
756 756 2011-09-01 113 FIRST 1 2000000 724533
757 757 2011-09-01 113 SECOND 2 100000 200700 571134 694542 931425 940708
758 758 2011-09-01 113 THIRD 3 40000 202396 543476 387546 766592 038084 856995 931787 435090 377570 106650
759 759 2011-09-01 113 FOURTH 4 20000 019724 022953 073503 078546 096238 167841 173766 207442 246368 249575 275562 277129 281277 292727 301061 313501 322856 329502 335494 354870 356260 392577 396201 415621 470435 470477 504118 561427 603898 624997 626131 635567 648711 748689 755934 820424 838287 842192 842351 855387 869786 876452 879589 879932 885364 895615 951721 957153 960866 961593
760 760 2011-09-01 113 FIFTH 5 10000 012063 018243 040522 058000 070098 071224 071324 083856 106949 109343 124607 133076 162013 168956 181622 192276 198041 201845 204130 206219 218245 221679 228241 231448 239045 244234 267455 275472 282324 286882 292316 295015 319274 319614 333038 348785 359957 392228 406012 437295 451035 456799 462059 468806 481478 490813 492984 494802 510724 521876 536461 552220 558209 574965 577141 577160 580366 592388 598095 599514 607926 630174 694424 695210 701688 701757 706997 712251 718873 721599 725221 731030 738890 755421 758151 768142 772211 776145 776699 777354 803641 820689 829391 834365 850740 867670 878598 907668 919049 943189 948413 955201 960017 964609 979096 979778 983654 990256 993618 998325
761 761 2011-09-01 113 TWO 9 1000 85
762 762 2011-09-01 113 THREE 7 2000 847 021 533 821

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