home / github

Menu
  • GraphQL API

stars

Table actions
  • GraphQL API for stars

21 rows where repo = 107914493 and "starred_at" is on date 2018-01-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: starred_at (date)

Link user repo starred_at
2882,107914493 nikolay 2882 datasette 107914493 2018-01-18T06:23:07Z
6383,107914493 rpdillon 6383 datasette 107914493 2018-01-18T00:02:41Z
17369,107914493 ericdaniel 17369 datasette 107914493 2018-01-18T00:32:55Z
41784,107914493 lzl 41784 datasette 107914493 2018-01-18T04:47:09Z
79637,107914493 chupy 79637 datasette 107914493 2018-01-18T15:29:06Z
204856,107914493 yazz 204856 datasette 107914493 2018-01-18T09:35:09Z
813449,107914493 rogersmarin 813449 datasette 107914493 2018-01-18T00:25:01Z
821567,107914493 assertnotnull 821567 datasette 107914493 2018-01-18T18:39:30Z
876213,107914493 bobspecht 876213 datasette 107914493 2018-01-18T03:49:25Z
1232007,107914493 leleu 1232007 datasette 107914493 2018-01-18T00:11:55Z
1482374,107914493 Code-Slave 1482374 datasette 107914493 2018-01-18T17:47:25Z
1508770,107914493 DanielBerns 1508770 datasette 107914493 2018-01-18T21:14:49Z
2148847,107914493 jshook 2148847 datasette 107914493 2018-01-18T18:49:58Z
2241459,107914493 bboydflo 2241459 datasette 107914493 2018-01-18T09:27:08Z
3342274,107914493 eli-oat 3342274 datasette 107914493 2018-01-18T02:08:03Z
4564911,107914493 jay-johnson 4564911 datasette 107914493 2018-01-18T00:06:59Z
5072613,107914493 derhuerst 5072613 datasette 107914493 2018-01-18T18:16:28Z
6948067,107914493 pranavlathigara 6948067 datasette 107914493 2018-01-18T09:41:42Z
8080555,107914493 Xzya 8080555 datasette 107914493 2018-01-18T19:05:54Z
11148454,107914493 LazerJesus 11148454 datasette 107914493 2018-01-18T20:19:16Z
12777558,107914493 iainmwallace 12777558 datasette 107914493 2018-01-18T14:27:58Z

Advanced export

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

CSV options:

CREATE TABLE [stars] (
   [user] INTEGER REFERENCES [users]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [starred_at] TEXT,
   PRIMARY KEY ([user], [repo])
);
CREATE INDEX [idx_stars_repo]
                ON [stars] ([repo]);
CREATE INDEX [idx_stars_user]
                ON [stars] ([user]);
Powered by Datasette · Queries took 297.736ms · About: simonw/datasette-graphql