home / thai-lottery

Prize

8 rows where round_id = 155

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
374 374 2013-06-01 155 FIRST_NEARBY 6 50000 935488 935490
375 375 2013-06-01 155 FIRST 1 2000000 935489
376 376 2013-06-01 155 SECOND 2 100000 640995 714698 772781 900456 994912
377 377 2013-06-01 155 THIRD 3 40000 220842 237128 348674 450358 556208 559807 602632 693667 882612 942895
378 378 2013-06-01 155 FOURTH 4 20000 056301 056504 066024 145336 183461 216156 264775 282680 294034 312810 314078 321704 334533 341015 341369 352991 363018 372617 375369 437121 446578 448155 452996 466898 467339 502944 529207 535851 545014 550491 561263 577956 584444 674712 687298 695834 711205 750025 756143 769096 773249 788784 807843 849835 859510 888857 898616 942830 944083 997504
379 379 2013-06-01 155 FIFTH 5 10000 017470 033391 033923 044982 049956 061194 091783 099305 102231 107444 119757 120471 123348 124410 131222 145464 147368 177437 181927 189746 193001 198887 204942 213784 215265 235744 235875 247071 248338 260170 282346 287411 300147 310156 312805 315327 320668 360393 372586 399104 404130 410266 412474 449505 503374 513462 517067 517111 519320 529759 540560 572994 579739 582554 597566 598368 613077 616780 633328 643834 644591 650665 660261 689186 691284 693807 708264 710510 718620 721012 722854 727082 748267 757479 772290 772995 773285 776965 782445 785817 800835 839624 841108 864303 884818 898790 917408 922522 926968 934170 936708 946199 951909 953021 954400 968321 972729 983691 984814 986763
380 380 2013-06-01 155 TWO 9 1000 90
381 381 2013-06-01 155 THREE 7 2000 480 713 716 768

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