musiccaps_details (view)
3 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Theme music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- poor audio quality · 3 ✖
- instrumental music 2
- a new dangerous world 1
- adrenaline rush 1
- adventurous 1
- apocalypse 1
- army band music 1
- brass band 1
- brass instruments playing triumphantly 1
- christmas presents 1
- christmas song 1
- conductor 1
- cymbal crashes 1
- documentary soundtrack 1
- emotional 1
- excitement 1
- exciting 1
- explore the wild 1
- glory and honour 1
- horn section 1
- horns plays howling tones 1
- inspiring 1
- instrumenatl music 1
- keyboard synth harmony 1
- low pitched harmony 1
- marching drumming rhythm 1
- marching rhythm 1
- medium tempo 1
- movie soundtrack 1
- new age music 1
- nights are scenario 1
- ominous tones 1
- opera hall 1
- patriotic fervour 1
- patriotic music 1
- philharmonic orchestra 1
- pomp and glory 1
- post nuclear doom 1
- santa claus 1
- showcasing air power 1
- slow tempo 1
- snare plays percussively 1
- soaring harmonies 1
- solo violin 1
- spirited 1
- string section 1
- surreal landscape 1
- trombones 1
- trumelts playing 1
- trumpets blaring harmony 1
- trumpets playing 1
- tubas playing 1
musiccaps_names (array) 6 ✖
- Music 3
- Theme music · 3 ✖
- Background music 1
- New-age music 1
- Soundtrack music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aviation Nation 2005- Ace Combat Music | The song is an instrumental. The tempo is medium with a marching band rhythm, snares playing percussively , cymbals crashing, brass band harmony, trumpets blaring, trombones and tubas playing long notes. The song has a patriotic fervour and inspires. The overall sound quality is poor. | 2007-02-02T14:27:08Z | shadowbreaker015 | Aviation Nation 2005 | ["Theme music", "Music", "Soundtrack music", "Tender music"] | ["instrumenatl music", "army band music", "patriotic fervour", "patriotic music", "spirited", "excitement", "pomp and glory", "adrenaline rush", "glory and honour", "marching drumming rhythm", "brass band", "trumpets blaring harmony", "trombones", "tubas playing", "snare plays percussively", "cymbal crashes", "poor audio quality", "showcasing air power", "documentary soundtrack", "poor audio quality"] | 1 | tKawN2sxhYc | 5028 | |
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;