home / github

Menu
  • GraphQL API

stars

Table actions
  • GraphQL API for stars

24 rows where "starred_at" is on date 2020-11-28

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, repo

starred_at (date) 1 ✖

  • 2020-11-28 · 24 ✖
Link user repo starred_at
11238,107914493 antogerva 11238 datasette 107914493 2020-11-28T20:53:32Z
89019,107914493 matthewturk 89019 datasette 107914493 2020-11-28T19:39:05Z
127824,107914493 zoosky 127824 datasette 107914493 2020-11-28T19:26:35Z
208337,207052882 okket 208337 github-to-sqlite 207052882 2020-11-28T07:16:48Z
246743,107914493 atse 246743 datasette 107914493 2020-11-28T22:44:10Z
370173,107914493 cawlin 370173 datasette 107914493 2020-11-28T05:10:57Z
380000,107914493 AoJ 380000 datasette 107914493 2020-11-28T07:05:25Z
380000,206156866 AoJ 380000 twitter-to-sqlite 206156866 2020-11-28T07:11:08Z
380000,207052882 AoJ 380000 github-to-sqlite 207052882 2020-11-28T07:06:30Z
400311,107914493 xqzhou 400311 datasette 107914493 2020-11-28T00:08:25Z
521097,107914493 pauloxnet 521097 datasette 107914493 2020-11-28T21:50:11Z
697194,107914493 cmaldonadowilson 697194 datasette 107914493 2020-11-28T01:04:58Z
780882,107914493 powerdude 780882 datasette 107914493 2020-11-28T03:57:28Z
1212964,107914493 gorcha 1212964 datasette 107914493 2020-11-28T12:21:22Z
2750442,107914493 recamshak 2750442 datasette 107914493 2020-11-28T23:17:23Z
3451581,107914493 giovannibonetti 3451581 datasette 107914493 2020-11-28T18:23:01Z
4599599,107914493 knguyen0105 4599599 datasette 107914493 2020-11-28T01:01:30Z
7829379,107914493 poudel 7829379 datasette 107914493 2020-11-28T17:22:17Z
12673597,107914493 dlaperriere 12673597 datasette 107914493 2020-11-28T19:17:50Z
14849329,107914493 plluksie 14849329 datasette 107914493 2020-11-28T18:39:30Z
26268125,206156866 rgwood 26268125 twitter-to-sqlite 206156866 2020-11-28T07:46:35Z
34899034,107914493 code86 34899034 datasette 107914493 2020-11-28T01:56:18Z
34899034,140912432 code86 34899034 sqlite-utils 140912432 2020-11-28T01:56:07Z
47585455,107914493 tg-z 47585455 datasette 107914493 2020-11-28T06:04:05Z

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