steps
7 rows where with = "{"python-version": "3.9"}"
This data as json, CSV (advanced)
id ▼ | seq | job | repo | uses | name | with | run | env | if |
---|---|---|---|---|---|---|---|---|---|
136853 | 2 | deploy 27464 | evernote-to-sqlite 303218369 | actions/setup-python@v2 | Set up Python | {"python-version": "3.9"} | |||
136863 | 2 | scheduled 27466 | github-to-sqlite 207052882 | actions/setup-python@v1 | Set up Python | {"python-version": "3.9"} | |||
136897 | 2 | deploy 27472 | hacker-news-to-sqlite 248903544 | actions/setup-python@v2 | Set up Python | {"python-version": "3.9"} | |||
136912 | 2 | deploy 27475 | healthkit-to-sqlite 197882382 | actions/setup-python@v2 | Set up Python | {"python-version": "3.9"} | |||
136951 | 2 | deploy 27484 | twitter-to-sqlite 206156866 | actions/setup-python@v2 | Set up Python | {"python-version": "3.9"} | |||
136968 | 2 | deploy 27488 | datasette 107914493 | actions/setup-python@v4 | Set up Python | {"python-version": "3.9"} | |||
136995 | 2 | deploy_static_docs 27493 | datasette 107914493 | actions/setup-python@v2 | Set up Python | {"python-version": "3.9"} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [steps] ( [id] INTEGER PRIMARY KEY, [seq] INTEGER, [job] INTEGER REFERENCES [jobs]([id]), [repo] INTEGER REFERENCES [repos]([id]), [uses] TEXT, [name] TEXT, [with] TEXT, [run] TEXT , [env] TEXT, [if] TEXT); CREATE INDEX [idx_steps_repo] ON [steps] ([repo]); CREATE INDEX [idx_steps_job] ON [steps] ([job]);