sc_version_detail (view)

12 rows where "appointment-date" is on date 1997-01-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, deceased, _commit_at (date), appointment-date (date), _changed_columns (array)

_commit_at _commit_hash _id _item _version _commit title name judge-of-appeal honoris-causa deceased organisation appointment-provision appointment-date _item_full_hash _changed_columns
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 4 4 1 938 Mr Joseph Grimberg 0 0 1   LPA,S30(1) 1997-01-04 ccc99dc7fb2360ff3c331e3f2aafa198ce1645bd 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 5 5 1 938 Mr Kasinather Saunthara Rajah 0 0 1   LPA,S30(1) 1997-01-04 3f15ac8aa0aaf84a9a4f624c4d75d0d08d223270 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 6 6 1 938 Dr Sydney Michael Hwang 0 0 0 Michael Hwang Chambers LLC LPA,S30(1) 1997-01-04 3c0e034efe5130c3985718999c4ffb74408736c5 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 7 7 1 938 Mr Harry Elias 0 0 1   LPA,S30(1) 1997-01-04 6ae52301783da6dc6f2405193cc8d198faef70b2 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 8 8 1 938 Mr Giam Chin Toon 0 0 0 Wee Swee Teow LLP LPA,S30(1) 1997-01-04 a283309b9faf4839092d5092f070059ce15f642a 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 9 9 1 938 Mr Michael Khoo Kah Lip 0 0 0 Michael Khoo & Partners LPA,S30(1) 1997-01-04 a771ccb80b0963a684362983cdd968408af5df46 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 10 10 1 938 Mr Tan Kok Quan 0 0 0 RWong Law Corporation LPA,S30(1) 1997-01-04 231bbc6c1c8b82fbfea186ea8ace1ac00278373c 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 11 11 1 938 Mr Wong Meng Meng 0 0 0 WongPartnership LLP LPA,S30(1) 1997-01-04 651dc1e7a926f130dc7b2f6c2d973ad644a9f6ef 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 12 12 1 938 Justice Woo Bih Li 0 0 0 Supreme Court LPA,S30(1) 1997-01-04 f0c4ec5631940acdc602fd82a09e8d1f914fa2c3 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 13 13 1 938 Mr V K Rajah 0 0 0 V K Rajah LLC LPA,S30(1) 1997-01-04 ecaa5db178390c6e5a57835462f8b8c437007fcb 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 14 14 1 938 Mr Davinder Singh 0 0 0 Davinder Singh Chambers LPA,S30(1) 1997-01-04 a799875620adec44e480f0ac6d7f3719910f6044 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 15 15 1 938 Mr Kenneth Michael Tan Wee Kheng 0 0 0 Kenneth Tan Partnership LPA,S30(1) 1997-01-04 bd32638a079e0ee6ad954058c40f079a6386277d 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW sc_version_detail AS select
  commits.commit_at as _commit_at,
  commits.hash as _commit_hash,
  sc_version.*,
  (
    select json_group_array(name) from columns
    where id in (
      select column from sc_changed
      where item_version = sc_version._id
    )
) as _changed_columns
from sc_version
  join commits on commits.id = sc_version._commit;