Prize

8 rows where round_id = 111

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
771 771 2011-08-01 111 FIRST_NEARBY 6 50000 218755 218757
772 772 2011-08-01 111 FIRST 1 2000000 218756
773 773 2011-08-01 111 SECOND 2 100000 300678 325341 403945 411013 654649
774 774 2011-08-01 111 THIRD 3 40000 490658 630212 616010 862198 809925 946307 676773 317596 804687 223566
775 775 2011-08-01 111 FOURTH 4 20000 021444 024960 087872 115930 133503 135849 159259 164894 201797 224797 237732 239453 247891 264572 274442 285686 332231 348935 355671 361225 375602 382948 405641 420205 449846 461816 487253 501272 510946 511351 560272 567812 582118 609236 611891 684989 685642 705222 708205 722629 761829 765230 802067 810677 815063 826876 857717 967144 974280 995270
776 776 2011-08-01 111 FIFTH 5 10000 016596 044272 064718 066208 074006 095442 100584 122145 123662 125767 140719 150266 154386 173397 179557 180923 188106 191613 202237 204791 214282 220807 225209 229636 238657 253086 300306 301128 310565 319161 327020 335777 342375 366366 369338 379574 384242 387211 420405 422752 429845 455454 465834 488377 520357 529444 556570 561761 571648 576633 581161 588901 590473 596686 652855 653262 653598 662783 672224 685938 692471 693845 708997 709340 716499 718913 720100 721034 738296 738891 752858 767974 771601 809701 812714 816006 816447 820297 821950 823203 828593 843153 843834 844122 856820 875131 904740 905388 910888 924701 930116 930147 940709 949669 956848 957463 961638 965357 982293 994826
777 777 2011-08-01 111 TWO 9 1000 12
778 778 2011-08-01 111 THREE 7 2000 221 583 660 703

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