musiccaps_details (view)
2 rows where musiccaps_aspects contains "disturbing" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_names (array) 4 ✖
- Chirp tone 1
- Harmonic 1
- Music 1
- Singing bowl 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
bols chantant de cristal | The low quality recording features a resonating bowl sound, followed by mellow metallic percussion. The recording is noisy and it sounds a bit harsh and disturbing. | 2010-12-06T11:10:25Z | Martina Jade | Concert de bols chantant de cristal donné en faveur de l'association humanitaire Tierra Sagrada http://anawak.olympe.in/ | ["Chirp tone", "Singing bowl"] | ["low quality", "noisy", "resonating bowl sound", "mellow metallic percussion", "harsh", "disturbing"] | 4 | v592zQpuaJA | 5153 |
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;