Prize

8 rows where round_id = 50

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1520 1520 2008-12-16 50 FIRST_NEARBY 6 50000 074113 074115
1521 1521 2008-12-16 50 FIRST 1 2000000 074114
1522 1522 2008-12-16 50 SECOND 2 100000 253526 505237 527546 684004 852122
1523 1523 2008-12-16 50 THIRD 3 40000 016667 017877 090504 328749 331880 486233 657629 743189 803813 961153
1524 1524 2008-12-16 50 FOURTH 4 20000 039745 085082 131265 147728 170092 205847 214514 231193 243565 259588 265006 298823 301831 309139 325407 339209 344653 351044 351482 364991 418548 450275 473958 490757 493261 496461 572269 633510 688665 699170 700917 704311 738792 758937 771742 792598 805488 808630 845323 870370 872304 874792 900925 903754 922323 926903 945640 953488 967251 995210
1525 1525 2008-12-16 50 FIFTH 5 10000 013255 015369 022786 030046 039658 048474 052731 054204 070844 088014 094591 104755 109985 115779 116915 118981 122312 126022 126334 126592 153232 159159 175493 189038 192994 202339 212891 222977 246187 266337 285543 289439 293951 308664 314518 316555 321264 326167 374402 380951 384304 394314 395451 397675 406178 427361 428043 434669 451137 452777 454810 457458 471586 479527 490551 492286 495992 497742 525252 531662 533438 538997 549337 551955 568083 630994 631021 640343 683466 692026 699302 712836 732821 758537 763430 765226 766849 791892 792702 795986 813140 848788 858553 870001 871356 872425 884738 905338 906434 906604 922546 922577 928482 951844 953305 965254 968010 971333 977920 987634
1526 1526 2008-12-16 50 TWO 9 1000 25
1527 1527 2008-12-16 50 THREE 7 2000 305 715 803 959

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