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

Subpages:

• Tango.info person ISNI data improvement
  • Tango.info person ISNI assignment
  • Tango.info person ISNI data merge

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
2015-06-10	5375	912	5241	894	2439	2634	717	3008
2015-06-12	5422	972	5243	909	2440	2681	731	3055
2015-06-16	5441	977	5262	914	2459	2700	736	3074
2015-06-17	5489	988	5310	925	2505	2746	747	3122
2015-06-19	5535	993	5356	930	2551	2792	752	3168
2015-06-22	5537	995	5358	932	2553	2794	754	3170