musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Theme music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- instrumental music · 2 ✖
- poor audio quality · 2 ✖
- a new dangerous world 1
- adventurous 1
- apocalypse 1
- brass instruments playing triumphantly 1
- christmas presents 1
- christmas song 1
- conductor 1
- emotional 1
- exciting 1
- explore the wild 1
- horn section 1
- horns plays howling tones 1
- inspiring 1
- keyboard synth harmony 1
- low pitched harmony 1
- marching rhythm 1
- medium tempo 1
- movie soundtrack 1
- new age music 1
- nights are scenario 1
- ominous tones 1
- opera hall 1
- philharmonic orchestra 1
- post nuclear doom 1
- santa claus 1
- slow tempo 1
- soaring harmonies 1
- solo violin 1
- string section 1
- surreal landscape 1
- trumelts playing 1
- trumpets playing 1
musiccaps_names (array) 4 ✖
- Music 2
- Theme music · 2 ✖
- Background music 1
- New-age music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jingle All the Way OST 18. Turbo Tom Marching Band #2 | The song is an instrumental song. The song is medium tempo with a marching drum rhythm, string section harmony, brass instruments playing and a horn section playing various harmonies. The song is exciting and adventurous in nature. The song is a movie soundtrack, and the audio quality is quite poor. | 2011-08-21T20:50:43Z | 1991Nukem | All rights go to 20th Century Fox & 1492 Pictures. | ["Theme music", "Music"] | ["movie soundtrack", "poor audio quality", "instrumental music", "trumpets playing", "soaring harmonies", "conductor", "santa claus", "christmas presents", "opera hall", "philharmonic orchestra", "string section", "solo violin", "trumelts playing", "medium tempo", "marching rhythm", "exciting", "adventurous", "christmas song", "horn section", "brass instruments playing triumphantly"] | 1 | JHkcCXF5vII | 1986 | |
Sacred Spirit - Yo-Hey-Ohee (War Cries) | The song is an instrumental. The song is slow tempo with a sweeping string section harmony along with a low pitched harmony played in harmony, and howling tones played by a horn like instrument. The song is emotional with a surreal effect. The song audio quality is poor. | 2012-08-19T08:30:28Z | Martonos Gabriel | From the Sacred Spirit album Chants & Dances of the Native Americans (1998) David and Steve Gordon | ["Background music", "Theme music", "New-age music", "Music"] | ["a new dangerous world", "instrumental music", "new age music", "surreal landscape", "emotional", "inspiring", "nights are scenario", "apocalypse", "post nuclear doom", "poor audio quality", "keyboard synth harmony", "horns plays howling tones", "low pitched harmony", "ominous tones", "instrumental music", "slow tempo", "explore the wild"] | 1 | VtHkxrta5xQ | 3040 |
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;