jobs

Table actions

25 rows where name = "test"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, runs-on, strategy

id ▼ workflow name repo runs-on strategy needs if
27456 Publish Python Package 20676 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27458 Test 20677 test apple-notes-to-sqlite 611552758 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
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]}}    
27467 Publish Python Package 20684 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27470 Test 20686 test github-to-sqlite 207052882 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
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]}}    
27477 Publish Python Package 20691 test pocket-to-sqlite 213286752 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27479 Test 20692 test pocket-to-sqlite 213286752 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27480 Publish Python Package 20693 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
27482 Test 20694 test swarm-to-sqlite 205429375 ubuntu-latest {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"]}}    
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]}}    
27491 Publish Python Package 20702 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27497 Calculate test coverage 20705 test datasette 107914493 ubuntu-latest      
27498 Test in Pyodide with shot-scraper 20706 test datasette 107914493 ubuntu-latest      
27499 Test 20707 test datasette 107914493 ubuntu-latest {"matrix": {"python-version": ["3.8", "3.9", "3.10", "3.11"]}}    
27504 Publish Python Package 20712 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"], "os": ["ubuntu-latest", "windows-latest", "macos-latest"]}}    
27507 Calculate test coverage 20714 test sqlite-utils 140912432 ubuntu-latest      
27508 Test 20715 test sqlite-utils 140912432 ${{ matrix.os }} {"matrix": {"python-version": ["3.7", "3.8", "3.9", "3.10", "3.11"], "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]);