musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_names contains "/t/dd00003" and musiccaps_names contains "Singing" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 37 ✖
- emotional 2
- acoustic drums 1
- acoustic rhythm guitar 1
- ambient 1
- american 1
- club music 1
- contemporary pop 1
- crowd clapping 1
- dance music 1
- dance pop 1
- digital drumming 1
- distorted 1
- electric guitar 1
- electric guitar riff 1
- electro pop 1
- electronic music 1
- female singer 1
- folk rock 1
- groovy bass guitar 1
- groovy rhythm 1
- harmonizing vocals 1
- keyboard arrangement 1
- live performance 1
- low quality 1
- male vocals 1
- medium fast tempo 1
- messy 1
- muddy 1
- passionate 1
- repeated theme 1
- rock music 1
- shimmering hi hats 1
- snappy rimshots 1
- synth pop 1
- synthesiser articulation 1
- upbeat 1
- vocal backup 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gimme More (Britney Spears) - Cover/Male Singing. | A female singer sings soft pop songs. The tempo is medium fast with electronically arranged music, electric guitar harmony, digital drum beats, and melodious vocal backup. The song is simple, soft, emotional, upbeat, catchy, with a dance groove. This song is an Electro Pop song. | 2013-03-03T05:27:25Z | TheMaleBritney | Please Like, Subscribe, Share and Comment :D I Don't Own "Gimme More" Britney Does. Heres the link to buy the original Gimme More: https://itunes.apple.com/au/album/gimme-more-single/id264025647 | ["Singing", "Music", "/m/05zppz", "Pop music", "/t/dd00003"] | ["female singer", "medium fast tempo", "emotional", "contemporary pop", "upbeat", "groovy rhythm", "dance music", "dance pop", "club music", "electro pop", "synth pop", "ambient", "electronic music", "synthesiser articulation", "digital drumming", "keyboard arrangement", "electric guitar riff", "vocal backup"] | 7 | MY0PsDE3xHs | 2279 | |
Tracy Chapman and Bruce Springsteen - My Hometown (Live 2004) | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | 2010-09-19T11:10:04Z | Tracy Chapman Online | ♥ Subscribe our newsletter ► https://www.about-tracy-chapman.net/newsletter/ ♥ ♥ Subscribe Tracy Chapman Youtube Channel ► http://www.youtube.com/tchapmanfan ♥ See also ► Fan website : http://www.about-tracy-chapman.net/ ► Facebook: https://www.facebook.com/tracychapmanonline ► Instagram https://instagram.com/tracychapmanonline ► Twitter: https://twitter.com/tchapmanonline Order Tracy Chapman’s "Greatest Hits" on iTunes http://apple.co/1RtSdDu | Amazon: http://hyperurl.co/TC-GH Tracy Chapman and Bruce Springsteen perform "My hometown" in 2004. Low Quality rare video. | ["Singing", "Music", "/t/dd00003"] | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | 4 | aPQTrv2B1sw | 3536 | |
NEIL YOUNG : ALABAMA . | This is a rock music piece with a leading male vocal. The electric guitar is playing the main melody while a simple rock beat is being played by the acoustic drums as the rhythmic background. It has the definitive qualities of 70s American rock music. It could be used in a movie taking place in the 70s. It could also be played at a rock bar or a sports bar in the background. | 2010-07-09T15:28:56Z | Solstice Shadows | Audience recording from the Winterland San Francisco California . 22nd March 1973 . Alabama . | ["Singing", "Music", "/t/dd00003"] | ["rock music", "male vocals", "electric guitar", "acoustic drums", "american", "repeated theme"] | 9 | dMAp3dvs3kE | 3777 |
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;