home / thai-lottery

Prize

8 rows where round_id = 192

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
51 51 2014-12-16 192 FIRST_NEARBY 6 50000 948353 948355
52 52 2014-12-16 192 FIRST 1 2000000 948354
53 53 2014-12-16 192 SECOND 2 100000 215527 305155 390096 469497 769143
54 54 2014-12-16 192 THIRD 3 40000 061228 307098 390110 516904 684344 751542 823715 906533 918536 926158
55 55 2014-12-16 192 FOURTH 4 20000 030048 048326 079263 116405 130783 135931 153990 167508 167899 197040 203885 210762 277420 282377 302828 320371 323797 346059 346425 382732 400932 427948 437264 440509 466279 483311 528547 529268 559389 610262 617683 639871 640198 653787 687239 709073 720899 729258 737760 749725 757761 788957 809153 841184 902875 944086 952126 956282 960623 989204
56 56 2014-12-16 192 FIFTH 5 10000 019909 028921 039363 061327 064512 069888 104286 114289 115436 116561 118742 124182 127529 138347 151387 178606 184408 196370 246592 247319 256228 272540 297975 317823 329329 343326 361809 368081 369666 427409 442264 444504 448875 466985 471345 478160 481019 489427 499733 505454 506090 511724 519496 534040 534788 549340 552554 557231 581522 584756 585444 595225 597707 601672 602618 603440 608187 617168 623201 630997 639461 642165 649986 651878 665182 674847 679251 679288 691158 711920 726747 747946 755569 759253 779747 780354 782511 792091 793239 801488 806194 816658 819435 829066 851662 871658 875923 878509 879075 883125 906529 911161 930042 933295 951569 957359 960263 962130 972327 995955
57 57 2014-12-16 192 TWO 9 1000 90
58 58 2014-12-16 192 THREE 7 2000 080 763 775 901

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