musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-11-01 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- amateur recording 2
- low quality 2
- mono 2
- noisy 2
- abrupt end 1
- acoustic guitar 1
- amateur 1
- ambient background sounds 1
- amplified guitar 1
- boomy 1
- chord progression 1
- chords 1
- distorted 1
- electric guitar 1
- home recording 1
- home video 1
- instrumental 1
- keyboard harmony 1
- live performance 1
- loud 1
- loud feedback 1
- low frequencies 1
- male singer 1
- medium tempo 1
- melodic 1
- of static 1
- paino tutorial 1
- passionate background male vocal 1
- passionate male vocal 1
- people talking 1
- phone recording 1
- repetitive didgeridoo melody 1
- sharp 1
- simple melody 1
- slow tempo 1
- sonic power 1
- soulful 1
- static 1
- string instrument 1
- subdued vocals 1
- sustained accordion melody 1
- tinny percussive elements 1
- traditional 1
- vibrations 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Travel digeridoo - it's spiral !! | The low quality recording features a repetitive didgeridoo melody. The recording is noisy and in mono, since it was probably recorded with a phone, and it sounds really low in frequency. | 2010-11-01T15:42:25Z | Sound For Health / Jonny Cope | New travel didgeridoo, hand-carved wood and great sound! http://www.soundforhealth.com/collections/didgeridoos/products/travel-didgeridoo-fantastic-sound-hand-carved-plain-wood-spiral | ["Didgeridoo", "Music"] | ["repetitive didgeridoo melody", "low frequencies", "noisy", "low quality", "phone recording", "mono"] | 4 | NPXZIqxKvXA | 2335 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Renuevame Marcos Witt - Tutorial Piano Carlos | A male vocalist sings a soft melody in a foreign language. The tempo is slow with a piano harmony . The vocals are soft and subdued with ambient background sounds. The song is simple, mellow , melancholic and soft. This song is soft pop. | 2010-11-01T20:58:01Z | CarlosMotiff | https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA cualquier donacion a este ministerio sera un abendicion ...y juntos podamos seguir con esta gran labor de seguir formando muchos mas musicos para el servicio de su obra https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA | ["Electric piano", "Keyboard (musical)", "Piano"] | ["male singer", "slow tempo", "keyboard harmony", "subdued vocals", "ambient background sounds", "simple melody", "home recording", "amateur recording", "paino tutorial"] | 7 | gkB4KBHBV9g | 4051 | |
Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi | The low quality recording features a live performance of a traditional song and it consists of passionate male vocal, alongside passionate background male vocal singing over sustained accordion melody and some tinny percussive elements. Even though it is a bit distorted, mono and noisy, it still sounds soulful. | 2010-11-01T13:24:25Z | Zee Marathi | Satypal Maharaj Kirtan | सत्यपाल महाराज कीर्तन | Zee Marathi Awards 2010 | Zee Marathi Free Subscription click here : http://bit.ly/SubscribeZeeMarathi Get notified about our Latest update by Clicking the Bell Icon 🔔 Award Shows Paid Subscription #Zee5 click here: https://bit.ly/32gxIJ4 To #Free #Download ZEE5 #Mobile app click the link below Playstore: http://bit.ly/Zee5PlayStore iTunes: http://bit.ly/Zee5ITunes Connect with Zee Marathi on Social Media Facebook - http://bit.ly/ZeeMarathiFb Instagram - http://bit.ly/ZeeMarathiInsta Twitter - http://bit.ly/ZeeMarathiTwitter Connect with Zee5 on Social Media Facebook : http://bit.ly/Zee5MarathiFB Instagram : http://bit.ly/Zee5MarathiInsta Twitter : http://bit.ly/Zee5MarathiTwitter | ["Carnatic music", "Music"] | ["traditional", "live performance", "passionate male vocal", "sustained accordion melody", "low quality", "tinny percussive elements", "passionate background male vocal", "noisy", "mono", "distorted", "soulful"] | 4 | pzm90xLX9HM | 4747 |
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;