Tango.info person ISNI: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 19: | Line 19: | ||
* to fix names in the ISNI DB | * to fix names in the ISNI DB | ||
Some of the work can be seen at the page [[Tango.info person | Some of the work can be seen at the page [[Tango.info person ISNI data improvement]]. | ||
==Statistics== | ==Statistics== |
Revision as of 2015-06-10T16:52:19
Overview
A tango.info person can have one ISNI. If several ISNI for one identity exist, the canonical ISNI should be the one that is connected with the person in tango.info.
Lists
ISNI
ISNI, IPI
- https://tango.info/persons?q=has_isni_or_ipi
- https://tango.info/persons?q=has_isni_and_ipi
- https://tango.info/persons?q=has_not_isni_and_has_ipi
ISNI, IPI, SADAIC ID
- https://tango.info/persons?q=has_not_isni_and_has_ipi_and_sadaic_id
- https://tango.info/persons?q=has_isni_or_ipi_or_sadaic_id
Working with ISNI to improve ISNI data
Tango.info is working with members of the ISNI Quality Team:
- to improve the coverage of tango items with ISNI codes and
- to merge duplicates of tango items within the ISNI DB and
- to fix names in the ISNI DB
Some of the work can be seen at the page Tango.info person ISNI data improvement.
Statistics
SQL query
SELECT date(CURRENT_TIMESTAMP()) UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND isni <> "" UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND CAST(person_code AS BINARY) REGEXP '[A-Z][a-z]{4}[A-Z][a-z]{4}' UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND isni <> "" AND CAST(person_code AS BINARY) REGEXP '[A-Z][a-z]{4}[A-Z][a-z]{4}' UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND ipi <> "" UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND (isni <> "" OR ipi <> "") UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND isni <> "" AND ipi <> "" UNION ALL SELECT count(*) FROM `ti_person` WHERE CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}' AND (isni <> "" OR ipi <> "" OR todotango <> "" OR sadaic_pn <> "")
SQL query results
As of 2014-12-09 there are 5025 person items in tango.info, of these:
- 473 have an ISNI
- 2159 have an ISNI or IPI
- 1839 have a Todotango ID
- 2618 have an ISNI or IPI or Todotango ID
- 370 have an ISNI and Todotango ID
Date | Person | ISNI | Human | ISNI and Human | IPI | ISNI or IPI | ISNI and IPI | ISNI or IPI or Todotango ID or SADAIC ID |
---|---|---|---|---|---|---|---|---|
2014-12-09 | - | 473 | - | - | - | 2159 | - | - |
2015-01-29 | 5057 | 849 | 4927 | 834 | 2130 | 2308 | 671 | 2689 |
2015-02-01 | 5074 | 850 | 4944 | 835 | 2144 | 2322 | 672 | 2705 |
2015-02-05 | 5076 | 866 | 4946 | 848 | 2147 | 2334 | 679 | 2711 |
2015-06-01 | 5264 | 889 | 5130 | 871 | 2325 | 2520 | 694 | 2894 |
2015-06-07 | 5351 | 898 | 5217 | 880 | 2415 | 2610 | 703 | 2984 |
2015-06-10 | 5371 | 903 | 5237 | 885 | 2435 | 2630 | 708 | 3004 |