31 rows

View and edit SQL

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

id ▼ workflow name repo runs-on strategy needs if
1148 Publish Python Package 852 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8]}}    
1149 Publish Python Package 852 deploy dogsheep-beta 197431109 ubuntu-latest   ["test"]  
1150 Test 853 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8]}}    
1151 Python package 854 build dogsheep-photos 256834907 macos-latest {"matrix": {"python-version": [3.7, 3.8]}}    
1152 Publish Python Package 855 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1153 Publish Python Package 855 deploy evernote-to-sqlite 303218369 ubuntu-latest   ["test"]  
1154 Test 856 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1155 Build and deploy demo 857 scheduled github-to-sqlite 207052882 ubuntu-latest      
1156 Publish Python Package 858 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1157 Publish Python Package 858 deploy github-to-sqlite 207052882 ubuntu-latest   ["test"]  
1158 Update README table of contents 859 build github-to-sqlite 207052882 ubuntu-latest      
1159 Test 860 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1160 Publish Python Package 861 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1161 Publish Python Package 861 deploy healthkit-to-sqlite 197882382 ubuntu-latest   ["test"]  
1162 Test 862 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1163 Publish Python Package 863 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1164 Publish Python Package 863 deploy swarm-to-sqlite 205429375 ubuntu-latest   ["test"]  
1165 Test 864 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1166 Update README table of contents 865 build twitter-to-sqlite 206156866 ubuntu-latest      
1167 Deploy latest.datasette.io 866 deploy datasette 107914493 ubuntu-latest      
1168 Mirror "master" and "main" branches 867 mirror datasette 107914493 ubuntu-latest      
1169 Publish Python Package 868 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1170 Publish Python Package 868 deploy datasette 107914493 ubuntu-latest   ["test"]  
1171 Publish Python Package 868 deploy_docker datasette 107914493 ubuntu-latest   ["deploy"] !github.event.release.prerelease
1172 Calculate test coverage 869 test datasette 107914493 ubuntu-latest      
1173 Test 870 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1174 tmate session 871 build datasette 107914493 ubuntu-latest      
1175 CodeQL 872 Analyze sqlite-utils 140912432 ubuntu-latest {"fail-fast": false, "matrix": {"language": ["python"]}}    
1176 Publish Python Package 873 test sqlite-utils 140912432 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
1177 Publish Python Package 873 deploy sqlite-utils 140912432 ubuntu-latest   ["test"]  
1178 Test 874 test sqlite-utils 140912432 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9], "numpy": [0, 1]}}    

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