musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "home recording" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- home recording · 2 ✖
- slow tempo 2
- acoustic guitar 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- echo tones 1
- female singing 1
- filler music 1
- groovy bass line 1
- guitar lead 1
- home video 1
- husky voice 1
- keyboard harmony 1
- lonely 1
- lonely sad 1
- melancholic 1
- mellow 1
- modern pop 1
- muffled guitar quality 1
- out of time 1
- poignant 1
- pop 1
- relaxing 1
- room acoustics 1
- sad 1
- soft 1
- steady drumming rhythm 1
musiccaps_names (array) 9 ✖
- Music 2
- Steel guitar, slide guitar · 2 ✖
- Acoustic guitar 1
- Distortion 1
- Electric guitar 1
- New-age music 1
- Rock music 1
- Strum 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
bathtub - waxahatchee (cover) | A female vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The guitar sound is muffled. The song is sad,poignant, melancholic, sentimental,emotional and lonely. This song is Pop. | 2013-10-01T02:06:18Z | gabbywade | idk hey blog: http://2003rapvideo.tumblr.com/ instagram: veganclit_ | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Vocal music"] | ["home video", "home recording", "female singing", "lonely sad", "room acoustics", "muffled guitar quality", "husky voice", "lonely", "sad", "poignant", "acoustic guitar", "slow tempo", "soft", "mellow", "poignant", "melancholic", "pop"] | 7 | mq_b6QKVsuc | 4495 |
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;