musiccaps_details (view)
2 rows where musiccaps_aspects contains "noisy" and musiccaps_aspects contains "wide sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- low quality 2
- noisy · 2 ✖
- wide sustained strings melody · 2 ✖
- ambient 1
- arpeggiated acoustic guitar melody 1
- calming 1
- disturbing 1
- emotional 1
- intimate soft male vocal 1
- lullaby 1
- mellow 1
- relaxing 1
- soft 1
- tinny metallic impact 1
- tinny wooden sounds 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lulla Lulla Lullaby | The low quality recording features a lullaby song that consists of an intimate, soft male vocal singing over arpeggiated acoustic guitar melody and wide sustained strings melody. It is a bit noisy and there is a tinny metallic impact towards the end of the loop. It sounds soft, mellow and emotional. | 2010-10-03T03:16:35Z | HartsCry1 | October 1, 2010 at 1:10pm: Welcome to our world Lucas Darryl Wilson. Remember in dreams you can do anything your heart desires. | ["Music", "Lullaby"] | ["intimate soft male vocal", "arpeggiated acoustic guitar melody", "wide sustained strings melody", "lullaby", "noisy", "low quality", "tinny metallic impact", "soft", "mellow", "emotional"] | 4 | Sp3T_x3SGzQ | 2790 | |
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;