Prize

8 rows where round_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1877 1877 2007-04-16 11 FIRST_NEARBY 6 50000 405104 405106
1878 1878 2007-04-16 11 FIRST 1 2000000 405105
1879 1879 2007-04-16 11 SECOND 2 100000 054508 376717 519066 523980 532325
1880 1880 2007-04-16 11 THIRD 3 40000 037587 187055 254877 550779 602939 716450 775272 931154 964626 973982
1881 1881 2007-04-16 11 FOURTH 4 20000 011879 027059 150660 169439 171933 195992 202452 235232 249391 257803 262511 277650 278534 306870 308377 350010 353733 358186 397306 429276 495011 565104 583864 598350 613766 675014 680108 697784 715604 768860 769976 778266 785547 796432 828617 837775 842384 872624 881828 883595 887347 889104 902051 905036 908275 943800 946489 963294 978852 996966
1882 1882 2007-04-16 11 FIFTH 5 10000 000530 007944 069423 076780 077175 097790 115538 121029 121626 127369 137242 142956 150345 204581 212286 228006 242895 249258 252442 254155 256350 257566 259530 261037 264598 269992 273973 288702 291795 297162 299829 314419 320652 322999 334316 335570 335962 338719 356561 360152 389471 393960 396090 410759 414779 415711 419584 427689 435501 441751 450006 453933 456412 495989 508898 509208 509737 526164 529347 532368 538184 544642 546251 565451 570005 574216 592021 605961 610110 612296 633527 633592 646008 659336 661246 677932 678960 690670 700511 734474 737607 751058 752373 755058 791156 812103 816899 820050 839714 845598 866448 866902 871168 878748 893059 933807 943302 967241 974747 987895
1883 1883 2007-04-16 11 TWO 9 1000 63
1884 1884 2007-04-16 11 THREE 7 2000 013 522 866 987

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