Prize

8 rows where round_id = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1690 1690 2008-03-01 31 FIRST_NEARBY 6 50000 936684 936686
1691 1691 2008-03-01 31 FIRST 1 2000000 936685
1692 1692 2008-03-01 31 SECOND 2 100000 036610 461812 468326 925656 949383
1693 1693 2008-03-01 31 THIRD 3 40000 063642 259261 305520 396448 418879 490787 631450 754519 835549 847908
1694 1694 2008-03-01 31 FOURTH 4 20000 003509 017631 021263 034223 092318 103098 103961 114759 128362 163446 164608 182171 184028 202390 210941 253692 255877 269701 277608 386322 387309 417643 425968 491450 544108 549050 584545 594643 622619 628964 636865 684055 696929 713672 730226 733041 736033 736951 828680 836252 862614 868604 876386 883537 888835 939671 939914 969913 985092 995299
1695 1695 2008-03-01 31 FIFTH 5 10000 000761 001841 003169 004783 033566 040971 048789 049364 067437 081312 108562 117656 126069 131822 136646 139477 139610 146111 161659 162764 190046 203999 206506 239107 250119 257230 261600 288304 289149 290084 297815 307510 311068 312051 314856 318397 324414 344657 352033 365711 399698 400513 418038 430636 437651 437719 440855 457695 458402 465079 481712 485396 486373 489093 501884 509755 526452 534312 536715 538030 556894 562203 583156 593546 630283 643325 651360 672957 673699 707842 715711 724401 737033 750781 769859 774570 782778 793930 798279 801999 841240 849813 855840 859015 863475 875287 889284 892649 894493 923570 934524 938243 946542 948616 952451 958108 960058 962187 973917 990757
1696 1696 2008-03-01 31 TWO 9 1000 05
1697 1697 2008-03-01 31 THREE 7 2000 056 085 371 691

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