{"id":13250,"date":"2010-11-10T08:41:10","date_gmt":"2010-11-10T16:41:10","guid":{"rendered":"http:\/\/seattlebubble.com\/blog\/?p=13250"},"modified":"2010-11-10T10:40:35","modified_gmt":"2010-11-10T18:40:35","slug":"every-home-price-percentile-down-significantly-since-july","status":"publish","type":"post","link":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/","title":{"rendered":"Every Home Price Percentile Down Significantly Since July"},"content":{"rendered":"<p>Here&#8217;s a new way to look at home prices.  Rather than just measuring the median price of what sells each month, why not get a little more granular, and break down each month&#8217;s sales into <em>five<\/em> percentiles?<\/p>\n<p>Using detailed sales data obtained through the sweet csv download function on Redfin, I have grabbed King County single-family sales data back through the beginning of 2009 (a somewhat tedious process when you can only get 500 results at a time).<\/p>\n<p>Here&#8217;s how I broke down the price tiers.  Each bucket is a cutoff where some percentage of homes sold below that price, while the remaining percentage sold above that price.<\/p>\n<ul>\n<li><b>Bottom:<\/b> 10% below, 90% above.<\/li>\n<li><b>Low:<\/b> 25% below, 75% above.<\/li>\n<li><b>Median:<\/b> 50% below, 50% above.<\/li>\n<li><b>High:<\/b> 75% below, 25% above.<\/li>\n<li><b>Top:<\/b> 90% below, 10% above.<\/li>\n<\/ul>\n<p>Here&#8217;s a look back through the beginning of 2009, with monthly sales volume displayed as a bar for each month.<\/p>\n<p style=\"margin: 5px auto; width: 600px; font-size: 0.8em; text-align: center;\"><a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png\" title=\"King County SFH Sales: Price &#038; Volume\" rel=\"lightbox[13250]\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10-600x435.png\" style=\"border: 0;\" title=\"King County SFH Sales: Price &#038; Volume - Click to enlarge\" alt=\"King County SFH Sales: Price &#038; Volume\" width=\"600\" height=\"435\" \/><\/a><\/p>\n<p>All five tiers ended 2009 within $10,000 of where they began the year, but 2010 looks like it might be a little more interesting.  Let&#8217;s zoom in on this year, and index each tier to 100 so we can get a better look at their respective changes since January.<\/p>\n<p style=\"margin: 5px auto; width: 600px; font-size: 0.8em; text-align: center;\"><a href=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile-Indexed_2010-10.png\" title=\"King County SFH Sale Price Tiers\" rel=\"lightbox[13250]\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile-Indexed_2010-10-600x435.png\" style=\"border: 0;\" title=\"King County SFH Sale Price Tiers - Click to enlarge\" alt=\"King County SFH Sale Price Tiers\" width=\"600\" height=\"435\" \/><\/a><\/p>\n<p>Interesting, indeed.  All five tiers crept up from January through July, with the bottom tier gaining 3.6% and the top tier rising 15.4%.  Since July, all three tiers are declining fairly rapidly.  Here&#8217;s how far each tier has fallen since July:<\/p>\n<ul>\n<li><b>Bottom:<\/b> down 10.9%<\/li>\n<li><b>Low:<\/b> down 9.1%<\/li>\n<li><b>Median:<\/b> down 6.3%<\/li>\n<li><b>High:<\/b> down 7.1%<\/li>\n<li><b>Top:<\/b> down 9.6%<\/li>\n<\/ul>\n<p>This is definitely a data set I&#8217;ll be keeping an eye on in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s a new way to look at home prices. Rather than just measuring the median price of what sells each month, why not get a little more granular, and break down each month&#8217;s sales into five percentiles? Using detailed sales data obtained through the sweet csv download function on Redfin, I have grabbed King County&#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":[149,725,82,254,334],"coauthors":[],"class_list":["post-13250","post","type-post","status-publish","format-standard","hentry","category-stats","category-counties","tag-median","tag-percentile","tag-redfin","tag-sales","tag-tiers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Every Home Price Percentile Down Significantly Since July \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\/11\/10\/every-home-price-percentile-down-significantly-since-july\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Every Home Price Percentile Down Significantly Since July \u2022 Seattle Bubble\" \/>\n<meta name=\"twitter:description\" content=\"Here&#8217;s a new way to look at home prices. Rather than just measuring the median price of what sells each month, why not get a little more granular, and break down each month&#8217;s sales into five percentiles? Using detailed sales data obtained through the sweet csv download function on Redfin, I have grabbed King County...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/\",\"url\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/\",\"name\":\"Every Home Price Percentile Down Significantly Since July \u2022 Seattle Bubble\",\"isPartOf\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10-600x435.png\",\"datePublished\":\"2010-11-10T16:41:10+00:00\",\"dateModified\":\"2010-11-10T18:40:35+00:00\",\"author\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f\"},\"breadcrumb\":{\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage\",\"url\":\"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png\",\"contentUrl\":\"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png\",\"width\":\"911\",\"height\":\"661\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seattlebubble.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Every Home Price Percentile Down Significantly Since July\"}]},{\"@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":"Every Home Price Percentile Down Significantly Since July \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\/11\/10\/every-home-price-percentile-down-significantly-since-july\/","twitter_card":"summary_large_image","twitter_title":"Every Home Price Percentile Down Significantly Since July \u2022 Seattle Bubble","twitter_description":"Here&#8217;s a new way to look at home prices. Rather than just measuring the median price of what sells each month, why not get a little more granular, and break down each month&#8217;s sales into five percentiles? Using detailed sales data obtained through the sweet csv download function on Redfin, I have grabbed King County...","twitter_image":"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png","twitter_creator":"@The_Tim","twitter_site":"@SeattleBubble","twitter_misc":{"Written by":"The Tim","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/","url":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/","name":"Every Home Price Percentile Down Significantly Since July \u2022 Seattle Bubble","isPartOf":{"@id":"https:\/\/seattlebubble.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage"},"image":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage"},"thumbnailUrl":"http:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10-600x435.png","datePublished":"2010-11-10T16:41:10+00:00","dateModified":"2010-11-10T18:40:35+00:00","author":{"@id":"https:\/\/seattlebubble.com\/blog\/#\/schema\/person\/7de7c0dd14bee1a2c67f7ce86bc4505f"},"breadcrumb":{"@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#primaryimage","url":"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png","contentUrl":"https:\/\/seattlebubble.com\/blog\/wp-content\/uploads\/2010\/11\/Percentile_2010-10.png","width":"911","height":"661"},{"@type":"BreadcrumbList","@id":"https:\/\/seattlebubble.com\/blog\/2010\/11\/10\/every-home-price-percentile-down-significantly-since-july\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seattlebubble.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Every Home Price Percentile Down Significantly Since July"}]},{"@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-3rI","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/13250","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=13250"}],"version-history":[{"count":0,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/posts\/13250\/revisions"}],"wp:attachment":[{"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/media?parent=13250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/categories?post=13250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/tags?post=13250"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/seattlebubble.com\/blog\/wp-json\/wp\/v2\/coauthors?post=13250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}