Prize

8 rows where round_id = 142

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
496 496 2012-11-16 142 FIRST_NEARBY 6 50000 639499 639501
497 497 2012-11-16 142 FIRST 1 2000000 639500
498 498 2012-11-16 142 SECOND 2 100000 893331 328601 872960 097338 157883
499 499 2012-11-16 142 THIRD 3 40000 502317 741182 686626 148453 701267 370524 370496 323271 780836 597165
500 500 2012-11-16 142 FOURTH 4 20000 292116 360214 078679 588238 246379 779799 356867 059572 269550 877876 231895 709610 120335 370403 584585 840853 125343 880148 596195 989414 922289 613395 043081 752520 781251 041361 258743 639166 861639 037467 365719 438661 929677 207864 351402 120339 402302 609441 668456 764585 953580 524290 302370 961834 681507 780351 365671 244418 876660 592117
501 501 2012-11-16 142 FIFTH 5 10000 013940 081403 165629 255332 362200 441892 530476 753933 815339 895867 024962 082274 178638 267118 371625 448138 557461 757256 835906 901078 028014 086828 195763 275186 372776 460661 568329 761566 838685 917925 035405 111724 197904 287662 375578 467945 639432 767130 844567 919613 051187 121976 203651 293813 388833 476062 651427 771166 846048 940581 058480 123594 205447 304648 401418 485338 668182 774832 847434 942997 062518 145202 216008 324486 406336 491531 689550 790473 860226 944379 070209 149533 231174 333355 424794 505786 728097 800436 860808 961594 074683 151194 236391 342983 432838 506610 748431 801429 868487 976353 077612 151414 246214 356870 433470 518219 749830 812075 889225 989325
502 502 2012-11-16 142 TWO 9 1000 15
503 503 2012-11-16 142 THREE 7 2000 576 560 804 627

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