musiccaps_details (view)
4 rows where musiccaps_aspects contains "dramatic", musiccaps_aspects contains "piano" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- dramatic · 4 ✖
- piano · 4 ✖
- female vocal 2
- sentimental 2
- strings 2
- bass guitar 1
- clicks 1
- contemporary classical 1
- dreamy 1
- drums 1
- electronic drums 1
- flute 1
- gothic 1
- instrumental 1
- live performance 1
- loud 1
- male vocal 1
- medium-to-high pitch 1
- medium-to-high pitch singing 1
- metalcore 1
- no singer 1
- orchestra 1
- percussion 1
- pop music 1
- post-hardcore 1
- rebellious 1
- repeated theme 1
- rock opera 1
- slow tempo 1
- strings sound 1
- suspense 1
- violin 1
- vocal fry 1
- vocal performance 1
musiccaps_names (array) 7 ✖
- Music 3
- Singing 2
- /t/dd00004 1
- Angry music 1
- Music of Asia 1
- Orchestra 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Breathtaking Sights" - Erik Zilliacus (Piano, Orchestral) | This is a contemporary classical music piece. It is an instrumental piece. There is a strings section playing the chords while the violin in the lead is playing a dramatic tune. The piano is playing accentuated notes. There is a percussion line in the rhythmic background. There is a dramatic atmosphere that is full of suspense. This piece could be used in the soundtrack of a sci-fi drama movie, especially during the scenes where a big revelation is about to take place. | 2014-06-26T09:56:05Z | TheMusicFlowChannel | This was composed by Erik Zilliacus. For more music by the composer: https://youtube.com/user/drunkensailorful SoundCloud: https://soundcloud.com/erik-zilliacus TheMusicFlowChannel on Facebook: https://facebook.com/TheMusicFlowChannel Wallpaper: http://mediafire.com/convkey/73fa/mr0n5n56236eea4fg.jpg?size_id=a * TMFC has the permission to promote "Breathtaking Sights" by Erik Zilliacus. * | ["Orchestra"] | ["contemporary classical", "no singer", "instrumental", "violin", "strings", "piano", "percussion", "repeated theme", "dramatic", "suspense"] | 9 | 7JE2eBK1f9M | 828 | |
Me singing the voice within | This is a vocal performance recording of a pop music piece. It is an amateur recording. The female vocalist is singing in a rising-and-falling manner in medium-to-high pitch. The backing track consists of a simple piano tune, a groovy bass line provided by a bass guitar and a 4/4 signature slow tempo drum beat with clicks on every fourth beat. The atmosphere is sentimental and heart-touching. | 2007-08-29T23:39:26Z | jessalovexox | Me singing the Voice within by christina aguilera.. my first youtube video so please be nice, lol. | ["Singing", "Music", "/t/dd00004"] | ["vocal performance", "pop music", "female vocal", "medium-to-high pitch", "piano", "bass guitar", "drums", "clicks", "slow tempo", "dramatic", "sentimental"] | 9 | 8DHtPopFvII | 903 | |
For All Those Sleeping - My Funeral | This is a metalcore/post-hardcore music piece. There is a male vocal singing using the vocal fry technique. A distant piano melody can be heard. There is an electronic drum beat with a heavy reverb effect. Later on, a string sound starts playing and adds texture to the melodic background. The atmosphere is dramatic and rebellious. This piece can be used in the soundtrack of a teenage drama movie, especially where one of the characters is experiencing a breaking point. | 2014-06-24T18:48:40Z | Fearless Records | ITUNES: http://smarturl.it/IncompleteMe MERCH: http://forallthosesleeping.merchnow.com "My Funeral" taken from For All Those Sleeping's new album 'Incomplete Me' available now in stores & online. Stay connected: http://forallthosesleeping.com http://facebook.com/forallthosesleeping http://twitter.com/fatsband http://instagram.com/fatsband | ["Music", "Angry music"] | ["metalcore", "post-hardcore", "male vocal", "vocal fry", "piano", "electronic drums", "strings sound", "dramatic", "loud", "rebellious", "gothic"] | 9 | d6w3d9S1LVM | 3764 | |
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 |
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;