Prize

8 rows where round_id = 189

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
75 75 2014-11-01 189 FIRST_NEARBY 6 50000 206607 206609
76 76 2014-11-01 189 FIRST 1 2000000 206608
77 77 2014-11-01 189 SECOND 2 100000 514847 783409 189478 793465 628367
78 78 2014-11-01 189 THIRD 3 40000 478206 780211 097787 750209 413327 621303 061128 031919 914656 687455
79 79 2014-11-01 189 FOURTH 4 20000 678893 205888 453639 774291 941614 061181 834145 253417 396319 567834 849296 381522 786822 070936 364742 727796 949162 562241 533163 249498 385509 705857 395030 573513 309521 134793 334677 771016 744381 366388 651358 944068 597595 684302 788628 432789 611977 154970 855638 885430 749851 269526 732885 810430 146647 147999 569283 709895 429382 515785
80 80 2014-11-01 189 FIFTH 5 10000 281210 895644 591422 616212 560418 627656 281963 612252 028896 523375 165365 811346 947047 069468 348155 404089 024850 346727 106766 599932 657304 418430 200732 987850 817841 402896 048481 390504 508103 096127 868132 679093 565432 285425 010850 417879 135824 043836 838692 412333 625645 938762 579805 918536 456380 616751 386985 274440 265364 343436 084649 211603 452404 608782 703438 807086 111482 595123 631067 253616 525103 202326 421965 064422 519223 853355 251994 914109 277694 574560 667837 948942 584023 245588 244851 777013 296917 466289 846022 518244 793572 751136 389909 372338 579981 797210 057138 233997 302802 892380 694090 069430 831265 430728 041460 318087 225076 408479 616615 510334
81 81 2014-11-01 189 TWO 9 1000 44
82 82 2014-11-01 189 THREE 7 2000 607 203 855 979

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