jobs

Table actions

6 rows where strategy = "{"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo

id ▼ workflow name repo runs-on strategy needs if
27456 Publish Python Package 20676 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27458 Test 20677 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27467 Publish Python Package 20684 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27470 Test 20686 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27480 Publish Python Package 20693 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27482 Test 20694 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "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]);