stars
14 rows where repo = 107914493 and "starred_at" is on date 2023-01-19
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
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 |
7922764,107914493 | Eugenio-Liso 7922764 | datasette 107914493 | 2023-01-19T21:07:48Z |
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]);