home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 726413829

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/1091#issuecomment-726413829 https://api.github.com/repos/simonw/datasette/issues/1091 726413829 MDEyOklzc3VlQ29tbWVudDcyNjQxMzgyOQ== 9599 2020-11-12T23:52:50Z 2020-11-12T23:54:16Z OWNER

Hmm... it's not just the .csv and .json export links - it's the column headings (which can be clicked to change the sort order) as well. Here's an extract of the HTML from that page: ```html

This data as json, CSV ( advanced)

<table class="rows-and-columns"> <thead> <tr> <th class="col-Link" scope="col" data-column="Link" data-column-type="" data-column-not-null="0" data-is-pk="0"> Link </th> <th class="col-rowid" scope="col" data-column="rowid" data-column-type="integer" data-column-not-null="0" data-is-pk="1"> rowid ▼ </th> <th class="col-PARSE_EXCEPTION_ID" scope="col" data-column="PARSE_EXCEPTION_ID" data-column-type="INTEGER" data-column-not-null="0" data-is-pk="0"> PARSE_EXCEPTION_ID </th> <th class="col-PARSE_EXCEPTION_DESCRIPTION" scope="col" data-column="PARSE_EXCEPTION_DESCRIPTION" data-column-type="VARCHAR(128)" data-column-not-null="0" data-is-pk="0"> PARSE_EXCEPTION_DESCRIPTION </th> </tr> </thead> <tbody> <tr> <td class="col-Link type-pk"> 1 </td> <td class="col-rowid type-int">1</td> <td class="col-PARSE_EXCEPTION_ID type-int">0</td> <td class="col-PARSE_EXCEPTION_DESCRIPTION type-str">RUNTIME</td> </tr> <tr> <td class="col-Link type-pk"> 2 </td> <td class="col-rowid type-int">2</td> <td class="col-PARSE_EXCEPTION_ID type-int">1</td> <td class="col-PARSE_EXCEPTION_DESCRIPTION type-str">ENCRYPTION</td> </tr> <tr> <td class="col-Link type-pk"> 3 </td> <td class="col-rowid type-int">3</td> <td class="col-PARSE_EXCEPTION_ID type-int">2</td> <td class="col-PARSE_EXCEPTION_DESCRIPTION type-str">ACCESS_PERMISSION</td> </tr> <tr> <td class="col-Link type-pk"> 4 </td> <td class="col-rowid type-int">4</td> <td class="col-PARSE_EXCEPTION_ID type-int">3</td> <td class="col-PARSE_EXCEPTION_DESCRIPTION type-str">UNSUPPORTED_VERSION</td> </tr> </tbody> </table>

Advanced export

JSON shape: default, array, newline-delimited

<form action="/corpora-metadata/REF_PARSE_EXCEPTION_TYPES.csv" method="get">

CSV options: <label> download file </label>

</form>

But here's something _really_ weird - the links to the individual rows DO include the `/datasette/` prefix:html

<td class="col-Link type-pk"> 2 </td>

The navigation bar on that page is correct too:html

home / corpora-metadata

`` I've also been unable to replicate this in my own local environment, runningdatasette fixtures.db --config base_url:/datasette/`.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
742011049  
Powered by Datasette · Queries took 0.866ms · About: github-to-sqlite