researcher_contact

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

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: checked_ts (date)

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