musiccaps_details (view)
6 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "male voice singing", musiccaps_aspects contains "medium tempo", musiccaps_author = 6 and musiccaps_names contains "Music"
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 Haunted - Pourquoi (60's Garage Punk) | A e-guitar takes the lead melody along with the hammond organ. The drums and the bass are providing a rock groove in the background. Another e-guitar is playing along with the bass on the lower notes, it's highly distorted and has some overdrive on it. The male singer streams and sings. His voice is full of reverb and delay. The whole recording is of poor quality. This song may be playing at an old bar. | 2010-10-05T23:32:54Z | heavenlyblueorange | The Haunted - Pourquoi (cover of Music Machine's Talk Talk in French) Montreal, Canada | ["Swing music", "Music", "Punk rock", "Ska", "Song"] | ["indirock", "hammond organ", "e-guitars", "male voice singing", "acoustic drums", "amateur recording", "medium tempo"] | 6 | CRDDdjDinYc | 1364 | |
mtx jackhammer bass | This recording is of very poor audio-quality. The sub bass is strongly over-driving the recorder's speaker. You can also hear a digital drum and a male voice singing in the mid to high range. This song may be playing in a club. | 2010-03-28T16:24:34Z | pease5921 | holy cow this system hits so hard and to think i only have 320 into her it hits crazy hard i love it so much and i plan to dj with it soon please leave a comment and subscribe.oh and hay the mtx thing is just a joke to kinda discrib the bass so dont get bent out of shap. | ["Music", "Radio"] | ["r&b", "sub bass", "male voice singing", "mid to high range", "digital drums", "amateur recording", "medium tempo"] | 6 | TPdqEmS1Dr0 | 2836 | |
Dans un coin le sapin | Someone is playing an acoustic guitar while a male voice in the mid range is singing accompanied by kids singing with him. This is an amateur recording. This song may be playing live in a school during music class. | 2013-12-21T06:09:35Z | Classe maternelle | ["Country", "Guitar", "Acoustic guitar", "Music", "Strum", "Plucked string instrument"] | ["kids song", "acoustic guitar", "male voice singing", "kids singing", "medium tempo", "amateur recording"] | 6 | dqJSTTS7HTY | 3816 | ||
Abrish Zegeyt - Idmaeyaen Bemulu | This song contains a male voice singing in the midrange while percussion instruments such a triangle and drums are playing a rhythm along with an e-bass. A baritone saxophone is playing a melody and someone is strumming chords and a melody on an acoustic guitar. This is an amateur recording. You can hear a high frequency tone from the recording and the sound is lagging. This song may be playing on the radio in a small village. | 2007-10-31T17:13:22Z | ahnd | ethiopian music | ["Music of Africa", "Music"] | ["pop", "amateur recording", "lagging video", "male voice singing", "mid range", "e-bass", "acoustic guitar", "saxophone", "drums", "medium tempo"] | 6 | pzpg2-jYu6k | 4748 | |
Перезимник - Нехай (premix static tv noise video) | This song starts with a lot of high pitched noise that is arpeggiated. Then a male voice starts singing in the mid-range along to a synth bass, pad and pluck sounds. This song may be playing recorded music at home. | 2016-01-11T16:34:27Z | СИНТЕТИКА | site: http://perezimnik.com/ facebook: http://fb.com/perezimnik instagram: http://instagram.com/perezimnik | ["Music", "Synthesizer"] | ["synth/pop", "noise", "arpeggios", "male voice singing", "synth bass", "synth pad", "medium tempo", "amateur recording"] | 6 | rccs9c1gteQ | 4889 | |
Marco Guazzone - Alarm Clock (Live on the street) | someone is playing a digital piano composition while a male voice is singing loudly a melody with long notes. In the background birds chirping and other noises can be heard. This is an amateur recording. This song may be playing in a live performance. | 2009-09-24T16:37:23Z | Marco Guazzone | -------Alarm Clock------- Wake up, its morning Alarm clock is ringing Lets get out off bed Breakfast is ready I made fresh orange juice Youre still half asleep I keep on calling you And your eyes Your eyes Opening one at a time Then they look at me Asking for just five minutes more The alarm clock is ringing for us too ---Music & Lyrics by Marco Guazzone--- SEGUI MARCO GUAZZONE: ►https://www.marcoguazzone.com ►https://www.instagram.com/guazzonemarco ►https://www.facebook.com/marcoguazzone ►https://www.tiktok.com/@guazzonemarco | ["New-age music", "Music"] | ["singer-songwriter", "digital piano", "male voice singing", "environmental noises", "medium tempo", "soothing", "emotional", "amateur recording"] | 6 | zUaZGKZIKic | 5483 |
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;