Pierce County House Sales Data for 2020 — pierce_county_house

Real estate sales for Pierce County, WA in 2020.

Usage

pierce_county_house_sales

Format

A data frame with 16814 rows and 19 variables.

sale_date: Date the legal document (deed) was executed.
sale_price: Dollar amount recorded for the sale.
house_square_feet: Sum of the square feet for the building.
attic_finished_square_feet: Finished living area in the attic.
basement_square_feet: Total square footage of the basement..
attached_garage_square_feet: Total square footage of the attached or built in garage(s).
detached_garage_square_feet: Total detached garage(s) square footage.
fireplaces: Total count of single, double or PreFab stoves.
hvac_description: Text description associated with the predominant heating source for the built-as structure i.e. Forced Air, Electric Baseboard, Steam, etc. .
exterior: Predominant type of construction materials used for the exterior siding on Residential Buildings.
interior: Predominant type of materials used on the interior walls. i.e. Sheetrock or Paneling.
stories: Number of floors/building levels above grade. Stories do not include attic or basement areas.
roof_cover: Material used for the roof. I.e. Composition Shingles, Wood Shake, Concrete Tile, etc.
year_built: Year the building was built, as stated by the building permit or a historical record.
bedrooms: Number of bedrooms listed for a residential property.
bathrooms: Number of baths listed for a residential property. The number is listed as a decimal, i.e. 2.75 = two full and one three-quarter baths. A tub/sink/toilet combination (plus any additional fixtures) is considered 1.0 bath. A shower/sink/toilet combination (plus any additional fixtures) is 0.75 bath. A sink/toilet combination is .5 bath.
waterfront_type: Describes the type of waterfront the property adjoins or has legal access to.
view_quality: Assigned to reflect the market appeal of the overall view available from the dwelling or property.
utility_sewer: Identifies if sewer/septic is installed, available or not available or if the property does not support an on site sewage disposal system.

Source

Pierce County, Washington

Examples

library(dplyr)
library(lubridate)
#> 
#> Attaching package: ‘lubridate’
#> The following objects are masked from ‘package:base’:
#> 
#>     date, intersect, setdiff, union

# List house sales frequency and average price grouped by month
pierce_county_house_sales |>
  mutate(month_sale = month(sale_date)) |>
  group_by(month_sale) |>
  summarize(freq = n(), mean_price = mean(sale_price)) |>
  arrange(desc(freq))
#> # A tibble: 12 × 3
#>    month_sale  freq mean_price
#>         <dbl> <int>      <dbl>
#>  1         10  1743    477112.
#>  2          9  1725    487640.
#>  3          7  1699    470293.
#>  4          8  1663    471328.
#>  5          6  1531    460242.
#>  6         11  1492    479536.
#>  7         12  1429    485101.
#>  8          3  1202    450739.
#>  9          5  1156    430333.
#> 10          4  1096    436553.
#> 11          1  1056    408079.
#> 12          2  1022    428170.

# List house sales frequency and average price group by waterfront type
pierce_county_house_sales |>
  group_by(waterfront_type) |>
  summarize(freq = n(), mean_price = mean(sale_price)) |>
  arrange(desc(mean_price))
#> # A tibble: 5 × 3
#>   waterfront_type    freq mean_price
#>   <chr>             <int>      <dbl>
#> 1 "WF Salt"           209   1109730.
#> 2 "WF Lake"           225    898376.
#> 3 "WF Stream/Creek"    93    496005.
#> 4 "WF River"           26    447623.
#> 5 ""                16261    446672.