musiccaps_details (view)
5 rows where musiccaps_aspects contains "enthusiastic drumming" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 85 ✖
- enthusiastic drumming · 5 ✖
- male singer · 5 ✖
- fast tempo 3
- youthful 3
- buoyant 2
- enthusiastic 2
- lively piano 2
- rhythmic acoustic guitar 2
- animated 1
- animated piano 1
- blasts 1
- booming sounds 1
- bouncy 1
- brass band 1
- brass instruments 1
- break the tension 1
- bright trumpet 1
- building anticipation 1
- buzz 1
- children’s song 1
- congas 1
- creepy 1
- dance groove 1
- dance music 1
- deep vocal riff 1
- distorted amplified guitar 1
- drum roll 1
- eerie 1
- electric guitar 1
- electro pop 1
- electro rock 1
- electronic rhythm 1
- electrostatic sounds 1
- energetic 1
- energetic music 1
- exciting 1
- fun 1
- get tones 1
- groovy bass lines 1
- guitar strumming 1
- happy 1
- heart beat melody 1
- jive 1
- k-pop 1
- keyboard arrangement 1
- keyboard harmony 1
- korean rock band 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- medium tempo 1
- muffled background sounds 1
- mysterious 1
- passionate 1
- people screaming 1
- peppy 1
- percussive bass line 1
- pop 1
- pop dance rhythm 1
- pop dance song 1
- pop rock 1
- popular music 1
- psychotic 1
- retro 1
- rock and rock 1
- rock and roll 1
- shooting 1
- signal tempo 1
- sinister 1
- spanish guitar 1
- spine tingling 1
- spirited 1
- spirted 1
- steady bass line 1
- storm cloud noises 1
- synth arrangements 1
- synth pop 1
- teen spirit 1
- thrilling 1
- upbeat 1
- vibrant 1
- vigorous 1
- vivacious 1
- world music 1
musiccaps_names (array) 9 ✖
- Music 5
- /t/dd00032 1
- Boom 1
- Country 1
- Drum and bass 1
- Electronic music 1
- Exciting music 1
- Music of Latin America 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
SAW DRUM AND BASS REMIX | A male uses a vocal phrase to the rhythm of background music. The tempo is fast with vigorous drumming, keyboard arrangements and muffled sounds of blasts, people screaming and shooting. This song is aggressive, sinister, creepy, mysterious and spine-tingling. This song is an Electro Pop/Rock. | 2008-02-19T15:43:42Z | mrDOTstretch | saw film drum and bass remix | ["Drum and bass", "Electronic music", "Music", "Boom"] | ["male singer", "fast tempo", "enthusiastic drumming", "people screaming", "shooting", "muffled background sounds", "spine tingling", "mysterious", "psychotic", "electro pop", "electro rock", "keyboard arrangement", "booming sounds", "blasts", "deep vocal riff", "sinister", "eerie", "creepy", "thrilling"] | 7 | RZmH4hGiYBg | 2711 | |
She's So Fine-Flash Cadillac-original song-1972 | A male vocalist sings this upbeat retro song. The tempo is medium with an infectious electronic guitar, hard hitting drums, rhythmic acoustic guitar and funky bass. The song is rhythmic, groovy, upbeat, catchy, and energetic. This song is Retro Rock and Roll. | 2008-03-18T21:01:55Z | AK47bandit | original song, oldie. | ["Country", "Music"] | ["male singer", "medium tempo", "rock and roll", "rhythmic acoustic guitar", "popular music", "retro", "dance groove", "jive", "enthusiastic drumming", "lively piano", "rock and rock", "electric guitar"] | 7 | d20qTsF6ll8 | 3758 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 |
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;