Prize
8 rows where round_id = 156
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 366 | 366 | 2013-06-16 156 | FIRST_NEARBY 6 | 50000 | 289672 289674 |
| 367 | 367 | 2013-06-16 156 | FIRST 1 | 2000000 | 289673 |
| 368 | 368 | 2013-06-16 156 | SECOND 2 | 100000 | 521283 616409 844058 648792 830053 |
| 369 | 369 | 2013-06-16 156 | THIRD 3 | 40000 | 036765 049778 190091 200224 212359 266442 301550 320487 479789 703800 |
| 370 | 370 | 2013-06-16 156 | FOURTH 4 | 20000 | 460692 937503 364677 702603 329117 509276 578594 827060 011889 941044 304830 842826 164008 826541 103479 200413 872256 877373 143417 889813 168948 278322 855369 579949 401783 539622 796135 992272 339703 437150 108722 763863 154118 219308 745702 560336 823629 026340 500403 212947 403101 962000 137294 637083 405274 687633 680954 871094 153177 654833 |
| 371 | 371 | 2013-06-16 156 | FIFTH 5 | 10000 | 001167 145673 265123 347413 457947 539369 626643 756238 849462 941947 010088 148929 281220 353110 480897 550656 659321 774402 862696 942237 014997 166887 287539 395088 484849 554569 660337 782608 866733 947887 024050 167906 290916 413817 486076 559400 679810 792391 868350 959295 034363 176204 302239 416272 488300 579150 688050 794327 879339 966759 040794 192236 305390 426267 492687 582970 716355 802334 885251 971503 051401 203418 314414 432594 505811 591280 729932 803510 897117 978707 051860 217014 329912 434431 515599 600529 745645 824881 899399 981407 115997 221680 332953 447851 531810 607141 746589 834590 917342 992252 135655 222506 338190 454043 533312 614180 754318 841683 929629 999600 |
| 372 | 372 | 2013-06-16 156 | TWO 9 | 1000 | 69 |
| 373 | 373 | 2013-06-16 156 | THREE 7 | 2000 | 390 098 114 502 |
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)
);