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?isni=showallwith

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

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

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

SQL query results

Date	Person	ISNI	Human	ISNI and Human	IPI	ISNI or IPI	ISNI and IPI
2015-01-29	5057	849	4927	834	2130	2308	671