home / thai-lottery

Prize

8 rows where round_id = 139

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
520 520 2012-10-01 139 FIRST_NEARBY 6 50000 124026 124024
521 521 2012-10-01 139 FIRST 1 2000000 124025
522 522 2012-10-01 139 SECOND 2 100000 057371 058926 078851 212223 823483
523 523 2012-10-01 139 THIRD 3 40000 090462 159272 210894 231341 387364 418812 541163 597502 667293 931770
524 524 2012-10-01 139 FOURTH 4 20000 007046 109037 161651 249614 352576 415346 448853 629487 712028 857121 015683 109285 167559 251862 372405 423173 548089 672291 747243 883196 049906 122025 175911 284345 394786 431991 580964 680196 749766 891167 078523 129024 192930 332697 401630 437177 600724 693713 782149 911796 089671 158376 220643 335313 409157 441286 603808 708832 818048 921867
525 525 2012-10-01 139 FIFTH 5 10000 011675 088594 188607 287752 359429 474418 558162 690895 801958 936531 015400 098462 205971 290352 377274 485369 559776 705060 806773 944011 020019 121585 217354 305210 386744 504643 574787 707336 811216 950839 023668 132099 220302 305965 391744 507289 590827 709964 811826 959145 033653 151636 234193 326913 407247 514589 602331 718394 877900 960162 045003 155707 243074 341411 407623 520817 624600 718552 882013 965664 048839 161772 247433 344261 415819 521527 626423 740608 892607 978905 060332 169926 255648 346353 438541 526418 632184 786973 900675 986148 064754 175733 257754 353233 468182 532020 655289 795566 916775 991424 076702 180975 273097 356934 471410 557843 676345 795744 928683 994109
526 526 2012-10-01 139 TWO 9 1000 58
527 527 2012-10-01 139 THREE 7 2000 940 554 291 873

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