stars
18 rows where "starred_at" is on date 2023-01-29
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
22850,107914493 | countnazgul 22850 | datasette 107914493 | 2023-01-29T19:00:17Z |
481465,107914493 | frangio 481465 | datasette 107914493 | 2023-01-29T03:13:20Z |
700518,107914493 | pklinef 700518 | datasette 107914493 | 2023-01-29T20:27:20Z |
1168026,107914493 | jotson 1168026 | datasette 107914493 | 2023-01-29T15:00:44Z |
1373593,107914493 | vasusen 1373593 | datasette 107914493 | 2023-01-29T22:02:25Z |
2181306,107914493 | oskareke 2181306 | datasette 107914493 | 2023-01-29T09:03:08Z |
2991389,107914493 | codeanpeace 2991389 | datasette 107914493 | 2023-01-29T01:16:22Z |
3365089,107914493 | mintpi 3365089 | datasette 107914493 | 2023-01-29T01:17:09Z |
4821190,107914493 | scerelli 4821190 | datasette 107914493 | 2023-01-29T02:05:37Z |
7085437,107914493 | knox-carl 7085437 | datasette 107914493 | 2023-01-29T05:54:52Z |
8211411,107914493 | bsenst 8211411 | datasette 107914493 | 2023-01-29T11:36:51Z |
11981528,107914493 | bitseer 11981528 | datasette 107914493 | 2023-01-29T19:24:29Z |
20302825,107914493 | thevahidal 20302825 | datasette 107914493 | 2023-01-29T12:13:40Z |
49921489,107914493 | natanielf 49921489 | datasette 107914493 | 2023-01-29T06:07:22Z |
69171871,107914493 | andrea-berardi 69171871 | datasette 107914493 | 2023-01-29T10:56:51Z |
70492091,107914493 | errantsky 70492091 | datasette 107914493 | 2023-01-29T05:39:05Z |
75775527,107914493 | abhinav4201 75775527 | datasette 107914493 | 2023-01-29T07:20:26Z |
93238466,107914493 | daiwanwei 93238466 | datasette 107914493 | 2023-01-29T07:07:42Z |
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]);