search

swiss-art-research-net / bso-data-pipeline

This contains the pipeline for converting BSO input data into CIDOC/RDF
3 stars 0 forks source link

Remove persons with no relations to other entities #58

Open fkraeutli opened 9 months ago

fkraeutli commented 9 months ago

There are persons that bear no relation to other entities and can be removed.

Query:

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/>
PREFIX search: <https://platform.swissartresearch.net/search/>
SELECT DISTINCT ?person (GROUP_CONCAT(DISTINCT ?source;SEPARATOR=';') as ?source) (MAX(?label) as ?label)  (COUNT(?statement) as ?num_statements) WHERE {
  ?person a search:Person .

  GRAPH ?source {
    ?person rdfs:label ?label
  }

  FILTER NOT EXISTS {
    ?thing crm:P14_carried_out_by|crm:P138_represents|crm:P23_transferred_title_from ?person
  }
  {
    ?person ?p ?statement .
  } UNION {
    ?statement ?p ?person .
  }
} GROUP BY ?person
ORDER BY ?label
Result: person source label num_statements
https://resource.swissartresearch.net/actor/9D576C54-1316-312F-8BA7-3E7663F73B9F https://resource.swissartresearch.net/graph/nb Achtnich, Walter Hermann (20. Jh.) 6
https://resource.swissartresearch.net/actor/DEB4C3DA-522A-3D44-A9DE-FE79C3451D7F https://resource.swissartresearch.net/graph/nb Albrecht, S.W. (19. Jh.) 5
https://resource.swissartresearch.net/actor/F6325C44-7076-3FA2-B42D-5BA5EDEDA341 https://resource.swissartresearch.net/graph/nb Amman, Johann Heinrich (1607-1669) 8
https://resource.swissartresearch.net/actor/EF877042-1C7D-3CE1-8AA3-4B2731589FC0 https://resource.swissartresearch.net/graph/nb Antonelli, Giuseppe (1793-1861) 6
https://resource.swissartresearch.net/actor/5EBB1009-AB0C-3617-AA98-194EC39BF933 https://resource.swissartresearch.net/graph/nb Artaria, Domenico (1765-1823) 8
https://resource.swissartresearch.net/actor/3F72D18A-AB1F-3A06-992E-1F9D26A5836F https://resource.swissartresearch.net/graph/nb Baedeker, Karl (1910-1979) 6
https://resource.swissartresearch.net/actor/23523DD5-32E5-337A-8C34-349F0D7CEBDB https://resource.swissartresearch.net/graph/nb Belleforest, François de (1530-1583) 8
https://resource.swissartresearch.net/actor/FB08B44C-12BB-3C49-B6AC-D170C46788FE https://resource.swissartresearch.net/graph/nb Blanchoud, G. (19. Jh.) 5
https://resource.swissartresearch.net/actor/F5B541D3-30B2-3563-BFCD-DE60797D5BC8 https://resource.swissartresearch.net/graph/nb Boisseau, Jean (1601-1657) 6
https://resource.swissartresearch.net/actor/A7384B2B-C1B6-38E9-9E35-2A7EDAF3FD37 https://resource.swissartresearch.net/graph/nb Boydell, John (1719-1804) 8
https://resource.swissartresearch.net/actor/B43F2920-1D1A-371B-BBAC-750A3BC093E4 https://resource.swissartresearch.net/graph/nb Broglie, Joseph (19./20. Jh.) 5
https://resource.swissartresearch.net/actor/E997D3F2-1EEE-3E05-9256-33A6A9A8A039 https://resource.swissartresearch.net/graph/nb Bulla, Eugène (ca. 1810/15-nach 1874) 5
https://resource.swissartresearch.net/actor/6FA57B65-9C69-3E93-BC5B-5A29CDDDCC34 https://resource.swissartresearch.net/graph/nb Bulla, François (ca. 1814-ca. 1855) 6
https://resource.swissartresearch.net/actor/5BB1F0D2-CF93-3E96-AF9B-0CC0D30AF4A8 https://resource.swissartresearch.net/graph/nb Büchler, Johann Konrad (19. Jh.) 5
https://resource.swissartresearch.net/actor/A6B0014C-91B0-3474-94C7-9D1865CA4337 https://resource.swissartresearch.net/graph/nb Bürgi, Jakob (1737-1795) 5
https://resource.swissartresearch.net/actor/4A001112-5287-34B3-9059-1B15AE655F7A https://resource.swissartresearch.net/graph/nb Bürkli, Johann Heinrich (1760-1821) 6
https://resource.swissartresearch.net/actor/3906720A-745E-3D8D-A902-36E46CEECDFE https://resource.swissartresearch.net/graph/nb Cadell, Thomas (1773-1836) 6
https://resource.swissartresearch.net/actor/64F63E31-4C06-32EC-B270-25D7A13D3974 https://resource.swissartresearch.net/graph/nb Cats, Jakob (1577-1660) 7
https://resource.swissartresearch.net/actor/FC57BE5B-4152-34FE-9DFE-02DA56C107C5 https://resource.swissartresearch.net/graph/nb Charnaux, Joseph Florentin (1819-1883) 6
https://resource.swissartresearch.net/actor/E9123422-66AD-3AA6-9980-1B007DD9862E https://resource.swissartresearch.net/graph/nb Chouet, Pierre (1610-1676) 6
https://resource.swissartresearch.net/actor/52BBC7BD-6978-394D-BC2E-E5BEB0F2143B https://resource.swissartresearch.net/graph/nb Couché, Jacques (ca. 1755-ca. 1821) 8
https://resource.swissartresearch.net/actor/64CF04BD-D5C4-3A4C-ABB1-499605BF75D4 https://resource.swissartresearch.net/graph/nb Delarue, François (1813-) 6
https://resource.swissartresearch.net/actor/BC1286AF-844E-305D-BB81-EA34CE128184 https://resource.swissartresearch.net/graph/nb Delarue, Victor (19. Jh.) 6
https://resource.swissartresearch.net/actor/9DECC107-B00D-3FF3-862E-1E7FAFCA42B8 https://resource.swissartresearch.net/graph/nb Däniker, Henri (19. Jh.) 6
https://resource.swissartresearch.net/actor/44B35EFC-8737-30A8-973C-EFCB4A21D530 https://resource.swissartresearch.net/graph/nb Ebner, Ferdinand (19. Jh.) 5
https://resource.swissartresearch.net/actor/EC14F9B3-06C5-3258-BA37-AF813D7AB14B https://resource.swissartresearch.net/graph/nb Eglin, Jakob (1875-1962) 6
https://resource.swissartresearch.net/actor/C3EF09CE-ABF5-3663-9B1D-960E8507B9CF https://resource.swissartresearch.net/graph/nb Funk, Sigmund Emanuel (1722-1781) 8
https://resource.swissartresearch.net/actor/251A5EA5-C360-33A0-B38C-77B43945F8FF https://resource.swissartresearch.net/graph/nb Furck, Sebastian (ca. 1600-1655) 8
https://resource.swissartresearch.net/actor/16C04CEA-A9B6-338E-A8ED-2A4E54BB6AC3 https://resource.swissartresearch.net/graph/nb Gache, Henri (19. Jh.) 5
https://resource.swissartresearch.net/actor/A97BFBFA-C78F-32E6-929C-6D83C0E9665D https://resource.swissartresearch.net/graph/nb Gaultier, Barthélemy (17. Jh.) 5
https://resource.swissartresearch.net/actor/9AD6A99D-1A95-347E-B3C3-983FF4E4C0D0 https://resource.swissartresearch.net/graph/nb Geyser, Robert (-1872) 5
https://resource.swissartresearch.net/actor/931128B6-7353-3BE1-B773-936DB34BE3C9 https://resource.swissartresearch.net/graph/nb Giegler, Jean-Pierre (1772-1828) 8
https://resource.swissartresearch.net/actor/C13C14F2-5141-3F80-835E-790C27570A11 https://resource.swissartresearch.net/graph/nb Girardet, Samuel (1730-1807) 6
https://resource.swissartresearch.net/actor/3C303FC8-0837-3584-A67A-128F37F8CAB1 https://resource.swissartresearch.net/graph/nb Gogel, Joseph (1804-1872) 5
https://resource.swissartresearch.net/actor/B9E73CF4-43B6-3823-ACB6-82196F1F749D https://resource.swissartresearch.net/graph/nb Gowland, Thomas (18. Jh) 6
https://resource.swissartresearch.net/actor/824784B0-AC6D-305E-945A-D97F8DF49B6A https://resource.swissartresearch.net/graph/nb Gruaz, Charles (19. Jh.) 5
https://resource.swissartresearch.net/actor/2A6D7BE5-0FFB-35B3-8233-203895C1B3CC https://resource.swissartresearch.net/graph/nb Gugelmann, Annemarie (1917-1986) 9
https://resource.swissartresearch.net/actor/7C3359F8-921F-3734-BF4D-08385BD001AF https://resource.swissartresearch.net/graph/nb Gugelmann, Rudolf (1913-1947) 8
https://resource.swissartresearch.net/actor/644B9750-BCBA-3AF5-924C-BFF654680BE7 https://resource.swissartresearch.net/graph/nb Helbling, Lorenz (19. Jh.) 5
https://resource.swissartresearch.net/actor/DECB0F2E-8718-319F-9B4B-B7926EB919AA https://resource.swissartresearch.net/graph/nb Hess, Johann Jakob (1791-1857) 8
https://resource.swissartresearch.net/actor/6BCE2099-4788-3270-B626-28B8D7972D37 https://resource.swissartresearch.net/graph/nb Hofer, Johann Jakob (1828-1892) 6
https://resource.swissartresearch.net/actor/80FA6B9D-01AB-3D57-827F-1B27D81FA247 https://resource.swissartresearch.net/graph/nb Hug, Nicolaus (1771-1852) 5
https://resource.swissartresearch.net/actor/A5606EBC-3447-3028-AA1A-F3C223030EBD https://resource.swissartresearch.net/graph/nb Jacobi, Johann Georg (1740-1814) 6
https://resource.swissartresearch.net/actor/51F77227-1AD8-31E5-B92F-472C10841738 https://resource.swissartresearch.net/graph/nb Jeannin, Henri Jules (1802-1852) 6
https://resource.swissartresearch.net/actor/047A4B75-9890-3675-A811-C91EC7A2A251 https://resource.swissartresearch.net/graph/nb Jonghe, Clement de (ca. 1624-ca. 1677) 6
https://resource.swissartresearch.net/actor/AAFE8F22-0A34-31FE-AEB9-BC6DF6785FAE https://resource.swissartresearch.net/graph/nb Kanning, David Martin (1806-1884) 8
https://resource.swissartresearch.net/actor/797D1062-CC42-315F-8687-3B467BCF4EA5 https://resource.swissartresearch.net/graph/nb Kellenberger, Samuel (19. Jh.) 6
https://resource.swissartresearch.net/actor/1CBF77E8-0E75-3FBE-BF79-61001076F368 https://resource.swissartresearch.net/graph/nb Kesselbach-Unterfinger, J. (19. Jh.) 5
https://resource.swissartresearch.net/actor/B913D233-BBFA-3F99-AC79-6063D4B4D2BD https://resource.swissartresearch.net/graph/nb Kieser, Carl (19. Jh.) 5
https://resource.swissartresearch.net/actor/75A68BE6-1C08-3250-9944-66C719D5B119 https://resource.swissartresearch.net/graph/nb Kuhn, Johann Jakob (1780-1850) 6
https://resource.swissartresearch.net/actor/A33E72C7-42CD-348D-AE6F-FB3DD992B395 https://resource.swissartresearch.net/graph/nb Küchler, Georg Wilhelm (-1872) 6
https://resource.swissartresearch.net/actor/392F3FBE-B3AB-3D47-9256-9B271D513947 https://resource.swissartresearch.net/graph/nb Lambert, André (1919-1977) 6
https://resource.swissartresearch.net/actor/CBA36CF9-DEC5-3A11-B92D-DDEE0853EDAB https://resource.swissartresearch.net/graph/nb Leopold, Johann Crhistian (1699-1755) 5
https://resource.swissartresearch.net/actor/0409E4A0-F9FD-3D73-9479-18A3B66AA3FF https://resource.swissartresearch.net/graph/nb Lewis, William (19. Jh.-) 5
https://resource.swissartresearch.net/actor/23BA7C48-C8EF-393D-B0E4-BC5FC8F68625 https://resource.swissartresearch.net/graph/nb Lordereau, Edme (1801-) 5
https://resource.swissartresearch.net/actor/32C5FEC2-FFC8-33D3-BAB0-57008D6AC992 https://resource.swissartresearch.net/graph/nb Lutz, Karl Rudolf (1799-1875) 8
https://resource.swissartresearch.net/actor/DD20C6AB-1E88-3AAB-B72D-6A0AD9B42B66 https://resource.swissartresearch.net/graph/nb Mack, Fr. (19. Jh.) 6
https://resource.swissartresearch.net/actor/11A73903-0166-318E-9FE6-66A896BF32A2 https://resource.swissartresearch.net/graph/nb Mackenzie, William (19. Jh.) 5
https://resource.swissartresearch.net/actor/7B472DA8-3E4E-34CF-99B5-FA38FAE30E89 https://resource.swissartresearch.net/graph/nb Margueron, Frédéric (19. Jh.) 5
https://resource.swissartresearch.net/actor/63426BC1-5698-3026-A78F-5CF424756000 https://resource.swissartresearch.net/graph/nb Meisner, Friedrich (1765-1825) 8
https://resource.swissartresearch.net/actor/1AB78639-843A-3DBD-8DDC-E4D3353750E4 https://resource.swissartresearch.net/graph/nb Mollo, Tranquillo (1767-1837) 8
https://resource.swissartresearch.net/actor/45923EF8-F801-31B1-B520-2BFFF34EBC4F https://resource.swissartresearch.net/graph/nb Monty, Fr. (18./19. Jh.) 5
https://resource.swissartresearch.net/actor/6DB1C252-0437-3EB3-BA10-7B9EE185723A https://resource.swissartresearch.net/graph/nb Morasch, Christian Gottfried (1749-1815) 8
https://resource.swissartresearch.net/actor/8A7E9C34-D9A8-3C5E-BFAC-81143EEFBA5D https://resource.swissartresearch.net/graph/nb Mucquardt, C. (19. Jh.) 5
https://resource.swissartresearch.net/actor/E73BF010-2350-3B97-81B7-7D0AF74645CF https://resource.swissartresearch.net/graph/nb Mäglin, Rudolf (1892-1971) 6
https://resource.swissartresearch.net/actor/90C0D0BF-48A3-39CA-B79B-ABC6878D36E1 https://resource.swissartresearch.net/graph/nb Müller, Johann Caspar (19. Jh.) 5
https://resource.swissartresearch.net/actor/E5305165-82F4-3805-A175-251D82E5BF04 https://resource.swissartresearch.net/graph/nb Müller, Johann Georg (1610-1672) 8
https://resource.swissartresearch.net/actor/C7E242F7-747C-322C-9034-255A83A9F867 https://resource.swissartresearch.net/graph/nb Ochs, Johann Anton (1752-1809) 6
https://resource.swissartresearch.net/actor/68BB2FC2-0446-30F4-AB1A-66B2BB59DEB4 https://resource.swissartresearch.net/graph/nb Ochsner, Johann Caspar (1815-1872) 5
https://resource.swissartresearch.net/actor/A1B5FC2F-CC8D-351A-A6AA-4F98A17DA390 https://resource.swissartresearch.net/graph/nb Offenhäuser, I.U. (19. Jh.) 5
https://resource.swissartresearch.net/actor/43EBACFA-9717-30BC-8C71-BE77C92323C8 https://resource.swissartresearch.net/graph/nb Payot, Venance (1826-1902) 6
https://resource.swissartresearch.net/actor/FDBF6519-E167-3834-A1FB-74749B7F3CFC https://resource.swissartresearch.net/graph/nb Platter, Thomas (1499-1582) 6
https://resource.swissartresearch.net/actor/377CA50A-253B-3C78-AA4B-26D8DDA4C30B https://resource.swissartresearch.net/graph/nb Prestel, Christian Erdmann Gottlieb (1773-1830) 8
https://resource.swissartresearch.net/actor/56AED90C-B16D-3BC0-B064-B8E1E3735F9E https://resource.swissartresearch.net/graph/nb Quénot, J.P. 5
https://resource.swissartresearch.net/actor/CE63D6E1-1E8D-3B91-BC61-681E531DFC09 https://resource.swissartresearch.net/graph/nb Riedel, Konrad (18./19. Jh.) 5
https://resource.swissartresearch.net/actor/BD20922D-9EC2-396B-8452-855F8008CA2E https://resource.swissartresearch.net/graph/nb Rittner, Henri (1802-1840) 6
https://resource.swissartresearch.net/actor/F8888115-B0F0-3D8C-833B-C1646A7FEF46 https://resource.swissartresearch.net/graph/nb Rouiller, Georges (19. Jh.) 5
https://resource.swissartresearch.net/actor/64A44E52-D9CF-3EB2-885A-629765879C1C https://resource.swissartresearch.net/graph/nb Sammer, Rudolf (1752-1821) 6
https://resource.swissartresearch.net/actor/29CE9E08-FF19-3620-904B-56BEA7791DA5 https://resource.swissartresearch.net/graph/nb Savary, Claude (17. Jh.) 5
https://resource.swissartresearch.net/actor/4C9DA9B5-9FA9-3FED-91EC-2A997A2F917F https://resource.swissartresearch.net/graph/nb Scholz, Joseph (19. Jh.) 5
https://resource.swissartresearch.net/actor/A5A38B66-49C9-39B9-97E5-DE641A5B715E https://resource.swissartresearch.net/graph/nb Schürmann, Joseph (19 Jh.) 5
https://resource.swissartresearch.net/actor/C986CA57-89E3-39C3-A1D8-1BE3F8570B68 https://resource.swissartresearch.net/graph/nb Seidler, H. W. Ch. (18./19. Jh.) 6
https://resource.swissartresearch.net/actor/320D1797-82E8-34C0-B241-4DE132DE48F9 https://resource.swissartresearch.net/graph/nb Seitz, Emil (ca. 1830-1911) 5
https://resource.swissartresearch.net/actor/D3DF4784-BBF0-3FCA-BC88-3A13FC33594A https://resource.swissartresearch.net/graph/nb Seringe, Nicolas Charles (1776-1858) 8
https://resource.swissartresearch.net/actor/01936C20-E259-349F-AECC-45F57D173F2B https://resource.swissartresearch.net/graph/nb Sinnett, F. (19. Jh.) 6
https://resource.swissartresearch.net/actor/E12A7B10-5081-32E1-8186-F463ADD6BA8C https://resource.swissartresearch.net/graph/nb Stettler, Karl (19. Jh.) 5
https://resource.swissartresearch.net/actor/99B43EB6-1BB3-3E90-BEBB-E385699A159F https://resource.swissartresearch.net/graph/nb Studer, Samuel (1757-1834) 8
https://resource.swissartresearch.net/actor/36B06B54-DE6D-3189-8241-8421C0A934AD https://resource.swissartresearch.net/graph/nb Stürler, Ludwig von (1805-1891) 7
https://resource.swissartresearch.net/actor/31E81443-6C4F-3457-B377-460B183EC687 https://resource.swissartresearch.net/graph/nb Thomet, F. (18. Jh.) 5
https://resource.swissartresearch.net/actor/8573247D-EE22-3A65-843F-0B7720F6C930 https://resource.swissartresearch.net/graph/nb Tilt, Charles (1797-1861) 8
https://resource.swissartresearch.net/actor/64130121-CB14-343F-BBA8-6D8307EC7EAA https://resource.swissartresearch.net/graph/nb Tscharner, Karl Ludwig von (1787-1856) 8
https://resource.swissartresearch.net/actor/13D8CABC-B892-3E6E-8991-DE2A34B4B50C https://resource.swissartresearch.net/graph/nb Velten, Johann (19. Jh) 5
https://resource.swissartresearch.net/actor/108529A2-7A84-3AA0-9B34-7CA1A64B7908 https://resource.swissartresearch.net/actor/108529A2-7A84-3AA0-9B34-7CA1A64B7908/container/context Verlag Hans Felix Leuthold 8
https://resource.swissartresearch.net/actor/B31CA7FB-63E8-3A48-A9AC-0F604E5526B7 https://resource.swissartresearch.net/graph/nb Vinet, Alexandre Rodolphe (1797-1847) 6
https://resource.swissartresearch.net/actor/9E04200A-5315-3033-8CAF-123BE1140761 https://resource.swissartresearch.net/graph/nb Virtue, James Sprent (1829-1892) 5
https://resource.swissartresearch.net/actor/8D8CE92C-8914-3B45-A919-BBA5CB782D47 https://resource.swissartresearch.net/graph/nb Westermann, George (1810-1879) 6
https://resource.swissartresearch.net/actor/C1574ACA-AEBC-3B54-A4B2-8A3E497559F3 https://resource.swissartresearch.net/graph/nb Wiederhold, Johann Carl (1743-1826) 5
https://resource.swissartresearch.net/actor/9095FF2E-05CC-3C0B-A815-538D912389CF https://resource.swissartresearch.net/graph/nb Zschokke, Heinrich (1771-1848) 6
https://resource.swissartresearch.net/actor/5132092E-E5C9-3D76-A5B3-E17FADA7EF15 https://resource.swissartresearch.net/graph/nb Zucoli, Luigi (19. Jh.) 6
fkraeutli commented 9 months ago

@sbenz1 These are the persons that would be removed. It seems they all come from NB.

sbenz1 commented 9 months ago

@fkraeutli This seems correct. I just finished looking through all the names - none appear directly on our persons list or only as duplicates aswell, meaning that deleting them should add clarity to the persons data on BSO. I'll quickly ask Michael what his opinion is on this!

sbenz1 commented 9 months ago

Update: Michael just looked through the list and has agreed to delete all mentioned entities.