Property talk:P2873

Documentation

• Start a query
• Current uses
• Statistics by class
• Units
• Scale of values
• List of qualifiers
• Count

time in space
time in space by an astronaut or cosmonaut

Represents	space exposure (Q7572583)
Data type	Quantity
Template parameter	"space_time" in en:Template:Infobox astronaut
Domain	According to this template: human (Q5) According to statements in the property: human (Q5) When possible, data should only be stored as statements
Allowed values	1 ≤ 𝓧 ≤ 1,100 day
Allowed units	Instances of: unit of time minute (Q7727)
Example	Bruce McCandless II (Q433608) → 18,751 minute Valery Bykovsky (Q159681) → 29,868 minute
Tracking: usage	Category:Pages using Wikidata property P2873 (Q26897875)
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 statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Minimum and maximum Items with highest numeric value Items with lowest numeric value Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 User:Laboramus/Units/P2873 (Units used) Database reports/Humans with missing claims/P2873 Database reports/Constraint violations/P2873 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 690 Main statement 683 99% of uses Qualifier 7 1% of uses

[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)

List of violations of this constraint: Database reports/Constraint violations/P2873#Single value, hourly updated report, SPARQL

Type “human (Q5)”: item must contain property “instance of (P31)” with classes “human (Q5)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P2873#Type Q5, hourly updated report, SPARQL

Item “occupation (P106): astronaut (Q11631)”: Items with this property should also have “occupation (P106): astronaut (Q11631)”. (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/P2873#Item P106, SPARQL

Units: “minute (Q7727)”: value unit must be one of listed. (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/P2873#Units

Range from “1” to “1100”: values should be in the range from “1” to “1100”. (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/P2873#Range

Item “country of citizenship (P27)”: Items with this property should also have “country of citizenship (P27)”. (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/P2873#Item P27, SPARQL

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

List of violations of this constraint: Database reports/Constraint violations/P2873#Entity types, hourly updated report

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (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/P2873#Item P21, SPARQL

Item “date of birth (P569)”: Items with this property should also have “date of birth (P569)”. (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/P2873#Item P569, SPARQL

Scope is as main value (Q54828448), as qualifier (Q54828449): 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/P2873#Scope, SPARQL

This property is being used by: it:Template:Astronauta eu:Txantiloi:Biografia infotaula automatikoa, eu:Txantiloi:Biografia infotaula automatikoa/en hu:Sablon:Űrhajós infobox, hu:Sablon:Személy infobox/Űrhajós kab:Talɣa:Infobox biography se:Málle:Biografia infotaula automatikoa/en mt:Mudell:Infobox biography, mt:Mudell:Infobox bijografija ha:Template:Infobox biography ca:Plantilla:Global Infobox person, ca:Plantilla:Global infobox person, ca:Plantilla:Infotaula persona ast:Plantía:Persona din:Macuëc:Bio ga:Teimpléad:WD Bosca Sonraí Duine gd:Teamplaid:Bogsa eachdraidh-bheatha ss:Template:Umuntfu ts:Template:Bio d:Template:Global infobox person qu:Plantilla:Biografia, qu:Plantilla:Kawsay dag:Tɛmplet:Bio ff:Template:Infobox biography gur:Tɛmpileti:Bio incubator:Template:Wp/igl/Bio, incubator:Template:Wp/ibb/Bio, incubator:Template:Wp/zgh/Infobox biography zgh:ⴰⵍⴱⵓⴹ:Infobox biography dga:Tɛmpileti:Bio ru:Шаблон:Время/тесты, ru:Шаблон:Космонавт gpe:Template:Bio Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Query

Time in days, hours, minutes

• Items used: second (Q11574)   

• Properties used: time in space (P2873)   

SELECT
  ?t
  ?time_in_days_hours_minutes
  ?item ?itemLabel ?itemDescription 
{
	?item p:P2873 / psn:P2873 [ wikibase:quantityAmount ?t ; wikibase:quantityUnit wd:Q11574 ] 
    BIND( ROUND(?t / 60) as ?q ) 
    BIND(IF( ?q >= 60 * 24 , CONCAT(str(floor(?q/60/24)),"d ") , "") as ?d)
    BIND(IF( ?q >= 60 , CONCAT(str(floor(?q/60)-floor(?q/60/24)*24),"h ") , "") as ?h)
    BIND(IF( ?q > 0 , CONCAT(str(?q-(floor(?q/60)*60)),"m ") , "") as ?m)
    BIND(CONCAT(?d,?h,?m) as ?time_in_days_hours_minutes)
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en"  }
}
ORDER BY DESC(?t) 
LIMIT 1000

Try it!