musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "alternative", musiccaps_aspects contains "electric guitar" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 14 ✖
- alternative · 2 ✖
- bass guitar 2
- electric guitar · 2 ✖
- male vocal 2
- acoustic drum 1
- acoustic drums 1
- easygoing 1
- energetic 1
- indie rock 1
- live performance 1
- melodic singing 1
- nu-metal 1
- repeated tune 1
- simple tune 1
musiccaps_names (array) 3 ✖
- Exciting music · 2 ✖
- Music 2
- Happy music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Surfer Blood - I Can't Explain (Official Music Video) | This is an indie rock music piece. There is a male vocalist singing melodically in the lead. There is an electric guitar playing a simple tune with a strong reverb effect. The bass guitar is playing the root notes. The rhythmic background consists of a basic acoustic drum beat. The atmosphere is easygoing. This piece could be used in the soundtrack of a teenage drama TV series as the opening theme. | 2015-04-30T23:57:18Z | Surfer Blood | '1000 Palms' out May 12, 2015. Pre-order at LP / CD http://www.surferblood.com/buy iTunes http://radi.al/1000PalmsiTunes Amazon http://radi.al/1000PalmsAmazon Director & Editor: Ates Isildak / Strangewave Cinematographer & Color Grading: Don Fils Producer: Joel Tillman Camera 2: Donny Barth | ["Music", "Happy music", "Exciting music"] | ["indie rock", "alternative", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drum", "simple tune", "easygoing"] | 9 | 3C-5_z01Olc | 447 | |
She's All That shouting out Music Music! (live @ Rheinkultur Bonn 2009) | This is a nu-metal piece performed live on the stage. There is a male vocal shouting the words at the end of the song. The electric guitar is repeating the same tune while the bass guitar is playing in the background. The drummer plays fills on the acoustic drums to provide the rhythmic background. There is a high energy atmosphere to this piece. It could be used in an ad targeted for teenagers. | 2009-07-05T21:32:23Z | pnolle | Those Nu-Break-maniacs give you the ultimate thrill on stage, hiding their identity behind bizarre masks. A ferocious mixture of electro, ragga, punk and breakbeat. Visit www.shesallthat.de SATrk09 SuperKid 640x360 | ["Music", "Exciting music"] | ["nu-metal", "alternative", "live performance", "male vocal", "electric guitar", "repeated tune", "bass guitar", "acoustic drums", "energetic"] | 9 | 79tuMIiWMZ4 | 816 |
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;