Prize

8 rows where round_id = 173

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
221 221 2014-03-01 173 FIRST_NEARBY 6 50000 906317 906319
222 222 2014-03-01 173 FIRST 1 2000000 906318
223 223 2014-03-01 173 SECOND 2 100000 967193 332227 054014 860777 471879
224 224 2014-03-01 173 THIRD 3 40000 426288 137363 895373 632850 165872 096702 731723 981678 216213 926272
225 225 2014-03-01 173 FOURTH 4 20000 994727 247315 205041 703251 824393 540849 144896 808473 390287 936399 785974 604253 481944 183510 723058 807705 079862 485346 819473 789129 401085 118473 880023 218448 612470 312948 522859 990834 009045 217255 612556 312783 990927 560066 690566 492608 214743 351476 685901 191973 986639 109827 780647 480715 783035 450206 255604 691174 861145 720597
226 226 2014-03-01 173 FIFTH 5 10000 105771 903179 114546 299496 562814 688708 118891 759897 449344 216240 904690 815732 569685 473574 575568 888226 511188 987402 887403 625296 443891 171686 271365 431587 306661 109861 008930 433209 214524 932491 351791 655355 359020 777002 476185 577397 749348 575460 446010 752460 300050 789621 218188 808373 536766 613471 755181 417719 648030 485035 579958 086012 428204 348676 457513 516868 328925 107039 728485 535125 434725 194176 517475 848722 921376 341157 737352 663162 351325 108036 603229 535928 533447 714650 609434 900546 520242 999702 877776 329236 643866 344805 160982 376921 550981 657562 209798 429262 829242 056007 217923 952941 581946 630038 899940 655270 720400 032195 484440 875203
227 227 2014-03-01 173 TWO 9 1000 35
228 228 2014-03-01 173 THREE 7 2000 116 537 753 798

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