musiccaps_details (view)
1 row where musiccaps_aspects contains "brass section", musiccaps_aspects contains "low quality" and musiccaps_names contains "Yodeling"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jodłowanie w Maurzycach k. Łowicza. 2003 r. | The low quality recording features a mono recording located only in the right channel of the stereo image. It consists of at least brass section melody, shimmering cymbals and melodic female vocals. There are some crowd chattering noises too, but it sounds fun and happy. | 2009-03-18T20:56:59Z | Łowiczak123 | Występ kapeli po zakończeniu przemówienia prezydenta Kwaśniewskiego.Sorry za złą jakość dźwięku-mono. | ["Yodeling", "Music", "Music of Latin America"] | ["low quality", "mono", "noisy", "brass section", "melodic female vocal", "happy", "fun", "crowd chattering"] | 4 | _n9boKzVRhs | 3491 |
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;