stars
87 rows where "starred_at" is on date 2017-11-16
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
12577046,107914493 | santoshgistto 12577046 | datasette 107914493 | 2017-11-16T10:01:34Z |
13808299,107914493 | gauravssnl 13808299 | datasette 107914493 | 2017-11-16T17:13:18Z |
14168642,107914493 | alanmarazzi 14168642 | datasette 107914493 | 2017-11-16T16:40:50Z |
16705366,107914493 | sooxin 16705366 | datasette 107914493 | 2017-11-16T10:18:49Z |
16959528,107914493 | unreal0 16959528 | datasette 107914493 | 2017-11-16T03:05:06Z |
18056710,107914493 | audoralc 18056710 | datasette 107914493 | 2017-11-16T00:56:41Z |
20240109,107914493 | spiderings 20240109 | datasette 107914493 | 2017-11-16T02:10:22Z |
20506046,107914493 | Eggwise 20506046 | datasette 107914493 | 2017-11-16T08:10:43Z |
23313992,107914493 | jeanmidevacc 23313992 | datasette 107914493 | 2017-11-16T09:35:02Z |
24830380,107914493 | sondregj 24830380 | datasette 107914493 | 2017-11-16T09:54:26Z |
30057178,107914493 | pyojo 30057178 | datasette 107914493 | 2017-11-16T13:42:10Z |
31338740,107914493 | henninglebbaeus 31338740 | datasette 107914493 | 2017-11-16T09:45:30Z |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);