Prize

8 rows where round_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
998 998 2010-07-01 86 FIRST_NEARBY 6 50000 480238 480240
999 999 2010-07-01 86 FIRST 1 2000000 480239
1000 1000 2010-07-01 86 SECOND 2 100000 153891 338552 417257 468232 927635
1001 1001 2010-07-01 86 THIRD 3 40000 100417 428294 447409 591687 623276 683005 752156 822357 888260 980816
1002 1002 2010-07-01 86 FOURTH 4 20000 000596 002099 009075 021799 031999 048361 069373 103418 181667 196656 198407 216403 218458 232806 234384 251810 255211 310359 326941 332064 334222 353346 393025 424560 434632 454329 535883 537317 540077 543758 572961 574580 582860 593989 660883 671018 687231 690522 692635 693012 749141 757224 777018 831608 834544 835295 843546 846313 920777 935949
1003 1003 2010-07-01 86 FIFTH 5 10000 002787 032408 037130 046974 056152 063282 077860 097056 098401 117053 120272 122734 131176 149062 153836 155909 159329 168764 169637 178949 179394 180657 183136 203571 210989 213264 217470 243067 263986 284651 285251 300480 308037 311661 315548 322354 333429 339404 342955 346478 389573 398882 402074 408682 418055 423533 431733 448711 497500 504550 512351 532911 540641 542013 542918 544941 572197 579417 593327 612381 615319 621257 629928 630367 641607 655207 656954 671492 671637 679519 681724 687366 691805 703201 710916 734079 764631 767087 771366 781136 782457 786891 792647 835693 846816 849459 860967 870979 873470 879015 881008 889060 899687 913923 923957 929644 942967 945210 961497 991925
1004 1004 2010-07-01 86 TWO 9 1000 68
1005 1005 2010-07-01 86 THREE 7 2000 450 893 918 961

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