Data on Most Recent Sales in Existing H1

Hi Jennifer,

I am working on a question I have about recent sales prices.

I have a hunch that the sales prices are normally distributed, and below the mean sales price for homes in Knoxville (i.e., "affordable.")

I looked up and saved the parcel ID for each parcel in the existing H1.

I then used the Parcel ID to form a URL that gave me access to the "Owner Card" in the KGIS system.


Parcel ID "082PE005"

Combine with URL:

Result: 082PE005

There are a few other steps but the end result is a folder on my computer full of PDF "Owner Cards" from KGIS.

I then sorted through the "Owner Card" and noted the most recent sale date.

I came up with the following data on "most recent sale date" for each property (table data below chart).

​The "Owner Cards" are also online:

I divided them up into the following categories:
Pre-1998 (24 properties last sold in this range)
1998-2007 (51 properties last sold in this range)
2008-2017 (101 properties last sold in this range)

The next step is to pull out the sales price into my spreadsheet of addresses.

My expectation is this will show the normal price distribution, with the average sale price in the H1 over 20 years holding below the Knoxville average.

The more interesting range to me is between 2008 and 2017.

-99 1
1955 1
1957 1
1972 1
1974 2
1978 2
1980 1
1982 1
1985 2
1986 1
1987 1
1988 2
1989 1
1991 1
1992 1
1993 3
1995 6
1996 5
1997 1
1998 2
1999 4
2000 2
2001 5
2002 8
2003 4
2004 3
2005 12
2006 6
2007 5
2008 7
2009 11
2010 7
2011 4
2012 9
2013 10
2014 17
2015 19
2016 12
2017 5

Per usual, the table data and interactive chart are online in Google Drive.


About Tanner Jessel

I am a recent M.S. in Information Science graduate from the University of Tennessee School of Information Science. I was formerly a graduate research assistant funded by DataONE (Data Observation Network for Earth). Prior, I worked for four years as a content lead and biodiversity scientist with the U.S. Geological Survey's Biodiversity Informatics Program. Building on my work experience in biodiversity and environmental informatics, my work with DataONE focused on exploring the nature of scientific collaborations necessary for scientific inquiry. I also conducted research concerning user experience and usability, and assisted in development of member nodes with an emphasis on spatial data and infrastructure. I assisted with research designed to understand sociocultural issues within collaborative research communities. Through August 1, 2014, I was based at the Center for Information and Communication Studies at the University of Tennessee School of Information Science in Knoxville, Tennessee.

Posted on March 31, 2017, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: