{"id":16501,"date":"2011-07-29T08:00:07","date_gmt":"2011-07-29T15:00:07","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=16501"},"modified":"2011-07-29T12:14:20","modified_gmt":"2011-07-29T19:14:20","slug":"your-regularly-scheduled-redfintableau-mashup","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/","title":{"rendered":"Your Regularly Scheduled Redfin\/Tableau Mashup"},"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...\">employed by Redfin<\/a>.<\/span><\/p>\n<p>As <a href=\"http:\/\/seattlebubble.com\/blog\/2011\/07\/25\/redfin-junes-warmest-puget-sound-region-ne-seattle\/\" title=\"Redfin: June\u2019s Warmest Puget Sound Region: NE Seattle\">promised on Monday<\/a>, I&#8217;d like to post the usual Tableau map of Redfin&#8217;s monthly Seattle-area market stats.<\/p>\n<p>Don&#8217;t forget that you can <a href=\"http:\/\/blog.redfin.com\/seattle\/files\/2011\/07\/Redfin-Seattle-Real-Estate-Market-Report-June-2011.xls\" title=\"Redfin Seattle Real Estate Market Report\">download the full spreadsheet from Redfin here<\/a>.  Going forward I&#8217;ll probably just include both of these maps in the same post.<\/p>\n<p>In the map below each zip code with enough sales in May is shown as a dot, with the size of the dot determined by the number of sales in that zip code in the month.  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.  There is also a county selector that allows you to narrow, expand, or modify the view to your liking.<\/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\/29\/your-regularly-scheduled-redfintableau-mashup\/\"><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>This month&#8217;s biggest sales winner in King County was way out in Snoqualmie (98065) (last month&#8217;s biggest loser), where sales bumped up from 7 in May to 18 in June.  King County&#8217;s biggest decline was in NW Seattle \/ W Shoreline (98177), where sales fell 42% from 24 in May to 14 in June.<\/p>\n<p>Here are the zip codes with the most SFH sales in May in King, Snohomish, Pierce, Thurston, and Kitsap County:<\/p>\n<ul>\n<li><strong>King:<\/strong> 98115 &mdash; 55 sales.<\/li>\n<li><strong>Snohomish:<\/strong> 98208 &mdash; 64 sales.<\/li>\n<li><strong>Pierce:<\/strong> 98391 &mdash; 77 sales.<\/li>\n<li><strong>Thurston:<\/strong> 98501 &mdash; 51 sales.<\/li>\n<li><strong>Kitsap:<\/strong> 98367 &mdash; 34 sales.<\/li>\n<\/ul>\n<p>Inventory almost turned positive in June, declining month-to-month in 35 King County neighborhoods, flat in 4, and rising in 34.  Year-to-year continues to come in worse: Just 12 neighborhoods saw inventory increase, 3 were flat, and the remaining 58 are all lower than a year ago.<\/p>\n<p>The median price fell from a year ago in 59 King County zip codes, and rose in just 12.  The median price per square foot was down in 54 zip codes, flat in 1, and up in 17.<\/p>\n<p>Anything stand out to you about the detailed stats this month?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Full disclosure: The Tim is employed by Redfin. As promised on Monday, I&#8217;d like to post the usual Tableau map of Redfin&#8217;s monthly Seattle-area market stats. Don&#8217;t forget that you can download the full spreadsheet from Redfin here. Going forward I&#8217;ll probably just include both of these maps in the same post. In the map&#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-16501","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>Your Regularly Scheduled Redfin\/Tableau Mashup \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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Your Regularly Scheduled Redfin\/Tableau Mashup \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"Full disclosure: The Tim is employed by Redfin. As promised on Monday, I&#8217;d like to post the usual Tableau map of Redfin&#8217;s monthly Seattle-area market stats. Don&#8217;t forget that you can download the full spreadsheet from Redfin here. Going forward I&#8217;ll probably just include both of these maps in the same post. In the map...\" \/>\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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/\",\"name\":\"Your Regularly Scheduled Redfin\/Tableau Mashup \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png\",\"datePublished\":\"2011-07-29T15:00:07+00:00\",\"dateModified\":\"2011-07-29T19:14:20+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Your Regularly Scheduled Redfin\/Tableau Mashup\"}]},{\"@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":"Your Regularly Scheduled Redfin\/Tableau Mashup \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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/","twitter_card":"summary_large_image","twitter_title":"Your Regularly Scheduled Redfin\/Tableau Mashup \u2022 Seattle Bubble","twitter_description":"Full disclosure: The Tim is employed by Redfin. As promised on Monday, I&#8217;d like to post the usual Tableau map of Redfin&#8217;s monthly Seattle-area market stats. Don&#8217;t forget that you can download the full spreadsheet from Redfin here. Going forward I&#8217;ll probably just include both of these maps in the same post. In the map...","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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/","url":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/","name":"Your Regularly Scheduled Redfin\/Tableau Mashup \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#primaryimage"},"thumbnailUrl":"http:\/\/public.tableausoftware.com\/static\/images\/RedfinMonthlyStats-RedfinDashboard_rss.png","datePublished":"2011-07-29T15:00:07+00:00","dateModified":"2011-07-29T19:14:20+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#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\/2011\/07\/29\/your-regularly-scheduled-redfintableau-mashup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Your Regularly Scheduled Redfin\/Tableau Mashup"}]},{"@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-4i9","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/16501","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=16501"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/16501\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=16501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=16501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=16501"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=16501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}