stars
12 rows where repo = 107914493 and "starred_at" is on date 2022-04-27 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
129,107914493 | canadaduane 129 | datasette 107914493 | 2022-04-27T17:40:51Z |
90166,107914493 | jamaa 90166 | datasette 107914493 | 2022-04-27T07:34:59Z |
128459,107914493 | venthur 128459 | datasette 107914493 | 2022-04-27T06:41:03Z |
165352,107914493 | elzoona 165352 | datasette 107914493 | 2022-04-27T12:22:45Z |
391975,107914493 | kud1ing 391975 | datasette 107914493 | 2022-04-27T05:38:46Z |
1298447,107914493 | cyroxx 1298447 | datasette 107914493 | 2022-04-27T06:05:45Z |
2666848,107914493 | Joshhua5 2666848 | datasette 107914493 | 2022-04-27T17:28:16Z |
4307346,107914493 | k-ni-ght 4307346 | datasette 107914493 | 2022-04-27T08:22:40Z |
6467403,107914493 | sydbarrett74 6467403 | datasette 107914493 | 2022-04-27T04:51:40Z |
40243568,107914493 | mvkvc 40243568 | datasette 107914493 | 2022-04-27T14:47:49Z |
54773003,107914493 | saumilvachheta 54773003 | datasette 107914493 | 2022-04-27T19:11:03Z |
92313710,107914493 | oms-josh 92313710 | datasette 107914493 | 2022-04-27T10:44:19Z |
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]);