{"id":11779,"date":"2010-07-16T07:00:24","date_gmt":"2010-07-16T14:00:24","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=11779"},"modified":"2010-07-17T16:27:16","modified_gmt":"2010-07-17T23:27:16","slug":"redfin-sales-stalling-in-seattle-climbing-on-eastside","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/","title":{"rendered":"Redfin: Sales Stalling in Seattle, Climbing on Eastside"},"content":{"rendered":"<p><span style=\"font-size:85%; font-style:italic;\">Full disclosure: The Tim is <a href=\"http:\/\/seattlebubble.com\/blog\/2010\/07\/14\/some-noteworthy-personal-news\/\" title=\"Some Noteworthy Personal News\u2026\">employed by Redfin<\/a>.<\/span><\/p>\n<p>With <a href=\"http:\/\/blog.redfin.com\/seattle\/2010\/07\/prices_up_fundamentals_down_in_seattle_june_2010_real_estate_insider_report.html\" title=\"Prices Up, Fundamentals Down in Seattle (June 2010 Real Estate Insider Report)\">the latest monthly stats release from Redfin<\/a> going live a couple days ago, I thought I would spend a little more time with the data (in addition to all the on-the-clock time I spent this week getting it prepared for release).<\/p>\n<p>In order to make the numbers in the spreadsheet more digestible, I thought a Tableau map would be just what the number doctor ordered (big surprise, I&#8217;m sure).  In the map below each zip code with enough sales in June is shown as a dot, with the size of the dot determined by the number of sales in that zip code in June.  Each dot is color-coded based on whichever measure you select below the map.  You can view the month-over-month or year-over-year changes in inventory, sales, median prices, or median prices per square foot.<\/p>\n<p>[<strong>Update:<\/strong> By request, I have modified the color coding on the map below to a more colorblind-friendly palette.]<\/p>\n<div style=\"width:600px; height:890px;\">\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=\"name\" value=\"RedfinMonthlyStats\/RedfinDashboard\" \/><param name=\"toolbar\" value=\"yes\" \/><\/object><noscript>Redfin Dashboard <br \/><a href=\"http:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/\"><img loading=\"lazy\" decoding=\"async\" alt=\"Redfin Dashboard \" src=\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png\" width=\"584\" height=\"820\" style=\"border:0;\" \/><\/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\/RedfinMonthlyStats\/RedfinDashboard\" target=\"_blank\">Powered by Tableau<\/a><\/div>\n<\/div>\n<\/div>\n<p>As you can see if you leave the map on its default setting, house sales took a tumble from May to June in most Seattle-area neighborhoods, but were slightly up month-to-month on the Eastside.  I suspect with the (original, unextended) expiration of the tax credit at the end of June, next month that version of the map will see an awful lot more dots.<\/p>\n<p>Interestingly, if you look at the raw median price year-over-year, you&#8217;ll see a fair bit of green in the central Seattle area, but if you flip the measure to the median price per square foot, much of that green turns to gray or red.  This would seem to suggest that prices have actually fallen in many of these neighborhoods over the last year or so, but buyers are just purchasing bigger houses.<\/p>\n<p>Let me know what you think of this method for visualizing Redfin&#8217;s housing market data.  One thing that has always frustrated me about the available information has been that it was difficult to see how the market was changing from neighborhood to neighborhood.  With Redfin&#8217;s data broken out by zip code, I think the ability to make a heat map like this goes a long way toward improving understanding of what&#8217;s really going on, but I&#8217;m interested to hear your feedback as well.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Full disclosure: The Tim is employed by Redfin. With the latest monthly stats release from Redfin going live a couple days ago, I thought I would spend a little more time with the data (in addition to all the on-the-clock time I spent this week getting it prepared for release). In order to make the&#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,217],"tags":[675,213,679,82,531],"coauthors":[],"class_list":["post-11779","post","type-post","status-publish","format-standard","hentry","category-stats","category-neighborhoods","tag-heat-map","tag-maps","tag-monthly-stats","tag-redfin","tag-tableau"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Redfin: Sales Stalling in Seattle, Climbing on Eastside \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\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Redfin: Sales Stalling in Seattle, Climbing on Eastside \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"Full disclosure: The Tim is employed by Redfin. With the latest monthly stats release from Redfin going live a couple days ago, I thought I would spend a little more time with the data (in addition to all the on-the-clock time I spent this week getting it prepared for release). In order to make the...\" \/>\n<meta name=\"twitter:image\" content=\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_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\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\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/\",\"name\":\"Redfin: Sales Stalling in Seattle, Climbing on Eastside \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png\",\"datePublished\":\"2010-07-16T14:00:24+00:00\",\"dateModified\":\"2010-07-17T23:27:16+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage\",\"url\":\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png\",\"contentUrl\":\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Redfin: Sales Stalling in Seattle, Climbing on Eastside\"}]},{\"@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":"Redfin: Sales Stalling in Seattle, Climbing on Eastside \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\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/","twitter_card":"summary_large_image","twitter_title":"Redfin: Sales Stalling in Seattle, Climbing on Eastside \u2022 Seattle Bubble","twitter_description":"Full disclosure: The Tim is employed by Redfin. With the latest monthly stats release from Redfin going live a couple days ago, I thought I would spend a little more time with the data (in addition to all the on-the-clock time I spent this week getting it prepared for release). In order to make the...","twitter_image":"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/","url":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/","name":"Redfin: Sales Stalling in Seattle, Climbing on Eastside \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage"},"thumbnailUrl":"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png","datePublished":"2010-07-16T14:00:24+00:00","dateModified":"2010-07-17T23:27:16+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#primaryimage","url":"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png","contentUrl":"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png"},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2010\/07\/16\/redfin-sales-stalling-in-seattle-climbing-on-eastside\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Redfin: Sales Stalling in Seattle, Climbing on Eastside"}]},{"@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-33Z","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/11779","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=11779"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/11779\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=11779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=11779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=11779"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=11779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}