Prize

8 rows where round_id = 39

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1617 1617 2008-07-01 39 FIRST_NEARBY 6 50000 943670 943672
1618 1618 2008-07-01 39 FIRST 1 2000000 943671
1619 1619 2008-07-01 39 SECOND 2 100000 022606 101572 456836 642100 870893
1620 1620 2008-07-01 39 THIRD 3 40000 121965 140058 151077 357627 539786 572155 697384 800920 828136 846222
1621 1621 2008-07-01 39 FOURTH 4 20000 008791 009954 037474 041208 045935 051949 131093 131323 173763 185678 221446 252905 285784 291620 301573 316666 346729 353795 368473 375345 376828 387151 424926 429384 432818 450921 482071 486737 541271 635719 649914 655953 687800 703524 732315 737392 779914 797412 821808 827287 847462 863307 874784 879743 888146 901608 911787 963661 978942 986013
1622 1622 2008-07-01 39 FIFTH 5 10000 002471 022633 032282 043701 047823 060949 073868 081949 089481 121746 121819 125664 132644 145089 150655 155483 173327 181189 185700 188609 196050 201725 217574 229452 233473 236115 238979 244857 249538 259769 276992 285943 290702 317609 320832 333517 337788 337842 344222 360652 382462 385822 399172 409349 416437 419317 421481 436943 438946 445605 447665 488902 505355 505615 510602 536785 578688 585462 617322 623040 628671 632118 647921 654562 664453 667135 669060 675023 682017 683291 689873 713884 716706 729269 748680 753276 756919 761008 778905 785128 815958 820110 821169 826413 843934 871907 884562 919993 942911 947435 950088 953399 962047 965473 974233 975252 990593 993343 993396 993765
1623 1623 2008-07-01 39 TWO 9 1000 50
1624 1624 2008-07-01 39 THREE 7 2000 096 287 490 523

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