musiccaps_details (view)
2 rows where musiccaps_aspects contains "soulful", musiccaps_names = "["Music", "Soul music"]" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Grateful Dead - Ship of Fools | The Rock song features a groovy piano melody followed by passionate electric guitar melody, church organ chord progression, strummed acoustic rhythm guitar chords, shimmering cymbals, punchy snare and mellow kick hits. It sounds emotional, soulful and passionate. | 2011-05-30T15:59:43Z | Istofn | ["Music", "Soul music"] | ["rock", "groovy piano melody", "passionate electric guitar melody", "church organ chords progression", "strummed acoustic rhythm guitar chords progression", "shimmering cymbals", "punchy snare", "mellow kick", "emotional", "soulful", "passionate"] | 4 | 6iZ49s7eH5g | 777 | ||
Arthur Conley ~ Sweet Soul Music (1967) | This is an upbeat, soulful and funky song. It's got a catchy and fast paced rhythm which makes it good to dance to. The singer has a raspy and energetic voice. | 2011-10-24T15:04:43Z | TheOldrecordclub | This great soul song by "Arthur Conley" was released in 1967 and i believe this was the biggest hit song he had.He actually wrote this song with "Otis Redding" and the song was originally released on the Atco label. | ["Music", "Soul music"] | ["blues", "funky", "soulful", "upbeat", "dance", "vibrant", "groovy bassline", "rhythm & blues", "raspy male vocal", "energetic male vocalist", "simple drum beat"] | 3 | grE0lwTsSPg | 4060 |
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;