musiccaps_details (view)
4 rows where musiccaps_aspects contains "no voices", musiccaps_aspects contains "violins" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- no voices · 4 ✖
- violins · 4 ✖
- low quality recording 2
- moderate tempo 2
- no percussion 2
- amateur recording 1
- banjo 1
- flutes 1
- folk song 1
- hand claps 1
- happy feel 1
- happy mood 1
- horn section 1
- instrumental 1
- lullaby 1
- orchestra music 1
- purring sound 1
- rock song 1
- simple percussion 1
- slow tempo 1
- sounds of crickets 1
- string section 1
- tambourine 1
- timpani percussion 1
musiccaps_names (array) 10 ✖
- Music · 4 ✖
- Banjo 1
- Bowed string instrument 1
- Classical music 1
- Middle Eastern music 1
- Music of Bollywood 1
- Musical instrument 1
- Orchestra 1
- Purr 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 |
---|---|---|---|---|---|---|---|---|---|---|
Scientists make music for cats purrs and meow like sounds in songs make moggies lovingly rub again | This clip features purring sounds as the main sound. This is accompanied by violins playing a lullaby melody in the background. The sounds of crickets chirping are also played in the background. This clip does not contain any voices or any other musical instruments. | 2015-02-27T18:38:28Z | ShoWTV | ["Purr", "Music"] | ["purring sound", "violins", "no percussion", "no voices", "lullaby", "sounds of crickets"] | 0 | 2uagA3ujRtM | 411 | ||
Jonathan Antoine 19 yrs Last Night of Proms Cliffs Pavilion 30 Nov 2014 | This orchestral song features violins playing the main melody along with trumpets. This is accompanied by the bass being played on a cello. The percussion is played on a timpani. There are no voices in this song. This is an amateur recording. This song can be played in a fairytale animation movie. | 2014-12-10T09:41:28Z | morag grant | Jonathan Antoine, Special Guest performer at the Last Night of the Proms in South Cliffs Pavilion, England UK. Connect with Jonathan through his Official Website: http://www.jonathanantoinemusic.com/ Jonathan Antoine albums available on these links: Tenore: http://amzn.to/2oWQNOk & Believe: http://amzn.to/2uPqeJ7 Facebook: https://www.facebook.com/JonathanStavvyAntoine Twitter: https://twitter.com/JonAntoine Christmas Classic single on this link: https://www.youtube.com/watch?v=2qXSzLF7TUg | ["Music", "Orchestra", "Classical music"] | ["orchestra music", "violins", "no voices", "string section", "low quality recording", "timpani percussion", "slow tempo", "horn section"] | 0 | 8jDanS4ZzRc | 939 | |
Classical Gas by Roy Clark Band Banjo Pickin' 1987 Live | This amateur recording features a rock song. The main melody is played on violins. This is accompanied by percussion playing with breaks matching the breaks in the violin parts. At the end, the violins play a sustained note and a banjo starts to play a melody. A tambourine is played on the first count of the second bar after the banjo starts to play. This is an uptempo song and has a happy feel. This instrumental song can be played in a coffee shop. | 2007-06-12T06:30:56Z | NelnetDude | Enjoy! | ["Banjo", "Music", "Musical instrument", "Bowed string instrument"] | ["amateur recording", "rock song", "instrumental", "no voices", "violins", "banjo", "tambourine", "simple percussion", "happy mood", "moderate tempo"] | 0 | MpWGx5odhh8 | 2301 | |
Irish traditional music : "Altan" [ with Frankie Kennedy ] play a medley | This clip features a melody played by violins and flutes. This is a low quality recording. There is no percussion in this song. Hand claps are played on every count. This is a folk song which has a happy mood. There is no voice in this song. This song can be used in a movie scene where somebody enters a castle to meet medieval royalty. | 2014-06-17T20:58:48Z | DOUGLAS HADDEN | "Altan" play a set of "highlands" and reels. The reels are "The Monaghan Twig" and the Scottish reel "The High Road To Linton". | ["Traditional music", "Music", "Middle Eastern music", "Music of Bollywood"] | ["low quality recording", "hand claps", "violins", "flutes", "no percussion", "no voices", "moderate tempo", "folk song", "happy feel"] | 0 | a2Wuroc8DQU | 3513 |
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;