musiccaps_details (view)
3 rows where musiccaps_aspects contains "speaking" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- speaking · 3 ✖
- audio fuzz 1
- chanting male background vocal 1
- complex fast drum beat 1
- conga 1
- dance song 1
- differing tones 1
- funky 1
- live recording 1
- low audio quality 1
- random percussion 1
- raspy male voice 1
- screaming female background vocal 1
- tutorial 1
- ukulele 1
- upbeat 1
musiccaps_names (array) 10 ✖
- Music 2
- Disco 1
- Drum 1
- Guitar 1
- Musical instrument 1
- Percussion 1
- Plucked string instrument 1
- Speech 1
- Tabla 1
- Ukulele 1
youtube_published (date) 3 ✖
- 2008-06-23 1
- 2010-06-25 1
- 2011-10-11 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rick james SLAP | The clip has no melodic instruments. It is mainly built of a complex persuasive rhythm played on the drums, and a repeated phrase by a male speaker in a raspy vocal. In the background, we have a soulful male voice chanting the same phrase repeatedly, and a female screaming voice once roughly every two bars. | 2008-06-23T18:28:43Z | mohem10 | yeeeeaaaaaaaaaa | ["Disco", "Music"] | ["raspy male voice", "speaking", "dance song", "upbeat", "funky", "complex fast drum beat", "chanting male background vocal", "screaming female background vocal"] | 3 | IhNPDueFVSo | 1929 | |
Jammin - Bob Marley | This is a live recording which features strums of a single chord on a ukulele. At points in the clip, there is the voice of someone who is speaking. The recording is of a low-quality, and thus the audio has a slight fuzzy sound the whole way through. | 2010-06-25T07:28:02Z | Seto Makura | skip tutorial to 2:00 | ["Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["live recording", "low audio quality", "ukulele", "speaking", "audio fuzz"] | 3 | oARFeTnImOg | 4607 | |
Conga Lessons with Jerry Rivera | This is a tutorial on how to use the conga percussion instrument. The American tutor narrates his actions as he plays. There are two tones - the open tone is lower and the closed tone is higher pitched. | 2011-10-11T17:07:31Z | trueseven | Conga Lesson 1 with Jerry Rivera | ["Tabla", "Drum", "Percussion"] | ["conga", "tutorial", "speaking", "random percussion", "differing tones"] | 3 | xXRGgPVnkqk | 5338 |
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;