assets

Table actions

1 row where "created_at" is on date 2021-01-04 and uploader = 9599

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

id ▼ url node_id name label uploader content_type state size download_count created_at updated_at browser_download_url release
30264367 https://api.github.com/repos/simonw/datasette/releases/assets/30264367 MDEyOlJlbGVhc2VBc3NldDMwMjY0MzY3 datasette-0.53-macos-binary.zip   simonw 9599 application/zip uploaded 8297283 49 2021-01-04T21:26:30Z 2021-01-04T21:26:43Z https://github.com/simonw/datasette/releases/download/0.53/datasette-0.53-macos-binary.zip 0.53 35131848

Advanced export

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

CSV options: 

CREATE TABLE [assets] (
   [url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [name] TEXT,
   [label] TEXT,
   [uploader] INTEGER REFERENCES [users]([id]),
   [content_type] TEXT,
   [state] TEXT,
   [size] INTEGER,
   [download_count] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [browser_download_url] TEXT,
   [release] INTEGER REFERENCES [releases]([id])
);
CREATE INDEX [idx_assets_release]
    ON [assets] ([release]);
CREATE INDEX [idx_assets_uploader]
    ON [assets] ([uploader]);