This is an old revision of the document!
CERL Thesaurus Help
Searching
Available Search Fields
The CERL Thesaurus comes with a complex index that allows for sophisticated searches. The following search fields are available:
| field | Fields | Description |
|---|---|---|
| active_in | 515$3 with $0 'actv','resd','teac','schl','stud' or 'trad' | id of a place of activity of an entity active_in:cnl00028786 |
| address | 515$a$d$e$r | search within the address of an entity address:“Kerk-straat” |
| based_in | 515$3 with $0 'dioc' | id of the place a diocese or parish is based in based_in:cnl00014398 |
| born_in | 515$3 with $0 'brth' | id of the place a person was born in born_in:cnl00008322 |
| child_of | 500$3 with $0 'ex:hasParent' | id of a person who is a parent to another person |
| collaborator_of | 500$3,510$3 with $0 'ex:hasCollaborator' | id of a person or printer who has worked together with another person or printer |
| corporateName | 212$a$b$e$r, 412$a$b$e$r | name (heading or variant) of a corporate entity (word) corporateName:university |
| corporateName.orig | 212$a$b$e$r, 412$a$b$e$r | name (heading or variant) of a corporate entity (phrase) |
| dedup | 001c/p0-2 with 831#1 present in the record | type of a record that is marked for deduplication dedup:cnl |
| died_in | 515$3 with $0 'deat' | id of a place where a person died |
| duplicate_of | 831#1$a | id of a record that could be a duplicate of another record |
| external_id | 801$b$c | ID from an external file external_id:gnd or external_id:(gnd 1029934118) |
| feature | 956, 516 | a certain feature/chunk of information of a record prdv Printers' Devices prov Provnance Information imag Image feature:prdv |
| gender | 120$a | a person's or printer's gender (code) a female b male u unknown gender:a |
| has_member | 512$3 with $0 'ex:isMemberOf' | id of a corporate body that has members |
| id | 001, 035$z | CERL Thesaurus ID id:cnc00006222 |
| imprintName | 210$a$b$e$r, 410$f$a$b$e$r | a name of a printer/bookseller etc. (heading or variant) (word) imprintName:sermartelli |
| imprintName.orig | 210$a$b$e$r, 410$f$a$b$e$r | a name of a printer/bookseller etc. (heading or variant) (phrase) |
| last_changed | 999$a$b only the last occurrence of 999 | date a record has last been changed last_changed:[2017-12-01 TO * ] all records changed at or after Dec, 1st 2017 |
| lived_in | 515$3 with $0 'resd' | id of a place where a person lived |
| location | 123$d$f | Geographic coordinates of a place |
| name | 200/210/212/215$a$b$e$r, 400/410/412/415$f$a$b$e$r | name of an entity (word). This index is a combination of personalName, imprintName, corporateName and placeName name:hamburg |
| name.orig | 200/210/212/215$a$b$e$r, 400/410/412/415$f$a$b$e$r | name of an entity (phrase). This index is a combination of personalName.orig, imprintName.orig, corporateName.orig and placeName.orig |
| note | 300$a,350$a,356$a | a general note, activity note or geographic note note:printer |
| parent_of | 500$3 with $0 'ex:hasChild' | id of a person that is the child of another person |
| placeName | 215$a$e$r, 415$a$e$r | name (heading or variant) of a place (word) placeName:hamburg |
| placeName.orig | 215$a$e$r, 415$a$e$r | name (heading or variant) of a place (phrase) |
| personalName | 200$a$b$e$r, 400$f$a$b$e$r | name (heading or variant) of a person (word) personalName:aristoteles |
| personalName.orig | 200$a$b$e$r, 400$f$a$b$e$r | name (heading or variant) of a person (phrase) personalName:aristoteles |
| predecessor_of | 500/510/512$3 | id of the entity that is the successor of another entity |
| record_flag | 830$6 | a specific record marker record_flag:ba18 |
| related_to | 500/510/512/515$3 | id of a record related to another record (backlinks) related_to:cnl00032270 |
| school_in | 515$3 with $0 'schl' | id of a place where a person visited a school |
| sign | 516$a$n | description of a sign/marks/device etc sign:tortuga |
| spouse_of | 500$3 with $0 'ex:hasSpouse' | id of a person that has been married to another person |
| studied_in | 515$3 with $0 'stud' | id of a place where a person visited a university |
| subordinate_to | 512$3 with $0 'ex:hasSuperiorHierarchicalLevel' | id of a corporate entity that has a sub division |
| successor_of | 500/510/512$3 with $0 'ex:hasPredecessor' | id of an entity that is a predecessor to another entity |
| superior_to | 512$3 with $0 'ex:hasSubordinateHierarchicalLevel' | id of a corporate entity that is a sub-division of another corporate entity |
| tought_in | 515$3 with $0 'teac' | id of a place where a person was teaching (e.g. at a school or university) |
| traded_in | 515$3 with $0 'trad' | id of a place where another entity conducted business |
| type | 001c/p0-2 | record type type:cnp |
| visited | 515$3 with $0 'vist' | id of a place a person has visited |
| year_end | 340$x | search for entities whose activity or existence ended before, in or after a certain year year_end:>1800 year_end:<1500 |
| year_start | 340$x | search for entities whose activity or existence started before, in or after a certain year year_start:[1530 TO 1560] |
Query Syntax
Search fields of the type string (except those ending in .orig) are word indexed, case-insensitive and diacritics are replaced by the base character. They can be searched by just typing the search term after the search key's name, separated by a colon:
name:hamburgthe term hamburg should appear in the name: fieldpersonalName:(visser jacob)the terms visser and jacob should appear in the personalName: field in any order, regardless if adjacent or notimprintName:“sermartelli e fratelli”the terms sermartelli e fratelli should appear in the imprintName: field in exactly this order
The fields named .orig contain the original field's content as a phrase, case-sensitive, diacritics are not replaced:
imprintName.orig:“Bartolommeo Sermartelli e fratelli, Firenze”
Search fields of the type date allow for range searches:
last_changed:[2017-05-1 TO 2017-05-31]all records that have last been edited in May 2017year_start:<1600all entities that were born or started their activity before the year 1600.
Search terms can be combined by using the Boolean Operators AND, OR and NOT. Please note that these must always be written in upper case.
year_start:<1600 AND feature:prdvall records where the activity/birth date is before 1600 and that contain descriptions of printers devicesname:sermartelli AND name:(bartolomeo OR michelangelo)all records where the name field contains Sermartelli and either Bartolomeo or Michelangelo.
Truncation/Wildcards can be used as well. Please that using wildcards will slow down the response time remarkably.
?replaces exactly one character*replaces any number or characters including zero
Searching Relationships
A number of the search keys listed above allow to retrace the relationship between the entities described in the CERL Thesaurus. It is assumed that one part of the relationship is known, e.g. a person or a place and using this person's or place's id, we can retrieve the records that link back to it.
For example: Knowing the ID for the place “Tübingen”, we can retrieve persons who went to university here: studied_in:cnl00014526
help/thesaurus/searching.1536761409.txt.gz · Last modified: 2018/09/12 16:10 by jahnke
