{"datasette": "<datasette.app.Datasette object at 0x3e7d9e787790>", "columns": ["addr", "opcode", "p1", "p2", "p3", "p4", "p5", "comment"], "rows": ["<sqlite3.Row object at 0x3e7d9e58fbb0>", "<sqlite3.Row object at 0x3e7d9d156b90>", "<sqlite3.Row object at 0x3e7d9d156380>", "<sqlite3.Row object at 0x3e7d9d156980>", "<sqlite3.Row object at 0x3e7d9d155e10>", "<sqlite3.Row object at 0x3e7d9d156b00>", "<sqlite3.Row object at 0x3e7d9d156b30>", "<sqlite3.Row object at 0x3e7d9d154700>", "<sqlite3.Row object at 0x3e7d9d155ea0>", "<sqlite3.Row object at 0x3e7d9d155d80>", "<sqlite3.Row object at 0x3e7d9d156cb0>", "<sqlite3.Row object at 0x3e7d9d156c20>", "<sqlite3.Row object at 0x3e7d9d155000>", "<sqlite3.Row object at 0x3e7d9d155030>", "<sqlite3.Row object at 0x3e7d9d156aa0>", "<sqlite3.Row object at 0x3e7d9d155f00>", "<sqlite3.Row object at 0x3e7d9d155900>", "<sqlite3.Row object at 0x3e7d9d157bb0>", "<sqlite3.Row object at 0x3e7d9d155510>", "<sqlite3.Row object at 0x3e7d9d1562f0>", "<sqlite3.Row object at 0x3e7d9d1576d0>", "<sqlite3.Row object at 0x3e7d9d1550f0>", "<sqlite3.Row object at 0x3e7d9d156ec0>", "<sqlite3.Row object at 0x3e7d9d1571c0>", "<sqlite3.Row object at 0x3e7d9d156230>", "<sqlite3.Row object at 0x3e7d9d155600>", "<sqlite3.Row object at 0x3e7d9d1555d0>", "<sqlite3.Row object at 0x3e7d9d157f70>", "<sqlite3.Row object at 0x3e7d9d155ed0>", "<sqlite3.Row object at 0x3e7d9d157d00>", "<sqlite3.Row object at 0x3e7d9d154ca0>", "<sqlite3.Row object at 0x3e7d9d156260>", "<sqlite3.Row object at 0x3e7d9d157370>", "<sqlite3.Row object at 0x3e7d9d154100>", "<sqlite3.Row object at 0x3e7d9d154fd0>", "<sqlite3.Row object at 0x3e7d9d157130>", "<sqlite3.Row object at 0x3e7d9d157190>", "<sqlite3.Row object at 0x3e7d9d156950>", "<sqlite3.Row object at 0x3e7d9d154670>", "<sqlite3.Row object at 0x3e7d9d1567d0>", "<sqlite3.Row object at 0x3e7d9d154d30>", "<sqlite3.Row object at 0x3e7d9d155c60>", "<sqlite3.Row object at 0x3e7d9d1555a0>", "<sqlite3.Row object at 0x3e7d9d154c40>", "<sqlite3.Row object at 0x3e7d9d1552a0>", "<sqlite3.Row object at 0x3e7d9d157940>", "<sqlite3.Row object at 0x3e7d9d156410>", "<sqlite3.Row object at 0x3e7d9d1549a0>", "<sqlite3.Row object at 0x3e7d9d157340>", "<sqlite3.Row object at 0x3e7d9d156560>", "<sqlite3.Row object at 0x3e7d9d155360>", "<sqlite3.Row object at 0x3e7d9d157970>"], "sql": "explain select 'name' as column, count (distinct name) as count_distinct, avg(length(name)) as avg_length from roadside_attractions\r\n  union\r\nselect 'address' as column, count(distinct address) as count_distinct, avg(length(address)) as avg_length from roadside_attractions", "query_name": null, "database": "fixtures", "table": null, "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures.testall?sql=explain+select+'name'+as+column%2C+count+(distinct+name)+as+count_distinct%2C+avg(length(name))+as+avg_length+from+roadside_attractions%0D%0A++union%0D%0Aselect+'address'+as+column%2C+count(distinct+address)+as+count_distinct%2C+avg(length(address))+as+avg_length+from+roadside_attractions\">", "view_name": "table", "1+1": 2}