home / thai-lottery

Prize

8 rows where round_id = 185

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ round_id prize_id amount keys
107 107 2014-09-01 185 FIRST_NEARBY 6 50000 856762 856764
108 108 2014-09-01 185 FIRST 1 2000000 856763
109 109 2014-09-01 185 SECOND 2 100000 185941 706459 739526 980798 589750
110 110 2014-09-01 185 THIRD 3 40000 202792 130608 049776 814585 914865 448757 869760 116517 567666 329145
111 111 2014-09-01 185 FOURTH 4 20000 876276 623571 151624 823423 932531 694065 210773 307815 430101 278214 451580 522322 631759 561465 498895 212527 149623 032786 450968 871744 741133 812561 154902 349381 018033 644399 088554 562748 377469 779585 233575 086368 206553 700012 103741 895921 715921 845442 040527 149286 030067 998338 324640 396186 486047 418378 976434 023018 463502 466200
112 112 2014-09-01 185 FIFTH 5 10000 967293 972890 510843 794279 562558 293745 876991 688832 595552 026501 299870 978695 282254 763818 555623 123529 481873 237788 914753 558154 951258 877431 960398 699977 327906 850996 979283 330065 984278 512562 180593 515092 771653 096948 910520 168032 371821 398546 915774 493385 632866 783738 412953 242467 097154 069248 224470 680702 344069 459146 818700 616334 234077 485569 823482 684343 133836 310931 264838 046108 307592 447220 097026 860573 750799 167536 639071 882480 078135 799848 206979 526420 311621 853919 408630 946886 577567 581788 274400 657938 866313 266732 733034 628777 387554 645519 850874 514863 306313 289417 129749 062417 310615 464855 113670 456275 657762 404025 001437 472775
113 113 2014-09-01 185 TWO 9 1000 22
114 114 2014-09-01 185 THREE 7 2000 308 912 477 490

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)
);
Powered by Datasette · Queries took 20.747ms