dependents
3 rows where "first_seen_utc" is on date 2020-09-22 and repo = 107914493 sorted by first_seen_utc
This data as json, CSV (advanced)
Link | repo | dependent | first_seen_utc ▼ |
---|---|---|---|
107914493,296716242 | datasette 107914493 | gunnarfiles 296716242 | 2020-09-22T00:27:31.969593 |
107914493,297329274 | datasette 107914493 | sqlite-for-data-scientists 297329274 | 2020-09-22T00:27:33.106430 |
107914493,297326640 | datasette 107914493 | sqlite-for-data-scientists 297326640 | 2020-09-22T00:27:34.238111 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [dependents] ( [repo] INTEGER REFERENCES [repos]([id]), [dependent] INTEGER REFERENCES [repos]([id]), [first_seen_utc] TEXT, PRIMARY KEY ([repo], [dependent]) ); CREATE INDEX [idx_dependents_dependent] ON [dependents] ([dependent]); CREATE INDEX [idx_dependents_repo] ON [dependents] ([repo]);