musiccaps_details (view)
3 rows where musiccaps_aspects contains "female vocal", musiccaps_aspects contains "relaxing" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- female vocal · 3 ✖
- relaxing · 3 ✖
- acoustic guitar 2
- bass guitar 2
- calming 2
- airy strings 1
- celtic 1
- drums 1
- folk music 1
- gentle singing 1
- hopeful 1
- indian 1
- keyboard 1
- lullaby 1
- mellow singing 1
- melodic singing 1
- movie music 1
- percussion 1
- piano 1
- sleep-inducing 1
- soothing 1
- synth strings 1
- world 1
musiccaps_names (array) 6 ✖
- Music 3
- Humming 1
- Inside, small room 1
- Lullaby 1
- Music for children 1
- New-age music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rose 2009: Enya,China Rose | This is a world music piece in the style of Celtic folk music. There is a female vocalist singing gently and melodically. There is an airy strings section creating a relaxing atmosphere while the piano plays a mellow arpeggio. The atmosphere is soothing. This piece could be used during the vivid scenery shots of a movie that takes place in the middle of nature. | 2009-12-28T02:27:14Z | Hea Kim | Rose photos at Chicago botanic Garden | ["New-age music", "Music"] | ["folk music", "world", "celtic", "female vocal", "gentle singing", "keyboard", "airy strings", "piano", "relaxing", "calming", "soothing"] | 9 | Ss1bubMNPQE | 2793 | |
Lullaby: Hush Little Baby - Sherri Huffman | This is a lullaby music piece. There is a female vocalist singing gently. The acoustic guitar is playing a mellow tune while the bass guitar accompanies with a simple bass line. There is a synth with a string sound in the background. The atmosphere is calming and sleep-inducing. This piece could be played at nurseries and it could be included in the soundtracks meant to put babies to sleep. | 2008-08-16T03:36:27Z | snicky58 | My daughter's teacher recently had a baby girl. My daughter and I have been making lullaby videos to give as a baby present. Here's one that I made. | ["Music", "Music for children", "Lullaby"] | ["lullaby", "female vocal", "mellow singing", "acoustic guitar", "bass guitar", "synth strings", "calming", "relaxing", "sleep-inducing"] | 9 | YxQzJweGS2c | 3325 | |
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;