musiccaps_details (view)
3 rows where musiccaps_aspects contains "rock", musiccaps_names contains "Singing" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- rock · 3 ✖
- acoustic drums 1
- alternative rock 1
- bass drum 1
- bright drumming 1
- cymbals 1
- dissonant female vocal 1
- e-bass 1
- e-guitars 1
- electric guitar melody 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- funky bass line 1
- funky keyboard harmony 1
- groovy bass 1
- groovy electric guitar accompaniment 1
- hard rock 1
- higher register 1
- hollow snare 1
- lively 1
- low quality 1
- male vocal backup 1
- male vocalist 1
- male voice singing 1
- medium to uptempo 1
- melancholic 1
- noisy 1
- shimmering hi hats 1
- sloppy 1
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RapScallions - The Garage Sessions - "What Do Ya Say?" | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | 2013-04-02T04:59:36Z | OfficialRapScallions | BUY THE NEW ALBUM "IN MY HEAD" on iTunes https://itunes.apple.com/us/album/in-my-head-ep/id611204088 The Garage Sessions #2: "What Do Ya Say?" Vocals: Sergio Ochoa Guitar: Dario Forzato Bass: Chris Clemence Drums: James Forsberg Video Director: Alessandro Casati RapScallions would like to thank their sponsors: D'Addario Strings, Planet Waves, Evans, Pro Mark, Warwick and Truth Custom Drums. | ["Singing", "Music", "Ska"] | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | 7 | 5xBfKiQcMZQ | 707 | |
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 | |
grace slick & the great society-white rabbit | The low quality recording features a rock song where dissonant female vocals are singing over electric guitar melody, groovy bass guitar, hollow snare, shimmering hi hats and soft kick hits. It sounds sloppy and the recording is noisy. | 2008-01-07T17:16:48Z | Francesco Giuliobello | An early live version of this song. White rabbit(1965). The images are taken from the movie:Woodstock 3 days of peace & music | ["Singing", "Ska"] | ["low quality", "rock", "unbalanced stereo", "noisy", "electric guitar melody", "dissonant female vocal", "shimmering hi hats", "groovy bass", "hollow snare", "soft kick hits", "sloppy"] | 4 | YddV91xnUz4 | 3302 |
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;