musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "live performance" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- flat male vocal · 2 ✖
- live performance · 2 ✖
- low quality 2
- addictive 1
- arpeggiated electric guitar melody 1
- crowd cheering 1
- crowd singing 1
- emotional 1
- folk 1
- groovy bass guitar 1
- noisy 1
- passionate 1
- punchy kick 1
- rock 1
- shimmering hi hats 1
- snappy rimshots 1
- steel guitars melodies 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Old Man Luedecke - I'm Fine (I Am, I Am) | The low quality recording features a short snippet of flat male vocals, followed by steel guitar melodies. It sounds passionate, even though the recording is very noisy. | 2012-10-01T19:57:33Z | AnalogSongs | Recorded live on the beach in Chester, NS with Old Man Luedecke and Joel E Hunt on mandolin. From the new album Tender is the Night, released October 2nd, 2012 http://oldmanluedecke.ca Video by Analog Songs: http://www.analogsongs.ca Camera and post production: Stephen Cooper and Katy Hopkins, Audio recording and post production: Cameron Dexter | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "steel guitars melodies", "flat male vocal", "passionate", "folk", "live performance"] | 4 | kIEEDYowZhA | 4307 |
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;