home / cccc

affiliation_matches

Each distinct printed affiliation and how it was matched. ror-affiliation-top and ror-chosen-refused rows record a guess that was not accepted.

Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits

10 rows where method = "ror-affiliation-top:01qrt2s96"

✎ View and edit SQL

This data as json, CSV (advanced)

method 1

  • ror-affiliation-top:01qrt2s96 · 10 ✖
Link rowid ▼ affiliation_as_printed institution_id method score
709 709 CUNY Queens College, Flushing, NY   ror-affiliation-top:01qrt2s96 1.0
732 732 CUNY-Queens College, Flushing, NY   ror-affiliation-top:01qrt2s96 1.0
733 733 CUNY-Queens College, NY   ror-affiliation-top:01qrt2s96 1.0
4670 4670 Queens College   ror-affiliation-top:01qrt2s96 1.0
4671 4671 Queens College CUNY   ror-affiliation-top:01qrt2s96 1.0
4680 4680 Queens College, Flushing, NY   ror-affiliation-top:01qrt2s96 1.0
4681 4681 Queens College, New York, NY   ror-affiliation-top:01qrt2s96 1.0
4684 4684 Queens College-CUNY, NY   ror-affiliation-top:01qrt2s96 1.0
4686 4686 Queens College/CUNY   ror-affiliation-top:01qrt2s96 1.0
4687 4687 Queens College/CUNY, Flushing   ror-affiliation-top:01qrt2s96 1.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE affiliation_matches (affiliation_as_printed TEXT, institution_id TEXT, method TEXT, score REAL);
CREATE INDEX ix_affiliation_matches_institution_id ON affiliation_matches(institution_id);
Powered by Datasette · Queries took 19.643ms · Data license: CC BY 4.0 (data), MIT (code) · Data source: Source code, methods and known limits