musiccaps_details (view)
1 row where musiccaps_aspects contains "male laughing", musiccaps_aspects contains "mono", musiccaps_aspects contains "muffled trumpet melody" and musiccaps_author = 4
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
REBIRTH BRASS BAND - "Move Your Body" (Live in New Orleans) #JAMINTHEVAN | The low quality recording features a muffled trumpet melody playing. There is a random male laughing sound. The recording is very noisy and in mono. It sounds like an intro of a video. | 2014-08-25T20:17:54Z | Jam In The Van | Rebirth Brass Band - "Move Your Body" Live in New Orleans with Jam in the Van. Subscribe to Jam in the Van! http://bit.ly/subthejamvan Check out Rebirth Brass Band's other video from this session! https://www.youtube.com/watch?v=GaKkoqDa8Ng GET THE AUDIO HERE: http://www.jaminthevan.com/band/rebirth-brass-band/ http://jaminthevan.com http://facebook.com/jaminthevan http://twitter.com/jaminthevan *** About Jam in the Van*** Jam in the Van ==== Where music takes a whole new road. We will be traveling anywhere accessible by road to find and record intimate musical experience's for our fans. If you are interested in our cause let us know. Dig on our cool sponsors: Lagunitas Brewing Company Brewers of fine ales, mystery and romance. In Petaluma, Chicago, & the World. Give us a call! 707.769.4495 Don't click these... www.LAGUNITAS.com #lagunitas on Instagram: http://instagram.com/lagunitasbeer #lagunitas on Twitter: http://twitter.com/lagunitasbruhws #lagunitas on YouTube: http://youtube.com/user/lagunitasbrewing Ploom's got us rethinking music.... http://www.ploom.com/ Harrahs Casino keeps us sheltered http://www.harrahsneworleans.com/ Get the MXL Mic used during this video here: http://www.mxlmics.com Dig on the awesome Orange Amps used in these videos here: http://www.orangeamps.com We keep our gear in Osprey Packs! http://www.ospreypacks.com We use GoPro Cameras! http://www.gopro.com Our thirst is quenched with Aquahydrate! http://www.aquahydrate.com/ QSC Audio Products keeps it sounding heady! http://qsc.com/ Goal Zero helps us harness the power of the sun! http://www.goalzero.com/ *** Credits *** Artists: Rebirth Brass Band Director of Photography: Dave Yeaman Camera Operator: Chris Shashaty Recording Engineer: Jacob Lacally Mixing Engineer: Sean P. Jones Post Production by: Joel Moody Created & Produced by Jam in the Van, LLC Music by: Rebirth Brass Band http://rebirthbrassband.com Tour Dates: http://www.rebirthbrassband.com/events ••••• https://www.facebook.com/rebirthbrassband | ["Brass instrument", "Foghorn", "Music", "Musical instrument"] | ["low quality", "muffled trumpet melody", "male laughing", "noisy", "mono", "intro"] | 4 | wz-7sy_Rin4 | 5296 |
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;