jobs

Table actions

54 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ workflow name repo runs-on strategy needs if
26772 Mirror "master" and "main" branches 20160 mirror datasette 107914493 ubuntu-latest      
27827 Publish Python Package 20956 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27828 Publish Python Package 20956 deploy apple-notes-to-sqlite 611552758 ubuntu-latest   ["test"]  
27829 Test 20957 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27830 Publish Python Package 20958 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27831 Publish Python Package 20958 deploy dogsheep-beta 197431109 ubuntu-latest   ["test"]  
27832 Test 20959 test dogsheep-beta 197431109 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27833 Python package 20960 build dogsheep-photos 256834907 macos-latest {"matrix": {"python-version": [3.7, 3.8]}}    
27834 Publish Python Package 20961 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27835 Publish Python Package 20961 deploy evernote-to-sqlite 303218369 ubuntu-latest   ["test"]  
27836 Test 20962 test evernote-to-sqlite 303218369 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27837 Build and deploy demo 20963 scheduled github-to-sqlite 207052882 ubuntu-latest      
27838 Publish Python Package 20964 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27839 Publish Python Package 20964 deploy github-to-sqlite 207052882 ubuntu-latest   ["test"]  
27840 Update README table of contents 20965 build github-to-sqlite 207052882 ubuntu-latest      
27841 Test 20966 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27842 Publish Python Package 20967 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27843 Publish Python Package 20967 deploy hacker-news-to-sqlite 248903544 ubuntu-latest   ["test"]  
27844 Test 20968 test hacker-news-to-sqlite 248903544 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27845 Publish Python Package 20969 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27846 Publish Python Package 20969 deploy healthkit-to-sqlite 197882382 ubuntu-latest   ["test"]  
27847 Test 20970 test healthkit-to-sqlite 197882382 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27848 Publish Python Package 20971 test pocket-to-sqlite 213286752 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27849 Publish Python Package 20971 deploy pocket-to-sqlite 213286752 ubuntu-latest   ["test"]  
27850 Test 20972 test pocket-to-sqlite 213286752 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27851 Publish Python Package 20973 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27852 Publish Python Package 20973 deploy swarm-to-sqlite 205429375 ubuntu-latest   ["test"]  
27853 Test 20974 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27854 Publish Python Package 20975 test twitter-to-sqlite 206156866 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27855 Publish Python Package 20975 deploy twitter-to-sqlite 206156866 ubuntu-latest   ["test"]  
27856 Update README table of contents 20976 build twitter-to-sqlite 206156866 ubuntu-latest      
27857 Test 20977 test twitter-to-sqlite 206156866 ubuntu-latest {"matrix": {"python-version": [3.6, 3.7, 3.8, 3.9]}}    
27858 Deploy a Datasette branch preview to Vercel 20978 deploy-branch-preview datasette 107914493 ubuntu-latest      
27859 Deploy latest.datasette.io 20979 deploy datasette 107914493 ubuntu-latest      
27860 Read the Docs Pull Request Preview 20980 documentation-links datasette 107914493 ubuntu-latest      
27861 Check JavaScript for conformance with Prettier 20981 prettier datasette 107914493 ubuntu-latest      
27862 Publish Python Package 20982 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27863 Publish Python Package 20982 deploy datasette 107914493 ubuntu-latest   ["test"]  
27864 Publish Python Package 20982 deploy_static_docs datasette 107914493 ubuntu-latest   ["deploy"] !github.event.release.prerelease
27865 Publish Python Package 20982 deploy_docker datasette 107914493 ubuntu-latest   ["deploy"] !github.event.release.prerelease
27866 Push specific Docker tag 20983 deploy_docker datasette 107914493 ubuntu-latest      
27867 Check spelling in documentation 20984 spellcheck datasette 107914493 ubuntu-latest      
27868 Calculate test coverage 20985 test datasette 107914493 ubuntu-latest      
27869 Test in Pyodide with shot-scraper 20986 test datasette 107914493 ubuntu-latest      
27870 Test 20987 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11", "3.12"]}}    
27871 tmate session mac 20988 build datasette 107914493 macos-latest      
27872 tmate session 20989 build datasette 107914493 ubuntu-latest      
27873 CodeQL 20990 Analyze sqlite-utils 140912432 ubuntu-latest {"fail-fast": false, "matrix": {"language": ["python"]}}    
27874 Read the Docs Pull Request Preview 20991 documentation-links sqlite-utils 140912432 ubuntu-latest      
27875 Publish Python Package 20992 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11", "3.12"], "os": ["ubuntu-latest", "windows-latest", "macos-latest"]}}    
27876 Publish Python Package 20992 deploy sqlite-utils 140912432 ubuntu-latest   ["test"]  
27877 Check spelling in documentation 20993 spellcheck sqlite-utils 140912432 ubuntu-latest      
27878 Calculate test coverage 20994 test sqlite-utils 140912432 ubuntu-latest      
27879 Test 20995 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11", "3.12"], "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]);