musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "rock and roll" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- male singer · 2 ✖
- retro 2
- rock and roll · 2 ✖
- baby crying 1
- bass guitar 1
- classic pop 1
- dance groove 1
- electric guitar 1
- enthusiastic drumming 1
- fast tempo 1
- infectious drumming 1
- jive 1
- keyboard harmony 1
- lively piano 1
- love song 1
- medium tempo 1
- popular music 1
- rhythmic acoustic guitar 1
- rock and rock 1
- romantic 1
- static 1
- steady drumming 1
- superimposed noises 1
- synthesiser arrangements 1
- tapping sound 1
- upbeat 1
- violins 1
- vivacious 1
- youthful 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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;