musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "phone ringing" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- instrumental · 2 ✖
- phone ringing · 2 ✖
- animated 1
- announcement 1
- beeping 1
- boisterous 1
- buddhism 1
- busy 1
- buzzing 1
- celebr 1
- celebration 1
- children cheering in unison 1
- clicking sound 1
- conch shell sound 1
- conical bore 1
- electronic music 1
- energetic 1
- enthusiastic 1
- exaltation 1
- fast tempo 1
- gunshots 1
- hinduism 1
- home video 1
- loud 1
- male voice talking 1
- meditation 1
- muffled audio 1
- noisy 1
- phone dial tone 1
- puja 1
- reverence 1
- sacred 1
- scratching sound 1
- shell trumpet 1
- slow tempo 1
- spirited 1
- synthesiser arrangement 1
- upbeat 1
- victory 1
- video game music 1
- whirring 1
- whirring sounds 1
- wind instrument 1
- worship 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disney Dancing and Singing Donald Duck (Solo) | This song is an instrumental. The tempo is fast with electronic instrumentation and sounds. There is a vigorous keyboard harmony along with sounds of gunshots, clicking, whirring, beeping, phone ring and scratching. The music is busy, animated and boisterous. The audio quality is inferior and muddled, making it difficult to hear the finer elements. | 2009-02-28T11:39:55Z | xiaohwee85 | 3 x great songs from Daffy 3 x AA battery operated | ["Music", "Synthetic singing"] | ["instrumental", "fast tempo", "loud", "busy", "boisterous", "beeping", "whirring", "noisy", "scratching sound", "video game music", "upbeat", "energetic", "enthusiastic", "electronic music", "clicking sound", "animated", "synthesiser arrangement", "muffled audio", "home video", "whirring sounds", "gunshots", "buzzing", "phone ringing", "spirited", "energetic"] | 7 | XjoRxeEyjz4 | 3217 | |
Touzani & Maher (PSV) | This music is instrumental . The tempo is medium fast with the sound of a conch shell or shell trumpet playing a victorious drone. The music is loud, clear, deep and is often used in religious and sacred rituals in Hinduism and Buddhism. There are sounds of phone dealing and ringing. This music is superimposed on the sound of male talking and children cheering in unison. | 2014-09-25T17:56:01Z | TOUZANI TV | Touzani & Maher (PSV) ► Bedankt voor het abonneren! - https://bit.ly/2PkZoGC 🔔 Belletje aan is zo gedaan. Mis geen 1 video! 🎒 Touzani Shop - https://www.touzani.shop/kids ►Meld je aan voor de Touzani Training - https://touzanitraining.com/ 👨🏻💻 Bekijk de nieuwste video's! - https://bit.ly/2JtNu9H Volg mij op Instagram 🙋🏻♂️ http://Instagram.com/TouzaniTV 🙋🏻♂️ https://www.instagram.com/touzani.sho... 🙋🏻♂️ https://www.instagram.com/touzanischo... TouzaniTV bestaat uit verschillende voetbal video's! Video's met de beste voetballers ter wereld, maar ook met de grootste talenten.Wij gaan ook langs verschillende voetbalclubs! Touzani gaat ook challenges aan die door de fans worden bedacht! Wij proberen ook altijd een prijs weg te geven aan onze trouwe kijkers. Dat kan een shirt of voetbalschoen zijn van een profvoetballer of Touzani trainingspakken. Heel veel kijkplezier en welkom bij TOUZANI TV ! Business of Media contact: info@touzanifc.com Alle video's worden geproduceerd door TouzaniFC B.V. http://www.touzanifc.com/ Touzani heeft ook een eigen stichting https://www.touzanifoundation.nl/ Adam Maher(PSV) was most talented player in 2012. Watch the report with Soufiane Touzani on a brand new channel, here on you tube. CRUYFF COURT TV | ["Wind instrument, woodwind instrument", "Shofar"] | ["instrumental", "slow tempo", "phone dial tone", "celebration", "reverence", "puja", "meditation", "phone ringing", "conch shell sound", "celebr", "victory", "announcement", "shell trumpet", "wind instrument", "conical bore", "sacred", "hinduism", "buddhism", "exaltation", "worship", "male voice talking", "children cheering in unison"] | 7 | nn2TnOGCHDI | 4575 |
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;