stars
9 rows where "starred_at" is on date 2022-03-29
This data as json, CSV (advanced)
Suggested facets: repo
Link | user | repo | starred_at |
---|---|---|---|
3464,140912432 | sneeu 3464 | sqlite-utils 140912432 | 2022-03-29T13:26:44Z |
93906,140912432 | filippog 93906 | sqlite-utils 140912432 | 2022-03-29T11:56:32Z |
1192302,107914493 | magoni 1192302 | datasette 107914493 | 2022-03-29T19:51:58Z |
5902731,107914493 | rickybassom 5902731 | datasette 107914493 | 2022-03-29T01:04:37Z |
10400095,107914493 | Moskovych 10400095 | datasette 107914493 | 2022-03-29T08:22:13Z |
26397813,107914493 | leoangelovb 26397813 | datasette 107914493 | 2022-03-29T22:19:59Z |
40823190,107914493 | taught1 40823190 | datasette 107914493 | 2022-03-29T03:06:41Z |
44169726,107914493 | cnf-clark 44169726 | datasette 107914493 | 2022-03-29T17:11:45Z |
59284036,107914493 | jagatiyakeval 59284036 | datasette 107914493 | 2022-03-29T09:43:32Z |
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]);