musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic piano", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic piano · 4 ✖
- amateur recording · 4 ✖
- uptempo · 4 ✖
- aggressive 1
- atmospheric sound 1
- ballad/pop 1
- digital drums 1
- e-guitar 1
- female singer 1
- female voice singing 1
- pop 1
- positive energy 1
- punkrock 1
- sad 1
musiccaps_names (array) 11 ✖
- Music 4
- Blues 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Heavy metal 1
- Musical instrument 1
- Sonar 1
- Tender music 1
- Vocal music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Minsan ♥ ( ROSELL GiMO ) | An acoustic piano is playing a sad piece accompanied by a female singer. A simple digital drum with crash hits rounds up the composition. This song is an amateur recording but of decent quality. This song may be playing at a talent show. | 2013-10-28T07:32:08Z | Rosell Gimo | ["Music", "Zing"] | ["ballad/pop", "acoustic piano", "female singer", "digital drums", "amateur recording", "uptempo", "sad"] | 6 | BWKQXn5xDwo | 1248 | ||
Lady Gaga - Telephone (Piano Cover) Music Video | This audio contains someone playing a modern piece of music on an acoustic piano. This song may be playing live in a bar with a piano. | 2010-01-16T22:32:30Z | Iwillbot | telephone lady gaga music video / telephone lady gaga piano cover / telephone lady gaga acoustic version / me playing telephone lady gaga / telephone lady gaga official music video / telephone lady gaga official lyrics / telephone lady gaga mp3 download link / telephone lady gaga studio version / telephone lady gaga live performance / telephone lady gaga chipmunk version / telephone lady gaga played by Iwillbot / telephone lady gaga piano tutorial / how to play telephone lady gaga / Not sure you can find sheet music for this Mp3 also! http://iwillbot.blogspot.com/ Personal Account + Piano Lessons http://www.youtube.com/WillTingMusic Sheet Music Links on Blog+Myspace http://iwillbot.blogspot.com/ http://www.myspace.com/iwillbot http://www.twitter.com/iwillbot | ["Blues", "Music"] | ["amateur recording", "pop", "acoustic piano", "uptempo"] | 6 | jBmP7xTI_TA | 4241 | |
New Teen Singer Star Actress Sound of Music How Can Love Survive Diana Madison Suk Broadway Musical | A female voice is singing in a high key along to a piano supported with the suited chords. This is an amateur recording. This song may be playing in a musical. | 2012-11-24T22:03:46Z | DianaMadisonMusic | New Teen Singer Star Actress, The Sound of Music, How Can Love Survive, Diana Madison Suk Music, Diana Suk, Broadway Musicals, Rogers & Hammerstein, Baroness Elsa Schraeder, New Teen Singer. Broadway Play, Song Version, Musical Theatre. Top teen talent. Up and coming talent. New music artists. Disney. Von Trapp Family. New Singers. New artists. Music industry, Theatre, Musical, Hollywood, Broadway, Teen Stars, New teen stars, actors, actresses, singers, taylor swift live performance, on stage, beautiful voice, x-factor, voice, american idol, pop singers, pop stars, humor, comedy, cast, ensemble, diana madison. | ["Music", "Vocal music", "Tender music"] | ["amateur recording", "female voice singing", "acoustic piano", "uptempo", "positive energy"] | 6 | jWQu301CEp8 | 4258 | |
Decapitated - The Blasphemous Psalm to The Dummy God Creation - Drum Cover | A drum is playing a lot of crash hits with fast and accurate snare rolls along to a backing track that contains an e-guitar playing a riff in a lower key. This song may be playing at a studio practicing. | 2014-08-07T17:49:41Z | Kevin Paradis | I proudly endorsed TRICK DRUMS USA double pedals and trigger. Hi there ! I've opened a soundcloud profile, and you will find on it some Drums Only mp3 files. You will be able to download them ! I just ask you to put a link to my youtube channel/facebook artist page if you use my drums on a video. Hope it will will be useful ! Drums only : https://soundcloud.com/kevinparadisdrummer/decapitated-the-blasphemous-psalm-to-the-dummy-god-drums-only-cover https://www.facebook.com/kevinparadisdrumming | ["Cymbal", "Drum", "Drum kit", "Heavy metal", "Music", "Musical instrument", "Sonar"] | ["punkrock", "acoustic piano", "atmospheric sound", "e-guitar", "uptempo", "aggressive", "amateur recording"] | 6 | w5EbmsPfGSo | 5238 |
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;