Custom SQL query

hksfcactivities

actType, actDesc, cactDesc

10 rows

hksfclicenceholders

ceref, nameenglish, namechinese

110,032 rows

hksfclicenceinstitutions

princeref, princename, princenamechin, mineffdate

4,617 rows

hksfclicences

nameenglish, ceref, timestamp, indieo, actType, actDesc, cactDesc, effDate, status...

Many rows

hksfclicencesraw

nameenglish, namechinese, ceref, jsoninfo, timestamp, indieo

110,501 rows

hksfcprincipalsdetails

princeref, addresses, emails, websites, timestamp

4,497 rows

... and 10 hidden tables