Prize
8 rows where round_id = 147
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 447 | 447 | 2013-02-01 147 | FIRST_NEARBY 6 | 50000 | 565565 565567 |
| 448 | 448 | 2013-02-01 147 | FIRST 1 | 2000000 | 565566 |
| 449 | 449 | 2013-02-01 147 | SECOND 2 | 100000 | 671110 547335 919268 840246 503703 |
| 450 | 450 | 2013-02-01 147 | THIRD 3 | 40000 | 498513 692039 132394 078503 770776 775599 227493 552158 784615 224859 |
| 451 | 451 | 2013-02-01 147 | FOURTH 4 | 20000 | 826875 366456 069422 808641 791043 553128 501993 708859 424545 016038 959973 177745 658898 862786 732352 917927 683018 749063 382035 116852 908516 861910 193353 065768 263317 269248 682316 294662 237153 742946 065732 665951 266052 599016 760041 437429 298286 588802 497603 461643 861406 028310 173651 112977 190089 359676 380834 256415 661986 124320 |
| 452 | 452 | 2013-02-01 147 | FIFTH 5 | 10000 | 006303 098569 201827 269220 433995 554490 657650 713026 791262 867140 012837 101457 208356 271057 439138 567606 661989 716573 795726 878715 019267 106217 218842 302919 460544 590425 682470 727686 803238 879503 052232 132590 220761 327587 461157 603061 687421 730340 806583 904279 060232 143190 221109 352140 461360 614362 694551 731680 823826 938215 061383 152057 221508 381809 471867 616678 695846 740706 830037 941232 062942 165988 230439 389349 478584 623255 699327 765487 830807 943923 079065 167285 235293 389952 503309 641227 699359 773395 850787 970577 087544 181448 236157 395665 522852 649766 699676 780432 861779 978873 088628 187283 246120 426896 529203 651617 701853 789443 866024 992675 |
| 453 | 453 | 2013-02-01 147 | TWO 9 | 1000 | 66 |
| 454 | 454 | 2013-02-01 147 | THREE 7 | 2000 | 452 695 641 782 |
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)
);