Prize

8 rows where round_id = 29

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1706 1706 2008-02-01 29 FIRST_NEARBY 6 50000 212683 212685
1707 1707 2008-02-01 29 FIRST 1 2000000 212684
1708 1708 2008-02-01 29 SECOND 2 100000 141994 178839 280031 494946 690715
1709 1709 2008-02-01 29 THIRD 3 40000 120195 160954 277212 530379 674628 677649 713229 784679 854543 967670
1710 1710 2008-02-01 29 FOURTH 4 20000 009048 024745 046717 139077 157712 161516 175520 178737 191803 227758 240005 242933 261446 265662 293838 315696 353086 367973 374475 412654 431628 433700 445968 457435 470375 517747 522639 547573 555859 569939 595435 596018 641606 644786 664760 698998 700408 736864 748866 751662 770119 770529 783217 840857 845608 862985 939519 942594 958533 973186
1711 1711 2008-02-01 29 FIFTH 5 10000 019394 039222 042573 044172 045587 048105 095342 097011 097685 102704 106068 132279 136339 143981 155783 174749 195313 197468 201988 216924 221388 224352 230685 231235 237360 237864 238480 250658 254998 265628 285211 294194 295938 300378 306180 309134 330767 354199 355849 355884 358280 366080 371986 380504 397442 415332 422611 430640 449429 453428 456150 476899 503650 538506 546466 549111 553122 555697 558178 571842 586293 601758 615574 622684 626618 635635 653153 658560 665101 676369 676857 682995 683095 684149 689141 691540 695059 704762 705885 714079 721310 722281 730264 734382 740433 748106 758457 776867 780009 801913 820714 822837 832870 837458 844697 860882 867098 891918 947118 971788
1712 1712 2008-02-01 29 TWO 9 1000 26
1713 1713 2008-02-01 29 THREE 7 2000 311 472 732 796

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