musiccaps_details (view)
2 rows where musiccaps_aspects contains "funky bass lines" and musiccaps_aspects contains "instrumental" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- funky bass lines · 2 ✖
- instrumental · 2 ✖
- acoustic guitar 1
- boisterous 1
- catchy 1
- clapping 1
- classic pop 1
- edm 1
- electric powered 1
- electrifying 1
- electro/pop 1
- electronic sounds 1
- energetic 1
- enthusiastic 1
- exhilarating 1
- explosive 1
- fast tempo 1
- fingers snapping 1
- fresh 1
- futuristic 1
- happy 1
- keyboard accompaniment 1
- keyboard harmony 1
- medium fast tempo 1
- melodic 1
- passionate 1
- peppy 1
- pop music 1
- powerful 1
- progressive 1
- rapid 1
- retro music 1
- rhythmic drumming 1
- simple harmony 1
- sunny 1
- synth/pop 1
- synthesiser articulation 1
- vibrant electric guitar harmony 1
- vigorous drumming 1
- vocalisation 1
- volatile 1
- whistle harmony 1
musiccaps_names (array) 4 ✖
- Music 2
- Drum and bass 1
- Exciting music 1
- House music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2012 Chrysler 300C CRD engine sound and 0-100km/h | This music is an Electronic instrumental. The tempo is fast with an electrifying drum rhythm, funky bass lines, synthesiser articulation, cymbals rides, digital drums and electronically arranged sounds. The music is an energetic, high-powered, energetic, enthusiastic, intense, and explosive EDM/Synth Pop. | 2012-11-22T10:36:55Z | PDriveTV | 2012 Chrysler 300C CRD engine sound and 0-100km/h. Head over to http://performancedrive.com.au/2012-chrysler-300c-crd-review-video/ for the full review. 2012 Chrysler 300C CRD 3.0-litre turbo-diesel V6 with DOHC and common-rail injection Five-speed automatic, rear-wheel drive 176kW/550Nm 0-100km/h in 7.0 seconds (as tested) | ["Drum and bass", "House music", "Music"] | ["instrumental", "fast tempo", "vocalisation", "synth/pop", "electro/pop", "futuristic", "progressive", "edm", "synthesiser articulation", "vigorous drumming", "funky bass lines", "vibrant electric guitar harmony", "keyboard accompaniment", "electronic sounds", "rapid", "boisterous", "energetic", "enthusiastic", "electrifying", "exhilarating", "passionate", "electric powered", "powerful", "volatile", "explosive"] | 7 | b8cgQBzBXi8 | 3603 | |
Tajomný ostrov (1984) series intro music | This music is instrumental. The tempo is medium fast with a melodic keyboard harmony, punchy drumming, funky bass lines, and rhythmic acoustic guitar, whistle harmony and clapping and fingers snapping.The melody is simple, sunny, warm, energetic and youthful with a retro vibe. This music is classic Pop. | 2009-09-01T20:07:10Z | dbacelic | ["Music", "Exciting music"] | ["instrumental", "pop music", "medium fast tempo", "acoustic guitar", "classic pop", "peppy", "retro music", "keyboard harmony", "rhythmic drumming", "funky bass lines", "whistle harmony", "clapping", "fingers snapping", "simple harmony", "melodic", "catchy", "fresh", "happy", "sunny"] | 7 | Pk5NZe-ah4U | 2560 |
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;