stars
21 rows where "starred_at" is on date 2022-04-27 sorted by user
This data as json, CSV (advanced)
Suggested facets: user
repo 7 ✖
Link | user ▼ | repo | starred_at |
---|---|---|---|
129,107914493 | canadaduane 129 | datasette 107914493 | 2022-04-27T17:40:51Z |
90166,107914493 | jamaa 90166 | datasette 107914493 | 2022-04-27T07:34:59Z |
128459,107914493 | venthur 128459 | datasette 107914493 | 2022-04-27T06:41:03Z |
165352,107914493 | elzoona 165352 | datasette 107914493 | 2022-04-27T12:22:45Z |
290948,207052882 | tmshv 290948 | github-to-sqlite 207052882 | 2022-04-27T14:33:44Z |
304786,140912432 | kinow 304786 | sqlite-utils 140912432 | 2022-04-27T08:48:57Z |
391975,107914493 | kud1ing 391975 | datasette 107914493 | 2022-04-27T05:38:46Z |
961871,256834907 | tphummel 961871 | dogsheep-photos 256834907 | 2022-04-27T15:59:30Z |
961871,197882382 | tphummel 961871 | healthkit-to-sqlite 197882382 | 2022-04-27T15:58:38Z |
961871,205429375 | tphummel 961871 | swarm-to-sqlite 205429375 | 2022-04-27T15:57:02Z |
961871,206156866 | tphummel 961871 | twitter-to-sqlite 206156866 | 2022-04-27T15:57:33Z |
1148218,197882382 | mbutsko 1148218 | healthkit-to-sqlite 197882382 | 2022-04-27T09:34:43Z |
1298447,107914493 | cyroxx 1298447 | datasette 107914493 | 2022-04-27T06:05:45Z |
2666848,107914493 | Joshhua5 2666848 | datasette 107914493 | 2022-04-27T17:28:16Z |
4307346,107914493 | k-ni-ght 4307346 | datasette 107914493 | 2022-04-27T08:22:40Z |
6467403,107914493 | sydbarrett74 6467403 | datasette 107914493 | 2022-04-27T04:51:40Z |
20137484,140912432 | hp4k1h5 20137484 | sqlite-utils 140912432 | 2022-04-27T16:58:13Z |
30274190,140912432 | sadielbartholomew 30274190 | sqlite-utils 140912432 | 2022-04-27T12:21:07Z |
40243568,107914493 | mvkvc 40243568 | datasette 107914493 | 2022-04-27T14:47:49Z |
54773003,107914493 | saumilvachheta 54773003 | datasette 107914493 | 2022-04-27T19:11:03Z |
92313710,107914493 | oms-josh 92313710 | datasette 107914493 | 2022-04-27T10:44:19Z |
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]);