Tango.info person ISNI: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 18: Line 18:
* 2618 have an ISNI or IPI or Todotango ID
* 2618 have an ISNI or IPI or Todotango ID
* 370 have an ISNI and Todotango ID
* 370 have an ISNI and Todotango ID
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-Z][a-z]{4}[A-Z][a-z]{4}'
UNION ALL
SELECT count(*)
FROM  `ti_person`
WHERE isni <> ''
UNION ALL
SELECT count(*)
FROM  `ti_person`
WHERE ipi <> ''
UNION ALL
SELECT count(*)
FROM  `ti_person`
WHERE ipi <> '' and isni <> ''
{| class="wikitable sortable"
! style="width:80px" | Date
! Person
! Human
! ISNI
! IPI
! ISNI+IPI
|-
| 2015-01-29 || 5057 || 4927 || 849 || 2130 || 671
|}

Revision as of 2015-01-29T06:54:40

Overview

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

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


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-Z][a-z]{4}[A-Z][a-z]{4}'

UNION ALL

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

UNION ALL

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

UNION ALL

SELECT count(*) 
FROM  `ti_person` 
WHERE ipi <>  and isni <> 
Date Person Human ISNI IPI ISNI+IPI
2015-01-29 5057 4927 849 2130 671