musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- emotional · 4 ✖
- groovy bass · 4 ✖
- low quality 4
- punchy kick · 4 ✖
- shimmering hi hats 3
- passionate 2
- punchy snare 2
- rock 2
- addictive 1
- background male vocal 1
- background music 1
- cinematic 1
- clicky keys 1
- echoing synth bell melody 1
- electric guitar melody 1
- electric guitars melodies 1
- energetic 1
- flat male vocal 1
- folk 1
- harmonizing background vocals 1
- live performance 1
- metallic percussive elements 1
- passionate female vocals 1
- passionate sitar guitar 1
- pop 1
- pulsating synth melody 1
- shimmering crash cymbal 1
- short offbeat accordion chords 1
- sustained strings melody 1
- wide electric guitar melody 1
musiccaps_names (array) 11 ✖
- Music 4
- Background music 1
- Choir 1
- Drum kit 1
- Guitar 1
- Musical instrument 1
- Punk rock 1
- Rock music 1
- Sad music 1
- Singing 1
- Tender music 1
youtube_published (date) 4 ✖
- 2007-06-24 1
- 2007-12-08 1
- 2012-11-02 1
- 2014-12-16 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Muzika kurdi Kurdish Music اغاني كردية - Gule te Je kerina 👍👍👍 | The Folk song features a passionately played sitar guitar, groovy bass and short offbeat accordion chords, followed by metallic percussive elements and punchy kick. The recording is a bit lower in quality due to loud clicky keys sounds. It sounds passionate and emotional. | 2014-12-16T01:20:13Z | Muzika Kurdi | Muzika kurdi - Kurdish Music Gule te Je kerina - اغاني كردية....اشتركو بقناتي# | ["Background music", "Music", "Sad music"] | ["folk", "passionate sitar guitar", "groovy bass", "punchy kick", "metallic percussive elements", "short offbeat accordion chords", "low quality", "clicky keys", "emotional"] | 4 | -sevczF5etI | 94 | |
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
Norske Artister - Venn | The low quality recording features a live performance of a rock song that contains harmonizing background vocals, alongside passionate female vocals, singing over wide electric guitar melody, punchy snare, groovy bass, punchy kick and shimmering hi hats and crash cymbals. It sounds emotional, passionate and addictive - thanks to that cadence. | 2007-12-08T21:06:41Z | Primož Dimnik | Norske Artister - Venn (Live) Espen Lind, Lene Marlin, Sivert Hoyem, Thomas Dybdahl; Espen Lind, Lene Marlin, Bertine Zetlitz, Sissel Kyrkjebø, Kurt Nilsen; Ravi, Morten Abel, ... | ["Singing", "Music", "Choir"] | ["low quality", "live performance", "rock", "harmonizing background vocals", "passionate female vocals", "wide electric guitar melody", "punchy snare", "groovy bass", "punchy kick", "shimmering hi hats", "emotional", "passionate", "addictive", "shimmering crash cymbal"] | 4 | EsssGCL-Axw | 1597 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;