Property talk:P6135
Jump to navigation
Jump to search
VD 18 ID
publication ID in the bibliography of 18th century printed material in the German speaking areas
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 361 others) | |||||||||
| See also | Incunabula Short Title Catalogue ID (P6494) | |||||||||
| Lists |
| |||||||||
| Proposal discussion | Proposal discussion | |||||||||
| Current 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)
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
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
[edit]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)
See also Category 18th century in German Wikisource.
Items with VD18 ID and German Wikisource page
[edit]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)