home / thai-lottery

Prize

8 rows where round_id = 69

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1350 1350 2009-10-16 69 FIRST_NEARBY 6 50000 258486 258488
1351 1351 2009-10-16 69 FIRST 1 2000000 258487
1352 1352 2009-10-16 69 SECOND 2 100000 139865 509876 563571 728759 910125
1353 1353 2009-10-16 69 THIRD 3 40000 037817 058368 311748 319226 444248 513427 524608 595216 814185 862198
1354 1354 2009-10-16 69 FOURTH 4 20000 005399 053096 055415 058928 060941 086486 095925 111691 123836 147139 148435 160073 168267 170085 176041 190929 246857 251915 278030 280673 292089 300672 330250 405227 433169 439762 449286 460799 463165 473275 483607 490081 522040 531496 538822 556613 579655 597629 663212 664397 693592 734257 746380 777745 806714 809859 852476 879838 905304 942726
1355 1355 2009-10-16 69 FIFTH 5 10000 004900 018601 043673 044764 048794 061117 074902 081537 114540 120649 122331 125200 128737 129959 139979 151647 158129 194386 197959 206258 216608 228732 236189 241378 251457 254272 270866 288581 324167 338320 339864 349543 349891 365614 366145 397486 407540 460777 473845 478078 492018 509649 513416 518192 518511 520333 531008 532228 534833 561938 580804 594730 616694 620776 625078 632639 642814 660331 660340 661712 673913 676924 706396 713395 724731 725852 735872 737913 742342 752138 761835 765881 768819 772149 786851 789100 792623 802650 806330 817788 819894 826532 836355 839635 840989 841524 845915 853926 860201 861915 865870 866364 877174 901767 905711 924629 926810 954738 965914 998267
1356 1356 2009-10-16 69 TWO 9 1000 00
1357 1357 2009-10-16 69 THREE 7 2000 122 135 174 226

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