musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic crash cymbal", musiccaps_aspects contains "sustained strings melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- energetic crash cymbal · 3 ✖
- sustained strings melody · 3 ✖
- emotional 2
- low quality 2
- pop 2
- punchy kick 2
- shimmering hi hats 2
- addictive 1
- energetic 1
- filtered drums 1
- filtered wide female vocal 1
- flat male vocal 1
- groovy bass guitar 1
- groovy piano chords 1
- harmonizing background female vocals 1
- mellow piano chords 1
- mono 1
- noisy 1
- papery 1
- passionate 1
- passionate male vocal 1
- piano chords 1
- playback 1
- punchy snare 1
- smooth 1
- snap 1
- soulful 1
- synth arpeggiated melody 1
- thin 1
- toms roll 1
- uplifting 1
- wide acoustic guitar melody 1
- wide harmonizing background vocals 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disney On Ice 2009 Finale | The low quality recording features a live performance where the song is played on playback and it consists of sustained strings and piano melody, energetic crash cymbals, shimmering hi hats and toms roll, over which passionate male vocal and harmonizing background female vocals are singing. It sounds emotional, passionate and soulful. | 2009-06-03T19:22:38Z | Freya JW | Disney On Ice was preforming at the Target Center in Minneapolis on March 8th and I was able to go and Oh Em Gee, it was sooo purely magicaly like you don't even know. This video doesn't do it justice!! I was actually crying during this part. | ["Yodeling", "Music", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "playback", "sustained strings melody", "toms roll", "shimmering hi hats", "energetic crash cymbal", "passionate male vocal", "harmonizing background female vocals", "piano chords", "emotional", "passionate", "soulful"] | 4 | bwHPVG6vbNQ | 3665 | |
Dubstep - Earthquake (Fytch Remix) | The low quality recording features a pop song that consists of filtered, wide female vocal singing over mellow piano chords, sustained strings melody and filtered drums located in the left channel of the stereo image. At the very beginning there is a snap sound and at the end, there is a short snippet of another section which contains punchy kicks layered with energetic crash cymbals and arpeggiated synth melody. It sounds emotional and energetic, even though it sounds kind of papery and thin, since it lacks lower frequencies. | 2011-08-13T20:46:16Z | dasistmeins89 | Ein Dubstep Remix von Little Boots - Eearhquake Download this song: http://www.share-online.biz/dl/NSS9ZK0MBT | ["Electronic music", "Music", "Dubstep"] | ["low quality", "pop", "filtered wide female vocal", "snap", "mellow piano chords", "sustained strings melody", "punchy kick", "energetic crash cymbal", "filtered drums", "synth arpeggiated melody", "emotional", "energetic", "papery", "thin"] | 4 | dh9XweTn6rI | 3807 | |
Jingles Eleições 2010 - Angela Amin - PP - leobrandao.net | The Pop song features a flat male vocal, alongside wide harmonizing background vocals, singing over punchy kick and snare hits, shimmering hi hats, energetic crash cymbals, groovy piano chords and widely spread acoustic guitar melody. It sounds smooth, uplifting and addictive thanks to those harmonizing vocals. | 2010-11-22T18:27:42Z | LB Jingles | Cortesia do site http://jingles.leobrandao.net Jingle Eleições 2010 Nome: Angela Amin - Santa Catarina Coligação: Aliança com Santa Catarina PP - PDT - PT do B | ["Jingle (music)", "Music", "Independent music", "Song"] | ["pop", "sustained strings melody", "flat male vocal", "punchy snare", "wide harmonizing background vocals", "punchy kick", "shimmering hi hats", "energetic crash cymbal", "groovy piano chords", "wide acoustic guitar melody", "uplifting", "groovy bass guitar", "smooth", "addictive"] | 4 | lvktro0asjs | 4430 |
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;