research_affiliation

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

5 rows where institution_id = "I102149020"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: lom_id, source_url, checked_ts (date)

Link lom_id author_id institution_id source_url checked_ts
doi:10.1016/j.leaqua.2025.101895,openalex:A5049583849,I102149020 doi:10.1016/j.leaqua.2025.101895 openalex:A5049583849 I102149020 https://openalex.org/W4412046765 2026-09-07T04:02:12Z
doi:10.1016/j.leaqua.2025.101895,openalex:A5052595540,I102149020 doi:10.1016/j.leaqua.2025.101895 openalex:A5052595540 I102149020 https://openalex.org/W4412046765 2026-09-07T04:02:12Z
doi:10.18653/v1/2021.gem-1.10,openalex:A5039347651,I102149020 doi:10.18653/v1/2021.gem-1.10 openalex:A5039347651 I102149020 https://openalex.org/W3186655327 2026-09-07T04:02:12Z
doi:10.18653/v1/2021.gem-1.10,openalex:A5079742046,I102149020 doi:10.18653/v1/2021.gem-1.10 openalex:A5079742046 I102149020 https://openalex.org/W3186655327 2026-09-07T04:02:12Z
doi:10.18653/v1/2021.gem-1.10,openalex:A5083688498,I102149020 doi:10.18653/v1/2021.gem-1.10 openalex:A5083688498 I102149020 https://openalex.org/W3186655327 2026-09-07T04:02:12Z

Advanced export

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

CSV options: 

CREATE TABLE research_affiliation (
  lom_id TEXT NOT NULL,
  author_id TEXT NOT NULL,
  institution_id TEXT NOT NULL REFERENCES institution(id),
  source_url TEXT NOT NULL,
  checked_ts TEXT NOT NULL,
  PRIMARY KEY (lom_id, author_id, institution_id),
  FOREIGN KEY (lom_id, author_id) REFERENCES paper_author(lom_id, author_id)
);
CREATE INDEX research_affiliation_author ON research_affiliation(author_id);
CREATE INDEX research_affiliation_institution ON research_affiliation(institution_id);