Prize

8 rows where round_id = 128

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
617 617 2012-04-16 128 FIRST_NEARBY 6 50000 583469 583471
618 618 2012-04-16 128 FIRST 1 2000000 583470
619 619 2012-04-16 128 SECOND 2 100000 372828 430239 515049 606377 806245
620 620 2012-04-16 128 THIRD 3 40000 061987 110514 168758 321304 413044 451119 517738 559408 836600 952954
621 621 2012-04-16 128 FOURTH 4 20000 053673 156216 162622 178556 185164 187341 191543 196110 237824 256963 260761 301870 338325 347448 374430 377852 384670 388923 396289 419635 426359 475362 475486 482499 515782 520102 528084 605724 611062 629481 658590 685903 710232 720750 731472 778591 782561 823144 858795 868039 885289 900848 913077 923860 927314 929001 957679 978285 984875 988290
622 622 2012-04-16 128 FIFTH 5 10000 002176 005819 014828 020352 023365 026122 033396 034059 047311 074553 079001 086003 100092 100633 164023 168344 174473 177624 184007 190431 196013 200546 216938 218766 221782 226349 231312 244725 253516 256186 280249 296431 304083 308438 314395 314982 323507 328451 344264 363028 368509 380234 387933 395860 406138 410633 411360 433952 434509 442586 467785 468313 469715 475172 486161 514900 523851 537105 539617 600991 605868 633973 638127 640038 655046 658641 682941 683296 685670 693348 711119 713392 715521 718841 731527 740503 753241 769478 776539 778688 781461 792280 800573 800798 818776 822099 837056 846935 864739 867545 879844 886069 887509 905701 913538 917672 932206 948260 953513 981766
623 623 2012-04-16 128 TWO 9 1000 62
624 624 2012-04-16 128 THREE 7 2000 088 216 722 754

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