musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "gentle" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitar · 3 ✖
- gentle · 3 ✖
- instrumental · 3 ✖
- no singer 2
- piano 2
- acoustic drums 1
- arpeggio 1
- easygoing 1
- emotional 1
- guitar cover 1
- mellow 1
- mellow tune 1
- optimistic 1
- poor quality 1
- relaxing 1
- romantic 1
- soap opera soundtrack 1
- strings 1
- violin 1
musiccaps_names (array) 9 ✖
- Music 3
- Acoustic guitar 1
- Echo 1
- Guitar 1
- Musical instrument 1
- New-age music 1
- Plucked string instrument 1
- Sad music 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shout to the Lord - American Sign Language | This is a poor quality instrumental piece played in the background of a sign language video. There is an optimistic sounding tune being played by the strings, the piano and the acoustic guitar. The atmosphere is mellow and gentle. Samples from this piece could be lifted to be used in beat-making. | 2010-11-08T21:09:46Z | Ag00dgranma | Class, here is our new song for class. Sorry it took me so long to get it up. Hope you enjoy and happy signing. | ["Echo", "New-age music", "Music"] | ["poor quality", "no singer", "instrumental", "piano", "strings", "acoustic guitar", "gentle", "mellow", "optimistic"] | 9 | -RYtUAsNhF0 | 46 | |
Kiralık Aşk - Enstrümantal Fon Müzik 2 || Instrumental Background Music 2 | This is an instrumental piece from a soap opera soundtrack. The violin and the acoustic guitar are playing a mellow tune while there is an occasional piano tune in the background. The rhythm is kept by a very quiet acoustic drum beat. The atmosphere is gentle and romantic. This piece could be used in the soundtrack of romance movies where the characters are having a good time in the presence of each other. | 2015-12-14T11:19:46Z | Kiralık Aşk Soundtrack | ABONE OL tuşuna basarak kanalıma abone olmayı unutmayın! Please do not forget to SUBSCRIBE my channel! | ["Music", "Sad music"] | ["soap opera soundtrack", "instrumental", "violin", "acoustic guitar", "piano", "acoustic drums", "gentle", "emotional", "romantic"] | 9 | 7eZTmLV9gcY | 871 | |
เธอ - Cocktail || Fingerstyle Guitar Cover by ต้นปาล์ม | This is a guitar cover video. There are no vocals in this piece. The acoustic guitar is playing a mellow tune with the heavy use of arpeggios. The atmosphere is gentle and relaxing. This piece could be used as the opening theme of a teenage drama TV series. It could also be playing in the background at a coffee shop. | 2014-05-06T10:23:45Z | tonpalm guitar | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar cover", "no singer", "instrumental", "acoustic guitar", "arpeggio", "mellow tune", "easygoing", "gentle", "relaxing"] | 9 | XWVGQbfpA0k | 3189 |
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;