Baselight

Real Estate Sales 730 Days

City of Hartford real estate sales for the past 2 years

@kaggle.thedevastator_analyzing_hartford_real_estate_sales_over_730_da

Loading...
Loading...

About this Dataset

Real Estate Sales 730 Days


Real Estate Sales 730 Days

City of Hartford real estate sales for the past 2 years

By [source]


About this dataset

This dataset contains data on City of Hartford real estate sales for the last two years, with comprehensive records including property ID, parcel ID, sale date, sale price and more. This dataset is continuously updated each night and sourced from an official reliable source. The columns in this dataset include LocationStartNumber, ApartmentUnitNumber, StreetNameAndWay, LandSF TotalFinishedArea, LivingUnits ,OwnerLastName OwnerFirstName ,PrimaryGrantor ,SaleDate SalePrice ,TotalAppraisedValue and LegalReference - all valuable information to anyone wishing to understand the recent market trends and developments in the City of Hartford real estate industry. With this data providing detailed insights into what properties are selling at what time frame and for how much money – let’s see what secrets we can learn from examining the City of Hartford real estate activity!

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains helpful information about homes sold in the Hartford area over the past two years. This data can be used to analyze trends in real estate markets, as well as monitor sales activity for various areas.

In order to use this dataset, you will need knowledge of EDA (Exploratory Data Analysis) such as data cleaning and data visualization techniques. You will also need a basic understanding of SQL queries and Python scripting language.

The first step is to familiarize yourself with the columns and information contained within the dataset by analyzing descriptive statistics like mean, min, max etc. Next you can filter or “slice” the data based on certain criteria or variables that interest you - such as sale date range, location (by street name or zip code), sale price range, type of dwelling unit etc. After using various filters for analysis it is important to take an error-check step by looking for outliers or any discrepancies that may exist - this will ensure more accuracy in results when plotting graphs and visualizing trends via software tools like Tableau and Power BI etc.

Next you can conduct exploratory analysis through plot visualizations of relationships between buyer characteristics (first & last name) vs prices over time; living units vs square footage stats; average price per bedroom/bathroom ratio comparisons etc – all while taking into account external factors such as seasonal changeovers that could affect pricing fluctuations during given intervals across multiple neighborhoods - use interactive maps if available ets. At this point it's easy to compile insightful reports containing commonalities amongst buyers and begin generalizing your findings with extrapolations which allow us gain a better understanding of current market conditions across different demographic spectrums being compared ie traditional Vs luxury properties – all made possible simply through dedicated research with datasets like these!

Research Ideas

  • Analyzing market trends in the City of Hartford's real estate industry by tracking sale prices and appraised values over time to identify regions who are being under or over valued.
  • Conducting a predictive analysis project to predict future sales prices, annual appreciation rates, and key features associated with residential properties such as total finished area and living units for investment purposes.
  • Studying the impact of local zoning laws on property ownership and development by comparing sale dates, primary grantors, legal references, street names and ways in a given area over time

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: real-estate-sales-730-days-1.csv

Column name Description
LocationStartNumber The starting number of the location of the property. (Integer)
ApartmentUnitNumber The apartment unit number of the property. (Integer)
StreetNameAndWay The street name and way of the property. (String)
LandSF The land square footage of the property. (Integer)
TotalFinishedArea The total finished area of the property. (Integer)
LivingUnits The number of living units in the property. (Integer)
OwnerLastName The last name of the owner of the property. (String)
OwnerFirstName The first name of the owner of the property. (String)
PrimaryGrantor The primary grantor of the property. (String)
SaleDate The date of the sale of the property. (Date)
SalePrice The sale price of the property. (Integer)
TotalAppraisedValue The total appraised value of the property. (Integer)
LegalReference The legal reference of the property. (String)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit data.world's Admin.

Tables

Real Estate Sales 730 Days 1

@kaggle.thedevastator_analyzing_hartford_real_estate_sales_over_730_da.real_estate_sales_730_days_1
  • 292 KB
  • 4735 rows
  • 21 columns
Loading...

CREATE TABLE real_estate_sales_730_days_1 (
  "index" BIGINT,
  "propertyid" BIGINT,
  "xrcompositelanduseid" BIGINT,
  "xrbuildingtypeid" DOUBLE,
  "parcelid" VARCHAR,
  "locationstartnumber" DOUBLE,
  "apartmentunitnumber" VARCHAR,
  "streetnameandway" VARCHAR,
  "xrprimaryneighborhoodid" BIGINT,
  "landsf" DOUBLE,
  "totalfinishedarea" DOUBLE,
  "livingunits" DOUBLE,
  "ownerlastname" VARCHAR,
  "ownerfirstname" VARCHAR,
  "primarygrantor" VARCHAR,
  "saledate" TIMESTAMP,
  "saleprice" BIGINT,
  "totalappraisedvalue" BIGINT,
  "legalreference" VARCHAR,
  "xrsalesvalidityid" BIGINT,
  "xrdeedid" BIGINT
);

Share link

Anyone who has the link will be able to view this.