Prize

8 rows where round_id = 14

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1853 1853 2007-06-01 14 FIRST_NEARBY 6 50000 836392 836394
1854 1854 2007-06-01 14 FIRST 1 2000000 836393
1855 1855 2007-06-01 14 SECOND 2 100000 077220 257992 307518 347241 963894
1856 1856 2007-06-01 14 THIRD 3 40000 055735 144484 245619 301318 344805 391552 831296 840645 883955 915958
1857 1857 2007-06-01 14 FOURTH 4 20000 044951 055054 058730 060080 062857 073487 106920 138597 192920 196596 205987 226710 259729 278257 279630 317999 319088 405652 443460 458894 477675 481060 493870 510268 542008 544330 573834 587712 622680 625441 638048 670664 694555 696846 717115 718338 738438 775531 789948 801174 808488 822461 828779 878458 884161 907092 912633 914030 979862 986010
1858 1858 2007-06-01 14 FIFTH 5 10000 022842 044745 053844 059413 066585 075388 096090 106086 120750 126345 134626 157389 164172 165190 175596 183396 187876 206177 211606 230933 247438 254089 283623 300993 301242 301306 302436 308922 319459 327260 327299 328392 328847 369414 374675 382589 396136 397873 412015 422918 433564 439182 447049 456512 467674 470431 494838 505706 506595 518102 527434 531997 533975 555624 556285 558860 562322 565055 569297 571699 571918 571976 579441 586979 600687 607641 613387 629297 640821 662575 670668 671850 687931 697569 704143 706971 715451 715750 726208 735006 735712 752145 752979 775527 818031 826566 828533 839480 862762 888232 898192 906969 911552 925871 939272 940714 954058 956260 960964 969221
1859 1859 2007-06-01 14 TWO 9 1000 05
1860 1860 2007-06-01 14 THREE 7 2000 242 433 523 739

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