stars
27 rows where "starred_at" is on date 2020-05-23
This data as json, CSV (advanced)
Suggested facets: user
repo 3 ✖
| Link | user | repo | starred_at |
|---|---|---|---|
| 25777,107914493 | chetan 25777 | datasette 107914493 | 2020-05-23T12:40:37Z |
| 37181,256834907 | tendant 37181 | dogsheep-photos 256834907 | 2020-05-23T00:56:08Z |
| 58814,256834907 | bhy 58814 | dogsheep-photos 256834907 | 2020-05-23T07:00:36Z |
| 70727,256834907 | waako 70727 | dogsheep-photos 256834907 | 2020-05-23T10:50:02Z |
| 94963,256834907 | estherbester 94963 | dogsheep-photos 256834907 | 2020-05-23T06:43:39Z |
| 104565,256834907 | yifan 104565 | dogsheep-photos 256834907 | 2020-05-23T15:07:08Z |
| 125546,107914493 | johnthethird 125546 | datasette 107914493 | 2020-05-23T15:46:35Z |
| 152635,256834907 | jkatzer 152635 | dogsheep-photos 256834907 | 2020-05-23T03:14:44Z |
| 185004,256834907 | RSully 185004 | dogsheep-photos 256834907 | 2020-05-23T02:06:58Z |
| 205631,107914493 | reiv 205631 | datasette 107914493 | 2020-05-23T01:29:03Z |
| 350893,256834907 | brandongalbraith 350893 | dogsheep-photos 256834907 | 2020-05-23T01:31:11Z |
| 385989,107914493 | nickfrez 385989 | datasette 107914493 | 2020-05-23T03:32:40Z |
| 399802,107914493 | smunson 399802 | datasette 107914493 | 2020-05-23T05:00:19Z |
| 399802,256834907 | smunson 399802 | dogsheep-photos 256834907 | 2020-05-23T04:59:43Z |
| 642870,107914493 | rxacevedo 642870 | datasette 107914493 | 2020-05-23T02:04:00Z |
| 642870,256834907 | rxacevedo 642870 | dogsheep-photos 256834907 | 2020-05-23T02:03:53Z |
| 719776,256834907 | wetmore 719776 | dogsheep-photos 256834907 | 2020-05-23T18:37:53Z |
| 786420,107914493 | xfbs 786420 | datasette 107914493 | 2020-05-23T11:02:25Z |
| 1240948,256834907 | rismay 1240948 | dogsheep-photos 256834907 | 2020-05-23T05:55:15Z |
| 1291012,107914493 | charles-l 1291012 | datasette 107914493 | 2020-05-23T13:16:59Z |
| 1291012,206156866 | charles-l 1291012 | twitter-to-sqlite 206156866 | 2020-05-23T13:18:26Z |
| 5324653,107914493 | cfilipov 5324653 | datasette 107914493 | 2020-05-23T05:34:40Z |
| 5324653,256834907 | cfilipov 5324653 | dogsheep-photos 256834907 | 2020-05-23T05:33:55Z |
| 5452617,256834907 | arthurbarr 5452617 | dogsheep-photos 256834907 | 2020-05-23T10:31:30Z |
| 6687499,256834907 | pike00 6687499 | dogsheep-photos 256834907 | 2020-05-23T19:44:04Z |
| 6857926,107914493 | monopoly-db 6857926 | datasette 107914493 | 2020-05-23T05:41:03Z |
| 44134283,107914493 | infominer33 44134283 | datasette 107914493 | 2020-05-23T15:01:55Z |
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]);