home / thai-lottery

Prize

8 rows where round_id = 193

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
43 43 2014-12-30 193 FIRST_NEARBY 6 50000 461703 461705
44 44 2014-12-30 193 FIRST 1 2000000 461704
45 45 2014-12-30 193 SECOND 2 100000 646240 232840 464050 173698 682065
46 46 2014-12-30 193 THIRD 3 40000 010503 789881 565372 326244 798504 192551 358615 400532 601796 795974
47 47 2014-12-30 193 FOURTH 4 20000 032473 046253 093200 137045 175765 178722 184525 196837 201259 257541 262561 268712 321492 324361 333257 386046 394776 399177 421036 428145 439727 526313 578991 583133 589780 611373 644245 665678 735551 757518 760367 771786 780871 795850 805202 827064 839966 854339 856343 896413 900257 908465 916202 936280 938587 957923 958465 972836 976555 979527
48 48 2014-12-30 193 FIFTH 5 10000 004245 017944 035286 041044 041826 050732 054382 067240 068584 071163 073224 078452 086722 096788 110062 116117 117371 125060 141805 146552 149212 150710 155596 158475 166952 169505 169955 169986 186424 210564 213260 221047 226057 233206 274909 278391 285822 287963 290725 298709 301930 306955 323965 334297 335666 344781 346360 354710 360608 364594 371470 377822 383983 393673 395119 406697 418916 431301 472359 477584 499132 507069 514431 517976 521156 541465 563476 568431 581558 604455 608451 614347 653294 659251 666135 692781 702628 713283 725821 739196 761594 781754 830735 840983 849141 872963 879372 893407 899747 901867 910658 911343 911426 915075 917378 925173 946913 956878 960177 994746
49 49 2014-12-30 193 TWO 9 1000 57
50 50 2014-12-30 193 THREE 7 2000 853 982 535 950

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