musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "e-guitar", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- e-guitar · 3 ✖
- male voice singing · 3 ✖
- pop · 3 ✖
- acoustic drums 1
- acoustic guitar 1
- bass 1
- digital drums 1
- drums 1
- e-bass 1
- funky 1
- higher register 1
- keyboard melodies 1
- male backing vocals 1
- medium tempo 1
- medium to uptempo 1
- mid-range 1
- piano 1
- positive atmosphere 1
- sensitive 1
- strumpets 1
- upright bass 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 3
- Blues 1
- Ska 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DANIJEL BOTO - URNEBES (OFFICIAL MUSIC VIDEO) | Digital drums are playing a four on the floor rhythm with a kick on every beat along with a bassline and a keyboard sound playing short rhythmic chords and a e-guitar playing a simple melody along. A male voice is singing in a higher key. This song may be playing at a folkfest. | 2012-10-31T00:15:59Z | CinematixStudios | Danijel Boto - Urnebes 1.dio Ima jeda smeđa mala oduvijek je plesat znala Kad zanjiše kukovima pomuti nam pamet svima... A,i ona mala plava kako pleše boli glava nezna čovjek šta bi reko ovaj stol je samo na njih čeko... REFREN: Hajmo svi na stol to je ovi fol hajmo svi a ples bit će URNEBES 2.dio Konobaru toči piće atmosfera luda biće donesi am piće svima mi smo već na stolovima Šta je ovo moji ljudi ova pjesma sve nas budi sve je ludo gori sve plešemo uz dobre ritmove... REFREN: Hajmo svi na stol 2x | ["Music", "Wedding music"] | ["pop", "digital drums", "e-guitar", "keyboard melodies", "male voice singing", "higher register", "bass", "uptempo", "positive atmosphere"] | 6 | -bgHkxwoliw | 65 | |
Damien Rice - Hypnosis [Official Music Video] | This song contains drums with a deep and strong but jet soft kick sound with a snare that sounds muted. An upright bass or e-bass is playing a line along. A e-guitar is strumming a chord progression along with a piano. A male voice is singing in the midrange sounding sensitive and honest. Panned to both sides of the speakers two trumpets are playing a melody in the lower to mid-range. This song may be playing in a beautiful romantic art video. | 2015-09-08T14:20:00Z | Damien Rice | Damien Rice's "Hypnosis" from Kahlil Gibran's The Prophet Soundtrack available now at http://smarturl.it/TheProphetSoundtrack. Follow Damien Rice on: Facebook https://DamienRice.lnk.to/Facebook Twitter https://DamienRice.lnk.to/Twitter Instagram https://DamienRice.lnk.to/Instagram YouTube https://DamienRice.lnk.to/YouTube https://DamienRice.lnk.to/Website | ["Blues", "Music"] | ["pop", "e-guitar", "strumpets", "upright bass", "drums", "piano", "male voice singing", "medium to uptempo", "sensitive"] | 6 | 4TXy2i036LU | 573 | |
Splendid - You Don't Understand | This song contains acoustic drums with a fat kick drum and a funky bassline. The acoustic guitar is strumming chords in the background being panned to the left side of the speaker while a e-guitar panned to the right side of the speaker is playing the lead melody strumming chords with a wah-wah pedal. A male backing voice is singing the same melody in a loop. The male lead voice is singing over the backing vocals. This song may be playing on a road trip. | 2007-10-23T20:56:12Z | splendidmusic | The long awaited all in the family happy happy sunshine videoclip for the Splendid track "You Don't Understand", taken from the 2006 album "Rebirth". iTunes: http://itunes.apple.com/nl/album/rebirth/id320728481 http://www.splendidmusic.nl Bookings: http://www.agentsafterall.nl | ["Music", "Ska"] | ["pop", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "male voice singing", "mid-range", "male backing vocals", "medium tempo", "funky"] | 6 | Aw2ctwyhe28 | 1185 |
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;