sc_version_detail (view)

6 rows where "appointment-date" is on date 2009-01-03

✎ 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 56 56 1 938 Mr Jeffrey Chan Wah Teck 0 0 0 TSMP Law Corporation LPA,S30(1) 2009-01-03 5d0e0e2f25274fc57a724fe444779e338964b3fc 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 57 57 1 938 Mr David Chong Gek Sian 0 0 0 Attorney-General's Chambers LPA,S30(1) 2009-01-03 e94c488c6e968382020b5d0934e346222ec55173 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 58 58 1 938 Mr Francis Xavier s/o Subramaniam Xavier Augustine 0 0 0 Rajah & Tann Singapore LLP LPA,S30(1) 2009-01-03 e545e2a056a4323099456bc383321cb66cd89499 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 59 59 1 938 Deputy Attorney-General Ang Cheng Hock 0 0 0 Attorney-General's Chambers LPA,S30(1) 2009-01-03 b412d431c05c6824e4f70dc43dfff8fe718d0474 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2025-05-05T21:08:01+00:00 bec3e4ad3da18b480eb70d11d3c72cc5c71477c6 142 104 1 1186 Justice ANG Cheng Hock SC 0 0 0 Supreme Court LPA,S30(1) 2009-01-03 20f8e8cadd36f83521b35d1c67a53834e3dd2489 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2025-05-19T21:08:04+00:00 fd85f11b2bd0fa87c647118c6a8ac9eb18904912 143 105 1 1187 Justice ANG Cheng Hock 0 0 0 Supreme Court LPA,S30(1) 2009-01-03 1031e397bc01efb3f8532f919959a6e7d0a92670 
[
    "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;