musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "reverberant" and musiccaps_names contains "Shofar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| SPECIAL OFFER RAMS HORN SHOFAR. EXCLUSIVE www.theshofarman.com item. A+ SOUND | The low quality recording features a sustained horn tone. There is a subtle inhale sound and it sounds reverberant as if it was recorded in a room. The recording is noisy and in mono. | 2011-05-05T19:14:57Z | James Barbarossa | This item is the Exclusive http://www.theshofarman.com/cartramspecialoffer.htm Special offer Rams Horn Shofar. This item has great sound and is being sold for a limited time as a Special Offer Package! Please call or email us for more details or to have a few sounded. | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "sustained horn tone", "noisy", "mono", "reverberant", "inhale"] | 4 | BhYaXU1MVcQ | 1277 | |
| MUSHY /// Demonstration of Shofar | The low quality recording features a flat male vocal talking in-between resonating shofar melody. It sounds like a traditional instrument and it is reverberant, as it was probably recorded in a medium size room. | 2011-09-30T01:08:48Z | Vulf | The 4 four traditional shofar blasts. | ["Wind instrument, woodwind instrument", "Shofar"] | ["flat male vocal", "resonating shofar melody", "noisy", "reverberant", "traditional", "low quality"] | 4 | l21xSYRR_Xc | 4371 | |
| The trumpet is for all generations. Shofar sounds. | The low quality recording features a shofar repetitive melody. The recording is in mono and so noisy that it slightly distorts the audio. It sounds soulful and reverberant. | 2014-11-01T02:58:57Z | Watchmen-Nehemiah 4:20 | Trumpet being sounded to make a new song. The shofar is a sound for young and old alike. May the sound of the trumpet stir up your spirit to follow and hearken to the voice of the almighty. Yeshua / Jesus IS Rosh vaSof (rosh ve-SOHF) Beginning and the Ending -Rev. 1:8 see http://www.hebrew4christians.com/Names_of_G-d/Yeshua/yeshua.html When ye blow an alarm, then the camps that lie on the east parts shall go forward. When ye blow an alarm the second time, then the camps that lie on the south side shall take their journey: they shall blow an alarm for their journeys. But when the congregation is to be gathered together, ye shall blow, but ye shall not sound an alarm. And the sons of Aaron, the priests, shall blow with the trumpets; and they shall be to you for an ordinance for ever throughout your generations. And if ye go to war in your land against the enemy that oppresseth you, then ye shall blow an alarm with the trumpets; and ye shall be remembered before the Lord your God, and ye shall be saved from your enemies. Also in the day of your gladness, and in your solemn days, and in the beginnings of your months, ye shall blow with the trumpets over your burnt offerings, and over the sacrifices of your peace offerings; that they may be to you for a memorial before your God: I am the Lord your God. -Numbers 10:5-10 Here are 2 links to hear some messages from my beloved Pastor Diego Mesa. These messages are aimed at reaching those who have not yet come to a saving faith in Jesus / Yahushua HaMashiach and to bring believers into deeper relationship and transformation in Jesus. I am grateful to belong to a church where the Pastor loves Jesus above all else and where God's Word goes forth with power. Here are those links; "Real" with Pastor Diego Mesa http://www.realwithdiegomesa.org/ and the website of Abundant Living Family Church http://www.abundantfamily.org/ where services are live streamed on Saturday, Sunday and Wednesday night. The Wednesday night service is a great blessing for those who see… | ["Wind instrument, woodwind instrument", "Shofar"] | ["low quality", "mono", "noisy", "distorted", "shofar repetitive melody", "soulful", "reverberant"] | 4 | st92BzeUzFU | 4984 |
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;