Prize

8 rows where round_id = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1641 1641 2008-05-16 36 FIRST_NEARBY 6 50000 329230 329232
1642 1642 2008-05-16 36 FIRST 1 2000000 329231
1643 1643 2008-05-16 36 SECOND 2 100000 018455 020460 051006 457024 494700
1644 1644 2008-05-16 36 THIRD 3 40000 054263 227831 320335 452805 502409 526105 723411 816163 828900 993013
1645 1645 2008-05-16 36 FOURTH 4 20000 016924 039345 095482 108132 123943 130586 133194 134478 147631 172391 226972 252671 257148 312065 318855 330146 332195 383177 385511 391182 402938 434733 477430 502584 507774 508082 546492 561961 567746 612984 650988 730188 741562 756173 778899 784477 795427 800459 807665 811272 831384 866917 878207 908402 915603 926269 935946 954888 982252 992520
1646 1646 2008-05-16 36 FIFTH 5 10000 007622 009417 018298 024912 048983 093734 105261 105370 110990 121508 124279 141000 144873 164325 165543 185179 191898 200638 206094 216130 225512 244135 251075 266335 266599 268855 271968 290046 298205 337237 346608 353260 364880 370891 372272 375820 386125 397154 409552 425349 426157 426452 441550 445927 457734 459620 460050 462296 465999 469409 471241 496093 500188 515470 519461 523507 524227 528733 539347 557685 574063 635000 637013 646869 648545 705847 709785 715812 716921 732473 735748 736767 737705 775442 779551 783042 787024 790766 799533 824948 865134 870098 876164 885541 887512 895809 906356 912037 913718 920570 931043 951244 959066 963310 964558 968836 981186 981726 985593 994501
1647 1647 2008-05-16 36 TWO 9 1000 69
1648 1648 2008-05-16 36 THREE 7 2000 193 120 355 214

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