musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-10-14 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- ambient room noise 1
- beep tones 1
- buzzy 1
- digital drums 1
- distorted 1
- doorsteps 1
- drawer closing 1
- flat male vocal 1
- flute 1
- foreign language 1
- home improvement video 1
- home video 1
- instrumental 1
- live performance 1
- low quality 1
- male singer 1
- male voice 1
- medium tempo 1
- moderate tempo 1
- noise 1
- noisy 1
- non musical tones 1
- passionate singing 1
- programmed percussion 1
- quirky sounds 1
- rap song 1
- repetitive plucked synth lick 1
- simple bass 1
- slow to medium tempo 1
- sustained strings melody 1
- synth bass 1
- synth drone 1
- traditional 1
- tribal/meditative/electro 1
- unimpressive sounds 1
- wind noise 1
- wind sound 1
- wooden percussive elements 1
- woodwinds melody 1
musiccaps_names (array) 9 ✖
- Music 3
- /t/dd00032 1
- Drawer open or close 1
- Hip hop music 1
- Rapping 1
- Reggae 1
- Singing 1
- Sitar 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ganjeromakata PITONG HIBLA MUSiC ViDEO | This rap song features a male voice rapping in a foreign language. This is accompanied by programmed percussion playing a simple beat. The bass plays the root note of the chord in sets of 3 strokes. The same note is played through the song in sets of three. A repetitive plucked synth sound is played in loop. Quirky sounds are heard in the background. This song has a defiant mood. This song can be played in a gangster movie. | 2010-10-14T22:17:31Z | tjfran3 | ["Music", "Rapping", "Reggae", "Hip hop music", "/t/dd00032"] | ["rap song", "foreign language", "male voice", "quirky sounds", "programmed percussion", "moderate tempo", "simple bass", "repetitive plucked synth lick"] | 0 | B1va1NqaA4o | 1196 | ||
Beaded jewelry by Elena E. Pate | This song contains someone playing a melody on a flute panning to the right side of the speakers. A lower synth drone pad is underlining the flute along with more synth pad sounds and wind. Then a soft riser comes in and a digital drum starts playing along to a synth bass sound. This song may be playing in an indie movie. | 2010-10-14T01:52:28Z | ElenaPate | Beautiful beaded jewelry (including embroidered bracelets) made from seed beads, pearls, czech glass beads and semi-precious stones. | ["Theremin"] | ["tribal/meditative/electro", "flute", "synth drone", "digital drums", "synth bass", "wind sound", "slow to medium tempo"] | 6 | gxAyZk01T3k | 4068 | |
Oscar Meble SZUFLADA BLUMOTION Kuchnia na wymiar wzór klasyczny | Ambient sound still in the room with a mild background music playing. A male singer sings a passionate melody with subtle background music. The audio quality is very poor with drawer sliding sound and general noise. | 2010-10-14T10:17:25Z | oscarmeble | Niniejszy film przedstawia zastosowanie systemu Bloumotion firmy Blum. Kuchnia wykonana przez firmę www.oscar-meble.pl, najwyższa jakość i staranność wykonania. | ["Music", "Drawer open or close"] | ["ambient room noise", "instrumental", "male singer", "beep tones", "wind noise", "doorsteps", "noise", "non musical tones", "home improvement video", "unimpressive sounds", "drawer closing", "home video", "passionate singing", "medium tempo"] | 1 | -SWaCArvQug | 48 | |
Jard Seng TAI 1 1/3 ( Shanmusic.tht.in ) | The low quality recording features a live performance of a traditional song that consists of flat male vocal singing over wooden percussive elements, sustained strings melody and woodwinds melody. The recording is very noisy and buzzy. | 2010-10-14T06:25:42Z | shanmusic taisongs | Shanmusic | ["Singing", "Music", "Sitar"] | ["low quality", "live performance", "buzzy", "noisy", "flat male vocal", "wooden percussive elements", "sustained strings melody", "woodwinds melody", "distorted", "traditional"] | 4 | Orge4_UlvNI | 2475 |
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;