home / thai-lottery

Prize

8 rows where round_id = 120

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
690 690 2011-12-16 120 FIRST_NEARBY 6 50000 884177 884179
691 691 2011-12-16 120 FIRST 1 2000000 884178
692 692 2011-12-16 120 SECOND 2 100000 021880 269585 306099 862685 967456
693 693 2011-12-16 120 THIRD 3 40000 045158 063305 270878 299247 348442 613174 643365 685815 887363 887534
694 694 2011-12-16 120 FOURTH 4 20000 089209 124147 130975 143026 159688 175029 249861 291387 292639 293569 299535 331624 332761 342076 366692 372339 373946 412939 428857 443328 505334 549057 549973 567995 593507 594579 597951 599897 631843 647008 648581 653795 667651 672416 713878 718812 785819 865354 877886 894103 896946 898114 937033 947525 963282 963949 976241 980500 982227 992018
695 695 2011-12-16 120 FIFTH 5 10000 018525 123833 231245 335899 462180 548890 641979 724357 849893 947966 028391 124067 239592 359386 465606 551740 644958 724726 866427 955563 030531 151696 243838 368016 469140 553554 646772 727879 869165 956832 037686 156570 256935 370445 473098 555830 652734 756039 871356 956910 045902 158562 264339 381003 473654 576200 661665 767232 880196 957019 057350 161318 273173 392296 476890 594770 669046 769753 889428 959778 080229 177878 275194 403362 490364 600909 672898 791095 904128 962568 081994 182640 287370 418040 517267 605757 677300 801847 909768 963931 091891 183610 327639 422486 520735 623590 681564 812731 921365 979904 111019 226255 328503 427398 540516 640088 693575 816250 926522 983717
696 696 2011-12-16 120 TWO 9 1000 21
697 697 2011-12-16 120 THREE 7 2000 784 235 295 651

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