musiccaps_details (view)
2 rows where musiccaps_aspects contains "hypnotic", musiccaps_author = 4 and "youtube_published" is on date 2011-09-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
Lugia's lullaby | The low quality recording features a reverberant, intimate female vocal singing over soft, arpeggiated piano melody. It sounds haunting, hypnotic, heartfelt and muddy, as the frequencies are clashing and creating a mess in the mix. It sounds like a lullaby. | 2011-09-09T20:48:42Z | Windwolf14 | I heard this recording of the prince of Egypt river lullaby and it sounded like a Lugia to me so I put this together^^ Please rate and comment Depending on feed back i might write a fan story for this I own NOTHING but editing. | ["Music", "Lullaby"] | ["low quality", "reverberant intimate female vocal", "soft arpeggiated piano melody", "haunting", "muddy", "hypnotic", "heartfelt"] | 4 | 9DCJTAzUwNc | 984 | |
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 |
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;