{"id":11199,"date":"2010-06-04T09:46:20","date_gmt":"2010-06-04T16:46:20","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=11199"},"modified":"2011-04-08T12:54:32","modified_gmt":"2011-04-08T19:54:32","slug":"heatmap-of-average-prices-for-2010-home-sales","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/","title":{"rendered":"Heatmap of Average Prices for 2010 Home Sales"},"content":{"rendered":"<p>Yesterday, in response to the sales histogram I posted, a reader asked:<\/p>\n<blockquote><p>Where the hell are all of these sub-350k houses?<\/p><\/blockquote>\n<p>That&#8217;s just the sort of question that a zip code heat map might answer.  So here you go.<\/p>\n<div style=\"width: 600px; height: 890px; margin: 0 auto;\">\n<script type=\"text\/javascript\" src=\"http:\/\/public.tableausoftware.com\/javascripts\/api\/viz_v1.js\"><\/script><object class=\"tableauViz\" width=\"604\" height=\"869\" style=\"display:none;\"><param name=\"host_url\" value=\"http%3A%2F%2Fpublic.tableausoftware.com%2F\" \/><param name=\"name\" value=\"Heatmap-Avg-Price&#47;HeatMap\" \/><param name=\"tabs\" value=\"no\" \/><param name=\"toolbar\" value=\"no\" \/><param name=\"animate_transition\" value=\"yes\" \/><param name=\"display_static_image\" value=\"yes\" \/><param name=\"display_spinner\" value=\"yes\" \/><param name=\"display_overlay\" value=\"yes\" \/><\/object><noscript>HeatMap <br \/><a href=\"http:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/\"><img decoding=\"async\" alt=\"HeatMap \" src=\"http:&#47;&#47;public.tableausoftware.com&#47;static&#47;images&#47;He&#47;Heatmap-Avg-Price&#47;HeatMap&#47;1_rss.png\" height=\"100%\" \/><\/a><\/noscript><\/p>\n<div style=\"width:604px;height:22px;padding:0px 10px 0px 0px;color:black;font:normal 8pt verdana,helvetica,arial,sans-serif;\">\n<div style=\"float:right; padding-right:8px;\"><a href=\"http:\/\/www.tableausoftware.com\/public?ref=http:\/\/public.tableausoftware.com\/views\/Heatmap-Avg-Price\/HeatMap\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<\/div>\n<p>Unfortunately Tableau does not have a median function, so average price will have to do.  Still, it does at least answer the question.  Most of the sub-$350k home sales are taking place south of Seattle.  The one exception is 98133 (Shoreline).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday, in response to the sales histogram I posted, a reader asked: Where the hell are all of these sub-350k houses? That&#8217;s just the sort of question that a zip code heat map might answer. So here you go. HeatMap Powered by Tableau Unfortunately Tableau does not have a median function, so average price will&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,616],"tags":[676,675,213,254,531],"coauthors":[],"class_list":["post-11199","post","type-post","status-publish","format-standard","hentry","category-stats","category-counties","tag-average-price","tag-heat-map","tag-maps","tag-sales","tag-tableau"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"Yesterday, in response to the sales histogram I posted, a reader asked: Where the hell are all of these sub-350k houses? That&#8217;s just the sort of question that a zip code heat map might answer. So here you go. HeatMap Powered by Tableau Unfortunately Tableau does not have a median function, so average price will...\" \/>\n<meta name=\"twitter:image\" content=\"http:&#47;&#47;public.tableausoftware.com&#47;static&#47;images&#47;He&#47;Heatmap-Avg-Price&#47;HeatMap&#47;1_rss.png\" \/>\n<meta name=\"twitter:creator\" content=\"@The_Tim\" \/>\n<meta name=\"twitter:site\" content=\"@SeattleBubble\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Tim\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/\",\"name\":\"Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"datePublished\":\"2010-06-04T16:46:20+00:00\",\"dateModified\":\"2011-04-08T19:54:32+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Heatmap of Average Prices for 2010 Home Sales\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\",\"url\":\"https:\/\/seattlebubble.com\/blog\/\",\"name\":\"Seattle Bubble\",\"description\":\"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\",\"name\":\"The Tim\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g\",\"caption\":\"The Tim\"},\"description\":\"Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer \/ internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.\",\"sameAs\":[\"http:\/\/SeattleBubble.com\/\",\"http:\/\/facebook.com\/is.totally.pointless\",\"https:\/\/x.com\/The_Tim\"],\"url\":\"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble","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":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/","twitter_card":"summary_large_image","twitter_title":"Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble","twitter_description":"Yesterday, in response to the sales histogram I posted, a reader asked: Where the hell are all of these sub-350k houses? That&#8217;s just the sort of question that a zip code heat map might answer. So here you go. HeatMap Powered by Tableau Unfortunately Tableau does not have a median function, so average price will...","twitter_image":"http:&#47;&#47;public.tableausoftware.com&#47;static&#47;images&#47;He&#47;Heatmap-Avg-Price&#47;HeatMap&#47;1_rss.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/","url":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/","name":"Heatmap of Average Prices for 2010 Home Sales \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"datePublished":"2010-06-04T16:46:20+00:00","dateModified":"2011-04-08T19:54:32+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2010\/06\/04\/heatmap-of-average-prices-for-2010-home-sales\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Heatmap of Average Prices for 2010 Home Sales"}]},{"@type":"WebSite","@id":"https:\/\/seattlebubble.com\/blog\/#website","url":"https:\/\/seattlebubble.com\/blog\/","name":"Seattle Bubble","description":"local\u00a0real\u00a0estate\u00a0news, statistics,\u00a0and\u00a0commentary without\u00a0the\u00a0sales\u00a0spin.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seattlebubble.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f","name":"The Tim","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/image\/37756956c11dcc50d2559761ffa5ee70","url":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19e5770990a1681615608091b2de571b10c3e03bbac7d07bb2ae15297ee72fbc?s=96&d=retro&r=g","caption":"The Tim"},"description":"Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer \/ internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.","sameAs":["http:\/\/SeattleBubble.com\/","http:\/\/facebook.com\/is.totally.pointless","https:\/\/x.com\/The_Tim"],"url":"https:\/\/seattlebubble.com\/blog\/author\/timothyellis\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6wh0F-2UD","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/11199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/comments?post=11199"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/11199\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=11199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=11199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=11199"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=11199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}