musiccaps_details (view)
2 rows where musiccaps_author = 6 and "youtube_published" is on date 2009-11-10
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 |
---|---|---|---|---|---|---|---|---|---|---|
Will You Miss Me - Rosine Kentucky Bluegrass Barn Jamboree - Traditional Bluegrass Music | Acoustic guitars are strumming chords while male voices are singing along. There are a lot of background noises of people talking. The recording is of very poor quality. This song may be playing at a local small town event. | 2009-11-10T07:40:04Z | db | Melvin Gill & Pat Meehan of the Kentuckiana Grass band play music with a few friends (Doug Morris & Guynn Cagle on flat top guitars, Sandy Morris on the Dobro) at the Rosine, KY Barn Jamboree Friday Nov. 6, 2009. *Pat Meehan-Mandolin *Melvin Gill-Singing & flat pickin. | ["Country", "Music", "Bluegrass"] | ["bluegrass", "acoustic guitars", "male voices singing", "background noises", "amateur recording", "medium tempo"] | 6 | ZqnbgQeeRbM | 3420 | |
Jordania y su Música | This song contains a male voice loudly singing in a higher key. A flutelike instrument is playing a melody out of tune accompanied by an accordion sound. This is an amateur recording. | 2009-11-10T08:33:59Z | rauloleono | El Reino Hachemita de Jordania es uno de los países que alberga en sus regiones deserticas a una gran cantidad de árabes beduinos. Este grupo social nómada tiene fuerte influencia sobre Jordania, principalmente en la música tradicional jordana. Los beduinos poseen sus propios maneras de desarrollar sus constumbres y tradiciones; las danzas es una manera de demostrar su cultura y la música a pesar de poseer escalas un tanto primitivas, mantienen un lugar popular en el folklór árabe. Espero disfruten de éstas 2 piezas tradicionales beduinas. Me hubiera gustado publicar más pero desafortunadamente la música de Jordania es escaza para conseguir, pero de todas maneras, lo que he publicado para ustedes narra claramente a "Jordania y su Música". Saludos a todos(as) y que lo disfruten. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "male voice singing", "higher key", "flute like instrument", "medium uptempo"] | 6 | gI-ovjTWBzo | 4022 |
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;