Prize

8 rows where round_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1942 1942 2006-12-30 4 FIRST_NEARBY 6 50000 778583 778585
1943 1943 2006-12-30 4 FIRST 1 2000000 778584
1944 1944 2006-12-30 4 SECOND 2 100000 133134 468424 509756 515202 640052
1945 1945 2006-12-30 4 THIRD 3 40000 039111 106962 243210 572025 672933 747619 783856 788562 883417 949422
1946 1946 2006-12-30 4 FOURTH 4 20000 002133 032265 044600 075557 095795 109439 110810 112031 126449 127436 127527 157152 169222 187299 198514 213242 222038 264843 305297 310318 356486 386925 396818 418273 434194 538756 606060 608167 613879 667721 683160 689045 690297 738817 758710 770442 789377 829263 853486 864513 867786 872541 896727 915911 929384 945876 947445 965430 981194 982009
1947 1947 2006-12-30 4 FIFTH 5 10000 004495 034106 049904 067124 069215 070092 100878 102543 129948 132951 139652 148659 158191 169092 178870 189115 191825 201127 203872 224131 228417 230865 242039 242762 250155 288678 306411 313144 314042 321908 323772 332255 334385 360469 361908 369027 371207 386380 388597 389859 398164 398995 409554 412334 432868 448126 463860 476405 496238 512379 512864 517389 524471 524612 526897 551450 554668 555292 564731 566015 570848 584444 590319 592632 596595 627814 628798 642846 650510 653801 657303 658195 659826 672627 681301 702980 703296 704141 723828 731281 737731 742541 748829 758763 772166 778816 781353 783383 804541 811450 814987 857430 858640 880979 896677 903983 921115 925084 956939 971877
1948 1948 2006-12-30 4 TWO 9 1000 07
1949 1949 2006-12-30 4 THREE 7 2000 164 403 811 971

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