Prize
8 rows where round_id = 113
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 755 | 755 | 2011-09-01 113 | FIRST_NEARBY 6 | 50000 | 724532 724534 |
| 756 | 756 | 2011-09-01 113 | FIRST 1 | 2000000 | 724533 |
| 757 | 757 | 2011-09-01 113 | SECOND 2 | 100000 | 200700 571134 694542 931425 940708 |
| 758 | 758 | 2011-09-01 113 | THIRD 3 | 40000 | 202396 543476 387546 766592 038084 856995 931787 435090 377570 106650 |
| 759 | 759 | 2011-09-01 113 | FOURTH 4 | 20000 | 019724 022953 073503 078546 096238 167841 173766 207442 246368 249575 275562 277129 281277 292727 301061 313501 322856 329502 335494 354870 356260 392577 396201 415621 470435 470477 504118 561427 603898 624997 626131 635567 648711 748689 755934 820424 838287 842192 842351 855387 869786 876452 879589 879932 885364 895615 951721 957153 960866 961593 |
| 760 | 760 | 2011-09-01 113 | FIFTH 5 | 10000 | 012063 018243 040522 058000 070098 071224 071324 083856 106949 109343 124607 133076 162013 168956 181622 192276 198041 201845 204130 206219 218245 221679 228241 231448 239045 244234 267455 275472 282324 286882 292316 295015 319274 319614 333038 348785 359957 392228 406012 437295 451035 456799 462059 468806 481478 490813 492984 494802 510724 521876 536461 552220 558209 574965 577141 577160 580366 592388 598095 599514 607926 630174 694424 695210 701688 701757 706997 712251 718873 721599 725221 731030 738890 755421 758151 768142 772211 776145 776699 777354 803641 820689 829391 834365 850740 867670 878598 907668 919049 943189 948413 955201 960017 964609 979096 979778 983654 990256 993618 998325 |
| 761 | 761 | 2011-09-01 113 | TWO 9 | 1000 | 85 |
| 762 | 762 | 2011-09-01 113 | THREE 7 | 2000 | 847 021 533 821 |
Advanced export
JSON shape: default, array, newline-delimited
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)
);