musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "string section"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- amateur recording · 4 ✖
- string section · 4 ✖
- slow tempo 2
- background sounds 1
- background whispering 1
- brass section 1
- cinematic 1
- classical music 1
- dramatic 1
- flutes 1
- instrumental 1
- male voice 1
- no percussion 1
- no voices 1
- oboes 1
- orchestra 1
- piano 1
- plucked string instrument 1
- romantic theme 1
- shooting sounds 1
- soft and dreamy 1
- synth pad 1
- trumpet song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jack Black parodies Spiderman by MAD TV (ORIGINAL) | An orchestra is playing a melody with a string section and a brass section giving it a feeling of something great is about to come. Apart from the music you can hear sounds of things breaking and a beeping sound. This is an amateur recording and not of the best audio-quality. This song may be playing in a heroic movie scene. | 2007-10-07T09:47:38Z | poobearpanda345 | MAD TV's Spiderman parody from the early 00s. Sorry for the bad quality! | ["Music", "Breaking", "Inside, small room"] | ["cinematic", "string section", "brass section", "background sounds", "amateur recording"] | 6 | SyJT8XsFsmE | 2801 | |
GTA IV - SWAT [Dubbing PL] [Subtitles EN] | A lot of gun firing can be heard in this recording. In the background strings are playing a melody along with a piano. A male voice is making a sound like being annoyed. This is an amateur recording and the song may be more suitable for a relaxing and sad movie-scene. | 2009-08-30T22:38:07Z | Gracjan Gornig | Facebook! http://facebook.com./gse.studio (Polska) Zapraszam do oglądania. (English) I invite to watch! | ["Music", "Boom"] | ["amateur recording", "string section", "piano", "synth pad", "shooting sounds", "male voice"] | 6 | WxgolzWTmO4 | 3152 | |
Mara Galeazzi & Edward Watson in Romeo & Juliet. | A full orchestra is playing a slow dramatic, emotional and soft composition. In the background whispering can be heard. This is an amateur recording. This song may be playing at a theater dancing ballet. | 2013-09-24T15:32:40Z | Approximatesonata | Balcony scene pas de deux. Cor. Kenneth Mac Millan. | ["Music", "Opera", "Classical music"] | ["classical music", "orchestra", "flutes", "string section", "oboes", "slow tempo", "dramatic", "background whispering", "soft and dreamy", "amateur recording"] | 6 | q9zAlMM-A9I | 4759 | |
Trumpet Solo ~ My Heart Will Go On, theme from Titanic | This amateur recording features a trumpet playing the main melody. The song starts with a string section playing a chord and fading away. The trumpet starts to play the melody. This is backed by a stringed instrument plucking chords. This sounds like a harp or an acoustic guitar. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-01-18T09:26:46Z | TPBOY | Book from " Take the Lead " | ["Brass instrument", "Trumpet"] | ["amateur recording", "trumpet song", "romantic theme", "string section", "plucked string instrument", "no percussion", "slow tempo", "no voices", "instrumental"] | 0 | xZukWGb52BI | 5341 |
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;