musiccaps_details (view)
3 rows where musiccaps_aspects contains "muffled instrumental" and musiccaps_author = 4 sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality 3
- muffled instrumental · 3 ✖
- noisy 3
- cover 1
- crushed 1
- crushed audio 1
- distorted bass guitar 1
- emotional 1
- energetic 1
- groovy 1
- harsh 1
- live prrformance 1
- loud 1
- mono 1
- muffled echoing male vocal 1
- passionate 1
- punk 1
- rock 1
- screaming female vocal 1
musiccaps_names (array) 6 ✖
- Music 3
- Bass guitar 1
- Middle Eastern music 1
- Music of Bollywood 1
- Radio 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rats - Pearl Jam | The low quality recording features a cover of a rock song and it consists of distorted bass guitar playing over muffled audio. The recording is distorted and very noisy, almost crushed, but it still sounds groovy. | 2009-11-05T15:21:32Z | frschone | I like this song very much, so I thought, lets cover it. There is much improvisation in it. In the solo itself I did my own thing :P | ["Bass guitar", "Music", "Radio"] | ["distorted bass guitar", "crushed audio", "muffled instrumental", "noisy", "low quality", "cover", "rock", "groovy"] | 4 | R3urUtvSgkU | 2662 | |
The Mentalists/The Good Ship | The low quality recording features a live performance of a punk song that consists of screaming female vocal singing over a muffled instrumental. It sounds energetic, harsh, crushed, loud and the recording is noisy and in mono. | 2007-05-31T20:39:50Z | Allyn Lai | Another tune by The Mentalists | ["Music", "Steelpan"] | ["low quality", "live prrformance", "punk", "screaming female vocal", "loud", "crushed", "noisy", "muffled instrumental", "energetic", "harsh", "mono"] | 4 | Ex18Xwznj60 | 1603 | |
Dosti All Songs Jukebox (HD) | Evergreen Bollywood Songs | Classic Old Hindi Songs | The low quality recording features a muffled echoing male vocal singing over a muffled instrumental. It sounds noisy, but also passionate and emotional. | 2015-09-16T04:00:32Z | Rajshri | Relish all the evergreen songs of Dosti (1964) now in HD only on Rajshri! Song List : 00:16 - Chahoonga Main Tujhe Saanj Savere 04:44 - Rahi Manwa Dukh Ki Chinta 09:01 - Jaanewalo Zara 14:38 - Meri Dosti Mera Pyar 18:30 - Mera To Jo Bhi Kadam 22:44 - Gudiya Kab Tak Na Hasogi Music that was a landmark in the glory of Indian cinema, emerged as a blockbuster hit and fetched the musical duo, Laxmikant-Pyarelal their first Filmfare award, songs of Dosti have moved people in every aspect and still continues to do so. Share on Facebook: https://goo.gl/p62Fvl Tweet it: https://goo.gl/8BtHDD Share on G+: https://goo.gl/Iajnvj Subscribe To Our Channel : http://bit.ly/SubscribeToRajshri Follow us on G+ http://plus.google.com/+rajshri Like us on Facebook - https://www.facebook.com/rajshri Follow us on Twitter - https://twitter.com/Rajshri Follow us on Pinterest - http://www.pinterest.com/rajshrivideos Visit Rajshri's Website - http://www.rajshri.com | ["Music", "Middle Eastern music", "Music of Bollywood"] | ["low quality", "muffled echoing male vocal", "muffled instrumental", "noisy", "passionate", "emotional"] | 4 | AVVfOYSmexM | 1126 |
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;