musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- exciting · 4 ✖
- poor audio quality · 4 ✖
- youthful · 4 ✖
- emotional 2
- energetic 2
- groovy bass line 2
- instrumental music 2
- male singer 2
- medium tempo 2
- romantic 2
- spirited 2
- acoustic guitar 1
- acoustic guitars strumming 1
- adventurous 1
- ambient street noises 1
- booming bass line 1
- country music 1
- dance rhythm 1
- distorted guitar lead 1
- dj 1
- fast harp passages 1
- fast tempo 1
- fats harp playing 1
- folk music 1
- groovy bas slime 1
- groovy dance music 1
- groovy rhythm 1
- guitar band 1
- guitar rhythm 1
- harpist 1
- head bangers 1
- high gain recording 1
- home music video 1
- house mix 1
- instrumental duet 1
- keyboard harmony 1
- latin dance music 1
- latin folk music 1
- medium fast tempo 1
- music jam 1
- party all night 1
- party mix 1
- people screaming 1
- ping pong shot tones 1
- positive 1
- retro classic rock 1
- rhythm guitar 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- screaming vocals 1
- story telling 1
- sweeping keyboard harmony 1
- talented duo 1
- techno dance rhythm 1
- trance music 1
- ukulele playing 1
- underground music scene 1
- various percussion hits 1
- youtube songs 1
musiccaps_names (array) 24 ✖
- Music 3
- Banjo 1
- Christian music 1
- Country 1
- Dance music 1
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- Grunge 1
- Guitar 1
- Harp 1
- Heavy metal 1
- House music 1
- Mandolin 1
- Musical instrument 1
- Pizzicato 1
- Plucked string instrument 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Song 1
- Steel guitar, slide guitar 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El karma - abraham gonzalez | A male singer sings this Latin dance melody. The tempo is fast with a harpist playing fast passages with an acoustic guitar strumming rhythm. The song is emotional and energetic. The audio quality is bad with ambient Street noises and high gain. | 2014-10-31T22:33:27Z | Abraham Gonzalez | Abraham gonzalez y flavio vega esperemos le guste amigos dios los vendiga siempre...!! | ["Harp", "Pizzicato"] | ["harpist", "acoustic guitar", "fast harp passages", "talented duo", "instrumental duet", "rhythm guitar", "fast tempo", "folk music", "latin folk music", "fats harp playing", "exciting", "romantic", "poor audio quality", "high gain recording", "youthful", "latin folk music", "latin dance music", "groovy rhythm", "emotional", "ambient street noises", "male singer"] | 1 | A2pgKzeDRqg | 1062 | |
Gypsy - Tyler May & The Kentucky School of Bluegrass and Traditional Music Ensemble | The song is an instrumental. The song is medium fast tempo with a groovy bass line, acoustic guitars strumming rhythm, and a ukulele playing lead. The song is spirited and exciting. The song is an instrumental with country music influences. | 2011-04-23T00:46:35Z | Stewart Tyler May | Gypsy © 2011 by Stewart Tyler May Guitar - Josh Reimen Guitar - Leslie Strong Banjo - Jeremy Moses Mandolin - Isaac May Bass - Tina May Fiddle/Clawhammer Banjo - Tyler May | ["Banjo", "Country", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["ukulele playing", "acoustic guitars strumming", "groovy bass line", "dance rhythm", "home music video", "youtube songs", "music jam", "spirited", "poor audio quality", "guitar band", "country music", "groovy bas slime", "energetic", "youthful", "exciting", "emotional", "dance rhythm", "instrumental music", "medium fast tempo"] | 1 | CudxWnS7ukw | 1413 | |
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;