musiccaps_details (view)
6 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 85 ✖
- amateur recording · 6 ✖
- instrumental · 6 ✖
- medium tempo · 6 ✖
- home video 3
- people talking 3
- amplified guitar 2
- electric guitar 2
- electronic music 2
- loud 2
- muddled audio 2
- muffled audio 2
- sharp 2
- white noise 2
- abrupt end 1
- accompanying music 1
- acoustic guitar 1
- aerophone 1
- amateur 1
- ambient sounds 1
- background noises 1
- background score 1
- besame mucho 1
- birds chirping 1
- boomy 1
- breeze 1
- car engine 1
- carousel 1
- carousel music 1
- children electronic toys 1
- children’s game music 1
- children’s music 1
- children’s toy music 1
- chord progression 1
- chords 1
- congas beat 1
- dissonant 1
- elctronic music 1
- engine sound 1
- engine whirring 1
- enthusiastic 1
- free reed aerophone 1
- free reed instrument 1
- french harp 1
- hard rock 1
- harmonica 1
- high notes 1
- home recording 1
- ice-cream cart 1
- incoherent music 1
- inferior audio recording 1
- intense 1
- latin songs 1
- lively accompaniment music 1
- loud feedback 1
- low quality audio 1
- melodic 1
- melodious 1
- merry-go round 1
- metal 1
- of static 1
- outdoors 1
- people talking in the background 1
- people’s voices 1
- popular spanish songs 1
- powerful 1
- rock 1
- rock instrumental 1
- sonic power 1
- sonic power’ 1
- spanish melody 1
- spirited 1
- static 1
- steel drum 1
- steel pan 1
- string instrument 1
- synthesiser arrangements 1
- thudding 1
- vehement 1
- vibrations 1
- video game music 1
- whirring 1
- whooshing sound 1
- wind instrument 1
- xylophone melody 1
- youthful 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Harmonica - Besame Mucho | This music is a soulful instrumental. The tempo is medium with a harmonica melody with a background track which is muffled. The melody is of a popular Spanish Classic song. This music is a Harmonica instrumental of Besame Mucho. | 2006-11-06T21:32:19Z | alliax | CLICK http://www.ALLIAX.net Besame Mucho played on a chromatic harmonica. If you play the harmonica and have videos on YouTube then join the Harmonica Group: http://www.youtube.com/group/harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "medium tempo", "harmonica", "french harp", "free reed instrument", "wind instrument", "aerophone", "free reed aerophone", "lively accompaniment music", "besame mucho", "popular spanish songs", "latin songs", "spanish melody", "background score", "muffled audio", "amateur recording", "congas beat"] | 7 | JtLNRHVGQuw | 2043 | |
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 | |
Trinidad Music - Youth plays steelpan - Indian Trail Church | This music is instrumental. The tempo is medium with a melodic steel pan harmony. The audio quality however is inferior and amateur,so the music is muddled. There are ambient sounds of breeze and people talking , indicating that this is a live performance. | 2009-06-18T20:47:10Z | Home and Happy. | A youth pannist plays at Indian Trails Open Bible Church. Steelpans (also known as steeldrums or pans, and sometimes collectively with musicians as a steelband) is a musical instrument and a form of music originating from Trinidad. Steelpan musicians are called pannists. | ["Music", "Steelpan"] | ["white noise", "instrumental", "medium tempo", "steel pan", "amateur recording", "muddled audio", "steel drum", "inferior audio recording", "incoherent music", "melodious", "ambient sounds", "people talking", "breeze"] | 7 | _ALGXHquYkM | 3450 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Curt Mitchell Chop Shop Solo Rockoryon Cover | This music is an Electric Guitar instrumental. The tempo is fast with a dissonant background score . There is the sound of people talking in the background. The music is superimposed on a track which doesn’t seem to be in sync. The lead however is powerful, loud, intense and emphatic. This is a Rock Instrumental. | 2009-08-10T15:54:08Z | OR1ON Orion Meshorer | (RockOryon Cover - when I was 12 years old) This is a great solo from Curt Mitchell Chop Shop. working hard on this solo, has improved my playing tremendously. it still needs more refinement but I want to use this occasion and thank Dear Curt Mitchell for his great teachings. | ["Tapping (guitar technique)", "Electric guitar", "Music"] | ["instrumental", "electric guitar", "people talking in the background", "home recording", "amateur recording", "rock instrumental", "intense", "loud", "amplified guitar", "youthful", "enthusiastic", "vehement", "spirited", "sonic power’", "medium tempo", "background noises", "accompanying music", "people talking", "loud", "powerful", "intense", "rock", "hard rock", "metal", "dissonant"] | 7 | hBQFoDI3NMI | 4082 | |
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN | This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. | 2010-10-29T21:53:59Z | 6877mercedes Ebay | City of Tampa Florida POLICE Diecast Car with Lights and SIREN | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] | 7 | uwPeQy7ZtGo | 5143 |
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;