Prize
8 rows where round_id = 112
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 763 | 763 | 2011-08-16 112 | FIRST_NEARBY 6 | 50000 | 536959 536961 |
| 764 | 764 | 2011-08-16 112 | FIRST 1 | 2000000 | 536960 |
| 765 | 765 | 2011-08-16 112 | SECOND 2 | 100000 | 999204 973756 239782 715412 921964 |
| 766 | 766 | 2011-08-16 112 | THIRD 3 | 40000 | 079193 113858 495601 539201 563549 572829 659615 719866 736436 765626 |
| 767 | 767 | 2011-08-16 112 | FOURTH 4 | 20000 | 018067 028224 033544 044274 089026 089190 096355 115688 122177 133237 152504 202033 248094 267919 270256 346032 371081 373408 380540 382147 485553 518069 539119 540696 546091 561264 561633 568492 590424 652995 671116 681574 698949 730322 748937 777560 797446 801377 823807 827730 893840 906209 909555 912306 912501 916830 939488 947881 948543 990166 |
| 768 | 768 | 2011-08-16 112 | FIFTH 5 | 10000 | 497638 382952 942016 174131 967173 818628 300631 565953 340658 760362 187785 444669 052435 529837 046231 263239 796921 692166 846711 512950 027738 576705 348296 166731 713235 419610 819133 434265 013977 632143 928197 047118 610360 319300 904511 402913 042033 373836 188686 099076 113852 319430 043762 378466 559885 470279 321593 665647 355797 012456 107296 657915 154180 458339 287374 784086 164914 950388 905373 131019 198272 492915 482863 008798 326899 854931 686893 516901 546252 913979 146201 053937 330197 957204 537753 676292 176338 783964 144877 114950 788898 770870 133346 175351 239385 216052 738058 152474 512775 191499 763656 943467 760977 435800 297791 104424 702375 722612 622043 076997 |
| 769 | 769 | 2011-08-16 112 | TWO 9 | 1000 | 62 |
| 770 | 770 | 2011-08-16 112 | THREE 7 | 2000 | 814 345 074 005 |
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)
);