musiccaps_details (view)
3 rows where musiccaps_aspects contains "mixed harmonizing choir" and musiccaps_author = 4 sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- mixed harmonizing choir · 3 ✖
- low quality 2
- noisy 2
- passionate 2
- brass section melody 1
- classical 1
- crowd clapping 1
- emotional 1
- epic 1
- euphoric 1
- footstep sound 1
- fruity male vocal 1
- groovy piano melody 1
- live performance 1
- mono 1
- organ melody 1
- powerful 1
- shimmering bells melody 1
- soulful 1
- wooden percussion 1
musiccaps_names (array) 11 ✖
- Music 3
- Choir 2
- Opera 2
- /m/05zppz 1
- /t/dd00003 1
- Chant 1
- Classical music 1
- Singing 1
- Song 1
- Soul music 1
- Speech 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Händel Hallelujah from the Messiah - Best-of Classical Music | The Classical song features a mixed harmonizing choir singing over organ melody, brass section melody and wooden percussion. It sounds powerful and epic. | 2010-03-21T19:20:17Z | TheFbiFilesRepeat | The audio is under "Public Domain" The public domain is an intellectual property designation for the range of content that is not owned or controlled by anyone. These materials are public property, and available for anyone to use freely (the "right to copy") for any purpose. ...50 years from creation year or 70 years after his death http://en.wikipedia.org/wiki/Public_domain | ["Music", "Opera", "Classical music", "Soul music"] | ["classical", "mixed harmonizing choir", "organ melody", "brass section melody", "epic", "wooden percussion", "powerful"] | 4 | FcwWl5JBnoU | 1656 | |
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 | |
Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 |
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;