{
    "databases": [
        {
            "name": "_memory",
            "hash": null,
            "color": "a6c7b9",
            "path": "/_memory",
            "tables_and_views_truncated": [],
            "tables_and_views_more": false,
            "tables_count": 0,
            "table_rows_sum": 0,
            "show_table_row_counts": false,
            "hidden_table_rows_sum": 0,
            "hidden_tables_count": 0,
            "views_count": 0,
            "private": false
        },
        {
            "name": "fixtures",
            "hash": "40882a89c8b0eb57f500131bdfccb64a6f2e53c670659f6d5d282f916e0cd909",
            "color": "40882a",
            "path": "/fixtures",
            "tables_and_views_truncated": [
                {
                    "name": "compound_three_primary_keys",
                    "columns": [
                        "pk1",
                        "pk2",
                        "pk3",
                        "content"
                    ],
                    "primary_keys": [
                        "pk1",
                        "pk2",
                        "pk3"
                    ],
                    "count": 1001,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "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,
                    "num_relationships_for_sorting": 0,
                    "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,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "simple_primary_key",
                    "columns": [
                        "id",
                        "content"
                    ],
                    "primary_keys": [
                        "id"
                    ],
                    "count": 5,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "roadside_attraction_characteristics",
                    "columns": [
                        "attraction_id",
                        "characteristic_id"
                    ],
                    "primary_keys": [],
                    "count": 5,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                }
            ],
            "tables_and_views_more": true,
            "tables_count": 24,
            "table_rows_sum": 1262,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 207,
            "hidden_tables_count": 6,
            "views_count": 4,
            "private": false
        },
        {
            "name": "fixtures2",
            "hash": "40882a89c8b0eb57f500131bdfccb64a6f2e53c670659f6d5d282f916e0cd909",
            "color": "40882a",
            "path": "/alternative-route",
            "tables_and_views_truncated": [
                {
                    "name": "compound_three_primary_keys",
                    "columns": [
                        "pk1",
                        "pk2",
                        "pk3",
                        "content"
                    ],
                    "primary_keys": [
                        "pk1",
                        "pk2",
                        "pk3"
                    ],
                    "count": 1001,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "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,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "no_primary_key",
                    "columns": [
                        "content",
                        "a",
                        "b",
                        "c"
                    ],
                    "primary_keys": [],
                    "count": 201,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "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,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "simple_primary_key",
                    "columns": [
                        "id",
                        "content"
                    ],
                    "primary_keys": [
                        "id"
                    ],
                    "count": 5,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                }
            ],
            "tables_and_views_more": true,
            "tables_count": 25,
            "table_rows_sum": 1463,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 6,
            "hidden_tables_count": 5,
            "views_count": 4,
            "private": false
        },
        {
            "name": "extra_database",
            "hash": "24f77e9e93c81137c2fa3873f24851b5361b89ec93c5241f01410e12f90c477a",
            "color": "24f77e",
            "path": "/extra_database",
            "tables_and_views_truncated": [
                {
                    "name": "searchable",
                    "columns": [
                        "pk",
                        "text1",
                        "text2"
                    ],
                    "primary_keys": [
                        "pk"
                    ],
                    "count": 2,
                    "hidden": false,
                    "fts_table": "searchable_fts",
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "searchable_view",
                    "private": false
                }
            ],
            "tables_and_views_more": false,
            "tables_count": 1,
            "table_rows_sum": 2,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 5,
            "hidden_tables_count": 4,
            "views_count": 1,
            "private": false
        },
        {
            "name": "counters",
            "hash": null,
            "color": "0976bd",
            "path": "/counters",
            "tables_and_views_truncated": [
                {
                    "name": "counters",
                    "columns": [
                        "name",
                        "value"
                    ],
                    "primary_keys": [
                        "name"
                    ],
                    "count": 3,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                }
            ],
            "tables_and_views_more": false,
            "tables_count": 1,
            "table_rows_sum": 3,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 0,
            "hidden_tables_count": 0,
            "views_count": 0,
            "private": false
        },
        {
            "name": "ephemeral",
            "hash": null,
            "color": "9a2692",
            "path": "/ephemeral",
            "tables_and_views_truncated": [],
            "tables_and_views_more": false,
            "tables_count": 0,
            "table_rows_sum": 0,
            "show_table_row_counts": false,
            "hidden_table_rows_sum": 0,
            "hidden_tables_count": 0,
            "views_count": 0,
            "private": false
        }
    ],
    "metadata": {
        "title": "Datasette Fixtures",
        "description_html": "An example SQLite database demonstrating Datasette. <a href=\"/login-as-root\">Sign in as root user</a>",
        "license": "Apache License 2.0",
        "license_url": "https://github.com/simonw/datasette/blob/main/LICENSE",
        "source": "tests/fixtures.py",
        "source_url": "https://github.com/simonw/datasette/blob/main/tests/fixtures.py",
        "about": "About Datasette",
        "about_url": "https://github.com/simonw/datasette",
        "databases": {
            "fixtures": {
                "description": "Test tables description",
                "tables": {
                    "simple_primary_key": {
                        "description_html": "Simple <em>primary</em> key",
                        "title": "This <em>HTML</em> is escaped"
                    },
                    "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"
            }
        }
    },
    "datasette_version": "1.0a12",
    "private": false,
    "top_homepage": "<function make_slot_function.<locals>.inner at 0x3ed2a753b7e0>",
    "select_templates": [
        "*index.html"
    ],
    "alternate_url_json": "https://latest.datasette.io/.json?_context=1",
    "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/?_context=1\">",
    "crumb_items": "<bound method Datasette._crumb_items of <datasette.app.Datasette object at 0x3ed2a8b74e90>>",
    "urls": "<datasette.url_builder.Urls object at 0x3ed2a6beb810>",
    "actor": null,
    "menu_links": "<function Datasette.render_template.<locals>.menu_links at 0x3ed2a753ad40>",
    "display_actor": "<function display_actor at 0x3ed2a9cfaf20>",
    "show_logout": false,
    "app_css_hash": "865267",
    "zip": "<class 'zip'>",
    "body_scripts": [
        {
            "script": "var extra_body_script = {\"template\": \"index.html\", \"database\": null, \"table\": null, \"config\": null, \"view_name\": \"index\", \"request_path\": \"/\", \"added\": 15, \"columns\": null};",
            "module": true
        }
    ],
    "format_bytes": "<function format_bytes at 0x3ed2a9cfa200>",
    "show_messages": "<function Datasette.render_template.<locals>.<lambda> at 0x3ed2a753b2e0>",
    "extra_css_urls": [
        {
            "url": "https://plugin-example.datasette.io/eyJ0ZW1wbGF0ZSI6ICJpbmRleC5odG1sIiwgImRhdGFiYXNlIjogbnVsbCwgInRhYmxlIjogbnVsbCwgInZpZXdfbmFtZSI6ICJpbmRleCIsICJyZXF1ZXN0X3BhdGgiOiAiLyIsICJhZGRlZCI6IDE1LCAiY29sdW1ucyI6IG51bGx9/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 0x3ed2a7538cc0>",
    "view_name": "index",
    "extra_template_vars_from_awaitable": "{\"template\": \"index.html\", \"scope_path\": \"/\", \"awaitable\": true}",
    "query_database": "<function extra_template_vars.<locals>.query_database at 0x3ed2a753b880>",
    "extra_template_vars": "{\"template\": \"index.html\", \"scope_path\": \"/\", \"columns\": null}"
}