paginated_view (view)

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

201 rows sorted by content_extra

View and edit SQL

content content_extra ▼
1 - 1 -
10 - 10 -
100 - 100 -
101 - 101 -
102 - 102 -
103 - 103 -
104 - 104 -
105 - 105 -
106 - 106 -
107 - 107 -
108 - 108 -
109 - 109 -
11 - 11 -
110 - 110 -
111 - 111 -
112 - 112 -
113 - 113 -
114 - 114 -
115 - 115 -
116 - 116 -
117 - 117 -
118 - 118 -
119 - 119 -
12 - 12 -
120 - 120 -
121 - 121 -
122 - 122 -
123 - 123 -
124 - 124 -
125 - 125 -
126 - 126 -
127 - 127 -
128 - 128 -
129 - 129 -
13 - 13 -
130 - 130 -
131 - 131 -
132 - 132 -
133 - 133 -
134 - 134 -
135 - 135 -
136 - 136 -
137 - 137 -
138 - 138 -
139 - 139 -
14 - 14 -
140 - 140 -
141 - 141 -
142 - 142 -
143 - 143 -
144 - 144 -
145 - 145 -
146 - 146 -
147 - 147 -
148 - 148 -
149 - 149 -
15 - 15 -
150 - 150 -
151 - 151 -
152 - 152 -
153 - 153 -
154 - 154 -
155 - 155 -
156 - 156 -
157 - 157 -
158 - 158 -
159 - 159 -
16 - 16 -
160 - 160 -
161 - 161 -
162 - 162 -
163 - 163 -
164 - 164 -
165 - 165 -
166 - 166 -
167 - 167 -
168 - 168 -
169 - 169 -
17 - 17 -
170 - 170 -
171 - 171 -
172 - 172 -
173 - 173 -
174 - 174 -
175 - 175 -
176 - 176 -
177 - 177 -
178 - 178 -
179 - 179 -
18 - 18 -
180 - 180 -
181 - 181 -
182 - 182 -
183 - 183 -
184 - 184 -
185 - 185 -
186 - 186 -
187 - 187 -
188 - 188 -
189 - 189 -

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW paginated_view AS
    SELECT
        content,
        '- ' || content || ' -' AS content_extra
    FROM no_primary_key
Powered by Datasette · Query took 11.938ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette