Tango.info person ISNI: Difference between revisions
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 |