home / thai-lottery

Prize

8 rows where round_id = 97

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
892 892 2010-12-16 97 FIRST_NEARBY 6 50000 334379 334381
893 893 2010-12-16 97 FIRST 1 2000000 334380
894 894 2010-12-16 97 SECOND 2 100000 059875 093531 117487 119865 945771
895 895 2010-12-16 97 THIRD 3 40000 182974 251200 282322 287015 304293 373867 794342 777699 871979 926215
896 896 2010-12-16 97 FOURTH 4 20000 005188 020457 036333 044384 086219 087216 092549 113836 133130 144780 156013 172619 177571 186919 224530 256539 289399 291263 298755 330288 373759 377892 404499 454050 575880 600215 624575 648535 670891 672728 677491 702964 733308 749254 753897 790324 805492 805945 815477 816124 816768 860952 869771 870414 870850 897283 926530 954826 969224 978140
897 897 2010-12-16 97 FIFTH 5 10000 001254 015728 052930 059285 074340 077348 077782 112882 118017 127568 131656 138643 143853 158229 170352 172363 179357 194510 194607 198201 231115 231152 237263 240130 252595 260128 287816 291799 292604 293336 305874 324888 326325 328966 329232 357293 360589 373535 394356 395940 396058 399785 404280 413884 418637 426651 448473 451655 454061 467788 493753 495964 506493 515801 515972 520564 520604 526428 536280 549932 573396 577854 582613 583694 584123 592263 595292 615130 627182 628192 635411 639827 640577 649788 653421 663499 692564 710486 719345 719484 752172 756009 767976 783650 790876 800848 824905 842269 844133 848343 857513 859007 892285 870042 873513 898877 933897 961593 987808 988527
898 898 2010-12-16 97 TWO 9 1000 24
899 899 2010-12-16 97 THREE 7 2000 306 315 529 533

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