musiccaps_details (view)
6 rows where musiccaps_aspects contains "easygoing", musiccaps_aspects contains "live performance" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- easygoing · 6 ✖
- live performance · 6 ✖
- acoustic guitar 4
- male vocals 3
- banjo 2
- bluegrass 2
- cozy 2
- joyful 2
- playful 2
- simple tune 2
- upbeat 2
- acoustic rock 1
- acoustic sounding drums 1
- banjo solo 1
- bass guitar 1
- country music 1
- dance pop 1
- electric guitar 1
- electronic drums 1
- female vocal 1
- female vocals 1
- fiddle 1
- generic 1
- gospel 1
- harmony singing 1
- instrumental 1
- jazz steel pan 1
- k-pop 1
- keyboard 1
- korean 1
- male vocal 1
- mandolin 1
- melodic 1
- melodic singing 1
- percussion 1
- relaxing 1
- repeated theme 1
- rhythm 1
- simple 1
- uplifting 1
- upright bass 1
musiccaps_names (array) 17 ✖
- Music 6
- Country 3
- Bluegrass 2
- Mandolin 2
- Singing 2
- Drum 1
- Drum kit 1
- Electronic organ 1
- Flamenco 1
- Jazz 1
- Music of Asia 1
- Musical instrument 1
- Organ 1
- Percussion 1
- Ska 1
- Song 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[Comeback Stage] GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨, Show Music core 20150711 | This is a K-pop music piece being performed live by a girl group. There are female vocals singing melodically. There is a keyboard playing a simple and repeated theme. The rhythmic background consists of a danceable electronic drum beat. The atmosphere is easygoing. This piece could be playing in the background at a clothing store. | 2015-07-11T07:45:45Z | MBCkpop | Music core 20150711 GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨 ▶Show Music Core Official Facebook Page - https://www.facebook.com/mbcmusiccore | ["Music of Asia", "Music"] | ["k-pop", "dance pop", "korean", "live performance", "female vocals", "melodic singing", "keyboard", "electronic drums", "simple tune", "repeated theme", "generic", "easygoing", "upbeat"] | 9 | CretxKgW4Jk | 1408 | |
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 | |
Greensky Bluegrass | 3/01/2014 | "Letter To Seymour" - "New Rize Hill" | This is the live performance of a bluegrass music piece. There are male vocals singing together in a lively manner. There are two banjos playing the melody, one acting as the lead and the other as the rhythm. There is also an acoustic guitar following the banjos. An upright bass is playing the bass line which acts as a rhythmic background. The general atmosphere of the piece is very uplifting. The piece can be used in the soundtrack of rural comedies. It could also be used in the background for funny social media content. | 2014-04-20T16:36:51Z | GreenskyBluegrass | Greensky Bluegrass live at the Neptune Theater in Seattle, Washington on March 1, 2014 performing a medley of Letter To Seymour into New Rize Hill. Anders Beck: dobro Michael Arlen Bont: banjo and vocals Dave Bruzza: guitar and vocals Mike Devol: bass and vocals Paul Hoffman: mandolin and vocals Filmed & Edited by Mark Burgin (tapermark) © 2014 Greensky Bluegrass All Rights Reserved www.greenskybluegrass.com | ["Flamenco", "Music", "Mandolin", "Bluegrass"] | ["bluegrass", "live performance", "male vocals", "banjo", "banjo solo", "upright bass", "acoustic guitar", "playful", "joyful", "uplifting", "easygoing"] | 9 | Tvwi_YuLehk | 2876 | |
Andy Narell Solo | This is the live performance of a percussion piece. There is a playful sounding jazz steel pan solo being performed on stage. The atmosphere is easygoing. This piece could be used during tropical scenery shots in a movie with a summer/vacation theme. | 2008-03-30T15:10:09Z | nehpets99 | Andy Narell, world famous steel pan composer/performer, solos as the guest artist for Miami University's Steel Band. | ["Organ", "Drum", "Drum kit", "Jazz", "Electronic organ", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["percussion", "rhythm", "live performance", "instrumental", "jazz steel pan", "playful", "relaxing", "easygoing"] | 9 | cQpK9zs_uv0 | 3706 | |
Dos Eddies-Come And Get Your Love (cover)-HD-Ogden Tap Room-Ogden, NC-6/14/14 | This is a live acoustic performance of a rock music song. There is a male vocalist singing at a medium-to-high pitch in a melodic manner while two acoustic guitars are carrying the background with a simple tune composed of only four chords. The music might be played at a bar in the background. | 2014-06-17T01:56:11Z | castromusicfreak | Dos Eddies performing Redbone's "Come And Get Your Love" at the Ogden Tap Room in Ogden, NC on 6/14/14. Greg Miller and Mark Weathers have created an acoustic duo version of The Steady Eddies, streamlined for those events that call for an unplugged experience. For more information about Dos Eddies, visit their Facebook page at: https://www.facebook.com/pages/Dos-Eddies/152709704894082 Video by Sue Kropp A Stolen Rune Recording | ["Country", "Music"] | ["acoustic rock", "acoustic guitar", "male vocal", "live performance", "simple", "melodic", "easygoing"] | 9 | eiFyXXqd9Rk | 3892 | |
Doyle Lawson and Quicksilver - Just Over In Heaven | This is the live performance of a bluegrass gospel music piece. There are male vocals synchronously harmony singing which is called a "stack" in bluegrass music. The melody is being played by the fiddle, the banjo, the acoustic guitar and the mandolin. There is a cozy atmosphere in this piece. It could be playing in the background of an American roadside diner. This piece could also be played at a Christian religious event. | 2010-11-26T01:42:06Z | Colt28683 | Doyle Lawson and Quicksilver - Just Over In Heaven Bluegrass Gospel | ["Singing", "Country", "Music", "Bluegrass"] | ["bluegrass", "gospel", "live performance", "male vocals", "harmony singing", "fiddle", "banjo", "acoustic guitar", "mandolin", "easygoing", "cozy"] | 9 | hHqrcLiKJRg | 4093 |
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;