musiccaps_details (view)
2 rows where "youtube_published" is on date 2007-03-06 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- amateur recording 1
- ambient room noises 1
- birds chirping 1
- bouncing balls 1
- didgeridoo 1
- engaging 1
- exciting 1
- groovy 1
- groovy rhythm 1
- improvised percussions 1
- instrument demo 1
- instrumental music 1
- lethargic groove 1
- live show 1
- medium tempo 1
- percussion technique 1
- percussionist 1
- poor audio quality 1
- rattle sound 1
- rattling percussions 1
- showman 1
- uninteresting 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 2
- Bouncing 1
- Didgeridoo 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bouncing in a Rotating Square (Preview) | The song is an instrumental. The song is medium tempo with an improvised percussion instrument playing steady rhythm and rattling sounds. The song has a very basic percussion rhythm. The audio quality is poor. | 2007-03-06T23:04:36Z | Greg Kennedy | Greg Kennedy's most recent routine, bounce jugglng on the inside surface of a rotating square. Visit www.innovativejuggler.com for more info. | ["Music", "Bouncing"] | ["improvised percussions", "poor audio quality", "lethargic groove", "uninteresting", "exciting", "engaging", "groovy", "percussion technique", "bouncing balls", "instrument demo", "rattling percussions", "groovy rhythm", "showman", "percussionist", "live show", "ambient room noises", "instrumental music", "medium tempo"] | 1 | JNW76fDWkA0 | 1995 | |
Didgeridoo in San Francisco | This audio contains someone playing a didgeridoo and a rattle sound. In the background you can hear birds chirping. This song may be played live by a busker. | 2007-03-06T23:42:22Z | envifilms | Hernan Battiato rocks the didgeridoo in Golden Gate Park, San Francisco. http://www.hernanbattiato.com | ["Didgeridoo", "Music", "Musical instrument"] | ["amateur recording", "didgeridoo", "rattle sound", "birds chirping", "uptempo"] | 6 | xSmmTveNPSM | 5331 |
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;