Prize

8 rows where round_id = 143

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
488 488 2012-12-01 143 FIRST_NEARBY 6 50000 110444 110442
489 489 2012-12-01 143 FIRST 1 2000000 110443
490 490 2012-12-01 143 SECOND 2 100000 070949 333362 661224 863065 912881
491 491 2012-12-01 143 THIRD 3 40000 043978 248435 366295 387700 460105 624706 779220 814567 940021 969699
492 492 2012-12-01 143 FOURTH 4 20000 000632 110385 164786 252897 335431 436429 565014 668453 832760 919954 031402 112959 194552 261930 343398 444025 600924 739816 861058 961152 032346 129391 204259 295131 344268 482146 640093 740831 863744 980662 059333 154766 249465 313260 366254 504506 660852 769589 906291 987650 104388 157337 250917 321331 411036 534951 665567 830576 909468 991709
493 493 2012-12-01 143 FIFTH 5 10000 009853 017727 033072 049490 050881 052726 067581 070305 072816 078257 088300 116712 122758 124631 132307 136081 146842 155710 165069 166937 172056 177815 182618 231390 232357 237898 254653 257336 278243 285192 290590 292778 296337 324394 329751 329989 336213 336603 342453 342865 356414 367930 374659 394823 397971 424603 447004 447610 452967 454409 466184 502001 525022 531445 536177 537779 541535 546008 556564 557974 583142 590013 595824 600367 616286 622072 627708 637201 641914 644096 650006 661271 671375 686793 714608 723806 734999 738482 790071 791917 805077 806196 813979 878134 892450 894866 895502 914300 924242 932895 933798 935416 938412 938884 960733 966453 974253 976845 982125 989462
494 494 2012-12-01 143 TWO 9 1000 43
495 495 2012-12-01 143 THREE 7 2000 434 553 489 303

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