stars
45 rows where "starred_at" is on date 2023-04-13
This data as json, CSV (advanced)
repo 2 ✖
- datasette 18
- sqlite-utils 1
Link | user | repo | starred_at |
---|---|---|---|
11518677,107914493 | matdmiller 11518677 | datasette 107914493 | 2023-04-13T03:56:44Z |
12200541,107914493 | davidcortesortuno 12200541 | datasette 107914493 | 2023-04-13T15:30:48Z |
12343599,107914493 | twiccox 12343599 | datasette 107914493 | 2023-04-13T07:57:12Z |
14010939,140912432 | Nanguage 14010939 | sqlite-utils 140912432 | 2023-04-13T01:17:42Z |
14073964,107914493 | namob 14073964 | datasette 107914493 | 2023-04-13T09:34:24Z |
15463126,107914493 | isimic95 15463126 | datasette 107914493 | 2023-04-13T17:11:00Z |
19303690,107914493 | lalitpagaria 19303690 | datasette 107914493 | 2023-04-13T04:40:15Z |
20910163,107914493 | AdjectiveAllison 20910163 | datasette 107914493 | 2023-04-13T13:32:47Z |
22048962,107914493 | gaileyleseman 22048962 | datasette 107914493 | 2023-04-13T11:14:29Z |
24412384,107914493 | sderev 24412384 | datasette 107914493 | 2023-04-13T00:23:10Z |
30412947,107914493 | Tweezii 30412947 | datasette 107914493 | 2023-04-13T00:45:47Z |
50575574,107914493 | gregskupien 50575574 | datasette 107914493 | 2023-04-13T08:22:29Z |
51956960,107914493 | astrogewgaw 51956960 | datasette 107914493 | 2023-04-13T14:14:47Z |
53521052,107914493 | arioboo 53521052 | datasette 107914493 | 2023-04-13T15:33:39Z |
57741163,107914493 | dkt101 57741163 | datasette 107914493 | 2023-04-13T15:27:46Z |
63288367,107914493 | MatteoNeta 63288367 | datasette 107914493 | 2023-04-13T14:36:18Z |
70793814,107914493 | jeaguil 70793814 | datasette 107914493 | 2023-04-13T14:24:08Z |
92061050,107914493 | Punkwe1ght 92061050 | datasette 107914493 | 2023-04-13T17:14:34Z |
102969362,107914493 | 87113 102969362 | datasette 107914493 | 2023-04-13T16:05:54Z |
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]);