researcher_contact

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

4 rows where author_id = "openalex:A5033896011"

✎ 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:0438d84d9d85b2584ce9 openalex:A5033896011 github https://github.com/semmypurewal GitHub listed https://semmy.me/ 2026-09-07  
contact:40e88e7525e5e33344de openalex:A5033896011 personal_website https://semmy.me/ Personal website listed https://semmy.me/ 2026-09-07  
contact:7806969b06e3d9e214f6 openalex:A5033896011 email tspurewal@gmail.com Published correspondence email historical https://www.cs.umd.edu/~gasarch/COURSES/858/S13/grid.pdf 2026-09-07 Author-supplied correspondence address in a historical grid-paper manuscript (2013 course archive); present use is unverified.
contact:e7562ddb59acfd5a742e openalex:A5033896011 linkedin https://www.linkedin.com/in/semmypurewal/ LinkedIn listed https://semmy.me/ 2026-09-07 Linked directly from his personal website.

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