sc_version_detail (view)

4 rows where "appointment-date" is on date 1999-01-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, _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 24 24 1 938 Mr Goh Phai Cheng 0 0 0 Goh Phai Cheng LLC LPA,S30(1) 1999-01-09 c6416c1fb5f1ce9dd61a9d34505e385c0e8eebfa 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 25 25 1 938 Justice Quentin Loh Sze On 0 0 0 Supreme Court LPA,S30(1) 1999-01-09 470eb4b1ca5c8c1bf091b1d85e3e09d5d2b72bd8 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 26 26 1 938 Mr Christopher Lau Loke Sam 0 0 0 Christopher Lau LPA,S30(1) 1999-01-09 62259d600e9adfa9377dd6c901061ddc4d3c99e2 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 27 27 1 938 Mr Tan Tee Jim 0 0 0 Lee & Lee LPA,S30(1) 1999-01-09 c55aa84d6315da916ae101c1ac248a74f9d0acf1 
[
    "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;