{"id":2007,"date":"2018-02-12T18:20:52","date_gmt":"2018-02-12T18:20:52","guid":{"rendered":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/"},"modified":"2018-02-12T18:20:52","modified_gmt":"2018-02-12T18:20:52","slug":"building-a-deity-database","status":"publish","type":"post","link":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/","title":{"rendered":"Building a Deity Database"},"content":{"rendered":"<p>Here&#8217;s a weird thing I&#8217;m working on: while discussing where I&#8217;d like to go next time I visit Europe, I started writing down all the different museums that I wanted to see, and what was in them.<\/p>\n<p>As I stared at it, I realized, &#8220;Wow, this would make an amazing little pivot table.&#8221;<\/p>\n<p>And so I&#8217;ve started treating it like a database, and (at some point, once I&#8217;m really happy with it, I suppose) I&#8217;ll release it for folks to use as a tool to plan their own trips.<\/p>\n<p>You may not use pivot tables (or you might consider them witchcraft), but they&#8217;re remarkably useful for this. In particular, you&#8217;ll be able to use the same data to organize the information as you wish.<\/p>\n<p>I&#8217;ve started entering deities, discovery sites, museums, countries (both of origin and of display), and a few other variables.<\/p>\n<p>Here&#8217;s what it looks like organized by deity:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/c10.patreonusercontent.com\/4\/patreon-media\/p\/post\/16956563\/28e7079781b94f08b90b339b65d3aa58\/eyJhIjoxLCJwIjoxfQ%3D%3D\/1.png?token-hash=tvHIdhlqtJFgQvhyxIDIzZMhb1sFeOQnbmKE1I1pgWk%3D&amp;token-time=1771632000\" \/><\/p>\n<p>Using that, you can say, &#8220;I want to see all the museums I have to visit to see all the stuff we&#8217;ve found that is clearly an Esus piece.&#8221; And boom, you have three museums to visit, listed conveniently above!<\/p>\n<p>But let&#8217;s say you have a layover in France and don&#8217;t have a lot of time to visit a bunch of museums, so you want to get the most bang for your buck. What museum should you go to? Well, organize by museum instead, and get this information:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/c10.patreonusercontent.com\/4\/patreon-media\/p\/post\/16956563\/44da18a854c74242947780a24e6a15a1\/eyJhIjoxLCJwIjoxfQ%3D%3D\/1.png?token-hash=qR_Rw_oT2W4hvY-O1UUvurZB6E8_aR9aTv__m1l4XVc%3D&amp;token-time=1771632000\" \/><\/p>\n<p>Now, you can better plan which museum to hit in order to get the largest number of statues and inscriptions that interest you!<\/p>\n<p>There&#8217;s a lot more data to load; like, about a hundred lines more. And I have to double-check it. But this is a cool little project that I think is going to be really, really helpful to a lot of folks.<\/p>\n<p>Once it&#8217;s ready, I&#8217;ll make a patron-only post with the full dataset attached, and some useful pivots already run for your convenience before I release it out at some later date.<\/p>\n<p>[Thanks to Catherine H. for some particular help in mentally organizing this.]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s a weird thing I&#8217;m working on: while discussing where I&#8217;d like to go next time I visit Europe, I started writing down all the different museums that I wanted to see, and what was in them. As I stared at it, I realized, &#8220;Wow, this would make an amazing little pivot table.&#8221; And so [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-2007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-patreon"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Building a Deity Database - Chronarchy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building a Deity Database - Chronarchy\" \/>\n<meta property=\"og:description\" content=\"Here&#8217;s a weird thing I&#8217;m working on: while discussing where I&#8217;d like to go next time I visit Europe, I started writing down all the different museums that I wanted to see, and what was in them. As I stared at it, I realized, &#8220;Wow, this would make an amazing little pivot table.&#8221; And so [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Chronarchy\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-12T18:20:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/c10.patreonusercontent.com\/4\/patreon-media\/p\/post\/16956563\/28e7079781b94f08b90b339b65d3aa58\/eyJhIjoxLCJwIjoxfQ%3D%3D\/1.png?token-hash=tvHIdhlqtJFgQvhyxIDIzZMhb1sFeOQnbmKE1I1pgWk%3D&amp;token-time=1771632000\" \/>\n<meta name=\"author\" content=\"Michael Dangler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Dangler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/\"},\"author\":{\"name\":\"Michael Dangler\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/#\\\/schema\\\/person\\\/10cbdcc94866b55d1b4eaf486de52666\"},\"headline\":\"Building a Deity Database\",\"datePublished\":\"2018-02-12T18:20:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/\"},\"wordCount\":350,\"commentCount\":0,\"image\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/8a565e1fcea23da8959dcc699626b999.png\",\"articleSection\":[\"Patreon\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/\",\"url\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/\",\"name\":\"Building a Deity Database - Chronarchy\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/8a565e1fcea23da8959dcc699626b999.png\",\"datePublished\":\"2018-02-12T18:20:52+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/#\\\/schema\\\/person\\\/10cbdcc94866b55d1b4eaf486de52666\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#primaryimage\",\"url\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/8a565e1fcea23da8959dcc699626b999.png\",\"contentUrl\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/8a565e1fcea23da8959dcc699626b999.png\",\"width\":331,\"height\":727,\"caption\":\"Museums organized by the deity images they hold\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/building-a-deity-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Building a Deity Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/#website\",\"url\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/\",\"name\":\"Chronarchy\",\"description\":\"Rule By Time\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/#\\\/schema\\\/person\\\/10cbdcc94866b55d1b4eaf486de52666\",\"name\":\"Michael Dangler\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g\",\"caption\":\"Michael Dangler\"},\"url\":\"http:\\\/\\\/67.225.164.17\\\/~chronarchy\\\/author\\\/chronarchy\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Building a Deity Database - Chronarchy","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/","og_locale":"en_US","og_type":"article","og_title":"Building a Deity Database - Chronarchy","og_description":"Here&#8217;s a weird thing I&#8217;m working on: while discussing where I&#8217;d like to go next time I visit Europe, I started writing down all the different museums that I wanted to see, and what was in them. As I stared at it, I realized, &#8220;Wow, this would make an amazing little pivot table.&#8221; And so [&hellip;]","og_url":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/","og_site_name":"Chronarchy","article_published_time":"2018-02-12T18:20:52+00:00","og_image":[{"url":"https:\/\/c10.patreonusercontent.com\/4\/patreon-media\/p\/post\/16956563\/28e7079781b94f08b90b339b65d3aa58\/eyJhIjoxLCJwIjoxfQ%3D%3D\/1.png?token-hash=tvHIdhlqtJFgQvhyxIDIzZMhb1sFeOQnbmKE1I1pgWk%3D&amp;token-time=1771632000","type":"","width":"","height":""}],"author":"Michael Dangler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Michael Dangler","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#article","isPartOf":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/"},"author":{"name":"Michael Dangler","@id":"http:\/\/67.225.164.17\/~chronarchy\/#\/schema\/person\/10cbdcc94866b55d1b4eaf486de52666"},"headline":"Building a Deity Database","datePublished":"2018-02-12T18:20:52+00:00","mainEntityOfPage":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/"},"wordCount":350,"commentCount":0,"image":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#primaryimage"},"thumbnailUrl":"http:\/\/67.225.164.17\/~chronarchy\/wp-content\/uploads\/2026\/02\/8a565e1fcea23da8959dcc699626b999.png","articleSection":["Patreon"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/","url":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/","name":"Building a Deity Database - Chronarchy","isPartOf":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/#website"},"primaryImageOfPage":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#primaryimage"},"image":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#primaryimage"},"thumbnailUrl":"http:\/\/67.225.164.17\/~chronarchy\/wp-content\/uploads\/2026\/02\/8a565e1fcea23da8959dcc699626b999.png","datePublished":"2018-02-12T18:20:52+00:00","author":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/#\/schema\/person\/10cbdcc94866b55d1b4eaf486de52666"},"breadcrumb":{"@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#primaryimage","url":"http:\/\/67.225.164.17\/~chronarchy\/wp-content\/uploads\/2026\/02\/8a565e1fcea23da8959dcc699626b999.png","contentUrl":"http:\/\/67.225.164.17\/~chronarchy\/wp-content\/uploads\/2026\/02\/8a565e1fcea23da8959dcc699626b999.png","width":331,"height":727,"caption":"Museums organized by the deity images they hold"},{"@type":"BreadcrumbList","@id":"http:\/\/67.225.164.17\/~chronarchy\/building-a-deity-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/67.225.164.17\/~chronarchy\/"},{"@type":"ListItem","position":2,"name":"Building a Deity Database"}]},{"@type":"WebSite","@id":"http:\/\/67.225.164.17\/~chronarchy\/#website","url":"http:\/\/67.225.164.17\/~chronarchy\/","name":"Chronarchy","description":"Rule By Time","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/67.225.164.17\/~chronarchy\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/67.225.164.17\/~chronarchy\/#\/schema\/person\/10cbdcc94866b55d1b4eaf486de52666","name":"Michael Dangler","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b964075929f283b39c8c2c1b41d266ef5e12a0782ce47c73d03a3b46ddcd68ae?s=96&d=mm&r=g","caption":"Michael Dangler"},"url":"http:\/\/67.225.164.17\/~chronarchy\/author\/chronarchy\/"}]}},"_links":{"self":[{"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/posts\/2007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/comments?post=2007"}],"version-history":[{"count":0,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/posts\/2007\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/media\/2005"}],"wp:attachment":[{"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/media?parent=2007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/categories?post=2007"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/67.225.164.17\/~chronarchy\/wp-json\/wp\/v2\/tags?post=2007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}