musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "live performance" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- bass guitar · 2 ✖
- live performance · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic sounding drums 1
- christian church 1
- country music 1
- cozy 1
- easygoing 1
- electric guitar 1
- female vocal 1
- gospel 1
- groovy 1
- joyful 1
- male choir 1
- male vocal 1
- male vocals 1
- melodic singing 1
- organ 1
- preach 1
- religious 1
- simple tune 1
- tambourine 1
- upbeat 1
youtube_published (date) 2 ✖
- 2012-04-02 1
- 2014-04-08 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mandolin Bridge Part 1 | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | 2014-04-08T18:01:39Z | janrohan | This video is about the Mandolin Bridge band Ohio -- rocking country, dance and oldies! Visit us at www.mandolinbridge.com ! | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | 9 | QSaX7QfeWog | 2620 | |
Whose Uncle Is This On The Tambourine??? | This is a live Christian gospel music performance. There is male lead vocal singing melodically and passionately with the backing of a male choir. The melody is being played by a church organ and a bass guitar. The acoustic drums and the tambourine played in a very eccentric manner are the elements of the rhythmic background. The atmosphere is religious. This piece could be played at Christian religious events or in the background of Christian social media content. | 2012-04-02T03:09:21Z | Thebookoffunny dotcom | Check Out this Wonderful Black Youtube Family based on Faith, Family,Film! www.Youtube.com/thefamilyoyoutube ► Subscribe to their Channel Here: http://www.youtube.com/subscription_center?add_user=blessedfilmsinc | ["Music", "Song", "Tambourine"] | ["gospel", "preach", "live performance", "male vocal", "melodic singing", "male choir", "organ", "bass guitar", "acoustic drums", "tambourine", "groovy", "religious", "christian church"] | 9 | XvtL_TTLXHY | 3236 |
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;