Wikidata

User:Máté/ratings/years

< User:Máté‎ | ratings

The following query uses these:

  • Properties: instance of (P31)  View with Reasonator View with SQID, subclass of (P279)  View with Reasonator View with SQID, publication date (P577)  View with Reasonator View with SQID, minimum age (P2899)  View with Reasonator View with SQID
    SELECT ?year ((round(avg(?age)*10)/10) AS ?avg)
       ((round(sum((?age-?avg)*(?age-?avg))*100/count(?age))/100) AS ?var)
       (count(distinct ?film) AS ?films) (count(?age) AS ?ratings)
WHERE {
  { SELECT ?film ?age (year(min(?date)) AS ?year)
    WHERE {
      [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p .
      ?film wdt:P31/wdt:P279* wd:Q11424; wdt:P577 ?date; ?p [ wdt:P2899 ?age ] .
    } GROUP BY ?film ?age
  }
  { SELECT ?year (avg(?avgf) AS ?avg)
    WHERE {
      { SELECT ?film (year(min(?date)) AS ?year) (avg(?age) AS ?avgf)
        WHERE {
          [] wdt:P31 wd:Q24716199; wikibase:directClaim ?p .
          ?film wdt:P31/wdt:P279* wd:Q11424; wdt:P577 ?date; ?p [ wdt:P2899 ?age ] .
        } GROUP BY ?film
      }
    } GROUP BY ?year
  }
} GROUP BY ?year ORDER BY DESC(?year)
Try it!

18:59, 26 November 2016 (UTC) edit

Year Mean SD Films Ratings
11.5 [9.1; 13.8] 5.76 6 6
11.1 [10.9; 11.2] 5.53 530 827
11.7 [11.5; 11.8] 5.04 637 939
11.7 [11.5; 11.8] 5.09 553 699
12.1 [11.8; 12.3] 5.03 438 504
12.0 [11.7; 12.2] 5.11 475 550
11.8 [11.5; 12.0] 5.48 523 588
11.7 [11.4; 11.9] 5.53 520 591
12.3 [12.0; 12.5] 5.25 581 664
12.3 [12.1; 12.4] 5.16 608 711
12.1 [11.9; 12.2] 5.20 661 754
11.9 [11.6; 12.1] 5.25 557 607
11.6 [11.3; 11.8] 5.39 441 459
11.2 [10.9; 11.4] 5.27 412 421
11.5 [11.2; 11.7] 5.11 385 406
12.1 [11.8; 12.3] 4.79 396 435
12.2 [11.9; 12.4] 4.48 400 428
11.7 [11.4; 11.9] 4.90 352 387
11.8 [11.5; 12.0] 4.69 332 374
12.0 [11.7; 12.2] 4.72 321 350
12.2 [11.9; 12.4] 4.68 306 334
11.9 [11.6; 12.1] 4.53 305 330
11.7 [11.4; 11.9] 4.94 274 293
11.0 [10.6; 11.3] 4.94 243 261
12.3 [12.0; 12.5] 4.48 245 274
12.2 [11.8; 12.5] 4.56 216 228
12.2 [11.8; 12.5] 4.57 211 227
12.5 [12.2; 12.7] 4.26 210 222
12.9 [12.6; 13.1] 4.07 217 231
12.9 [12.6; 13.1] 4.08 230 240
12.4 [12.0; 12.7] 4.58 206 221
12.8 [12.4; 13.1] 4.37 177 194
13.0 [12.7; 13.2] 3.78 198 215
12.6 [12.2; 12.9] 4.34 173 184
13.2 [12.8; 13.5] 3.99 148 165
12.3 [11.9; 12.6] 4.38 144 158
12.9 [12.5; 13.2] 4.42 138 150
12.5 [12.1; 12.8] 4.31 148 153
12.3 [11.9; 12.6] 4.02 134 145
13.1 [12.7; 13.4] 4.00 140 146
12.2 [11.7; 12.6] 5.47 143 151
12.9 [12.5; 13.2] 4.84 151 159
12.5 [12.1; 12.8] 4.60 140 147
13.1 [12.7; 13.4] 4.40 146 153
13.3 [12.9; 13.6] 4.44 141 146
13.0 [12.6; 13.3] 4.16 151 162
13.8 [13.5; 14.0] 4.01 181 187
13.5 [13.1; 13.8] 4.49 158 166
13.0 [12.6; 13.3] 4.59 160 167
13.1 [12.7; 13.4] 4.72 178 185
13.3 [13.0; 13.5] 4.19 191 196
13.0 [12.6; 13.3] 4.67 188 195
12.4 [12.1; 12.6] 3.96 182 189
12.0 [11.7; 12.2] 4.14 198 203
12.2 [11.8; 12.5] 4.03 138 141
11.9 [11.5; 12.2] 4.05 158 166
12.0 [11.6; 12.3] 4.36 158 161
11.7 [11.3; 12.0] 4.07 132 138
11.1 [10.7; 11.4] 4.26 143 146
11.4 [11.0; 11.7] 4.51 146 151
11.8 [11.5; 12.0] 3.70 153 158
10.9 [10.5; 11.2] 3.91 131 134
10.6 [10.2; 10.9] 4.34 130 132
10.2 [9.7; 10.6] 4.53 102 106
10.4 [9.9; 10.8] 4.72 101 104
11.4 [11.0; 11.7] 3.76 93 94
12.5 [12.1; 12.8] 3.58 87 89
11.8 [11.4; 12.1] 4.05 107 113
10.4 [9.5; 11.2] 4.70 28 28
12.4 [11.8; 12.9] 4.21 53 54
12.4 [11.8; 12.9] 3.79 47 47
12.7 [12.0; 13.3] 3.54 33 34
12.8 [12.2; 13.3] 3.06 35 35
11.7 [11.0; 12.3] 4.16 40 40
10.6 [9.8; 11.3] 4.68 41 42
11.4 [10.7; 12.0] 4.21 39 42
10.5 [9.8; 11.1] 4.65 46 46
11.0 [10.3; 11.6] 4.75 46 49
10.4 [9.8; 10.9] 4.18 50 50
10.1 [9.4; 10.7] 4.52 44 45
11.3 [10.6; 11.9] 3.53 31 31
9.7 [8.7; 10.6] 5.71 39 39
10.4 [9.6; 11.1] 4.42 32 33
10.8 [9.9; 11.6] 4.85 34 34
8.1 [7.1; 9.0] 4.94 27 27
11.4 [10.5; 12.2] 4.22 24 24
8.8 [7.8; 9.7] 4.99 25 25
8.1 [6.9; 9.2] 5.04 19 19
8.4 [7.1; 9.6] 3.97 10 10
6.0 [5.0; 6.9] 2.82 9 9
6.9 [5.4; 8.3] 3.88 6 7
8.0 [6.3; 9.6] 2.82 3 3
4.0 [2.3; 5.6] 2.82 3 3
4.0 [2.3; 5.6] 2.82 3 3
3.0 [0.8; 5.1] 3.00 2 2
3.6 [1.4; 5.7] 4.80 5 5
6.0 [6.0; 6.0] 0.00 2 2
12.0 [12.0; 12.0] 0.00 1 1
6.0 [1.7; 10.2] 6.00 2 2
6.0 [6.0; 6.0] 0.00 1 1
9.0 [6.8; 11.1] 3.00 2 2
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Máté/ratings/years&oldid=418475258"