home / train

file

10 rows where patch_id = 1867

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
8445 1867 1867 extension.json
8446 1867 1867 i18n/en.json
8447 1867 1867 i18n/qqq.json
8448 1867 1867 modules/CommentController.js
8449 1867 1867 modules/dt-ve/CommentTarget.js
8450 1867 1867 modules/dt-ve/dt.ce.MWSignatureNode.js
8451 1867 1867 modules/dt-ve/dt.dm.MWSignatureNode.js
8452 1867 1867 modules/dt-ve/dt.ui.MWSignatureContextItem.js
8453 1867 1867 modules/dt-ve/dt.ui.registries.js
8454 1867 1867 modules/dt.ui.ReplyWidgetVisual.js

Advanced export

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

CSV options:

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);
Powered by Datasette · Queries took 19.304ms