Prize

8 rows where round_id = 125

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
641 641 2012-03-01 125 FIRST_NEARBY 6 50000 222517 222519
642 642 2012-03-01 125 FIRST 1 2000000 222518
643 643 2012-03-01 125 SECOND 2 100000 112810 173506 464801 758152 803142
644 644 2012-03-01 125 THIRD 3 40000 060797 082729 385506 407360 426445 515654 538835 541416 818283 950723
645 645 2012-03-01 125 FOURTH 4 20000 043037 049773 092185 100195 103114 118165 128411 134698 149859 174614 212255 225219 248784 309856 312618 327075 329119 330047 341586 414330 416425 447609 454332 455398 504448 507434 535107 562494 582199 594316 663016 674773 688420 699804 748156 754865 778972 782322 810386 842726 861967 862968 867517 873797 930529 935578 937987 961092 992388 994478
646 646 2012-03-01 125 FIFTH 5 10000 000584 005414 020793 048934 066394 067310 067415 075615 076058 078667 080657 084192 093735 096701 097978 102655 103711 114506 140245 141489 157302 157484 159383 161230 185623 189317 191972 201671 219641 230302 231823 232510 260364 281103 307944 321521 330686 339899 348848 355728 357647 389934 413405 422437 449896 463395 466390 468346 470576 474994 494135 496866 509863 546464 550720 555705 557106 561749 564281 572829 576423 583816 597933 605005 616122 631952 633904 635162 636565 640236 644197 651861 666375 683806 690194 704600 717017 722473 723983 739977 755395 769057 769205 769659 773419 773828 800430 800716 815309 817544 818740 833651 835020 847968 871616 887796 889338 943314 956432 961430
647 647 2012-03-01 125 TWO 9 1000 79
648 648 2012-03-01 125 THREE 7 2000 295 135 711 199

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