Prize

8 rows where round_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
666 666 2012-02-01 123 FIRST_NEARBY 6 50000 320604 320606
667 667 2012-02-01 123 FIRST 1 2000000 320605
668 668 2012-02-01 123 SECOND 2 100000 382917 656079 693587 732718 930227
669 669 2012-02-01 123 THIRD 3 40000 041168 079976 101374 254426 374888 438887 678543 737431 744222 944934
670 670 2012-02-01 123 FOURTH 4 20000 010492 065028 068794 072531 087463 090698 104990 123054 127630 135860 146517 250259 272166 273439 275328 285550 387009 418511 418696 483143 494683 519465 531960 540273 544874 553219 556167 585079 593790 599333 625068 659084 663215 674517 677723 706910 708081 745772 749230 758466 762290 804515 808206 815058 830689 835417 857482 872024 887665 996554
671 671 2012-02-01 123 FIFTH 5 10000 000273 001583 004078 019867 025896 075747 075883 077706 092100 092771 108870 114985 116366 120263 135388 140178 144301 156249 172876 176363 188988 201893 216101 250924 257667 258100 284652 288938 297742 313449 336184 342182 351600 352809 359508 361946 375458 386795 392065 393574 399640 420713 429281 433868 444836 446513 450889 468458 498906 521518 527196 551619 563080 563669 567547 571541 579065 592633 603707 611516 618737 627619 636795 639771 681630 682764 683983 719191 725810 731196 735385 742605 756432 771768 774822 780848 785674 789264 806354 824661 825029 829738 835137 845581 855771 884061 894766 900293 906204 916917 922478 924532 936650 937294 938601 941294 944116 965399 986704 994983
672 672 2012-02-01 123 TWO 9 1000 32
673 673 2012-02-01 123 THREE 7 2000 426 498 598 749

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)
);