Prize

8 rows where round_id = 70

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1342 1342 2009-11-01 70 FIRST_NEARBY 6 50000 689139 689141
1343 1343 2009-11-01 70 FIRST 1 2000000 689140
1344 1344 2009-11-01 70 SECOND 2 100000 106979 375433 467651 551213 937347
1345 1345 2009-11-01 70 THIRD 3 40000 117399 235650 243283 298371 442709 759098 760944 810250 864237 889071
1346 1346 2009-11-01 70 FOURTH 4 20000 019208 023199 027258 063332 071255 074081 082901 102353 130691 182411 184934 199455 241907 243682 272759 277504 301204 374404 380827 380849 430440 447700 453010 505031 510752 538798 539804 557070 587489 593785 606218 657263 729862 736227 765118 767073 793261 814342 836414 838212 842545 846464 867492 871522 882741 884802 936066 962945 969550 991211
1347 1347 2009-11-01 70 FIFTH 5 10000 008927 015742 016308 022033 031858 035992 045678 061672 063039 067509 073382 084870 099824 110038 127411 129103 130517 133452 147724 155334 156956 167273 190479 196876 197386 205696 209392 224174 229419 239865 247511 252950 269468 277951 292123 294308 294441 308215 319219 332186 345065 361432 364809 394809 397785 398312 399326 406222 417559 426789 430744 431390 435811 453741 454195 464971 490184 500390 511705 513130 538817 574012 579246 589904 605616 637586 647361 648297 668704 679670 687829 713221 741029 743134 758291 776352 777287 820104 853271 853499 858752 867666 898999 900193 902615 905406 905757 908347 919552 923312 936053 939289 945232 953686 955877 977389 979313 989340 995166
1348 1348 2009-11-01 70 TWO 9 1000 85
1349 1349 2009-11-01 70 THREE 7 2000 366 465 642 923

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