home / db

wagtailcore_page

Data license: MIT

3 rows where locale_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: numchild, latest_revision_created_at (date), first_published_at (date), last_published_at (date)

id ▼ path depth numchild title slug live has_unpublished_changes url_path seo_title show_in_menus search_description go_live_at expire_at expired content_type_id owner_id locked latest_revision_created_at first_published_at live_revision_id last_published_at draft_title locked_at locked_by_id locale_id translation_key alias_of_id latest_revision_id
1 0001 1 1 Root root 1 0 /   0       0 1 1   0         Root     en 1 a29327ab4709405fb0d5c06bf5952089    
3 00010001 2 1 Home home 1 0 /home/   0       0 2 2   0         Home     en 1 b8d541b256224d3093ab9797536b7f16    
4 000100010001 3 0 I am running xAI agentically on my server i-am-running-xai-agentically-on-my-server 1 0 /home/i-am-running-xai-agentically-on-my-server/   0       0 48 48 1 1 0 2026-09-29 01:22:57.373283 2026-09-29 01:22:57.402207 2 2 2026-09-29 01:22:57.402207 I am running xAI agentically on my server     en 1 afa6618a456f4e78959fcb97ac8328f1   2 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "wagtailcore_page" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "path" varchar(255) NOT NULL UNIQUE, "depth" integer unsigned NOT NULL CHECK ("depth" >= 0), "numchild" integer unsigned NOT NULL CHECK ("numchild" >= 0), "title" varchar(255) NOT NULL, "slug" varchar(255) NOT NULL, "live" bool NOT NULL, "has_unpublished_changes" bool NOT NULL, "url_path" text NOT NULL, "seo_title" varchar(255) NOT NULL, "show_in_menus" bool NOT NULL, "search_description" text NOT NULL, "go_live_at" datetime NULL, "expire_at" datetime NULL, "expired" bool NOT NULL, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id") DEFERRABLE INITIALLY DEFERRED, "owner_id" integer NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "locked" bool NOT NULL, "latest_revision_created_at" datetime NULL, "first_published_at" datetime NULL, "live_revision_id" integer NULL REFERENCES "wagtailcore_revision" ("id") DEFERRABLE INITIALLY DEFERRED, "last_published_at" datetime NULL, "draft_title" varchar(255) NOT NULL, "locked_at" datetime NULL, "locked_by_id" integer NULL REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, "locale_id" integer NOT NULL REFERENCES "wagtailcore_locale" ("id") DEFERRABLE INITIALLY DEFERRED, "translation_key" char(32) NOT NULL, "alias_of_id" integer NULL REFERENCES "wagtailcore_page" ("id") DEFERRABLE INITIALLY DEFERRED, "latest_revision_id" integer NULL REFERENCES "wagtailcore_revision" ("id") DEFERRABLE INITIALLY DEFERRED);
CREATE UNIQUE INDEX "wagtailcore_page_translation_key_locale_id_9b041bad_uniq" ON "wagtailcore_page" ("translation_key", "locale_id");
CREATE INDEX "wagtailcore_page_slug_e7c11b8f" ON "wagtailcore_page" ("slug");
CREATE INDEX "wagtailcore_page_content_type_id_c28424df" ON "wagtailcore_page" ("content_type_id");
CREATE INDEX "wagtailcore_page_owner_id_fbf7c332" ON "wagtailcore_page" ("owner_id");
CREATE INDEX "wagtailcore_page_first_published_at_2b5dd637" ON "wagtailcore_page" ("first_published_at");
CREATE INDEX "wagtailcore_page_live_revision_id_930bd822" ON "wagtailcore_page" ("live_revision_id");
CREATE INDEX "wagtailcore_page_locked_by_id_bcb86245" ON "wagtailcore_page" ("locked_by_id");
CREATE INDEX "wagtailcore_page_locale_id_3c7e30a6" ON "wagtailcore_page" ("locale_id");
CREATE INDEX "wagtailcore_page_alias_of_id_12945502" ON "wagtailcore_page" ("alias_of_id");
CREATE INDEX "wagtailcore_page_latest_revision_id_e60fef51" ON "wagtailcore_page" ("latest_revision_id");
Powered by Datasette · Queries took 30.031ms · Data license: MIT