turbot/youtube

Query: youtube_channel_overview

Usage

powerpipe query youtube.query.youtube_channel_overview

SQL

select
youtuber as "Channel",
created_month as "Created Month",
created_year as "Created Year",
country_rank as "Country Rank",
video_views_for_the_last_30_days as "Views (Last 30 Days)",
subscribers_for_last_30_days as "Subscribers (Last 30 Days)",
country as "Country",
population as "Country Population",
unemployment_rate as "Country Unemployment Rate",
gross_tertiary_education_enrollment_percent as "Country Gross Tertiary Education Enrollment Percent"
from
youtube_statistics
where
rank = $1;

Dashboards

The query is used in the dashboards: