Prize

8 rows where round_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1901 1901 2007-03-01 8 FIRST_NEARBY 6 50000 742424 742426
1902 1902 2007-03-01 8 FIRST 1 2000000 742425
1903 1903 2007-03-01 8 SECOND 2 100000 179586 181690 243014 295266 789975
1904 1904 2007-03-01 8 THIRD 3 40000 064679 105754 180873 243084 276352 781615 961869 989162 993038 995619
1905 1905 2007-03-01 8 FOURTH 4 20000 037911 049245 049962 060793 075729 077315 086799 088324 145952 147583 158990 198634 224653 232888 244200 246088 251789 253518 253563 257233 276464 299853 309956 351519 383294 436004 441412 442406 475069 513827 526019 535620 539096 549039 604562 612443 615619 618394 675187 733252 803591 834756 873456 882412 890045 891125 903567 906753 910145 963759
1906 1906 2007-03-01 8 FIFTH 5 10000 001098 016124 025473 039940 040304 045622 088178 094023 106641 133555 141338 141881 172130 176218 188549 196835 202074 209285 212615 221674 232253 239751 260135 269989 271389 273292 277310 285756 285863 286794 290528 290638 298627 332945 333909 335052 337675 339210 340107 346341 355011 355490 364796 371302 395970 410094 418670 424686 438360 444168 449299 452196 481019 490868 514325 537240 538164 562174 565838 579413 587642 595499 626355 638228 649910 655025 686048 694435 712722 716644 725301 733572 748194 759914 768292 772862 778034 784778 791954 793506 800148 819432 837961 869763 881898 885808 903202 907946 921970 923463 926899 934926 935121 942495 959309 963205 987561 988536 989679 990089
1907 1907 2007-03-01 8 TWO 9 1000 61
1908 1908 2007-03-01 8 THREE 7 2000 294 801 942 949

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);