Prize

8 rows where round_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1609 1609 2008-07-16 40 FIRST_NEARBY 6 50000 257373 257375
1610 1610 2008-07-16 40 FIRST 1 2000000 257374
1611 1611 2008-07-16 40 SECOND 2 100000 342933 401597 684568 715935 865578
1612 1612 2008-07-16 40 THIRD 3 40000 037799 076072 249499 349490 423667 539376 559482 607969 725044 740008
1613 1613 2008-07-16 40 FOURTH 4 20000 003876 081280 151358 245303 340554 415530 498906 696329 717558 771445 034166 112335 172461 255142 359946 433847 514670 696421 740101 847518 034917 122560 189392 255609 362940 450625 606532 700293 742770 871233 039455 123666 233172 321488 362966 459353 642952 715643 761011 921596 077002 132910 240653 339796 363598 477671 666415 716172 771393 938239
1614 1614 2008-07-16 40 FIFTH 5 10000 000404 003174 003380 005666 012479 019877 025306 029228 034169 064265 068408 086598 091849 095442 101024 106155 127173 137885 141836 167457 212521 212867 217697 222480 225650 228063 229675 238664 245248 248160 253090 253775 261742 312792 328984 346670 365952 460128 470765 470832 481385 485295 488391 490581 513873 516660 527470 527826 548887 551295 560651 574745 585502 588835 598387 598948 599207 599836 619458 634470 636750 685513 686815 689071 710778 715446 715561 716453 716536 719131 739205 745517 755075 757720 766658 774830 780767 785761 788373 802986 803636 804373 821958 831288 848774 855076 863503 864280 868251 876607 880934 887008 890036 941184 950502 959260 960039 970260 976755 996447
1615 1615 2008-07-16 40 TWO 9 1000 41
1616 1616 2008-07-16 40 THREE 7 2000 344 401 486 576

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