musiccaps_details (view)
2 rows where musiccaps_names contains "Singing" and "youtube_published" is on date 2012-12-10
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic drums 1
- ambient room noise 1
- cymbals crashing 1
- e-bass 1
- e-guitars 1
- female choir 1
- female singer 1
- higher register 1
- improvisation 1
- jazz drumming 1
- jazz scatting 1
- latin jazz music 1
- latin percussion rhythm 1
- love performance 1
- male voice singing 1
- medium fast tempo 1
- medium to uptempo 1
- melancholic 1
- piano accompaniment 1
- poor audio quality 1
- rock 1
- scat improvisation 1
- screaming vocals 1
- steady bass line 1
- vocal jazz 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Peter Doherty - Nothing Comes To Nothing (DEMO Track) | This song contains acoustic drums playing kind of a slow drum&bass rhythm along with a bass playing the rootnote of a e-guitar strumming along. Another e-guitar is strumming along, panned to the right side of the speakers. A male voice is singing in a higher key with delay in his voice. This song may be playing with headphones on a rainy colder day. | 2012-12-10T19:03:53Z | enenes | "Nothing Comes To Nothing" Won't you come, come back to earth Cause they're all concerned You know how they're worried for you. And all their words, they jar my nerves I know Each curse by each new kiss is run through Nothing comes to nothing without my baby, Nothing ever comes to nothing without my baby At an Amwellian Do a tongue soaked in booze says "He's filthy and much older than you" Oh the sick sick muse, the sickly muse Pulls out her sickle so shiny, cuts the tongue in two While the music sways and forays and searches and says: "Give me the young man in blue" While the music sways and forays and searches and says: "Break your heart in two" Nothing comes to nothing without my baby, Nothing ever comes to nothing with my baby, All I ever do Where's the happy prince? Where? There's his smiling bride. He's right beside you Flo... Nothing ever comes to nothing without my baby, Nothing's ever good for nothing with that lady Nothing ever comes to nothing without my baby, Nothing ever comes to nothing without my baby | ["Singing", "Music", "Ska"] | ["rock", "e-bass", "e-guitars", "acoustic drums", "male voice singing", "higher register", "melancholic", "medium to uptempo"] | 6 | FY8bZRm_QiE | 1647 | |
Jazzmeia Horn- (The Horn and The Harper)- Insight By Billy Harper | A female singer sings this jazz scat improvisation. The song is medium fast tempo with jazz drumming, Latin percussion, steady bass line and a piano accompaniment. The song is energetic and highly improvisational. The song is a live jazz performance with ambient room noises and other disturbances. | 2012-12-10T06:12:08Z | msjazzhorn | Insight- Billy Harper Professor, Director, Educator, Musician, Father- Billy Harper uses 60 voices in a concert. This is a snippet of the small group from those 60 voices. Jazzmeia Horn & Billy Harper have fun doing what they love best! "Having a musical conversation" :) | ["Singing", "Jazz", "Music", "Tambourine"] | ["female singer", "jazz scatting", "medium fast tempo", "cymbals crashing", "latin percussion rhythm", "piano accompaniment", "steady bass line", "screaming vocals", "love performance", "ambient room noise", "vocal jazz", "scat improvisation", "poor audio quality", "jazz drumming", "improvisation", "female choir", "latin jazz music"] | 1 | HtSznF9_784 | 1845 |
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;