{
    "database": "fixtures",
    "size": 258048,
    "tables": [
        {
            "name": "123_starts_with_digits",
            "columns": [
                "content"
            ],
            "primary_keys": [],
            "count": 0,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "Table With Space In Name",
            "columns": [
                "pk",
                "content"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 0,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "attraction_characteristic",
            "columns": [
                "pk",
                "name"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 2,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "roadside_attraction_characteristics",
                        "column": "pk",
                        "other_column": "characteristic_id"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "binary_data",
            "columns": [
                "data"
            ],
            "primary_keys": [],
            "count": 2,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "complex_foreign_keys",
            "columns": [
                "pk",
                "f1",
                "f2",
                "f3"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "simple_primary_key",
                        "column": "f3",
                        "other_column": "id"
                    },
                    {
                        "other_table": "simple_primary_key",
                        "column": "f2",
                        "other_column": "id"
                    },
                    {
                        "other_table": "simple_primary_key",
                        "column": "f1",
                        "other_column": "id"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "compound_primary_key",
            "columns": [
                "pk1",
                "pk2",
                "content"
            ],
            "primary_keys": [
                "pk1",
                "pk2"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "compound_three_primary_keys",
            "columns": [
                "pk1",
                "pk2",
                "pk3",
                "content"
            ],
            "primary_keys": [
                "pk1",
                "pk2",
                "pk3"
            ],
            "count": 1001,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "custom_foreign_key_label",
            "columns": [
                "pk",
                "foreign_key_with_custom_label"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "primary_key_multiple_columns_explicit_label",
                        "column": "foreign_key_with_custom_label",
                        "other_column": "id"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "facet_cities",
            "columns": [
                "id",
                "name"
            ],
            "primary_keys": [
                "id"
            ],
            "count": 4,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "facetable",
                        "column": "id",
                        "other_column": "city_id"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "facetable",
            "columns": [
                "pk",
                "created",
                "planet_int",
                "on_earth",
                "state",
                "city_id",
                "neighborhood",
                "tags",
                "complex_array",
                "distinct_some_null"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 15,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "facet_cities",
                        "column": "city_id",
                        "other_column": "id"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "foreign_key_references",
            "columns": [
                "pk",
                "foreign_key_with_label",
                "foreign_key_with_no_label"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 2,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "primary_key_multiple_columns",
                        "column": "foreign_key_with_no_label",
                        "other_column": "id"
                    },
                    {
                        "other_table": "simple_primary_key",
                        "column": "foreign_key_with_label",
                        "other_column": "id"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "infinity",
            "columns": [
                "value"
            ],
            "primary_keys": [],
            "count": 3,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "primary_key_multiple_columns",
            "columns": [
                "id",
                "content",
                "content2"
            ],
            "primary_keys": [
                "id"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "foreign_key_references",
                        "column": "id",
                        "other_column": "foreign_key_with_no_label"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "primary_key_multiple_columns_explicit_label",
            "columns": [
                "id",
                "content",
                "content2"
            ],
            "primary_keys": [
                "id"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "custom_foreign_key_label",
                        "column": "id",
                        "other_column": "foreign_key_with_custom_label"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "roadside_attraction_characteristics",
            "columns": [
                "attraction_id",
                "characteristic_id"
            ],
            "primary_keys": [],
            "count": 5,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "attraction_characteristic",
                        "column": "characteristic_id",
                        "other_column": "pk"
                    },
                    {
                        "other_table": "roadside_attractions",
                        "column": "attraction_id",
                        "other_column": "pk"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "roadside_attractions",
            "columns": [
                "pk",
                "name",
                "address",
                "latitude",
                "longitude"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 4,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "roadside_attraction_characteristics",
                        "column": "pk",
                        "other_column": "attraction_id"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable",
            "columns": [
                "pk",
                "text1",
                "text2",
                "name with . and spaces"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 2,
            "hidden": false,
            "fts_table": "searchable_fts",
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "searchable_tags",
                        "column": "pk",
                        "other_column": "searchable_id"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_tags",
            "columns": [
                "searchable_id",
                "tag"
            ],
            "primary_keys": [
                "searchable_id",
                "tag"
            ],
            "count": 2,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": [
                    {
                        "other_table": "tags",
                        "column": "tag",
                        "other_column": "tag"
                    },
                    {
                        "other_table": "searchable",
                        "column": "searchable_id",
                        "other_column": "pk"
                    }
                ]
            },
            "private": false
        },
        {
            "name": "select",
            "columns": [
                "group",
                "having",
                "and",
                "json"
            ],
            "primary_keys": [],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "simple_primary_key",
            "columns": [
                "id",
                "content"
            ],
            "primary_keys": [
                "id"
            ],
            "count": 4,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "foreign_key_references",
                        "column": "id",
                        "other_column": "foreign_key_with_label"
                    },
                    {
                        "other_table": "complex_foreign_keys",
                        "column": "id",
                        "other_column": "f3"
                    },
                    {
                        "other_table": "complex_foreign_keys",
                        "column": "id",
                        "other_column": "f2"
                    },
                    {
                        "other_table": "complex_foreign_keys",
                        "column": "id",
                        "other_column": "f1"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "sortable",
            "columns": [
                "pk1",
                "pk2",
                "content",
                "sortable",
                "sortable_with_nulls",
                "sortable_with_nulls_2",
                "text"
            ],
            "primary_keys": [
                "pk1",
                "pk2"
            ],
            "count": 201,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "table/with/slashes.csv",
            "columns": [
                "pk",
                "content"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 1,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "tags",
            "columns": [
                "tag"
            ],
            "primary_keys": [
                "tag"
            ],
            "count": 2,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "searchable_tags",
                        "column": "tag",
                        "other_column": "tag"
                    }
                ],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "units",
            "columns": [
                "pk",
                "distance",
                "frequency"
            ],
            "primary_keys": [
                "pk"
            ],
            "count": 3,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "no_primary_key",
            "columns": [
                "content",
                "a",
                "b",
                "c"
            ],
            "primary_keys": [],
            "count": 201,
            "hidden": true,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_fts",
            "columns": [
                "text1",
                "text2",
                "name with . and spaces",
                "content"
            ],
            "primary_keys": [],
            "count": 2,
            "hidden": true,
            "fts_table": "searchable_fts",
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_fts_content",
            "columns": [
                "docid",
                "c0text1",
                "c1text2",
                "c2name with . and spaces",
                "c3content"
            ],
            "primary_keys": [
                "docid"
            ],
            "count": 2,
            "hidden": true,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_fts_segdir",
            "columns": [
                "level",
                "idx",
                "start_block",
                "leaves_end_block",
                "end_block",
                "root"
            ],
            "primary_keys": [
                "level",
                "idx"
            ],
            "count": 1,
            "hidden": true,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_fts_segments",
            "columns": [
                "blockid",
                "block"
            ],
            "primary_keys": [
                "blockid"
            ],
            "count": 0,
            "hidden": true,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        }
    ],
    "hidden_count": 5,
    "views": [
        {
            "name": "paginated_view",
            "private": false
        },
        {
            "name": "simple_view",
            "private": false
        },
        {
            "name": "searchable_view",
            "private": false
        },
        {
            "name": "searchable_view_configured_by_metadata",
            "private": false
        }
    ],
    "queries": [
        {
            "sql": "select id, name from facet_cities order by id limit 1;",
            "name": "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c",
            "private": false
        },
        {
            "sql": "PRAGMA cache_size;",
            "name": "pragma_cache_size",
            "private": false
        },
        {
            "sql": "select :_header_user_agent as user_agent, :_now_datetime_utc as datetime",
            "name": "magic_parameters",
            "private": false
        },
        {
            "sql": "\nselect neighborhood, facet_cities.name, state\nfrom facetable\n    join facet_cities\n        on facetable.city_id = facet_cities.id\nwhere neighborhood like '%' || :text || '%'\norder by neighborhood;\n",
            "title": "Search neighborhoods",
            "description_html": "<b>Demonstrating</b> simple like search",
            "fragment": "fragment-goes-here",
            "name": "neighborhood_search",
            "private": false
        }
    ],
    "private": false,
    "allow_execute_sql": true,
    "query_ms": 31.64958953857422,
    "source": "tests/fixtures.py",
    "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
    "license": "Apache License 2.0",
    "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
    "show_hidden": null,
    "editable": true,
    "metadata": {
        "description": "Test tables description",
        "plugins": {
            "name-of-plugin": {
                "depth": "database"
            }
        },
        "tables": {
            "simple_primary_key": {
                "description_html": "Simple <em>primary</em> key",
                "title": "This <em>HTML</em> is escaped",
                "plugins": {
                    "name-of-plugin": {
                        "depth": "table",
                        "special": "this-is-simple_primary_key"
                    }
                },
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "sortable": {
                "sortable_columns": [
                    "sortable",
                    "sortable_with_nulls",
                    "sortable_with_nulls_2",
                    "text"
                ],
                "plugins": {
                    "name-of-plugin": {
                        "depth": "table"
                    }
                },
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "no_primary_key": {
                "sortable_columns": [],
                "hidden": true
            },
            "units": {
                "units": {
                    "distance": "m",
                    "frequency": "Hz"
                },
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "primary_key_multiple_columns_explicit_label": {
                "label_column": "content2",
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "simple_view": {
                "sortable_columns": [
                    "content"
                ],
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "searchable_view_configured_by_metadata": {
                "fts_table": "searchable_fts",
                "fts_pk": "pk",
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "attraction_characteristic": {
                "sort_desc": "pk",
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "facet_cities": {
                "sort": "name",
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "paginated_view": {
                "size": 25,
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            }
        },
        "queries": {
            "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c": {
                "sql": "select id, name from facet_cities order by id limit 1;",
                "name": "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c"
            },
            "pragma_cache_size": {
                "sql": "PRAGMA cache_size;",
                "name": "pragma_cache_size"
            },
            "magic_parameters": {
                "sql": "select :_header_user_agent as user_agent, :_now_datetime_utc as datetime",
                "name": "magic_parameters"
            },
            "neighborhood_search": {
                "sql": "\nselect neighborhood, facet_cities.name, state\nfrom facetable\n    join facet_cities\n        on facetable.city_id = facet_cities.id\nwhere neighborhood like '%' || :text || '%'\norder by neighborhood;\n",
                "title": "Search neighborhoods",
                "description_html": "<b>Demonstrating</b> simple like search",
                "fragment": "fragment-goes-here",
                "name": "neighborhood_search"
            }
        },
        "source": "tests/fixtures.py",
        "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
        "license": "Apache License 2.0",
        "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
        "about": "About Datasette",
        "about_url": "https://github.com/simonw/datasette"
    },
    "allow_download": true,
    "renderers": {
        "json": "/fixtures.json?_context=1"
    },
    "url_csv": "/fixtures.csv?_context=1&_size=max",
    "url_csv_path": "/fixtures.csv",
    "url_csv_hidden_args": [
        [
            "_context",
            "1"
        ],
        [
            "_size",
            "max"
        ]
    ],
    "datasette_version": "0+unknown",
    "config": {
        "default_page_size": 100,
        "max_returned_rows": 1000,
        "num_sql_threads": 3,
        "sql_time_limit_ms": 1000,
        "default_facet_size": 30,
        "facet_time_limit_ms": 200,
        "facet_suggest_time_limit_ms": 50,
        "hash_urls": false,
        "allow_facet": true,
        "allow_download": true,
        "suggest_facets": true,
        "default_cache_ttl": 5,
        "default_cache_ttl_hashed": 31536000,
        "cache_size_kb": 0,
        "allow_csv_stream": true,
        "max_csv_mb": 100,
        "truncate_cells_html": 2048,
        "force_https_urls": false,
        "template_debug": true,
        "base_url": "/"
    },
    "database_url": "<bound method BaseView.database_url of <datasette.views.database.DatabaseView object at 0x3e62d04af220>>",
    "database_color": "<bound method BaseView.database_color of <datasette.views.database.DatabaseView object at 0x3e62d04af220>>",
    "select_templates": [
        "database-fixtures.html",
        "*database.html"
    ],
    "actor": null,
    "display_actor": "<function display_actor at 0x3e62d1879430>",
    "show_logout": false,
    "app_css_hash": "8dfc36",
    "zip": "<class 'zip'>",
    "body_scripts": [],
    "format_bytes": "<function format_bytes at 0x3e62d18788b0>",
    "show_messages": "<function Datasette.render_template.<locals>.<lambda> at 0x3e62d0137280>",
    "extra_css_urls": [],
    "extra_js_urls": [],
    "base_url": "/",
    "csrftoken": "<function asgi_csrf_decorator.<locals>._asgi_csrf_decorator.<locals>.app_wrapped_with_csrf.<locals>.get_csrftoken at 0x3e62d01379d0>"
}