musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "movie soundtrack" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- keyboard accompaniment · 2 ✖
- movie soundtrack · 2 ✖
- spirited · 2 ✖
- suspense 2
- bad audio quality 1
- creating tension 1
- crime 1
- eerie 1
- emotional 1
- female singer 1
- hissing and buzzing distortions 1
- hissing tones 1
- inspiring 1
- instrumental music 1
- life’s lessons 1
- medium tempo 1
- modern pop covers 1
- murder mystery 1
- mysterious 1
- no percussions 1
- odern pop hits 1
- passionate 1
- poor audio quality 1
- pop song 1
- scary 1
- slamming door percussion 1
- slow tempo 1
- song cover 1
- story telling 1
- string section 1
- strong bass line 1
- tremolo effect 1
- tv season 1
- tv show theme 1
- vibrato 1
- vocal echoes 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 |
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;