home / thai-lottery

Prize

8 rows where round_id = 126

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
633 633 2012-03-16 126 FIRST_NEARBY 6 50000 607063 607065
634 634 2012-03-16 126 FIRST 1 2000000 607064
635 635 2012-03-16 126 SECOND 2 100000 226110 297879 575154 702982 959731
636 636 2012-03-16 126 THIRD 3 40000 907392 224291 255702 055354 513937 665364 776538 359645 498473 576033
637 637 2012-03-16 126 FOURTH 4 20000 430707 146641 874549 042119 869482 374301 048458 258559 222972 370300 692389 752723 889303 323328 495773 417241 131083 951943 613658 102498 283039 131537 736188 552058 319547 289090 491854 770849 614539 533772 367018 905621 964303 561808 285328 312531 241374 650175 651677 300204 094973 743669 024941 179416 560320 127323 155093 224220 822962 127217
638 638 2012-03-16 126 FIFTH 5 10000 001423 006197 007729 009180 045540 048589 061298 062705 085184 113168 115701 118967 128980 136373 136565 139906 159340 162442 164269 185375 198122 205258 212945 215140 229077 244078 251870 252169 257173 276303 288412 293846 302223 305304 306320 325522 331157 357167 367254 367506 374397 382377 389122 389413 404803 417491 417747 435940 458481 459119 465287 468730 471357 482457 499425 521177 523788 524408 534879 550609 567803 569003 578538 588589 590290 627455 647362 662308 664487 681024 685176 694816 707282 710291 711463 717041 731788 733830 752315 769677 791930 805163 806357 819192 820880 857964 879956 880819 897187 897486 901068 903050 949387 959865 961432 975105 977703 990531 998206 999495
639 639 2012-03-16 126 TWO 9 1000 08
640 640 2012-03-16 126 THREE 7 2000 333 350 573 606

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