musiccaps_details (view)
2 rows where musiccaps_aspects contains "fruity male vocal" and musiccaps_aspects contains "reverberant" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- fruity male vocal · 2 ✖
- low quality 2
- noisy 2
- reverberant · 2 ✖
- classical 1
- coughing 1
- emotional 1
- humming 1
- live performance 1
- muffled 1
- opera 1
- passionate 1
- piano melody 1
- telephone ring 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cantor Helfgot @ Lincoln Center | The low quality recording features a live performance of a classical song that consists of a fruity male opera singer over a piano melody. In the background there are coughing and telephone ring sounds. The recording is noisy, muffled and it sounds emotional and passionate. | 2008-01-02T17:40:24Z | yessory | Helfgot sings Vlirusholayim Ircha, Avery Fisher Hall, Dec. 02, 2007. At the concert while this selection was sung, rare footage of how Moshe koussevitsky masterfully sang this selection were shown. The recorded audio appears with a slideshow of pictures, from previous Helfgot Performances. | ["Singing", "Mantra", "Music", "Opera", "Orchestra", "Classical music"] | ["low quality", "live performance", "reverberant", "noisy", "muffled", "coughing", "classical", "opera", "fruity male vocal", "piano melody", "emotional", "passionate", "telephone ring"] | 4 | PFa1XVCgPgM | 2522 | |
The Wolf of Wall Street: Chest beat Chant Song (Full) | The low quality recording features a fruity male vocal humming. In the first half of the loop, there is a lot of reverb on it, which progressively disappears. The recording is a bit noisy. | 2014-01-10T22:28:38Z | Jordan Wolf | Epic, motivating and uplifting chanting song from the movie: The Wolf of Wall Street! If you haven't watched the movie, go watch it! | ["Chant", "Music"] | ["fruity male vocal", "humming", "reverberant", "noisy", "low quality"] | 4 | Kqo7am5oq0U | 2124 |
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;