musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "messy" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- addictive · 3 ✖
- low quality 3
- messy · 3 ✖
- punchy kick · 3 ✖
- punchy snare 3
- energetic 2
- groovy bass 2
- addictive female vocal 1
- distorted 1
- distorted bass 1
- easygoing 1
- electric guitar melody 1
- emotional 1
- filtered background male vocal 1
- flat male vocal 1
- harmonizing background female vocals 1
- harsh 1
- live performance 1
- passionate 1
- passionate female vocal 1
- r&b 1
- repetitive synth lead melody 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- snare roll 1
- string melody 1
- traditional pop 1
- uptempo hi hats 1
- wide acoustic guitar chords 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
- Music 3
- Happy music 1
- Hip hop music 1
- Music of Asia 1
- Rapping 1
- Salsa music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | The low quality recording features a rock song that consists of a passionate female vocal, alongside harmonizing background female vocals, singing over wide acoustic guitar chords, groovy bass, punchy kick and snare hits. It sounds addictive and easygoing, even though the recording is a bit messy. | 2011-03-15T21:08:19Z | Mondosigle | Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | ["Music", "Happy music"] | ["low quality", "rock", "wide acoustic guitar chords", "groovy bass", "harmonizing background female vocals", "passionate female vocal", "punchy kick", "punchy snare", "shimmering hi hats", "addictive", "easygoing", "messy"] | 4 | 7RtQpW2dSU4 | 846 | |
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 | |
Wale - Focused clean version | The low quality recording features a R&B song that consists of flat male vocals, alongside filtered background male vocals, singing over punchy kick and snare hits, shimmering cymbals, uptempo hi hats, distorted bass and repetitive synth lead melody. It sounds messy, as the frequencies are clashing with each other, but also energetic, emotional and addictive - like something you would quickly learn to sing along. | 2011-11-26T16:53:06Z | DjDrewskie | I was Really Feeiling His Albm But There Was No Clean Version Anywhere So You KNow I Had To Do It! if want anymore songs done comment nd ill get to it I DO NOT OWN ANY RIGHTS TO THIS SONG RML | ["Music", "Rapping", "Zing", "Hip hop music"] | ["low quality", "r&b", "uptempo hi hats", "distorted bass", "repetitive synth lead melody", "filtered background male vocal", "punchy snare", "shimmering cymbals", "punchy kick", "flat male vocal", "energetic", "emotional", "addictive", "messy"] | 4 | nSLxQLYYoNE | 4538 |
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;