musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "energetic", musiccaps_aspects contains "keyboard" and musiccaps_aspects contains "melodic singing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Videos - Trickle Trickle | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | 2009-03-10T17:37:32Z | chargertom | Oldies favorite "Trickle Trickle" by The Videos. Another record selection from the Oldies Jukebox at www.fhs1961.com | ["Music", "Ska"] | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | 9 | KV99GJg0tvA | 2089 | |
Sound Of Music - 02 Magic Night (1987) | This is a pop music piece with 80s characteristics. There is a female vocalist in the lead singing melodically. The main theme is played by a keyboard and an electric guitar at the same time in the major scale. There is a bass guitar and a medium-to-high range pad in the background. The rhythmic background is provided by a loud but simple acoustic drum beat. There is a maximalist, vibrant and energetic atmosphere. This piece could be used in the soundtrack of a romance movie. It could also fit very nicely as the soundtrack of an anime. | 2009-12-25T08:13:42Z | mixtis carminibus | Sound Of Music was a Swedish pop group who recorded two albums 1986-1987. Peter Grönvall, who wrote the music, is the son of Benny Andersson from Abba. The other two members were Nanne Grönvall and Angelique Widengren. | ["Music of Asia", "Music", "Exciting music"] | ["pop music", "80s pop", "female vocal", "melodic singing", "keyboard", "bass guitar", "electric guitar", "pad", "acoustic drums", "grandiose", "vibrant", "energetic", "high tempo"] | 9 | TN53jpjqAGI | 2833 |
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;