musiccaps_details (view)
2 rows where musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "relaxing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- melodic singing · 2 ✖
- relaxing · 2 ✖
- acoustic guitar 1
- bass guitar 1
- calming 1
- drums 1
- easygoing 1
- female vocal 1
- gentle 1
- hawaiian folk 1
- hopeful 1
- indian 1
- male vocal 1
- movie music 1
- peaceful 1
- percussion 1
- ukulele 1
- world music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Israel kamakawiwo'ole somewhere over the rainbow | This is a Hawaiian folk music rendition of a jazz music piece. There is a male vocalist singing melodically in the lead. The simple tune is being played by a mellow sounding ukulele. There is a peaceful and relaxing atmosphere. This piece could be playing in the background of a coffee shop. It could also be included in the soundtrack of a feelgood movie/TV series. Another good use would be in the background of wholesome social media content. | 2008-03-11T15:20:37Z | Lasse Jespersen | this is about the danish soldiers in the schleswig war, and of course Israe Kamakawiwo'ole. I have choosen this song because when you are a soldier and you face an enemy that 3 times as big as yours ( as it was in the Schleswig wars), then there might be something over the rainbow that's better than what you are facing right now. | ["Folk music", "Music", "Middle Eastern music"] | ["hawaiian folk", "world music", "male vocal", "melodic singing", "ukulele", "gentle", "peaceful", "calming", "relaxing", "easygoing"] | 9 | p2jnUySmuvA | 4682 | |
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;