home / thai-lottery

Prize

8 rows where round_id = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1374 1374 2009-09-01 66 FIRST_NEARBY 6 50000 015864 015866
1375 1375 2009-09-01 66 FIRST 1 2000000 015865
1376 1376 2009-09-01 66 SECOND 2 100000 028923 064025 128893 225850 370610
1377 1377 2009-09-01 66 THIRD 3 40000 134008 517511 663088 709724 782498 834217 835514 875325 891075 969347
1378 1378 2009-09-01 66 FOURTH 4 20000 003075 053956 072842 093066 131409 171436 173674 216923 228063 242093 273964 279151 282327 287814 301202 301896 321304 334686 343119 343636 352303 354690 356544 366977 390194 400666 400792 425602 430629 453979 501922 520736 524191 598753 604087 683445 693747 774144 807407 808154 865385 884524 894083 911489 912804 959614 976990 982614 988669 995584
1379 1379 2009-09-01 66 FIFTH 5 10000 011787 021700 033082 041097 094331 098163 120944 122704 142652 156780 172308 187196 201598 203812 204397 207219 218070 221990 222266 229563 244033 250489 278687 280609 281124 289289 303596 310166 310332 321710 327673 360760 366918 376497 377503 386322 396163 397820 398557 408825 416911 432279 433439 445459 472764 478555 486404 497393 509926 511233 525387 525614 525880 542090 543204 551796 557588 573952 594630 604553 612406 612626 616761 624709 631510 653874 670850 675674 684176 690207 706859 732399 737110 762724 767894 773839 775578 791180 791968 806092 812927 824784 825298 853375 864880 866233 894485 900123 901707 902197 906156 914978 916438 925686 935841 941352 943192 985557 989135 993974
1380 1380 2009-09-01 66 TWO 9 1000 32
1381 1381 2009-09-01 66 THREE 7 2000 435 446 447 924

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