home / thai-lottery

Prize

8 rows where round_id = 118

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
706 706 2011-11-16 118 FIRST_NEARBY 6 50000 997776 997778
707 707 2011-11-16 118 FIRST 1 2000000 997777
708 708 2011-11-16 118 SECOND 2 100000 027748 752950 845496 285304 518836
709 709 2011-11-16 118 THIRD 3 40000 061084 144033 162750 182065 215770 307707 377865 666153 726631 746712
710 710 2011-11-16 118 FOURTH 4 20000 015962 045192 065499 104358 106664 138469 142839 148522 172284 208954 221052 242578 301409 303541 319587 320436 324522 379408 422103 463699 466216 475386 548085 572521 575738 589578 592873 606737 638427 648935 658073 661363 668784 672335 679486 716572 720200 726129 774531 819357 837021 874792 893198 908490 915053 928165 939497 977820 979409 981715
711 711 2011-11-16 118 FIFTH 5 10000 001689 102644 231660 334692 430182 532602 599557 665464 788970 893777 002166 112788 249575 350123 440805 540641 607421 668720 813550 895537 002645 114367 252631 368056 452978 541445 611172 676608 814858 910257 009319 129904 254625 373174 458779 550317 611881 711650 819322 915585 034480 146543 260908 391066 459045 565399 619085 714405 833004 921271 064897 155625 261848 393320 485335 570171 624266 766798 847532 939755 066585 174292 267853 402828 485852 583560 645332 767111 865060 954081 069257 201492 305217 407671 500177 584922 646044 779527 866930 964958 078644 204001 320611 407844 526374 589739 649923 780325 867541 974694 096171 209599 323712 425991 532341 597386 658308 783801 868466 983484
712 712 2011-11-16 118 TWO 9 1000 57
713 713 2011-11-16 118 THREE 7 2000 425 551 406 993

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