musiccaps_details (view)
2 rows where musiccaps_aspects contains "drums" and musiccaps_aspects contains "slower tempo" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- drums · 2 ✖
- slower tempo · 2 ✖
- amateur recording 1
- bagpipes 1
- e-bass 1
- hiphop 1
- laid back atmosphere 1
- male voice singing 1
- scratching 1
- traditional 1
- vocal samples 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Chris Paul - Here comes the Hotstepper | This song contains a drumbeat with a funky bassline. A male voice is singing in a higher range. in the background you can hear different voice samples and scratching. This song may be playing while cruising down the street in your car. | 2008-02-07T18:29:09Z | LUXfinest | My Chris Paul Mix | ["Music", "Reggae"] | ["hiphop", "drums", "scratching", "e-bass", "vocal samples", "male voice singing", "laid back atmosphere", "slower tempo"] | 6 | h9zF09TMgLU | 4081 | |
Edinburgh Military Tattoo 2012 - Massed Pipes and Drums (1 of 3) | This audio contains a huge amount of people playing a melody on the bagpipes while others are playing a kick sound on every beat. This song may be playing live during a big public event. | 2012-08-11T14:29:06Z | darm49 | Edinburgh Military Tattoo - Wednesday 8th August 2012 Tunes: The Crofter Colin's Cattle The Herding Song Cutting Bracken Clean Please Strae The Wind that Shakes the Barley Na Goisidich Speed the Plough Bands: The Royal Scots Dragoon Guards The Royal Corps of Signals The Royal Highland Fusiliers, 2nd Battalion The Royal Regiment of Scotland The Black Watch, 3rd Battalion The Royal Regiment of Scotland The Highlanders, 4th Battalion The Royal Regiment of Scotland The Rats of Tobruk, Melbourne, Australia Australian Federal Police Pipes & Drums, Canberra, Australia The Manly Warringah Pie Band, Sydney, Australia The Cape Town Highlanders, South Africa The Canadian Army Pipes & Drums The Scots College Pipes & Drums, Sydney, Australia Queen Victoria School Pipes, Drums & Dancers, Dunblane, Scotland | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "bagpipes", "drums", "traditional", "slower tempo"] | 6 | w2MeQg3W7Po | 5231 |
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;