lab_membership

Data license: Space charter; records cite primary sources · Data source: TeamScience Space repository

2 rows where author_id = "openalex:A5118452825"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: checked_ts (date)

id ▼ lab_id author_id role status period source_url checked_ts note
membership:37c1f72c4f0b13a77e65 Skeletal Biology Laboratory michigan-skeletal-biology openalex:A5118452825 Undergraduate researcher historical 2018 https://sites.lsa.umich.edu/devlin-lab/lab-members/ 2026-09-07 Matched using the Oxford biography’s Michigan degree year and undergraduate research history.
membership:641dedcf611d8ab58151 Multicenter Perioperative Outcomes Group michigan-mpog openalex:A5118452825 Former clinical researcher historical Before Oxford MSc (2023) https://www.sjc.ox.ac.uk/alumni/sjc-womens-network/sjc-womens-network-enewsletters/sjc-womens-network-enewsletter-july-2025/introducing-rachel-hurwitz/ 2026-09-07  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lab_membership (
  id TEXT PRIMARY KEY,
  lab_id TEXT NOT NULL REFERENCES research_lab(id),
  author_id TEXT NOT NULL REFERENCES author(author_id),
  role TEXT NOT NULL,
  status TEXT NOT NULL CHECK(status IN ('reported','historical','forming')),
  period TEXT,
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL,
  note TEXT,
  UNIQUE(lab_id,author_id,source_url)
);
CREATE INDEX lab_membership_author ON lab_membership(author_id);