musiccaps_details (view)
2 rows where musiccaps_aspects contains "romantic theme" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- instrumental 2
- romantic theme · 2 ✖
- amateur recording 1
- brass section 1
- hand claps 1
- no percussion 1
- no voice 1
- no voices 1
- piano 1
- plucked string instrument 1
- slow pop song 1
- slow tempo 1
- string section 1
- tambourine 1
- trumpet song 1
youtube_published (date) 2 ✖
- 2009-01-18 1
- 2009-08-20 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robots by Dan Mangan | This slow pop song features the brass section playing the main melody in harmony. This is accompanied by hand claps on every alternate count. A tambourine plays a rhythmic beat in the background. Two piano notes are played in the background in the first bar of the song. There are no voices in this song. This instrumental song has a romantic theme. This song can be played in a romantic movie. | 2009-08-20T01:31:13Z | Taylor Jones | This song is called Robots and is preformed by Dan Mangan. This is a compilation of photos. | ["Brass instrument", "Trombone", "Trumpet"] | ["slow pop song", "hand claps", "tambourine", "brass section", "no voice", "instrumental", "piano", "romantic theme"] | 0 | T7khbuOBHbo | 2814 | |
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;