home / thai-lottery

Prize

8 rows where round_id = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1536 1536 2008-11-16 48 FIRST_NEARBY 6 50000 002611 002613
1537 1537 2008-11-16 48 FIRST 1 2000000 002612
1538 1538 2008-11-16 48 SECOND 2 100000 068339 076845 453662 598255 772978
1539 1539 2008-11-16 48 THIRD 3 40000 114327 171975 240543 468332 581440 643909 806820 837995 887312 935695
1540 1540 2008-11-16 48 FOURTH 4 20000 018837 054913 059019 063200 142376 155453 162770 168385 192240 258959 275394 291511 324313 340964 343218 355753 398488 450193 451070 465152 476738 481034 487847 498709 502169 506641 508152 511850 519606 543145 559043 569312 579856 586473 643385 699751 720905 752269 791761 796815 797306 817160 845415 914244 928221 963599
1541 1541 2008-11-16 48 FIFTH 5 10000 001621 005189 028848 028888 032480 038752 040549 044833 060009 060977 065540 075220 077963 078935 080839 085154 086788 089991 118095 120065 131466 137086 148725 153343 174224 174242 185725 207461 212551 216783 223523 229756 241444 247281 247995 269242 277222 280881 306182 317922 340771 357080 371463 387715 394687 428259 430868 432122 433682 437703 443440 476510 492319 515964 516070 532267 536857 543024 565240 570693 601864 602795 604083 612137 624077 633505 655522 674535 676997 679911 688929 692623 699477 738796 749526 750674 768790 776129 777338 789765 799249 806363 814624 849634 850250 866962 878391 891654 909049 909661 912399 926670 942386 953212 958010 965556 967170 972247 973852 988424
1542 1542 2008-11-16 48 TWO 9 1000 20
1543 1543 2008-11-16 48 THREE 7 2000 068 589 824 877

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 34.238ms