pull_requests

Table actions

2 rows where user = 2129

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

id ▼ node_id number state locked title user body created_at updated_at closed_at merged_at merge_commit_sha assignee milestone draft head base author_association repo url merged_by auto_merge
727390835 MDExOlB1bGxSZXF1ZXN0NzI3MzkwODM1 36 open 0 Correct naming of tool in readme badboy 2129   2021-09-05T12:05:40Z 2022-01-06T16:04:46Z     358678c6b48072769f2985fe6be8fc5e54ed2e06     0 bf26955c250e601a0d9e751311530940b704f81e edc80a0d361006f478f2904a90bfe6c730ed6194 FIRST_TIME_CONTRIBUTOR dogsheep-photos 256834907 https://github.com/dogsheep/dogsheep-photos/pull/36    
1182000455 PR_kwDOC8tyDs5Gc-VH 23 open 0 Include workout statistics badboy 2129 Not sure when this changed (iOS 16 maybe?), but the `WorkoutStatistics` now has a whole bunch of information about workouts, e.g. for runs it contains the distance (as a `<WorkoutStatistics type="HKQuantityTypeIdentifierDistanceWalkingRunning ...>` element). Adding it as another column at leat allows me to pull these out (using SQLite's JSON support). I'm running with this patch on my own data now. 2023-01-01T17:29:56Z 2023-01-01T17:29:57Z     e0ad45055f363810085119f26df87a6804451056     0 d5b9e3609961515cc52bcc5ef070e3b83b473339 9fe3cb17e03d6c73222b63e643638cf951567c4c FIRST_TIME_CONTRIBUTOR healthkit-to-sqlite 197882382 https://github.com/dogsheep/healthkit-to-sqlite/pull/23    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [pull_requests] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [number] INTEGER,
   [state] TEXT,
   [locked] INTEGER,
   [title] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [body] TEXT,
   [created_at] TEXT,
   [updated_at] TEXT,
   [closed_at] TEXT,
   [merged_at] TEXT,
   [merge_commit_sha] TEXT,
   [assignee] INTEGER REFERENCES [users]([id]),
   [milestone] INTEGER REFERENCES [milestones]([id]),
   [draft] INTEGER,
   [head] TEXT,
   [base] TEXT,
   [author_association] TEXT,
   [repo] INTEGER REFERENCES [repos]([id]),
   [url] TEXT,
   [merged_by] INTEGER REFERENCES [users]([id])
, [auto_merge] TEXT);
CREATE INDEX [idx_pull_requests_merged_by]
    ON [pull_requests] ([merged_by]);
CREATE INDEX [idx_pull_requests_repo]
    ON [pull_requests] ([repo]);
CREATE INDEX [idx_pull_requests_milestone]
    ON [pull_requests] ([milestone]);
CREATE INDEX [idx_pull_requests_assignee]
    ON [pull_requests] ([assignee]);
CREATE INDEX [idx_pull_requests_user]
    ON [pull_requests] ([user]);