Property talk:P6135

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

VD 18 ID
publication ID in the bibliography of 18th century printed material in the German speaking areas

Applicable "stated in" value	VD 18 (Q1739957)
Data type	External identifier
Allowed values	[0-9]\d{7}
Example	Journal der practischen Heilkunde (Q19214494) → 90294076 Critique of Pure Reason (Q220002) → 14482940 Oekonomische Encyklopädie (Q916201) → 11039493
Formatter URL	https://kxp.k10plus.de/DB=1.65/CMD?ACT=SRCHA&IKT=8080&TRM=VD18$1
Related to country	Germany (Q183) (See 347 others)
See also	Incunabula Short Title Catalogue ID (P6494)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Database reports/Constraint violations/P6135 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 47 Main statement 44 93.6% of uses Qualifier 3 6.4% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6135#Single value, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6135#Unique value, SPARQL (every item), SPARQL (by value)

Format “[0-9]\d{7}”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6135#Format, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6135#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P6135#Scope, SPARQL

Items that should have VD 18 identifiers

Filtering all publications results in a timeout but selected publication types from the 18th century can be queried like this:

SELECT ?p ?pLabel ?pDescription ?year ?vd18 WHERE {
  # books and periodicals (all publications would lead to timeout)
  { { ?p wdt:P31/wdt:P279* wd:Q571 } UNION
    { ?p wdt:P31/wdt:P279* wd:Q1002697 } }
  
  # filter by date
  ?p wdt:P577 ?date .  
  FILTER (year(?date) >= 1701) .
  FILTER (year(?date) <= 1800) .

  # Publications with German or unknown language
  OPTIONAL { 
    ?p wdt:P407 ?lang 
    FILTER NOT EXISTS { ?p wdt:P407 wd:Q188 }
  } 
  FILTER (!BOUND(?lang)) .
  
  # get VD 18 ID, year, and labels
  OPTIONAL { ?p wdt:P6135 ?vd18 }
  BIND (year(?date) AS ?year) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
} ORDER BY DESC(?vd18)

Try it!

See also Category 18th century in German Wikisource.

Items with VD18 ID and German Wikisource page

SELECT ?item ?itemLabel ?year ?vd18 ?wikisource ?wikipedia WHERE {
  ?item wdt:P6135 ?vd18 .     
  ?item wdt:P577 ?date .   
  OPTIONAL {
    ?wikisource schema:about ?item .   
    FILTER (SUBSTR(STR(?wikisource),1,25)="https://de.wikisource.org")
  }
  OPTIONAL {
    ?wikipedia schema:about ?item .
    FILTER (SUBSTR(STR(?wikipedia),1,25)="https://de.wikipedia.org/")
  }
  BIND (year(?date) AS ?year) .  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
} ORDER BY ASC(?year)

Try it!