musiccaps_details (view)
4 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "unbalanced stereo" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- flat male vocal · 4 ✖
- unbalanced stereo · 4 ✖
- low quality 3
- noisy 3
- tutorial 2
- arpeggiated electric guitar melody 1
- echoing uptempo electric guitar melody 1
- energetic 1
- fun 1
- groovy 1
- groovy bass guitar 1
- happy 1
- muffled 1
- punchy kick 1
- punchy snare 1
- resonant 1
- rock 1
- shimmering hi hats 1
- shimmering tambourine 1
- steel guitar melody 1
- traditional 1
- vintage 1
- wooden percussive elements 1
musiccaps_names (array) 16 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Das Leben ist ein Rodeo Schule Illingen Hiss | The Rock song features a flat male vocal singing over arpeggiated electric guitar melody located in the right channel of the stereo image, groovy bass guitar, punchy kick and snare hits and shimmering hi hats. The stereo image is unbalanced because of the electric guitar, which makes it lean towards the right channel. It sounds energetic, groovy, happy and fun. | 2012-04-21T15:03:23Z | 55alwin | Ein Stopp-Motion Projekt der Klasse H6, GHRS Illingen | ["Funk", "Music", "Rock music", "Ska"] | ["rock", "groovy bass guitar", "punchy snare", "flat male vocal", "shimmering hi hats", "punchy kick", "arpeggiated electric guitar melody", "energetic", "groovy", "unbalanced stereo", "happy", "fun"] | 4 | JNwt0afB1fQ | 1998 | |
Ahmad Zahir - Shab Haye Zulmani - Vol 3 | The low quality recording features a traditional song that consists of at least steel guitar melody, wooden percussive elements and flat male vocal singing over it. The recording is very noisy and the stereo image is unbalanced - pretty much destroyed. It sounds vintage. | 2012-01-17T03:43:14Z | Ahmad Zahir | 🙏 PLEASE SUBSCRIBE OUR CHANNEL ✅ FOLLOW US: 🇦🇫 @dmin Fraydoon Hakimi ► Facebook: https://www.facebook.com/afghanlatests ►Instagram: https://www.instagram.com/afghanlatest ► Twitter: https://twitter.com/afghanlatest Ahmad Zahir King of Afghanistan Music Ahmad Zahir 2020 Ahmad Zaher 2020 Ahmad Zahir 2019 Ahmad Zaher 2019 Ahmad Zahir 2018 Ahmad Zaher 2018 A * Ahmad Zahir * Ahmad Wali * Aryana Sayeed * Abdul Rahim Sarban * Amir Jan Sabori * Awalmir * Asad Badie * Aziz Herawi B * Bakht Zamina * Beltoon * Burka Band D * Dawood Sarkhosh E * Ehsan Aman * Elaha Soroor F * Farhad Darya * Farid Rastagar * Faiz Karizi * Farid Zaland * Fereshta Samah H * Hangama * Haidar Salim I * Jalil Zaland K * Khyal Muhammad L * Latif Nangarhari M * Mohammad Din Zakhil * Mozhdah Jamalzadah * Mohammad Hussain Sarahang * Mahwash * Mohammad Hashem Cheshti * Miri Maftun * Mangal * Mariam Wafa * Mohammad Din Zakhil N * Nasrat Parsa * Naghma * Nashenas * Naim Popal * Nainawaz * Nasrat Sharqi P * Parasto Q * Qamar Gula * Qader Eshpari R * Rafiq Shinwari * Rahim Mehryar * Rahim Bakhsh * Rezwan Munawar * Rishad Zahir S * Sardar Ali Takkar * Shah Wali * Soosan Firooz * Shakeeb Hamdard * Seeta Qasemi * Soheila Zaland * Saifo * Seema Tarana T * Tahir Shubab * Tawab Arash U * Ubaidullah Jan V * Vahid Soroor W * Wajiha Rastagar * Wahed Wafa Z * Zahir Howaida Ahmad Zahir Farhad Darya jawd sharif new qataghani 2012 jawid sharif yak qadam pesh Jawid Sharif Yak Qadam Pesh yak qandam pesh Yak Qadam Pesh jawid sharif Raminmansour production new qataghani jawid sharif new qataghani 2012 yak qadam pesh jawid sharif jawid sharif new song 2012 Jawid Sharif Unknown gunmen shot dead famous Pushto singer Ghazala Javed along with her father in the provincial capital of Khyber-Pukhtunkhwa Jawid Sharif new Qataghani 2012 Jawid Sharif new song 2012 Jawid Sharif Jawid Sharif Yak Qadam Pesh New Qataghani 2012 Jawid Sharif - Yak Qadam Pesh Fayaz Hamid-Dard e Dil New Song-Nov 2011 720p HD Mp4 Singer : Fayaz Hamid Song : Dard E Dil Lyrics By : Qahar Aasi Compo… | ["Carnatic music", "Music", "Middle Eastern music", "Music of Bollywood", "Sitar"] | ["low quality", "noisy", "unbalanced stereo", "muffled", "resonant", "steel guitar melody", "wooden percussive elements", "flat male vocal", "vintage", "traditional"] | 4 | fZyq2pM2-dI | 3961 | |
ESCOLA VIRTUAL DE PERCUSSIÓ IBÈRICA Capítol 2: LA PANDERETA | The low quality recording features a flat male vocal talking, after which there is a shimmering tambourine being played. The recording is noisy and the stereo image is unbalanced, as the audio is slightly leaning towards the right channel of the stereo image. | 2009-09-21T22:19:12Z | Metrònom Films | En aquest primer capítol de pandereta treballarem la tècnica basca, el triscao, accents, i la frase de les sevillanes coetals. Feina no us en faltarà als amics de la percussió ibèrica... Presenten els pandereteiros Anna Tobias i Acari bertran, gentilesa com sempre de COETUS. | ["Music", "Musical instrument", "Tambourine", "Speech", "Percussion"] | ["low quality", "unbalanced stereo", "flat male vocal", "shimmering tambourine", "tutorial", "noisy"] | 4 | mU6cfEWw5Og | 4473 | |
How To Play Eruption | The low quality recording features a tutorial where a flat male vocalist talks, followed by echoing, uptempo electric guitar melody. The recording is really noisy and the actual sound is leaning towards the right channel - which makes the stereo image unbalanced. | 2007-08-20T04:38:34Z | vic thomson | This is an instuctional video on how to play Eddie Van Halen's "Eruption". Check me out @ http://www.myspace.com/mexal1500 | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["low quality", "noisy", "flat male vocal", "tutorial", "echoing uptempo electric guitar melody", "unbalanced stereo"] | 4 | sUjAb0SfppQ | 4955 |
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;