home / thai-lottery

Prize

8 rows where round_id = 146

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
455 455 2013-01-16 146 FIRST_NEARBY 6 50000 820980 820982
456 456 2013-01-16 146 FIRST 1 2000000 820981
457 457 2013-01-16 146 SECOND 2 100000 780790 034234 559027 028515 244271
458 458 2013-01-16 146 THIRD 3 40000 633762 813503 412820 064377 031701 195700 302847 595414 723570 905744
459 459 2013-01-16 146 FOURTH 4 20000 010727 044193 115560 173743 274151 386201 496192 671077 776897 872719 023736 060578 122197 183424 285974 395806 552401 704759 822554 885911 025850 082506 133395 199093 316791 420000 565253 746950 830193 924009 031249 088669 146506 210265 318777 424761 624541 770124 856642 979056 042164 109570 151668 229095 352848 434544 652778 770703 867274 998107
460 460 2013-01-16 146 FIFTH 5 10000 015973 151021 267142 351280 474097 550131 646852 717899 814348 900612 018491 174191 267809 358042 474999 554880 646999 725526 825043 903036 030924 178632 270906 362896 479209 584290 652023 737593 841235 930498 092569 188021 291878 371684 482084 586267 654720 748596 859207 940409 092603 188099 297250 373876 502749 589855 671129 750548 859609 957014 096990 203456 300958 381943 506432 633230 672200 758854 863359 969624 107252 207049 306550 404900 512442 633760 692302 789258 866742 977927 125598 207694 324814 436772 517666 635723 705348 793066 883232 978343 134676 248418 341568 443070 530448 638459 714051 800523 890371 983829 139854 263250 347028 469266 536162 646368 715140 810308 898102 993792
461 461 2013-01-16 146 TWO 9 1000 08
462 462 2013-01-16 146 THREE 7 2000 555 196 374 334

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