home / thai-lottery

Prize

9 rows where round_id = 261

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: amount

Link rowid ▼ round_id prize_id amount keys
2022 2022 2017-11-01 261 FIRST_NEARBY 6 100000 533725 533727
2023 2023 2017-11-01 261 FIRST 1 6000000 533726
2024 2024 2017-11-01 261 SECOND 2 200000 207204 440879 497237 617980 951035
2025 2025 2017-11-01 261 THIRD 3 80000 195866 221435 271632 331751 356817 578206 643292 824536 852509 965400
2026 2026 2017-11-01 261 FOURTH 4 40000 001263 125838 216680 281155 428264 521350 570718 698919 773706 877149 009858 129205 227663 302041 450928 540510 575848 712207 775833 889479 070880 145388 240610 379756 469579 543337 607203 724415 788521 926624 104008 156493 247967 383075 473765 556546 622114 738140 834022 931437 124404 203055 268386 411755 501283 557169 696245 764510 873762 956856
2027 2027 2017-11-01 261 FIFTH 5 20000 006555 098597 210554 324029 424320 528172 615441 741700 857793 929052 007883 106578 229044 329876 429901 528280 617283 765199 867177 932719 017809 113286 230161 364734 456938 537719 618915 780694 873490 942028 019293 122017 235006 372221 463861 542591 640249 798210 878860 945762 038276 145821 252163 396723 467003 544322 647038 826783 892015 952213 044624 150996 260500 399108 485599 548390 670524 830187 899309 954310 047020 154176 266801 400566 489312 554191 695390 843336 901466 957227 051909 187116 269421 401648 512292 568991 698328 845846 911913 966534 070407 194007 279935 406118 522529 573434 713448 849567 924447 972987 095244 203781 298608 410462 525959 574226 730669 855583 928129 975753
2028 2028 2017-11-01 261 THREE_FRONT 8 4000 165 425
2029 2029 2017-11-01 261 TWO 9 2000 85
2030 2030 2017-11-01 261 THREE 7 4000 485 036

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