researcher_contact

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 ▼ author_id kind value label status source_url checked_ts note
contact:5e684c61deb23daafd00 openalex:A5118452825 bluesky https://bsky.app/profile/rachel-hurwitz.bsky.social Bluesky listed https://www.anthro.ox.ac.uk/people/rachel-hurwitz 2026-09-07 Handle explicitly listed on her Oxford profile.
contact:6129dc46a14687e5c31e openalex:A5118452825 academic_website https://www.anthro.ox.ac.uk/people/rachel-hurwitz Oxford researcher profile listed https://www.anthro.ox.ac.uk/people/rachel-hurwitz 2026-09-07  

Advanced export

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

CSV options: 

CREATE TABLE researcher_contact (
  id TEXT PRIMARY KEY,
  author_id TEXT NOT NULL REFERENCES author(author_id),
  kind TEXT NOT NULL CHECK(kind IN ('email','academic_website','personal_website','linkedin','github','google_scholar','bluesky','blog','researchgate')),
  value TEXT NOT NULL,
  label TEXT NOT NULL,
  status TEXT NOT NULL CHECK(status IN ('listed','historical')),
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL,
  note TEXT,
  UNIQUE(author_id,kind,value)
);
CREATE INDEX researcher_contact_author ON researcher_contact(author_id);