home / thai-lottery

Prize

8 rows where round_id = 145

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
463 463 2012-12-30 145 FIRST_NEARBY 6 50000 302357 302359
464 464 2012-12-30 145 FIRST 1 2000000 302358
465 465 2012-12-30 145 SECOND 2 100000 233041 446296 990081 196146 638488
466 466 2012-12-30 145 THIRD 3 40000 082129 122365 586314 064514 239400 718802 646482 296963 384862 744548
467 467 2012-12-30 145 FOURTH 4 20000 131673 239321 955576 899490 033311 127885 864613 886413 671846 560844 538195 185296 947039 668707 646864 014629 235904 620925 576930 740264 173619 335524 543227 927602 690800 098445 168331 072527 341249 055254 527730 728073 381321 052877 996646 444648 508449 480136 753108 370429 188301 236107 673485 449187 124005 011889 107465 998437 346210 742636
468 468 2012-12-30 145 FIFTH 5 10000 441623 543240 394962 701000 474679 417351 545703 213699 180476 383795 212763 284076 366300 032215 419573 550501 229936 822822 395553 667388 954955 331236 535373 572692 995560 444981 099514 710880 484119 814462 502084 018394 843586 330925 679417 172515 371533 640088 454955 018634 534980 892133 616124 000741 752432 381132 682376 015476 543519 733871 485688 997740 713131 395261 753557 389524 603024 484034 544762 705928 646438 004447 984031 284109 409895 537896 287536 325522 823371 384606 971298 392425 473341 864410 929970 671784 141827 559558 864588 528170 771645 349669 233333 190162 923347 235700 464541 695973 600807 928680 055585 664601 069749 588886 489429 738633 170853 291849 604030 580125
469 469 2012-12-30 145 TWO 9 1000 00
470 470 2012-12-30 145 THREE 7 2000 589 864 126 832

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