stars
17 rows where "starred_at" is on date 2023-01-19 sorted by user
This data as json, CSV (advanced)
Suggested facets: repo
Link | user ▼ | repo | starred_at |
---|---|---|---|
1571,107914493 | stan 1571 | datasette 107914493 | 2023-01-19T12:46:29Z |
223910,107914493 | dbalan 223910 | datasette 107914493 | 2023-01-19T21:15:15Z |
422437,107914493 | krgn 422437 | datasette 107914493 | 2023-01-19T14:24:34Z |
577424,107914493 | matthewdeanmartin 577424 | datasette 107914493 | 2023-01-19T03:39:55Z |
753891,107914493 | 0xdevalias 753891 | datasette 107914493 | 2023-01-19T23:11:10Z |
2177439,107914493 | shishini 2177439 | datasette 107914493 | 2023-01-19T01:59:06Z |
7886676,140912432 | gbrault 7886676 | sqlite-utils 140912432 | 2023-01-19T07:53:19Z |
7922764,107914493 | Eugenio-Liso 7922764 | datasette 107914493 | 2023-01-19T21:07:48Z |
8401697,140912432 | Yotooon 8401697 | sqlite-utils 140912432 | 2023-01-19T11:37:22Z |
8433809,140912432 | gaoqi7 8433809 | sqlite-utils 140912432 | 2023-01-19T20:18:24Z |
9571936,107914493 | null-dev 9571936 | datasette 107914493 | 2023-01-19T17:08:28Z |
14824422,107914493 | sourcesmith 14824422 | datasette 107914493 | 2023-01-19T08:26:26Z |
17225208,107914493 | keturiosakys 17225208 | datasette 107914493 | 2023-01-19T10:12:54Z |
21299683,107914493 | pjyi2147 21299683 | datasette 107914493 | 2023-01-19T22:21:29Z |
29175668,107914493 | wenyugu 29175668 | datasette 107914493 | 2023-01-19T04:15:52Z |
44367535,107914493 | jnjerin 44367535 | datasette 107914493 | 2023-01-19T08:28:54Z |
91542210,107914493 | mtcogco 91542210 | datasette 107914493 | 2023-01-19T11:24: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]);