home / thai-lottery

Prize

8 rows where round_id = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
67 67 2014-11-16 190 FIRST_NEARBY 6 50000 479803 479805
68 68 2014-11-16 190 FIRST 1 2000000 479804
69 69 2014-11-16 190 SECOND 2 100000 001831 134473 150252 367863 773636
70 70 2014-11-16 190 THIRD 3 40000 027762 055963 098738 201425 333790 503755 692585 723387 795812 963959
71 71 2014-11-16 190 FOURTH 4 20000 000014 011724 060974 069168 075159 086789 088732 096077 129393 130303 140615 153457 157702 166370 185672 189324 199203 216080 231383 271289 301588 305525 312910 340131 405692 413155 434294 479983 483754 494959 496653 504832 568112 575340 601403 656417 705520 751532 781404 803782 816616 826432 832410 850341 897541 904348 916131 933697 957569 983321
72 72 2014-11-16 190 FIFTH 5 10000 021196 024396 026284 034375 035517 044334 063793 078913 092760 147503 151356 170518 177896 185027 196672 221146 225741 229635 249878 255070 259476 261586 268474 285104 287093 288205 292107 312404 338739 363604 368830 371057 375923 376860 380618 391450 392742 404451 415695 424400 432899 437305 451700 455204 456964 461753 479241 491042 519429 543539 543922 544333 550357 564309 571236 575014 582207 586956 594641 595028 608290 611292 613299 619278 624345 627046 641922 643202 650605 657945 681418 691472 692903 694047 713395 724015 730459 738234 739514 751849 756906 806399 810527 810980 814725 819801 831124 850426 861860 911860 916990 931997 933145 937988 949036 964252 968314 968840 970546 985307
73 73 2014-11-16 190 TWO 9 1000 25
74 74 2014-11-16 190 THREE 7 2000 179 422 480 709

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