home / thai-lottery

Prize

8 rows where round_id = 144

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
471 471 2012-12-16 144 FIRST_NEARBY 6 50000 529523 529525
472 472 2012-12-16 144 FIRST 1 2000000 529524
473 473 2012-12-16 144 SECOND 2 100000 016169 299611 388078 524517 751749
474 474 2012-12-16 144 THIRD 3 40000 361578 464041 571881 691885 868594 871878 896699 896976 931834 981517
475 475 2012-12-16 144 FOURTH 4 20000 021288 080263 087061 122016 147193 150489 165705 170969 188258 207114 207531 249734 277554 386287 398098 419851 461908 464644 468821 491037 515128 541766 581070 593381 618665 626564 634034 665228 670382 684954 698851 715318 718116 730293 734287 736865 739003 795831 811537 839343 888948 898081 910416 912407 955987 957202 959171 969863 974503 982227
476 476 2012-12-16 144 FIFTH 5 10000 003253 024246 038906 049189 062106 065037 069170 086126 087526 121005 124049 126909 127588 133565 137429 138050 158146 158848 161643 165423 167159 167936 170925 176435 190229 205996 209100 221043 224816 225762 226722 249215 249542 252046 255741 260214 265460 278587 286705 301631 335051 341642 372839 378206 385116 392771 405736 411807 414310 414427 421012 427895 431062 443127 462969 482126 485742 501966 523135 538228 559294 571223 589370 612018 619164 637985 639655 653244 657291 659377 671929 707804 710420 714869 739220 756402 776045 782388 804931 814467 830564 832541 838630 840051 865183 871353 896961 902951 904389 927330 930668 938482 962805 962989 963149 963922 965962 968199 993182 996884
477 477 2012-12-16 144 TWO 9 1000 72
478 478 2012-12-16 144 THREE 7 2000 734 745 778 008

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