Prize
8 rows where round_id = 118
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 706 | 706 | 2011-11-16 118 | FIRST_NEARBY 6 | 50000 | 997776 997778 |
| 707 | 707 | 2011-11-16 118 | FIRST 1 | 2000000 | 997777 |
| 708 | 708 | 2011-11-16 118 | SECOND 2 | 100000 | 027748 752950 845496 285304 518836 |
| 709 | 709 | 2011-11-16 118 | THIRD 3 | 40000 | 061084 144033 162750 182065 215770 307707 377865 666153 726631 746712 |
| 710 | 710 | 2011-11-16 118 | FOURTH 4 | 20000 | 015962 045192 065499 104358 106664 138469 142839 148522 172284 208954 221052 242578 301409 303541 319587 320436 324522 379408 422103 463699 466216 475386 548085 572521 575738 589578 592873 606737 638427 648935 658073 661363 668784 672335 679486 716572 720200 726129 774531 819357 837021 874792 893198 908490 915053 928165 939497 977820 979409 981715 |
| 711 | 711 | 2011-11-16 118 | FIFTH 5 | 10000 | 001689 102644 231660 334692 430182 532602 599557 665464 788970 893777 002166 112788 249575 350123 440805 540641 607421 668720 813550 895537 002645 114367 252631 368056 452978 541445 611172 676608 814858 910257 009319 129904 254625 373174 458779 550317 611881 711650 819322 915585 034480 146543 260908 391066 459045 565399 619085 714405 833004 921271 064897 155625 261848 393320 485335 570171 624266 766798 847532 939755 066585 174292 267853 402828 485852 583560 645332 767111 865060 954081 069257 201492 305217 407671 500177 584922 646044 779527 866930 964958 078644 204001 320611 407844 526374 589739 649923 780325 867541 974694 096171 209599 323712 425991 532341 597386 658308 783801 868466 983484 |
| 712 | 712 | 2011-11-16 118 | TWO 9 | 1000 | 57 |
| 713 | 713 | 2011-11-16 118 | THREE 7 | 2000 | 425 551 406 993 |
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)
);