musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "strings melody" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 28 ✖
- groovy bass · 3 ✖
- low quality 3
- strings melody · 3 ✖
- energetic 2
- punchy kick 2
- acoustic guitar chords 1
- aggressive 1
- breathy flute melody 1
- distorted static sound 1
- distorted wide electric guitars 1
- energetic cymbals 1
- fun 1
- groovy 1
- happy 1
- harmonized vocals 1
- harmonizing male vocals 1
- manic 1
- metal 1
- passionate 1
- pop 1
- punchy snare 1
- regional mexican 1
- repetitive piano melody 1
- screaming female vocal 1
- traditional 1
- wide acoustic rhythm guitar 1
- wide bouncy wooden percussion 1
- wooden percussions 1
musiccaps_names (array) 4 ✖
- Music 3
- Angry music 1
- Middle Eastern music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Nightcore Fight Inside | The low quality recording features a metal song that consists of a screaming female vocal singing over punchy kick and snare hits, energetic cymbals, groovy bass guitar, wide distorted electric guitars, strings melody and repetitive piano melody. At the very end of the loop, there is a short distorted static sound. It sounds energetic, aggressive and manic. | 2012-08-10T08:11:02Z | Tobias Fritz Holm | Like and Subscribe. picture: http://i1.ytimg.com/vi/BscoQHJrNm8/maxresdefault.jpg | ["Music", "Angry music"] | ["low quality", "metal", "screaming female vocal", "punchy snare", "energetic cymbals", "punchy kick", "repetitive piano melody", "distorted wide electric guitars", "groovy bass", "strings melody", "energetic", "aggressive", "manic", "distorted static sound"] | 4 | BscoQHJrNm8 | 1300 | |
Atif Aslam Olpers Qawwali / Naat Hum Mustafavi Hain | The low quality recording features a traditional pop song that consists of harmonized vocals singing over breathy flute melody, groovy bass, wooden percussion, strings melody and acoustic guitar chords. It sounds happy and fun - like a song you would hear in a TV commercial. | 2009-08-21T07:54:51Z | fsfaizan | Download it from http://www.koolmuzone.com/2009/08/atif-aslam-olpers-qawwali-audio/ The Naat/Qawwali is done by Atif Aslam for Engro foods which produces milk products. Lyrics: Hum Mustafavi Hain Aaa.. Hum Ne Ki Dawat Kul Aalam Mein We Have A Message Peace For The Earth Maslak Aam... Hamara.... Sub Ki Zubaan Par Sub Kay Diloon Mein Yeh Paighaam.. Hamara... Allah Ho Akbar X 2 Hum Ta Wa Abad Saiyoo Taghiyor Kay Wali Hein Hum Ta Wa Abad Saiyoo Taghiyor Kay Wali Hein Hum Mustafavi Mustafavi Mustafavi Hein X 2 Mustafavi Hein Deen Hamara Deeno Mukamal Is Kay Maa Hai Baat e Arzal Khair Hai Jedo Jahed Musalsal InAllah X 6 Allah Ho Akbar X 2 | ["Music", "Middle Eastern music"] | ["low quality", "pop", "traditional", "breathy flute melody", "groovy bass", "wooden percussions", "harmonized vocals", "strings melody", "acoustic guitar chords", "happy", "fun"] | 4 | nONXdP6T3pc | 4534 |
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;