paper_author_affiliation

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

14,099 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: seq

Next page

CREATE TABLE paper_author_affiliation (
  lom_id     TEXT NOT NULL,
  author_id  TEXT NOT NULL,
  seq        INTEGER NOT NULL CHECK (seq >= 1),
  raw        TEXT NOT NULL,
  ror        TEXT,
  PRIMARY KEY (lom_id, author_id, seq),
  FOREIGN KEY (lom_id, author_id) REFERENCES paper_author(lom_id, author_id)
);