Prize

8 rows where round_id = 187

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
91 91 2014-10-01 187 FIRST_NEARBY 6 50000 375614 375616
92 92 2014-10-01 187 FIRST 1 2000000 375615
93 93 2014-10-01 187 SECOND 2 100000 782437 726980 251639 885899 438907
94 94 2014-10-01 187 THIRD 3 40000 551569 279415 623337 351053 751679 147464 792023 413384 062320 830528
95 95 2014-10-01 187 FOURTH 4 20000 162630 412955 613014 010183 080754 297764 893050 405990 465085 827181 849617 026027 087209 139862 842042 898537 692485 070478 613343 988259 733033 419360 435069 618488 473162 472981 543429 154029 909397 589658 452376 007462 231891 397386 290155 779152 434431 051214 515669 341695 277636 646923 608896 526682 792923 439961 707264 201921 421934 904587
96 96 2014-10-01 187 FIFTH 5 10000 874175 808697 277954 211024 665661 626981 295359 661471 198334 131830 002617 039902 648513 536665 694489 685480 870034 719376 503170 696275 113939 923255 625597 602935 779339 661441 269474 260867 609603 812318 432795 163316 152115 729204 050845 664420 484375 193735 865526 602038 684456 989736 324274 383137 929508 887122 976501 721681 667403 811563 748981 551771 867555 959073 153641 190068 411855 830214 789214 739427 812183 674855 385947 544875 271820 165730 406267 208280 976524 661692 009654 672826 945600 509434 142354 601407 778845 551552 393118 333052 357830 057619 738809 421774 422561 322043 112603 790876 364805 007361 730734 256250 161509 010461 860381 004252 450640 422729 239735 977182
97 97 2014-10-01 187 TWO 9 1000 44
98 98 2014-10-01 187 THREE 7 2000 251 086 159 520

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