musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-01-11
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- ambient 1
- calming 1
- classical hindustani song 1
- dance 1
- dirty sound 1
- disturbing 1
- dj set 1
- electronic drums 1
- groovy 1
- low quality 1
- moderate tempo 1
- no other instruments 1
- no voices 1
- noisy 1
- relaxing 1
- scratching 1
- sitar 1
- tabla 1
- tinny wooden sounds 1
- turntable 1
- urban 1
- wide sustained strings melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Delayed Prism Scratch By Syndrum | This is the recording of a DJ performance. In the rhythmic background, the electronic drums are playing a simple yet groovy beat. The DJ is scratching the turntable rapidly over this track. The piece is danceable. It has a dirty mix. Parts of this piece can be used as turntable samples for a beat. It could also be used in the soundtrack of a show with a big city setting. | 2008-01-11T16:54:01Z | entoure | delayed prisms | ["Music", "Scratch"] | ["dj set", "scratching", "turntable", "electronic drums", "dirty sound", "groovy", "dance", "urban"] | 9 | Fa1c4qfBqzE | 1652 | |
sitar solo www.triwat.org | This classical Hindustani song features the sitar playing the main melody. Open strings are continuously played with fretted strings providing the main melody of this song. This is accompanied by a tabla playing a classical rhythm. There are no other instruments in this song. There are no voices in this song. This song can be played for an Indian traditional dance. | 2008-01-11T09:11:22Z | TRIWAT DANCE SCHOOL | sitar solo by hari-har sharan bhatt | ["Tabla", "Drum", "Percussion"] | ["classical hindustani song", "sitar", "tabla", "no other instruments", "no voices", "moderate tempo"] | 0 | lpHa-S_x1LA | 4424 | |
AWAKEN TO LOVE by LIORA Harmonic Vocalist | The low quality recording features an ambient song that consists of a wide sustained string melody going left and right through the stereo image. There are tinny wooden sounds in the background, as the recording is a bit noisy. Even though it is calming and relaxing, it is a bit disturbing too. | 2008-01-11T05:54:33Z | LIORA | http://www.twinflame1111.com This beautiful video features the track "AWAKEN" off LIORA'S Galactic Harmonics cd.... for all of LIORA'S mp3 instant download cd's visit the website as above... The Teachings of the "Twin Flame Sacred Keys"....Collection !! Assisting Humanity's Ascension. VIBRATIONAL self Reunion = The SACRED Twin Flame Reunion....... | ["Music", "Harmonic"] | ["low quality", "noisy", "ambient", "wide sustained strings melody", "noisy", "tinny wooden sounds", "disturbing", "calming", "relaxing"] | 4 | o6ZQNr0Tpz4 | 4605 |
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;