Prize

8 rows where round_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1811 1811 2007-07-16 17 FIRST_NEARBY 6 50000 527383 527385
1812 1812 2007-07-16 17 FIRST 1 2000000 527384
1813 1813 2007-07-16 17 SECOND 2 100000 117662 238718 309983 816189 834231
1814 1814 2007-07-16 17 THIRD 3 40000 069135 079393 336709 348566 399414 442521 673672 844412 864714 979056
1815 1815 2007-07-16 17 FOURTH 4 20000 007514 017171 019279 063718 103484 103891 109420 123473 140203 154687 256521 259726 272108 287360 287979 296306 297214 299504 341917 354231 363055 370493 446378 489151 497873 506864 514672 529137 612516 613867 619110 643158 650502 670141 686320 694637 722013 782282 800093 857969 858067 883425 887570 899388 904008 906004 911501 935758 946282 955141
1816 1816 2007-07-16 17 FIFTH 5 10000 003956 006632 027373 030815 031029 066431 071811 080081 094831 095903 096282 125348 140255 142326 150088 160280 173633 178411 182788 189643 205616 236078 240186 248861 259412 270883 280562 288144 295891 296230 308290 318576 330683 340091 342341 349944 354572 355915 370894 385659 391628 393792 427806 447341 461119 475336 478491 506044 519679 526629 527992 564691 571987 578897 583077 588038 617785 644818 649748 651763 663754 666433 677991 678124 683962 685444 686636 687408 687729 688980 693065 696194 699127 700771 722229 764800 767452 780672 781183 782211 795022 830647 833961 840358 843381 850131 886764 886832 890425 902330 919344 944925 945284 948615 956531 958261 975659 985610 986585 998148
1817 1817 2007-07-16 17 TWO 9 1000 77
1818 1818 2007-07-16 17 THREE 7 2000 105 183 334 947

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