musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_author = 9 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- amateur recording · 3 ✖
- afro cuban dance 1
- bongo 1
- child female voice 1
- conga 1
- dj performance 1
- electronic drums 1
- instructive speaking 1
- keyboard lesson 1
- lesson recording 1
- lively 1
- male vocal sample 1
- male vocals 1
- male voice 1
- percussion 1
- scratching 1
- street performance 1
- timbale 1
- turntable 1
- urban sound 1
- vibrant 1
musiccaps_names (array) 12 ✖
- Music 3
- Speech · 3 ✖
- Blues 1
- Dance music 1
- Electronic tuner 1
- Inside, small room 1
- Keyboard (musical) 1
- Musical instrument 1
- Piano 1
- Scratch 1
- Scratching (performance technique) 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afro Cuban Rumba music and dance -- havana, cuba | This is an amateur recording of an Afro-cuban dance music performance. There are male vocals singing joyfully. There is a percussion orchestra made up of diverse elements such as the conga, the bongo and the timbales are playing in the rhythmic background. The atmosphere is lively and vibrant. Although the audio quality is not that great, this piece can still be sampled for use in beat-making. | 2009-03-26T00:28:54Z | mathmuse | live at the palenque -- vedado, havana, cuba | ["Blues", "Traditional music", "Music", "Speech", "Dance music"] | ["afro cuban dance", "amateur recording", "street performance", "male vocals", "percussion", "conga", "bongo", "timbale", "lively", "vibrant"] | 9 | 07mS0mSTDjY | 124 | |
How to Play Butterflies & Hurricanes - Part 1 (LearnMUSE) | This is the recording of a keyboard lesson. There is a male instructor that plays the notes on the keyboard first and then describes the placement of the fingers and the notes that are being played. The audio quality of the lesson is not that great. | 2008-03-10T19:35:06Z | LearnMUSE | Band: Muse Album: Absolution Song: Butterflies & Hurricanes -- Part 1 of 3 -- This is a tutorial for Butterflies and Hurricanes by Muse on the piano by Samuel Deacon. Sorry about the camera positioning, its very difficult to fit everything in, especially on this song. If my hands go off the screen, just try to listen to the notes I'm telling you to play. I've made this with beginners in mind, so if you're a seasoned player you can ignore me talking about notes of chords and stuff. Remember, don't give up, a lot of the song is repeated so if you can get one part down the rest becomes easy. Don't give up on the tricky bits (the solo lol), it takes time before it all becomes smooth. It's a great song to play, really not THAT difficult and a great for showing off! | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Speech", "Electronic tuner", "Inside, small room"] | ["lesson recording", "amateur recording", "keyboard lesson", "male voice", "instructive speaking"] | 9 | 2pTnwe3DzCs | 408 | |
Next Generation Dj's | This is an amateur recording of a little girl performing on a turntable. The girl can be heard talking to the person behind the camera. There is a repeating male vocal sample and an electronic drum beat in the piece that is playing. There is an urban atmosphere to the track. | 2007-09-25T18:48:01Z | Masta Hanksta | Time coded vinyl $20.00 bucks. Needles Stanton's $30 bucks a pair. Numark Mixer $99.99 Watching my daughters scratch priceless. | ["Scratching (performance technique)", "Music", "Scratch", "Speech"] | ["amateur recording", "child female voice", "dj performance", "male vocal sample", "turntable", "scratching", "electronic drums", "urban sound"] | 9 | DQzg3cZeYSw | 1476 |
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;