home / thai-lottery

Prize

8 rows where round_id = 154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
382 382 2013-05-16 154 FIRST_NEARBY 6 50000 687124 687126
383 383 2013-05-16 154 FIRST 1 2000000 687125
384 384 2013-05-16 154 SECOND 2 100000 207239 436870 645921 709419 848178
385 385 2013-05-16 154 THIRD 3 40000 034948 207577 227581 304629 381868 524992 632851 831951 856786 981416
386 386 2013-05-16 154 FOURTH 4 20000 036111 064601 067010 105914 139712 158151 169977 193572 202951 212299 246967 251239 270905 301856 303998 318044 350240 375464 401938 464651 467757 502016 517321 518245 545175 548285 561040 582054 608521 613134 645199 656207 711967 716994 756319 766286 771251 777918 795863 796473 835839 834379 836828 845414 859978 893395 942206 943703 975761 998355
387 387 2013-05-16 154 FIFTH 5 10000 013509 014676 023166 040022 058620 061374 068353 069515 073524 084948 095189 095290 101638 105075 144518 148085 154369 154877 172128 172411 177398 194613 198259 208711 211546 218358 227650 242023 242329 256192 270013 276886 284633 297423 309711 348510 369023 371620 409624 412921 439288 451865 453259 454882 479414 485071 489188 500514 513453 532858 554028 556615 569984 563958 599185 599317 608195 610970 620017 633025 636547 637404 658739 666214 684133 732545 744609 756005 782003 788819 798145 810662 814383 820267 823858 827604 851495 865920 870954 873049 876798 882178 884576 894999 900070 908860 928890 935319 952539 963589 966314 969145 981408 983453 991389 995082 997442 997511 998656 999192
388 388 2013-05-16 154 TWO 9 1000 56
389 389 2013-05-16 154 THREE 7 2000 034 261 390 945

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