musiccaps_details (view)
2 rows where musiccaps_aspects contains "creating tension", musiccaps_aspects contains "eerie" and musiccaps_aspects contains "movie soundtrack"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Breaking Bad Season 1 (2008) You're All They Talk About (Extra Soundtrack OST) | The song is an instrumental. The song is medium tempo, with a keyboard accompaniment and string pad section. The song is emotional and passionate. The song is a movie soundtrack with poor audio quality. | 2012-06-09T10:35:15Z | portaps10 | 01 Breaking Bad (Main Title Theme) 02 Negro y Azul - Ballad of Heisenber 03 One By One 04 Walt Bandages His Leg 05 Zungguzungguzungguzeng (Short Version) 06 The Peanut Vendor 07 You're All They Talk About 08 Fallacies 09 Banderilla 10 The Morning After 11 Red Moon 12 The Missing Piece 13 End Credits - Season One | ["Singing bowl"] | ["instrumental music", "keyboard accompaniment", "poor audio quality", "tv show theme", "suspense", "mysterious", "tv season", "crime", "murder mystery", "scary", "eerie", "spirited", "medium tempo", "string section", "vibrato", "tremolo effect", "creating tension", "movie soundtrack", "no percussions"] | 1 | OVNVaXZ9D0E | 2445 | |
Inception Soundtrack - Projections (BONUS TRACK) | The song is an instrumental. The tempo is medium with footstep like percussion, mysterious bell tones, tremolo effects, string section harmony, crescendoing tones and various percussion hits. The song is suspenseful and ominous. The song is a movie soundtrack with bad audio quality. | 2010-08-12T19:49:16Z | Will C | "If I jump, would I survive?" One of two exclusive bonus tracks off Hans Zimmer's INCEPTION soundtrack available for download on the official soundtrack website: www.inceptionsoundtrack.com * HANS ZIMMER'S MUSIC IS THE PROPERTY OF REPRISE RECORDS/WARNER BROS. MUSIC | ["Music", "Scary music"] | ["movie soundtrack", "mysterious", "suspense", "keyboard accompaniment", "string section harmony", "various percussion hits", "crescendo", "mysterious bell tones", "emotional", "scary", "horror", "eerie", "impending distance", "creating tension", "building anticipation", "medium tempo", "poor audio quality", "instrumental music", "ominous", "footsteps"] | 1 | cn-SilfYLZo | 3740 |
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;