researcher_contact

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

3 rows where author_id = "openalex:A5111848148"

✎ 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:94cdc42616bcdc73a2fc openalex:A5111848148 academic_website https://sc.edu/study/colleges_schools/engineering_and_computing/faculty-staff/stephenfenner.php South Carolina faculty profile listed https://cse.sc.edu/~fenner/ 2026-09-07  
contact:cbaf0196b1af2880b3cc openalex:A5111848148 personal_website https://cse.sc.edu/~fenner/ Personal academic website listed https://cse.sc.edu/~fenner/ 2026-09-07  
contact:ea204141c7dbebe692e3 openalex:A5111848148 email fenner@cse.sc.edu Academic email listed https://cse.sc.edu/~fenner/ 2026-09-07 Address explicitly spelled out on his personal faculty page, updated August 2026.

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);