Prize

8 rows where round_id = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1779 1779 2007-09-16 21 FIRST_NEARBY 6 50000 49933 499337
1780 1780 2007-09-16 21 FIRST 1 2000000 499336
1781 1781 2007-09-16 21 SECOND 2 100000 001292 173159 197282 432873 898540
1782 1782 2007-09-16 21 THIRD 3 40000 037505 059588 110027 241159 352813 356628 527459 543347 681025 797084
1783 1783 2007-09-16 21 FOURTH 4 20000 015441 016755 024688 069118 139446 146580 155927 187270 216538 220859 231032 270621 271960 276386 283902 283946 304573 321818 340414 363738 372908 379502 480165 480309 483642 484261 486446 503565 534693 546287 552981 618618 622688 625193 628273 633228 640732 655738 705827 706467 747095 773606 803000 824001 881902 902784 932848 960063 962908 988716
1784 1784 2007-09-16 21 FIFTH 5 10000 035875 055176 062722 075119 098727 103296 106043 122396 135883 139929 150747 157556 190352 216809 218761 221382 233109 236605 248343 254749 259467 272262 291044 325978 349634 361311 368014 376158 383035 389459 394254 402032 406879 407782 408234 414574 418777 425475 425633 427974 437978 461656 462321 494671 495364 514355 521556 524439 531366 535224 538695 539709 540182 547938 548594 563887 567193 568553 569922 570971 571542 595658 605785 618570 629302 640475 646318 648489 660362 667887 683865 699183 699481 708147 711543 711732 712761 719960 729975 745105 767538 783316 792399 794068 809737 820828 828695 830060 842129 857971 860492 870907 880965 889513 891309 893025 903567 943489 981157 983561
1785 1785 2007-09-16 21 TWO 9 1000 45
1786 1786 2007-09-16 21 THREE 7 2000 247 273 604 608

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