User:MKar/sandbox

From Wikidata
Jump to navigation Jump to search 
If you want to test on an actual item, see Q4115189, Q13406268, Q15397819, Q112795079.

Data Model

[edit]

Rajya Sabha

[edit]

All items for members of Rajya Sabha (Q244730) should have the following metadata:

Mandatory
instance of (P31): human (Q5)
country of citizenship (P27): India (Q668)
occupation (P106): politician (Q82955)
position held (P39): Member of Rajya Sabha (Q17324844)
preferably with a reference URL (P854) (ideally to the official site), and with modifiers (where known/appropriate):
member of political party (P102): Bharatiya Janata Party (Q10230)/ Indian National Congress (Q10225)
electoral district (P768):
elected in (P2715):
start time (P580):
end time (P582):
end cause (P1534)> : the reason for ending this period; eg time limit (Q1465133), resignation (Q796919), leaving party (Q30580660), exclusion from a political party (Q30580630), death in office (Q5247364).
Where known
sex or gender (P21): male (Q6581097)/ female (Q6581072)
date of birth (P569):
date of death (P570) (if deceased!)
given name (P735):

Lok Sabha

[edit]

All items for members of Lok Sabha (Q230003) should have the following metadata:

Mandatory
instance of (P31): human (Q5)
country of citizenship (P27): India (Q668)
occupation (P106): politician (Q82955)
position held (P39): Member of the 16th Lok Sabha (Q42509248)/ list of members of the 15th Lok Sabha (Q42509330)
preferably with a reference URL (P854) (ideally to the official site), and with modifiers (where known/appropriate):
parliamentary term (P2937): 16th Lok Sabha (Q15978395)/ 15th Lok Sabha (Q2617526)
parliamentary group (P4100): National Democratic Alliance (Q129815)
member of political party (P102): Bharatiya Janata Party (Q10230)
electoral district (P768):
elected in (P2715): 2014 Indian general election (Q3587169)/ 2009 Indian general election (Q1134751)
start time (P580):
end time (P582):
end cause (P1534)> : the reason for ending this period; eg dissolution of parliament (Q741182), leaving party (Q30580660), resignation (Q796919), exclusion from a political party (Q30580630), death in office (Q5247364), crossing the floor (Q5188683).
Where known
sex or gender (P21): male (Q6581097)/ female (Q6581072)
date of birth (P569):
date of death (P570) (if deceased!)
given name (P735):

Core properties and qualifiers

[edit]
<position held (P39) : a term-specific value such as Member of the 16th Lok Sabha (Q42509248)>
Optional:
Examples -
- sat for three parliamentary terms with no break in service. She thus gets three position held (P39) entries.
- sat for three terms; resigned to fight a by-election on changing parties in the second term; then changed parties again time with no by-election in the third term. He thus gets five position held (P39) entries.

Sahitya Akademi

[edit]

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, language of work or name (P407)  View with Reasonator View with SQID, award received (P166)  View with Reasonator View with SQID, notable work (P800)  View with Reasonator View with SQID, point in time (P585)  View with Reasonator View with SQID
    # Sahitya Akademi Awarded Odia books (34 Results, 16 JAN 2019)
SELECT ?book ?bookLabel ?itemLabel ?year 
WHERE {
  ?book wdt:P31 wd:Q571.
  ?book wdt:P407 wd:Q33810.
  ?book wdt:P166 wd:Q172582.
  
  ?item wdt:P31 wd:Q5.
  ?item wdt:P800 ?book.
  ?item p:P166 ?statement.
  ?statement ps:P166 wd:Q172582.
  ?statement pq:P585 ?year.
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
}
ORDER BY DESC(?year)
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:MKar/sandbox&oldid=1253464072"