paper_author_affiliation

Paper-time affiliations[] replay. Multiple rows per author so dual prints (Hajishirzi UW+AI2) survive.

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

8 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_id, seq, raw, ror

Link lom_id author_id seq raw ror
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5001778694,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5001778694 1 Allen Institute for Artificial Intelligence, Seattle, WA, USA https://ror.org/05w520734
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5037862554,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5037862554 1 University of Washington, Seattle, WA, USA https://ror.org/00cvxb145
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5048135392,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5048135392 1 University of Washington, Seattle, WA, USA https://ror.org/00cvxb145
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5053129557,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5053129557 1 Allen Institute for Artificial Intelligence, Seattle, WA, USA https://ror.org/05w520734
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5064858748,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5064858748 1 Allen Institute for Artificial Intelligence, Seattle, WA, USA https://ror.org/05w520734
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5066588555,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5066588555 1 Allen Institute for Artificial Intelligence, Seattle, WA, USA https://ror.org/05w520734
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5082305994,1 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5082305994 1 University of Washington, Seattle, WA, USA https://ror.org/00cvxb145
doi:10.18653/v1/2020.emnlp-main.609,openalex:A5082305994,2 doi:10.18653/v1/2020.emnlp-main.609 openalex:A5082305994 2 Allen Institute for Artificial Intelligence, Seattle, WA, USA https://ror.org/05w520734

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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