sc_version_detail (view)

6 rows where "appointment-date" is on date 2008-01-05

✎ 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 49 49 1 938 Professor Jeffrey Dan Pinsler 0 0 0 National University of Singapore LPA,S30(1) 2008-01-05 c8c00044742129bc367e05ee43a55192fe164e54 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 50 50 1 938 Chief Justice Sundaresh Menon 0 0 0 Supreme Court LPA,S30(1) 2008-01-05 353d88f352c9b4929e00d17b58d16815876d1347 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 51 51 1 938 Deputy Attorney-General Hri Kumar Nair 0 0 0 Attorney-General's Chambers LPA,S30(1) 2008-01-05 3fde4fcf05d1085360ef69adcf6c78bc1f4a3a2f 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 52 52 1 938 Mr Thio Shen Yi 0 0 0 TSMP Law Corporation LPA,S30(1) 2008-01-05 6703eb81f40d3e254dca72cfb3f750df88080644 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 53 53 1 938 Mr Cavinder Bull 0 0 0 Drew & Napier LLC LPA,S30(1) 2008-01-05 8889234085952aa1e5ee20e70a41bc6c7c248af2 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 54 54 1 938 Mr Lee Eng Beng 0 0 0 Rajah & Tann Singapore LLP LPA,S30(1) 2008-01-05 cec18ad98c54906a41f548c82cf4d26fa5c0b7d7 
[
    "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;