Prize

8 rows where round_id = 93

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
942 942 2010-10-16 93 FIRST_NEARBY 6 50000 621376 621378
943 943 2010-10-16 93 FIRST 1 2000000 621377
944 944 2010-10-16 93 SECOND 2 100000 098622 245057 760942 764060 850821
945 945 2010-10-16 93 THIRD 3 40000 252688 334773 348171 352743 648834 835298 868992 884333 924902 974904
946 946 2010-10-16 93 FOURTH 4 20000 029052 034047 051590 096888 112660 122054 128624 142345 166211 169521 182924 193628 217978 232919 245767 253643 276995 303278 307704 344967 359753 360475 366384 409804 417744 468915 507690 515080 524322 574643 579319 613417 670794 685527 696007 754173 777045 791835 817998 844692 860078 866920 873570 915654 916002 951641 971661 974010 983668 996314
947 947 2010-10-16 93 FIFTH 5 10000 009657 011606 015677 022715 045235 053982 057661 079419 109123 137862 160240 166357 170233 178441 216441 224227 225687 232510 254897 258687 260731 262969 263929 267732 273405 274643 274645 282889 289547 307865 310427 315870 316690 327737 368244 406572 409883 429508 431125 431647 440809 458144 463077 497182 518576 530881 561550 576041 591471 603948 614089 625873 634828 642740 666093 683815 689013 692721 695002 696554 699575 710073 724720 728147 748430 757162 757324 761588 770987 771687 772219 786615 798734 814124 843116 855389 869127 874425 878730 880108 894723 897624 902541 906837 912964 921749 938174 949162 953607 955536 959005 972909 973866 976006 979597 980603 981649 982843 986149 993044
948 948 2010-10-16 93 TWO 9 1000 42
949 949 2010-10-16 93 THREE 7 2000 310 385 518 872

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