musiccaps_details (view)
4 rows where musiccaps_aspects contains "enthusiastic drumming", musiccaps_aspects contains "male singer" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- enthusiastic drumming · 4 ✖
- male singer · 4 ✖
- fast tempo 3
- buoyant 2
- lively piano 2
- rhythmic acoustic guitar 2
- youthful 2
- animated 1
- animated piano 1
- blasts 1
- booming sounds 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- children’s song 1
- congas 1
- creepy 1
- dance groove 1
- dance music 1
- deep vocal riff 1
- eerie 1
- electric guitar 1
- electro pop 1
- electro rock 1
- electronic rhythm 1
- energetic 1
- energetic music 1
- enthusiastic 1
- fun 1
- groovy bass lines 1
- happy 1
- jive 1
- keyboard arrangement 1
- keyboard harmony 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- medium tempo 1
- muffled background sounds 1
- mysterious 1
- people screaming 1
- peppy 1
- pop rock 1
- popular music 1
- psychotic 1
- retro 1
- rock and rock 1
- rock and roll 1
- shooting 1
- sinister 1
- spanish guitar 1
- spine tingling 1
- spirted 1
- steady bass line 1
- synth arrangements 1
- synth pop 1
- thrilling 1
- upbeat 1
- vibrant 1
- vigorous 1
- vivacious 1
- world music 1
musiccaps_names (array) 8 ✖
- Music 4
- /t/dd00032 1
- Boom 1
- Country 1
- Drum and bass 1
- Electronic 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 | |
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;