home / fixtures

Menu

fixtures

Test tables description

Custom SQL query returning 62 rows (hide)

Export data

fixtures

Query results from this SQL query

TSV All 62 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 62 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 62 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 62 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 62 rows
    One JSON object per line
    View Download
  • testall All 62 rows
    View Download
  • testnone All 62 rows
    View Download
  • testresponse All 62 rows
    View Download

addropcodep1p2p3p4p5comment
0 Init 0 60 0   0  
1 InitCoroutine 1 49 2   0  
2 SorterOpen 2 3 0 k(1,B) 0  
3 Integer 0 9 0   0  
4 Null 0 12 12   0  
5 Gosub 11 45 0   0  
6 OpenRead 1 40 0 5 0  
7 Rewind 1 14 0   0  
8 Column 1 4 14   0  
9 Column 1 2 15   0  
10 Column 1 3 16   0  
11 MakeRecord 14 3 17   0  
12 SorterInsert 2 17 0   0  
13 Next 1 8 0   1  
14 OpenPseudo 3 17 3   0  
15 SorterSort 2 48 0   0  
16 SorterData 2 17 3   0  
17 Column 3 0 13   0  
18 Compare 12 13 1 k(1,B) 0  
19 Jump 20 24 20   0  
20 Move 13 12 1   0  
21 Gosub 10 37 0   0  
22 IfPos 9 48 0   0  
23 Gosub 11 45 0   0  
24 AggStep 0 0 3 count(0) 0  
25 Column 3 1 18   0  
26 AggStep 0 18 4 sum(1) 1  
27 Column 3 2 18   0  
28 AggStep 0 18 5 avg(1) 1  
29 If 8 31 0   0  
30 Column 3 0 2   0  
31 Integer 1 8 0   0  
32 SorterNext 2 16 0   0  
33 Gosub 10 37 0   0  
34 Goto 0 48 0   0  
35 Integer 1 9 0   0  
36 Return 10 0 0   0  
37 IfPos 8 39 0   0  
38 Return 10 0 0   0  
39 AggFinal 3 0 0 count(0) 0  
40 AggFinal 4 1 0 sum(1) 0  
41 AggFinal 5 1 0 avg(1) 0  
42 Copy 2 19 3   0  
43 Yield 1 0 0   0  
44 Return 10 0 0   0  
45 Null 0 2 7   0  
46 Integer 0 8 0   0  
47 Return 11 0 0   0  
48 EndCoroutine 1 0 0   0  
49 Integer 101 23 0   0  
50 InitCoroutine 1 0 2   0  
51 Yield 1 59 0   0  
52 Copy 19 24 0   0  
53 Copy 20 25 0   0  
54 Copy 21 26 0   0  
55 Copy 22 27 0   0  
56 ResultRow 24 4 0   0  
57 DecrJumpZero 23 59 0   0  
58 Goto 0 51 0   0  
59 Halt 0 0 0   0  
60 Transaction 0 0 39 0 1  
61 Goto 0 1 0   0  
Powered by Datasette