sc_version_detail (view)

5 rows where "appointment-date" is on date 2003-01-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: _commit_at, _commit_hash, _commit, title, organisation, _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 35 35 1 938 Mr Lim Teong Qwee 0 0 0   LPA,S30(1) 2003-01-04 8097544a91a4813c25e5fc254f74fd63d1a83b0d 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 36 36 1 938 Mr Andre Yeap Poh Leong 0 0 0 Rajah & Tann Singapore LLP LPA,S30(1) 2003-01-04 2bec31071ae92ce8d02bc8d1c88bda832ac1e44e 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 37 37 1 938 Ms Indranee Thurai Rajah 0 0 0 Prime Minister's Office, Ministry of National Development and Ministry of Finance LPA,S30(1) 2003-01-04 5aaf237a7dffc4feffee62e151278f211a12a58a 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 38 38 1 938 Justice Philip Anthony Jeyaretnam 0 0 0 Supreme Court LPA,S30(1) 2003-01-04 69134ba194fcae621075981cb985b7704aeaa850 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2025-01-27T21:07:57+00:00 d5fcb2dfa6c5f8912d3054f282dee76934c519ef 129 103 1 946 Justice Philip Jeyaretnam 0 0 0 Supreme Court LPA,S30(1) 2003-01-04 dc25efe0cd9c870307c7b79e944cd5e52d3fcac0 
[
    "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;