Prize

8 rows where round_id = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1885 1885 2007-04-01 10 FIRST_NEARBY 6 50000 622779 622781
1886 1886 2007-04-01 10 FIRST 1 2000000 622780
1887 1887 2007-04-01 10 SECOND 2 100000 025178 373795 449880 633699 803757
1888 1888 2007-04-01 10 THIRD 3 40000 106371 119215 149042 173136 241867 323232 511244 511544 527614 889034
1889 1889 2007-04-01 10 FOURTH 4 20000 008036 041703 050965 054279 081037 098235 113982 144892 155237 164555 170000 171499 180383 212116 235851 290591 308386 322315 327324 408508 420575 430617 461092 469659 469881 542147 608323 658823 672116 673596 680511 681408 709076 720971 753489 755410 761056 774472 780269 783747 784604 802661 842006 883365 899266 906563 923043 934757 963285 972256
1890 1890 2007-04-01 10 FIFTH 5 10000 007486 018783 039585 042768 048033 053635 062524 062950 073187 076419 083116 097665 099506 104430 112728 121646 128679 139035 156850 169305 179766 180582 184795 192255 192717 229122 234424 244860 257013 265997 271543 273701 283810 285661 300692 310190 311092 319822 346462 358327 361901 362018 372714 401200 410423 424842 429851 436580 445363 449827 452970 456480 456483 457049 467518 508461 511748 535323 540156 560765 579182 586456 592248 638657 643331 647229 648644 654290 654810 674888 679796 683469 700483 701779 720950 750752 764140 764754 765858 766280 768074 786359 786579 791466 791783 811555 811655 851405 856927 860126 862006 868902 913518 929850 959902 962080 978465 981946 985384 989109
1891 1891 2007-04-01 10 TWO 9 1000 93
1892 1892 2007-04-01 10 THREE 7 2000 022 677 794 814

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