musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental" and musiccaps_names contains "Gospel music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- instrumental · 4 ✖
- acoustic guitar 2
- banjo 2
- bluegrass 2
- mandolin 2
- no voice 2
- active drums 1
- boomy 1
- calming 1
- country 1
- crowd noise 1
- double bass 1
- drum kit 1
- easygoing 1
- electric bass 1
- happy mood 1
- harp 1
- joyful 1
- live recording 1
- low fidelity 1
- moderate tempo 1
- no percussion 1
- no singer 1
- pastoral 1
- piano 1
- piano trio 1
- playful 1
- pretty piano 1
- romantic 1
- rural 1
- sidestick 1
- synth pad 1
- uplifting 1
musiccaps_names (array) 11 ✖
- Gospel music · 4 ✖
- Music 4
- Bluegrass 2
- Christmas music 1
- Country 1
- Flamenco 1
- Folk music 1
- Music of Bollywood 1
- Music of Latin America 1
- Rhythm and blues 1
- Soul music 1
youtube_published (date) 4 ✖
- 2007-06-26 1
- 2007-07-31 1
- 2011-08-25 1
- 2014-04-11 1
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 | |
Relaxing Harp Instrumental Christian Music | The instrumental music features a harp playing a combination of melody and accompaniment. In the background one can hear a synth pad providing harmony throughout the music excerpt. The message of the song seems romantic and the atmosphere is calming. | 2014-04-11T20:46:55Z | okcSDRmedia | ["Christmas music", "Gospel music", "Music"] | ["harp", "synth pad", "romantic", "calming", "instrumental", "no voice"] | 2 | FKChZXXhufE | 1636 | ||
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 | |
Karla Urias singing Amazing Grace w/Gospel Choir | A live recording of an instrumental piano trio. The recording is boomy and low fidelity. The drumming is active and the piano playing is pretty. The drum kit features a sidestick. Electric bass is also present. Crowd noise can be heard. Sounds like gospel music that might be heard at a church service. | 2007-07-31T04:49:03Z | Karla Urias | This was the Gospel Choir + Me singing Amazing Grace 7-29-2007 @ the Fairbanks Summer Arts Festival | ["Gospel music", "Music"] | ["live recording", "boomy", "low fidelity", "piano trio", "instrumental", "drum kit", "sidestick", "piano", "electric bass", "active drums", "pretty piano", "crowd noise"] | 8 | gAURHUoIK0M | 4011 |
Advanced export
JSON shape: default, array, newline-delimited
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;