stars

Table actions

26 rows where "starred_at" is on date 2021-01-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, repo

starred_at (date) 1 ✖

  • 2021-01-06 · 26 ✖
Link user repo starred_at
35616,206156866 jmn 35616 twitter-to-sqlite 206156866 2021-01-06T20:44:17Z
42320,107914493 LaundroMat 42320 datasette 107914493 2021-01-06T19:43:02Z
67420,107914493 atomotic 67420 datasette 107914493 2021-01-06T17:32:26Z
135060,107914493 rcholic 135060 datasette 107914493 2021-01-06T06:06:20Z
1881266,107914493 iamandrewluca 1881266 datasette 107914493 2021-01-06T00:34:52Z
3458013,107914493 Kirushanr 3458013 datasette 107914493 2021-01-06T04:01:32Z
3463291,107914493 zek 3463291 datasette 107914493 2021-01-06T12:48:55Z
4126052,206649770 hharzer 4126052 google-takeout-to-sqlite 206649770 2021-01-06T16:23:38Z
4726180,107914493 oguzhankiyar 4726180 datasette 107914493 2021-01-06T07:04:05Z
4962633,107914493 hussainb 4962633 datasette 107914493 2021-01-06T17:10:54Z
5673050,107914493 manrajgrover 5673050 datasette 107914493 2021-01-06T07:13:20Z
5866487,107914493 emircokdogan 5866487 datasette 107914493 2021-01-06T07:01:22Z
6143029,107914493 the-x-man 6143029 datasette 107914493 2021-01-06T08:02:41Z
7697196,107914493 JonatanSalas 7697196 datasette 107914493 2021-01-06T00:12:08Z
9514280,107914493 gautamchitnis 9514280 datasette 107914493 2021-01-06T04:59:30Z
12918431,107914493 geekodour 12918431 datasette 107914493 2021-01-06T08:44:50Z
13276705,107914493 fourjuaneight 13276705 datasette 107914493 2021-01-06T04:25:51Z
18418010,107914493 NE-SmallTown 18418010 datasette 107914493 2021-01-06T11:43:51Z
22145591,107914493 faustbrian 22145591 datasette 107914493 2021-01-06T11:48:50Z
22399784,107914493 ljungmark 22399784 datasette 107914493 2021-01-06T11:40:11Z
24981282,107914493 maxzzze 24981282 datasette 107914493 2021-01-06T12:23:37Z
24981282,140912432 maxzzze 24981282 sqlite-utils 140912432 2021-01-06T12:35:02Z
33766249,107914493 Azghour-Saad 33766249 datasette 107914493 2021-01-06T11:47:37Z
34790378,107914493 abhijithvijayan 34790378 datasette 107914493 2021-01-06T09:23:44Z
46817541,107914493 ajw998 46817541 datasette 107914493 2021-01-06T22:32:46Z
53739928,107914493 amin-da 53739928 datasette 107914493 2021-01-06T16:36:19Z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);