Prize

8 rows where round_id = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1845 1845 2007-06-16 15 FIRST_NEARBY 6 50000 39319 393195
1846 1846 2007-06-16 15 FIRST 1 2000000 393194
1847 1847 2007-06-16 15 SECOND 2 100000 416062 504706 542137 855158 857322
1848 1848 2007-06-16 15 THIRD 3 40000 007856 072285 081609 109535 111104 180659 355413 611167 738966 740142
1849 1849 2007-06-16 15 FOURTH 4 20000 003308 007404 016272 032726 033383 047407 056702 089946 146290 180803 282169 282308 291491 315995 360544 364278 389018 397508 408384 412584 422866 439202 446817 481322 484164 495986 497331 587594 597095 598299 608044 614011 615473 662790 671422 687533 700790 722142 723502 731635 769793 787569 790048 790580 801214 913683 921519 930054 969629 983720
1850 1850 2007-06-16 15 FIFTH 5 10000 031406 036293 037876 045565 058285 069181 102859 106381 115133 117759 121071 128520 130901 132738 140492 143485 162115 164043 171288 172441 174528 205005 205237 206152 210741 220105 253962 307603 328825 376646 382970 386444 391266 398756 406322 413340 421916 423592 425193 445415 460370 471005 489986 491223 497824 510154 510265 515416 522064 526314 529460 532119 534426 534634 545931 558855 561622 591095 604673 612855 619228 634306 664892 670136 672213 676148 680998 682365 691122 725765 728578 746006 760800 775542 776355 780578 795034 797267 797972 807787 813079 821643 823442 823642 831426 840386 859222 872791 900225 921156 927320 938806 941814 952481 954835 955468 960729 966292 988861 991289
1851 1851 2007-06-16 15 TWO 9 1000 41
1852 1852 2007-06-16 15 THREE 7 2000 424 589 907 989

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