musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocal" and musiccaps_aspects contains "unique"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- female vocal · 2 ✖
- unique · 2 ✖
- acoustic 1
- bass guitar 1
- carnatic music 1
- complex 1
- easygoing 1
- eccentric 1
- electric guitar 1
- electronic percussion 1
- fun 1
- hard rock 1
- indo-european fusion 1
- male vocals 1
- medium-to-high pitch singing 1
- piano 1
- ukulele 1
- ukulele solos 1
- virtual sounding brass 1
musiccaps_names (array) 6 ✖
- Music 2
- Carnatic music 1
- Music of Bollywood 1
- Singing 1
- Song 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LISTEN Fusion Music Indian Carnatic ERA NAPAI & RARA VENU | This is a Indo-European fusion music piece. There is a mix of Carnatic music with Western sounding elements. There is a female vocalist singing at a medium-to-high pitch. The melody consists of a variety of intertwined sounds such as a piano, an electric guitar, a bass guitar and a virtual sounding brass section. The rhythmic background is provided by electronic percussive elements. There is an eccentric atmosphere to this piece. It sounds unique. | 2007-09-20T10:42:07Z | jaikumarnargunam | LISTEN INDIAN classical music carnatic ERA NAPAI & RARA VENU set to fusion with European Western by N.JAIKUMAR Cine musician / Indo European Fusionist from Chennai INDIA. S.P.Sailaja sings | ["Carnatic music", "Music", "Song", "Music of Bollywood"] | ["indo-european fusion", "carnatic music", "female vocal", "medium-to-high pitch singing", "piano", "electric guitar", "bass guitar", "virtual sounding brass", "electronic percussion", "eccentric", "complex", "unique"] | 9 | ZLxhZcS3Ppw | 3366 | |
The Ukulele Orchestra of Great Britain;»Born to be wild« | This is the acoustic version of a hard rock piece performed by an orchestra of ukulele players. There are two male vocalists and one female vocalist singing melodically. The different sections of the tune are all being played by a separate ukulele. The atmosphere is easygoing. This piece could fit well in the soundtrack of an animation movie or a comedy movie. | 2009-07-28T15:14:36Z | hunderttausend.de | Billy Wilder und Marilyn Monroe setzten der Ukulele in dem Kult-Film »Manche mögens heiß« ein Denkmal. Wenn THE UKES in die Saiten greifen, ist das Ergebnis ein virtuoser, urkomischer, singender, schwingender, augenzwinkernder, Mund-und-Nase-offenstehen-lassender Nachruf auf den Rockn Roll. Das Video zeigt einen Live-Mitschnitt des Rock-Klassikers »born to be wild« von STEPPENWOLF. Vorab gab es auf hunderttausend.de ein 5 Fragen Interview. Einen ausführlichen und wohlwollenden Nachbericht zum Konzertabendim Kurfürstlichen Palais findet man bei den geschätzten Kollegen von 16vor.de. | ["Singing", "Music", "Ukulele"] | ["hard rock", "acoustic", "ukulele", "ukulele solos", "male vocals", "female vocal", "easygoing", "fun", "unique"] | 9 | sYIymaJi6tc | 4958 |
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;