Skip to content

Instantly share code, notes, and snippets.

@kaplun
Last active June 22, 2017 15:24
Show Gist options
  • Save kaplun/aa79777e0f5d371383cbadaf33631893 to your computer and use it in GitHub Desktop.
Save kaplun/aa79777e0f5d371383cbadaf33631893 to your computer and use it in GitHub Desktop.
Duplicate INSPIRE IDs
+----------+------------------------------------------------------------------------+---+
| personid | GROUP_CONCAT(distinct data SEPARATOR ', ') | c |
+----------+------------------------------------------------------------------------+---+
| 224828 | INSPIRE-00509411, INSPIRE-00052076 | 2 |
| 246425 | INSPIRE-00281360, INSPIRE-00132187 | 2 |
| 249861 | INSPIRE-00454826, INSPIRE-00625964, INSPIRE-00330298, INSPIRE-00219535 | 4 |
| 251044 | INSPIRE-00645673, INSPIRE-None | 2 |
| 251960 | INSPIRE-00278790, INSPIRE-00102470 | 2 |
| 254681 | INSPIRE-00449933, INSPIRE-00295984 | 2 |
| 259219 | INSPIRE-00506284, INSPIRE-0041107 | 2 |
| 259439 | INSPIRE-00047393, INSPIRE-00576981 | 2 |
| 265523 | INSPIRE-00186195, INSPIRE-00208640 | 2 |
| 265532 | INSPIRE-00208640, INSPIRE-00091389 | 2 |
| 265883 | INSPIRE-00147455, INSPIRE-00046599 | 2 |
| 270102 | INSPIRE-00005771, INSPIRE-00271946 | 2 |
| 270196 | INSPIRE-00117955, INSPIRE-00298300 | 2 |
| 272409 | INSPIRE-00560581, INSPIRE-00060921 | 2 |
| 272885 | INSPIRE-00240095, INSPIRE-00386389 | 2 |
| 273020 | INSPIRE-00182306, INSPIRE-00265381 | 2 |
| 275383 | INSPIRE-00546945, INSPIRE-00546270 | 2 |
| 277357 | INSPIRE-00226974, INSPIRE-00224260 | 2 |
| 280054 | INSPIRE-00072600, INSPIRE-00460461 | 2 |
| 280072 | INSPIRE-00147979, INSPIRE-00228603 | 2 |
| 284237 | INSPIRE-00365234, INSPIRE-00108551 | 2 |
| 290893 | INSPIRE-00218063, INSPIRE-00461324 | 2 |
| 293394 | INSPIRE-00073057, INSPIRE-00227239 | 2 |
| 297234 | INSPIRE-00619464, INSPIRE-00149639 | 2 |
| 297458 | INSPIRE-00470966, INSPIRE-00440984 | 2 |
| 297728 | INSPIRE-00014761, INSPIRE-00386295 | 2 |
| 300582 | INSPIRE-00062868, INSPIRE-00185783 | 2 |
| 301095 | INSPIRE-00446569, INSPIRE-00514515 | 2 |
| 301259 | INSPIRE-00403579, INSPIRE-00335306 | 2 |
| 301611 | INSPIRE-00645570, INSPIRE-None | 2 |
| 306975 | INSPIRE-00300150, INSPIRE-00302606 | 2 |
| 306977 | INSPIRE-00100760, INSPIRE-00100793 | 2 |
| 307096 | INSPIRE-00100671, INSPIRE-00100660 | 2 |
| 307633 | INSPIRE-00296179, INSPIRE-00115528 | 2 |
| 307665 | INSPIRE-00262688, INSPIRE-00100355 | 2 |
| 308052 | INSPIRE-00339347, INSPIRE-00224249 | 2 |
| 308087 | INSPIRE-00417122, INSPIRE-00471699 | 2 |
| 308137 | INSPIRE-00076180, INSPIRE-00429957 | 2 |
| 310577 | INSPIRE-00226472, INSPIRE-00226484 | 2 |
| 311448 | INSPIRE-00706750, INSPIRE-00164378 | 2 |
| 311466 | INSPIRE-00424289, INSPIRE-00028138 | 2 |
| 311469 | INSPIRE-00183536, INSPIRE-00368736 | 2 |
| 311512 | INSPIRE-00525729, INSPIRE-00447725 | 2 |
| 312458 | INSPIRE-00262606, INSPIRE-00095925 | 2 |
| 313718 | INSPIRE-00274453, INSPIRE-00032436 | 2 |
| 317679 | INSPIRE-00184853, INSPIRE-00186076 | 2 |
| 319863 | INSPIRE-00261047, INSPIRE-00216280 | 2 |
| 320065 | INSPIRE-00246754, INSPIRE-00291773 | 2 |
| 320484 | INSPIRE-00452769, INSPIRE-00724198, INSPIRE-00069676 | 3 |
| 323336 | INSPIRE-00248772, INSPIRE-00262127 | 2 |
| 323378 | INSPIRE-00537571, INSPIRE-00406638 | 2 |
| 329620 | INSPIRE-00645513, INSPIRE-None | 2 |
| 329738 | INSPIRE-00248760, INSPIRE-00262137 | 2 |
| 334168 | INSPIRE-00455046, INSPIRE-00436670 | 2 |
| 334247 | INSPIRE-00300560, INSPIRE-00219756 | 2 |
| 335368 | INSPIRE-00182749, INSPIRE-00290103 | 2 |
| 336506 | INSPIRE-00262557, INSPIRE-00248880 | 2 |
| 337555 | NOLAB-20100721, INSPIRE-00020233 | 2 |
| 337889 | INSPIRE-00447181, INSPIRE-00446270 | 2 |
| 338293 | INSPIRE-00077392, INSPIRE-00374651 | 2 |
| 340067 | INSPIRE-00301078, INSPIRE-00013348 | 2 |
| 340390 | INSPIRE-00270172, INSPIRE-02701726 | 2 |
| 340409 | INSPIRE-00045380, INSPIRE-00135716 | 2 |
| 340813 | INSPIRE-00271425, INSPIRE-00121130 | 2 |
| 341808 | INSPIRE-00072166, INSPIRE-00272251 | 2 |
| 342659 | INSPIRE-00204440, INSPIRE-00245887 | 2 |
| 345375 | INSPIRE-00240980, INSPIRE-00561478 | 2 |
| 345960 | INSPIRE-00058274, INSPIRE-00292959 | 2 |
| 347540 | INSPIRE-00049715, INSPIRE-00270653 | 2 |
| 348509 | INSPIRE-00290001, INSPIRE-00246047 | 2 |
| 349932 | INSPIRE-00211100, INSPIRE-00064320 | 2 |
| 359454 | INSPIRE-00256344, INSPIRE-00347646 | 2 |
| 363572 | INSPIRE-00541874, INSPIRE-00097353 | 2 |
| 364014 | INSPIRE-00233184, INSPIRE-00408088 | 2 |
| 365557 | INSPIRE-00090409, INSPIRE-00113871 | 2 |
| 365953 | INSPIRE-00121790, INSPIRE-00222798 | 2 |
| 368665 | INSPIRE-00431159, INSPIRE-00419488 | 2 |
| 369429 | INSPIRE-00181074, INSPIRE-00289436 | 2 |
| 369433 | INSPIRE-00375579, INSPIRE-00181074 | 2 |
| 372590 | INSPIRE-00084795, INSPIRE-00152081 | 2 |
| 378587 | INSPIRE-None, INSPIRE-00645530 | 2 |
| 379034 | INSPIRE-00456480, INSPIRE-00449787 | 2 |
| 383097 | INSPIRE-00326020, INSPIRE-00553445 | 2 |
| 384494 | INSPIRE-00366352, INSPIRE-00469856 | 2 |
| 384862 | INSPIRE-00470295, INSPIRE-00506285 | 2 |
| 385395 | INSPIRE-00571896, INSPIRE-00162546 | 2 |
| 388480 | INSPIRE-00300593, INSPIRE-00160151 | 2 |
| 392895 | INSPIRE-00473113, INSPIRE-00473108 | 2 |
| 393172 | INSPIRE-00219939, INSPIRE-00105075 | 2 |
| 395172 | INSPIRE-00173232, INSPIRE-00074222 | 2 |
| 396592 | INSPIRE-00448463, INSPIRE-00450383 | 2 |
| 397084 | JACOW-00004871, INSPIRE-00001634 | 2 |
| 397660 | INSPIRE-00120026, INSPIRE-00120014 | 2 |
| 400470 | INSPIRE-00164750, INSPIRE-00104384 | 2 |
| 401566 | INSPIRE-00083737, INSPIRE-00083729 | 2 |
| 403304 | INSPIRE-00226158, INSPIRE-00258670 | 2 |
| 403551 | INSPIRE-00320553, INSPIRE-00362890 | 2 |
| 408148 | INSPIRE-00249256, INSPIRE-00262286 | 2 |
| 409092 | INSPIRE-00289454, INSPIRE-00249410 | 2 |
| 410702 | INSPIRE-00068140, INSPIRE-00173335 | 2 |
| 415523 | INSPIRE-00262106, INSPIRE-00244603 | 2 |
| 416748 | INSPIRE-00172607, INSPIRE-00446939 | 2 |
| 419888 | INSPIRE-00003015, INSPIRE-00301984 | 2 |
| 420445 | INSPIRE-00116512, INSPIRE-00220498 | 2 |
| 427942 | INSPIRE-00176097, INSPIRE-00473671 | 2 |
| 431198 | INSPIRE-00211268, INSPIRE-00065527 | 2 |
| 432514 | INSPIRE-00066350, INSPIRE-00049561 | 2 |
| 434473 | INSPIRE-00031500, INSPIRE-00275100 | 2 |
| 436647 | INSPIRE-00471015, INSPIRE-00231495 | 2 |
| 467097 | INSPIRE-00326936, INSPIRE-00182793 | 2 |
| 468071 | INSPIRE-00438812, INSPIRE-00581421 | 2 |
| 468815 | INSPIRE-00178829, INSPIRE-00090409 | 2 |
| 472087 | INSPIRE-00457965, INSPIRE-00374256 | 2 |
| 473344 | INSPIRE-00228635, INSPIRE-00228785 | 2 |
| 474130 | INSPIRE-00243894, INSPIRE-00262496 | 2 |
| 475115 | INSPIRE-00075131, INSPIRE-00094443 | 2 |
| 476472 | INSPIRE-00448738, INSPIRE-00445668 | 2 |
| 482831 | INSPIRE-00383195, INSPIRE-00162763 | 2 |
| 483950 | INSPIRE-00265230, INSPIRE-00320516 | 2 |
| 484371 | INSPIRE-00457529, INSPIRE-00457882 | 2 |
| 488420 | INSPIRE-00214233, INSPIRE-00339598 | 2 |
| 489491 | INSPIRE-00280294, INSPIRE-00369729 | 2 |
| 489506 | INSPIRE-00348078, INSPIRE-00265154 | 2 |
| 489592 | INSPIRE-00460113, INSPIRE-00394875 | 2 |
| 489640 | INSPIRE-00356588, INSPIRE-00006423, INSPIRE-00397488 | 3 |
| 489641 | INSPIRE-00262636, INSPIRE-00053490 | 2 |
| 489657 | INSPIRE-00019770, INSPIRE-00020720 | 2 |
| 490720 | INSPIRE-00465470, INSPIRE-00145153 | 2 |
| 490914 | INSPIRE-00191441, INSPIRE-00462993 | 2 |
| 491757 | INSPIRE-00023468, INSPIRE-00280116 | 2 |
| 492191 | INSPIRE-00267690, INSPIRE-00474829 | 2 |
| 492215 | INSPIRE-00217416, INSPIRE-00446471 | 2 |
| 496512 | INSPIRE-00255332, INSPIRE-00150592 | 2 |
| 503985 | INSPIRE-00056972, INSPIRE-00102907 | 2 |
| 507425 | INSPIRE-00348761, INSPIRE-00349593 | 2 |
| 508201 | INSPIRE-00336767, INSPIRE-00320516, INSPIRE-00265230 | 3 |
| 508212 | INSPIRE-00336857, INSPIRE-00137614 | 2 |
| 509395 | INSPIRE-00032797, INSPIRE-00085897, INSPIRE-00022128 | 3 |
| 539144 | INSPIRE-00034400, INSPIRE-00102287 | 2 |
| 563617 | INSPIRE-00395354, INSPIRE-00438156 | 2 |
| 567448 | INSPIRE-00118291, INSPIRE-00118288 | 2 |
| 570867 | INSPIRE-00134858, INSPIRE-00370773 | 2 |
| 573632 | INSPIRE-00519645, INSPIRE-00447710 | 2 |
| 584501 | INSPIRE-00116085, INSPIRE-00412124 | 2 |
| 586283 | INSPIRE-00064260, INSPIRE-00064259 | 2 |
| 595331 | INSPIRE-00057424, INSPIRE-00290740 | 2 |
| 597713 | INSPIRE-00067727, INSPIRE-00300831 | 2 |
| 600540 | INSPIRE-00362191, INSPIRE-00194393 | 2 |
| 601130 | INSPIRE-00030781, INSPIRE-00367766 | 2 |
| 606738 | INSPIRE-00248784, INSPIRE-00262112 | 2 |
| 607447 | INSPIRE-00370753, INSPIRE-00369472 | 2 |
| 610232 | INSPIRE-00075124, INSPIRE-00091968 | 2 |
| 613524 | INSPIRE-00473091, INSPIRE-00464090 | 2 |
| 615252 | INSPIRE-00261177, INSPIRE-00342010 | 2 |
| 623618 | INSPIRE-00093834, INSPIRE-00093828 | 2 |
| 629497 | INSPIRE-00261617, INSPIRE-00261603 | 2 |
| 645857 | INSPIRE-00464786, INSPIRE-00138380 | 2 |
| 646607 | INSPIRE-00047046, INSPIRE-00000225 | 2 |
| 647474 | INSPIRE-00409736, INSPIRE-00462479 | 2 |
| 649581 | INSPIRE-00389298, INSPIRE-00389866 | 2 |
| 652578 | INSPIRE-00706551, INSPIRE-00310351 | 2 |
| 652992 | INSPIRE-00042194, INSPIRE-00458476 | 2 |
| 654104 | INSPIRE-00708850, INSPIRE-00636166 | 2 |
| 656487 | INSPIRE-00447675, INSPIRE-00447683 | 2 |
| 656757 | INSPIRE-00464609, INSPIRE-00464489 | 2 |
| 661631 | INSPIRE-00465146, INSPIRE-00002496 | 2 |
| 674250 | INSPIRE-00434447, INSPIRE-00291820 | 2 |
| 676905 | INSPIRE-00472540, INSPIRE-00109552 | 2 |
| 679224 | INSPIRE-00000419, INSPIRE-00536572 | 2 |
| 687994 | INSPIRE-00473091, INSPIRE-00464090 | 2 |
| 10003199 | INSPIRE-00474581, INSPIRE-00114089 | 2 |
| 10007509 | INSPIRE-None, INSPIRE-00645582 | 2 |
| 10008436 | INSPIRE-00534484, INSPIRE-None | 2 |
| 10008444 | INSPIRE-None, INSPIRE-00645569 | 2 |
| 10008447 | INSPIRE-None, INSPIRE-00645541 | 2 |
| 10008448 | INSPIRE-None, INSPIRE-00645616 | 2 |
| 10008453 | INSPIRE-00645551, INSPIRE-None | 2 |
| 10031601 | INSPIRE-00214518, INSPIRE-00083629 | 2 |
| 10035635 | INSPIRE-00455904, INSPIRE-00468020 | 2 |
| 10048212 | INSPIRE-00579530, INSPIRE-00234283 | 2 |
| 10051655 | INSPIRE-00396576, INSPIRE-00101560 | 2 |
| 10056423 | INSPIRE-None, INSPIRE-00645498 | 2 |
| 10056829 | INSPIRE-00461151, INSPIRE-00412106 | 2 |
| 10060752 | INSPIRE-00261920, INSPIRE-00342046 | 2 |
| 10061895 | INSPIRE-00349762, INSPIRE-00578013 | 2 |
| 10061918 | INSPIRE-00449464, INSPIRE-00385836 | 2 |
| 10062277 | INSPIRE-00317229, INSPIRE-00365887 | 2 |
| 10079369 | INSPIRE-00023943, INSPIRE-00560236 | 2 |
| 10106043 | INSPIRE-00349982, INSPIRE-00000640 | 2 |
| 10107829 | INSPIRE-00427723, INSPIRE-00571818 | 2 |
| 10110891 | INSPIRE-00625399, INSPIRE-00320913 | 2 |
| 10112662 | INSPIRE-00440984, INSPIRE-00470966 | 2 |
| 10118075 | INSPIRE-00037384, INSPIRE-00468525 | 2 |
| 10120615 | INSPIRE-00583210, INSPIRE-00404930 | 2 |
| 10127725 | INSPIRE-None, INSPIRE-00645520 | 2 |
| 10136179 | INSPIRE-00226430, INSPIRE-00455517 | 2 |
+----------+------------------------------------------------------------------------+---+
210 rows in set (0.84 sec)
Generated with: select personid, GROUP_CONCAT(distinct data SEPARATOR ', '), count(*) as c from aidPERSONIDDATA WHERE tag='extid:INSPIREID' group by personid having c > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment