musiccaps_details (view)
4 rows where musiccaps_aspects contains "adventurous", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- adventurous · 4 ✖
- medium tempo · 4 ✖
- poor audio quality · 4 ✖
- exciting 3
- instrumental music 3
- adventure music 1
- ambient echoes 1
- brass instruments playing triumphantly 1
- buzzing hum 1
- christmas presents 1
- christmas song 1
- conductor 1
- cymbal crash tone 1
- daw setup 1
- distorted guitar lead 1
- electronic dance music 1
- electronic music 1
- emotional 1
- groovy bass line 1
- groovy rhythm 1
- guitar amplifier 1
- guitar demo 1
- guitar played accompaniment style 1
- guitar rhythm 1
- guitar solo 1
- head bangers 1
- home studio 1
- home video 1
- horn section 1
- long echoes 1
- male singer 1
- marching rhythm 1
- movie soundtrack 1
- mystery 1
- opera hall 1
- party time 1
- passionate 1
- people screaming 1
- philharmonic orchestra 1
- positive 1
- pulsating tones 1
- retro classic rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- santa claus 1
- screaming vocals 1
- soaring harmonies 1
- solo violin 1
- soloist 1
- song ending 1
- song fading 1
- story telling 1
- string section 1
- subtle bass line 1
- suspense 1
- techno tones 1
- tone generator 1
- trance music 1
- trumelts playing 1
- trumpets playing 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 16 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
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 | |
Pirates of the Caribbean Trance/Dance Remix | The song is an instrumental. The song is medium tempo with a loud crash tone which undulates percussively and fades. The song is of poor audio quality and probably faded with a lot of humming noise. | 2007-06-28T22:54:39Z | cornholio | I hope you guys enjoy this. I had some latency issues so I just placed the mp3 file over the video file. Tell me what you think! Software used: FL Studio 7, Sytrus, Nexus Hardware used: M-Audio Axiom 49 | ["Music", "White noise"] | ["instrumental music", "poor audio quality", "suspense", "mystery", "adventurous", "party time", "trance music", "buzzing hum", "electronic dance music", "home studio", "cymbal crash tone", "groovy rhythm", "long echoes", "electronic music", "song fading", "techno tones", "daw setup", "electronic music", "song ending", "medium tempo", "pulsating tones"] | 1 | KpwdlYIdtfs | 2123 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;