Prize

8 rows where round_id = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1755 1755 2007-11-01 24 FIRST_NEARBY 6 50000 192790 927908
1756 1756 2007-11-01 24 FIRST 1 2000000 927907
1757 1757 2007-11-01 24 SECOND 2 100000 022019 297392 307599 391781 533515
1758 1758 2007-11-01 24 THIRD 3 40000 011886 152808 322133 324666 609474 633274 726093 750887 755791 848203
1759 1759 2007-11-01 24 FOURTH 4 20000 023097 024917 059859 069661 078425 090595 099798 110752 113662 131288 135025 148336 148774 171857 193799 250061 289024 308458 310437 346874 368481 388247 388500 415369 423703 424900 441618 454459 470209 519306 522701 597177 604598 627192 629508 654166 654325 695677 719608 731644 765846 780092 790334 817338 882248 917568 929536 950978 958408 962830
1760 1760 2007-11-01 24 FIFTH 5 10000 003776 010490 011165 075551 078512 088499 097587 098127 103075 117173 128817 136505 143388 146865 149028 149701 156198 159955 183745 185421 199593 200853 226113 227571 235117 240644 296323 308013 345320 345969 359554 362273 377896 384409 384449 401644 402458 433649 437336 450012 460112 485915 496469 512022 517053 521187 536917 561411 566827 573186 588595 598624 601512 609289 611044 626370 631793 638575 639535 650253 655120 665114 667736 680542 683040 684738 687805 689031 705233 712974 730603 745324 748362 752904 770584 804393 806641 807624 811354 814372 855505 863449 867218 871891 885102 908571 909672 910482 912379 917586 918257 929528 931779 933805 939463 964115 969305 978116 984394 988309
1761 1761 2007-11-01 24 TWO 9 1000 88
1762 1762 2007-11-01 24 THREE 7 2000 213 277 524 648

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