jobs

Table actions

12 rows where name = "deploy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, needs (array)

id ▼ workflow name repo runs-on strategy needs if
27457 Publish Python Package 20676 deploy apple-notes-to-sqlite 611552758 ubuntu-latest   ["test"]  
27460 Publish Python Package 20678 deploy dogsheep-beta 197431109 ubuntu-latest   ["test"]  
27464 Publish Python Package 20681 deploy evernote-to-sqlite 303218369 ubuntu-latest   ["test"]  
27468 Publish Python Package 20684 deploy github-to-sqlite 207052882 ubuntu-latest   ["test"]  
27472 Publish Python Package 20687 deploy hacker-news-to-sqlite 248903544 ubuntu-latest   ["test"]  
27475 Publish Python Package 20689 deploy healthkit-to-sqlite 197882382 ubuntu-latest   ["test"]  
27478 Publish Python Package 20691 deploy pocket-to-sqlite 213286752 ubuntu-latest   ["test"]  
27481 Publish Python Package 20693 deploy swarm-to-sqlite 205429375 ubuntu-latest   ["test"]  
27484 Publish Python Package 20695 deploy twitter-to-sqlite 206156866 ubuntu-latest   ["test"]  
27488 Deploy latest.datasette.io 20699 deploy datasette 107914493 ubuntu-latest      
27492 Publish Python Package 20702 deploy datasette 107914493 ubuntu-latest   ["test"]  
27505 Publish Python Package 20712 deploy sqlite-utils 140912432 ubuntu-latest   ["test"]  

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