Tango.info person ISNI

Overview

Each tango.info person that has an ISNI in the tango.info database can be seen at:

• https://tango.info/persons?q=has_isni

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 ISNI DB.

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 isni <> ""

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE CAST(person_code AS BINARY) REGEXP '[A-Z][a-z]{4}[A-Z][a-z]{4}'

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE 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 ipi <> ""

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE isni <> "" OR ipi <> ""

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE isni <> "" AND ipi <> ""

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE 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
2015-01-29	5057	849	4927	834	2130	2308	671	2689