home / thai-lottery

Prize

8 rows where round_id = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
439 439 2013-02-16 148 FIRST_NEARBY 6 50000 368256 368258
440 440 2013-02-16 148 FIRST 1 2000000 368257
441 441 2013-02-16 148 SECOND 2 100000 176979 852539 919881 629690 721136
442 442 2013-02-16 148 THIRD 3 40000 642844 642097 559243 469887 740164 625827 410442 223366 496886 728701
443 443 2013-02-16 148 FOURTH 4 20000 309728 443434 450792 126678 549944 803403 125615 802049 279483 184091 851335 946183 561943 785733 248961 788128 067068 855337 653557 602121 750352 632444 689279 179393 987904 087204 016126 113248 737356 816468 639644 499178 285393 729881 640545 739411 837810 292512 348377 313054 160932 241227 739710 879673 983513 719157 668845 501654 830387 278770
444 444 2013-02-16 148 FIFTH 5 10000 002696 003182 009587 015076 023795 025254 042182 057930 071878 081986 086533 087362 092677 115904 117797 125966 128432 139212 153812 158642 186327 196574 221301 224650 234491 245791 275303 281151 283924 287124 301683 321329 328169 361435 362402 362757 381846 386687 390586 397124 402973 404843 432593 437360 440152 441594 444174 451817 485262 487897 495457 495885 503797 507586 512579 515967 516056 517143 526862 531475 552228 560735 583385 589626 592916 603174 637128 638870 649719 655213 678915 697327 710690 724291 725845 732803 747893 753850 764638 766784 773053 777815 785584 810255 812141 822034 828756 830415 851933 879108 887058 897296 911894 919521 931539 967804 972351 981250 993011 996814
445 445 2013-02-16 148 TWO 9 1000 09
446 446 2013-02-16 148 THREE 7 2000 657 708 109 386

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