home / thai-lottery

Prize

8 rows where round_id = 95

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
908 908 2010-11-16 95 FIRST_NEARBY 6 50000 813992 813994
909 909 2010-11-16 95 FIRST 1 2000000 813993
910 910 2010-11-16 95 SECOND 2 100000 096835 104173 348227 579668 856098
911 911 2010-11-16 95 THIRD 3 40000 056146 197390 319062 400996 439855 505101 510286 606668 740361 795973
912 912 2010-11-16 95 FOURTH 4 20000 023988 052628 073150 076834 088728 091616 094740 101832 109907 145275 145758 158502 177167 178860 184248 191362 309407 382688 416737 418490 426295 454689 463922 465324 467603 479048 483756 510873 526204 529180 557641 558355 564490 573868 678522 714931 734964 743451 780123 786802 817219 822361 831847 839399 891787 909012 913450 945780 963841 992221
913 913 2010-11-16 95 FIFTH 5 10000 005967 022378 040525 042790 043605 074784 079446 079935 082385 132098 145474 160197 175967 184372 185737 186494 186585 188486 193824 198893 216739 223194 233820 236073 238942 247063 260868 265809 277143 292932 299559 301805 303829 316971 317060 318355 335541 346796 353553 360080 402083 403077 419990 420130 424057 425308 429658 432522 434476 440823 455344 476667 487586 497228 517490 535877 544234 551209 555839 557516 561240 565268 568562 598613 628370 634440 662293 669427 702585 704254 704881 722165 724815 727025 733854 734838 772688 776003 785378 793330 827921 832825 837283 856564 863327 863361 871026 900084 907466 912236 940760 944601 956832 967680 976300 980379 981106 985240 995172 999482
914 914 2010-11-16 95 TWO 9 1000 43
915 915 2010-11-16 95 THREE 7 2000 129 763 907 979

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