sc_version_detail (view)

5 rows where "appointment-date" is on date 2010-01-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: _commit_at, _commit_hash, _commit, _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 60 60 1 938 Mr George Lim Teong Jin 0 0 0 Wee Tay & Lim LLP LPA,S30(1) 2010-01-09 4d528f909e1a13f6e1df04f3e2fc19837c45855f 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 61 61 1 938 Deputy Presiding Judge Ms Jennifer S Marie 0 0 0 State Courts LPA,S30(1) 2010-01-09 ad3d1e5e3a00c8fb0c482f18c92938ac01486b45 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 62 62 1 938 Justice Andre Francis Maniam 0 0 0 Supreme Court LPA,S30(1) 2010-01-09 ad820b5e6304c0508b67d1c465659708d41710af 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 63 63 1 938 Dr Stanley Lai Tze Chang 0 0 0 Allen & Gledhill LLP LPA,S30(1) 2010-01-09 3e60343ea29cc6c6ada3e8c20901c7bc947b61ba 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-10-09T21:11:35+00:00 38b750810ebc757433f7641ea69d6fba319e193e 102 99 1 939 Ms Jennifer S Marie 0 0 0 National University of Singapore LPA,S30(1) 2010-01-09 b80262690857b8078956db1d264c193797ee70aa 
[
    "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;