musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "shimmering bells melody" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- passionate · 3 ✖
- shimmering bells melody · 3 ✖
- low quality 2
- mellow 2
- soft 2
- acoustic guitar melody 1
- euphoric 1
- groovy bass 1
- groovy piano melody 1
- jazz 1
- mixed harmonizing choir 1
- noisy 1
- passionate female vocal 1
- punchy snare 1
- saxophone solo melody 1
- shimmering hi hats 1
- simple bass 1
- simple hi hats 1
- soft kick hits 1
- soulful 1
- wide harmonizing background vocals 1
musiccaps_names (array) 7 ✖
- Music 2
- Chant 1
- Choir 1
- Christian music 1
- Harmonica 1
- Song 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blessed Relief - Frank Zappa | The Jazz song features a saxophone solo melody playing over shimmering hi hats, groovy bass and shimmering bells melody. It sounds passionate, soft, mellow and soulful. | 2007-09-16T15:33:59Z | zemoraes000 | A Tribute to Frank Zappa - Blessed Relief, one of the best songs composed by him. I took the video from "trance fusion - Chunga's Revenge" (author unknown). Awsome!!! see also: http://br.youtube.com/watch?v=smSfnpCZMeI hehehe | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz", "groovy bass", "shimmering bells melody", "saxophone solo melody", "shimmering hi hats", "mellow", "soft", "passionate", "soulful"] | 4 | sSavMIH-e-w | 4951 | |
Rhythm of Life - GMEA Honor Chorus | The low quality recording features a mixed harmonizing vocals singing over shimmering bells and groovy piano melody. It sounds passionate and euphoric. The recording is noisy. | 2008-02-10T22:21:33Z | ElleForrest | Rhythm of life preformed by the Georgia 11/12 Mixed 6 Honors Chorus. No Copyright intended | ["Chant", "Music", "Song", "Choir"] | ["low quality", "noisy", "shimmering bells melody", "groovy piano melody", "mixed harmonizing choir", "passionate", "euphoric"] | 4 | G-5UYGccne4 | 1683 | |
Disney Princess | The low quality recording features a wide harmonizing background vocals singing alongside passionate female lead vocal, over punchy snare hits, shimmering bells melody, simple hi hats, soft kick hits, simple bass and acoustic guitar melody. It sounds passionate, mellow and soft. | 2009-01-02T18:58:44Z | Renie42 | I like Disney´s characters so I decided to make this video about Ariel, Aurora, Belle, Cinderella, Jasmine, Mulan, Pocahontas and Snow White. | ["Christian music", "Music"] | ["low quality", "wide harmonizing background vocals", "passionate female vocal", "punchy snare", "shimmering bells melody", "simple hi hats", "soft kick hits", "simple bass", "acoustic guitar melody", "passionate", "mellow", "soft"] | 4 | NLQts9t7d8k | 2332 |
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;