turbot/imdb

Query: imdb_movie_votes_summary

Usage

powerpipe query imdb.query.imdb_movie_votes_summary

SQL

select
TotalVotes as "Total Votes",
CVotesU18 as "Votes Under 18",
CVotes1829 as "Votes 18-29",
CVotes3044 as "Votes 30-44",
CVotes45A as "Votes 45+"
from
imdb
where
movie_id = $1;

Dashboards

The query is used in the dashboards: