Prize

8 rows where round_id = 127

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
625 625 2012-04-01 127 FIRST_NEARBY 6 50000 257561 257563
626 626 2012-04-01 127 FIRST 1 2000000 257562
627 627 2012-04-01 127 SECOND 2 100000 173402 189468 219517 233360 305949
628 628 2012-04-01 127 THIRD 3 40000 108799 143430 220969 337127 451460 533338 576483 718001 882212 992661
629 629 2012-04-01 127 FOURTH 4 20000 004754 020941 049780 056144 058070 071505 083839 095259 108303 113790 129444 139001 155049 162025 173608 244605 262164 304113 340433 350889 407809 413960 416219 482809 537926 545080 551486 630119 631118 643936 659410 659744 660493 676901 678192 704471 721733 727570 749558 759836 772033 777813 788725 840610 845983 852271 886797 956867 971861 975145
630 630 2012-04-01 127 FIFTH 5 10000 001141 010019 012841 016986 032468 035758 037009 050537 058120 061155 063818 064256 070127 106268 109467 140062 166366 173432 182973 192989 208515 213869 228445 231145 233058 235933 236079 245660 249738 273410 274191 287153 315833 315980 323408 355757 358145 361459 377037 401392 412288 427388 430850 466241 470536 477337 483462 494952 514023 516599 521858 523073 525278 528558 562467 564241 567108 575097 577182 588065 602811 607135 613681 615786 635229 643168 648111 653848 722972 724711 730074 742493 749234 750715 755172 757013 778192 786245 793723 805933 814896 828880 836760 858444 864250 868723 871505 873442 886544 899026 903998 926202 928037 961800 962579 962970 991591 992992 997086 997973
631 631 2012-04-01 127 TWO 9 1000 69
632 632 2012-04-01 127 THREE 7 2000 074 332 581 616

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