musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "together forever"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- emotional 2
- female singer · 2 ✖
- love song 2
- piano accompaniment · 2 ✖
- together forever · 2 ✖
- backup singers 1
- bad audio quality 1
- black gospel music influences 1
- blues music 1
- cymbals crashing 1
- disco music 1
- disco romance hits 1
- dream of you 1
- falsetto 1
- groovy bass line 1
- guitar rhythm 1
- jazz and blues 1
- jazz drumming rhythm 1
- jazz music 1
- love you so badly 1
- marry me 1
- missing you 1
- passionate 1
- percussive bass line 1
- retro hits 1
- retro pop song 1
- slow tempo 1
- slowing down 1
- song retarding 1
- soul music 1
- special someone 1
- steady drumming 1
- story telling 1
- tambourine percussions 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Music 2
- Happy music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alice Fredenham - How Come You Don't Call | A female singer sings this soulful song. The song is slow tempo with piano accompaniment, strong bass line and groovy jazz drumming. The song is soulful and emotional. The song is a blues jazz song. | 2013-07-28T23:41:28Z | Virgilio Gan | Alice Fredenham - How Come You Don't Call http://www.facebook.com/realhealthnwealth Virgilio Gan World Talent Media Group | ["Music", "Happy music"] | ["female singer", "soul music", "jazz music", "blues music", "jazz and blues", "slow tempo", "black gospel music influences", "special someone", "dream of you", "missing you", "percussive bass line", "jazz drumming rhythm", "piano accompaniment", "emotional", "love song", "story telling", "love you so badly", "together forever"] | 1 | XUD-9HkQuTE | 3186 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 |
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;