musiccaps_details (view)
3 rows where musiccaps_aspects contains "adventurous", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- adventurous · 3 ✖
- emotional · 3 ✖
- passionate 3
- poor audio quality · 3 ✖
- exciting 2
- instrumental music 2
- adventure music 1
- ambient echoes 1
- ambient noise 1
- chromatic harmony 1
- classic western music 1
- crystal glass harp solo 1
- cymbals crashing 1
- drum rolls 1
- fast tempo 1
- female singer 1
- glass harp 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar amplifier 1
- guitar demo 1
- guitar played accompaniment style 1
- guitar solo 1
- hissing tones 1
- home video 1
- keyboard accompaniment 1
- live performance 1
- magical journey 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- mysterious 1
- people talking 1
- percussive bass line 1
- retro pop hits 1
- romantic 1
- solo performance 1
- soloist 1
- steady drumming rhythm 1
- subtle bass line 1
- tone generator 1
- virtuoso glass harpist 1
- vocal duet 1
- youtube music video 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
Musical Crystal Glasses Like Never Before | The song is an instrumental piece. The song is fast tempo with a glass harpist playing an extremely intricate solo with no other instrumentation . The song is magical and mysterious. The song is a live performance with ambient sounds of people talking in the background. | 2008-02-14T01:47:31Z | Amplify | I've only seen this in dramatized situations (film, cartoon). This man is ridiculous. I bet he could satisfy a classroom of women all at once. | ["Tubular bells", "Glass", "Music"] | ["crystal glass harp solo", "glass harp", "live performance", "hissing tones", "people talking", "instrumental music", "mysterious", "adventurous", "magical journey", "instrumental music", "solo performance", "emotional", "passionate", "chromatic harmony", "fast tempo", "virtuoso glass harpist", "classic western music", "poor audio quality", "ambient noise"] | 1 | ew-7SwLcHBg | 3909 |
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;