Prize

8 rows where round_id = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1819 1819 2007-07-01 16 FIRST_NEARBY 6 50000 565150 565152
1820 1820 2007-07-01 16 FIRST 1 2000000 565151
1821 1821 2007-07-01 16 SECOND 2 100000 381012 474300 567467 697849 843433
1822 1822 2007-07-01 16 THIRD 3 40000 069065 160170 253141 372227 389192 529221 680415 797378 821607 944929
1823 1823 2007-07-01 16 FOURTH 4 20000 008092 079993 106171 119858 133394 140139 150962 195735 244797 276316 288081 291140 310302 313300 318213 324546 340093 367256 376121 390672 418454 445162 452107 476175 516614 523576 525563 526775 536423 544298 548001 572997 579829 621049 629569 670040 747094 767143 775882 798311 842333 911273 925049 969289 973957 978763 980885 984216 992167 992973
1824 1824 2007-07-01 16 FIFTH 5 10000 002167 006824 015534 034338 038981 047141 047184 069389 079572 080751 100135 113141 115161 132906 155584 163210 171814 173138 184662 224925 234215 237328 250704 258753 266632 277328 284577 284831 285206 301462 314914 326094 338063 372111 373500 397639 399647 404851 425342 426589 430932 441710 488140 495050 496237 498396 499700 503438 518576 521103 523339 529267 531863 541753 557503 569390 581400 596837 600920 601820 615443 615856 631827 632419 652077 688208 688377 706462 711177 723847 740798 748587 748927 774301 785456 787968 815806 819597 820683 822399 828704 836713 837532 845132 846660 873366 874227 875255 880360 896917 900945 901086 912657 945071 946383 954914 957813 979159 979352 985395
1825 1825 2007-07-01 16 TWO 9 1000 76
1826 1826 2007-07-01 16 THREE 7 2000 146 287 638 949

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