musiccaps_details (view)
3 rows where musiccaps_aspects contains "male singer" and musiccaps_aspects contains "rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- male singer · 3 ✖
- rock and roll · 3 ✖
- keyboard harmony 2
- retro 2
- steady drumming 2
- baby crying 1
- bass guitar 1
- buoyant 1
- classic pop 1
- dance groove 1
- electric guitar 1
- electric guitar lead 1
- enthusiastic drumming 1
- fast tempo 1
- groovy 1
- groovy bass line 1
- infectious drumming 1
- jive 1
- lively piano 1
- love song 1
- medium tempo 1
- piano accompaniment 1
- popular music 1
- punchy beats 1
- retro feel 1
- rhythmic acoustic guitar 1
- rock and rock 1
- rock music 1
- romantic 1
- slow tempo 1
- soft rock 1
- static 1
- superimposed noises 1
- syncopated harmony 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tapping sound 1
- upbeat 1
- violins 1
- vivacious 1
- youthful 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 | |
RickRolling the Baby | A male singer sings this classic pop song. The tempo is fast with keyboard harmony, violins,infectious drumming,funky bass guitar and synthesiser arrangement. There are sounds of static, tapping and a baby crying loudly superimposed on the song. The audio quality is inferior and the recording is amateur. This song is Retro Rock and Roll. | 2008-01-26T06:05:33Z | DessertSage | http://www.marylowd.com | ["Crying, sobbing", "Music", "Baby cry, infant cry", "Inside, small room"] | ["male singer", "fast tempo", "baby crying", "youthful", "romantic", "upbeat", "superimposed noises", "synthesiser arrangements", "infectious drumming", "love song", "romantic", "vivacious", "violins", "bass guitar", "keyboard harmony", "tapping sound", "static", "steady drumming", "classic pop", "rock and roll", "retro"] | 7 | qMbGFWz9who | 4780 |
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;