musiccaps_details (view)
3 rows where musiccaps_aspects contains "mellow", musiccaps_author = 9 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- mellow · 3 ✖
- male voice 2
- ambient synth 1
- calm 1
- clean sound 1
- electric guitar 1
- female voice 1
- gentle playing 1
- guitar lesson 1
- instructive speaking 1
- instrument showcase 1
- jam 1
- meditation 1
- relaxing 1
- spanish 1
- speech 1
- steel drums 1
musiccaps_names (array) 10 ✖
- Music 3
- Speech · 3 ✖
- Musical instrument 2
- Electronic tuner 1
- Guitar 1
- Inside, small room 1
- New-age music 1
- Percussion 1
- Plucked string instrument 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SANAR EL CANCER CON EL ARCANGEL RAFAEL.Original de maya333godwmv | This is a meditation track. There is a mellow sounding ambient synth in the background. A female voice can be heard speaking gently in the Spanish language. The general atmosphere of the track is calm. | 2012-02-06T03:38:11Z | maya333god | Lograr que esa energía estancada en nuestras células, pueda fluir AUDIO IVOOX http://www.ivoox.com/meditacion-sanar-cancer-arcangel-rafael-audios-mp3_rf_1425120_1.html | ["New-age music", "Music", "Speech"] | ["meditation", "ambient synth", "female voice", "speech", "spanish", "mellow", "calm"] | 9 | B9K58KYq-Cs | 1212 | |
Guitar Lesson - Hallelujah by Jeff Buckley - Simple How to Play Tutorial | This is the recording of a guitar lesson video. There is a male speaking in an instructive manner, giving the name of the chord he is about to play next. The chords are being played gently on a clean sounding electric guitar. There is a mellow feel to the sound. Parts of this recording can be sampled for use in beat-making. | 2011-02-02T23:22:19Z | FullDistortionDotCom | http://www.FullDistortion.com - Lesson on how to play Hallelujah by Jeff Buckley. To view this lesson with the tab go to http://www.FullDistortion.com. To join the Full Distortion Players' Club go to http://www.FullDistortion.com/players-club Copyrights to any songs mentioned or used are the property of the artist and its promoters, producers and/or affiliates and is used here for informational and educational purposes only as outlined in the Fair Use provision of Title 17 of the United States Code as amended by the Digital Millennium Copyright Act of 1998. No copyright infringement intended. | ["Guitar", "Music", "Musical instrument", "Speech", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["guitar lesson", "male voice", "instructive speaking", "electric guitar", "clean sound", "gentle playing", "mellow"] | 9 | WvaIypMvAHY | 3149 | |
Rockcreek Steel Drums Cycle of Fifths Drum | This is an instrument showcase jam. The steel drums are being played in a gentle manner. Then, a male voice starts describing the features of the steel drums. The instrument has a relaxing timbre. The parts where it is being played can be sampled for use in the background of meditation videos. | 2010-03-05T21:12:05Z | steeldrumbuilder | Demonstration of Rockcreek Steel Drums Cycle of Fifths Drum | ["Music", "Musical instrument", "Speech", "Percussion", "Steelpan"] | ["instrument showcase", "jam", "male voice", "steel drums", "relaxing", "mellow"] | 9 | pvxx3aokwCU | 4742 |
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;