dependents

1 row where dependent = 197882382 and "first_seen_utc" is on date 2020-05-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: first_seen_utc (date)

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