musiccaps_details (view)
2 rows where musiccaps_aspects contains "wide low synth pad" and musiccaps_author = 4 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- low quality 2
- wide low synth pad · 2 ✖
- ambient 1
- calming 1
- dramatic 1
- haunting male vocal 1
- hypnotic 1
- intense 1
- mellow wide bells 1
- muffled gunshots 1
- relaxing 1
- reversed crash cymbal 1
- suspenseful 1
musiccaps_names (array) 3 ✖
- Music 1
- Scary 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 |
---|---|---|---|---|---|---|---|---|---|---|
432hz Lazu Ra Oh | The low quality recording features an ambient song that consists of mellow wide bells and wide low synth pad playing in the background. It sounds calming, relaxing and hypnotic, like something you would hear in a hypnotic therapy session. | 2011-09-09T21:35:44Z | nutstar13 | Music Lazu Ra Oh 432hz is by Stellar www.starsistrum.com. and produced by Marc Mitchell www.marcmitchell.com Painting Loving oneness is by Katrina Vrebalovich www.magicaleye.net 2011 sept | ["Singing bowl"] | ["ambient", "mellow wide bells", "wide low synth pad", "calming", "relaxing", "hypnotic", "low quality"] | 4 | EN_FOFkxAEw | 1549 | |
COLT KING COBRA | The low quality recording features muffled gunshots over a wide, low synth pad, reversed crash cymbal and haunting male vocals. It sounds suspenseful, intense and dramatic. | 2008-02-22T22:37:10Z | Myka Santos | Colt King Cobra, need I say more? ................................. kkkkk, i know it's not a python but hey it's still a Colt :D | ["Music", "Scary music"] | ["low quality", "muffled gunshots", "wide low synth pad", "haunting male vocal", "reversed crash cymbal", "suspenseful", "intense", "dramatic"] | 4 | dMfKImuNJjA | 3778 |
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;