home / thai-lottery

Prize

9 rows where round_id = 269

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: amount

Link rowid ▼ round_id prize_id amount keys
1299 1299 2018-03-02 269 FIRST_NEARBY 6 100000 759414 759416
1300 1300 2018-03-02 269 FIRST 1 6000000 759415
1301 1301 2018-03-02 269 SECOND 2 200000 349580 512224 741654 847817 968589
1302 1302 2018-03-02 269 THIRD 3 80000 051847 193810 315630 321385 425611 460143 581582 601005 863360 930214
1303 1303 2018-03-02 269 FOURTH 4 40000 015727 102417 185029 296806 371568 478639 621758 779849 839204 933947 026981 103979 210847 303960 390835 498313 693441 784313 851159 954660 045867 126074 240111 327692 398479 503459 698784 785915 864696 983573 070712 152334 273514 352995 430068 544791 716490 801754 894536 990151 076002 169125 287832 361494 443322 554295 750865 835924 910272 994306
1304 1304 2018-03-02 269 FIFTH 5 20000 004981 077812 200418 316252 428060 512784 633033 746954 832527 910988 014457 085405 209754 328938 434244 526177 638841 752628 835575 918245 024682 094672 220381 330559 434842 529317 645336 790901 838127 937239 033463 097708 228411 342789 467021 569966 649458 798339 842461 945681 038047 143457 238839 346820 472058 580596 663095 806804 860866 967730 055924 149945 269176 352349 480166 586403 672259 807790 891309 968658 061679 159934 295378 375417 489883 612687 708698 809022 897474 970069 062141 160420 297330 395440 492351 625162 710373 809742 898484 976427 068241 176100 300371 398210 497518 625434 746684 812475 900803 985027 075465 194019 303591 413416 501558 628783 746951 824971 903575 991249
1305 1305 2018-03-02 269 THREE_FRONT 8 4000 318 870
1306 1306 2018-03-02 269 TWO 9 2000 29
1307 1307 2018-03-02 269 THREE 7 4000 589 723

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