musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "electronic drums" and musiccaps_aspects contains "live performance" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- electronic drums · 3 ✖
- live performance · 3 ✖
- bass guitar 2
- electric guitar 2
- male vocal 2
- melodic singing 2
- drum breaks 1
- electronic percussion 1
- emotional 1
- female choir 1
- female vocal 1
- girl band 1
- go go beat 1
- grandiose 1
- groovy 1
- group female vocals 1
- hip-hop 1
- keyboard 1
- loud bass 1
- low fidelity 1
- pop 1
- r&b 1
- religious 1
- soul 1
- surf guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
hebron song ''gorepilla'' sung by brp.p.suresh, music by bro.stephen | This is a live performance of a religious song. There is a male vocalist singing melodically as the lead. The main melody is being played by the keyboard with the electric guitar and the bass guitar in the background. The rhythmic background is provided by the electronic drums and the electronic percussion. The piece has movements reminiscent of Jewish music. | 2015-05-01T09:06:39Z | Dr. Suresh David | ["Singing", "Music", "Sad music"] | ["live performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "electronic percussion", "keyboard", "religious"] | 9 | teyDfFbVMSY | 5056 | ||
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 | ||
Girls Aloud - Sound Of The Underground (Party in the Park) | Live performance of a girl band group, featuring surf guitar and a go-go beat that transitions to modern pop production with loud bass and electronic drum breaks. Audio is low fidelity. Would be popular with teenage girls. | 2008-03-02T14:23:52Z | Eva McLaughlin | Girls Aloud performing LIVE Sound Of The Underground at Party in the Park, 2003) Official Websites: http://www.girlsaloud.co.uk http://www.polydor.co.uk Girls Aloud: Nadine Coyle Cheryl Cole Sarah Harding Nicola Roberts Kimberley Walsh | ["Music of Asia", "Music", "Pop music"] | ["girl band", "surf guitar", "go go beat", "loud bass", "pop", "live performance", "low fidelity", "group female vocals", "drum breaks", "electronic drums"] | 8 | vo7BYs1OqbM | 5206 |
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;