musiccaps_details (view)
2 rows where musiccaps_names contains "Music", musiccaps_names contains "Musical instrument" and "youtube_published" is on date 2013-02-10
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daud Khan Sadozai - live - 2013 | This music is a mellifluous Indian classical instrumental. The tempo is fast with a harmonic sarod and rhythmic Oud accompaniment. The music is mesmerising, spirited, engaging, captivating and skilfully rendered Ragas. This instrumental is an Indian/Pakistani classical music. | 2013-02-10T17:18:05Z | soon4ward | Daud Khan live 26-01-2013 in Hagen, Germany. Daud Khan Sadozai - Robab, Sarod Efren Lopez - Robab, Oud Yma Karin / Shekab Wadwa- Tabla | ["Tabla", "Traditional music", "Guitar", "Music", "Musical instrument", "Percussion"] | ["instrumental", "medium tempo", "sarod harmony", "oud", "hindustani music", "indian classical", "stringed instrument", "lute", "pakistani music", "mesmerising", "engaging", "skilful musicians", "raga", "sympathetic strings", "sliding pitches", "indian classical instruments"] | 7 | ALU-1AILj1c | 1107 | |
Joyo JF-37 Analog Chorus | The low quality recording features an electric guitar melody played with a chorus effect on. The recording is noisy and in mono. | 2013-02-10T07:46:29Z | musicexpresscanada | JOYO EFFECTS JF-37 "ANALOG CHORUS" BBD CHIP SET WATERY CHORUS TONES TRUE BYPASS Joyo JF-37 Analog Chorus Effects Pedal You are viewing the JF-37 Classic Chorus. A Great choice to touch up a clear and melodious tone. This Analog Chorus uses the classic BBD chip to acheive those warm, rich and thick classic chorus tones. Rate and Depth knobs let you shape your sound. True Bypass design. Powered by a 9V Battery or 9V adapter. This is a very well electrically designed and mechanically rugged pedal, at a great price!!!.... Buy it Here http://www.musicexpresscanada.com Direct Link http://www.musicexpresscanada.com/product_info.php?products_id=415 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["low quality", "mono", "noisy", "tinny tap sound", "chorus effect", "electric guitar melody"] | 4 | c6Fiz5IznkU | 3679 |
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;