author

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

73 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE author (
  author_id     TEXT PRIMARY KEY,
  openalex      TEXT,
  orcid         TEXT,
  display_name  TEXT NOT NULL
);
CREATE UNIQUE INDEX author_openalex ON author(openalex) WHERE openalex IS NOT NULL;
CREATE UNIQUE INDEX author_orcid ON author(orcid) WHERE orcid IS NOT NULL;