musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 71 ✖
- groovy rhythm · 5 ✖
- medium tempo · 5 ✖
- story telling · 5 ✖
- male singer 4
- emotional 3
- exciting 3
- vocal harmony 3
- backup singers 2
- groovy bass line 2
- guitar rhythm 2
- hip hop music 2
- ambient street noises 1
- autoharp accompaniment 1
- bad audio quality 1
- badly tuned strings 1
- cello playing 1
- cheerful 1
- classic county hits 1
- country classics 1
- country music 1
- cymbals crashing 1
- dance rhythm 1
- discordant harmonies 1
- enteric 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- groovy cello bass 1
- guitar strumming 1
- happy 1
- hip hop dance music 1
- indie music 1
- keyboard harmony 1
- male backup singers 1
- male singers 1
- marching rhythm 1
- modern love 1
- nostalgia 1
- offbeat 1
- old memories 1
- old school music 1
- old world charm 1
- pain 1
- people dancing 1
- percussive bass line 1
- pleasant 1
- poor audio quality 1
- poor video quality 1
- pop super hits 1
- positive cheerful 1
- psychedelic pop 1
- quirky and eccentric 1
- reggae hip hops music 1
- retro hits 1
- retro pop music 1
- roller sakte wheel squeaking tones 1
- roller skate wheel noises 1
- romantic 1
- slick drumming rhythm 1
- snare hits 1
- song cover 1
- spirited 1
- spirited singing 1
- squeaky wheel noise 1
- steady drumming 1
- steady drumming rhythm 1
- string harmony 1
- strumming guitars 1
- vintage hits 1
- walking bas s line 1
- walking bass line 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
Coedie Donovan MGP Edit | A male singer sings this hip hop song with backup singers in vocal harmony. The song is medium tempo with slick drumming rhythm, groovy bass line, and keyboard harmony. The song is story telling and emotional in nature. The song has poor audio quality with ambient noises like squeaking wheel tones. | 2009-12-06T20:08:48Z | Nickehfilms | Coedie Donovan MADDGEAR TEAM Filmed over 2 days except the: Grind to inward off grind to double whip off 270 back lip down whip off | ["Music", "Skateboard"] | ["male singer", "backup singers", "vocal harmony", "roller skate wheel noises", "squeaky wheel noise", "medium tempo", "groovy rhythm", "hip hop music", "slick drumming rhythm", "groovy bass line", "keyboard harmony", "emotional", "pain", "story telling", "groovy rhythm", "ambient street noises", "roller sakte wheel squeaking tones"] | 1 | An-4jPvUT14 | 1169 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 | |
Strobe Light by Luke Janela - Cello Rock Music | Male singers sing this vocal harmony. The song is medium tempo with steady drumming rhythm, cello playing the bass line, guitars strumming rhythm and various percussion hits. The song is chaotic and exciting. The song is an amateur band playing a retro pop song with audio quality. | 2009-10-14T23:46:39Z | Luke Janela | Buy the album, REDWOOD SUMMER on iTunes at: http://itunes.apple.com/us/album/redwood-summer/id336710013 or order the cd at: http://www.cdbaby.com/cd/lukejanela5 Cellist/Songwriter Luke Janela performs the song "Strobe Light" off his album REDWOOD SUMMER. | ["Music", "Punk rock", "Independent music", "Psychedelic rock"] | ["cello playing", "discordant harmonies", "offbeat", "groovy rhythm", "old world charm", "indie music", "poor video quality", "male singers", "vocal harmony", "strumming guitars", "medium tempo", "groovy cello bass", "quirky and eccentric", "badly tuned strings", "cheerful", "happy", "story telling", "psychedelic pop"] | 1 | oYECB7KFJgU | 4639 |
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;