musiccaps_details (view)
2 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- emotional 2
- female singer · 2 ✖
- piano accompaniment · 2 ✖
- slow tempo · 2 ✖
- black gospel music influences 1
- blues music 1
- booming bass line 1
- chaotic harmony 1
- classic pop hits 1
- classic pop song 1
- dream of you 1
- dreamscapes 1
- electric guitar tremolo tones 1
- grunge keyboard tones 1
- inspiring 1
- jazz and blues 1
- jazz drumming rhythm 1
- jazz music 1
- love song 1
- love you so badly 1
- melancholic 1
- missing you 1
- percussive bass line 1
- poor audio quality 1
- pop song 1
- sadness 1
- soul music 1
- special someone 1
- steady drumming rhythm 1
- story telling 1
- tambourine percussions 1
- together forever 1
- traditional percussion rhythm 1
- trudging drum rhythm 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 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 |
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;