musiccaps_details (view)
7 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "upbeat" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- live performance · 7 ✖
- upbeat · 7 ✖
- dance 2
- latin american music 2
- low quality audio 2
- accordion 1
- acoustic guitar 1
- bongo drums 1
- brass instruments 1
- breathy female vocals 1
- cajon drum 1
- cellphone recording 1
- cheerful 1
- clapping hands 1
- energetic 1
- fast paced rhythmic singing 1
- female singing quarter 1
- flamenco guitarists 1
- grand piano 1
- happy 1
- harmonies 1
- hip hop 1
- jazzy 1
- laughing vocals 1
- live recording 1
- lively 1
- low quality recording 1
- male hispanic vocal group 1
- motown song 1
- nylon string guitar 1
- old desi music 1
- piano 1
- poor audio quality 1
- pop dance music 1
- reverb 1
- salsa dancing 1
- seductive female pop vocals 1
- soulful female vocal 1
- strings motif 1
- tabla playing 1
- tap dancing percussion 1
- traditional south asian music 1
- vibrant 1
- vintage european 1
- violins 1
musiccaps_names (array) 19 ✖
- Music 7
- Musical instrument 3
- /t/dd00004 1
- A capella 1
- Bowed string instrument 1
- Classical music 1
- Flamenco 1
- Folk music 1
- Guitar 1
- Middle Eastern music 1
- Music of Asia 1
- Music of Latin America 1
- Percussion 1
- Plucked string instrument 1
- Pop music 1
- Salsa music 1
- Synthetic singing 1
- Tap 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNNY QAWALI OF SHOKI KHAN | This is a traditional, cultural South Asian song. It is upbeat, vibrant, cheerful. The lead singer sings in a fast paced and rhythmic way, connecting many words within a short span of musical time. The rest of the performers are clapping their hands, playing the tabla. This is a live performance. | 2010-08-04T10:48:03Z | Hussain Akram | ["Music", "Middle Eastern music"] | ["traditional south asian music", "old desi music", "fast paced rhythmic singing", "clapping hands", "live performance", "tabla playing", "upbeat", "vibrant"] | 3 | 0fiOM---7QI | 197 | ||
Los Blancos (en vivo) | This is a traditional Latin American song which would be suitable for salsa dancing. There are layers of percussion including bongo drums and snare drums. The pianist plays intricate melodies and the brass section plays vibrant and punchy motifs. It's a live performance with a relatively poor audio quality. There is a male group of singers performing energetically. | 2008-07-14T19:10:04Z | juandog2000 | en concierto (el Rey del timbal) Leopoldo Blanco en los timbales | ["Music", "Musical instrument", "Music of Latin America", "Percussion", "Salsa music"] | ["latin american music", "upbeat", "brass instruments", "bongo drums", "piano", "male hispanic vocal group", "salsa dancing", "live performance", "low quality audio"] | 3 | DAX9uKYlDvw | 1449 | |
Faraon - Flamenco Rumba_20/11/2011@Barceloan | This is a recording of two flamenco guitarists playing a captivating latin american rhythm. It's upbeat and suitable for dancing. The one guitarist strums chords in the percussive flamenco style, while the other guitarist plays flamenco lead with arpeggios and licks. The performance is live and outside. There is reverb applied to the lead guitar. Both are playing on nylon strings. | 2011-11-24T17:50:51Z | Julian Kan | Spanish Guitar - Adrian Roman & Martin Sazandeh's performance at Cathedral, Gothic Quarter, Barcelona | ["Folk music", "Flamenco", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["live performance", "flamenco guitarists", "acoustic guitar", "nylon string guitar", "latin american music", "upbeat", "energetic", "dance", "reverb"] | 3 | KChjW89XOF0 | 2064 | |
Tyler Perry Laugh To Stop From Crying Play in Philadelphia-The Whole Cast Singing | This is a low quality recording of a motown style song. The song seems to have been recorded using a cellphone. The lead female vocalist has a soulful and powerful voice. The song is upbeat and jovial. | 2009-10-29T06:19:52Z | Sylvia Lawton | October 25th -The whole cast singing The Jackson's Five I Want You Back. | ["Music", "/t/dd00004", "Synthetic singing"] | ["live performance", "low quality recording", "cellphone recording", "low quality audio", "motown song", "upbeat", "soulful female vocal"] | 3 | MocXmVbat3s | 2298 | |
Pussycat Dolls - Beep (Live) | The song is an upbeat pop song with a slight hip hop influence. It's a live performance and features a breathy, seductive female vocalist. The backup singers almost chant or laugh in a staccato way that creates a vocal riff. There are string instruments in the background. This is a live performance. | 2010-08-29T11:39:18Z | Suniuke | ["Music of Asia", "Music", "Pop music"] | ["live performance", "laughing vocals", "seductive female pop vocals", "strings motif", "pop dance music", "upbeat", "breathy female vocals", "hip hop"] | 3 | NsYVaRI6rXg | 2373 | ||
Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 | |
Suji Tap wearing Capezio K360USA Basement-Model | The song is upbeat, groovy and jazzy. The main percussive elements are created by live tap dancing on a stage, as well as more base oriented percussion from a cajon drum. There's a grand piano playing an intricate melody. | 2011-11-18T01:21:35Z | Basement Tap Dance | TAP DANCER : 浦上雄次(SUJI TAP) WEB SITE http://www.sujitap.jp/ TAP DANCER : 當間里美(SATOMI TOMA) WEB SITE http://blog.livedoor.jp/satojazz/ BASEMENT : タップシューズ販売・タップシューズ加工修理・レンタルダンススタジオ http://www.basement-tokyo.com/ Capezio http://www.capeziodance.com/ 山本光恵(Mitsue Yamamoto)on Piano 森智紀(Tomonori Ono)on Percussion | ["Music", "Tap"] | ["live performance", "tap dancing percussion", "grand piano", "upbeat", "cajon drum", "lively", "dance", "jazzy"] | 3 | gRn6OjQf2ZQ | 4030 |
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;