musiccaps_details (view)
4 rows where musiccaps_aspects contains "sustained brass melody", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- sustained brass melody · 4 ✖
- low quality 3
- noisy 3
- emotional 2
- groovy bass 2
- mono 2
- passionate 2
- sustained strings melody 2
- background harmonizing female vocals 1
- background music 1
- crushed 1
- distorted 1
- energetic drums 1
- enka 1
- funky 1
- haunting sizzling bells 1
- heartfelt 1
- intense 1
- low wooden percussions 1
- mellow bells chord progression 1
- northern soul 1
- orchestra 1
- passionate female vocal 1
- punchy snare 1
- reverberant passionate male vocal 1
- short brass melody 1
- soul 1
- steel guitar solo melody 1
- suspenseful 1
- thin 1
- upbeat 1
- vintage 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gwen Owens - Just Say You're Wanted (And Needed) | The low quality recording features a Northern Soul song sung by passionate female vocalists and background harmonizing female vocals over punchy snare, groovy bass and sustained brass melody. It sounds upbeat, crushed, vintage, emotional and funky. The recording is noisy and in mono. | 2009-10-08T07:53:03Z | bricomaligno | Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use. | ["Music", "Roll"] | ["low quality", "vintage", "northern soul", "passionate female vocal", "background harmonizing female vocals", "punchy snare", "noisy", "groovy bass", "sustained brass melody", "crushed", "mono", "distorted", "funky", "emotional", "upbeat"] | 4 | EZAwPnGOJPE | 1567 | |
Doom OST - E1M6 - On the Hunt | The low quality recording features an orchestra music that contains haunting sizzling bells melody, low wooden percussions, sustained strings melody and sustained brass melody. It sounds suspenseful and intense, as background music for movies would sound. | 2007-09-10T08:54:24Z | Jim DarkMagic | E1M6 http://www.bpmusic.com | ["Timpani", "Music"] | ["orchestra", "low quality", "haunting sizzling bells", "low wooden percussions", "sustained strings melody", "sustained brass melody", "suspenseful", "intense", "background music"] | 4 | QJzveo6IBsU | 2612 | |
Enka - itsuki hiroshi | The low quality recording features an Enka song that consists of a steel guitar solo melody, mellow bell chord progression, sustained strings melody and sustained brass melody. The recording is noisy and in mono, and it sounds emotional, heartfelt and passionate. | 2007-08-06T13:45:53Z | Ali mohammed yousof | music video | ["Music", "Ukulele", "Pizzicato"] | ["enka", "low quality", "mono", "steel guitar solo melody", "sustained strings melody", "sustained brass melody", "emotional", "heartfelt", "passionate", "noisy", "mellow bells chord progression"] | 4 | nvvXOfLs-ng | 4595 | |
soul sound band - ja te uzalud ljubim | The low quality recording features a soul song that consists of reverberant passionate male vocal singing over sustained brass melody, followed by short brass melody and energetic, barely audible energetic drums. The recording is very noisy and thin, as it lacks low frequencies, but it sounds passionate and energetic. | 2011-07-23T17:58:38Z | video produkcija eminentni | te 1971. godine, soul sound band je izdao tri singla. na jednom od njih se nalazi ova pesma. | ["Funk", "Music", "Soul music"] | ["soul", "sustained brass melody", "short brass melody", "groovy bass", "reverberant passionate male vocal", "energetic drums", "noisy", "thin", "passionate"] | 4 | o8FsD7l5er4 | 4606 |
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;