Wikidata:WikiProject Performing arts/Statistics

From Wikidata
Jump to navigation Jump to search

Pfeil oben.svg

 

Home

 

Data Structure

 

Typology

 

Data Sources

 

Use Cases

 

Tools & Tasks

 

Statistics

 

Creative Works and Performing Arts Productions – Item Counts[edit]

Statistics (number of items)
Date Musical Work Edition of Musical Work Choreo-graphic Work Edition of Choreographic Work Play (incl. opera) Edition of Play Opera Aria Opera with listing of arias Character Role (Play / Opera) Play / Opera with indication of character roles Performing Arts Production Performance Series of Performances Season (Performing Arts) Cast Member (Performing Arts Production) - each person is counted once per production
2017-12-21 n/a n/a n/a n/a 17359 291 n/a n/a n/a n/a n/a 126 n/a 1 3 131
2018-01-16 n/a n/a n/a n/a 17443 295 n/a n/a n/a n/a n/a 864 n/a 3 34 11445
2018-03-11 n/a n/a n/a n/a 17578 311 n/a n/a n/a n/a n/a 882 n/a 3 34 11440
2018-04-01 n/a n/a n/a n/a 17602 326 4652 n/a n/a n/a n/a 889 219 4 36 11469
2018-06-14 n/a n/a n/a n/a 19323 342 5123 380 n/a 967 n/a 1030 285 4 67 11620
2018-06-18 n/a n/a n/a n/a 20814 342 6599 4009 520 10101 1196 1036 288 4 70 11629
2018-07-09 n/a n/a n/a n/a 20872 344 6608 4009 520 10094 1197 1057 292 4 71 11638
2018-08-23 n/a n/a n/a n/a 21007 381 6616 4012 520 10074 1196 1149 342 4 105 11693
2018-11-05 n/a n/a n/a n/a 21484 432 6711 3974 520 10224 1253 13642 374 15 124 43862
2018-12-03 n/a n/a n/a n/a 21582 530 6677 3973 520 10235 1258 17537 3662 15 129 45268
2019-02-27 n/a n/a n/a n/a 21088 643 6690 3974 521 10867 1383 20542 3743 10 225 50124
2019-03-11 416984 574 880 4 21100 650 6693 3974 521 10869 1386 17905 3749 10 225 50150
2019-04-29 436069 662 888 4 21240 683 6702 3974 521 11104 1410 18047 3787 11 265 51280
2019-06-15 437398 753 890 4 21346 718 6719 3976 521 22335 2320 18215 3810 11 273 53449
2019-10-15 448933 1337 895 4 21890 758 6747 3974 521 22780 2405 20583 4040 11 273 54214
2020-05-17 469765 1848 901 4 22831 821 6800 3974 521 23889 2511 21107 4452 12 307 59255

Items of the class "Musical Work" (and its sub-classes)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q2188189.
}

Try it!


Items of the class "Edition" of a "Musical Work" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel ?work ?workLabel
WHERE 
{
  ?item wdt:P629 ?work.
  ?work wdt:P31/wdt:P279* wd:Q2188189
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Choreographic Work" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q58483088.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Edition" of a "Choreographic Work" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel ?work ?workLabel
WHERE 
{
  ?item wdt:P629 ?work.
  ?work wdt:P31/wdt:P279* wd:Q58483088
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Play" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q25379.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Edition" of a "Play" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel ?work ?workLabel
WHERE 
{
  ?item wdt:P629 ?work.
  ?work wdt:P31/wdt:P279* wd:Q25379
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Items of the class "Opera" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q1344.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Aria" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q178122.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Opera" with a listing of at least one aria[edit]

SELECT DISTINCT ?opera ?operaLabel
WHERE 
{
  ?opera wdt:P31/wdt:P279* wd:Q1344.
  ?aria wdt:P31/wdt:P279* wd:Q178122.
  ?aria wdt:P361 ?opera.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en,de,fr,ru". }
}

Try it!

Fictional characters (or subclasses) that are present in a play (or subclass)[edit]

SELECT DISTINCT ?character ?characterLabel ?play ?playLabel
WHERE 
{
  ?play wdt:P31/wdt:P279* wd:Q25379.
  ?character wdt:P31/wdt:P279* wd:Q95074.
  ?character wdt:P1441 ?play.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Items of the class "Play" with indication of character roles[edit]

SELECT DISTINCT ?play ?playLabel
WHERE 
{
  ?play wdt:P31/wdt:P279* wd:Q25379.
  ?role wdt:P31/wdt:P279* wd:Q95074.
  ?role wdt:P1441 ?play.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it,fr,de,es,ru". }
}

Try it!

Items of the class "Performing Arts Production" (and its sub-classes)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q43099500.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Performance" (and its sub-classes, but without wrestling events)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q35140.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q21156425. }
}

Try it!


Items of the class "Series of Performances" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q43100730.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Season" which are used in combination with a performing arts production[edit]

SELECT DISTINCT ?item ?itemLabel ?season ?seasonLabel
WHERE 
{
  ?item wdt:P31 ?season.
  {?production wdt:P31/wdt:P279* wd:Q43099500. ?production wdt:P2348 ?item}
  UNION {?series wdt:P31/wdt:P279* wd:Q43100730 . ?series wdt:P2348 ?item} 
  UNION {?performance wdt:P31/wdt:P279* wd:Q35140. ?performance wdt:P2348 ?item}.
   
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Performers who are listed as "cast member" of a performing arts production (each person is listed once per production)[edit]

SELECT DISTINCT ?item ?itemLabel ?production ?productionLabel
WHERE 
{
  ?production wdt:P31/wdt:P279* wd:Q43099500.
  ?production wdt:P161 ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Performing Arts Venues – Item Counts[edit]

Statistics (number of items)
Date Performing Arts Building Theatre (Venue) Music Venue Circus Building Auditorium (= room within a performing arts building) Stage
2017-12-21 n/a 12903 n/a n/a n/a 3
2018-01-16 n/a 14252 n/a n/a n/a 3
2018-03-11 n/a 14342 n/a n/a n/a 3
2018-04-01 n/a 14487 n/a n/a n/a 3
2018-06-14 n/a 14600 n/a n/a n/a 3
2018-06-18 n/a 14611 n/a n/a n/a 3
2018-07-09 n/a 14679 n/a n/a n/a 3
2018-08-23 n/a 14962 n/a n/a n/a 5
2018-11-05 n/a 15478 n/a n/a n/a 6
2018-12-03 n/a 15533 n/a n/a n/a 6
2019-02-27 n/a 16709 n/a n/a n/a 17
2019-03-11 19861 16740 3515 34 99 17
2019-04-29 20105 16896 3600 36 101 26
2019-06-15 20586 17109 3670 39 102 28
2019-10-15 21125 17445 3860 44 117 27
2020-05-17 22083 18088 4141 68 146 34


Items of the class "Performing Arts Building" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q57660343.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Theatre (venue)" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q24354.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Music Venue" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q8719053.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Circus Building" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q56195017.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Auditorium" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q230752.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Stage" (and its subclasses)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q194428.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Humans and Organizations Related to the Performing Arts – Item Counts[edit]

Statistics (number of items)
Date Musician Actor/Actress Cast Member (humans listed at least once as a cast member of a performing arts production) Stage Director Scenographer Costume designer Conductor Choreographer Musical Ensemble Theatrical Troupe Dance Troupe Production Company (organizations listed at least once as production company of a performing arts production)
2019-03-11 256657 251864 12679 7551 3490 2734 17925 6147 86761 5023 340 2235
2019-10-15 271781 267820 14533 8592 3774 3028 18576 6587 92652 5171 368 2358
2020-05-17 284887 279624 15624 9016 3924 3289 19149 6797 96240 5556 402 2443


Items of the class "Human" and the occupation "musician" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q639669.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "actor" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q33999.
  ?item wdt:P31 wd:Q5.
}

Try it!


Performers who are listed as "cast member" of a performing arts production (only humans, excluding collectives)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?production wdt:P31/wdt:P279* wd:Q43099500.
  ?production wdt:P161 ?item.
  ?item wdt:P31/wdt:P279* wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "stage director" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q3387717.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "scenographer" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q2707485.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "costume designer" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q1323191.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "conductor" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q158852.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Human" and the occupation "choreographer" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item
WHERE 
{
  ?item wdt:P106/wdt:P279* wd:Q2490358.
  ?item wdt:P31 wd:Q5.
}

Try it!


Items of the class "Musical Ensemble" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q2088357.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Theatrical Troupe" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q742421.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!


Items of the class "Dance Troupe" (or a sub-class thereof)[edit]

SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q2393314.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Organizations listed as "production company" of a performing arts production[edit]

SELECT DISTINCT ?item ?itemLabel 
WHERE 
{
  ?production wdt:P31/wdt:P279* wd:Q43099500.
  ?production wdt:P272 ?item.
  ?item wdt:P31/wdt:P279* wd:Q43229.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!