musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "addictive", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- addictive · 4 ✖
- live performance · 4 ✖
- low quality 4
- punchy kick · 4 ✖
- punchy snare 3
- shimmering hi hats 3
- emotional 2
- energetic 2
- flat male vocal 2
- groovy bass 2
- passionate 2
- rock 2
- addictive female vocal 1
- alternative/indie 1
- arpeggiated electric guitar melody 1
- audio distortion 1
- crowd cheering 1
- crowd singing 1
- distorted 1
- drum break 1
- electric guitar chord progression 1
- electric guitar melody 1
- groovy 1
- groovy bass guitar 1
- groovy thin bass guitar 1
- harmonizing background vocals 1
- harsh 1
- messy 1
- passionate female vocals 1
- shimmering crash cymbal 1
- …
musiccaps_names (array) 9 ✖
- Music 4
- Singing 2
- Blues 1
- Choir 1
- Exciting music 1
- Music of Asia 1
- Musical instrument 1
- Rock and roll 1
- Salsa music 1
youtube_published (date) 4 ✖
- 2007-12-08 1
- 2008-04-19 1
- 2008-06-25 1
- 2015-11-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ill Scarlett - Babylon Song @ Sound of Music | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | 2008-06-25T11:52:33Z | KyleCherops | ill Scarlett - "Babylon Song" live at Sound of Music Festival 2008 Burlington, ON | June 14, 2008 video 04 of 10 shot by Kyle Cheropita www.ishotyourset.net www.cherops.com | ["Music", "Rock and roll", "Exciting music"] | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | 4 | 8akqVDDGsNQ | 931 | |
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 | |
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 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 |
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;