Prize

8 rows where round_id = 149

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
431 431 2013-03-01 149 FIRST_NEARBY 6 50000 976240 976242
432 432 2013-03-01 149 FIRST 1 2000000 976241
433 433 2013-03-01 149 SECOND 2 100000 200902 292247 769135 867127 910098
434 434 2013-03-01 149 THIRD 3 40000 016221 295930 305890 332145 487847 520602 655560 725599 746961 818735
435 435 2013-03-01 149 FOURTH 4 20000 004578 139861 221871 300553 410566 532177 670049 708033 761077 854744 014685 142825 222904 323893 412996 539603 672185 734789 764030 936682 027031 184769 245192 332904 417774 543875 679705 734871 793231 939214 101231 188147 254644 359846 438361 610797 691541 752136 826522 949077 111641 218906 283056 369601 477931 622821 692457 758532 835939 979633
436 436 2013-03-01 149 FIFTH 5 10000 534665 257935 720886 023248 569776 727291 185965 136100 201115 435454 458422 242007 684677 963156 194523 954478 323962 476827 589738 732223 309254 951512 019152 060948 555551 902480 712889 029784 577555 966451 224142 068038 071072 308104 338630 894178 777839 893208 727500 706861 609552 508368 134538 586633 963776 846909 352080 681841 770361 349447 923594 439499 799853 067987 963620 131961 043558 287017 702648 604877 612915 238314 585961 884550 199105 274044 001212 318846 754257 429470 115250 417544 314302 818479 589293 131791 526237 000454 993622 637927 644270 151621 676142 101088 654336 440804 408442 459825 346349 177889 817294 630636 994725 561532 555387 196158 139421 441389 812697 904229
437 437 2013-03-01 149 TWO 9 1000 37
438 438 2013-03-01 149 THREE 7 2000 972 721 133 775

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