stars
11 rows where "starred_at" is on date 2023-06-30 sorted by user
This data as json, CSV (advanced)
Suggested facets: repo
Link | user ▼ | repo | starred_at |
---|---|---|---|
15551,140912432 | voluntas 15551 | sqlite-utils 140912432 | 2023-06-30T14:33:15Z |
374863,107914493 | solrevdev 374863 | datasette 107914493 | 2023-06-30T02:00:13Z |
3945566,107914493 | jus-jus 3945566 | datasette 107914493 | 2023-06-30T11:02:24Z |
7031498,107914493 | Nullcano 7031498 | datasette 107914493 | 2023-06-30T10:54:02Z |
10300271,107914493 | mskian 10300271 | datasette 107914493 | 2023-06-30T04:58:45Z |
30038895,107914493 | HurryUpWb 30038895 | datasette 107914493 | 2023-06-30T09:45:22Z |
37922280,107914493 | fathnakbar 37922280 | datasette 107914493 | 2023-06-30T02:34:19Z |
63093552,107914493 | TomasLei-8 63093552 | datasette 107914493 | 2023-06-30T01:35:14Z |
73450291,107914493 | a877429929 73450291 | datasette 107914493 | 2023-06-30T00:49:51Z |
90471683,107914493 | Imamyahya 90471683 | datasette 107914493 | 2023-06-30T06:37:37Z |
106853815,107914493 | JugaadiTek 106853815 | datasette 107914493 | 2023-06-30T05:03:17Z |
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]);