stars
21 rows where repo = 107914493 and "starred_at" is on date 2021-02-22 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
12680,107914493 | Chaz6 12680 | datasette 107914493 | 2021-02-22T09:47:32Z |
72300,107914493 | mastre 72300 | datasette 107914493 | 2021-02-22T02:19:25Z |
92361,107914493 | herberthamaral 92361 | datasette 107914493 | 2021-02-22T14:14:57Z |
107426,107914493 | metoikos 107426 | datasette 107914493 | 2021-02-22T08:54:53Z |
143435,107914493 | svieira 143435 | datasette 107914493 | 2021-02-22T03:20:08Z |
609557,107914493 | shawkinaw 609557 | datasette 107914493 | 2021-02-22T13:21:18Z |
1238202,107914493 | kmanley 1238202 | datasette 107914493 | 2021-02-22T03:04:22Z |
1707033,107914493 | dalberto 1707033 | datasette 107914493 | 2021-02-22T02:28:32Z |
2847328,107914493 | Systemcluster 2847328 | datasette 107914493 | 2021-02-22T04:38:51Z |
3778937,107914493 | oandrew 3778937 | datasette 107914493 | 2021-02-22T01:04:38Z |
5426147,107914493 | thekitp 5426147 | datasette 107914493 | 2021-02-22T05:40:33Z |
5678247,107914493 | ryantate13 5678247 | datasette 107914493 | 2021-02-22T03:19:15Z |
6937141,107914493 | zmzhang 6937141 | datasette 107914493 | 2021-02-22T00:58:58Z |
7682807,107914493 | pouloum 7682807 | datasette 107914493 | 2021-02-22T12:16:59Z |
8878983,107914493 | brunurb 8878983 | datasette 107914493 | 2021-02-22T22:59:38Z |
10776269,107914493 | matuskosut 10776269 | datasette 107914493 | 2021-02-22T14:23:08Z |
25322884,107914493 | guillemcortes 25322884 | datasette 107914493 | 2021-02-22T12:14:33Z |
26148700,107914493 | samuspaa 26148700 | datasette 107914493 | 2021-02-22T17:42:26Z |
59277414,107914493 | qeet 59277414 | datasette 107914493 | 2021-02-22T10:12:59Z |
68716630,107914493 | danskycode 68716630 | datasette 107914493 | 2021-02-22T23:00:54Z |
73920147,107914493 | fliptoshi 73920147 | datasette 107914493 | 2021-02-22T00:05:08Z |
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]);