37 rows

View and edit SQL

Suggested facets: workflow, name, repo, runs-on, strategy, needs, needs (array)

id ▼ workflow name repo runs-on strategy needs if
6411 Publish Python Package 4830 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8]}}    
6412 Publish Python Package 4830 deploy dogsheep-beta 197431109 ubuntu-latest   ["test"]  
6413 Test 4831 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8]}}    
6414 Python package 4832 build dogsheep-photos 256834907 macos-latest {"matrix": {"python-version": [3.7, 3.8]}}    
6415 Publish Python Package 4833 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6416 Publish Python Package 4833 deploy evernote-to-sqlite 303218369 ubuntu-latest   ["test"]  
6417 Test 4834 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6418 Build and deploy demo 4835 scheduled github-to-sqlite 207052882 ubuntu-latest      
6419 Publish Python Package 4836 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6420 Publish Python Package 4836 deploy github-to-sqlite 207052882 ubuntu-latest   ["test"]  
6421 Update README table of contents 4837 build github-to-sqlite 207052882 ubuntu-latest      
6422 Test 4838 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6423 Publish Python Package 4839 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6424 Publish Python Package 4839 deploy hacker-news-to-sqlite 248903544 ubuntu-latest   ["test"]  
6425 Test 4840 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6426 Publish Python Package 4841 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6427 Publish Python Package 4841 deploy healthkit-to-sqlite 197882382 ubuntu-latest   ["test"]  
6428 Test 4842 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6429 Publish Python Package 4843 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6430 Publish Python Package 4843 deploy swarm-to-sqlite 205429375 ubuntu-latest   ["test"]  
6431 Test 4844 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6432 Update README table of contents 4845 build twitter-to-sqlite 206156866 ubuntu-latest      
6433 Deploy latest.datasette.io 4846 deploy datasette 107914493 ubuntu-latest      
6434 Mirror "master" and "main" branches 4847 mirror datasette 107914493 ubuntu-latest      
6435 Check JavaScript for conformance with Prettier 4848 prettier datasette 107914493 ubuntu-latest      
6436 Publish Python Package 4849 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6437 Publish Python Package 4849 deploy datasette 107914493 ubuntu-latest   ["test"]  
6438 Publish Python Package 4849 deploy_docker datasette 107914493 ubuntu-latest   ["deploy"] !github.event.release.prerelease
6439 Push specific Docker tag 4850 deploy_docker datasette 107914493 ubuntu-latest      
6440 Calculate test coverage 4851 test datasette 107914493 ubuntu-latest      
6441 Test 4852 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
6442 tmate session mac 4853 build datasette 107914493 macos-latest      
6443 tmate session 4854 build datasette 107914493 ubuntu-latest      
6444 CodeQL 4855 Analyze sqlite-utils 140912432 ubuntu-latest {"fail-fast": false, "matrix": {"language": ["python"]}}    
6445 Publish Python Package 4856 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9], "os": ["ubuntu-latest", "macos-latest", "windows-latest"]}}    
6446 Publish Python Package 4856 deploy sqlite-utils 140912432 ubuntu-latest   ["test"]  
6447 Test 4857 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9], "numpy": [0, 1], "os": ["ubuntu-latest", "macos-latest", "windows-latest"]}}    

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