{
    "database": "fixtures",
    "private": false,
    "path": "/fixtures",
    "size": 262144,
    "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": 3,
            "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": 2,
            "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",
                "n"
            ],
            "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_blank_label",
                "foreign_key_with_no_label",
                "foreign_key_compound_pk1",
                "foreign_key_compound_pk2"
            ],
            "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_blank_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",
                "url",
                "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": 5,
            "hidden": false,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [
                    {
                        "other_table": "foreign_key_references",
                        "column": "id",
                        "other_column": "foreign_key_with_blank_label"
                    },
                    {
                        "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",
                "searchable_fts",
                "docid",
                "__langid"
            ],
            "primary_keys": [],
            "count": 2,
            "hidden": true,
            "fts_table": "searchable_fts",
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        },
        {
            "name": "searchable_fts_docsize",
            "columns": [
                "docid",
                "size"
            ],
            "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
        },
        {
            "name": "searchable_fts_stat",
            "columns": [
                "id",
                "value"
            ],
            "primary_keys": [
                "id"
            ],
            "count": 1,
            "hidden": true,
            "fts_table": null,
            "foreign_keys": {
                "incoming": [],
                "outgoing": []
            },
            "private": false
        }
    ],
    "hidden_count": 6,
    "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 2",
            "name": "from_async_hook",
            "private": false
        },
        {
            "sql": "select 1, 'null' as actor_id",
            "name": "from_hook",
            "private": false
        }
    ],
    "allow_execute_sql": true,
    "table_columns": {
        "123_starts_with_digits": [
            "content"
        ],
        "Table With Space In Name": [
            "content",
            "pk"
        ],
        "attraction_characteristic": [
            "name",
            "pk"
        ],
        "binary_data": [
            "data"
        ],
        "complex_foreign_keys": [
            "f1",
            "f2",
            "f3",
            "pk"
        ],
        "compound_primary_key": [
            "content",
            "pk1",
            "pk2"
        ],
        "compound_three_primary_keys": [
            "content",
            "pk1",
            "pk2",
            "pk3"
        ],
        "custom_foreign_key_label": [
            "foreign_key_with_custom_label",
            "pk"
        ],
        "facet_cities": [
            "id",
            "name"
        ],
        "facetable": [
            "_city_id",
            "_neighborhood",
            "complex_array",
            "created",
            "distinct_some_null",
            "n",
            "on_earth",
            "pk",
            "planet_int",
            "state",
            "tags"
        ],
        "foreign_key_references": [
            "foreign_key_compound_pk1",
            "foreign_key_compound_pk2",
            "foreign_key_with_blank_label",
            "foreign_key_with_label",
            "foreign_key_with_no_label",
            "pk"
        ],
        "infinity": [
            "value"
        ],
        "no_primary_key": [
            "a",
            "b",
            "c",
            "content"
        ],
        "primary_key_multiple_columns": [
            "content",
            "content2",
            "id"
        ],
        "primary_key_multiple_columns_explicit_label": [
            "content",
            "content2",
            "id"
        ],
        "roadside_attraction_characteristics": [
            "attraction_id",
            "characteristic_id"
        ],
        "roadside_attractions": [
            "address",
            "latitude",
            "longitude",
            "name",
            "pk",
            "url"
        ],
        "searchable": [
            "name with . and spaces",
            "pk",
            "text1",
            "text2"
        ],
        "searchable_fts": [
            "__langid",
            "docid",
            "name with . and spaces",
            "searchable_fts",
            "text1",
            "text2"
        ],
        "searchable_fts_docsize": [
            "docid",
            "size"
        ],
        "searchable_fts_segdir": [
            "end_block",
            "idx",
            "leaves_end_block",
            "level",
            "root",
            "start_block"
        ],
        "searchable_fts_segments": [
            "block",
            "blockid"
        ],
        "searchable_fts_stat": [
            "id",
            "value"
        ],
        "searchable_tags": [
            "searchable_id",
            "tag"
        ],
        "select": [
            "and",
            "group",
            "having",
            "json"
        ],
        "simple_primary_key": [
            "content",
            "id"
        ],
        "sortable": [
            "content",
            "pk1",
            "pk2",
            "sortable",
            "sortable_with_nulls",
            "sortable_with_nulls_2",
            "text"
        ],
        "table/with/slashes.csv": [
            "content",
            "pk"
        ],
        "tags": [
            "tag"
        ],
        "units": [
            "distance",
            "frequency",
            "pk"
        ],
        "paginated_view": [],
        "simple_view": [],
        "searchable_view": [],
        "searchable_view_configured_by_metadata": []
    },
    "database_color": "40882a",
    "database_actions": "<function DatabaseView.get.<locals>.database_actions at 0x3eb32329aa20>",
    "show_hidden": null,
    "editable": true,
    "metadata": {
        "description": "Test tables description",
        "tables": {
            "simple_primary_key": {
                "description_html": "Simple <em>primary</em> key",
                "title": "This <em>HTML</em> is escaped",
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/main/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/main/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            },
            "roadside_attractions": {
                "columns": {
                    "name": "The name of the attraction",
                    "address": "The street address for the attraction"
                },
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/main/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/main/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            }
        },
        "source": "tests/fixtures.py",
        "source_url": "https://github.com/simonw/datasette/blob/main/tests/fixtures.py",
        "license": "Apache License 2.0",
        "license_url": "https://github.com/simonw/datasette/blob/main/LICENSE",
        "about": "About Datasette",
        "about_url": "https://github.com/simonw/datasette"
    },
    "allow_download": true,
    "attached_databases": [],
    "alternate_url_json": "https://latest.datasette.io/fixtures.json?_context=1",
    "select_templates": [
        "database-fixtures.html",
        "*database.html"
    ],
    "top_database": "<function make_slot_function.<locals>.inner at 0x3eb32329ac00>",
    "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures?_context=1\">",
    "crumb_items": "<bound method Datasette._crumb_items of <datasette.app.Datasette object at 0x3eb323483250>>",
    "urls": "<datasette.url_builder.Urls object at 0x3eb321376f50>",
    "actor": null,
    "menu_links": "<function Datasette.render_template.<locals>.menu_links at 0x3eb323298ea0>",
    "display_actor": "<function display_actor at 0x3eb3246044a0>",
    "show_logout": false,
    "app_css_hash": "bad7e8",
    "zip": "<class 'zip'>",
    "body_scripts": [
        {
            "script": "var extra_body_script = {\"template\": \"database.html\", \"database\": \"fixtures\", \"table\": null, \"config\": null, \"view_name\": \"database\", \"request_path\": \"/fixtures\", \"added\": 15, \"columns\": null};",
            "module": true
        }
    ],
    "format_bytes": "<function format_bytes at 0x3eb3245eb740>",
    "show_messages": "<function Datasette.render_template.<locals>.<lambda> at 0x3eb3232984a0>",
    "extra_css_urls": [
        {
            "url": "https://plugin-example.datasette.io/eyJ0ZW1wbGF0ZSI6ICJkYXRhYmFzZS5odG1sIiwgImRhdGFiYXNlIjogImZpeHR1cmVzIiwgInRhYmxlIjogbnVsbCwgInZpZXdfbmFtZSI6ICJkYXRhYmFzZSIsICJyZXF1ZXN0X3BhdGgiOiAiL2ZpeHR1cmVzIiwgImFkZGVkIjogMTUsICJjb2x1bW5zIjogbnVsbH0=/extra-css-urls-demo.css"
        }
    ],
    "extra_js_urls": [
        {
            "url": "https://plugin-example.datasette.io/jquery.js",
            "sri": "SRIHASH"
        },
        {
            "url": "https://plugin-example.datasette.io/plugin2.js"
        },
        {
            "url": "https://plugin-example.datasette.io/plugin1.js"
        },
        {
            "url": "https://plugin-example.datasette.io/plugin.module.js",
            "module": true
        }
    ],
    "base_url": "/",
    "csrftoken": "<function asgi_csrf_decorator.<locals>._asgi_csrf_decorator.<locals>.app_wrapped_with_csrf.<locals>.get_csrftoken at 0x3eb3213a5b20>",
    "datasette_version": "1.0a13",
    "view_name": "database",
    "extra_template_vars_from_awaitable": "{\"template\": \"database.html\", \"scope_path\": \"/fixtures\", \"awaitable\": true}",
    "query_database": "<function extra_template_vars.<locals>.query_database at 0x3eb32329bb00>",
    "extra_template_vars": "{\"template\": \"database.html\", \"scope_path\": \"/fixtures\", \"columns\": null}"
}