musiccaps_details (view)

5 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_names contains "Gospel music"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
ROZBĚH BLUEGRASS MUSIC This is a bluegrass music piece. There is a mandolin playing the main tune as the lead while a banjo and an acoustic guitar are supporting it in the melodic background. There is a joyful feeling to this piece. It could be used in the soundtrack of a movie or a TV show with a rural setting. It could also be used in the background of pastoral social media content. 2011-08-25T14:41:30Z honzabaseman 00. Úvod 01. MATTERHORN 02. PLEASE SEARCH A HEART 03. FOX ON THE RUN 04. HROU ZÍSKÁŠ HROW 05. SALT CREEK 06. ZÁTOKA 07. NOČNÍ VLAK 08. ZLATÁ RYBKA 09. BLACK DIAMOND 10. PÁDÍ MISSISSIPPI 11. FOGGY MOUNTAIN BREAKDAUN 12. KAROLÍNA 13. SVÍCEN ZMIZEL V TMÁCH 14. ARKANSAS TRAVELLER 15. PÝCHA PŘEDCHÁZÍ PÁD 16. PŘÍSAHEJ 17. SAIL TO AUSTRALIA ["Gospel music", "Folk music", "Flamenco", "Music", "Music of Bollywood", "Music of Latin America", "Bluegrass"] ["bluegrass", "no singer", "instrumental", "banjo", "mandolin", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing", "rural", "pastoral"] 9 0-7PyzhzuYQ 108
Coro Gospel AGUAVIVA en Albacete 1 A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. 2010-02-07T02:22:15Z MakinGospel Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] 7 0oIFGARD9xE 210
80 MÚSICAS GOSPEL EM UM SÓ VÍDEO -VÍDEO 1/4 A female voice is singing a ballad with some reverb on her voice while an acoustic guitar is finger-picking chords on the left side of the speakers. A string section is playing harmonies along with the singer. A e,bass is played along with shakers and ride hits from a drummer. A piano is playing along with the melody. The elements are spread across the sides of the speakers. 2011-05-29T15:39:46Z Raquel Lerbach 80 Músicas Gospel em apenas um vídeo LOUVORES MÚSICA CRISTÃ HINO EVANGÉLICO HINOS LOUVOR ADORAÇÃO MUSIC GOSPEL GOSPEL MÚSICAS ESPIRITUAIS ["Gospel music", "Music", "Tender music"] ["gospel", "2 separate songs", "strings", "acoustic guitar", "acoustic drums", "e-bass", "female voice singing", "medium to uptempo"] 6 DA8lw6Mq0DY 1447
Bluegrass Gospel Music - You've Got To Choose This bluegrass song features a solo played on a mandolin. This is accompanied by an acoustic guitar strumming chords. A double bass plays the root note and fifth of the chords. A banjo player fills in between phrases. This song is at a moderate tempo and has a country feel. The mood of this song is happy. This song can be played in an inspirational movie. 2007-06-26T00:26:55Z Billy Pollard Bill Jolliff, Jacob Henry and Band, Southern Gospel Music, Strolling Down Memory Lane, Billy & Willie Pollard's Country Gospel TV Program, http://billyandwillie.tripod.com ["Gospel music", "Country", "Music", "Rhythm and blues", "Bluegrass", "Soul music"] ["bluegrass", "country", "instrumental", "no voice", "no percussion", "mandolin", "acoustic guitar", "banjo", "double bass", "moderate tempo", "happy mood"] 0 REpuZwvyThM 2681
Villancicos - Una Pandereta Suena The music features a group of female and male voices singing a melody in unison. An acoustic guitar is accompanying the group with strummed chords and a tambourine is highlighting every beat. The overall atmosphere is joyful. 2014-11-30T16:29:04Z JORGE LEMUS Coro Pastoral Juvenil, Parroquia Nuestra Señora del Carmen, Guamal, Magdalena, Colombia ["Christmas music", "Gospel music", "Jingle (music)", "Music", "Song"] ["female and male voices", "acoustic guitar", "tambourine", "joyful"] 2 fvw3Bi0GONA 3991

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;