Prize

8 rows where round_id = 85

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1006 1006 2010-06-16 85 FIRST_NEARBY 6 50000 500103 500105
1007 1007 2010-06-16 85 FIRST 1 2000000 500104
1008 1008 2010-06-16 85 SECOND 2 100000 260941 350358 777902 864439 870674
1009 1009 2010-06-16 85 THIRD 3 40000 040538 100804 181102 373481 551631 552329 790086 797690 810767 988011
1010 1010 2010-06-16 85 FOURTH 4 20000 023523 035948 054812 094606 111981 124819 135594 166862 180706 226343 253380 312813 337858 372369 392004 437119 447862 459330 487332 514446 516178 556652 561456 619660 665516 689890 699137 703046 732765 749955 766838 779892 788672 796424 815499 825983 834378 843331 884949 886995 908244 920606 939664 940009 943589 950750 959437 966941 987505 997596
1011 1011 2010-06-16 85 FIFTH 5 10000 002634 010843 012693 057273 060217 065035 073928 077380 084820 088438 090675 104238 113177 138520 139710 169210 180309 185719 193449 199057 204977 223357 263247 285740 305378 317601 318081 321123 324059 325429 327710 327997 332914 337339 341234 349781 350432 354551 371641 385787 397680 409625 414419 426070 460464 463727 478276 481965 487211 489069 494497 508452 536480 546986 560592 570003 590404 592091 623233 623916 630439 638284 677539 692703 707739 716936 719545 723320 724291 725648 728711 742216 751009 751703 757191 758470 761316 782754 786708 797403 802431 803140 812412 825113 826789 828395 847403 855914 859736 862709 869033 892767 922670 923008 923449 933571 941091 947876 949541 964164
1012 1012 2010-06-16 85 TWO 9 1000 73
1013 1013 2010-06-16 85 THREE 7 2000 200 628 681 816

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