musiccaps_details (view)
3 rows where musiccaps_aspects contains "shimmering hi hats", musiccaps_author = 4 and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- low quality 3
- shimmering hi hats · 3 ✖
- groovy bass 2
- passionate 2
- "4 on the floor" kick pattern 1
- accordion melody 1
- applause 1
- classical 1
- crowd chattering 1
- crowd cheering 1
- electric guitar melody 1
- emotional 1
- exotic 1
- folk 1
- fun 1
- groovy 1
- happy 1
- live perfomrance 1
- live performance 1
- muffled 1
- punchy snare 1
- reverberant 1
- steel pans melody 1
- sustained strings 1
- syncopated snare 1
- trombone melody 1
musiccaps_names (array) 12 ✖
- Orchestra · 3 ✖
- Music 2
- Musical instrument 2
- Accordion 1
- Brass instrument 1
- Music of Latin America 1
- Percussion 1
- Saxophone 1
- Singing 1
- Speech 1
- Steelpan 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Amazing Grace" on the steel pans by the Dover High School Steel Drum Band | The low quality recording features a steel pans melody, shimmering hi hats, syncopated snare and "4 on the floor" kick pattern. It is a bit reverberant as it was played in a concert hall. There are some crowd cheering and applause sounds. It sounds exotic, fun and happy. | 2011-10-15T22:04:45Z | Ann Swinderman | Under the direction of Joan Wenzel, the Dover Steel Drum Band performs this favorite in the Performing Arts Center Kent State University Tuscarawas lobby. | ["Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "steel pans melody", "reverberant", "shimmering hi hats", "syncopated snare", "\"4 on the floor\" kick pattern", "groovy bass", "crowd cheering", "applause", "exotic", "fun", "happy"] | 4 | 6J3X0whM_-4 | 742 | |
GoPro on Trombone: Crescent Moon | The low quality recording features a live performance of a classical song and it contains trombone melody playing over shimmering hi hats and sustained strings. It sounds muffled, but also passionate and emotional. | 2014-09-22T18:25:32Z | Manuel Nägeli | Crescent Moon von Jan Van der Roost. Gespielt vom Symphonischen Blasorchester des Schweizer Armeespiels, dirigiert von Major Philippe Monnerat. | ["Brass instrument", "Orchestra", "Saxophone"] | ["low quality", "classical", "live perfomrance", "shimmering hi hats", "trombone melody", "sustained strings", "muffled", "passionate", "emotional"] | 4 | 9K8EePrEDdo | 994 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 |
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;