musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "medium tempo", musiccaps_author = 1 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- emotional · 3 ✖
- medium tempo · 3 ✖
- exciting 2
- groovy 2
- amplifier knob flicks 1
- bad audio quality 1
- bass guitar solo 1
- big band 1
- cymbal hits 1
- echo tones 1
- electric guitar lead 1
- groovy rhythm 1
- guitar amplifier 1
- guitar lead 1
- guitar licks 1
- guitar playing rhythm 1
- guitar tone test demo 1
- healing music 1
- home music video 1
- inspiring 1
- instrumental music 1
- loud music 1
- love song 1
- male singer 1
- meditation playlist 1
- melancholic 1
- missing you 1
- new age 1
- noir style 1
- nostalgia 1
- …
musiccaps_names (array) 7 ✖
- Blues · 3 ✖
- Music 2
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 | ||
Owen Barry , Vertex Effects Landau stereo chorus, Victoria | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | 2014-06-11T21:10:50Z | owen barry | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | 1 | R4b_-IT43P4 | 2663 | ||
Children - Sitting On A Flower From Rebirth 1968 Music for a Mind and the Body | The song is an instrumental. The song is medium tempo with a groovy bass line, guitar playing accompaniment along with piano and a steady drumming rhythm with cymbal hits. The song is meditative and nostalgic. The song is a new age rock inspired tune. | 2011-05-12T17:29:51Z | jonpollina | ["Blues", "Music"] | ["guitar playing rhythm", "piano accompaniment", "meditation playlist", "new age", "subtle drum play", "cymbal hits", "medium tempo", "instrumental music", "groovy rhythm", "melancholic", "old memories", "groovy", "nostalgia", "emotional", "exciting", "positive", "inspiring", "healing music", "sustained bass line"] | 1 | UDg9vuBDtVU | 2898 |
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;