Prize

8 rows where round_id = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
1666 1666 2008-04-16 34 FIRST_NEARBY 6 50000 982799 982801
1667 1667 2008-04-16 34 FIRST 1 2000000 982800
1668 1668 2008-04-16 34 SECOND 2 100000 150056 307485 623373 772113 983890
1669 1669 2008-04-16 34 THIRD 3 40000 043089 055612 112855 194447 324196 374313 441536 590647 603436 913450
1670 1670 2008-04-16 34 FOURTH 4 20000 020987 045380 047598 082633 085001 098311 103878 121307 126954 185771 193425 256122 257701 282422 302960 314718 329169 379534 396641 401630 402092 409359 415338 439335 440133 448190 457069 478254 505912 528219 541798 598625 616632 619377 630136 658054 669365 725552 747019 765941 781634 795299 796356 824146 826081 827955 853300 884500 906637 945977
1671 1671 2008-04-16 34 FIFTH 5 10000 011112 045443 058013 062453 071752 079272 084757 091199 095570 136876 142531 152396 163372 171915 188079 196855 202204 216482 218593 218937 221017 224066 231675 260377 268589 273350 277049 295794 302895 306287 306530 323922 328924 335448 342841 347506 347785 357944 361953 370303 376785 383552 388418 401252 402465 408528 442345 447202 456387 466667 488196 490511 503566 512249 541371 544624 545952 549118 551180 564963 565173 610942 614192 616836 659083 669743 671456 672611 673059 676303 677844 683095 696541 705355 712258 735142 741648 743084 757616 758845 779273 787497 789713 790600 794414 813715 832331 834098 848001 850346 851561 853188 886344 907155 909803 917900 926331 944110 944735 990155
1672 1672 2008-04-16 34 TWO 9 1000 64
1673 1673 2008-04-16 34 THREE 7 2000 008 043 584 802

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