musiccaps_details (view)

3 rows where musiccaps_author = 8 and musiccaps_names contains "Christian music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
ΠΑΡΕ ΜΕ ΑΠΟΨΕ ΑΓΚΑΛΙΑ Mellow rock with a slow drum beat, acoustic strumming guitar, male and female vocalists singing in octaves. 2009-01-19T13:00:52Z kreta1giouli1cagapaw Gia pragmatika erwteumenous pou 3anazoun to oneiro ap thn arxh.. ["Christian music", "Music"] ["acoustic guitar strumming", "slow rock", "male and female singing in octaves", "mellow"] 8 5rsQHo-6DI4 700
Buzz Goertzen - The Idaho Yodeler - TheIdahoYodeler.com A female and male duo yodeling over a fast bluegrass band. The bass and drums are steady and simple as is the chord progression. The guitarist and other instrumentalists are virtuosic. 2011-03-30T18:33:50Z theidahoyodeler Nothing stirs up an audience like yodeling, and no one yodels like Buzz Goertzen. His charismatic personality, wit and unique style have endeared him to audiences everywhere. Being also a gifted songwriter as well as a humorist, it is no wonder that standing ovations are the norm wherever he performs. He has written most of his own compositions, but also sings many of the "old favorite" yodeling songs of the past. Visit his website today at www.TheIdahoYodeler.com ["Christmas music", "Singing", "Gospel music", "Yodeling", "Christian music", "Music", "Song"] ["yodeling", "female and male yodeling", "country", "fast", "bluegrass", "steady bass and drums", "guitar", "virtuosic", "simple rhythms", "simple chord progression"] 8 Y7mTjfgcybQ 3256
Inspirational Christian Music Clips Stoic music featuring steady acoustic guitar arpeggios, a clave, and a measured female singer. There is a slight tape hiss. The source material may be old. 2009-08-21T04:21:43Z Flo Fizzle AWESOME SPIRITUAL MUSIC Please comment on this selection your opinion is valued! ["Christmas music", "Christian music", "Music", "Song"] ["female singing", "measured", "acoustic guitar fingerpicking", "guitar arpeggios", "clave", "slight tape hiss", "steady rhythm", "guitar doubles vocal melody", "stoic"] 8 gHWMKew9Xq0 4021

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW musiccaps_details AS select
  musiccaps.url as video,
  json_object(
    'label',
    coalesce(videos.title, 'Missing from YouTube'),
    'href',
    musiccaps.url
  ) as youtube_link,
  musiccaps.caption as musiccaps_caption,
  videos.publishedAt as youtube_published,
  videos.channelTitle as youtube_channel,
  videos.description as youtube_description,
  musiccaps.audioset_names as musiccaps_names,
  musiccaps.aspect_list as musiccaps_aspects,
  musiccaps.author_id as musiccaps_author,
  videos.id as youtube_id,
  musiccaps.rowid as musiccaps_rowid
from
  musiccaps
  left join videos on musiccaps.ytid = videos.id;