musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- acoustic guitar · 6 ✖
- amateur recording · 6 ✖
- male voice 2
- medium tempo 2
- slow tempo 2
- alternative pop 1
- alternative rock 1
- animated 1
- background noises 1
- backing track 1
- boomy 1
- children’s song 1
- e-bass 1
- educational 1
- folk song 1
- funny song 1
- higher register singing 1
- home video 1
- informative 1
- learning 1
- male vocalist 1
- male voice singing 1
- medium to uptempo 1
- melancholy 1
- minimal instruments 1
- moderate tempo 1
- monotone singing 1
- romantic feel 1
- shaker 1
- simple lyrics 1
- simple melody 1
- singer-songwriter 1
- singer-songwriter/pop 1
- slide guitar 1
- soft stomping noise 1
- sound of static 1
- tambourine 1
- violin 1
musiccaps_names (array) 9 ✖
- Music 6
- Steel guitar, slide guitar · 6 ✖
- Acoustic guitar 5
- Guitar 3
- Plucked string instrument 3
- Strum 3
- Bluegrass 1
- Blues 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cours de guitare The sound of silence | Someone is playing acoustic guitar. While a higher pitched male voice is singing a sad song. This is an amateur recording. This song may be playing at home on a rainy day. | 2011-08-06T09:41:42Z | bluesbosse1 | ..des tablatures pour débutants au : www.partition-guitare-tablature.com | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["singer-songwriter", "acoustic guitar", "male voice", "higher register singing", "soft stomping noise", "melancholy", "amateur recording", "medium tempo"] | 6 | DroAzooK4yw | 1514 | |
Sleepwalk | This file contains someone playing a slide guitar melody over a backing track. The backing-track contains an e-bass playing the footnote of an acoustic guitar strumming chords. You can hear a shaker serving as a rhythmic instrument. | 2008-04-09T00:57:53Z | Usher Ben Ishay | Santo and Johnny Cover Played On my 58' Rickenbacker Lap Steel. | ["Guitar", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["amateur recording", "backing track", "slide guitar", "tambourine", "e-bass", "acoustic guitar", "slow tempo"] | 6 | EQHrQIaQNv8 | 1554 | |
Sound Check Acoustic Guitar Walden T550.avi | Someone is playing an acoustic guitar ending his phrase. In the background you can hear high pitched noises. This song may be playing at home practicing guitar. | 2012-04-20T06:39:37Z | Chacross | Sound Check Acoustic Guitar Walden T550.avi | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "slow tempo", "background noises"] | 6 | G4fTKotMoWI | 1690 | |
ライオンハート SMAP cover, Gibson Humming bird ( ギター 弾き語り スマップカバー ギブソン ハミングバード) | Someone is strumming an acoustic guitar while a male voice is singing along. This may be playing at a bonfire. | 2015-05-31T09:04:29Z | MA channel | ライオンハート SMAP cover 8曲目のアップとなります!是非!聞いてください。 | ["Blues", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["singer-songwriter/pop", "acoustic guitar", "male voice singing", "medium to uptempo", "amateur recording"] | 6 | em7akjDUsWk | 3895 | |
Derick Mar09 Irish Heartbeat | This folk song features a male voice singing the main melody. This is accompanied by an acoustic guitar. A shaker plays in place of the percussion. Violins play a melody in the background. The mood of this song is romantic. This song can be played in a flashback scene of a movie. | 2009-04-10T22:33:44Z | Ken Persson | Copyright music and lyrics reproduced by kind permission of Exile for original, exclusive performances by Van Morison, check-out the official channel at www.youtube.com/officialexilefilms. Recorded at a practice of Irish Street for a St Patrick's Day performance at Muldoon's. From L to R, Eileen, bodhran, Derick, vocals & guitar, Margaret, accordion, Brendan, fiddle, and Ken, whistle. | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Bluegrass"] | ["amateur recording", "acoustic guitar", "male voice", "shaker", "violin", "folk song", "romantic feel", "moderate tempo"] | 0 | etmmUjsRNRs | 3903 | |
Music - David Bowie Space Oddity/Major Tom | A male vocalist sings this soft pop. The tempo is medium with an acoustic guitar accompaniment and sound of static in the background. The song has simple lyrics and melody . It is informative and educational. This song is a Children’s song/Alternative Pop. | 2007-08-12T05:38:32Z | artcarver | The orchestra entrance section to the bridge - replaced with a climbing chord progression. See my Universal Records posting: http://www.unpredictableporridge.com/artist.aspx?id=589777ec-a379-4ae5-9b22-5956d51ee4bb | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["male vocalist", "medium tempo", "acoustic guitar", "boomy", "simple melody", "simple lyrics", "informative", "educational", "learning", "monotone singing", "home video", "amateur recording", "sound of static", "simple melody", "funny song", "children’s song", "alternative pop", "alternative rock", "animated", "simple melody", "minimal instruments"] | 7 | lIBsL97sUmY | 4390 |
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;