home / github

Menu
  • GraphQL API

stars

Table actions
  • GraphQL API for stars

27 rows where "starred_at" is on date 2017-11-21

✎ View and edit SQL

This data as json, CSV (advanced)

starred_at (date) 1 ✖

  • 2017-11-21 · 27 ✖

repo 1 ✖

  • datasette 27
Link user repo starred_at
11256,107914493 copiousfreetime 11256 datasette 107914493 2017-11-21T18:22:05Z
93241,107914493 michaelsmanley 93241 datasette 107914493 2017-11-21T18:48:50Z
117813,107914493 xeonarno 117813 datasette 107914493 2017-11-21T13:05:23Z
153502,107914493 jcambien 153502 datasette 107914493 2017-11-21T08:17:21Z
192655,107914493 opt9 192655 datasette 107914493 2017-11-21T00:45:53Z
194032,107914493 boostventilator 194032 datasette 107914493 2017-11-21T18:51:30Z
248267,107914493 ecylmz 248267 datasette 107914493 2017-11-21T09:15:00Z
271298,107914493 keefmoon 271298 datasette 107914493 2017-11-21T23:42:50Z
422815,107914493 mgacy 422815 datasette 107914493 2017-11-21T18:42:00Z
737729,107914493 avetisk 737729 datasette 107914493 2017-11-21T23:49:51Z
756373,107914493 irudi 756373 datasette 107914493 2017-11-21T14:44:49Z
896478,107914493 axhixh 896478 datasette 107914493 2017-11-21T02:57:20Z
2424724,107914493 sebabeva 2424724 datasette 107914493 2017-11-21T03:16:18Z
2937272,107914493 hardliner66 2937272 datasette 107914493 2017-11-21T12:38:04Z
3755139,107914493 FadedWeiss 3755139 datasette 107914493 2017-11-21T02:50:38Z
4105507,107914493 ghostgzt 4105507 datasette 107914493 2017-11-21T12:45:52Z
5788790,107914493 gunesacar 5788790 datasette 107914493 2017-11-21T02:39:04Z
6391516,107914493 vndrewlee 6391516 datasette 107914493 2017-11-21T18:40:10Z
7608904,107914493 jameslamb 7608904 datasette 107914493 2017-11-21T06:32:50Z
7645532,107914493 genesem 7645532 datasette 107914493 2017-11-21T07:22:46Z
8255034,107914493 codesoon 8255034 datasette 107914493 2017-11-21T00:02:06Z
8318747,107914493 zeromake 8318747 datasette 107914493 2017-11-21T03:52:11Z
17456182,107914493 optimalstrategy 17456182 datasette 107914493 2017-11-21T06:48:23Z
18135213,107914493 tomysaman 18135213 datasette 107914493 2017-11-21T23:13:50Z
18431775,107914493 james-cain 18431775 datasette 107914493 2017-11-21T16:13:44Z
22281127,107914493 AndrewMlamba 22281127 datasette 107914493 2017-11-21T08:06:05Z
23209985,107914493 goforward01 23209985 datasette 107914493 2017-11-21T01:35:56Z

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 45.559ms · About: simonw/datasette-graphql