home / thai-lottery

Prize

8 rows where round_id = 179

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
164 164 2014-06-01 179 FIRST_NEARBY 6 50000 781197 781199
165 165 2014-06-01 179 FIRST 1 2000000 781198
166 166 2014-06-01 179 SECOND 2 100000 405023 493803 599778 830587 871445
167 167 2014-06-01 179 THIRD 3 40000 078043 107060 199807 289139 380561 396122 579372 665012 677580 954099
168 168 2014-06-01 179 FOURTH 4 20000 003883 041200 087983 122796 137892 159305 201135 234490 237206 238775 317698 324726 332740 361739 364462 374551 371024 402649 413723 450122 451517 465502 467720 469055 481147 487486 487880 518792 524725 542511 560703 575237 580667 618366 627809 632678 642432 649841 683086 737847 768018 786291 796651 838720 856954 885518 913521 928944 951485 966991
169 169 2014-06-01 179 FIFTH 5 10000 008828 015718 019812 038442 045866 065846 066482 066854 068330 088886 091686 104372 108903 118616 123671 128520 135218 174736 188705 195207 205276 221388 228764 225025 228983 252185 255004 259277 267746 286514 294372 302246 308021 308221 312616 314235 344827 346936 367115 400525 409815 415197 432295 447389 449390 459181 467654 471345 488917 494602 496194 511966 521461 533768 537343 546386 550816 546151 551821 571951 574440 587407 588265 630825 632007 634204 637607 650026 669146 672133 674210 679265 701744 718578 730622 730215 738451 747522 761255 786083 804765 817717 820056 820935 826235 829645 860230 861285 863854 864125 877078 878427 880125 893758 896652 904390 924091 929422 946764 975694
170 170 2014-06-01 179 TWO 9 1000 18
171 171 2014-06-01 179 THREE 7 2000 160 324 409 636

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