sc_version_detail (view)

2 rows where "appointment-date" is on date 2025-01-13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: _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
2025-01-13T21:07:46+00:00 5bbd7b6dd502885b358c5e14e7463b7b5187a68f 127 101 1 945 Ms Hing Shan Shan Blossom 0 0 0 Drew & Napier LLC LPA, S30(1) 2025-01-13 bc5ae3a8379c9647d98d200f116bd73c9bf945be 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2025-01-13T21:07:46+00:00 5bbd7b6dd502885b358c5e14e7463b7b5187a68f 128 102 1 945 Mr Christopher Ong Siu Jin 0 0 0 Attorney-General's Chambers LPA, S30(1) 2025-01-13 13c03f64f8caa13d84bea4dfc7138347929bb24d 
[
    "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;