Tango.info person ISNI

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

• https://tango.info/persons?q=has_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 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