Prize

8 rows where round_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1488 1488 2009-02-16 54 FIRST_NEARBY 6 50000 038729 038731
1489 1489 2009-02-16 54 FIRST 1 2000000 038730
1490 1490 2009-02-16 54 SECOND 2 100000 029453 037616 122799 639439 864569
1491 1491 2009-02-16 54 THIRD 3 40000 073164 171135 216209 260453 491664 531130 544578 756798 836031 841870
1492 1492 2009-02-16 54 FOURTH 4 20000 022574 052948 058508 090483 097013 102215 137675 163110 165032 190512 201507 218230 240754 266777 303024 303679 313176 320519 346421 347182 368229 392172 413786 417861 432270 459498 485354 489270 511372 565630 566846 576912 617545 622575 625009 649704 650496 651969 653614 794932 800489 801123 852649 889741 894212 905931 935884 952653 983029 995788
1493 1493 2009-02-16 54 FIFTH 5 10000 009456 011664 024660 026842 051041 055499 058249 059392 062767 068515 068816 071189 084514 091733 093364 114751 128279 133729 153066 159762 161349 171730 181327 190105 193061 211464 233524 242507 265135 271672 273343 287455 294416 299253 307811 324416 332203 332901 341386 365328 373833 397890 434768 466576 473929 485282 485989 494857 521000 529469 537277 542118 546501 568551 577933 584289 585045 590258 617980 622854 645619 668084 681946 693173 700248 704696 721957 725871 734287 735864 743007 744368 746301 754057 780374 785804 815981 817560 819181 821323 825603 831117 841860 852119 857214 882276 885853 892873 902101 910189 915295 927423 936006 939221 955946 959894 972131 972297 993156 997586
1494 1494 2009-02-16 54 TWO 9 1000 93
1495 1495 2009-02-16 54 THREE 7 2000 115 434 939 961

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