musiccaps_details (view)
1 row where musiccaps_author = 4, musiccaps_names contains "Flamenco" and youtube_channel = "Mohib ur rahman"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nadia (ja re ja moo dho ke aa) :P by Mohib ur Rahman | The low quality recording features a flat male vocal singing over muffled acoustic rhythm guitar. The recording is very noisy, it sounds uptempo and like it is recorded via phone. | 2010-06-16T12:24:34Z | Mohib ur rahman | lyrics: baal hain ye.... ya gaai ki dum... gandey tery daant.... uss pe ganda ye moo.... kholey jo tu moo ..... tou aaey badboo.... Nadia nadia o rey nadia nadia nadia o rey nadia... ja rey ja..... moo dho key aa.. ja rey ja..... moo dho key aa... dekhey jo tujhey...... dar jaaey woh.. choo le tu jisse ..... Allah bachaaey uss ko.. Nadia nadia o rey nadia.. Nadia nadia o rey nadia ja rey ja... moo dho key aa.. ja rey ja..... moo dho key aa... Jo baney tera yaar.... us ka jeena dushwaar jisey ho gaya tujh se pyaar....... nahi us se bara koi khuaar... nadia nadia o rey nadia... nadia nadia o rey nadia... ja rey ja.... moo dho ke aa... ja rey ja.... moo dho key aa.. | ["Flamenco", "Music"] | ["low quality", "noisy", "flat male vocal", "muffled acoustic rhythm guitar", "uptempo"] | 4 | EJMUwh1vY2s | 1544 |
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;