musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "adventurous", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 42 ✖
- adventurous · 3 ✖
- emotional · 3 ✖
- instrumental music · 3 ✖
- medium tempo 3
- acoustic guitar lead 1
- adventure music 1
- ambient echoes 1
- arcade game music 1
- children playing games 1
- classic rock music 1
- computer music 1
- distortion guitars 1
- documentary soundtrack 1
- drum roll 1
- electric guitar lead 1
- energetic 1
- exciting 1
- game music track 1
- groovy 1
- groovy bass line 1
- guitar amplifier 1
- guitar demo 1
- guitar harmony 1
- guitar played accompaniment style 1
- guitar solo 1
- handheld game 1
- home video 1
- me 1
- midi music 1
- passionate 1
- poignant 1
- poor audio quality 1
- poor quality audio 1
- retro game tracks 1
- science experiment 1
- soloist 1
- strong bass line 1
- strong rock drumming 1
- subtle bass line 1
- tone generator 1
- tv show 1
- youtube music video 1
musiccaps_names (array) 14 ✖
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 | |
Bouncing Steel Balls on Water | The song is an instrumental. The tempo is medium with a strong rock drumming rhythm, groovy bass slime, electric guitars playing lead and guitar harmony. The song is exciting, youthful and emotional. The song is a classic rock instrumental. | 2009-08-26T21:41:24Z | protonsforbreakfast | Some slow-motion footage of experiments bouncing 25 mm diameter steel balls on water. The Balls were fired from a specially constructed air gun and had a muzzle velocity of around 40 meters per second (90 miles per hour). The bouncing is easy to see and the general effect delightful. Enjoy! The experiment was performed on the site of a 'Ship Tank' at the UK's National Physical Laboratory in which the original experiments were conducted in 1943 on a so-called 'bouncing bomb'. | ["Heavy metal", "Music", "Punk rock", "Independent music", "Rock music", "Progressive rock"] | ["classic rock music", "instrumental music", "emotional", "groovy", "poignant", "drum roll", "distortion guitars", "tv show", "instrumental music", "medium tempo", "electric guitar lead", "guitar harmony", "strong bass line", "adventurous", "energetic", "documentary soundtrack", "science experiment", "strong rock drumming", "me"] | 1 | XfdySM4X9Xo | 3209 | |
Mabinogi Music Playing- Kuroshitsuji Ending 2: Lacrimosa | The song is an instrumental. The song is medium tempo with a groovy bass line and a guitar synth tone playing melody. The song is exciting and adventurous in nature. The song is a video game song track. | 2011-04-21T22:37:24Z | CatnipMafia | For this score by me and more, please visit: [ http://reo12.webs.com/mmlscript.htm ] | ["Background music", "Music", "/t/dd00032"] | ["acoustic guitar lead", "midi music", "groovy bass line", "children playing games", "handheld game", "arcade game music", "retro game tracks", "poor quality audio", "instrumental music", "computer music", "medium tempo", "game music track", "emotional", "adventurous"] | 1 | uT-S_JC_GzU | 5116 |
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;