jobs

Table actions

3 rows where repo = 213286752

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: workflow, name, needs (array)

id ▼ workflow name repo runs-on strategy needs if
27795 Publish Python Package 20931 test pocket-to-sqlite 213286752 ubuntu-latest 
{
    "matrix": {
        "python-version": [
            "3.8",
            "3.9",
            "3.10",
            "3.11"
        ]
    }
}
    
27796 Publish Python Package 20931 deploy pocket-to-sqlite 213286752 ubuntu-latest   
[
    "test"
]
  
27797 Test 20932 test pocket-to-sqlite 213286752 ubuntu-latest 
{
    "matrix": {
        "python-version": [
            "3.8",
            "3.9",
            "3.10",
            "3.11"
        ]
    }
}
    

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]);