musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussion", musiccaps_aspects contains "relaxing" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- percussion · 3 ✖
- relaxing · 3 ✖
- instrumental 2
- acoustic guitar 1
- ambient 1
- bass guitar 1
- birds singing 1
- calming 1
- drums 1
- easygoing 1
- female vocal 1
- flute 1
- hopeful 1
- indian 1
- jazz steel pan 1
- live performance 1
- melodic singing 1
- movie music 1
- playful 1
- rhythm 1
- solo 1
- wind 1
musiccaps_names (array) 12 ✖
- Music 3
- Drum 1
- Drum kit 1
- Electronic organ 1
- Humming 1
- Inside, small room 1
- Jazz 1
- Musical instrument 1
- Organ 1
- Percussion 1
- Rustling leaves 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Energy from the Wind - Wind Turbines | This is an instrumental flute piece. The flute is playing a solo while ambient samples of the wind and the birds singing can be heard in the background. There is also a very faint clattering bell-like percussion that can be heard. The piece is very relaxing. It could be used in a meditation video. It could also be used during the scenery shots in the soundtrack of a documentary. | 2007-03-30T18:25:34Z | Bernd Riebe | I am fascinated by those beautiful, effective and environmentally sound modern wind turbines. This is the Repower MM92, rated power: 2000kW, rotor diameter: 92.5m, hub height: 100m. See also the record breaking 6MW E-126 from ENERCON http://www.youtube.com/watch?v=LQxp6QTjgJg | ["Music", "Rustling leaves"] | ["instrumental", "flute", "solo", "ambient", "wind", "birds singing", "percussion", "calming", "relaxing"] | 9 | 9gCeNCnWZhE | 1032 | |
Andy Narell Solo | This is the live performance of a percussion piece. There is a playful sounding jazz steel pan solo being performed on stage. The atmosphere is easygoing. This piece could be used during tropical scenery shots in a movie with a summer/vacation theme. | 2008-03-30T15:10:09Z | nehpets99 | Andy Narell, world famous steel pan composer/performer, solos as the guest artist for Miami University's Steel Band. | ["Organ", "Drum", "Drum kit", "Jazz", "Electronic organ", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["percussion", "rhythm", "live performance", "instrumental", "jazz steel pan", "playful", "relaxing", "easygoing"] | 9 | cQpK9zs_uv0 | 3706 | |
Life of Pi - "Pi's Lullaby" - Cover Version by Ambika Jois & Amal Lad | This is a movie music piece. There is a female vocalist singing melodically at the forefront. There is an acoustic guitar playing the main tune with a bass guitar holding the root notes in the background. The rhythmic structure is composed of acoustic sounding drums and percussion playing a syncopated beat. There is a feeling of hope in this piece. This piece could be used in the soundtrack of an inspiring movie/TV show. It could also be played at sports venues. | 2012-12-22T22:49:17Z | Amal Lad | Song from the 2012 film "Life of Pi", directed by award winning director Ang Lee. Based on novel written by Yann Martel of same title. Original music composed by Mychael Danna Original singer on OST - Bombay Jayashri Starring - Suraj Sharma, Irrfan Khan, Tabu, Adil Hussain, Gerard Depardieu, Rafe Spall Thanks for Listening! Ambika Jois (Vocals) http://www.twitter.com/AmbikaJois http://www.facebook.com/ambikajois.music http://www.youtube.com/ambikajois Amal Lad (Music) http://www.amal-lad.com http://www.twitter.com/AmalLadMusic http://www.soundcloud.com/Amal-Lad http://www.facebook.com/Amal.Lad.Music ***FREE Download*** at: http://soundcloud.com/amal-lad/pis-lullaby | ["Humming", "Music", "Inside, small room"] | ["movie music", "female vocal", "melodic singing", "acoustic guitar", "bass guitar", "drums", "percussion", "relaxing", "hopeful", "indian"] | 9 | z2kTJ6pQ4Uo | 5453 |
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;