Prize

8 rows where round_id = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1763 1763 2007-10-16 23 FIRST_NEARBY 6 50000 103298 032989
1764 1764 2007-10-16 23 FIRST 1 2000000 032988
1765 1765 2007-10-16 23 SECOND 2 100000 205817 249853 280278 658543 661597
1766 1766 2007-10-16 23 THIRD 3 40000 002589 040229 220980 267895 300384 303461 581249 678984 757581 960638
1767 1767 2007-10-16 23 FOURTH 4 20000 066717 071628 080463 105301 131041 150884 158348 187183 190237 208303 211022 220993 230276 237179 243426 291184 426322 441983 444535 456785 472364 477362 479292 482041 488108 598532 634145 641337 645028 659756 691355 716725 734001 752927 781530 785681 823364 824166 825453 845657 845840 845946 875258 892669 903168 920515 949363 989425 990474 995262
1768 1768 2007-10-16 23 FIFTH 5 10000 015416 018855 021355 028135 074524 089207 111203 115791 122543 126347 156815 160864 162770 179148 185923 197200 199959 218104 219541 226258 243864 247813 247912 252996 262177 268136 272581 279439 289103 302327 305548 318286 327070 355833 371218 387129 398062 400525 403633 405910 409629 411067 417504 433139 444411 445822 452513 460043 461247 479531 497949 513086 521143 524843 534077 550259 575286 576119 576502 586163 589208 598532 606114 621160 627677 634869 642955 643405 657989 690660 700852 746888 752272 762808 778502 783762 787652 791874 792482 800258 809529 822661 828640 829536 830596 879259 882439 887267 896361 905935 911048 923553 936694 953833 964053 965464 976153 980051 993195 995898
1769 1769 2007-10-16 23 TWO 9 1000 48
1770 1770 2007-10-16 23 THREE 7 2000 158 663 685 846

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