issue_comments: 813134227

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/1293#issuecomment-813134227 https://api.github.com/repos/simonw/datasette/issues/1293 813134227 MDEyOklzc3VlQ29tbWVudDgxMzEzNDIyNw== 9599 2021-04-05T01:19:31Z 2021-04-05T01:19:31Z OWNER
<table> <thead> <tr> <th>addr</th> <th>opcode</th> <th>p1</th> <th>p2</th> <th>p3</th> <th>p4</th> <th>p5</th> <th>comment</th> </tr> </thead> <tbody> <tr> <td>0</td> <td>Init</td> <td>0</td> <td>47</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>1</td> <td>OpenRead</td> <td>0</td> <td>51</td> <td>0</td> <td>15</td> <td>00</td> <td></td> </tr> <tr> <td>2</td> <td>Integer</td> <td>15</td> <td>2</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>3</td> <td>Once</td> <td>0</td> <td>15</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>4</td> <td>OpenEphemeral</td> <td>2</td> <td>1</td> <td>0</td> <td>k(1,)</td> <td>00</td> <td></td> </tr> <tr> <td>5</td> <td>VOpen</td> <td>1</td> <td>0</td> <td>0</td> <td>vtab:3E692C362158</td> <td>00</td> <td></td> </tr> <tr> <td>6</td> <td>String8</td> <td>0</td> <td>5</td> <td>0</td> <td>CPAD_2020a_SuperUnits</td> <td>00</td> <td></td> </tr> <tr> <td>7</td> <td>SCopy</td> <td>7</td> <td>6</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>8</td> <td>Integer</td> <td>2</td> <td>3</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>9</td> <td>Integer</td> <td>2</td> <td>4</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>10</td> <td>VFilter</td> <td>1</td> <td>15</td> <td>3</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>11</td> <td>Rowid</td> <td>1</td> <td>8</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>12</td> <td>MakeRecord</td> <td>8</td> <td>1</td> <td>9</td> <td>C</td> <td>00</td> <td></td> </tr> <tr> <td>13</td> <td>IdxInsert</td> <td>2</td> <td>9</td> <td>8</td> <td>1</td> <td>00</td> <td></td> </tr> <tr> <td>14</td> <td>VNext</td> <td>1</td> <td>11</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>15</td> <td>Return</td> <td>2</td> <td>0</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>16</td> <td>Rewind</td> <td>2</td> <td>46</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>17</td> <td>Column</td> <td>2</td> <td>0</td> <td>1</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>18</td> <td>IsNull</td> <td>1</td> <td>45</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>19</td> <td>SeekRowid</td> <td>0</td> <td>45</td> <td>1</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>20</td> <td>Column</td> <td>0</td> <td>2</td> <td>11</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>21</td> <td>Function0</td> <td>1</td> <td>10</td> <td>9</td> <td>like(2)</td> <td>02</td> <td></td> </tr> <tr> <td>22</td> <td>IfNot</td> <td>9</td> <td>45</td> <td>1</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>23</td> <td>Column</td> <td>0</td> <td>14</td> <td>13</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>24</td> <td>Function0</td> <td>1</td> <td>12</td> <td>9</td> <td>intersects(2)</td> <td>02</td> <td></td> </tr> <tr> <td>25</td> <td>Ne</td> <td>14</td> <td>45</td> <td>9</td> <td></td> <td>51</td> <td></td> </tr> <tr> <td>26</td> <td>Column</td> <td>0</td> <td>14</td> <td>9</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>27</td> <td>Function0</td> <td>0</td> <td>9</td> <td>15</td> <td>asgeojson(1)</td> <td>01</td> <td></td> </tr> <tr> <td>28</td> <td>Rowid</td> <td>0</td> <td>16</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>29</td> <td>Column</td> <td>0</td> <td>1</td> <td>17</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>30</td> <td>Column</td> <td>0</td> <td>2</td> <td>18</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>31</td> <td>Column</td> <td>0</td> <td>3</td> <td>19</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>32</td> <td>Column</td> <td>0</td> <td>4</td> <td>20</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>33</td> <td>Column</td> <td>0</td> <td>5</td> <td>21</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>34</td> <td>Column</td> <td>0</td> <td>6</td> <td>22</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>35</td> <td>Column</td> <td>0</td> <td>7</td> <td>23</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>36</td> <td>Column</td> <td>0</td> <td>8</td> <td>24</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>37</td> <td>Column</td> <td>0</td> <td>9</td> <td>25</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>38</td> <td>Column</td> <td>0</td> <td>10</td> <td>26</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>39</td> <td>Column</td> <td>0</td> <td>11</td> <td>27</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>40</td> <td>RealAffinity</td> <td>27</td> <td>0</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>41</td> <td>Column</td> <td>0</td> <td>12</td> <td>28</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>42</td> <td>Column</td> <td>0</td> <td>13</td> <td>29</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>43</td> <td>Column</td> <td>0</td> <td>14</td> <td>30</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>44</td> <td>ResultRow</td> <td>15</td> <td>16</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>45</td> <td>Next</td> <td>2</td> <td>17</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>46</td> <td>Halt</td> <td>0</td> <td>0</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>47</td> <td>Transaction</td> <td>0</td> <td>0</td> <td>265</td> <td>0</td> <td>01</td> <td></td> </tr> <tr> <td>48</td> <td>Variable</td> <td>1</td> <td>31</td> <td>0</td> <td>:freedraw</td> <td>00</td> <td></td> </tr> <tr> <td>49</td> <td>Function0</td> <td>1</td> <td>31</td> <td>7</td> <td>geomfromgeojson(1)</td> <td>01</td> <td></td> </tr> <tr> <td>50</td> <td>String8</td> <td>0</td> <td>10</td> <td>0</td> <td>%mini%</td> <td>00</td> <td></td> </tr> <tr> <td>51</td> <td>Variable</td> <td>1</td> <td>32</td> <td>0</td> <td>:freedraw</td> <td>00</td> <td></td> </tr> <tr> <td>52</td> <td>Function0</td> <td>1</td> <td>32</td> <td>12</td> <td>geomfromgeojson(1)</td> <td>01</td> <td></td> </tr> <tr> <td>53</td> <td>Integer</td> <td>1</td> <td>14</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> <tr> <td>54</td> <td>Goto</td> <td>0</td> <td>1</td> <td>0</td> <td></td> <td>00</td> <td></td> </tr> </tbody> </table>

Essential documentation for understanding that output: https://www.sqlite.org/opcode.html

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 849978964