sc_version_detail (view)

8 rows where "appointment-date" is on date 1998-01-10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, judge-of-appeal, 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 16 16 1 938 Mr Chelva Retnam Rajah 0 0 0 Tan Rajah & Cheah LPA,S30(1) 1998-01-10 c7bd68be810fd5197889753a139614e6ed8694a2 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 17 17 1 938 Mr Sarjit Singh Gill 0 0 0 Shook Lin & Bok LLP LPA,S30(1) 1998-01-10 c1d173af652753b941ca64c7380c41e923814473 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 18 18 1 938 Justice Belinda Ang Saw Ean 0 0 0 Supreme Court LPA,S30(1) 1998-01-10 ce20bf1b3398ab92ae8e0e0f89a07204ed5b9720 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 19 19 1 938 Ms Engelin Teh Guek Ngor 0 0 0 Engelin Teh Practice LLC LPA,S30(1) 1998-01-10 890a16312eeba601eb0d9e03c1becd37d3b7b088 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 20 20 1 938 Ms Molly Lim Kheng Yan 0 0 0 Wong Tan & Molly Lim LLC LPA,S30(1) 1998-01-10 64f37ee0657b00764f28a285226525fbcfb48a6f 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 21 21 1 938 Justice Steven Chong Horng Siong 1 0 0 Supreme Court LPA,S30(1) 1998-01-10 20e635294c66fe8bc1b96a64fad87660780a6c04 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 22 22 1 938 Mr Jimmy Yim Wing Kuen 0 0 0 Drew & Napier LLC LPA,S30(1) 1998-01-10 d7329cd88ddaeaec70f8e164979efcda51c2a9bc 
[
    "honoris-causa",
    "title",
    "name",
    "organisation",
    "deceased",
    "appointment-provision",
    "appointment-date",
    "judge-of-appeal"
]
2023-09-30T12:18:51+08:00 828371cb952509c6b6a05107413672ca2a63e02d 23 23 1 938 Mr K Shanmugam 0 0 0 Ministry of Home Affairs and Ministry of Law LPA,S30(1) 1998-01-10 e0ab88bc9419c6c84a643a83594e22299d1c8c6f 
[
    "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;