musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality" and musiccaps_aspects contains "straight piano melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality · 2 ✖
- passionate 2
- pop 2
- straight piano melody · 2 ✖
- addictive 1
- electric guitar chords 1
- emotional 1
- groovy 1
- groovy bass 1
- harmonizing vocals 1
- passionate male vocal 1
- punchy snare 1
- reverberant passionate female vocal 1
- smooth bass guitar 1
- wide brass melody 1
- wide claps 1
- wide harmonizing male vocals 1
- wide shimmering hi hats 1
- wide shimmering tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cry Baby Soundtrack - Teardrops Are Falling | The low quality recording features a pop song that contains a passionate female vocal, alongside wide harmonizing male vocals, singing over wide brass melody, electric guitar chords, straight piano melody, punchy snare and smooth bass guitar. It sounds groovy, addictive and passionate. | 2009-09-11T13:34:33Z | MortRaineyFan | Cry Baby Soundtrack - Teardrops Are Falling. :) | ["Music", "Vocal music"] | ["low quality", "pop", "wide harmonizing male vocals", "wide shimmering hi hats", "wide brass melody", "electric guitar chords", "straight piano melody", "reverberant passionate female vocal", "punchy snare", "smooth bass guitar", "groovy", "addictive", "passionate"] | 4 | 46WpyRUqwXU | 539 | |
Charlie Puth - Marvin Gaye ft. Meghan Trainor | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing vocals, singing over wide claps, layered with shimmering tambourine, groovy bass and straight piano melody. It sounds emotional and passionate. | 2015-06-28T19:27:02Z | TheBlinkStudios | This video is dedicated to Mr. Charlie Puth... and Meghan Trainor. See you guys July 12th! | ["Singing", "Music", "Happy music"] | ["low quality", "pop", "straight piano melody", "harmonizing vocals", "passionate male vocal", "groovy bass", "wide claps", "wide shimmering tambourine", "passionate", "emotional"] | 4 | hrCf8rMBtA8 | 4146 |
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;