musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "enthusiastic" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- enthusiastic · 3 ✖
- instrumental 2
- loud 2
- playful 2
- aerophone 1
- ambient crowd noise 1
- amplified harmonica 1
- animated 1
- bad audio quality 1
- bagpipes playing 1
- blues harp 1
- celtic music 1
- cheerful 1
- crowds cheering 1
- crowds clapping 1
- drum playing percussively 1
- exciting 1
- exciting solo 1
- fast tempo 1
- female bagpiper 1
- folk music 1
- free reed instrument 1
- french harp 1
- groovy bass 1
- happy 1
- harmonica lesson 1
- harmonica melody 1
- harmonica solo 1
- instrumental music 1
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Julie Fowlis playing Bagpipe - Live | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | 2009-09-05T09:48:05Z | smartotrams | Live at Lüdenscheid, Germany 4th Sept 2009 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | 1 | 0NTzOtVmoiU | 154 | |
Electret Condenser Microphone Wiring | This music is an enthusiastic instrumental. The tempo is fast with an amplified harmonica solo. The music is lively, animated, happy, cheerful, energetic, enthusiastic and peppy. | 2013-08-14T13:45:16Z | John Salmon | Please note I have drawn the capacitor with the wrong polarity marker. The + side should be connected to the resistor before the battery. Watch my other video for a more up to date video using an electret mic. http://youtu.be/B_BDtYSDQ9g | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "fast tempo", "harmonica solo", "loud", "playful", "energetic", "peppy", "happy", "animated", "enthusiastic", "cheerful", "amplified harmonica", "harmonica lesson", "tutorial"] | 7 | FYFapDVOFHg | 1648 | |
Harmonica: Tongue Block vs. Pucker | This music is a lively harmonica instrumental. The tempo is medium with a spirited melody. The music is lively, clear, energetic, vibrant and breezy with a male voice at the end of the audio clip. This is probably a Harmonica tutorial. | 2006-11-05T01:45:40Z | 12gagedan | This is my 2cents (or 5 minutes) added to the old debate of TB vs. Pucker embuochure when playing the harmonica. My take is very "end justifies the means" and don't limit yourself or worry about myths. (I believed for a very long time that bending and TB was impossible) The bottom line is: achieve the sound you want by working towards good tone with either approach. Apologies to all U-Blockers, as I'm not very good with that. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "medium tempo", "harmonica melody", "male voice speaking", "vibrant", "energetic", "enthusiastic", "playful", "loud", "lucid", "mouth organ", "free reed instrument", "wind instrument", "folk music", "aerophone", "french harp", "blues harp", "tuneful", "melodious"] | 7 | _94ra2KoZGo | 3447 |
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;