California Housing Prices

Median house prices for California districts derived from the 1990 census.

@kaggle.camnugent_california_housing_prices

Table List

1 table(405.22 KB)

Housing

@kaggle.camnugent_california_housing_prices.housing

405.22 KB
20640 rows
10 columns

longitude Longitude	latitude Latitude	housing_median_age Housing Median Age	total_rooms Total Rooms	total_bedrooms Total Bedrooms	population Population	households Households	median_income Median Income	median_house_value Median House Value	ocean_proximity Ocean Proximity
-122.23	37.88	41	880	129	322	126	8.3252	452600	NEAR BAY
-122.22	37.86	21	7099	1106	2401	1138	8.3014	358500	NEAR BAY
-122.24	37.85	52	1467	190	496	177	7.2574	352100	NEAR BAY
-122.25	37.85	52	1274	235	558	219	5.6431	341300	NEAR BAY
-122.25	37.85	52	1627	280	565	259	3.8462	342200	NEAR BAY
-122.25	37.85	52	919	213	413	193	4.0368	269700	NEAR BAY
-122.25	37.84	52	2535	489	1094	514	3.6591	299200	NEAR BAY
-122.25	37.84	52	3104	687	1157	647	3.12	241400	NEAR BAY
-122.26	37.84	42	2555	665	1206	595	2.0804	226700	NEAR BAY
-122.25	37.84	52	3549	707	1551	714	3.6912	261100	NEAR BAY


CREATE TABLE housing (
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "housing_median_age" DOUBLE,
  "total_rooms" DOUBLE,
  "total_bedrooms" DOUBLE,
  "population" DOUBLE,
  "households" DOUBLE,
  "median_income" DOUBLE,
  "median_house_value" DOUBLE,
  "ocean_proximity" VARCHAR
);