Prize

8 rows where round_id = 175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
196 196 2014-04-01 175 FIRST_NEARBY 6 50000 028865 028867
197 197 2014-04-01 175 FIRST 1 2000000 028866
198 198 2014-04-01 175 SECOND 2 100000 183830 295971 765754 780617 924161
199 199 2014-04-01 175 THIRD 3 40000 204032 296733 325056 392234 464872 501806 592290 656343 948476 958103
200 200 2014-04-01 175 FOURTH 4 20000 021585 063422 082607 083364 097891 136902 208935 214134 230010 233002 248563 262898 284845 310090 329687 332698 361414 378660 386406 389013 442353 461841 483363 501985 523398 589255 601008 643866 646816 663426 671585 675736 684293 736323 738075 747768 755385 762418 777032 798038 813686 827564 853640 869144 872347 903997 911726 928218 936076 961887
201 201 2014-04-01 175 FIFTH 5 10000 008174 016882 038104 047901 052621 053679 061233 062291 065951 072683 078923 078979 091434 099644 109222 129335 139167 145462 187227 193366 195134 209744 219880 220139 221179 223146 225993 259294 260044 264037 266082 272306 282710 320254 322936 326874 328949 350222 359586 366442 373356 377816 378102 386258 392717 394599 405363 407004 407664 411529 417985 432042 432197 472487 473113 476711 485310 486177 491034 502160 503428 512707 517327 522542 531066 538755 548689 548734 566407 582637 605525 619459 636298 643103 651657 687349 689439 701068 738284 754711 757443 770242 775204 782444 787652 801054 812448 833935 834253 849129 857823 858478 891605 909385 913405 927311 939220 986535 997062 999101
202 202 2014-04-01 175 TWO 9 1000 95
203 203 2014-04-01 175 THREE 7 2000 186 499 835 938

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