jobs

Table actions

10 rows where strategy = "{"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo

id ▼ workflow name repo runs-on strategy needs if
27459 Publish Python Package 20678 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27461 Test 20679 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27463 Publish Python Package 20681 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27465 Test 20682 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27471 Publish Python Package 20687 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27473 Test 20688 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27474 Publish Python Package 20689 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27476 Test 20690 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27483 Publish Python Package 20695 test twitter-to-sqlite 206156866 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27486 Test 20697 test twitter-to-sqlite 206156866 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]);