Zillow All Homes Data

Zillow town homes data from the Zillow website.

@kaggle.moezabid_zillow_all_homes_data

Table List

1 table(8.21 MB)

City Zhvi Allhomes

@kaggle.moezabid_zillow_all_homes_data.city_zhvi_allhomes

8.21 MB
10730 rows
251 columns
Only the first 100 columns are shown

regionid RegionID	regionname RegionName	state State	metro Metro	countyname CountyName	sizerank SizeRank	n_1996_04 1996-04	n_1996_05 1996-05	n_1996_06 1996-06	n_1996_07 1996-07	n_1996_08 1996-08	n_1996_09 1996-09	n_1996_10 1996-10	n_1996_11 1996-11	n_1996_12 1996-12	n_1997_01 1997-01	n_1997_02 1997-02	n_1997_03 1997-03	n_1997_04 1997-04	n_1997_05 1997-05	n_1997_06 1997-06	n_1997_07 1997-07	n_1997_08 1997-08	n_1997_09 1997-09	n_1997_10 1997-10	n_1997_11 1997-11	n_1997_12 1997-12	n_1998_01 1998-01	n_1998_02 1998-02	n_1998_03 1998-03	n_1998_04 1998-04	n_1998_05 1998-05	n_1998_06 1998-06	n_1998_07 1998-07	n_1998_08 1998-08	n_1998_09 1998-09	n_1998_10 1998-10	n_1998_11 1998-11	n_1998_12 1998-12	n_1999_01 1999-01	n_1999_02 1999-02	n_1999_03 1999-03	n_1999_04 1999-04	n_1999_05 1999-05	n_1999_06 1999-06	n_1999_07 1999-07	n_1999_08 1999-08	n_1999_09 1999-09	n_1999_10 1999-10	n_1999_11 1999-11	n_1999_12 1999-12	n_2000_01 2000-01	n_2000_02 2000-02	n_2000_03 2000-03	n_2000_04 2000-04	n_2000_05 2000-05	n_2000_06 2000-06	n_2000_07 2000-07	n_2000_08 2000-08	n_2000_09 2000-09	n_2000_10 2000-10	n_2000_11 2000-11	n_2000_12 2000-12	n_2001_01 2001-01	n_2001_02 2001-02	n_2001_03 2001-03	n_2001_04 2001-04	n_2001_05 2001-05	n_2001_06 2001-06	n_2001_07 2001-07	n_2001_08 2001-08	n_2001_09 2001-09	n_2001_10 2001-10	n_2001_11 2001-11	n_2001_12 2001-12	n_2002_01 2002-01	n_2002_02 2002-02	n_2002_03 2002-03	n_2002_04 2002-04	n_2002_05 2002-05	n_2002_06 2002-06	n_2002_07 2002-07	n_2002_08 2002-08	n_2002_09 2002-09	n_2002_10 2002-10	n_2002_11 2002-11	n_2002_12 2002-12	n_2003_01 2003-01	n_2003_02 2003-02	n_2003_03 2003-03	n_2003_04 2003-04	n_2003_05 2003-05	n_2003_06 2003-06	n_2003_07 2003-07	n_2003_08 2003-08	n_2003_09 2003-09	n_2003_10 2003-10	n_2003_11 2003-11	n_2003_12 2003-12	n_2004_01 2004-01
6181	New York	NY	New York	Queens	1
12447	Los Angeles	CA	Los Angeles-Long Beach-Anaheim	Los Angeles	2	155000	154600	154400	154200	154100	154300	154300	154200	154800	155900	157000	157700	158200	158600	158800	158900	159100	159800	160700	161900	163400	165400	167000	168500	169900	171400	172900	174300	175800	177800	180100	182600	184400	185600	186900	188200	189600	191300	193100	194700	196300	197700	199100	200700	202300	204400	207000	209800	212300	214500	216600	219000	221100	222800	224300	226100	228100	230600	233000	235400	237300	239100	240900	242900	245000	247300	250100	253100	255900	258800	261900	265200	268600	272600	276900	281800	287000	292200	297000	302100	307600	313400	319000	324300	329600	334600	339300	344500	350600	356800	363400	370700	378400	386500
17426	Chicago	IL	Chicago	Cook	3	109700	109400	109300	109300	109100	109000	109000	109600	110200	110800	111300	111700	112200	112300	112100	112200	113000	113700	114200	114800	115500	116200	117100	117600	117800	118300	119200	120000	120600	121500	122300	122700	122900	123300	123700	124500	125700	127300	128800	130200	131400	132600	133700	134600	135500	136800	138300	140100	141900	143700	145300	146700	147900	149000	150400	152000	154000	155600	157000	158200	159900	161800	163700	165300	166400	167500	168800	170400	172100	173900	175600	177000	177800	177600	177300	177700	178800	180400	182300	183800	185000	185600	186800	188900	191300	194100	197500	200200	202300	203700	204000	204000	204400	205300
13271	Philadelphia	PA	Philadelphia	Philadelphia	4	50000	49900	49600	49400	49400	49300	49300	49400	49700	49600	49500	49700	49800	49700	49700	49800	49700	49700	49800	49900	49900	50000	50300	50600	50800	50800	50800	50800	50700	50500	50500	50700	50700	50800	50900	51100	51200	51400	51500	51400	51500	51800	52100	52100	52300	52700	53100	53200	53400	53700	53800	53800	54100	54500	54700	54600	54800	55100	55400	55500	55400	55500	55700	55900	56300	56600	57000	57500	58100	58600	59100	59700	60300	60700	61200	61800	62200	62500	63000	63600	63900	64200	64700	65300	65700	66100	66800	67700	68500	69200	69800	70700	71700	72800
40326	Phoenix	AZ	Phoenix	Maricopa	5	87200	87700	88200	88400	88500	88900	89400	89700	90100	90700	91400	91700	91800	92000	92300	92600	93000	93400	94000	94600	95300	96100	96800	97300	97700	98400	99200	100100	100500	100700	100900	101700	102600	103400	103900	104400	105100	105900	106200	106600	107400	108300	109000	109700	110400	111000	111700	112800	113700	114300	115100	115600	115900	116500	117200	117400	117600	118400	119700	120700	121200	121500	122000	122400	122700	123000	123600	124300	125000	125800	126600	127200	127900	128400	128800	129500	130500	131600	132500	133200	134000	134900	135700	136500	137200	138000	138600	138900	139200	139400	139600	140300	141400	142500
18959	Las Vegas	NV	Las Vegas	Clark	6	121600	120900	120400	120300	120200	120300	120500	120900	121400	122100	122700	123100	123400	123700	123900	123800	123600	123700	124100	124700	125000	125100	125200	125200	125400	125600	126100	126600	127200	127700	128000	127800	127500	127600	127700	127900	128200	128400	128500	128800	129100	129300	129600	130300	131000	131700	132600	133500	134100	134400	134600	134800	135400	136000	136400	136900	137700	138600	139500	140500	141300	141800	142100	142600	143300	144200	145100	146000	147300	148500	149500	150000	150400	151000	151400	151800	152200	153000	154000	155400	156800	158200	159500	160700	161700	162600	163700	165200	167200	169600	172500	176000	180000	184300
54296	San Diego	CA	San Diego	San Diego	7	161100	160700	160400	160100	159600	159100	158700	158500	158700	159800	160800	161300	161600	162000	162300	162400	163100	164500	166200	168200	170200	172300	174600	177000	179200	180600	181200	182200	183700	185200	186900	188900	190600	192000	193500	195200	197200	199500	202100	204600	207200	209600	212000	214300	216400	219200	222900	226600	230200	234400	238500	242000	245300	249000	252500	256000	259600	263200	267100	271300	274200	276100	278500	281800	284700	287000	289200	291800	294800	298100	301300	304300	308000	312500	318100	324600	331200	337500	344200	351000	356900	362000	366600	370700	374500	377600	380200	383800	389200	395800	403300	411800	421000	430600
38128	Dallas	TX	Dallas-Fort Worth	Dallas	8											68500	68400	67600	67000	67000	67000	67200	67400	68200	70300	72400	73100	73300	73200	72600	72000	71900	72000	71900	71600	72000	73900	76000	76900	77200	77900	78800	79600	79900	80100	80000	79700	80200	82400	84600	85100	84500	83800	83600	83800	84200	84500	84900	85200	86000	87900	89600	89800	89700	89700	89500	89300	89100	89000	89000	89200	89900	91000	91800	92200	92500	93000	93400	93800	94200	94700	95500	96000	96200	96400	96900	97700	98400	98500	98400	98500	98600	98800	99100	99500	99700	99900	100300	101200
33839	San Jose	CA	San Jose	Santa Clara	9	224500	224900	225400	226100	227100	228100	229300	230900	233400	236500	239400	242000	244000	245900	248600	252000	255500	259000	262400	266100	269700	272800	275600	278100	280400	282800	285700	289200	292700	295300	297700	300300	302700	304900	306500	307800	309700	312400	315900	321200	327100	333700	341200	348800	355900	364100	374000	384700	395700	407100	416900	424700	431700	439200	447600	456000	462900	468000	471300	472700	472300	471000	467300	461200	455900	453300	450300	445500	440900	439200	440600	444500	450800	457900	464600	470000	473700	476000	477700	478800	479300	479200	478400	477200	475400	473100	472600	474800	478500	481300	483500	486500	491500	498000
25290	Jacksonville	FL	Jacksonville	Duval	10	77500	77200	76800	76600	76300	76000	75900	76000	76200	76500	76900	77000	77000	77200	77400	77500	77700	78100	78600	79000	79100	79500	80000	80500	80600	80600	80500	80700	80900	81300	81300	81000	81000	81900	82500	82900	83500	84500	85200	85500	85700	86200	86700	87200	87500	88000	88800	89000	88900	89600	90600	91200	91700	92200	92600	93100	93600	94000	94400	94800	95300	95600	95900	96500	97100	97600	98300	99100	99800	100600	101200	101900	102700	103500	104100	104700	105400	106300	107200	108200	109200	110200	111100	112000	112600	113000	114100	115600	116800	117600	118600	119800	120900	121900


CREATE TABLE city_zhvi_allhomes (
  "regionid" BIGINT,
  "regionname" VARCHAR,
  "state" VARCHAR,
  "metro" VARCHAR,
  "countyname" VARCHAR,
  "sizerank" BIGINT,
  "n_1996_04" DOUBLE,
  "n_1996_05" DOUBLE,
  "n_1996_06" DOUBLE,
  "n_1996_07" DOUBLE,
  "n_1996_08" DOUBLE,
  "n_1996_09" DOUBLE,
  "n_1996_10" DOUBLE,
  "n_1996_11" DOUBLE,
  "n_1996_12" DOUBLE,
  "n_1997_01" DOUBLE,
  "n_1997_02" DOUBLE,
  "n_1997_03" DOUBLE,
  "n_1997_04" DOUBLE,
  "n_1997_05" DOUBLE,
  "n_1997_06" DOUBLE,
  "n_1997_07" DOUBLE,
  "n_1997_08" DOUBLE,
  "n_1997_09" DOUBLE,
  "n_1997_10" DOUBLE,
  "n_1997_11" DOUBLE,
  "n_1997_12" DOUBLE,
  "n_1998_01" DOUBLE,
  "n_1998_02" DOUBLE,
  "n_1998_03" DOUBLE,
  "n_1998_04" DOUBLE,
  "n_1998_05" DOUBLE,
  "n_1998_06" DOUBLE,
  "n_1998_07" DOUBLE,
  "n_1998_08" DOUBLE,
  "n_1998_09" DOUBLE,
  "n_1998_10" DOUBLE,
  "n_1998_11" DOUBLE,
  "n_1998_12" DOUBLE,
  "n_1999_01" DOUBLE,
  "n_1999_02" DOUBLE,
  "n_1999_03" DOUBLE,
  "n_1999_04" DOUBLE,
  "n_1999_05" DOUBLE,
  "n_1999_06" DOUBLE,
  "n_1999_07" DOUBLE,
  "n_1999_08" DOUBLE,
  "n_1999_09" DOUBLE,
  "n_1999_10" DOUBLE,
  "n_1999_11" DOUBLE,
  "n_1999_12" DOUBLE,
  "n_2000_01" DOUBLE,
  "n_2000_02" DOUBLE,
  "n_2000_03" DOUBLE,
  "n_2000_04" DOUBLE,
  "n_2000_05" DOUBLE,
  "n_2000_06" DOUBLE,
  "n_2000_07" DOUBLE,
  "n_2000_08" DOUBLE,
  "n_2000_09" DOUBLE,
  "n_2000_10" DOUBLE,
  "n_2000_11" DOUBLE,
  "n_2000_12" DOUBLE,
  "n_2001_01" DOUBLE,
  "n_2001_02" DOUBLE,
  "n_2001_03" DOUBLE,
  "n_2001_04" DOUBLE,
  "n_2001_05" DOUBLE,
  "n_2001_06" DOUBLE,
  "n_2001_07" DOUBLE,
  "n_2001_08" DOUBLE,
  "n_2001_09" DOUBLE,
  "n_2001_10" DOUBLE,
  "n_2001_11" DOUBLE,
  "n_2001_12" DOUBLE,
  "n_2002_01" DOUBLE,
  "n_2002_02" DOUBLE,
  "n_2002_03" DOUBLE,
  "n_2002_04" DOUBLE,
  "n_2002_05" DOUBLE,
  "n_2002_06" DOUBLE,
  "n_2002_07" DOUBLE,
  "n_2002_08" DOUBLE,
  "n_2002_09" DOUBLE,
  "n_2002_10" DOUBLE,
  "n_2002_11" DOUBLE,
  "n_2002_12" DOUBLE,
  "n_2003_01" DOUBLE,
  "n_2003_02" DOUBLE,
  "n_2003_03" DOUBLE,
  "n_2003_04" DOUBLE,
  "n_2003_05" DOUBLE,
  "n_2003_06" DOUBLE,
  "n_2003_07" DOUBLE,
  "n_2003_08" DOUBLE,
  "n_2003_09" DOUBLE,
  "n_2003_10" DOUBLE,
  "n_2003_11" DOUBLE,
  "n_2003_12" DOUBLE,
  "n_2004_01" DOUBLE
);