3 rows where repo = 248903544

View and edit SQL

Suggested facets: workflow, name, needs (array)

id ▼ workflow name repo runs-on strategy needs if
7692 Publish Python Package 5789 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
7693 Publish Python Package 5789 deploy hacker-news-to-sqlite 248903544 ubuntu-latest   ["test"]  
7694 Test 5790 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    

Advanced export

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

CSV options:

CREATE TABLE [jobs] (
   [id] INTEGER PRIMARY KEY,
   [workflow] INTEGER REFERENCES [workflows]([id]),
   [name] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [runs-on] TEXT,
   [strategy] TEXT
, [needs] TEXT, [if] TEXT);
CREATE INDEX [idx_jobs_repo]
    ON [jobs] ([repo]);
CREATE INDEX [idx_jobs_workflow]
    ON [jobs] ([workflow]);