Prize

8 rows where round_id = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1326 1326 2009-12-01 72 FIRST_NEARBY 6 50000 776979 776981
1327 1327 2009-12-01 72 FIRST 1 2000000 776980
1328 1328 2009-12-01 72 SECOND 2 100000 289128 368501 626196 883087 958821
1329 1329 2009-12-01 72 THIRD 3 40000 113884 178005 259278 261045 344859 351614 352109 530260 565228 882471
1330 1330 2009-12-01 72 FOURTH 4 20000 012057 071820 096332 099447 102745 149457 160511 198600 199768 290534 293246 293757 294380 306625 322074 331797 365302 375944 398443 410741 412462 430647 439341 441300 444038 458778 467205 477623 506307 525605 526317 539955 540055 546191 548279 560222 577028 611983 622833 750170 771818 782783 816840 817174 826145 850002 854101 873729 878971 884175
1331 1331 2009-12-01 72 FIFTH 5 10000 002644 005816 010214 024468 031028 040018 048377 059765 066273 095797 098111 107852 112638 115323 125928 166404 177031 177528 183094 196237 196769 205003 214507 217289 238741 250533 252523 271659 273970 278403 281353 306779 317466 317660 325725 341343 342123 343311 350471 351993 363221 363380 377036 395362 405441 423686 425158 437458 442808 447198 449775 453015 461273 465683 466276 471229 482529 521722 560767 590361 602515 623532 635109 641888 643755 646296 662110 666630 677323 689563 697285 699137 710617 712533 717970 721578 724357 729405 729442 761133 761156 764194 779654 780822 781474 781680 795578 803667 835013 852210 854449 857077 870137 881143 904629 917039 920277 976970 979908 989385
1332 1332 2009-12-01 72 TWO 9 1000 59
1333 1333 2009-12-01 72 THREE 7 2000 188 252 412 937

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