home / thai-lottery

Prize

8 rows where round_id = 64

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1399 1399 2009-07-16 64 FIRST_NEARBY 6 50000 000815 000817
1400 1400 2009-07-16 64 FIRST 1 2000000 000816
1401 1401 2009-07-16 64 SECOND 2 100000 169964 292125 373983 533197 944511
1402 1402 2009-07-16 64 THIRD 3 40000 082354 261753 510745 692173 792039 805155 866501 930331 943298 981253
1403 1403 2009-07-16 64 FOURTH 4 20000 008837 036184 037821 085420 165019 165512 187110 191200 194142 195492 222653 234097 241565 252275 276987 291522 315259 318365 324019 332537 392298 472199 474072 474425 477518 488339 490220 492112 511487 568958 600917 601409 635607 641501 659611 724932 727376 738005 760339 784534 830421 840504 848138 903730 921590 921885 923059 939234 958699 958853
1404 1404 2009-07-16 64 FIFTH 5 10000 019215 022920 032261 034041 041287 047118 048143 053587 059853 069210 076200 078965 112020 144504 147083 152307 157581 169677 175370 185747 189553 192651 195236 198946 221823 231231 232322 233416 233560 246958 256442 256943 293606 313211 317394 323706 342122 347370 357344 358960 373690 377513 378689 385851 392585 407348 407740 413562 423682 450080 463197 482119 490242 503831 522240 529840 542009 543772 552719 576454 577208 585903 594642 601570 611063 634154 663586 672894 690114 701065 702521 713720 718348 733758 734294 741341 753513 762350 786351 800489 808758 823016 828714 851468 867304 872702 887049 891687 899181 901982 917953 920012 927305 931119 957058 962535 968804
1405 1405 2009-07-16 64 TWO 9 1000 94
1406 1406 2009-07-16 64 THREE 7 2000 005 177 356 836

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