musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 1 and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 62 ✖
- live performance 2
- passionate 2
- poor audio quality 2
- adventurous 1
- ambient crowd noise 1
- ambient crowd noises 1
- bad audio quality 1
- blues music 1
- blues turnaround 1
- diva 1
- electric rhythm guitar playing 1
- electric rhythm guitar plays 1
- energetic 1
- enthusiastic 1
- exciting 1
- female guitarist 1
- female singer 1
- fret noise 1
- groovy music 1
- guitar notes playing 1
- guitar playing 1
- guitar solo 1
- hard rock 1
- hip hop music 1
- hissing ambient sound 1
- home video 1
- instrumental music 1
- keyboard accompaniment 1
- keyboard beep tones 1
- lilting vocals 1
- live audience 1
- live concert video 1
- love song 1
- madly in love 1
- male singer 1
- medium fast tempo 1
- medium fats tempo 1
- medium tempo 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- poor audio recording 1
- pop diva 1
- pop song 1
- pop super hits 1
- rapping vocals 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- romantic 1
- rough male vocals 1
- singer talking 1
- slick drumming rhythm 1
- song fade 1
- song introduction 1
- song stops playing 1
- soul music 1
- soul singer 1
- story telling 1
- telephone ringing 1
- testosterone driven 1
- youthful 1
musiccaps_names (array) 10 ✖
- Inside, large room or hall · 3 ✖
- Music 3
- /t/dd00004 1
- Guitar 1
- Inside, small room 1
- Pop music 1
- Singing 1
- Telephone bell ringing 1
- Whoop 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;