Prize

8 rows where round_id = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1585 1585 2008-09-01 43 FIRST_NEARBY 6 50000 695992 695994
1586 1586 2008-09-01 43 FIRST 1 2000000 695993
1587 1587 2008-09-01 43 SECOND 2 100000 100141 166340 257676 845706 960743
1588 1588 2008-09-01 43 THIRD 3 40000 152556 247380 406260 445506 500931 586784 645282 897367 905083 908585
1589 1589 2008-09-01 43 FOURTH 4 20000 025060 029178 040899 051937 080125 084429 125622 141409 167344 211332 219701 239479 244174 245801 251589 255631 283550 294884 311169 344787 359822 371296 416601 423055 429735 463062 466957 469939 475760 501507 572711 596510 602641 622083 661318 664894 680299 700807 715827 725036 742847 746180 754314 782521 810392 836264 867700 900425 911516 990915
1590 1590 2008-09-01 43 FIFTH 5 10000 012480 032872 042981 048521 054999 062343 065754 071062 071930 085807 156850 172563 177968 193172 193569 198218 213397 222120 245512 260696 268166 289352 306649 307094 318221 334965 344938 346913 368950 401481 421102 430104 438189 438984 439440 448702 452271 454337 455094 458028 479647 480647 487340 492061 509434 512603 514236 521829 527148 547574 550182 550227 590822 615533 662673 664995 669031 678448 678625 681250 704999 705394 713868 723995 724008 724348 725867 727964 734790 753130 767664 787398 806327 810504 810574 822758 849968 854589 859399 875608 881596 885742 887701 909684 915235 926155 928599 937806 959201 967807
1591 1591 2008-09-01 43 TWO 9 1000 09
1592 1592 2008-09-01 43 THREE 7 2000 027 206 413 904

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