issue_comments

Table actions

3 rows where issue = 649437530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

id ▼ html_url issue_url node_id user created_at updated_at author_association body reactions issue performed_via_github_app
652709199 https://github.com/simonw/datasette/issues/887#issuecomment-652709199 https://api.github.com/repos/simonw/datasette/issues/887 MDEyOklzc3VlQ29tbWVudDY1MjcwOTE5OQ== simonw 9599 2020-07-02T00:21:54Z 2020-07-02T00:21:54Z OWNER Example in the live demo: https://latest.datasette.io/fixtures/magic_parameters <img width="858" alt="fixtures__select___header_user_agent_as_user_agent____now_datetime_utc_as_datetime" src="https://user-images.githubusercontent.com/9599/86303008-58bab480-bbbf-11ea-9c99-aec7ed1f4f56.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Canned query page should show the name of the canned query 649437530  
652711562 https://github.com/simonw/datasette/issues/887#issuecomment-652711562 https://api.github.com/repos/simonw/datasette/issues/887 MDEyOklzc3VlQ29tbWVudDY1MjcxMTU2Mg== simonw 9599 2020-07-02T00:30:43Z 2020-07-02T00:30:43Z OWNER Demo has updated: https://latest.datasette.io/fixtures/magic_parameters <img width="900" alt="fixtures__select___header_user_agent_as_user_agent____now_datetime_utc_as_datetime" src="https://user-images.githubusercontent.com/9599/86303410-95d37680-bbc0-11ea-892c-0ef4744c261a.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Canned query page should show the name of the canned query 649437530  
652711822 https://github.com/simonw/datasette/issues/887#issuecomment-652711822 https://api.github.com/repos/simonw/datasette/issues/887 MDEyOklzc3VlQ29tbWVudDY1MjcxMTgyMg== simonw 9599 2020-07-02T00:31:33Z 2020-07-02T00:31:33Z OWNER If a canned query has a title defined that will be used instead: https://latest.datasette.io/fixtures/neighborhood_search <img width="821" alt="fixtures__select_neighborhood__facet_cities_name__state_from_facetable_join_facet_cities_on_facetable_city_id___facet_cities_id_where_neighborhood_like_________text________order_by_neighborhood_" src="https://user-images.githubusercontent.com/9599/86303455-b26fae80-bbc0-11ea-9054-0cc6c086f143.png"> {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Canned query page should show the name of the canned query 649437530  

Advanced export

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

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
, [performed_via_github_app] TEXT);
CREATE INDEX [idx_issue_comments_issue]
                ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
                ON [issue_comments] ([user]);