musiccaps_details (view)
1 row where search matches "opera", musiccaps_aspects contains "soap opera soundtrack", musiccaps_names contains "Vocal music" and "youtube_published" is on date 2010-09-23
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- eerie 1
- female voice 1
- irritating 1
- loud 1
- soap opera soundtrack · 1 ✖
- unsettling 1
- vocoder 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Barbara, Eustaquia, Melquiades, & Juan Primito || Hide & Seek | This is a vocal performance from a soap opera soundtrack. There is a female vocalist that is singing with a heavily manipulated voice, most probably through the use of a vocoder. The volume of the track is unnecessarily loud and it peaks frequently. There is an unsettling atmosphere. It could be used in the soundtrack of a horror movie where the protagonist is slowly losing touch with reality. | 2010-09-23T16:57:15Z | VenusKaMGchannel2 | RE-UPLOADED Rights reserved by Telemundo NBC. No Copyright Infringment Intended. Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. la cancion es "Hide and Seek" de Imogen Heap | ["Vocal music"] | ["soap opera soundtrack", "female voice", "vocoder", "eerie", "unsettling", "loud", "irritating"] | 9 | b6hr31Qaemg | 3602 |
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;