musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 6 and musiccaps_names contains "New-age music" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- acoustic guitar 2
- dreamy 2
- medium to uptempo 2
- relaxing 2
- synth pad 2
- acoustic piano 1
- atmospheric 1
- e-bass 1
- electronic/meditation 1
- female voice singing 1
- guitar 1
- piano 1
- slow tempo 1
- synth bass 1
- synth plucks 1
- voice sample 1
musiccaps_names (array) 5 ✖
- Music 3
- New-age music · 3 ✖
- Ambient music 1
- Background music 1
- Drum and bass 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dave Darrell - Children | This piece contains a lot of reverb and the instruments are using delay to create long arpeggio landscapes and rhythms. An acoustic guitar is being picked creating an arpeggio melody. A piano is playing a countermelody with a lot of reverb. A synth bassline playing one note in a 8th note rhythm is holding the ground of this composition. This song may be playing while dancing alone in your room. | 2008-09-13T15:02:12Z | a6n1a9 | Dave Darrell(or Darell, I don't know) - Children This video is dedicated to my bloody best friend! I wanna thank her for everything! I Love You Dick! =D ----------------------------- | ["New-age music", "Music"] | ["electronic/meditation", "acoustic guitar", "e-bass", "piano", "synth bass", "dreamy", "medium to uptempo"] | 6 | UeYmnV-B8so | 2931 | |
Bcee - Hold On | A voice sample is ringing out with a lot of reverb. A synth pad is underlining an acoustic piano being played with a lot of reverb and delay creating an arpeggio. A guitar is playing another melody also with a lot of reverb and delay creating a ping pong effect on both sides of the speakers. There is another pulsating little synth sound being played in a higher key. This song may be playing at home relaxing and daydreaming. | 2013-07-25T11:30:12Z | Liquicity | In heaven Bcee: http://www.facebook.com/bceespearhead http://twitter.com/stevebcee Liquicity Facebook: http://www.facebook.com/Liquicity Liquicity Events: http://www.facebook.com/LiquicityEvents Liquicity Twitter: http://www.twitter.com/liquicity Join Liquicity Records Soundcloud & Beatport! Beatport Page: http://beatport.com/label/liquicity-records/25942 Soundcloud Page: http://soundcloud.com/liquicityrecords Free Liquicity Wallpaper: http://tinyurl.com/cc6fy44 [Liquicity Merchandise:] EU: http://liquicity.spreadshirt.nl/ USA http://liquicity.spreadshirt.com | ["Drum and bass", "New-age music", "Music", "Ambient music"] | ["atmospheric", "acoustic piano", "guitar", "voice sample", "synth pad", "relaxing", "dreamy", "slow tempo"] | 6 | 7k3OZ_fPXuM | 877 | |
Raudsilla Matkakompleks | A female voice is singing with a little bit of reverb and delay on her voice. A synth pad is playing a soft string drone sound in the mid-range. An acoustic guitar is playing an arpeggio melody along with a synth pluck sound walking down a scale and another pluck sound playing a melody on top. All of them have different rhythm structures and seem to play against each other but fitting perfectly together. The sounds are spread across both sides of the speakers. This song may be playing in a ceremony at a festival. | 2011-08-11T10:34:03Z | Hantlike | Raudsilla Matkakompleks Created with MAGIX Slideshow Maker 2 | ["Background music", "New-age music", "Music"] | ["synth pad", "synth plucks", "acoustic guitar", "female voice singing", "relaxing", "medium to uptempo"] | 6 | v88cAXP03As | 5157 |
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;