home / github

Menu
  • Search all tables
  • GraphQL API

users

Table actions
  • GraphQL API for users

3 rows where type = "Bot"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ login node_id avatar_url gravatar_id html_url type site_admin name
22429695 codecov[bot] MDM6Qm90MjI0Mjk2OTU= https://avatars.githubusercontent.com/in/254?v=4   https://github.com/apps/codecov Bot 0 codecov[bot]
27856297 dependabot-preview[bot] MDM6Qm90Mjc4NTYyOTc= https://avatars.githubusercontent.com/in/2141?v=4   https://github.com/apps/dependabot-preview Bot 0 dependabot-preview[bot]
49699333 dependabot[bot] MDM6Qm90NDk2OTkzMzM= https://avatars.githubusercontent.com/in/29110?v=4   https://github.com/apps/dependabot Bot 0 dependabot[bot]

Advanced export

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

CSV options:

CREATE TABLE [users] (
   [login] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [avatar_url] TEXT,
   [gravatar_id] TEXT,
   [html_url] TEXT,
   [type] TEXT,
   [site_admin] INTEGER,
   [name] TEXT
);
Powered by Datasette · Queries took 92.687ms · About: github-to-sqlite
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows