stars
14 rows where "starred_at" is on date 2021-01-20
This data as json, CSV (advanced)
Suggested facets: repo
Link | user | repo | starred_at |
---|---|---|---|
58662,107914493 | amitu 58662 | datasette 107914493 | 2021-01-20T10:57:29Z |
106825,140912432 | opexxx 106825 | sqlite-utils 140912432 | 2021-01-20T21:31:57Z |
140869,140912432 | chandmk 140869 | sqlite-utils 140912432 | 2021-01-20T15:45:22Z |
150135,107914493 | bnadland 150135 | datasette 107914493 | 2021-01-20T13:22:41Z |
2817811,197431109 | gyger 2817811 | dogsheep-beta 197431109 | 2021-01-20T08:52:06Z |
3671624,107914493 | jonesberg 3671624 | datasette 107914493 | 2021-01-20T14:27:35Z |
4434603,107914493 | Baoqi 4434603 | datasette 107914493 | 2021-01-20T15:59:48Z |
5052636,107914493 | ixcviw7bw 5052636 | datasette 107914493 | 2021-01-20T19:49:28Z |
7883396,107914493 | jamwine 7883396 | datasette 107914493 | 2021-01-20T21:31:35Z |
17103888,107914493 | TheAndrewJackson 17103888 | datasette 107914493 | 2021-01-20T14:30:12Z |
19284077,107914493 | AnttiHaerkoenen 19284077 | datasette 107914493 | 2021-01-20T10:36:15Z |
23000671,107914493 | noufalsalim 23000671 | datasette 107914493 | 2021-01-20T05:07:35Z |
52290376,206156866 | TarjMecwan 52290376 | twitter-to-sqlite 206156866 | 2021-01-20T04:47:26Z |
57777521,107914493 | ConradSollitt 57777521 | datasette 107914493 | 2021-01-20T23:08:05Z |
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]);