musiccaps_details (view)
1 row where musiccaps_aspects contains "shofar horn siren", musiccaps_names contains "Shofar" and "youtube_published" is on date 2012-12-07
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Incredible sound of the Shofar - Played by Nick Duffield - First Time Ever Playing a Shofar | The low quality recording features a shofar horn siren. It is so loud that the audio is distorting. The recording itself is a bit noisy. | 2012-12-07T04:49:48Z | November Delta | Nick plays the Amazing Shofar for the first time ever - Location: Flinders Street, Adelaide South Australia. Watch the people look up in awe at the most remarkable and unusual sound as they go about their business in the city. Shofar is the Hebrew term for a trumpet made from a curved ram's horn. To sound the ram's horn came from the root word "Teruwah" in Hebrew which means clangor of trumpets, acclamation of joy, clamor, rejoicing, high joyful sound, loud noise, wild shout, a battle cry, to announce forcefully or loudly. "Uwah" means to split the ears with sound. | ["Wind instrument, woodwind instrument", "Shofar"] | ["shofar horn siren", "loud", "distorted", "low quality", "noisy"] | 4 | ZUg7rRpFGvA | 3383 |
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;