Tango.info person ISNI: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 1: | Line 1: | ||
==Overview== | ==Overview== | ||
Each [[tango.info person]] that has an [[ISNI]] in the tango.info database can be seen at: | Each [[tango.info person]] that has an [[ISNI]] in the tango.info database can be seen at: | ||
* https://tango.info/persons? | * https://tango.info/persons?q=has_isni | ||
==Working with ISNI to improve ISNI data== | ==Working with ISNI to improve ISNI data== |
Revision as of 2015-01-30T01:07:54
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
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 |