researcher_contact

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

2 rows where author_id = "openalex:A5084344697"

✎ 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:374dda0674f1ac49fea0 openalex:A5084344697 email c.d.venditti@reading.ac.uk Academic email listed https://www.reading.ac.uk/ecology/staff/chris-venditti 2026-09-07  
contact:52f47dbb917c70018b9b openalex:A5084344697 academic_website https://www.reading.ac.uk/ecology/staff/chris-venditti Reading faculty profile listed https://www.reading.ac.uk/ecology/staff/chris-venditti 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);