Tango.info person ISNI: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(→‎SQL query results: | 2016-06-19 || 5725 || 1150 || 5543 || 1085 || 2712 || 2969 || 893 || 3348)
 
(13 intermediate revisions by the same user not shown)
Line 2: Line 2:
==Overview==
==Overview==
A [[tango.info person]] can have one ISNI. If several ISNI for one identity exist, the canonical ISNI should be the one that is connected with the person in tango.info.
A [[tango.info person]] can have one ISNI. If several ISNI for one identity exist, the canonical ISNI should be the one that is connected with the person in tango.info.
==Issues==
*0000000368557676 - linking to isni.org displays 0000 0001 0918 1571
*000000006041293X - not found in isni.org as of  2017-09-24, still found in http://datos.bne.es/persona/XX1501889.html section enlaces "ISNI http://isni-url.oclc.nl/isni/000000006041293X"


==Lists==
==Lists==
ISNI
ISNI
* https://tango.info/persons?q=has_isni
* https://tango.info/person?q=has_isni
ISNI, IPI
ISNI, IPI
* https://tango.info/persons?q=has_isni_or_ipi
* https://tango.info/person?q=has_isni_or_ipi
* https://tango.info/persons?q=has_isni_and_ipi
* https://tango.info/person?q=has_isni_and_ipi
* https://tango.info/persons?q=has_not_isni_and_has_ipi
* https://tango.info/person?q=has_not_isni_and_has_ipi
ISNI, IPI, SADAIC ID
ISNI, IPI, SADAIC ID
* https://tango.info/persons?q=has_not_isni_and_has_ipi_and_sadaic_id
* https://tango.info/person?q=has_not_isni_and_has_ipi_and_sadaic_id
* https://tango.info/persons?q=has_isni_or_ipi_or_sadaic_id
* https://tango.info/person?q=has_isni_or_ipi_or_sadaic_id


==Working with ISNI to improve ISNI data==
==Working with ISNI to improve ISNI data==
Line 24: Line 28:
** [[Tango.info person ISNI assignment]]
** [[Tango.info person ISNI assignment]]
** [[Tango.info person ISNI data merge]]
** [[Tango.info person ISNI data merge]]
 
* [[Tango.info person ISNI statistics]]
==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 CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}'
AND isni <> ""
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}'
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 CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}'
AND 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 CAST(person_code AS BINARY) REGEXP '[A-Za-z][a-z]{4}[A-Za-z][a-z]{4}'
AND ipi <> ""
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}'
AND (isni <> "" OR ipi <> "")
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}'
AND isni <> "" AND ipi <> ""
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}'
AND (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
 
{| class="wikitable sortable"
! style="width:80px" | Date
! Person
! ISNI
! Human
! ISNI and Human
! IPI
! ISNI or IPI
! ISNI and IPI
! ISNI or IPI or Todotango ID or SADAIC ID
|-
| 2014-12-09 || - || 473 || - || - || - || 2159 || - || -
|-
| 2015-01-29 || 5057 || 849 || 4927 || 834 || 2130 || 2308 || 671 || 2689
|-
| 2015-02-01 || 5074 || 850 || 4944 || 835 || 2144 || 2322 || 672 || 2705
|-
| 2015-02-05 || 5076 || 866 || 4946 || 848 || 2147 || 2334 || 679 || 2711
|-
| 2015-06-01 || 5264 || 889 || 5130 || 871 || 2325 || 2520 || 694 || 2894
|-
| 2015-06-07 || 5351 || 898 || 5217 || 880 || 2415 || 2610 || 703 || 2984
|-
| 2015-06-10 || 5371 || 903 || 5237 || 885 || 2435 || 2630 || 708 || 3004
|-
| 2015-06-10 || 5375 || 912 || 5241 || 894 || 2439 || 2634 || 717 || 3008
|-
| 2015-06-12 || 5422 || 972 || 5243 || 909 || 2440 || 2681 || 731 || 3055
|-
| 2015-06-16 || 5441 || 977 || 5262 || 914 || 2459 || 2700 || 736 || 3074
|-
| 2015-06-17 || 5489 || 988 || 5310 || 925 || 2505 || 2746 || 747 || 3122
|-
| 2015-06-19 || 5535 || 993 || 5356 || 930 || 2551 || 2792 || 752 || 3168
|-
| 2015-06-22 || 5537 || 995 || 5358 || 932 || 2553 || 2794 || 754 || 3170
|-
| 2015-06-24 || 5549 || 1005 || 5369 || 941 || 2566 || 2809 || 762 || 3185
|-
| 2015-06-30 || 5561 || 1006 || 5381 || 942 || 2572 || 2815 || 763 || 3192
|-
| 2015-10-28 || 5615 || 1018 || 5434 || 954 || 2612 || 2860 || 770 || 3243
|-
| 2015-11-11 || 5639 || 1025 || 5457 || 961 || 2633 || 2883 || 775 || 3268
|-
| 2016-06-09 || 5647 || 1044 || 5465 || 980 || 2637 || 2887 || 794 || 3272
|-
| 2016-06-10 || 5647 || 1082 || 5465 || 1017 || 2637 || 2889 || 830 || 3272
|-
| 2016-06-11 || 5647 || 1100 || 5465 || 1035 || 2637 || 2889 || 848 || 3272
|-
| 2016-06-14 || 5647 || 1127 || 5465 || 1062 || 2637 || 2889 || 875 || 3272
|-
| 2016-06-15 || 5647 || 1134 || 5465 || 1069 || 2643 || 2899 || 878 || 3274
|-
| 2016-06-18 || 5708 || 1147 || 5526 || 1082 || 2697 || 2954 || 890 || 3332
|-
| 2016-06-19 || 5725 || 1150 || 5543 || 1085 || 2712 || 2969 || 893 || 3348
|}

Latest revision as of 2018-07-19T19:37:45

Overview

A tango.info person can have one ISNI. If several ISNI for one identity exist, the canonical ISNI should be the one that is connected with the person in tango.info.

Issues

Lists

ISNI

ISNI, IPI

ISNI, IPI, SADAIC ID

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

Subpages:

Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_person_ISNI&oldid=72433"