home / musiccaps

videos

1 row where defaultLanguage = "hr"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publishedAt (date), tags (array)

id ▼ publishedAt channelId title description thumbnails channelTitle tags categoryId liveBroadcastContent localized viewCount likeCount favoriteCount commentCount defaultAudioLanguage defaultLanguage
Zy_YSROQmlE 2012-03-18T23:49:52Z UCLxb0nuOUaIlwD9djFO1kcw Oliver Dragojevic - Serenada (mix) {"default": {"url": "https://i.ytimg.com/vi/Zy_YSROQmlE/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Zy_YSROQmlE/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Zy_YSROQmlE/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/Zy_YSROQmlE/sddefault.jpg", "width": 640, "height": 480}} Life is Good ["MIX"] 10 none {"title": "Oliver Dragojevic - Serenada (mix)", "description": " "} 915294 1424 0 97 hr hr

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [videos] (
   [id] TEXT PRIMARY KEY,
   [publishedAt] TEXT,
   [channelId] TEXT,
   [title] TEXT,
   [description] TEXT,
   [thumbnails] TEXT,
   [channelTitle] TEXT,
   [tags] TEXT,
   [categoryId] TEXT,
   [liveBroadcastContent] TEXT,
   [localized] TEXT,
   [viewCount] INTEGER,
   [likeCount] INTEGER,
   [favoriteCount] INTEGER,
   [commentCount] INTEGER,
   [defaultAudioLanguage] TEXT
, [defaultLanguage] TEXT);
Powered by Datasette · Queries took 765.417ms · About: simonw/musiccaps-datasette