Custom SQL query

disclosures

listedexchange, surname, dateaware, previousserialnumber, s317info, brnumber, dependentinformation, formserialnumber, before...

Many rows

disclosurespositions

formserialnumber, position, before_number, after_number, change_number, before_percent, after_percent, change_percent, before_percent_calculated...

Many rows

hkexcodes

code, description, type

504 rows

hkexdirectors

companynameenglish, companynamechinese, stock_code, listingstatus, directornameenglish, directornamechinese, capacity, position, appointmentdate...

Many rows

hkexdisclosuresraw

listedexchange, surname, dateaware, previousserialnumber, s317info, brnumber, dependentinformation, formserialnumber, before...

Many rows

listedcorporations

id, value

5,470 rows

shareholders

id, value

Many rows

... and 10 hidden tables